Verry many usefull scripts For Your Mu Online Server !

UPDATE Character
SET Strength='65000'
WHERE Strength<1

UPDATE Character
SET Dexterity='65000'
WHERE Dexterity<1

UPDATE Character
SET Vitality='65000'
WHERE Vitality<1

UPDATE Character
SET Energy='65000'
WHERE Energy<1

UPDATE Character
SET Leadership='65000'
WHERE Leadership<1


Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.

how to fix?

cant u read ? :DDD Use a larger integer column. (lol)

not bad

I got a question how would you change beginner gear .. like upon char creation it added different beginner items

tehfire10, you shold rewrite GameServer, coz the default values is in it. (idk, maybe it's Dataserver, not GS).

Quote:

---

Originally Posted by Jahte

tehfire10, you shold rewrite GameServer, coz the default values is in it. (idk, maybe it's Dataserver, not GS).

---

oh i thought you could change the db's didnt know it would be something in the server files

Where to put this scripts ? :O

you have script for making guild in website?

how about if the character already gained max stat in all atrributes of his character which is (str 32767, agi 32767, Vit 32767, energy 32767 and command of 32767) and this character is making resets and gaining level up points even he already got the max stats in all attributes. how can i stop this character gaining levelup points when he still likes to make more resets if he already reach max stat in all field? let say he can gain more resets but no more levelup points to gain :), hope that good and brilliant scripters can help in this matter. More power to all :D

Nice Job :D

Thanks!!

Quote:

---

Originally Posted by rammerz

how about if the character already gained max stat in all atrributes of his character which is (str 32767, agi 32767, Vit 32767, energy 32767 and command of 32767) and this character is making resets and gaining level up points even he already got the max stats in all attributes. how can i stop this character gaining levelup points when he still likes to make more resets if he already reach max stat in all field? let say he can gain more resets but no more levelup points to gain :), hope that good and brilliant scripters can help in this matter. More power to all :D

---

update Character set leveluppoint='0'
where
Strength+Dexterity+Vitality+Energy='131068'
OR
Strength+Dexterity+Vitality+Energy+Leadership='163835'

if you like to implement build system for different character classes, and you like to give them different max points for their characters class upon reaching their max resets : like 65k for DL, 55k for MG and SM, 75k for Summoner and Elf and 50K for BK. what is the script do i need to encode just to do this kind of build system? help me with this one please. God Bless and more power.

Please Help Only Code
Grand Reset Code Please help me
500 Reset Only 1 Grand Reset
1 Grand Reset = Auto 10000 Kredi Free Please Code
İm Wait Please Code Only Quazer...
Thzx.

i know it exist a script to reduce the size of the DataBase... my database size is 6GB lol.. cand someone give me that script?

UPDATE Character
SET LevelUpPoint=('') + 1500
WHERE cLevel<=1 and Resets<=1
this script aint working .... i put it in SQL it shows me that i put it coreect but when i make a new char... Nothing :| No start up points