PhotoPost Community - How do I remove a user from the "Top Posters"?

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro How Do I...? (http://www.photopost.com/forum/photopost-pro-how-do-i/)

- - How do I remove a user from the "Top Posters"? (http://www.photopost.com/forum/photopost-pro-how-do-i/114883-how-do-i-remove-user-top-posters.html)

Johnny Doomo

July 14th, 2005 10:47 PM

How do I remove a user from the "Top Posters"?

In my gallery I am the one uploading most of the images, 41,585 to be exact. I don't want it to display my name, BUT my registration system is using my forum registration and I am not the only admin on my forums. Does that mean that the other person that has admin on my forum also has admin on my gallery as well? If so, I want it to not show my name on the "Top Posters", but I don't want it to hide the other admin.

Can somebody help me with how I can do this? It has been bugging me for a long time. Any help you can provide me with I would really appreciate it.

Thanks in advance.

Johnny Doomo

September 8th, 2005 03:35 PM

bumpy

volarium

January 26th, 2006 11:29 PM

I am by NO MEANS an expert, so take my advice for what it's worth, but this is how I did it.

You need to make this edit in the following four files:
index.php
showphoto.php
showgallery.php
showmembers.php

Find this:

Quote:

$queryz = ppmysql_query("SELECT cat,id,title,rating FROM {$Globals['pp_db_prefix']}photos ORDER BY rating DESC,views DESC LIMIT {$Globals['mostpoppal']}", $link);

Replace with this:

Quote:

$queryz = ppmysql_query("SELECT user,userid,COUNT(*) AS pcount FROM {$Globals['pp_db_prefix']}photos WHERE user NOT LIKE 'username' GROUP BY user ORDER BY pcount DESC LIMIT {$Globals['numtoppal']}", $link);

Replace username with the username you want to exclude.

You can see mine here: http://vfrworld.com/photos

Good luck!
Michael

Chuck S

January 27th, 2006 09:30 AM

NOT LIKE OR simply !=

Johnny Doomo

April 7th, 2006 04:22 PM

Quote:

Originally Posted by Chuck S

NOT LIKE OR simply !=

What do you mean? You mean replace the "NOT LIKE OR" with "!="?

Chuck S

April 7th, 2006 07:16 PM

You can use NOT LIKE

Johnny Doomo

April 9th, 2006 12:55 AM

I tried this and it didn't work. I am trying to get rid of the admin user and the "user" unregistered. Can somebody help me more on what I need to add to get this to work? I need them both gone, but as a test I tried each one individually and neither disappeared after changing it.

Any ideas?

Chuck S

April 9th, 2006 09:46 AM

Code:

Content visible to verified customers only.

Guaranteed no photos will be pulled by Johnny Doomo but anyway good luck with your hacking

Johnny Doomo

April 11th, 2006 10:59 PM

Nope that doesn't work. It still shows me in the top uploaders. Is the top posters pal cached? Do I need to change the code and wait a while or change a setting in the admincp?

Chuck S

April 12th, 2006 06:50 AM

It could be a cache issue but your free to continue any discussion on code modifications in the mod forum.

Johnny Doomo

April 12th, 2006 10:16 AM

discussion? More like empty requests that never get replies. :(

Chuck S

April 12th, 2006 10:39 AM

Sorry if you feel that way about our mod forum Johnny.

The suggestion I posted above works and I would think your issue if that of cache

All times are GMT -5. The time now is 03:27 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97