?> <FONT class="h2"><?Print $text_pi_forbid;?></FONT> <BR><BR> <? IF(!IsSet($_GET['page'])) $_GET['page'] = 1; IF(!IsSet($_GET['orderby'])) $_GET['orderby'] = $VA_setup['pi_forbid_order_by']; IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "pi_forbid", $_GET['filter_colum']); $query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '"; IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";} $query .= $DB_hub->Real_Escape_String($_GET['filter']); IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins") {$query .= "%";} $query .= "'"; } $result = $DB_hub->Query("SELECT Count(word) AS `count` FROM pi_forbid".$query); $count = $result->Fetch_Assoc(); $total = $count['count']; $result->Free_Result(); $pages = (int)(($total - 1) / $VA_setup['pi_forbid_results']) + 1;
?> <FONT class="h2"><?Print $text_conn_types;?></FONT> <BR><BR> <? IF(!IsSet($_GET['page'])) $_GET['page'] = 1; IF(!IsSet($_GET['orderby'])) $_GET['orderby'] = $VA_setup['conn_types_order_by']; IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "conn_types", $_GET['filter_colum']); $query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '"; IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";} $query .= $DB_hub->Real_Escape_String($_GET['filter']); IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins") {$query .= "%";} $query .= "'"; } $result = $DB_hub->Query("SELECT Count(identifier) AS `count` FROM conn_types".$query); $count = $result->Fetch_Assoc(); $total = $count['count']; $result->Free_Result(); $pages = (int)(($total - 1) / $VA_setup['conn_types_results']) + 1;
IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['setuplist_order_by'];} IF($_GET['page'] == ""){$_GET['page'] = 1;} IF($_GET['filter_file'] == "VA_config") {$query = " WHERE (file LIKE 'verliadmin' OR file LIKE 'config')";} ELSEIF($_GET['filter_file'] == "defaults") {$query = " WHERE file LIKE 'defaults'";} ELSEIF($_GET['filter_file'] == "VerliAdmin") {$query = " WHERE file LIKE 'verliadmin'";} ELSEIF($_GET['filter_file'] == "config") {$query = " WHERE file LIKE 'config'";} IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "SetupList", $_GET['filter_colum']); IF(!$_GET['filter_file']) {$query .= " WHERE";} IF($_GET['filter_file']) {$query .= " AND";} $query .= "`".$_GET['filter_colum']."` LIKE '"; IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";} $query .= $DB_hub->Real_Escape_String($_GET['filter']); IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins") {$query .= "%";} $query .= "'"; } $result = $DB_hub->Query("SELECT Count(var) AS `count` FROM SetupList".$query); $count = $result->Fetch_Assoc();
IF($VA_setup['userlog_min_class'] > USR_CLASS) {Die(VA_Error($err_msg_no_access));} ?> <FONT class="h2"><?Print $text_userlog;?></FONT> <BR><BR> <? IF($_GET['page'] == ""){$_GET['page'] = 1;} IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['userlog_order_by'];} IF($_GET['filter'] != "" && $_GET['filter_colum'] && $_GET['filter_type']) { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "pi_iplog", $_GET['filter_colum']); IF($_GET['filter_colum'] == "date") {$filter = DateToInt($_GET['filter']);} ELSE {$filter = $_GET['filter'];} IF($_GET['filter_type'] == "less") {$query = " WHERE `".$_GET['filter_colum']."` < '";} ELSEIF($_GET['filter_type'] == "greater") {$query = " WHERE `".$_GET['filter_colum']."` > '";} ELSE {$query = " WHERE `".$_GET['filter_colum']."` LIKE '";} IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";}
$DB_hub->Query("UPDATE reglist SET enabled = 0 WHERE login_last < ".$time." AND ((class = 1 AND ".$disable_class[1]." <= ".USR_CLASS.") OR (class = 2 AND ".$disable_class[2]." <= ".USR_CLASS."))"); VA_Message($text_affected_rows." : ".$DB_hub->affected_rows, "info32"); } ELSEIF($_POST['del_ina'] && $_POST['age_ina']) { $time = Time() - $_POST['age_ina'] * 86400; $DB_hub->Query("DELETE FROM reglist WHERE login_last < ".$time." AND ((class = 1 AND ".$delete_class[1]." <= ".USR_CLASS.") OR (class = 2 AND ".$delete_class[2]." <= ".USR_CLASS."))"); VA_Message($text_affected_rows." : ".$DB_hub->affected_rows, "info32"); } IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['reglist_order_by'];} IF($_GET['page'] == ""){$_GET['page'] = 1;} IF($_GET['filter'] != "" && $_GET['filter_colum'] && $_GET['filter_type']) { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "reglist", $_GET['filter_colum']); IF($_GET['filter_colum'] == "reg_date" || $_GET['filter_colum'] == "login_last" || $_GET['filter_colum'] == "logout_last" || $_GET['filter_colum'] == "error_last") {$filter = DateToInt($_GET['filter']);} ELSE {$filter = $_GET['filter'];} IF($_GET['filter_type'] == "less") {$query = " WHERE `".$_GET['filter_colum']."` < '";} ELSEIF($_GET['filter_type'] == "greater") {$query = " WHERE `".$_GET['filter_colum']."` > '";} ELSE {$query = " WHERE `".$_GET['filter_colum']."` LIKE '";} IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";} $query .= $DB_hub->Real_Escape_String($filter);
IF($_POST['delete']) {$DB_hub->Query("DELETE FROM pi_messages WHERE `sender` = '".$_POST['sender']."' AND `date_sent` = '".$_POST['date_sent']."' AND `receiver` LIKE '".USR_NICK."'");} ?> <FONT class="h2"><?Print $text_messanger;?></FONT> <BR><BR> <? $query = " WHERE `receiver` LIKE '".USR_NICK."'"; IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "pi_messages", $_GET['filter_colum']); IF($_GET['filter_colum'] == "date_sent" || $_GET['filter_colum'] == "date_expires") {$filter = DateToInt($_GET['filter']);} ELSE {$filter = $_GET['filter'];} IF($_GET['filter_type'] == "less") {$query = " WHERE `".$_GET['filter_colum']."` < '";} ELSEIF($_GET['filter_type'] == "greater") {$query = " WHERE `".$_GET['filter_colum']."` > '";} ELSE {$query = " WHERE `".$_GET['filter_colum']."` LIKE '";} IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";}
?> <FONT class="h2"><?Print $text_file_trigger;?></FONT> <BR><BR> <? IF(!IsSet($_GET['page'])) $_GET['page'] = 1; IF(!IsSet($_GET['orderby'])) $_GET['orderby'] = $VA_setup['file_trigger_order_by']; IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "file_trigger", $_GET['filter_colum']); $query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '"; IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";} $query .= $DB_hub->Real_Escape_String($_GET['filter']); IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins") {$query .= "%";} $query .= "'"; } $result = $DB_hub->Query("SELECT Count(command) AS `count` FROM file_trigger".$query); $count = $result->Fetch_Assoc(); $total = $count['count']; $result->Free_Result(); $pages = (int)(($total - 1) / $VA_setup['file_trigger_results']) + 1;
You should have received a copy of the GNU General Public License along with VerliAdmin; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ IF(USR_CLASS < $VA_setup['stats_min_class']) {Die(VA_Message($err_msg_no_access, "error"));} IF($VA_setup['create_indexes']) { Create_Index($DB_hub, "kicklist", "op"); Create_Index($DB_hub, "banlist", "nick_op"); Create_Index($DB_hub, "unbanlist", "unban_op"); Create_Index($DB_hub, "kicklist", "ip"); Create_Index($DB_hub, "banlist", "nick"); } ?> <FONT class="h2"><?Print $text_stats;?></FONT> <BR><BR> <? GetTables($DB_hub); IF($VA_setup['stats_plugin'] && IsSet($tables['pi_stats'])) { IF(!IsSet($_GET['month'])) { $_GET['month'] = Date(n); $_GET['year'] = Date(Y); }
IF($VA_setup['unbanlist_min_class'] > USR_CLASS) {Die(VA_Message($err_msg_no_access, "error"));}?> <FONT class="h2"><?Print $text_unbanlist;?></FONT> <BR><BR> <? IF($_GET['page'] == ""){$_GET['page'] = 1;} IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['unbanlist_order_by'];} IF($_GET['filter'] != "" && $_GET['filter_colum'] != "") { IF($VA_setup['create_indexes']) Create_Index($DB_hub, "unbanlist", $_GET['filter_colum']); IF($_GET['filter_colum'] == "date_start" || $_GET['filter_colum'] == "date_limit" || $_GET['filter_colum'] == "date_unban") {$filter = DateToInt($_GET['filter']);} ELSE {$filter = $_GET['filter'];} IF($_GET['filter_type'] == "less") {$query = " WHERE `".$_GET['filter_colum']."` < '";} ELSEIF($_GET['filter_type'] == "greater") {$query = " WHERE `".$_GET['filter_colum']."` > '";} ELSE {$query = " WHERE `".$_GET['filter_colum']."` LIKE '";} IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends") {$query .= "%";}