الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)
-   -   AddTimedJob هو اية دة بالظبط (https://silkroad4arab.com/vb/showthread.php?t=555317)

gameman 24-04-2014 10:47 PM

AddTimedJob هو اية دة بالظبط
 
_AddTimedJob
if(@JobID = '1000012')
BEGIN
UPDATE dbo._Char SET HwanLevel = 9 Where CharID = @CharID
END
This is what guys a query or what where i add this plz tell me i got this from Add scroll oF title name

و لو دة query عموما مش شغال

دة الموضوع

http://silkroad4arab.com/vb/showthread.php?t=544099

gameman 25-04-2014 08:39 AM

up

che_9299 25-04-2014 10:46 AM

دى عباره عن سكرولايه اللى يضربها بياخد title اللى هوه HwanLevel = 9
وبيتحط فى ال addnewchar

gameman 25-04-2014 02:34 PM

ممكن توضيح اكتر منك يعني اعملها Copy paste في ال add new char

Tigger 25-04-2014 02:51 PM

كود بلغة HTML:

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 Marwan Abbas
--############################################ 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


Tigger 25-04-2014 02:52 PM

Qurey Change title Name Eru ~ Chinse

gameman 26-04-2014 08:26 AM

اية علاقة دة بالموضوع انا كل الي عايز اعرفوا ادخل الكلام دة الداتا ازاي

gameman 26-04-2014 10:58 AM

Help plz need help for this

gameman 26-04-2014 03:42 PM

Up


الساعة الآن 12:45 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.