function sql_main()
{
global $gbl, $sgbl, $login, $ghtml;
/*
self::$__fdb = mysql_connect($db_server, 'kloxo', getAdminPass());
mysql_select_db($sgbl->__var_dbf);
self::$__database = 'mysql';
*/
create_database();
create_general();
}
function create_main()
{
global $argc, $argv;
global $gbl, $sgbl, $login, $ghtml;
$opt = parse_opt($argv);
if (file_exists('/usr/local/lxlabs/.git')) {
$opt['development_found'] = '1';
}
lxfile_mkdir("{$sgbl->__path_program_etc}/conf");
lxfile_mkdir("{$sgbl->__path_program_root}/pid");
lxfile_mkdir("{$sgbl->__path_program_root}/log");
lxfile_mkdir("{$sgbl->__path_httpd_root}");
os_create_program_service();
if (isset($opt['admin-password'])) {
$admin_pass = $opt['admin-password'];
} else {
$admin_pass = '******';
}
if ($opt['install-type'] == 'master') {
if (!isset($opt['development_found'])) {
create_mysql_db('master', $opt, $admin_pass);
create_database();
create_general();
add_admin($admin_pass);
create_servername();
lxshell_return("__path_php_path", "../bin/collectquota.php");
} else {
print "Development GIT version found. Skipping creation from scratch of HyperVM-NG.\n";
}
print "Updating the system. Will take a while\n";
system("/usr/local/lxlabs/ext/php/php ../bin/common/updatecleanup-main.php --type=master");
} else {
if ($opt['install-type'] == 'slave') {
if (!isset($opt['development_found'])) {
init_slave($admin_pass);
} else {
print "Development GIT version found. Skipping creation from scratch of HyperVM-NG.\n";
}
print "Updating the system. Will take a while\n";
system("/usr/local/lxlabs/ext/php/php ../bin/common/updatecleanup-main.php --type=slave");
} else {
print "Unknown Install type\n";
flush();
}
}
system("rm -f /etc/sysconfig/network-scripts/ifcfg-*-range*");
//system("$sgbl->__path_php_path ../bin/misc/fixcentos5xen.php");
//os_fix_some_permissions();
system("cp ../sbin/lxxen ../sbin/lxopenvz /usr/bin");
system("chmod 4755 /usr/bin/lxxen /usr/bin/lxopenvz");
//os_set_iis_ftp_root_path();
}
function create_main()
{
global $argc, $argv;
global $gbl, $sgbl, $login, $ghtml;
$opt = parse_opt($argv);
lxfile_mkdir("{$sgbl->__path_program_etc}/conf");
lxfile_mkdir("{$sgbl->__path_program_root}/pid");
lxfile_mkdir("{$sgbl->__path_program_root}/log");
lxfile_mkdir("{$sgbl->__path_httpd_root}");
os_fix_lxlabs_permission();
os_create_program_service();
os_create_kloxo_service_once();
if (isset($opt['admin-password'])) {
$admin_pass = $opt['admin-password'];
} else {
$admin_pass = '******';
}
if ($opt['install-type'] == 'master') {
create_mysql_db('master', $opt, $admin_pass);
create_database();
create_general();
init_main($admin_pass);
lxshell_return("__path_php_path", "../bin/collectquota.php");
print "This will take a long time... Please wait...\n";
system("/usr/local/lxlabs/ext/php/php ../bin/common/tmpupdatecleanup.php --type=master");
} else {
if ($opt['install-type'] == 'slave') {
init_slave($admin_pass);
print "This will take a long time... Please wait...\n";
system("/usr/local/lxlabs/ext/php/php ../bin/common/tmpupdatecleanup.php --type=slave");
} else {
if ($opt['install-type'] == 'supernode') {
$sgbl->__path_sql_file = $sgbl->__path_sql_file_supernode;
$sgbl->__var_dbf = $sgbl->__path_supernode_db;
$sgbl->__path_admin_pass = $sgbl->__path_super_pass;
$sgbl->__var_admin_user = $sgbl->__var_super_user;
create_mysql_db('super', $opt, $admin_pass);
init_supernode($admin_pass);
print "\n";
} else {
print "Unknown Install type\n";
flush();
}
}
}
os_create_default_slave_driver_db();
os_fix_some_permissions();
}
}
$db_host = isset($_POST['dbhost']) ? trim($_POST['dbhost']) : '';
$db_port = isset($_POST['db_port']) ? trim($_POST['db_port']) : '';
$db_user = isset($_POST['dbuser']) ? trim($_POST['dbuser']) : '';
$db_pass = isset($_POST['dbpass']) ? trim($_POST['dbpass']) : '';
$db_name = isset($_POST['dbname']) ? trim($_POST['dbname']) : '';
$prefix = isset($_POST['db_prefix']) ? trim($_POST['db_prefix']) : 'ecs_';
$timezone = isset($_POST['timezone']) ? trim($_POST['timezone']) : 'Asia/Shanghai';
if (empty($db_host) || empty($db_user) || empty($db_pass) || empty($db_name)) {
data_back('缺少必要的参数');
}
$result = create_config_file($db_host, $db_port, $db_user, $db_pass, $db_name, $prefix, $timezone);
if ($result === false) {
data_back('构建配置文件失败');
}
$result = create_database($db_host, $db_port, $db_user, $db_pass, $db_name);
if ($result === false) {
data_back('创建数据库失败');
}
$system_lang = isset($_POST['system_lang']) ? $_POST['system_lang'] : 'zh_cn';
if (file_exists(ROOT_PATH . 'install/data/data_' . $system_lang . '.sql')) {
$data_path = ROOT_PATH . 'install/data/data_' . $system_lang . '.sql';
} else {
$data_path = ROOT_PATH . 'install/data/data_zh_cn.sql';
}
$sql_files = array(ROOT_PATH . 'install/data/structure.sql', $data_path);
$result = install_data($sql_files);
if ($result === false) {
data_back('构建数据库内容失败');
}
$admin_name = isset($_POST['admin_name']) ? json_str_iconv(trim($_POST['admin_name'])) : 'admin';
$_GET["db"] = "";
// to save in global history
queries_adminer_redirect(remove_from_uri("db|database"), lang('Database has been dropped.'), drop_databases(array(DB)));
} elseif (DB !== $name) {
// create or rename database
if (DB != "") {
$_GET["db"] = $name;
queries_adminer_redirect(preg_replace('~\\bdb=[^&]*&~', '', ME) . "db=" . urlencode($name), lang('Database has been renamed.'), rename_database($name, $row["collation"]));
} else {
$databases = explode("\n", str_replace("\r", "", $name));
$success = true;
$last = "";
foreach ($databases as $db) {
if (count($databases) == 1 || $db != "") {
// ignore empty lines but always try to create single database
if (!create_database($db, $row["collation"])) {
$success = false;
}
$last = $db;
}
}
queries_adminer_redirect(ME . "db=" . urlencode($last), lang('Database has been created.'), $success);
}
} else {
// alter database
if (!$row["collation"]) {
adminer_redirect(substr(ME, 0, -1));
}
query_adminer_redirect("ALTER DATABASE " . idf_escape($name) . (preg_match('~^[a-z0-9_]+$~i', $row["collation"]) ? " COLLATE {$row['collation']}" : ""), substr(ME, 0, -1), lang('Database has been altered.'));
}
}
die("Connection failed");
}
query_check('DROP DATABASE irremote;');
}
function create_database()
{
global $db;
$db = new mysqli(DB_SERVER, DB_USER, DB_PASS);
if ($db->connect_error) {
die("Connect failed");
}
query_check('CREATE DATABASE IF NOT EXISTS ' . DB_NAME);
query_check('USE ' . DB_NAME);
query_check('CREATE TABLE IF NOT EXISTS users (' . 'id int NOT NULL AUTO_INCREMENT,' . 'email VARCHAR(255) NOT NULL,' . 'username VARCHAR(32) NOT NULL,' . 'password VARCHAR(128) NOT NULL,' . 'reg_date TIMESTAMP NOT NULL DEFAULT NOW(),' . 'access_token VARCHAR(32),' . 'PRIMARY KEY (id)' . ');');
query_check('ALTER TABLE users AUTO_INCREMENT=10000;');
query_check('CREATE TABLE IF NOT EXISTS registrations (' . 'username VARCHAR(32) NOT NULL,' . 'email VARCHAR(255) NOT NULL,' . 'password VARCHAR(128) NOT NULL,' . 'reg_date TIMESTAMP NOT NULL DEFAULT NOW(),' . 'token CHAR(32) NOT NULL' . ');');
query_check('CREATE TABLE IF NOT EXISTS remotes (' . 'id int NOT NULL AUTO_INCREMENT,' . 'parent_id int,' . 'user_id int,' . 'manufacturer VARCHAR(64),' . 'model VARCHAR(64),' . 'device_type VARCHAR(64),' . 'PRIMARY KEY (id),' . 'FOREIGN KEY (parent_id) REFERENCES remotes(id),' . 'FOREIGN KEY (user_id) REFERENCES users(id)' . ');');
query_check('ALTER TABLE remotes AUTO_INCREMENT=10000;');
query_check('CREATE TABLE IF NOT EXISTS buttons (' . 'remote_id int,' . 'function VARCHAR(64),' . 'frequency int,' . 'pattern VARCHAR(32768),' . 'FOREIGN KEY (remote_id) REFERENCES remotes(id)' . ');');
query_check('CREATE TABLE IF NOT EXISTS ratings (' . 'remote_id int NOT NULL,' . 'user_id int NOT NULL,' . 'rating tinyint,' . 'FOREIGN KEY (remote_id) REFERENCES remotes(id),' . 'FOREIGN KEY (user_id) REFERENCES users(id)' . ');');
echo '<br><br>All OK';
}
if ($allow_db_creation) {
if (isset($_GET['drop_db'])) {
drop_database();
}
if (isset($_GET['create_db'])) {
create_database();
}
echo '<!DOCTYPE html>' . '<html>' . '<body>' . ' <form mehtod="get" action="create-db.php">' . ' <input hidden name="create_db" value="true">' . ' <button type="submit">Create db</button>' . ' </form><br>' . ' <form mehtod="get" action="create-db.php">' . ' <input hidden name="drop_db" value="true">' . ' <button type="submit">Drop db</button>' . ' </form>' . '</body>' . '</html>';
}
function install_step_3()
{
$db_address = _request('db_address');
$db_login = _request('db_login');
$db_password = _request('db_password');
global $lcm_db_version;
$install_log = "";
$upgrade_log = "";
// Possible errors will get trapped in the output buffer and displayed later,
// so that they don't mess up with headers/html.
ob_start();
if (_request('db_choice') == "__manual__") {
$sel_db = _request('manual_db');
} else {
$sel_db = _request('db_choice');
}
$link = lcm_connect_db($db_address, 0, $db_login, $db_password, $sel_db);
$io_output = ob_get_contents();
ob_end_clean();
if (!$link) {
install_html_start('AUTO', '', 3);
lcm_panic("connection denied: " . lcm_sql_error());
}
//
// TEMPORARY (used by testing the installer)
/*
lcm_query("DROP TABLE lcm_case", true);
lcm_query("DROP TABLE lcm_case_attachment", true);
lcm_query("DROP TABLE lcm_stage", true);
lcm_query("DROP TABLE lcm_followup", true);
lcm_query("DROP TABLE lcm_author", true);
lcm_query("DROP TABLE lcm_client", true);
lcm_query("DROP TABLE lcm_client_attachment", true);
lcm_query("DROP TABLE lcm_org", true);
lcm_query("DROP TABLE lcm_org_attachment", true);
lcm_query("DROP TABLE lcm_contact", true);
lcm_query("DROP TABLE lcm_keyword", true);
lcm_query("DROP TABLE lcm_keyword_case", true);
lcm_query("DROP TABLE lcm_keyword_client", true);
lcm_query("DROP TABLE lcm_keyword_org", true);
lcm_query("DROP TABLE lcm_keyword_group", true);
lcm_query("DROP TABLE lcm_report", true);
lcm_query("DROP TABLE lcm_fields", true);
lcm_query("DROP TABLE lcm_filter", true);
lcm_query("DROP TABLE lcm_app", true);
lcm_query("DROP TABLE lcm_app_client_org", true);
lcm_query("DROP TABLE lcm_app_fu", true);
lcm_query("DROP TABLE lcm_author_app", true);
lcm_query("DROP TABLE lcm_case_client_org", true);
lcm_query("DROP TABLE lcm_case_author", true);
lcm_query("DROP TABLE lcm_client_org", true);
lcm_query("DROP TABLE lcm_rep_col", true);
lcm_query("DROP TABLE lcm_rep_line", true);
lcm_query("DROP TABLE lcm_rep_filters", true);
lcm_query("DROP TABLE lcm_filter_conds", true);
lcm_query("DROP TABLE lcm_rep_filter", true);
lcm_query("DROP TABLE lcm_meta", true);
*/
// Test if the software was already installed
$result = lcm_query("SELECT * FROM lcm_meta", true);
$already_installed = !lcm_sql_errno() && lcm_num_rows($result);
$old_lcm_version = 'NONE';
if ($already_installed) {
lcm_log("LCM already installed", 'install');
// Find the current database version
$old_lcm_db_version = 0;
$query = "SELECT value FROM lcm_meta WHERE name = 'lcm_db_version'";
$result = lcm_query_db($query);
while ($row = lcm_fetch_array($result)) {
$old_lcm_db_version = $row['value'];
}
lcm_log("LCM version installed is {$old_lcm_db_version}", 'install');
// Check if upgrade is needed
if ($old_lcm_db_version < $lcm_db_version) {
lcm_log("Calling the upgrade procedure (since < {$lcm_db_version})", 'install');
include_lcm('inc_db_upgrade');
$upgrade_log = upgrade_database($old_lcm_db_version);
} else {
lcm_log("Upgrade _not_ called, looks OK (= {$lcm_db_version})", 'install');
}
} else {
lcm_log("Creating the database from scratch", 'install');
include_lcm('inc_db_create');
$install_log .= create_database();
lcm_log("DB creation complete", 'install');
}
// Create default meta + keywords
include_lcm('inc_meta');
include_lcm('inc_keywords_default');
include_lcm('inc_meta_defaults');
init_default_config();
init_languages();
$skwg = get_default_keywords();
create_groups($skwg);
write_metas();
// regenerate inc/data/inc_meta_cache.php
// Test DB: not used for now..
include_lcm('inc_db_test');
$structure_ok = lcm_structure_test();
if (!empty($install_log)) {
install_html_start('AUTO', '', 3);
echo "<h3><small>" . _T('install_step_three') . "</small> " . _T('install_title_creating_database') . "</h3>\n";
echo "<div class='box_error'>\n";
echo "<p>";
echo "<b>" . _T('warning_operation_failed') . "</b> " . _T('install_database_install_failed');
echo " " . lcm_help("install_connection") . "</p>\n";
echo "</div>\n";
// Dump error listing
echo put_text_in_textbox($install_log);
install_html_end();
} else {
if (!empty($upgrade_log)) {
install_html_start('AUTO', '', 3);
echo "<h3><small>" . _T('install_step_three') . "</small> " . _T('install_title_creating_database') . "</h3>\n";
echo "<div class='box_error'>\n";
echo "<p>" . _T('install_warning_update_impossible', array('old_version' => $old_lcm_version, 'version' => $lcm_version)) . "</p>\n";
echo "</div>\n";
// Dump error listing
echo put_text_in_textbox($upgrade_log);
install_html_end();
} else {
if (!$structure_ok) {
install_html_start('AUTO', '', 3);
echo "<h3><small>" . _T('install_step_three') . "</small> " . _T('install_title_creating_database') . "</h3>\n";
echo "<div class='box_error'>\n";
echo "<p> STRUCTURE PROBLEM </p>\n";
// TRAD
echo "</div>\n";
install_html_end();
} else {
// Everything OK
$conn = '<' . '?php' . "\n";
$conn .= "if (defined('_CONFIG_INC_CONNECT')) return;\n";
$conn .= "define('_CONFIG_INC_CONNECT', '1');\n";
$conn .= "\$GLOBALS['lcm_connect_version'] = 0.1;\n";
$conn .= "include_lcm('inc_db');\n";
$conn .= "@lcm_connect_db('{$db_address}','','{$db_login}','{$db_password}','{$sel_db}');\n";
$conn .= "\$GLOBALS['db_ok'] = !!@lcm_num_rows(@lcm_query_db('SELECT COUNT(*) FROM lcm_meta'));\n";
$conn .= '?' . '>';
$lcm_config_prefix = isset($_SERVER['LcmConfigDir']) ? $_SERVER['LcmConfigDir'] : 'inc/config';
$myFile = fopen($lcm_config_prefix . '/inc_connect_install.php', 'wb');
fputs($myFile, $conn);
fclose($myFile);
install_step_4();
}
}
}
}
<?php
require 'create_db.php';
if (isset($_POST['hostname']) && isset($_POST['username']) && isset($_POST['password']) && isset($_POST['database']) && !empty($_POST['hostname']) && !empty($_POST['username']) && !empty($_POST['password']) && !empty($_POST['database'])) {
$server = trim($_POST['hostname']);
$user = trim($_POST['username']);
$password = trim($_POST['password']);
$db = trim($_POST['database']);
create_database($server, $user, $password, $db);
$file = fopen($_SERVER['DOCUMENT_ROOT'] . "/connect.php", "w") or die("Unable to open file!");
$content = '<?php
error_reporting(0);
$connection = new mysqli("' . $server . '","' . $user . '","' . $password . '","' . $db . '");
if($connection->connect_errno) {
die("Sorry, we are having some problems!");
}
?>';
fwrite($file, $content);
fclose($file);
} else {
echo "All fields are mandatory!";
}
/**
* 选择数据库
* @param string $dbName
* @return
*/
private function selectDb($dbName)
{
// 设置数据库字符集
mysql_query('SET NAMES "utf8"');
// 打开指定的数据库
if (!mysql_select_db($dbName, $this->conn)) {
// 指定数据库不存在，创建数据库
if (!create_database($dbName, $this->conn)) {
$this->closeDb();
// 没有权限创建数据库
$this->ajaxReturn(array('step' => 0, 'info' => '没有权限创建数据库！'));
}
if ($this->step == 0) {
$this->closeDb();
// 创建数据库成功
$data = array('step' => 1, 'info' => "成功创建数据库:{$dbName}<br>");
$this->ajaxReturn($data);
}
}
}
$_GET["db"] = "";
// to save in global history
queries_redirect(remove_from_uri("db|database"), lang('Database has been dropped.'), drop_databases(array(DB)));
} elseif (DB !== $name) {
// create or rename database
if (DB != "") {
$_GET["db"] = $name;
queries_redirect(preg_replace('~db=[^&]*&~', '', ME) . "db=" . urlencode($name), lang('Database has been renamed.'), rename_database($name, $_POST["collation"]));
} else {
$databases = explode("\n", str_replace("\r", "", $name));
$success = true;
$last = "";
foreach ($databases as $db) {
if (count($databases) == 1 || $db != "") {
// ignore empty lines but always try to create single database
if (!create_database($db, $_POST["collation"])) {
$success = false;
}
$last = $db;
}
}
queries_redirect(ME . "db=" . urlencode($last), lang('Database has been created.'), $success);
}
} else {
// alter database
if (!$_POST["collation"]) {
redirect(substr(ME, 0, -1));
}
query_redirect("ALTER DATABASE " . idf_escape($name) . (eregi('^[a-z0-9_]+$', $_POST["collation"]) ? " COLLATE {$_POST['collation']}" : ""), substr(ME, 0, -1), lang('Database has been altered.'));
}
}
<?php
include 'installUtil.php';
$dbhost = test_input($_POST['dbhost']);
$dbport = test_input($_POST['dbport']);
$dbname = test_input($_POST['dbname']);
$dbusername = test_input($_POST['dbusername']);
$dbpassword = test_input($_POST['dbpassword']);
$adminpassword = test_input($_POST['adminpassword']);
if ($dbport == null) {
$dbport = "3306";
}
if ($dbhost == null || $dbname == null || $dbusername == null || $adminpassword == null) {
header("Location: configure.php?error=param");
exit;
}
if (file_exists(__DIR__ . '/../../app/config/parameters.yml')) {
header("Location: configure.php?error=already");
exit;
}
//Testing mysql connection
$link = mysqli_connect($dbhost, $dbusername, $dbpassword, null, $dbport);
if (!$link) {
header("Location: configure.php?error=bdd");
exit;
}
create_database($link, $dbname);
import_dump($link, $dbname);
mysqli_close($link);
//Generating parameter.yml file
generateParameters($dbhost, $dbport, $dbname, $dbusername, $dbpassword, $adminpassword);
}
if (isset($_POST['new_db'])) {
// new DB is to be created, approach depends on version of API
if (min_version("0.1.2-Beta-02")) {
// version is new enough to handle action by SQL
$db = new Database(ROOT_DATABASE);
$query = "CREATE DATABASE " . $_POST['new_db'];
if ($db->executeQuery($query)) {
$_GET['show'] = "database_details";
$_GET['db'] = $_POST['new_db'];
eval("\$gui_message .= \"" . gettemplate("message_db_created_sql") . "\";");
}
unset($db);
} else {
// version is too old, must fall back to system functions instead of SQL
if (create_database($_POST['new_db'])) {
$_GET['show'] = "database_details";
$_GET['db'] = $_POST['new_db'];
}
}
}
if (isset($_GET['delete_db'])) {
// DB is to be deleted, approach depends on version of API
if (isset($_POST['confirm'])) {
if ($_POST['confirm'] == "OK") {
if (min_version("0.1.2-Beta-02")) {
// version is new enough to handle action by SQL
$db = new Database(ROOT_DATABASE);
$query = "DROP DATABASE " . $_GET['delete_db'];
if ($db->executeQuery($query)) {
eval("\$gui_message .= \"" . gettemplate("message_db_deleted_sql") . "\";");
/** Rename database from DB
* @param string new name
* @param string
* @return bool
*/
function rename_database($name, $collation)
{
$return = false;
if (create_database($name, $collation)) {
//! move triggers
$rename = array();
foreach (tables_list() as $table => $type) {
$rename[] = table($table) . " TO " . idf_escape($name) . "." . table($table);
}
$return = !$rename || queries("RENAME TABLE " . implode(", ", $rename));
if ($return) {
queries("DROP DATABASE " . idf_escape(DB));
}
restart_session();
set_session("dbs", null);
}
return $return;
}
?>
<td class="error">MySQL Error - <?php
echo $sql_error['Text'];
?>
</td>
<?php
}
?>
</tr>
<?php
if ($sql_error['Code'] == 1049) {
?>
<tr>
<td>Create Database</td>
<?php
if (!($sql_error = create_database($db_name, $db_host, $db_username, $db_password))) {
?>
<td class="success">We were able to create the database - <?php
echo $db_name;
?>
</td>
<?php
$fail = FALSE;
?>
<?php
} else {
$fail = TRUE;
?>
<td class="error">MySQL Error - <?php
echo $sql_error['Text'];
# templates table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_EMAIL_STORAGE_DATABASE . ".`" . NQ_EMAIL_STORAGE_TABLE_PREFIX . "templates`\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\t`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID in the table', \n\t\t\t\t\t\t\t`app_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID of the user who created the template', \n\t\t\t\t\t\t\t`environment` char(5) NOT NULL DEFAULT 'prod', \n\t\t\t\t\t\t\t`requires_unsubscribe` bit(1) NOT NULL DEFAULT b'1', \n\t\t\t\t\t\t\t`tag` char(25) NOT NULL, \n\t\t\t\t\t\t\t`subject` char(255) NOT NULL DEFAULT '' COMMENT 'The subject portion of the email', \n\t\t\t\t\t\t\t`body` text NOT NULL COMMENT 'The body of the email', \n\t\t\t\t\t\t\t`bcc` char(255) NOT NULL, \n\t\t\t\t\t\t\t`track` bit(1) NOT NULL DEFAULT b'1', \n\t\t\t\t\t\t\t`locked` bit(1) NOT NULL DEFAULT b'0', \n\t\t\t\t\t\t\t`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, \n\t\t\t\t\t\t\tPRIMARY KEY (`id`), \n\t\t\t\t\t\t\tUNIQUE KEY `app_tag` (`app_id`, `environment`, `tag`), \n\t\t\t\t\t\t\tKEY `app_name` (`app_id`, `environment`)\n\t\t\t\t\t\t)\n\t\t\t\t\tENGINE = InnoDB DEFAULT CHARSET = latin1;";
create_table($G_FILE_STORAGE_DBLINK, $query, $G_OUTPUT_RESULTS);
# templates_archived table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_EMAIL_STORAGE_DATABASE . ".`" . NQ_EMAIL_STORAGE_TABLE_PREFIX . "templates_archived`\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\t`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID in the table', \n\t\t\t\t\t\t\t`app_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID of the user who created the template', \n\t\t\t\t\t\t\t`environment` char(5) NOT NULL, \n\t\t\t\t\t\t\t`requires_unsubscribe` bit(1) NOT NULL DEFAULT b'1', \n\t\t\t\t\t\t\t`tag` char(25) NOT NULL, \n\t\t\t\t\t\t\t`subject` char(255) NOT NULL DEFAULT '' COMMENT 'The subject portion of the email', \n\t\t\t\t\t\t\t`body` text NOT NULL COMMENT 'The body of the email', \n\t\t\t\t\t\t\t`bcc` char(255) NOT NULL, \n\t\t\t\t\t\t\t`track` bit(1) NOT NULL DEFAULT b'1', \n\t\t\t\t\t\t\t`locked` bit(1) NOT NULL DEFAULT b'0', \n\t\t\t\t\t\t\t`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, \n\t\t\t\t\t\t\tPRIMARY KEY (`id`)\n\t\t\t\t\t\t)\n\t\t\t\t\tENGINE = InnoDB DEFAULT CHARSET = latin1;";
create_table($G_FILE_STORAGE_DBLINK, $query, $G_OUTPUT_RESULTS);
}
/* ----- End Email Tables ----- */
/* ----- Start Tracking Tables ----- */
# If we are going to install the tracking tables
if (INSTALL_TABLES && isset($_POST['tracking_mysql_install']) && $_POST['tracking_mysql_install'] != '') {
# Controller tracking header
create_header('Controller Tracking Database', $G_OUTPUT_RESULTS);
# Tracking Storage database
$query = "CREATE DATABASE IF NOT EXISTS " . NQ_TRACKING_DATABASE;
create_database($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
# analytics_database_table_io table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_TRACKING_DATABASE . ".`" . NQ_TRACKING_TABLE_PREFIX . "analytics_database_table_io`\n\t\t\t\t\t\t(\n\t\t \t\t\t\t\t`app_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`environment` enum( '*', 'prod', 'beta', 'alpha', 'dev' ) NOT NULL, \n\t\t \t\t\t\t\t`table_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`reads` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`read_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`writes` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`write_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`deletes` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`delete_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`created` datetime NOT NULL, \n\t\t \t\t\t\t\tKEY `table_environment_created` ( `table_id`, `environment`, `created` )\n\t\t \t\t\t\t)\n\t\t\t\t\tENGINE = MEMORY DEFAULT CHARSET = latin1;";
create_table($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
# analytics_database_table_io_summary table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_TRACKING_DATABASE . ".`" . NQ_TRACKING_TABLE_PREFIX . "analytics_database_table_io_summary`\n\t\t\t\t\t\t(\n\t\t \t\t\t\t\t`app_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`environment` enum( '*', 'prod', 'beta', 'alpha', 'dev' ) NOT NULL, \n\t\t \t\t\t\t\t`table_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`reads` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`read_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`writes` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`write_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`deletes` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`delete_rows` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`created` datetime NOT NULL, \n\t\t \t\t\t\t\tKEY `app_id` ( `app_id`, `table_id`, `created`, `environment` )\n\t\t \t\t\t\t)\n\t\t\t\t\tENGINE = InnoDB DEFAULT CHARSET = latin1;";
create_table($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
# analytics_eails_blocked table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_TRACKING_DATABASE . ".`" . NQ_TRACKING_TABLE_PREFIX . "analytics_emails_blocked`\n\t\t\t\t\t\t(\n\t\t \t\t\t\t\t`id` int(10) unsigned NOT NULL AUTO_INCREMENT, \n\t\t \t\t\t\t\t`app_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`template_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`sender` char(75) NOT NULL, \n\t\t \t\t\t\t\t`recipient` char(75) NOT NULL, \n\t\t \t\t\t\t\t`created` datetime NOT NULL, \n\t\t \t\t\t\t\tPRIMARY KEY (`id`)\n\t\t \t\t\t\t)\n\t\t\t\t\tENGINE = InnoDB DEFAULT CHARSET = latin1;";
create_table($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
# analytics_email_sent table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_TRACKING_DATABASE . ".`" . NQ_TRACKING_TABLE_PREFIX . "analytics_emails_sent`\n\t\t\t\t\t\t(\n\t\t \t\t\t\t\t`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, \n\t\t \t\t\t\t\t`hash_id` char(64) NOT NULL, \n\t\t \t\t\t\t\t`app_id` int(10) unsigned NOT NULL DEFAULT '0', \n\t\t \t\t\t\t\t`template_id` int(10) unsigned NOT NULL DEFAULT '0', \n\t\t \t\t\t\t\t`sender` char(75) NOT NULL DEFAULT '', \n\t\t \t\t\t\t\t`recipient` char(75) NOT NULL DEFAULT '', \n\t\t \t\t\t\t\t`requested_date` datetime NOT NULL, \n\t\t \t\t\t\t\t`sent_date` datetime NOT NULL, \n\t\t \t\t\t\t\t`read` bit(1) NOT NULL, \n\t\t \t\t\t\t\t`read_date` datetime NOT NULL, \n\t\t \t\t\t\t\t`created` datetime NOT NULL, \n\t\t \t\t\t\t\tPRIMARY KEY (`id`), \n\t\t \t\t\t\t\tKEY `app_created_sender` (`app_id`, `created`, `sender`), \n\t\t \t\t\t\t\tKEY `hash_id` (`hash_id`)\n\t\t\t\t\t\t)\n\t\t\t\t\tENGINE = InnoDBDEFAULT CHARSET = latin1;";
create_table($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
# api_calls_database table
$query = "\tCREATE TABLE IF NOT EXISTS " . NQ_TRACKING_DATABASE . ".`" . NQ_TRACKING_TABLE_PREFIX . "api_calls_database`\n\t\t\t\t\t\t(\n\t\t \t\t\t\t\t`app_id` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`environment` char(5) NOT NULL, \n\t\t \t\t\t\t\t`endpoint` enum( 'fetch', 'insert', 'update', 'delete', 'replicate', 'tables', 'structure', 'table', 'privilages', 'indices', 'update_primary', 'tables_diff' ) NOT NULL, \n\t\t \t\t\t\t\t`receive_size` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`send_size` int(10) unsigned NOT NULL, \n\t\t \t\t\t\t\t`send_time` float unsigned NOT NULL, \n\t\t \t\t\t\t\t`complete_time` float unsigned NOT NULL, \n\t\t \t\t\t\t\t`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, \n\t\t \t\t\t\t\tKEY `app_type_created` ( `app_id`, `created`, `environment` )\n\t\t \t\t\t\t)\n\t\t \t\t\tENGINE = InnoDB DEFAULT CHARSET = latin1;";
create_table($G_TRACKING_DBLINK, $query, $G_OUTPUT_RESULTS);
my_mysql_query('SET NAMES utf8', $conn);
$tables = array();
$res = my_mysql_query('SHOW TABLES FROM ' . $s['MYSQL_DBNAME'], $conn);
if (my_mysql_num_rows($res)) {
while ($tbl = my_mysql_fetch_row($res)) {
$tables[] = $tbl[0];
}
}
$convert_version = FALSE;
if (isset($OLDC->VERSION)) {
$convert_version = $OLDC->VERSION;
} elseif (file_exists(INCPATH . '../../include/conf_main.php') && in_array('users_watched', $tables)) {
$convert_version = 'unofficial';
}
require_once INCPATH . 'func_database.php';
$res = create_database($convert_version);
if (!$res) {
$error = TRUE;
$errmsg = 'V4dCBldm';
}
}
if (!$error) {
if ($convert_version == 'unofficial') {
$resize = array();
$path = INCPATH . '../../i/attachments/1/';
$dir = opendir($path);
while ($file = readdir($dir)) {
if ($file == '.' || $file == '..') {
continue;
}
if (FALSE === strpos($file, '_thumb.')) {