<?php
$username = "";
$password = "";
$hostname = "";
$dbname = '';

//connection to the database
$db = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
mysql_select_db($dbname);

$filename = "../config/sql/kinspire_mysql.sql";

$msg = false;
$sql = false;
if ($f = fopen($filename, 'r')) do {
    $line = fgets($f);
    $line = trim($line);
    if(!@ereg('^--', $line))
    {
        $sql .= " " . $line;
    }
} while (!feof($f));
fclose($f);

if(!$sql) {
    $msg = "No queries found in $filename";
    return false;
}

$queries = explode(';', $sql);

foreach($queries as $query) {
    $query = trim($query);
    if($query == "") {
        continue;
    }
    if(!mysql_query($query . ';')) {
        $msg = "query " . $query . " failed";
        return false;
    }
}

if ($msg === false) {
    $msg = "Done";
}

echo $msg;

mysql_close();
?>