شـريـط الاهـداءات
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ]
10-06-2014, 10:39 PM
#1
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117131
• المشـــاركـات » 70
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
مشكله فى اللعبه
انا فاتح اللعبه وى شغاله تمام اوى بس مش بتفتح عند حد وى هما معايا على الهاش وى ضبطوا ال ipinput العبه مش بتجيب الانشر وى انا جربت اعمل اكونت نورمال وى انزل بيه بتفتح بس بعمل character يقولى faild to connect please try again دا من ايه بقا ؟؟؟
إعلانات google
10-06-2014, 10:45 PM
#2
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117131
• المشـــاركـات » 70
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
11-06-2014, 02:56 AM
#3
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117095
• المشـــاركـات » 319
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 18
شوف المدينة الى منزلة فيها مفتوحا ولا لا
وشوف فى حاجة دفتها فى AddNewChear غلط
جرب AddNewChear دا
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 06/10/2014 19:36:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ].[ _AddNewChar ] @ UserJID INT , --@ CharSlot INT , @ RefCharID INT , @ CharName varchar ( 64 ), @ CharScale tinyINT , @ StartRegionID INT , @ StartPos_X real , @ StartPos_Y real , @ StartPos_Z real , @ DefaultTeleport INT , @ RefMailID INT , @ RefPantsID INT , @ RefBootsID INT , @ RefWeaponID INT , @ RefShield INT , @ DurMail tinyINT , @ DurPants tinyINT , @ DurBoots tinyINT , @ DurWeapon tinyINT , @ DurShield tinyINT , @ DefaultArrow INT AS SET NOCOUNT ON DECLARE @ Slot INT DECLARE @ temp INT DECLARE @ NewCharID INT SET @ NewCharID = 0 ----------------------------------------------------------------------------- -- 1. ؤ³¸¯إح ½½·ش ³ر¹ِ°، validار °حہخءِ , ±×¸®°ي ؛َ½½·شہج ¸آ´آءِ ¸صہْ أ¼إ©ار´ظ . ----------------------------------------------------------------------------- -- start by novice . SELECT @ temp = count ( CharID ) FROM _User WITH ( NOLOCK ) WHERE UserJID = @ UserJID IF (@ temp >= 4 ) BEGIN -- ³ت¹« ¸¹ہع³ھ RETURN - 2 END -- finish by novice . ----------------------------------------------------------------------------- -- 2. ؤ³¸¯إح أك°،اد±â ----------------------------------------------------------------------------- IF (@ CharScale > 68 ) -- 0100 0100 --> 68 ہج´ظ ! BEGIN -- ؤ³¸¯إح »¼؛ ½ائذ ! ½؛ؤةہد °ھہج ہج»َاد´ظ ! RETURN - 3 END EXEC @ temp = _IsExistingCharName @ CharName IF (@ temp <> 0 ) BEGIN -- ہج¹ج »ç؟ëءكہخ ہج¸§ہج¶َ´آµ¥ ? RETURN - 4 END BEGIN TRANSACTION -- ہخ´ّ½أ½؛إغہج ہû؟ëµا¸é¼ * ¸¶ءِ¸·؟، WorldID؟ح 1°ھہ» ´ُ ³ض¾î ءض¾ْ´ظ ! INSERT INTO _Char ( RefObjID , CharName16 , Scale , Strength , Intellect , LatestRegion , PosX , PosY , PosZ , AppointedTeleport , InventorySize , LastLogout , CurLevel , MaxLevel , RemainGold , RemainStatPoint , RemainSkillPoint , HP , MP , JobLvl_Trader , JobLvl_Hunter , JobLvl_Robber , WorldID , HwanLevel ) VALUES (@ RefCharID , @ CharName , @ CharScale , 230 , 230 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 109 , GetDate (), 120 , 120 , 500000000 , 355 , 30000000 , 260 , 260 , 1 , 1 , 1 , 1 , 4 ) SET @ NewCharID = @@ IDENTITY IF (@@ ERROR <> 0 OR @@ ROWCOUNT = 0 ) BEGIN -- ؤ³¸¯إح »¼؛ ½ائذ ! ROLLBACK TRANSACTION RETURN - 5 END -- start by novice . -- ہجء¦ Slot ¾ب¾´´ظ .. ±×³ة Insert ¸¸ .. INSERT INTO _User VALUES (@ UserJID , @ NewCharID ) -- finish by novice . ----------------------------------------------------------------------------- -- 3 - 1. ہه؛ٌ ½½·ش أ¤؟ى±â -- [ ہخ؛¥إن¸® ½½·ش 96°³ ] + [ ہه؛ٌ½½·ش 13°³ ] <- ہخ؛¥إن¸® ب®ہه ¼ * ؛ٌ½؛ بؤ 48°³؟،¼ * 96°³·خ ءُ°، !!!( woos0 ) ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _Inventory ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 109 IF (@@ ERROR <> 0 ) BEGIN -- ہخ؛¥إن¸® »¼؛ ½ائذ ! ROLLBACK TRANSACTION RETURN - 7 END -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! -- µًئْئ®·خ ¼±إأار ¾ئہجإغہ» ´ظ½أ ³ض¾îءضہع ... /* ؟ن·± ¼ّ¼*·خ ء¤ہاµا¾î ہض´ظ. 0: EQUIP_SLOT_HELM 1: EQUIP_SLOT_MAIL, 2: EQUIP_SLOT_SHOULDERGUARD, 3: EQUIP_SLOT_GAUNTLET, 4: EQUIP_SLOT_PANTS, 5: EQUIP_SLOT_BOOTS, 6: EQUIP_SLOT_WEAPON, 7: EQUIP_SLOT_SHIELD or ARROW, 8: EQUIP_SLOT_EARRING, 9: EQUIP_SLOT_NECKLACE, 10: EQUIP_SLOT_L_RING, 11: EQUIP_SLOT_R_RING, */ DECLARE @ ItemID BIGINT SET @ ItemID = 0 -- »َ°© IF (@ RefMailID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 1 , @ RefMailID , @ DurMail IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 8 END END -- ¹ظءِ IF (@ RefPantsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 4 , @ RefPantsID , @ DurPants IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 9 END END -- Boots IF (@ RefBootsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 5 , @ RefBootsID , @ DurBoots IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 10 END END -- Weapon IF (@ RefWeaponID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 6 , @ RefWeaponID , @ DurWeapon IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 11 END END -- ¹وئذ IF (@ RefShield <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ RefShield , @ DurShield IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 12 END END -- ب¤½أ default·خ ¼±إأار ¹«±â°، ب°ہج¶َ¸é ب * »ى 250°³µéہج ب°إëµµ اش²² ءط´ظ . ءزؤ، ? IF (@ DefaultArrow <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ DefaultArrow , 250 IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 13 END END ----------------------------------------------------------------------------- -- 3 - 2. ¾ئ¹ظإ¸ Inventory ½½·ش أ¤؟ى±â -- [ ¾ئ¹ظإ¸ ہخ؛¥إن¸® ½½·ش 5°³ ] -- APPLY_AVATAR_SYSTEMہج ہû؟ëµا¸é¼ * أك°،µا´آ ؛خ؛ذ ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _InventoryForAvatar ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 5 IF (@@ ERROR <> 0 ) BEGIN -- ¾ئ¹ظإ¸ ہخ؛¥إن¸® »¼؛ ½ائذ ! ROLLBACK TRANSACTION RETURN - 14 END -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! ----------------------------------------------------------------------------- -- default skill³ض¾îءض±â ----------------------------------------------------------------------------- DECLARE @ country tinyINT EXEC @ country = _GetObjCountry @ RefCharID INSERT INTO _CharSkillMastery ( CharID , MasteryID , Level ) SELECT @ NewCharID , MasteryID , 0 FROM _RefCharDefault_SkillMastery with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 15 END INSERT INTO _CharSkill ( CharID , SkillID , Enable ) SELECT @ NewCharID , SkillID , 1 FROM _RefCharDefault_Skill with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 16 END ----------------------------------------------------------------------------- -- ±â؛» ؤù½؛ئ® ³ض¾îءض±â ----------------------------------------------------------------------------- INSERT INTO _CharQuest ( CharID , QuestID , Status , AchievementCount , StartTime , EndTime , QuestData1 , QuestData2 ) SELECT @ NewCharID , ID , 1 , 0 , getdate (), getdate (), 0 , 0 FROM _RefQuest WHERE CodeName in ( SELECT CodeName FROM _RefCharDefault_Quest with ( nolock ) WHERE ( Race = @ country or Race = 3 ) and RequiredLevel = 1 and Service = 1 ) IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 17 END ----------------------------------------------------------------------------- -- Static Avatar Initial Record ³ض±â ----------------------------------------------------------------------------- INSERT INTO _StaticAvatar ( CharID ) values (@ NewCharID ) IF (@@ ERROR <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 18 END ----------------------------------------------------------------------------- -- Trijob أ¤؟ِ³ض±â !!!!! ----------------------------------------------------------------------------- INSERT INTO _CharTrijob VALUES (@ NewCharID , 0 , 1 , 0 , 0 , 0 ) IF (@@ ERROR <> 0 ) BEGIN -- ہخ؛¥إن¸® »¼؛ ½ائذ ! ROLLBACK TRANSACTION RETURN - 19 END ----------------------------------------------------------------------------- -- CharList؟، ID ³ض¾îءض±â ----------------------------------------------------------------------------- INSERT _CharNameList VALUES (@ CharName , @ NewCharID ) -- EUROPE MAAAAAn IF (@ RefBootsID = 11622 or @ RefBootsID = 11625 or @ RefBootsID = 11619 ) BEGIN exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_AXE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SHIELD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_CROSSBOW_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DAGGER_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_STAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSTAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DARKSTAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_HARP_13_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_EARRING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_NECKLACE_14_A_RARE ' , 1 , 15 END -- EUROPE WOMENNN IF (@ RefBootsID = 11631 or @ RefBootsID = 11634 or @ RefBootsID = 11628 ) BEGIN exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_AXE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SHIELD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_CROSSBOW_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DAGGER_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_STAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSTAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DARKSTAFF_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_HARP_13_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_EARRING_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_NECKLACE_14_A_RARE ' , 1 , 15 END -- CHina MAAAAN IF (@ RefBootsID = 3639 or @ RefBootsID = 3642 or @ RefBootsID = 3645 ) BEGIN exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_TBLADE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BLADE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BOW_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SHIELD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SPEAR_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_EARRING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_NECKLACE_14_A_RARE' , 1 , 12 END -- CHINA WOMENNN IF (@ RefBootsID = 3648 or @ RefBootsID = 3651 or @ RefBootsID = 3654 ) BEGIN exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_TBLADE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BLADE_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BOW_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SWORD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SHIELD_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SPEAR_14_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_HA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_BA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_FA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_SA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_AA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_LA_A_RARE ' , 1 , 15 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_EARRING_14_A_RARE' , 1 , 12 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_NECKLACE_14_A_RARE' , 1 , 12 END INSERT INTO SRO_VT_ACCOUNT . dbo . SK_Silk ( JID , silk_own , silk_gift , silk_point ) VALUES (@ UserJID , 10000000 , 0 , 0 ); -- Quick Slot ء¤؛¸ ہْہه؟ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
توقيع GM] COMNDs]
:
[SPOILER="x"]عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ] [/SPOILER]
11-06-2014, 02:56 AM
#4
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117095
• المشـــاركـات » 319
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 18
شوف المدينة الى منزلة فيها مفتوحا ولا لا
وشوف فى حاجة دفتها فى AddNewChear غلط
جرب AddNewChear دا
كود PHP:
USE [ SRO_VT_SHARD ]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 06/10/2014 19:36:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [ dbo ].[ _AddNewChar ]
@ UserJID INT ,
--@ CharSlot INT ,
@ RefCharID INT ,
@ CharName varchar ( 64 ),
@ CharScale tinyINT ,
@ StartRegionID INT ,
@ StartPos_X real ,
@ StartPos_Y real ,
@ StartPos_Z real ,
@ DefaultTeleport INT ,
@ RefMailID INT ,
@ RefPantsID INT ,
@ RefBootsID INT ,
@ RefWeaponID INT ,
@ RefShield INT ,
@ DurMail tinyINT ,
@ DurPants tinyINT ,
@ DurBoots tinyINT ,
@ DurWeapon tinyINT ,
@ DurShield tinyINT ,
@ DefaultArrow INT
AS
SET NOCOUNT ON
DECLARE @ Slot INT
DECLARE @ temp INT
DECLARE @ NewCharID INT
SET @ NewCharID = 0
-----------------------------------------------------------------------------
-- 1. ؤ³¸¯إح ½½·ش ³ر¹ِ°، validار °حہخءِ , ±×¸®°ي ؛َ½½·شہج ¸آ´آءِ ¸صہْ أ¼إ©ار´ظ .
-----------------------------------------------------------------------------
-- start by novice .
SELECT @ temp = count ( CharID ) FROM _User WITH ( NOLOCK ) WHERE UserJID = @ UserJID
IF (@ temp >= 4 )
BEGIN
-- ³ت¹« ¸¹ہع³ھ
RETURN - 2
END
-- finish by novice .
-----------------------------------------------------------------------------
-- 2. ؤ³¸¯إح أك°،اد±â
-----------------------------------------------------------------------------
IF (@ CharScale > 68 ) -- 0100 0100 --> 68 ہج´ظ !
BEGIN
-- ؤ³¸¯إح »¼؛ ½ائذ ! ½؛ؤةہد °ھہج ہج»َاد´ظ !
RETURN - 3
END
EXEC @ temp = _IsExistingCharName @ CharName
IF (@ temp <> 0 )
BEGIN
-- ہج¹ج »ç؟ëءكہخ ہج¸§ہج¶َ´آµ¥ ?
RETURN - 4
END
BEGIN TRANSACTION
-- ہخ´ّ½أ½؛إغہج ہû؟ëµا¸é¼ * ¸¶ءِ¸·؟، WorldID؟ح 1°ھہ» ´ُ ³ض¾î ءض¾ْ´ظ !
INSERT INTO _Char ( RefObjID , CharName16 , Scale , Strength , Intellect , LatestRegion , PosX , PosY , PosZ , AppointedTeleport , InventorySize ,
LastLogout , CurLevel , MaxLevel , RemainGold , RemainStatPoint , RemainSkillPoint , HP , MP , JobLvl_Trader , JobLvl_Hunter , JobLvl_Robber , WorldID , HwanLevel )
VALUES (@ RefCharID , @ CharName , @ CharScale , 230 , 230 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 109 ,
GetDate (), 120 , 120 , 500000000 , 355 , 30000000 , 260 , 260 , 1 , 1 , 1 , 1 , 4 )
SET @ NewCharID = @@ IDENTITY
IF (@@ ERROR <> 0 OR @@ ROWCOUNT = 0 )
BEGIN
-- ؤ³¸¯إح »¼؛ ½ائذ !
ROLLBACK TRANSACTION
RETURN - 5
END
-- start by novice .
-- ہجء¦ Slot ¾ب¾´´ظ .. ±×³ة Insert ¸¸ ..
INSERT INTO _User VALUES (@ UserJID , @ NewCharID )
-- finish by novice .
-----------------------------------------------------------------------------
-- 3 - 1. ہه؛ٌ ½½·ش أ¤؟ى±â
-- [ ہخ؛¥إن¸® ½½·ش 96°³ ] + [ ہه؛ٌ½½·ش 13°³ ] <- ہخ؛¥إن¸® ب®ہه ¼ * ؛ٌ½؛ بؤ 48°³؟،¼ * 96°³·خ ءُ°، !!!( woos0 )
-----------------------------------------------------------------------------
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
INSERT INTO _Inventory ( CharID , Slot , ItemID )
SELECT @ NewCharID , cnt , 0
FROM _RefDummySlot with ( nolock )
WHERE cnt < 109
IF (@@ ERROR <> 0 )
BEGIN
-- ہخ؛¥إن¸® »¼؛ ½ائذ !
ROLLBACK TRANSACTION
RETURN - 7
END
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
-- µًئْئ®·خ ¼±إأار ¾ئہجإغہ» ´ظ½أ ³ض¾îءضہع ...
/* ؟ن·± ¼ّ¼*·خ ء¤ہاµا¾î ہض´ظ.
0: EQUIP_SLOT_HELM
1: EQUIP_SLOT_MAIL,
2: EQUIP_SLOT_SHOULDERGUARD,
3: EQUIP_SLOT_GAUNTLET,
4: EQUIP_SLOT_PANTS,
5: EQUIP_SLOT_BOOTS,
6: EQUIP_SLOT_WEAPON,
7: EQUIP_SLOT_SHIELD or ARROW,
8: EQUIP_SLOT_EARRING,
9: EQUIP_SLOT_NECKLACE,
10: EQUIP_SLOT_L_RING,
11: EQUIP_SLOT_R_RING,
*/
DECLARE @ ItemID BIGINT
SET @ ItemID = 0
-- »َ°©
IF (@ RefMailID <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 1 , @ RefMailID , @ DurMail
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 8
END
END
-- ¹ظءِ
IF (@ RefPantsID <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 4 , @ RefPantsID , @ DurPants
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 9
END
END
-- Boots
IF (@ RefBootsID <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 5 , @ RefBootsID , @ DurBoots
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 10
END
END
-- Weapon
IF (@ RefWeaponID <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 6 , @ RefWeaponID , @ DurWeapon
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 11
END
END
-- ¹وئذ
IF (@ RefShield <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ RefShield , @ DurShield
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 12
END
END
-- ب¤½أ default·خ ¼±إأار ¹«±â°، ب°ہج¶َ¸é ب * »ى 250°³µéہج ب°إëµµ اش²² ءط´ظ . ءزؤ، ?
IF (@ DefaultArrow <> 0 )
BEGIN
EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ DefaultArrow , 250
IF (@ ItemID <= 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 13
END
END
-----------------------------------------------------------------------------
-- 3 - 2. ¾ئ¹ظإ¸ Inventory ½½·ش أ¤؟ى±â
-- [ ¾ئ¹ظإ¸ ہخ؛¥إن¸® ½½·ش 5°³ ]
-- APPLY_AVATAR_SYSTEMہج ہû؟ëµا¸é¼ * أك°،µا´آ ؛خ؛ذ
-----------------------------------------------------------------------------
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
INSERT INTO _InventoryForAvatar ( CharID , Slot , ItemID )
SELECT @ NewCharID , cnt , 0
FROM _RefDummySlot with ( nolock )
WHERE cnt < 5
IF (@@ ERROR <> 0 )
BEGIN
-- ¾ئ¹ظإ¸ ہخ؛¥إن¸® »¼؛ ½ائذ !
ROLLBACK TRANSACTION
RETURN - 14
END
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
-----------------------------------------------------------------------------
-- default skill³ض¾îءض±â
-----------------------------------------------------------------------------
DECLARE @ country tinyINT
EXEC @ country = _GetObjCountry @ RefCharID
INSERT INTO _CharSkillMastery ( CharID , MasteryID , Level )
SELECT @ NewCharID , MasteryID , 0
FROM _RefCharDefault_SkillMastery with ( nolock )
WHERE Race = @ country or Race = 3
IF (@@ error <> 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 15
END
INSERT INTO _CharSkill ( CharID , SkillID , Enable )
SELECT @ NewCharID , SkillID , 1
FROM _RefCharDefault_Skill with ( nolock )
WHERE Race = @ country or Race = 3
IF (@@ error <> 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 16
END
-----------------------------------------------------------------------------
-- ±â؛» ؤù½؛ئ® ³ض¾îءض±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest ( CharID , QuestID , Status , AchievementCount , StartTime , EndTime , QuestData1 , QuestData2 )
SELECT @ NewCharID , ID , 1 , 0 , getdate (), getdate (), 0 , 0
FROM _RefQuest
WHERE CodeName in ( SELECT CodeName FROM _RefCharDefault_Quest with ( nolock ) WHERE ( Race = @ country or Race = 3 ) and RequiredLevel = 1 and Service = 1 )
IF (@@ error <> 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³ض±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar ( CharID ) values (@ NewCharID )
IF (@@ ERROR <> 0 )
BEGIN
ROLLBACK TRANSACTION
RETURN - 18
END
-----------------------------------------------------------------------------
-- Trijob أ¤؟ِ³ض±â !!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@ NewCharID , 0 , 1 , 0 , 0 , 0 )
IF (@@ ERROR <> 0 )
BEGIN
-- ہخ؛¥إن¸® »¼؛ ½ائذ !
ROLLBACK TRANSACTION
RETURN - 19
END
-----------------------------------------------------------------------------
-- CharList؟، ID ³ض¾îءض±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES (@ CharName , @ NewCharID )
-- EUROPE MAAAAAn
IF (@ RefBootsID = 11622 or @ RefBootsID = 11625 or @ RefBootsID = 11619 )
BEGIN
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_AXE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SHIELD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_CROSSBOW_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DAGGER_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_STAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSTAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DARKSTAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_HARP_13_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_HEAVY_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_LIGHT_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_M_CLOTHES_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_EARRING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_NECKLACE_14_A_RARE ' , 1 , 15
END
-- EUROPE WOMENNN
IF (@ RefBootsID = 11631 or @ RefBootsID = 11634 or @ RefBootsID = 11628 )
BEGIN
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_AXE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SHIELD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_CROSSBOW_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DAGGER_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_STAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSTAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_DARKSTAFF_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_HARP_13_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_SWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_TSWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_CLOTHES_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_LIGHT_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_W_HEAVY_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_RING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_EARRING_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EU_NECKLACE_14_A_RARE ' , 1 , 15
END
-- CHina MAAAAN
IF (@ RefBootsID = 3639 or @ RefBootsID = 3642 or @ RefBootsID = 3645 )
BEGIN
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_TBLADE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BLADE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BOW_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SHIELD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SPEAR_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_HEAVY_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_LIGHT_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_M_CLOTHES_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_EARRING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_NECKLACE_14_A_RARE' , 1 , 12
END
-- CHINA WOMENNN
IF (@ RefBootsID = 3648 or @ RefBootsID = 3651 or @ RefBootsID = 3654 )
BEGIN
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_TBLADE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BLADE_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_BOW_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SWORD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SHIELD_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_SPEAR_14_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_CLOTHES_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_LIGHT_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_HA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_BA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_FA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_SA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_AA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_W_HEAVY_14_LA_A_RARE ' , 1 , 15
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_RING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_EARRING_14_A_RARE' , 1 , 12
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_CH_NECKLACE_14_A_RARE' , 1 , 12
END
INSERT INTO SRO_VT_ACCOUNT . dbo . SK_Silk ( JID , silk_own , silk_gift , silk_point ) VALUES (@ UserJID , 10000000 , 0 , 0 );
-- Quick Slot ء¤؛¸ ہْہه؟ë !!!
exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ...
COMMIT TRANSACTION
RETURN @ NewCharID
توقيع GM] COMNDs]
:
[SPOILER="x"]عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ] [/SPOILER]
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك
كود HTML معطلة
الساعة الآن 07:25 AM .