شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
18-04-2013, 03:55 AM | #1 | ||||||||||||
|
انا عايز اعرف اشغل الكويرى ده ازاى لو سمحتوا والوكيرى ده لفتح السكيلات كلها هل فى كدة ولا ايه بالظبط USE*[SRO_VT_SHARD] DECLARE*@CharName*varchar(255) DECLARE*@CharID*INT SET*@CharName='CharName*here' SELECT*@CharID*=*CharID*FROM*_Char*WHERE*CharName1 6=@CharName UPDATE*_CharSkillMastery*SET*Level*=*'Max*Skill*Le vel*Here'*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) Like*This** Quote MultiQuote Report *#2* Bouken* |
||||||||||||
|
18-04-2013, 04:22 AM | #2 | ||||||||||||
|
هتفتح SQL وتدوس على NEW QUERY وتاخد الكيورى كوبى باست وهتختار فوق SRO_VT_SHARD وبعدين هتدوس Execute تقريبأ هوه ده بيفتح كل السكيلات |
||||||||||||
|
18-04-2013, 04:58 AM | #3 | ||||||||||||
|
زي ما قالك موري تحطه تعمل Excute وجنبيه علامه صح بس
|
||||||||||||
|
18-04-2013, 10:06 AM | #4 | ||||||||||||
|
SRO_VT_SHARD New Query بعد كدة تحط ال Query خلي المكس لفل 120 بعد كدة اكتب اسم الكركتر هنا SET*@CharName='CharName*here' امسح كلمت here اكتب اسم الكركتر مكان CharName |
||||||||||||
|
18-04-2013, 10:07 AM | #5 | ||||||||||||
|
كود PHP:
|
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|