Deleting guests

[RichieBoy67]

Hey there,

Can anyone help me add guests to this? Basically I want to delete guests from my session table via cron. I just need to add guests to this line.

PHP Code:

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE (useragent like '%bot%')"); 


Thanks so much

[RichieBoy67]

Bump please.

[shka]

PHP Code:

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE `userid` = 0;"); 


A registered but not logged in user will also be kicked. So its better to add lastactivity if someone is in login process.

PHP Code:

$vbulletin->db->query_write("
    DELETE FROM " . TABLE_PREFIX . "session 
    WHERE (`userid` = 0) 
    AND (`lastactivity` < UNIX_TIMESTAMP() - 3600);
"); 


Replace 3600 with your intervall in seconds

[RichieBoy67]

Originally Posted by shka

PHP Code:

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE `userid` = 0;"); 


A registered but not logged in user will also be kicked. So its better to add lastactivity if someone is in login process.

PHP Code:

$vbulletin->db->query_write("
    DELETE FROM " . TABLE_PREFIX . "session 
    WHERE (`userid` = 0) 
    AND (`lastactivity` < UNIX_TIMESTAMP() - 3600);
"); 


Replace 3600 with your intervall in seconds

That is perfect. Thank you so much