ChSoundsDb.php

Go to the documentation of this file.

<?php
 
require_once(CH_DIRECTORY_PATH_CLASSES . 'ChWsbFilesDb.php');
 
class ChSoundsDb extends ChWsbFilesDb
{
    /*
     * Constructor.
     */
    function __construct (&$oConfig)
    {
        parent::__construct($oConfig);
        $this->aFileFields['medViews'] = 'Listens';
        $this->sFileTable = 'RayMp3Files';
        $this->sFavoriteTable = 'ch_sounds_favorites';
    }
 
    function getSettingsCategory ()
    {
        return (int)$this->getOne("SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Sounds' LIMIT 1");
    }
 
    function updateAudio($iId, $aData) {
        // process all recived fields;
        foreach($aData as $sKey => $mValue) {
            $mValue = process_db_input($mValue, CH_TAGS_VALIDATE, CH_SLASHES_AUTO);
            $sKey = process_db_input($sKey, CH_TAGS_STRIP, CH_SLASHES_NO_ACTION);
            $sFields .= "`{$sKey}` = '{$mValue}', ";
        }
 
        $sFields = preg_replace( '/,$/', '', trim($sFields) );
 
        $sQuery = "UPDATE `RayMp3Files` SET {$sFields} WHERE `ID` = '$iId'";
        $this -> query($sQuery);
    }
 
    function getAudioData($iId) {
        $sQuery = "SELECT * FROM `RayMp3Files` WHERE `ID` = '$iId'";
        return $this -> getRow($sQuery);
    }
 
}