عايز حل للمشكله دي

[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