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; }