عرض مشاركة واحدة
قديم 13-10-2013, 01:17 AM   #12

merazz012
عضو لامع



الصورة الرمزية merazz012


• الانـتـسـاب » Jun 2008
• رقـم العـضـويـة » 23523
• المشـــاركـات » 1,200
• الـدولـة »
• الـهـوايـة » Dev>DataBase>PK2
• اسـم الـسـيـرفـر » Pavo
• الـجـنـس » Male
• نقـاط التقييم » 15
merazz012 صـاعـد

merazz012 غير متواجد حالياً



افتراضي



INSERT _CharNameList VALUES(@CharName, @NewCharID)

if (@RefCharID >= 1907 and @RefCharID <= 1919)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_FA_A_RARE',1,5

END
else if (@RefCharID >= 1920 and @RefCharID <= 1932)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_FA_A_RARE',1,5
END
else if (@RefCharID >= 14875 and @RefCharID <= 14887)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_A_RARE',1,5
END
else if (@RefCharID >= 14888 and @RefCharID <= 14900)
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_A_RARE',1,5

END
else
BEGIN
return -999
END
-- Quick Slot ?¤?¸ A?A??ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...

COMMIT TRANSACTION

RETURN @NewCharID

دي الكود بس انا بغير (A) وبخليها C علشان ينزل صن مش نوفا و ال5 بخليها 1 علشان ينزل +1 بس مش اكتر
و لو في حاجه غلط في مكنش رضي يتحط من الاول
ana database castaway


توقيع merazz012 :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]