function save_album()
{
global $wpdb;
$album_count = $wpdb->get_var("SELECT count(album_id) FROM " . gallery_bank_albums());
if ($album_count < 3) {
global $wpdb;
include_once GALLERY_BK_PLUGIN_DIR . "/views/header.php";
include_once GALLERY_BK_PLUGIN_DIR . "/views/edit-album.php";
} else {
?>
<script type="text/javascript">
window.location.href="admin.php?page=gallery_bank";
</script>
<?php
}
}
break;
case "name":
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_name asc");
break;
case "date":
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_date asc");
break;
case "asc":
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_id asc");
break;
case "desc":
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_id desc");
break;
}
} else {
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_order asc ");
}
$album_css = $wpdb->get_results("SELECT * FROM " . gallery_bank_settings());
if (count($album_css) != 0) {
$setting_keys = array();
for ($flag = 0; $flag < count($album_css); $flag++) {
array_push($setting_keys, $album_css[$flag]->setting_key);
}
$index = array_search("cover_thumbnail_width", $setting_keys);
$cover_thumbnail_width = $album_css[$index]->setting_value;
$index = array_search("cover_thumbnail_height", $setting_keys);
$cover_thumbnail_height = $album_css[$index]->setting_value;
$index = array_search("cover_thumbnail_opacity", $setting_keys);
$cover_thumbnail_opacity = $album_css[$index]->setting_value;
$index = array_search("cover_thumbnail_border_size", $setting_keys);
$cover_thumbnail_border_size = $album_css[$index]->setting_value;
$albumCover = $wpdb->get_row($wpdb->prepare("SELECT album_cover,thumbnail_url,video FROM " . gallery_bank_pics() . " WHERE album_cover=1 and album_id = %d", $album_id));
break;
case "grid" || "list":
if (isset($widget)) {
$galleryWidget = $widget;
} else {
$galleryWidget = "";
}
if ($img_in_row == "") {
$img_in_row = 0;
}
if ($show_albums == "all" || $show_albums == "") {
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_order asc");
} else {
if (preg_match("/^\\d+(?:,\\d+)*\$/", $show_albums)) {
$album = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " where album_id in ({$show_albums}) order by album_order asc");
}
}
break;
}
/** Switch for global settings **/
switch ($album_type) {
case "images":
$index = array_search("thumbnails_width", $setting_keys);
if ($widget == "true") {
$thumbnails_width = intval($thumb_width);
} else {
$thumbnails_width = intval($album_css[$index]->setting_value);
}
$index = array_search("thumbnails_height", $setting_keys);
if ($widget == "true") {
} else {
$wpdb->query($wpdb->prepare("UPDATE " . gallery_bank_pics() . " SET title = %s, description = %s, date = CURDATE(), tags = %s, album_cover = %d WHERE pic_id = %d", $field[4], $field[5], $field[6], 0, $field[1]));
}
}
die;
} else {
if ($_REQUEST["param"] == "delete_pic") {
$delete_array = html_entity_decode($_REQUEST["delete_array"]);
$albumId = intval($_REQUEST["albumid"]);
$wpdb->query("DELETE FROM " . gallery_bank_pics() . " WHERE pic_id in ({$delete_array})");
die;
} else {
if ($_REQUEST["param"] == "Delete_album") {
$album_id = intval($_REQUEST["album_id"]);
$wpdb->query($wpdb->prepare("DELETE FROM " . gallery_bank_pics() . " WHERE album_id = %d", $album_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . gallery_bank_albums() . " WHERE album_id = %d", $album_id));
die;
} else {
if ($_REQUEST["param"] == "update_option") {
update_option("gallery-bank-info-popup", "no");
die;
}
}
}
}
}
}
}
}
}
function process_image_upload($image, $width, $height)
<?php global $wpdb; $sql = "TRUNCATE TABLE " . gallery_bank_albums(); $wpdb->query($sql); $sql = "TRUNCATE TABLE " . gallery_bank_pics(); $wpdb->query($sql); include_once GALLERY_BK_PLUGIN_DIR . "/lib/include_settings.php";
function save_album()
{
global $wpdb, $current_user, $user_role_permission;
if (is_super_admin()) {
$gb_role = "administrator";
} else {
$gb_role = $wpdb->prefix . "capabilities";
$current_user->role = array_keys($current_user->{$gb_role});
$gb_role = $current_user->role[0];
}
$album_count = $wpdb->get_var("SELECT count(album_id) FROM " . gallery_bank_albums());
if ($album_count <= 3) {
include_once GALLERY_BK_PLUGIN_DIR . "/views/header.php";
include_once GALLERY_BK_PLUGIN_DIR . "/views/edit-album.php";
} else {
header("Location:admin.php?page=gallery_bank");
}
}
</th>
<th style="width:15%"><?php
_e("Date", gallery_bank);
?>
</th>
<th style="width:14%"><?php
_e("Short-Codes", gallery_bank);
?>
</th>
<th style="width:17%"></th>
</tr>
</thead>
<tbody>
<?php
for ($flag = 0; $flag < count($album); $flag++) {
$count_pic = $wpdb->get_var($wpdb->prepare("SELECT count(" . gallery_bank_albums() . ".album_id) FROM " . gallery_bank_albums() . " join " . gallery_bank_pics() . " on " . gallery_bank_albums() . ".album_id = " . gallery_bank_pics() . ".album_id where " . gallery_bank_albums() . ".album_id = %d ", $album[$flag]->album_id));
$albumCover = $wpdb->get_row($wpdb->prepare("SELECT album_cover,thumbnail_url,video FROM " . gallery_bank_pics() . " WHERE album_cover=1 and album_id = %d", $album[$flag]->album_id));
?>
<tr>
<td>
<a href="admin.php?page=save_album&album_id=<?php
echo $album[$flag]->album_id;
?>
" title="<?php
echo stripcslashes(htmlspecialchars_decode($album[$flag]->album_name));
?>
" >
<div class="imgLiquidFill dynamic_cover_css">
<?php
if (count($albumCover) != 0) {
if ($albumCover->album_cover == 0) {
function create_table_albums()
{
$sql = "CREATE TABLE " . gallery_bank_albums() . "(\r\n album_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n album_name VARCHAR(100),\r\n author VARCHAR(100),\r\n album_date DATE,\r\n description TEXT ,\r\n album_order INTEGER(10),\r\n PRIMARY KEY (album_id)\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
dbDelta($sql);
}
<?php
global $wpdb;
global $current_user;
$unique_id = rand(100, 10000);
if (isset($_REQUEST["row"])) {
$img_in_row = intval($_REQUEST["row"]);
} else {
$img_in_row = 3;
}
$album_id = intval($_REQUEST["album_id"]);
$album = $wpdb->get_var($wpdb->prepare("SELECT album_name FROM " . gallery_bank_albums() . " WHERE album_id = %d", $album_id));
$album_css = $wpdb->get_results("SELECT * FROM " . gallery_bank_settings());
/***** Global Queries ******/
$pics = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by sorting_order asc", $album_id));
/***** Global Settings ******/
if (count($album_css) != 0) {
$setting_keys = array();
for ($flag = 0; $flag < count($album_css); $flag++) {
array_push($setting_keys, $album_css[$flag]->setting_key);
}
$index = array_search("thumbnails_width", $setting_keys);
$thumbnails_width = $album_css[$index]->setting_value;
$index = array_search("thumbnails_height", $setting_keys);
$thumbnails_height = $album_css[$index]->setting_value;
$index = array_search("thumbnails_opacity", $setting_keys);
$thumbnails_opacity = $album_css[$index]->setting_value;
$index = array_search("thumbnails_border_size", $setting_keys);
$thumbnails_border_size = $album_css[$index]->setting_value;
$index = array_search("thumbnails_border_radius", $setting_keys);
$thumbnails_border_radius = $album_css[$index]->setting_value;
$pics_order = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by title asc", $album_id));
break;
case "date":
$pics_order = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by date asc", $album_id));
break;
case "asc":
$pics_order = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by pic_id asc", $album_id));
break;
case "desc":
$pics_order = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by pic_id desc", $album_id));
break;
}
} else {
$pics_order = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_pics() . " WHERE album_id = %d order by sorting_order asc", $album_id));
}
$album = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . gallery_bank_albums() . " where album_id = %d", $album_id));
$album_css = $wpdb->get_results("SELECT * FROM " . gallery_bank_settings());
if (count($album_css) != 0) {
$setting_keys = array();
for ($flag = 0; $flag < count($album_css); $flag++) {
array_push($setting_keys, $album_css[$flag]->setting_key);
}
$index = array_search("thumbnails_width", $setting_keys);
$thumbnails_width = $album_css[$index]->setting_value;
$index = array_search("thumbnails_height", $setting_keys);
$thumbnails_height = $album_css[$index]->setting_value;
$index = array_search("thumbnails_opacity", $setting_keys);
$thumbnails_opacity = $album_css[$index]->setting_value;
$index = array_search("thumbnails_border_size", $setting_keys);
$thumbnails_border_size = $album_css[$index]->setting_value;
$new_thumb_width = $thumbnails_width + $thumbnails_border_size * 4;
function add_gallery_bank_icon($meta = TRUE)
{
global $wp_admin_bar;
global $current_user, $wpdb;
$gb_role = $wpdb->prefix . "capabilities";
$current_user->role = array_keys($current_user->{$gb_role});
$gb_role = $current_user->role[0];
if (!is_user_logged_in()) {
return;
}
include GALLERY_BK_PLUGIN_DIR . "/lib/include_roles_settings.php";
$last_album_id = $wpdb->get_var("SELECT album_id FROM " . gallery_bank_albums() . " order by album_id desc limit 1");
$id = count($last_album_id) == 0 ? 1 : $last_album_id + 1;
switch ($gb_role) {
case "administrator":
if ($admin_full_control == "0" && $admin_read_control == "1" && $admin_write_control == "0") {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($admin_full_control == "0" && ($admin_read_control == "1" || $admin_write_control == "1")) {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($admin_full_control == "0" && $admin_read_control == "0" && $admin_write_control == "0") {
} else {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "Licensing_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_licensing", "title" => __("Licensing", gallery_bank)));
}
break;
case "editor":
if ($editor_full_control == "0" && $editor_read_control == "1" && $editor_write_control == "0") {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($editor_full_control == "0" && ($editor_read_control == "1" || $editor_write_control == "1")) {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($editor_full_control == "0" && $editor_read_control == "0" && $editor_write_control == "0") {
} else {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "Licensing_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_licensing", "title" => __("Licensing", gallery_bank)));
}
break;
case "author":
if ($author_full_control == "0" && $author_read_control == "1" && $author_write_control == "0") {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($author_full_control == "0" && ($author_read_control == "1" || $author_write_control == "1")) {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($author_full_control == "0" && $author_read_control == "0" && $author_write_control == "0") {
} else {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "Licensing_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_licensing", "title" => __("Licensing", gallery_bank)));
}
break;
case "contributor":
if ($contributor_full_control == "0" && $contributor_read_control == "1" && $contributor_write_control == "0") {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($contributor_full_control == "0" && ($contributor_read_control == "1" || $contributor_write_control == "1")) {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($contributor_full_control == "0" && $contributor_read_control == "0" && $contributor_write_control == "0") {
} else {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "Licensing_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_licensing", "title" => __("Licensing", gallery_bank)));
}
break;
case "subscriber":
if ($subscriber_full_control == "0" && $subscriber_read_control == "1" && $subscriber_write_control == "0") {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($subscriber_full_control == "0" && ($subscriber_read_control == "1" || $subscriber_write_control == "1")) {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
} elseif ($subscriber_full_control == "0" && $subscriber_read_control == "0" && $subscriber_write_control == "0") {
} else {
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . plugins_url("/assets/images/icon.png", __FILE__) . "\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "recommendation_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_recommended_plugins", "title" => __("Recommendations", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "our_services_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_other_services", "title" => __("Our Other Services", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "Licensing_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_licensing", "title" => __("Licensing", gallery_bank)));
}
break;
}
}
<?php
global $wpdb, $current_user;
if (!is_user_logged_in()) {
return;
}
$sql = "DROP TABLE " . gallery_bank_albums();
$wpdb->query($sql);
$sql = "DROP TABLE " . gallery_bank_pics();
$wpdb->query($sql);
$sql = "DROP TABLE " . gallery_bank_settings();
$wpdb->query($sql);
$sql = "DROP TABLE " . gallery_bank_licensing();
$wpdb->query($sql);
delete_option("gallery-bank-pro-edition");
delete_option("gallery-bank-updation-check-url");
delete_option("gallery-bank-activation");
delete_option("allow_tracking_gb");
function widget($args, $instance)
{
global $wpdb, $responsiveGallery;
$albums = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM " . gallery_bank_albums() . " WHERE album_id = %d", $instance["galleryid"]));
extract($args, EXTR_SKIP);
echo $before_widget;
$title = empty($instance["title"]) ? " " : apply_filters("widget_title", $instance["title"]);
if ($instance["responsive"] == 1) {
$responsiveGallery = "responsive = \"true\"";
} else {
$responsiveGallery = "img_in_row=\"" . $instance["imgInRow"] . "\"";
}
if ($albums > 0) {
if ($instance["galleryid"] != 0) {
echo $before_title . $title . $after_title;
if ($instance["displayImages"] == "all") {
switch ($instance["textFormat"]) {
case "title_only":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"true\" desc=\"false\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tanimation_effect=\"" . $instance["animationEffect"] . "\" thumb_width=\"" . $instance["thumbWidth"] . "\" \r\n\t\t\t\t\t\t\tthumb_height=\"" . $instance["thumbHeight"] . "\" album_id=\"" . $instance["galleryid"] . "\" display=\"all\" widget=\"true\"]";
break;
case "title_desc":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"true\" desc=\"true\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tthumb_width=\"" . $instance["thumbWidth"] . "\" thumb_height=\"" . $instance["thumbHeight"] . "\" \r\n\t\t\t\t\t\t\tanimation_effect=\"" . $instance["animationEffect"] . "\" album_id=\"" . $instance["galleryid"] . "\" display=\"all\" widget=\"true\"]";
break;
case "no_text":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"false\" desc=\"false\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tthumb_width=\"" . $instance["thumbWidth"] . "\" thumb_height=\"" . $instance["thumbHeight"] . "\" \r\n\t\t\t\t\t\t\tspecial_effect=\"" . $instance["specialEffect"] . "\" animation_effect=\"" . $instance["animationEffect"] . "\" \r\n\t\t\t\t\t\t\talbum_id=\"" . $instance["galleryid"] . "\" display=\"all\" widget=\"true\"]";
break;
}
} else {
switch ($instance["textFormat"]) {
case "title_only":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"true\" desc=\"false\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tanimation_effect=\"" . $instance["animationEffect"] . "\" thumb_width=\"" . $instance["thumbWidth"] . "\" \r\n\t\t\t\t\t\t\tthumb_height=\"" . $instance["thumbHeight"] . "\" album_id=\"" . $instance["galleryid"] . "\" display=\"selected\" \r\n\t\t\t\t\t\t\tno_of_images=\"" . $instance["numberOfImages"] . "\" sort_by=\"" . $instance["sortBy"] . "\" widget=\"true\"]";
break;
case "title_desc":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"true\" desc=\"true\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tthumb_width=\"" . $instance["thumbWidth"] . "\" thumb_height=\"" . $instance["thumbHeight"] . "\" \r\n\t\t\t\t\t\t\tanimation_effect=\"" . $instance["animationEffect"] . "\" album_id=\"" . $instance["galleryid"] . "\" display=\"selected\" \r\n\t\t\t\t\t\t\tno_of_images=\"" . $instance["numberOfImages"] . "\" sort_by=\"" . $instance["sortBy"] . "\" widget=\"true\"]";
break;
case "no_text":
$shortcode_for_albums = "[gallery_bank type=\"images\" format=\"" . $instance["galleryFormat"] . "\" \r\n\t\t\t\t\t\t\ttitle=\"false\" desc=\"false\" " . $responsiveGallery . " \r\n\t\t\t\t\t\t\tthumb_width=\"" . $instance["thumbWidth"] . "\" thumb_height=\"" . $instance["thumbHeight"] . "\" \r\n\t\t\t\t\t\t\tspecial_effect=\"" . $instance["specialEffect"] . "\" animation_effect=\"" . $instance["animationEffect"] . "\" \r\n\t\t\t\t\t\t\talbum_id=\"" . $instance["galleryid"] . "\" display=\"selected\" no_of_images=\"" . $instance["numberOfImages"] . "\" \r\n\t\t\t\t\t\t\tsort_by=\"" . $instance["sortBy"] . "\" widget=\"true\"]";
break;
}
}
echo do_shortcode($shortcode_for_albums);
echo $after_widget;
}
}
}
</div>
<div class="layout-control-group" id="ux_select_album" style="display: block;">
<label class="custom-layout-label"><?php
_e("Choose Album", gallery_bank);
?>
: </label>
<select id="ux_ddl_select_album" class="layout-span7">
<?php
global $wpdb, $current_user;
$gb_role = $wpdb->prefix . "capabilities";
$current_user->role = array_keys($current_user->{$gb_role});
$gb_role = $current_user->role[0];
if ($gb_role == "administrator") {
$albums = $wpdb->get_results("SELECT * FROM " . gallery_bank_albums() . " order by album_order asc ");
} else {
$albums = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . gallery_bank_albums() . " where author = %s order by album_order asc ", $current_user->display_name));
}
for ($flag = 0; $flag < count($albums); $flag++) {
?>
<option value="<?php
echo intval($albums[$flag]->album_id);
?>
"><?php
echo esc_html($albums[$flag]->album_name);
?>
</option>
<?php
}
?>
</select>
</div>
function add_gallery_bank_icon($meta = TRUE)
{
global $wp_admin_bar, $wpdb;
if (!is_user_logged_in()) {
return;
}
$last_album_id = $wpdb->get_var("SELECT album_id FROM " . gallery_bank_albums() . " order by album_id desc limit 1");
$id = count($last_album_id) == 0 ? 1 : $last_album_id + 1;
$wp_admin_bar->add_menu(array("id" => "gallery_bank_links", "title" => __("<img src=\"" . GALLERY_BK_PLUGIN_URL . "/assets/images/icon.png\" width=\"25\"\n height=\"25\" style=\"vertical-align:text-top; margin-right:5px;\" />Gallery Bank"), "href" => __(site_url() . "/wp-admin/admin.php?page=gallery_bank")));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "dashboard_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank", "title" => __("Dashboard", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "add_new_album_links", "href" => site_url() . "/wp-admin/admin.php?page=save_album&album_id=" . $id, "title" => __("Add New Album", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "sorting_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_album_sorting", "title" => __("Album Sorting", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "global_settings_links", "href" => site_url() . "/wp-admin/admin.php?page=global_settings", "title" => __("Global Settings", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "system_status_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_system_status", "title" => __("System Status", gallery_bank)));
$wp_admin_bar->add_menu(array("parent" => "gallery_bank_links", "id" => "purchase_pro_version_links", "href" => site_url() . "/wp-admin/admin.php?page=gallery_bank_purchase", "title" => __("Purchase Pro Version", gallery_bank)));
}
