• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

gesior acc error help

carre

Advanced OT User
Joined
Apr 23, 2013
Messages
881
Solutions
1
Reaction score
157
Location
Sweden
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.
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();


Screenshot_1.png
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
Screenshot_1.png
 
Last edited:
Back
Top