Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks
Author Message
corporalstorm
Hangin' Around


Joined: Nov 06, 2006
Posts: 46

PostPosted: Sat Jun 09, 2007 12:29 am Reply with quote

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>&middot;</big></strong>&nbsp;<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?!
 
View user's profile Send private message
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Sat Jun 09, 2007 10:05 am Reply with quote

Your $content = statement should be $content .=

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

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©