Dev.Ri3o
06-12-2016, 07:46 PM
http://www4.0zz0.com/2015/11/27/18/243536469.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
Job Dealer Scroll
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
عشان الناس اللى بتحب ال Job System لقيت ان بعض السيرفرات عاملة نظام Scroll بتضربها بعد اما بتوصل lvl 7 فى ال Job سواء Trader او Thief او Hunter بترجعك lvl 1 تانى وبتديك Reward سواء Coin او Silk
نخش على ال Scroll على طول
Database
RefObjCommon
1 105006 ITEM_DEALER_JOB_SCROLL ???????????(???) xxx SN_ITEM_DEALER_JOB_SCROLL SN_ITEM_DEALER_JOB_SCROLL_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 item\etc\mall_change_name.ddj xxx xxx 206100
RefObjItem
206100 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_DEALER_JOB_SCROLL] -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 120003 1923 SKILL_DEALER_JOB_SCROLL ???????? SKILL_DEALER_JOB_SCROLL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 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_change_name.ddj SN_SKILL_DEALER_JOB_SCROLL xxx SN_SKILL_DEALER_JOB_SCROLL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
RefSkillGroup
1923 SKILL_DEALER_JOB_SCROLL
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
Media
Itemdata_xxxx
1 105006 ITEM_DEALER_JOB_SCROLL ???????????(???) xxx SN_ITEM_DEALER_JOB_SCROLL SN_ITEM_DEALER_JOB_SCROLL_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 item\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 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_DEALER_JOB_SCROLL] -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
Skilldata_xxxxenc
1 120003 1923 SKILL_DEALER_JOB_SCROLL ???????? SKILL_DEALER_JOB_SCROLL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 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_change_name.ddj SN_SKILL_DEALER_JOB_SCROLL xxx SN_SKILL_DEALER_JOB_SCROLL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
Textdata_Object
1 SN_ITEM_DEALER_JOB_SCROLL Job Restart Scroll
1 SN_ITEM_DEALER_JOB_SCROLL_TT_DESC <sml2>The scroll will Restart your Job Level and Give You A Gift: <br><strong><font color="255,0,255,127">500 Arena Coin</font></strong></sml2>
textdata_equip&skill
1 SN_SKILL_DEALER_JOB_SCROLL Job Restart Scroll
1 SN_SKILL_DEALER_JOB_SCROLL_TT_DESC <sml2>The scroll will Restart your Job Level and Give You A Gift: <br><strong><font color="255,0,255,127">500 Arena Coin</font></strong></sml2>
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
Procedures
_TimedJob
لو عايز ال Reward يبقى Coin او Item تحددو هتعمل ده وهتعدل على ITEM_ETC_ARENA_COIN والرقم اللى بعدو اللى هو 500 ده العدد
declare @JobLevel int
Select @JobLevel = Level From _CharTrijob Where CharID = @CharID
if(@JobID = '37417') And ( @JobLevel = 7 )
Begin
Declare @Charname varchar(max)
Select @Charname=Charname16 From _Char Where CharID = @CharID
UPDATE _CharTrijob
Set Exp = 0
,Level = 1
Where CharID = @CharID
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARENA_COIN',500,1
End
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
ولو ال System عندك Silk هتعمل ده وهتعدل على ال 500 لعدد ال Silk اللى انت عاوزو
DECLARE @USERJID int
Declare @JobLevel int
SELECT @USERJID = USERJID FROM _User WHERE CHARID = @CHARID
Select @JobLevel = Level From _CharTrijob Where CharID = @CharID
if(@JobID = '37417') And ( @JobLevel = 7 )
Begin
Declare @Charname varchar(max)
Select @Charname=Charname16 From _Char Where CharID = @CharID
UPDATE _CharTrijob Set Exp = 0 ,Level = 1 Where CharID = @CharID
UPDATE SRO_VT_ACCOUNT..SK_Silk SET SILK_OWN = SILK_OWN + 500 WHERE JID = @USERJID
End
شوية صور
http://up.dev-point.com/uploads1/f15dde05733d1.jpg (http://up.dev-point.com/)
http://up.dev-point.com/uploads1/fa21e196a2cc2.jpg (http://up.dev-point.com/)
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
Job Dealer Scroll
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
عشان الناس اللى بتحب ال Job System لقيت ان بعض السيرفرات عاملة نظام Scroll بتضربها بعد اما بتوصل lvl 7 فى ال Job سواء Trader او Thief او Hunter بترجعك lvl 1 تانى وبتديك Reward سواء Coin او Silk
نخش على ال Scroll على طول
Database
RefObjCommon
1 105006 ITEM_DEALER_JOB_SCROLL ???????????(???) xxx SN_ITEM_DEALER_JOB_SCROLL SN_ITEM_DEALER_JOB_SCROLL_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 item\etc\mall_change_name.ddj xxx xxx 206100
RefObjItem
206100 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_DEALER_JOB_SCROLL] -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 120003 1923 SKILL_DEALER_JOB_SCROLL ???????? SKILL_DEALER_JOB_SCROLL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 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_change_name.ddj SN_SKILL_DEALER_JOB_SCROLL xxx SN_SKILL_DEALER_JOB_SCROLL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
RefSkillGroup
1923 SKILL_DEALER_JOB_SCROLL
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
Media
Itemdata_xxxx
1 105006 ITEM_DEALER_JOB_SCROLL ???????????(???) xxx SN_ITEM_DEALER_JOB_SCROLL SN_ITEM_DEALER_JOB_SCROLL_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 item\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 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_DEALER_JOB_SCROLL] -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
Skilldata_xxxxenc
1 120003 1923 SKILL_DEALER_JOB_SCROLL ???????? SKILL_DEALER_JOB_SCROLL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 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_change_name.ddj SN_SKILL_DEALER_JOB_SCROLL xxx SN_SKILL_DEALER_JOB_SCROLL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 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
Textdata_Object
1 SN_ITEM_DEALER_JOB_SCROLL Job Restart Scroll
1 SN_ITEM_DEALER_JOB_SCROLL_TT_DESC <sml2>The scroll will Restart your Job Level and Give You A Gift: <br><strong><font color="255,0,255,127">500 Arena Coin</font></strong></sml2>
textdata_equip&skill
1 SN_SKILL_DEALER_JOB_SCROLL Job Restart Scroll
1 SN_SKILL_DEALER_JOB_SCROLL_TT_DESC <sml2>The scroll will Restart your Job Level and Give You A Gift: <br><strong><font color="255,0,255,127">500 Arena Coin</font></strong></sml2>
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
Procedures
_TimedJob
لو عايز ال Reward يبقى Coin او Item تحددو هتعمل ده وهتعدل على ITEM_ETC_ARENA_COIN والرقم اللى بعدو اللى هو 500 ده العدد
declare @JobLevel int
Select @JobLevel = Level From _CharTrijob Where CharID = @CharID
if(@JobID = '37417') And ( @JobLevel = 7 )
Begin
Declare @Charname varchar(max)
Select @Charname=Charname16 From _Char Where CharID = @CharID
UPDATE _CharTrijob
Set Exp = 0
,Level = 1
Where CharID = @CharID
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARENA_COIN',500,1
End
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
ولو ال System عندك Silk هتعمل ده وهتعدل على ال 500 لعدد ال Silk اللى انت عاوزو
DECLARE @USERJID int
Declare @JobLevel int
SELECT @USERJID = USERJID FROM _User WHERE CHARID = @CHARID
Select @JobLevel = Level From _CharTrijob Where CharID = @CharID
if(@JobID = '37417') And ( @JobLevel = 7 )
Begin
Declare @Charname varchar(max)
Select @Charname=Charname16 From _Char Where CharID = @CharID
UPDATE _CharTrijob Set Exp = 0 ,Level = 1 Where CharID = @CharID
UPDATE SRO_VT_ACCOUNT..SK_Silk SET SILK_OWN = SILK_OWN + 500 WHERE JID = @USERJID
End
شوية صور
http://up.dev-point.com/uploads1/f15dde05733d1.jpg (http://up.dev-point.com/)
http://up.dev-point.com/uploads1/fa21e196a2cc2.jpg (http://up.dev-point.com/)
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)