Cria a coluna  flag  na tabela accounts e o problema será resolvido.

O problema da linha 13 resolveu, mas aí abri o site e apareceram mais erros... Resolvi então deletar tudo e recomeçar. Preciso criar algumas tables nesse de agora, mas nem tenho ideia de como seja a sintaxe exata do comando pra adiciona-las:

 

Query:	SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 50;
SQLSTATE:	42S02
Driver code:	1146
Error message:	La table 'hauntera-revolution.z_news_tickers' n'existe pas
Query:	SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1
SQLSTATE:	00000
Driver code:	
Error message:	
Query:	SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE:	42S02
Driver code:	1146
Error message:	La table 'hauntera-revolution.z_forum' n'existe pas

 

( ! ) Fatal error: Call to a member function fetchAll() on a non-object in C:\wamp\www\pages\latestnews.php on line 303
Call Stack
#	Time	Memory	Function	Location
1	0.0010	136912	{main}( )	..\index.php:0
2	0.0460	546880	include_once( 'C:\wamp\www\system\load.page.php' )	..\index.php:37
3	0.0480	626248	include( 'C:\wamp\www\pages\latestnews.php' )	..\load.page.php:7

 

 

Se puder ajudar novamente... rsrs

Roda esse comando na database 

 

CREATE TABLE IF NOT EXISTS `z_news_tickers` (
`date` int(11) NOT NULL default '1',
`author` int(11) NOT NULL,
`image_id` int(3) NOT NULL default '0',
`text` text NOT NULL,
`hide_ticker` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

e esse

 

CREATE TABLE `z_forum` 
(
	`id` int(11) NOT NULL auto_increment,
	`sticky` tinyint(1) NOT NULL DEFAULT '0',
	`closed` tinyint(1) NOT NULL DEFAULT '0',
	`first_post` int(11) NOT NULL default '0',
	`last_post` int(11) NOT NULL default '0',
	`section` int(3) NOT NULL default '0',
	`icon_id` int(3) NOT NULL default '1',
	`replies` int(20) NOT NULL default '0',
	`views` int(20) NOT NULL default '0',
	`author_aid` int(20) NOT NULL default '0',
	`author_guid` int(20) NOT NULL default '0',
	`post_text` text NOT NULL,
	`post_topic` varchar(255) NOT NULL,
	`post_smile` tinyint(1) NOT NULL default '0',
	`post_date` int(20) NOT NULL default '0',
	`last_edit_aid` int(20) NOT NULL default '0',
	`edit_date` int(20) NOT NULL default '0',
	`post_ip` varchar(32) NOT NULL default '0.0.0.0',
	PRIMARY KEY  (`id`),
	KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

 

Valeu pela ajuda, o erro foi resolvido, mas surgiram outros mil mais. Talvez este tópico ajude outra pessoa. Eu desisto disso! rsrsr