[Release]Global Stat/Skill Reset

You forgot temp table declaration lilpro. All and all, nice script.

Quote:

Originally Posted by Danco1990 Don't forget to detract 1 for bp lv1 3 for bp lv2 and 5 in total for bp lv3. Also, the original script was missing the 5 starter skillpoints. Had to add this all manually. Just a heads up.

The subtraction for the backpack skill points is in my script already. Also You'll see that it updates the CharSkill table to make the backpack skill number 0. If you don't do this it can cause issues when the chars go and learn new skills, and as for the 5 skill points that you start with I forgot about that. I updated the script above to have it.

Prof:
you dont need to declare a temp table when you place it in a select statement.

Hmm, i have used my own script, and have not received any problems yet with people learning new skills, i left the BP SkillID value standard. However, i only use a direct "Everything except this skill" statement, perhaps that is what made it tick lol. Ofcourse it tested it on a test DB a few times, but it seems to work from what i see.

5 Skillpoints extra is easy, just use the skillpoint = skillpoint + 5 or something like that.

Thanked. pretty usful

ummm how to reset skill/stat points in shaiya phoenix i know a guy who does but wont tell lol...can anyone help please???

Genial, me sirvio de mucho !