function installMain(&$s)
{
global $lll;
global $hostName, $dbUser, $dbUserPw, $dbName, $dbPort, $dbSocket;
global $scriptName;
global $cookiePath;
global $phpVersionMin, $mySqlVersionMin;
$s = "";
showInstallHeader($s1);
$s .= $s1;
// Ezt azert kommentezem ki, mert gyakran ujrainstallalok ugy hogy elozoleg
// john-kent be voltam jelentkezve. Ilyen esetben mindig john
// id-jevel hozta letre eloszor az admint, majd amikor john
// letrehozasara kerult a sor, akkor hibat adott az install mondvan,
// hogy ilyen id-ju juzer mar letezik:
//if (!isset($_COOKIE["globalUserId"]))
//{
mt_srand((double) microtime() * 1000000);
global $randIdMax, $randIdMin;
if (!isset($randIdMin)) {
$randIdMin = 0;
}
if (!isset($randIdMax)) {
$randIdMax = getrandmax();
}
$randomId = (int) mt_rand($randIdMin, $randIdMax);
setcookie("globalUserId", $randomId, Loginlib_ExpirationDate, $cookiePath);
$_COOKIE["globalUserId"] = $randomId;
//}
if (isset($_POST["edit"])) {
$s .= showEditForm(TRUE);
return;
}
//if( isset($_POST["submit"]) &&
// $_POST["submit"]==$lll["install"] )
//{
//check file creation
$ret = checkFileCreate();
if ($ret == ok) {
iPrint($lll["create_file_ok"], "ok", $sp);
$s .= $sp;
$createconf = TRUE;
} else {
if (!isset($_POST["confirm"])) {
iPrint($lll["create_file_nok_ext"], "warn", $sp);
} else {
iPrint($lll["create_file_nok"], "warn", $sp);
}
$s .= $sp;
$createconf = FALSE;
}
//check mysql connection
$db->hostName = $hostName;
$db->user = $dbUser;
$db->password = $dbUserPw;
$db->port = $dbPort;
$db->socket = $dbSocket;
$connectRet = checkMysql($db, $s1);
$s .= $s1;
if ($connectRet == ok) {
iPrint($lll["mysql_found"], "ok", $sp);
$s .= $sp;
$connectok = TRUE;
$pwok = TRUE;
} elseif ($connectRet == mysql_access_denied) {
iPrint($lll["mysql_found"], "ok", $sp);
$s .= $sp;
if ($dbUserPw == "") {
iPrint(sprintf($lll["need_pw"], $dbUser), "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
} else {
iPrint(sprintf($lll["incorr_pw"], $dbUser), "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
}
} else {
iPrint($lll["mysql_not_found"] . " (" . mysql_error() . ")", "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
}
if (!DbInstall::checkComponentVersions($mySqlVersion, $phpVersion)) {
iPrint(sprintf($lll["versionTooLow"], $mySqlVersionMin, $mySqlVersion, $phpVersionMin, $phpVersion), "err", $sp);
$s .= $sp;
return ok;
}
if (!isset($_POST["confirm"])) {
$s .= showAskConfirm();
return ok;
}
if (isset($_COOKIE["globalUserId"])) {
iPrint($lll["cookieok"], "ok", $sp);
$s .= $sp;
} else {
iPrint($lll["cookienok"], "err", $sp);
$s .= $sp;
return;
}
//check if db exists
$ret = mysql_select_db($dbName);
if ($ret) {
iPrint(sprintf($lll["db_installed"], $dbName), "ok", $sp);
$s .= $sp;
} else {
$ret = createDb();
if ($ret != ok) {
$s1 = sprintf($lll["cantcreatedb"], $dbUser);
iPrint($s1, "warn", $sp);
$s .= $sp;
return ok;
} else {
iPrint(sprintf($lll["db_created"], $dbName), "ok", $sp);
$s .= $sp;
//select db
$ret = mysql_select_db($dbName);
}
}
$ret = DbInstall::installCreateTables();
if ($ret != ok) {
iPrint($lll["inst_create_table_err"], "err", $sp);
$s .= $sp;
return $ret;
} else {
iPrint($lll["tables_installed"], "ok", $sp);
$s .= $sp;
}
createFirstAdmin();
appFillTables();
iPrint($lll["tables_filled"], "ok", $sp);
$s .= $sp;
if ($createconf) {
//config file can be generated
$ret = writeConfigFile($s1);
if ($ret != ok) {
$s .= $s1;
return;
}
} else {
//config can't be created
iPrint($lll["compare_conf"], "warn", $sp);
$s .= $sp;
showConfFileHtml($s1);
$s .= $s1;
iPrint($lll["afterwrconf"], "warn", $s1);
$s .= $s1;
}
iPrint($lll["move_inst_file"], "warn", $s1);
$s .= $s1;
iPrint(sprintf($lll["congrat"], "Noah's Classifieds"), "hurra", $s1);
$s .= $s1;
iPrint($lll["inst_ch_pw"], "warn", $s1);
$s .= $s1;
//send him to the application:
$s .= "<a href='{$scriptName}'>" . sprintf($lll["inst_click"], "Noah's Classifieds") . "</a>";
return ok;
}
define("T_4_PASSWORD", "Password");
define("T_4_USER", "User");
define("T_4_PSWD", "Pswd");
// Declarations =====================================
// Always use database: users
$_SESSION['a4_db'] = 'users';
// read SESSION parameters ===============================
$sel_db = $_SESSION['a4_db'];
$sel_object = $_SESSION['a4_object_id'];
$sel_name = $_SESSION['a4_object_name'];
$super = $_SESSION['super'];
$par['super'] = $super;
// Initiate database if necessary
$file = getXmlFileName($sel_db);
if (!file_exists($file)) {
createDb($sel_db, 4);
$sel_object = 1;
$_SESSION['a4_db'] = $sel_db;
$_SESSION['a4_object'] = $sel_object;
echo "Database initiated !";
$user_id = getNextNodeId($sel_db);
createObject($sel_db, 1, 'admin', $user_id);
// Admin username
setObjectText($sel_db, $user_id, 'amazon');
// default password
}
// GET ==============================================
$temp = $_GET['a4_object_id'];
if ($temp) {
$sel_object = $temp;
$sel_name = getObjectName($sel_db, $sel_object);
require_once dirname(__FILE__) . '/../bootstrap/unit.php';
if (!checkMysql()) {
return true;
}
$t = new lime_test(3);
$t->comment('Mysql Drop Command');
// Setup
createAdminUser($mysqlAdminUsername, $mysqlAdminPassword, $tempAdminUsername, $tempAdminPassword);
createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
$t->comment('MysqlDropCommand executed by admin user with password');
$cmd = new nbMysqlDropCommand();
$commandLine = sprintf('%s %s %s', $dbName, $tempAdminUsername, $tempAdminPassword);
$t->ok($cmd->run(new nbCommandLineParser(), $commandLine), 'MysqlDrop executed successfully');
//TearDown
dropDatabaseUser($mysqlAdminUsername, $mysqlAdminPassword, $tempAdminUsername);
// Setup
createAdminUser($mysqlAdminUsername, $mysqlAdminPassword, $tempAdminUsernameWithNoPassword);
createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
$t->comment('MysqlDropCommand executed by admin user without password');
$cmd = new nbMysqlDropCommand();
$commandLine = sprintf('%s %s', $dbName, $tempAdminUsernameWithNoPassword);
$t->ok($cmd->run(new nbCommandLineParser(), $commandLine), 'MysqlDrop executed successfully');
//TearDown
dropDatabaseUser($mysqlAdminUsername, $mysqlAdminPassword, $tempAdminUsernameWithNoPassword);
// Setup
createDb($mysqlAdminUsername, $mysqlAdminPassword, $dbName);
$cmd = new nbMysqlDropCommand();
$parser = new nbCommandLineParser();
$parser->setDefaultConfigurationDirs(dirname(__FILE__) . '/../data/config');
$commandLine = '--config-file=mysql-plugin.yml';
$t->ok($cmd->run($parser, $commandLine), 'MysqlDrop executed successfully from config file');
$a6pr = array();
//====================================================
// GET
//====================================================
$par['a6_sid'] = $_GET['sid'];
//====================================================
// POST
//====================================================
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$post_action = $_POST['a6_post_action'];
$sid = $_POST['a6_sid'];
if ($post_action == 'a6_post_create_list') {
$sel_db = $_POST['a6_db'];
$a6pr[$sys_id]['a6_db'] = $sel_db;
if ($sel_db) {
createDb($sel_db, 6);
//$sel_object = 1;
$a6pr[$sys_id]['a6_object'] = 1;
} else {
$g_error = 10;
}
}
}
//====================================================
// HTMLfunctions
//====================================================
function viking_6_createList_Link($sys_id)
{
global $par;
$sid = $par['a6_sid'];
$path = $par['path'];
$dbUser = $_POST['databaseLogin'];
$dbPassword = $_POST['databasePassword1'];
$dbConfirm = $_POST['databasePassword2'];
$connectionString = sprintf('mysql:host=%s;port=%d', $host, $port);
if (!empty($dbPassword) && $dbPassword === $dbConfirm) {
try {
$pdo = new PDO($connectionString, $root, $rootPass);
$template = str_replace('{host}', "'{$host}'", CONFIG_TEMPLATE);
$template = str_replace('{user}', "'{$dbUser}'", $template);
$template = str_replace('{pass}', "'{$dbPassword}'", $template);
$template = str_replace('{database}', "'{$db}'", $template);
$dbFileHandle = fopen(CONFIG_FILE, 'w');
if ($dbFileHandle !== FALSE) {
fwrite($dbFileHandle, $template);
fclose($dbFileHandle);
createDb($pdo, $db);
createDbUser($pdo, $host, $dbUser, $dbPassword, $db);
createDbStructure($host, $port, $db, $dbUser, $dbPassword);
$_SESSION['db_user'] = $dbUser;
$_SESSION['db_pass'] = $dbPassword;
$_SESSION['db_name'] = $db;
header('Location: ' . $url . '?step=4');
} else {
$_SESSION['error'] = 'Unable to create configuration file. Please check your folder permissions. <br />' . CONFIG_DIR;
header('Location: ' . $url . '?step=3');
}
} catch (PDOException $ex) {
$_SESSION['error'] = $ex->getMessage();
header('Location: ' . $url . '?step=3');
}
} else {
define("T_PRODUCT_PRICE", "Produktpris");
define("T_PRODUCT_IMAGE", "Produktbild");
define("T_PRODUCT_STATUS", "Produktstatus");
define("T_PRODUCT_DESCRIPTION", "Produktbeskrivning");
define("T_CREATE_PRODUCT", "Skapa produkt");
define("T_EDIT_PRODUCT", "Editera produkt");
// Always use database: shop
$_SESSION['a5_db'] = 'shop';
// SESSION parameters ===============================
$sel_db = $_SESSION['a5_db'];
$sel_id = $_SESSION['a5_object_id'];
$sel_name = $_SESSION['a5_object_name'];
// Initiate database if necessary
$file = getXmlFileName($sel_db);
if (!file_exists($file)) {
createDb($sel_db, 5);
$sel_object = 1;
$_SESSION['a5_db'] = $sel_db;
$_SESSION['a5_object'] = $sel_object;
echo "Database initiated !";
}
// GET ==============================================
$temp = $_GET['a5_object_id'];
if ($temp) {
$sel_object = $temp;
$_SESSION['a5_object_id'] = $temp;
$_SESSION['a5_object_name'] = getObjectName($sel_db, $sel_object);
}
// POST =============================================
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$post_action = $_POST['a5_post_action'];
<?php /** * This is only meant to be used to create the database when creating the site. * This will delete all tables and recreate them. */ require_once 'lib.php'; require_once 'database.ini'; //Creating a DB handle $connection = connectToDb(); createDb($connection); echo 'Database table creation SQL command sent'; $connection = null;
if ($post_action == 'post_delete_object') {
if ($sel_db && $sel_object > 1) {
$father = $par['p2'];
deleteObject($sel_db, $sel_object, $father);
$a3pr[$sys_id]['a3_index2'] = '';
$a3pr[$sys_id]['a3_from'] = '';
$a3pr[$sys_id]['a3_from_father'] = '';
$a3pr[$sys_id]['a3_object'] = 1;
}
}
if ($post_action == 'post_create_db') {
$sel_db = $_POST['a3_db'];
$sel_db = str_replace(" ", "-", $sel_db);
$a3pr[$sys_id]['a3_db'] = $sel_db;
if ($sel_db) {
createDb($sel_db, 3);
//$sel_object = 1;
$a3pr[$sys_id]['a3_object'] = 1;
} else {
$g_error = 10;
}
}
if ($post_action == 'post_set_text') {
$value = $_POST['a3_object_text'];
if ($sel_db && $sel_object) {
setObjectText($sel_db, $sel_object, $value);
}
}
if ($post_action == 'post_add_link_from') {
echo "dummy linking from {$sel_object} ({$sys_id})<br>";
$par['a3_link_from_object'] = $sel_object;
);';
echo '即将创建表……<br/>';
echo 'SQL命令为：' . $sql . '<br/>';
$result = mysql_query($sql);
echo '命令执行完毕。<br/>';
// var_dump($result); //bool(true) or bool(false)
if ($result) {
echo '<span class="success">创建表成功！</span><br/>';
} else {
echo '<span class="fail">创建表失败，错误信息：' . mysql_error() . '</span><br/>';
}
}
if ($_POST['type'] == 'both') {
createDb();
createTable();
} elseif ($_POST['type'] == 'db') {
createDb();
} elseif ($_POST['type'] == 'table') {
createTable();
} else {
echo '等待命令。<br />';
}
?>
</p>
<p><a href="testMySql.php" target="_blank">测试数据库连接</a> <a href="index.php">返回首页</a><br /><?php
echo $dev_info;
?>
</p>
</div>
</body>
</html>
<?php
$pathToDbInc = './db.inc';
include $pathToDbInc;
$sqlLink = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if (!$sqlLink) {
fiveHundred();
} else {
createDb($sqlLink);
}
//---------------------------
function createDb($link)
{
$sql = 'CREATE TABLE nodes(node_id CHAR(40) NOT NULL,PRIMARY KEY(node_id),node_string TEXT NOT NULL,access_date BIGINT NOT NULL)';
if (!mysqli_query($link, $sql)) {
echo mysqli_error($link);
}
}
//---------------------------
function fourOhFour()
{
header('HTTP/1.0 404 Not Found');
echo "<h1>404 Not Found</h1>";
exit;
}
function fiveHundred()
{
header('HTTP/1.0 500 Internal Server Error');
echo "<h1>500 Internal Server Error</h1>";
exit;
}
