Is it possible to make a script to clear all buffs/stats from gear from the db? This would be very useful for roleplay servers.
all stats and spell’s ? item_template , playercreateinfo_spell and playercreateinfo_spell_custom . Empty this table and
insert passive and Language spells . You seach this spell http://subversion.assembla.com/svn/rtdb/Structure/World/playercreateinfo_spell.sql
Make a backup before attempting anything.
What all stats should be cleared?
Something like this should work:
UPDATE item_template SET
itemset = 0, StatsCount = 0,
stat_type1 = 0, stat_value1 = 0,
stat_type2 = 0, stat_value2 = 0,
stat_type3 = 0, stat_value3 = 0,
stat_type4 = 0, stat_value4 = 0,
stat_type5 = 0, stat_value5 = 0,
stat_type6 = 0, stat_value6 = 0,
stat_type7 = 0, stat_value7 = 0,
stat_type8 = 0, stat_value8 = 0,
stat_type9 = 0, stat_value9 = 0,
stat_type10 = 0, stat_value10 = 0,
spellid_1 = 0, spelltrigger_1 = 0, spellcharges_1 = 0, spellppmRate_1 = 0, spellcooldown_1 = 0, spellcategory_1 = 0, spellcategorycooldown_1 = 0,
spellid_2 = 0, spelltrigger_2 = 0, spellcharges_2 = 0, spellppmRate_2 = 0, spellcooldown_2 = 0, spellcategory_2 = 0, spellcategorycooldown_2 = 0,
spellid_3 = 0, spelltrigger_3 = 0, spellcharges_3 = 0, spellppmRate_3 = 0, spellcooldown_3 = 0, spellcategory_3 = 0, spellcategorycooldown_3 = 0,
spellid_4 = 0, spelltrigger_4 = 0, spellcharges_4 = 0, spellppmRate_4 = 0, spellcooldown_4 = 0, spellcategory_4 = 0, spellcategorycooldown_4 = 0,
spellid_5 = 0, spelltrigger_5 = 0, spellcharges_5 = 0, spellppmRate_5 = 0, spellcooldown_5 = 0, spellcategory_5 = 0, spellcategorycooldown_5 = 0;
I mean for clothing, so that characters only have base stats to work with.
You need to depower all of the weapons as well or else your RP’ers will be two-shotting each other with LK weapons.
That too. But is this possible?