[NEW] Skill reset scrolls (Working 100%)

[Klito*]

Greetings @everyone,

@ this is what you requested.

I created this query to reset the skills and the masteries, it will return all of the skill points that the character used
There are a lot of topics about this scroll but it doesn't return the real skill point that been used, but this does!

Here are the qurey:

DECLARE @TSP INT
DECLARE @TMSP INT
SET @TSP = (SELECT SUM(A.ReqLearn_SP) FROM _RefSkill A, _CharSkill B WHERE A.GroupID = (SELECT GroupID FROM _RefSkill WHERE ID = B.SkillID) AND A.Basic_Level <= (SELECT Basic_Level FROM _RefSkill WHERE ID = B.SkillID) AND B.CharID = @CharID)
SET @TMSP = (SELECT SUM(A.Exp_M) FROM _RefLevel A, _CharSkillMastery B WHERE A.Lvl <= B.Level - 1 AND B.CharID = @CharID)
UPDATE _Char SET RemainSkillPoint = RemainSkillPoint + @TSP + @TMSP
UPDATE _CharSkillMastery SET Level = 0 WHERE CharID = @CharID
DELETE _CharSkill WHERE SkillID NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625) AND CharID = @CharID

EDITED:

Due to @ you can replace the last line with:

DELETE FROM _CharSkill WHERE SkillID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill) AND CharID = @CharID

NOTE: Please dude don't ask me "Where is the _RefObjCommon & _RefObjItem lines?" or "Where/How should I use this?"
If you want to ask those questions then <Answer yourself>

Have A Nice Life!

[#HB]

You can replace:

DELETE _CharSkill WHERE SkillID NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625) AND CharID = @CharID

With:

DELETE skill FROM _CharSkill skill WHERE skill.SkillID NOT IN (SELECT defs.SkillID FROM _RefCharDefault_Skill defs) AND skill.CharID = @CharID

Good job though, it's nice to see that there's still people who can write a clean code other than known ones.

[SubZero**]

nice work mate

[Klito*]

Originally Posted by #HB

You can replace:

DELETE _CharSkill WHERE SkillID NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625) AND CharID = @CharID

With:

DELETE skill FROM _CharSkill skill WHERE skill.SkillID NOT IN (SELECT defs.SkillID FROM _RefCharDefault_Skill defs) AND skill.CharID = @CharID

Good job though, it's nice to see that there's still people who can write a clean code other than known ones.

Yeah!, but i think this line is shorter:

DELETE FROM _CharSkill WHERE SkillID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill) AND CharID = @CharID

Thanks dude.

Originally Posted by Zoro.Sro

nice work mate

Any Time!

[bende16]

Originally Posted by Klito*

Yeah!, but i think this line is shorter:

DELETE FROM _CharSkill WHERE SkillID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill) AND CharID = @CharID

Thanks dude.


Any Time!

need fb scroll 16/17/18/19 dg item Weapon/Shield/Armor/Ring set please ? % 100 fb +15 scroll

[Worshiper]

good work

[Dev.L0RdReVaN]

Originally Posted by Klito*

Greetings @everyone,

@ this is what you requested.

I created this query to reset the skills and the masteries, it will return all of the skill points that the character used
There are a lot of topics about this scroll but it doesn't return the real skill point that been used, but this does!

Here are the qurey:

DECLARE @TSP INT
DECLARE @TMSP INT
SET @TSP = (SELECT SUM(A.ReqLearn_SP) FROM _RefSkill A, _CharSkill B WHERE A.GroupID = (SELECT GroupID FROM _RefSkill WHERE ID = B.SkillID) AND A.Basic_Level <= (SELECT Basic_Level FROM _RefSkill WHERE ID = B.SkillID) AND B.CharID = @CharID)
SET @TMSP = (SELECT SUM(A.Exp_M) FROM _RefLevel A, _CharSkillMastery B WHERE A.Lvl <= B.Level - 1 AND B.CharID = @CharID)
UPDATE _Char SET RemainSkillPoint = RemainSkillPoint + @TSP + @TMSP
UPDATE _CharSkillMastery SET Level = 0 WHERE CharID = @CharID
DELETE _CharSkill WHERE SkillID NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625) AND CharID = @CharID

EDITED:

Due to @ you can replace the last line with:

DELETE FROM _CharSkill WHERE SkillID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill) AND CharID = @CharID

NOTE: Please dude don't ask me "Where is the _RefObjCommon & _RefObjItem lines?" or "Where/How should I use this?"
If you want to ask those questions then <Answer yourself>

Have A Nice Life!

wasn't my request i can do it

[!Apple]

GOOD JOB

[$telios]

Thnaks alot dude

[Klito*]

Originally Posted by Dev.L0RdReVaN

wasn't my request i can do it

Really!, So why you didn't?
Because it doesn't work in your server, That's a good question (WoW)
You asked me to do it for you but you are like a baby who doesn't want people to look at him and say: "He calls himself a developer and can't write this simple query", Oh dude baby will still a baby!

Thanks guys for supporting me!

[FrictionF0]

Originally Posted by #HB

You can replace:

DELETE _CharSkill WHERE SkillID NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625) AND CharID = @CharID

With:

DELETE skill FROM _CharSkill skill WHERE skill.SkillID NOT IN (SELECT defs.SkillID FROM _RefCharDefault_Skill defs) AND skill.CharID = @CharID

Good job though, it's nice to see that there's still people who can write a clean code other than known ones.

Actually if he already picked that info, it's more efficient to do it with a list and save that query each time since these values are usually static. You better notice the important matters, and there are important matters. I don't know how you guys can thank him for such a disaster query.
It's 100% working, in deed, but he forgot to mention that it's 100% working for everyone.
The query takes the data from a specific char but all the players enjoy the SP lol.

Originally Posted by Klito*

UPDATE _Char SET RemainSkillPoint = RemainSkillPoint + @TSP + @TMSP

Have A Nice Life!

But yeah..

Originally Posted by #HB

Good job though, it's nice to see that there's still people who can write a clean code other than known ones.

Delete this misleading thread or edit the query.

UPDATE _Char SET RemainSkillPoint = RemainSkillPoint + @TSP + @TMSP WHERE CharID = @CharID

Have A Nice Life!

[VORTEX*]

is that a show for your skills guys ?

[White Ros3]

good job

[onkeltonkel]

Gonna try out this.

[senua]

When your _Charskill table reaches the big data situation, these code is going to ****** up.