Starter Skills

[trysten]

close

[{Skrillex}]

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

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 @ 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 @_ .


Do you put the Script under this line in usp_Create_Char_R?

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

Regards

[{Skrillex}]

well,
what about your logs?

[RaydenRey]

well 3 years after, i tried same script from @

Works mostly but for warrior and fighters. Those 2 crashe the cliente upon trying to log in, all the rest works. Ep6 Db but running as ep5.4

[Realp0rta]

Ep4 SkillLevel < 3
EP5 SkillLevel < 9
EP6.4+ SkillLevel < 15 < error .sdata and SkillLevel scrip.sql

SkillLevel <100 not 6.4 = Error!


Español!
Recomiendo usar solo en ep 4,5 con skillLevel Original y no Utilizar SkillLevel superior a lv9
las habilidades no funcionan correctamente para el ep 6.4 o superior!

Puede!

 Spoiler

Editar SkillLevel < 100 AND
TypeShow > 0 AND

Ep4 SkillLevel < 3
EP5 SkillLevel < 9
EP6.4+ SkillLevel < 9.

esto es un error ´por parte de Ps_game Ep5.4 si usted logra solucionar podra utilizar en ep 6.4+ o superior,