EQEmulator Forums - View Single Post - slash play, playing time location in database?

revloc02c · #4 12-31-2012, 02:07 PM

The sum function had me stumped for a bit so I am posting my version for posterity.

Code:

select id, account_id, name, zoneid, class, level, 
	ascii(substring(profile, 237, 1)) + (ascii(substring(profile, 238, 1)) * 256) + (ascii(substring(profile, 239, 1)) * 65536) + (ascii(substring(profile, 240, 1)) * 16777216) AS 'Play Time Minutes'
	from character_;

Thanks again Derision.