/** * Insert a row into the database * * @param string $table name * @param array $data * @return integer|null */ static function insert($table, array $data) { $query = "INSERT INTO`{$table}`(`" . implode('`,`', array_keys($data)) . '`)VALUES(' . rtrim(str_repeat('?,', count($data = array_values($data))), ',') . ')'; return DB::$p ? DB::column($query . 'RETURNING`id`', $data) : (DB::query($query, $data) ? static::$c->lastInsertId() : NULL); }
<?php session_start(); require "functions.php"; require "../config.php"; require "apply_config_include.php"; $force_admin = TRUE; require "check_admin.php"; #Sanitize $defaultqf = filter_var($_POST["defaultqf"], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $check = DB::column('SELECT COUNT(*) FROM `PumilioSettings` WHERE Settings = "default_qf"'); $settings = array('Settings' => 'default_qf', 'Value' => $defaultqf); if ($check == 0) { DB::insert('PumilioSettings', $settings); } else { DB::update('PumilioSettings', $settings, 'default_qf', 'Settings'); } // Relocate back to the first page of the application header("Location: ../admin.php?t=6&u=4"); die;
$force_admin = TRUE; require "include/check_admin.php"; $SoundIDs = $_POST['SoundIDs']; $where_to = filter_var($_POST["where_to"], FILTER_SANITIZE_URL); $howmany = count($SoundIDs); if ($howmany > 0) { for ($i = 0; $i < $howmany; $i++) { $SoundID = $SoundIDs[$i]; #$filename=query_one("SELECT OriginalFilename FROM Sounds WHERE SoundID='$SoundID' LIMIT 1", $connection); #$ColID=query_one("SELECT ColID FROM Sounds WHERE SoundID='$SoundID' LIMIT 1", $connection); #$DirID=query_one("SELECT DirID FROM Sounds WHERE SoundID='$SoundID' LIMIT 1", $connection); #$AudioPreviewFilename=query_one("SELECT AudioPreviewFilename FROM Sounds WHERE SoundID='$SoundID' LIMIT 1", $connection); $filename = DB::column('SELECT `OriginalFilename` FROM `Sounds` WHERE `SoundID` = ' . $SoundID); $ColID = DB::column('SELECT `ColID` FROM `Sounds` WHERE `SoundID` = ' . $SoundID); $DirID = DB::column('SELECT `DirID` FROM `Sounds` WHERE `SoundID` = ' . $SoundID); $AudioPreviewFilename = DB::column('SELECT `AudioPreviewFilename` FROM `Sounds` WHERE `SoundID` = ' . $SoundID); $source_dir = "sounds/sounds/{$ColID}/{$DirID}"; if (unlink($source_dir . "/" . $filename)) { $query_file = "UPDATE Sounds SET SoundStatus='9' WHERE SoundID='{$SoundID}' LIMIT 1"; $result_file = mysqli_query($connection, $query_file) or die(mysqli_error($connection)); save_log($connection, $SoundID, "90", "The file sounds/sounds/{$ColID}/{$DirID}/{$filename} was deleted."); #Check if there are images $query_img = "SELECT COUNT(*) FROM SoundsImages WHERE SoundID='{$SoundID}'"; $sound_images = query_one($query_img, $connection); if ($sound_images != 0) { $ImageFile = query_one("SELECT ImageFile FROM SoundsImages WHERE SoundID='{$SoundID}' AND ImageType='spectrogram'", $connection); if (is_file("sounds/images/{$ColID}" . "/" . $DirID . "/" . $ImageFile)) { unlink("sounds/images/{$ColID}" . "/" . $DirID . "/" . $ImageFile); } $ImageFile = query_one("SELECT ImageFile FROM SoundsImages WHERE SoundID='{$SoundID}' AND ImageType='waveform'", $connection); if (is_file("sounds/images/{$ColID}" . "/" . $DirID . "/" . $ImageFile)) {
/** * set column field * * @param string $field */ public static function setColumnField($field = '*') { self::$column = $field; }
static function insert($a, array $b) { $c = "INSERT INTO`{$a}`(`" . implode('`,`', array_keys($b)) . '`)VALUES(' . rtrim(str_repeat('?,', count($b = array_values($b))), ',') . ')'; return DB::$d ? DB::column($c . 'RETURNING`id`', $b) : (DB::query($c, $b) ? static::$e->lastInsertId() : N); }
} 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) { #$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) {