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>