if (isset($where_lang) and !empty($where_lang)) {
$page .= file_get_contents("templates/information.html");
$page = str_replace("{INFORMATION}", $where_lang . " <a onclick=\"skm_LockScreen()\" class=\"btn btn-default btn-sm\" href=\"jurnal_in.php\">{LANG_CLEAN_SERCH_RESULTS}</a>", $page);
}
$query_order_by = "ORDER BY `id` DESC ";
if (isset($_GET['export']) and $_GET['export'] == "do") {
$query_order_by = "ORDER BY `id` ";
$sql_limit = "";
$export_type = "text/csv";
$export_name = "jurnal_in.csv";
$export = "\"" . $c_nam . "\";\n\n";
$export .= "\"{LANG_HEADERINFO}\";\n";
$export .= "\"{LANG_SEARCH_RESULTS} :\";\n";
$export .= "\"{LANG_ORG_INDEX_S}\";\"{LANG_JURNAL_STEP_DO}\";\"{LANG_ADD_USER}\";\"{LANG_ADD_TIME}\";\"{LANG_GET_DATA_S}\";\"{LANG_ORG_NAME_S}\";\"{LANG_ORG_INDEX_S}\";\"{LANG_ORG_DATA_S}\";\"{LANG_ORG_SUBJ_S}\";\"{LANG_DO_USER}\";\"{LANG_MAKE_VISA_S}\";\"{LANG_MAKE_DATA}\";\"{LANG_JURNAL_IN_STATUS_2}\";\"{LANG_JURNAL_IN_STATUS_3}\";\n";
}
$html_navy = get_navy("DB_" . $_SESSION['user_year'] . "_IN", $query_where, $query_order_by, $active, $_SESSION['user_page_limit'], "jurnal_in.php?" . $pre_link . "&page_num=");
$page = str_replace("{NAVY}", $html_navy, $page);
$page .= file_get_contents("templates/jurnal_in.html");
$query = "SELECT * FROM `db_" . $_SESSION['user_year'] . "_in` " . $query_where . " " . $query_order_by . " " . $sql_limit . " ;";
$res = mysql_query($query) or die(mysql_error());
$queryes_num++;
$page = str_replace("{NAVY_INSERT_SHOW}", mysql_num_rows($res), $page);
$jurnal_in = "";
$modals = "";
$is_first = "";
if (mysql_num_rows($res) > 0) {
$users = get_users_names(0);
$queryes_num++;
while ($row = mysql_fetch_array($res)) {
$tr_color_info = "onclick=\"cTR('TRn" . $row['id'] . "')\"";
if ($row['make_data'] != "") {
$page .= file_get_contents("templates/information.html");
$page = str_replace("{INFORMATION}", $where_lang . " <a class=\"btn btn-default btn-sm\" href=\"loging.php\">{LANG_CLEAN_SERCH_RESULTS}</a>", $page);
}
$page .= file_get_contents("templates/log_admin.html");
if (isset($_GET['page_num']) and preg_match('/^[1-9][0-9]*$/', $_GET['page_num'])) {
$active = $_GET['page_num'];
} else {
$active = 1;
}
$limit_pre = ($active - 1) * $_SESSION['user_page_limit'];
$sql_limit = "LIMIT " . $limit_pre . ", " . $_SESSION['user_page_limit'];
$query_order_by = "ORDER BY `id` DESC ";
if ($query_where != "") {
$where = " WHERE " . $query_where;
}
$html_navy = get_navy("log", $where, $query_order_by, $active, $_SESSION['user_page_limit'], "loging.php?" . $search_pre . "page_num=");
$queryes_num++;
$page = str_replace("{NAVY}", $html_navy, $page);
$query = "SELECT * FROM `log` " . $where . " " . $query_order_by . " " . $sql_limit . " ; ";
$res = mysql_query($query) or die(mysql_error());
$queryes_num++;
while ($row = mysql_fetch_array($res)) {
$template_log .= "<tr valign=\"middle\" align=\"center\">\n <td align=\"center\">" . date('d.m.Y H:i:s', $row['time']) . "</td>\n <td align=\"center\"><a href=\"?search=do&user="******"\">" . $users[$row['user']] . "</a></td>\n <td align=\"center\"><a href=\"?search=do&ip=" . $row['ip'] . "\">" . $row['ip'] . "</a></td>\n <td align=\"left\">" . $row['do'] . "</td>\n </tr>";
}
$page = str_replace("{LOG_VIEWS}", $template_log, $page);
$page = str_replace("{NAVY_INSERT_SHOW}", mysql_num_rows($res), $page);
}
} else {
$loging_do = "{LANG_LOG_LOGING_403}";
include 'inc/loging.php';
header('HTTP/1.1 403 Forbidden');
