/**
 * Dumpimporter for http://www.my-Playlist.at
 * @author Kevin Reinmüller
 */

error_reporting(E_ALL);
set_time_limit(0);

# MySQL-Server
$mysqlserver='svr';
# MySQL-Server User
$mysqluser='usr';
# MySQL-Server Password
$mysqlpass='yourpass';
# MySQL-Database
$mysqldatabase='database';

$con=mysql_connect($mysqlserver, $mysqluser, $mysqlpass) or die(error($adminmail));
mysql_select_db($mysqldatabase ,$con) or die(error($adminmail));

// Check connection
if(mysqli_connect_errno()) {
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

splitSQL("dump.sql");

function splitSQL($file, $delimiter = ';') {
	if (is_file($file) === true) {
		$file = fopen($file, 'r');
		if (is_resource($file) === true) {
			$query = array();
			while (feof($file) === false) {
				$query[] = fgets($file);
				if (preg_match('~' . preg_quote($delimiter, '~') . '\s*$~iS', end($query)) === 1) {
					$query = trim(implode('', $query));
					if (mysql_query($query) === false) {
						echo '<h3>ERROR: ' . $query . '</h3>' . "</hr>";
					} else {
						echo '<p>SUCCESS</p>' . "</hr>";
					}
					while (ob_get_level() > 0) {
						ob_end_flush();
					}
					flush();
				}
				if (is_string($query) === true) {
					$query = array();
				}
			}
			return fclose($file);
		}
	}
	return false;
}