[Gesior AAC] 0.3.4 (beta4) fixed v5

[Dejyo]

Could anyone send me their MYSQL file so i can import what you have done to your database because mine is not working, when i try to import those 3 lines it gives me some kind of error :S ,
thank you

 

[Dejyo]

ALTER TABLE `players` ADD `redskulltime` BIGINT NOT NULL DEAFULT 0;
ALTER TABLE `players` ADD `redskull` SMALLINT NOT NULL DEAFULT 0;
ALTER TABLE `player_deaths` ADD `time` bigint(20) unsigned NOT NULL DEFAULT '0'

these does not work for me

 

[Dejyo]

sorry for triple posting but this is what i get ;O

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEAFULT 0' at line 1

 

[Core_]

ALTER TABLE `player_deaths` ADD `time` bigint(20) unsigned NOT NULL DEFAULT '0'

even this one?? i mean do it first alone and then

ALTER TABLE `players` ADD `redskulltime` BIGINT NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `redskull` SMALLINT NOT NULL DEFAULT '0';

 

[Dejyo]

ALTER TABLE `player_deaths` ADD `time` bigint(20) unsigned NOT NULL DEFAULT '0'

even this one?? i mean do it first alone and then

ALTER TABLE `players` ADD `redskulltime` BIGINT NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `redskull` SMALLINT NOT NULL DEFAULT '0';

lol now it worked, thank you thank you thank you

 

[Core_]

np ^^

 

[Dejyo]

now i got this next error :S

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'guildnick' in 'field list'' in C:\xampp\htdocs\install.php:528 Stack trace: #0 C:\xampp\htdocs\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 528

 

[Norix]

Sorry you will get always some errors because this version does NOT support TFS 0.3.6 and TFS 4.0...

 

[Dejyo]

oh ok, what can i use for Feragon Online then ? i have tried EVERY aac on this website i think.. and its not working so im getting pretty pissed..

 

[M3rli]

Add tables and columns to DB
Installer try to add new tables and columns to database.

Add columns to table accounts
Can't add column key to table accounts, already exist?
Can't add column page_lastday to table accounts, already exist?
Can't add column email_new to table accounts, already exist?
Can't add column email_new_time to table accounts, already exist?
Can't add column created to table accounts, already exist?
Can't add column rlname to table accounts, already exist?
Can't add column location to table accounts, already exist?
Can't add column page_access to table accounts, already exist?
Can't add column email_code to table accounts, already exist?
Can't add column next_email to table accounts, already exist?
Can't add column premium_points to table accounts, already exist?

Add columns to table guilds
Can't add column description to table guilds, already exist?
Can't add column logo_gfx_name to table guilds, already exist?

Add columns to table players
Can't add column online to table players, already exist?
Can't add column created to table players, already exist?
Can't add column nick_verify to table players, already exist?
Can't add column old_name to table players, already exist?
Can't add column hide_char to table players, already exist?
Can't add column comment to table players, already exist?
Can't add column vote to table players, already exist?

Add new tables to database
Table z_news_big not added. Already exist?
Added table z_news_tickers
Added table z_spells
Added table z_monsters
Added table z_ots_comunication (shopsystem).
Added table z_shop_offer (shopsystem).
Added table z_shop_history_item (shopsystem).
Added table z_shop_history_pacc (shopsystem).
Added table z_changelog (changelog).
Added table z_polls (poll-system).
Added table z_polls_answers (poll-system).
Added table z_bug_tracker (bug tracker).






please help

 

[Core_]

do u import ur otserv db? D: i think u don't do it and then install ur acc and.. "already exist?" that means u done it

 

[M3rli]

I haven't add the DB before thats the problem :SS:s

 

[M3rli]

so fixed but have another problem now.

When i do a character it comes.

The Following Errors Have Occurred:

Wrong characters configuration. Try again or contact with admin. ADMIN: Edit file config/config.php and set valid characters to copy names. Character to copySorcerer Sample doesn't exist.

 

[qweertty]

cant go into http://localhost/install.php

 

[qweertty]

help

cant in to http://localhost/install.php

 

[markitu]

anyone can post 0.3.6 gesior aac?

 

[rikis15]

Warning: Error parsing C:/Documents and Settings/rikard/Skrivbord/The Forgotten Server 0.3.6pl1 GUI/config.lua on line 17 in C:\xampp\htdocs\install.php on line 181
Database error. Unknown database type in C:/Documents and Settings/rikard/Skrivbord/The Forgotten Server 0.3.6pl1 GUI/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

need help

 

[RaikND]

Warning: Error parsing C:/Documents and Settings/rikard/Skrivbord/The Forgotten Server 0.3.6pl1 GUI/config.lua on line 17 in C:\xampp\htdocs\install.php on line 181
Database error. Unknown database type in C:/Documents and Settings/rikard/Skrivbord/The Forgotten Server 0.3.6pl1 GUI/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

need help

Goto config.lua
Goto to the lines with ----
Select lines with ----
Press "Supr" =D

 

[fbgboy1989]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'redskulltime' in 'field list'' in C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\pot\OTS_Player.php:112 Stack trace: #0 C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\pot\OTS_Player.php(112): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\pot\OTS_Base_List.php(228): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\accountmanagement.php(58): OTS_Base_List->current() #4 C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\index.php(178): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\gesior 0.3.4(beta4) fixed\pot\OTS_Player.php on line 112

I get this when i'm trying to log on to my account throught the account manager on the site, someone know why i get this?

Regards, fbgboy1989!

 

[Pepe Bash]

You nice !