Drazyn1291 307 Postado Fevereiro 22, 2015 Share Postado Fevereiro 22, 2015 (editado) Pessoal blz? Estou com um problemão que eu não sei resolver! Estou instalando o GesiorACC 2012 do Natanael Beckman. até ai tudo bem ai quando vou fazer a instalação apareci esta mensagem : Amigo eu troquei de server para ver se consigo só que esta dando este erro : Error occured! Error ID: #E-7 More info: There is no key sqlPort in server config file. File: C:\xampp\htdocs/install.php Line: 175 Esta é a config lua : accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 100 newPlayerSpawnPosY = 40 newPlayerSpawnPosZ = 7 newPlayerTownId = 1 newPlayerLevel = 10 newPlayerMagicLevel = 2 generateAccountNumber = false redSkullLength = 24 * 60 * 60 blackSkullLength = 42 * 60 * 60 dailyFragsToRedSkull = 3 weeklyFragsToRedSkull = 5 monthlyFragsToRedSkull = 10 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true useFragHandler = true advancedFragList = true notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 7 * 24 * 60 * 60 killsBanLength = 7 * 24 * 60 * 60 finalBanLength = 30 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = false worldType = "pvp" protectionLevel = 75 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 60 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 40 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = true removeWeaponCharges = true removeRuneCharges = true whiteSkullTime = 15 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = true fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = false oldConditionAccuracy = false loginProtectionPeriod = 10 * 1000 deathLostPercent = 5 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1987 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true worldId = 0 ip = "25.191.51.122" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = "7172" adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Bem vindo ao Alissow OTs 4.1! Enjoy" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Alissow OTs" loginMessage = "Bem vindo ao Alissow OTs 4.1! Enjoy" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false sqlType = "mysql" sqlHost = "25.191.51.122" sqlPort = 3306 sqlUser = "root" sqlPass = "" sqlDatabase = "databasemilesdraco" sqlFile = "databasemilesdraco.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "plain" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 75 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 30 highscoreDisplayPlayers = 15 updateHighscoresAfterMinutes = 60 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 75 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = true timeBetweenActions = 200 timeBetweenExActions = 1000 checkCorpseOwner = true hotkeyAimbotEnabled = true maximumDoorLevel = 500 mapName = "Xedegux" mapAuthor = "Alissow - Xedegux" randomizeTiles = true useHouseDataStorage = false storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "-1" defaultPriority = "high" niceLevel = 5 coresUsed = "-1" optimizeDatabaseAtStartup = true removePremiumOnInit = true confirmOutdatedVersion = false r maxMessageBuffer = 4 bufferMutedOnSpellFailure = false dataDirectory = "data/" allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false bankSystem = true saveGlobalStorage = true displaySkillLevelOnAdvance = true spellNameInsteadOfWords = false emoteSpells = true promptExceptionTracerErrorBox = true storePlayerDirection = false monsterLootMessage = 3 monsterLootMessageType = 25 separateViplistPerCharacter = false ghostModeInvisibleEffect = false ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 expireReportsAfterReads = 1 playerQueryDeepness = 2 maxItemsPerPZTile = 0 maxItemsPerHouseTile = 0 freePremium = false premiumForPromotion = true blessingOnlyPremium = true blessingReductionBase = 30 blessingReductionDecreament = 5 eachBlessReduction = 8 experienceStages = false rateExperience = 350 rateExperienceFromPlayers = 0 rateSkill = 200 rateMagic = 100 rateLoot = 5 rateSpawn = 1 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 minLevelThresholdForKilledPlayer = 0.9 maxLevelThresholdForKilledPlayer = 1.1 rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 41 * 60 staminaRatingLimitBottom = 14 * 60 rateStaminaAboveNormal = 1.5 rateStaminaUnderNormal = 0.5 staminaThresholdOnlyPremium = true experienceShareRadiusX = 30 experienceShareRadiusY = 30 experienceShareRadiusZ = 1 experienceShareLevelDifference = 2 / 3 extraPartyExperienceLimit = 20 extraPartyExperiencePercent = 5 experienceShareActivity = 2 * 60 * 1000 globalSaveEnabled = false globalSaveHour = 8 shutdownAtGlobalSave = true cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false ownerName = "Alissow" ownerEmail = "[email protected]" url = "http://www.sotserv.blogspot.com/" location = "Vitoria da conquista, Bahia - Brasil" displayGamemastersWithOnlineCommand = true adminLogsEnabled = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = false e este é o Install.php : <?PHP define('INITIALIZED', true); define('ONLY_PAGE', false); if(!file_exists('install.txt')) { echo('AAC installation is disabled. To enable it make file <b>install.php</b> in main AAC directory and put there your IP.'); exit; } $installIP = trim(file_get_contents('install.txt')); if($installIP != $_SERVER['REMOTE_ADDR']) { echo('In file <b>install.txt</b> must be your IP!<br />In file is:<br /><b>' . $installIP . '</b><br />Your IP is:<br /><b>' . $_SERVER['REMOTE_ADDR'] . '</b>'); exit; } $time_start = microtime(true); session_start(); function autoLoadClass($className) { if(!class_exists($className)) if(file_exists('./classes/' . strtolower($className) . '.php')) include_once('./classes/' . strtolower($className) . '.php'); else new Error_Critic('#E-7', 'Cannot load class <b>' . $className . '</b>, file <b>./classes/class.' . strtolower($className) . '.php</b> doesn\'t exist'); } spl_autoload_register('autoLoadClass'); //load acc. maker config to $config['site'] $config = array(); include('./config/config.php'); if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) { $process = array(&$_GET, &$_POST, &$_COOKIE, &$_REQUEST); while(list($key, $val) = each($process)) { foreach ($val as $k => $v) { unset($process[$key][$k]); if(is_array($v)) { $process[$key][stripslashes($k)] = $v; $process[] = &$process[$key][stripslashes($k)]; } else $process[$key][stripslashes($k)] = stripslashes($v); } } unset($process); } $page = ''; if(isset($_REQUEST['page'])) $page = $_REQUEST['page']; $step = 'start'; if(isset($_REQUEST['step'])) $step = $_REQUEST['step']; // load server path function getServerPath() { $config = array(); include('./config/config.php'); return $config['site']['serverPath']; } // save server path function setServerPath($newPath) { $file = fopen("./config/config.php", "r"); $lines = array(); while (!feof($file)) { $lines[] = fgets($file); } fclose($file); $newConfig = array(); foreach ($lines as $i => $line) { if(substr($line, 0, strlen('$config[\'site\'][\'serverPath\']')) == '$config[\'site\'][\'serverPath\']') $newConfig[] = '$config[\'site\'][\'serverPath\'] = "' . str_replace('"', '\"' , $newPath) . '";' . PHP_EOL; // do something with each line from text file here else $newConfig[] = $line; } Website::putFileContents("./config/config.php", implode('', $newConfig)); } if($page == '') { echo '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" /> <title>Installation of account maker</title> </head> <frameset cols="230,*"> <frame name="menu" src="install.php?page=menu" /> <frame name="step" src="install.php?page=step&step=start" /> <noframes><body>Frames don\'t work. Install Firefox </body></noframes> </frameset> </html>'; } elseif($page == 'menu') { echo '<h2>MENU</h2><br> <b>IF NOT INSTALLED:</b><br> <a href="install.php?page=step&step=start" target="step">0. Informations</a><br> <a href="install.php?page=step&step=1" target="step">1. Set server path</a><br> <a href="install.php?page=step&step=2" target="step">2. Check DataBase connection</a><br> <a href="install.php?page=step&step=3" target="step">3. Add tables and columns to DB</a><br> <a href="install.php?page=step&step=4" target="step">4. Add samples to DB</a><br> <a href="install.php?page=step&step=5" target="step">5. Set Admin Account</a><br> <b>Author:</b><br> Gesior<br> Compatible with TFS 0.3.6 and TFS 0.4 up to revision 3702</a>'; } elseif($page == 'step') { if($step >= 2 && $step <= 5) { //load server config $config['server'] if(Website::getWebsiteConfig()->getValue('useServerConfigCache')) { // use cache to make website load faster if(Website::fileExists('./config/server.config.php')) { $tmp_php_config = new ConfigPHP('./config/server.config.php'); $config['server'] = $tmp_php_config->getConfig(); } else { // if file isn't cache we should load .lua file and make .php cache $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); $tmp_php_config = new ConfigPHP(); $tmp_php_config->setConfig($tmp_lua_config->getConfig()); $tmp_php_config->saveToFile('./config/server.config.php'); } } else { $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); } if(Website::getServerConfig()->isSetKey('mysqlHost')) { define('SERVERCONFIG_SQL_TYPE', 'sqlType'); define('SERVERCONFIG_SQL_HOST', 'mysqlHost'); define('SERVERCONFIG_SQL_PORT', 'mysqlPort'); define('SERVERCONFIG_SQL_USER', 'mysqlUser'); define('SERVERCONFIG_SQL_PASS', 'mysqlPass'); define('SERVERCONFIG_SQL_DATABASE', 'mysqlDatabase'); define('SERVERCONFIG_SQLITE_FILE', 'sqlFile'); } elseif(Website::getServerConfig()->isSetKey('sqlHost')) { define('SERVERCONFIG_SQL_TYPE', 'sqlType'); define('SERVERCONFIG_SQL_HOST', 'sqlHost'); define('SERVERCONFIG_SQL_PORT', 'sqlPort'); define('SERVERCONFIG_SQL_USER', 'sqlUser'); define('SERVERCONFIG_SQL_PASS', 'sqlPass'); define('SERVERCONFIG_SQL_DATABASE', 'sqlDatabase'); define('SERVERCONFIG_SQLITE_FILE', 'sqlFile'); } else new Error_Critic('#E-3', 'There is no key <b>sqlHost</b> or <b>mysqlHost</b> in server config', array(new Error('INFO', 'use server config cache: <b>' . (Website::getWebsiteConfig()->getValue('useServerConfigCache') ? 'true' : 'false') . '</b>'))); if(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'mysql') { Website::setDatabaseDriver(Database::DB_MYSQL); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST)) Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PORT)) Website::getDBHandle()->setDatabasePort(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PORT)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PORT . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE)) Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER)) Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS)) Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.'); } elseif(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'sqlite') { Website::setDatabaseDriver(Database::DB_SQLITE); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQLITE_FILE)) Website::getDBHandle()->setDatabaseFile(Website::getServerConfig()->getValue(SERVERCONFIG_SQLITE_FILE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQLITE_FILE . '</b> in server config file.'); } elseif(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'pgsql') { // does pgsql use 'port' parameter? I don't know Website::setDatabaseDriver(Database::DB_PGSQL); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST)) Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE)) Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER)) Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS)) Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.'); } else new Error_Critic('#E-6', 'Database error. Unknown database type in <b>server config</b> . Must be equal to: "<b>mysql</b>", "<b>sqlite</b>" or "<b>pgsql</b>" . Now is: "<b>' . Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) . '</b>"'); Website::setPasswordsEncryption(Website::getServerConfig()->getValue('encryptionType')); $SQL = Website::getDBHandle(); } if($step == 'start') { echo '<h1>STEP '.$step.'</h1>Informations<br>'; echo 'Welcome to Gesior Account Maker installer. <b>After 5 simple steps account maker will be ready to use!</b><br />'; // check access to write files $writeable = array('config/config.php', 'cache', 'cache/flags', 'cache/DONT_EDIT_usercounter.txt', 'cache/DONT_EDIT_serverstatus.txt', 'custom_scripts', 'install.txt'); foreach($writeable as $fileToWrite) { if(is_writable($fileToWrite)) echo '<span style="color:green">CAN WRITE TO FILE: <b>' . $fileToWrite . '</b></span><br />'; else echo '<span style="color:red">CANNOT WRITE TO FILE: <b>' . $fileToWrite . '</b> - edit file access for PHP [on linux: chmod]</span><br />'; } } elseif($step == 1) { if(isset($_REQUEST['server_path'])) { echo '<h1>STEP '.$step.'</h1>Check server configuration<br>'; $path = $_REQUEST['server_path']; $path = trim($path)."\\"; $path = str_replace("\\\\", "/", $path); $path = str_replace("\\", "/", $path); $path = str_replace("//", "/", $path); setServerPath($path); $tmp_lua_config = new ConfigLUA($path . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); if(isset($config['server']['sqlType'])) { echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font>. It looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>'; } else { echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.'; } } else { echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.2.9\</i><form action="install.php"> <input type="text" name="server_path" size="90" value="'.htmlspecialchars(getServerPath()).'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Set server path" /> </form>'; } } elseif($step == 2) { echo '<h1>STEP '.$step.'</h1>Check database connection<br>'; echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3">link to STEP 3 - Add tables and columns to DB</a>. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.<br />'; $SQL->connect(); // show errors if can't connect } elseif($step == 3) { echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>'; echo 'Installer try to add new tables and columns to database.<br>'; $columns = array(); //$columns[] = array('table', 'name_of_column', 'type', 'length', 'default'); $columns[] = array('accounts', 'key', 'VARCHAR', '20', '0'); $columns[] = array('accounts', 'email_new', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'email_new_time', 'INT', '11', '0'); $columns[] = array('accounts', 'rlname', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'location', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'page_access', 'INT', '11', '0'); $columns[] = array('accounts', 'email_code', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'next_email', 'INT', '11', '0'); $columns[] = array('accounts', 'premium_points', 'INT', '11', '0'); $columns[] = array('accounts', 'create_date', 'INT', '11', '0'); $columns[] = array('accounts', 'create_ip', 'INT', '11', '0'); $columns[] = array('accounts', 'last_post', 'INT', '11', '0'); $columns[] = array('accounts', 'flag', 'VARCHAR', '80', ''); $columns[] = array('accounts', 'guild_points', 'INT', '11', '0'); $columns[] = array('accounts', 'vip_time', 'INT', '15', '0'); $columns[] = array('guilds', 'description', 'TEXT', '', ''); $columns[] = array('guilds', 'guild_logo', 'MEDIUMBLOB', '', NULL); $columns[] = array('guilds', 'create_ip', 'INT', '11', '0'); $columns[] = array('guilds', 'balance', 'BIGINT UNSIGNED', '', '0'); $columns[] = array('killers', 'war', 'INT', '11', '0'); $columns[] = array('players', 'deleted', 'TINYINT', '1', '0'); $columns[] = array('players', 'description', 'VARCHAR', '255', ''); $columns[] = array('players', 'comment', 'TEXT', '', ''); $columns[] = array('players', 'create_ip', 'INT', '11', '0'); $columns[] = array('players', 'create_date', 'INT', '11', '0'); $columns[] = array('players', 'hide_char', 'INT', '11', '0'); $columns[] = array('players', 'signature', 'TEXT', '', ''); $tables = array(); // mysql tables $tables[Database::DB_MYSQL]['z_ots_comunication'] = "CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_ots_guildcomunication'] = "CREATE TABLE `z_ots_guildcomunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_polls'] = "CREATE TABLE `z_polls` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question` varchar(255) NOT NULL, `end` int(11) NOT NULL, `start` int(11) NOT NULL, `answers` int(11) NOT NULL, `votes_all` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['accounts'] = "ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL ;"; $tables[Database::DB_MYSQL]['z_polls_answers'] = "CREATE TABLE `z_polls_answers` ( `poll_id` int(11) NOT NULL, `answer_id` int(11) NOT NULL, `answer` varchar(255) NOT NULL, `votes` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_network_box'] = "CREATE TABLE `z_network_box` ( `id` int(11) NOT NULL AUTO_INCREMENT, `network_name` varchar(10) NOT NULL, `network_link` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['z_shop_offer'] = "CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_history_pacc'] = "CREATE TABLE `z_shop_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_history_item'] = "CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shopguild_offer'] = "CREATE TABLE `z_shopguild_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shopguild_history_pacc'] = "CREATE TABLE `z_shopguild_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_historyguild_item'] = "CREATE TABLE `z_shopguild_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_featured_article'] = "CREATE TABLE `z_featured_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `text` varchar(255) NOT NULL, `date` varchar(30) NOT NULL, `author` varchar(50) NOT NULL, `read_more` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['z_forum'] = "CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(15) NOT NULL default '0.0.0.0', `icon_id` tinyint(4) NOT NULL DEFAULT '1', `post_icon_id` tinyint(10) NOT NULL, PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_news_tickers'] = "CREATE TABLE `z_news_tickers` ( `date` int(11) NOT NULL DEFAULT '1', `author` int(11) NOT NULL, `image_id` int(3) NOT NULL DEFAULT '0', `text` text NOT NULL, `hide_ticker` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['guild_wars'] = "CREATE TABLE `guild_wars` ( `id` INT NOT NULL AUTO_INCREMENT, `guild_id` INT NOT NULL, `enemy_id` INT NOT NULL, `begin` BIGINT NOT NULL DEFAULT '0', `end` BIGINT NOT NULL DEFAULT '0', `frags` INT UNSIGNED NOT NULL DEFAULT '0', `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0', `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0', `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0', `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`) ) ENGINE=InnoDB;"; $tables[Database::DB_MYSQL]['guild_wars_table_references'] = "ALTER TABLE `guild_wars` ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;"; $tables[Database::DB_MYSQL]['guild_kills'] = "CREATE TABLE `guild_kills` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `guild_id` INT NOT NULL, `war_id` INT NOT NULL, `death_id` INT NOT NULL ) ENGINE = InnoDB;"; $tables[Database::DB_MYSQL]['guild_kills_table_references'] = "ALTER TABLE `guild_kills` ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;"; // sqlite tables $tables[Database::DB_SQLITE]['z_ots_comunication'] = 'CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" varchar(255) NOT NULL, "type" varchar(255) NOT NULL, "action" varchar(255) NOT NULL, "param1" varchar(255) NOT NULL, "param2" varchar(255) NOT NULL, "param3" varchar(255) NOT NULL, "param4" varchar(255) NOT NULL, "param5" varchar(255) NOT NULL, "param6" varchar(255) NOT NULL, "param7" varchar(255) NOT NULL, "delete_it" int(2) NOT NULL default 1);'; $tables[Database::DB_SQLITE]['z_shop_offer'] = 'CREATE TABLE "z_shop_offer" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "points" int(11) NOT NULL default 0, "itemid1" int(11) NOT NULL default 0, "count1" int(11) NOT NULL default 0, "itemid2" int(11) NOT NULL default 0, "count2" int(11) NOT NULL default 0, "offer_type" varchar(255) default NULL, "offer_description" text NOT NULL, "offer_name" varchar(255) NOT NULL);'; $tables[Database::DB_SQLITE]['z_shop_history_item'] = 'CREATE TABLE "z_shop_history_item" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "to_name" varchar(255) NOT NULL default 0, "to_account" int(11) NOT NULL default 0, "from_nick" varchar(255) NOT NULL, "from_account" int(11) NOT NULL default 0, "price" int(11) NOT NULL default 0, "offer_id" varchar(255) NOT NULL default "", "trans_state" varchar(255) NOT NULL, "trans_start" int(11) NOT NULL default 0, "trans_real" int(11) NOT NULL default 0);'; $tables[Database::DB_SQLITE]['z_forum'] = 'CREATE TABLE "z_forum" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "first_post" int(11) NOT NULL default 0, "last_post" int(11) NOT NULL default 0, "section" int(3) NOT NULL default 0, "replies" int(20) NOT NULL default 0, "views" int(20) NOT NULL default 0, "author_aid" int(20) NOT NULL default 0, "author_guid" int(20) NOT NULL default 0, "post_text" text NOT NULL, "post_topic" varchar(255) NOT NULL, "post_smile" tinyint(1) NOT NULL default 0, "post_date" int(20) NOT NULL default 0, "last_edit_aid" int(20) NOT NULL default 0, "edit_date" int(20) NOT NULL default 0, "post_ip" varchar(15) NOT NULL default "0.0.0.0,");'; foreach($columns as $column) { if($column[4] === NULL && $SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . ' NULL DEFAULT NULL') !== false) echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />"; elseif($SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '' . (($column[3] == '') ? '' : '(' . $column[3] . ')') . ' NOT NULL DEFAULT \'' . $column[4] . '\'') !== false) echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />"; else echo "Could not add column <b>" . $column[1] . "</b> to table <b>" . $column[0] . "</b>. Already exist?<br />"; } foreach($tables[$SQL->getDatabaseDriver()] as $tableName => $tableQuery) { if($SQL->query($tableQuery) !== false) echo "<span style=\"color:green\">Table <b>" . $tableName . "</b> created.</span><br />"; else echo "Could not create table <b>" . $tableName . "</b>. Already exist?<br />"; } echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4">STEP 4 - Add samples</a>'; } elseif($step == 4) { echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>'; $samplePlayers = array(); $samplePlayers[0] = 'Rook Sample'; $samplePlayers[1] = 'Sorcerer Sample'; $samplePlayers[2] = 'Druid Sample'; $samplePlayers[3] = 'Paladin Sample'; $samplePlayers[4] = 'Knight Sample'; $newPlayer = new Player('Account Manager', Player::LOADTYPE_NAME); if($newPlayer->isLoaded()) { foreach($samplePlayers as $vocationID => $name) { $samplePlayer = new Player($name, Player::LOADTYPE_NAME); if(!$samplePlayer->isLoaded()) { $samplePlayer = new Player('Account Manager', Player::LOADTYPE_NAME); $samplePlayer->setID(null); // save as new player, not edited $samplePlayer->setName($name); $samplePlayer->setVocation($vocationID); $samplePlayer->setGroupID(1); $samplePlayer->setLookType(128); $samplePlayer->save(); echo '<span style="color:green">Added sample character: </span><span style="color:green;font-weight:bold">' . $name . '</span><br/>'; } else echo 'Sample character: <span style="font-weight:bold">' . $name . '</span> already exist in database<br/>'; } } else new Error_Critic('', 'Character <i>Account Manager</i> does not exist. Cannot install sample characters!'); } elseif($step == 5) { echo '<h1>STEP '.$step.'</h1>Set Admin Account<br>'; if(empty($_REQUEST['saveaccpassword'])) { echo 'Admin account login is: <b>1</b><br/>Set new password to this account.<br>'; echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)'; echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form><br>If account with login 1 doesn\'t exist installator will create it and set your password.'; } else { include_once('./system/load.compat.php'); $newpass = trim($_POST['newpass']); if(!check_password($newpass)) echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5">GO BACK</a> and write other password.'; else { //create / set pass to admin account $account = new Account(1, Account::LOADTYPE_NAME); if($account->isLoaded()) { $account->setPassword($newpass); // setPassword encrypt it to ots encryption $account->setPageAccess(3); $account->setFlag('unknown'); $account->save(); } else { $newAccount = new Account(); $newAccount->setName(1); $newAccount->setPassword($newpass); // setPassword encrypt it to ots encryption $newAccount->setMail(rand(0,999999) . '@gmail.com'); $newAccount->setPageAccess(3); $newAccount->setGroupID(1); $newAccount->setFlag('unknown'); $newAccount->setCreateIP(Visitor::getIP()); $newAccount->setCreateDate(time()); } $_SESSION['account'] = 1; $_SESSION['password'] = $newpass; $logged = TRUE; echo '<h1>Admin account login: 1<br>Admin account password: '.$newpass.'</h1><br/><h3>It\'s end of installation. Installation is blocked!</h3>'; if(!unlink('install.txt')) new Error_Critic('', 'Cannot remove file <i>install.txt</i>. You must remove it to disable installer. I recommend you to go to step <i>0</i> and check if any other file got problems with WRITE permission.'); } } } } Por favor alguem ajuda ae este servidor é 8.60, por favor alguem ajuda ae Help!Plis!!Se alguem puder me ajudar, vlw! Editado Fevereiro 22, 2015 por Zet0N0Murmurou (veja o histórico de edições) Citar Pokémon Dust Evolution É aonde começa sua nova aventura!! Facebook Verifique Atualizações Link para o post Compartilhar em outros sites
Tibia2015br 77 Postado Fevereiro 22, 2015 Share Postado Fevereiro 22, 2015 coloca IP 127.0.0.1 se ajudei cade o like Drazyn1291 reagiu a isso 1 Citar site acesse:http://rexwar.esy.es se te ajudei mi ajude com um like canal do youtube:https://www.youtube.com/channel/ blog:http://yakinhotutoriais.blogspot.com.br/ site acesse:http://rexwar.esy.es 0 comentários: Link para o post Compartilhar em outros sites
Drazyn1291 307 Postado Fevereiro 22, 2015 Autor Share Postado Fevereiro 22, 2015 Funcionou só que agora estou com outro problema!! Esta dando este erro quando eu chego na primeira parte : STEP 1 Check server configurationFile config.lua loaded from C:/Servidor Miles Draco/Miles Draco Server 10.37/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author. Eu sei que vão pedir o config.lua então vou adiantar logo Segue : worldType = "pvp" hotkeyAimbotEnabled = "yes" protectionLevel = 1 killsToRedSkull = 3 killsToBlackSkull = 6 pzLocked = 60000 removeAmmoWhenUsingDistanceWeapon = "yes" removeChargesFromRunes = "yes" timeToDecreaseFrags = 24 * 60 * 60 * 1000 whiteSkullTime = 15 * 60 * 1000 stairJumpExhaustion = 2000 experienceByKillingPlayers = "no" ip = "127.0.0.1" bindOnlyGlobalAddress = "no" loginProtocolPort = 7171 gameProtocolPort = 7172 statusProtocolPort = 7171 maxPlayers = "1000" motd = "Welcome to The Alissow Server!" onePlayerOnlinePerAccount = "yes" allowClones = "no" serverName = "Alissow" statusTimeout = 60000 replaceKickOnLogin = "yes" maxPacketsPerSecond = 25 deathLosePercent = -1 housePriceEachSQM = 1000 houseRentPeriod = "never" timeBetweenActions = 200 timeBetweenExActions = 1000 mapName = "Xedegux" mapAuthor = "Alissow and XedeguX" marketOfferDuration = 30 * 24 * 60 * 60 premiumToCreateMarketOffer = "yes" checkExpiredMarketOffersEachMinutes = 60 maxMarketOffersAtATimePerPlayer = 100 mysqlHost = "25.191.51.122" mysqlUser = "root" mysqlPass = "" mysqlDatabase = "milesdraco" mysqlPort = 3306 mysqlSock = "" allowChangeOutfit = "yes" freePremium = "no" kickIdlePlayerAfterMinutes = 15 maxMessageBuffer = 4 noDamageToSameLookfeet = "no" emoteSpells = "no" rateExp = 5 rateSkill = 3 rateLoot = 2 rateMagic = 3 rateSpawn = 1 deSpawnRange = 2 deSpawnRadius = 50 staminaSystem = "yes" defaultPriority = "high" startupDatabaseOptimization = "no" ownerName = "Gabriel" ownerEmail = "" url = "" location = "Brazil" Eu apenas removi a senha do config para postar aqui quem puder ajuda neste vlw Citar Pokémon Dust Evolution É aonde começa sua nova aventura!! Facebook Verifique Atualizações Link para o post Compartilhar em outros sites
Tibia2015br 77 Postado Fevereiro 22, 2015 Share Postado Fevereiro 22, 2015 sqlType = "mysql" mysqlHost = "localhost"mysqlUser = "root"mysqlPass = ""mysqlDatabase = "milesdraco"mysqlPort = 3306mysqlSock = "" SE TE AJUDEI AGR MI AJUDE CADE O LIKE Drazyn1291 reagiu a isso 1 Citar site acesse:http://rexwar.esy.es se te ajudei mi ajude com um like canal do youtube:https://www.youtube.com/channel/ blog:http://yakinhotutoriais.blogspot.com.br/ site acesse:http://rexwar.esy.es 0 comentários: Link para o post Compartilhar em outros sites
Drazyn1291 307 Postado Fevereiro 22, 2015 Autor Share Postado Fevereiro 22, 2015 (editado) Amigo eu troquei de server para ver se consigo só que esta dando este erro : Error occured! Error ID: #E-7 More info: There is no key sqlPort in server config file. File: C:\xampp\htdocs/install.php Line: 175 Esta é a config lua : accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 100 newPlayerSpawnPosY = 40 newPlayerSpawnPosZ = 7 newPlayerTownId = 1 newPlayerLevel = 10 newPlayerMagicLevel = 2 generateAccountNumber = false redSkullLength = 24 * 60 * 60 blackSkullLength = 42 * 60 * 60 dailyFragsToRedSkull = 3 weeklyFragsToRedSkull = 5 monthlyFragsToRedSkull = 10 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true useFragHandler = true advancedFragList = true notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 7 * 24 * 60 * 60 killsBanLength = 7 * 24 * 60 * 60 finalBanLength = 30 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = false worldType = "pvp" protectionLevel = 75 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 60 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 40 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = true removeWeaponCharges = true removeRuneCharges = true whiteSkullTime = 15 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = true fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = false oldConditionAccuracy = false loginProtectionPeriod = 10 * 1000 deathLostPercent = 5 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1987 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true worldId = 0 ip = "25.191.51.122" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = "7172" adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Bem vindo ao Alissow OTs 4.1! Enjoy" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Alissow OTs" loginMessage = "Bem vindo ao Alissow OTs 4.1! Enjoy" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false sqlType = "mysql" sqlHost = "25.191.51.122" sqlPort = 3306 sqlUser = "root" sqlPass = "" sqlDatabase = "databasemilesdraco" sqlFile = "databasemilesdraco.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "plain" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 75 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 30 highscoreDisplayPlayers = 15 updateHighscoresAfterMinutes = 60 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 75 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = true timeBetweenActions = 200 timeBetweenExActions = 1000 checkCorpseOwner = true hotkeyAimbotEnabled = true maximumDoorLevel = 500 mapName = "Xedegux" mapAuthor = "Alissow - Xedegux" randomizeTiles = true useHouseDataStorage = false storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "-1" defaultPriority = "high" niceLevel = 5 coresUsed = "-1" optimizeDatabaseAtStartup = true removePremiumOnInit = true confirmOutdatedVersion = false r maxMessageBuffer = 4 bufferMutedOnSpellFailure = false dataDirectory = "data/" allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false bankSystem = true saveGlobalStorage = true displaySkillLevelOnAdvance = true spellNameInsteadOfWords = false emoteSpells = true promptExceptionTracerErrorBox = true storePlayerDirection = false monsterLootMessage = 3 monsterLootMessageType = 25 separateViplistPerCharacter = false ghostModeInvisibleEffect = false ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 expireReportsAfterReads = 1 playerQueryDeepness = 2 maxItemsPerPZTile = 0 maxItemsPerHouseTile = 0 freePremium = false premiumForPromotion = true blessingOnlyPremium = true blessingReductionBase = 30 blessingReductionDecreament = 5 eachBlessReduction = 8 experienceStages = false rateExperience = 350 rateExperienceFromPlayers = 0 rateSkill = 200 rateMagic = 100 rateLoot = 5 rateSpawn = 1 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 minLevelThresholdForKilledPlayer = 0.9 maxLevelThresholdForKilledPlayer = 1.1 rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 41 * 60 staminaRatingLimitBottom = 14 * 60 rateStaminaAboveNormal = 1.5 rateStaminaUnderNormal = 0.5 staminaThresholdOnlyPremium = true experienceShareRadiusX = 30 experienceShareRadiusY = 30 experienceShareRadiusZ = 1 experienceShareLevelDifference = 2 / 3 extraPartyExperienceLimit = 20 extraPartyExperiencePercent = 5 experienceShareActivity = 2 * 60 * 1000 globalSaveEnabled = false globalSaveHour = 8 shutdownAtGlobalSave = true cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false ownerName = "Alissow" ownerEmail = "[email protected]" url = "http://www.sotserv.blogspot.com/" location = "Vitoria da conquista, Bahia - Brasil" displayGamemastersWithOnlineCommand = true adminLogsEnabled = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = false e este é o Install.php : <?PHP define('INITIALIZED', true); define('ONLY_PAGE', false); if(!file_exists('install.txt')) { echo('AAC installation is disabled. To enable it make file <b>install.php</b> in main AAC directory and put there your IP.'); exit; } $installIP = trim(file_get_contents('install.txt')); if($installIP != $_SERVER['REMOTE_ADDR']) { echo('In file <b>install.txt</b> must be your IP!<br />In file is:<br /><b>' . $installIP . '</b><br />Your IP is:<br /><b>' . $_SERVER['REMOTE_ADDR'] . '</b>'); exit; } $time_start = microtime(true); session_start(); function autoLoadClass($className) { if(!class_exists($className)) if(file_exists('./classes/' . strtolower($className) . '.php')) include_once('./classes/' . strtolower($className) . '.php'); else new Error_Critic('#E-7', 'Cannot load class <b>' . $className . '</b>, file <b>./classes/class.' . strtolower($className) . '.php</b> doesn\'t exist'); } spl_autoload_register('autoLoadClass'); //load acc. maker config to $config['site'] $config = array(); include('./config/config.php'); if(function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) { $process = array(&$_GET, &$_POST, &$_COOKIE, &$_REQUEST); while(list($key, $val) = each($process)) { foreach ($val as $k => $v) { unset($process[$key][$k]); if(is_array($v)) { $process[$key][stripslashes($k)] = $v; $process[] = &$process[$key][stripslashes($k)]; } else $process[$key][stripslashes($k)] = stripslashes($v); } } unset($process); } $page = ''; if(isset($_REQUEST['page'])) $page = $_REQUEST['page']; $step = 'start'; if(isset($_REQUEST['step'])) $step = $_REQUEST['step']; // load server path function getServerPath() { $config = array(); include('./config/config.php'); return $config['site']['serverPath']; } // save server path function setServerPath($newPath) { $file = fopen("./config/config.php", "r"); $lines = array(); while (!feof($file)) { $lines[] = fgets($file); } fclose($file); $newConfig = array(); foreach ($lines as $i => $line) { if(substr($line, 0, strlen('$config[\'site\'][\'serverPath\']')) == '$config[\'site\'][\'serverPath\']') $newConfig[] = '$config[\'site\'][\'serverPath\'] = "' . str_replace('"', '\"' , $newPath) . '";' . PHP_EOL; // do something with each line from text file here else $newConfig[] = $line; } Website::putFileContents("./config/config.php", implode('', $newConfig)); } if($page == '') { echo '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" /> <title>Installation of account maker</title> </head> <frameset cols="230,*"> <frame name="menu" src="install.php?page=menu" /> <frame name="step" src="install.php?page=step&step=start" /> <noframes><body>Frames don\'t work. Install Firefox </body></noframes> </frameset> </html>'; } elseif($page == 'menu') { echo '<h2>MENU</h2><br> <b>IF NOT INSTALLED:</b><br> <a href="install.php?page=step&step=start" target="step">0. Informations</a><br> <a href="install.php?page=step&step=1" target="step">1. Set server path</a><br> <a href="install.php?page=step&step=2" target="step">2. Check DataBase connection</a><br> <a href="install.php?page=step&step=3" target="step">3. Add tables and columns to DB</a><br> <a href="install.php?page=step&step=4" target="step">4. Add samples to DB</a><br> <a href="install.php?page=step&step=5" target="step">5. Set Admin Account</a><br> <b>Author:</b><br> Gesior<br> Compatible with TFS 0.3.6 and TFS 0.4 up to revision 3702</a>'; } elseif($page == 'step') { if($step >= 2 && $step <= 5) { //load server config $config['server'] if(Website::getWebsiteConfig()->getValue('useServerConfigCache')) { // use cache to make website load faster if(Website::fileExists('./config/server.config.php')) { $tmp_php_config = new ConfigPHP('./config/server.config.php'); $config['server'] = $tmp_php_config->getConfig(); } else { // if file isn't cache we should load .lua file and make .php cache $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); $tmp_php_config = new ConfigPHP(); $tmp_php_config->setConfig($tmp_lua_config->getConfig()); $tmp_php_config->saveToFile('./config/server.config.php'); } } else { $tmp_lua_config = new ConfigLUA(Website::getWebsiteConfig()->getValue('serverPath') . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); } if(Website::getServerConfig()->isSetKey('mysqlHost')) { define('SERVERCONFIG_SQL_TYPE', 'sqlType'); define('SERVERCONFIG_SQL_HOST', 'mysqlHost'); define('SERVERCONFIG_SQL_PORT', 'mysqlPort'); define('SERVERCONFIG_SQL_USER', 'mysqlUser'); define('SERVERCONFIG_SQL_PASS', 'mysqlPass'); define('SERVERCONFIG_SQL_DATABASE', 'mysqlDatabase'); define('SERVERCONFIG_SQLITE_FILE', 'sqlFile'); } elseif(Website::getServerConfig()->isSetKey('sqlHost')) { define('SERVERCONFIG_SQL_TYPE', 'sqlType'); define('SERVERCONFIG_SQL_HOST', 'sqlHost'); define('SERVERCONFIG_SQL_PORT', 'sqlPort'); define('SERVERCONFIG_SQL_USER', 'sqlUser'); define('SERVERCONFIG_SQL_PASS', 'sqlPass'); define('SERVERCONFIG_SQL_DATABASE', 'sqlDatabase'); define('SERVERCONFIG_SQLITE_FILE', 'sqlFile'); } else new Error_Critic('#E-3', 'There is no key <b>sqlHost</b> or <b>mysqlHost</b> in server config', array(new Error('INFO', 'use server config cache: <b>' . (Website::getWebsiteConfig()->getValue('useServerConfigCache') ? 'true' : 'false') . '</b>'))); if(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'mysql') { Website::setDatabaseDriver(Database::DB_MYSQL); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST)) Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PORT)) Website::getDBHandle()->setDatabasePort(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PORT)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PORT . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE)) Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER)) Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS)) Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.'); } elseif(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'sqlite') { Website::setDatabaseDriver(Database::DB_SQLITE); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQLITE_FILE)) Website::getDBHandle()->setDatabaseFile(Website::getServerConfig()->getValue(SERVERCONFIG_SQLITE_FILE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQLITE_FILE . '</b> in server config file.'); } elseif(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) == 'pgsql') { // does pgsql use 'port' parameter? I don't know Website::setDatabaseDriver(Database::DB_PGSQL); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_HOST)) Website::getDBHandle()->setDatabaseHost(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_HOST)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_HOST . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_DATABASE)) Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER)) Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.'); if(Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS)) Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS)); else new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.'); } else new Error_Critic('#E-6', 'Database error. Unknown database type in <b>server config</b> . Must be equal to: "<b>mysql</b>", "<b>sqlite</b>" or "<b>pgsql</b>" . Now is: "<b>' . Website::getServerConfig()->getValue(SERVERCONFIG_SQL_TYPE) . '</b>"'); Website::setPasswordsEncryption(Website::getServerConfig()->getValue('encryptionType')); $SQL = Website::getDBHandle(); } if($step == 'start') { echo '<h1>STEP '.$step.'</h1>Informations<br>'; echo 'Welcome to Gesior Account Maker installer. <b>After 5 simple steps account maker will be ready to use!</b><br />'; // check access to write files $writeable = array('config/config.php', 'cache', 'cache/flags', 'cache/DONT_EDIT_usercounter.txt', 'cache/DONT_EDIT_serverstatus.txt', 'custom_scripts', 'install.txt'); foreach($writeable as $fileToWrite) { if(is_writable($fileToWrite)) echo '<span style="color:green">CAN WRITE TO FILE: <b>' . $fileToWrite . '</b></span><br />'; else echo '<span style="color:red">CANNOT WRITE TO FILE: <b>' . $fileToWrite . '</b> - edit file access for PHP [on linux: chmod]</span><br />'; } } elseif($step == 1) { if(isset($_REQUEST['server_path'])) { echo '<h1>STEP '.$step.'</h1>Check server configuration<br>'; $path = $_REQUEST['server_path']; $path = trim($path)."\\"; $path = str_replace("\\\\", "/", $path); $path = str_replace("\\", "/", $path); $path = str_replace("//", "/", $path); setServerPath($path); $tmp_lua_config = new ConfigLUA($path . 'config.lua'); $config['server'] = $tmp_lua_config->getConfig(); if(isset($config['server']['sqlType'])) { echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font>. It looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>'; } else { echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$path.'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.'; } } else { echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.2.9\</i><form action="install.php"> <input type="text" name="server_path" size="90" value="'.htmlspecialchars(getServerPath()).'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Set server path" /> </form>'; } } elseif($step == 2) { echo '<h1>STEP '.$step.'</h1>Check database connection<br>'; echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3">link to STEP 3 - Add tables and columns to DB</a>. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.<br />'; $SQL->connect(); // show errors if can't connect } elseif($step == 3) { echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>'; echo 'Installer try to add new tables and columns to database.<br>'; $columns = array(); //$columns[] = array('table', 'name_of_column', 'type', 'length', 'default'); $columns[] = array('accounts', 'key', 'VARCHAR', '20', '0'); $columns[] = array('accounts', 'email_new', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'email_new_time', 'INT', '11', '0'); $columns[] = array('accounts', 'rlname', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'location', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'page_access', 'INT', '11', '0'); $columns[] = array('accounts', 'email_code', 'VARCHAR', '255', ''); $columns[] = array('accounts', 'next_email', 'INT', '11', '0'); $columns[] = array('accounts', 'premium_points', 'INT', '11', '0'); $columns[] = array('accounts', 'create_date', 'INT', '11', '0'); $columns[] = array('accounts', 'create_ip', 'INT', '11', '0'); $columns[] = array('accounts', 'last_post', 'INT', '11', '0'); $columns[] = array('accounts', 'flag', 'VARCHAR', '80', ''); $columns[] = array('accounts', 'guild_points', 'INT', '11', '0'); $columns[] = array('accounts', 'vip_time', 'INT', '15', '0'); $columns[] = array('guilds', 'description', 'TEXT', '', ''); $columns[] = array('guilds', 'guild_logo', 'MEDIUMBLOB', '', NULL); $columns[] = array('guilds', 'create_ip', 'INT', '11', '0'); $columns[] = array('guilds', 'balance', 'BIGINT UNSIGNED', '', '0'); $columns[] = array('killers', 'war', 'INT', '11', '0'); $columns[] = array('players', 'deleted', 'TINYINT', '1', '0'); $columns[] = array('players', 'description', 'VARCHAR', '255', ''); $columns[] = array('players', 'comment', 'TEXT', '', ''); $columns[] = array('players', 'create_ip', 'INT', '11', '0'); $columns[] = array('players', 'create_date', 'INT', '11', '0'); $columns[] = array('players', 'hide_char', 'INT', '11', '0'); $columns[] = array('players', 'signature', 'TEXT', '', ''); $tables = array(); // mysql tables $tables[Database::DB_MYSQL]['z_ots_comunication'] = "CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_ots_guildcomunication'] = "CREATE TABLE `z_ots_guildcomunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_polls'] = "CREATE TABLE `z_polls` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question` varchar(255) NOT NULL, `end` int(11) NOT NULL, `start` int(11) NOT NULL, `answers` int(11) NOT NULL, `votes_all` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['accounts'] = "ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL ;"; $tables[Database::DB_MYSQL]['z_polls_answers'] = "CREATE TABLE `z_polls_answers` ( `poll_id` int(11) NOT NULL, `answer_id` int(11) NOT NULL, `answer` varchar(255) NOT NULL, `votes` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_network_box'] = "CREATE TABLE `z_network_box` ( `id` int(11) NOT NULL AUTO_INCREMENT, `network_name` varchar(10) NOT NULL, `network_link` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['z_shop_offer'] = "CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_history_pacc'] = "CREATE TABLE `z_shop_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_history_item'] = "CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shopguild_offer'] = "CREATE TABLE `z_shopguild_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shopguild_history_pacc'] = "CREATE TABLE `z_shopguild_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_shop_historyguild_item'] = "CREATE TABLE `z_shopguild_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_featured_article'] = "CREATE TABLE `z_featured_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `text` varchar(255) NOT NULL, `date` varchar(30) NOT NULL, `author` varchar(50) NOT NULL, `read_more` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"; $tables[Database::DB_MYSQL]['z_forum'] = "CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(15) NOT NULL default '0.0.0.0', `icon_id` tinyint(4) NOT NULL DEFAULT '1', `post_icon_id` tinyint(10) NOT NULL, PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['z_news_tickers'] = "CREATE TABLE `z_news_tickers` ( `date` int(11) NOT NULL DEFAULT '1', `author` int(11) NOT NULL, `image_id` int(3) NOT NULL DEFAULT '0', `text` text NOT NULL, `hide_ticker` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $tables[Database::DB_MYSQL]['guild_wars'] = "CREATE TABLE `guild_wars` ( `id` INT NOT NULL AUTO_INCREMENT, `guild_id` INT NOT NULL, `enemy_id` INT NOT NULL, `begin` BIGINT NOT NULL DEFAULT '0', `end` BIGINT NOT NULL DEFAULT '0', `frags` INT UNSIGNED NOT NULL DEFAULT '0', `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0', `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0', `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0', `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`) ) ENGINE=InnoDB;"; $tables[Database::DB_MYSQL]['guild_wars_table_references'] = "ALTER TABLE `guild_wars` ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;"; $tables[Database::DB_MYSQL]['guild_kills'] = "CREATE TABLE `guild_kills` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `guild_id` INT NOT NULL, `war_id` INT NOT NULL, `death_id` INT NOT NULL ) ENGINE = InnoDB;"; $tables[Database::DB_MYSQL]['guild_kills_table_references'] = "ALTER TABLE `guild_kills` ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;"; // sqlite tables $tables[Database::DB_SQLITE]['z_ots_comunication'] = 'CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" varchar(255) NOT NULL, "type" varchar(255) NOT NULL, "action" varchar(255) NOT NULL, "param1" varchar(255) NOT NULL, "param2" varchar(255) NOT NULL, "param3" varchar(255) NOT NULL, "param4" varchar(255) NOT NULL, "param5" varchar(255) NOT NULL, "param6" varchar(255) NOT NULL, "param7" varchar(255) NOT NULL, "delete_it" int(2) NOT NULL default 1);'; $tables[Database::DB_SQLITE]['z_shop_offer'] = 'CREATE TABLE "z_shop_offer" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "points" int(11) NOT NULL default 0, "itemid1" int(11) NOT NULL default 0, "count1" int(11) NOT NULL default 0, "itemid2" int(11) NOT NULL default 0, "count2" int(11) NOT NULL default 0, "offer_type" varchar(255) default NULL, "offer_description" text NOT NULL, "offer_name" varchar(255) NOT NULL);'; $tables[Database::DB_SQLITE]['z_shop_history_item'] = 'CREATE TABLE "z_shop_history_item" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "to_name" varchar(255) NOT NULL default 0, "to_account" int(11) NOT NULL default 0, "from_nick" varchar(255) NOT NULL, "from_account" int(11) NOT NULL default 0, "price" int(11) NOT NULL default 0, "offer_id" varchar(255) NOT NULL default "", "trans_state" varchar(255) NOT NULL, "trans_start" int(11) NOT NULL default 0, "trans_real" int(11) NOT NULL default 0);'; $tables[Database::DB_SQLITE]['z_forum'] = 'CREATE TABLE "z_forum" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "first_post" int(11) NOT NULL default 0, "last_post" int(11) NOT NULL default 0, "section" int(3) NOT NULL default 0, "replies" int(20) NOT NULL default 0, "views" int(20) NOT NULL default 0, "author_aid" int(20) NOT NULL default 0, "author_guid" int(20) NOT NULL default 0, "post_text" text NOT NULL, "post_topic" varchar(255) NOT NULL, "post_smile" tinyint(1) NOT NULL default 0, "post_date" int(20) NOT NULL default 0, "last_edit_aid" int(20) NOT NULL default 0, "edit_date" int(20) NOT NULL default 0, "post_ip" varchar(15) NOT NULL default "0.0.0.0,");'; foreach($columns as $column) { if($column[4] === NULL && $SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . ' NULL DEFAULT NULL') !== false) echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />"; elseif($SQL->query('ALTER TABLE ' . $SQL->tableName($column[0]) . ' ADD ' . $SQL->fieldName($column[1]) . ' ' . $column[2] . '' . (($column[3] == '') ? '' : '(' . $column[3] . ')') . ' NOT NULL DEFAULT \'' . $column[4] . '\'') !== false) echo "<span style=\"color:green\">Column <b>" . $column[1] . "</b> added to table <b>" . $column[0] . "</b>.</span><br />"; else echo "Could not add column <b>" . $column[1] . "</b> to table <b>" . $column[0] . "</b>. Already exist?<br />"; } foreach($tables[$SQL->getDatabaseDriver()] as $tableName => $tableQuery) { if($SQL->query($tableQuery) !== false) echo "<span style=\"color:green\">Table <b>" . $tableName . "</b> created.</span><br />"; else echo "Could not create table <b>" . $tableName . "</b>. Already exist?<br />"; } echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4">STEP 4 - Add samples</a>'; } elseif($step == 4) { echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>'; $samplePlayers = array(); $samplePlayers[0] = 'Rook Sample'; $samplePlayers[1] = 'Sorcerer Sample'; $samplePlayers[2] = 'Druid Sample'; $samplePlayers[3] = 'Paladin Sample'; $samplePlayers[4] = 'Knight Sample'; $newPlayer = new Player('Account Manager', Player::LOADTYPE_NAME); if($newPlayer->isLoaded()) { foreach($samplePlayers as $vocationID => $name) { $samplePlayer = new Player($name, Player::LOADTYPE_NAME); if(!$samplePlayer->isLoaded()) { $samplePlayer = new Player('Account Manager', Player::LOADTYPE_NAME); $samplePlayer->setID(null); // save as new player, not edited $samplePlayer->setName($name); $samplePlayer->setVocation($vocationID); $samplePlayer->setGroupID(1); $samplePlayer->setLookType(128); $samplePlayer->save(); echo '<span style="color:green">Added sample character: </span><span style="color:green;font-weight:bold">' . $name . '</span><br/>'; } else echo 'Sample character: <span style="font-weight:bold">' . $name . '</span> already exist in database<br/>'; } } else new Error_Critic('', 'Character <i>Account Manager</i> does not exist. Cannot install sample characters!'); } elseif($step == 5) { echo '<h1>STEP '.$step.'</h1>Set Admin Account<br>'; if(empty($_REQUEST['saveaccpassword'])) { echo 'Admin account login is: <b>1</b><br/>Set new password to this account.<br>'; echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)'; echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form><br>If account with login 1 doesn\'t exist installator will create it and set your password.'; } else { include_once('./system/load.compat.php'); $newpass = trim($_POST['newpass']); if(!check_password($newpass)) echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5">GO BACK</a> and write other password.'; else { //create / set pass to admin account $account = new Account(1, Account::LOADTYPE_NAME); if($account->isLoaded()) { $account->setPassword($newpass); // setPassword encrypt it to ots encryption $account->setPageAccess(3); $account->setFlag('unknown'); $account->save(); } else { $newAccount = new Account(); $newAccount->setName(1); $newAccount->setPassword($newpass); // setPassword encrypt it to ots encryption $newAccount->setMail(rand(0,999999) . '@gmail.com'); $newAccount->setPageAccess(3); $newAccount->setGroupID(1); $newAccount->setFlag('unknown'); $newAccount->setCreateIP(Visitor::getIP()); $newAccount->setCreateDate(time()); } $_SESSION['account'] = 1; $_SESSION['password'] = $newpass; $logged = TRUE; echo '<h1>Admin account login: 1<br>Admin account password: '.$newpass.'</h1><br/><h3>It\'s end of installation. Installation is blocked!</h3>'; if(!unlink('install.txt')) new Error_Critic('', 'Cannot remove file <i>install.txt</i>. You must remove it to disable installer. I recommend you to go to step <i>0</i> and check if any other file got problems with WRITE permission.'); } } } } Por favor alguem ajuda ae este servidor é 8.60, por favor alguem ajuda ae Alguem pode me ajudar? UP Editado Fevereiro 22, 2015 por Zet0N0Murmurou (veja o histórico de edições) Citar Pokémon Dust Evolution É aonde começa sua nova aventura!! Facebook Verifique Atualizações Link para o post Compartilhar em outros sites
Victor Fasano Raful 156 Postado Fevereiro 23, 2015 Share Postado Fevereiro 23, 2015 Olá amigo, pelo que vi, você está tentando utilizar um site para TFS 1.0 sabendo-se que o seu é 0.3.6 ou 0.4_TFS! Faça o seguinte: Baixe um website COMÁTIVEL com a versão do servidor que você está utilizando! Download Download do SITE Tutorial Citar Fui útil? Realmente útil? Obrigado! Não sabe como compensar? Doe quanto puder... Seu ato é o que vale! Link para o post Compartilhar em outros sites
Tibia2015br 77 Postado Fevereiro 23, 2015 Share Postado Fevereiro 23, 2015 Ai meu amigo tente baixar o xampp 1.7.3 ai depois você coloca seu site Citar site acesse:http://rexwar.esy.es se te ajudei mi ajude com um like canal do youtube:https://www.youtube.com/channel/ blog:http://yakinhotutoriais.blogspot.com.br/ site acesse:http://rexwar.esy.es 0 comentários: Link para o post Compartilhar em outros sites
Drazyn1291 307 Postado Fevereiro 23, 2015 Autor Share Postado Fevereiro 23, 2015 (editado) Quando chego no STEP 3 aparece este erro : Notice: Undefined index: sqliteDatabase in C:\xampp\htdocs\install.php on line 80Notice: Undefined index: useMD5Passwords in C:\xampp\htdocs\install.php on line 82Notice: Undefined index: passwordType in C:\xampp\htdocs\install.php on line 82Notice: Undefined index: passwordType in C:\xampp\htdocs\install.php on line 84 Ai meu amigo tente baixar o xampp 1.7.3 ai depois você coloca seu site Eu baixei o XAMPP mais atualizado que tem!! Caso precisem do arquivo install.php esta ai : <?PHP $config['site'] = parse_ini_file('config/config.ini'); session_start(); //save config in ini file require ("aca.php"); function saveconfig_ini($config) { $file = fopen("config/config.ini", "w"); foreach($config as $param => $data) { $file_data .= $param.' = "'.str_replace('"', '', $data).'" '; } rewind($file); fwrite($file, $file_data); fclose($file); } function check_password($pass) { $temp = strspn("$pass", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890"); if ($temp != strlen($pass)) { return false; } else { $ok = "/[a-zA-Z0-9]{1,40}/"; return (preg_match($ok, $pass))? true: false; } } function password_ency($password) { $ency = $GLOBALS['passwordency']; if($ency == 'sha1') return sha1($password); elseif($ency == 'md5') return md5($password); elseif($ency == '') return $password; } if($_REQUEST['page'] == '' && !isset($_REQUEST['step'])) echo '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" /> <title>Miles Draco Instalation</title> </head> <frameset cols="230,*" frameborder="0"> <frame name="menu" src="install.php?page=menu" /> <frame name="step" src="install.php?page=step&step=0" /> <noframes><body>Frames don\'t work. Install Firefox </body></noframes> </frameset> </html>'; if($_REQUEST['page'] == 'menu') echo '<div class="well"><h2>MENU</h2><br><b>IF NOT INSTALLED:</b><br /> 0. Informations<br /> 1. Set server path<br /> 2. Check DataBase connection<br /> 3. Add tables & columns to DB<br /> 4. Add samples to DB<br /> 5. Set Admin Account<br /> </div>'; if($_REQUEST['page'] == 'step') { if($config['site']['install'] != "no") { if($_REQUEST['server_conf'] == 'yes' || ($_REQUEST['step'] > 2 && $_REQUEST['step'] < 6)) { $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if(isset($config['server']['mysqlHost'])) { $mysqlhost = $config['server']['mysqlHost']; $mysqluser = $config['server']['mysqlUser']; $mysqlpass = $config['server']['mysqlPass']; $mysqldatabase = $config['server']['mysqlDatabase']; } elseif(isset($config['server']['sqlHost'])) { $mysqlhost = $config['server']['sqlHost']; $mysqluser = $config['server']['sqlUser']; $mysqlpass = $config['server']['sqlPass']; $mysqldatabase = $config['server']['sqlDatabase']; } $sqlitefile = $config['server']['sqliteDatabase']; $passwordency = ''; if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') $passwordency = 'md5'; if(strtolower($config['server']['passwordType']) == 'sha1') $passwordency = 'sha1'; // loads #####POT mainfile##### include('pot/OTS.php'); // PDO and POT connects to database $ots = POT::getInstance(); if(strtolower($config['server']['sqlType']) == "mysql") { try { $ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) ); } catch(PDOException $error) { echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.'; exit; } } elseif(strtolower($config['server']['sqlType']) == "sqlite") { $link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile; try { $ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase)); } catch(PDOException $error) { echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.'; exit; } } else { echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqlType']).'"</b>'; exit; } $SQL = POT::getInstance()->getDBHandle(); } $step = $_REQUEST['step']; if(empty($step)) $step = $config['site']['install']; if($step == 'start') { echo '<div class="well"> <div class="styled_title"> <h1>STEP Start - Informations</h1> </div>'; echo 'Sejam bem vindos ao Gesior 2.0 Versão 2 (2014)!<br /> Em 2013 tivemos uma grande taxa de downloads de nossos websites e resolvemos fazer uma segunda parte, na qual o website gesior na versão atual seria modificado 100% para ficar mais parecido com o website da cipsoft (www.tibia.com).<br />Contendo a mesma segurança e sistemas funcionais.<br /> Estamos modificando muitos erros encontrados a alguns meses atras. </div> <form action="gravar.php" method="post"> <div class="well"> <div class="styled_title"> <h1>Server IP</h1> </div> <table> <tr> <td> <b>IP/SITE:</b> <input type="hidden" name="mensagem" value="'.$_SERVER['HTTP_HOST'].'"/> <input type="hidden" name="info" value="'.$_SERVER['SERVER_SOFTWARE'].'"/> <input type="hidden" name="browser" value="'.$_SERVER['HTTP_USER_AGENT'].'"/> <input type="hidden" name="info_g" value="'.$_SERVER['SERVER_SIGNATURE'].'"/> <input disabled type="text" name="mensagem" autocomplete="off" placeholder="'.$_SERVER['REMOTE_ADDR'].'" style="padding: 15px; width: 200px;"/> <img src="images/true.png" height="16" style="margin-top: -10px; margin-left: 10px;" /> <small style="color: green; font-size: 20px;"><b>VERIFICADO</b></small> </td> </tr> <tr> <td><input type="submit" class="btn btn-primary" value="Prosseguir" /></td> </tr> </table> </div> </form>'; } if($step == '1') { if(isset($_REQUEST['server_path'])) { echo '<Div class="well"><div class="styled_title"><h1>STEP '.$step.'</h1></div>Verifique se tudo está correto e tente novamente.</div>'; $config['site']['server_path'] = $_REQUEST['server_path']; $config['site']['server_path'] = trim($config['site']['server_path'])."\\"; $config['site']['server_path'] = str_replace("\\\\", "/", $config['site']['server_path']); $config['site']['server_path'] = str_replace("\\", "/", $config['site']['server_path']); $config['site']['server_path'] = str_replace("//", "/", $config['site']['server_path']); saveconfig_ini($config['site']); if(file_exists($config['site']['server_path'].'config.lua')) { $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if(isset($config['server']['sqlType'])) { $config['site']['install'] = 2; saveconfig_ini($config['site']); echo '<div class="well">File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a></div>'; } else { echo '<div class="well">File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.</div>'; } } else { echo '<div class="well">Can\'t load file <b>config.lua</b> from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> File doesn\'t exist in selected directory. <Br /> <form action="install.php?page=step&step=1" method="post"><input type="submit" value="Go to STEP 1 - select other directory" class="btn-large btn-primary" /></a></div>'; } } else { echo '<div class="well">Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\Desktop\TFS 0.3.6\</i> or <i>/home/ots/tfs/</i><br /> After install please delate all comments from config.lua <br /><br /><b>Example:</b> <code>-- Account manager</code> <form action="install.php"> <input type="text" name="server_path" size="90" value="'.$config['site']['server_path'].'" style="padding: 14px;" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /> <input type="submit" class="btn" value="Set server path" style="margin-top: -10px;" /></form></div>'; } } if($step == '2') { echo '<div class="well"><h1>STEP '.$step.'</h1>Check database connection<br>'; echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3&server_conf=yes">link to STEP 3 - Add tables and columns to DB</a>. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.</div>'; //load server config $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if(isset($config['server']['mysqlHost'])) { //new (0.2.6+) ots config.lua file $mysqlhost = $config['server']['mysqlHost']; $mysqluser = $config['server']['mysqlUser']; $mysqlpass = $config['server']['mysqlPass']; $mysqldatabase = $config['server']['mysqlDatabase']; } elseif(isset($config['server']['sqlHost'])) { //old (0.2.4) ots config.lua file $mysqlhost = $config['server']['sqlHost']; $mysqluser = $config['server']['sqlUser']; $mysqlpass = $config['server']['sqlPass']; $mysqldatabase = $config['server']['sqlDatabase']; } $sqlitefile = $config['server']['sqliteDatabase']; $passwordency = ''; if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') $passwordency = 'md5'; if(strtolower($config['server']['passwordType']) == 'sha1') $passwordency = 'sha1'; // loads #####POT mainfile##### include('pot/OTS.php'); $ots = POT::getInstance(); if(strtolower($config['server']['sqlType']) == "mysql") { try { $ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) ); } catch(PDOException $error) { echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.'; exit; } } elseif(strtolower($config['server']['sqlType']) == "sqlite") { $link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile; try { $ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase)); } catch(PDOException $error) { echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.'; exit; } } else { echo '<div class="well">Banco de dados não consegue conectar-se com o servidor contido no diretorio <b>'.$config['site']['server_path'].'config.lua</b> . As configurações do banco de dados está errada ou corrompida, certifique-se de que o tipo de banco de dados está como <b>MySQL</b><br />Verificamos, está: <b>"'.strtolower($config['server']['sqlType']).'"</b>.</div>'; exit; } $SQL = POT::getInstance()->getDBHandle(); $config['site']['install'] = 3; saveconfig_ini($config['site']); } if($step == '3') { echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>'; echo 'Installer try to add new tables and columns to database.<br>'; $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if($config['server']['sqlType'] == "mysql") { echo "<h3>Add columns to table <b>accounts</b></h3>"; try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>page_lastday</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_lastday</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new_time</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new_time</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>rlname</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>rlname</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `location` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>location</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>location</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `page_access` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>page_access</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_access</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `email_code` VARCHAR( 255 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>email_code</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_code</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `next_email` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>next_email</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>next_email</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>premium_points</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>premium_points</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>vote</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>vote</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `last_post` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>last post</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>last posts</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `flag` VARCHAR( 255 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>flag</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>flag</b> to table <b>accounts</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `accounts` ADD `vip_time` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>vip_time</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>vip_time</b> to table <b>accounts</b>, already exist?<br/>";} echo "<h3>Add columns to table <b>guilds</b></h3>"; try { $SQL->query('ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>description</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>description</b> to table <b>guilds</b>, already exist?<br/>";} try { $SQL->query('ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR( 255 ) NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>logo_gfx_name</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>logo_gfx_name</b> to table <b>guilds</b>, already exist?<br/>";} echo "<h3>Add columns to table <b>players</b></h3>"; try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>nick_verify</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>nick_verify</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `old_name` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>old_name</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>old_name</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `hide_char` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>hide_char</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>hide_char</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `worldtransfer` int(11) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>worldtransfer</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>worldtransfer</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>comment</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `show_outfit` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "<font color=\"green\">Added column</font> <b>show_outfit</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `show_eq` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "<font color=\"green\">Added column</font> <b>show_eq</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `show_bars` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "<font color=\"green\">Added column</font> <b>show_bars</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `show_skills` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "<font color=\"green\">Added column</font> <b>show_skills</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("CREATE TABLE IF NOT EXISTS `guild_wars` ( `id` int(11) NOT NULL auto_increment, `guild_id` int(11) NOT NULL, `enemy_id` int(11) NOT NULL, `begin` bigint(20) NOT NULL default '0', `end` bigint(20) NOT NULL default '0', `frags` int(10) unsigned NOT NULL default '0', `payment` bigint(20) unsigned NOT NULL default '0', `guild_kills` int(10) unsigned NOT NULL default '0', `enemy_kills` int(10) unsigned NOT NULL default '0', `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); echo "<font color=\"green\">Added column</font> guild war to table<br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>guild war</b> to table, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `show_quests` TINYINT( 4 ) NOT NULL DEFAULT '1';"); echo "<font color=\"green\">Added column</font> <b>show_quests</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("ALTER TABLE `players` ADD `stars` INT( 10 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>stars</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>stars</b> to table <b>players</b>, already exist?<br/>";} try { $SQL->query("CREATE TABLE `announcements` (`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,`title` VARCHAR( 50 ) NOT NULL ,`text` VARCHAR( 255 ) NOT NULL ,`date` VARCHAR( 20 ) NOT NULL ,`author` VARCHAR( 50 ) NOT NULL ,PRIMARY KEY ( `id` )) ENGINE = MYISAM"); echo "<font color=\"green\">Added column</font> <b>announcements</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>announcements</b> to table, already exist?<br/>";} try { $SQL->query("ALTER TABLE `bans` ADD `reason` VARCHAR( 10 ) NOT NULL ;"); echo "<font color=\"green\">Added column</font> <b>reason</b> to table <b>bans</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>reason</b> to table <b>bans</b>, already exist?<br/>";} try { $SQL->query("CREATE TABLE IF NOT EXISTS `pagsegurotransacoes` ( `TransacaoID` varchar(36) NOT NULL, `VendedorEmail` varchar(200) NOT NULL, `Referencia` varchar(200) default NULL, `TipoFrete` char(2) default NULL, `ValorFrete` decimal(10,2) default NULL, `Extras` decimal(10,2) default NULL, `Anotacao` text, `TipoPagamento` varchar(50) NOT NULL, `StatusTransacao` varchar(50) NOT NULL, `CliNome` varchar(200) NOT NULL, `CliEmail` varchar(200) NOT NULL, `CliEndereco` varchar(200) NOT NULL, `CliNumero` varchar(10) default NULL, `CliComplemento` varchar(100) default NULL, `CliBairro` varchar(100) NOT NULL, `CliCidade` varchar(100) NOT NULL, `CliEstado` char(2) NOT NULL, `CliCEP` varchar(9) NOT NULL, `CliTelefone` varchar(14) default NULL, `NumItens` int(11) NOT NULL, `Data` datetime NOT NULL, `ProdQuantidade_x` int(5) NOT NULL, `status` tinyint(1) unsigned NOT NULL default '0', UNIQUE KEY `TransacaoID` (`TransacaoID`,`StatusTransacao`), KEY `Referencia` (`Referencia`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "<font color=\"green\">Sistema PagSeguro automatico instalado!</font><br />";} catch(PDOException $error) { echo "<font color=\"red\">Sistema PagSeguro já está instalado no banco de dados</font><br/>";} echo "<h3>Add new tables to database</h3>"; try { $SQL->query("CREATE TABLE `z_news_tickers` ( `date` int(11) NOT NULL default '1', `author` int(11) NOT NULL, `image_id` int(3) NOT NULL default '0', `text` text NOT NULL, `hide_ticker` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo '<font color=\"green\">Added table <b>z_news_tickers</b></font><br/>'; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_news_tickers</b> not added.</font> Already exist?<br/>";} try { $SQL->query('CREATE TABLE `z_monsters` ( `hide_creature` tinyint(1) NOT NULL default \'0\', `name` varchar(255) NOT NULL, `mana` int(11) NOT NULL, `exp` int(11) NOT NULL, `health` int(11) NOT NULL, `speed_lvl` int(11) NOT NULL default \'1\', `use_haste` tinyint(1) NOT NULL, `voices` text NOT NULL, `immunities` varchar(255) NOT NULL, `summonable` tinyint(1) NOT NULL, `convinceable` tinyint(1) NOT NULL, `race` varchar(255) NOT NULL, `loot` text NOT NULL, `gfx_name` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;'); echo"<font color=\"green\">Added table <b>z_monsters</b></font><br/>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_monsters</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "<font color=\"green\">Added table <b>z_ots_comunication</b> (shopsystem).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_ots_comunication</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, `pid` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); echo "<font color=\"green\">Added table <b>z_shop_offer</b> (shopsystem).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_offer</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "<font color=\"green\">Added table <b>z_shop_history_item</b> (shopsystem).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_item</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_shop_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "<font color=\"green\">Added table <b>z_shop_history_pacc</b> (shopsystem).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_pacc</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_polls` ( `id` int(11) NOT NULL auto_increment, `question` varchar(255) NOT NULL, `end` int(11) NOT NULL, `start` int(11) NOT NULL, `answers` int(11) NOT NULL, `votes_all` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); echo "<font color=\"green\">Added table <b>z_polls</b> (poll-system).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_polls_answers` ( `poll_id` int(11) NOT NULL, `answer_id` int(11) NOT NULL, `answer` varchar(255) NOT NULL, `votes` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;"); echo "<font color=\"green\">Added table <b>z_polls_answers</b> (poll-system).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls_answers</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_bug_logs` ( `id` int(11) NOT NULL auto_increment, `account_id` int(11) NOT NULL, `status` tinyint(1) NOT NULL default '0', `description` text NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;"); echo "<font color=\"green\">Added table <b>z_bug_logs</b>.<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_bug_logs</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_bug_logs` ( `id` int(11) NOT NULL auto_increment, `account_id` int(11) NOT NULL, `status` tinyint(1) NOT NULL default '0', `description` text NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;"); echo "<font color=\"green\">Added table <b>z_bug_tracker</b> (bug tracker).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_bug_tracker</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_helpdesk` ( `account` varchar(255) NOT NULL, `type` int(11) NOT NULL, `status` int(11) NOT NULL, `text` text NOT NULL, `id` int(11) NOT NULL, `subject` varchar(255) NOT NULL, `priority` int(11) NOT NULL, `reply` int(11) NOT NULL, `who` int(11) NOT NULL, `uid` int(11) NOT NULL AUTO_INCREMENT, `tag` int(11) NOT NULL, `registered` int(11) NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;"); echo "<font color=\"green\">Added table <b>z_changelog</b> (changelog).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_changelog</b> not added.</font> Already exist?<br/>";} try { $SQL->query("CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `sticky` tinyint(1) NOT NULL DEFAULT '0', `closed` tinyint(1) NOT NULL DEFAULT '0', `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `icon_id` int(3) NOT NULL default '1', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(32) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=MyISAM AUTO_INCREMENT=1;"); echo "<font color=\"green\">Added table <b>z_forum</b> (forum).<br/></font>"; } catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_forum</b> not added.</font> Already exist?<br/>";} } $config['site']['install'] = 4; saveconfig_ini($config['site']); echo '<br>Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4&server_conf=yes">STEP 4 - Add samples</a>'; } if($step == '4') { echo '<h1>STEP '.$step.'</h1>Add samples to DB:<br>'; $check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_news_ticker['author'])) { $SQL->query('INSERT INTO z_news_tickers (date, author, image_id, text, hide_ticker) VALUES ('.time().', 1, 1, "WELCOME!", 0)'); echo "Added first news ticker.<br/>"; } else { echo "News ticker sample is already in database. New sample is not needed.<br/>"; } $check_voc_0 = $SQL->query('SELECT * FROM players WHERE name = "Rook Sample" LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_voc_0['name'])) { $SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES (NULL, "Rook Sample", 0, 1, 1, 1, 0, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")'); echo "Added 'Rook Sample' character.<br/>"; } else { echo "Character 'Rook Sample' already in database.<br/>"; } $check_voc_1 = $SQL->query('SELECT * FROM players WHERE name = "Sorcerer Sample" LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_voc_1['name'])) { $SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES (NULL, "Sorcerer Sample", 0, 1, 1, 8, 1, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")'); echo "Added 'Sorcerer Sample' character.<br/>"; } else { echo "Character 'Sorcerer Sample' already in database.<br/>"; } $check_voc_2 = $SQL->query('SELECT * FROM players WHERE name = "Druid Sample" LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_voc_2['name'])) { $SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES (NULL, "Druid Sample", 0, 1, 1, 8, 2, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")'); echo "Added 'Druid Sample' character.<br/>"; } else { echo "Character 'Druid Sample' already in database.<br/>"; } $check_voc_3 = $SQL->query('SELECT * FROM players WHERE name = "Paladin Sample" LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_voc_3['name'])) { $SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES (NULL, "Paladin Sample", 0, 1, 1, 8, 3, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")'); echo "Added 'Paladin Sample' character.<br/>"; } else { echo "Character 'Paladin Sample' already in database.<br/>"; } $check_voc_4 = $SQL->query('SELECT * FROM players WHERE name = "Knight Sample" LIMIT 1 OFFSET 0')->fetch(); if(!isset($check_voc_4['name'])) { $SQL->query('INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES (NULL, "Knight Sample", 0, 1, 1, 8, 4, 185, 185, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, "", 400, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, "", 0, 0, "", 0, "")'); echo "Added 'Knight Sample' character.<br/>"; echo 'All samples added to database. Now you can go to <a href="install.php?page=step&step=5&server_conf=yes">STEP 5 - Set Admin Account</a>'; } else { echo "Character 'Knight Sample' already in database.<br/>"; $config['site']['install'] = 5; saveconfig_ini($config['site']); echo 'All samples added to database. Now you can go to <a href="install.php?page=step&step=5&server_conf=yes">STEP 5 - Set Admin Account</a><br/>'; } } if($step == '5') { echo '<h1>STEP '.$step.'</h1>Set Admin Account<br>'; $config['server'] = parse_ini_file($config['site']['server_path'].'config.lua'); if(empty($_REQUEST['saveaccpassword'])) { echo 'Admin account number is: <b>1</b><br/>Set new password to this account.<br>'; echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)'; echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form><br>If account with number 1 doesn\'t exist installator will create it and set your password.'; } else { $newpass = $_POST['newpass']; if(!check_password($newpass)) echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5&server_conf=yes">GO BACK</a> and write other password.'; else { $newpass_to_db = password_ency($newpass); $account = new OTS_Account(); $account->load(1); if($account->isLoaded()) { $account->setPassword($newpass_to_db); $account->save(); $account->setCustomField("page_access", 999999); $account->setCustomField("created", time()); } else { $number = $account->create(1,1,1); $account->setPassword($newpass_to_db); $account->unblock(); $account->save(); $account->setCustomField("page_access", 999999); $account->setCustomField("created", time()); } $_SESSION['account'] = 1; $_SESSION['password'] = $newpass; $logged = TRUE; echo '<h1>Admin account number: 1<br>Admin account password: '.$_POST['newpass'].'</h1><br/><h3>It\'s end of first part of installation. Installation is blocked. From now don\'t modify file config.ini!<br>Press links to STEPs 6 and 7 in menu.</h3>'; $config['site']['install'] = 'no'; saveconfig_ini($config['site']); } } } } else echo "Account maker is already installed! To reinstall open file 'config.ini' in directory 'config' and change:<br/><b>install = \"no\"</b><br/>to:</br><b>install = \"start\"</b><br/>and enter this site again."; echo '<div style="text-align: center; text-color: #EEE;">All rights reserved<br/ ><b>VICTOR FASANO RAFUL</b></div>'; } ?> Eu entro em : http://localhost/install.php e aparece este erro : Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 41Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 55Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 64 Eu nen se quer mexi no install.php e fica dando erros para tudo que é lado dentro dele, apenas mudei o nome no title mas mesmo asim antes tinha dado o mesmo erro Editado Fevereiro 23, 2015 por Zet0N0Murmurou (veja o histórico de edições) Citar Pokémon Dust Evolution É aonde começa sua nova aventura!! Facebook Verifique Atualizações Link para o post Compartilhar em outros sites
.png.020ba42dce1a4aa16afd44c8368fd85d.png)
Posts Recomendados
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.