*

Recent

Author Topic: MOD - Remove "0" players from Top Users  (Read 5392 times)

Frank

  • Sr. Member
  • ****
  • Posts: 257
  • Force: +4/-0
MOD - Remove "0" players from Top Users
« on: October 11, 2011, 07:04:45 PM »
Just one of my idiosyncrasies about NOT having a negative user/guest in the top users statistics.

I know that they eventually disappear - That's not the point.  ;D

Code: [Select]
Open:

includes/arcadesubmenu2.php

Find:
$tur1 = 'SELECT username, userid, plays FROM dd_users ORDER BY plays DESC LIMIT 0,15';

Replace With:

$tur1 = 'SELECT username, userid, plays FROM dd_users WHERE plays!="0" ORDER BY plays DESC LIMIT 0,15';


If you only want to remove the "Guest 0" Use this.


Code: [Select]
$tur1 = 'SELECT username, userid, plays FROM dd_users WHERE user_level!="0" ORDER BY plays DESC LIMIT 0,15';

Dillon

  • Developer
  • Sr. Member
  • ******
  • Posts: 340
  • Force: +3/-0
    • Arcade Freak
Re: MOD - Remove "0" players from Top Users
« Reply #1 on: October 11, 2011, 08:33:18 PM »
I was gunna make this.... lol just didnt feel like it but since its here..... ill add it

Dillon

  • Developer
  • Sr. Member
  • ******
  • Posts: 340
  • Force: +3/-0
    • Arcade Freak
Re: MOD - Remove "0" players from Top Users
« Reply #2 on: October 11, 2011, 08:37:11 PM »
Works great thanks!

Frank

  • Sr. Member
  • ****
  • Posts: 257
  • Force: +4/-0
Re: MOD - Remove "0" players from Top Users
« Reply #3 on: October 11, 2011, 10:10:57 PM »
Whatdidjaexpect? :P

kurt

  • Developer
  • Hero Member
  • ******
  • Posts: 634
  • Force: +16/-1
Re: MOD - Remove "0" players from Top Users
« Reply #4 on: October 11, 2011, 10:39:03 PM »
Good twist. Thanks mort!