|
You last visited: Today at 00:32
Advertisement
[RELEASE] Query to full blue chars items one click
Discussion on [RELEASE] Query to full blue chars items one click within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
08/29/2015, 05:54
|
#16
|
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
|
FIX !
|
|
|
09/01/2015, 18:08
|
#17
|
elite*gold: 0
Join Date: Jul 2015
Posts: 100
Received Thanks: 28
|
nice Query
|
|
|
09/12/2015, 13:34
|
#18
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
Quote:
Originally Posted by spinal2
FIX !
|
fix for ?
|
|
|
09/12/2015, 13:57
|
#19
|
elite*gold: 0
Join Date: Jul 2015
Posts: 613
Received Thanks: 192
|
Nice Query
|
|
|
09/13/2015, 16:02
|
#20
|
elite*gold: 0
Join Date: Aug 2015
Posts: 129
Received Thanks: 6
|
nice query
|
|
|
07/20/2016, 09:21
|
#21
|
elite*gold: 30
Join Date: Oct 2010
Posts: 438
Received Thanks: 15
|
NPC items HP MP 1700
How to remove ?
|
|
|
01/21/2017, 15:10
|
#22
|
elite*gold: 32
Join Date: Apr 2016
Posts: 164
Received Thanks: 50
|
Quote:
Originally Posted by mohamedbebo999
thank you i will try
couldn't make it thankx for your Time any way
Code:
DECLARE @Charid int
DECLARE @ItemID int
Declare @Charname VarChar(50)
Declare @PLUS int
DECLARE @Head int
Declare @CHEST int
DECLARE @LEGS int
DECLARE @SHOULDER int
DECLARE @HAND int
DECLARE @FOOT int
DECLARE @RING1 int
DECLARE @RING2 int
DECLARE @NECK int
DECLARE @ERRING int
DECLARE @WEP int
DECLARE @SHIELD int
SET @Charname = 'Pur3viL'
SET @PLUS = '13'
SET @Charid = (select CharID from _Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @RING1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid)
SET @RING2 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @WEP =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid)
SET @SHIELD =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid)
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =7301444403351,
MagParam3 =34359738441,
MagParam4=257698037899,
MagParam5=7301444403363,
MagParam6=34359738447,
Variance=865920825
where ID64 =@Head
---------------
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =7301444403351,
MagParam4=7301444403363,
MagParam5=34359738441,
MagParam6=34359738447,
Variance=865920825
where ID64 =@CHEST
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
Variance=865920825
where ID64 =@SHOULDER
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
Variance=865920825
where ID64 =@HAND
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =7301444403351,
MagParam4=34359738447,
MagParam5=7301444403363,
MagParam6=34359738441,
Variance=865920825
where ID64 =@LEGS
-----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =858993459290,
MagParam2 =257698037898,
MagParam3 =34359738447,
MagParam4=34359738441,
Variance=865920825
where ID64 =@FOOT
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =85899346101,
MagParam3 =85899346095,
MagParam4 =85899346089,
MagParam5 =85899346107,
MagParam6 =34359738441,
Variance=825
where ID64 =@RING1
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =85899346101,
MagParam3 =85899346095,
MagParam4 =85899346089,
MagParam5 =85899346113,
MagParam6 =34359738441,
Variance=825
where ID64 =@RING2
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =85899346113,
MagParam4 =85899346107,
MagParam5 =85899346089,
MagParam6 =85899346101,
Variance=858
where ID64 =@NECK
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =85899346113,
MagParam4 =85899346107,
MagParam5 =85899346095,
MagParam6 =85899346089,
Variance=825
where ID64 =@ERRING
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =34359738447,
MagParam2 =34359738441,
MagParam3 =858993459291,
MagParam4 =429496729715,
Variance=28817845082
where ID64 =@WEP
update _Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =858993459291,
MagParam2 =34359738441,
MagParam3 =34359738447,
MagParam4 =429496729727,
MagParam5 =25769803981,
MagParam6 =25769803975,
Variance=900557658
where ID64 =@SHIELD
select * from _Inventory where CharID=@Charid and Slot between 0 and 12
|
Hello . i need a query for D9 :-?
|
|
|
06/27/2018, 23:16
|
#23
|
elite*gold: 0
Join Date: Apr 2012
Posts: 458
Received Thanks: 296
|
Edited a bit to be more good looking, also, you're now free to edit the variance easier from 0% to 100%.
If you want magparams for non-d11 servers:
(blue value in hex) * 10^(6+lenght of ID in hex) + (ID of blue in hex)
Example:
1300 HP, ID = 150 (d11)
in hex
HP 1300 -> 514
ID 150 -> 96
514 * 10^(6+2) + 96
514 + 100000000 + 96
51400000096
in dec
5583457484950
tadaa! you got your magparams for any degree. Now figure out how to implement it into a query (hint: format, sql 2012+)
Code:
/*Original author: Pur3viL
Edited by: JustNrik*/
USE SRO_VT_SHARD
DECLARE @CharID INT
DECLARE @ItemID INT
DECLARE @CharName VARCHAR(12)
DECLARE @PLUS TINYINT
DECLARE @HEAD INT
DECLARE @CHEST INT
DECLARE @LEGS INT
DECLARE @SHOULDER INT
DECLARE @HAND INT
DECLARE @FOOT INT
DECLARE @LRING INT
DECLARE @RRING INT
DECLARE @NECK INT
DECLARE @EARRING INT
DECLARE @WEAPON INT
DECLARE @SHIELD INT
DECLARE @VARIANCE BIGINT
SET @CharName = 'YourCharNameHere'
SET @PLUS = 7 -- Any plus FROM 0 to 255
SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName)
SET @HEAD = (SELECT ItemID FROM _Inventory WHERE Slot=0 AND CharID = @CharID)
SET @CHEST = (SELECT ItemID FROM _Inventory WHERE Slot=1 AND CharID = @CharID)
SET @LEGS = (SELECT ItemID FROM _Inventory WHERE Slot=4 AND CharID = @CharID)
SET @SHOULDER = (SELECT ItemID FROM _Inventory WHERE Slot=2 AND CharID = @CharID)
SET @HAND = (SELECT ItemID FROM _Inventory WHERE Slot=3 AND CharID = @CharID)
SET @FOOT = (SELECT ItemID FROM _Inventory WHERE Slot=5 AND CharID = @CharID)
SET @LRING = (SELECT ItemID FROM _Inventory WHERE Slot=11 AND CharID = @CharID)
SET @RRING = (SELECT ItemID FROM _Inventory WHERE Slot=12 AND CharID = @CharID)
SET @NECK = (SELECT ItemID FROM _Inventory WHERE Slot=10 AND CharID = @CharID)
SET @EARRING = (SELECT ItemID FROM _Inventory WHERE Slot=9 AND CharID = @CharID)
SET @WEAPON =(SELECT ItemID FROM _Inventory WHERE Slot=6 AND CharID = @CharID)
SET @SHIELD =(SELECT ItemID FROM _Inventory WHERE Slot=7 AND CharID = @CharID)
SET @VARIANCE = 34359738367
/*
Take this value: 1108378657
and multiply it from any number from 0 to 31, where:
31 = 100%, 25 = 80%, 19 = 61%, 13 = 41%, 7 = 22%, 0 = 0%
*/
UPDATE _Items
SET MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=@VARIANCE
WHERE ID64 IN (@HEAD, @CHEST, @LEGS)
----------------------
UPDATE _Items
SET MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=@VARIANCE
WHERE ID64 IN (@SHOULDER, @HAND, @FOOT)
UPDATE _Items
SET MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=@VARIANCE
WHERE ID64 IN (@LRING, @RRING, @EARRING, @NECK)
UPDATE _Items
SET MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=@VARIANCE
WHERE ID64 =@WEAPON
UPDATE _Items
SET MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=@VARIANCE
WHERE ID64 =@SHIELD
SELECT * FROM _Inventory WHERE CharID = @CharID AND Slot BETWEEN 0 AND 12 AND Slot != 8
|
|
|
01/30/2024, 23:59
|
#24
|
elite*gold: 0
Join Date: Jul 2023
Posts: 25
Received Thanks: 0
|
Can any one help with query can put in char inventory items nova dg11 that i choose type it like l.a,robe,h.a or chn pro, armor and weapons etc ..
thanks in advanced <3
|
|
|
02/03/2024, 13:39
|
#25
|
elite*gold: 0
Join Date: Jul 2023
Posts: 25
Received Thanks: 0
|
brother can you help with same query but it's up item's stats for 60% or 80% with out drubility just mag,phy, mag reinforce, phy reinforce , attack rate etc all items,acc's , weapons , thank you in advanced.
|
|
|
02/04/2024, 18:25
|
#26
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
Quote:
Originally Posted by kaka20315
brother can you help with same query but it's up item's stats for 60% or 80% with out drubility just mag,phy, mag reinforce, phy reinforce , attack rate etc all items,acc's , weapons , thank you in advanced.
|
its doable , just add and remove some lines ,
im sorry im not able to support .
|
|
|
All times are GMT +2. The time now is 00:32.
|
|