|
You last visited: Today at 05:16
Advertisement
12 DG İTEM FULL FB QUERY.
Discussion on 12 DG İTEM FULL FB QUERY. within the SRO Private Server forum part of the Silkroad Online category.
04/08/2016, 13:28
|
#1
|
elite*gold: 0
Join Date: May 2010
Posts: 92
Received Thanks: 1
|
12 DG İTEM FULL FB QUERY.
Need 12 DG 1700 HP MP Query
|
|
|
05/07/2016, 02:18
|
#2
|
elite*gold: 0
Join Date: May 2016
Posts: 113
Received Thanks: 13
|
Hey you here is the querry :
PHP Code:
[SPOILER]USE SRO_VT_SHARD
DECLARE @Charid int DECLARE [MENTION=1134588]item[/MENTION]ID int Declare @Charname VarChar(50) Declare [MENTION=954425]plus[/MENTION] int DECLARE [MENTION=291668]Head[/MENTION] int Declare @CHEST int DECLARE [MENTION=412764]legs[/MENTION] int DECLARE [MENTION=4433738]Shoulder[/MENTION] int DECLARE @HAND int DECLARE @FOOT int DECLARE [MENTION=1198794]ring[/MENTION]1 int DECLARE [MENTION=5959531]ring2[/MENTION] int DECLARE [MENTION=461653]neck[/MENTION] int DECLARE @ERRING int DECLARE [MENTION=795817]wep[/MENTION] int DECLARE [MENTION=662184]Shield[/MENTION] int
SET @Charname = 'name here' SET [MENTION=954425]plus[/MENTION] = '10' SET @Charid = (select CharID from _Char where CharName16=@Charname) SET [MENTION=291668]Head[/MENTION] = (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 [MENTION=412764]legs[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=4 and CharID=@Charid) SET [MENTION=4433738]Shoulder[/MENTION] = (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 [MENTION=1198794]ring[/MENTION]1 = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID=@Charid) SET [MENTION=5959531]ring2[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID=@Charid) SET [MENTION=461653]neck[/MENTION] = (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 [MENTION=795817]wep[/MENTION] =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=6 and CharID=@Charid) SET [MENTION=662184]Shield[/MENTION] =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=7 and CharID=@Charid)
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =7301444403351, MagParam3 =34359738441, MagParam4=257698037899, MagParam5=7301444403363, MagParam6=34359738447, Variance=865920825 where ID64 [MENTION=291668]Head[/MENTION] ---------------
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =257698037898, MagParam3 =7301444403351, MagParam4=7301444403363, MagParam5=34359738441, MagParam6=34359738447, Variance=865920825 where ID64 =@CHEST
----------------------
update _Items set MagParamNum=4, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =257698037898, MagParam3 =34359738447, MagParam4=34359738441, Variance=865920825 where ID64 [MENTION=4433738]Shoulder[/MENTION]
---------------------- update _Items set MagParamNum=4, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =257698037898, MagParam3 =34359738447, MagParam4=34359738441, Variance=865920825 where ID64 =@HAND
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =257698037898, MagParam3 =7301444403351, MagParam4=34359738447, MagParam5=7301444403363, MagParam6=34359738441, Variance=865920825 where ID64 [MENTION=412764]legs[/MENTION]
-----------------------
update _Items set MagParamNum=4, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459290, MagParam2 =257698037898, MagParam3 =34359738447, MagParam4=34359738441, Variance=865920825 where ID64 =@FOOT
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =34359738447, MagParam2 =85899346101, MagParam3 =85899346095, MagParam4 =85899346089, MagParam5 =85899346107, MagParam6 =34359738441, Variance=825 where ID64 [MENTION=1198794]ring[/MENTION]1
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =34359738447, MagParam2 =85899346101, MagParam3 =85899346095, MagParam4 =85899346089, MagParam5 =85899346113, MagParam6 =34359738441, Variance=825 where ID64 [MENTION=5959531]ring2[/MENTION]
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =34359738447, MagParam2 =34359738441, MagParam3 =85899346113, MagParam4 =85899346107, MagParam5 =85899346089, MagParam6 =85899346101, Variance=858 where ID64 [MENTION=461653]neck[/MENTION]
update _Items set MagParamNum=6, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =34359738447, MagParam2 =34359738441, MagParam3 =85899346113, MagParam4 =85899346107, MagParam5 =85899346095, MagParam6 =85899346089, Variance=825 where ID64 =@ERRING
update _Items set MagParamNum=4, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =34359738447, MagParam2 =34359738441, MagParam3 =858993459291, MagParam4 =429496729715, Variance=28817845082 where ID64 [MENTION=795817]wep[/MENTION]
update _Items set MagParamNum=3, optlevel [MENTION=954425]plus[/MENTION], MagParam1 =858993459291, MagParam2 =34359738441, MagParam3 =34359738447, MagParam4 =429496729727, MagParam5 =25769803981, MagParam6 =25769803975, Variance=900557658 where ID64 [MENTION=662184]Shield[/MENTION]
select * from _Inventory where CharID=@Charid and Slot between 0 and 12[/SPOILER]
whrer name ehre put your name and where is 10 put what + want and this querry add str int 8 hp mp 1700 all fb stats 83% check it
If help Press Thanks!
|
|
|
|
Similar Threads
|
[RELEASE] Query to full blue chars items one click
02/04/2024 - SRO PServer Guides & Releases - 25 Replies
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
--Auther Pur3viL
DECLARE @Charid int
DECLARE @ItemID int
|
Pet query Maker ( Full - Mini )
07/09/2019 - EO PServer Guides & Releases - 1 Replies
I found this tools in my pc XD
who still have problem with make query for their pets , can check this tools
1- is mini version make query for 3 ids only ( total is 5)
2- full one make query for 6 ids (total is 8 )
Download : https://www.mediafire.com/?frc8ylnfjemb6io
(the mini one is the same one like the one in UFM )
http://i.epvpimg.com/PH0ch.jpg
http://i.epvpimg.com/tRgld.jpg
http://i.epvpimg.com/z7L5f.jpg
|
Need Query Full Blue one char ?
05/15/2019 - SRO Private Server - 4 Replies
me need 1 query full blue one char . thax
|
[Release][Query] Query _InvCOS Items WITH _Char Connection
12/29/2015 - SRO PServer Guides & Releases - 1 Replies
Ok, so i needed to write this query for a procedure im working on and not many people know how to connect the pet inventory table to the character table.... so this query will explain how its done...
im not going to explain every single detail, like how there is no charcos when pet is despawned / dead... but yea you can probably figure that all out from this query...
The code...
USE
SELECT pet_invo.
,pet_invo. PetSlot
|
Full Query Serverside
04/26/2013 - Metin2 Private Server - 0 Replies
Hey ich habe unabsichtlich etwas aus der Item_Proto gelöscht jetzt habe ich probleme mit dem Server kann mir jemand von Serverside Query schicken mit allen Sachen plss!!!
Oder Export von DB!
PS: item_proto->Dump SQL-File->Speichern->item_proto.sql
Brauche die item_proto.sql
|
All times are GMT +2. The time now is 05:16.
|
|