Processor Account: " . sec_username($sec_dbsocket,$userid) . "
\n"; echo "
Status: "; if ( idexist($dbsocket,"Syslog_TSuspend","TLogin_ID",$userid) ) { echo "SUSPENDED

\n"; } else { echo "Not Suspended

\n"; } if ( $action == "Clear Stale Processor" ) { if ( ($testmailid = ismailopen($dbsocket,$userid) ) && ( idexist($sec_dbsocket,"Secframe_TLogin","TLogin_ID",$userid) ) ) { if ( ! $subaction ) { openform("processor.php","post",2,1,0); formfield("userid","Hidden",3,1,0,200,200,$userid); formfield("subaction","Hidden",3,1,0,10,10,1); echo "Are you sure you want to clear stale processor : " . sec_username($sec_dbsocket,$userid) . "? "; php?> Yes No
thost_id."
"; $cleanid=stripslashes(pgdatatrim($SQLQueryResultsObject->tprocess_id)); $cleanhost=gethost($dbsocket,stripslashes(pgdatatrim($SQLQueryResultsObject->thost_id))); $PurgeQuery = $PurgeQuery . "delete from Syslog_TAlert where Syslog_TAlert.TSyslog_ID=TSyslog.TSyslog_ID and TSyslog.TSyslog_ID > $cleanid and TSyslog.host='$cleanhost' ; "; $PurgeQuery = $PurgeQuery . "delete from Syslog_TArchive where TSyslog_ID > $cleanid and host='$cleanhost' ; "; } $PurgeQuery = $PurgeQuery . "commit ; "; $PurgeSQLQueryResults = pg_exec($dbsocket,$PurgeQuery) or die(pg_errormessage()."\n"); } pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "\n"); cleanemail($dbsocket,$testmailid); clearlaunchqueue($dbsocket,$testmailid); closeopenmail($dbsocket,$testmailid); } if ( $PurgeSQLQueryResults ) { echo "
SUCCESS!!
\n"; pg_freeresult($PurgeSQLQueryResults) or die(pg_errormessage() . "\n"); } else { echo "
FAIlED!!
\n"; pg_freeresult($PurgeSQLQueryResults) or die(pg_errormessage() . "\n"); } } } else { echo "
The processor you've selected is not stale!

\n"; } } else { openform("processor.php","post",2,1,0); formfield("userid","Hidden",3,1,0,200,200,$userid); formsubmit("Toggle Suspension",3,1,1); closeform(); echo ""; echo "\n\n"; formfield("userid","Hidden",3,0,0,10,10,$userid); closeform(); /* $SQLQuery="select * from Syslog_TProcessorProfile where TLogin_ID=$userid"; */ $SQLQuery="select TProcessorProfile_ID,Syslog_THost.THost_Host from Syslog_TProcessorProfile where Syslog_TProcessorProfile.TLogin_ID=$userid and Syslog_TProcessorProfile.THost_ID=Syslog_THost.THost_ID order by Syslog_THost.THost_Host"; $SQLQueryResults=pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { echo "\n"; for ( $loop = 0 ; $loop != $SQLNumRows ; $loop++ ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); $id=stripslashes(pgdatatrim($SQLQueryResultsObject->tprocessorprofile_id)); $host=pgdatatrim($SQLQueryResultsObject->thost_host); echo ""; formfield("userid","Hidden",3,1,0,10,10,$userid); formfield("id","Hidden",3,1,0,10,10,$id); formfield("host","Hidden",3,1,0,10,128,$host); closeform(); } } echo "
ActionHost
"; openform("processor.php","post",2,1,0); formsubmit("Save",3,1,0); echo ""; hostdropdown ($dbsocket, $sec_dbsocket,"hostid",$REMOTE_ID,$group,0,0,0,1,"",1); echo "
ActionHost
"; openform("processor.php","post",2,1,0); echo ''; echo "$host
"; pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); } $endtime=time(); echo "
Page loaded in " . ($endtime - $begintime) . " seconds.
\n"; do_footer(); dbdisconnect($sec_dbsocket); dbdisconnect($dbsocket); php?>