function query_mult_assoc($query) { global $log_all, $log_error; if ($result = mysql_query(quote_smart($query))) { while ($row = mysql_fetch_assoc($result)) { $array[] = $row; } if ($log_all == 1) { logSQL($query); } return isset($array) ? $array : ''; } if ($log_error == 1) { logSQL($query . " - Error: " . mysql_error()); } else { mysql::error($query . " - " . mysql_error()); } }
public function query($statement) { $mysql = new mysql($this->db_handle); $statement = $this->replaceTablePrefix($statement); $mysql->query($statement); $this->set_error($mysql->error()); if ($mysql->error()) { return null; } else { return $mysql; } }
function step5($data) { if ($_POST['meta_name'] == "" || $_POST['alli_tag'] == "" || $_POST['alli_name'] == "" || $_POST['user_name'] == "" || $_POST['user_password'] == "" || $_POST['user_coords1'] == "" || $_POST['user_coords2'] == "") { return "Du musst alle Felder ausfüllen."; } echo "<div style=\"border:1px #000000 solid;width:400px;padding:3px;\"><b>Schritt 5: Abschluß der Installation</b><div style=\"text-align:left\">"; $t =& $_SESSION['install']['mysql']; $file = @fopen("../accdata.php", "w"); if (!$file) { echo "<div style=\"color:#800000\">Die Datei accdata.php konnte nicht zum schreiben öffnen. Trage die Mysqldaten bitte nachträglich ein.</div>"; } else { fwrite($file, "<?php\n // Account Daten\n \$db_info['host'] = '" . $t['host'] . "';\n \$db_info['user'] = '******'username'] . "';\n \$db_info['password'] = '******'password'] . "';\n \$db_info['dbname'] = '" . $t['database'] . "';\n \$pfadzumtick = '" . $_SESSION['install']['tic_adress'] . "'; // Der Schrägstrich am Ende ist wichtig!\n\n \$tic_status = array('" . implode("', '", $GLOBALS['status']) . "');\n \$tic_version = array(" . implode(", ", $GLOBALS['version']) . ");\n ?>"); fclose($file); @chmod("../accdata.php", 0777); } $mysql = new mysql(array('host' => $t['host'], 'user' => $t['username'], 'password' => $t['password'], 'dbname' => $t['database'])); unset($t); if (isset($_SESSION['install']['tables'])) { include "sql.php"; foreach ($_SESSION['install']['tables'] as $table) { $mysql->multiquery($sqlquery[$table]) or die($mysql->error(__FILE__, __LINE__)); } } $mysql->insert("gn4meta", "name, sysmsg", "'" . $_POST['meta_name'] . "', 'Wenn dieser Text zu lesen ist dann ist leuft der TIC diese Nachricht kann unter Managment geändert werden.'") or die($mysql->error(__FILE__, __LINE__)); $ticid = $mysql->insert_id(); $mysql->insert("gn4vars", "name, value, ticid", "'lastscanclean', '" . date("H:n d.m.Y.") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'forumpriority', '0', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'lasttick', '" . date("H:n:s") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'style', '../gnstyle', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'attplaner', 'aktiv', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'botpw', '', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'tickdauer', '15', '" . $ticid . "'") or die(mysql_error(__FILE__, __LINE__)); $mysql->insert("gn4allianzen", "ticid, name , tag", "'" . $ticid . "', '" . $_POST['alli_name'] . "', '" . $_POST['alli_tag'] . "'") or die($mysql->error(__FILE__, __LINE__)); $alli_id = $mysql->insert_id(); $mysql->insert("gn4accounts", "ticid, name, passwort, galaxie, planet, rang, allianz", "'" . $ticid . "', '" . $_POST['user_name'] . "', '" . md5($_POST['user_password']) . "', '" . $_POST['user_coords1'] . "', '" . $_POST['user_coords2'] . "', '5', '" . $alli_id . "'") or die($mysql->error(__FILE__, __LINE__)); echo "Die Installation wurde erfolgreich abgeschlossen.<br />Bitte lösche den Ordner installer vom Server.<br />Danach kannst du dich <a href=\"../index.php\">hier</a> mit deinen Accountdaten einloggen.</div>"; return ""; }
# Tentative de connexion à la base de données $con_id = mysqli_connect(${$environement . '_host'}, ${$environement . '_user'}, ${$environement . '_password'}); if (!$con_id) { $errors->set('MySQL: ' . mysqli_connect_errno() . ' ' . mysqli_connect_error()); } else { mysqli_query($con_id, "CREATE DATABASE IF NOT EXISTS " . ${$environement . '_database'}); $db = mysqli_select_db($con_id, ${$environement . '_database'}); if (!$db) { $errors->set('MySQL: ' . mysqli_errno($con_id) . ' ' . mysqli_error($con_id)); } mysqli_close($con_id); } if ($errors->isEmpty()) { $db = new mysql(); $db->init(${$environement . '_user'}, ${$environement . '_password'}, ${$environement . '_host'}, ${$environement . '_database'}); if ($db->error()) { $errors->set($db->error()); } else { # Création du fichier de configuration $configfile = OKT_CONFIG_PATH . '/connexion.php'; $config = implode('', (array) file($configfile . '.in')); $config = str_replace('%%DB_PROD_HOST%%', $prod_host, $config); $config = str_replace('%%DB_PROD_USER%%', $prod_user, $config); $config = str_replace('%%DB_PROD_PASS%%', $prod_password, $config); $config = str_replace('%%DB_PROD_BASE%%', $prod_database, $config); $config = str_replace('%%DB_PROD_PREFIX%%', $prod_prefix, $config); $config = str_replace('%%DB_DEV_HOST%%', $dev_host, $config); $config = str_replace('%%DB_DEV_USER%%', $dev_user, $config); $config = str_replace('%%DB_DEV_PASS%%', $dev_password, $config); $config = str_replace('%%DB_DEV_BASE%%', $dev_database, $config); $config = str_replace('%%DB_DEV_PREFIX%%', $dev_prefix, $config);
function query($statement) { $mysql = new mysql($this->db_handle); $mysql->query($statement); $this->set_error($mysql->error()); if ($mysql->error()) { return null; } else { return $mysql; } }