[jim6763nva]

Originally Posted by Alien

I also noticed that it grabbed a wrong avatar for my tester.

Does this work with custom avatars? It grabbed an avatar the person does not have.

Ok, I installed this Guestbook on vb 3.7.3 and all seems to be working ok with exception of that it's not showing the right custom avatar. I took a moment and made a couple modifications to the MySQL query in the GuestBook.php file. I've done a few tests and it appears to be working correctly now. This should fix the issue for everyone else however I make no promises. If you would like to try making this same correction, then follow this:

1. Make a copy of your GuestBook.php file then open the orginial in your favorite text editor.

2. Look for the following query which should be around lines 153 - 157:

PHP Code:

SELECT guestbook.id, guestbook.userid, guestbook.yazan, guestbook.sehir, guestbook.site, guestbook.message, guestbook.not, 
              guestbook.tarih, guestbook.baslik, user.avatarid, user.avatarrevision, avatarpath,
       NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline
       FROM " . TABLE_PREFIX . "guestbook AS guestbook
       LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=guestbook.userid)
       LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid=guestbook.userid)
       LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid=guestbook.userid) 


3. Replace the previously mentioned query, with the one below:

PHP Code:

  SELECT guestbook.id, guestbook.userid, guestbook.yazan, guestbook.sehir, guestbook.site, guestbook.message, guestbook.not, guestbook.tarih, guestbook.baslik, user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL( customavatar.userid ) AS hascustomavatar, customavatar.dateline
  FROM " . TABLE_PREFIX . "guestbook AS guestbook
  LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = guestbook.userid
  LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON avatar.avatarid = user.avatarid
  LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON customavatar.userid = user.userid 


4. Save the Guestbook.php and upload it to your server.

It should be working now. If you feel uncomfortable about making edits to the file then feel free to download the attachement.

Jim