Register for your free account! | Forgot your password?

You last visited: Today at 15:43

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

Advertisement



query silk history

Discussion on query silk history within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2013
Posts: 99
Received Thanks: 8
Unhappy query silk history

Hello,
as topic is anyone know a query or table i can check the Silk purchases history or i can know who get silk in any day ?.
tk69ok is offline  
Old 03/07/2014, 16:14   #2

 
AceSpace's Avatar
 
elite*gold: 21
Join Date: Mar 2011
Posts: 1,613
Received Thanks: 1,122
Explain more please. What do you need this history for? Silk purchases? Silk per hour? If it was silk per hour then It has already a log table.
AceSpace is offline  
Old 03/07/2014, 16:32   #3
 
elite*gold: 0
Join Date: Oct 2013
Posts: 99
Received Thanks: 8
Quote:
Originally Posted by ˛˛Rock˛˛ View Post
Explain more please. What do you need this history for? Silk purchases? Silk per hour? If it was silk per hour then It has already a log table.
thank you rock it is Silk purchases,can you help me?.

up
tk69ok is offline  
Old 03/07/2014, 19:27   #4
 
elite*gold: 0
Join Date: Feb 2008
Posts: 340
Received Thanks: 72
select * from SK_PackageItemSaleLog where JID=YOU_JID_HERE
This will show what Cash item was purchased from that account on all characters.
pushipu is offline  
Thanks
1 User
Old 03/07/2014, 20:58   #5
 
elite*gold: 0
Join Date: Oct 2013
Posts: 99
Received Thanks: 8
Quote:
Originally Posted by pushipu View Post
select * from SK_PackageItemSaleLog where JID=YOU_JID_HERE
This will show what Cash item was purchased from that account on all characters.
Thank you pushipu
tk69ok is offline  
Reply


Similar Threads Similar Threads
Add silk with history log and more
11/22/2012 - SRO PServer Guides & Releases - 5 Replies
Hello, Everyone I created new tool to help you to find silk history by user name and calculate how many silk user charged. there is 2 options more for change hwn level and give character gold or edit the gold value. Virustotal Character Modifier ver1.rar
[Help] Want query or a method to close off exchanging silk items.
06/02/2012 - SRO Private Server - 4 Replies
-Want query or a method to close off exchanging silk items any help guys?:o
Query for adding silk for new accounts
04/27/2012 - SRO PServer Guides & Releases - 1 Replies
Hi Guy's :mofo: $ jidque = @ mssql_fetch_array (@ mssql_query ("SELECT * FROM WHERE dbo.TB_User StrUserID = '$ user'")); jidque realjid = $ $ ; $ silkver = mssql_query ("INSERT INTO SK_Silk (JID, Silk_own) values ​​('$ realjid', '1000000 ')"); yourself who is the name of the variable $ user to record, edit account id. '1000000 'Is the amount of silk box unchecked in the record section of your website, add and change.
[Query] Add Silk To all Registered users
03/10/2012 - SRO Private Server - 4 Replies
Hello , (resume to queries threads) Just a very simple query to add amount of silk to all registered users /***********Wrote by Dr.Abdelfattah***********/ USE SRO_VT_ACCOUNT; GO INSERT INTO SK_SILK (JID, silk_own,
Query To Change Item Mall Silk Price
02/12/2012 - SRO Private Server - 3 Replies
here is the query forgot : change the xx with the silk price



All times are GMT +1. The time now is 15:46.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.