</ul>';
$html .= '<h2><a name="pie-enc"></a>Percentage of unencrypted WLAN</h2>';
$html .= '<img src="encrypted.png" alt="Encrypted?" />';
$html .= '<h2><a name="pie-wpa"></a>Percentage of WPA encryption</h2>';
$html .= '<img src="encryption.png" alt="WPA?" />';
if (file_exists('oui.txt')) {
$oui_file_content = file_get_contents('oui.txt');
}
$html .= '<h2><a name="macs-all"></a>50 most detected MAC-Ranges</h2>';
$html .= '<table>
<tr>
<th>Count</th>
<th>MAC-Range</th>
<th>Owner (OUI)</th>
</tr>';
$query = $db->unbufferedQuery('SELECT macparts as m, COUNT(machash) as c FROM accesspoints GROUP by macparts ORDER by c DESC LIMIT 50');
$result = $query->fetchAll(SQLITE_ASSOC);
foreach ($result as $row) {
$html .= '<tr><td>' . $row['c'] . '</td><td>' . substr($row['m'], 0, 8) . '</td>';
if ($oui_file_content) {
preg_match('#' . str_replace(':', '-', substr($row['m'], 0, 8)) . '[^(]*\\(hex\\)[ ]*(.*)#i', $oui_file_content, $sub);
$html .= '<td>' . $sub[1] . '</td>';
unset($sub);
} else {
$html .= '<td></td>';
}
$html .= '</tr>';
}
$html .= '</table>';
$html .= '<h2><a name="macs-unenc"></a>50 most detected MAC-Ranges on <u>unprotected</u> WLANs</h2>';
$html .= '<table>
<?php
chdir(dirname(__FILE__));
// pres2 hack
// sample IP
$_SERVER['REMOTE_ADDR'] = "24.100.195.79";
$ip_int = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
try {
$db = new SQLiteDatabase("./ip.db");
} catch (SQLiteException $err) {
die($err->getMessage() . " in " . $err->getFile() . ":" . $err->getLine());
}
$res = $db->unbufferedQuery("\nSELECT country_name \nFROM ip_ranges ir \nINNER JOIN country_data cd ON ir.country_code=cd.id\nWHERE {$ip_int} BETWEEN ip_start AND ip_end");
echo "User is located in " . $res->fetchSingle();
<?php
/* open connection to memory database */
$db = new SQLiteDatabase(":memory:");
/* execute a regular query */
$db->query("CREATE TABLE test(a,b)");
$db->query("INSERT INTO test VALUES('1','2')");
/* retrieve data using an unbuffered query */
$r = $db->unbufferedQuery("SELECT * FROM test", SQLITE_ASSOC);
echo '<pre>';
/* use object iterators to retrieve the data, without any additional functions */
foreach ($r as $row) {
print_r($row);
}
echo '</pre>';
$q = @$db->query('SELECT requests FROM tablename WHERE id = 1');
if ($q === false) {
$db->queryExec('CREATE TABLE tablename (id int, requests int, PRIMARY KEY (id)); INSERT INTO tablename VALUES (1,1)');
$hits = 1;
} else {
$result = $q->fetchSingle();
$hits = $result + 1;
}
$db->queryExec("UPDATE tablename SET requests = '{$hits}' WHERE id = 1");
} else {
die($err);
}
$dbhandle = new SQLiteDatabase('sqlitedb');
$query = $dbhandle->query('SELECT name, email FROM users LIMIT 25');
// buffered result set
$query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25');
// unbuffered result set
while ($entry = $query->fetch(SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))');
sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
$result = sqlite_query($db, 'select bar from foo');
var_dump(sqlite_fetch_array($result));
} else {
die($sqliteerror);
}
$dbhandle = sqlite_factory('sqlitedb');
$dbhandle->query('SELECT user_id, username FROM users');
/* functionally equivalent to: */
<pre>
<?php
$db = new SQLiteDatabase(dirname(__FILE__) . "/ip.db");
$res = $db->unbufferedQuery("SELECT * FROM country_data WHERE cc_code_2='CA'", SQLITE_ASSOC);
foreach ($res as $row) {
print_r($row);
}
?>
</pre>
