Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory :  /home/claqxcrl/confenda.com/wp-content/plugins/photo-gallery/admin/models/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

class ShortcodeModel_bwg {

  public function get_shortcode_data() {
    global $wpdb;
    $shortcode = $wpdb->get_results("SELECT id, tagtext FROM " . $wpdb->prefix . "bwg_shortcode ORDER BY `id` ASC");

    return $shortcode;
  }

  public function get_shortcode_max_id() {
    global $wpdb;
    $max_id = $wpdb->get_var("SELECT MAX(id) FROM " . $wpdb->prefix . "bwg_shortcode");
    return $max_id;
  }

  public function get_gallery_rows_data() {
    global $wpdb;
    $query = "SELECT * FROM " . $wpdb->prefix . "bwg_gallery WHERE published=1 ORDER BY name";
    $rows = $wpdb->get_results($query);
    return $rows;
  }

  public function get_album_rows_data() {
    global $wpdb;
    $query = "SELECT * FROM " . $wpdb->prefix . "bwg_album WHERE published=1 ORDER BY name";
    $rows = $wpdb->get_results($query);
    return $rows;
  }

  public function get_theme_rows_data() {
    global $wpdb;
    $query = "SELECT * FROM " . $wpdb->prefix . "bwg_theme ORDER BY `default_theme` DESC, `name`";
    $rows = $wpdb->get_results($query);
    return $rows;
  }

  public function get_tag_rows_data() {
    global $wpdb;
    $query ="SELECT * FROM ".$wpdb->prefix."terms as A LEFT JOIN ".$wpdb->prefix ."term_taxonomy as B ON A.term_id = B.term_id WHERE B.taxonomy='bwg_tag'";
    $rows = $wpdb->get_results($query);
    return $rows;
  }
}