Postado Junho 30, 2015 10 anos Bom estou com o seguinte erro na instalação do ACC : Preciso de ajuda, peço encarecidamente que alguém me ajude kk. Init.php $l_time = microtime(); $l_time = explode(' ', $l_time); $l_time = $l_time[1] + $l_time[0]; $l_start = $l_time; function elapsedTime($l_start = false, $l_time = false) { if ($l_start === false) global $l_start; if ($l_time === false) global $l_time; $l_time = explode(' ', microtime()); $l_finish = $l_time[1] + $l_time[0]; return round(($l_finish - $l_start), 4); } $time = time(); $version = '1.5_SVN'; $aacQueries = 0; $accQueriesData = array(); session_start(); ob_start(); require_once 'config.php'; $sessionPrefix = $config['session_prefix']; if ($config['paypal']['enabled'] || $config['zeotss']['enabled']) { $curlcheck = function_exists('curl_version') ? true : false; if (!$curlcheck) die("php cURL is not enabled. It is required to for paypal and ZEOTSS services. 1. Find your php.ini file. 2. Uncomment extension=php_curl Restart web server.If you don't want this then disable zeotss and paypal in config.php."); } require_once 'database/connect.php'; require_once 'function/general.php'; require_once 'function/users.php'; require_once 'function/cache.php'; require_once 'function/mail.php'; require_once 'function/token.php'; require_once 'function/itemparser/itemlistparser.php'; if (isset($_SESSION['token'])) { $_SESSION['old_token'] = $_SESSION['token']; } Token::generate(); if (user_logged_in() === true) { $session_user_id = getSession('user_id'); $user_data = user_data($session_user_id, 'id', 'name', 'password', 'email', 'premdays'); $user_znote_data = user_znote_account_data($session_user_id, 'ip', 'created', 'points', 'cooldown'); } $errors = array(); // Log IP if ($config['log_ip']) { $visitor_config = $config['ip_security']; $flush = $config['flush_ip_logs']; if ($flush != false) { $timef = $time - $flush; if (getCache() < $timef) { $timef = $time - $visitor_config['time_period']; mysql_delete("DELETE FROM znote_visitors_details WHERE time <= '$timef'"); setCache($time); } } $visitor_data = znote_visitors_get_data(); znote_visitor_set_data($visitor_data); // update or insert data znote_visitor_insert_detailed_data(0); // detailed data $visitor_detailed = znote_visitors_get_detailed_data($visitor_config['time_period']); // max activity $v_activity = 0; $v_register = 0; $v_highscore = 0; $v_c_char = 0; $v_s_char = 0; $v_form = 0; foreach ((array)$visitor_detailed as $v_d) { // Activity if ($v_d['ip'] == ip2long(getIP())) { // count each type of visit switch ($v_d['type']) { case 0: // max activity $v_activity++; break; case 1: // account registered $v_register++; $v_form++; break; case 2: // character creations $v_c_char++; $v_form++; break; case 3: // Highscore fetched $v_highscore++; $v_form++; break; case 4: // character searched $v_s_char++; $v_form++; break; case 5: // Other forms (login.?) $v_form++; break; } } } // Deny access if activity is too high if ($v_activity > $visitor_config['max_activity']) die("Chill down. Your web activity is too big. max_activity"); if ($v_register > $visitor_config['max_account']) die("Chill down. You can't create multiple accounts that fast. max_account"); if ($v_c_char > $visitor_config['max_character']) die("Chill down. Your web activity is too big. max_character"); if ($v_form > $visitor_config['max_post']) die("Chill down. Your web activity is too big. max_post"); //var_dump($v_activity, $v_register, $v_highscore, $v_c_char, $v_s_char, $v_form); //echo ' <--- IP logging activity past 10 seconds.'; } // Sub page override system if ($config['allowSubPages']) { require_once 'layout/sub.php'; $filename = explode('/', $_SERVER['PHP_SELF']); $filename = $filename[count($filename)-1]; if (isset($subpages) && !empty($subpages)) { foreach ($subpages as $page) { if ($page['override'] && $page['file'] === $filename) { require_once 'layout/overall/header.php'; require_once 'layout/sub/'.$page['file']; require_once 'layout/overall/footer.php'; exit; } } } else { ?> Old layout!The layout is running an outdated sub system which is not compatible with this version of Znote AAC. The file /layout/sub.php is outdated. Please update it to look like THIS. } } ?> Connect.php $time = time(); if (!isset($version)) $version = '1.5_SVN'; $install = " Install: Make sure you have imported TFS database. (OTdir/schemas+Database/compact.sql) Import the below schema to a TFS database in phpmyadmin: <br>CREATE TABLE IF NOT EXISTS `znote` (<br> `id` int(10) NOT NULL AUTO_INCREMENT,<br> `version` varchar(30) NOT NULL COMMENT 'Znote AAC version',<br> `installed` int(10) NOT NULL,<br> `cached` int(11) DEFAULT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br><br>INSERT INTO `znote` (`version`, `installed`) VALUES<br>('$version', '$time');<br><br>CREATE TABLE IF NOT EXISTS `znote_accounts` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `account_id` int(11) NOT NULL,<br> `ip` int(10) NOT NULL,<br> `created` int(10) NOT NULL,<br> `points` int(10) DEFAULT 0,<br> `cooldown` int(10) DEFAULT 0,<br> `active` tinyint(4) NOT NULL DEFAULT '0',<br> `activekey` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br><br>INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES<br>('1', '0', '$time');<br><br>CREATE TABLE IF NOT EXISTS `znote_news` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `title` varchar(30) NOT NULL,<br> `text` text NOT NULL,<br> `date` int(11) NOT NULL,<br> `pid` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_images` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `title` varchar(30) NOT NULL,<br> `desc` text NOT NULL,<br> `date` int(11) NOT NULL,<br> `status` int(11) NOT NULL,<br> `image` varchar(30) NOT NULL,<br> `account_id` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_paypal` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `txn_id` varchar(30) NOT NULL,<br> `email` varchar(255) NOT NULL,<br> `accid` int(11) NOT NULL,<br> `price` int(11) NOT NULL,<br> `points` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_paygol` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `account_id` int(11) NOT NULL,<br> `price` int(11) NOT NULL,<br> `points` int(11) NOT NULL,<br> `message_id` varchar(255) NOT NULL,<br> `service_id` varchar(255) NOT NULL,<br> `shortcode` varchar(255) NOT NULL,<br> `keyword` varchar(255) NOT NULL,<br> `message` varchar(255) NOT NULL,<br> `sender` varchar(255) NOT NULL,<br> `operator` varchar(255) NOT NULL,<br> `country` varchar(255) NOT NULL,<br> `currency` varchar(255) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_players` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `player_id` int(11) NOT NULL,<br> `created` int(11) NOT NULL,<br> `hide_char` tinyint(4) NOT NULL,<br> `comment` varchar(255) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES<br>('1', '$time', '0', '. . .');<br><br>CREATE TABLE IF NOT EXISTS `znote_player_reports` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `name` varchar(50) NOT NULL,<br> `posx` int(6) NOT NULL,<br> `posy` int(6) NOT NULL,<br> `posz` int(6) NOT NULL,<br> `report_description` VARCHAR(255) NOT NULL,<br> `date` INT(11) NOT NULL,<br> `status` TINYINT(3) NOT NULL DEFAULT '0',<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_changelog` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `text` VARCHAR(255) NOT NULL,<br> `time` INT(11) NOT NULL,<br> `report_id` INT(11) NOT NULL,<br> `status` TINYINT(3) NOT NULL DEFAULT '0',<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_shop` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `type` int(11) NOT NULL,<br> `itemid` int(11) DEFAULT NULL,<br> `count` int(11) NOT NULL DEFAULT '1',<br> `description` varchar(255) NOT NULL,<br> `points` int(11) NOT NULL DEFAULT '10',<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_shop_logs` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `account_id` int(11) NOT NULL,<br> `player_id` int(11) NOT NULL,<br> `type` int(11) NOT NULL,<br> `itemid` int(11) NOT NULL,<br> `count` int(11) NOT NULL,<br> `points` int(11) NOT NULL,<br> `time` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_shop_orders` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `account_id` int(11) NOT NULL,<br> `type` int(11) NOT NULL,<br> `itemid` int(11) NOT NULL,<br> `count` int(11) NOT NULL,<br> `time` int(11) NOT NULL DEFAULT '0',<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_visitors` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `ip` int(11) NOT NULL,<br> `value` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_visitors_details` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `ip` int(11) NOT NULL,<br> `time` int(11) NOT NULL,<br> `type` tinyint(4) NOT NULL,<br> `account_id` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_forum` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `name` varchar(50) NOT NULL,<br> `access` tinyint(4) NOT NULL,<br> `closed` tinyint(4) NOT NULL,<br> `hidden` tinyint(4) NOT NULL,<br> `guild_id` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES<br>('Staff Board', '4', '0', '0', '0'),<br>('Tutors Board', '2', '0', '0', '0'),<br>('Discussion', '1', '0', '0', '0'),<br>('Feedback', '1', '0', '1', '0');<br><br>CREATE TABLE IF NOT EXISTS `znote_forum_threads` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `forum_id` int(11) NOT NULL,<br> `player_id` int(11) NOT NULL,<br> `player_name` varchar(50) NOT NULL,<br> `title` varchar(50) NOT NULL,<br> `text` text NOT NULL,<br> `created` int(11) NOT NULL,<br> `updated` int(11) NOT NULL,<br> `sticky` tinyint(4) NOT NULL,<br> `hidden` tinyint(4) NOT NULL,<br> `closed` tinyint(4) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_forum_posts` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `thread_id` int(11) NOT NULL,<br> `player_id` int(11) NOT NULL,<br> `player_name` varchar(50) NOT NULL,<br> `text` text NOT NULL,<br> `created` int(11) NOT NULL,<br> `updated` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_deleted_characters` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `original_account_id` int(11) NOT NULL,<br> `character_name` varchar(255) NOT NULL,<br> `time` datetime NOT NULL,<br> `done` tinyint(1) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_guild_wars` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `limit` int(11) NOT NULL DEFAULT '0',<br> PRIMARY KEY (`id`),<br> FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE<br>) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_tickets` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `owner` int(11) NOT NULL,<br> `username` varchar(32) CHARACTER SET latin1 NOT NULL,<br> `subject` text CHARACTER SET latin1 NOT NULL,<br> `message` text CHARACTER SET latin1 NOT NULL,<br> `ip` int(11) NOT NULL,<br> `creation` int(11) NOT NULL,<br> `status` varchar(20) CHARACTER SET latin1 NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br>CREATE TABLE IF NOT EXISTS `znote_tickets_replies` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `tid` int(11) NOT NULL,<br> `username` varchar(32) CHARACTER SET latin1 NOT NULL,<br> `message` text CHARACTER SET latin1 NOT NULL,<br> `created` int(11) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br><br> Edit config.php with correct mysql connection details. "; $connect = new mysqli($config['127.0.0.1'], $config['root'], $config['vertrigo'], $config['compact']); if ($connect->connect_errno) { die("Failed to connect to MySQL: (" . $connect->connect_errno . ") " . $connect->connect_error . $install); } function mysql_znote_escape_string($escapestr) { global $connect; return mysqli_real_escape_string($connect, $escapestr); } // Select single row from database function mysql_select_single($query) { global $connect; global $aacQueries; $aacQueries++; global $accQueriesData; $accQueriesData[] = "[" . elapsedTime() . "] " . $query; $result = mysqli_query($connect,$query) or die(var_dump($query)." (query - SQL error) Type: select_single (select single row from database) ".mysqli_error($connect)); $row = mysqli_fetch_assoc($result); return !empty($row) ? $row : false; } // Selecting multiple rows from database. function mysql_select_multi($query){ global $connect; global $aacQueries; $aacQueries++; global $accQueriesData; $accQueriesData[] = "[" . elapsedTime() . "] " . $query; $array = array(); $results = mysqli_query($connect,$query) or die(var_dump($query)." (query - SQL error) Type: select_multi (select multiple rows from database) ".mysqli_error($connect)); while($row = mysqli_fetch_assoc($results)) { $array[] = $row; } return !empty($array) ? $array : false; } ////// // Query database without expecting returned results // - mysql update function mysql_update($query){ voidQuery($query); } // mysql insert function mysql_insert($query){ voidQuery($query); } // mysql delete function mysql_delete($query){ voidQuery($query); } // Send a void query function voidQuery($query) { global $connect; global $aacQueries; $aacQueries++; global $accQueriesData; $accQueriesData[] = "[" . elapsedTime() . "] " . $query; mysqli_query($connect,$query) or die(var_dump($query)." (query - SQL error) Type: voidQuery (voidQuery is used for update, insert or delete from database) ".mysqli_error($connect)); } ?> Editado Junho 30, 2015 10 anos por matheus36000 (veja o histórico de edições)
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.