Here's basically what I did:
Code:
$query = "SELECT profile FROM character_ WHERE name='$pp'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$lastname = GetNulLTermString(substr($row[0],34,20));
That gets the lastname
For inventory slots where I used unpack...
Code:
array($inventory);
$inventory = unpack("v30slot",substr($row[0],168,60));
That made:
Code:
$inventory["slot1"];
$inventory["slot2"];
$inventory["slot3"];
...
$inventory["slot30"];
Hope this helps