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

Discussion in 'The Graveyard' started by Pan Kropelka, Apr 6, 2013.

  1. Pan Kropelka

    Pan Kropelka I HATE SLENDER :(

    Joined:
    Mar 28, 2013
    Messages:
    19
    Likes Received:
    4
    Best Answers:
    0
    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
     
  2. gumekskc

    gumekskc Member

    Joined:
    Sep 20, 2009
    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    add this line too:

     
  3. Dexter91

    Dexter91 New Member

    Joined:
    Mar 31, 2013
    Messages:
    72
    Likes Received:
    9
    Best Answers:
    0
    this is not for geisor lol!
    nm. i think it is but it's buggy
     
    Last edited: Apr 10, 2013
  4. Uzzio

    Uzzio New Member

    Joined:
    Jan 3, 2009
    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Could you give us screen from otsmateria's layout?
     
  5. maladiec

    maladiec Member

    Joined:
    May 9, 2010
    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    yeah give screeny :p
     
  6. Wolfenrir

    Wolfenrir how you remind me?

    Joined:
    Sep 29, 2008
    Messages:
    106
    Likes Received:
    1
    Best Answers:
    0
    rehost please?
     
  7. krzychu660

    krzychu660 New Member

    Joined:
    Nov 4, 2014
    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    rehost plis
     
  8. Ervvin

    Ervvin New Member

    Joined:
    Apr 21, 2015
    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Can rehost this rar? I will use it to edit my old own site.
     
  9. mackowiaq

    mackowiaq New Member

    Joined:
    Dec 9, 2013
    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Re-Upload ? Please ? :) Thanks :)
     

Share This Page

Loading...