XeroChat Updates [Upgrade from version 4.2.9 & 5.0 to version 5.0.2]

Admin

Administrator
Staff member
68747470733a2f2f7865726f6e6569742e6e65742f64656d6f2f7865726f636861745f656e7661746f5f696d616765...png
***Backup
Upload xerochat 4.9.2 to 5.0.2.zip root directory.
Unzip in root directory
Import sql-import.sql

Good luck!

Files
  • application/controllers/Addons.php
  • application/controllers/Admin.php
  • application/controllers/Messenger_bot.php
  • application/controllers/Paypal_ipn.php
  • application/controllers/Social_apps.php
  • application/libraries/Google_youtube/Utils.php
  • application/libraries/Razorpay_class_ecommerce.php
  • application/libraries/Stripe_class.php
  • application/views/admin/payment/accounts.php
  • application/views/admin/cron_job/command.php
  • application/views/admin/settings/general.php
  • application/views/facebook_rx/account_import.php
  • application/views/messenger_tools/add_new_template.php
  • application/views/messenger_tools/bot_settings.php
  • application/views/messenger_tools/edit_bot_settings.php
  • application/views/messenger_tools/edit_template.php
  • application/views/messenger_tools/menu_block.php
  • application/views/messenger_tools/persistent_menu.php
  • application/views/messenger_tools/persistent_menu_edit.php
  • application/views/sms_email_manager/email/email_templates/template.php
  • application/views/sms_email_manager/email/email_templates/template_lists.php
  • application/views/sms_email_manager/email/email_templates/sms_email_manager_js.php
  • application/views/sms_email_manager/email/email_templates/sms_email_manager_css.php
  • application/views/sms_email_manager/email/email_campaign/create_email_campaign.php
  • application/views/sms_email_manager/email/email_campaign/edit_email_campaigns.php
  • application/views/sms_email_manager/email/email_section_global_js.php
  • application/views/site/default/index.php
  • application/views/utility/menu_block.php
  • application/modules/ultrapost/views/poster_menu_block.php
  • assets
  • system/libraries/Form_validation.php
  • application/helpers/ecommerce_helper.php
  • assets/img/icon/single_tag.png
  • assets/pre-loader/loading-animations.gif
  • assets/images/video-thumbnail.jpg
  • plugins
  • upload_caster
  • application/views/include/js_include_back.php
  • application/libraries/Paypal_class.php
  • application/views/member/buy_package.php
  • application/controllers/Cron_job.php
  • application/controllers/Sms_email_manager.php
  • application/views/messenger_tools/bulk_message/menu_block.php
  • application/controllers/Stripe_action.php
  • application/controllers/Payment.php
  • application/libraries/Mollie_class_ecommerce.php
  • application/libraries/Paystack_class_ecommerce.php
  • application/libraries/Stripe_class_ecommerce.php
  • application/controllers/Social_accounts.php
  • application/libraries/Fb_rx_login.php
  • application/modules
  • application/controllers/Instagram_reply.php
  • application/views
  • application/libraries/Medium.php
  • application/views/admin/social_apps/settings.php
  • application/views/admin/social_apps/medium_app_settings.php
  • application/views/admin/social_apps/medium_settings.php
  • application/controllers/Home.php
  • application/modules/comboposter/views/social_account_list.php
  • application/modules/comboposter/views/posts/social_accounts/medium.php
  • application/modules/comboposter/views/posts/image.php
  • application/modules/comboposter/views/posts/universal_js.php
  • application/modules/comboposter/views/posts/forms/image_post_form.php
  • application/modules/comboposter/views/posts/html.php
  • application/modules/comboposter/views/posts/text.php
  • application/modules/comboposter/views/posts/forms/text_post_form.php
  • application/controllers/Subscriber_manager.php
  • application/views/messenger_tools/bot_subscribers.php
  • application/modules/comboposter
  • application/views
  • application/controllers/Ecommerce.php
  • application
  • application/views/admin/theme/sidebar.php
  • application/modules/menu_manager/controllers/Menu_manager.php


Sql
DELETE FROM `email_template_management` WHERE `email_template_management`.`template_type` = 'emcommerce_order_status_update';

ALTER TABLE `ecommerce_store` ADD `notification_sms_api_id` INT NOT NULL AFTER `configure_email_table`, ADD `notification_email_api_id` INT NOT NULL AFTER `notification_sms_api_id`, ADD `notification_email_subject` VARCHAR(255) NOT NULL AFTER `notification_email_api_id`, ADD `notification_configure_email_table` VARCHAR(255) NOT NULL AFTER `notification_email_subject`, ADD `notification_message` TEXT NOT NULL AFTER `notification_configure_email_table`;

ALTER TABLE `ecommerce_store` ADD `razorpay_enabled` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `stripe_enabled`, ADD `paystack_enabled` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `razorpay_enabled`, ADD `mollie_enabled` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `paystack_enabled`;

ALTER TABLE `ecommerce_store` ADD `store_locale` VARCHAR(50) NOT NULL AFTER `refund_policy_link`, ADD `pixel_id` VARCHAR(50) NOT NULL AFTER `store_locale`, ADD `google_id` VARCHAR(50) NOT NULL AFTER `pixel_id`;

ALTER TABLE `ecommerce_cart` ADD `last_sent_at` DATETIME NOT NULL AFTER `is_totally_completed`;

ALTER TABLE `ecommerce_config` ADD `paystack_secret_key` VARCHAR(255) NOT NULL AFTER `stripe_publishable_key`, ADD `paystack_public_key` VARCHAR(255) NOT NULL AFTER `paystack_secret_key`, ADD `razorpay_key_id` VARCHAR(255) NOT NULL AFTER `paystack_public_key`, ADD `razorpay_key_secret` VARCHAR(255) NOT NULL AFTER `razorpay_key_id`, ADD `mollie_api_key` VARCHAR(255) NOT NULL AFTER `razorpay_key_secret`;

ALTER TABLE `ecommerce_config` ADD `stripe_billing_address` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `paypal_mode`;

ALTER TABLE `ecommerce_cart` CHANGE `payment_method` `payment_method` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `payment_config` CHANGE `currency` `currency` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD';

ALTER TABLE `ecommerce_reminder_report` ADD INDEX(`cart_id`);

UPDATE `menu` SET `icon` = 'fab fa-facebook-square' WHERE `module_access` = '80,201,202,204,206,220,222,223,251,256';

INSERT INTO `modules` (`id`, `module_name`, `add_ons_id`, `extra_text`, `limit_enabled`, `bulk_limit_enabled`, `deleted`) VALUES ('279', 'Instagram Auto Comment Reply', '0', 'month', '1', '0', '0');

INSERT INTO `menu` (`id`, `name`, `icon`, `url`, `serial`, `module_access`, `have_child`, `only_admin`, `only_member`, `add_ons_id`, `is_external`, `header_text`, `is_menu_manager`, `custom_page_id`) VALUES (NULL, 'Comment Automation', 'fab fa-instagram', '', (SELECT serial FROM menu as menu2 WHERE module_access='80,201,202,204,206,220,222,223,251,256'), '278,279', '1', '0', '0', '0', '0', '', '0', '0');

INSERT INTO `menu_child_1` (`id`, `name`, `url`, `serial`, `icon`, `module_access`, `parent_id`, `have_child`, `only_admin`, `only_member`, `is_external`) VALUES (NULL, 'Automation Campaign', 'instagram_reply/get_account_lists', '1', 'fa fa-pen-alt', '278,279', (SELECT id FROM menu WHERE module_access='278,279'), '0', '0', '0', '0');

INSERT INTO `menu_child_1` (`id`, `name`, `url`, `serial`, `icon`, `module_access`, `parent_id`, `have_child`, `only_admin`, `only_member`, `is_external`) VALUES (NULL, 'Report', 'instagram_reply/reports', '1', 'fas fa-chart-pie', '278,279', (SELECT id FROM menu WHERE module_access='278,279'), '0', '0', '0', '0');

INSERT INTO `modules` (`id`, `module_name`, `add_ons_id`, `extra_text`, `limit_enabled`, `bulk_limit_enabled`, `deleted`) VALUES ('279', 'Instagram Auto Comment Reply', '0', 'month', '1', '0', '0');

ALTER TABLE `facebook_rx_fb_page_info` ADD `has_instagram` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `sequence_email_campaign_id`, ADD `instagram_business_account_id` VARCHAR(100) NOT NULL AFTER `has_instagram`, ADD `insta_username` VARCHAR(200) NOT NULL AFTER `instagram_business_account_id`, ADD `insta_followers_count` INT(11) NOT NULL AFTER `insta_username`, ADD `insta_media_count` INT(11) NOT NULL AFTER `insta_followers_count`, ADD `insta_website` VARCHAR(250) NOT NULL AFTER `insta_media_count`, ADD `insta_biography` TINYTEXT NOT NULL AFTER `insta_website`;

CREATE TABLE IF NOT EXISTS `instagram_reply_autoreply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `facebook_rx_fb_user_info_id` int(11) NOT NULL, `autoreply_type` enum('post_autoreply','account_autoreply','mentions_autoreply') NOT NULL DEFAULT 'post_autoreply', `post_pause_play` enum('play','pause') NOT NULL DEFAULT 'play', `full_pause_play` enum('play','pause') NOT NULL, `mentions_pause_play` enum('play','pause') NOT NULL DEFAULT 'play', `auto_reply_campaign_name` varchar(255) DEFAULT NULL, `user_id` int(11) NOT NULL, `page_info_table_id` int(11) NOT NULL, `page_name` text, `post_id` varchar(200) NOT NULL, `post_url` text NOT NULL, `media_url` text NOT NULL, `media_type` varchar(50) NOT NULL, `post_created_at` varchar(255) DEFAULT NULL, `post_description` longtext, `reply_type` varchar(200) NOT NULL, `report_type` enum('full','mention','post') NOT NULL DEFAULT 'post', `multiple_reply` enum('no','yes') NOT NULL, `nofilter_word_found_text` longtext NOT NULL, `auto_reply_text` longtext NOT NULL, `last_updated_at` datetime NOT NULL, `last_reply_time` datetime NOT NULL, `error_message` text NOT NULL, `hide_comment_after_comment_reply` enum('no','yes') NOT NULL, `is_delete_offensive` enum('hide','delete') NOT NULL, `offensive_words` longtext NOT NULL, `hidden_comment_count` int(11) NOT NULL, `deleted_comment_count` int(11) NOT NULL, `auto_comment_reply_count` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`,`page_info_table_id`,`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `instagram_autoreply_report` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `autoreply_table_id` int(11) NOT NULL, `post_id` varchar(50) CHARACTER SET utf8 NOT NULL, `reply_type` enum('post','full','mention') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post', `comment_id` varchar(50) CHARACTER SET utf8 NOT NULL, `comment_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `commenter_name` varchar(120) CHARACTER SET utf8 NOT NULL, `commenter_id` varchar(50) CHARACTER SET utf8 NOT NULL, `comment_time` datetime NOT NULL, `reply_time` datetime NOT NULL, `comment_reply_text` text COLLATE utf8mb4_unicode_ci NOT NULL, `reply_status_comment` text CHARACTER SET utf8 NOT NULL, `post_url` text COLLATE utf8mb4_unicode_ci NOT NULL, `media_url` text COLLATE utf8mb4_unicode_ci NOT NULL, `media_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `error_message` text COLLATE utf8mb4_unicode_ci NOT NULL, `hidden_comment_count` int(11) NOT NULL, `deleted_comment_count` int(11) NOT NULL, `auto_comment_reply_count` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `comment_id` (`comment_id`), KEY `Autoreply_teable_id` (`autoreply_table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `payment_config` ADD `razorpay_key_id` VARCHAR(255) NOT NULL AFTER `stripe_publishable_key`, ADD `razorpay_key_secret` VARCHAR(255) NOT NULL AFTER `razorpay_key_id`, ADD `paystack_secret_key` VARCHAR(255) NOT NULL AFTER `razorpay_key_secret`, ADD `paystack_public_key` VARCHAR(255) NOT NULL AFTER `paystack_secret_key`, ADD `mollie_api_key` VARCHAR(255) NOT NULL AFTER `paystack_public_key`;

CREATE TABLE IF NOT EXISTS `email_sms_template` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `template_type` enum('sms','email') NOT NULL, `template_name` varchar(255) NOT NULL, `subject` varchar(255) CHARACTER SET utf8mb4 NOT NULL, `content` longtext CHARACTER SET utf8mb4 NOT NULL, PRIMARY KEY (`id`), KEY `user_id_template` (`user_id`,`template_type`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

alter table `email_sms_template` add column `editor_type` enum('rich_text_editor','drag_and_drop') not null default 'rich_text_editor' after `template_type`;

alter table `email_sms_template` add column `location_hash` varchar(50) null after `editor_type`;

alter table `email_sending_campaign` add column `email_template_id` int null DEFAULT null after `email_message`;

ALTER TABLE `ecommerce_cart` ADD `payment_temp_session` VARCHAR(255) NOT NULL AFTER `processing_status`;

CREATE TABLE IF NOT EXISTS `medium_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `app_name` varchar(255) NOT NULL, `client_id` varchar(255) NOT NULL, `client_secret` varchar(255) NOT NULL, `status` enum('0','1') NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `medium_users_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `medium_id` varchar(200) NOT NULL, `name` varchar(255) NOT NULL, `user_name` varchar(255) NOT NULL, `profile_pic` text NOT NULL, `access_token` varchar(255) NOT NULL, `refresh_token` varchar(255) NOT NULL, `add_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `modules` (`id`, `module_name`, `add_ons_id`, `extra_text`, `limit_enabled`, `bulk_limit_enabled`, `deleted`) VALUES ('277', 'Social Poster - Account Import : Medium', '0', '', '1', '0', '0');

UPDATE `version` SET `current`='0';

INSERT INTO version(version, current, date) VALUES ('5.0','1',CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE version='5.0',current='1',date=CURRENT_TIMESTAMP;





Change log
- CSV bulk post planner [https://xeroneit.net/blog/how-to-post-on-social-media-from-csv-file-with-xerochat-bulk-post-planner]

- Drag & Drop Email Builder for Email Marketing Feature [https://xeroneit.net/blog/how-to-create-beautiful-email-templates-in-xerochat]

- Instagram Comment Auto Reply [https://xeroneit.net/home/blog/instagram-auto-comment-reply-with-xerochat]

- Drag & Drop Bot setting soring for replies, button, quick replies, carousel [
]

- Ecommerce : Razorpay, Paystack & Mollie payment method added[https://xeroneit.net/blog/how-to-setup-ecommerce-payment-settings-in-xerochat]

- Ecommerce : Abandoned cart recovery system (messenger,sms and email) [https://xeroneit.net/blog/how-to-recover-lost-sale-with-xerochat-abandoned-cart-reminder]

- Ecommerce : Store-wise order status update notification (messenger,sms and email)

- Ecommerce : Store-wise language selection

- Ecommerce : Facebook pixel and Google analytics code support

- Ecommerce : Country and phonecode auto selected in checkout page

- Auto post add-on : YouTube video post bug

- Auto post add-on : Fixes decoding special characters

- Company information now displayed in landing page footer

- Medium posting feature has been added. [https://xeroneit.net/blog/how-to-create-medium-app-and-integrate-with-xerochat]

- Deprecated : place search and multi-level persistent menu

- YouTube & Pinterest posting has been removed.

- Domain whitelisting fix

- Chat with bot button reply fix

- Add postback button in 3rd level iframe fix

- Google SDK error fix for PHP 7.4

- Stripe payment billing address added (extended license)

- Package subscription conformation email variables do not replace issue (extended license)

- All possible currency displayed in payment settings (extended license)

- Razorpay, Paystack & Mollie payment method added in package purchase for service selling of Xerochat (extended license)

- Many more fixes
Files
  • application/views/admin
  • application/modules
  • application/controllers/Instagram_reply.php
  • application/controllers/Sms_email_manager.php
  • application/views/sms_email_manager/email/email_templates/sms_email_manager_js.php
  • application/views/sms_email_manager/sms/view_template.php


Sql
UPDATE `version` SET `current`='0';

INSERT INTO version(version, current, date) VALUES ('5.0.1','1',CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE version='5.0.1',current='1',date=CURRENT_TIMESTAMP;





Change log
- Youtube & Pinterest deprecation missing files fix

- Email view template not found

- Email template update route not found
Files
  • application/controllers/Ecommerce.php
  • upload


Sql
UPDATE `version` SET `current`='0';

INSERT INTO version(version, current, date) VALUES ('5.0.2','1',CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE version='5.0.2',current='1',date=CURRENT_TIMESTAMP;





Change log
- Ecommerce edit issue
 

Attachments

Last edited:

irfan003

Member
Again you are not responding.
With this behavior, who will come and visit your site?
Who will upgrade his account?

Please do the needful.

We are expecting a lot from you and good service fro you and I am sure you will provide us.

Looking forward to you.

Thank you
 
Top Bottom
AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock