[RELEASE] lil Costum HWAN Title Query

[Caipi]

USE SRO_VT_SHARD
Declare @newHWANlevel varchar(64)
Declare @blueORred int
Declare @ZerkDMG tinyint
Declare @CHwriting1 varchar(74)
Declare @EUwriting1 varchar(74)
Declare @newCHtitle varchar(74)
Declare @newEUtitle varchar(74)


--############################################ by Caipi
--############################################ Parameter which you can change!

SET @blueORred = 1145127506 /* 1145127506 for blue, 0 for red Zerk*/
SET @ZerkDMG = 50 /*e.g. for 50% more DMG; MAX = 255% change tinyint to int if you want more*/
SET @newCHtitle = 'Rage'    /*new Chinese Title*/
SET @newEUtitle = 'Zone'    /*new European Title*/

--############################################ END
--############################################


SET @newHWANlevel = (SELECT MAX(HwanLevel) FROM _RefHWANLevel)+1
SET @CHwriting1 = 'UIO_SECOND_HWAN_CH_NAME_LEVEL_'
SET @EUwriting1 = 'UIO_SECOND_HWAN_EU_NAME_LEVEL_'
INSERT INTO _RefHWANLevel (HwanLevel,ParamFourcc1,ParamValue1,ParamFourcc2,ParamValue2,ParamFourcc3,ParamValue3,ParamFourcc4,ParamValue4,ParamFourcc5,ParamValue5,AssocFileObj128,Title_CH70,Title_EU70) VALUES (@newHWANlevel,1397769301,200,@blueORred,@ZerkDMG,0,0,0,0,0,0,'xxx',@CHwriting1+@newHWANlevel,@EUwriting1+@newHWANlevel);
print ''
print 'Media/server_dep/silkroad/textdata/textuisystem.txt'
print '1    '+@CHwriting1+@newHWANlevel+'                            '+@newCHtitle
print '1    '+@EUwriting1+@newHWANlevel+'                            '+@newEUtitle
print ''
print 'Media/server_dep/silkroad/textdata/hwanleveldata.txt'
print @newHWANlevel+'    UIO_SECOND_HWAN_CH_NAME_LEVEL_'+@newHWANlevel+'    UIO_SECOND_HWAN_EU_NAME_LEVEL_'+@newHWANlevel 

Will throw also the path + the necessary pk2 lines out.
Change only the 4 values between the ## Häf phun :)

USE SRO_VT_SHARD/--_INIT

Declare @CharNick varchar(64)
Declare @Hwanlvl tinyint

SET @CharNick = ''    --Your Ingame Nick
SET @Hwanlvl = ''    --Your desired Hwan Title e.g. '6'

/* Hwan Title Explanation:
CH '1'    Captain
CH '2'    General
CH '3'    Senior General
CH '4'    Chief General
CH '5'    Vice General Lord
CH '6'    General Lord
EU '1'    Knight
EU '2'    Baronet
EU '3'    Baron
EU '4'    Count
EU '5'    Marquis
EU '6'    Duke    */

UPDATE dbo._Char
SET HwanLevel = @Hwanlvl
WHERE CharName16 like @CharNick 

To simply use one of the just created titles.. ^^


For example with "Ò_ó"

[MentaL]

[asi41]

What is this?

[Caipi]

Simply to add more titles like "Baronet" to your server - only for the lazy ones out there since it can be easily made manually too :)

[asi41]

ok...

[achm177]

need srv restart?

[3d2000]

GReaaaaaaaaaaat :))

[epvp2]

very helpful :-)

[HardStylax]

Where's the file?
I just didn't understood command 'print'

[Caipi]

It gives you the writings out in the "Messages" window of mssql below - nothing more, to copy pasta it for the pk2

[HardStylax]

Okay, Thanks anyway :)

[epvp2]

i'm do every thing in u r Topic but not thing hapend
and i add new code Like this
CH '7' Owner

not working

[Caipi]

i'm do every thing in u r Topic but not thing hapend
and i add new code Like this
CH '7' Owner

not working

Weird, I lately used it several times and it worked pretty well - seems like the query dislikes you.

(Keep in mind to adjust the tabs correctly - the text system here doesn't support tabs properly)


EDIT: Added the textfile version, try this one out

[Kira]

I have a noob Question Caipi
if i wanna give Title for my GM Account Only!!

[Caipi]

Then create your own one and update the HwanLevel from your GM Title only @ GM Chars ^^

[Kira]

Then create your own one and update the HwanLevel from your GM Title only @ GM Chars ^^

Thx For Prof Answer

[shadowfuuk]

Not understand

[mohsen857]

thanks its very useful i will try now

[Kira]

Hey Bro can u help me !! coz i try but i fail so can u help me
if i wanna give my char Nike name like " Owner " Can u give me The code to do it !!

[GiannyRockZ]

Does not work...idk why

[gergomiho]

Nice , but Seal online section ? :D Somebody move it to Silkroad online please. :)

[dhohopin]

Lol... i missing the section... idk why that patch at seal online ?