break;
}
## TABLE KB_ITEMS
$res = mysqli_query($dbTmp, "CREATE TABLE IF NOT EXISTS `" . $_SESSION['tbl_prefix'] . "kb_items` (\n `kb_id` tinyint(12) NOT NULL,\n `item_id` tinyint(12) NOT NULL\n );");
if ($res) {
echo 'document.getElementById("tbl_12").innerHTML = ' . '"<img src=\\"images/tick.png\\">";';
} else {
echo 'document.getElementById("res_step4").innerHTML = ' . '"An error appears on table KB_ITEMS!";';
echo 'document.getElementById("tbl_12").innerHTML = ' . '"<img src=\\"images/exclamation-red.png\\">";';
echo 'document.getElementById("loader").style.display = "none";';
mysqli_close($dbTmp);
break;
}
## TABLE restriction_to_roles
$res = mysqli_query($dbTmp, "CREATE TABLE IF NOT EXISTS `" . $_SESSION['tbl_prefix'] . "restriction_to_roles` (\n `role_id` tinyint(12) NOT NULL,\n `item_id` tinyint(12) NOT NULL\n ) CHARSET=utf8;");
$res = addIndexIfNotExist($_SESSION['tbl_prefix'] . 'restriction_to_roles', 'role_id_idx', 'ADD INDEX `role_id_idx` (`role_id`)');
if ($res) {
echo 'document.getElementById("tbl_13").innerHTML = ' . '"<img src=\\"images/tick.png\\">";';
} else {
echo 'document.getElementById("res_step4").innerHTML = ' . '"An error appears on table restriction_to_roles!";';
echo 'document.getElementById("tbl_13").innerHTML = ' . '"<img src=\\"images/exclamation-red.png\\">";';
echo 'document.getElementById("loader").style.display = "none";';
mysqli_close($dbTmp);
break;
}
## TABLE Languages
$res = mysqli_query($dbTmp, "CREATE TABLE IF NOT EXISTS `" . $_SESSION['tbl_prefix'] . "languages` (\n `id` INT(10) NOT null AUTO_INCREMENT PRIMARY KEY ,\n `name` VARCHAR(50) NOT null ,\n `label` VARCHAR(50) NOT null ,\n `code` VARCHAR(10) NOT null ,\n `flag` VARCHAR(30) NOT NULL\n ) CHARSET=utf8;");
$resTmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM " . $_SESSION['tbl_prefix'] . "languages"));
mysqli_query($dbTmp, "TRUNCATE TABLE " . $_SESSION['tbl_prefix'] . "languages");
mysqli_query($dbTmp, "INSERT IGNORE INTO `" . $_SESSION['tbl_prefix'] . "languages`\n (`id`, `name`, `label`, `code`, `flag`) VALUES\n ('', 'french', 'French' , 'fr', 'fr.png'),\n ('', 'english', 'English' , 'us', 'us.png'),\n ('', 'spanish', 'Spanish' , 'es', 'es.png'),\n ('', 'german', 'German' , 'de', 'de.png'),\n ('', 'czech', 'Czech' , 'cz', 'cz.png'),\n ('', 'italian', 'Italian' , 'it', 'it.png'),\n ('', 'russian', 'Russian' , 'ru', 'ru.png'),\n ('', 'turkish', 'Turkish' , 'tr', 'tr.png'),\n ('', 'norwegian', 'Norwegian' , 'no', 'no.png'),\n ('', 'japanese', 'Japanese' , 'ja', 'ja.png'),\n ('', 'portuguese', 'Portuguese' , 'pr', 'pr.png'),\n ('', 'chinese', 'Chinese' , 'cn', 'cn.png'),\n ('', 'swedish', 'Swedish' , 'se', 'se.png'),\n ('', 'dutch', 'Dutch' , 'nl', 'nl.png'),\n ('', 'catalan', 'Catalan' , 'ct', 'ct.png'),\n ('', 'vietnamese', 'Vietnamese' , 'vi', 'vi.png');");
if ($res) {
## TABLE restriction_to_roles
$res = mysqli_query($dbTmp, "CREATE TABLE IF NOT EXISTS `" . $_SESSION['tbl_prefix'] . "restriction_to_roles` (\n `role_id` tinyint(12) NOT NULL,\n `item_id` tinyint(12) NOT NULL\n ) CHARSET=utf8;");
$res = addIndexIfNotExist($_SESSION['tbl_prefix'] . 'restriction_to_roles', 'role_id_idx', 'ADD INDEX `role_id_idx` (`role_id`)');
if ($res) {
echo 'document.getElementById("tbl_13").innerHTML = ' . '"<img src=\\"images/tick.png\\">";';
} else {
echo 'document.getElementById("res_step4").innerHTML = ' . '"An error appears on table restriction_to_roles!";';
echo 'document.getElementById("tbl_13").innerHTML = ' . '"<img src=\\"images/exclamation-red.png\\">";';
echo 'document.getElementById("loader").style.display = "none";';
mysqli_close($dbTmp);
break;
}
## TABLE keys
$res = mysqli_query($dbTmp, "CREATE TABLE IF NOT EXISTS `" . $_SESSION['tbl_prefix'] . "keys` (\n `sql_table` varchar(25) NOT NULL,\n `id` int(20) NOT NULL,\n `rand_key` varchar(25) NOT NULL\n ) CHARSET=utf8;");
// add index to table if not already exists
$res = addIndexIfNotExist($_SESSION['tbl_prefix'] . 'keys', 'rand_key_id_idx', 'ADD UNIQUE KEY `rand_key_id_idx` (`rand_key`,`id`)');
$resTmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM " . $_SESSION['tbl_prefix'] . "keys"));
if ($res && $resTmp[0] == 0) {
echo 'document.getElementById("tbl_14").innerHTML = ' . '"<img src=\\"images/tick.png\\">";';
//increase size of PW field in ITEMS table
mysqli_query($dbTmp, "ALTER TABLE " . $_SESSION['tbl_prefix'] . "items MODIFY pw VARCHAR(400)");
//Populate table KEYS
//create all keys for all items
$rows = mysqli_query($dbTmp, "SELECT * FROM " . $_SESSION['tbl_prefix'] . "items WHERE perso = 0");
while ($reccord = mysqli_fetch_array($rows)) {
if (!empty($reccord['pw'])) {
//get pw
$pw = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, SALT, base64_decode($reccord['pw']), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)));
//generate random key
$randomKey = substr(md5(rand() . rand()), 0, 15);
//Store generated key
