/**
* The SQL Query funtion
*
* @version 1
* @author Rick de Man <*****@*****.**>
*
* @param string $Query
* The Query to be executed
* @param string $Comment
* The Comment for the Query, for Debug use
* @param bool $Fetchall
* When a single result is found return a multi-dimension Array
* @return integer|false|array
*/
public function Query($Query, $Comment, $Fetchall = false)
{
// The SQL must be free to continue
if ($this->SQL_Free !== true) {
$this->Query_Next();
}
// SQL is occupied
$this->SQL_Free = false;
// process table name, Place prefix
$Query = $this->Query_Table_Preg($Query);
try {
// Create The Query and Execute
$this->STH = $this->DBH->Query($Query);
// Load the Backtrace
$Trace = debug_backtrace();
// Create a SQL Log Event
$this->Log = array('F' => $Trace[0]['file'] . ':' . $Trace[0]['line'] . '(' . $Trace[1]['function'] . ')', 'Q' => $Query, 'C' => $Comment);
} catch (PDOException $e) {
// Duplicate Error
if (preg_match('/Duplicate entry/i', $e->getMessage()) === 1) {
return -1;
}
// Oops, Something went wrong...
PDO_Error($e->getMessage(), $Query, $_SESSION['WMS-Debug']);
}
// Finish the SQL Query
$this->Query_Next();
// Return the processed Data
return $this->Result($Fetchall);
}
public function query($query, $model = 'StdClass')
{
/* @var $result \PDOStatement */
// echo "*** Model in Query: " . $model . "\n";
try {
$exec_time_start = microtime(true);
$result = parent::Query($query, \PDO::FETCH_CLASS, $model);
#\Kint::dump($query, $model, $result, "There are {$result->rowCount()} elements.", parent::errorInfo());
$exec_time_end = microtime(true);
$exec_time = $exec_time_end - $exec_time_start;
if (DatabaseLayer::getInstance()->getLogger()) {
DatabaseLayer::getInstance()->getLogger()->addDebug("{$exec_time} sec: {$query}");
}
if (ActiveRecord::$showSql) {
echo "{$exec_time} sec: {$query}\n";
}
$this->query_log[] = new Log($query, $exec_time);
return $result;
} catch (\PDOException $e) {
#\Kint::dump($e->getMessage(), $query, $result);
if (DatabaseLayer::getInstance()->getLogger()) {
DatabaseLayer::getInstance()->getLogger()->addDebug("Query() Caught Exception: {$e->getMessage()}");
}
$this->handleError($model, $query, $e);
}
}
public static function SetUpDatabase()
{
$db = new \PDO('sqlite::memory:');
$db->SetAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$db->Query("\n CREATE TABLE test_table\n (\n id integer PRIMARY KEY AUTOINCREMENT,\n title varchar(100),\n description text,\n value text,\n is_hidden boolean,\n reference_id integer\n );\n ");
return $db;
}
function generate_reserve($bookbag_id, $course_code, $instructor)
{
require '../settings.php';
// Open sqlite db, then insert values
$db_session = new PDO('sqlite:../' . $SETTINGS['dbfile']);
$query = "SELECT count(*) from reserve where bookbag_id = " . $bookbag_id;
$res = $db_session->Query($query);
if ($res->fetchColumn() == 0) {
$query = "INSERT into reserve (course_code, instructor, bookbag_id) values ('" . $course_code . "', '" . $instructor . "', " . $bookbag_id . ")";
$results = $db_session->Query($query);
if (!$results) {
die('Query Failed... Please go back and retry');
}
return true;
}
return false;
}
/**
* Load data from the database by ID
*
* @version 1
* @author Rick de Man <*****@*****.**>
*
* @param string $Table
* @param string $ID
* @return mixed
*/
private function GetDefinitionsById($Table, $ID)
{
// Create Query
$Query = "SELECT * FROM `{$Table}` WHERE id = {$ID}";
try {
// Execute the query
$STH = $this->DBH->Query($Query);
} catch (PDOException $e) {
// Oops, Something went wrong...
$this->_Result(array('message' => $e->getMessage(), 'line' => __LINE__), false);
}
// Debug Database Qeury
$this->DebugLocalEndpoint("<font style='color:green'>{$Query} (" . $STH->RowCount() . ")</font>");
// Get the results
$STH = $STH->fetch();
if ($STH !== false) {
// Return parsed JSON string
return json_decode($STH['json'], true);
}
}
<div class="breadcrumbs">
<a href="/">Home</a> ›
<a href="vieworderbook.php">Order Book</a> ›
Order <?php echo $id; ?>
</div>
<h2>#bitcoin-otc order id <?php echo $id; ?></h2>
<?php
try { $db = new PDO('sqlite:./otc/OTCOrderBook.db'); }
catch (PDOException $e) { die($e->getMessage()); }
?>
<table class="datadisplay">
<?php
if (!$query = $db->Query('SELECT id, created_at, refreshed_at, buysell, nick, host, amount, thing, price, otherthing, notes FROM orders WHERE id=' . $id ))
echo " <tr><td>No matching orders found</td></tr>\n";
else {
if( $entry = $query->fetch(PDO::FETCH_BOTH)){
$entry["indexedprice"] = index_prices($entry["price"]);
?>
<tr>
<th>id</th>
<td><?php echo $entry["id"]; ?></td>
</tr>
<tr>
<th>created at</th>
<td><?php echo gmdate("Y-m-d H:i:s", $entry["created_at"]); ?></td>
</tr>
<tr>
<th>refreshed at</th>
// ------------------------------------------------
//libxml_use_internal_errors(false);
$doxyData = simplexml_load_file($xmlindex);
// -------------
// Connect to db
// -------------
$db = new PDO(MYSQL_DSN, MYSQL_USR, MYSQL_PWD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_BOTH));
$db->Exec("set character set utf8");
$db->Exec("set names utf8 collate utf8_general_ci");
// -------------------------------
// Prefetch all documnetation data
// -------------------------------
$schema_doc = array();
$table_doc = array();
$column_doc = array();
$result = $db->Query("SELECT `schema`, `brief`, `details` FROM `documentation`.`schema`")->fetchAll();
foreach ($result as $row) {
$schema_doc[$row["schema"]] = $row;
$table_doc[$row["schema"]] = array();
$column_doc[$row["schema"]] = array();
}
$result = $db->Query("SELECT `schema`, `table`, `brief`, `details` FROM `documentation`.`table`")->fetchAll();
foreach ($result as $row) {
$table_doc[$row["schema"]][$row["table"]] = $row;
$column_doc[$row["schema"]][$row["table"]] = array();
}
$result = $db->Query("SELECT `schema`, `table`, `column`, `brief`, `details`, `reference` FROM `documentation`.`column`")->fetchAll();
foreach ($result as $row) {
$column_doc[$row["schema"]][$row["table"]][$row["column"]] = $row;
}
// -------------------------------
/**
* Setup db connection.
* Based on defined options, this method connects to db defined in {@link $dsn}
* and creates a {@link $table} table if {@link $createTable} is true.
* @return boolean true if all ok.
* @throws a PDOException if the attempt to connect to the requested database fails.
*/
public function activateOptions()
{
try {
if ($this->user === null) {
$this->db = new PDO($this->dsn);
} else {
if ($this->password === null) {
$this->db = new PDO($this->dsn, $this->user);
} else {
$this->db = new PDO($this->dsn, $this->user, $this->password);
}
}
$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// test if log table exists
try {
$result = $this->db->Query('SELECT * FROM ' . $this->table . ' WHERE 1 = 0');
$result->closeCursor();
} catch (PDOException $e) {
// It could be something else but a "no such table" is the most likely
$result = false;
}
// create table if necessary
if ($result == false and $this->createTable) {
// The syntax should at least be compatible with MySQL, PostgreSQL, SQLite and Oracle.
$Query = "CREATE TABLE {$this->table} (" . "timestamp varchar(32)," . "logger varchar(64)," . "level varchar(32)," . "message varchar(9999)," . "thread varchar(32)," . "file varchar(255)," . "line varchar(6))";
$result = $this->db->Query($Query);
}
} catch (PDOException $e) {
$this->canAppend = false;
throw new LoggerException($e);
}
$this->layout = new LoggerLayoutPattern();
//
// Keep compatibility to legacy option $sql which already included the format patterns!
//
if (empty($this->sql)) {
// new style with prepared Statment and $InsertSql and $InsertPattern
// Maybe the tablename has to be substituted.
$this->InsertSql = preg_replace('/__TABLE__/', $this->table, $this->InsertSql);
$this->preparedInsert = $this->db->prepare($this->InsertSql);
$this->layout->setConversionPattern($this->InsertPattern);
} else {
// Old style with format strings in the $sql Query should be used.
$this->layout->setConversionPattern($this->sql);
}
$this->canAppend = true;
return true;
}
tr.even {
background-color: #dbdfff;
}
--></style>
<title>#bitcoin-otc order book</title>
</head>
<body>
<h2>#bitcoin-otc order book</h2>
<p>[<a href="/">home</a>]</p>
<h3>Summary statistics on outstanding orders</h3>
<ul>
<?php
try { $db = new PDO('sqlite:./otc/OTCOrderBook.db'); }
catch (PDOException $e) { die($e->getMessage()); }
if (!$query = $db->Query('SELECT count(*) as ordercount, sum(btcamount) as ordersum FROM orders'))
echo " <li>No outstanding orders found</li>";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo " <li>" . number_format($entry['ordercount']) . " outstanding orders, for a total of " . number_format($entry['ordersum'], 1) . " BTC.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ordercount, sum(btcamount) as ordersum FROM orders WHERE buysell='BUY'"))
echo " <li>No outstanding BUY orders found</li>\n";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo " <li>" . number_format($entry['ordercount']) . " outstanding BUY orders, for a total of " . number_format($entry['ordersum'], 1) . " BTC.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ordercount, sum(btcamount) as ordersum FROM orders WHERE buysell='SELL'"))
echo " <li>No outstanding SELL orders found</li>\n";
<?php
set_time_limit(0);
$DBH = new PDO("mysql:host=127.0.0.1;dbname=c2go", 'c2go', 'zRyJJ5xzKN7sMb3b');
$DBH->Query('SET NAMES utf8');
$handle = fopen('cities5000.txt', "r");
$i = 0;
$STH = $DBH->prepare("INSERT INTO site_cities (geonameid,name,asciiname,alternatenames,latitude,longitude,feature_class,feature_code,country_code,cc2,admin1_code,admin2_code,admin3_code,admin4_code,population,elevation,dem,timezone,ru_name) \r\n values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
while (!feof($handle)) {
$buffer = fgets($handle, 1000000);
$data = explode("\t", $buffer);
$data[18] = '';
if (preg_match_all('/^(.+,|)([-`\\s0-9а-я]+)(,.+|)$/msiu', $data[3], $matches)) {
$data[18] = $matches[2][0];
}
$STH->execute($data);
++$i;
}
fclose($handle);
Last updated on: <?php echo $lastupdated; ?>. <br>
Current OTC time: <?php echo date("F d Y H:i:s T"); ?>.
</p>
<?php
try { $db = new PDO('sqlite:./OTCQuotes.db'); }
catch (PDOException $e) { die($e->getMessage()); }
?>
<table class="datadisplay">
<tr>
<th>currency</th>
<th>bid</th>
<th>ask</th>
</tr>
<?php
if (!$query = $db->Query('SELECT currency, bid, ask FROM quotes ORDER BY currency ASC'))
echo " <tr><td>No data found</td></tr>\n";
else {
while ($entry = $query->fetch(PDO::FETCH_BOTH)) {
if ($color++ % 2) $class="even"; else $class="odd";
?>
<tr class="<?php echo $class; ?>">
<td><a href = "http://bitcoin-otc.com/vieworderbook.php?sortby=buysell&eitherthing=<?php echo $entry['currency']; ?>"><?php echo $entry['currency']; ?></a></td>
<td><?php echo $entry['bid']; ?></td>
<td><?php echo $entry['ask']; ?></td>
</tr>
<?
}
}
?>
border: 1px solid gray;
padding: 10px;
}
tr.even {
background-color: #dbdfff;
}
--></style>
</head>
<body>
<h2>OTC web of trust</h2>
<p>[<a href="/">home</a>]</p>
<h3>Summary statistics on web of trust</h3>
<ul><?php
try { $db = new PDO('sqlite:./otc/RatingSystem.db'); }
catch (PDOException $e) { die($e->getMessage()); }
if (!$query = $db->Query('SELECT count(*) as usercount, sum(total_rating) as ratingsum FROM users'))
echo "<li>No outstanding orders found</li>\n";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo "<li>" . $entry['usercount'] . " users in database, with a total of " . $entry['ratingsum'] . " net rating points.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ratingcount, sum(rating) as ratingsum FROM ratings WHERE rating > 0"))
echo "<li>No positive ratings found</li>\n";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo "<li>" . $entry['ratingcount'] . " positive ratings sent, for a total of " . $entry['ratingsum'] . " points.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ratingcount, sum(rating) as ratingsum FROM ratings WHERE rating < 0"))
echo "<li>No negative ratings found</li>\n";
* 3 - discounts - пїЅпїЅпїЅпїЅпїЅ пїЅ пїЅпїЅпїЅпїЅпїЅпїЅ
* 4 - gifts for him
* 5 - gifts for her
* 6 - gifts for family
* 7 - gifts for children
* 8 - wareinfo + ids
*/
list($dev_id, $dev_name) = split(",", isset($_GET['device']) ? $_GET['device'] : ',');
if ($appdb = new PDO('sqlite:/www/sites/newmvideo/data/iphone_app.sqlite')) {
$appdb->Query("insert into app_stats values(datetime('now'), '{$_SERVER['REMOTE_ADDR']}', '{$dev_id}', '{$dev_name}')");
}
error_log("" . date("Y/m/d H:i:s") . "\t" . $_SERVER['REMOTE_ADDR'] . "\t" . $_GET['device'] . "\n", 3, '/tmp/iphone_data_device.log');
if (isset($_GET['token'])) {
error_log("" . date("Y/m/d H:i:s") . "\t" . $_SERVER['REMOTE_ADDR'] . "\t" . $_GET['device'] . "\t" . $_GET['token'] . "\n", 3, '/tmp/token.log');
if ($appdb = new PDO('sqlite:/www/sites/newmvideo/data/iphone_app.sqlite')) {
$appdb->Query("insert into notification values(datetime('now'), '{$_SERVER['REMOTE_ADDR']}', '{$dev_id}', '{$dev_name}', '{$_GET[token]}')");
}
exit;
}
// пїЅпїЅпїЅпїЅпїЅпїЅпїЅ , пїЅпїЅпїЅ пїЅпїЅпїЅ xml
// пїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅ пїЅ пїЅпїЅпїЅпїЅпїЅ
$db = new DB_Mvideo();
// пїЅпїЅпїЅпїЅпїЅпїЅ пїЅпїЅ пїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅ - 1
$GlobalConfig["RegionID"] = 1;
if (isset($_GET['region'])) {
$GlobalConfig["RegionID"] = (int) $_GET['region'];
}
// пїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅ пїЅпїЅ пїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅ - 1
$category = 1;
if (isset($_GET['category'])) {
$category = (int) $_GET['category'];
$validkeys = array('id', 'nick', 'created_at', 'keyid', 'total_rating', 'pos_rating_recv_count', 'neg_rating_recv_count', 'pos_rating_sent_count', 'neg_rating_sent_count');
$sortorder = "DESC";
?>
<div class="breadcrumbs">
<a href="/">Home</a> ›
<a href="trust.php">Web of Trust</a> ›
Web of Trust Data
</div>
<h3>Summary statistics on web of trust</h3>
<ul><?php
try { $db = new PDO('sqlite:./otc/RatingSystem.db'); }
catch (PDOException $e) { die($e->getMessage()); }
if (!$query = $db->Query('SELECT count(*) as usercount, sum(total_rating) as ratingsum FROM users'))
echo "<li>No outstanding orders found</li>\n";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo "<li>" . $entry['usercount'] . " users in database, with a total of " . $entry['ratingsum'] . " net rating points.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ratingcount, sum(rating) as ratingsum FROM ratings WHERE rating > 0"))
echo "<li>No positive ratings found</li>\n";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo "<li>" . $entry['ratingcount'] . " positive ratings sent, for a total of " . $entry['ratingsum'] . " points.</li>\n";
}
if (!$query = $db->Query("SELECT count(*) as ratingcount, sum(rating) as ratingsum FROM ratings WHERE rating < 0"))
echo "<li>No negative ratings found</li>\n";
<h2>OTC Order Book <sup>[<a href="orderbook.json">json</a>]</sup></h2>
<?php
if (sizeof($queryfilter) != 0) {
echo '<div class="filter">Filtered results. <a href="vieworderbook.php">Clear filter</a></div>';
}
?>
<table class="datadisplay" style="width: 100%;">
<tr>
<?php
try { $db = new PDO('sqlite:./otc/OTCOrderBook.db'); }
catch (PDOException $e) { die($e->getMessage()); }
echo ' <td style="text-align: center;">Total orders<br>';
if (!$query = $db->Query('SELECT count(*) as ordercount FROM orders'))
echo "0";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo number_format($entry['ordercount']);
}
echo "</td>\n";
echo ' <td style="text-align: center;">Buy orders<br>';
if (!$query = $db->Query("SELECT count(*) as ordercount FROM orders WHERE buysell='BUY'"))
echo "0";
else {
$entry = $query->fetch(PDO::FETCH_BOTH);
echo number_format($entry['ordercount']);
}
echo "</td>\n";
