Пример #1
0
 /**
  * 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);
 }
Пример #2
0
<?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;
Пример #3
0
$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)) {
Пример #4
0
Файл: DB.php Проект: Rgss/imp
 /**
  * set column field
  * 
  * @param string $field
  */
 public static function setColumnField($field = '*')
 {
     self::$column = $field;
 }
Пример #5
0
 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);
 }
Пример #6
0
        } 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) {