TOP POSTERS - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » Managing & Customizing your Board » How do I? » TOP POSTERS

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	49
Gizmo	24
DennyP	24
Dunny	17
SteveS	14
AllenAyres	12
dbremer	10
drkknght00	9
SD	9
driv	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#170213 - 12/13/06 07:27 AM

TOP POSTERS

Markus_003 Offline

journeyman

Registered: 07/26/06
Posts: 58

Is it possible to exclued a particular user from displaying his or hers NAME and TOTAL POST NUMBER?

For example, Rick has over 2500 posts (currently). Is it possible to exclude Rick from TOP POSTERS table?

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#170215 - 12/13/06 07:40 AM

Re: TOP POSTERS [Re: Markus_003]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

You could edit the coding to exclude ricks uid in the sql statement in the appropriate files (I believe top posters island is built from cache_builders/top_posters.php).

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top

#170216 - 12/13/06 07:45 AM

Re: TOP POSTERS [Re: Gizmo]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

Just screwing around wiht the query, completely untested and i'm half asleep so i don't know if it'll work, but you could try something similar to:

Change:

Code:

$query = "
	select t1.USER_ID,t1.USER_DISPLAY_NAME,t2.USER_TOTAL_POSTS
	from {$config['TABLE_PREFIX']}USERS as t1,
	{$config['TABLE_PREFIX']}USER_PROFILE as t2
	where t1.USER_ID <> 1
	and t1.USER_ID = t2.USER_ID
	and	t1.USER_IS_APPROVED = 'yes'
	order by t2.USER_TOTAL_POSTS desc
	limit {$config['TOP_POSTERS']}
";

To:

Code:

$query = "
	select t1.USER_ID,t1.USER_DISPLAY_NAME,t2.USER_TOTAL_POSTS
	from {$config['TABLE_PREFIX']}USERS as t1,
	{$config['TABLE_PREFIX']}USER_PROFILE as t2
	where t1.USER_ID <> 1
	and t1.USER_ID != 1
	and t1.USER_ID = t2.USER_ID
	and	t1.USER_IS_APPROVED = 'yes'
	order by t2.USER_TOTAL_POSTS desc
	limit {$config['TOP_POSTERS']}
";

Adding the uID of users to ban (in this case, the line below):

Code:

	and t1.USER_ID != 1

Top

#170217 - 12/13/06 07:53 AM

Re: TOP POSTERS [Re: Gizmo]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

Should also be good to point out that you can add numerous lines like what i added again and again with seperate uid's.

Also, be sure to clear your cache after updating the cache builder.

Also it's good to note that by modifying stock code you may be voiding your access to official support from Groupee on your forums, and that you may be required to restore the code to stock before requesting support through a support ticket (just a small disclaimer I try to include when showing people how to break, err modify,things ;).

Top

#170219 - 12/13/06 08:09 AM

Re: TOP POSTERS [Re: Gizmo]

Markus_003 Offline

journeyman

Registered: 07/26/06
Posts: 58

It is working. Thank you.

Top

#170221 - 12/13/06 08:13 AM

Re: TOP POSTERS [Re: Markus_003]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

Not a problem, glad I could be of service :).

Top

#185174 - 05/30/07 12:01 AM

Re: TOP POSTERS [Re: Gizmo]

Trixie Offline

member

Registered: 05/10/07
Posts: 154
Loc: Rye, Co - USA

Why is it that my forum panels only show 5 top posters but this website forum shows 10? Thanks.

_________________________

Top

#185176 - 05/30/07 12:55 AM

Re: TOP POSTERS [Re: Trixie]

ntdoc

Registered: 11/09/06
Posts: 3384

You can control how many show via the control panel I think. We changed ours but don't recall 100% if it was a code hack or Control Panel entry, I think it's a control panel entry.

Top