Posted February 8, 2018 Hello friends of wurm I am not so good with sql and would need you help please. We like to activate upkeep in the next days, but before i change the setting i like to add 20s upkeep to each deed to prevent that the deeds are disbanded after turn on the upkeep. Hopefully someone can post me the correct sql statement and tell me in which db i have to run the code. Thanks in advance Eject Share this post Link to post Share on other sites
Posted February 8, 2018 Something like that should work i think update VILLAGES set UPKEEP=UPKEEP+200000 WHERE DISBANDED=0 in wurmzones.db 1 Share this post Link to post Share on other sites
Posted February 8, 2018 Thank you very much bdew, that was very fast =) Eject Share this post Link to post Share on other sites
Posted February 8, 2018 Something is wrong, i added the upkeep but at settlement info i see just the 3 silvercoins from the standard but the new entry is in the db Eject Share this post Link to post Share on other sites
Posted February 8, 2018 did you do it while the server was offline? the server won't pick it up while running Share this post Link to post Share on other sites
Posted February 8, 2018 Maybe its another table? Upkeep sounds correct, but where i look, i cant see the 3 silver from the standard upkeep. Eject Share this post Link to post Share on other sites
Posted February 8, 2018 (edited) Hmm, looks like there another place... try this: (still in wurmzones.db) update GUARDPLAN set MONEYLEFT=MONEYLEFT+200000 Edited February 8, 2018 by bdew Share this post Link to post Share on other sites
Posted February 8, 2018 Yes that was it bdew I never thought that this is here Thank you very much for your help =) Share this post Link to post Share on other sites