function display_duck_blinds()
{
$dbinfo = initialize_db_info();
#report_database_settings($dbinfo);
try {
$db_link = db_connect($dbinfo);
db_select($db_link, $dbinfo);
} catch (Exception $e) {
echo report_exception("Database Connection", $e);
echo report_database_settings($dbinfo);
}
$sql = generate_blind_list_sql();
$result_rows = mysql_query($sql, $db_link);
if (!$result_rows) {
echo $sql;
$message = 'Invalid query: ' . mysql_error() . "\n";
echo $message;
throw new Exception('No Results.');
}
echo '<table>';
while ($row = mysql_fetch_array($result_rows, MYSQL_ASSOC)) {
//echo generate_blind_row($row);
}
echo '</table>';
}
function registerX($email, $password, $first_name, $last_name)
{
// Register new person with db
// Return true or error message
// Connect to db
$dbinfo = initialize_db_info();
//report_database_settings($dbinfo);
try {
$db_link = db_connect($dbinfo);
db_select($db_link, $dbinfo);
} catch (Exception $e) {
echo report_exception("Database Connection", $e);
echo report_database_settings($dbinfo);
}
// Check if username is unique
$uniqueSql = "select * from login where email='" . $email . "'";
echo report_name_value("uniqueSql", $uniqueSql);
$result_rows = mysql_query($uniqueSql, $db_link);
if (!$result_rows) {
throw new Exception('Could not execute query');
}
$numberOfRows = mysql_num_rows($result_rows);
if ($numberOfRows > 0) {
throw new Exception('That email is taken - go back and choose another one.');
}
$insert_sql = generateUserInsertSql($email, $password, $first_name, $last_name);
$result_rows = mysql_query($insert_sql, $db_link);
if (!$result_rows) {
throw new Exception('Could not register you in database - please try again later. (' . $insert_sql . ')');
}
return true;
}
/**
* Geeft de uitvoer van een component als string.
* (Uitvoer zoals emails en header() worden niet afgevangen).
*
* @param Component $component
*
* @return string
*/
function component_to_string($component)
{
if (is_valid_component($component) === false) {
return false;
}
ob_start();
try {
$component->render();
} catch (Exception $e) {
$output = ob_get_clean();
report_exception($e);
return $output;
}
return ob_get_clean();
}
function db_connect($dbinfo)
{
$server = $dbinfo->getServer();
$user = $dbinfo->getUser();
$password = $dbinfo->getPassword();
try {
$db_link = mysql_connect($server, $user, $password);
} catch (Exception $e) {
echo report_exception("Database Connection", $e);
}
if (!$db_link) {
throw new Exception('Could not connect to database server');
} else {
return $db_link;
}
}
try
{
$config_cache = Cache::getInstance("cached_config");
$route_config = "configs/routes.xml";
$store_config = "configs/db.xml";
$min_time = max(filemtime($route_config), filemtime($store_config));
if ($config = $config_cache->get($min_time))
{
$routes = $config->routes;
}
else
{
$config = Config::getInstance();
$config->loadXML($store_config, "storage");
$routes = $config->loadXML($route_config, "routes");
$config_cache->put($config);
}
//$dispatcher = new Dispatcher_Cached($routes["site"]);
$dispatcher = new Dispatcher($routes['site']);
$dispatcher->run();
} catch (Exception $e) {
report_exception($e);
}
$end_time = microtime(true);
//include("debug.php");
?>
} catch (Error $e) {
if ($e->getTitle() == 'Lock Error') {
echo "can't get lock for {$uid}\n";
} else {
throw $e;
}
}
}
$query = "\n SELECT orderid\n FROM orderbook\n WHERE processed=FALSE\n ORDER BY timest ASC\n ";
$result = b_query($query);
while ($row = mysql_fetch_array($result)) {
$orderid = $row['orderid'];
echo "Processing {$orderid}...\n";
fulfill_order($orderid);
echo "Completed.\n\n";
$query = "\n UPDATE orderbook\n SET processed=TRUE\n WHERE orderid='{$orderid}'\n ";
b_query($query);
}
}
try {
check_frozen();
process();
} catch (Error $e) {
report_exception($e, SEVERITY::ERROR);
// Same as below, but flag + log this for review,
echo "\nError: \"{$e->getTitle()}\"\n {$e->getMessage()}\n";
} catch (Problem $e) {
echo "\nProblem: \"{$e->getTitle()}\"\n {$e->getMessage()}\n";
} catch (Exception $e) {
echo "\nException: \"{$e->getTitle()}\"\n {$e->getMessage()}\n";
}
function switcher($page)
{
global $is_logged_in, $is_admin, $is_verified;
try {
$lock = false;
if (!preg_match("/^[0-9_a-z]*\$/", $page)) {
$page = 'junk';
}
// delay showing the header when logging in until we know whether the login worked or not
if ($page != 'download' && $page != 'login' && $page != 'graph') {
show_header($page, $is_logged_in);
}
if ($is_logged_in) {
get_user_lock($lock = $is_logged_in);
}
addlog(LOG_SWITCHER, sprintf("[%s] visit page '%s'", getenv("REMOTE_ADDR"), $page));
switch ($page) {
////////////////////////////////////////////////////////////////////////
// for general consumption
////////////////////////////////////////////////////////////////////////
case '404':
case 'graph':
case 'help':
case 'news':
case 'orderbook':
case 'test':
case 'trade':
case 'view_trades':
include "{$page}.php";
break;
////////////////////////////////////////////////////////////////////////
// for logged in users only
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
// for logged in users only
////////////////////////////////////////////////////////////////////////
case 'api':
case 'deposit':
case 'identity':
case 'place_order':
case 'profile':
case 'statement':
case 'turn_on_duo':
case 'view_order':
case 'view_request':
case 'withdraw':
if ($is_logged_in) {
include "{$page}.php";
} else {
log_badpage($page);
}
break;
////////////////////////////////////////////////////////////////////////
// for admin only
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
// for admin only
////////////////////////////////////////////////////////////////////////
case 'add_cash':
case 'bank':
case 'commission':
case 'docs':
case 'download':
case 'freeze':
case 'users':
if ($is_admin) {
include "{$page}.php";
} else {
log_badpage($page);
}
break;
case 'login':
if (!$is_logged_in) {
include "login.php";
// we just tried to log in, so check whether or not it worked before showing the footer
get_login_status();
} else {
addlog(LOG_LOGIN, " already logged in");
log_badpage($page);
}
break;
case 'logout':
setcookie('autologin', FALSE, time() - 60 * 60 * 24 * 365);
logout();
default:
sleep(3);
log_badpage($page);
break;
}
// debugging for session stuff
if (0) {
echo "<div class='content_box'>\n";
echo "<h3>Debug</h3>\n";
echo "<p>\n";
echo "session id: ", session_id(), "<br/>\n";
echo "session age: ", time() - $_SESSION['creation_time'], " seconds<br/>\n";
if (isset($inactivity)) {
echo "you were inactive for {$inactivity} seconds<br/>\n";
}
echo "MAX_IDLE_MINUTES_BEFORE_LOGOUT = ", MAX_IDLE_MINUTES_BEFORE_LOGOUT, " minutes = ", MAX_IDLE_MINUTES_BEFORE_LOGOUT * 60, " seconds<br/>\n";
echo "MAX_SESSION_ID_LIFETIME = ", MAX_SESSION_ID_LIFETIME, " minutes = ", MAX_SESSION_ID_LIFETIME * 60, " seconds<br/>\n";
echo "</p></div>\n";
}
} catch (Error $e) {
global $shown_header;
report_exception($e, SEVERITY::ERROR);
// Same as below, but flag + log this for review,
if (!$shown_header) {
show_header($page, $is_logged_in);
}
echo "<div class='content_box'><h3>{$e->getTitle()}</h3>";
echo "<p>{$e->getMessage()}</p></div>";
} catch (Problem $e) {
global $shown_header;
if (!$shown_header) {
show_header($page, $is_logged_in);
}
echo "<div class='content_box'><h3>{$e->getTitle()}</h3>";
echo "<p>{$e->getMessage()}</p></div>";
} catch (Exception $e) {
global $shown_header;
if (!$shown_header) {
show_header($page, $is_logged_in);
}
echo "<div class='content_box'><h3>Technical difficulties</h3>";
echo "<p>{$e->getMessage()}</p></div>";
}
show_footer($is_logged_in, $is_admin, $is_verified);
if ($lock) {
release_lock($lock);
}
}
/**
* Fetch connected grapobjects and store in the property.
*
* @param string $property
* @return mixed
*/
function __get($property)
{
if (empty($this->id)) {
return parent::__get($property);
}
$connections = $this->getKnownConnections();
if (array_key_exists($property, $connections) === false) {
// not a (known) connection?
if ($this->_state === 'id_only') {
$fields = Facebook::get($this->id, $this->_apiParameters);
$this->__set($fields);
$this->_state = 'ready';
unset($this->_apiParameters);
if (array_key_exists($property, $fields)) {
return $fields[$property];
}
}
if ($this->_state === 'partial') {
$fields = Facebook::get($this->id);
$this->__set($fields);
$this->_state = 'ready';
if (array_key_exists($property, $fields)) {
return $fields[$property];
}
}
$fields = get_public_vars(get_class($this));
if (array_key_exists($property, $fields)) {
// is the field defined in the class?
$permissions = static::getFieldPermissions(array('id' => $this->id));
if (isset($permissions[$property]) && $permissions[$property] !== 'denied' && in_array($permissions[$property], Facebook::getInstance()->getPermissions()) === false) {
notice('Field "' . $property . '" requires the "' . $permissions[$property] . '" permission', 'Current permissions: ' . quoted_human_implode(' and ', Facebook::getInstance()->getPermissions()));
}
return parent::__get($property);
}
}
try {
// Retrieve a connection
if (isset($connections[$property]['class'])) {
$parameters = array('fields' => call_user_func(array($connections[$property]['class'], 'getAllowedFields')));
} else {
$parameters = array();
}
$method = 'get' . ucfirst($property);
$this->__set(array($property => $this->{$method}($parameters)));
return $this->{$property};
} catch (\Exception $e) {
report_exception($e);
return parent::__get($property);
}
}
?>
<html>
<head>
<title>Blind List</title>
</head>
<body>
<?php
$dbinfo = initialize_db_info();
//report_database_settings($dbinfo);
try {
$db_link = db_connect($dbinfo);
db_select($db_link, $dbinfo);
} catch (Exception $e) {
echo report_exception("Database Connection", $e);
echo report_database_settings($dbinfo);
}
$sql = generate_blind_list_sql();
$result_rows = mysql_query($sql, $db_link);
if (!$result_rows) {
echo $sql;
$message = 'Invalid query: ' . mysql_error() . "\n";
echo $message;
throw new Exception('No Results.');
}
?>
<h1>Blind List</h1>
