View Single Post
  #2  
Old 12-31-2012, 12:41 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

It's in the profile blob.

This SQL query calculates the 'time entitled on the account' by summing up the time played in minutes across all characters on an account, so you may be able to adapt it for your needs:
Code:
select sum(ascii(substring(profile, 237, 1)) + (ascii(substring(profile, 238, 1)) * 256) +
          (ascii(substring(profile, 239, 1)) * 65536) + (ascii(substring(profile, 240, 1)) * 16777216))
          from character_ where account_id = %i;
Reply With Quote