WordPress.org
Get WordPress

Plugin Directory

Changeset 397041


Ignore:
Timestamp:
06/14/2011 02:48:48 PM (15 years ago)
Author:
CJ_Jackson
Message:

Updated to 0.1.2

Location:
html5avmanager
Files:
75 added
6 edited

Legend:

Unmodified
Added
Removed

  • html5avmanager/trunk/html5avmanager.php

    r396791 r397041  
    55  Plugin URI: http://cj-jackson.com/
    66  Description: A video manager with a Modal-View-Controller and video uploader.
    7   Version: 0.1.1
     7  Version: 0.1.2
    88  Author: Christopher John Jackson
    99  Author URI: http://cj-jackson.com/

  • html5avmanager/trunk/lib/model/html5av_audio_video.php

    r396591 r397041  
    163163            }
    164164            $names = implode(', ', $names);
    165             $sql = "UPDATE " . $db->getPrefix() . "audio_video
     165            $sql = "UPDATE `" . $db->getPrefix() . "audio_video`
    166166            SET $names
    167167            WHERE ID=?;";
    … …  
    180180            $names = implode(', ', $names);
    181181            $values = implode(', ', $values);
    182             $sql = "INSERT INTO " . $db->getPrefix() . "audio_video ($names)
     182            $sql = "INSERT INTO `" . $db->getPrefix() . "audio_video` ($names)
    183183            VALUES ($values);";
    184184            $prepare = $db->prepare($sql);
    … …  
    200200            unlink($this->getPoster());
    201201            $db = new html5av_dbal();
    202             $sql = "DELETE FROM " . $db->getPrefix() . "audio_video WHERE ID=?;";
     202            $sql = "DELETE FROM `" . $db->getPrefix() . "audio_video` WHERE ID=?;";
    203203            $prepare = $db->prepare($sql);
    204204            $prepare->execute(array($this->ID));
    … …  
    213213    static public function getByID($id) {
    214214        $db = new html5av_dbal();
    215         $sql = "SELECT * FROM " . $db->getPrefix() . "audio_video WHERE ID=?;";
     215        $sql = "SELECT * FROM `" . $db->getPrefix() . "audio_video` WHERE ID=?;";
    216216        $prepare = $db->prepare($sql);
    217217        $prepare->execute(array($id));
    … …  
    221221    static public function pager() {
    222222        $db = new html5av_dbal();
    223         $sql = "SELECT count(*) as COUNT FROM " . $db->getPrefix() . "audio_video";
     223        $sql = "SELECT count(*) as COUNT FROM `" . $db->getPrefix() . "audio_video`";
    224224        $query = $db->query($sql);
    225225        $data = $query->fetch();
    … …  
    236236        $db = new html5av_dbal();
    237237        $offset = ($page - 1) * 25;
    238         $sql = "SELECT * FROM " . $db->getPrefix() . "audio_video ORDER BY ID DESC
     238        $sql = "SELECT * FROM `" . $db->getPrefix() . "audio_video` ORDER BY ID DESC
    239239            LIMIT ".$offset.", 25;";
    240240        $prepare = $db->prepare($sql);

  • html5avmanager/trunk/lib/model/html5av_source.php

    r396591 r397041  
    135135            }
    136136            $names = implode(', ', $names);
    137             $sql = "UPDATE " . $db->getPrefix() . "source
     137            $sql = "UPDATE `" . $db->getPrefix() . "source`
    138138            SET $names
    139139            WHERE ID=?;";
    … …  
    152152            $names = implode(', ', $names);
    153153            $values = implode(', ', $values);
    154             $sql = "INSERT INTO " . $db->getPrefix() . "source ($names)
     154            $sql = "INSERT INTO `" . $db->getPrefix() . "source` ($names)
    155155            VALUES ($values);";
    156156            $prepare = $db->prepare($sql);
    … …  
    166166            }
    167167            $db = new html5av_dbal();
    168             $sql = "DELETE FROM " . $db->getPrefix() . "source WHERE ID=?;";
     168            $sql = "DELETE FROM `" . $db->getPrefix() . "source` WHERE ID=?;";
    169169            $prepare = $db->prepare($sql);
    170170            $prepare->execute(array($this->ID));
    … …  
    179179    static public function getByID($id) {
    180180        $db = new html5av_dbal();
    181         $sql = "SELECT * FROM " . $db->getPrefix() . "source WHERE ID=?;";
     181        $sql = "SELECT * FROM `" . $db->getPrefix() . "source` WHERE ID=?;";
    182182        $prepare = $db->prepare($sql);
    183183        $prepare->execute(array($id));
    … …  
    188188        $db = new html5av_dbal();
    189189        if ($incDisabled) {
    190             $sql = "SELECT * FROM " . $db->getPrefix() . "source WHERE audio_video_id=? ORDER BY order_no ASC;";
    191         } else {
    192             $sql = "SELECT * FROM " . $db->getPrefix() . "source WHERE disabled=0 AND audio_video_id=? ORDER BY order_no ASC;";
     190            $sql = "SELECT * FROM `" . $db->getPrefix() . "source` WHERE audio_video_id=? ORDER BY order_no ASC;";
     191        } else {
     192            $sql = "SELECT * FROM `" . $db->getPrefix() . "source` WHERE disabled=0 AND audio_video_id=? ORDER BY order_no ASC;";
    193193        }
    194194        $prepare = $db->prepare($sql);

  • html5avmanager/trunk/lib/model/html5av_track.php

    r396591 r397041  
    155155            }
    156156            $names = implode(', ', $names);
    157             $sql = "UPDATE " . $db->getPrefix() . "track
     157            $sql = "UPDATE `" . $db->getPrefix() . "track`
    158158            SET $names
    159159            WHERE ID=?;";
    … …  
    172172            $names = implode(', ', $names);
    173173            $values = implode(', ', $values);
    174             $sql = "INSERT INTO " . $db->getPrefix() . "track ($names)
     174            $sql = "INSERT INTO `" . $db->getPrefix() . "track` ($names)
    175175            VALUES ($values);";
    176176            $prepare = $db->prepare($sql);
    … …  
    186186            }
    187187            $db = new html5av_dbal();
    188             $sql = "DELETE FROM " . $db->getPrefix() . "track WHERE ID=?;";
     188            $sql = "DELETE FROM `" . $db->getPrefix() . "track` WHERE ID=?;";
    189189            $prepare = $db->prepare($sql);
    190190            $prepare->execute(array($this->ID));
    … …  
    199199    static public function getByID($id) {
    200200        $db = new html5av_dbal();
    201         $sql = "SELECT * FROM " . $db->getPrefix() . "track WHERE ID=?;";
     201        $sql = "SELECT * FROM `" . $db->getPrefix() . "track` WHERE ID=?;";
    202202        $prepare = $db->prepare($sql);
    203203        $prepare->execute(array($id));
    … …  
    208208        $db = new html5av_dbal();
    209209        if ($incDisabled) {
    210             $sql = "SELECT * FROM " . $db->getPrefix() . "track WHERE audio_video_id=? ORDER BY order_no ASC;";
    211         } else {
    212             $sql = "SELECT * FROM " . $db->getPrefix() . "track WHERE disabled=0 AND audio_video_id=? ORDER BY order_no ASC;";
     210            $sql = "SELECT * FROM `" . $db->getPrefix() . "track` WHERE audio_video_id=? ORDER BY order_no ASC;";
     211        } else {
     212            $sql = "SELECT * FROM `" . $db->getPrefix() . "track` WHERE disabled=0 AND audio_video_id=? ORDER BY order_no ASC;";
    213213        }
    214214        $prepare = $db->prepare($sql);

  • html5avmanager/trunk/readme.txt

    r396791 r397041  
    55Requires at least: 2.7
    66Tested up to: 3.2
    7 Stable tag: 0.1.1
     7Stable tag: 0.1.2
    88
    99A HTML5 Audio and Video manager that take full advantage of
    … …  
    6060== Changelog ==
    6161
     62= 0.1.2 =
     63* Added Ticks (`) to SQL Statement, to prevent problem with prefixes that
     64contain spaces or even keywords.
     65
    6266= 0.1.1 =
    6367* Default default video view is now based upon [Video for Everybody](http://camendesign.com/code/video_for_everybody).

  • html5avmanager/trunk/sql/main.sql

    r396591 r397041  
    11-- rev 1
    22
    3 CREATE TABLE _prefix_audio_video (
     3CREATE TABLE `_prefix_audio_video` (
    44    ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    55    `type` varchar(20) NOT NULL,
    … …  
    1616) ENGINE=innodb;
    1717
    18 CREATE TABLE _prefix_source (
     18CREATE TABLE `_prefix_source` (
    1919    ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    2020    order_no bigint(20) UNSIGNED NOT NULL,
    … …  
    2626    disabled boolean NOT NULL,
    2727    audio_video_id bigint(20) UNSIGNED NOT NULL,
    28     FOREIGN KEY (audio_video_id) REFERENCES _prefix_audio_video(ID)
     28    FOREIGN KEY (audio_video_id) REFERENCES `_prefix_audio_video`(ID)
    2929ON UPDATE CASCADE ON DELETE CASCADE
    3030) ENGINE=innodb;
    3131
    32 CREATE TABLE _prefix_track (
     32CREATE TABLE `_prefix_track` (
    3333    ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    3434    order_no bigint(20) UNSIGNED NOT NULL,
    … …  
    4242    disabled boolean NOT NULL,
    4343    audio_video_id bigint(20) UNSIGNED NOT NULL,
    44     FOREIGN KEY (audio_video_id) REFERENCES _prefix_audio_video(ID)
     44    FOREIGN KEY (audio_video_id) REFERENCES `_prefix_audio_video`(ID)
    4545ON UPDATE CASCADE ON DELETE CASCADE
    4646) ENGINE=innodb;
Note: See TracChangeset for help on using the changeset viewer.