عايز اعمل Title جديد عاجل لو سمحتوا
 

ألسلام عليكم ورحمت الله انا عايز اعمل Title باس لما بكتب
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 Albert
--############################################ Parameter which you can change!

SET @blueORred = 1145127506
SET @ZerkDMG = 95
SET @newCHtitle = 'Reflect'
SET @newEUtitle = 'Reflect'

--############################################ 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,P aramValue2,ParamFourcc3,ParamValue3,ParamFourcc4,P aramValue4,ParamFourcc5,ParamValue5,AssocFileObj12 8,Title_CH70,Title_EU70) VALUES (@newHWANlevel,1397769301,200,@blueORred,@ZerkDMG, 0,0,0,0,0,0,'xxx',@CHwriting1+@newHWANlevel,@EUwri ting1+@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












بيجبلي Msg 102, Level 15, State 1, Line 27
Incorrect syntax near 'aramValue2'.




عايز حل بسرعه رجا:biker::biker::biker::biker::biker::biker:

بس يا صحبي مش query و بس ده من الميديا خش هنا هيفيدك
.
.
.
http://www.silkroad4arab.com/vb/showthread.php?t=434210

™Dev Microsoft™ شكرا ™Dev Microsoft™ جاري التجربة انتا فنان :) :queen_h4h: