Help: SQL to extract ldon pts from blob

[Irreverent]

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

[Theeper]

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.


SELECT name, (ascii(mid(profile,7061,1)))+(ascii(mid(profile,70 62,1))*256)+(ascii(mid(profile,7063,1))*4096)+(asc ii(mid(profile,7064,1))*65536) as Guk FROM character_ WHERE id = 1