hi everyone is there a sql script to delete level up points and stats.,im using sql2008 and TT 11.70.28 server files.,thank you!
Printable View
hi everyone is there a sql script to delete level up points and stats.,im using sql2008 and TT 11.70.28 server files.,thank you!
for all chracters right?
If you don't worry about original stats then you can do it like this for all.Quote:
Originally Posted by jeffzkie69
>Code:Use [MuOnline]
Update Character Set LevelUpPoint = 0, Strength = 25, Dexterity = 25, Vitality = 25, Energy = 25
-- & (for DL/LE cmd)
Use [MuOnline]
Update Character Set Leadership = 25 where Leadership > 0
>>
>>>
=============================================================
If you wish to restore original stats, follow the same but use + where Class = ? on the first query.
where ? = Class code
HF.Code:0 = dw
1 = sm
2 = gm
3 = gm
16 = dk
17 = bk
18 = bm
19 = bm
32 = elf
33 = melf
34 = he
35 = he
48 = mg
49 = dm
50 = dm
64 = dl
65 = le
66 = le
80 = su
81 = bs
82 = dm
83 = dm
96 = rf
97 = fm
98 = fm
Btw here is bunch of useful sql scripts: http://forum.ragezone.com/f197/verry...93/index3.html