-
Make Title
Code:
USE [SRO_VT_SHARD]
DECLARE @Title Varchar (max) = 'Mais Nun éh Perigoso?'
DECLARE @Defesa INT = '30' --% de defesa quando zerka
/*===============================================================================*/
DECLARE @HwanID Varchar(max) = (SELECT MAX (HwanLevel) FROM _RefHWANLevel)+1
INSERT INTO [dbo].[_RefHWANLevel]([HwanLevel],[ParamFourcc1],[ParamValue1],[ParamFourcc2],[ParamValue2],[ParamFourcc3],[ParamValue3],[ParamFourcc4],[ParamValue4],[ParamFourcc5],[ParamValue5],[AssocFileObj128],[Title_CH70],[Title_EU70])
VALUES(@HwanID,1397769301,200,1145127506,@Defesa,0,0,0,0,0,0,'xxx','UIO_SECOND_HWAN_NAME_LEVEL_'+@HwanID,'UIO_SECOND_HWAN_NAME_LEVEL_'+@HwanID)
PRINT ''
PRINT 'Add This Line to media\server_dep\silkroad\textdata\hwanleveldata.txt'
PRINT @HwanID+' UIO_SECOND_HWAN_NAME_LEVEL_'+@HwanID+' UIO_SECOND_HWAN_NAME_LEVEL_'+@HwanID
PRINT ''
PRINT 'add This Line to media\server_dep\silkroad\textdata\textuisystem.txt'
PRINT '1 UIO_SECOND_HWAN_NAME_LEVEL_'+@HwanID+' '+@Title+' '+@Title