شـريـط الاهـداءات
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة
25-10-2012, 03:39 PM
#1
• الانـتـسـاب » Feb 2012
• رقـم العـضـويـة » 98641
• المشـــاركـات » 286
• الـدولـة » Alexandria
• الـهـوايـة »
• اسـم الـسـيـرفـر » Centaurus
• الـجـنـس » Male
• نقـاط التقييم » 17
بج جديد
أرجو حل البج ده اي حد عندي عامل شخصية جديدة وعمل كويست الصفحة التانية لما بيحط في الصفحة التانية حاجة بياخد دي سي أرجو الحل
إعلانات google
25-10-2012, 04:15 PM
#2
• الانـتـسـاب » Jul 2012
• رقـم العـضـويـة » 101989
• المشـــاركـات » 546
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر »
• الـجـنـس »
• نقـاط التقييم » 10
لما واحد بياخدت منهم دى سى قبقى هاتلى صورة من
SR_ShardManger
07-06-2014, 01:14 PM
#3
• الانـتـسـاب » Mar 2011
• رقـم العـضـويـة » 85115
• المشـــاركـات » 4
• الـدولـة » كولالامبور
• الـهـوايـة »
• اسـم الـسـيـرفـر »
• الـجـنـس »
• نقـاط التقييم » 10
غريبة دى
07-06-2014, 11:51 PM
#4
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117095
• المشـــاركـات » 319
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 18
طب انتا الصفحة التانية شغالة عندك تمام لو دى سى بردو جرب
Add New Cher دا
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 06/07/2014 22:51:07 ******/ 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]
07-06-2014, 11:51 PM
#5
• الانـتـسـاب » Mar 2014
• رقـم العـضـويـة » 117095
• المشـــاركـات » 319
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 18
طب انتا الصفحة التانية شغالة عندك تمام لو دى سى بردو جرب
Add New Cher دا
كود PHP:
USE [ SRO_VT_SHARD ]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 06/07/2014 22:51:07 ******/
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 معطلة
الساعة الآن 05:10 AM .