User Points Block

Nuke Soldier Joined: May 06, 2003 Posts: 25

I need this block for PHP-Nuke 6.5, but I only obtained for 5.x...

Somebody can help me?

Code:

<?php

/********************************************************/
/* block-User_Points.php vs. 1.0 */
/* Written by: complex-berlin.de */
/* http://www.complex-berlin.de */
/* */
/* This program is opensource, so you can do whatever */
/* you want with it. */
/********************************************************/

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

{
global $cat, $multilingual, $prefix, $dbi;

$result = sql_query("select * from $prefix"._userpoints." order by punkte desc limit
0,10", $dbi);
$numrows = sql_num_rows($result, $dbi);
if ($numrows == 0) {
return;
} else {
$content .= "<table>";
$i=1;
while(list($userid, $punkte) = sql_fetch_row($result, $dbi)) {
$result2=sql_query("select uname from $prefix"._users." where
uid='$userid'", $dbi);
$userd=sql_fetch_array($result2, $dbi);
$name = $userd["uname"];
if(($name!="Anonymous") AND ($name!="Anonymous")) $content.= "<tr><td><small>$i-<a
href=modules.php?name=Your_Account&op=userinfo&uname=$name>$name</td><td align=\"right\"><small> $punkte</td></tr>";

if(($name!="Anonymous") AND ($name!="Anonymous")) $i++;
}

$content .= "</tr></table>";
$content.= "<center><small><a href=top.html#POINT><bR>"._ALLMEMBERS."</a></center></font>";

}
}

?>

Joined: Jan 31, 2004 Posts: -88

change this bit:

Code:

$result2=sql_query("select uname from $prefix"._users." where
uid='$userid'", $dbi);
$userd=sql_fetch_array($result2, $dbi);
$name = $userd["uname"];
if(($name!="Anonymous") AND ($name!="Anonymous")) $content.= "<tr><td><small>$i-<a
href=modules.php?name=Your_Account&op=userinfo&uname=$name>$name</td><td align=\"right\"><small> $punkte</td></tr>";

to

Code:

$result2=$db->sql_query("select username from $prefix"._users." where
user_id='$userid'");
$userd=$db->sql_fetchrow($result2);
$name = $userd["username"];
if(($name!="Anonymous") AND ($name!="Anonymous")) $content.= "<tr><td><small>$i-<a
href=userinfo-.html$name>$name</td><td align=\"right\"><small> $punkte</td></tr>";

Also, change

Code:

global $cat, $multilingual, $prefix, $dbi;

to

Code:

global $cat, $multilingual, $prefix, $db, $dbi;

Nuke Cadet Joined: Jun 18, 2003 Posts: 1

For Nuke 6.5 anyone have the database Table for the user points block?
Question