|
You last visited: Today at 01:03
Advertisement
Need Query Full Blue one char ?
Discussion on Need Query Full Blue one char ? within the SRO Private Server forum part of the Silkroad Online category.
01/25/2016, 09:13
|
#1
|
elite*gold: 0
Join Date: Oct 2008
Posts: 50
Received Thanks: 2
|
Need Query Full Blue one char ?
me need 1 query full blue one char . thax
|
|
|
01/26/2016, 08:36
|
#2
|
elite*gold: 0
Join Date: Jan 2016
Posts: 5
Received Thanks: 4
|
HTML Code:
USE SRO_VT_SHARD
UPDATE dbo._Items set MagParamNum=’5′,MagParam1=’85899346100′,MagParam2=’85899346088′,MagParam3=’85899346106′,MagParam4=’85899346112′
WHERE ID64=’ItemIdHERE‘
NT: 30064771150 STR: 30064771144 MP: 5583457484962 HP: 5583457484950 DUR: 858993459290 BLOCKRATE: 429496729714 PARRYRATE: 257698037898 ATACKRATE: 257698037862 CRITICAL: 429496729726 BURN: 85899346100 ELECT: 85899346094 FROST: 85899346088 POISION: 85899346106 ZOMBIE: 85899346112
|
|
|
01/26/2016, 12:37
|
#3
|
elite*gold: 0
Join Date: Oct 2008
Posts: 50
Received Thanks: 2
|
me need query full blue new char ?
|
|
|
02/01/2016, 13:07
|
#4
|
elite*gold: 0
Join Date: May 2012
Posts: 142
Received Thanks: 38
|
Full blue & 100% stats " working for D11 " u can edit the numbers to be D12 or D13 , whatever you want.
PHP Code:
USE SRO_VT_SHARD
declare @CharName varchar (64) set @CharName = 'ActOfDark' declare @CharID INT = ( select CharID from _Char where CharName16 = @CharName )
--(Str/Int 8, Parry 60%, Durability 200%, HP 100% , MP 100% for custom) UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '0') UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '1') UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '2') UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '3') UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144',MagParam5 ='858993459290',MagParam6 ='4294967494' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '4') UPDATE _Items SET Variance = 34359738336,OptLevel='20', MagParamNum='4',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='30064771150',MagParam4= '30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '5') --(Str/Int 8, Freeze 20%, Electric Shock 20%, Burn 20%, Poison 20%, Zombie 20%) UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '9' ) UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '10' ) UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '11' ) UPDATE _Items SET Variance = 1023,OptLevel='20', MagParamNum='7',MagParam1='30064771150',MagParam2= '30064771144',MagParam3='85899346100',MagParam4= '85899346094',MagParam5='85899346088',MagParam6='85899346106',MagParam7='85899346112' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '12' ) -- UPDATE _Items SET Variance = 34359738367,OptLevel='20', MagParamNum='5',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='429496729714',MagParam4= '30064771150',MagParam5='30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '6' ) UPDATE _Items SET Variance = 1073741823,OptLevel='20',MagParamNum='5',MagParam1='858993459290',MagParam2= '429496729714',MagParam3='257698037862',MagParam4= '30064771150',MagParam5='30064771144' WHERE ID64 = (select ItemID from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID and Slot = '7' )
|
|
|
05/15/2019, 05:57
|
#5
|
elite*gold: 0
Join Date: Sep 2018
Posts: 60
Received Thanks: 5
|
how can i disable "durability 200% magparam 858993459290"
I try replace "858993459290" to "Null" or "0"
But client error. I can't login game. Pls help me..
|
|
|
All times are GMT +1. The time now is 01:03.
|
|