public function SlideshowJedoSlideDBHelper($oPlugin)
 {
     parent::SlideshowJedoGallery();
     $this->oPlugin = $oPlugin;
     $this->tableName = SlideshowJedoGallery::table_slide();
     $this->select_query = "SELECT `id`, `title`, `description`, `order`, \n\t\t\t\t\t\t\t\t`options`,\n\t\t\t\t\t\t\t\t`created`, `modified`\n\t\t                         FROM `" . $this->tableName . "` slide";
 }
 public function select($where)
 {
     global $wpdb;
     $query = "SELECT `id`, `gallery_id`, `slide_id`, `order`, `created`, `modified`,\n\t\t\t\t\t\t(SELECT `title` FROM `" . SlideshowJedoGallery::table_gallery() . "` WHERE id = galleryslide.gallery_id) AS `gallery_title`,\n\t\t\t\t\t\t(SELECT `title` FROM `" . SlideshowJedoGallery::table_slide() . "` WHERE id = galleryslide.slide_id) AS `slide_title`\n                    FROM `" . $this->tableName . "` galleryslide ";
     if (!empty($where) && 0 < count($where)) {
         $query .= " WHERE";
         $c = 1;
         foreach ($where as $ckey => $cval) {
             $query .= " `" . $ckey . "` = '" . $cval . "'";
             if ($c < count($where)) {
                 $query .= " AND";
             }
             $c++;
         }
     }
     return $wpdb->get_results($wpdb->prepare($query));
 }
 private function drop_table_slideshow_jedo_slide()
 {
     global $wpdb;
     $query = "DROP TABLE " . SlideshowJedoGallery::table_slide();
     $wpdb->query($query);
     require_once ABSPATH . 'wp-admin' . DS . 'upgrade-functions.php';
     dbDelta($query, true);
 }