if ($QualityFlagID == $thisfile_QualityFlagID) {
echo "<option value=\"{$QualityFlagID}\" SELECTED>{$QualityFlag} ({$QualityFlagID})</option>\n";
} else {
echo "<option value=\"{$QualityFlagID}\">{$QualityFlag} ({$QualityFlagID})</option>\n";
}
}
echo "</select>\n\t\t\t\t\t\t<button type=\"submit\" class=\"btn btn-primary btn-xs\"> Change </button>\n\t\t\t\t\t\t</form>";
}
echo "</dd>";
if ($DerivedSound == "1") {
echo "<dt>Derived from</dt><dd><a href=\"db_filedetails.php?SoundID={$DerivedFromSoundID}\">{$DerivedFromSoundID}";
}
echo "<dt>Database ID</dt><dd>{$SoundID}</dd>";
#License
$files_license = DB::column('SELECT `Value` from `PumilioSettings` WHERE `Settings`="files_license"');
$files_license_detail = DB::column('SELECT `Value` from `PumilioSettings` WHERE `Settings`="files_license_detail"');
if ($files_license != "") {
echo "<dt>License</dt><dd>";
if ($files_license == "Copyright") {
echo "© Copyright ";
} else {
$files_license_img = str_replace(" ", "", $files_license);
$files_license_link = strtolower(str_replace("CC ", "", $files_license));
echo "<p>File available under a \n\t\t\t\t\t\t\t\t<a href=\"http://creativecommons.org/licenses/{$files_license_link}/3.0/\" target=_blank><img src=\"images/cc/{$files_license_img}.png\"></a>\n\t\t\t\t\t\t\t\t{$files_license} license by ";
}
echo "{$files_license_detail}</dd>\n";
}
if ($guests_can_dl || $pumilio_loggedin) {
echo "<dt>Download</dt>";
echo "<dd><a href=\"dl.php?file=sounds/sounds/{$ColID}/{$DirID}/{$OriginalFilename}\" title=\"Please read the license field on the right for legal limitations on the use of these files.\">{$SoundFormat}</a>";
echo " | ";
DB::$c = $pdo;
ob_flush();
flush();
$row_break_counter = 0;
for ($i = 0; $i < $nrows; $i++) {
$row = mysqli_fetch_array($result);
extract($row);
if ($row_break_counter == 0) {
echo "<div class=\"row\">";
}
$row_break_counter = $row_break_counter + 1;
echo "<div class=\"col-lg-4\">";
$ColID = DB::column('SELECT ColID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$SiteID = DB::column('SELECT SiteID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$DirID = DB::column('SELECT DirID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$small_spectrogram = DB::column('SELECT ImageFile FROM `SoundsImages` WHERE ImageType="spectrogram-small" AND SoundID = ' . $SoundID);
$small_spectrogram_path = "sounds/images/{$ColID}/{$DirID}/{$small_spectrogram}";
if (!is_file("{$absolute_dir}/{$small_spectrogram_path}")) {
$small_spectrogram_path = "images/notready-small.png";
}
echo "<a href=\"db_filedetails.php?SoundID={$SoundID}\" title=\"Click for file details and more options\">\n\t\t<img src=\"{$small_spectrogram_path}\" width=\"300\" height=\"150\" style=\"margin-top: 20px;\"><br>\n\t\t{$SoundName}</a>";
if (isset($Date_h) && $Date_h != "") {
echo "<br>{$Date_h} | {$Time}";
}
if (!isset($show_tags)) {
$show_tags = 0;
}
flush();
@ob_flush();
#Check if there are images
$query_img = "SELECT COUNT(*) FROM SoundsImages WHERE SoundID='{$SoundID}'";
<?php
#DB
use DByte\DB;
DB::$c = $pdo;
echo "\n\n<div class=\"panel panel-primary\">\n\t<div class=\"panel-heading\">\n\t\t<h3 class=\"panel-title\">Sensors</h3>\n\t</div>\n <div class=\"panel-body\">\n\n\t<strong>Add sensors to the database</strong>\n\t\t<form action=\"include/add_sensors.php\" method=\"POST\" id=\"AddSensors\">\n\t\t\t<p>Recorder:<br><input type=\"text\" name=\"Recorder\" maxlength=\"100\" size=\"40\"><br>\n\t\t\tMicrophone: <br><input type=\"text\" name=\"Microphone\" maxlength=\"80\" size=\"40\"><br>\n\t\t\tNotes of the sensor: <br><input type=\"text\" name=\"Notes\" maxlength=\"255\" size=\"40\"><br>\n\t\t\t<button type=\"submit\" class=\"btn btn-primary\"> Add sensor </button>\n\t\t</form>";
#Sensors in the db:
echo "<hr noshade>";
$no_sensors = DB::column('SELECT COUNT(*) FROM `Sensors`');
if ($no_sensors == 0) {
echo "<p>There are no sensors in the system.";
} else {
$rows = DB::fetch('SELECT * FROM `Sensors` ORDER BY `SensorID`', array(TRUE));
echo "<p>The system has the following " . count($rows) . " sensors:\n\t\t<table>";
echo "<tr>\n\t\t\t<td>Sensor ID</td>\n\t\t\t<td> </td>\n\t\t\t<td>Recorder</td>\n\t\t\t<td> </td>\n\t\t\t<td>Microphone</td>\n\t\t\t<td> </td>\n\t\t\t<td>Notes</td>\n\t\t\t<td> </td>\n\t\t\t<td>Edit</td>\n\t\t</tr>\n";
foreach ($rows as $row) {
# for ($i = 0; $i < $nrows; $i++) {
#$row = mysqli_fetch_array($result);
#extract($row);
echo "<tr>\n\t\t\t\t<td>" . $row->SensorID . "</td>\n\t\t\t\t<td> </td>\n\t\t\t\t<td>" . $row->Recorder . "</td>\n\t\t\t\t<td> </td>\n\t\t\t\t<td>" . $row->Microphone . "</td>\n\t\t\t\t<td> </td>\n\t\t\t\t<td>" . $row->Notes . "</td>\n\t\t\t\t<td> </td>\n\t\t\t\t<td><a href=\"sensor_edit.php?SensorID=" . $row->SensorID . "\"><img src=\"images/pencil.png\"></td>\n\t\t\t</tr>\n";
}
echo "</table>";
}
echo "</div></div>";
if ($use_leaflet == FALSE) {
echo "<body onload=\"initialize()\" onunload=\"GUnload()\">";
} else {
echo "<body>";
}
?>
<!--Blueprint container-->
<div class="container">
<?php
require "include/topbar.php";
echo "<div class=\"jumbotron\">\n\t\t\t<h2>Welcome to {$app_custom_name}</h2>";
echo "<div class=\"pull-right\"><p><a class=\"btn btn-primary btn-lg\" href=\"protocol.php\" role=\"button\">Our protocol</a></p>\n\t\t\t\t<p><a class=\"btn btn-primary btn-lg\" href=\"science.php\" role=\"button\">The science of this project</a></p>\n\t\t\t\t</div>\n\n\n\t\t\t<p>{$app_custom_text}<br>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam suscipit lobortis leo sed maximus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin sed arcu ac tellus tempus facilisis eget ac diam. Maecenas purus leo, cursus ut consequat in, luctus eget libero. Etiam dictum massa enim, consectetur tincidunt sem fermentum finibus. Ut vulputate neque leo, ut vulputate dolor consequat in.</p>\n";
$no_Collections = DB::column('SELECT COUNT(DISTINCT ColID) FROM `Sounds` WHERE SoundStatus!=9 ' . $qf_check);
$no_sounds = DB::column('SELECT COUNT(*) FROM `Sounds` WHERE SoundStatus!=9 ' . $qf_check);
$no_sites = DB::column('SELECT COUNT(DISTINCT SiteID) FROM `Sounds` WHERE SoundStatus!=9 ' . $qf_check);
if ($no_sounds > 0) {
$no_sounds_f = number_format($no_sounds);
$no_Collections_f = number_format($no_Collections);
$no_sites_f = number_format($no_sites);
echo "<p>This archive has {$no_sounds_f} sound files ";
if ($no_sites > 0) {
echo "from {$no_sites_f} sites ";
}
echo "in {$no_Collections_f} ";
if ($no_Collections == 1) {
echo "collection.</p>";
} else {
echo "collections.</p>";
}
}
if ($u == 3) {
echo "<p><div class=\"success\">Change was made successfully</div>";
}
$no_users = DB::column('SELECT COUNT(*) FROM `Users` WHERE `UserActive` LIKE 1');
$query = "SELECT * from Users WHERE UserActive='1' ORDER BY UserName";
$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$nrows = mysqli_num_rows($result);
echo "<p>This system has {$no_users} users:\n\t\t\t\t<table border=\"0\">";
for ($i = 0; $i < $nrows; $i++) {
$row = mysqli_fetch_array($result);
extract($row);
echo "<tr>\n\t\t\t\t\t<td><strong>Name</strong></td><td> </td><td><strong>Username</strong></td><td> </td><td><strong>Role</strong></td><td> </td><td><strong>Change password</strong></td>\n\t\t\t\t\t</tr><tr>";
echo "<td><form action=\"include/edit_user.php\" method=\"POST\">{$UserFullname}</td><td> </td><td>{$UserName}</td><td> </td><td>";
if ($UserRole == "admin") {
#$other_admins=query_one("SELECT COUNT(*) FROM Users WHERE UserRole='admin' AND UserID!='$UserID'", $connection);
$other_admins = DB::column('SELECT COUNT(*) FROM `Users` WHERE `UserRole`=`admin` AND `UserID`!= ?', $UserID);
if ($other_admins > 0 && $UserName != $username) {
echo "<input type=\"hidden\" name=\"ac\" value=\"remadmin\">\n\t\t\t\t\t\t<input type=\"hidden\" name=\"UserID\" value=\"{$UserID}\">\n\t\t\t\t\t\t<input type=submit value=\" Remove from administrators \"></form>";
} else {
echo "[Administrator]</form>";
}
} else {
echo "<input type=\"hidden\" name=\"ac\" value=\"makeadmin\">\n\t\t\t\t\t<input type=\"hidden\" name=\"UserID\" value=\"{$UserID}\">\n\t\t\t\t\t<input type=submit value=\" Make administrator \"></form>";
}
echo "</td><td> </td><td>";
if ($UserName == $username) {
echo "<a href=\"edit_myinfo.php?t=2\" title=\"Edit my information or change password\">Change my password</a>";
} else {
echo "<form method=\"GET\" action=\"include/edit_user_password.php\" target=\"editpassword\" onsubmit=\"window.open('', 'editpassword', 'width=450,height=400,status=yes,resizable=yes,scrollbars=yes')\">\n\t\t\t\t\t\t<input type=\"hidden\" name=\"UserID\" value=\"{$UserID}\">\n\t\t\t\t\t\t<button type=\"submit\" class=\"btn btn-primary\"> Edit user password </button>\n\t\t\t\t\t</form>\n\t\t\t\t\t</td></tr>";
}
}
} else {
die("Could not find the Wordpress installation.");
}
}
}
date_default_timezone_set('GMT');
#Google Analytics
$use_googleanalytics = FALSE;
if (isset($googleanalytics_ID)) {
$use_googleanalytics = TRUE;
$googleanalytics_code = "\n\n<script>\n\t\t(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){\n\t\t(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\n\t\tm=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\n\t\t})(window,document,'script','//www.google-analytics.com/analytics.js','ga');\n\n\t\tga('create', '{$googleanalytics_ID}', '{$app_host}');\n\t\tga('send', 'pageview');\n\n\t</script>\n\n";
}
#Check sox version
if ($special_noprocess == FALSE) {
#$sox_version=query_one("SELECT Value from PumilioSettings WHERE Settings='sox_version'", $connection);
$sox_version = DB::column('SELECT Value FROM `PumilioSettings` WHERE Settings = "sox_version"');
# using only forward of version 14.3.2 (w: 5000 h: )
if ($sox_version == "") {
exec('sox --version', $soxout, $soxretval);
$sox_version = explode("v", $soxout[0]);
$sox_version = $sox_version[1];
$soxver = explode(".", $sox_version);
query_one("INSERT INTO PumilioSettings (Settings, Value) VALUES ('sox_version', '{$sox_version}')", $connection);
}
$soxver = explode(".", $sox_version);
if ($soxver[0] > 14) {
$sox_images = TRUE;
} elseif ($soxver[0] = 14) {
if ($soxver[1] > 3) {
$sox_images = TRUE;
} elseif ($soxver[1] < 3) {
require "include/functions.php";
$config_file = 'config.php';
if (file_exists($config_file)) {
require $config_file;
} else {
header("Location: error.php?e=config");
die;
}
require "include/apply_config.php";
require "include/check_login.php";
use DByte\DB;
DB::$c = $pdo;
#Sanitize inputs
$SiteID = filter_var($_GET["SiteID"], FILTER_SANITIZE_NUMBER_INT);
#Check if site has files or is valid
$valid_id = DB::column('SELECT COUNT(*) FROM `Sounds` WHERE SiteID = ' . $SiteID);
if ($valid_id == 0) {
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\n\t\t<html>\n\t\t<head>\n\n\t\t<title>{$app_custom_name} - File Details</title>\n";
require "include/get_css3.php";
echo "<body>\n\t\t\t<div class=\"alert alert-danger\"><img src=\"images/exclamation.png\"> The site requested does not exists or it has no recordings. Please go back and try your query again.</div>\n\t\t\t</body>\n\t\t\t</html>";
die;
}
#Display type saved as a cookie
#NOW only gallery
/*if (isset($_GET["display_type"])){
$display_type = filter_var($_GET["display_type"], FILTER_SANITIZE_STRING);
}
else{
$display_type = "gallery";
}
*/
<?php
use DByte\DB;
DB::$c = $pdo;
$SiteID = DB::column('SELECT SiteID FROM `Sounds` WHERE SoundID = ' . $SoundID);
$SiteLat = DB::column('SELECT SiteLat FROM `Sites` WHERE SiteID = ' . $SiteID);
$SiteLon = DB::column('SELECT SiteLon FROM `Sites` WHERE SiteID = ' . $SiteID);
$SiteName = DB::column('SELECT SiteName FROM `Sites` WHERE SiteID = ' . $SiteID);
if ($SiteLat != "" && $SiteLon != "") {
echo " <script src=\"libs/leaflet/leaflet.js\"></script>\n\n\t\t\t\t<script>\n\n\t\t\t\tvar map = L.map('map').setView([{$SiteLat}, {$SiteLon}], 13);";
if ($tileserver == "mapbox") {
#From default leaflet demo
echo "\n\t\t\t\t\tL.tileLayer('https://{s}.tiles.mapbox.com/v3/{id}/{z}/{x}/{y}.png', {\n\t\t\t\t\t\tmaxZoom: 18,\n\t\t\t\t\t\tattribution: 'Map data © <a href=\"http://openstreetmap.org\">OpenStreetMap</a> contributors, ' +\n\t\t\t\t\t\t\t'<a href=\"http://creativecommons.org/licenses/by-sa/2.0/\">CC-BY-SA</a>, ' +\n\t\t\t\t\t\t\t'Imagery © <a href=\"http://mapbox.com\">Mapbox</a>',\n\t\t\t\t\t\tid: 'examples.map-i875mjb7'\n\t\t\t\t\t}).addTo(map);\n\t\t\t\t\t";
} elseif ($tileserver == "openstreet") {
echo "\n\t\t\t\t\tL.tileLayer('http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {\n\t\t\t\t\t\tmaxZoom: 18,\n\t\t\t\t\t\tattribution: '© <a href=\"http://www.openstreetmap.org/copyright\">OpenStreetMap</a> contributors'\n\t\t\t\t\t}).addTo(map);\n\t\t\t\t\t";
} elseif ($tileserver == "cartodb") {
echo "\n\t\t\t\t\tL.tileLayer('http://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}.png', {\n\t\t\t\t\t\tmaxZoom: 18,\n\t\t\t\t\t\tattribution: '© <a href=\"http://www.openstreetmap.org/copyright\">OpenStreetMap</a> contributors, © <a href=\"http://cartodb.com/attributions\">CartoDB</a>'\n\t\t\t\t\t}).addTo(map);\n\t\t\t\t\t";
}
echo "\tL.marker([{$SiteLat}, {$SiteLon}]).addTo(map)\n\t\t\t\t\t\t.bindPopup('<div style=\"width: 160px\">Site: <a href=\"browse_site.php?SiteID={$SiteID}\" title=\"Browse the recordings made at this site\"><strong>{$SiteName}</strong></a></div>');\n\n\t\t\t\tvar popup = L.popup();\n\n\t\t\t</script>\n\t\t\t\t ";
}
<?php
session_start();
require "include/functions.php";
$config_file = 'config.php';
if (file_exists($config_file)) {
require "config.php";
} else {
header("Location: error.php?e=config");
die;
}
require "include/apply_config.php";
#DB
use DByte\DB;
DB::$c = $pdo;
$force_loggedin = TRUE;
require "include/check_login.php";
if (isset($_GET["d"])) {
$d = filter_var($_GET["d"], FILTER_SANITIZE_NUMBER_INT);
} else {
$d = 0;
}
if (isset($_GET["t"])) {
$t = filter_var($_GET["t"], FILTER_SANITIZE_NUMBER_INT);
} else {
$t = 0;
}
echo "<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<title>{$app_custom_name} - Edit my information</title>";
require "include/get_css3.php";
require "include/get_jqueryui.php";
?>
// Oops! We got Bob's info wrong! Lets fix it!
$user = array('username' => 'Bob', 'email' => '*****@*****.**');
$result = DB::update('users', $user, 3);
var_dump($result);
// Our moderators say that the "Troll" user needs to be deleted!
$result = DB::query('DELETE FROM users WHERE username = ?', array('Troll'));
var_dump($result);
/*
* Select Queries
*/
// Count all the users
$result = DB::column('SELECT COUNT(*) FROM `users`');
var_dump('Total users: ' . $result);
br();
// Get user number 2 (John)
$result = DB::row('SELECT * FROM `users` WHERE id = ?', array(3));
var_dump($result);
br();
// Fetch all the users!
$result = DB::fetch('SELECT * FROM `users`');
var_dump($result);
br();
// Fetch users from "example.com"
$result = DB::fetch('SELECT * FROM `users` WHERE email LIKE ?', array('%example.com'));
var_dump($result);
br();
/*
* Results
*/
print count(DB::$q) . " Queries Run:\n";
print_r(DB::$q);
<?php
use DByte\DB;
DB::$c = $pdo;
if ($no_results_map > 0) {
echo " <script src=\"libs/leaflet/leaflet.js\"></script>\n\n\t\t\t<link rel=\"stylesheet\" href=\"libs/leaflet/MarkerCluster.css\" />\n\t\t\t<link rel=\"stylesheet\" href=\"libs/leaflet/MarkerCluster.Default.css\" />\n\t\t\t<script src=\"libs/leaflet/leaflet.markercluster-src.js\"></script>\n\t\t\t<script src=\"libs/leaflet/leaflet-providers.js\"></script>\n\t\t\t\n\t\t\t<script>\n\n\t\t\tvar map = L.map('map').setView([0, 0], 8);\n";
echo "L.tileLayer.provider('OpenStreetMap.HOT').addTo(map);";
echo "var markers = new L.MarkerClusterGroup();\n";
for ($i = 0; $i < $no_results_map; $i++) {
$SiteID = $results_map[$i]->SiteID;
$SiteLat = $results_map[$i]->SiteLat;
$SiteLon = $results_map[$i]->SiteLon;
$SiteName = $results_map[$i]->SiteName;
$res_site = DB::column('SELECT COUNT(*) FROM `Sounds` WHERE SiteID = ' . $SiteID);
echo "var marker = L.marker(new L.LatLng({$SiteLat}, {$SiteLon}));\n\t\t\t\t\tvar title = \"<a href='browse_site.php?SiteID={$SiteID}'><strong>{$SiteName}</strong></a><br>{$res_site} sounds at this site\";\n";
echo "marker.bindPopup(title);\n\t\t\tmarkers.addLayer(marker);\n";
}
echo "\n\t\tmap.addLayer(markers);\n\t\tvar popup = L.popup();\n\t\tL.control.scale().addTo(map);\n\t\t\n\tmap.fitBounds([";
for ($i = 0; $i < $no_results_map; $i++) {
$SiteLat = $results_map[$i]->SiteLat;
$SiteLon = $results_map[$i]->SiteLon;
echo "[{$SiteLat}, {$SiteLon}]";
if ($i != $no_results_map - 1) {
echo ",";
}
}
echo "]);\n \tmap.setZoom(map.getZoom()-1);\n\n\t</script>\n\t";
}
