i need to know how much silk

[mohamedbebo99]

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

[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.

[PlayTaurus]

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.

[janicka]

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

[mohamedbebo99]

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

[Spidy.]

^

#Closed