i need to know how much silk

11/28/2016 15:08 mohamedbebo99#1

i need to know how much silk in my server in every char

some players got silk i want to know how much

how to know the amount

11/28/2016 15:22 NoIdeaForAName#2

Why would you open a server if you don't know the basics?
Easy way : Open the SK_Silk table from your account database.

Another method :

PHP Code:


			
USE
SRO_VT_ACCOUNT -- or however your account database is called
SELECT silk_own, silk_gift, silk_point FROM SK_Silk WHERE JID like '%'

Then, if you want to simply find the JID :

PHP Code:


			
USE
SRO_VT_ACCOUNT -- or however your account database is called
SELECT JID FROM SK_Silk WHERE silk_own like '%' -- % is the amount, silk_own can be replaced with silk_gift or silk_point

Like, seriously, I don't even know SQL and I'm able to do it.

11/28/2016 19:43 PlayTaurus#3

Quote:

Originally Posted by NoIdeaForAName

Why would you open a server if you don't know the basics?
Easy way : Open the SK_Silk table from your account database.

Another method :

PHP Code:

USE SRO_VT_ACCOUNT -- or however your account database is called SELECT silk_own, silk_gift, silk_point FROM SK_Silk WHERE JID like '%'

Then, if you want to simply find the JID :

PHP Code:

USE SRO_VT_ACCOUNT -- or however your account database is called SELECT JID FROM SK_Silk WHERE silk_own like '%' -- % is the amount, silk_own can be replaced with silk_gift or silk_point

Like, seriously, I don't even know SQL and I'm able to do it.

Just take a look on SK_Silk table ( in the database "SRO_VT_ACCOUNT" ).
You will find there the silks amount of every user, and his JID.
For finding the username of the JID, you have to use that query:

PHP Code:


			
select top 1 StrUserID from SRO_VT_ACCOUNT.dbo.TB_User where JID = THE_JID

Replace "THE_JID" with the JID number, and you the result will be the username of the JID.

11/28/2016 20:03 janicka#4

lol better close youre server if you must ask for this.....

11/28/2016 22:05 mohamedbebo99#5

thx guys for the help

but this is for asking the expert and thats what i did

you dont have to be mean just tell me the info and i will say thx i think no one of you guys born as expert in Vsro servers

thx again guys for your help thats was useful

11/30/2016 19:55 Spidy.#6

^

#Closed