Character "profile"

[Cailin]

OK, thanks for that. I'll keep it all in mind.

[fathernitwit]

yes, this structure changes nearly every patch. Normally it is just expanded with unknown stuff, but sometimes it changes more dramatically.

If you wanna edit it in php, you going to have to get framiliar with 'unpack' in php.. and write a VERY long unpack description based on the struct ranger pointed out.

on the other hand, people would love to have this tool. I hear requests for things like it all the time. (expecially by rangerdown )

[Rogean]

$Query = mysql_query("SELECT id,name,guild,guildrank,zonename, 
	 (ascii(mid(profile,117,1)))+(ascii(mid(profile,118,1))*256)+(ascii(mid(profile,119,1))*4096)+(ascii(mid(profile,120,1))*65536) as level,
	 (ascii(mid(profile,105,1)))+(ascii(mid(profile,106,1))*256)+(ascii(mid(profile,107,1))*4096)+(ascii(mid(profile,108,1))*65536) as race,
	 (ascii(mid(profile,109,1)))+(ascii(mid(profile,110,1))*256)+(ascii(mid(profile,111,1))*4096)+(ascii(mid(profile,112,1))*65536) as pclass,
	 (ascii(mid(profile,101,1)))+(ascii(mid(profile,102,1))*256)+(ascii(mid(profile,103,1))*4096)+(ascii(mid(profile,104,1))*65536) as gender,
	 (ascii(mid(profile,164,1))) as gm,
	 (ascii(mid(profile,165,1))) as anon,
	 mid(profile,69,30) as lastname,
	 profile
	 FROM character_ WHERE id = $charid");
	 
$Char = mysql_fetch_array($Query);

Theres something that should help you out a bit. Took it from the Raid Addicts panel I made.

[RangerDown]

LOL FNW. I don't request a profile blob editor so much as I request getting entirely rid of the blob from the database and save character data in relational db fields/tables like the Good Lord intended a relational db to be used

(And for anyone who takes that seriously, there are issues around doing it that way -- not the least of which are possible impact on server performance, reliably saving multiple fields/tables, and just the sheer amount of work that would go into overhauling that.)

Rogean, that's a clever way of using the blob. For the same reasons I mentioned earlier though, don't necessarily expect the fields he's extracting to be in the same positions they were when that was written. He said that was from his RaidAddicts... so it was... some time ago :P