You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 47 guest(s) and 1 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - User Points Block [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Shadowlord_MU
Nuke Soldier
Nuke Soldier


Joined: May 06, 2003
Posts: 25


PostPosted: Tue May 27, 2003 3:14 am Reply with quoteBack to top

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>";

    }
}

?>
Find all posts by Shadowlord_MUView user's profileSend private messageVisit poster's website
ArtificialIntel



Joined: Jan 31, 2004
Posts: -88


PostPosted: Tue May 27, 2003 3:36 am Reply with quoteBack to top

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;
Find all posts by ArtificialIntelView user's profileSend private message
DemonAngel
Nuke Cadet
Nuke Cadet


Joined: Jun 18, 2003
Posts: 1


PostPosted: Wed Jun 25, 2003 6:16 am Reply with quoteBack to top

For Nuke 6.5 anyone have the database Table for the user points block?
Question
Find all posts by DemonAngelView user's profileSend private messageAIM AddressICQ Number
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by · TOGETHER TEAM srl ITALY http://www.togetherteam.it · DONDELEO E-COMMERCE http://www.DonDeLeo.com
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.322 Seconds - 313 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::