VIp SKill

i Have Promblem To OPen two Skill How i can open the 2 skill


[Only registered and activated users can see links. Click Here To Register...]

up

check if the skills service is set to 1

Quote:

Originally Posted by leo2111 check if the skills service is set to 1

^ either this, or the "required race" setting.

Quote:

Originally Posted by leo2111 check if the skills service is set to 1

Service 1 in Refskill and Skilldata

i can't Up Skill

Check ID, Skill Slot, ReqCommon_Mastery1 2 etc, ReqLearnRace both server and client

Alright, if the service is setted to 1 , you can up the skills through a query
1st step :

- execute this





USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_CHARSKILLS] Script Date: 06.01.2015 05:06:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/**
return value :
0 = No Errors
100 = The charname does not exists.
101 = Unknown Error.
**/

CREATE PROCEDURE [dbo].[_UPDATE_CHARSKILLS]
@[Only registered and activated users can see links. Click Here To Register...]CharName nvarchar(30)
AS
SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @[Only registered and activated users can see links. Click Here To Register...]turnValue int
, @[Only registered and activated users can see links. Click Here To Register...]harID int
, @[Only registered and activated users can see links. Click Here To Register...]killID int

/**_# Rollback and return if inside an uncommittable transaction.*/
IF XACT_STATE() = -1
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]turnValue = 1
GOTO ErrorHandler
END

BEGIN TRY
SELECT @[Only registered and activated users can see links. Click Here To Register...]harID = CharID
FROM _Char WITH (NOLOCK)
WHERE CharName16 = @[Only registered and activated users can see links. Click Here To Register...]CharName

IF @[Only registered and activated users can see links. Click Here To Register...]harID IS NULL OR @[Only registered and activated users can see links. Click Here To Register...]harID = 0)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]turnValue = 100
GOTO ErrorHandler
END

/**_# [_CharSkill] DELETE FROM TABLE*/
DELETE FROM _CharSkill WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]harID AND SkillID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill)

/**_# [UPDATE_SKILL_CURSOR] CREATE AND EXECUTE*/
DECLARE UPDATE_SKILL_CURSOR CURSOR FOR
SELECT RS.ID
FROM
(
SELECT Basic_Group
, MAX(Basic_Level) AS Basic_Level
FROM _RefSkill RS
JOIN _CharSkillMastery CSM
ON RS.ReqCommon_Mastery1 = CSM.MasteryID
WHERE RS.Service = 1
AND RS.ID NOT IN (SELECT SkillID FROM _RefCharDefault_Skill)
AND RS.ReqCommon_MasteryLevel1 <= CSM.Level
AND CSM.CharID = @[Only registered and activated users can see links. Click Here To Register...]harID
GROUP BY Basic_Group
) MGS
JOIN _RefSkill RS
ON RS.Basic_Group = MGS.Basic_Group
AND RS.Basic_Level = MGS.Basic_Level
WHERE RS.ReqLearn_SP != 0

OPEN UPDATE_SKILL_CURSOR
FETCH NEXT FROM UPDATE_SKILL_CURSOR INTO @[Only registered and activated users can see links. Click Here To Register...]killID
WHILE @@FETCH_STATUS = 0
BEGIN

/**_# [_CharSkill] INSERT INTO TABLE*/
INSERT INTO _CharSkill (CharID, SkillID, Enable)
VALUES @[Only registered and activated users can see links. Click Here To Register...]harID, @[Only registered and activated users can see links. Click Here To Register...]killID, 1)

FETCH NEXT FROM UPDATE_SKILL_CURSOR INTO @[Only registered and activated users can see links. Click Here To Register...]killID
END
CLOSE UPDATE_SKILL_CURSOR
DEALLOCATE UPDATE_SKILL_CURSOR
END TRY
BEGIN CATCH
SET @[Only registered and activated users can see links. Click Here To Register...]turnValue = 101
GOTO ErrorHandler
END CATCH

RETURN 0

ErrorHandler:
IF XACT_STATE() <> 0
ROLLBACK TRANSACTION
RETURN @[Only registered and activated users can see links. Click Here To Register...]turnValue





2nd step :
-create a new query, paste this :




USE SRO_VT_SHARD
DECLARE @[Only registered and activated users can see links. Click Here To Register...]turnValue int

EXEC @[Only registered and activated users can see links. Click Here To Register...]turnValue = _UPDATE_CHARSKILLS Charname
SELECT @[Only registered and activated users can see links. Click Here To Register...]turnValue AS ReturnValue
[/CODE]





3rd step :
-execute it, teleport and your skills are up