Announcement

Collapse
No announcement yet.

How do I exclude myself as Top 10 Poster?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I exclude myself as Top 10 Poster?

    I'm the admin and therefore have the most posts. I want to exclude myself from the main Top 10 list seen in the Members area. I'm assuming this is a MySQL statement edit somewhere?

  • #2
    you would need to edit the memberlist.php file. i recommend posting a hack request on www.vbulletin.org

    Comment


    • #3
      I found a solution if anyone else reading this thread in the future.

      Using VBStats Hack, wanted to omit/exclude myself from the Top 10 List.

      In the vbstats.php file, under Top Posters, I found the query area for the database.

      Code:
      // Ever
      	$toppost1=$DB_site->query("SELECT DISTINCT(userid),COUNT(postid) AS posts
      					FROM post
      					WHERE userid > 0
      					GROUP BY userid
      					ORDER BY posts DESC
      					LIMIT $toppostmax");
      For the //Ever, //30 days and // 24 hours sections, I changed the userID to:

      Code:
      WHERE userid > 1
      I'm user #1, so this queries all users greater than my id #1. Simple fix, that's why I guess I overlooked it.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X