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');