Gesior Errors and a Question

[ELEM3NT]

Hello there, I'll tell you some of my errors that I currently have on my Gesior AAC.
And to the people that was helping me in my last thread "Gesior AAC Installment" I am back. xD

I am using XAMPP 1.7.3 with the most upgraded phpMyAdmin.
Using Gesior 0.3.4(beta4) Fixed v5 as my AAC
and The Forgotten Server 0.3.6pl1 GUI as the server...


I always get an error on these following clicks:
Account Management,
My Account,
When I Try to Login,
When I look up a character,
Highscores,
Last Kills,
and Banishments.


Heres the errors for each click,

When I Try to Login, When I click My Account, and when I click on Account Management (ALL THE SAME ERROR):

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(178): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

When I Look up a Character:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_Player.php:2362 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(2362): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Player.php(2393): OTS_Player->loadNameLock() #2 C:\xampp\htdocs\characters.php(20): OTS_Player->isNameLocked() #3 C:\xampp\htdocs\index.php(142): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 2362

When I click on Highscores:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\highscores.php(93): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(154): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

When I click on Last Kills:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'time' in 'order clause'' in C:\xampp\htdocs\killstatistics.php:2 Stack trace: #0 C:\xampp\htdocs\killstatistics.php(2): PDO->query('SELECT * FROM p...') #1 C:\xampp\htdocs\index.php(160): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\killstatistics.php on line 2

and When I click on Banishments:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.bans' doesn't exist' in C:\xampp\htdocs\bans.php:15 Stack trace: #0 C:\xampp\htdocs\bans.php(15): PDO->query('SELECT `bans`.`...') #1 C:\xampp\htdocs\index.php(94): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\bans.php on line 15

So yeh, thats all the errors I get when I click on any one of em. If you know why i'm getting these errors, please help me. I'd really appreciate it. ^_^

-MY VERY IMPORTANT QUESTION-
Okay, so right now im using http://localhost/ or http://127.0.0.1/ to connect to my website.
>>How do I make it so I can go on it with my IP address or my No-Ip?<< Do I have to change something in the settings?

Alright ya'll, if you can help me out, please do so.

Thank you,
ELEM3NT:thumbup:

 

[Limannen]

Use ModernAAC

 

[ELEM3NT]

@Limannen Can you use the same scripts that you use in Gesior on Modern? Like the shop system thing... The customer buys something then he gets it in on his account. Like it gives the customer the item automatically.

 

[ELEM3NT]

Bump

 

[Rexxar]

@Limannen Can you use the same scripts that you use in Gesior on Modern? Like the shop system thing... The customer buys something then he gets it in on his account. Like it gives the customer the item automatically.

Modules/Addons/Scripts made for Geisor AAC will not work on Modern AAC because they use a completely different coding style for Modules/Addons/Scripts.

They would have to be re-written to work with Modern AAC.

 

[devianceone]

Do you not have a 'bans' table in your database? It's a default table for TFS. It seems you're either using a really old unsupported version of TFS, geisor or you installed one of them wrong.

 

[ELEM3NT]

@devianceone, Nope. I do not have a 'bans' table in my database... I'm using TFS 0.3.6pl1. Isn't there a way to just add it? D:!

Thanks,
ELEM3NT

 

[Ward_214]

I have the same problems.
Someone help?

 

[Nilithan]

Add this to your database.

CREATE TABLE `bans`
(
	`id` INT UNSIGNED NOT NULL auto_increment,
	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
	`active` TINYINT(1) NOT NULL DEFAULT TRUE,
	`expires` INT NOT NULL,
	`added` INT UNSIGNED NOT NULL,
	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
	`comment` TEXT NOT NULL,
	`reason` INT UNSIGNED NOT NULL DEFAULT 0,
	`action` INT UNSIGNED NOT NULL DEFAULT 0,
	`statement` VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`id`),
	KEY `type` (`type`, `value`),
	KEY `active` (`active`)
) ENGINE = InnoDB;