how to make these changes for a RP server

So_1337 · #2 10-20-2008, 02:22 PM

I'll do the easy ones now.

Remove NO DROP flag from all items:

Code:

UPDATE items SET nodrop = 1 WHERE nodrop = 0;

Remove QUEST flag from all items:

Code:

UPDATE items SET questitemflag = 0 WHERE questitemflag = 1;

Remove LORE flag from all items:

Code:

UPDATE items SET lore = 0 WHERE lore = 1;

Change NPC corpse rot rate to 24 hours real time:

Code:

UPDATE rule_values SET rule_value = 86400000 WHERE rule_name = 'NPC:MinorNPCCorpseDecayTimeMS';
UPDATE rule_values SET rule_value = 86400000 WHERE rule_name = 'NPC:MajorNPCCorpseDecayTimeMS';

More to come =P