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));
}
public function delete($id)
{
global $wpdb;
$this->oPlugin->oGallerySlideDBHelper->delete_from_gallery($id);
$wpdb->delete(SlideshowJedoGallery::table_gallery(), array('id' => $id));
}
private function drop_table_slideshow_jedo_gallery()
{
global $wpdb;
$query = "DROP TABLE " . SlideshowJedoGallery::table_gallery();
$wpdb->query($query);
require_once ABSPATH . 'wp-admin' . DS . 'upgrade-functions.php';
dbDelta($query, true);
}
