Maykkkin666

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

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

Apareceu isso: Query: SELECT `accounts`.`flag`, `players`.`name`, `players`.`vocation`, `players`.`level`, `players`.`skull`, `players`.`looktype`, `players`.`lookaddons`, `players`.`lookhead`, `players`.`lookbody`, `players`.`looklegs`, `players`.`lookfeet` FROM `accounts`, `players`, `players_online` WHERE `players`.`id` = `players_online`.`player_id` AND `accounts`.`id` = `players`.`account_id` ORDER BY `name` SQLSTATE: 42S22 Driver code: 1054 Error message: Champ 'accounts.flag' inconnu dans field list ( ! ) Fatal error: Call to a member function fetchAll() on a non-object in C:\wamp\www\layouts\tibiacom\layout.php on line 13 Call Stack # Time Memory Function Location 1 0.0010 136096 {main}( ) ..\index.php:0 2 0.0550 628448 include_once( 'C:\wamp\www\system\load.layout.php' ) ..\index.php:43 3 0.0560 710440 include( 'C:\wamp\www\layouts\tibiacom\layout.php' ) ..\load.layout.php:42

wamp/www/index.php Aí está index.php

Não sei se eu tenho que criar alguma table, ou o quê.. não acho a solução em lugar nenhum ( ! ) Fatal error: Call to a member function fetchAll() on a non-object in C:\wamp\www\layouts\tibiacom\layout.php on line 13 Call Stack # Time Memory Function Location 1 0.0010 136912 {main}( ) ..\index.php:0 2 0.2660 625400 include_once( 'C:\wamp\www\system\load.layout.php' ) ..\index.php:43 3 0.2670 707376 include( 'C:\wamp\www\layouts\tibiacom\layout.php' ) ..\load.layout.php:42 A linha 13 completa: players_online_data = $SQL->query('SELECT ' . $SQL->tableName('accounts') . '.' . $SQL->fieldName('flag') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('name') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('vocation') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('level') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('skull') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('looktype') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('lookaddons') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('lookhead') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('lookbody') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('looklegs') . ', ' . $SQL->tableName('players') . '.' . $SQL->fieldName('lookfeet') . ' FROM ' . $SQL->tableName('accounts') . ', ' . $SQL->tableName('players') . ', ' . $SQL->tableName('players_online') . ' WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('players_online') . '.' . $SQL->fieldName('player_id') . ' AND ' . $SQL->tableName('accounts') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('players') . '.' . $SQL->fieldName('account_id') . ' ORDER BY ' . $SQL->fieldName($orderby))->fetchAll();