OTS MATERIA - otsmateria.pl - DATA+MODS- EVOLUTION MAP - Last Edition 2013! for FREE!

Pan Kropelka · Apr 4, 2013

otsmateria.pl - last edition - free [8.60]

(dead screenshots removed)

I'm not helping with that!

Scarlet Ayleid · Apr 5, 2013

Approved

Gregorex · Apr 5, 2013

Wasn't Zao the last edition? Thanks anyway

Gollum · Apr 5, 2013

Lookin good

danipopeye · Apr 6, 2013

Very good! Rep+

killing · Apr 6, 2013

Repp
<_<

demoniclooz · Apr 6, 2013

Witam!
Full WWW folder serwera otsmateria.pl
Wszystkie pliki czyste, nic nie zmieniane.

Poniżej zapytania potrzebne do MySQL:

Folder WWW:
Download: CLICK

- - - Updated - - -

Code:

ALTER TABLE players ADD ip varchar(255) NOT NULL

Code:

CREATE TABLE `castle_fighters` (
  `id` INT(11) NOT NULL,
  `guild` INT(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Code:

CREATE TABLE `castle` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `owner` INT(11) NOT NULL,
  `guild_name` VARCHAR(99) NOT NULL,
  `king` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Code:

CREATE TABLE `castle_dmg` (
  `guild` INT(11) NOT NULL,
  `dmg` INT(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Code:

CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_name` varchar(255) NOT NULL,
  `winner_name` varchar(255) NOT NULL,
  `won_item` varchar(255) NOT NULL,
  `time_win` int(7) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

Code:

ALTER TABLE `z_shop_offer` ADD `bought` INT( 11 ) NOT NULL DEFAULT '0';

Code:

ALTER TABLE `accounts` ADD `ip` VARCHAR( 30 ) NOT NULL ;

Code:

ALTER TABLE `accounts` ADD `get_points` INT(11) NOT NULL DEFAULT '0';

Code:

ALTER TABLE `guilds` ADD `get_points` INT(11) NOT NULL DEFAULT '0';

Code:

ALTER TABLE `players` ADD `get_points` INT(11) NOT NULL DEFAULT '0';

Code:

ALTER TABLE `accounts` ADD `guild_points` int(11) NOT NULL DEFAULT '0';

Code:

CREATE TABLE `application` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `nick` varchar(255) NOT NULL DEFAULT '',
  `guildid` int(11) NOT NULL,
  `players` varchar(255) NOT NULL DEFAULT '',
  `vt_ip` varchar(255) NOT NULL DEFAULT '',
  `vt_port` varchar(255) NOT NULL DEFAULT '',
  `vt_password` varchar(255) NOT NULL DEFAULT '',
  `vt_version` varchar(255) NOT NULL DEFAULT '',
  `vt_acc_nick` varchar(255) NOT NULL DEFAULT '',
  `vt_acc_password` varchar(255) NOT NULL DEFAULT '',
  `reason` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `accept` int(5) NOT NULL DEFAULT 0,
  `data` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Code:

CREATE TABLE IF NOT EXISTS `sms_cost` ( 
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `cash` double DEFAULT NULL, 
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  PRIMARY KEY (`id`) 
);

Code:

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT '0',
  `end` BIGINT NOT NULL DEFAULT '0',
  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;

Code:

ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCAD

Code:

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

Code:

CREATE TABLE IF NOT EXISTS `guild_kills` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `guild_id` INT NOT NULL,
  `war_id` INT NOT NULL,
  `death_id` INT NOT NULL
) ENGINE = InnoDB;

Code:

ALTER TABLE `guild_kills`
  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

Code:

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

Code:

CREATE TABLE IF NOT EXISTS `z_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `icon_id` int(3) NOT NULL DEFAULT '1',
  `replies` int(20) NOT NULL DEFAULT '0',
  `views` int(20) NOT NULL DEFAULT '0',
  `author_aid` int(20) NOT NULL DEFAULT '0',
  `author_guid` int(20) NOT NULL DEFAULT '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
  `post_date` int(20) NOT NULL DEFAULT '0',
  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
  `edit_date` int(20) NOT NULL DEFAULT '0',
  `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

Code:

CREATE TABLE IF NOT EXISTS `lists_cache` (
  `cache_id` char(32) NOT NULL,
  `cache_html` mediumtext,
  `cache_date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cache_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code:

CREATE TABLE `point_winner` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `account_id` INT(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Code:

ALTER TABLE accounts ADD referrer INT(11) NOT NULL DEFAULT '0';

Code:

CREATE TABLE `guild_competition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `guild_name` varchar(255) NOT NULL,
  `group_first` varchar(30) NOT NULL,
  `group_second` varchar(30) NOT NULL,
  `group_semi_final` varchar(30) NOT NULL,
  `group_final` varchar(30) NOT NULL,
  `group_winner` varchar(30) NOT NULL,
  `wins` int(5) NOT NULL DEFAULT '0',
  `losses` int(5) NOT NULL DEFAULT '0',
  `draws` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Code:

CREATE TABLE `guild_fights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `guild_name` varchar(255) NOT NULL,
  `enemy_id` int(11) NOT NULL,
  `enemy_name` varchar(255) NOT NULL,
  `time_fight` int(11) NOT NULL,
  `winner` int(11) NOT NULL DEFAULT '0',
  `losser` int(11) NOT NULL DEFAULT '0',
  `room` int(10) NOT NULL,
  `join_first` varchar(10) NOT NULL DEFAULT 'false',
  `join_second` varchar(10) NOT NULL DEFAULT 'false',
  `running` varchar(10) NOT NULL DEFAULT 'false',
  `joining` varchar(10) NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Code:

ALTER TABLE guild_fights ADD guild_frags INT(5) NOT NULL DEFAULT '0';
ALTER TABLE guild_fights ADD enemy_frags INT(5) NOT NULL DEFAULT '0';
ALTER TABLE guild_competition ADD status INT(1) NOT NULL DEFAULT '0';

Code:

CREATE TABLE IF NOT EXISTS `sellchar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `vocation` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `status` varchar(40) NOT NULL,
  `oldid` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

Code:

CREATE TABLE IF NOT EXISTS `z_forum2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sticky` tinyint(1) NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `icon_id` int(3) NOT NULL DEFAULT '1',
  `replies` int(20) NOT NULL DEFAULT '0',
  `views` int(20) NOT NULL DEFAULT '0',
  `author_aid` int(20) NOT NULL DEFAULT '0',
  `author_guid` int(20) NOT NULL DEFAULT '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
  `post_date` int(20) NOT NULL DEFAULT '0',
  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
  `edit_date` int(20) NOT NULL DEFAULT '0',
  `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;

killing · Apr 10, 2013

So where is Hunthing room?

noobwars · Apr 11, 2013

Anyone knows what TFS REV / SVN, they used? and what type of Xampp?, cuz im getting "Canno't Connect to MySQL Database" even if im doing everything right!!!!!!.

avaster12 · May 9, 2013

How to fix this error

[02/05/2013 12:12:25] Brzuszek has logged in.

[02/05/2013 12:12:25] [Error - CreatureScript Interface]
[02/05/2013 12:12:25] buffernLogin
[02/05/2013 12:12:25] Description:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: attempt to compare number with string
[02/05/2013 12:12:25] stack traceback:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: in function <[string "loadBuffer"]:3>

[02/05/2013 12:12:25] [Error - CreatureScript Interface]
[02/05/2013 12:12:25] buffernLogin
[02/05/2013 12:12:25] Description:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: attempt to compare number with string
[02/05/2013 12:12:25] stack traceback:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: in function <[string "loadBuffer"]:3>

[02/05/2013 12:12:25] [Error - CreatureScript Interface]
[02/05/2013 12:12:25] data/creaturescripts/scripts/login.luanLogin
[02/05/2013 12:12:25] Description:
[02/05/2013 12:12:25] data/creaturescripts/scripts/login.lua:23: attempt to call global 'doPlayerOpenChannel' (a nil value)
[02/05/2013 12:12:25] stack traceback:
[02/05/2013 12:12:25] data/creaturescripts/scripts/login.lua:23: in function <data/creaturescripts/scripts/login.lua:18>

[02/05/2013 12:12:25] [Error - CreatureScript Interface]
[02/05/2013 12:12:25] buffernLogin
[02/05/2013 12:12:25] Description:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: attempt to compare number with string
[02/05/2013 12:12:25] stack traceback:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: in function <[string "loadBuffer"]:3>

[02/05/2013 12:12:25] [Error - CreatureScript Interface]
[02/05/2013 12:12:25] buffernLogin
[02/05/2013 12:12:25] Description:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: attempt to compare number with string
[02/05/2013 12:12:25] stack traceback:
[02/05/2013 12:12:25] [string "loadBuffer"]:4: in function <[string "loadBuffer"]:3>
[02/05/2013 12:12:25] Brzuszek has logged out.

Beyond Sky · May 16, 2013

The link says it needs to be to get premium download

Spankarn · May 16, 2013

Last Edition 2013! for FREE!
Hahaha
!

It's not free...
i need prem download thingy..

Upload it for free ... not for only prems..

Demrenfaris · May 16, 2013

Reupload: OTS MATERIA - otsmateria.pl - DATA+MODS- EVOLUTION MAP - Last Edition 2013! for FREE!
Scan: https://www.virustotal.com/pl/file/...ddc7213c2a0060e49a313de1/analysis/1368716108/

tetra20 · Jun 3, 2013

can i have the source??

Zerak · Jun 5, 2013

What's up with all these errors?

And it keeps on spamming errors.

Azkuzz · Jun 7, 2013

What distro is this used with? Can't get any distro to work with this?

danipopeye · Jun 8, 2013

Azkuzz said:
What distro is this used with? Can't get any distro to work with this?

Hiho, I am using TFS 0.4_SVN and it works perfectly

0 errors on console

Azkuzz · Jun 8, 2013

Could you link to the distro, can't seem to find it :/ ?

Mr.Bela · Jun 15, 2013

danipopeye said:
Hiho, I am using TFS 0.4_SVN and it works perfectly 0 errors on console

0.4 rev ???

antamalak · Jun 16, 2013

U Was Say The Server For Free But the server Premium Make Server Free In Speady Share

OTS MATERIA - otsmateria.pl - DATA+MODS- EVOLUTION MAP - Last Edition 2013! for FREE!

I HATE SLENDER :(

Attachments

Advanced OT User

Ϡϡ

ayy lmao

127.0.0.1

Member

New Member

Member

NoobWars.hopto.org Hoster

New Member

Weed is Life

New Member

Senior Member

DD

http://otstatus.com/

Pro

127.0.0.1

Pro

Back :P

New Member

Similar threads