[RELEASE] How to add Title name Scroll.

Page 1 of 2 1 2
04/22/2014 17:06 Tustin1337#1
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.
04/23/2014 05:09 PortalDark#2
#Approved
04/23/2014 05:21 [NoReason]#3
Tustin1337

Tustin ?! :DDD
04/23/2014 07:51 Tustin1337#4
Quote:
Originally Posted by PortalDark View Post
#Approved
Thank you =)

Quote:
Originally Posted by [NoReason] View Post
Tustin1337

Tustin ?! :DDD
Oh ye , Tustin.
04/23/2014 08:13 globalsilkroad2#5
Thanks body :D
04/23/2014 11:37 bestprem#6
Old but thanks anyway
04/23/2014 12:03 Tustin1337#7
Quote:
Originally Posted by globalsilkroad2 View Post
Thanks body :D
Your welcome , press thanks button instead :p

Quote:
Originally Posted by bestprem View Post
Old but thanks anyway
You can't call it such " old " because it dose not exist in any other p-sro forums , anyway thanks :p
04/23/2014 13:32 Crue*#8
thank you
awesome guide :P
04/23/2014 13:41 Tustin1337#9
Quote:
Originally Posted by Crue* View Post
thank you
awesome guide :P
Thank you :p
04/23/2014 16:15 [NoReason]#10
Quote:
Originally Posted by Tustin1337 View Post
Thank you :p
Still Tustin ? :D

i think you was Justin ?
04/23/2014 16:22 geomangy#11
Don't Need To Declare :D
Check This :-

AddTimedJob
04/23/2014 16:29 Dallin¥#12
why you declare hwanlevel and also its useless anyway thanks
04/23/2014 16:36 geomangy#13
Quote:
Originally Posted by M̷r̷.̷X̷ View Post
why you declare hwanlevel and also its useless anyway thanks

I'm Say That Before :D
04/23/2014 17:23 Tustin1337#14
Quote:
Originally Posted by geomangy View Post
Don't Need To Declare :D
Check This :-

AddTimedJob
haha :D 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.
04/23/2014 17:40 geomangy#15
Quote:
Originally Posted by Tustin1337 View Post
haha :D 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 :D
Page 1 of 2 1 2