[sv1cec]

Originally Posted by eXtremeTim

This is simple to fix I just fixed it on my site.

do the following

Find in member.php

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $bbuserinfo[teamid]
        "); 


Replace with

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $userinfo[teamid]
        "); 


Miz if you want I can release all the changes I did to my files to your for your next version so that you have a load optimized version. My sites url is http://www.extremechatforums.com/forums/index.php I cleaned up the code on forumdisplay using left joins. I cleaned up the code for showthread (required changes to showthread and functions_showthread) I also cleaned up the not in team list which now runs at 11 (4 of which are from some stats tracking code im using on my site so its really 7 queries) queries on my site no matter how many users as displayed.

Sorry, but aren't these two pieces of code the same? Unless I am too tired right now!

Rgds :-)