phpvms_sessions question

[tutmeister]

This table is huge in my database and I'd like to run the following as a weekly Cron Job:

<?php

$connect = @mysql_connect("localhost","username","password");

if (!$connect)
 {
 die('Could not connect: ' . mysql_error());
 }

@mysql_select_db("database");

// DELETE empties the table
$query = "DELETE FROM `phpvms_sessions` WHERE `logintime` < date_sub(NOW(), INTERVAL 2 DAY);";


mysql_query($query);

?>

Is there anything other than storing current login details that this table is responsible for that I would be screwing up by doing this?

The reason I am doing the above is that I have changed the MySQL table to the Memory Storage Engine and I don't want more than 2 day's worth of sessions loaded into memory.

[tutmeister]

*BUMP*

[mark1million]

Is this not already a function in the maintenance.php script?

Also the session limit is currently set to 30 days i believe, there is a setting in the config file.

[tutmeister]

Sorry Mark, I only just saw this reply. I'm not sure but I will take a look. It might possible kill all open sessions, but the issue at hand, for me at least, is not the amount of sessions. It's that it stores a record for each session which in turn unnecessarily is bloating my database with a year's worth of sessions (well not anymore, as I've run my script to delete them). My host (mediatemple) has a limit on the size a database can be, so I try to get rid of unnecessary bloat.

[HighFlyerPL185]

What happens if you remove all the data from that table? It really is big!

[OzFlyer]

I would also know how to clean out / delete this table.

or at least let me know which file and what to change to set it to 30 day log only.

[mark1million]

You can just clear it out manually, all that will happen is users will have to login again. Dont delete the table just empty or truncate.

I dont think the native function works to empty the table.