Re-Open Skills

03/16/2017 20:20 batymaty#1

I had a problem this afternoon, had to delete all the players' open skills, and then re-apply again, but I don't find a script, then I edited one from Elitepvpers for this.
I used the script of Philipp_ here [Only registered and activated users can see links. Click Here To Register...], so credits Goes to HIM.

03/16/2017 22:14 SnickQ#2

Add this to another Storred Proc than Create_Chars

03/16/2017 22:49 batymaty#3

Quote:

Originally Posted by SnickQ

Add this to another Storred Proc than Create_Chars

I just wanted to delete all CharSkill for the toons that already exist in the server and re-open then, how I'm newbie in SQL idk how to do it as proc and if it works, then did it on that way, but thanks Snick :)

03/16/2017 23:11 SnickQ#4

USE PS_GameData
Delete from CharSkills
--This is for dellete skills

Open Your PS_GameData serch for Programmability then open Stored Procedure and then open for me usp_Read_Chars_R and paste here

03/16/2017 23:20 momocruz#5

You mean Reset all Char skill from game

this help you

PHP Code:


			
TRUNCATE TABLE PS_GameData.dbo.CharQuickSlots





DELETE FROM  PS_GameData.dbo.CharSkills WHERE SkillID <> 4





UPDATE PS_GameData.dbo.Chars   SET   SkillPoint= [Level]*(Grow+2)

03/16/2017 23:59 batymaty#6

but If I do it, will not execute the query many times? I just wanted to delete and re-open 1 time during restart.

03/17/2017 11:55 SnickQ#7

Yes only one time