From 1fe76ba743a3418da9a0883b29756d442384d0bc Mon Sep 17 00:00:00 2001
From: Horus3
Date: Thu, 25 Sep 2014 10:33:47 +0200
Subject: init

---
 bootstrap/class/mysql.php | 153 ----------------------------------------------
 1 file changed, 153 deletions(-)
 delete mode 100644 bootstrap/class/mysql.php

(limited to 'bootstrap/class/mysql.php')

diff --git a/bootstrap/class/mysql.php b/bootstrap/class/mysql.php
deleted file mode 100644
index 8d75538..0000000
--- a/bootstrap/class/mysql.php
+++ /dev/null
@@ -1,153 +0,0 @@
-<?php
-
-class db {
-	
-	protected $db;
-
-	public function __construct(){
-		$this->open();
-	}
-
-	public function open(){
-		try {
-			$this->db = new mysqli(DBHOST, DBUSER, DBPASSWORD, DBNAME);	
-		} catch (Exception $e){
-			failure("<p>".$e->getMessage()."</p>", '500 Server Failure', false, '<h1>Failed to open database connection.</h1>');
-		}
-
-		if ( $this->db->connect_errno ){
-			failure("<p>Can't connect to the database. MySQL gave this error code: " . $this->db->connect_errno . "</p>", '500 Server Failure', false, '<h1>Connection to MySQL server failed.</h1>');
-		}
-
-		if ( ! $this->db->ping() ){
-			failure("<p>Can't reach MySQL server. Server says: " . $this->db->error . "</p>", '500 Server Failure', false, "<h1>Can't reach MySQL server!</h1>");
-		}
-
-		if ( ! $this->db->set_charset(DBCHARSET) ){
-			failure("<p>Can't set " . DBCHARSET . " as the charset on your MySQL server.</p>" , '500 Server Failure', false, "<h1>Setting Charset failed!</h1>");
-		}
-
-	}
-
-	public function close(){
-		$this->db->close();	
-	}
-
-	public function check(){
-		if ( ! $this->db->ping() ){
-			return false;
-		}
-
-		return true;
-	}
-
-	# does a single MySQL query with output (SELECT, INSERT, UPDATE... )
-	public function doQuery($string){
-		if ( ! $this->check() )
-			return false;
-
-		return $this->db->query($string);
-	}
-
-	# does multiple queries WITHOUT output (INSERT, UPDATE, DELETE... )
-	public function execMultipleQueries($sql){
-		if ( ! $this->check() )
-			return false;	
-
-		$result = $this->db->multi_query($sql);
-		if ( ! $result )
-			return false;
-
-		do {
-			if( ! $this->db->more_results() )	
-				break;
-			if ( ! $this->db->next_result() ){
-				if ( $this->db->error != "" ){
-					//$result->free();
-					return false;
-				}
-			}
-		} while (true);
-
-		return true;
-	}
-
-	# code by WordPress. See @link https://core.trac.wordpress.org/browser/branches/4.0/src/wp-includes/wp-db.php#L1154
-	# syntax like sprintf()
-	public function prepare( $query, $args ) {
-		if ( is_null( $query ) )
-			return;
-		
-		// This is not meant to be foolproof -- but it will catch obviously incorrect usage.
-		if ( strpos( $query, '%' ) === false ) {
-			return false;
-		}
-		
-		$args = func_get_args();
-		array_shift( $args );
-
-		// If args were passed as an array (as in vsprintf), move them up
-		if ( isset( $args[0] ) && is_array($args[0]) )
-			$args = $args[0];
-
-		$query = str_replace( "'%s'", '%s', $query ); // in case someone mistakenly already singlequoted it
-		$query = str_replace( '"%s"', '%s', $query ); // doublequote unquoting
-		$query = preg_replace( '|(?<!%)%f|' , '%F', $query ); // Force floats to be locale unaware
-		$query = preg_replace( '|(?<!%)%s|', "'%s'", $query ); // quote the strings, avoiding escaped strings like %%s
-
-		array_walk( $args, array( $this, '_escape_by_ref' ) );
-
-		return @vsprintf( $query, $args );
-	}
-
-	private function _escape_by_ref( &$string ){
-		if ( ! is_float( $string ) )
-			$string = $this->_real_escape( $string );
-	}
-
-	private function _real_escape( $string ){
-		return $this->db->real_escape_string($string);
-	}
-	# WordPress End
-
-	public function createTables(){
-		$user_table = 
-		'CREATE TABLE IF NOT EXISTS ' . DBPREFIX . 'user 
-			( id INTEGER AUTO_INCREMENT NOT NULL, PRIMARY KEY(id), 
-			name VARCHAR(70), UNIQUE(name), 
-			password VARCHAR(70), UNIQUE(password), 
-			email VARCHAR(70), UNIQUE(email), 
-			register INTEGER 
-			) ENGINE=InnoDB;';
-
-		$banned_user_table = 
-		'CREATE TABLE IF NOT EXISTS ' . DBPREFIX . 'banned_user
-			( banned_id INTEGER AUTO_INCREMENT NOT NULL, PRIMARY KEY(banned_id),
-			login_attempts INTEGER,
-			ip TEXT,
-			session_id TEXT,
-			time INTEGER,
-			user INTEGER
-			)
-		ENGINE=InnoDB;';
-
-		$jg_table = 
-		'CREATE TABLE IF NOT EXISTS ' . DBPREFIX . 'member
-			( member_id INTEGER AUTO_INCREMENT NOT NULL, PRIMARY KEY(member_id),
-			name varchar(70), UNIQUE(name),
-			adresse TEXT,
-			telefonnummer TEXT,
-			handynummer TEXT,
-			email varchar(70), UNIQUE(email),
-			geburtstag TEXT
-			)
-		ENGINE=InnoDB;';
-
-		if ( ! $this->execMultipleQueries('BEGIN; '. $user_table . ' ' . $banned_user_table . ' ' . $jg_table . ' COMMIT;') )
-			failure("<p>There was a problem during bootstrapping the database schema. " . $this->db->error . "</p>", '500 Server Failure', false, "<h1>CREATE TABLE FAILED</h1>");
-	}
-	
-	public function __destruct(){
-		$this->close();
-	}
-}
-- 
cgit v1.2.3