[GESIOR AAC] Full WWW otsmateria.pl folder - ALL scripts etc...

ADD TO DB:

Code (Text):

1. ALTER TABLE players ADD ip varchar(255) NOT NULL

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

1. CREATE TABLE `events` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `event_name` varchar(255) NOT NULL,
4.   `winner_name` varchar(255) NOT NULL,
5.   `won_item` varchar(255) NOT NULL,
6.   `time_win` int(7) NOT NULL,
7.   PRIMARY KEY (`id`)
8. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

1. CREATE TABLE `application` (
2.   `id` int(5) NOT NULL AUTO_INCREMENT,
3.   `nick` varchar(255) NOT NULL DEFAULT '',
4.   `guildid` int(11) NOT NULL,
5.   `players` varchar(255) NOT NULL DEFAULT '',
6.   `vt_ip` varchar(255) NOT NULL DEFAULT '',
7.   `vt_port` varchar(255) NOT NULL DEFAULT '',
8.   `vt_password` varchar(255) NOT NULL DEFAULT '',
9.   `vt_version` varchar(255) NOT NULL DEFAULT '',
10.   `vt_acc_nick` varchar(255) NOT NULL DEFAULT '',
11.   `vt_acc_password` varchar(255) NOT NULL DEFAULT '',
12.   `reason` varchar(255) NOT NULL DEFAULT '',
13.   `contact` varchar(255) NOT NULL DEFAULT '',
14.   `accept` int(5) NOT NULL DEFAULT 0,
15.   `data` int(10) NOT NULL,
16.   PRIMARY KEY (`id`)
17. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Code (Text):

1. CREATE TABLE IF NOT EXISTS `sms_cost` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `cash` double DEFAULT NULL,
4.   `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5.   PRIMARY KEY (`id`)
6. );

Code (Text):

1. CREATE TABLE IF NOT EXISTS `guild_wars` (
2.   `id` INT NOT NULL AUTO_INCREMENT,
3.   `guild_id` INT NOT NULL,
4.   `enemy_id` INT NOT NULL,
5.   `begin` BIGINT NOT NULL DEFAULT '0',
6.   `end` BIGINT NOT NULL DEFAULT '0',
7.   `frags` INT UNSIGNED NOT NULL DEFAULT '0',
8.   `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
9.   `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
10.   `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
11.   `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
12.   PRIMARY KEY (`id`),
13.   KEY `status` (`status`),
14.   KEY `guild_id` (`guild_id`),
15.   KEY `enemy_id` (`enemy_id`)
16. ) ENGINE=InnoDB;

Code (Text):

1. ALTER TABLE `guild_wars`
2.   ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
3.   ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

Code (Text):

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

Code (Text):

1. CREATE TABLE IF NOT EXISTS `guild_kills` (
2.   `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
3.   `guild_id` INT NOT NULL,
4.   `war_id` INT NOT NULL,
5.   `death_id` INT NOT NULL
6. ) ENGINE = InnoDB;

Code (Text):

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

Code (Text):

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

Code (Text):

1. CREATE TABLE IF NOT EXISTS `z_forum` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `sticky` tinyint(1) NOT NULL DEFAULT '0',
4.   `closed` tinyint(1) NOT NULL DEFAULT '0',
5.   `first_post` int(11) NOT NULL DEFAULT '0',
6.   `last_post` int(11) NOT NULL DEFAULT '0',
7.   `section` int(3) NOT NULL DEFAULT '0',
8.   `icon_id` int(3) NOT NULL DEFAULT '1',
9.   `replies` int(20) NOT NULL DEFAULT '0',
10.   `views` int(20) NOT NULL DEFAULT '0',
11.   `author_aid` int(20) NOT NULL DEFAULT '0',
12.   `author_guid` int(20) NOT NULL DEFAULT '0',
13.   `post_text` text NOT NULL,
14.   `post_topic` varchar(255) NOT NULL,
15.   `post_smile` tinyint(1) NOT NULL DEFAULT '0',
16.   `post_date` int(20) NOT NULL DEFAULT '0',
17.   `last_edit_aid` int(20) NOT NULL DEFAULT '0',
18.   `edit_date` int(20) NOT NULL DEFAULT '0',
19.   `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
20.   PRIMARY KEY (`id`),
21.   KEY `section` (`section`)
22. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

Code (Text):

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

Code (Text):

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

Code (Text):

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

Code (Text):

1. CREATE TABLE `guild_competition` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `guild_id` int(11) NOT NULL,
4.   `guild_name` varchar(255) NOT NULL,
5.   `group_first` varchar(30) NOT NULL,
6.   `group_second` varchar(30) NOT NULL,
7.   `group_semi_final` varchar(30) NOT NULL,
8.   `group_final` varchar(30) NOT NULL,
9.   `group_winner` varchar(30) NOT NULL,
10.   `wins` int(5) NOT NULL DEFAULT '0',
11.   `losses` int(5) NOT NULL DEFAULT '0',
12.   `draws` int(5) NOT NULL DEFAULT '0',
13.   PRIMARY KEY (`id`)
14. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Code (Text):

1. CREATE TABLE `guild_fights` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `guild_id` int(11) NOT NULL,
4.   `guild_name` varchar(255) NOT NULL,
5.   `enemy_id` int(11) NOT NULL,
6.   `enemy_name` varchar(255) NOT NULL,
7.   `time_fight` int(11) NOT NULL,
8.   `winner` int(11) NOT NULL DEFAULT '0',
9.   `losser` int(11) NOT NULL DEFAULT '0',
10.   `room` int(10) NOT NULL,
11.   `join_first` varchar(10) NOT NULL DEFAULT 'false',
12.   `join_second` varchar(10) NOT NULL DEFAULT 'false',
13.   `running` varchar(10) NOT NULL DEFAULT 'false',
14.   `joining` varchar(10) NOT NULL DEFAULT 'false',
15.   PRIMARY KEY (`id`)
16. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Code (Text):

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

Code (Text):

1. CREATE TABLE IF NOT EXISTS `sellchar` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `name` varchar(40) NOT NULL,
4.   `vocation` int(11) NOT NULL,
5.   `price` int(11) NOT NULL,
6.   `status` varchar(40) NOT NULL,
7.   `oldid` varchar(40) NOT NULL,
8.   PRIMARY KEY (`id`)
9. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

Code (Text):

1. CREATE TABLE IF NOT EXISTS `z_forum2` (
2.   `id` int(11) NOT NULL AUTO_INCREMENT,
3.   `sticky` tinyint(1) NOT NULL DEFAULT '0',
4.   `closed` tinyint(1) NOT NULL DEFAULT '0',
5.   `first_post` int(11) NOT NULL DEFAULT '0',
6.   `last_post` int(11) NOT NULL DEFAULT '0',
7.   `section` int(3) NOT NULL DEFAULT '0',
8.   `icon_id` int(3) NOT NULL DEFAULT '1',
9.   `replies` int(20) NOT NULL DEFAULT '0',
10.   `views` int(20) NOT NULL DEFAULT '0',
11.   `author_aid` int(20) NOT NULL DEFAULT '0',
12.   `author_guid` int(20) NOT NULL DEFAULT '0',
13.   `post_text` text NOT NULL,
14.   `post_topic` varchar(255) NOT NULL,
15.   `post_smile` tinyint(1) NOT NULL DEFAULT '0',
16.   `post_date` int(20) NOT NULL DEFAULT '0',
17.   `last_edit_aid` int(20) NOT NULL DEFAULT '0',
18.   `edit_date` int(20) NOT NULL DEFAULT '0',
19.   `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
20.   PRIMARY KEY (`id`),
21.   KEY `section` (`section`)
22. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;

Download: HERE

 

add this line too:

 

this is not for geisor lol!
nm. i think it is but it's buggy

 

Could you give us screen from otsmateria's layout?

 

yeah give screeny

 

rehost please?

 

rehost plis

 

Can rehost this rar? I will use it to edit my old own site.

 

Re-Upload ? Please ? Thanks