About Reset

[Takamura]

Hi guys, im in need of help.

This is my problem:

i want people/characters to get their bonus points when they reset.

because i want this to happen in my test server

When a character reach level 400, he reset, then after he reset, he will receive a free levelup points of 500 points but hes stats will be back to str = 28, agi= 28 vit=28 ene=28.

i tried changing settings in my website.

reset = reset : where reset/reset stats keep/keep stats
bonus points: 500

i tried that, but when they reset and got their 500 free bonus level up points, and they add it in their stats, after they had their 2nd reset, the bonus stats 500 also disappear, its like getting things back to zero.

coz in my test server, i want it to have max reset of 70. and every reset they got 500 points free, so when they reach 70 reset(max) they have all stats sum up to 35,000 points. \because i dont want to have everyone to have full stats! i want to make evryone to have their own strategy of having their stats distribution.
if there's is an sql script out there out guide to do this.
please help me

if u miss out my point please read my msg again^^ im sure ull get it. it's hard to explain. damn!

thnx in advance!

[MentaL]

[JaneX]

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 500, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Resets = Resets + 1, Character.Strength = 28, Character.Dexterity = 28, Character.Vitality =28, Character.Energy = 28
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 400) AND (Money >= (100000000)) AND (ConnectStat = 0) ;

im not sure if this works but since its a test server why dont give a try? xD

[Takamura]

so i just need to insert this script in mu online database using query analyzer?

and do u have a link for a mssql2000 service pack 4, coz i have 1 but its due for 3 months use only

hope u can help me

[JaneX]

yes but you can also make a job for sql too so it will check players every period :P

sorry im not allowed to that here ;c u can search at google btw.

muweb has an option too in character panel that will suite ur preference

==>KEEP STATS
or
==>RESET STATS