Instalando Znote ACC

matheus36000 · Junho 30, 2015

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:

 CREATE TABLE IF NOT EXISTS `znote` ( `id` int(10) NOT NULL AUTO_INCREMENT, `version` varchar(30) NOT NULL COMMENT 'Znote AAC version', `installed` int(10) NOT NULL, `cached` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote` (`version`, `installed`) VALUES ('$version', '$time'); CREATE TABLE IF NOT EXISTS `znote_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `ip` int(10) NOT NULL, `created` int(10) NOT NULL, `points` int(10) DEFAULT 0, `cooldown` int(10) DEFAULT 0, `active` tinyint(4) NOT NULL DEFAULT '0', `activekey` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES ('1', '0', '$time'); CREATE TABLE IF NOT EXISTS `znote_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `text` text NOT NULL, `date` int(11) NOT NULL, `pid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `desc` text NOT NULL, `date` int(11) NOT NULL, `status` int(11) NOT NULL, `image` varchar(30) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paypal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `txn_id` varchar(30) NOT NULL, `email` varchar(255) NOT NULL, `accid` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paygol` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, `message_id` varchar(255) NOT NULL, `service_id` varchar(255) NOT NULL, `shortcode` varchar(255) NOT NULL, `keyword` varchar(255) NOT NULL, `message` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `operator` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `currency` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL, `created` int(11) NOT NULL, `hide_char` tinyint(4) NOT NULL, `comment` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES ('1', '$time', '0', '. . .'); CREATE TABLE IF NOT EXISTS `znote_player_reports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `posx` int(6) NOT NULL, `posy` int(6) NOT NULL, `posz` int(6) NOT NULL, `report_description` VARCHAR(255) NOT NULL, `date` INT(11) NOT NULL, `status` TINYINT(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_changelog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `text` VARCHAR(255) NOT NULL, `time` INT(11) NOT NULL, `report_id` INT(11) NOT NULL, `status` TINYINT(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL, `itemid` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT '1', `description` varchar(255) NOT NULL, `points` int(11) NOT NULL DEFAULT '10', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `points` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `value` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `time` int(11) NOT NULL, `type` tinyint(4) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `access` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `guild_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Staff Board', '4', '0', '0', '0'), ('Tutors Board', '2', '0', '0', '0'), ('Discussion', '1', '0', '0', '0'), ('Feedback', '1', '0', '1', '0'); CREATE TABLE IF NOT EXISTS `znote_forum_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `title` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, `sticky` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_deleted_characters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `original_account_id` int(11) NOT NULL, `character_name` varchar(255) NOT NULL, `time` datetime NOT NULL, `done` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_guild_wars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `limit` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_tickets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `owner` int(11) NOT NULL, `username` varchar(32) CHARACTER SET latin1 NOT NULL, `subject` text CHARACTER SET latin1 NOT NULL, `message` text CHARACTER SET latin1 NOT NULL, `ip` int(11) NOT NULL, `creation` int(11) NOT NULL, `status` varchar(20) CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_tickets_replies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL, `username` varchar(32) CHARACTER SET latin1 NOT NULL, `message` text CHARACTER SET latin1 NOT NULL, `created` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 

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 por matheus36000 (veja o histórico de edições)

Entrar

Instalando Znote ACC

Posts Recomendados

matheus36000 0

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Fóruns

Anuncie

Informação Importante