EQEmulator Forums - Help: SQL to extract ldon pts from blob

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Help: SQL to extract ldon pts from blob (https://www.eqemulator.org/forums/showthread.php?t=29723)

Irreverent

10-06-2009 11:05 AM

Help: SQL to extract ldon pts from blob

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

Theeper

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

All times are GMT -4. The time now is 08:01 AM.