• 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!

Modern AAC | v0.1

Status
Not open for further replies.
Will if any one want to help please dont say it say that its order bec i can see that i download other virsion and the same so please
Tell how + Steps + links thx
 
If it says that your php version is older then 5.3.0 then simply update your php version since most people use examp just download the 1.7.3 version of xampp.

All tho be aware that xampp got some holes for the hackers.
 
tjx kyo Rep+

What about that ?


A Database Error Occurred

Error Number: 1146

Table 'server.news' doesn't exist

SELECT `id`, `title`, `body`, `time` FROM `news` ORDER BY id DESC LIMIT 10
 
Last edited by a moderator:
semary re-install the AAC with your right database then this table will be created..
rep ++ me :D ?
 
tjx kyo Rep+

What about that ?


A Database Error Occurred

Error Number: 1146

Table 'server.news' doesn't exist

SELECT `id`, `title`, `body`, `time` FROM `news` ORDER BY id DESC LIMIT 10

Re-install Modern AAC and the tables will be created in the database automaticly.

As the guy before me said. :p
 
PHP:
ALTER TABLE `accounts` ADD `page_access` int(11);

ALTER TABLE `accounts` ADD `page_lastday` int(11);

ALTER TABLE `accounts` ADD `email_new` varchar(255);

ALTER TABLE `accounts` ADD `email_new_time` int(15);

ALTER TABLE `accounts` ADD `rlname` varchar(255);

ALTER TABLE `accounts` ADD `location` varchar(255);

ALTER TABLE `accounts` ADD `created` int(16);

ALTER TABLE `accounts` ADD `email_code` varchar(255);

ALTER TABLE `accounts` ADD `next_email` int(11);

ALTER TABLE `accounts` ADD `premium_points` int(11);

ALTER TABLE `players` ADD `old_name` varchar(255);

ALTER TABLE `players` ADD `hide_char` int(11);

ALTER TABLE `players` ADD `worldtransfer` int(11);

ALTER TABLE `players` ADD `created` int(16);

ALTER TABLE `players` ADD `nick_verify` int(11);

ALTER TABLE `players` ADD `comment` text;



CREATE TABLE IF NOT EXISTS `news` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL DEFAULT '',

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `comments` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `news_id` int(11) DEFAULT NULL,

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  `author` varchar(64) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;



CREATE TABLE IF NOT EXISTS `forums` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `description` text NOT NULL,

  `access` int(5) unsigned NOT NULL,

  `closed` int(1) unsigned NOT NULL COMMENT 'Min. access to see the board',

  `moderators` text NOT NULL,

  `order` int(6) DEFAULT NULL,

  `requireLogin` int(1) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `posts` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL,

  `text` text NOT NULL,

  `time` int(16) unsigned NOT NULL,

  `author` varchar(64) NOT NULL,

  `board_id` int(16) unsigned NOT NULL,

  `thread_id` int(16) unsigned NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `threads` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `sticked` tinyint(1) unsigned NOT NULL,

  `closed` tinyint(1) unsigned NOT NULL,

  `author` varchar(64) NOT NULL,

  `time` int(12) unsigned NOT NULL,

  `board_id` int(12) unsigned NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `bugtracker` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `category` int(3) unsigned NOT NULL,

  `time` int(16) unsigned NOT NULL,

  `author` int(16) unsigned NOT NULL,

  `text` text NOT NULL,

  `title` varchar(64) NOT NULL,

  `done` int(3) unsigned NOT NULL,

  `priority` int(3) unsigned NOT NULL,

  `closed` int(1) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
Alright, I'm sorry but I did not get any reply.
Why going capital? :S

EDIT: Sorry, did not use my brain enough. So I did not read that FAQ.
Thanks anyways.

PS. Any plans to make it supported for TFS 0.2?
 
Alright, I'm sorry but I did not get any reply.
Why going capital? :S

EDIT: Sorry, did not use my brain enough. So I did not read that FAQ.
Thanks anyways.

PS. Any plans to make it supported for TFS 0.2?

I don't have any plans as I personally use 0.4, and some of the people I host use 0.3, but noone uses 0.2. You are, however, free to submit a patch.
 
A Database Error Occurred

Error Number: 1054

Unknown column 'title' in 'field list'

SELECT `id`, `title`, `body`, `time` FROM `news` ORDER BY id DESC LIMIT 10


??;/
 
If you add SMS shop to this aac, count of users would incrase like 500%... Today sms shop is most important part of OTS
 
@up: ots with shop isnt real server, its just tool to gather money

but I'd love to have working pajacyk script here(paxton should know what I mean)xD
 
@up: ots with shop isnt real server, its just tool to gather money

but I'd love to have working pajacyk script here(paxton should know what I mean)xD

You know some ppl use shop (donation system) To cover the costs for dedicated. So (players) dont have to experience "lagg, freeze" In ot.
 
A Database Error Occurred

Error Number: 1054

Unknown column 'title' in 'field list'

SELECT `id`, `title`, `body`, `time` FROM `news` ORDER BY id DESC LIMIT 10


??;/
You are probably using TFS 0.2 version

You know some ppl use shop (donation system) To cover the costs for dedicated. So (players) dont have to experience "lagg, freeze" In ot.
Yeah, but actually no, they use it mostly to fill their pockets.
 
Status
Not open for further replies.
Back
Top