Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> CZ Points Module

Register

I have been searching the archives on the site and have not found any info related to this minor sorting problem in the CZ Points Module.

Observation: Seems like the User with the most amount of POINTS is being dropped off the list when you click on the Points link in the Navigation block.

I was able to verify this by changing the points manually for the top user to fall below the second highest user. When I did that the second higher user was not shown but the previous highest user was. In other words ALL members show EXCEPT the very highest member with the highest Point score. (not post score). Since the sort appears to be done in DECENDING ORDER on the POINTS column, the error must be in the way the sort is initiated. I am not an expert coder but perhaps a < might need to be a < = somewhere since the highest value is being lost in the sort.

THe problem is in the index. p h p file in the CZ Points Module. (Which otherwise has been excellent since I loaded it last evening. If there was a patch to the bug please advise...

I will try to do version 2.0. I have a few other things I want to add to it too.

Register

Hi Telli ---

I think I isolated the problem and corrected it for you.

Module: CZ Points v.1.0.0

Corrected code in / around line 232 in the index. p h p file :

/* Top Points */
$sql = "SELECT * FROM ".$prefix."_users ORDER BY points DESC limit 0,$toshow";