Starter Skills

Quote:

Originally Posted by trysten

this script never worked for my client and 6.4

I'm always disconnected from the game with error

I have to go into the database erase character skills to get into the game without error

Code:

SELECT SkillID,MAX(SkillLevel) AS SkillLevel,MAX(Country) AS Country,MAX(Grow) AS Grow,MAX(Attackfighter) AS Attackfighter,MAX(Defensefighter) AS Defensefighter,MAX(Patrolrogue) AS Patrolrogue,MAX(Shootrogue) AS Shootrogue,MAX(Attackmage) AS Attackmage,MAX(Defensemage) AS Defensemage INTO #Skills
FROM PS_GameDefs.dbo.Skills
WHERE ReqLevel <= [MENTION=309964]level[/MENTION] AND 
	SkillLevel < 100 AND 
	TypeShow > 0 AND 
	(((@Job != 0 OR (Attackfighter = 1)) AND ((@Family != 0 OR (Country IN (6,2,0))) AND (@Family != 3 OR (Country IN (6,5,3)))))
		AND ((@Job != 1 OR (Defensefighter = 1)) AND ((@Family != 0 OR (Country IN (6,2,0))) AND (@Family != 3 OR (Country IN (6,5,3)))))
		AND ((@Job != 2 OR (Patrolrogue = 1)) AND ((@Family != 1 OR (Country IN (6,2,1))) AND (@Family != 2 OR (Country IN (6,5,4)))))
		AND ((@Job != 3 OR (Shootrogue = 1)) AND ((@Family != 1 OR (Country IN (6,2,1))) AND (@Family != 3 OR (Country IN (6,5,3)))))
		AND ((@Job != 4 OR (Attackmage = 1)) AND ((@Family != 1 OR (Country IN (6,2,1))) AND (@Family != 2 OR (Country IN (6,5,4)))))
		AND ((@Job != 5 OR (Defensemage = 1)) AND ((@Family != 0 OR (Country IN (6,2,0))) AND (@Family != 2 OR (Country IN (6,5,4))))))
GROUP BY SkillID

DECLARE [MENTION=414337]count[/MENTION] INT = (SELECT COUNT(SkillLevel) FROM #Skills)

WHILE [MENTION=414337]count[/MENTION] > 0
BEGIN
	INSERT INTO CharSkills
	SELECT TOP (1)   [MENTION=395373]Chari[/MENTION]D,SkillID,SkillLevel [MENTION=414337]count[/MENTION],0,GETDATE(),0
	FROM #Skills

	DELETE TOP (1) FROM #Skills

	SET [MENTION=414337]count[/MENTION] -= 1
END

DROP TABLE #Skills

someone could help free all skills for clients shaiya ep 6.4 ?

Good morning,
what about your Server logs? Is anything interesting in it?

This Release from @[Only registered and activated users can see links. Click Here To Register...] is from the year 2013. And I know that the Ep 6.4 Skill Table has been changed. Maybe you have to correct the script from @[Only registered and activated users can see links. Click Here To Register...]_ .

Do you put the Script under this line in usp_Create_Char_R?

Code:

SET [@]CharID = IDENT_CURRENT('Chars')

Regards