function MSD_mysql_connect($encoding = 'utf8', $keycheck_off = false, $actual_table = '') { global $config, $databases; $port = isset($config['dbport']) && !empty($config['dbport']) ? ':' . $config['dbport'] : ''; $socket = isset($config['dbsocket']) && !empty($config['dbsocket']) ? ':' . $config['dbsocket'] : ''; $config['dbconnection'] = mysql_connect($config['dbhost'] . $port . $socket, $config['dbuser'], $config['dbpass']) or die(SQLError("Database connection error: ", mysql_error())); if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } if (!isset($config['mysql_standard_character_set']) || $config['mysql_standard_character_set'] == '') { get_sql_encodings(); } if ($config['mysql_standard_character_set'] != $encoding) { $set_encoding = @mysql_query('SET NAMES \'' . $encoding . '\'', $config['dbconnection']); if ($set_encoding === false) { $config['mysql_can_change_encoding'] = false; } else { $config['mysql_can_change_encoding'] = true; } } if ($keycheck_off) { mysql_query('SET FOREIGN_KEY_CHECKS=0', $config['dbconnection']); } return $config['dbconnection']; }
function MSD_mysql_connect($encoding = 'utf8', $keycheck_off = false, $actual_table = '') { global $config, $databases; if (isset($config['dbconnection']) && is_resource($config['dbconnection'])) { return $config['dbconnection']; } $port = isset($config['dbport']) && !empty($config['dbport']) ? ':' . $config['dbport'] : ''; $socket = isset($config['dbsocket']) && !empty($config['dbsocket']) ? ':' . $config['dbsocket'] : ''; $config['dbconnection'] = @mysql_connect($config['dbhost'] . $port . $socket, $config['dbuser'], $config['dbpass']) or die(SQLError("Error establishing a database connection!", mysql_error())); if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } if (!isset($config['mysql_standard_character_set']) || $config['mysql_standard_character_set'] == '') { get_sql_encodings(); } if ($config['mysql_standard_character_set'] != $encoding) { $set_encoding = @mysql_query('SET NAMES \'' . $encoding . '\'', $config['dbconnection']); if ($set_encoding === false) { $config['mysql_can_change_encoding'] = false; } else { $config['mysql_can_change_encoding'] = true; } } if ($keycheck_off) { // only called with this param when restoring mysql_query('SET FOREIGN_KEY_CHECKS=0', $config['dbconnection']); // also set SQL-Mode NO_AUTO_VALUE_ON_ZERO for magento users mysql_query('SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"', $config['dbconnection']); } return $config['dbconnection']; }
function MSD_mysql_connect() { global $config, $databases; $port = isset($config['dbport']) && !empty($config['dbport']) ? ":" . $config['dbport'] : ""; $socket = isset($config['dbsocket']) && !empty($config['dbsocket']) ? ":" . $config['dbsocket'] : ""; $config['dbconnection'] = @mysql_connect($config['dbhost'] . $port . $socket, $config['dbuser'], $config['dbpass']) or die(SQLError("Datenbankverbindung", mysql_error())); if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } return true; }
/** * Creates the first statusline with information for backup files * * @return string */ function getStatusLine() { // strcuture of status line: // -- Status:nrOfTables:nrOfRecords:Multipart:database:script: // scriptversion:comment:MySQL-Version:Backupflags(unused):SQLBefore: //SQLAfter:Charset:CharsetEXTINFO global $databases, $config, $dump; if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } $tline = "-- \n-- TABLE-INFO\r\n"; foreach ($dump['databases'][$dump['db_actual']]['tables'] as $tableName => $val) { $tline .= "-- TABLE|" . $tableName . '|' . $val['records'] . '|' . $val['data_length'] . '|' . $val['update_time'] . '|' . $val['engine'] . "\n"; } $flags = 1; $mp = 'MP_0'; if ($config['multi_part'] == 1) { $mp = "MP_" . ($dump['part'] - $dump['part_offset']); } $statusline = "-- Status:" . $dump['databases'][$dump['db_actual']]['table_count'] . ':' . $dump['databases'][$dump['db_actual']]['records_total'] . ":{$mp}:" . $dump['db_actual'] . ":PHP:" . MSD_VERSION . ":" . $dump['comment'] . ":"; $statusline .= MSD_MYSQL_VERSION . ":{$flags}:::" . $dump['dump_encoding'] . ":EXTINFO\n" . $tline . "-- " . "EOF TABLE-INFO\n-- "; return $statusline; }
/** * Receive all possible MySQL character sets and save standard to $config['mysql_standard_charset'] */ function get_sql_encodings() { global $config; unset($config['mysql_possible_character_sets']); if (!isset($config['dbconnection'])) { MSD_mysql_connect(); } $erg = false; $config['mysql_standard_character_set'] = ''; $config['mysql_possible_character_sets'] = array(); if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } $v = explode('.', MSD_MYSQL_VERSION); $config['mysql_can_change_encoding'] = false; if ($v[0] <= 4 && $v[1] < 1 || $v[0] <= 3) { // MySQL < 4.1 $config['mysql_can_change_encoding'] = false; $sqlt = 'SHOW VARIABLES LIKE \'character_set%\''; $res = MSD_query($sqlt) or die(SQLError($sqlt, mysql_error())); if ($res) { while ($row = mysql_fetch_row($res)) { if ($row[0] == 'character_set') { $config['mysql_standard_character_set'] = $row[1]; if ($v[0] == 3) { $config['mysql_possible_character_sets'][0] = $row[1]; } } if ($row[0] == 'character_sets' && $v[0] > 3) { $config['mysql_possible_character_sets'] = explode(' ', $row[1]); sort($config['mysql_possible_character_sets']); } } } } else { // MySQL-Version >= 4.1 $config['mysql_can_change_encoding'] = true; $sqlt = 'SHOW CHARACTER SET'; $res = MSD_query($sqlt) or die(SQLError($sqlt, mysql_error())); if ($res) { while ($row = mysql_fetch_row($res)) { $config['mysql_possible_character_sets'][] = $row[0] . ' - ' . $row[1]; } sort($config['mysql_possible_character_sets']); } $sqlt = 'SHOW VARIABLES LIKE \'character_set_connection\''; $res = MSD_query($sqlt) or die(SQLError($sqlt, mysql_error())); if ($res) { while ($row = mysql_fetch_row($res)) { $config['mysql_standard_character_set'] = $row[1]; } } } }
$lastBu = array(); if ($action == '') { $action = 'status'; } include './inc/define_icons.php'; if (isset($_POST['htaccess']) || $action == 'schutz') { include './inc/home/protection_create.php'; } elseif ($action == 'edithtaccess') { include './inc/home/protection_edit.php'; } elseif ($action == 'deletehtaccess') { include './inc/home/protection_delete.php'; } if ($action == 'status') { $htaExists = file_exists('./.htaccess'); if (!defined('MSD_MYSQL_VERSION')) { GetMySQLVersion(); } // find latest backup file $dh = opendir($config['paths']['backup']); while (false !== ($fileName = readdir($dh))) { if ($fileName != '.' && $fileName != '..' && !is_dir($config['paths']['backup'] . $fileName)) { $files[] = $fileName; $sumFiles++; $sumSize += filesize($config['paths']['backup'] . $fileName); $ft = filectime($config['paths']['backup'] . $fileName); if (!isset($lastBu[2]) || isset($lastBu[2]) && $ft > $lastBu[2]) { $lastBu[0] = $fileName; $lastBu[1] = date("d.m.Y H:i", $ft); $lastBu[2] = $ft; } }