/** * 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'];