UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support [6.5] saved admin searches

Hi,
how do I create a saved serched job for displaying user with an inactivity time of 180 days ? I found no way in the control panel.

I create a dummy search, go to phpMyadmin and take a look on the format of the example 30 days search:
AND U_Laston < (UNIX_TIMESTAMP() - 259200) ORDER BY U_LastOn

I copy this to my dummy search but must change the timestamp. I dont have a clue about Unix timestamps and like to know wich one must be used for 180 days instead of 30 days (259200).

thanks.

The paramater in question on the search page is Advanced >> Last online. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

For the SQL, you can do the math in the query:

... and U_Laston < ( UNIX_TIMESTAMP() - ( 60 * 60 * 24 * 180 ) )

You could also try MySQL's date functions...

... and U_Laston < ( UNIX_TIMESTAMP( DATE_SUBTRACT(NOW(), interval 180 day) ) )

.. or something like that. I don't recall the exact syntax.