End-User Options - Reputation Page Split

Reputation Comments Page Split (Pagination)

Description:
- This mod allows you to be able to paginate your way through reputation comments! Default VB code only allows you to globally set a limit for all users. So if you chose 50 for example, only 50 comments would show...but not all of them. Booo!! Some people want to see ALL of their comments, just not the last 50

Features:

• Reputation Page Splitting

Drawbacks

• This will require 1 change to default code! (It Is The ONLY Way, Sorry!!)

Installation:
1.) Upload Product
2.) Perform File Edit
3.) Enjoy Release

Code Change:

Open usercp.php

Find:

PHP Code:

LIMIT 0, " . $vbulletin->options['showuserrates'] 


Replace With:

PHP Code:

LIMIT " . ($limitlower - 1) . ", $perpage " 


UPDATES:
1.0.1
- Updated code base to include table prefix


Number of results per page is changeable in the admincp!

[Cla75]

Hello,
congratulations for this mod.

I tried to install it:
1. upload product
2. make changes to this file in the root usercp.php

Problem:
I do not see the chart on the bottom topic

What is wrong?
thansk

[Cla75]

help me pleaseeeeee

[paul41598]

Originally Posted by Cla75

help me pleaseeeeee

Chart on the bottom topic? The only thing you're going to see is pagination in your USERCP for reputation.

[Rean]

Originally Posted by Cla75

Hello,
congratulations for this mod.

I tried to install it:
1. upload product
2. make changes to this file in the root usercp.php

Problem:
I do not see the chart on the bottom topic

What is wrong?
thansk

what chart??

[Speysider]

This product does not work and should be archived, because anyone and everyone will receive a Database Error when trying to go to the User CP.

The db error message itself:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT
count(postid) AS count
FROM reputation
WHERE reputation.userid = 1;

MySQL Error   : Table '{forumdb}vb.reputation' doesn't exist
Error Number  : 1146
Request Date  : Friday, October 9th 2009 @ 03:35:38 AM
Error Date    : Friday, October 9th 2009 @ 03:35:38 AM
Script        : {sitearea}/usercp.php
Referrer      : {forum domain}/index.php
IP Address    : **.**.**.***
Username      : {username}
Classname     : vB_Database
MySQL Version : 5.0.51a-log

[Rean]

just realize... the paging does not work...

[Speysider]

This hack has never worked. No idea why it was made when the author knew it didn't work

[paul41598]

New update posted to reflect table prefix. Please uninstall and reinstall 1.0.1

[Cla75]

Originally Posted by paul41598

Chart on the bottom topic? The only thing you're going to see is pagination in your USERCP for reputation.

I made this change:

Open usercp.php 

Find: 
PHP Code: 
LIMIT 0, ". $ Vbulletin-> options [ 'showuserrates'] 
Replace With: 
PHP Code: 
LIMIT ". ($ Limitlower - 1).", $ Perpage "

but I see nothing button topic!

Originally Posted by Rean

what chart??

I do not see this:

[infnity8x3]

This hack has all ways worked for me. Follow directions and you should be fine. Thanks again author.

Although the updated XML did not fix the bug. So I reverted back to 1.0 version with the "my" edited prefix's.