Random Members Block

Private Joined: Jan 13, 2003 Posts: 46 Location: Canada

I'm hoping to create a block that displays member information randomly each time the page is refreshed.

I've used snippets of code from other blocks, modules, etc. that do work. You can see it not working at http://www.compytec.com, bottom left block called "testing." I'm only getting an empty block. Any ideas?

Code:

<?php

if (eregi("block-Random_Member.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}

global $prefix, $uname, $url, $user_avatar, $user_from, $user_interest, $dbi;

// Create the random id for the user
$result = mysql_query("SELECT COUNT(*) FROM $prefix"._users."");
$users_count = mysql_fetch_array($result);
$users_count = $users_count[0];

// only proceed if we have user in the database
if ($users_count > 0) {
if ($users_count == 1) {
$random = 0;
} else {
srand((double)microtime()*1000000);
$random = rand(0,$users_count - 1);
}
// Now that we have the random number we can pull out the record
$result = mysql_query("SELECT * FROM $prefix"._users." LIMIT $random,1");
$myrow = mysql_fetch_row($result);
$content .= '<center>';

while ($myrow = mysql_fetch_array($result)) {

printf(" %s %s %s %s %s %s \n",
$myrow["user_avatar"], $myrow["uname"], $myrow["url"], $myrow["user_avatar"], $myrow["user_from"], $myrow["user_interest"]);
}

//close the formatting
$content .= '</center>';
} else {

// this is what we say when the user database is empty
$content = "NoMoreUsers";
}

?>

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Try this... (I took a short look):

Code:

<?php

if (eregi("block-Random_Member.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}

global $prefix, $uname, $url, $user_avatar, $user_from, $user_interest, $dbi;

// Create the random id for the user
$result = mysql_query("SELECT COUNT(uid) FROM ".prefix."_users", $dbi);
$users_count = mysql_fetch_array($result);
$users_count = $users_count[0];

// only proceed if we have user in the database
$random = 0;
if ($users_count) {
srand((double)microtime()*1000000);
$random = rand(0,$users_count - 1);
}
// Now that we have the random number we can pull out the record
$result = mysql_query("SELECT user_avatar, uname, url, user_from, user_intrest FROM ".$prefix."_users LIMIT $random,1", $dbi);
$myrow = mysql_fetch_row($result);
$content .= '<center>';

while (list($user_avatar, $uname, $url, $user_from, $user_intrest) = mysql_fetch_array($result)) {

printf(" %s %s %s %s %s %s \n",
$myrow["user_avatar"], $myrow["uname"], $myrow["url"], $myrow["user_avatar"], $myrow["user_from"], $myrow["user_intrest"]);
}

//close the formatting
$content .= '</center>';
} else {

// this is what we say when the user database is empty
$content = "NoMoreUsers";
}

?>

Private Joined: Jan 13, 2003 Posts: 46 Location: Canada

At first I was getting a syntax error in that else statement at the bottom. So I removed it. Now:

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/compytec.com/httpdocs/blocks/block-Random_Member.php on line 13, in this bit.

Code:

// Create the random id for the user
$result = mysql_query("SELECT COUNT(uid) FROM ".prefix."_users", $dbi);
$users_count = mysql_fetch_array($result);
$users_count = $users_count[0];

Could the result be not valid because of empty fields?

Private Joined: Jan 13, 2003 Posts: 46 Location: Canada

How difficult could this block be?? Am I missing something obvious or just clueless.

Does it make sense to develop the block output first, then, once that works, add the code to make it random? Or should it be a more organic process, one doesn't work without the other?

The random isn't working. Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/compytec.com/httpdocs/blocks/block-Random_Member.php on line 13, in this bit.

[code]

global $prefix, $uname, $url, $user_avatar, $user_from, $user_intrest, $dbi;
// Create the random id for the user
$result = mysql_query("SELECT COUNT (uid) FROM ".prefix."_users", $dbi);
/* 13 */ $users_count = mysql_fetch_array($result);
$users_count = $users_count[0];

// only proceed if we have user in the database
$random = 0;
if ($users_count) {
srand((double)microtime()*1000000);
$random = rand(0,$users_count - 1);
}