--############################################ by Caipi --############################################ Parameter which you can change!
SET @blueORred = 1145127506 /* 1145127506 for blue, 0 for red Zerk*/ SET @ZerkDMG = 95 /*e.g. for 50% more DMG; MAX = 255% change tinyint to int if you want more*/ SET @newCHtitle = 'Queen' /*new Chinese Title*/ SET @newEUtitle = 'Queen' /*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