Block not working now

corporalstorm · Hangin' Around Joined: Nov 06, 2006 Posts: 46

I've ported most of my site over but I'm havig a problem with this block that worked with PHP Nuke 8.. I don't know if some coding changed or if MySQL 5.0 is way different then what I'm use to.. I looked in my book and it appears right.. Any ideas? I keep getting no content for this block message.

Code:

<?PHP

if ( !defined('BLOCK_FILE') ) {
Header('Location: ../index.php');
die();
}

global $prefix, $db;

$result = $db->sql_query("SELECT uname, uid FROM ".$prefix."_nsngr_users WHERE gid = '2', uid > '0' ORDER BY uname ASC");
while ($row = $db->sql_fetchrow($result)) {
$title = filter($row['uname'], "nohtml");
$uid = filter($row['uid']);
$content = "<strong><big>·</big></strong> <a href=\"/modules.php?name=Private_Messages&mode=post&u=$uid\">$title</a><br>";

}

?>

What I'm doing is.. The block is for Guild Officers.. If the user is in the Guild Office Group which has GID of "2" and UID of "0".. I'm telling it to grab the uname and gid from nuke_nsngr_users to print the user in alphabetical order to show who our Guild Officers are.. It works flawlessly in PHP Nuke 8..

What'd I do wrong?!

Gremmie · Posted: Sat Jun 09, 2007 10:05 am

Your $content = statement should be $content .=

I would also try changing the SQL to 'WHERE gid = 2 AND uid > 0'