ahmedzizoa |
01-12-2018 11:04 PM |
حصريا كويرى لفتح كل سكيلات الاوربى للجى ام
open all skill to Eourp GM order
new query
بسم الله الرحمن الرحيم
اولا الكويرى ده مش منقول انا اللى عامله
ندخل على طول
كود:
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)
|