function logit($parameters, $arg1 = '', $arg2 = '', $arg3 = '')
{
if ($arg1 or $arg2 or $arg3) {
$type = $arg1;
$script = $arg2;
$log_message = $arg3;
} else {
if (is_array($parameters)) {
$type = array_key_exists("type", $parameters) ? $parameters['type'] : NULL;
$script = array_key_exists("script", $parameters) ? $parameters['script'] : NULL;
$log_message = array_key_exists("log_message", $parameters) ? $parameters['log_message'] : NULL;
}
}
$log_message = strtolower($log_message);
$sql_query_type = NULL;
$record_action = NULL;
require_once "../zig-api/lib/info.lib.php";
$info_object = new zig_info();
$user = $info_object->user();
$pre = $GLOBALS['zig']['sql']['pre'];
$zig_global_database = $GLOBALS['zig']['sql']['global_database'];
$script = $GLOBALS['zig']['current']['script'];
$module = $GLOBALS['zig']['current']['module'];
$action = $GLOBALS['zig']['current']['action'];
$sql = "SELECT `a`.`module`,`a`.`name`\n\t\t\t\tFROM `zig_tabs` `a`,`zig_applications` `b` \n\t\t\t\tWHERE `a`.`module`=`b`.`name` AND `directory`='{$module}' AND `a`.`link`='{$script}' \n\t\t\t\tLIMIT 1";
$result = $GLOBALS['zig']['adodb']->Execute($sql);
$fetch = $result->fetchRow();
$module = $fetch['module'];
$tab = $fetch['name'];
// -- Start Record Action
if (stripos($log_message, "select ") == 0 and stripos($log_message, "select ") !== false) {
$sql_query_type = "select";
$record_action = "search";
} else {
if (stripos($log_message, "update ") == 0 and stripos($log_message, "update ") !== false) {
$sql_query_type = "update";
if (stripos(strtolower(str_replace("`", "", $log_message)), "set zig_status='deleted'")) {
$record_action = "delete";
$splitted_log = explode(" where ", str_replace("`", "", $log_message));
$splitted_where = explode("id", $splitted_log[1]);
} else {
$record_action = "edit";
}
} else {
if (stripos($log_message, "insert into ") == 0 and stripos($log_message, "insert into ") !== false) {
$sql_query_type = "insert";
$record_action = "add";
} else {
if (stripos($log_message, "show ") == 0 and stripos($log_message, "show ") !== false) {
$sql_query_type = "show";
}
}
}
}
// -- End Record Action
$sql = "INSERT INTO `{$zig_global_database}`.`{$pre}logs` (zig_created,zig_user,log_type,module,tab,action,script,record_action,sql_query_type,log_message) VALUES(NOW(),'{$user}','{$type}','{$module}','{$tab}','{$action}','{$script}','{$record_action}','{$sql_query_type}',\"{$log_message}\") ";
$result = $GLOBALS['zig']['adodb']->Execute($sql);
$error_number = $GLOBALS['zig']['adodb']->ErrorNo();
if ($error_number) {
$zig_result['error'] = "Script: {$script}<br />";
$zig_result['error'] .= "SQL Statement: {$sql}<br />";
$zig_result['error'] .= "SQL Error: " . $GLOBALS['zig']['adodb']->ErrorMsg();
}
$zig_result['return'] = 1;
return $zig_result;
}
