طــلــبــيــن لا غــــــــــــيـــــــــــر

[GM]MaRveL]]

محتاج بس حجتين خفاف

1

1-ازاى اخلى حد GM او افتحلوا الــ Console

2-ازاى افتح كل الاسكيلات اللى عيزها ليا او لاى حد

همل دول الطلبات ارجوا الرد السريع و شكرا :)

[komnda]

بسم الله الرحمن الرحيم

1 - انتا هماشى ولا استتك ولا ايه ؟

2- اتفضل يا ريس declare @char varchar(50)
declare @level int
set @char = 'CharName' -- You Char
set @level = '130' -- You Mastery Skill
update _CharSkillMastery set Level = @level
where CharID = (select CharID from _Char where CharName16 = @char)

[Ch3tos]

دهـ الكوريري دهـ عبارهـ عن ايهـ
بيفتح كل البلدات بتاعت الاكونت لـ 130 ؟

[komnda]

المشاركة الأصلية كتبت بواسطة ch3tos

دهـ الكوريري دهـ عبارهـ عن ايهـ
بيفتح كل البلدات بتاعت الاكونت لـ 130 ؟

ايوه ممكن تبدل ال130 ل 120 او زى ما نتا عاوز وفوق اسم الكراكتر

[BomBom]

1-من هنا



2-

USE([SRO_VT_SHARD])
GO()

Declare @CharName Varchar (64)
Set @CharName    =    'BomBom'

Update([dbo].[_CharSkillMastery])
Level = 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

[Mahmoud Rashwan]

اشتغل بى دة http://files.fm/u/xzdesrx و هات الايدى بتاعو و اعمل عاندو كدة

[GM]MaRveL]]

تسلموااااااااااااا يا جماااااااااعة :) :)
بس المشكلة فى انــى لو خليت حد gm الاكومنت مش بيفتح
ولا لازم اعمل ريستارت للسيرفر ؟؟ مع العلم انى بضيف الاى بى بتاعوا

[komnda]

المشاركة الأصلية كتبت بواسطة xperiadodo

تسلموااااااااااااا يا جماااااااااعة :) :)
بس المشكلة فى انــى لو خليت حد gm الاكومنت مش بيفتح
ولا لازم اعمل ريستارت للسيرفر ؟؟ مع العلم انى بضيف الاى بى بتاعوا

اول حاجه حط الايبى بتاعو زى ما انتا حطيط كدا فى PRIVEiP

وبعد كده TB_USER

اعملو اكونت ورستر السيرفر بس كده تمام
لو جبلك رساله رخمه كده وانتا بتعمل الCHAR
هقولك اعمل اميل عادى وخليه يعمل CHAR وبعد كده حطلو 1 : 1 بدل 3 : 3 فى SEC_ AND SEC_

بس كده

[Ch3tos]

لا مش لازم تقفل السيرفر ولا حاجهـ
انت لو حطيت اي بي جديد
اقفل بس Getway
وشغلها من تاني
وعامل Start Serves ;)

[GM]MaRveL]]

ماشى يا رجااالة شكراااا :)
بس الكويرى بتاع الاسكيلات مش شغال معلش !!
جريتوا و مشتغلش !!
انا اسف بتقل عليكوا بس دة اة حلها !!

[Developer]

حكايه ال GM زى ما قلولك اعمل Sec_Primary 1 + Sec_Conatct 1
و بدل ما تضيف ال IP بتاع الناس خد ده بدل اللى عندك و متحطش غير ال IP بتاعك بس او IP لشبكه تانيه لو انتا هاماشى و مبروك
Open GM From any PC Gateaway server
بدلها بدل اللى عندك فى Server Files

[Ch3tos]

جرب دهـ

USE SRO_VT_SHARD
GO
DECLARE @CharName varchar(255)
DECLARE @CharID INT

SET @CharName='Ch3tos'

SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName

UPDATE _CharSkillMastery SET Level = '130' WHERE CharID=@CharID

INSERT INTO _CharSkill VALUES (@CharID,1,1) 
INSERT INTO _CharSkill VALUES (@CharID,2,1) 
INSERT INTO _CharSkill VALUES (@CharID,40,1) 
INSERT INTO _CharSkill VALUES (@CharID,70,1) 
INSERT INTO _CharSkill VALUES (@CharID,298,1) 
INSERT INTO _CharSkill VALUES (@CharID,306,1) 
INSERT INTO _CharSkill VALUES (@CharID,314,1) 
INSERT INTO _CharSkill VALUES (@CharID,322,1) 
INSERT INTO _CharSkill VALUES (@CharID,346,1) 
INSERT INTO _CharSkill VALUES (@CharID,378,1) 
INSERT INTO _CharSkill VALUES (@CharID,418,1) 
INSERT INTO _CharSkill VALUES (@CharID,463,1) 
INSERT INTO _CharSkill VALUES (@CharID,558,1) 
INSERT INTO _CharSkill VALUES (@CharID,569,1) 
INSERT INTO _CharSkill VALUES (@CharID,580,1) 
INSERT INTO _CharSkill VALUES (@CharID,588,1) 
INSERT INTO _CharSkill VALUES (@CharID,596,1) 
INSERT INTO _CharSkill VALUES (@CharID,604,1) 
INSERT INTO _CharSkill VALUES (@CharID,647,1) 
INSERT INTO _CharSkill VALUES (@CharID,655,1) 
INSERT INTO _CharSkill VALUES (@CharID,672,1) 
INSERT INTO _CharSkill VALUES (@CharID,689,1) 
INSERT INTO _CharSkill VALUES (@CharID,699,1) 
INSERT INTO _CharSkill VALUES (@CharID,708,1) 
INSERT INTO _CharSkill VALUES (@CharID,716,1) 
INSERT INTO _CharSkill VALUES (@CharID,724,1) 
INSERT INTO _CharSkill VALUES (@CharID,735,1) 
INSERT INTO _CharSkill VALUES (@CharID,746,1) 
INSERT INTO _CharSkill VALUES (@CharID,757,1) 
INSERT INTO _CharSkill VALUES (@CharID,765,1) 
INSERT INTO _CharSkill VALUES (@CharID,773,1) 
INSERT INTO _CharSkill VALUES (@CharID,781,1) 
INSERT INTO _CharSkill VALUES (@CharID,789,1) 
INSERT INTO _CharSkill VALUES (@CharID,797,1) 
INSERT INTO _CharSkill VALUES (@CharID,805,1) 
INSERT INTO _CharSkill VALUES (@CharID,813,1) 
INSERT INTO _CharSkill VALUES (@CharID,821,1) 
INSERT INTO _CharSkill VALUES (@CharID,829,1) 
INSERT INTO _CharSkill VALUES (@CharID,853,1) 
INSERT INTO _CharSkill VALUES (@CharID,885,1) 
INSERT INTO _CharSkill VALUES (@CharID,925,1) 
INSERT INTO _CharSkill VALUES (@CharID,933,1) 
INSERT INTO _CharSkill VALUES (@CharID,943,1) 
INSERT INTO _CharSkill VALUES (@CharID,952,1) 
INSERT INTO _CharSkill VALUES (@CharID,960,1) 
INSERT INTO _CharSkill VALUES (@CharID,968,1) 
INSERT INTO _CharSkill VALUES (@CharID,976,1) 
INSERT INTO _CharSkill VALUES (@CharID,984,1) 
INSERT INTO _CharSkill VALUES (@CharID,992,1) 
INSERT INTO _CharSkill VALUES (@CharID,1003,1) 
INSERT INTO _CharSkill VALUES (@CharID,1014,1) 
INSERT INTO _CharSkill VALUES (@CharID,1025,1) 
INSERT INTO _CharSkill VALUES (@CharID,1033,1) 
INSERT INTO _CharSkill VALUES (@CharID,1041,1) 
INSERT INTO _CharSkill VALUES (@CharID,1049,1) 
INSERT INTO _CharSkill VALUES (@CharID,1053,1) 
INSERT INTO _CharSkill VALUES (@CharID,1057,1) 
INSERT INTO _CharSkill VALUES (@CharID,1065,1) 
INSERT INTO _CharSkill VALUES (@CharID,1073,1) 
INSERT INTO _CharSkill VALUES (@CharID,1081,1) 
INSERT INTO _CharSkill VALUES (@CharID,1089,1) 
INSERT INTO _CharSkill VALUES (@CharID,1099,1) 
INSERT INTO _CharSkill VALUES (@CharID,1108,1) 
INSERT INTO _CharSkill VALUES (@CharID,1116,1) 
INSERT INTO _CharSkill VALUES (@CharID,1124,1) 
INSERT INTO _CharSkill VALUES (@CharID,1132,1) 
INSERT INTO _CharSkill VALUES (@CharID,1140,1) 
INSERT INTO _CharSkill VALUES (@CharID,1148,1) 
INSERT INTO _CharSkill VALUES (@CharID,1153,1) 
INSERT INTO _CharSkill VALUES (@CharID,1158,1) 
INSERT INTO _CharSkill VALUES (@CharID,1163,1) 
INSERT INTO _CharSkill VALUES (@CharID,1168,1) 
INSERT INTO _CharSkill VALUES (@CharID,1173,1) 
INSERT INTO _CharSkill VALUES (@CharID,1178,1) 
INSERT INTO _CharSkill VALUES (@CharID,1189,1) 
INSERT INTO _CharSkill VALUES (@CharID,1200,1) 
INSERT INTO _CharSkill VALUES (@CharID,1217,1) 
INSERT INTO _CharSkill VALUES (@CharID,1234,1) 
INSERT INTO _CharSkill VALUES (@CharID,1244,1) 
INSERT INTO _CharSkill VALUES (@CharID,1253,1) 
INSERT INTO _CharSkill VALUES (@CharID,1261,1) 
INSERT INTO _CharSkill VALUES (@CharID,1269,1) 
INSERT INTO _CharSkill VALUES (@CharID,1271,1) 
INSERT INTO _CharSkill VALUES (@CharID,1273,1) 
INSERT INTO _CharSkill VALUES (@CharID,1275,1) 
INSERT INTO _CharSkill VALUES (@CharID,1286,1) 
INSERT INTO _CharSkill VALUES (@CharID,1297,1) 
INSERT INTO _CharSkill VALUES (@CharID,1308,1) 
INSERT INTO _CharSkill VALUES (@CharID,1316,1) 
INSERT INTO _CharSkill VALUES (@CharID,1324,1) 
INSERT INTO _CharSkill VALUES (@CharID,1332,1) 
INSERT INTO _CharSkill VALUES (@CharID,1337,1) 
INSERT INTO _CharSkill VALUES (@CharID,1342,1) 
INSERT INTO _CharSkill VALUES (@CharID,1350,1) 
INSERT INTO _CharSkill VALUES (@CharID,1358,1) 
INSERT INTO _CharSkill VALUES (@CharID,1368,1) 
INSERT INTO _CharSkill VALUES (@CharID,1377,1) 
INSERT INTO _CharSkill VALUES (@CharID,1385,1) 
INSERT INTO _CharSkill VALUES (@CharID,1393,1) 
INSERT INTO _CharSkill VALUES (@CharID,1398,1) 
INSERT INTO _CharSkill VALUES (@CharID,1403,1) 
INSERT INTO _CharSkill VALUES (@CharID,1408,1) 
INSERT INTO _CharSkill VALUES (@CharID,1410,1) 
INSERT INTO _CharSkill VALUES (@CharID,1412,1) 
INSERT INTO _CharSkill VALUES (@CharID,1414,1) 
INSERT INTO _CharSkill VALUES (@CharID,1422,1) 
INSERT INTO _CharSkill VALUES (@CharID,1430,1) 
INSERT INTO _CharSkill VALUES (@CharID,1438,1) 
INSERT INTO _CharSkill VALUES (@CharID,1443,1) 
INSERT INTO _CharSkill VALUES (@CharID,1448,1) 
INSERT INTO _CharSkill VALUES (@CharID,1465,1) 
INSERT INTO _CharSkill VALUES (@CharID,1482,1) 
INSERT INTO _CharSkill VALUES (@CharID,1499,1) 
INSERT INTO _CharSkill VALUES (@CharID,1509,1) 
INSERT INTO _CharSkill VALUES (@CharID,1518,1) 
INSERT INTO _CharSkill VALUES (@CharID,1526,1) 
INSERT INTO _CharSkill VALUES (@CharID,1534,1) 
INSERT INTO _CharSkill VALUES (@CharID,1539,1) 
INSERT INTO _CharSkill VALUES (@CharID,1544,1) 
INSERT INTO _CharSkill VALUES (@CharID,1549,1) 
INSERT INTO _CharSkill VALUES (@CharID,1557,1) 
INSERT INTO _CharSkill VALUES (@CharID,1565,1) 
INSERT INTO _CharSkill VALUES (@CharID,1573,1) 
INSERT INTO _CharSkill VALUES (@CharID,1578,1) 
INSERT INTO _CharSkill VALUES (@CharID,1583,1) 
INSERT INTO _CharSkill VALUES (@CharID,1588,1) 
INSERT INTO _CharSkill VALUES (@CharID,1593,1) 
INSERT INTO _CharSkill VALUES (@CharID,1598,1) 
INSERT INTO _CharSkill VALUES (@CharID,1609,1) 
INSERT INTO _CharSkill VALUES (@CharID,1617,1) 
INSERT INTO _CharSkill VALUES (@CharID,1628,1) 
INSERT INTO _CharSkill VALUES (@CharID,3149,1) 
INSERT INTO _CharSkill VALUES (@CharID,3167,1) 
INSERT INTO _CharSkill VALUES (@CharID,3176,1) 
INSERT INTO _CharSkill VALUES (@CharID,3224,1) 
INSERT INTO _CharSkill VALUES (@CharID,3340,1) 
INSERT INTO _CharSkill VALUES (@CharID,3349,1) 
INSERT INTO _CharSkill VALUES (@CharID,3364,1) 
INSERT INTO _CharSkill VALUES (@CharID,3379,1) 
INSERT INTO _CharSkill VALUES (@CharID,3391,1) 
INSERT INTO _CharSkill VALUES (@CharID,3406,1) 
INSERT INTO _CharSkill VALUES (@CharID,3409,1) 
INSERT INTO _CharSkill VALUES (@CharID,3415,1) 
INSERT INTO _CharSkill VALUES (@CharID,3430,1) 
INSERT INTO _CharSkill VALUES (@CharID,3431,1) 
INSERT INTO _CharSkill VALUES (@CharID,3446,1) 
INSERT INTO _CharSkill VALUES (@CharID,3461,1) 
INSERT INTO _CharSkill VALUES (@CharID,3467,1) 
INSERT INTO _CharSkill VALUES (@CharID,3473,1) 
INSERT INTO _CharSkill VALUES (@CharID,7139,1) 
INSERT INTO _CharSkill VALUES (@CharID,7159,1) 
INSERT INTO _CharSkill VALUES (@CharID,7203,1) 
INSERT INTO _CharSkill VALUES (@CharID,7322,1) 
INSERT INTO _CharSkill VALUES (@CharID,7385,1) 
INSERT INTO _CharSkill VALUES (@CharID,7390,1) 
INSERT INTO _CharSkill VALUES (@CharID,7392,1) 
INSERT INTO _CharSkill VALUES (@CharID,7404,1) 
INSERT INTO _CharSkill VALUES (@CharID,7418,1) 
INSERT INTO _CharSkill VALUES (@CharID,7474,1) 
INSERT INTO _CharSkill VALUES (@CharID,7484,1) 
INSERT INTO _CharSkill VALUES (@CharID,7513,1) 
INSERT INTO _CharSkill VALUES (@CharID,7520,1) 
INSERT INTO _CharSkill VALUES (@CharID,7536,1) 
INSERT INTO _CharSkill VALUES (@CharID,7554,1) 
INSERT INTO _CharSkill VALUES (@CharID,7577,1) 
INSERT INTO _CharSkill VALUES (@CharID,7582,1) 
INSERT INTO _CharSkill VALUES (@CharID,7584,1) 
INSERT INTO _CharSkill VALUES (@CharID,7596,1) 
INSERT INTO _CharSkill VALUES (@CharID,7612,1) 
INSERT INTO _CharSkill VALUES (@CharID,7637,1) 
INSERT INTO _CharSkill VALUES (@CharID,7651,1) 
INSERT INTO _CharSkill VALUES (@CharID,7672,1) 
INSERT INTO _CharSkill VALUES (@CharID,7675,1) 
INSERT INTO _CharSkill VALUES (@CharID,7688,1) 
INSERT INTO _CharSkill VALUES (@CharID,7798,1) 
INSERT INTO _CharSkill VALUES (@CharID,7805,1) 
INSERT INTO _CharSkill VALUES (@CharID,7829,1) 
INSERT INTO _CharSkill VALUES (@CharID,7838,1) 
INSERT INTO _CharSkill VALUES (@CharID,7839,1) 
INSERT INTO _CharSkill VALUES (@CharID,7853,1) 
INSERT INTO _CharSkill VALUES (@CharID,7862,1) 
INSERT INTO _CharSkill VALUES (@CharID,7877,1) 
INSERT INTO _CharSkill VALUES (@CharID,7881,1) 
INSERT INTO _CharSkill VALUES (@CharID,7894,1) 
INSERT INTO _CharSkill VALUES (@CharID,7899,1) 
INSERT INTO _CharSkill VALUES (@CharID,7907,1) 
INSERT INTO _CharSkill VALUES (@CharID,7919,1) 
INSERT INTO _CharSkill VALUES (@CharID,7931,1) 
INSERT INTO _CharSkill VALUES (@CharID,7938,1) 
INSERT INTO _CharSkill VALUES (@CharID,7947,1) 
INSERT INTO _CharSkill VALUES (@CharID,7953,1) 
INSERT INTO _CharSkill VALUES (@CharID,7959,1) 
INSERT INTO _CharSkill VALUES (@CharID,7962,1) 
INSERT INTO _CharSkill VALUES (@CharID,7972,1) 
INSERT INTO _CharSkill VALUES (@CharID,7980,1) 
INSERT INTO _CharSkill VALUES (@CharID,7995,1) 
INSERT INTO _CharSkill VALUES (@CharID,7997,1) 
INSERT INTO _CharSkill VALUES (@CharID,8010,1) 
INSERT INTO _CharSkill VALUES (@CharID,8024,1) 
INSERT INTO _CharSkill VALUES (@CharID,8050,1) 
INSERT INTO _CharSkill VALUES (@CharID,8084,1) 
INSERT INTO _CharSkill VALUES (@CharID,8097,1) 
INSERT INTO _CharSkill VALUES (@CharID,8103,1) 
INSERT INTO _CharSkill VALUES (@CharID,8109,1) 
INSERT INTO _CharSkill VALUES (@CharID,8115,1) 
INSERT INTO _CharSkill VALUES (@CharID,8119,1) 
INSERT INTO _CharSkill VALUES (@CharID,8129,1) 
INSERT INTO _CharSkill VALUES (@CharID,8133,1) 
INSERT INTO _CharSkill VALUES (@CharID,8142,1) 
INSERT INTO _CharSkill VALUES (@CharID,8150,1) 
INSERT INTO _CharSkill VALUES (@CharID,8164,1) 
INSERT INTO _CharSkill VALUES (@CharID,8171,1) 
INSERT INTO _CharSkill VALUES (@CharID,8183,1) 
INSERT INTO _CharSkill VALUES (@CharID,8195,1) 
INSERT INTO _CharSkill VALUES (@CharID,8204,1) 
INSERT INTO _CharSkill VALUES (@CharID,8214,1) 
INSERT INTO _CharSkill VALUES (@CharID,8220,1) 
INSERT INTO _CharSkill VALUES (@CharID,8221,1) 
INSERT INTO _CharSkill VALUES (@CharID,8238,1) 
INSERT INTO _CharSkill VALUES (@CharID,8239,1) 
INSERT INTO _CharSkill VALUES (@CharID,8250,1) 
INSERT INTO _CharSkill VALUES (@CharID,8253,1) 
INSERT INTO _CharSkill VALUES (@CharID,8276,1) 
INSERT INTO _CharSkill VALUES (@CharID,8291,1) 
INSERT INTO _CharSkill VALUES (@CharID,8304,1) 
INSERT INTO _CharSkill VALUES (@CharID,8316,1) 
INSERT INTO _CharSkill VALUES (@CharID,8320,1) 
INSERT INTO _CharSkill VALUES (@CharID,8338,1) 
INSERT INTO _CharSkill VALUES (@CharID,8347,1) 
INSERT INTO _CharSkill VALUES (@CharID,8348,1) 
INSERT INTO _CharSkill VALUES (@CharID,8361,1) 
INSERT INTO _CharSkill VALUES (@CharID,8370,1) 
INSERT INTO _CharSkill VALUES (@CharID,8379,1) 
INSERT INTO _CharSkill VALUES (@CharID,8383,1) 
INSERT INTO _CharSkill VALUES (@CharID,8390,1) 
INSERT INTO _CharSkill VALUES (@CharID,8399,1) 
INSERT INTO _CharSkill VALUES (@CharID,8405,1) 
INSERT INTO _CharSkill VALUES (@CharID,8410,1) 
INSERT INTO _CharSkill VALUES (@CharID,8414,1) 
INSERT INTO _CharSkill VALUES (@CharID,8416,1) 
INSERT INTO _CharSkill VALUES (@CharID,20494,1) 
INSERT INTO _CharSkill VALUES (@CharID,20497,1) 
INSERT INTO _CharSkill VALUES (@CharID,20500,1) 
INSERT INTO _CharSkill VALUES (@CharID,21215,1) 
INSERT INTO _CharSkill VALUES (@CharID,21217,1) 
INSERT INTO _CharSkill VALUES (@CharID,30578,1) 
INSERT INTO _CharSkill VALUES (@CharID,30584,1) 
INSERT INTO _CharSkill VALUES (@CharID,30590,1) 
INSERT INTO _CharSkill VALUES (@CharID,30596,1) 
INSERT INTO _CharSkill VALUES (@CharID,30600,1)

بدال Ch3tos اكتب اسم الاكونت
;)

[GM]MaRveL]]

مش شغال بردوا
اعمل اة ؟؟!!

[Ch3tos]

ازاي مش شغال
انا جربتهـ قبل ما اديهولك وشغال عندي

[GM]MaRveL]]

ما انا عندى جربتوا و مش شغال !!