| Re: Random Member ... ? |
| by antifmradio on 2008/7/22 23:13:56 Quote:
this works really well for me ill adjust the Quantity of listed members but how can i allow ADMIN to show up? |
| Re: Random Member ... ? |
| by mjoel on 2007/11/15 3:22:05 Bingo !! le="color: #000000"><?php 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 "<img src='./uploads/".$user_avatar."'alt='Avatar'></a><br />"; echo "<a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a><br />"; } 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 |
| Re: Random Member ... ? |
| by mjoel on 2007/11/14 15:17:10 le="color: #000000"><?php $member_handler = xoops_gethandler('member'); $criteria = new CriteriaCompo(new Criteria('level', '0', '>')); $criteria->setSort('RAND()'); $criteria->setLimit(10); $users = $member_handler->getUserList($criteria); foreach ($users as $uid => $uname) { echo "<a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a><br />"; } can someone help me to update this code to include avatar |
| Re: Random Member ... ? |
| by Cuidiu on 2006/12/15 22:20:28 Ah, success! The first set of code worked. Thank you for giving in, Mith. I did spend time searching through similar code and trying to work it through but my attempts failed. I want to learn more PHP so that I don't have to bug you nice folks as much, but my day job keeps getting in the way! Please know your help is much appreciated! C Quote:
|
| Re: Random Member ... ? |
| by Mithrandir on 2006/12/15 21:53:45 ok, I give in. This should work: le="color: #000000"><?php $member_handler = xoops_gethandler('member'); $criteria = new CriteriaCompo(new Criteria('level', '0', '>')); $criteria->add(new Criteria('uid', "(1,4,215)", "NOT IN") ); $criteria->setSort('RAND()'); $criteria->setLimit(10); $users = $member_handler->getUserList($criteria); foreach ($users as $uid => $uname) { echo "<a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a><br />"; } or if it doesn't, this should: le="color: #000000"><?php global $xoopsDB; $sql = "SELECT uid, uname FROM ".$xoopsDB->prefix("users")." WHERE level > 0 AND uid NOT IN (1,4,215) ORDER BY RAND() LIMIT 10"; $result = $xoopsDB->query($sql); while (list($uid, $uname) = $xoopsDB->fetchRow($result) ) { echo "<a href='".XOOPS_URL."/userinfo.php?uid=".$uid."'>".$uname."</a><br />"; }
|
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|