<?php require_once "lib/installer/installer_sqlstatements.php"; require_once "lib/installer/installer_functions.php"; require_once "lib/installer/installer_default_settings.php"; output("`@`c`bBuilding the Tables`b`c"); output("`2I'm now going to build the tables."); output("If this is an upgrade, your current tables will be brought in line with the current version."); output("If it's an install, the necessary tables will be placed in your database.`n"); output("`n`@Table Synchronization Logs:`n"); rawoutput("<div style='width: 100%; height: 150px; max-height: 150px; overflow: auto;'>"); $descriptors = descriptors($DB_PREFIX); require_once "lib/tabledescriptor.php"; reset($descriptors); while (list($tablename, $descriptor) = each($descriptors)) { output("`3Synchronizing table `#{$tablename}`3..`n"); synctable($tablename, $descriptor, true); if ($session['dbinfo']['upgrade'] == false) { //on a clean install, destroy all old data. db_query("TRUNCATE TABLE {$tablename}"); } } rawoutput("</div>"); output("`n`2The tables now have new fields and columns added, I'm going to begin importing data now.`n"); rawoutput("<div style='width: 100%; height: 150px; max-height: 150px; overflow: auto;'>"); $dosql = false; reset($sql_upgrade_statements); while (list($key, $val) = each($sql_upgrade_statements)) { if ($dosql) { output("`3Version `#%s`3: %s SQL statements...`n", $key, count($val)); if (count($val) > 0) {
<?php require_once "lib/installer/installer_functions.php"; if (httppostisset("DB_PREFIX") > "") { $session['dbinfo']['DB_PREFIX'] = httppost("DB_PREFIX"); } if ($session['dbinfo']['DB_PREFIX'] > "" && substr($session['dbinfo']['DB_PREFIX'], -1) != "_") { $session['dbinfo']['DB_PREFIX'] .= "_"; } $descriptors = descriptors($session['dbinfo']['DB_PREFIX']); $unique = 0; $game = 0; $missing = 0; $conflict = array(); $link = mysqli_connect($session['dbinfo']['DB_HOST'], $session['dbinfo']['DB_USER'], $session['dbinfo']['DB_PASS']); mysqli_select_db($session['dbinfo']['DB_NAME']); $sql = "SHOW TABLES"; $result = mysqli_query($sql); while ($row = mysqli_fetch_assoc($result)) { list($key, $val) = each($row); if (isset($descriptors[$val])) { $game++; array_push($conflict, $val); } else { $unique++; } } $missing = count($descriptors) - $game; if ($missing * 10 < $game) { //looks like an upgrade $upgrade = true;