Solved Gesior ACC Maker for avesta 7.4

[MisaeltheKid]

I'm using gesior 0.3.7 ACC Maker for my 7.4 server, but show that error: "Check server configuration
File config.lua loaded from D:/Documents and Settings/admin/Desktop/Avesta/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory.If it's your config.lua file from TFS contact with acc. maker author."

This is my config.lua:

DataDir = "data/"

NotationsToBan = 3
WarningsToFinalBan = 4
WarningsToDeletion = 5
BanLength = 1 * 24 * 60 * 60
FinalBanLength = 7 * 24 * 60 * 60
IPBanishmentLength = 24 * 60 * 60
KillsToBan = 7

WorldType = "pvp"

Exhausted = 1000

FightExhausted = 1000

HealExhausted = 1000

ExhaustedAdd = 100

PZLock = 60000

FieldOwnershipDuration = 5000

TimeToDecreaseFrags = 24 * 60 * 60 * 1000

WhiteSkullTime = 3

KillsToRedSkull = 5

RemoveAmmunition = false

RemoveRuneCharges = false

RemoveWeaponCharges = false

UHTrap = true

IP = "-------"

Port = "7171"

LoginTries = 5

RetryTimeout = 5000

LoginTimeout = 60 * 1000

AllowClones = false

CheckAccounts = false
SQL_Type = "mysql"
SQL_DB = "otserv"
SQL_Host = "localhost"
SQL_Port = 3306
SQL_User = "root"
SQL_Pass = "-----"

LoginMsg = "Welcome to OTServ. For help visit our site."
ServerName = "Otserver"
WorldName = "OpenTibia"
OwnerName = "Ferrus"
OwnerEmail = ""
URL = ""
Location = "Poland"

MinActionInterval = 200
MinActionExInterval = 1000

HouseRentPeriod = "monthly"
HousePrice = 100
HouseLevel = 1
PremOnlyHouse = true
PremOnlyBeds = false

Map = "data/world/fibula.otbm"

MapKind = "OTBM"
MapStoreType = "binary"

RateExp = 1
RateSkill = 1
RateMag = 1
RateLoot = 1
RateSpawn = 1

DespawnRange = 2
DespawnRadius = 50

MOTD = "Welcome to OTServ!"
MOTD_Num = "1"
MaxPlayers = "100"

PasswordType = "plain"
MaxMessageBuffer = 4
SaveClientDebug = false
UseAccBalance = false
MaxIdleTime = 15
LevelToRook = 5
RookTempleId = 1
StorePlayerDeathsInDB = true
FACCTempleID = 0

 

[Naxtie]

You are using the wrong version of gesior, simple as that.. >_>

 

[MisaeltheKid]

You are using the wrong version of gesior, simple as that.. >_>

What version i use? Can u post link too, please?

 

[Naxtie]

What version i use? Can u post link too, please?

I have no idea which version to use, I never create old school servers. Use the search function instead.

 

[Olddies]

i think we dont have any gesior acc for avesta... maybe you should use the znote for 7.6 servers http://otland.net/threads/znote-aac-converted-to-7-6-servers.217823/ ... i dont know if it work with avesta 7.4 so maybe u should do some changes in the tables

 

[MisaeltheKid]

i think we dont have any gesior acc for avesta... maybe you should use the znote for 7.6 servers http://otland.net/threads/znote-aac-converted-to-7-6-servers.217823/ ... i dont know if it work with avesta 7.4 so maybe u should do some changes in the tables

Thanks dude, i go try. Also, i dont know how do that changes... Im newbie.

 

[Cornex]

Thanks dude, i go try. Also, i dont know how do that changes... Im newbie.

Well, hello. I gonna point it out right now, you will need to learn so better you do it now.
Because the support board are not getting more active, it get less active.

 

[MisaeltheKid]

Well, hello. I gonna point it out right now, you will need to learn so better you do it now.
Because the support board are not getting more active, it get less active.

Dude, to be honest with you I do not understand right, 4 days ago we[my and friends] had a idea to create a 7.4 server war/rpg with low xp secret hunts, secret quests, easter eggs etc... From there to here i'm working like 10hour/day and i learn a lot of things.. Now i go try run in 7.4!!!

Dudes, after some work i got that problem:
Failed to connect to database.
Install:

1. Make sure you have imported TFS database. (OTdir/forgottenserver.sql OR OTdir/schemas/mysql.sql)
   
   
2. Import the below schema to a TFS database in phpmyadmin:

CREATE TABLE IF NOT EXISTS `znote` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
  `installed` int(10) NOT NULL,
  `cached` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `znote` (`version`, `installed`) VALUES
('1.5_SVN', '1407944843');

CREATE TABLE IF NOT EXISTS `znote_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `ip` int(10) NOT NULL,
  `created` int(10) NOT NULL,
  `points` int(10) DEFAULT 0,
  `cooldown` int(10) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1407944843');

CREATE TABLE IF NOT EXISTS `znote_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(30) NOT NULL,
  `text` text NOT NULL,
  `date` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(30) NOT NULL,
  `desc` text NOT NULL,
  `date` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `image` varchar(30) NOT NULL,
  `account_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_paypal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `txn_id` varchar(30) NOT NULL,
  `email` varchar(255) NOT NULL,
  `accid` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_paygol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `message_id` varchar(255) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `shortcode` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `sender` varchar(255) NOT NULL,
  `operator` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `created` int(11) NOT NULL,
  `hide_char` tinyint(4) NOT NULL,
  `comment` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES
('1', '1407944843', '0', '. . .');

CREATE TABLE IF NOT EXISTS `znote_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  `itemid` int(11) DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  `describtion` varchar(255) NOT NULL,
  `points` int(11) NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_shop_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `itemid` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `itemid` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_visitors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` int(11) NOT NULL,
  `value` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_visitors_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `account_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `access` tinyint(4) NOT NULL,
  `closed` tinyint(4) NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `guild_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES
('Staff Board', '4', '0', '0', '0'),
('Tutors Board', '2', '0', '0', '0'),
('Discussion', '1', '0', '0', '0'),
('Feedback', '1', '0', '1', '0');

CREATE TABLE IF NOT EXISTS `znote_forum_threads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `created` int(11) NOT NULL,
  `updated` int(11) NOT NULL,
  `sticky` tinyint(4) NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `closed` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `znote_forum_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `player_name` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `created` int(11) NOT NULL,
  `updated` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

3. Config.php with correct mysql connection details.

In the first step i imported the correct avesta schema... But in second step i dont know what i do...

 

[Olddies]

your database connection are wrong maybe ur password or something try to do it well

 

[MisaeltheKid]

I fix'd !!!!!! I'm happy as fuck... I need sleep now, 25h +- i'm wake have a lot of work to do..... Focus!!!!

So...i'm have this error : 1INSERT ERROR: Cannot add or update a child row: a foreign key constraint fails (`otserv`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`))

 

[Cornex]

So...i'm have this error : 1INSERT ERROR: Cannot add or update a child row: a foreign key constraint fails (`otserv`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`))

It says you cannot add an key that not exist. group_id at players need to be in groups table. Execute:

INSERT INTO `groups` (`id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist`)
VALUES
(0, 'Player', 0, 0, 4000, 200),
(1, 'Tutor', 16777216, 1, 2000, 200),
(2, 'Senior Tutor', 137455763456, 2, 2000, 200),
(3, 'Trial Gamemaster', 214207947535, 3, 0, 200),
(4, 'Gamemaster', 489622725391, 4, 0, 200),
(5, 'Community Manager', 489622725391, 5, 0, 200),
(6, 'Administrator', 529957625850, 6, 2000, 200),
(7, 'Administrator', 547104989176, 6, 2000, 200);

 

[MisaeltheKid]

It says you cannot add an key that not exist. group_id at players need to be in groups table. Execute:

INSERT INTO `groups` (`id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist`)
VALUES
(0, 'Player', 0, 0, 4000, 200),
(1, 'Tutor', 16777216, 1, 2000, 200),
(2, 'Senior Tutor', 137455763456, 2, 2000, 200),
(3, 'Trial Gamemaster', 214207947535, 3, 0, 200),
(4, 'Gamemaster', 489622725391, 4, 0, 200),
(5, 'Community Manager', 489622725391, 5, 0, 200),
(6, 'Administrator', 529957625850, 6, 2000, 200),
(7, 'Administrator', 547104989176, 6, 2000, 200);

Sorry for ask, but for i execute this i create a file schema.mysql and import in my db?

 

[Olddies]

nope in phpmyadmin go to your database and click in SQL then copy and paste it then click OK

 

[MisaeltheKid]

nope in phpmyadmin go to your database and click in SQL then copy and paste it then click OK

#1062 - Duplicate entry '1' for key 'PRIMARY'

 

[Cornex]

#1062 - Duplicate entry '1' for key 'PRIMARY'

What lines to you already have in groups table?

 

[MisaeltheKid]

Also, i think i know what is wrong, first i get that error: 1INSERT ERROR: Unknown column 'soul' in 'field list'
Cant create characters on avesta mysql schemas. Then, i imported a schema.mysql with this only " ALTER TABLE players
ADD soul int unsigned;" Because of this i get that error... How i find for delete that autism i did?

 

[Cornex]

Also, i think i know what is wrong, first i get that error: 1INSERT ERROR: Unknown column 'soul' in 'field list'
Cant create characters on avesta mysql schemas. Then, i imported a schema.mysql with this only " ALTER TABLE players
ADD soul int unsigned;" Because of this i get that error... How i find for delete that autism i did?

I'm pretty sure you will have more problems, seems like you use an gesior version which not support 7.4.

 

[MisaeltheKid]

I'm pretty sure you will have more problems, seems like you use an gesior version which not support 7.4.

I dont use gesior.. I use znot. U can help me via team viewer?

 

[Olddies]

look into your database if you have any line in table groups

 

[MisaeltheKid]

What lines to you already have in groups table?

Id, name, flags, acess, maxdepotitems and maxviplist.