Quote:
Originally Posted by putyn
hint LEFT JOIN
|
I like to use this to like so
PHP Code:
$sql = "SELECT S.*, U.id as uid, U.can_do as can_do, U.donator AS donator, U.warned as warned, U.level as level, IF(U.name IS NULL, U.username, U.name) as user_name FROM ".$db_prefix."_shouts S LEFT JOIN ".$db_prefix."_users U ON S.user = U.id WHERE S.id_to = '0' OR S.id_to = '".$user->id."' OR (S.user = '".$user->id."' AND S.id_to >'0') ORDER BY posted DESC LIMIT ".$shout_config['shouts_to_show']."";
it dont slow it down no extra querys
and as for enlarging you shout box all you would have to do is make the avatar a set size
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in
BT.Manager™ forum
My Current Demo is here
http://demo.btmanager.org/