Well, I guess for those that it worked, great and for those that it doesn't too bad so sad. No support. Uninstalling.

Thx Andi. Installed it. Great Hack !:banana:

/me clicks install

is there any way to make awaiting acti auto prune by X days and registered autoprune for Z days, guess not

i got this email

atabase error in vBulletin 3.5.4:
Invalid SQL:
SELECT userid, username, email, languageid FROM vbuser
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
' at line 2
Error Number : 1064
Date : Tuesday, May 16th 2006 @ 09:15:25 PM

Hello,

After installing - which was fine - I've got this mail:

Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:

SELECT userid, username, email, languageid FROM trekkingforum_user
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));

MySQL-Fehler : You have an error in your SQL syntax near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND ' at line 3
Fehler-Nr. : 1064
Datum : Wednesday, May 17th 2006 @ 12:03:18 AM
Skript : http://www.trekkingforum.com/forum/cron.php?&rand=289400
Referrer : http://www.trekkingforum.com/forum/index.php
IP-Adresse : xx.xx.xx.xx
Benutzername : Unregistriert
Klassenname : vb_database

Hmmm,
Is it normal? will it work properly? Or is it better to uninstall again?

Andreas

so is this working cause i do have a productive board and would love to add this hack so i do not have to go through each user and click delete...please reply if you have tried it and working for you i use 5.4 too btw...

Thanks
CF

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT userid, username, email, languageid FROM vb_user
WHERE usergroupid IN ()
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND lastactivity < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -180 DAY));

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND inactivitytag=0
AND lastpost=0
AND pmtotal <= 0
AND ' at line 2
Error Number : 1064

guess its not working...:( maybe missing the .TABLE PREFIX. ?

It works on my test forum and if Andreas doesnt mind I would like to work on this a little bit and maybe add the feature of moving to another usergroup and fixing the syntax errors if i can.

please do , i get an error everyday cause of that sql up ther eand would like to get the SQL to add with the table prefix in it so that i can use it...if you cvan help me that would be great...

Thanks
CF

ok thanks for your offer to help Neo, but i have got it ;) had to uninstall and reinstall it and it worked so my server must have glitched or something...but all is well now i believe no more SQL errors yet...lol