Yui
07-05-2013, 01:16 PM
Hello Silkroad4arab
this Query by Yui
Query to back all item to +20 or change 20 to any thing you want
UPDATE _Items
SET OptLevel = 20
WHERE OptLevel BETWEEN '20' and '50'
Query to show how much GM in your server
USE SRO_VT_ACCOUNT
/*****Yui4host ** Skype (valikiemagic)***/
SELECT *FROM [dbo].[TB_User]
WHERE sec_primary BETWEEN '1' and '1'
Query to show hwanLevel (Zerk) change 1 and 10 to any thing you want
USE SRO_VT_SHARD
/*****Yui4host ** Skype (valikiemagic)***/
SELECT *FROM [dbo].[_Char]
WHERE HwanLevel BETWEEN '1' and '10'
this Query by Yui
Query to back all item to +20 or change 20 to any thing you want
UPDATE _Items
SET OptLevel = 20
WHERE OptLevel BETWEEN '20' and '50'
Query to show how much GM in your server
USE SRO_VT_ACCOUNT
/*****Yui4host ** Skype (valikiemagic)***/
SELECT *FROM [dbo].[TB_User]
WHERE sec_primary BETWEEN '1' and '1'
Query to show hwanLevel (Zerk) change 1 and 10 to any thing you want
USE SRO_VT_SHARD
/*****Yui4host ** Skype (valikiemagic)***/
SELECT *FROM [dbo].[_Char]
WHERE HwanLevel BETWEEN '1' and '10'