شـريـط الاهـداءات
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة
إعلانات google
06-07-2014, 12:06 AM
#7
• الانـتـسـاب » Oct 2008
• رقـم العـضـويـة » 36761
• المشـــاركـات » 534
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 23
الداتابيز
_REFSKILLGROUP
كود:
300000 SKILL_MALL_GODBLESS
_REFOBJCOMMON
كود:
1 60047 ITEM_MALL_GODBLESS ???? ???? ??? (???) xxx SN_ITEM_MALL_GODBLESS SN_ITEM_MALL_GODBLESS_TT_DESC 1 0 3 3 13 14 180000 3 0 0 0 0 255 1 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\mall_change_name.ddj xxx xxx 2236094
_refobjitem
كود:
2236020 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_GODBLESS] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
_refskill
كود:
1 50134 300000 SKILL_MALL_GODBLESS ???? ???? SKILL_MALL_GODBLESS 0 1 1 0 0 0 0 0 1000 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_GODBLESS xxx SN_SKILL_MALL_GODBLESS_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 -1875767296 26738 110 0 1752396851 200 0 1752656242 120 0 7172201 3500 0 6844521 3500 0 1937011305 15 0 1768846441 15 0 25970 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
06-07-2014, 12:09 AM
#8
• الانـتـسـاب » Jan 2014
• رقـم العـضـويـة » 116050
• المشـــاركـات » 6,995
• الـدولـة » Egypt
• الـهـوايـة » ;"#string n = "C
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 191
طيب امسح اللى عندك و ضيف الاكواد دى
كود PHP:
MEDIA skill effect PHP Code : 1 ???? 6 % ???? SKILL_MALL_GODBLESS 0 FALSE 0 DEFAULT none none none none none none none none 0 0 , 0 , 0 , 0 ONE none none none none none none none 0 1 - SKILL_MALL_GODBLESS ACT_S 0 FALSE none CHAR_BASE 0 0 0 0 1 0 , 0 AT_ONE_FOLLOW MOV_NONE , 0 , 0 , 0 0 , 0 , 0 false , 0 , 0 , 0 , 0 , false system \ system_levelup . efp none 0 , 0 , 0 none 0 , 0 , 0 none 0 none none none - SKILL_MALL_GODBLESS ACT_L 0 FALSE none CHAR_BASE 0 0 0 0 1 0 , 0 AT_LOOP MOV_NONE , 0 , 0 , 0 0 , 0 , 0 false , 0 , 0 , 0 , 0 , false system \ hwanlook_m_whiteaustralia1 . efp Bip01 L Finger2 0 , 0 , 0 none 0 , 0 , 0 none 0 none none none - SKILL_MALL_GODBLESS ACT_L 0 FALSE none CHAR_BASE 0 0 0 0 1 0 , 0 AT_LOOP MOV_NONE , 0 , 0 , 0 0 , 0 , 0 false , 0 , 0 , 0 , 0 , false system \ hwanlook_m_whiteaustralia1 . efp Bip01 R Finger2 0 , 0 , 0 none 0 , 0 , 0 none 0 none none none - SKILL_MALL_GODBLESS ACT_L 0 FALSE none CHAR_BASE 0 0 0 0 1 0 , 0 AT_LOOP MOV_NONE , 0 , 0 , 0 0 , 0 , 0 false , 0 , 0 , 0 , 0 , false system \ hwanlook_c_panda1 . efp Bip01 0 , 0 , 0 none 0 , 0 , 0 none 0 none none none - SKILL_MALL_GODBLESS ACT_L 0 FALSE none CHAR_BASE 0 0 0 0 1 0 , 0 AT_LOOP MOV_NONE , 0 , 0 , 0 0 , 0 , 0 false , 0 , 0 , 0 , 0 , false system \ hwanlook_c_penguin1 . efp Bip01 Spine1 0 , 0 , 0 none 0 , 0 , 0 none 0 none none none textdata_object PHP Code : 1 SN_ITEM_MALL_GODBLESS God 's Blessing 1 SN_ITEM_MALL_GODBLESS_TT_DESC God blessing scroll added by Gold Team to Incrace your force , Active the scroll and you will gain special buff 1 SN_ITEM_MALL_GODBLESS_DAY God' s Blessing 1 SN_ITEM_MALL_GODBLESS_DAY_TT_DESC God blessing scroll added by Gold Team to Incrace your force , Active the scroll and you will gain special buff itemdata_xxxxxx PHP Code : 1 47066 ITEM_MALL_GODBLESS ???? ???? ??? (???) xxx SN_ITEM_MALL_GODBLESS SN_ITEM_MALL_GODBLESS_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 - 1 0 - 1 0 - 1 0 - 1 0 - 1 0 0 0 0 0 0 0 100 0 0 0 xxx item \ etc \ drop_mall_scroll . bsr Premium \ etc \ mall_change_name . ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [ USU1 : SKILL_MALL_GODBLESS ] - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx 0 0 0 skilldata_enc PHP Code : 1 33816 300000 SKILL_MALL_GODBLESS ???? ???? SKILL_MALL_GODBLESS 0 1 1 0 0 0 0 0 1000 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item \ etc \ mall_optlevel_upgrade_scroll_1 . ddj SN_SKILL_MALL_GODBLESS xxx SN_SKILL_MALL_GODBLESS_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 - 1875767296 26738 110 0 1752396851 200 0 1752656242 120 0 7172201 3500 0 6844521 3500 0 1937011305 15 0 1768846441 15 0 25970 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PHP Code : DATABASE _REFSKILLGROUP PHP Code : 300000 SKILL_MALL_GODBLESS _REFOBJCOMMON PHP Code : 1 60120 ITEM_MALL_GODBLESS ???? ???? ??? (???) xxx SN_ITEM_MALL_GODBLESS SN_ITEM_MALL_GODBLESS_TT_DESC 1 0 3 3 13 14 180000 3 0 0 0 0 255 1 1 0 0 129 0 0 0 0 0 0 0 - 1 0 - 1 0 - 1 0 - 1 0 - 1 0 0 0 0 0 0 0 100 0 0 0 xxx item \ etc \ drop_mall_scroll . bsr Premium \ etc \ mall_change_name . ddj xxx xxx 2236094 _refskill PHP Code : 1 50134 300000 SKILL_MALL_GODBLESS ???? ???? SKILL_MALL_GODBLESS 0 1 1 0 0 0 0 0 1000 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item \ etc \ mall_optlevel_upgrade_scroll_1 . ddj SN_SKILL_MALL_GODBLESS xxx SN_SKILL_MALL_GODBLESS_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 - 1875767296 26738 110 0 1752396851 200 0 1752656242 120 0 7172201 3500 0 6844521 3500 0 1937011305 15 0 1768846441 15 0 25970 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 _refobjitem PHP Code : 2236094 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [ USU1 : SKILL_MALL_GODBLESS ] - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx - 1 xxx 0 0 0
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
pw hero
توقيع Hero
:
...!!
06-07-2014, 12:14 AM
#10
• الانـتـسـاب » Jan 2014
• رقـم العـضـويـة » 116050
• المشـــاركـات » 6,995
• الـدولـة » Egypt
• الـهـوايـة » ;"#string n = "C
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 191
طيب جرب اعمل دى
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 07/05/2014 23:13:38 ******/ 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 , 20 , 20 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 45 , GetDate (), 1 , 1 , 500000 , 0 , 3000000 , 200 , 200 , 1 , 1 , 1 , 1 , 0 ) 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 ) exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_60EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_SCROLL_RETURN_NEWBIE_01' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_REVERSE_RETURN_SCROLL' , 5 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E041225_SANTA_WINGS' , 15 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_HP_SUPERSET_5_BAG' , 200 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_MP_SUPERSET_5_BAG' , 200 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RESURRECTION_100P_SCROLL' , 5 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_REPAIR_HAMMER' , 2 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_COS_P_GOLDPIG_SCROLL' , 1 , 1 INSERT INTO SRO_VT_ACCOUNT . dbo . SK_Silk ( JID , silk_own , silk_gift , silk_point ) VALUES (@ UserJID , 1000000 , 0 , 0 ); -- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
توقيع Hero
:
...!!
06-07-2014, 12:28 AM
#14
• الانـتـسـاب » Jan 2014
• رقـم العـضـويـة » 116050
• المشـــاركـات » 6,995
• الـدولـة » Egypt
• الـهـوايـة » ;"#string n = "C
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 191
طيب اعمل الكورى دى الاول و شوف
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 07/05/2014 23:13:38 ******/ 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 , 20 , 20 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 45 , GetDate (), 1 , 1 , 500000 , 0 , 3000000 , 200 , 200 , 1 , 1 , 1 , 1 , 0 ) 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 ) exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_60EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_SCROLL_RETURN_NEWBIE_01' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_REVERSE_RETURN_SCROLL' , 5 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E041225_SANTA_WINGS' , 15 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_HP_SUPERSET_5_BAG' , 200 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_MP_SUPERSET_5_BAG' , 200 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RESURRECTION_100P_SCROLL' , 5 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_REPAIR_HAMMER' , 2 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_COS_P_GOLDPIG_SCROLL' , 1 , 1 INSERT INTO SRO_VT_ACCOUNT . dbo . SK_Silk ( JID , silk_own , silk_gift , silk_point ) VALUES (@ UserJID , 1000000 , 0 , 0 ); -- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
توقيع Hero
:
...!!
06-07-2014, 02:19 AM
#15
• الانـتـسـاب » Oct 2008
• رقـم العـضـويـة » 36761
• المشـــاركـات » 534
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 23
اقتباس:
المشاركة الأصلية كتبت بواسطة hismmm
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
انا رفعت ملفات الميديا ممكن تظبطهالى
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
lممكن تضيفها فى الملفات دى
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
ضوابط المشاركة
تستطيع إضافة مواضيع جديدة
تستطيع الرد على المواضيع
تستطيع إرفاق ملفات
تستطيع تعديل مشاركاتك
كود HTML معطلة
الساعة الآن 03:37 PM .