function install_smooth_slider()
{
global $wpdb, $table_prefix;
$table_name = $table_prefix . SLIDER_TABLE;
if ($wpdb->get_var("show tables like '{$table_name}'") != $table_name) {
$sql = "CREATE TABLE {$table_name} (\r\r\n\t\t\t\t\tid int(5) NOT NULL AUTO_INCREMENT,\r\r\n\t\t\t\t\tpost_id int(11) NOT NULL,\r\r\n\t\t\t\t\tdate datetime NOT NULL,\r\r\n\t\t\t\t\tslider_id int(5) NOT NULL DEFAULT '1',\r\r\n\t\t\t\t\tUNIQUE KEY id(id)\r\r\n\t\t\t\t);";
$rs = $wpdb->query($sql);
$prev_table_name = $table_prefix . PREV_SLIDER_TABLE;
if ($wpdb->get_var("show tables like '{$prev_table_name}'") == $prev_table_name) {
$prev_slider_data = ss_get_prev_slider();
foreach ($prev_slider_data as $prev_slider_row) {
$prev_post_id = $prev_slider_row['id'];
$prev_date_time = $prev_slider_row['date'];
if ($prev_post_id) {
$sql = "INSERT INTO {$table_name} (post_id,date) VALUES('{$prev_post_id}','{$prev_date_time}');";
$result = $wpdb->query($sql);
}
}
}
}
add_column_if_not_exist($table_name, 'slide_order', "ALTER TABLE " . $table_name . " ADD slide_order int(5) NOT NULL DEFAULT '0';");
$meta_table_name = $table_prefix . SLIDER_META;
if ($wpdb->get_var("show tables like '{$meta_table_name}'") != $meta_table_name) {
$sql = "CREATE TABLE {$meta_table_name} (\r\r\n\t\t\t\t\tslider_id int(5) NOT NULL AUTO_INCREMENT,\r\r\n\t\t\t\t\tslider_name varchar(100) NOT NULL default '',\r\r\n\t\t\t\t\tUNIQUE KEY slider_id(slider_id)\r\r\n\t\t\t\t);";
$rs2 = $wpdb->query($sql);
$sql = "INSERT INTO {$meta_table_name} (slider_id,slider_name) VALUES('1','Smooth Slider');";
$rs3 = $wpdb->query($sql);
}
$slider_postmeta = $table_prefix . SLIDER_POST_META;
if ($wpdb->get_var("show tables like '{$slider_postmeta}'") != $slider_postmeta) {
$sql = "CREATE TABLE {$slider_postmeta} (\r\r\n\t\t\t\t\tpost_id int(11) NOT NULL,\r\r\n\t\t\t\t\tslider_id int(5) NOT NULL default '1',\r\r\n\t\t\t\t\tUNIQUE KEY post_id(post_id)\r\r\n\t\t\t\t);";
$rs4 = $wpdb->query($sql);
}
// Need to delete the previously created options in old versions and create only one option field for Smooth Slider
$default_slider = array();
$default_slider = array('speed' => '7', 'no_posts' => '5', 'bg_color' => '#ffffff', 'height' => '200', 'width' => '450', 'border' => '1', 'brcolor' => '#999999', 'prev_next' => '0', 'goto_slide' => '1', 'title_text' => 'Featured Posts', 'title_font' => 'Georgia', 'title_fsize' => '20', 'title_fstyle' => 'bold', 'title_fcolor' => '#000000', 'ptitle_font' => 'Trebuchet MS', 'ptitle_fsize' => '14', 'ptitle_fstyle' => 'bold', 'ptitle_fcolor' => '#000000', 'img_align' => 'left', 'img_height' => '120', 'img_width' => '165', 'img_border' => '1', 'img_brcolor' => '#000000', 'content_font' => 'Verdana', 'content_fsize' => '12', 'content_fstyle' => 'normal', 'content_fcolor' => '#333333', 'content_from' => 'content', 'content_chars' => '300', 'bg' => '0', 'image_only' => '0', 'allowable_tags' => '', 'more' => 'Read More', 'img_size' => '1', 'img_pick' => array('1', 'slider_thumbnail', '1', '1', '1', '1'), 'user_level' => 'edit_others_posts', 'custom_nav' => '', 'crop' => '0', 'transition' => '5', 'autostep' => '1', 'multiple_sliders' => '0', 'navimg_w' => '32', 'navimg_ht' => '32', 'content_limit' => '50', 'stylesheet' => 'default.css', 'shortcode' => '1');
$smooth_slider = get_option('smooth_slider_options');
$img_pick = $smooth_slider['img_pick'];
if (is_array($img_pick)) {
//if(isset($smooth_slider['img_pick'][1])) {
$cskey = $smooth_slider['img_pick'][1];
} else {
$cskey = 'slider_thumbnail';
}
if (!is_array($img_pick)) {
//if(!isset($smooth_slider['img_pick'][0])) {
if ($smooth_slider['img_pick'] == '1') {
$smooth_slider['img_pick'] = array('0', $cskey, '0', '0', '1', '1');
} elseif ($smooth_slider['img_pick'] == '0') {
$smooth_slider['img_pick'] = array('1', $cskey, '0', '0', '1', '0');
} else {
$smooth_slider['img_pick'] = array('1', $cskey, '1', '1', '1', '1');
}
}
/* if(is_array($img_pick) and (count($img_pick)<6 or count($img_pick)>6)) {
$smooth_slider['img_pick'] = array('1',$cskey,'1','1','1','1');
}
*/
if (!$smooth_slider) {
$smooth_slider = array();
}
foreach ($default_slider as $key => $value) {
if (!isset($smooth_slider[$key])) {
$smooth_slider[$key] = $value;
}
}
if ($smooth_slider['user_level'] <= 10 and $smooth_slider['user_level'] >= 1) {
if ($smooth_slider['user_level'] <= 10 and $smooth_slider['user_level'] > 7) {
$smooth_slider['user_level'] = 'manage_options';
} elseif ($smooth_slider['user_level'] <= 7 and $smooth_slider['user_level'] > 2) {
$smooth_slider['user_level'] = 'edit_others_posts';
} elseif ($smooth_slider['user_level'] == 2) {
$smooth_slider['user_level'] = 'publish_posts';
} else {
$smooth_slider['user_level'] = 'edit_posts';
}
}
delete_option('smooth_slider_options');
update_option('smooth_slider_options', $smooth_slider);
delete_option('smooth_slider_speed');
delete_option('smooth_slider_no_posts');
delete_option('smooth_slider_bg_color');
delete_option('smooth_slider_height');
delete_option('smooth_slider_width');
delete_option('smooth_slider_border');
delete_option('smooth_slider_brcolor');
delete_option('smooth_slider_prev_next');
delete_option('smooth_slider_goto_slide');
delete_option('smooth_slider_title_text');
delete_option('smooth_slider_title_font');
delete_option('smooth_slider_title_fsize');
delete_option('smooth_slider_title_fstyle');
delete_option('smooth_slider_title_fcolor');
delete_option('smooth_slider_ptitle_font');
delete_option('smooth_slider_ptitle_fsize');
delete_option('smooth_slider_ptitle_fstyle');
delete_option('smooth_slider_ptitle_fcolor');
delete_option('smooth_slider_img_align');
delete_option('smooth_slider_img_height');
delete_option('smooth_slider_img_width');
delete_option('smooth_slider_img_border');
delete_option('smooth_slider_img_brcolor');
delete_option('smooth_slider_content_font');
delete_option('smooth_slider_content_fsize');
delete_option('smooth_slider_content_fstyle');
delete_option('smooth_slider_content_fcolor');
delete_option('smooth_slider_content_from');
delete_option('smooth_slider_content_chars');
delete_option('smooth_slider_bg');
delete_option('smooth_slider_clear');
delete_option('smooth_slider_image_only');
}
function install_smooth_slider()
{
global $wpdb, $table_prefix, $smooth_db_version;
$installed_ver = get_option("smooth_db_version");
if ($installed_ver != $smooth_db_version) {
$table_name = $table_prefix . SLIDER_TABLE;
if ($wpdb->get_var("show tables like '{$table_name}'") != $table_name) {
$sql = "CREATE TABLE {$table_name} (\r\n\t\t\t\t\t\tid int(5) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\tpost_id int(11) NOT NULL,\r\n\t\t\t\t\t\tdate datetime NOT NULL,\r\n\t\t\t\t\t\tslider_id int(5) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\tUNIQUE KEY id(id)\r\n\t\t\t\t\t);";
$rs = $wpdb->query($sql);
$prev_table_name = $table_prefix . PREV_SLIDER_TABLE;
if ($wpdb->get_var("show tables like '{$prev_table_name}'") == $prev_table_name) {
$prev_slider_data = ss_get_prev_slider();
foreach ($prev_slider_data as $prev_slider_row) {
$prev_post_id = $prev_slider_row['id'];
$prev_date_time = $prev_slider_row['date'];
if ($prev_post_id) {
$sql = "INSERT INTO {$table_name} (post_id,date) VALUES('{$prev_post_id}','{$prev_date_time}');";
$result = $wpdb->query($sql);
}
}
}
}
add_cf5_column_if_not_exist($table_name, 'slide_order', "ALTER TABLE " . $table_name . " ADD slide_order int(5) NOT NULL DEFAULT '0';");
$meta_table_name = $table_prefix . SLIDER_META;
if ($wpdb->get_var("show tables like '{$meta_table_name}'") != $meta_table_name) {
$sql = "CREATE TABLE {$meta_table_name} (\r\n\t\t\t\t\t\tslider_id int(5) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\tslider_name varchar(100) NOT NULL default '',\r\n\t\t\t\t\t\tUNIQUE KEY slider_id(slider_id)\r\n\t\t\t\t\t);";
$rs2 = $wpdb->query($sql);
$sql = "INSERT INTO {$meta_table_name} (slider_id,slider_name) VALUES('1','Smooth Slider');";
$rs3 = $wpdb->query($sql);
}
$slider_postmeta = $table_prefix . SLIDER_POST_META;
if ($wpdb->get_var("show tables like '{$slider_postmeta}'") != $slider_postmeta) {
$sql = "CREATE TABLE {$slider_postmeta} (\r\n\t\t\t\t\t\tpost_id int(11) NOT NULL,\r\n\t\t\t\t\t\tslider_id int(5) NOT NULL default '1',\r\n\t\t\t\t\t\tUNIQUE KEY post_id(post_id)\r\n\t\t\t\t\t);";
$rs4 = $wpdb->query($sql);
}
global $default_slider;
$smooth_slider = get_option('smooth_slider_options');
$img_pick = $smooth_slider['img_pick'];
if (is_array($img_pick)) {
$cskey = $smooth_slider['img_pick'][1];
} else {
$cskey = 'slider_thumbnail';
}
if (!is_array($img_pick)) {
//if(!isset($smooth_slider['img_pick'][0])) {
if ($smooth_slider['img_pick'] == '1') {
$smooth_slider['img_pick'] = array('0', $cskey, '0', '0', '1', '1');
} elseif ($smooth_slider['img_pick'] == '0') {
$smooth_slider['img_pick'] = array('1', $cskey, '0', '0', '1', '0');
} else {
$smooth_slider['img_pick'] = array('1', $cskey, '1', '1', '1', '1');
}
}
/* if(is_array($img_pick) and (count($img_pick)<6 or count($img_pick)>6)) {
$smooth_slider['img_pick'] = array('1',$cskey,'1','1','1','1');
}
*/
if (!$smooth_slider) {
$smooth_slider = array();
}
//if($smooth_slider and !isset($smooth_slider['ver'])){
$smooth_slider['stylesheet'] = 'default';
//}
foreach ($default_slider as $key => $value) {
if (!isset($smooth_slider[$key])) {
$smooth_slider[$key] = $value;
}
}
$smooth_slider['ver'] = 'j';
if ($smooth_slider['user_level'] <= 10 and $smooth_slider['user_level'] >= 1) {
if ($smooth_slider['user_level'] <= 10 and $smooth_slider['user_level'] > 7) {
$smooth_slider['user_level'] = 'manage_options';
} elseif ($smooth_slider['user_level'] <= 7 and $smooth_slider['user_level'] > 2) {
$smooth_slider['user_level'] = 'edit_others_posts';
} elseif ($smooth_slider['user_level'] == 2) {
$smooth_slider['user_level'] = 'publish_posts';
} else {
$smooth_slider['user_level'] = 'edit_posts';
}
}
delete_option('smooth_slider_options');
update_option('smooth_slider_options', $smooth_slider);
update_option("smooth_db_version", $smooth_db_version);
}
}
function install_smooth_slider() {
global $wpdb, $table_prefix;
$table_name = $table_prefix.SLIDER_TABLE;
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = "CREATE TABLE $table_name (
id int(5) NOT NULL AUTO_INCREMENT,
post_id int(11) NOT NULL,
date datetime NOT NULL,
slider_id int(5) NOT NULL DEFAULT '1',
UNIQUE KEY id(id)
);";
$rs = $wpdb->query($sql);
$prev_table_name = $table_prefix.PREV_SLIDER_TABLE;
if($wpdb->get_var("show tables like '$prev_table_name'") == $prev_table_name) {
$prev_slider_data = ss_get_prev_slider();
foreach ($prev_slider_data as $prev_slider_row){
$prev_post_id = $prev_slider_row['id'];
$prev_date_time = $prev_slider_row['date'];
if ($prev_post_id) {
$sql = "INSERT INTO $table_name (post_id,date) VALUES('$prev_post_id','$prev_date_time');";
$result = $wpdb->query($sql);
}
}
}
}
add_cf5_column_if_not_exist($table_name, 'slide_order', "ALTER TABLE ".$table_name." ADD slide_order int(5) NOT NULL DEFAULT '0';");
$meta_table_name = $table_prefix.SLIDER_META;
if($wpdb->get_var("show tables like '$meta_table_name'") != $meta_table_name) {
$sql = "CREATE TABLE $meta_table_name (
slider_id int(5) NOT NULL AUTO_INCREMENT,
slider_name varchar(100) NOT NULL default '',
UNIQUE KEY slider_id(slider_id)
);";
$rs2 = $wpdb->query($sql);
$sql = "INSERT INTO $meta_table_name (slider_id,slider_name) VALUES('1','Smooth Slider');";
$rs3 = $wpdb->query($sql);
}
$slider_postmeta = $table_prefix.SLIDER_POST_META;
if($wpdb->get_var("show tables like '$slider_postmeta'") != $slider_postmeta) {
$sql = "CREATE TABLE $slider_postmeta (
post_id int(11) NOT NULL,
slider_id int(5) NOT NULL default '1',
UNIQUE KEY post_id(post_id)
);";
$rs4 = $wpdb->query($sql);
}
// Need to delete the previously created options in old versions and create only one option field for Smooth Slider
$default_slider = array();
$default_slider = array('speed'=>'7',
'no_posts'=>'5',
'bg_color'=>'#ffffff',
'height'=>'250',
'width'=>'450',
'border'=>'1',
'brcolor'=>'#999999',
'prev_next'=>'0',
'goto_slide'=>'1',
'title_text'=>'Featured Posts',
'title_from'=>'0',
'title_font'=>'Georgia',
'title_fsize'=>'20',
'title_fstyle'=>'bold',
'title_fcolor'=>'#000000',
'ptitle_font'=>'Trebuchet MS',
'ptitle_fsize'=>'14',
'ptitle_fstyle'=>'bold',
'ptitle_fcolor'=>'#000000',
'img_align'=>'left',
'img_height'=>'120',
'img_width'=>'165',
'img_border'=>'1',
'img_brcolor'=>'#000000',
'content_font'=>'Verdana',
'content_fsize'=>'12',
'content_fstyle'=>'normal',
'content_fcolor'=>'#333333',
'content_from'=>'content',
'content_chars'=>'300',
'bg'=>'0',
'image_only'=>'0',
'allowable_tags'=>'',
'more'=>'Read More',
'img_size'=>'1',
'img_pick'=>array('1','slider_thumbnail','1','1','1','1'), //use custom field/key, name of the key, use post featured image, pick the image attachment, attachment order,scan images
'user_level'=>'edit_others_posts',
'custom_nav'=>'',
'crop'=>'0',
'transition'=>'5',
'autostep'=>'1',
'multiple_sliders'=>'0',
'navimg_w'=>'32',
'navimg_ht'=>'32',
'content_limit'=>'20',
'stylesheet'=>'default',
'shortcode'=>'1',
'rand'=>'0',
'ver'=>'j',
'support'=>'1',
'fouc'=>'0',
'fx'=>'scrollHorz',
'responsive'=>'0',
'css'=>'',
'noscript'=>'This page is having a slideshow that uses Javascript. Your browser either doesn\'t support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.'
);
$smooth_slider = get_option('smooth_slider_options');
/*if($smooth_slider){
$default_slider['ver']='step';
}*/
$img_pick = $smooth_slider['img_pick'];
if(is_array($img_pick)) {
$cskey = $smooth_slider['img_pick'][1];
}
else{
$cskey = 'slider_thumbnail';
}
if(!is_array($img_pick)) {
//if(!isset($smooth_slider['img_pick'][0])) {
if($smooth_slider['img_pick'] == '1') {
$smooth_slider['img_pick'] = array('0',$cskey,'0','0','1','1');
}
elseif($smooth_slider['img_pick'] == '0'){
$smooth_slider['img_pick'] = array('1',$cskey,'0','0','1','0');
}
else {
$smooth_slider['img_pick'] = array('1',$cskey,'1','1','1','1');
}
}
/* if(is_array($img_pick) and (count($img_pick)<6 or count($img_pick)>6)) {
$smooth_slider['img_pick'] = array('1',$cskey,'1','1','1','1');
}
*/
if(!$smooth_slider) {
$smooth_slider = array();
}
//if($smooth_slider and !isset($smooth_slider['ver'])){
$smooth_slider['stylesheet']='default';
//}
foreach($default_slider as $key=>$value) {
if(!isset($smooth_slider[$key])) {
$smooth_slider[$key] = $value;
}
}
$smooth_slider['ver']='j';
if($smooth_slider['user_level']<=10 and $smooth_slider['user_level'] >=1) {
if($smooth_slider['user_level']<=10 and $smooth_slider['user_level'] >7) {
$smooth_slider['user_level']='manage_options';
}
elseif($smooth_slider['user_level']<=7 and $smooth_slider['user_level'] >2){
$smooth_slider['user_level']='edit_others_posts';
}
elseif($smooth_slider['user_level']==2){
$smooth_slider['user_level']='publish_posts';
}
else {
$smooth_slider['user_level']='edit_posts';
}
}
delete_option('smooth_slider_options');
update_option('smooth_slider_options',$smooth_slider);
}