Checking users points

Involved Joined: Jul 25, 2006 Posts: 354

How can I see a list of current users and what points they currently have (from submitting website content etc.)

My points system works and everything and I have the lateste Ravennuke etc.

I just want to know how I can check how many points all users have in a list somewhere..

Thanks

Posted: Sun Sep 28, 2008 7:56 pm

I do not believe that there is a page were you can view this information. You would have to create a page to to do this or maybe modify the member list to show points (not to hard).

On a side not to any of the Ravennuke team guys. Maybe add points to the userinfo page of Your Account in 2.30.00? I see it is not there currently.

Posted: Mon Sep 29, 2008 8:27 am

Unfortunately it is probably too late for RN 2.30.00, but maybe for a later release. Wink

Posted: Mon Sep 29, 2008 8:28 am

In my opinion you will need to use an extra enhanced points module like I had before.
With this module almost everything was possible while later the included points system in higher nuke versions e.g. Nuke 7 + has changed and many said its not really a good point system.
There are pros and cons using a point system and if you have a site with x thousands of members there are sometimes more cons.
All the calls to the database stopped my Account module a time ago.
Maybe a question of coding.
In RavenNuke Your Account you can view every single user and of course his points.

Posted: Mon Sep 29, 2008 5:10 pm

wtf?

So how do I view someones points?

Posted: Mon Sep 29, 2008 6:15 pm

Check table nuke_users select the user click edit and scroll down until you see there points.Beneed this logged in as admin you will see also the points
using such url /userinfo-youruser.html

Posted: Mon Sep 29, 2008 8:08 pm

Are you talking about in the cpanel thing?

Or through admin in ravennuke

Worker Joined: Oct 05, 2003 Posts: 107 Location: Illinois

well you could make a module or a block to show it in. Modify this code into either one of those.

Code:

global $db, $prefix;


$query='SELECT username, user_id, points FROM '.$prefix."_users WHERE `user_id`>'1' ORDER BY `points` DESC LIMIT 99999999";


$result=$db->sql_query($query);


$content = "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td width=\"100%\" align=\"center\"><span class=\"content\"><b>Member</b></span></td><td align=\"center\"><span class=\"content\"><b>Points</b></span></td></tr>";


for($i = 1;$h = $db->sql_fetchrow($result);$i++)


{


$id = $h['user_id'];


$name = $h['username'];


$points = $h['points'];


$content .= "<tr><td align=\"left\"><span class=\"content\">$i: </span><a href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=$id\">$name</a></td><td align=\"center\"><span class=\"content\">$points</span></td></tr>";


}

Posted: Tue Sep 30, 2008 12:00 am

zomg srsly?

that will work?

registered · Posted: Tue Sep 30, 2008 6:20 am

pan wrote:

wtf?

So how do I view someones points?

Quite frankly, very few people use the points system. This is probably why it has never really been improved upon.

BTW, a little known tid-bit. If you are logged in as admin, you can see anyone's points by checking their Profile. For example, the following shows the profile with a username of 'montego':

userinfo-montego.html

Edit: Sorry, Raven's mod-rewrite rules messed with that URL. I have added a space in the module.php below to get the URL to show.

m odules.php?name=Your_Account&op=userinfo&username=montego

Posted: Tue Sep 30, 2008 4:50 pm

That seems to show up my points on every user instead of their own if i am logged in as user and admin

it shows 0 on everyone if logged in as admin only and no user login

Posted: Tue Sep 30, 2008 5:56 pm

Well, it requires that points are enabled and that an individual user has actually accumulated points. But, it is possible that there is a bug in pulling the count. One way to verify that for sure, though, it to go into phpMyAdmin, look up that user in the nuke_users table to see if their total points is really something other than 0. At least it would verify whether there really is a bug or not.

Posted: Wed Oct 01, 2008 5:45 pm

I know for sure they have points and I know for sure it all works.

Yet it still does as explained above.

Posted: Thu Oct 02, 2008 1:04 pm

i used to have an addon developed by me for one of my former websites that lists users and current points they have, ordered by points descending.

I'll take a look and try to find the addon, pack it and post back, so you can download it.

Posted: Thu Oct 02, 2008 3:32 pm

Thanks matey

Posted: Thu Oct 02, 2008 4:06 pm

Well I worked out how to confirm them in phpmyadmin so it doesn't matter so much anymore.

Thanks everyone for your help and patience.