query($query1);
$userrole = 'superadmin';
$registeredcheck = 1;
$enabled = 1;
$query2 = $mysqli->prepare("INSERT INTO app_users (userrole, username, password, emailaddress, registered, enabled) VALUES (?, ?, ?, ?, ?, ?);");
$query2->bind_param("ssssii", $userrole, $adminuser, $adminuserpass, $adminuseremail, $registeredcheck, $enabled);
$query2->execute();
// Create table for contacts of Roundpin users
$query3 = " CREATE TABLE IF NOT EXISTS contacts (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
user_id INT UNSIGNED NOT NULL,
contact_name VARCHAR (300) DEFAULT NULL,
contact_desc VARCHAR (300) DEFAULT NULL,
extension_number VARCHAR (50) DEFAULT NULL,
contact_mobile VARCHAR (50) DEFAULT NULL,
contact_num1 VARCHAR (50) DEFAULT NULL,
contact_num2 VARCHAR (50) DEFAULT NULL,
contact_fax VARCHAR (50) DEFAULT NULL,
contact_email VARCHAR (300) DEFAULT NULL,
profile_picture_c LONGTEXT DEFAULT NULL,
groups VARCHAR (1500) DEFAULT NULL,
date_added DATETIME DEFAULT NULL,
date_modified DATETIME DEFAULT NULL,
CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
); ";
$result3 = $mysqli->query($query3);
// Create table for external users of video conference
$query4 = " CREATE TABLE IF NOT EXISTS external_users (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
userid INT UNSIGNED NOT NULL,
exten_for_external VARCHAR (150) DEFAULT NULL,
exten_for_ext_pass VARCHAR (2000) DEFAULT NULL,
conf_access_link LONGTEXT DEFAULT NULL,
CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `app_users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
); ";
$result4 = $mysqli->query($query4);
$_SESSION['validateaccess'] = "noaccessallowed";
$_SESSION['instcompleteaccess'] = "instaccess";
header("Location: roundpin-inst-complete.php");
}
}
?>
Roundpin Setup
Roundpin Setup
