[10.77][TFS 1.2] ORTS, a real map project

Extrodus · Dec 3, 2013

Yeah, as long as you have 100mbps you should be fine, its when you get down to the 10mbps it starts to get really hard to host.

Rickolajten · Dec 3, 2013

Wartio said:

Try to insert this code,

Code:

INSERT INTO `players` (`name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`) VALUES
('Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.');

let me know if you get any errors

Morning!
I got this one

"#1054 - Unknown column 'world_id' in 'field list'"

alissonfgp · Dec 3, 2013

Rickolajten said:
Morning!
I got this one

"#1054 - Unknown column 'world_id' in 'field list'"

you can try for add field

Code:

  ALTER TABLE `accounts` ADD `world_id` INTEGER(11) NOT NULL DEFAULT 0;

OR
tries to use that to my database Gesior, have to clean some tables.
http://www.mediafire.com/download/sbvkk2v1nxfyyib/server.rar
Here it works 100%...

alissonfgp · Dec 3, 2013

It's impossible to edit the post? oO
something wrong replace the `accounts` by `players`

Rickolajten · Dec 3, 2013

alissonfgp said:
It's impossible to edit the post? oO
something wrong replace the `accounts` by `players`

Thanks, it worked.. but it just got me to the next problem. #1054 - Unknown column 'rank_id' in 'field list'

Should i add each of these manually? won't that come back and bite me in the ass later?

alissonfgp · Dec 3, 2013

yes =/, you have to add the missing, save your database when it ends. For warranty.

luddo9 · Dec 3, 2013

Now i got a other question, how Execly do i map edit the "realmap"? i tried importing it to RME but it gets 97k missing tiles etc

Rickolajten · Dec 3, 2013

alissonfgp said:
yes =/, you have to add the missing, save your database when it ends. For warranty.

Added all the missing columns manually, took me like 30 minutes.. then this came up

#1452 - Cannot add or update a child row: a foreign key constraint fails (`panaxia`.`players`, CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE)

So i guess i fucked it up badly. I also tried downloading your server.sql but all sorts of errors came up. :-(

Rickolajten · Dec 3, 2013

It's indeed really frustrating that you can't edit posts.

Anyway, just a quick tip from me.. if you wan't the real tibia look and can't be bothered to mess around with geisors you can use znote and download the template from znote here: http://otland.net/threads/znote-aac-tibiacom-template.191625/

(Maybe me and some others should take discussions like this elsewhere since it doesnt really belong in this thread)

Rickolajten · Dec 3, 2013

This is gonna sound extremely stupid, but how does this server save? /save doesnt work and well.. it doesnt seem to save automatically.

Zarmaka · Dec 3, 2013

Code:

-- Connection Config
ip = "127.0.0.1"
bindOnlyGlobalAddress = "no"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171
maxPlayers = "1000"
motd = "Welcome to The Forgotten Server!"
onePlayerOnlinePerAccount = "yes"
allowClones = "no"
serverName = "Thais"
adminLogsEnabled = "no"
statusTimeout = 60000
replaceKickOnLogin = "yes"
maxPacketsPerSecond = 25

Does anything look wrong in this code? I can't connect to the server at all. Ports are open :/

Tazer · Dec 3, 2013

alissonfgp said:
you can try for add field

Code:

ALTER TABLE `accounts` ADD `world_id` INTEGER(11) NOT NULL DEFAULT 0;

OR
tries to use that to my database Gesior, have to clean some tables.
http://www.mediafire.com/download/sbvkk2v1nxfyyib/server.rar
Here it works 100%...

What Website Acc do you use there?

tibia held · Dec 3, 2013

I know it's probably the dumbest question , but does anybody know where I get a database or how I can make one? ._.

Wartio · Dec 3, 2013

Tazer said:
What Website Acc do you use there?

Gesior AAC 1.0

Wartio · Dec 3, 2013

tibia held said:
I know it's probably the dumbest question , but does anybody know where I get a database or how I can make one? ._.

You have to enter "phpmyadmin" then "create database, choose any name you want" then "import" your schema.sql into your database. , Schema is located in your server directory/schemas, otherwise just in your server directory

tibia held · Dec 3, 2013

Wartio said:
You have to enter "phpmyadmin" then "create database, choose any name you want" then "import" your schema.sql into your database. , Schema is located in your server directory/schemas, otherwise just in your server directory

Thanks for your help

Charmz · Dec 3, 2013

i cant get znote acc to work out,
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', '1386086644');

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', '1386086644');

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', '1386086644', '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 ;

Rickolajten · Dec 3, 2013

Anyone figured out how to save the server yet?

Ninja · Dec 3, 2013

Rickolajten said:
Anyone figured out how to save the server yet?

Register the talkaction in talkactions.xml if you haven't done that already.

Code:

<talkaction words="/save" script="save.lua"/>

Or use global save.

Rickolajten · Dec 3, 2013

Ninja said:
Register the talkaction in talkactions.xml if you haven't done that already.

Code:

<talkaction words="/save" script="save.lua"/>

Or use global save.

I got not save.lua though, is that a known TFS 1.0 thingy?
I tried using the global save, i'll see if it works in 5 minutes.

[10.77][TFS 1.2] ORTS, a real map project

|| Blazera.net ||

Member

LUA, C, C++, C#

LUA, C, C++, C#

Member

LUA, C, C++, C#

New Member

Member

Member

Member

New Member

Banned User

New Member

Any game ideas?

Any game ideas?

New Member

New Member

Member

Global Moderator

Member

Similar threads