query( "DELETE $wpdb->posts, $wpdb->postmeta FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ({$wpdb->posts}.ID = {$wpdb->postmeta}.post_id) WHERE {$wpdb->posts}.post_type IN ('fep_message', 'fep_announcement')" );
update_option( '_fep_can_delete_all', 0 );
wp_safe_redirect( admin_url() );
exit;
}
function install() {
if ( false !== fep_get_option( 'plugin_version', false ) ) {
return;
}
global $wpdb;
$roles = array_keys( get_editable_roles() );
$id = $wpdb->get_var( "SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE '%[front-end-pm%' AND post_status = 'publish' AND post_type = 'page' LIMIT 1" );
$options = array();
$options['userrole_access'] = $roles;
$options['userrole_new_message'] = $roles;
$options['userrole_reply'] = $roles;
$options['plugin_version'] = get_option( 'FEP_admin_options' ) ? '4.0' : FEP_PLUGIN_VERSION;
$options['page_id'] = $id;
fep_update_option( $options );
//fep_add_caps_to_roles();
$this->create_htaccess();
}
function update( $prev_ver ) {
global $wpdb;
if ( version_compare( $prev_ver, '5.3', '<' ) ) {
$this->create_htaccess();
}
if ( version_compare( $prev_ver, '6.1', '<' ) ) {
$options = array();
$options['show_directory'] = fep_get_option( 'hide_directory', 0 ) ? 0 : 1;
$options['show_notification'] = fep_get_option( 'hide_notification', 0 ) ? 0 : 1;
$options['show_branding'] = fep_get_option( 'hide_branding', 0 ) ? 0 : 1;
$options['show_autosuggest'] = fep_get_option( 'hide_autosuggest', 0 ) ? 0 : 1;
fep_update_option( $options );
}
if ( version_compare( $prev_ver, '11.1.1', '<' ) ) {
$wpdb->query( "DELETE mm FROM $wpdb->fep_messagemeta mm LEFT JOIN $wpdb->fep_messages m ON mm.fep_message_id = m.mgs_id WHERE m.mgs_id IS NULL" );
}
if ( version_compare( $prev_ver, '11.2.1', '<' ) ) {
// Drop the old index. dbDelta() doesn't do the drop.
$wpdb->query( "ALTER TABLE $wpdb->fep_messages DROP INDEX mgs_parent" );
$wpdb->query( "ALTER TABLE $wpdb->fep_messages DROP INDEX mgs_author" );
$wpdb->query( "ALTER TABLE $wpdb->fep_messages DROP INDEX mgs_created" );
$wpdb->query( "ALTER TABLE $wpdb->fep_messages DROP INDEX type_status" );
$wpdb->query( "ALTER TABLE $wpdb->fep_messages DROP INDEX mgs_last_reply_time" );
$wpdb->query( "ALTER TABLE " . FEP_PARTICIPANT_TABLE . " DROP INDEX mgs_parent_read" );
$wpdb->query( "ALTER TABLE " . FEP_PARTICIPANT_TABLE . " DROP INDEX mgs_deleted" );
$wpdb->query( "ALTER TABLE " . FEP_PARTICIPANT_TABLE . " DROP INDEX mgs_archived" );
$wpdb->query( "ALTER TABLE " . FEP_ATTACHMENT_TABLE . " DROP INDEX att_status" );
}
}
function message_view_changed() {
if ( get_option( '_fep_message_view_changed' ) ) {
add_filter( 'fep_update_enable_version_check', '__return_false' );
add_filter( 'fep_require_manual_update', '__return_true' );
add_action( 'fep_plugin_manual_update', array( $this, 'individual_to_threaded' ) );
}
}
function auto_update() {
if ( defined( 'DOING_AJAX' ) && DOING_AJAX ) {
return;
}
if ( isset( $_GET['page'] ) && 'fep_update' == $_GET['page'] ) {
return;
}
$prev_ver = fep_get_option( 'plugin_version', '3.3' );
if ( version_compare( $prev_ver, FEP_PLUGIN_VERSION, '=' ) && apply_filters( 'fep_update_enable_version_check', true ) ) {
return;
}
$require = false;
if ( version_compare( $prev_ver, '10.1.1', '<' ) ) {
$require = true;
}
if ( apply_filters( 'fep_require_manual_update', $require, $prev_ver ) ) {
add_action( 'admin_notices', array( $this, 'notice_update' ) );
} else {
do_action( 'fep_plugin_auto_update', $prev_ver );
do_action( 'fep_plugin_update', $prev_ver );
fep_update_option( 'plugin_version', FEP_PLUGIN_VERSION );
}
}
public function notice_update() {
if ( ! current_user_can( 'manage_options' ) ) {
return;
}
if ( isset( $_GET['page'] ) && 'fep_update' == $_GET['page'] ) {
return;
}
?>
'completed',
'message' => __( 'You do not have permission to trigger update.', 'front-end-pm' ),
);
wp_send_json( $response );
}
$prev_ver = fep_get_option( 'plugin_version', '3.3' );
if ( version_compare( $prev_ver, '4.1', '<' ) ) {
//$this->update_version_41();
$response = array(
'update' => 'completed',
'message' => __( 'You cannot update from your current version.', 'front-end-pm' ),
);
wp_send_json( $response );
}
ignore_user_abort( true );
if ( ! fep_is_func_disabled( 'set_time_limit' ) ) {
set_time_limit( 3600 );
}
if ( version_compare( $prev_ver, '5.1', '<' ) ) {
$this->update_version_51();
}
if ( version_compare( $prev_ver, '10.1.1', '<' ) ) {
$this->update_version_1011();
}
do_action( 'fep_plugin_manual_update', $prev_ver );
do_action( 'fep_plugin_update', $prev_ver );
fep_update_option( 'plugin_version', FEP_PLUGIN_VERSION );
$response = array(
'update' => 'completed',
'message' => __( 'Update completed.', 'front-end-pm' ),
);
wp_send_json( $response );
}
function update_version_51() {
$updated = fep_get_option( 'v51', 0, 'fep_updated_versions' );
if ( $updated ) {
return;
}
$custom_int = isset( $_POST['custom_int'] ) ? absint( $_POST['custom_int'] ) : 0;
global $wpdb;
$wpdb->query( "UPDATE $wpdb->postmeta SET meta_key = REPLACE( meta_key, '_message_key', '_fep_message_key' ) WHERE meta_key = '_message_key'" );
$wpdb->query( "UPDATE $wpdb->postmeta SET meta_key = REPLACE( meta_key, '_participant_roles', '_fep_participant_roles' ) WHERE meta_key = '_participant_roles'" );
$wpdb->query( "UPDATE $wpdb->postmeta SET meta_key = REPLACE( meta_key, '_participants', '_fep_participants' ) WHERE meta_key = '_participants'" );
fep_update_option( 'v51', 1, 'fep_updated_versions' );
$response = array(
'update' => 'continue',
'message' => __( 'Messages meta updated', 'front-end-pm' ),
'custom_int'=> 0,
'custom_str'=> '',
);
wp_send_json( $response );
}
function update_version_1011() {
global $wpdb;
$updated = fep_get_option( 'v1011', 0, 'fep_updated_versions' );
if ( $updated ) {
return;
}
$custom_int = isset( $_POST['custom_int'] ) ? absint( $_POST['custom_int'] ) : 0;
$custom_str = isset( $_POST['custom_str'] ) ? sanitize_text_field( $_POST['custom_str']) : 'messages';
if ( 'announcements' == $custom_str ) {
$args = array(
'post_type' => 'fep_announcement',
'posts_per_page'=> 50,
'post_status' => 'any',
'meta_query' => array(
array(
'key' => '_fep_new_id',
'compare' => 'NOT EXISTS',
),
),
);
$announcements = get_posts( $args );
if ( $announcements ) {
foreach ( $announcements as $announcement ) {
$this->insert_announcement( $announcement );
}
$custom_int = $custom_int + count( $announcements );
$response = array(
'update' => 'continue',
'message' => sprintf( _n( '%s announcement updated', '%s announcements updated', $custom_int, 'front-end-pm' ), number_format_i18n( $custom_int ) ),
'custom_int'=> $custom_int,
'custom_str'=> $custom_str,
);
wp_send_json( $response );
}
} else {
$args = array(
'post_type' => 'fep_message',
'posts_per_page'=> 25,
'post_status' => 'any',
'post_parent' => 0,
'meta_query' => array(
array(
'key' => '_fep_new_id',
'compare' => 'NOT EXISTS',
),
),
);
$messages = get_posts( $args );
if ( $messages ) {
foreach ( $messages as $message ) {
$custom_int += $this->insert_message( $message );
}
//$custom_int = $custom_int + count( $messages );
$response = array(
'update' => 'continue',
'message' => sprintf( _n( '%s message updated', '%s messages updated', $custom_int, 'front-end-pm' ), number_format_i18n( $custom_int ) ),
'custom_int'=> $custom_int,
'custom_str'=> $custom_str,
);
wp_send_json( $response );
} else {
$response = array(
'update' => 'continue',
'message' => __( 'All messages updated', 'front-end-pm' ),
'custom_int'=> 0,
'custom_str'=> 'announcements',
);
wp_send_json( $response );
}
}
update_option( '_fep_can_delete_all', 1 );
// multisite add prefix_blogid_ to meta, so delete those as well.
$wpdb->query(
$wpdb->prepare( "DELETE FROM $wpdb->usermeta WHERE meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s",
'%' . $wpdb->esc_like( '_FEP_user_options' ), // Not delete main site meta which is without leading underscore.
'%' . $wpdb->esc_like( '_fep_user_message_count' ),
'%' . $wpdb->esc_like( '_fep_user_announcement_count' ),
'%' . $wpdb->esc_like( '_fep_notification_dismiss' )
)
);
$wp_roles = wp_roles();
$roles = $wp_roles->get_names();
$roles = array_keys( $roles );
$caps = array(
'delete_published_fep_messages' => 1,
'delete_private_fep_messages' => 1,
'delete_others_fep_messages' => 1,
'delete_fep_messages' => 1,
'publish_fep_messages' => 1,
'read_private_fep_messages' => 1,
'edit_private_fep_messages' => 1,
'edit_others_fep_messages' => 1,
'edit_fep_messages' => 1,
'edit_published_fep_messages' => 1,
'create_fep_messages' => 1,
'delete_published_fep_announcements'=> 1,
'delete_private_fep_announcements' => 1,
'delete_others_fep_announcements' => 1,
'delete_fep_announcements' => 1,
'publish_fep_announcements' => 1,
'read_private_fep_announcements' => 1,
'edit_private_fep_announcements' => 1,
'edit_others_fep_announcements' => 1,
'edit_fep_announcements' => 1,
'edit_published_fep_announcements' => 1,
'create_fep_announcements' => 1,
);
foreach( $roles as $role ) {
$role_obj = get_role( $role );
if ( ! $role_obj ) {
continue;
}
foreach( $caps as $cap => $val ) {
$role_obj->remove_cap( $cap );
}
}
fep_update_option( 'v1011', 1, 'fep_updated_versions' );
$response = array(
'update' => 'continue',
'message' => __( 'All messages and announcements updated', 'front-end-pm' ),
'custom_int'=> 0,
'custom_str'=> '',
);
wp_send_json( $response );
}
function individual_to_threaded() {
global $wpdb;
$custom_int = isset( $_POST['custom_int'] ) ? absint( $_POST['custom_int'] ) : 0;
$args = array(
'mgs_type' => 'message',
'mgs_parent' => 0,
'mgs_status' => 'publish',
'per_page' => 50,
'orderby' => 'mgs_created',
'mgs_last_reply_by' => 0,
'fields' => array( 'mgs_id' ),
);
$messages = fep_get_messages( $args );
if ( $messages ) {
foreach ( $messages as $mgs_id ) {
fep_update_reply_info( $mgs_id );
}
$custom_int = $custom_int + count( $messages );
$response = array(
'update' => 'continue',
'message' => sprintf( _n( '%s message meta updated', '%s messages meta updated', $custom_int, 'front-end-pm' ), number_format_i18n( $custom_int ) ),
'custom_int'=> $custom_int,
'custom_str'=> '',
);
wp_send_json( $response );
}
delete_metadata( 'user', 0, '_fep_user_message_count', '', true );
update_option( '_fep_message_view_changed', 0 );
}
function insert_announcement( $announcement ) {
$arr = array(
'mgs_id' => $announcement->ID,
'mgs_parent' => $announcement->post_parent,
'mgs_author' => $announcement->post_author,
'mgs_created' => $announcement->post_date_gmt,
'mgs_title' => $announcement->post_title,
'mgs_content' => $announcement->post_content,
'mgs_last_reply_excerpt'=> fep_get_the_excerpt_from_content( 100, $announcement->post_content ),
'mgs_type' => 'announcement',
'mgs_status' => $announcement->post_status,
);
$mgs_obj = new FEP_Message;
$ann_id = $mgs_obj->insert( $arr );
if( ! $ann_id ){
return;
}
add_post_meta( $announcement->ID, '_fep_new_id', $ann_id );
fep_add_meta( $ann_id, '_fep_email_sent', get_post_meta( $announcement->ID, '_fep_email_sent', true ) );
$roles = get_post_meta( $announcement->ID, '_fep_participant_roles' );
if ( $roles ) {
$user_ids = get_users( [ 'fields' => 'ids', 'role__in' => $roles ] );
$user_ids[] = $mgs_obj->mgs_author;
$user_ids = array_unique( $user_ids );
$new_participants = [];
$read_by = get_post_meta( $announcement->ID, '_fep_read_by', true );
if( ! is_array( $read_by ) ){
$read_by = [];
} else {
$read_by = array_flip( $read_by );
}
$deleted_by = get_post_meta( $announcement->ID, '_fep_deleted_by', true );
if ( ! is_array( $deleted_by ) ) {
$deleted_by = array();
}
foreach( $user_ids as $participant ){
$new_participants[] = [
'mgs_participant' => $participant,
'mgs_read' => isset( $read_by[ $participant ] ) ? $read_by[ $participant ] : 0,
'mgs_parent_read' => isset( $read_by[ $participant ] ) ? $read_by[ $participant ] : 0,
'mgs_deleted' => isset( $deleted_by[ $participant ] ) ? $deleted_by[ $participant ] : 0,
'mgs_archived' => 0,
];
}
if( $new_participants ){
$mgs_obj->insert_participants( $new_participants );
}
foreach( $roles as $role ){
fep_add_meta( $ann_id, '_fep_participant_roles', $role );
}
}
$this->insert_attachment( $announcement->ID, $mgs_obj );
$this->insert_meta( $announcement->ID, $ann_id );
}
function insert_message( $message ) {
$arr = array(
'mgs_id' => $message->ID,
'mgs_parent' => 0,
'mgs_author' => $message->post_author,
'mgs_created' => $message->post_date_gmt,
'mgs_title' => $message->post_title,
'mgs_content' => $message->post_content,
'mgs_type' => 'message',
'mgs_status' => $message->post_status,
);
if( 'threaded' == fep_get_message_view() ){
$arr['mgs_last_reply_by'] = get_post_meta( $message->ID, '_fep_last_reply_by', true );
$arr['mgs_last_reply_excerpt'] = fep_get_the_excerpt_from_content( 100, get_post_field('post_content', get_post_meta( $message->ID, '_fep_last_reply_id', true ) ) );
$arr['mgs_last_reply_time'] = get_post_field('post_date_gmt', get_post_meta( $message->ID, '_fep_last_reply_id', true ) );
}
$mgs_obj = new FEP_Message;
$message_id = $mgs_obj->insert( $arr );
if( ! $message_id ){
return 0;
}
$count = 1;
add_post_meta( $message->ID, '_fep_new_id', $message_id, true );
fep_add_meta( $message_id, '_fep_email_sent', get_post_meta( $message->ID, '_fep_email_sent', true ) );
$this->insert_participants( $message->ID, $mgs_obj );
$this->insert_attachment( $message->ID, $mgs_obj );
$this->insert_meta( $message->ID, $message_id );
$count += $this->insert_replies( $message->ID, $mgs_obj );
//$this->delete_message( $message->id );
return $count;
}
function insert_replies( $message_id, $mgs_obj ) {
$args = array(
'post_type' => 'fep_message',
'posts_per_page'=> -1,
'post_status' => 'any',
'post_parent' => $message_id,
);
if ( ! $replies = get_posts( $args ) ) {
return 0;
}
foreach ( $replies as $reply ) {
$arr = array(
'mgs_id' => $reply->ID,
'mgs_parent' => $mgs_obj->mgs_id,
'mgs_author' => $reply->post_author,
'mgs_created' => $reply->post_date_gmt,
'mgs_title' => $reply->post_title,
'mgs_content' => $reply->post_content,
'mgs_type' => 'message',
'mgs_status' => $reply->post_status,
);
$reply_obj = new FEP_Message;
$reply_id = $reply_obj->insert( $arr );
if ( $reply_id ) {
add_post_meta( $reply->ID, '_fep_new_id', $reply_id, true );
fep_add_meta( $reply_id, '_fep_email_sent', get_post_meta( $reply->ID, '_fep_email_sent', true ) );
$this->insert_participants( $reply->ID, $reply_obj );
$this->insert_attachment( $reply->ID, $reply_obj );
$this->insert_meta( $reply->ID, $reply_id );
}
}
return count( $replies );
}
function insert_attachment( $message_id, $mgs_obj ) {
$args = array(
'post_type' => 'attachment',
'posts_per_page'=> -1,
'post_status' => 'any',
'post_parent' => $message_id,
);
if ( ! $attachments = get_posts( $args ) ) {
return;
}
$new_attachments = [];
foreach ( $attachments as $attachment ) {
$new_attachments[] = [
'att_mime' => $attachment->post_mime_type,
'att_file' => get_attached_file( $attachment->ID ),
'att_status' => in_array( $attachment->post_status, [ 'publish', 'inherit' ] ) ? 'publish' : $attachment->post_status,
];
}
if( $new_attachments ){
$mgs_obj->insert_attachments( $new_attachments );
}
}
function insert_participants( $message_id, $mgs_obj ){
if( 'threaded' == fep_get_message_view() && $mgs_obj->mgs_parent ){
$participants = get_post_meta( wp_get_post_parent_id( $message_id ), '_fep_participants' );
} else {
$participants = get_post_meta( $message_id, '_fep_participants' );
}
$new_participants = [];
$read_by = get_post_meta( $message_id, '_fep_read_by', true );
if( ! is_array( $read_by ) ){
$read_by = [];
} else {
$read_by = array_flip( $read_by );
}
foreach( $participants as $participant ){
$args = [
'mgs_participant' => $participant,
'mgs_read' => isset( $read_by[ $participant ] ) ? $read_by[ $participant ] : 0,
'mgs_deleted' => get_post_meta( $message_id, '_fep_delete_by_' . $participant, true ),
'mgs_archived' => get_post_meta( $message_id, '_fep_archived_by_' . $participant, true ),
];
if( 'threaded' == fep_get_message_view() && $mgs_obj->mgs_parent ){
$args['mgs_parent_read'] = get_post_meta( wp_get_post_parent_id( $message_id ), '_fep_parent_read_by_' . $participant, true );
} else {
$args['mgs_parent_read'] = get_post_meta( $message_id, '_fep_parent_read_by_' . $participant, true );
}
$new_participants[] = $args;
}
if( $new_participants ){
$mgs_obj->insert_participants( $new_participants );
}
}
function insert_meta( $prev_id, $new_id ) {
if( ! $prev_id || ! is_numeric( $prev_id ) || ! $new_id || ! is_numeric( $new_id ) ) {
return false;
}
$meta = get_post_meta( $prev_id );
if ( ! $meta || ! is_array( $meta ) ) {
return false;
}
unset( $meta['_fep_read_by'], $meta['_fep_deleted_by'], $meta['_fep_participants'], $meta['_fep_participant_roles'], $meta['_fep_email_sent'], $meta['_fep_new_id'], $meta['_fep_last_reply_by'], $meta['_fep_last_reply_id'], $meta['_fep_last_reply_time'] );
foreach ( $meta as $meta_key => $meta_values ) {
if ( 0 === strpos( $meta_key, '_fep_parent_read_by_' ) || 0 === strpos( $meta_key, '_fep_delete_by_' ) || 0 === strpos( $meta_key, '_fep_archived_by_' ) ) {
continue;
}
foreach ( $meta_values as $meta_value ) {
fep_add_meta( $new_id, $meta_key, $meta_value );
}
}
}
function create_htaccess() {
add_filter( 'upload_dir', array( Fep_Attachment::init(), 'upload_dir' ), 99 );
$wp_upload_dir = wp_upload_dir();
remove_filter( 'upload_dir', array( Fep_Attachment::init(), 'upload_dir' ), 99 );
$upload_path = $wp_upload_dir['basedir'] . '/front-end-pm';
$htaccess_path = $upload_path . '/.htaccess';
// Make sure the /front-end-pm folder is created
wp_mkdir_p( $upload_path );
//.htaccess file content
$htaccess = "Options -Indexes\ndeny from all\n";
if ( ! file_exists( $htaccess_path ) && wp_is_writable( $upload_path ) ) {
// Create the file if it doesn't exist
@file_put_contents( $htaccess_path, $htaccess );
}
}
} //END CLASS
add_action( 'init', array( Fep_Update::init(), 'actions_filters' ) );
