carre
Advanced OT User
Hi
When I try to reload gesior localhost on my site and I get this
I've also checked the line 18 on home.php and don't find anything wrong.
I've fixed it now thanks to
however now I get this when trying to make an account
When I try to reload gesior localhost on my site and I get this
I've also checked the line 18 on home.php and don't find anything wrong.
Code:
<?PHP if(!defined('INITIALIZED')) exit;
if($action == '')
{
#==================== SQL ======================#
$news_database = $SQL->query('SELECT
'.$SQL->tableName('players').'.'.$SQL->fieldName('name').',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_text') . ',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_topic') . ',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_smile') . ',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('replies') . ',
' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_date') . '
FROM ' . $SQL->tableName('players') . ',' . $SQL->tableName('z_forum') . '
WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('author_guid') . '
AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('section') . ' = 1
AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('first_post') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . '
ORDER BY ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('last_post') . ' DESC LIMIT 3;')->fetchAll();
Post automatically merged:
I've fixed it now thanks to
Code:
CREATE TABLE `z_forum` (
`id` int(11) NOT NULL auto_increment,
`first_post` int(11) NOT NULL default '0',
`last_post` int(11) NOT NULL default '0',
`section` int(3) NOT NULL default '0',
`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;
Code:
ALTER TABLE `accounts` ADD `last_post` INT( 11 ) NOT NULL DEFAULT '0';
however now I get this when trying to make an account
Last edited: