# wpforo/1.0.0/wpf-includes/functions-installation.php
wpForo Forum, version 1.0.0. 640 lines.
- Page: https://pluginprobe.com/plugins/wpforo/1.0.0/code/wpf-includes/functions-installation.php
- Raw: https://pluginprobe.com/plugins/wpforo/1.0.0/raw/wpf-includes/functions-installation.php
- Modified: 2016-09-06T20:35:18+00:00
Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/wpforo/1.0.0/code/wpf-includes/functions-installation.php#L10-L20`.
```php
db->query( $sql );
$wpforo->member->synchronize_users();
$wpforo->member->init_current_user();
$blogname = get_option('blogname');
$adminemail = get_option('admin_email');
add_option( 'wpforo_count_per_page', 10 );
###################################################################
// General Options ////////////////////////////////////////////////
$general_options = array(
'title' => $blogname . ' ' . __('Forum', 'wpforo'),
'description' => $blogname . ' ' . __('Discussion Board', 'wpforo'),
'lang' => 1,
);
wpforo_update_options( 'wpforo_general_options', $general_options );
###################################################################
// Forums /////////////////////////////////////////////////////////
$wpforo_forum = array(
'layout_qa_intro_topics_toggle' => 1,
'layout_extended_intro_topics_toggle' => 1,
'layout_qa_intro_topics_count' => 3,
'layout_extended_intro_topics_count' => 5,
);
wpforo_update_options( 'wpforo_forum_options', $wpforo_forum );
##################################################################
// Topics & Posts ////////////////////////////////////////////////
$upload_max_filesize = @ini_get('upload_max_filesize');
$upload_max_filesize = wpforo_human_size_to_bytes($upload_max_filesize);
if( !$upload_max_filesize || $upload_max_filesize > 10485760 ) $upload_max_filesize = 10485760;
$wpforo_post = array(
'layout_extended_intro_posts_toggle' => 1,
'layout_extended_intro_posts_count' => 4,
'topics_per_page' => 10,
'eot_durr' => 300,
'dot_durr' => 300,
'posts_per_page' => 15,
'eor_durr' => 300,
'dor_durr' => 300,
'max_upload_size' => $upload_max_filesize
);
wpforo_update_options( 'wpforo_post_options', $wpforo_post );
#################################################################
// Features /////////////////////////////////////////////////////
$wpforo_features = array(
'user-admin-bar' => 0,
'page-title' => 1,
'top-bar' => 1,
'top-bar-search' => 1,
'breadcrumb' => 1,
'footer-stat' => 1,
'author-link' => 0,
'comment-author-link' => 0,
'user-register' => 1,
'register-url' => 0,
'login-url' => 0,
'replace-avatar' => 1,
'avatars' => 1,
'custom-avatars' => 1,
'signature' => 1,
'rating' => 1,
'rating_title' => 1,
'member_cashe' => 1,
'seo-title' => 1,
'seo-meta' => 1,
'font-awesome' => 1,
'output-buffer' => 0,
'wp-date-format' => 0,
'subscribe_conf' => 1,
'attach-media-lib' => 1,
'debug-mode' => 0,
'copyright' => 1
);
wpforo_update_options( 'wpforo_features', $wpforo_features );
#################################################################
// Theme & Style ////////////////////////////////////////////////
$wpforo_style = array(
'font_size_forum' => 17,
'font_size_topic' => 16,
'font_size_post_content' => 14,
'custom_css' => "#wpforo-wrap {\r\n font-size: 13px; width: 100%; padding:10px 20px; margin:0px;\r\n}\r\n",
);
wpforo_update_options( 'wpforo_style_options', $wpforo_style );
$defaut_theme = 'classic';
$theme = $wpforo->tpl->find_theme( $defaut_theme );
$current_theme = get_option( 'wpforo_theme_options' );
if(!empty($current_theme)) {
$theme = wpforo_deep_merge($theme, $current_theme);
update_option( 'wpforo_theme_options', $theme );
}
add_option( 'wpforo_theme_options', $theme );
#################################################################
// Members //////////////////////////////////////////////////////
$wpforo_member = array(
'online_status_timeout' => 240,
'url_structure' => 'nicename',
'login_url' => '',
'register_url' => '',
'lost_password_url' => '',
'rating_title_ug' => array ( 1 => '1', 5 => '1', 4 => '1', 2 => '1', 3 => '1' ),
'rating_badge_ug' => array ( 1 => '1', 5 => '1', 4 => '1', 2 => '1', 3 => '1' ),
);
wpforo_update_options( 'wpforo_member_options', $wpforo_member );
#################################################################
// Subscribe Options ////////////////////////////////////////////
$subscriptions_options = array (
'from_name' => $blogname . ' - Forum',
'from_email' => $adminemail,
'admin_emails' => $adminemail,
'confirmation_email_subject' => "Please confirm subscription to [entry_title]",
'confirmation_email_message' => "Hello [member_name]!
\r\n Thank you for subscribing.
\r\n This is an automated response.
\r\n We are glad to inform you that after confirmation you will get updates from - [entry_title].
\r\n Please click on link below to complete this step.
\r\n [confirm_link]" ,
'new_topic_notification_email_subject' => "New Topic" ,
'new_topic_notification_email_message' => "Hello [member_name]!
\r\n New topic has been created on your subscribed forum - [forum].\r\n
\r\n [topic_title]\r\n \r\n [topic_desc]\r\n
\r\n
\r\n If you want to unsubscribe from this forum please use the link below.
\r\n [unsubscribe_link]" ,
'new_post_notification_email_subject' => "New Reply" ,
'new_post_notification_email_message' => "Hello [member_name]!
\r\n New reply has been posted on your subscribed topic - [topic].\r\n
\r\n [reply_title]\r\n \r\n [reply_desc]\r\n
\r\n
\r\n If you want to unsubscribe from this topic please use the link below.
\r\n [unsubscribe_link]" ,
'report_email_subject' => "Forum Post Report",
'report_email_message' => "Report details:\r\n Reporter: [reporter],
\r\n Message: [message],
\r\n
\r\n [post_url]",
'update' => '1'
);
wpforo_update_options( 'wpforo_subscribe_options', $subscriptions_options );
#################################################################
// Countries ////////////////////////////////////////////////////
$countries = array( "Afghanistan","Åland Islands","Albania","Algeria","American Samoa","Andorra","Angola","Anguilla","Antarctica",
"Antigua and Barbuda","Argentina","Armenia","Aruba","Australia","Austria","Azerbaijan","Bahamas","Bahrain",
"Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bermuda","Bhutan","Bolivia","Bosnia and Herzegovina",
"Botswana","Bouvet Island","Brazil","British Indian Ocean Territory","Brunei Darussalam","Bulgaria","Burkina Faso",
"Burundi","Cambodia","Cameroon","Canada","Cape Verde","Cayman Islands","Central African Republic","Chad","Chile",
"China","Christmas Island","Cocos (Keeling) Islands","Colombia","Comoros","Congo","Congo, The Democratic Republic of The",
"Cook Islands","Costa Rica","Cote D'ivoire","Croatia","Cuba","Cyprus","Czech Republic","Denmark","Djibouti","Dominica",
"Dominican Republic","Ecuador","Egypt","El Salvador","Equatorial Guinea","Eritrea","Estonia","Ethiopia","Falkland Islands (Malvinas)",
"Faroe Islands","Fiji","Finland","France","French Guiana","French Polynesia","French Southern Territories","Gabon",
"Gambia","Georgia","Germany","Ghana","Gibraltar","Greece","Greenland","Grenada","Guadeloupe","Guam","Guatemala",
"Guernsey","Guinea","Guinea-bissau","Guyana","Haiti","Heard Island and Mcdonald Islands","Holy See (Vatican City State)",
"Honduras","Hong Kong","Hungary","Iceland","India","Indonesia","Iran, Islamic Republic of","Iraq","Ireland",
"Isle of Man","Israel","Italy","Jamaica","Japan","Jersey","Jordan","Kazakhstan","Kenya","Kiribati","Korea, Democratic People's Republic of",
"Korea, Republic of","Kuwait","Kyrgyzstan","Lao People's Democratic Republic","Latvia","Lebanon","Lesotho","Liberia",
"Libyan Arab Jamahiriya","Liechtenstein","Lithuania","Luxembourg","Macao","Macedonia, The Former Yugoslav Republic of",
"Madagascar","Malawi","Malaysia","Maldives","Mali","Malta","Marshall Islands","Martinique","Mauritania","Mauritius",
"Mayotte","Mexico","Micronesia, Federated States of","Moldova, Republic of","Monaco","Mongolia","Montenegro","Montserrat",
"Morocco","Mozambique","Myanmar","Namibia","Nauru","Nepal","Netherlands","Netherlands Antilles","New Caledonia",
"New Zealand","Nicaragua","Niger","Nigeria","Niue","Norfolk Island","Northern Mariana Islands","Norway","Oman",
"Pakistan","Palau","Palestinian Territory, Occupied","Panama","Papua New Guinea","Paraguay","Peru","Philippines",
"Pitcairn","Poland","Portugal","Puerto Rico","Qatar","Reunion","Romania","Russian Federation","Rwanda","Saint Helena",
"Saint Kitts and Nevis","Saint Lucia","Saint Pierre and Miquelon","Saint Vincent and The Grenadines","Samoa",
"San Marino","Sao Tome and Principe","Saudi Arabia","Senegal","Serbia","Seychelles","Sierra Leone","Singapore",
"Slovakia","Slovenia","Solomon Islands","Somalia","South Africa","South Georgia and The South Sandwich Islands",
"Spain","Sri Lanka","Sudan","Suriname","Svalbard and Jan Mayen","Swaziland","Sweden","Switzerland","Syrian Arab Republic",
"Taiwan, Province of China","Tajikistan","Tanzania, United Republic of","Thailand","Timor-leste","Togo","Tokelau",
"Tonga","Trinidad and Tobago","Tunisia","Turkey","Turkmenistan","Turks and Caicos Islands","Tuvalu","Uganda","Ukraine",
"United Arab Emirates","United Kingdom","United States","United States Minor Outlying Islands","Uruguay","Uzbekistan",
"Vanuatu","Venezuela","Viet Nam","Virgin Islands, British","Virgin Islands, U.S.","Wallis and Futuna","Western Sahara",
"Yemen","Zambia","Zimbabwe" );
add_option( 'wpforo_countries', $countries );
#################################################################
// Forum Navigation and Menu ////////////////////////////////////
$menu_name = wpforo_phrase('wpForo Navigation', false, 'orig');
$menu_location = 'wpforo-menu';
$menu_exists = wp_get_nav_menu_object( $menu_name );
if(!$menu_exists){
$id = array();
$menu_id = wp_create_nav_menu($menu_name);
$id['wpforo-home'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Forums', false),
'menu-item-classes' => 'wpforo-home',
'menu-item-url' => '/%wpforo-home%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
$id['wpforo-members'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Members', false),
'menu-item-classes' => 'wpforo-members',
'menu-item-url' => '/%wpforo-members%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
$id['wpforo-profile'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('My Profile', false),
'menu-item-classes' => 'wpforo-profile',
'menu-item-url' => '/%wpforo-profile-home%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
if(isset($id['wpforo-profile']) && $id['wpforo-profile']){
$id['wpforo-profile-account'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Account', false),
'menu-item-classes' => 'wpforo-profile-account',
'menu-item-url' => '/%wpforo-profile-account%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => $id['wpforo-profile'],
'menu-item-position' => 1)
);
$id['wpforo-profile-activity'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Activity', false),
'menu-item-classes' => 'wpforo-profile-activity',
'menu-item-url' => '/%wpforo-profile-activity%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => $id['wpforo-profile'],
'menu-item-position' => 1)
);
$id['wpforo-profile-subscriptions'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Subscriptions', false),
'menu-item-classes' => 'wpforo-profile-subscriptions',
'menu-item-url' => '/%wpforo-profile-subscriptions%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => $id['wpforo-profile'],
'menu-item-position' => 2)
);
}
$id['wpforo-register'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Register', false),
'menu-item-classes' => 'wpforo-register',
'menu-item-url' => '/%wpforo-register%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
$id['wpforo-login'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Login', false),
'menu-item-classes' => 'wpforo-login',
'menu-item-url' => '/%wpforo-login%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
$id['wpforo-logout'] = wp_update_nav_menu_item($menu_id, 0, array(
'menu-item-title' => wpforo_phrase('Logout', false),
'menu-item-classes' => 'wpforo-logout',
'menu-item-url' => '/%wpforo-logout%/',
'menu-item-status' => 'publish',
'menu-item-parent-id' => 0,
'menu-item-position' => 0));
if( !has_nav_menu( $menu_location ) ){
$locations = get_theme_mod('nav_menu_locations');
if(empty($locations)) $locations = array();
$locations[$menu_location] = $menu_id;
set_theme_mod( 'nav_menu_locations', $locations );
}
}
#################################################################
// Forum Access Array ///////////////////////////////////////////
$forum_cans = array (
'vf' => 'Can view forum',
'ct' => 'Can create topic',
'vt' => 'Can view topic',
'et' => 'Can edit topic',
'dt' => 'Can delete topic',
'cr' => 'Can post reply',
'vr' => 'Can view replies',
'er' => 'Can edit replies',
'dr' => 'Can delete replies',
'eot' => 'Can edit own topic',
'eor' => 'Can edit own replay',
'dot' => 'Can delete own topic',
'dor' => 'Can delete own replay',
'l' => 'Can like',
'r' => 'Can report',
's' => 'Can make topic sticky',
'sv' => 'Can make topic solved',
'osv' => 'Can make own topic solved',
'v' => 'Can vote',
'a' => 'Can Attach File',
'at' => 'Can make topic answered',
'oat' => 'Can make own topic answered',
'cot' => 'Can close topic',
'mt' => 'Can move topic'
);
wpforo_update_options( 'wpforo_forum_cans', $forum_cans);
#################################################################
// Access Sets //////////////////////////////////////////////////
$cans_n = array('vf' => 0, 'ct' => 0, 'vt' => 0, 'et' => 0, 'dt' => 0,
'cr' => 0, 'vr' => 0, 'er' => 0, 'dr' => 0,
'eot' => 0, 'eor' => 0, 'dot' => 0, 'dor' => 0,
'l' => 0, 'r' => 0, 's' => 0, 'sv' => 0, 'osv' => 0, 'v' => 0, 'a' => 0,
'at' => 0, 'oat' => 0, 'cot' => 0, 'mt' => 0);
$cans_r = array('vf' => 1, 'ct' => 0, 'vt' => 1, 'et' => 0, 'dt' => 0,
'cr' => 0, 'vr' => 1, 'er' => 0, 'dr' => 0,
'eot' => 0, 'eor' => 0, 'dot' => 0, 'dor' => 0,
'l' => 0, 'r' => 0, 's' => 0, 'sv' => 0, 'osv' => 0, 'v' => 0, 'a' => 0,
'at' => 0, 'oat' => 0, 'cot' => 0, 'mt' => 0);
$cans_s = array('vf' => 1, 'ct' => 1, 'vt' => 1, 'et' => 0, 'dt' => 0,
'cr' => 1, 'vr' => 1, 'er' => 0, 'dr' => 0,
'eot' => 1, 'eor' => 1, 'dot' => 1, 'dor' => 1,
'l' => 1, 'r' => 1, 's' => 0, 'sv' => 0, 'osv' => 1, 'v' => 1, 'a' => 1,
'at' => 0, 'oat' => 1, 'cot' => 0, 'mt' => 0);
$cans_m = array('vf' => 1, 'ct' => 1, 'vt' => 1, 'et' => 1, 'dt' => 1,
'cr' => 1, 'vr' => 1, 'er' => 1, 'dr' => 1,
'eot' => 1, 'eor' => 1, 'dot' => 1, 'dor' => 1,
'l' => 1, 'r' => 1, 's' => 1, 'sv' => 1, 'osv' => 1, 'v' => 1, 'a' => 1,
'at' => 1, 'oat' => 1, 'cot' => 1, 'mt' => 1);
$cans_a = array('vf' => 1, 'ct' => 1, 'vt' => 1, 'et' => 1, 'dt' => 1,
'cr' => 1, 'vr' => 1, 'er' => 1, 'dr' => 1,
'eot' => 1, 'eor' => 1, 'dot' => 1, 'dor' => 1,
'l' => 1, 'r' => 1, 's' => 1, 'sv' => 1, 'osv' => 1, 'v' => 1, 'a' => 1,
'at' => 1, 'oat' => 1, 'cot' => 1, 'mt' => 1);
$sql = "SELECT * FROM `".$wpforo->db->prefix."wpforo_accesses`";
$accesses = $wpforo->db->get_results($sql, ARRAY_A);
if( empty($accesses) ){
$cans_n = serialize($cans_n);
$cans_r = serialize($cans_r);
$cans_s = serialize($cans_s);
$cans_m = serialize($cans_m);
$cans_a = serialize($cans_a);
$sql = "INSERT IGNORE INTO `".$wpforo->db->prefix."wpforo_accesses`
(`access`, `title`, cans) VALUES
('no_access', 'No access', '". $cans_n ."'),
('read_only', 'Read only access', '". $cans_r ."'),
('standard', 'Standard access', '". $cans_s ."'),
('moderator', 'Moderator access', '".$cans_m."'),
('full', 'Full access', '".$cans_a."')";
$wpforo->db->query( $sql );
}
else{
foreach($accesses as $access){
$default = array();
$data_update = array();
$current = unserialize($access['cans']);
if( strtolower($access['access']) == 'no_access' ) $default = $cans_n;
elseif( strtolower($access['access']) == 'read_only' ) $default = $cans_r;
elseif( strtolower($access['access']) == 'standard' ) $default = $cans_s;
elseif( strtolower($access['access']) == 'moderator' ) $default = $cans_m;
elseif( strtolower($access['access']) == 'full' ) $default = $cans_a;
if( !empty($default) ){
$data_update = array_merge($default, $current);
if( !empty($data_update) ){
$data_update = serialize($data_update);
$wpforo->db->query("UPDATE `".$wpforo->db->prefix."wpforo_accesses` SET `cans` = '" . $wpforo->db->_real_escape($data_update) . "' WHERE `accessid` = " . intval($access['accessid']) );
}
}
}
}
#################################################################
// Usergroup Cans ///////////////////////////////////////////////
$usergroup_cans = array (
'cf' => 'Dahsboard - Can create forum',
'ef' => 'Dahsboard - Can edit forum',
'df' => 'Dahsboard - Can delete forum',
'vm' => 'Dahsboard - Members Menu',
'em' => 'Dahsboard - Can edit member',
'dm' => 'Dahsboard - Can delete member',
'vmg' => 'Dahsboard - Usergroup Menu',
'vmem' => 'Front - Can view members',
'vprf' => 'Front - Can view profiles',
'upa' => 'Front - Can upload avatar',
'ups' => 'Front - Can have signatur',
'va' => 'Front - Can view avatars',
'vmu' => 'Front - Can view member username',
'vmm' => 'Front - Can view member email',
'vmt' => 'Front - Can view member title',
'vmct' => 'Front - Can view member custom title',
'vmr' => 'Front - Can view member reputation',
'vmw' => 'Front - Can view member website',
'vmsn' => 'Front - Can view member social networks',
'vmrd' => 'Front - Can view member reg. date',
'vmlad'=> 'Front - Can view member last active date',
'vip' => 'Front - Can view member ip address',
'vml' => 'Front - Can view member location',
'vmo' => 'Front - Can view member ocumpation',
'vms' => 'Front - Can view member signatur',
'vmam' => 'Front - Can view member about me',
'vmpn' => 'Front - Can view member phone number',
'vwpm' => 'Front - Can write PM'
);
wpforo_update_options( 'wpforo_usergroup_cans', $usergroup_cans );
#################################################################
// Usergroup ////////////////////////////////////////////////////
$cans_admin = array('cf' => '1', 'ef' => '1', 'df' => '1', 'vm' => '1', 'em' => '1', 'vmg' => '1', 'vmem' => '1', 'vprf' => '1',
'dm' => '1', 'upa' => '1', 'ups' => '1', 'va' => '1',
'vmu' => '1', 'vmm' => '1', 'vmt' => '1', 'vmct' => '1',
'vmr' => '1', 'vmw' => '1', 'vmsn' => '1', 'vmrd' => '1',
'vmlad' => '1', 'vip' => '1', 'vml' => '1', 'vmo' => '1',
'vms' => '1', 'vmam' => '1', 'vmpn' => '1', 'vwpm' => '1');
$cans_moder = array('cf' => '0', 'ef' => '0', 'df' => '0', 'vm' => '0', 'em' => '0', 'vmg' => '0', 'vmem' => '1', 'vprf' => '1',
'dm' => '1', 'upa' => '1', 'ups' => '1', 'va' => '1',
'vmu' => '1', 'vmm' => '1', 'vmt' => '1', 'vmct' => '1',
'vmr' => '1', 'vmw' => '1', 'vmsn' => '1', 'vmrd' => '1',
'vmlad' => '1', 'vip' => '1', 'vml' => '1', 'vmo' => '1',
'vms' => '1', 'vmam' => '1', 'vmpn' => '1', 'vwpm' => '1');
$cans_reg = array( 'cf' => '0', 'ef' => '0', 'df' => '0', 'vm' => '0', 'em' => '0', 'vmg' => '0', 'vmem' => '1', 'vprf' => '1',
'dm' => '0', 'upa' => '1', 'ups' => '1', 'va' => '1',
'vmu' => '1', 'vmm' => '0', 'vmt' => '1', 'vmct' => '1',
'vmr' => '1', 'vmw' => '1', 'vmsn' => '1', 'vmrd' => '1',
'vmlad' => '1', 'vip' => '0', 'vml' => '1', 'vmo' => '1',
'vms' => '1', 'vmam' => '1', 'vmpn' => '0', 'vwpm' => '1');
$cans_guest = array('cf' => '0', 'ef' => '0', 'df' => '0', 'vm' => '0', 'em' => '0', 'vmg' => '0', 'vmem' => '1', 'vprf' => '1',
'dm' => '0', 'upa' => '0', 'ups' => '0', 'va' => '0',
'vmu' => '0', 'vmm' => '0', 'vmt' => '0', 'vmct' => '0',
'vmr' => '1', 'vmw' => '0', 'vmsn' => '1', 'vmrd' => '0',
'vmlad' => '1', 'vip' => '0', 'vml' => '1', 'vmo' => '1',
'vms' => '0', 'vmam' => '1', 'vmpn' => '0', 'vwpm' => '0');
$cans_customer = array( 'cf' => '0', 'ef' => '0', 'df' => '0', 'vm' => '0', 'em' => '0', 'vmg' => '0', 'vmem' => '1', 'vprf' => '1',
'dm' => '0', 'upa' => '1', 'ups' => '1', 'va' => '1',
'vmu' => '1', 'vmm' => '0', 'vmt' => '1', 'vmct' => '1',
'vmr' => '1', 'vmw' => '1', 'vmsn' => '1', 'vmrd' => '1',
'vmlad' => '1', 'vip' => '0', 'vml' => '1', 'vmo' => '1',
'vms' => '1', 'vmam' => '1', 'vmpn' => '0', 'vwpm' => '1');
$sql = "SELECT * FROM `".$wpforo->db->prefix."wpforo_usergroups`";
$usergroups = $wpforo->db->get_results($sql, ARRAY_A);
if( empty($usergroups) ){
$cans_admin = serialize( $cans_admin );
$cans_moder = serialize( $cans_moder );
$cans_reg = serialize( $cans_reg );
$cans_guest = serialize( $cans_guest );
$cans_customer = serialize( $cans_customer );
$sql = "INSERT IGNORE INTO `".$wpforo->db->prefix."wpforo_usergroups`
(`name`, `cans`) VALUES ('Admin', '$cans_admin'),('Moderator', '$cans_moder'),('Registered', '$cans_reg'),('Guest', '$cans_guest'),('Customer', '$cans_customer')";
$wpforo->db->query($sql);
}
else{
foreach($usergroups as $usergroup){
$default = array();
$data_update = array();
$current = unserialize($usergroup['cans']);
if( strtolower($usergroup['name']) == 'admin' ) $default = $cans_admin;
elseif( strtolower($usergroup['name']) == 'moderator' ) $default = $cans_moder;
elseif( strtolower($usergroup['name']) == 'registered' ) $default = $cans_reg;
elseif( strtolower($usergroup['name']) == 'guest' ) $default = $cans_guest;
elseif( strtolower($usergroup['name']) == 'customer' ) $default = $cans_customer;
if( !empty($default) ){
$data_update = array_merge($default, $current);
if( !empty($data_update) ){
$data_update = serialize($data_update);
$wpforo->db->query("UPDATE `".$wpforo->db->prefix."wpforo_usergroups` SET `cans` = '" . $wpforo->db->_real_escape($data_update) . "' WHERE `groupid` = " . intval($usergroup['groupid']) );
}
}
}
}
$sql = "SELECT COUNT(*) FROM `".$wpforo->db->prefix."wpforo_forums`";
$count = $wpforo->db->get_var($sql);
if(!$count){
if( $parentid = $wpforo->forum->add( array( 'title' => 'Main Category', 'description' => 'This is a simple category / section' ), FALSE ) ){
$wpforo->forum->add( array( 'title' => 'Main Forum', 'description' => 'This is a simple parent forum', 'parentid' => $parentid ), FALSE );
}
}
#################################################################
// Permalink Settings ///////////////////////////////////////////
$permalink_structure = get_option( 'permalink_structure' );
if( !$permalink_structure ){
global $wp_rewrite;
$wp_rewrite->set_permalink_structure( '/%postname%/' );
}
#################################################################
// Creating Forum Page //////////////////////////////////////////
if( !$wpforo->pageid ){
if( !$page_id = $wpforo->db->get_var("SELECT `ID` FROM `{$wpforo->db->prefix}posts` WHERE `post_content` LIKE '%[wpforo%' AND `post_status` LIKE 'publish' AND `post_type` IN('post', 'page')") ){
$wpforo_page = array(
'post_date' => current_time( 'mysql', 1 ),
'post_date_gmt' => current_time( 'mysql', 1 ),
'post_content' => '[wpforo]',
'post_title' => 'Forum',
'post_status' => 'publish',
'comment_status' => 'close',
'ping_status' => 'close',
'post_name' => 'community',
'post_modified' => current_time( 'mysql', 1 ),
'post_modified_gmt' => current_time( 'mysql', 1 ),
'post_parent' => 0,
'menu_order' => 0,
'post_type' => 'page'
);
$page_id = wp_insert_post( $wpforo_page );
}
if( $page_id && !is_wp_error($page_id) ){
update_option( 'wpforo_pageid', $page_id );
update_option( 'wpforo_use_home_url', '0' );
update_option( 'wpforo_permastruct', 'community' );
update_option( 'wpforo_url', site_url('/') . "community/" );
}
}else{
if( !$wpforo->use_home_url ) update_option( 'wpforo_use_home_url', '0' );
if( !$wpforo->permastruct ) update_option( 'wpforo_permastruct', basename( get_wpf_option('wpforo_url') ) );
$wpforo->db->query("UPDATE `{$wpforo->db->prefix}posts` SET `post_content` = REPLACE(`post_content`, '[wpforo-index]', '[wpforo]') WHERE `ID` = '{$wpforo->pageid}'");
}
#################################################################
// Importing Language Packs and Phrases /////////////////////////
$wpforo->phrase->xml_import('english.xml', 'install');
#################################################################
// Creating wpforo folders //////////////////////////////////////
$upload_array = wp_upload_dir();
$wpforo_upload_dir = $upload_array['basedir'].'/wpforo/';
if (!is_dir($wpforo_upload_dir)) {
wp_mkdir_p($wpforo_upload_dir);
}
$avatars_upload_dir=$upload_array['basedir'].'/wpforo/avatars/';
if (!is_dir($avatars_upload_dir)) {
wp_mkdir_p($avatars_upload_dir);
}
#################################################################
// RESET USER CACHE /////////////////////////////////////////////
$wpforo->member->clear_db_cache();
#################################################################
// RESET FUNCTIONS //////////////////////////////////////////////
$wpforo->db->query("DELETE FROM " . $wpforo->db->prefix . "options WHERE `option_name` LIKE '%_transient_wpforo_get_phrases_%' OR `option_name` LIKE '%_transient_timeout_wpforo_get_phrases_%'");
#################################################################
// UPDATE VERSION - END /////////////////////////////////////////
update_option('wpforo_version', WPFORO_VERSION);
$wpforo->notice->clear();
}
function wpforo_update() {
if ( WPFORO_VERSION !== get_option('wpforo_version') ) wpforo_activation();
}
add_action('plugins_loaded', 'wpforo_update');
function wpforo_update_options( $option_key, $default ) {
$option = get_option( $option_key, array() );
if( !empty($option) ){
$option_update = array_merge($default, $option);
}
else{
$option_update = $default;
}
update_option( $option_key, $option_update );
}
function wpforo_deactivation() {}
function wpforo_uninstall() {
global $wpforo, $wpdb;
if( ! is_admin() ) return;
if( ! current_user_can( 'activate_plugins' ) ) return;
$QUERY_STRING = trim(preg_replace('|_wpnonce=[^\&\?\=]*|is', '', $_SERVER['QUERY_STRING']), '&');
if( 'action=wpforo-uninstall' == trim($QUERY_STRING) ){
$tables = array( $wpdb->prefix . 'wpforo_accesses',
$wpdb->prefix . 'wpforo_forums',
$wpdb->prefix . 'wpforo_languages',
$wpdb->prefix . 'wpforo_likes',
$wpdb->prefix . 'wpforo_phrases',
$wpdb->prefix . 'wpforo_profiles',
$wpdb->prefix . 'wpforo_posts',
$wpdb->prefix . 'wpforo_subscribes',
$wpdb->prefix . 'wpforo_topics',
$wpdb->prefix . 'wpforo_usergroups',
$wpdb->prefix . 'wpforo_views',
$wpdb->prefix . 'wpforo_votes');
foreach($tables as $table){
if( strpos( $table, '_wpforo_' ) !== FALSE){
$sql = "DROP TABLE IF EXISTS `$table`;";
$wpdb->query( $sql );
}
}
if( isset($wpforo->pageid) && $wpforo->pageid ){
wp_delete_post( $wpforo->pageid, true );
}
$options = array( 'wpforo_version',
'wpforo_url',
'wpforo_general_options',
'wpforo_pageid',
'wpforo_count_per_page',
'wpforo_default_groupid',
'wpforo_usergroup_cans',
'wpforo_forum_options',
'wpforo_forum_cans',
'wpforo_post_options',
'wpforo_member_options',
'wpforo_subscribe_options',
'wpforo_countries',
'wpforo_theme_options',
'wpforo_features',
'wpforo_plugins_status',);
foreach($options as $option){
if( strpos( $option, 'wpforo_' ) !== FALSE){
delete_option( $option );
}
}
$wpdb->query( "DELETE FROM `" . $wpdb->prefix ."usermeta` WHERE `meta_key` = '_wpf_member_obj'" );
$wpdb->query( "DELETE FROM `" . $wpdb->prefix ."options` WHERE option_name LIKE 'widget_wpforo_widget_%'" );
$menu = wp_get_nav_menu_object( 'wpforo-navigation' );
wp_delete_nav_menu( $menu->term_id );
wp_delete_post($wpforo->pageid, TRUE);
deactivate_plugins( WPFORO_BASENAME );
}
else{
return;
}
}
?>
```