xTibia

.com
TD

[Erro] Gesior Acc 0.3.8

Por tdp157, 28 de jan. de 2011 em Archived

otserv
9
2.6k
tdp157T
28 de janeiro de 2011 às 14:09

Bom dia galera !

 

Gostaria de saber se tem algum profissional que possa me ajudar com este erro no Gesior ACC 0.3.8, estou criando 1 ot 8.6 mapa global full e precisando muito disso para criar vip sistem, garanto ao profissional que recebera CM em meu otserver & ficara responsavel pelo site do mesmo!

 

 

errogesioracc038.jpg

luzifullL
28 de janeiro de 2011 às 15:42

Vá no index.php, e depois de <?PHP

 

Coloque isto:

date.timezone = America/Sao_Paulo

tdp157T
29 de janeiro de 2011 às 17:57

Bem eu fiz isso, e agora nem o site abre apenas apareçe este erro !

 

erro2jd.jpg

 

Abaixo segue meu index.php

 

<?PHP
session_start();
ob_start("ob_gzhandler");
//require('./exaBD.php');
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
$time_start = microtime_float();


//##### CONFIG #####
include('config-and-functions.php');
$action = $_REQUEST['action'];

//##### LOGOUT #####
if($action == "logout") {
unset($_SESSION['account']);
unset($_SESSION['password']);
}

//##### LOGIN #####
$logged = FALSE;
if(isset($_SESSION['account'])) {
$account_logged = $ots->createObject('Account');
$account_logged->load($_SESSION['account']);
if($account_logged->isLoaded() && $account_logged->getPassword() == $_SESSION['password']) {
	$logged = TRUE;
	$group_id_of_acc_logged = $account_logged->getPageAccess();
} else {
	$logged = FALSE;
	unset($_SESSION['account']);
	unset($account_logged);
}
}
$login_account = strtoupper(trim($_POST['account_login']));
$login_password = trim($_POST['password_login']);
if(!$logged && !empty($login_account) && !empty($login_password)) {
$login_password = password_ency($login_password);
$account_logged = $ots->createObject('Account');
$account_logged->find($login_account);
if($account_logged->isLoaded()) {
	if($login_password == $account_logged->getPassword()) {
		$_SESSION['account'] = $account_logged->getId();
		$_SESSION['password'] = $login_password;
		$logged = TRUE;
		$account_logged->setCustomField("page_lastday", time());
		$group_id_of_acc_logged = $account_logged->getPageAccess();
	} else
		$logged = FALSE;
}
}

//#### LOAD PAGE ##########
if(empty($_REQUEST['subtopic'])) {
$_REQUEST['subtopic'] = "latestnews";
$subtopic = "latestnews";
}
switch($_REQUEST['subtopic']) {

       case "latestnews":
               $topic = "Latest News";
               $subtopic = "latestnews";
               include("latestnews.php");
       break;

       case "creatures";
               $topic = "Creatures";
               $subtopic = "creatures";
               include("creatures.php");
       break;

       case "spells";
               $topic = "Spells";
               $subtopic = "spells";
               include("spells.php");
       break;

	case "bugtracker";
 	        $topic = "Bug Tracker";
	        $subtopic = "bugtracker";
	        include("bug.php");
break;  

       case "experiencetable";
               $topic = "Experience Table";
               $subtopic = "experiencetable";
               include("experiencetable.php");
       break;

       case "characters";
               $topic = "Characters";
               $subtopic = "characters";
               include("characters.php");
       break;

       case "whoisonline";
               $topic = "Who is online?";
               $subtopic = "whoisonline";
               include("whoisonline.php");
       break;

       case "highscores";
               $topic = "Highscores";
               $subtopic = "highscores";
               include("highscores.php");
       break;

       case "killstatistics";
               $topic = "Last Kills";
               $subtopic = "killstatistics";
               include("killstatistics.php");
       break;

       case "guilds";
               $topic = "Guilds";
               $subtopic = "guilds";
               include("guilds.php");
       break;

       case "accountmanagement";
               $topic = "Account Management";
               $subtopic = "accountmanagement";
               include("accountmanagement.php");
       break;

       case "createaccount";
               $topic = "Create Account";
               $subtopic = "createaccount";
               include("createaccount.php");
       break;

       case "lostaccount";
               $topic = "Lost Account Interface";
               $subtopic = "lostaccount";
               include("lostaccount.php");
       break;

       case "tibiarules";
               $topic = "Server Rules";
               $subtopic = "tibiarules";
               include("tibiarules.php");
       break;

       case "adminpanel":
               $topic = "Admin Panel";
               $subtopic = "adminpanel";
               include("adminpanel.php");
       break;

       case "confirmacao":
               $topic = "Confirmacao";
               $subtopic = "confirmacao";
               include("confirmacao.php");
       break;

       case "vantagens":
               $topic = "Vantagens";
               $subtopic = "vantagens";
               include("vantagens.php");
       break;

       case "forum":
               $topic = "Forum";
               $subtopic = "forum";
               include("forum.php");
       break;

       case "team";
               $subtopic = "team";
               $topic = "Gamemasters List";
               include("team.php");
       break;

       case "downloads";
               $subtopic = "downloads";
               $topic = "Downloads";
               include("downloads.php");
       break;

       case "serverinfo";
               $subtopic = "serverinfo";
               $topic = "Server Info";
               include("serverinfo.php");
       break;

       case "shopsystem";
               $subtopic = "shopsystem";
               $topic = "Shop System";
               include("shopsystem.php");
       break;

       case "doacao";
               $subtopic = "doacao";
               $topic = "Doacao";
               include("doacao.php");
       break;

       case "gallery";
               $subtopic = "gallery";
               $topic = "Gallery";
               include("gallery.php");
       break;

       case "namelock";
               $subtopic = "namelock";
               $topic = "Namelock Manager";
               include("namelocks.php");
       break;

       case "archive";
               $subtopic = "archive";
               $topic = "News Archives";
               include("archive.php");
       break;

       case "mail";
               $subtopic = "mail";
               $topic = "Mass emails sender";
               include("mail.php");
       break;

case "shopadmin";
	$subtopic = "shopadmin";
	$topic = "Shop Admin";
	include("shopadmin.php");
break;

case "records";
	$subtopic = "records";
	$topic = "Players Online Records";
	include("records.php");
break;

case "restarter";
	$subtopic = "restarter";
	$topic = "Restarter";
	include("restarter.php");
break;

case "bans";
	$subtopic = "bans";
	$topic = "Ban List";
	include("bans.php");
break;

 	case "polls";
	$topic = "Polls";
	$subtopic = "polls";
	include("polls.php");
break; 	

case "changelog";
  		 $topic = "Changelog";
 		 $subtopic = "changelog";
 		 include("changelog.php");
break; 

case "fragers";
  		 $topic = "Top Fragers";
 		 $subtopic = "fragers";
 		 include("fragers.php");
break;

	case "paypal";
  		 $topic = "Donate via PayPal";
 		 $subtopic = "paypal";
 		 include("paypal.php");
break;
}

if(empty($topic)) {
$title = $GLOBALS['config']['server']["serverName"]." - OTS";
$main_content .= 'Invalid subtopic. Can\'t load page.';
} else {
$title = $GLOBALS['config']['server']["serverName"]." - ".$topic;
}

//#####LAYOUT#####
$layout_header = '<script type=\'text/javascript\'>
function GetXmlHttpObject()
{
var xmlHttp=null;
try
 {
 xmlHttp=new XMLHttpRequest();
 }
catch (e)
 {
 try
   {
   xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
   }
 catch (e)
   {
   xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
   }
 }
return xmlHttp;
}

function MouseOverBigButton(source)
{
 source.firstChild.style.visibility = "visible";
}
function MouseOutBigButton(source)
{
 source.firstChild.style.visibility = "hidden";
}
function BigButtonAction(path)
{
 window.location = path;
}
var';
if($logged) { $layout_header .= "loginStatus=1; loginStatus='true';"; } else { $layout_header .= "loginStatus=0; loginStatus='false';"; };
$layout_header .= " var activeSubmenuItem='".$subtopic."';</script>";
include($layout_name."/layout.php");
ob_end_flush();
?>

Natanael BeckmanN
29 de janeiro de 2011 às 22:29

Talvez se você tivesse lido o topico não teria duvidas...

 

Executa isso na sua database e reinstale o gesior...

 

 

ALTER TABLE `accounts` ADD vip_time INT(15) NOT NULL DEFAULT 0;

tyuahoiT
29 de janeiro de 2011 às 23:07

Vai na pasta HTDOCS, abre o INDEX.PHP, e adiciona embaixo de

<?PHP

isso:

 

"date_default_timezone_set('Europe/Berlin');"

 

(Sem aspas)

tdp157T
30 de janeiro de 2011 às 10:41

galera muito obrigado resolveu !

tyuahoiT
30 de janeiro de 2011 às 11:31

Duvida Senada,

Topico reportado.

9 meses depois...
leonunes1202L
23 de outubro de 2011 às 17:14

CARA BASTA VC BOTA UMA NOTICIA QUALQUER QUE IRA VOLTAR AO NORMAL

 

AJUDEI? da REP+

1 mês depois...
biel1010B
07 de novembro de 2011 às 18:49

Ow, meu otserv esta dando erro ao tentar abri o My Account >

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'styllersystem.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampp\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('89721') #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(159): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

 

 

Se poder me ajudar do REP+ - So Falta Solucionar Isso Para Abrir Meu Otserv...

Agradeço desde Já

 

Obg..