Dawn of Light

Hello there,

i have started to spiral myself into DOL and am setting up a PvP server which will go public soon. I am an IT student and have been playing DAoC for a long time. So, i want to give you guys something back by adding some handy db scripts like this one:

Code: Select all

-- This changes all realmspecific Bonusslots in items to Acuity (156) -- -- Items with Piety (6) -- UPDATE itemtemplate it SET it.Bonus1Type = 156 WHERE it.Bonus1Type = 6; UPDATE itemtemplate it SET it.Bonus2Type = 156 WHERE it.Bonus2Type = 6; UPDATE itemtemplate it SET it.Bonus3Type = 156 WHERE it.Bonus3Type = 6; UPDATE itemtemplate it SET it.Bonus4Type = 156 WHERE it.Bonus4Type = 6; UPDATE itemtemplate it SET it.Bonus5Type = 156 WHERE it.Bonus5Type = 6; -- Items with Empathy (7) -- UPDATE itemtemplate it SET it.Bonus1Type = 156 WHERE it.Bonus1Type = 7; UPDATE itemtemplate it SET it.Bonus2Type = 156 WHERE it.Bonus2Type = 7; UPDATE itemtemplate it SET it.Bonus3Type = 156 WHERE it.Bonus3Type = 7; UPDATE itemtemplate it SET it.Bonus4Type = 156 WHERE it.Bonus4Type = 7; UPDATE itemtemplate it SET it.Bonus5Type = 156 WHERE it.Bonus5Type = 7; -- Items with Intelligence (5) -- UPDATE itemtemplate it SET it.Bonus1Type = 156 WHERE it.Bonus1Type = 5; UPDATE itemtemplate it SET it.Bonus2Type = 156 WHERE it.Bonus2Type = 5; UPDATE itemtemplate it SET it.Bonus3Type = 156 WHERE it.Bonus3Type = 5; UPDATE itemtemplate it SET it.Bonus4Type = 156 WHERE it.Bonus4Type = 5; UPDATE itemtemplate it SET it.Bonus5Type = 156 WHERE it.Bonus5Type = 5; -- Items with Charisma (8) -- UPDATE itemtemplate it SET it.Bonus1Type = 156 WHERE it.Bonus1Type = 8; UPDATE itemtemplate it SET it.Bonus2Type = 156 WHERE it.Bonus2Type = 8; UPDATE itemtemplate it SET it.Bonus3Type = 156 WHERE it.Bonus3Type = 8; UPDATE itemtemplate it SET it.Bonus4Type = 156 WHERE it.Bonus4Type = 8; UPDATE itemtemplate it SET it.Bonus5Type = 156 WHERE it.Bonus5Type = 8;

Enjoy!

Thank you VM ! Can you simply mention against what DB you are running theses queries ?

If you are interested to cleanup the actual public DB, we can release it as the new public DB. Thank you !

I have written this query in a way that allows you to execute it as often as you want and also it doesn't make any difference whether there are 50k items in it or 500k. This script just searches for Empathy/Charisma/Piety/Intelligence in every BonusType Slot of every item in this table and replaces (only at these certain slots) the value with the value of Acuity.

I will keep more of these scripts coming!

PS: I am searching for a way to better understand how the tables are connected to each other. Some documentation/coding rulesets would be much appreciated. Also, i would like to help to increase the performance of the db by helping you guys to use indexes/indices, primary keys, maybe we could even build cachetables for statistical things like a herald.
(I remember playing on Argain and when the herald update script was running the server would lag or even go offline.)

My question was rather because some DBs could already be up to date.

A lot of work have been done in DOLDatabase: this module is able to handle indexes, caches etc... Latest huge project was a complete move to integer primary key support (a big performance problem). It is actually working IIRC, but it lacks a script for migrate the whole stuff in a single click and throw string pkey to the hell they deserve !

for herald, various approaches have been implemented, and as some are poors, some are really working fine. IIRC you can find a lot of herald, from c# to php, on theses forums