22-11-2014, 03:47 AM
|
#2
|
|
• ÇáÇäÜÊÜÓÜÇÈ » Mar 2013
|
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 110495
|
• ÇáãÔÜÜÜÇÑßÜÇÊ » 2,214
|
• ÇáÜÏæáÜÉ » in Dedicated Server
|
• ÇáÜåÜæÇíÜÉ » Develop DB&PHP Edit&Fixing Buged Files
|
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » Private Server
|
• ÇáÜÌÜäÜÓ » Male
|
• äÞÜÇØ ÇáÊÞííã » 61
|
|
|
Ïí scroll title name
I Assume you have already " Silkroad4arab " title name in your media.pk2 ( at textuisystem.txt ). Lets get started:
First Data base lines:
dbo._RefObjCommon:
ßæÏ PHP:
1 41802 ITEM_MALL_CHANGETITLE_Silkroad4arab ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGETITLE_Silkroad4arab SN_ITEM_MALL_CHANGETITLE_Silkroad4arab_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 33789
dbo._RefObjItem:
ßæÏ PHP:
33789 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_CHANGETITLE_Silkroad4arab] -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
dbo._RefSkill:
ßæÏ PHP:
1 3882 1200 SKILL_MALL_CHANGETITLE_Silkroad4arab ???? ???? SKILL_MALL_CHANGETITLE_Silkroad4arab 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_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGETITLE xxx SN_SKILL_MALL_CHANGETITLE_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
dbo._RefSkillGroup:
ßæÏ PHP:
1200 SKILL_MALL_CHANGETITLE_Silkroad4arab
Now lets move to Media.pk2 lines:
itemdata45000.txt:
ßæÏ PHP:
1 41802 ITEM_MALL_CHANGETITLE_Silkroad4arab ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGETITLE_Silkroad4arab SN_ITEM_MALL_CHANGETITLE_Silkroad4arab_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_MALL_CHANGETITLE_Silkroad4arab] -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
Skilldata35000enc.txt:
ßæÏ PHP:
1 3882 1200 SKILL_MALL_CHANGETITLE_Silkroad4arab ???? ???? SKILL_MALL_CHANGETITLE_Silkroad4arab 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_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGETITLE xxx SN_SKILL_MALL_CHANGETITLE_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
Skilleffect.txt:
ßæÏ PHP:
1 귀환서 사용전 SKILL_MALL_CHANGETITLE_Silkroad4arab 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_CHANGETITLE_Silkroad4arab ACT_S 0 FALSE none none 0 0 0 0 1 0,0 AT_LOOP MOV_NONE,0,0,0 0,0,0 false,0,0,0,0,false system\ item_returnscroll.efp none 0,0,0 none 0,0,0 none 0 none none none
textdata_object.txt:
ßæÏ PHP:
1 SN_ITEM_MALL_CHANGETITLE_Silkroad4arab Silkroad4arab title name Scroll 1 SN_ITEM_MALL_CHANGETITLE_Silkroad4arab_TT_DESC Silkroad4arab title name scroll
Now lets move to the STORED PROCEDURE:
Open SRO_VT_SHARD , Programmability , Stored Procedures , AddTimedJob right click on AddTimedJob and Modify and add these lines to your stored procedure.
PHP Code:
if(@JobID = 'xxxx') -- Tusin1337 developments , Silkroad4arab.com
BEGIN
declare @HwanLevel tinyint
Select @HwanLevel=HwanLevel from _Char where CharID = @CharID
Update _Char Set HwanLevel = 7 Where CharID = @CharID
END
You have to edit JobID =' xxxxx ' and HwanLevel='x' to your value.
|
|
|