شـريـط الاهـداءات
قسم المواضيع المكررة و المخالفة هنا يتم وضع المواضيع المخالفة والمواضيع المكررة
إعلانات 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 معطلة
الساعة الآن 05:56 AM .