Server Information
Current PHP version: 5.6.32
Current MySQL version: 5.5.58
------------------------------------------------------------------------------------------
Site Info:
Multisite: No
Wordpress Version: 4.8.4
IMAP Loaded: Yes
------------------------------------------------------------------------------------------
Active Plugins
4Media(version:1.0)
ACF: Better Search(version:2.0.7)
ACF Columns(version:1.0.0)
Advanced Custom Fields: User Role Selector(version:3.0.2)
Advanced Custom Fields: Theme Code(version:1.3.2)
Add Search To Menu(version:3.3)
Admin Menu Editor(version:1.8)
Advanced Custom Fields PRO(version:5.6.2)
Advanced Forms(version:1.3.2)
Aquila Admin Theme(version:2.2)
ARI Fancy Lightbox(version:1.2.10)
Check and Enable GZIP compression(version:1.1.11)
Child Themify(version:1.2.0)
Clean Login(version:1.8.1)
Code Snippets(version:2.9.4)
SiteOrigin Widgets by CodeLights(version:1.2)
Content Views(version:1.9.9.5)
Custom Post Type UI(version:1.5.5)
Duplicate Post(version:3.2)
Duplicator(version:1.2.26)
Elementor(version:1.8.8)
Enhanced Media Library(version:2.4.5)
WP ERP(version:1.2.5)
Events Manager(version:5.7.3)
FAQ WD(version:1.0.31)
FooBox Image Lightbox(version:1.2.27)
FooGallery Owl Carousel Template(version:1.4.2)
FooGallery - Polaroid Gallery Template Extension(version:1.0.3)
FooGallery - ZOOM!(version:1.1.1)
FooGallery(version:1.3.8)
Go Live Update URLS(version:4.1.5)
Hover Effects(version:2.1)
Import users from CSV with meta(version:1.10.7.4)
LifterLMS Labs(version:1.4.0)
LifterLMS(version:3.12.2)
Menu Icons(version:0.10.2)
Nav Menu Roles(version:1.8.6)
Slider by Nivo - Responsive Image Slider(version:2.1.0)
PDF Image Generator(version:1.5.6)
Content Views Pro(version:4.7.4)
Regenerate Thumbnails(version:2.3.1)
Relevanssi(version:3.6.0)
Responsive Lightbox(version:1.7.2)
Simple Lightbox(version:2.6.0)
SiteOrigin CSS(version:1.1.5)
Orbit Fox Companion(version:2.0.6)
TinyMCE Advanced(version:4.6.3)
User profile(version:2.0.7)
User Role Editor(version:4.36.1)
ACF User Role Field Setting(version:2.1.12)
Velvet Blues Update URLs(version:3.2.7)
Void Elementor Post Grid Addon for Elementor Page builder(version:1.0.6)
W3 Total Cache(version:0.9.5.4)
Facebook Feed WD(version:1.0.27)
Instagram Feed WD(version:1.2.7)
Yoast SEO(version:5.4.2)
WP FullCalendar(version:1.2)
WP Maintenance Mode(version:2.0.9)
WP Smush(version:2.7.4.1)
WP Support Plus(version:8.0.7)
WP-Sweep(version:1.0.10)
WPFront Scroll Top(version:1.5)
YouTube(version:11.8.2)
------------------------------------------------------------------------------------------
Active Theme:
Theme Name: Tiny Hestia(version:1.0.5)
------------------------------------------------------------------------------------------
Support Plus Options
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_remove_faulty_indexes';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159682, 'wpsp_remove_faulty_indexes','1', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wp_support_plus_version';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159683, 'wp_support_plus_version','8.0.7', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_add_table_indexes';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159684, 'wpsp_add_table_indexes','1', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_repair_faulty_indexes';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159685, 'wpsp_repair_faulty_indexes','1', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_general_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159686, 'wpsp_general_settings','a:25:{s:7:"post_id";s:1:"0";s:21:"enable_support_button";s:1:"1";s:23:"support_button_position";s:12:"bottom_right";s:19:"enable_guest_ticket";s:1:"0";s:18:"enable_slider_menu";s:1:"1";s:13:"support_title";s:10:"Need Help?";s:20:"support_phone_number";s:0:"";s:18:"display_skype_chat";s:1:"0";s:18:"display_skype_call";s:1:"0";s:23:"default_ticket_category";s:1:"1";s:20:"enable_default_login";s:1:"1";s:36:"enable_user_selection_public_private";s:1:"0";s:19:"default_ticket_type";s:1:"0";s:30:"allow_agents_to_assign_tickets";s:1:"0";s:30:"allow_agents_to_delete_tickets";s:1:"0";s:33:"allow_attachment_for_guest_ticket";s:1:"0";s:30:"ticket_status_after_cust_reply";s:7:"pending";s:20:"front_end_submission";s:1:"0";s:25:"default_new_ticket_status";s:1:"1";s:20:"default_login_module";s:1:"1";s:27:"close_ticket_btn_status_val";s:6:"closed";s:15:"close_btn_alice";s:12:"Close Ticket";s:26:"enable_register_guest_user";s:1:"0";s:15:"guest_user_role";s:10:"subscriber";s:28:"allow_agents_to_edit_tickets";s:1:"1";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_email_notification_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159687, 'wpsp_email_notification_settings','a:17:{s:16:"admin_new_ticket";i:1;s:18:"admin_reply_ticket";i:1;s:20:"administrator_emails";s:24:"andrew.tan@4media.com.sg";s:24:"agent_email_notification";i:1;s:17:"enable_email_pipe";i:0;s:18:"default_from_email";s:32:"wordpress@elearn.kinohimitsu.com";s:17:"default_from_name";s:9:"WordPress";s:16:"default_reply_to";s:0:"";s:11:"piping_type";s:6:"cpanel";s:15:"imap_encryption";s:4:"none";s:11:"imap_server";s:0:"";s:9:"imap_port";s:0:"";s:13:"imap_username";s:0:"";s:13:"imap_password";s:0:"";s:22:"imap_connection_status";i:0;s:19:"agent_silent_create";i:0;s:13:"ignore_emails";s:0:"";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_role_management';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159688, 'wpsp_role_management','a:4:{s:6:"agents";a:1:{i:0;s:14:"erp_hr_manager";}s:11:"supervisors";a:1:{i:0;s:14:"erp_hr_manager";}s:16:"front_ticket_all";b:0;s:12:"front_ticket";a:3:{i:0;s:13:"administrator";i:1;s:21:"wp_support_plus_agent";i:2;s:26:"wp_support_plus_supervisor";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_customcss_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159689, 'wpsp_customcss_settings','', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159690, 'wpsp_advanced_settings','a:28:{s:31:"guest_ticket_submission_message";s:70:"Thank You. We will shortly get back to you on your given mail address!";s:20:"pending_ticket_close";s:0:"";s:18:"ticket_label_alice";a:20:{i:1;s:6:"Ticket";i:2;s:7:"Tickets";i:3;s:17:"Create New Ticket";i:4;s:20:"Ticket List Settings";i:5;s:16:"Create Ticket As";i:6;s:18:"Make Ticket Public";i:7;s:13:"Submit Ticket";i:8;s:11:"Edit Ticket";i:9;s:12:"Reply Ticket";i:10;s:13:"Delete Ticket";i:11;s:11:"Ticket Type";i:12;s:14:"No. of Tickets";i:13;s:14:"Ticket Creator";i:14;s:27:"Create Ticket Success Email";i:15;s:32:"Delete Ticket Notification Email";i:16;s:22:"New Ticket From Thread";i:17;s:15:"Back to Tickets";i:18;s:26:"Backend Ticket List Fields";i:19;s:27:"Frontend Ticket List Fields";i:20;s:16:"No Tickets Found";}s:24:"wpsp_reply_form_position";i:1;s:22:"wpsp_shortcode_used_in";i:0;s:16:"enable_accordion";i:1;s:27:"hide_selected_status_ticket";s:4:"none";s:8:"ticketId";i:1;s:15:"logout_Settings";i:1;s:17:"admin_bar_Setting";i:1;s:11:"reply_above";i:1;s:13:"datecustfield";s:8:"dd-mm-yy";s:10:"active_tab";i:1;s:21:"wpsp_ticket_id_prefix";s:1:"#";s:35:"hide_selected_status_ticket_backend";a:0:{}s:16:"modify_raised_by";a:0:{}s:25:"wpsp_dashboard_menu_label";s:12:"Support Plus";s:21:"guest_ticket_redirect";i:0;s:25:"guest_ticket_redirect_url";s:0:"";s:22:"message_for_ticket_url";s:38:"This ticket is closed for new replies.";s:33:"wpsp_redirect_after_ticket_update";i:1;s:21:"wpspAttachMaxFileSize";i:20;s:22:"wpspBootstrapJSSetting";i:1;s:23:"wpspBootstrapCSSSetting";i:1;s:28:"wpsp_attachment_download_url";i:1;s:17:"wpspAttachment_bc";s:7:"#1aaf1c";s:17:"wpspAttachment_pc";s:7:"#ff0000";s:36:"hide_selected_status_ticket_frontend";a:0:{}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_shortcode_used_in_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159691, 'wpsp_shortcode_used_in_settings','1', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings_field_order';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159692, 'wpsp_advanced_settings_field_order','a:4:{s:12:"fields_order";a:7:{i:0;s:2:"dn";i:1;s:2:"de";i:2;s:2:"ds";i:3;s:2:"dd";i:4;s:2:"dc";i:5;s:2:"dp";i:6;s:2:"da";}s:14:"display_fields";a:7:{i:0;s:2:"dn";i:1;s:2:"de";i:2;s:2:"ds";i:3;s:2:"dd";i:4;s:2:"dc";i:5;s:2:"dp";i:6;s:2:"da";}s:20:"default_fields_label";a:7:{s:2:"dn";s:4:"Name";s:2:"de";s:13:"Email Address";s:2:"ds";s:7:"Subject";s:2:"dd";s:11:"Description";s:2:"dc";s:8:"Category";s:2:"dp";s:8:"Priority";s:2:"da";s:11:"Attachments";}s:29:"wpsp_default_value_of_subject";s:2:"NA";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings_status_order';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159693, 'wpsp_advanced_settings_status_order','a:1:{s:12:"status_order";a:3:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings_priority_order';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159694, 'wpsp_advanced_settings_priority_order','a:1:{s:14:"priority_order";a:4:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings_ticket_list_order';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159695, 'wpsp_advanced_settings_ticket_list_order','a:2:{s:19:"backend_ticket_list";a:12:{s:2:"id";i:1;s:2:"st";i:1;s:2:"sb";i:1;s:2:"rb";i:1;s:2:"ty";i:1;s:2:"ct";i:1;s:2:"at";i:1;s:2:"pt";i:1;s:2:"ut";i:1;s:3:"cdt";i:0;s:3:"udt";i:0;s:3:"acd";i:0;}s:20:"frontend_ticket_list";a:10:{s:2:"id";i:1;s:2:"st";i:1;s:2:"sb";i:1;s:2:"ct";i:1;s:2:"at";i:1;s:2:"pt";i:1;s:2:"ut";i:1;s:3:"cdt";i:0;s:3:"udt";i:0;s:2:"rb";i:1;}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_ticket_list_date_format';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159696, 'wpsp_ticket_list_date_format','a:4:{s:11:"cdt_backend";s:0:"";s:11:"udt_backend";s:0:"";s:12:"cdt_frontend";s:0:"";s:12:"udt_frontend";s:0:"";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_advanced_settings_custom_filter_front';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159697, 'wpsp_advanced_settings_custom_filter_front','a:3:{s:9:"logged_in";a:4:{i:0;s:2:"st";i:1;s:2:"ct";i:2;s:3:"not";i:3;s:2:"tt";}s:15:"agent_logged_in";a:4:{i:0;s:2:"st";i:1;s:2:"ct";i:2;s:3:"not";i:3;s:2:"tt";}s:20:"supervisor_logged_in";a:4:{i:0;s:2:"st";i:1;s:2:"ct";i:2;s:3:"not";i:3;s:2:"tt";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_ticket_list_subject_char_length';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159698, 'wpsp_ticket_list_subject_char_length','a:2:{s:8:"frontend";s:2:"20";s:7:"backend";s:2:"20";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_et_create_new_ticket';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159699, 'wpsp_et_create_new_ticket','a:7:{s:14:"enable_success";s:1:"1";s:15:"success_subject";s:41:"Your Ticket has been created successfully";s:12:"success_body";s:373:"Dear {customer_name},
Thank you for contacting Support. Your ticket has been created Successfully!
Below are details of your ticket -
Subject: {ticket_subject}
Description:
{ticket_description}
";s:13:"staff_subject";s:16:"{ticket_subject}";s:10:"staff_body";s:124:"{customer_name} ({customer_email}) wrote:
{ticket_description}
";s:9:"templates";a:10:{s:13:"customer_name";s:13:"Customer Name";s:14:"customer_email";s:14:"Customer Email";s:9:"ticket_id";s:9:"Ticket ID";s:14:"ticket_subject";s:14:"Ticket Subject";s:18:"ticket_description";s:18:"Ticket Description";s:15:"ticket_category";s:15:"Ticket Category";s:15:"ticket_priority";s:15:"Ticket Priority";s:10:"ticket_url";s:10:"Ticket URL";s:12:"time_created";s:14:"Ticket Created";s:13:"agent_created";s:13:"Agent Created";}s:15:"staff_to_notify";a:4:{s:13:"administrator";s:1:"1";s:10:"supervisor";s:1:"1";s:14:"assigned_agent";s:1:"1";s:10:"all_agents";s:1:"0";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_et_reply_ticket';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159700, 'wpsp_et_reply_ticket','a:4:{s:13:"reply_subject";s:16:"{ticket_subject}";s:10:"reply_body";s:123:"{reply_by_name} ({reply_by_email}) wrote:
{reply_description}
";s:9:"templates";a:12:{s:13:"reply_by_name";s:13:"Reply By Name";s:14:"reply_by_email";s:14:"Reply By Email";s:13:"ticket_status";s:13:"Ticket Status";s:13:"customer_name";s:29:"Customer Name(ticket creator)";s:14:"customer_email";s:30:"Customer Email(ticket creator)";s:9:"ticket_id";s:9:"Ticket ID";s:14:"ticket_subject";s:14:"Ticket Subject";s:17:"reply_description";s:17:"Reply Description";s:15:"ticket_category";s:15:"Ticket Category";s:15:"ticket_priority";s:15:"Ticket Priority";s:10:"ticket_url";s:10:"Ticket URL";s:12:"time_created";s:14:"Ticket Created";}s:9:"notify_to";a:5:{s:8:"customer";s:1:"1";s:13:"administrator";s:1:"1";s:10:"supervisor";s:1:"1";s:14:"assigned_agent";s:1:"1";s:10:"all_agents";s:1:"0";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_et_change_ticket_status';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159701, 'wpsp_et_change_ticket_status','a:4:{s:9:"notify_to";a:5:{s:8:"customer";s:1:"1";s:13:"administrator";s:1:"1";s:10:"supervisor";s:1:"1";s:14:"assigned_agent";s:1:"1";s:10:"all_agents";s:1:"0";}s:12:"mail_subject";s:16:"{ticket_subject}";s:9:"mail_body";s:771:"Below are details of ticket:
------------------------------------------------------------------------------------------------------------------------------------
Subject: {ticket_subject}
Status: {ticket_status}
Category: {ticket_category}
Priority: {ticket_priority}
------------------------------------------------------------------------------------------------------------------------------------
Description:
{ticket_description}";s:9:"templates";a:11:{s:13:"customer_name";s:29:"Customer Name(ticket creator)";s:14:"customer_email";s:30:"Customer Email(ticket creator)";s:9:"ticket_id";s:9:"Ticket ID";s:14:"ticket_subject";s:14:"Ticket Subject";s:18:"ticket_description";s:18:"Ticket Description";s:13:"ticket_status";s:13:"Ticket Status";s:15:"ticket_category";s:15:"Ticket Category";s:15:"ticket_priority";s:15:"Ticket Priority";s:10:"ticket_url";s:10:"Ticket URL";s:10:"updated_by";s:23:"User who changed status";s:12:"time_created";s:14:"Ticket Created";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_et_change_ticket_assign_agent';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159702, 'wpsp_et_change_ticket_assign_agent','a:4:{s:9:"notify_to";a:5:{s:8:"customer";s:1:"1";s:13:"administrator";s:1:"1";s:10:"supervisor";s:1:"1";s:14:"assigned_agent";s:1:"1";s:10:"all_agents";s:1:"0";}s:12:"mail_subject";s:49:"{updated_by} assigned ticket to {new_assigned_to}";s:9:"mail_body";s:853:"Below are details of ticket:
------------------------------------------------------------------------------------------------------------------------------------
Subject: {ticket_subject}
Status: {ticket_status}
Category: {ticket_category}
Priority: {ticket_priority}
Previously Assigned: {old_assigned_to}
------------------------------------------------------------------------------------------------------------------------------------
Description:
{ticket_description}";s:9:"templates";a:13:{s:13:"customer_name";s:29:"Customer Name(ticket creator)";s:14:"customer_email";s:30:"Customer Email(ticket creator)";s:9:"ticket_id";s:9:"Ticket ID";s:14:"ticket_subject";s:14:"Ticket Subject";s:18:"ticket_description";s:18:"Ticket Description";s:13:"ticket_status";s:13:"Ticket Status";s:15:"ticket_category";s:15:"Ticket Category";s:15:"ticket_priority";s:15:"Ticket Priority";s:10:"ticket_url";s:10:"Ticket URL";s:10:"updated_by";s:24:"User who assigned ticket";s:15:"old_assigned_to";s:35:"User to whom assigned ticket before";s:15:"new_assigned_to";s:32:"User to whom assigned ticket now";s:12:"time_created";s:14:"Ticket Created";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_et_delete_ticket';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159703, 'wpsp_et_delete_ticket','a:4:{s:9:"notify_to";a:5:{s:8:"customer";s:1:"1";s:13:"administrator";s:1:"1";s:10:"supervisor";s:1:"1";s:14:"assigned_agent";s:1:"1";s:10:"all_agents";s:1:"0";}s:12:"mail_subject";s:40:"{updated_by} deleted ticket #{ticket_id}";s:9:"mail_body";s:772:"Below ware details of ticket:
------------------------------------------------------------------------------------------------------------------------------------
Subject: {ticket_subject}
Status: {ticket_status}
Category: {ticket_category}
Priority: {ticket_priority}
------------------------------------------------------------------------------------------------------------------------------------
Description:
{ticket_description}";s:9:"templates";a:10:{s:13:"customer_name";s:29:"Customer Name(ticket creator)";s:14:"customer_email";s:30:"Customer Email(ticket creator)";s:9:"ticket_id";s:9:"Ticket ID";s:14:"ticket_subject";s:14:"Ticket Subject";s:18:"ticket_description";s:18:"Ticket Description";s:13:"ticket_status";s:13:"Ticket Status";s:15:"ticket_category";s:15:"Ticket Category";s:15:"ticket_priority";s:15:"Ticket Priority";s:10:"updated_by";s:24:"User who assigned ticket";s:12:"time_created";s:14:"Ticket Created";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_default_status_priority_names';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159704, 'wpsp_default_status_priority_names','a:2:{s:12:"status_names";a:3:{s:4:"open";s:4:"open";s:7:"pending";s:7:"pending";s:6:"closed";s:6:"closed";}s:14:"priority_names";a:4:{s:6:"Normal";s:6:"Normal";s:4:"High";s:4:"High";s:6:"Medium";s:6:"Medium";s:3:"Low";s:3:"Low";}}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_ckeditor_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159705, 'wpsp_ckeditor_settings','a:2:{s:14:"guestUserFront";s:1:"1";s:14:"loginUserFront";s:1:"1";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_upload_image_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159706, 'wpsp_upload_image_settings','a:3:{s:17:"leftSupportButton";s:127:"https://elearn.kinohimitsu.com/wp-content/plugins/wp-support-plus-responsive-ticket-system/asset/images/support-button-left.png";s:18:"rightSupportButton";s:128:"https://elearn.kinohimitsu.com/wp-content/plugins/wp-support-plus-responsive-ticket-system/asset/images/support-button-right.png";s:11:"panel_image";s:120:"https://elearn.kinohimitsu.com/wp-content/plugins/wp-support-plus-responsive-ticket-system/asset/images/support_icon.jpg";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_front_end_display_settings';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159707, 'wpsp_front_end_display_settings','a:45:{s:21:"wpsp_hideBackToTicket";i:1;s:20:"wpsp_hideCloseTicket";i:1;s:19:"wpsp_hideMoreAction";i:1;s:21:"wpsp_hideChangeStatus";i:1;s:20:"wpsp_hideCannedReply";i:1;s:20:"wpsp_hideAssignAgent";i:1;s:21:"wpsp_hideDeleteTicket";i:1;s:11:"wpsp_hideCC";i:1;s:12:"wpsp_hideBCC";i:1;s:15:"wpsp_hideStatus";i:1;s:17:"wpsp_hideCategory";i:1;s:17:"wpsp_hidePriority";i:1;s:20:"wpsp_hideAttachments";i:1;s:17:"wpsp_hideAddNotes";i:1;s:20:"wpsp_hideSubmitReply";i:1;s:14:"wpsp_hideEmail";i:1;s:26:"wpsp_hideDaysMonthsYearAgo";i:1;s:18:"wpsp_hideExactDate";i:1;s:18:"wpsp_hideExactTime";i:1;s:24:"wpsp_faq_display_setting";i:1;s:11:"wpsp_btt_fc";s:4:"#fff";s:11:"wpsp_btt_bc";s:7:"#428bca";s:10:"wpsp_ct_fc";s:4:"#fff";s:10:"wpsp_ct_bc";s:7:"#428bca";s:10:"wpsp_ma_fc";s:4:"#fff";s:10:"wpsp_ma_bc";s:7:"#428bca";s:10:"wpsp_cs_fc";s:4:"#fff";s:10:"wpsp_cs_bc";s:7:"#428bca";s:10:"wpsp_cr_fc";s:4:"#fff";s:10:"wpsp_cr_bc";s:7:"#428bca";s:10:"wpsp_aa_fc";s:4:"#fff";s:10:"wpsp_aa_bc";s:7:"#428bca";s:10:"wpsp_dt_fc";s:4:"#fff";s:10:"wpsp_dt_bc";s:7:"#d43f3a";s:10:"wpsp_an_fc";s:4:"#fff";s:10:"wpsp_an_bc";s:7:"#428bca";s:10:"wpsp_sr_fc";s:4:"#fff";s:10:"wpsp_sr_bc";s:7:"#428bca";s:23:"front_end_display_alice";a:14:{i:1;s:13:"Change Status";i:2;s:12:"Canned Reply";i:3;s:12:"Assign Agent";i:4;s:13:"Delete Ticket";i:5;s:2:"CC";i:6;s:3:"BCC";i:7;s:6:"Status";i:8;s:8:"Category";i:9;s:8:"Priority";i:10;s:11:"Attachments";i:11;s:9:"Add Notes";i:12;s:12:"Submit Reply";i:13;s:16:"Change Raised By";i:14;s:14:"Restore Ticket";}s:10:"wpsp_cb_bc";s:7:"#428bca";s:10:"wpsp_cb_fc";s:4:"#fff";s:19:"wpsp_ChangeRaisedBy";i:1;s:18:"wpsp_restoreTicket";i:1;s:10:"wpsp_rt_bc";s:7:"#428bca";s:10:"wpsp_rt_fc";s:4:"#fff";}', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_attachment_random_key';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159708, 'wpsp_attachment_random_key','1', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='wpsp_ticket_open_page_shortcode';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (159712, 'wpsp_ticket_open_page_shortcode','3831', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='date_format';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (23, 'date_format','F j, Y', 'yes');
DELETE FROM `wp_options` WHERE `wp_options`.`option_name`='users_can_register';
INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES (5, 'users_can_register','0', 'yes');
------------------------------------------------------------------------------------------
Support Plus Categories:
TRUNCATE TABLE wp_wpsp_catagories;
INSERT INTO `wp_wpsp_catagories` (`id`, `name`, `default_assignee`) VALUES (1,'General','0');
------------------------------------------------------------------------------------------
Support Plus Custom Statuses:
TRUNCATE TABLE wp_wpsp_custom_status;
INSERT INTO `wp_wpsp_custom_status` (`id`, `name`, `color`) VALUES (1,'open','#d9534f'),(2,'pending','#f0ad4e'),(3,'closed','#5cb85c');
------------------------------------------------------------------------------------------
Support Plus Custom Priority:
TRUNCATE TABLE wp_wpsp_custom_priority;
INSERT INTO `wp_wpsp_custom_priority` (`id`, `name`, `color`) VALUES (1,'Normal','#5cb85c'),(2,'High','#d9534f'),(3,'Medium','#f0ad4e'),(4,'Low','#5bc0de');
------------------------------------------------------------------------------------------
Support Plus Custom Fields:
TRUNCATE TABLE wp_wpsp_custom_fields;
INSERT INTO `wp_wpsp_custom_fields` (`id`, `label`, `required`, `field_type`, `field_options`, `field_categories`, `isVarFeild`) VALUES ;
------------------------------------------------------------------------------------------