</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>