كود:
USE [SRO_VT_SHARD]
DECLARE @CharName varchar(255)
DECLARE @CharID INT
----------------------------------------------------------
SET @CharName='Player' --CharName
----------------------------------------------------------
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName
------------------------------------------------------------------
UPDATE _CharSkillMastery SET Level = '120' --Mastry
------------------------------------------------------------------
WHERE CharID=@CharID
INSERT INTO _CharSkill VALUES (@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,8419,1)
INSERT INTO _CharSkill VALUES (@CharID,8420,1)
INSERT INTO _CharSkill VALUES (@CharID,8421,1)
INSERT INTO _CharSkill VALUES (@CharID,8440,1)
INSERT INTO _CharSkill VALUES (@CharID,8451,1)
INSERT INTO _CharSkill VALUES (@CharID,8468,1)
INSERT INTO _CharSkill VALUES (@CharID,8478,1)
INSERT INTO _CharSkill VALUES (@CharID,8501,1)
INSERT INTO _CharSkill VALUES (@CharID,8515,1)
INSERT INTO _CharSkill VALUES (@CharID,8526,1)
INSERT INTO _CharSkill VALUES (@CharID,8531,1)
INSERT INTO _CharSkill VALUES (@CharID,8546,1)
INSERT INTO _CharSkill VALUES (@CharID,8560,1)
INSERT INTO _CharSkill VALUES (@CharID,8574,1)
INSERT INTO _CharSkill VALUES (@CharID,8584,1)
INSERT INTO _CharSkill VALUES (@CharID,8599,1)
INSERT INTO _CharSkill VALUES (@CharID,8629,1)
INSERT INTO _CharSkill VALUES (@CharID,8649,1)
INSERT INTO _CharSkill VALUES (@CharID,8660,1)
INSERT INTO _CharSkill VALUES (@CharID,8670,1)
INSERT INTO _CharSkill VALUES (@CharID,8710,1)
INSERT INTO _CharSkill VALUES (@CharID,8725,1)
INSERT INTO _CharSkill VALUES (@CharID,8752,1)
INSERT INTO _CharSkill VALUES (@CharID,8777,1)
INSERT INTO _CharSkill VALUES (@CharID,8812,1)
INSERT INTO _CharSkill VALUES (@CharID,8832,1)
INSERT INTO _CharSkill VALUES (@CharID,8884,1)
INSERT INTO _CharSkill VALUES (@CharID,8895,1)
INSERT INTO _CharSkill VALUES (@CharID,8905,1)
INSERT INTO _CharSkill VALUES (@CharID,8935,1)
INSERT INTO _CharSkill VALUES (@CharID,8974,1)
INSERT INTO _CharSkill VALUES (@CharID,8999,1)
INSERT INTO _CharSkill VALUES (@CharID,9034,1)
INSERT INTO _CharSkill VALUES (@CharID,9045,1)
INSERT INTO _CharSkill VALUES (@CharID,9075,1)
INSERT INTO _CharSkill VALUES (@CharID,9105,1)
INSERT INTO _CharSkill VALUES (@CharID,9116,1)
INSERT INTO _CharSkill VALUES (@CharID,9126,1)
INSERT INTO _CharSkill VALUES (@CharID,9145,1)
INSERT INTO _CharSkill VALUES (@CharID,9175,1)
INSERT INTO _CharSkill VALUES (@CharID,9187,1)
INSERT INTO _CharSkill VALUES (@CharID,9214,1)
INSERT INTO _CharSkill VALUES (@CharID,9250,1)
INSERT INTO _CharSkill VALUES (@CharID,9262,1)
INSERT INTO _CharSkill VALUES (@CharID,9287,1)
INSERT INTO _CharSkill VALUES (@CharID,9322,1)
INSERT INTO _CharSkill VALUES (@CharID,9342,1)
INSERT INTO _CharSkill VALUES (@CharID,9354,1)
INSERT INTO _CharSkill VALUES (@CharID,9355,1)
INSERT INTO _CharSkill VALUES (@CharID,9365,1)
INSERT INTO _CharSkill VALUES (@CharID,9370,1)
INSERT INTO _CharSkill VALUES (@CharID,9373,1)
INSERT INTO _CharSkill VALUES (@CharID,9378,1)
INSERT INTO _CharSkill VALUES (@CharID,9383,1)
INSERT INTO _CharSkill VALUES (@CharID,9388,1)
INSERT INTO _CharSkill VALUES (@CharID,9393,1)
INSERT INTO _CharSkill VALUES (@CharID,9397,1)
INSERT INTO _CharSkill VALUES (@CharID,9401,1)
INSERT INTO _CharSkill VALUES (@CharID,9407,1)
INSERT INTO _CharSkill VALUES (@CharID,9412,1)
INSERT INTO _CharSkill VALUES (@CharID,9417,1)
INSERT INTO _CharSkill VALUES (@CharID,9422,1)
INSERT INTO _CharSkill VALUES (@CharID,9428,1)
INSERT INTO _CharSkill VALUES (@CharID,9431,1)
INSERT INTO _CharSkill VALUES (@CharID,9437,1)
INSERT INTO _CharSkill VALUES (@CharID,9439,1)
INSERT INTO _CharSkill VALUES (@CharID,9444,1)
INSERT INTO _CharSkill VALUES (@CharID,9450,1)
INSERT INTO _CharSkill VALUES (@CharID,9453,1)
INSERT INTO _CharSkill VALUES (@CharID,9454,1)
INSERT INTO _CharSkill VALUES (@CharID,9484,1)
INSERT INTO _CharSkill VALUES (@CharID,9489,1)
INSERT INTO _CharSkill VALUES (@CharID,9500,1)
INSERT INTO _CharSkill VALUES (@CharID,9517,1)
INSERT INTO _CharSkill VALUES (@CharID,9528,1)
INSERT INTO _CharSkill VALUES (@CharID,9545,1)
INSERT INTO _CharSkill VALUES (@CharID,9574,1)
INSERT INTO _CharSkill VALUES (@CharID,9589,1)
INSERT INTO _CharSkill VALUES (@CharID,9601,1)
INSERT INTO _CharSkill VALUES (@CharID,9614,1)
INSERT INTO _CharSkill VALUES (@CharID,9623,1)
INSERT INTO _CharSkill VALUES (@CharID,9634,1)
INSERT INTO _CharSkill VALUES (@CharID,9675,1)
INSERT INTO _CharSkill VALUES (@CharID,9687,1)
INSERT INTO _CharSkill VALUES (@CharID,9704,1)
INSERT INTO _CharSkill VALUES (@CharID,9715,1)
INSERT INTO _CharSkill VALUES (@CharID,9722,1)
INSERT INTO _CharSkill VALUES (@CharID,9738,1)
INSERT INTO _CharSkill VALUES (@CharID,9743,1)
INSERT INTO _CharSkill VALUES (@CharID,9773,1)
INSERT INTO _CharSkill VALUES (@CharID,9785,1)
INSERT INTO _CharSkill VALUES (@CharID,9801,1)
INSERT INTO _CharSkill VALUES (@CharID,9845,1)
INSERT INTO _CharSkill VALUES (@CharID,9871,1)
INSERT INTO _CharSkill VALUES (@CharID,9880,1)
INSERT INTO _CharSkill VALUES (@CharID,9900,1)
INSERT INTO _CharSkill VALUES (@CharID,9943,1)
INSERT INTO _CharSkill VALUES (@CharID,9944,1)
INSERT INTO _CharSkill VALUES (@CharID,9949,1)
INSERT INTO _CharSkill VALUES (@CharID,9952,1)
INSERT INTO _CharSkill VALUES (@CharID,9954,1)
INSERT INTO _CharSkill VALUES (@CharID,9957,1)
INSERT INTO _CharSkill VALUES (@CharID,9965,1)
INSERT INTO _CharSkill VALUES (@CharID,9967,1)
INSERT INTO _CharSkill VALUES (@CharID,9974,1)
INSERT INTO _CharSkill VALUES (@CharID,9993,1)
INSERT INTO _CharSkill VALUES (@CharID,10004,1)
INSERT INTO _CharSkill VALUES (@CharID,10017,1)
INSERT INTO _CharSkill VALUES (@CharID,10032,1)
INSERT INTO _CharSkill VALUES (@CharID,10043,1)
INSERT INTO _CharSkill VALUES (@CharID,10048,1)
INSERT INTO _CharSkill VALUES (@CharID,10062,1)
INSERT INTO _CharSkill VALUES (@CharID,10073,1)
INSERT INTO _CharSkill VALUES (@CharID,10076,1)
INSERT INTO _CharSkill VALUES (@CharID,10079,1)
INSERT INTO _CharSkill VALUES (@CharID,10098,1)
INSERT INTO _CharSkill VALUES (@CharID,10109,1)
INSERT INTO _CharSkill VALUES (@CharID,10122,1)
INSERT INTO _CharSkill VALUES (@CharID,10137,1)
INSERT INTO _CharSkill VALUES (@CharID,10163,1)
INSERT INTO _CharSkill VALUES (@CharID,10168,1)
INSERT INTO _CharSkill VALUES (@CharID,10182,1)
INSERT INTO _CharSkill VALUES (@CharID,10192,1)
INSERT INTO _CharSkill VALUES (@CharID,10202,1)
INSERT INTO _CharSkill VALUES (@CharID,10207,1)
INSERT INTO _CharSkill VALUES (@CharID,10226,1)
INSERT INTO _CharSkill VALUES (@CharID,10237,1)
INSERT INTO _CharSkill VALUES (@CharID,10256,1)
INSERT INTO _CharSkill VALUES (@CharID,10267,1)
INSERT INTO _CharSkill VALUES (@CharID,10282,1)
INSERT INTO _CharSkill VALUES (@CharID,10296,1)
INSERT INTO _CharSkill VALUES (@CharID,10309,1)
INSERT INTO _CharSkill VALUES (@CharID,10323,1)
INSERT INTO _CharSkill VALUES (@CharID,10418,1)
INSERT INTO _CharSkill VALUES (@CharID,10489,1)
INSERT INTO _CharSkill VALUES (@CharID,10494,1)
INSERT INTO _CharSkill VALUES (@CharID,10513,1)
INSERT INTO _CharSkill VALUES (@CharID,10524,1)
INSERT INTO _CharSkill VALUES (@CharID,10537,1)
INSERT INTO _CharSkill VALUES (@CharID,10552,1)
INSERT INTO _CharSkill VALUES (@CharID,10563,1)
INSERT INTO _CharSkill VALUES (@CharID,10568,1)
INSERT INTO _CharSkill VALUES (@CharID,10582,1)
INSERT INTO _CharSkill VALUES (@CharID,10607,1)
INSERT INTO _CharSkill VALUES (@CharID,10621,1)
INSERT INTO _CharSkill VALUES (@CharID,10624,1)
INSERT INTO _CharSkill VALUES (@CharID,10625,1)
INSERT INTO _CharSkill VALUES (@CharID,10655,1)
INSERT INTO _CharSkill VALUES (@CharID,10660,1)
INSERT INTO _CharSkill VALUES (@CharID,10689,1)
INSERT INTO _CharSkill VALUES (@CharID,10707,1)
INSERT INTO _CharSkill VALUES (@CharID,10735,1)
INSERT INTO _CharSkill VALUES (@CharID,10751,1)
INSERT INTO _CharSkill VALUES (@CharID,10776,1)
INSERT INTO _CharSkill VALUES (@CharID,10789,1)
INSERT INTO _CharSkill VALUES (@CharID,10810,1)
INSERT INTO _CharSkill VALUES (@CharID,10821,1)
INSERT INTO _CharSkill VALUES (@CharID,10832,1)
INSERT INTO _CharSkill VALUES (@CharID,10838,1)
INSERT INTO _CharSkill VALUES (@CharID,10848,1)
INSERT INTO _CharSkill VALUES (@CharID,10853,1)
INSERT INTO _CharSkill VALUES (@CharID,10862,1)
INSERT INTO _CharSkill VALUES (@CharID,10866,1)
INSERT INTO _CharSkill VALUES (@CharID,10874,1)
INSERT INTO _CharSkill VALUES (@CharID,10877,1)
INSERT INTO _CharSkill VALUES (@CharID,10907,1)
INSERT INTO _CharSkill VALUES (@CharID,10917,1)
INSERT INTO _CharSkill VALUES (@CharID,10947,1)
INSERT INTO _CharSkill VALUES (@CharID,10965,1)
INSERT INTO _CharSkill VALUES (@CharID,10973,1)
INSERT INTO _CharSkill VALUES (@CharID,10977,1)
INSERT INTO _CharSkill VALUES (@CharID,10988,1)
INSERT INTO _CharSkill VALUES (@CharID,10993,1)
INSERT INTO _CharSkill VALUES (@CharID,11003,1)
INSERT INTO _CharSkill VALUES (@CharID,11007,1)
INSERT INTO _CharSkill VALUES (@CharID,11011,1)
INSERT INTO _CharSkill VALUES (@CharID,11015,1)
INSERT INTO _CharSkill VALUES (@CharID,11045,1)
INSERT INTO _CharSkill VALUES (@CharID,11074,1)
INSERT INTO _CharSkill VALUES (@CharID,11086,1)
INSERT INTO _CharSkill VALUES (@CharID,11099,1)
INSERT INTO _CharSkill VALUES (@CharID,11109,1)
INSERT INTO _CharSkill VALUES (@CharID,11118,1)
INSERT INTO _CharSkill VALUES (@CharID,11129,1)
INSERT INTO _CharSkill VALUES (@CharID,11134,1)
INSERT INTO _CharSkill VALUES (@CharID,11144,1)
INSERT INTO _CharSkill VALUES (@CharID,11148,1)
INSERT INTO _CharSkill VALUES (@CharID,11154,1)
INSERT INTO _CharSkill VALUES (@CharID,11161,1)
INSERT INTO _CharSkill VALUES (@CharID,11162,1)
INSERT INTO _CharSkill VALUES (@CharID,11192,1)
INSERT INTO _CharSkill VALUES (@CharID,11200,1)
INSERT INTO _CharSkill VALUES (@CharID,11211,1)
INSERT INTO _CharSkill VALUES (@CharID,11218,1)
INSERT INTO _CharSkill VALUES (@CharID,11248,1)
INSERT INTO _CharSkill VALUES (@CharID,11264,1)
INSERT INTO _CharSkill VALUES (@CharID,11284,1)
INSERT INTO _CharSkill VALUES (@CharID,11295,1)
INSERT INTO _CharSkill VALUES (@CharID,11301,1)
INSERT INTO _CharSkill VALUES (@CharID,11312,1)
INSERT INTO _CharSkill VALUES (@CharID,11322,1)
INSERT INTO _CharSkill VALUES (@CharID,11337,1)
INSERT INTO _CharSkill VALUES (@CharID,11341,1)
INSERT INTO _CharSkill VALUES (@CharID,11352,1)
INSERT INTO _CharSkill VALUES (@CharID,11357,1)
INSERT INTO _CharSkill VALUES (@CharID,11363,1)
INSERT INTO _CharSkill VALUES (@CharID,11367,1)
INSERT INTO _CharSkill VALUES (@CharID,11377,1)
INSERT INTO _CharSkill VALUES (@CharID,11381,1)
INSERT INTO _CharSkill VALUES (@CharID,11387,1)
INSERT INTO _CharSkill VALUES (@CharID,11390,1)
INSERT INTO _CharSkill VALUES (@CharID,11400,1)
INSERT INTO _CharSkill VALUES (@CharID,11432,1)
INSERT INTO _CharSkill VALUES (@CharID,11448,1)
INSERT INTO _CharSkill VALUES (@CharID,11465,1)
INSERT INTO _CharSkill VALUES (@CharID,11474,1)
INSERT INTO _CharSkill VALUES (@CharID,11481,1)
INSERT INTO _CharSkill VALUES (@CharID,11487,1)
INSERT INTO _CharSkill VALUES (@CharID,11492,1)
INSERT INTO _CharSkill VALUES (@CharID,11498,1)
INSERT INTO _CharSkill VALUES (@CharID,11503,1)
INSERT INTO _CharSkill VALUES (@CharID,11508,1)
INSERT INTO _CharSkill VALUES (@CharID,11513,1)
INSERT INTO _CharSkill VALUES (@CharID,11517,1)
INSERT INTO _CharSkill VALUES (@CharID,11522,1)
INSERT INTO _CharSkill VALUES (@CharID,11525,1)
INSERT INTO _CharSkill VALUES (@CharID,11526,1)
INSERT INTO _CharSkill VALUES (@CharID,11556,1)
INSERT INTO _CharSkill VALUES (@CharID,11586,1)
INSERT INTO _CharSkill VALUES (@CharID,11602,1)
INSERT INTO _CharSkill VALUES (@CharID,11611,1)
INSERT INTO _CharSkill VALUES (@CharID,11622,1)
INSERT INTO _CharSkill VALUES (@CharID,11627,1)
INSERT INTO _CharSkill VALUES (@CharID,11643,1)
INSERT INTO _CharSkill VALUES (@CharID,11649,1)
INSERT INTO _CharSkill VALUES (@CharID,11668,1)
INSERT INTO _CharSkill VALUES (@CharID,11685,1)
INSERT INTO _CharSkill VALUES (@CharID,11694,1)
INSERT INTO _CharSkill VALUES (@CharID,11702,1)
INSERT INTO _CharSkill VALUES (@CharID,11711,1)
INSERT INTO _CharSkill VALUES (@CharID,11719,1)
INSERT INTO _CharSkill VALUES (@CharID,11728,1)
INSERT INTO _CharSkill VALUES (@CharID,11744,1)
INSERT INTO _CharSkill VALUES (@CharID,11751,1)
INSERT INTO _CharSkill VALUES (@CharID,11768,1)
INSERT INTO _CharSkill VALUES (@CharID,11776,1)
INSERT INTO _CharSkill VALUES (@CharID,11783,1)
INSERT INTO _CharSkill VALUES (@CharID,11791,1)
INSERT INTO _CharSkill VALUES (@CharID,11797,1)
INSERT INTO _CharSkill VALUES (@CharID,11805,1)
INSERT INTO _CharSkill VALUES (@CharID,11811,1)
INSERT INTO _CharSkill VALUES (@CharID,11816,1)
INSERT INTO _CharSkill VALUES (@CharID,11823,1)
INSERT INTO _CharSkill VALUES (@CharID,11851,1)
INSERT INTO _CharSkill VALUES (@CharID,11868,1)
INSERT INTO _CharSkill VALUES (@CharID,11884,1)
INSERT INTO _CharSkill VALUES (@CharID,11893,1)
INSERT INTO _CharSkill VALUES (@CharID,11904,1)
INSERT INTO _CharSkill VALUES (@CharID,11914,1)
INSERT INTO _CharSkill VALUES (@CharID,11919,1)
INSERT INTO _CharSkill VALUES (@CharID,11930,1)
INSERT INTO _CharSkill VALUES (@CharID,11935,1)
INSERT INTO _CharSkill VALUES (@CharID,11943,1)
INSERT INTO _CharSkill VALUES (@CharID,11953,1)
INSERT INTO _CharSkill VALUES (@CharID,11961,1)
INSERT INTO _CharSkill VALUES (@CharID,11970,1)
INSERT INTO _CharSkill VALUES (@CharID,11978,1)
INSERT INTO _CharSkill VALUES (@CharID,11985,1)
INSERT INTO _CharSkill VALUES (@CharID,11993,1)
INSERT INTO _CharSkill VALUES (@CharID,11999,1)
INSERT INTO _CharSkill VALUES (@CharID,21227,1)
INSERT INTO _CharSkill VALUES (@CharID,30169,1)
INSERT INTO _CharSkill VALUES (@CharID,30170,1)
INSERT INTO _CharSkill VALUES (@CharID,30189,1)
INSERT INTO _CharSkill VALUES (@CharID,30194,1)
INSERT INTO _CharSkill VALUES (@CharID,30197,1)
INSERT INTO _CharSkill VALUES (@CharID,30215,1)
INSERT INTO _CharSkill VALUES (@CharID,30226,1)
INSERT INTO _CharSkill VALUES (@CharID,30245,1)
INSERT INTO _CharSkill VALUES (@CharID,30251,1)
INSERT INTO _CharSkill VALUES (@CharID,33826,1)
INSERT INTO _CharSkill VALUES (@CharID,33909,1)
INSERT INTO _CharSkill VALUES (@CharID,33910,1)
INSERT INTO _CharSkill VALUES (@CharID,33911,1)
INSERT INTO _CharSkill VALUES (@CharID,33912,1)
01-12-2018, 11:04 PM
المواضيع المتشابهه
.gif){kind=icon}
العرض الشجري