صيانة احلى منتدى
هل تريد التفاعل مع هذه المساهمة؟ كل ما عليك هو إنشاء حساب جديد ببضع خطوات أو تسجيل الدخول للمتابعة.
صيانة احلى منتدى

صيانة احلى منتدى


حصريا كويرى لفتح كل سكيلات الاوربى للجى ام

صيانة احلى منتدى :: الالعاب :: الالعاب الاون لاين

اذهب الى الأسفل

حصريا كويرى لفتح كل سكيلات الاوربى للجى ام Empty حصريا كويرى لفتح كل سكيلات الاوربى للجى ام

مُساهمة من طرف ابو محمد السبت ديسمبر 01, 2018 10:21 pm

New query to open all skill to Eourp
حصرى هذا الكويرى يفتح كل السكلات الخاصة بالاوربى


الكود:
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)



ابو محمد

المساهمات : 10
تاريخ التسجيل : 28/10/2018

الرجوع الى أعلى الصفحة اذهب الى الأسفل

الرجوع الى أعلى الصفحة

صيانة احلى منتدى :: الالعاب :: الالعاب الاون لاين

 
صلاحيات هذا المنتدى:
لاتستطيع الرد على المواضيع في هذا المنتدى