Posted November 9, 2015 Starting a list of database tweaks for everyone to enjoy. You will neeed a sql browser(free one here http://sqlitebrowser.org/) To find most of the databases... Navigate to your server's sqlite folder.In most cases it is best to close server down and make the changes then start server back up If you are using Sqlite browser select "browse data" tab and in the drop down you can find each record of data. Once you make a change make sure to click "write changes" There are many changes in these databases you may see that I didn't list, most of them in these records can be altered in other ways like through GM or server settings. These are a list that effect the game thatyou can only change within the database. Changing Season:Open wurmlogin.db then select the "Servers" record. Scroll to the right until you see "WORLDTIME".A value of "5575600" = Some time in "spring" Year 980http://www.wurmpedia.com/index.php/Time_of_WurmIf anyone has any good values for other seasons, I will post and edit them here. Changing or Quickly Obtaining Path Levels:Open wurmplayers.db then select "Cult" record. You can change your path under "PATH" (1=Love, 2=Hate, 3=Knowledge, 4=Insanity, 5=Power)You can change the Level(ie. to 7 to get Enchant Grass) under "LEVEL". I havn't tested it but I also changed the "LASTAPPOINTED LEVEL" to the level under what i set my level to. Changing Animal Age and Sex:Open wurmcreatures.db then select "Creatures" record.This is sorta tricky but not that hard. there are so many creatures in the game... you will want to do 1 of 2 things or both to find your creature. (1 - make a grooming brush and groom the creature or creatures you want to change, or 2 - Hitch them to a cart if they are eligible)Scroll to the right almost all the way and find "LASTGROOMED" or "VEHICLE" they are next to eachother. click on the top tab to sort them and you will see your creatures. Now scroll back to the left and find "AGE" and edit. Value of 8 will make it "Mature"Value of 12 will make it "Aged"Not sure of exact numbering but i found those 2 pretty quickly.You can also change the "SEX" of the animal 0=Male and 1=Female Changing Animal Birth Time:Open wurmcreatures.db then select "Offspring" record.These are the list of your pregnant creatures. Change the value of "DELIVERYDAYS" to 0.Note: This will just reduce the "...will delivery in about # to 0-2.If someone finds out a value to place there that will make it 0 please let me know. Share this post Link to post Share on other sites
Posted January 1, 2016 To set affinities, edit the affinity table. You need to know the Id for the skill that you want to set. I have a list of most of the useful skills Religion: 1026 Prayer: Channeling: 10067 Preaching: Exorcism: Artifacts: Hammers: Warhammer: Healing: 1024 First aid: 10056 Clubs: Huge club: Archery: Short bow: Medium bow: Long bow: Thievery: Stealing: Lock picking: Traps: War machines: Catapults: Trebuchets: Turrets: Ballistae: Polearms: 1033 Staff: 10090 Long spear: Halberd: Prospecting: 1013 Coal-making: Milling: Tracking: Paving: 10031 Climbing: Thatching: Firemaking: 1010 Pottery: Mining: 1008 Digging: 1009 Ropemaking: Smithing: 1015 Blacksmithing: 10015 Locksmithing: 10034 Jewelry smithing: 10043 Metallurgy: Weapon smithing: 1016 Blades smithing: 10010 Weapon heads smithing: 10056 Armour smithing: Shield smithing: Chain armour smithing: Plate armour smithing: Tailoring: 1012 Cloth tailoring: 10016 Leatherworking: 10017 Masonry: 1013 Stone cutting: 10074 Cooking: 1018 Hot food cooking: 10038 Baking: Dairy food making: Butchering: 10059 Beverages: Nature: 1019 Fishing: Gardening: Foraging: Botanizing: Animal taming: Forestry: 10048 Farming: 10049 and 10059 Milking: Meditating: 10086 Animal husbandry: 10085 Papyrusmaking: Toys: Yoyo: Puppeteering: Fighting: 1023 Defensive fighting: 10054 Normal fighting: 10055 Weaponless fighting: 10052 Aggressive fighting: 10053 Shield bashing: Taunting: Miscellaneous items: 1020 Shovel: 10002 Rake: 10004 Saw: 10008 Pickaxe: 10009 Repairing: 10035 Sickle: 10046 Scythe: Hammer: 10026 Stone chisel: 10030 Alchemy: 1021 Natural substances: 10042 Shields: Medium metal shield: Small wooden shield: Small metal shield: Large metal shield: Medium wooden shield: Large wooden shield: Axes: 1003 Hatchet: Small Axe: 10001 Large axe: Huge axe: 10025 Swords: Longsword: Shortsword: Two handed sword: Knives: 1001 Carving knife: 10007 Butchering knife: 10029 Woodcutting: 1007 Mauls: Medium maul: Small maul: Large maul: Carpentry: 1005 Bowyery: Fletching: Fine carpentry: 10044 Toy making: Ship building: ______ Characteristics: Mind: 2 Mind logic: 100 Mind speed: 101 Soul: 3 Soul depth: 106 Soul strength: 105 Body: 1 Body strength: 102 Body stamina: 103 Body control: 104 Share this post Link to post Share on other sites
Posted January 11, 2016 all skills by number: CHARACTERISTICS = 2147483646; FAITH = 2147483645; FAVOR = 2147483644; RELIGION = 2147483643; ALIGNMENT = 2147483642; BODY = 1; MIND = 2; SOUL = 3; MIND_LOGICAL = 100; MIND_SPEED = 101; BODY_STRENGTH = 102; BODY_STAMINA = 103; BODY_CONTROL = 104; SOUL_STRENGTH = 105; SOUL_DEPTH = 106; GROUP_SWORDS = 1000; GROUP_KNIVES = 1001; GROUP_SHIELDS = 1002; GROUP_AXES = 1003; GROUP_MAULS = 1004; CARPENTRY = 1005; WOODCUTTING = 1007; MINING = 1008; DIGGING = 1009; FIREMAKING = 1010; POTTERY = 1011; GROUP_TAILORING = 1012; MASONRY = 1013; ROPEMAKING = 1014; GROUP_SMITHING = 1015; GROUP_SMITHING_WEAPONSMITHING = 1016; GROUP_SMITHING_ARMOURSMITHING = 1017; GROUP_COOKING = 1018; GROUP_NATURE = 1019; MISCELLANEOUS = 1020; GROUP_ALCHEMY = 1021; GROUP_TOYS = 1022; GROUP_FIGHTING = 1023; GROUP_HEALING = 1024; GROUP_CLUBS = 1025; GROUP_RELIGION = 1026; GROUP_HAMMERS = 1027; GROUP_THIEVERY = 1028; GROUP_WARMACHINES = 1029; GROUP_ARCHERY = 1030; GROUP_BOWYERY = 1031; GROUP_FLETCHING = 1032; GROUP_POLEARMS = 1033; AXE_SMALL = 10001; SHOVEL = 10002; HATCHET = 10003; RAKE = 10004; SWORD_LONG = 10005; SHIELD_MEDIUM_METAL = 10006; KNIFE_CARVING = 10007; SAW = 10008; PICKAXE = 10009; SMITHING_WEAPON_BLADES = 10010; SMITHING_WEAPON_HEADS = 10011; SMITHING_ARMOUR_CHAIN = 10012; SMITHING_ARMOUR_PLATE = 10013; SMITHING_SHIELDS = 10014; SMITHING_BLACKSMITHING = 10015; CLOTHTAILORING = 10016; LEATHERWORKING = 10017; TRACKING = 10018; SHIELD_SMALL_WOOD = 10019; SHIELD_MEDIUM_WOOD = 10020; SHIELD_LARGE_WOOD = 10021; SHIELD_SMALL_METAL = 10022; SHIELD_LARGE_METAL = 10023; AXE_LARGE = 10024; AXE_HUGE = 10025; HAMMER = 10026; SWORD_SHORT = 10027; SWORD_TWOHANDED = 10028; KNIFE_BUTCHERING = 10029; STONE_CHISEL = 10030; PAVING = 10031; PROSPECT = 10032; FISHING = 10033; SMITHING_LOCKSMITHING = 10034; REPAIR = 10035; COALING = 10036; COOKING_DAIRIES = 10037; COOKING_STEAKING = 10038; COOKING_BAKING = 10039; MILLING = 10040; SMITHING_METALLURGY = 10041; ALCHEMY_NATURAL = 10042; SMITHING_GOLDSMITHING = 10043; CARPENTRY_FINE = 10044; GARDENING = 10045; SICKLE = 10046; SCYTHE = 10047; FORESTRY = 10048; FARMING = 10049; YOYO = 10050; TOYMAKING = 10051; WEAPONLESS_FIGHTING = 10052; FIGHT_AGGRESSIVESTYLE = 10053; FIGHT_DEFENSIVESTYLE = 10054; FIGHT_NORMALSTYLE = 10055; FIRSTAID = 10056; TAUNTING = 10057; SHIELDBASHING = 10058; BUTCHERING = 10059; MILKING = 10060; MAUL_LARGE = 10061; MAUL_MEDIUM = 10062; MAUL_SMALL = 10063; CLUB_HUGE = 10064; PREACHING = 10065; PRAYER = 10066; CHANNELING = 10067; EXORCISM = 10068; ARTIFACTS = 10069; WARHAMMER = 10070; FORAGING = 10071; BOTANIZING = 10072; CLIMBING = 10073; STONECUTTING = 10074; STEALING = 10075; LOCKPICKING = 10076; CATAPULT = 10077; TAMEANIMAL = 10078; BOW_SHORT = 10079; BOW_MEDIUM = 10080; BOW_LONG = 10081; SHIPBUILDING = 10082; COOKING_BEVERAGES = 10083; TRAPS = 10084; BREEDING = 10085; MEDITATING = 10086; PUPPETEERING = 10087; SPEAR_LONG = 10088; HALBERD = 10089; STAFF = 10090; PAPYRUSMAKING = 10091; THATCHING = 10092; BALLISTA = 10093; TREBUCHET = 10094; TURRETS = 10095; Share this post Link to post Share on other sites