prefix."alidani_contact_form_color_font"; } // add database admin function alidani_contact_form_admin_info_database_table(){ global $wpdb; return $wpdb->prefix."alidani_contact_form_admin_info"; } // add database table Front function alidani_contact_form_database_table(){ global $wpdb; return $wpdb->prefix."alidani_contact_form_admin"; } //activate hook function alidani_contact_form_generation_table_script(){ global $wpdb; require_once ABSPATH.'wp-admin/includes/upgrade.php'; // new table $sql = "CREATE TABLE `".alidani_contact_form_database_table()."` ( `id` int(11) NOT NULL AUTO_INCREMENT, `firstname` varchar(255) DEFAULT NULL, `lastname` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `number` decimal(10,0) DEFAULT NULL, `enquiry` text, `creating` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1"; dbDelta($sql); // Admin Info $sql = "CREATE TABLE `".alidani_contact_form_admin_info_database_table()."` ( `adminid` int(11) NOT NULL AUTO_INCREMENT, `adminfirstname` varchar(255) DEFAULT NULL, `adminlastname` varchar(255) DEFAULT NULL, `adminemail` varchar(255) DEFAULT NULL, `adminmessage` text, PRIMARY KEY (`adminid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1"; dbDelta($sql); // Color and font $sql = "CREATE TABLE `".alidani_contact_form_color_font_database_table()."` ( `colorid` int(11) NOT NULL , `colorone` varchar(255) DEFAULT NULL, `colortwo` varchar(255) DEFAULT NULL, `colorthree` varchar(255) DEFAULT NULL, `colorfour` varchar(255) DEFAULT NULL, `colorfive` varchar(255) DEFAULT NULL, `colorsix` varchar(255) DEFAULT NULL, `fontone` varchar(255) DEFAULT NULL, `fonttwo` varchar(255) DEFAULT NULL, `fontthree` varchar(255) DEFAULT NULL, `fontfour` varchar(255) DEFAULT NULL, `fontfive` varchar(255) DEFAULT NULL, `fontsix` varchar(255) DEFAULT NULL, `fontseven` varchar(255) DEFAULT NULL, `fonteight` varchar(255) DEFAULT NULL, PRIMARY KEY (`colorid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1"; dbDelta($sql); $wpdb->insert(alidani_contact_form_color_font_database_table(),array( "colorid"=>"1", "colorone"=>"#000", "colortwo"=>"#337ab7", "colorthree"=>"#fff", "colorfour"=>"#fff", "colorfive"=>"#fff", "colorsix"=>"#000", "fontone"=>"First Name:", "fonttwo"=>"Last Name:", "fontthree"=>"Email:", "fontfour"=>"Phone Number:", "fontfive"=>"Enquiry:", "fontsix"=>"Submit", "fontseven"=>"Contact Form", )); } register_activation_hook(__FILE__,"alidani_contact_form_generation_table_script"); // deactivate hook function drop_table_plugin_alidani_contact_form(){ global $wpdb; $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_database_table() ); $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_admin_info_database_table() ); $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_color_font_database_table() ); } register_deactivation_hook(__FILE__,"drop_table_plugin_alidani_contact_form"); // uninstall hook function delete_table_plugin_alidani_contact_form(){ global $wpdb; $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_database_table() ); $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_admin_info_database_table() ); $wpdb->query( "DROP TABLE IF EXISTS ".alidani_contact_form_color_font_database_table() ); } register_uninstall_hook(__FILE__,"delete_table_plugin_alidani_contact_form"); //add ajax for alidanicontactlibrary add_action( "wp_ajax_alidanicontactlibrary","alidani_contact_ajax_handler" ); //add ajax for alidaniadmincontactlibrary add_action( "wp_ajax_alidaniadmincontactlibrary","alidani_admin_contact_ajax_handler" ); //add ajax for alidanicolorandfontlibrary add_action( "wp_ajax_alidanicolorandfontlibrary","alidani_color_font_contact_ajax_handler" ); //add ajax for alidanisendcontactlibrary add_action( "wp_ajax_alidanisendcontactlibrary","alidani_send_contact_ajax_handler" ); // function for alidani_color_font_contact_ajax_handler function alidani_color_font_contact_ajax_handler(){ global $wpdb; if($_REQUEST['param']=="save_color_font_form"){ $wpdb->update(alidani_contact_form_color_font_database_table(),array( "colorone"=>sanitize_hex_color($_REQUEST['colorInputColor']), "colortwo"=>sanitize_hex_color($_REQUEST['backcolorInputColor']), "colorthree"=>sanitize_hex_color($_REQUEST['interbackcolorInputColor']), "colorfour"=>sanitize_hex_color($_REQUEST['inputbackcolorInputColor']), "colorfive"=>sanitize_hex_color($_REQUEST['submitcolorInputColor']), "colorsix"=>sanitize_hex_color($_REQUEST['submitcolorfontColor']), "fontone"=>sanitize_text_field($_REQUEST['firstfieldText']), "fonttwo"=>sanitize_text_field($_REQUEST['secondfieldText']), "fontthree"=>sanitize_text_field($_REQUEST['thirdfieldText']), "fontfour"=>sanitize_text_field($_REQUEST['forthfieldText']), "fontfive"=>sanitize_text_field($_REQUEST['fifthfieldText']), "fontsix"=>sanitize_text_field($_REQUEST['sixthfieldText']), "fontseven"=>sanitize_text_field($_REQUEST['seventhfieldText']), ),array( "colorid"=> "1" )); echo json_encode(array("status"=>1,"message"=>"Changes has been saved!")); } wp_die(); } // function for alidani_send_contact_ajax_handler function alidani_send_contact_ajax_handler(){ global $wpdb; if($_REQUEST['param']=="send_contact_form"){ $to=array( "to"=>sanitize_email($_REQUEST['toSend-email']), "from"=>sanitize_email($_REQUEST['adminSend-email']), ); $subject=array( "subject"=>sanitize_text_field($_REQUEST['subjectSend-email']), ); $message=array( "message"=>sanitize_text_field($_REQUEST['sendMessage']), ); wp_mail($to,$subject,$message); echo json_encode(array("status"=>1,"message"=>"The email has been send")); } wp_die(); } // function for alidani_admin_contact_ajax_handler function alidani_admin_contact_ajax_handler(){ global $wpdb; if($_REQUEST['param']=="save_admin_contact_form"){ $wpdb->insert(alidani_contact_form_admin_info_database_table(),array( "adminid"=> "1", "adminfirstname"=>sanitize_user($_REQUEST['admin-first-name']), "adminlastname"=>sanitize_user($_REQUEST['admin-last-name']), "adminemail"=>sanitize_email($_REQUEST['admin-email']), "adminmessage"=>sanitize_text_field($_REQUEST['admin-message']), )); echo json_encode(array("status"=>1,"message"=>"Request created Successfully")); }elseif ($_REQUEST['param']=="edit_admin_contact_form"){ $wpdb->update(alidani_contact_form_admin_info_database_table(),array( "adminfirstname"=>sanitize_user($_REQUEST['admin-first-name']), "adminlastname"=>sanitize_user($_REQUEST['admin-last-name']), "adminemail"=>sanitize_email($_REQUEST['admin-email']), "adminmessage"=>sanitize_text_field($_REQUEST['admin-message']), ),array( "adminid"=>sanitize_text_field($_REQUEST['alidani_admin_contact_id']) )); echo json_encode(array("status"=>1,"message"=>"Request created Successfully")); } elseif ($_REQUEST['param']=="delete_admin_contact_form") { $wpdb->delete(alidani_contact_form_admin_info_database_table(),array( "adminid"=>sanitize_text_field($_REQUEST['adminid']) )); echo json_encode(array("status"=>1,"message"=>"Request Deleted Successfully")); } wp_die(); } //function alidani_contact_ajax_handler function alidani_contact_ajax_handler(){ global $wpdb; if($_REQUEST['param']=="save_contact_form"){ $wpdb->insert(alidani_contact_form_database_table(),array( "firstname"=>sanitize_user($_REQUEST['first-name']), "lastname"=>sanitize_user($_REQUEST['last-name']), "email"=>sanitize_email($_REQUEST['email']), "number"=>sanitize_text_field($_REQUEST['number']), "enquiry"=>sanitize_text_field($_REQUEST['enquiry']), )); echo json_encode(array("status"=>1,"message"=>"Thank you for contacting us; we will respond as soon as possible.")); }elseif ($_REQUEST['param']=="edit_contact_form"){ $wpdb->update(alidani_contact_form_database_table(),array( "firstname"=>sanitize_user($_REQUEST['first-name']), "lastname"=>sanitize_user($_REQUEST['last-name']), "email"=>sanitize_email($_REQUEST['email']), "number"=>sanitize_text_field($_REQUEST['number']), "enquiry"=>sanitize_text_field($_REQUEST['enquiry']), ),array( "id"=>sanitize_text_field($_REQUEST['alidani_contact_id']) )); echo json_encode(array("status"=>1,"message"=>"Request created Successfully")); } //delete the recieving form elseif ($_REQUEST['param']=="delete_contact_form") { $wpdb->delete(alidani_contact_form_database_table(),array( "id"=>sanitize_text_field($_REQUEST['id']) )); echo json_encode(array("status"=>1,"message"=>"Request Deleted Successfully")); } wp_die(); }