private void confirmRegisterButton_Click(object sender, EventArgs e) { //Register form variables userClass user = new userClass(); user.registerLogin = loginBox.Text; user.registerEmail = emailBox.Text; user.registerPassword = user.passEncryprtSHA1("salt" + passwordBox.Text + "aks"); user.registerRepeatPassword = user.passEncryprtSHA1("salt" + repeatPasswordBox.Text + "aks"); user.registerAcceptReg = regCheckBox.Checked; //Check correctness of details bool emailCheck = user.emailCheck(user.registerEmail); bool passCheck = user.passCheck(user.registerPassword, user.registerRepeatPassword); bool loginCheck = user.loginCheck(user.registerLogin); bool regCheck = user.regCheck(user.registerAcceptReg); if (emailCheck == true && passCheck == true && loginCheck == true && regCheck == true) { DataBaseClass db = new DataBaseClass(); //Create new user in DB string sql = "INSERT INTO users (login, pass , email) VALUES ('" + user.registerLogin + "','" + user.registerPassword + "','" + user.registerEmail + "')"; db.executeDB(sql); //Create templates data table db.executeDB("CREATE TABLE IF NOT EXISTS `templates_" + user.registerLogin + "` (" + "`id` int(10) NOT NULL auto_increment," + "`name` varchar(255)," + "`text` varchar(255)," + "PRIMARY KEY( `id` )" + "); "); //Create temp data table db.executeDB("CREATE TABLE IF NOT EXISTS `temporary_data_" + user.registerLogin + "` (" + "`id` int(10) NOT NULL auto_increment," + "`name` varchar(255)," + "`value` varchar(1000)," + "PRIMARY KEY( `id` )" + "); "); //Create offers data table db.executeDB("CREATE TABLE `offers_" + user.registerLogin + "` (" + "`id` INT(10) NOT NULL AUTO_INCREMENT," + "`monit_name` CHAR(200) NULL DEFAULT NULL," + "`offer_id` INT(30) NULL DEFAULT NULL," + "`offer_name` VARCHAR(255) NULL DEFAULT NULL," + "`code_base` VARCHAR(255) NULL DEFAULT NULL," + "`template` VARCHAR(255) NULL DEFAULT NULL," + "`active` BIT(1) NULL DEFAULT NULL," + "PRIMARY KEY(`id`))" + "COLLATE = 'utf8_general_ci'" + "ENGINE = InnoDB" + "; "); //Create orders datatable db.executeDB("CREATE TABLE `orders_" + user.registerLogin + "` (" + "`order_id` CHAR(100) NULL DEFAULT NULL," + "`customer_login` CHAR(50) NULL DEFAULT NULL," + "`customer_email` CHAR(50) NULL DEFAULT NULL," + "`quantity` INT(11) NULL DEFAULT NULL," + "`offer_name` CHAR(50) NULL DEFAULT NULL," + "`sent` TINYINT(4) NULL DEFAULT '0')" + "COLLATE = 'utf8_general_ci'" + "ENGINE = InnoDB;"); MessageBox.Show("Registered!", "Success"); this.Visible = false; } }