Clear Open User Sessions for $login Could not include SQL library functions. Aborting EOM; exit(); } echo << EOM; include("../html/user_toolbar.html.php3"); $open_sessions = 0; $sql_extra_query = ''; if ($config[sql_accounting_extra_query] != '') $sql_extra_query = sql_xlat($config[sql_accounting_extra_query],$login,$config); print <<

Clear open sessions for $login

EOM; if ($clear_sessions == 1){ $link = @da_sql_pconnect($config); if ($link){ $res = @da_sql_query($link,$config, "DELETE FROM $config[sql_accounting_table] WHERE username='$login' AND acctstoptime = 0 $sql_extra_query;"); if ($res) echo "Deleted open sessions from accounting table \n"; else echo "Error deleting open sessions for user" . da_sql_error($link,$config) . " \n"; } else echo "Could not connect to SQL database \n"; echo <<

EOM; exit(); } else{ $link = @da_sql_pconnect($config); if ($link){ $search = @da_sql_query($link,$config, "SELECT COUNT(*) AS counter FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime IS NULL $sql_extra_query;"); if ($search){ if ($row = @da_sql_fetch_array($search,$config)) $open_sessions = $row[counter]; } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; } else echo "Could not connect to SQL database
\n"; } ?>

>

User has open sessions Are you sure you want to clear all open user sessions?