|
You last visited: Today at 01:25
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.
07/30/2015, 21:08
|
#1
|
elite*gold: 1020 
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
[RELEASE] Query to full blue chars items one click
Hello , its might be old or some one release it befor but i did not find it some where when i needed some thing like it
so created it maybe its usefull for any one
PHP Code:
--Auther Pur3viL
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 = '7'
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 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@Head
---------------
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@CHEST
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 =@SHOULDER
----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 =@HAND
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where ID64 =@LEGS
-----------------------
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=865920825
where ID64 =@FOOT
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@RING1
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@RING2
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@NECK
update _Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=858
where ID64 =@ERRING
update _Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=28817845082
where ID64 =@WEP
update _Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=900557658
where ID64 =@SHIELD
select * from _Inventory where CharID=@Charid and Slot between 0 and 12
|
|
|
|
07/30/2015, 21:50
|
#2
|
elite*gold: 0
Join Date: Sep 2014
Posts: 469
Received Thanks: 222
|
Nice one (y)
|
|
|
|
|
07/31/2015, 03:43
|
#3
|
elite*gold: 100
Join Date: Jul 2015
Posts: 27
Received Thanks: 2
|
nice query
|
|
|
|
|
08/03/2015, 16:05
|
#4
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
you welcome
|
|
|
|
|
08/04/2015, 13:25
|
#5
|
elite*gold: 0
Join Date: Mar 2015
Posts: 30
Received Thanks: 5
|
it's very helpfull but can you edit it for D12 items
1700 hp and mp
8 str and INT
or tell me how thats will be very kind of you 
|
|
|
|
|
08/04/2015, 20:40
|
#6
|
elite*gold: 150
Join Date: Sep 2009
Posts: 979
Received Thanks: 252
|
Quote:
Originally Posted by mohamedbebo999
it's very helpfull but can you edit it for D12 items
1700 hp and mp
8 str and INT
or tell me how thats will be very kind of you
|
First ty for the query it can be a very helpful scroll
2nd about mohamedbebo999 u can edit parms as u like
|
|
|
|
|
08/05/2015, 12:19
|
#7
|
elite*gold: 0
Join Date: Mar 2015
Posts: 30
Received Thanks: 5
|
Im New can you make it plz
|
|
|
|
|
08/05/2015, 13:09
|
#8
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
Quote:
Originally Posted by mohamedbebo999
it's very helpfull but can you edit it for D12 items
1700 hp and mp
8 str and INT
or tell me how thats will be very kind of you
|
well , i will explain how coz i have no time to edit it for d12 since i dont need it
so here we go
well , u can use ur smc to full blue a item d12 , then get the prams from the smc
change the prams in the query and done
|
|
|
|
|
08/05/2015, 17:50
|
#9
|
elite*gold: 0
Join Date: Mar 2015
Posts: 30
Received Thanks: 5
|
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
|
|
|
|
|
08/06/2015, 09:47
|
#10
|
elite*gold: 0
Join Date: Jun 2015
Posts: 65
Received Thanks: 41
|
shity query -,-
|
|
|
|
|
08/06/2015, 17:10
|
#11
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
Quote:
Originally Posted by Excods
shity query -,-
|
should i care ?
|
|
|
|
|
08/08/2015, 01:53
|
#12
|
elite*gold: 0
Join Date: Aug 2015
Posts: 116
Received Thanks: 44
|
good query
|
|
|
|
|
08/22/2015, 05:03
|
#13
|
elite*gold: 0
Join Date: Dec 2007
Posts: 241
Received Thanks: 16
|
Any one have PARAM to D10 Itens ? STR / INT 6 - HP/MP 850 - ??
|
|
|
|
|
08/23/2015, 03:43
|
#14
|
elite*gold: 1020
Join Date: Dec 2013
Posts: 904
Received Thanks: 434
|
Quote:
Originally Posted by spinal2
Any one have PARAM to D10 Itens ? STR / INT 6 - HP/MP 850 - ??
|
get it from smc
|
|
|
|
|
08/25/2015, 19:02
|
#15
|
elite*gold: 0
Join Date: Jul 2015
Posts: 66
Received Thanks: 18
|
Nice Query 
|
|
|
|
All times are GMT +2. The time now is 01:25.
|
|
![[RELEASE] Query to full blue chars items one click](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-query-full-blue-chars-items-one-click_ltr.gif){kind=small}
