[RELEASE] How to add Title name Scroll.

[Tustin1337]

Hello elitepvpers community. Today i'm going to show you how to add title name scroll to your server correctly without bugs.

I Assume you have already " Elitepvpers " title name in your media.pk2 ( at textuisystem.txt ). Lets get started:

First Data base lines:

dbo._RefObjCommon:

PHP Code:

1    41802    ITEM_MALL_CHANGETITLE_ELITEPVPERS    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS_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 Code:

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_ELITEPVPERS]                                                                                                         -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 Code:

1    3882    1200    SKILL_MALL_CHANGETITLE_ELITEPVPERS    ???? ????    SKILL_MALL_CHANGETITLE_ELITEPVPERS    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 Code:

1200    SKILL_MALL_CHANGETITLE_ELITEPVPERS 


Now lets move to Media.pk2 lines:

itemdata45000.txt:

PHP Code:

1    41802    ITEM_MALL_CHANGETITLE_ELITEPVPERS    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS_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_ELITEPVPERS]    -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 Code:

1    3882    1200    SKILL_MALL_CHANGETITLE_ELITEPVPERS    ???? ????    SKILL_MALL_CHANGETITLE_ELITEPVPERS    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 Code:

1    귀환서 사용전    SKILL_MALL_CHANGETITLE_ELITEPVPERS    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_ELITEPVPERS    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 Code:

1    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS                                Elitepvpers title name Scroll                        
1    SN_ITEM_MALL_CHANGETITLE_ELITEPVPERS_TT_DESC                                Elitepvpers 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 , elitepvpers.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.

Created by ME - DO NOT RELEASE IT UNDER YOURNAME.

[PortalDark]

#Approved

[[NoReason]]

Tustin1337

Tustin ?! DD

[Tustin1337]

Originally Posted by PortalDark

#Approved

Thank you =)

Originally Posted by [NoReason]

Tustin1337

Tustin ?! DD

Oh ye , Tustin.

[globalsilkroad2]

Thanks body

[bestprem]

Old but thanks anyway

[Tustin1337]

Originally Posted by globalsilkroad2

Thanks body

Your welcome , press thanks button instead

Originally Posted by bestprem

Old but thanks anyway

You can't call it such " old " because it dose not exist in any other p-sro forums , anyway thanks

[Crue*]

thank you
awesome guide :P

[Tustin1337]

Originally Posted by Crue*

thank you
awesome guide :P

Thank you

[[NoReason]]

Originally Posted by Tustin1337

Thank you

Still Tustin ?

i think you was Justin ?

[geomangy]

Don't Need To Declare
Check This :-

AddTimedJob

 Spoiler

if(@JobID = '59710')
BEGIN
UPDATE dbo._Char SET HwanLevel = 41 Where CharID = @CharID
END

[Dallin¥]

why you declare hwanlevel and also its useless anyway thanks

[geomangy]

Originally Posted by M̷r̷.̷X̷

why you declare hwanlevel and also its useless anyway thanks

I'm Say That Before

[Tustin1337]

Originally Posted by geomangy

Don't Need To Declare
Check This :-

AddTimedJob

 Spoiler

if(@JobID = '59710')
BEGIN
UPDATE dbo._Char SET HwanLevel = 41 Where CharID = @CharID
END

haha I would do that , but i prefer to declare and then update or set a new value to the declared param :P , it dosent matter anyway still helpful for beginners.

[geomangy]

Originally Posted by Tustin1337

haha I would do that , but i prefer to declare and then update or set a new value to the declared param :P , it dosent matter anyway still helpful for beginners.

AnyWay GL