/**
* Install schema into the database
*
* @param string $filename location of database schema file
* @param dbconn $conn connection to database
* @param string $type type of database, currently mysql or pgsql
*
* @return boolean - indicating success or failure
*/
function runDbScript($filename, $conn, $type = 'mysqli')
{
$sql = trim(file_get_contents(INSTALLDIR . '/db/' . $filename));
$stmts = explode(';', $sql);
foreach ($stmts as $stmt) {
$stmt = trim($stmt);
if (!mb_strlen($stmt)) {
continue;
}
// FIXME: use PEAR::DB or PDO instead of our own switch
switch ($type) {
case 'mysqli':
$res = $conn->query($stmt);
if ($res === false) {
$error = $conn->error();
}
break;
case 'pgsql':
$res = pg_query($conn, $stmt);
if ($res === false) {
$error = pg_last_error();
}
break;
default:
$this->updateStatus("runDbScript() error: unknown database type " . $type . " provided.");
}
if ($res === false) {
$this->updateStatus("ERROR ({$error}) for SQL '{$stmt}'");
return $res;
}
}
return true;
}
$starttime = time();
while (!feof($fp) && time() < $starttime + 5) {
$_SESSION['ca_pic']['data'] .= fread($fp, 8192);
}
fclose($fp);
}
$_SESSION['ca_pic']['dirty'] = true;
}
}
break;
case "reset":
unset($_SESSION['ca_pic']);
break;
}
if (!isset($_SESSION['ca_pic'])) {
$_SESSION['ca_pic'] = array();
$_SESSION['ca_pic']['dirty'] = false;
$db = new dbconn();
$return = $db->query("SELECT picture FROM pictures WHERE id=" . $_SESSION['ca_id']);
if ($db->row_count($return) > 0) {
$_SESSION['ca_pic']['in_db'] = true;
$arr = $db->fetch_row($return);
$_SESSION['ca_pic']['data'] = $arr[0];
} else {
$_SESSION['ca_pic']['in_db'] = false;
$fp = fopen("unknown.jpg", "rb");
$_SESSION['ca_pic']['data'] = fread($fp, 906240);
fclose($fp);
}
}
echo $_SESSION['ca_pic']['data'];
