Instalando Znote ACC

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:

 

1.  
2. 
   

   Make sure you have imported TFS database. (OTdir/schemas+Database/compact.sql)

3.  
4. 
   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>
5.  
6. 
   

   Edit config.php with correct mysql connection details.

7.  

";

$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)