function systemDatabase()
{
$dbMainHost = "db153.pair.com";
$dbMainUser = "******";
$dbMainPass = "******";
$dbMainDbse = "reinfurt_point";
$dbConnect = MYSQL_CONNECT($dbMainHost, $dbMainUser, $dbMainPass);
MYSQL_SELECT_DB($dbMainDbse, $dbConnect);
}
/**
* Connecting To Database;
*
* @param $debug = false;
**/
private function Databases($debug = true)
{
global $config;
$this->db = $config['iSafe']['databases']['db_name'];
$this->db_host = $config['iSafe']['databases']['db_host'];
$this->db_user = $config['iSafe']['databases']['db_user'];
$this->db_pass = $config['iSafe']['databases']['db_pass'];
MYSQL_CONNECT($this->db_host, $this->db_user, $this->db_pass) or die($this->debug(1, __LINE__, __FILE__));
MYSQL_SELECT_DB($this->db) or die($this->debug(2, __LINE__, __FILE__));
}
public function __construct($db)
{
$this->name = $db->getName();
// load relation list for table
$this->relation = $db->relation;
// establish connection to db server
$this->dbResource = @MYSQL_CONNECT($db->server, $db->user, $db->password);
if (!$this->dbResource) {
OLIVError::fire('no database connection');
return FALSE;
} else {
// connection established
// select database and set prefix
@MYSQL_SELECT_DB($this->name);
if (array_key_exists('prefix', $db)) {
$this->prefix = $db['prefix'];
}
return $this->dbResource;
}
}
}
// connected, now lets select the database
if ($dbname) {
if (!@MYSQL_SELECT_DB($dbname, $connection)) {
// The database does not exist... try to create it:
if (!@DB_Query("CREATE DATABASE {$dbname}")) {
$installerrors[] = '创建数据库 "' . $dbname . '" 失败! 您的用户名可能没有创建数据库的权限.<br />' . mysql_error();
} else {
mysql_query("set names 'utf8'");
mysql_query("SET COLLATION_CONNECTION='utf8_general_ci'");
mysql_query("ALTER DATABASE `{$dbname}` DEFAULT CHARACTER SET utf8 COLLATE 'utf8_general_ci'");
if ($sqlversion >= '5.0') {
mysql_query("SET sql_mode=''");
}
// Success! Database created
MYSQL_SELECT_DB($dbname, $connection);
}
}
} else {
$installerrors[] = '请输入数据库名称.';
}
} else {
// could not connect
$installerrors[] = '无法连接MySql数据库服务器, 信息:<br />' . mysql_error();
}
} else {
// mysql extensions not installed
$installerrors[] = '网站服务器环境不支持MySql数据库.';
}
if (!isset($installerrors)) {
$SqlLines = @file('welive.sql');
class parser
{
function parse_message($text, $settings = array())
{
return $text;
}
}
$parser = new parser();
/* END */
preg_match('/^([a-z]+)\\./', $_SERVER['SERVER_NAME'], $subdomain);
if (is_dir($cfg['language_abs'] . '/' . $subdomain[1]) && $subdomain[1] != "") {
$flolang->language = $subdomain[1];
}
$flolang->load("global");
$db = MYSQL_CONNECT($cfg['dbhost'], $cfg['dbuser'], $cfg['dbpasswd']) or die("No Database connection");
MYSQL_SELECT_DB($cfg['dbname'], $db) or die("No Database connection");
MYSQL_QUERY("SET NAMES 'utf8'");
require_once $cfg['root_abs'] . "/functions.php";
define('is_florensia', 1);
require_once $cfg['root_abs'] . "/class_florensia.php";
$florensia = new class_florensia();
$color1 = 255;
$color2 = 255;
$color3 = 255;
$columnname_x = 0;
$columnall_start = 10;
$columnvalue_x = 300;
$picturewidth = 310;
$fontsize = 9;
$steps = 12;
if ($_REQUEST['small']) {
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Test ModRewrite</title>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<?php
@MYSQL_CONNECT("localhost", "iggmp", "grumblfurz34");
@MYSQL_SELECT_DB("iggmp");
$res = mysql_query("SELECT * FROM lang_railway_summary");
echo mysql_num_rows($res);
while ($entry = mysql_fetch_array($res)) {
$text = utf8_encode($entry['content']);
echo $entry['content'] . "<hr>" . $text . "<hr><hr>";
}
?>
</body>
</html>
$i++;
}
$queryitemtables = MYSQL_QUERY("SHOW TABLES FROM florensia LIKE 'server_questtext_%'");
while ($itemtables = MYSQL_FETCH_ARRAY($queryitemtables)) {
$tablelist[$i][$itemtables[0]]['searchkey'] = "questlistid";
$tablelist[$i][$itemtables[0]]['ignore'] = "id";
$i++;
}
/* */
//NOT IMPLEMENTED: server_skilltrees, server_items_idtable, server_upgraderule, server_seal_option
//missbrauch der cache-funktion -> einfacheres einschreiben und ggf. workarounds fuer keys mit nummern/sonderzeichen
$sqldiff = new class_cache();
$sqldiff->load_cache("sqldiff");
$sqldiff->write_cache("timestamp", date("U"));
$dbold = MYSQL_CONNECT($cfg['dbhost'], $cfg['dbuser'], $cfg['dbpasswd'], TRUE) or die("No Database connection");
MYSQL_SELECT_DB("{$oldtable}", $dbold) or die("No Database connection");
MYSQL_QUERY("SET NAMES 'utf8'", $dbold);
foreach ($tablelist as $globalkey => $value) {
foreach ($tablelist[$globalkey] as $table => $tablesettings) {
$diffentries = 0;
$newentries = 0;
unset($allentries, $exceptkeys, $content);
$allentries = array();
$querytabledata = MYSQL_QUERY("SELECT * FROM {$table} " . $tablelist[$globalkey][$table]['dbwhere'], $db);
while ($tabledata = MYSQL_FETCH_ASSOC($querytabledata)) {
$querytabledata_old = MYSQL_QUERY("SELECT * FROM {$table} WHERE " . $tablelist[$globalkey][$table]['searchkey'] . "='" . $tabledata[$tablelist[$globalkey][$table]['searchkey']] . "'", $dbold);
if ($tabledata_old = MYSQL_FETCH_ASSOC($querytabledata_old)) {
foreach (explode(",", $tablelist[$globalkey][$table]['ignore']) as $ignorekey) {
unset($tabledata[$ignorekey], $tabledata_old[$ignorekey]);
}
$arraydiff = array_diff_assoc($tabledata, $tabledata_old);
$dbname = "iemu_ls";
if (isset($_POST['submit'])) {
$login = $_POST['login'];
$password = $_POST['password'];
$email = $_POST['email'];
if (strlen($login) <= 32) {
if (empty($login)) {
echo 'Fill login';
} elseif (empty($password)) {
echo 'Fill password';
} elseif (empty($email)) {
echo 'Fill E-mail';
} else {
$password = md5($password);
if ($msconn = mysql_connect($dbhost, $dbuser, $dbpassword)) {
if (!MYSQL_SELECT_DB($dbname)) {
exit('Select DB Error');
}
$mdpass = md5($login) . $password;
$query = "INSERT INTO accounts (id, login, password, email, email_status, access, hash) VALUES ('', '" . $login . "', '" . $mdpass . "', '" . $email . "', '0', '0', '')";
mysql_query($query);
echo 'Account has been created.';
}
}
}
}
?>
* Include HTML parsing functionality.
* We depend on the presence of the XML_HTMLSax PEAR package for PHP ({@link http://pear.php.net/package/XML_HTMLSax}).
* You can probably install this like this:
*
* pear install XML_HTMLSax
*
*/
require_once 'XML/XML_HTMLSax.php';
/**
* Include RSS feed creation functionality.
* We depend on the presence of FeedCreator.class.php for PHP ({@link http://www.bitfolge.de/rsscreator-en.html}).
*/
require_once "feedcreator.class.php";
// Connect to the MySQL server
MYSQL_CONNECT($db_host, $db_user, $db_pw);
MYSQL_SELECT_DB($db) or die("Unable to select database");
//Select previously indexed URLs from the cache table, and put them into an array $oneurl
$query = "select url from {$db_table}";
$result = MYSQL_QUERY($query);
$howmanyrecords = MYSQL_NUM_ROWS($result);
$currentrecord = 0;
while ($currentrecord < $howmanyrecords) {
$url = trim(MYSQL_RESULT($result, $currentrecord, "url"));
$oneurl[$url] = 1;
$currentrecord++;
}
date_default_timezone_set('America/Halifax');
/**
* Handlers for HTML parsing.
*/
class MyHandler
<?php
$hostname = "localhost";
$username = "******";
$password = "******";
$dbName = "DatabaseName";
MYSQL_CONNECT($hostname, $username, $password) or die("Unable to connect to database.");
MYSQL_SELECT_DB("{$dbName}") or die("Unable to select database");
$thispayment_amount_3 = "480.00";
$thispayment_amount_4 = "720.00";
$thispayment_currency = "USD";
// Validate transaction details against subscription request
if ($txn_type == $thistxn_type && $payment_status == $thispayment_status && ($payment_amount == $thispayment_amount_1 && $item_name == $thisitem_name_1 || $payment_amount == $thispayment_amount_2 && $item_name == $thisitem_name_2 || $payment_amount == $thispayment_amount_3 && $item_name == $thisitem_name_3 || $payment_amount == $thispayment_amount_4 && $item_name == $thisitem_name_4) && $payment_currency == $thispayment_currency && $receiver_email == $thisreceiver_email) {
// Pass
if ($debug) {
$debugString .= "\n 1.0 transaction details validated";
}
// Connect to Subscriptions database
$dbMainHost = "db147b.pair.com";
$dbMainUser = "******";
$dbMainPass = "******";
$dbMainDbse = "reinfurt_servinglibrarysubscriptions";
$dbConnect = MYSQL_CONNECT($dbMainHost, $dbMainUser, $dbMainPass);
MYSQL_SELECT_DB($dbMainDbse, $dbConnect);
// Check that txn_id has not been previously processed
// if duplicate, then exit()
$sql = "SELECT id, notes FROM objects WHERE notes={$txn_id}";
$result = MYSQL_QUERY($sql);
if ($result) {
if ($debug) {
$debugString .= "\n 1.1 txn_id {$txn_id} already exists -- exiting";
}
if ($debug) {
mail($IPNemail, 'debug write', $debugString, $IPNemail);
}
exit("This txn_id already exists");
}
// Pre-process variables
$payment_date = $payment_date ? date("Y-m-d H:i:s", strtotime($payment_date)) : NULL;
<?php
//var_dump($_GET);
if (!isset($_GET['startp'])) {
$_GET['startp'] = "";
$_GET['startp'] = 0;
}
if (!isset($_GET['lpp'])) {
$_GET['lpp'] = 50;
}
$lpp = 50;
if (!isset($_GET['userlog'])) {
$_GET['userlog'] = "";
}
include 'config.inc.php';
MYSQL_CONNECT("{$sql_server}", "{$sql_user}", "{$sql_pw}");
MYSQL_SELECT_DB("{$sql_db}");
$sql = "";
if (!empty($_GET['userlog'])) {
$sql = "SELECT * \n\tFROM ftp_transfer \n\tWHERE username = '******'userlog'] . "' \n\tORDER BY lokale_zeit DESC limit " . $_GET['startp'] . ",{$lpp}";
} else {
$sql = "SELECT * \n\tFROM ftp_transfer \n\tORDER BY lokale_zeit DESC limit " . $_GET['startp'] . ",{$lpp}";
}
$result = MYSQL_QUERY($sql);
$line = 0;
while ($row = mysql_fetch_array($result)) {
if ($line == 0) {
echo "<TR class=\"blau\">\n";
} else {
echo "<TR>\n";
}
//$row[1] = preg_replace("/", "/ ", $row[1]);
require 'include/picmgmt.inc.php';
pageheader($lang_util_php['title']);
if (!GALLERY_ADMIN_MODE) {
die('Access denied');
}
global $albumtbl, $picturetbl, $categorytbl, $usertbl, $lang_util_php;
$albumtbl = $CONFIG['TABLE_PREFIX'] . 'albums';
$picturetbl = $CONFIG['TABLE_PREFIX'] . 'pictures';
$categorytbl = $CONFIG['TABLE_PREFIX'] . 'categories';
$usertbl = $CONFIG['TABLE_PREFIX'] . 'users';
// initialize vars
$startpic = '';
$action = "";
$action = $_POST['action'];
MYSQL_CONNECT($CONFIG['dbserver'], $CONFIG['dbuser'], $CONFIG['dbpass']) or die("can't connect to mysql server");
MYSQL_SELECT_DB($CONFIG['dbname']);
function my_flush()
{
print str_repeat(" ", 4096);
// force a flush
}
function filenametotitle($delete)
{
$albumid = $_POST['albumid'];
$parsemode = $_POST['parsemode'];
global $picturetbl, $lang_util_php;
$query = "SELECT * FROM {$picturetbl} WHERE aid = '{$albumid}'";
$result = MYSQL_QUERY($query);
$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {
<head>
<?php
include 'inc/favicon.inc.php';
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
<title>Unbenanntes Dokument</title>
<?php
$server = "localhost";
$user = "******";
$passwort = "EWbrVxjt";
$datenbank = "db854004";
MYSQL_CONNECT($server, $user, $passwort) or die("Fehler - Datenbankserver nicht erreichbar");
#Verbindung zum Datenbankserver herstellen
MYSQL_SELECT_DB($datenbank) or die("Fehler - Datenbank nicht vorhanden");
#Verbindung zur Datenbank herstellen
$daten = mysql_query("Select * from termine");
#Auswahl - Abfrage (Select) auf die Tabelle Termine (wichtig: Tabelle ist nicht Datenbank)
?>
</head>
<body>
<?php
while ($termine = mysql_fetch_array($daten)) {
# Schleifenbeginn, Ausgabe der Datensätze am Bildschirm
echo $termine[1];
}
?>
<?php
$db_server = "localhost";
$db_name = "bs";
$db_user = "******";
$db_passwort = "bspw";
// when change this, then need to edit schema.sql
define("DB_PREFIX", "bs_");
$db = @MYSQL_CONNECT($db_server, $db_user, $db_passwort) or die("Konnte keine Verbindung zur Datenbank herstellen");
$db_select = @MYSQL_SELECT_DB($db_name);
//$DB_TBLName, $DB_DBName, may also be commented out & passed to the browser
//as parameters in a query string, so that this code may be easily reused for
//any MySQL table or any MySQL database on your server
//DEFINE SQL QUERY:
//edit this to suit your needs
/*
Leave the connection info below as it is:
just edit the above.
(Editing of code past this point recommended only for advanced users.)
*/
//create MySQL connection
$Connect = @MYSQL_CONNECT($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO());
//select database
$Db = @MYSQL_SELECT_DB($DB_DBName, $Connect) or die("Couldn't select database:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO());
//execute query
$result = @MYSQL_QUERY($sql, $Connect) or die("Couldn't execute query:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO());
//if this parameter is included ($w=1), file returned will be in word format ('.doc')
//if parameter is not included, file returned will be in excel format ('.xls')
if (isset($w) && $w == 1) {
$file_type = "msword";
$file_ending = "doc";
} else {
$file_type = "vnd.ms-excel";
$file_ending = "xls";
}
//header info for browser: determines file type ('.doc' or '.xls')
HEADER("Content-Type: application/{$file_type}");
HEADER("Content-Disposition: attachment; filename=database_dump.{$file_ending}");
HEADER("Pragma: no-cache");
