Rs Checker SQL logging Update

[Admin 1,000]

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.

[Admin 1,000]

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

RS3:

combo,
RS3_total_level,
RS3_total_exp,
RS3_combat_level

OSRS:

combo,
OSRS_total_level
OSRS_total_exp