New Query for SQL silkroad server

[Yui]

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'