NineChime forum

Just above that line, check for this:

if ($use_c_avatars == 'yes' && $use_avatars == 'yes') {

Replace it with this:

if ($use_c_avatars == 'yes' && $use_avatars == 'yes' && $innerrow['usrname'] != 'Guest') {

Guest accounts (posts by non-members) are special because the name of the person making the post is not stored in the usrname field.  I overlooked that.

Not really.  If you're getting a "0 row" error for a registered member's account (not a guest), that usually means the database isn't set up right.  But, if that were the case, avatars wouldn't work at all.

Given that the standard index file is 520 lines long, it looks like you've added quite a bit of code.  If you don't mind, it may be best to send me a copy of your modified files, and I'll check them out.  My text editor, EditPlus2, has lots of great features for tracking down problems quickly that take forever to find with a PHP syntax check.

Do you have a web server set up on your computer or a text editor with syntax highlighting?  If not, I highly recommend them.

I don't know if it just stops working cold turkey, but trust me, EditPlus is well worth a try.  What I like most about it is that it's very fast, and doesn't clog your system registry with crap, so getting rid of it won't leave any junk behind on your system that will cause problems later on.  That tends to be a big problem with other trial software.

As for the index file, I sent you a new one, with a few coding tips.  If you have trouble with it, let me know.

If I wanted to calculate how old the drawing is, I can use that formula and subtract the age of the drawing (or comment from the current server time.

The proper way to do this is to get the date the drawing was posted as a UNIX timestamp, as follows:

$result = mysql_query ("SELECT UNIX_TIMESTAMP(posttime) FROM {$OekakiPoteto_Prefix}oekakidta WHERE PIC_ID='$resno'");

The UNIX_TIMESTAMP() function will get the time (in seconds) that the picture was posted, rather than a MySQL date string.

You can then do:

$age_in_seconds = time() - $row['posttime']

If $age_in_seconds is "86400", you know the image is 1 day old.