PHP OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Pan Kropelka · Apr 5, 2013

Witam!

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

Poni?ej zapytania potrzebne do MySQL:

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 CASCADE;

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 ;

Download:

You do not have permission to view link please Log in or Register

Dowody wdzi?czno?ci TUTAJ przyjmuj?, cho? nie zmuszam, ale mi?o by by?o.

sioter5 · Apr 5, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Dzia. Wiedzia?em ,?e cz?owiek zacny z Ciebie. I pr?dzej czy p??niej doczekamy si? tego.
Bless

Brzustek · Apr 5, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Dzi?ki ;D

DJ Mrozu · Apr 5, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Konkurs wygra?e? na 1000000%

Pan Kropelka · Apr 5, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

WDZI?CZNO?? oka?cie jak??.

#SWAG · Apr 5, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Code:

Podzi?kowa? 35 w 19 postach

Okazujemy, okazujemy

Teraz czeka? tylko na tematy z problemami xd

karabasz · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

zawarto?ci

Code:

z_shop_offer

by? nie znalaz? ?

Brzustek · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Nie s? to wszystkie zapytania :|

Edit : Sory, s? wszystkie

Pan Kropelka · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

karabasz said:
zawarto?ci

Code:

z_shop_offer

by? nie znalaz? ?

Zaimportuj sobie czyst? baz? TFS'a. (lub tworzy si? przy instalacji gesiora, nie pami?tam dok?adnie).
Ju? widz?, jakie b?d? kolejne edycje materii. :ninja:

Clean-Sector · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

yea stawia? materie ! ;o joke ^.^ kto postawi tak? gotow? materie to naprawd? musi by? debilem..! Ludzie r?bcie co? swojego a nie same gotowce!

Ja tylko z tej strony par? skrypt?w wykorzystam do ots'a ;d

#SWAG · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Ja tylko eventy bior?.

karabasz · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Pan Kropelka said:
Zaimportuj sobie czyst? baz? TFS'a. (lub tworzy si? przy instalacji gesiora, nie pami?tam dok?adnie).
Ju? widz?, jakie b?d? kolejne edycje materii. :ninja:

Mi chodzi o zawarto?? sms shopa. Nie gra?em tam i nie wiem co powstawia?.

Pan Kropelka · Apr 6, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

WSZYSTKO MASZ W PLIKU PHP SHOP SYSTEMU...
Nie musisz mie? z bazy item?w.

rafiik18 · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Wrzuci? by mi to kto? na jaki? inny hosting ni? speedyshare? <prosi>

DJ Mrozu · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Best said:
Ja tylko eventy bior?.

Czy jest tu moderator bo wed?ug mnie to off topic ;p

Kuzirashi · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Bez rewelki, nie znalaz?em tam nic ciekawego szczerze m?wi?c, ale dzi?ki za wrzutk?. Plus dla Ciebie. Mi?ego dnia.

Grecky · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Napisz, ?e to jest ?r?d?o z otlandu

Pan Kropelka · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Grecky said:
Napisz, ?e to jest ?r?d?o z otlandu

?e niby skopiowa?em to z otlandu?
najpierw udost?pni?em paczk? na tibia.net.pl, dopiero potem na otlandzie.

Grecky · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

no nie, ale pod Twoim Tematem na otland widzia?em jak kto? to doda?.

Pan Kropelka · Apr 7, 2013

Odp: OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Grecky said:
no nie, ale pod Twoim Tematem na otland widzia?em jak kto? to doda?.

Zgadza si?, ale ja jako pierwszy to tam udost?pni?em - na premium zone (dla donator?w).
Jaki? kole? po prostu skopiowa? i waln?? post z nowego konta.

Pozdrawiam!

PHP OTS MATERIA - otsmateria.pl - Edycja 2013 - FULL WWW folder. ZA DARMO!

Active User

Senior User

Senior User

Senior User

Active User

Dolej w?dy

Active User

Senior User

Active User

Senior User

Dolej w?dy

Active User

Active User

Banned

Senior User

ASP.NET MVC, JS-SPA, PHP, NODE

Active User

Active User

Active User

Active User