So, I was going to try & convert my profile viewer (in PHP) into Perl so that it can be incorporated into the World HTTP Server, but I'm a little stuck.
When I query the character_ table with the following:
Code:
my $q = "SELECT name, profile, level, extprofile FROM character_ WHERE id=".$request->getInt("charid", 0);
my $res = $EQDB->query($q);
if ($res) {
my $row = $res->fetch_row_hash;
}
and try to access the profile blob via
$row->{profile} (
as advised in the Wiki), it only returns the first few characters of the blob.
After checking the profile itself, it seems to stop at the first null character (0x00). I guess the question then becomes, what's causing it to stop there? Once I can get that figured out, dissecting the blob will be easy.
Any thoughts?