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!

Admin

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. 

image.png

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.

image.png

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

3a12dc962e1279bf613b050a03008273.gif

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

"%s:"//combo
+ "%s:"//rsn
+ "%d:"//total level
+ "%s:"//member
+ "%,d:"//invent total
+ "%,d:"//equip total
+ "%,d:"//bank Total
+ "%,d:"//exchange total
+ "%s:"//bank pin
+ "%d:"//combat level
+ "%s:"//last login
+ "%s:"//completed quests
+ "%s:"//location
+ "%s:"//account type
+ "%d:"//membership days left
+ "%d:"//quest points
+ "%s:"//skills
+ "%s:"//date checked
+ "%d:"//recieved packets
+ "%s", //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

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Posts

    • 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 "%s:"//combo + "%s:"//rsn + "%d:"//total level + "%s:"//member + "%,d:"//invent total + "%,d:"//equip total + "%,d:"//bank Total + "%,d:"//exchange total + "%s:"//bank pin + "%d:"//combat level + "%s:"//last login + "%s:"//completed quests + "%s:"//location + "%s:"//account type + "%d:"//membership days left + "%d:"//quest points + "%s:"//skills + "%s:"//date checked + "%d:"//recieved packets + "%s", //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  
    • Heard wonderful things about this one, let's try it out
    • OSRS accs: select by stats, any quests , account inactivity, etc RS3 accs: select by stats prices negotiable pm fouston100#7999 on discord    
    • you still selling 9hp ironman?
  • Topics

  • Member Statistics

    192
    Total Members
    72
    Most Online
    ApeBehavior
    Newest Member
    ApeBehavior
    Joined
×
×
  • Create New...