[NexDog]

Originally posted by FireFly
Replace:

                                       WHERE userid<>$daybits[1]

with:

                                       WHERE userid<>$daybits[1] AND lastactivity>".time()-(86400*14)."

(14 is the number of days)

By the way, I'm not sure myself whether it's lastactivity or lastvisit we need to check, so I'm open for corrections here.

Well, that produced this:

Database error in vBulletin 2.2.6:

Invalid SQL: -1209600
                                         AND (usergroupid=5
                                          OR usergroupid=6
                                          OR usergroupid=7
                                          OR usergroupid=2)
                                       ORDER BY RAND()
                                       LIMIT 1
mysql error: You have an error in your SQL syntax near '-1209600
                                         AND (usergroupid=5
           ' at line 1

mysql error number: 1064

Date: Friday 16th of August 2002 05:47:34 AM
Script: http://www.hostnexus.com/forum/forum/
Referer:

So I just used the minimum posts requirement instead of last activity....