[Gesior Acc] Last News.php

president vankk · May 18, 2010

Error

Lua:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in C:\Arquivos de programas\VertrigoServ\www\latestnews.php:202 Stack trace: #0 C:\Arquivos de programas\VertrigoServ\www\latestnews.php(202): PDO->query('SELECT `z_forum...') #1 C:\Arquivos de programas\VertrigoServ\www\index.php(63): include('C:\Arquivos de ...') #2 {main} thrown in C:\Arquivos de programas\VertrigoServ\www\latestnews.php on line 202

Help plx :thumbup:

rep + :wub:

president vankk · May 19, 2010

sorry my db is br

Lua:

Erro
consulta SQL:

ALTER TABLE  `account` ADD  `warned` INT( 11 ) NOT NULL

Mensagens do MySQL : 

#1146 - Table 'otserv.account' doesn't exist

Kavvson · May 19, 2010

Blahh my fail

try

ALTER TABLE `accounts` ADD `warned` INT( 11 ) NOT NULL

president vankk · May 19, 2010

Fatal error: Call to undefined method OTS_Account::getPageAccess() in C:\Arquivos de programas\VertrigoServ\www\index.php on line 47

index.php

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 "commands"; 
        $subtopic = "commands"; 
        $topic = "Commands"; 
        include("Cópia de vantagens.php"); 
    break;
	
	case "outfits":
		$topic = "outfits";
		$subtopic = "outfits";
		include("forum.php");
	break;

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

    case "onlinetime"; 
        $topic = "Onlinetime"; 
        $subtopic = "onlinetime"; 
        include("onlinetime.php"); 
    break;  
	
	case "frags";
		$topic = "Frags";
		$subtopic = "frags";
		include("frags.php");
	break;
	
	        case "creatures";
                $topic = "Creatures";
                $subtopic = "creatures";
                include("creatures.php");
        break;

      case "lottery";
          $topic = "Lottery System";
          $subtopic = "lottery";
          include("lottery.php");
      break;  

     case "faq";
              $topic = "F.A.Q.";
             $subtopic = "faq";
             include("faq.php");
    break; 
	
    case "board"; 
        $subtopic = "board"; 
        $topic = "Forums Board"; 
        include("forum/board.php"); 
    break; 
     
    case "thread"; 
        $subtopic = "thread"; 
        $topic = "Forums Board"; 
        include("forum/thread.php"); 
    break; 
	
case "forum": 
        $topic = "Forum"; 
        $subtopic = "forum"; 
        include("forum.php"); 
    break;  
	
	case "spells";
		$topic = "Spells";
		$subtopic = "spells";
		include("spells.php");
	break;

    case "rep"; 
          $topic = "Reputation Highscores"; 
          $subtopic = "rep"; 
          include("rep.php"); 
    break;  
	
	case "sejavip";
		$topic = "sejavip";
		$subtopic = "sejavip";
		include("sejavip.php");
	break;

    case "polls"; 
        $topic = "Polls"; 
        $subtopic = "polls"; 
        include("polls.php"); 
    break;    
	
	case "experiencetable";
		$topic = "Experience Table";
		$subtopic = "experiencetable";
		include("experiencetable.php");
	break;
	
	case "bans":
        $topic = "bans";
        $subtopic = "bans";
        include("bans.php");
    break;
	
	case "characters";
		$topic = "Characters";
		$subtopic = "characters";
		include("characters.php");
	break;

    case "bugtracker"; 
        $topic = "Bug Tracker"; 
        $subtopic = "bugtracker"; 
        include("bug.php"); 
    break;  
	
    case "changelog";
        $topic = "Changelogs";
        $subtopic = "changelog";
        include("changelog.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 "auctions"; 
        $topic = "Auctions"; 
        $subtopic = "auctions"; 
        include("auctionsystem.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 "gallery";
                $subtopic = "gallery";
                $topic = "Gallery";
                include("gallery.php");
        break;

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

    case "exphist"; 
        $subtopic = "exphist"; 
        $topic = "Powergamers"; 
        include("exphist.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 "vipfeatures";
		$subtopic = "vipfeatures";
		$topic = "vipfeatures";
		include("vantagens.php");
	break;
	
	case "scrollnews"; 
              $topic = "Scroll News"; 
             $subtopic = "scrollnews"; 
             include("scrollnews.php"); 
    break;  
	
	    case "wars"; 
        $subtopic = "wars"; 
        $topic = "Wars"; 
        include("wars.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 "shopadmin";
           $subtopic = "shopadmin";
           $topic = "Shop Admin";
           include("shopadmin.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();
?>

Kavvson · May 19, 2010

Man what kind of acc maker you use?

president vankk · May 19, 2010

0.3.6
confirmed

Kavvson · May 19, 2010

Dunno try :

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 "warstatistics":
                $topic = "warstatistics";
                $subtopic = "warstatistics";
                include("warstatistics.php");
        break;
        case "creatures";
                $topic = "Creatures";
                $subtopic = "creatures";
                include("creatures.php");
        break;

case "chartosell";
$topic = "List of characters to sell";
$subtopic = "chartosell";
include("sellcharlist.php");
    break;
case "buychar":
$topic = "Buy Character";
$subtopic = "buychar";
include("buychar.php");
     break; 

	case "onlinetime";
                $topic = "onlinetime";
                $subtopic = "online";
                include("onlinetime.php");
        break;

	case "latestkill";
          $topic = "Latest Kill";
          $subtopic = "latestkill";
          include("latestkill.php");
      break; 
       
        case "spells";
                $topic = "Spells";
                $subtopic = "spells";
                include("spells.php");
        break;
	case "wars";
  	        $topic = "Wars";
 	        $subtopic = "wars";
 	        include("wars.php");
	break;

	case "notations";
  	        $topic = "Notations";
 	        $subtopic = "notations";
 	        include("notations.php");
	break;

	case "faq";
  	        $topic = "Velogia FAQ";
 	        $subtopic = "faq";
 	        include("faq.php");
	break;

	case "frags";
  	        $topic = "Frags";
 	        $subtopic = "frags";
 	        include("frags.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 "houses";
                $topic = "Houses";
                $subtopic = "houses";
                include("houses.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 "forum":
                $topic = "Forum";
                $subtopic = "forum";
                include("forum/index.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 "buypoints";
                $subtopic = "buypoints";
                $topic = "Buy Points";
                include("buypoints.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();
?>

president vankk · May 19, 2010

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Arquivos de programas\VertrigoServ\www\index.php:1) in C:\Arquivos de programas\VertrigoServ\www\index.php on line 2

Fatal error: Call to undefined method OTS_Account::getPageAccess() in C:\Arquivos de programas\VertrigoServ\www\index.php on line 28

Kavvson · May 19, 2010

For sure it would help if you download a new acc maker 0.3.6

president vankk · May 19, 2010

was before 0.3.3 or 0.3.4
I downloaded the new

plx fixed x.x

Kavvson · May 19, 2010

If you have downloaded it install it (clean all databases etc.)

president vankk · May 19, 2010

OMG!
my players will kill me

Kavvson · May 19, 2010

Reply me the pm

jeff101 · Aug 31, 2010

hey I dont mean to Bug but im getting this error and i cant figure it out.. Can someone help plx.. Thanks

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'unbeaten.z_news_big' doesn't exist' in C:\xampp\htdocs\latestnews.php:131 Stack trace: #0 C:\xampp\htdocs\latestnews.php(131): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 131

I get this error once im done with my steps and i try and pull up my webpage with 127.0.0.1 But i can still see at step 7 i can see the whole website when i click line 7 But when i try and pull it up on 127.0.0.1 it will come up with this////

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'unbeaten.z_scrolling_news' doesn't exist' in C:\xampp\htdocs\latestnews.php:8 Stack trace: #0 C:\xampp\htdocs\latestnews.php(8): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 8

[Gesior Acc] Last News.php

president vankk

Web Developer & AuraOT Owner

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

president vankk

Web Developer & AuraOT Owner

Kavvson

Gdy boli cie glowa wez

jeff101

New Member

Similar threads