Help: SQL to extract ldon pts from blob

Irreverent · #1 10-06-2009, 11:05 AM

Can anyone give me an example code to do a query against ldon pts? Lets use GUK as the example please.

Theeper · #2 10-06-2009, 08:00 PM

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