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

اذهب الى الأسفل
ahmedzizoa
ahmedzizoa
لاعب متوسط
لاعب متوسط
المساهمات : 92
تاريخ التسجيل : 01/12/2019

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

الثلاثاء يناير 14, 2020 8:03 pm
باين

الكود:
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)
الرجوع الى أعلى الصفحة
صلاحيات هذا المنتدى:
لاتستطيع الرد على المواضيع في هذا المنتدى