X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=libs%2Flib_connect.php;h=952445486d1b0429e97be130b96ddeb6c5e00daf;hb=3f5cd5b92d3ea339f3d099c3fa8e65b0bc0f1533;hp=c704fcf793072cb60098b4791b416fa627fe3873;hpb=1c0b801f6514cf9675efead98fcb41a052ffb0b8;p=ctracker.git diff --git a/libs/lib_connect.php b/libs/lib_connect.php index c704fcf..9524454 100644 --- a/libs/lib_connect.php +++ b/libs/lib_connect.php @@ -2,11 +2,11 @@ /** * Database connection library * - * @author Roland Haeder + * @author Roland Haeder * @version 3.0.0 - * @copyright Copyright (c) 2009 - 2011 Cracker Tracker Team + * @copyright Copyright (c) 2009 - 2017 Cracker Tracker Team * @license GNU GPL 3.0 or any newer version - * @link http://www.ship-simu.org + * @link http://www.shipsimu.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by @@ -46,9 +46,9 @@ function aquireCrackerTrackerDatabaseLink () { // Inits a fake configurtation function crackerTrackerInitFakeConfig () { // Set the array - $GLOBALS['ctracker_config'] = array( + $GLOBALS['ctracker_config'] = [ 'ctracker_alert_user' => 'Y', - ); + ]; } // Checks if the link is up @@ -96,7 +96,7 @@ function crackerTrackerCloseDatabaseLink () { } // END - if } -// Inserts given array, if IP/check_worm combination was not found +// Inserts given array, if IP/check_get combination was not found function crackerTrackerInsertArray ($table, $rowData) { // Is there a link up? if (!isCrackerTrackerDatabaseLinkUp()) { @@ -107,13 +107,13 @@ function crackerTrackerInsertArray ($table, $rowData) { // Is it found? if (!isCrackerTrackerEntryFound($rowData)) { // Prepare SQL - $SQL = 'INSERT INTO `' . $table . '` (`' . implode('`,`', array_keys($rowData)) . '`) VALUES(' . implode_secure($rowData) . ')'; + $sqlString = 'INSERT INTO `' . $table . '` (`' . implode('`,`', array_keys($rowData)) . '`) VALUES(' . implode_secure($rowData) . ')'; // Reset insert id $GLOBALS['ctracker_last_insert_id'] = FALSE; // Run it - runCrackerTrackerSql($SQL, __FUNCTION__, __LINE__); + runCrackerTrackerSql($sqlString, __FUNCTION__, __LINE__); // Remember the last insert id $GLOBALS['ctracker_last_insert_id'] = mysqli_insert_id($GLOBALS['ctracker_link']) or crackerTrackerDatabaseError(__FUNCTION__, __LINE__); @@ -124,21 +124,21 @@ function crackerTrackerInsertArray ($table, $rowData) { } // Updates a given entry by just counting it up -function updateCrackerTrackerEntry ($rowData) { +function updateCrackerTrackerEntry (array $rowData) { // Construct the SELECT query - $SQL = 'UPDATE `ctracker_data` SET `count`=`count`+1 WHERE (`remote_addr`="' . crackerTrackerEscapeString($rowData['remote_addr']) . '" OR `proxy_addr`="' . crackerTrackerEscapeString($rowData['proxy_addr']) . '") AND `check_worm` = "' . crackerTrackerEscapeString($rowData['check_worm']) . '" LIMIT 1'; + $sqlString = 'UPDATE `ctracker_data` SET `count`=`count`+1 WHERE (`remote_addr`="' . crackerTrackerEscapeString($rowData['remote_addr']) . '" OR `proxy_addr`="' . crackerTrackerEscapeString($rowData['proxy_addr']) . '") AND `` = "' . crackerTrackerEscapeString($rowData['']) . '" LIMIT 1'; // Run the SQL and check if we have one line - runCrackerTrackerSql($SQL, __FUNCTION__, __LINE__); + runCrackerTrackerSql($sqlString, __FUNCTION__, __LINE__); } -// Checks if an entry with IP/check_worm/domain combination is there -function isCrackerTrackerEntryFound ($rowData) { +// Checks if an entry with IP/check_get/domain combination is there +function isCrackerTrackerEntryFound (array $rowData) { // Construct the SELECT query - $SQL = 'SELECT `id` FROM `ctracker_data` WHERE (`remote_addr`="' . crackerTrackerEscapeString($rowData['remote_addr']) . '" OR `proxy_addr`="' . crackerTrackerEscapeString($rowData['proxy_addr']) . '") AND `check_worm` = "' . crackerTrackerEscapeString($rowData['check_worm']) . '" AND `server_name`="' . crackerTrackerEscapeString($rowData['server_name']) . '" LIMIT 1'; + $sqlString = 'SELECT `id` FROM `ctracker_data` WHERE (`remote_addr`="' . crackerTrackerEscapeString($rowData['remote_addr']) . '" OR `proxy_addr`="' . crackerTrackerEscapeString($rowData['proxy_addr']) . '") AND `check_get` = "' . crackerTrackerEscapeString($rowData['check_get']) . '" AND `server_name`="' . crackerTrackerEscapeString($rowData['server_name']) . '" LIMIT 1'; // Run the SQL and check if we have one line - return ((isCrackerTrackerDatabaseLinkUp()) && (mysqli_num_rows(runCrackerTrackerSql($SQL, __FUNCTION__, __LINE__)) == 1)); + return ((isCrackerTrackerDatabaseLinkUp()) && (mysqli_num_rows(runCrackerTrackerSql($sqlString, __FUNCTION__, __LINE__)) == 1)); } // Escapes the string @@ -160,7 +160,7 @@ function crackerTrackerEscapeString ($string) { } // END - if // Runs an SQL query and checks for errors -function runCrackerTrackerSql ($SQL, $F, $L) { +function runCrackerTrackerSql ($sqlString, $function, $line) { // Is the link up? if (!isCrackerTrackerDatabaseLinkUp()) { // Abort here @@ -168,10 +168,10 @@ function runCrackerTrackerSql ($SQL, $F, $L) { } // END - if // Remember last SQL - $GLOBALS['ctracker_last_sql'] = $SQL; + $GLOBALS['ctracker_last_sql'] = $sqlString; // Run the query - $GLOBALS['ctracker_last_result'] = mysqli_query($GLOBALS['ctracker_link'], $SQL) or crackerTrackerDatabaseError(__FUNCTION__, __LINE__); + $GLOBALS['ctracker_last_result'] = mysqli_query($GLOBALS['ctracker_link'], $sqlString) or crackerTrackerDatabaseError($function, $line); // And return it return $GLOBALS['ctracker_last_result']; @@ -208,31 +208,31 @@ function isCrackerTrackerTableCreated ($table) { // Creates the given table with columns function crackerTrackerCreateTable ($table, array $columns, array $keys) { // Begin the SQL - $SQL = 'CREATE TABLE IF NOT EXISTS `' . $table . '` ('; + $sqlString = 'CREATE TABLE IF NOT EXISTS `' . $table . '` ('; // Add table name as first column - $SQL .= '`' . $table . '` BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT, '; + $sqlString .= '`' . $table . '` BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT, '; // Add all columns foreach ($columns as $column=>$type) { // Add this entry - $SQL .= '`' . $column . '` ' . $type . ', '; + $sqlString .= '`' . $column . '` ' . $type . ', '; } // END - foreach // Add table name as primary key - $SQL .= 'PRIMARY KEY (`' . $table . '`), '; + $sqlString .= 'PRIMARY KEY (`' . $table . '`), '; // Add keys foreach ($keys as $key=>$type) { // Add this entry - $SQL .= '' . $type . ' (`' . $key . '`), '; + $sqlString .= '' . $type . ' (`' . $key . '`), '; } // END - foreach // Finish SQL - $SQL = substr($SQL, 0, -2) . ') TYPE=InnoDB'; + $sqlString = substr($sqlString, 0, -2) . ') TYPE=InnoDB'; // And run it - runCrackerTrackerSql($SQL); + runCrackerTrackerSql($sqlString); } // Inits a table by inserting @@ -367,14 +367,14 @@ function ifCrackerTrackerIpHasTicket () { // Adds a ticket based on given (mostly $_POST) data function addCrackerTrackerTicket (array $data) { // Prepare the array - $GLOBALS['ctracker_last_ticket'] = array( + $GLOBALS['ctracker_last_ticket'] = [ 'ctracker_ticket_remote_addr' => determineCrackerTrackerRealRemoteAddress(), 'ctracker_ticket_proxy_addr' => getenv('REMOTE_ADDR'), 'ctracker_ticket_user_agent' => crackerTrackerUserAgent(), 'ctracker_ticket_name' => crackerTrackerSecureString($data['name']), 'ctracker_ticket_email' => crackerTrackerSecureString($data['email']), 'ctracker_ticket_comment' => crackerTrackerSecureString($data['comment']) - ); + ]; // Insert it crackerTrackerInsertArray('ctracker_ticket', $GLOBALS['ctracker_last_ticket']); @@ -382,10 +382,10 @@ function addCrackerTrackerTicket (array $data) { // Is there an entry? if ((isset($GLOBALS['ctracker_last_insert_id'])) && ($GLOBALS['ctracker_last_insert_id'] > 0)) { // All fine, so prepare the link between ticket<->data - $data = array( + $data = [ 'ctracker_ticket_id' => $GLOBALS['ctracker_last_insert_id'], 'ctracker_data_id' => $GLOBALS['ctracker_last_suspicious_entry']['id'] - ); + ]; // And insert it as well crackerTrackerInsertArray('ctracker_ticket_data', $data); @@ -415,6 +415,3 @@ function freeCrackerTrackerResult (mysqli_result $result) { // Free result $result->free(); } - -// [EOF] -?>