[Release] Title Name System( More Controll )

[Eslam Galull]

Title Name System

i Will Release and Explain Some more Things For ALL

ALl PLayers Was Searching For a Title Name System To Make & allowed Donaters Players To Free Change Yellow Titles And At Same Time Keep Non DOnaters With the Only title They Get When They Creat the Chr For Ex. Non Donater


So Here We Go :
1: Donate FOr Title Will Be With Buying A Title Name Change Scroll
2: Free Change Will Be By Codes Allowed Donaters To Change / Non Cant Change it

------ Frist Part :

We Will Use The Title Name Scroll With Some Changes Lets Start

DataBase Side :

RefObjCommon

1	113893	ITEM_MALL_TitleSc	???????????(???)	xxx	SN_ITEM_MALL_TitleSc	SN_ITEM_MALL_TitleSc_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_stats_point_recall_81lv.ddj	xxx	xxx	[COLOR="Red"]3336114[/COLOR]

Red >> ObjItem ID

RefObjItem

3336114	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_TitleSc]                                                                                                           	-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	1000012	[COLOR="Red"]13133[/COLOR]	SKILL_MALL_TitleSc	    ???? ????	        SKILL_MALL_TitleSc	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_s4a	xxx	SN_SKILL_MALL_TitleSc_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

Red >> RefSkill Group ID

RefSkillGroup :

13133	SKILL_MALL_TitleSc

Now With Media Side :

Itemdata_4500 :

1	[COLOR="Red"]113893[/COLOR]	ITEM_MALL_TitleSc	???????????(???)	xxx	SN_ITEM_MALL_TitleSc	SN_ITEM_MALL_TitleSc_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_TitleSc]	-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

Red > RefObjCommon ID

Skilldata_3500enc:
Decrypt it and Put THis Line :

1	[COLOR="Red"]1000012[/COLOR]	[COLOR="Blue"]13133[/COLOR]	SKILL_MALL_TitleSc	    ???? ????	        SKILL_MALL_TitleSc	    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_TitleSc	xxx	SN_SKILL_MALL_TitleSc_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

Red > RefSkill
Blue > Skill Group ID

SkillEffect :
That One in This Path : server_dep\silkroad\textdata\ Cuz you will Found 2x Skilleffect
Put Comming Line After This Line // Paid Item

1	귀환서 사용전	SKILL_MALL_TitleSc	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

Textdata_Object :

1	SN_ITEM_MALL_TitleSc	?? ?? (?)	0	0	0	0	0	Yellow Title Name Scroll

Now We Done Back To Your Database And Open AddTimeJob Table And Put Next Lines ( i will Explain )

if(@JobID = '[COLOR="Red"]1000012[/COLOR]')
BEGIN
update SRO_VT_SHARD.dbo._Char set [COLOR="Lime"]HwanLevel = 9[/COLOR] where CharID = @CharID
END

Red > is Your RefSkill ID
This Turns The Player From THe Hwan Lvl 1 ( Starter Hwan ) To lvl (9)

You Can Change 9 To ANy Hwan Lvl You Wanna

Frist Part IS Done And its Easy .. Now Sec Part : Changing The Title Names In Game
And How i Can Refuse Non DOnater Request


We Will Use Message System as a System TO Change Hwanlvl ( Yellow Title Name )

Open Ur Database > Procedures > Memo_Add

And Add This

If (@TargetCharName like @SenderCharName and @Message = '[COLOR="Yellow"]S3XY[/COLOR]')
  
if(select HwanLevel from _Char where CharName16 = @SenderCharName) > 1
BEGIN
    update SRO_VT_SHARD.dbo._Char set [COLOR="Yellow"]HwanLevel = 3[/COLOR] where CharName16 = @SenderCharName 
END

its Work Like This
Player Send A Message To Him Self Conatin a Word That He wanna Turn His Title To it
Explain :
Our Non DOnater Have Hwanlvl 1 : What ever you Rename it in Media
We Wanna Any One Have Hwanlvl 1 Send a Msg .. Nothing Happen
if Any One Have Hwanlvl 2 ++ We accept Request and Change his Hwan

Yellow Words :
S3XY is The Title Name We Store In Media in Hwan lvl 3

--So Change S3XY TO ANy Word You Need as a Short To the Title
--Change Hwan lvl To The Title Hwanlvl

For Example If you Have a Title Called "War Machine" And you Stored it in hwanlvl = 5

Change S3XY To "WAR"
And Change Hwan lvl To = 5


if you Wanna Player Get a Disconnect When he Change Title Add

return -3

Before

End

or Keep it As i Did .. its Work By Return Or Telport He will Found Title Changed


So Here We Are Make a Success Donate Yellow Title Name

Eslam Galull
Best Regards

-- its My Own Lines & Codes From My DataBase i Know May there is a Smiliir Topics But Not For That System !

>> Please Dont Copy it To Another Forms Or At Less mention My Name On it <<

After Previwe Post i Found That HTML Didnt Support

So When You Copy it Remove What EVer The Color From Lines ,, im To Lazy To Reedit it
-- its a good Point to To make Ppl Wakeup while they COping it to database

[PortalDark]

#Approved

[Justin1337*]

Thanks man. =)

[Crue*]

so pro menz

[Ṃ¥ŘέŦЏŔŊ®]

ThX BRo

[Syloxx]

I just ask me why ppl still use this system

Scroll > Skill > DC

if u use your brain for like 3 mins u´ll see there is a better method 2 do it without disconnect (yes db only)

[Eslam Galull]

Originally Posted by PortalDark

#Approved

Thanks Bro <3

Originally Posted by Justin1337*

Thanks man. =)

urw Dude

Originally Posted by Crue*

so pro menz

Hope You Like My Idea !

Originally Posted by Ṃ¥ŘέŦЏŔŊ®

ThX BRo

Urw <3

Originally Posted by Syloxx

I just ask me why ppl still use this system

Scroll > Skill > DC

if u use your brain for like 3 mins u´ll see there is a better method 2 do it without disconnect (yes db only)

If You Read My Topic Well You Will Get This i Said ..
If You WAnna Add D.C after Active Scroll Bla bla Add Below Code , if You Wont Just Let My Code As it !!
i Dont Use The D.C in My Server Dude ^^

[aw_elkady]

I worked every need true
Except this step

And Add This
HTML Code:
If (@TargetCharName like @SenderCharName and @Message = '[COLOR="Yellow"]S3XY[/COLOR]')
  
if(select HwanLevel from _Char where CharName16 = @SenderCharName) > 1
BEGIN
    update SRO_VT_SHARD.dbo._Char set [COLOR="Yellow"]HwanLevel = 3[/COLOR] where CharName16 = @SenderCharName 
END

And opened the server and download SCROLL AND hit, but something does not happen
??????????

[Eslam Galull]

Originally Posted by aw_elkady

I worked every need true
Except this step

And Add This
HTML Code:
If (@TargetCharName like @SenderCharName and @Message = '[COLOR="Yellow"]S3XY[/COLOR]')
  
if(select HwanLevel from _Char where CharName16 = @SenderCharName) > 1
BEGIN
    update SRO_VT_SHARD.dbo._Char set [COLOR="Yellow"]HwanLevel = 3[/COLOR] where CharName16 = @SenderCharName 
END

And opened the server and download SCROLL AND hit, but something does not happen
??????????

Need A Good English Skills To Understand The Topic
Read it Word By Word

i Dont Know What the problem You Did But i Get it From ur Quote xD

Remove Any [ COLOR="Yellow" ] And [ / C O L O R ]
Form Database & Media Side Codes .. i was Make it For Explain & HTML Didnt accept This xD So just Remove THis

[aw_elkady]

KK I I UNDERSTAND THIS

Remove Any [ COLOR="Yellow" ] And [ / C O L O R ]
Form Database & Media Side Codes .. i was Make it For Explain & HTML Didnt accept This xD So just Remove THis

AND DONE add all lines Database & Media Side Codes and server runing good and clint no crash
but wen i use title scroll nothing work
i think because i cant make this steep
Open Ur Database > Procedures > Memo_Add
tell me bet by bet how can i make it
sorry for bad English.

[Eslam Galull]

Originally Posted by aw_elkady

KK I I UNDERSTAND THIS

AND DONE add all lines Database & Media Side Codes and server runing good and clint no crash
but wen i use title scroll nothing work
i think because i cant make this steep
Open Ur Database > Procedures > Memo_Add
tell me bet by bet how can i make it
sorry for bad English.

Never mind Bro im Not Mad i Make This Post To Help You Guys

Here We Go :
Open Your Database
1. Go To SRO_VT_SHARD or What Ever You Renamed it
2. Go To Programmabilty
3.Stored Procedures
4.dbo._Memo_Add

And Put This

PHP Code:

If (@TargetCharName like @SenderCharName and @Message = 'S3XY')
  
if(select HwanLevel from _Char where CharName16 = @SenderCharName) > 1
BEGIN
    update SRO_VT_SHARD.dbo._Char set HwanLevel = 3 where CharName16 = @SenderCharName 
END 


After This

PHP Code:

    begin transaction
        declare @target_charid int
        set @target_charid = (select CharID from _Char where CharName16 = @TargetCharName)
        if (@@error <> 0 or @@rowcount = 0 )
        begin
            --±×·±¾Ö´Â ¾ø¾î~
            rollback transaction
            return -1
        end 


Its Done !

[aw_elkady]

Explain in very Extravaganza
The steps were okay
But still the problem
When using SCROLL change does not happen at the Title Name
Thanked generally if at all
It seems that I have a problem I

[Eslam Galull]

copy ur both lines here ,,, and i will check it

[[NoReason]]

Originally Posted by Crue*

so pro menz

poor guy...

[Crue*]

Originally Posted by [NoReason]

poor guy...

yea b1q you're so pro too menz
vary vary pro