Register for your free account! | Forgot your password?

You last visited: Today at 17:03

  • Please register to post and access all features, it's quick, easy and FREE!


12 DG İTEM FULL FB QUERY.

Reply
 
Old   #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



ozzan32 is offline  
Old 05/07/2016, 02:18   #2
 
elite*gold: 0
Join Date: May 2016
Posts: 103
Received Thanks: 6
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[/MENTIONint 
DECLARE [MENTION=291668]Head[/MENTIONint 
Declare @CHEST int 
DECLARE [MENTION=412764]legs[/MENTIONint 
DECLARE  [MENTION=4433738]Shoulder[/MENTIONint 
DECLARE @HAND int 
DECLARE @FOOT int 
DECLARE  [MENTION=1198794]ring[/MENTION]1 int 
DECLARE  [MENTION=5959531]ring2[/MENTIONint 
DECLARE [MENTION=461653]neck[/MENTIONint 
DECLARE @ERRING int 
DECLARE  [MENTION=795817]wep[/MENTIONint 
DECLARE  [MENTION=662184]Shield[/MENTIONint 

SET 
@Charname 'name here' 
SET [MENTION=954425]plus[/MENTION] = '10' 
SET @Charid = (select CharID from _Char where CharName16[email protected]Charname
SET [MENTION=291668]Head[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET @CHEST = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET [MENTION=412764]legs[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET  [MENTION=4433738]Shoulder[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET @HAND = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET @FOOT = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET  [MENTION=1198794]ring[/MENTION]= (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=11 and CharID[email protected]Charid
SET  [MENTION=5959531]ring2[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=12 and CharID[email protected]Charid
SET [MENTION=461653]neck[/MENTION] = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=10 and CharID[email protected]Charid
SET @ERRING = (Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET  [MENTION=795817]wep[/MENTION] =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]Charid
SET  [MENTION=662184]Shield[/MENTION] =(Select ItemID from SRO_VT_SHARD.dbo._Inventory where Slot=and CharID[email protected]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 
[email protected]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 
[email protected]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 
[email protected]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]



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 
[email protected]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[email protected]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!


EQuiNoXsro is offline  
Reply



« how to make uniques attack ?? | Help me ! got crash when trade DW - HT »

Similar Threads
[RELEASE] Query to full blue chars items one click
06/27/2018 - SRO PServer Guides & Releases - 22 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
Need Query Full Blue one char ?
02/01/2016 - SRO PServer Ask the Experts - 3 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
Pet query Maker ( Full - Mini )
02/06/2015 - EO PServer Guides & Releases - 0 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
Full Query Serverside
04/26/2013 - Metin2 PServer - Discussions / Questions - 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 +1. The time now is 17:03.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.