Windows PHP Solutions

<?php
//disconnects windows share sessions with any sort of idle time and doesn't //have any open files; combine with cron for windows:
//from David @ PHP4IT.com 2006-01-14

$cmd = "net session";
exec($cmd, $out);
$disconnect_these = array();
foreach ($out as $line){
    $line = trim($line);
    if (substr($line, 0, 2) != "\\\\"){ continue; }
    $t = explode(':', $line);
    $idle_time = substr($t[0], -1);
    $open_files = explode(' ', $t[0]);
    $open_files = $open_files[sizeof($open_files)-2];
    if ($idle_time > 0 || !$open_files){
        $computer_name = trim(substr($line, 0, 17));
        $disconnect_these[] = $computer_name;
        #print "$computer_name\t$idle_time\t$open_files\n";
    }
}
if (sizeof($disconnect_these)){
    foreach ($disconnect_these as $disconnect){
        passthru("net session $disconnect /delete /Y");
    }
}
#print_r($disconnect_these);
?>

Here's the sample crontab entry to run the script, which we're calling disconnect_idle_sessions.php, to run every minute:

* * * * * c:\php\php c:\php\disconnect_idle_sessions.php

Cron.php would basically just call cron_exec.php every designated X seconds (or minutes, e.g.):

<?php
//Runs cron_exec.php every XX seconds; put in Windows startup folder
$dir = "c:\\php";
$cmd = "c:\php\php -q " . $dir . "\\" . 'cron_exec.php';
$interval = 10;
do {
    $output = shell_exec($cmd);
    $cur_time_str = date("F d, Y \t h:i A");
    print "$cur_time_str: $output\n\n";
    write_log();
    sleep($interval);
} while (TRUE)

function write_log()
{
    global dir, $output, $cur_time_str;
    $log_file = $dir . "\\logs\\cron" . date("Ymd") . '.log';
    $fp = fopen($log_file, 'a');
    fwrite($fp, $cur_time_str . "\n" . $output . "\n");
    fclose($fp);
}
?>

----

Here's cron_exec.php:

<?php
//cron script that executes commands
$dir = "c:\\php";
$lock_file = $dir . "\\" . 'cron_exec.lock';
if (file_exists($lock_file)){ die("Error: cron_exec.lock exists.\n"); }
$fp = fopen($lock_file, 'w');
$result = fwrite($fp, 'cron_exec.php is running');
fclose($fp);
mysql_pconnect($host, $user_name, $password);
$q = "select min(cqid) from command_queue where executed != 'Y'";
if (!$result = mysql_query($q)){
    unlink($lock_file);
    die(mysql_error() . " SQL: $q");
}
list($cqid) = mysql_fetch_row($result);
if (mysql_num_rows($result) == 0 || !$cqid){
    unlink($lock_file);
    die("Nothing to be executed.");
}

$q = "select * from command_queue where cqid = $cqid";
if (!$result = mysql_query($q)){
    unlink($lock_file);
    die(mysql_error() . " SQL: $q");
}
$row = mysql_fetch_assoc($result);
$cmd = "c:\php\php -q " . $row['command'] . ' ' . @$row['add_switch'];
$s_time = get_microtime();
$output = shell_exec($cmd);
$e_time = get_microtime();
$duration = sprintf("%01.2f", $e_time - $s_time);
$q = "update command_queue
        set executed = 'Y', duration = '$duration', date = sysdate()
        where cqid = $cqid";
if (!$result = mysql_query($q)){
    unlink($lock_file);
    die(mysql_error() . " SQL: $q");
}
print "Executed $cmd, output: $output\n";
unlink($lock_file);
?>

The MySQL table would have the following structure:

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| cqid       | int(10) unsigned |      | PRI | NULL    | auto_increment |
| command    | char(32)         | YES  |     | NULL    |                |
| add_switch | char(8)          | YES  |     | NULL    |                |
| executed   | char(1)          | YES  |     | N       |                |
| date       | datetime         | YES  |     | NULL    |                |
| duration   | char(32)         | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+