include_once( dirname(__FILE__) .'/includes.php' ); /** * Class Log * @author NTConseil */ class Log { function addLogFile( $content ) { $pathLog = $params['ROOT'].'/log'; $fileHandle = fopen($pathLog, "a"); if(!$fileHandle){ echo 'Unable to open ' . $pathLog; return FALSE; } $content = date("Y/m/d H-i") . " remote user:" . gethostbyaddr($_SERVER['REMOTE_ADDR']) . " " . $_SERVER['REMOTE_ADDR'] . " " . $content. "\r\n"; fputs($fileHandle, $content); fclose($fileHandle); return TRUE; } function add( $module, $command, $comment ='' ) { $sqlQuery = " INSERT INTO log (username, id_user , log_date, log_time, ip, agent, module, cmd, comment ) VALUES ( '". $_SESSION['username'] ."' , '". $_SESSION['id_user'] ."' , CURDATE(), CURTIME(),'". $_SERVER['REMOTE_ADDR'] ."', '". $_SERVER['HTTP_USER_AGENT'] ."', '". $module ."' , '". $command ."' , '". $comment ."' ) "; $result = mysql_query( $sqlQuery ); } function addMail( $data ) { $sqlQuery = " INSERT INTO log_mail (sender, recipient , date , time ,subject, body ) VALUES ( '". $_SESSION['username'] ."' ,'". addslashes($data['recipient']) ."', CURDATE() , CURTIME(),'". addslashes($data['subject']) ."', '". addslashes($data['body']) ."' ) "; mysql_query( $sqlQuery ); //echo $sqlQuery ; } function show ( $where = '' , $order = '') { $sqlQuery = " SELECT * FROM log "; if ($where) $sqlQuery = " WHERE ". $where; if ($order) $sqlQuery = " ORDER BY ". $order; $result = mysql_query( $sqlQuery ); // Détermine la structure du tableau $num_fields = mysql_num_fields($result); // Construction de vecteurs avec les noms et la longueur des champs for ($i = 0; $i < $num_fields; $i++) { $fields[$i] = mysql_field_name($result, $i); } echo '
| '. $fields[$i] .' | '; } echo '
| '. $row[ $fields[$i] ] .' | '; } echo '