Webmastersite.net
Register Log In
  1. WSN Support Forums
  2. Paid Scripts Support
  3. event variables in toplists

event variables in toplists

Comments on event variables in toplists

•joshberm
Nothing is impossible...

Usergroup: Customer
Joined: Aug 07, 2006
Location: Tampa, Florida

Total Topics: 36
Total Comments: 91
•joshberm
#1 - Quote - Permalink
Posted Oct 05, 2006 - 11:03 AM:

How do I filter my events toplist so that only events starting in the next week (or 2 weeks, or month) will show?

Thanks
•Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
•Paul
#2 - Quote - Permalink
Posted Oct 05, 2006 - 5:15 PM:

The mysql function UNIX_TIMESTAMP() is handy for getting the current time, and there are 86400 seconds in a day, so:

starttime > UNIX_TIMESTAMP() AND starttime < UNIX_TIMESTAMP() + (86400 * 7)
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.