Jump to content

Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. If you already have an account, login here - otherwise create an account for free today!


Rs Checker SQL logging Update

Recommended Posts

Today we will be releasing SQL logging for premium and soon deluxe users!

Why add this functionality?

For the past while we've utilized text files to log data. While this method works, it severely limits our ability to log details that could be very helpful for users. For example, if we wished to implement logging of all items in the bank, using text files would lead to massive files and unreadability for most users. 


The above screenshot shows the new data we are capturing by adding SQL logging support. Before, we only captured the value. Now users can check the exact items that are on an account whether it be by name or ID/amount.

The above logging has been done for: Equipment, Inventory and Grand Exchange.

Valid accounts are the only data being logged into the DB file at the moment. This is due to us needing to rewrite our account loading handler to support SQL should a user wish to move all logging over to it. This will be difficult as we wish to maintain backwards compatibility for users wishing to keep text file logging. 

Below contains the more detailed skills logging that we added as well. This will make it easy to find accounts with a certain skill.


Below contains the valids table where most data will be imported to.


Share this post

Link to post
Share on other sites

When using text file based logging, the format for valids is output such as:

New Format

"combo:RSN || "
+ "Members: %s || "
+ "TOTAL_LEVEL: %,d || "
+ "INVENTORY VALUE: %,d || "
+ "EQUIPPED VALUE: %,d || "
+ "BANK_VALUE: %,d || "
+ "G_E VALUE: %,d || "
+ "Pin: %s || "
+ "Combat_Lvl: %d || "
+ "Last_Login: %s || "
+ "Quests: %s || "
+ "Location: %s || "
+ "Account Type: %s || "
+ "Membership Days Left: %d || "
+ "Quest Points: %d || "
+ "Skills: %s || "
+ "Date Checked: %s || " 
+ "Info: %d || Error: %s",


Old Format

combo:rsn:total level:member:invent total:equip total:bank Total:exchange total:bank pin:combat level:last login:completed quests:location:account type:membership days left:quest points:skills:date checked:recieved packets:error during grab


RS3/OSRS Hiscore Lookup Format






Share this post

Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in

Sign In Now

  • Member Statistics

    Total Members
    Most Online
    Newest Member
  • Create New...