function install_signup_builder() { //NB Always set wpdb globally! global $wpdb, $user_ID; //Set Table Name $signup_builder_table = $wpdb->prefix . "signup_builder"; //Check whether or not the table already exists if (!check_signup_builder_existance($signup_builder_table)) { // Create the main Table, don't forget the ( ` ) - MySQL Reference @ http://www.w3schools.com/Sql/sql_create_table.asp $signup_builder_table_install = "CREATE TABLE `" . $signup_builder_table . "` (\t\t\t\n\t\t\t`id` MEDIUMINT(8) unsigned NOT NULL auto_increment PRIMARY KEY,\n\t\t\t`field_name` VARCHAR(255),\n\t\t\t`field_type` VARCHAR(255),\n\t\t\t`field_label` VARCHAR(255),\n\t\t\t`field_values` VARCHAR(255),\n\t\t\t`field_max_value` VARCHAR(255),\n\t\t\t`field_isEmpty` INT( 1 ),\n\t\t\t`field_can_delete` INT( 1 ) NOT NULL DEFAULT 1,\n\t\t\t`field_class` VARCHAR( 20 ),\n\t\t\t`field_order` INT( 1 ),\n\t\t\t`field_error_msg` VARCHAR(255),\n\t\t\t`field_sub_label` VARCHAR(255));"; $signup_builder_table_add = " INSERT INTO `" . $signup_builder_table . "` \n\t\t\t (`id`, `field_name`, `field_type`, `field_label`, `field_values`, `field_max_value`, `field_isEmpty`, `field_can_delete`, `field_class`, `field_order`, `field_error_msg`, `field_sub_label`) \n\tVALUES ('', 'username', 'text', 'Username', '', '50', 1, 0, '', 1,'','Type a username'), \n\t\t ('', 'password', 'password', 'Password', '', '50', 1, 0, '', 2,'','Type a password'),\n\t\t ('', 'email', 'text', 'Email', '', '50', 1, 0, '', 3,'','Enter your valid email');"; //Run the and validate that it was successful if (mysql_query($signup_builder_table_install) === true) { $tabe_created = 1; } if (mysql_query($signup_builder_table_add) === true) { $tabe_created = 1; } } //check if post space exist if not add new post and store data check_create_post(); //default email create_email_message(); //default color sb_default_menu(); }
function custom_signup() { // add_menu_page('Front GUI', 'Front GUI', 'add_users', 'signup-builder/signup-builder.php', 'show_signup', plugins_url('signup-builder/images/star.png')); add_menu_page('Signup Builder', 'Signup Builder', 8, 'signup-builder/signup-builder.php', 'show_signup', plugins_url('signup-builder/images/star.png')); check_create_post(); }