lil Costum HWAN Title Query
PHP Code:
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 = 'Elite' /*new Chinese Title*/
SET @newEUtitle = 'pvpers' /*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
Change only the 4 values between the ## Häf phun
PHP Code:
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
For example with "Ò_ó"
