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

[Johnny Doomo]

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]

bumpy

[volarium]

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:

$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:

$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]

NOT LIKE OR simply !=

[Johnny Doomo]

Originally Posted by Chuck S

NOT LIKE OR simply !=

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

[Chuck S]

You can use NOT LIKE

[Johnny Doomo]

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]

Content visible to verified customers only.

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

[Johnny Doomo]

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]

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

[Johnny Doomo]

discussion? More like empty requests that never get replies.

[Chuck S]

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