Szukam Skrypty QA

[type009]

witam !  

 

 

poszukuje skryptów. Query.. 

gdy wykonam Reset... to chciałbym aby Staty .. się Kasowały.. a po reset 1000 PKT do Rozdania .


SQL 2000 

Pozdrawiam 

[mattgoodbye]

A próbowałeś poszukać skryptów w google .... Jest tego dużo naprawdę

[type009]

tak patrzylem . ale chyba problem rozwiazalem . Pliki które posiadam .  kolumnie : Reset >- stailem .. AFTERRESET 1000points. , tylko terasz w sql trzeba ustaic aby staty sie kasowaly i tu jest problem )


Pozdrawiam !

[zyga29]

UPDATE Character SET CLevel = 1, Experience = 0, %1$s=%2$s, Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, LevelUpPoint = 0 + %2$s * 1000, MapNumber = 0, MapPosX = 125, MapPosY = 125 WHERE (Class = 0 OR Class = 1) AND Name = '%3$s'

UPDATE Character SET CLevel = 1, Experience = 0, %1$s=%2$s, Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, LevelUpPoint = 0 + %2$s * 1000, MapNumber = 0, MapPosX = 125, MapPosY = 125 WHERE (Class = 16 OR Class = 17) AND Name = '%3$s'

UPDATE Character SET CLevel = 1, Experience = 0, %1$s=%2$s, Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, LevelUpPoint = 0 + %2$s * 1000, MapNumber = 0, MapPosX = 125, MapPosY = 125 WHERE (Class = 32 OR Class = 33) AND Name = '%3$s'

UPDATE Character SET CLevel = 1, Experience = 0, %1$s=%2$s, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, LevelUpPoint = 0 + %2$s * 1000, MapNumber = 0, MapPosX = 125, MapPosY = 125 WHERE (Class = 48 OR Class = 64) AND Name = '%3$s'