View Single Post
  #1  
Old 10-06-2009, 08:00 PM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default

Here's a simple hackish query I use for quickly pulling stuff from the pp blob. I can't test it right now, but it should work. Take a look at the profile struct and match the field lengths for each item you want.

I stole this method from Rogean (I think it was) some time ago.


Code:
SELECT name, (ascii(mid(profile,7061,1)))+(ascii(mid(profile,7062,1))*256)+(ascii(mid(profile,7063,1))*4096)+(ascii(mid(profile,7064,1))*65536) as Guk FROM character_ WHERE id = 1
Reply With Quote