in macdonald previous post ...update the mylinks_top.php with this
// $Id: mylinks_top.php,v 1.11 2004/12/26 19:11:56 Onokazu Exp $ // ------------------------------------------------------------------------ // // XOOPS - PHP Content Management System // // Copyright (c) 2000 XOOPS.org // // // // ------------------------------------------------------------------------ // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // You may not change or alter any portion of this comment or credits // // of supporting developers from this source code or any supporting // // source code which is considered copyrighted (c) material of the // // original comment or credit authors. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // // ------------------------------------------------------------------------ // /****************************************************************************** * Function: b_mylinks_top_show * Input : $options[0] = date for the most recent links * hits for the most popular links * $block['content'] = The optional above content * $options[1] = How many reviews are displayes * Output : Returns the desired most recent or most popular links ******************************************************************************/ function b_mylinks_top_show($options) { global $xoopsDB; $block = array(); $myts =& MyTextSanitizer::getInstance(); $result = $xoopsDB->query("SELECT lid, cid, title, date, hits FROM ".$xoopsDB->prefix('mylinks_links')." WHERE status>0 ORDER BY ".$options[0]." DESC",$options[1],0); while($myrow = $xoopsDB->fetchArray($result)){ $link = array(); $title = $myts->makeTboxData4Show($myrow["title"]); if ( !XOOPS_USE_MULTIBYTES ) { if (strlen($myrow['title']) >= $options[2]) { $title = $myts->makeTboxData4Show(substr($myrow['title'],0,($options[2] -1)))."..."; } } $link['id'] = $myrow['lid']; $link['cid'] = $myrow['cid']; $link['title'] = $title; if($options[0] == "date"){ $link['date'] = formatTimestamp($myrow['date'],'s'); }elseif($options[0] == "hits"){ $link['hits'] = $myrow['hits']; } $block['links'][] = $link; } return $block; }
function b_mylinks_random( $options ) { global $xoopsDB; $block = array(); $myts =& MyTextSanitizer::getInstance(); $result = $xoopsDB -> query("SELECT lid, cid, title, url, logourl, date FROM " . $xoopsDB -> prefix('mylinks_links') . " WHERE status>0 ORDER BY RAND()"); while($myrow = $xoopsDB->fetchArray($result)){ $link = array(); $title = $myts->makeTboxData4Show($myrow["title"]); if ( !XOOPS_USE_MULTIBYTES ) { if (strlen($myrow['title']) >= $options[2]) { $title = $myts->makeTboxData4Show(substr($myrow['title'],0,($options[2] -1)))."..."; } } $link['id'] = $myrow['lid']; $link['cid'] = $myrow['cid']; $link['title'] = $title; $link['url'] = $myrow['url']; $link['logourl'] = $myrow['logourl']; $link['date'] = formatTimestamp($myrow['date'],'s'); $block['links'][] = $link; } return $block; }
global $xoopsDB; $sql = "SELECT uid, uname, user_avatar FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (1) AND user_avatar <> 'blank.gif' ORDER BY RAND() LIMIT 10"; $result = $xoopsDB->query($sql); while (list($uid, $uname,$user_avatar) = $xoopsDB->fetchRow($result) ) { echo ".$user_avatar."'alt='Avatar'> "; echo ".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname." "; }
admin is not included - uid NOT IN (1) user with no avatar not included - user_avatar <> 'blank.gif' show 10 random user RAND() LIMIT 10