function form($instance)
{
$instance = wp_parse_args((array) $instance, array('title' => __("RoyalSlider", "new_royalslider")));
?>
<p>
<label for="<?php
echo $this->get_field_id('title');
?>
"><?php
_e("Title", "new_royalslider");
?>
:</label>
<input id="<?php
echo $this->get_field_id('title');
?>
" name="<?php
echo $this->get_field_name('title');
?>
" value="<?php
echo $instance['title'];
?>
" />
</p>
<p>
<label for="<?php
echo $this->get_field_id('royalslider_id');
?>
"><?php
_e("Select slider to add", "new_royalslider");
?>
:</label>
<select id="<?php
echo $this->get_field_id('royalslider_id');
?>
" name="<?php
echo $this->get_field_name('royalslider_id');
?>
" style="width:100%;">
<?php
global $wpdb;
$table = NewRoyalSliderMain::get_sliders_table_name();
$qstr = " \n\t\t\t\t\tSELECT id, name FROM {$table} WHERE active=1 AND type!='gallery'\n\t\t\t\t";
$res = $wpdb->get_results($qstr, ARRAY_A);
$curr_id = isset($instance['royalslider_id']) ? $instance['royalslider_id'] : '';
if (is_array($res)) {
foreach ($res as $key => $slider_data) {
$id = $slider_data['id'];
$selected = '';
if ($id == $curr_id) {
$selected = ' selected="selected"';
}
$name = isset($slider_data['name']) ? $slider_data['name'] . ' ' : '';
echo '<option value="' . $id . '"' . $selected . '>' . $name . '#' . $id . '</option>';
}
}
?>
</select>
</p>
<?php
}
function __construct($is_add_new)
{
$this->is_add_new = $is_add_new;
$this->slider_type = isset($_REQUEST['rstype']) ? esc_html($_REQUEST['rstype']) : '';
$this->parsed_options = null;
if (!$is_add_new && isset($_REQUEST['id'])) {
global $wpdb;
$this->slider_id = (int) $_REQUEST['id'];
$table = NewRoyalSliderMain::get_sliders_table_name();
$this->res = $wpdb->get_results($wpdb->prepare("\n SELECT * FROM {$table} WHERE id=%d\n ", $this->slider_id), ARRAY_A);
if (isset($this->res[0])) {
$this->res = $this->res[0];
$this->parsed_options = json_decode($this->res['options'], ARRAY_A);
}
}
$this->build_view();
}
function ajax_save_slider()
{
check_ajax_referer('new_royalslider_save_ajax_nonce');
global $wpdb;
$data = stripslashes_deep($_POST);
$options = isset($_POST['options']) ? json_encode($data['options']) : '';
$slides = isset($_POST['slides']) ? json_encode($data['slides']) : '';
$table_name = NewRoyalSliderMain::get_sliders_table_name();
//$type = strtolower($type);
$values = array('name' => $data['name'], 'type' => $data['slider_type'], 'skin' => $data['skin'], 'slides' => $slides, 'options' => $options, 'template' => $data['template'], 'template_html' => $data['template_html']);
$format = array('%s', '%s', '%s', '%s', '%s', '%s', '%s');
if (isset($_POST['isCreate']) && $_POST['isCreate'] == 'true') {
$wpdb->insert($table_name, $values, $format);
echo $wpdb->insert_id;
if ($data['slider_type'] == 'nextgen') {
update_option('new_royalslider_ng_slider_id', $wpdb->insert_id);
}
} else {
if (isset($_POST['slider_id'])) {
$wpdb->update($table_name, $values, array('ID' => $_POST['slider_id']), $format, array('%d'));
NewRoyalSliderMain::delete_cache_for($_POST['slider_id'], $data['slider_type']);
echo 'saved';
if ($data['slider_type'] == 'nextgen') {
update_option('new_royalslider_ng_slider_id', (int) $_POST['slider_id']);
}
} else {
echo 'incorrect id';
}
}
die;
}
private function duplicate_slider($id)
{
global $wpdb;
$table = NewRoyalSliderMain::get_sliders_table_name();
$res = $wpdb->get_results($wpdb->prepare("\n SELECT * FROM {$table} WHERE id=%d\n ", $id), ARRAY_A);
$res = $res[0];
$res['name'] = (isset($res['name']) && $res['name'] != '' ? $res['name'] . ' ' : '') . __('(copy of ', 'new_royalslider') . '#' . $id . ')';
unset($res['id']);
$wpdb->insert($table, $res);
return $wpdb->insert_id;
}
function activate_db()
{
$curr_ver = get_option("new_royalslider_version");
if ($curr_ver != NEW_ROYALSLIDER_WP_VERSION) {
global $wpdb;
$charset_collate = '';
if (!empty($wpdb->charset)) {
$charset_collate = " DEFAULT CHARACTER SET {$wpdb->charset}";
}
if (!empty($wpdb->collate)) {
$charset_collate .= " COLLATE {$wpdb->collate}";
}
$table_name = NewRoyalSliderMain::get_sliders_table_name();
$sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " (\r\n\t\t\t\t\t id \t\t\t\tmediumint(9) NOT NULL AUTO_INCREMENT,\t\r\n\t\t\t\t\t active tinyint(1) not null default 1,\r\n\t\t\t\t\t type \t\t\t\tvarchar(100) NOT NULL,\t\t\t\t \r\n\t\t\t\t\t name \t\t\t\tvarchar(100) NOT NULL,\r\n\t\t\t\t\t skin \t\t\t\tvarchar(100) NOT NULL,\r\n\t\t\t\t\t template varchar(100) NOT NULL,\r\n\t\t\t\t\t slides\t\t\tlongtext NOT NULL, \r\n\t\t\t\t\t options\t\t\tmediumtext NOT NULL, \r\n\t\t\t\t\t template_html\t\tmediumtext NOT NULL, \r\n\r\n\t\t\t\t\t PRIMARY KEY (id)\r\n\t\t\t\t)" . $charset_collate . ";";
$wpdb->query($sql);
// increase size of fields in old versions
if ($curr_ver && version_compare($curr_ver, '3.0.3', '<')) {
$upd_sql = "\r\n\t\t\t\tALTER TABLE {$table_name}\r\n\t\t\t\t\tMODIFY type varchar(100),\r\n\t\t\t\t\tMODIFY name varchar(100),\r\n\t\t\t\t\tMODIFY skin varchar(100),\r\n\t\t\t\t\tMODIFY template varchar(100)\r\n\t\t\t\t";
$wpdb->query($upd_sql);
}
$options = array('timeout' => 10, 'headers' => array('Accept' => 'application/json', 'Content-Type' => 'application/x-www-form-urlencoded; charset=' . get_option('blog_charset'), 'User-Agent' => 'WordPress/' . get_bloginfo("version") . ' RoyalSlider/' . NEW_ROYALSLIDER_WP_VERSION, 'Referer' => home_url()));
update_option("new_royalslider_version", NEW_ROYALSLIDER_WP_VERSION);
}
}
<?php
if (!defined('ABSPATH')) {
exit;
}
if (!defined('WP_UNINSTALL_PLUGIN')) {
exit;
}
global $wpdb;
require_once 'classes/NewRoyalSliderMain.php';
$slider_table = NewRoyalSliderMain::get_sliders_table_name();
$wpdb->query("DROP TABLE IF EXISTS {$slider_table}");
delete_option("new_royalslider_version");
delete_option('new_royalslider_config');
delete_option('new_royalslider_anim_block_classes');
delete_option('new_royalslider_instagram_oauth_token');
delete_option('new_royalslider_ng_slider_id');
function activate_db()
{
$curr_ver = get_option("new_royalslider_version");
if ($curr_ver != NEW_ROYALSLIDER_WP_VERSION) {
global $wpdb;
$charset_collate = '';
if (!empty($wpdb->charset)) {
$charset_collate = " DEFAULT CHARACTER SET {$wpdb->charset}";
}
if (!empty($wpdb->collate)) {
$charset_collate .= " COLLATE {$wpdb->collate}";
}
$table_name = NewRoyalSliderMain::get_sliders_table_name();
$sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " (\n\t\t\t\t\t id \t\t\t\tmediumint(9) NOT NULL AUTO_INCREMENT,\t\n\t\t\t\t\t active tinyint(1) not null default 1,\n\t\t\t\t\t type \t\t\t\tvarchar(100) NOT NULL,\t\t\t\t \n\t\t\t\t\t name \t\t\t\tvarchar(100) NOT NULL,\n\t\t\t\t\t skin \t\t\t\tvarchar(100) NOT NULL,\n\t\t\t\t\t template varchar(100) NOT NULL,\n\t\t\t\t\t slides\t\t\tlongtext NOT NULL, \n\t\t\t\t\t options\t\t\tmediumtext NOT NULL, \n\t\t\t\t\t template_html\t\tmediumtext NOT NULL, \n\n\t\t\t\t\t PRIMARY KEY (id)\n\t\t\t\t)" . $charset_collate . ";";
$wpdb->query($sql);
// increase size of fields in old versions
if ($curr_ver && version_compare($curr_ver, '3.0.3', '<')) {
$upd_sql = "\n\t\t\t\tALTER TABLE {$table_name}\n\t\t\t\t\tMODIFY type varchar(100),\n\t\t\t\t\tMODIFY name varchar(100),\n\t\t\t\t\tMODIFY skin varchar(100),\n\t\t\t\t\tMODIFY template varchar(100)\n\t\t\t\t";
$wpdb->query($upd_sql);
}
update_option("new_royalslider_version", NEW_ROYALSLIDER_WP_VERSION);
}
}