CREATE TABLE IF NOT EXISTS `arenaprzedmioty` (
  `uid` int(11) NOT NULL,
  `itemID` int(11) NOT NULL,
  KEY `uid` (`uid`,`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `arenaprzedmioty` (`uid`, `itemID`) VALUES
(1, 4),
(4, 20),
(7, 1),
(7, 1),
(7, 1),
(7, 1),
(7, 1),
(7, 1),
(13, 3),
(43, 15);


CREATE TABLE IF NOT EXISTS `arenaprzedmiotyInfo` (
  `item` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT '7',
  `name` text NOT NULL,
  `gold` int(11) NOT NULL,
  `attack` int(11) NOT NULL,
  `defence` int(11) NOT NULL,
  `lifeMax` int(11) NOT NULL,
  `dMin` int(11) NOT NULL,
  `dMax` int(11) NOT NULL,
  PRIMARY KEY (`item`),
  KEY `type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;


INSERT INTO `arenaprzedmiotyInfo` (`item`, `type`, `name`, `gold`, `attack`, `defence`, `lifeMax`, `dMin`, `dMax`) VALUES
(1, 0, 'Jabłko', 10, 0, 0, 10, 0, 0),
(2, 0, 'Truskawka', 15, 0, 0, 20, 0, 0),
(3, 0, 'Gruszka', 20, 0, 0, 35, 0, 0),
(4, 0, 'Banan', 50, 0, 0, 150, 0, 0),
(5, 0, 'Ser', 100, 0, 0, 310, 0, 0),
(6, 0, 'Ryba', 150, 0, 0, 600, 0, 0),
(7, 0, 'Chleb', 200, 0, 0, 1000, 0, 0),
(8, 0, 'Mięso', 500, 0, 0, 3000, 0, 0),
(9, 1, 'Miecz', 250, 10, 0, 0, 3, 5),
(10, 1, 'Włócznia', 240, 7, 5, 0, 2, 4),
(11, 1, 'Młot', 350, 0, 0, 0, 5, 7),
(12, 1, 'Morningstar', 500, 0, 0, 0, 8, 11),
(13, 1, 'Topór', 400, 5, 0, 0, 3, 8),
(14, 1, 'Długi miecz', 600, 15, 0, 0, 6, 9),
(15, 1, 'Katana', 1000, 25, 0, 0, 9, 13),
(16, 1, 'Lanca', 700, 10, 15, 0, 6, 9),
(17, 1, 'Tasak', 1100, 0, 0, 0, 11, 18),
(18, 1, 'Wielki topór ', 1500, 0, 0, 0, 16, 20),
(19, 1, 'Topór barbarzyńcy', 2500, 0, 0, 0, 25, 31),
(20, 2, 'Puklerz', 300, 0, 15, 0, 0, 0),
(21, 2, 'Mała tarcza', 500, 0, 20, 0, 0, 0),
(22, 2, 'Stalowa tarcza', 1240, 0, 50, 0, 0, 0),
(23, 2, 'Tarcza rycerska', 2765, 0, 75, 0, 0, 0),
(24, 3, 'Kaszliet', 200, 0, 5, 0, 0, 0),
(25, 3, 'Hełm', 785, 0, 15, 0, 0, 0),
(26, 3, 'Hełm wojownika', 1000, 0, 44, 0, 0, 0),
(27, 4, 'Koszula', 500, 0, 15, 0, 0, 0),
(28, 4, 'Skórzana koszula', 750, 0, 25, 0, 0, 0),
(29, 4, 'Zbroja', 1755, 0, 50, 0, 0, 0),
(30, 4, 'Zbroja płytowa', 3485, 0, 100, 0, 0, 0),
(31, 4, 'Pełna zbroja płytowa', 6785, 0, 125, 25, 0, 0),
(32, 5, 'Buty', 50, 2, 1, 0, 0, 0),
(33, 5, 'Wzmocnione buty', 250, 4, 2, 0, 0, 0),
(34, 6, 'Pierścień ochrony', 5000, 0, 50, 50, 0, 0),
(35, 6, 'Pierścień mocy', 5000, 50, 0, 0, 10, 15),
(36, 6, 'Pierścień ducha', 3000, 0, 0, 100, 0, 0),
(37, 7, 'Medalion Pradawnych', 13575, 25, 25, 50, 5, 15),
(38, 7, 'Gwiazda Północy', 12355, 0, 75, 100, 0, 0);



CREATE TABLE IF NOT EXISTS `enemy` (
  `enemy` int(11) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `attack` int(11) NOT NULL,
  `defence` int(11) NOT NULL,
  `lifeMax` int(11) NOT NULL,
  `dMin` int(11) NOT NULL,
  `dMax` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  PRIMARY KEY (`enemy`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;



INSERT INTO `enemy` (`enemy`, `username`, `attack`, `defence`, `lifeMax`, `dMin`, `dMax`, `exp`, `gold`) VALUES
(1, 'Pszczoła', 70, 20, 30, 3, 4, 1, 2),
(2, 'Żaba', 80, 25, 50, 3, 7, 2, 3),
(3, 'Pająk', 100, 30, 60, 4, 7, 3, 10),
(4, 'Centaur', 110, 70, 30, 6, 9, 4, 1),
(5, 'Harpia', 120, 100, 120, 11, 15, 6, 6),
(6, 'Wojownik', 150, 120, 150, 25, 50, 20, 30),
(7, 'Meduza', 170, 150, 200, 25, 50, 30, 50),
(8, 'Drzewiec', 125, 250, 500, 30, 60, 50, 100),
(9, 'Olbrzym', 250, 150, 500, 50, 75, 100, 500),
(10, 'Czerwony Smok', 300, 300, 1000, 100, 125, 500, 1000);


CREATE TABLE IF NOT EXISTS `enemyLocations` (
  `locationID` int(11) NOT NULL,
  `enemyID` int(11) NOT NULL,
  KEY `locationID` (`locationID`,`enemyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `enemyLocations` (`locationID`, `enemyID`) VALUES
(1, 1),
(1, 1),
(1, 1),
(1, 1),
(1, 2),
(1, 2),
(2, 1),
(2, 1),
(2, 2),
(2, 2),
(2, 3),
(2, 3),
(3, 3),
(3, 3),
(3, 4),
(3, 4),
(3, 5),
(3, 6),
(4, 3),
(4, 6),
(4, 7),
(4, 8),
(5, 7),
(5, 8),
(5, 9),
(5, 10);



CREATE TABLE IF NOT EXISTS `locations` (
  `location` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `lvl` int(11) NOT NULL,
  PRIMARY KEY (`location`),
  KEY `lvl` (`lvl`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;


INSERT INTO `locations` (`location`, `name`, `lvl`) VALUES
(1, 'Wichorowe wzgórza', 1),
(2, 'Przełęcz Umarlaków', 3),
(3, 'Pustkowia', 5),
(4, 'Dolina Cieni', 7),
(5, 'Skaliste góry', 10);


CREATE TABLE IF NOT EXISTS `raporty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `tekst` text NOT NULL,
  `czas` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER  TABLE `game_users` ADD `resetBonus` VARCHAR( 16 ) NOT NULL ,
ADD  `points` INT NOT NULL DEFAULT '0',
ADD `arena` INT NOT NULL DEFAULT '0',
ADD `exp` INT NOT NULL DEFAULT '0',
ADD  `expLvl` int(11) NOT NULL DEFAULT '100',
ADD  `lvl` int(11) NOT NULL DEFAULT '1',
ADD  `skills` int(11) NOT NULL DEFAULT '5',
ADD  `gold` int(11) NOT NULL DEFAULT '1000',
ADD  `attack` int(11) NOT NULL DEFAULT '1',
ADD  `defence` int(11) NOT NULL DEFAULT '1',
ADD  `life` int(11) NOT NULL DEFAULT '100',
ADD  `lifeMax` int(11) NOT NULL DEFAULT '100',
ADD  `dMin` int(11) NOT NULL DEFAULT '1',
ADD  `dMax` int(11) NOT NULL DEFAULT '3',
ADD  `AP` int(11) NOT NULL DEFAULT '100',
ADD  `lastAP` int(11) NOT NULL DEFAULT '0',
ADD  `weapon` int(11) NOT NULL DEFAULT '0',
ADD  `shield` int(11) NOT NULL DEFAULT '0',
ADD  `helm` int(11) NOT NULL DEFAULT '0',
ADD  `armour` int(11) NOT NULL DEFAULT '0',
ADD  `legs` int(11) NOT NULL DEFAULT '0',
ADD  `ring` int(11) NOT NULL DEFAULT '0',
ADD  `necklage` int(11) NOT NULL DEFAULT '0',
ADD  `Bonus` int(11) NOT NULL DEFAULT '100';




INSERT INTO `game_templates` (`tid`, `title`, `template`, `sid`, `version`, `status`, `dateline`) VALUES
(589, 'gra_gosc', '<script type="text/javascript">\r\n<!--\r\n	lang.username = "{$lang->login_username}";\r\n	lang.password = "{$lang->login_password}";\r\n	lang.login = "{$lang->login}";\r\n	lang.lost_password = " &mdash; <a href=\\"{$mybb->settings[''bburl'']}/member.php?action=lostpw\\">{$lang->lost_password}<\\/a>";\r\n	lang.register_url = " &mdash; <a href=\\"{$mybb->settings[''bburl'']}/member.php?action=register\\">{$lang->welcome_register}<\\/a>";\r\n	lang.remember_me = "{$lang->remember_me}";\r\n// -->\r\n</script>\r\n<span style="float: right;">{$lang->welcome_current_time}</span>\r\n<span id="quick_login">{$lang->welcome_guest} \r\n	(\r\n	<a href="{$mybb->settings[''bburl'']}/member.php?action=login" onclick="MyBB.quickLogin(); return false;">\r\n		{$lang->welcome_login}\r\n	</a> \r\n	&mdash; \r\n	<a href="{$mybb->settings[''bburl'']}/member.php?action=register">\r\n		{$lang->welcome_register}\r\n	</a>\r\n	)\r\n</span>', -1, '1604', '', 1316373783),
(590, 'gra', '<html>\r\n<head>\r\n<title>{$podstrona}</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n<body>\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n<title>tytul</title>\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n\r\n<body>\r\n<div class="topHead" id="gTop" style="">\r\n	<div class="gTopmenu">\r\n		<div class="gTopmenucontent"></div>\r\n	</div>\r\n	<div class="Head">\r\n		<div class="mainMenu">\r\n			<div class="cache">\r\n				<img src="www/firstover.gif">\r\n				<img src="www/tabover.gif">\r\n				<img src="www/buttonover.gif">\r\n				<img src="www/buttonsmallover.gif">\r\n				<img src="www/block_buildover.gif">\r\n			</div>\r\n\r\n			{$menu}\r\n		</div>\r\n\r\n		<div class="gTopmaincontent">\r\n			<div class="bottomMainContent">\r\n				<div class="borderMainContent">\r\n					<div class="Content" id="Content">\r\n						<div class="cache">\r\n							<img src="www/buttonover.gif">\r\n							<img src="www/firstover.gif">\r\n							<img src="www/tabover.gif">\r\n						</div>\r\n<p style=''margin:20px auto; width:750px;''>tu np reklama cpm</p>\r\n\r\n						<table class="usertable">\r\n							<tbody>\r\n							<tr>\r\n								<td class="left">\r\n\r\n									<div class="box4">\r\n										<div class="box4bottom">\r\n											<div class="box4bg">\r\n												\r\n<h2 class="h2h"></h2>												<div style="padding:20px;">{$content}</div>\r\n												<div class="clear"></div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								\r\n									\r\n								</td>\r\n								<td class="right">\r\n									<div class="box3">\r\n										<div class="box3bottom">\r\n											<div class="box3bg">\r\n												<h2 class="h2f" ></h2>\r\n												<div style="padding:20px">{$welcomeblock}</div>\r\n{$logout}\r\n												\r\n												<h2 class="h2g" >Reklama</h2>\r\n												<div style=''padding:10px;''>\r\n												\r\n\r\n\r\n													</div>										\r\n											</div>\r\n										</div>\r\n									</div>\r\n									\r\n\r\n								</td>\r\n							</tr>\r\n							</tbody>\r\n						</table>\r\n\r\n						\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n\r\n\r\n\r\n</div>\r\n\r\n</body>\r\n</html>', -1, '1604', '', 1316508023),
(591, 'gra_user', '{$lang->welcome_back}\r\n<a href="{$mybb->settings[''bburl'']}/member.php?action=logout&amp;logoutkey={$mybb->user[''logoutkey'']}">{$lang->welcome_logout}</a>)<br />', -1, '1604', '', 1316373805),
(592, 'header_welcomeblock_guest', '<script type="text/javascript">\r\n<!--\r\n	lang.username = "{$lang->login_username}";\r\n	lang.password = "{$lang->login_password}";\r\n	lang.login = "{$lang->login}";\r\n	lang.lost_password = " &mdash; <a href=\\"{$mybb->settings[''bburl'']}/member.php?action=lostpw\\">{$lang->lost_password}<\\/a>";\r\n	lang.register_url = " &mdash; <a href=\\"{$mybb->settings[''bburl'']}/member.php?action=register\\">{$lang->welcome_register}<\\/a>";\r\n	lang.remember_me = "{$lang->remember_me}";\r\n// -->\r\n</script>\r\n\r\n		<span id="quick_login">{$lang->welcome_guest} (<a href="{$mybb->settings[''bburl'']}/member.php?action=login" onclick="MyBB.quickLogin(); return false;">{$lang->welcome_login}</a> &mdash; <a href="{$mybb->settings[''bburl'']}/member.php?action=register">{$lang->welcome_register}</a>)</span>', 1, '1604', '', 1316376160),
(593, 'header_welcomeblock_member', '{$lang->welcome_back}\r\n&nbsp;&mdash; <a href="{$mybb->settings[''bburl'']}/member.php?action=logout&amp;logoutkey={$mybb->user[''logoutkey'']}">{$lang->welcome_logout}</a>', 1, '1604', '', 1316376304),
(594, 'member_login', '<html>\r\n<head>\r\n<title>Dragon Quest</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n<body>\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n<title>tytul</title>\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n\r\n<body>\r\n<div class="topHead" id="gTop" style="">\r\n	<div class="gTopmenu">\r\n		<div class="gTopmenucontent"></div>\r\n	</div>\r\n	<div class="Head">\r\n		<a href="index.php" class="logo"><img src="www/pixel.gif" alt=""></a>\r\n		<div class="mainMenu">\r\n			<div class="cache">\r\n				<img src="www/firstover.gif">\r\n				<img src="www/tabover.gif">\r\n				<img src="www/buttonover.gif">\r\n				<img src="www/buttonsmallover.gif">\r\n				<img src="www/block_buildover.gif">\r\n			</div>\r\n\r\n			{$menu}\r\n		</div>\r\n\r\n		<div class="gTopmaincontent">\r\n			<div class="bottomMainContent">\r\n				<div class="borderMainContent">\r\n					<div class="Content" id="Content">\r\n						<div class="cache">\r\n							<img src="www/buttonover.gif">\r\n							<img src="www/firstover.gif">\r\n							<img src="www/tabover.gif">\r\n						</div>\r\n						<table class="usertable">\r\n							<tbody>\r\n							<tr>\r\n								<td class="left">\r\n									<div class="box4">\r\n										<div class="box4bottom">\r\n											<div class="box4bg">\r\n												<h2 class="h2h">Logowanie</h2>\r\n												<div style="padding:20px;">\r\n												{$inline_errors}\r\n{$member_loggedin_notice}\r\n<form action="member.php" method="post">\r\n<table border="0" cellspacing="{$theme[''borderwidth'']}" cellpadding="{$theme[''tablespace'']}" class="tborder">\r\n\r\n<tr>\r\n<td class="trow1"><strong>{$lang->username}</strong></td>\r\n<td class="trow1"><input type="text" class="textbox" name="username" size="25" maxlength="{$mybb->settings[''maxnamelength'']}" style="width: 200px;" value="{$username}" /></td>\r\n</tr>\r\n<tr>\r\n<td class="trow2"><strong>{$lang->password}</strong><br /><span class="smalltext">{$lang->pw_note}</span></td>\r\n<td class="trow2"><input type="password" class="textbox" name="password" size="25" style="width: 200px;" value="{$password}" /> <br/></td>\r\n</tr>\r\n<tr>\r\n<td class="trow1" colspan="2" align="center"><label title="{$lang->remember_me_desc}"><input type="checkbox" class="checkbox" name="remember" checked="checked" value="yes" /> {$lang->remember_me}</label></td>\r\n</tr>\r\n\r\n{$captcha}\r\n</table>\r\n<br />\r\n<div align="center"><input type="submit" class="button" name="submit" value="{$lang->login}" /></div>\r\n<input type="hidden" name="action" value="do_login" />\r\n<input type="hidden" name="url" value="{$redirect_url}" />\r\n\r\n<br/>\r\n<a href="member.php?action=lostpw">{$lang->lostpw_note}</a>\r\n</form>\r\n												\r\n												</div>\r\n												<div class="clear"></div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								\r\n									\r\n								</td>\r\n								<td class="right">\r\n									\r\n									\r\n<div class="box3">\r\n										<div class="box3bottom">\r\n											<div class="box3bg">\r\n												<h2 class="h2f" >Reklama</h2>\r\n												<div style=''padding:10px;''>\r\n												\r\n\r\n\r\n													</div></div>											\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</td>\r\n							</tr>\r\n							</tbody>\r\n						</table>\r\n\r\n						\r\n\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n\r\n</body>\r\n</html>', 1, '1604', '', 1316424507),
(595, 'member_lostpw', '<html>\r\n<head>\r\n<title>{$podstrona}</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n<body>\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n<title>tytul</title>\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n\r\n<body>\r\n<div class="topHead" id="gTop" style="">\r\n	<div class="gTopmenu">\r\n		<div class="gTopmenucontent"></div>\r\n	</div>\r\n	<div class="Head">\r\n		<a href="index.php" class="logo"><img src="www/pixel.gif" alt=""></a>\r\n		<div class="mainMenu">\r\n			<div class="cache">\r\n				<img src="www/firstover.gif">\r\n				<img src="www/tabover.gif">\r\n				<img src="www/buttonover.gif">\r\n				<img src="www/buttonsmallover.gif">\r\n				<img src="www/block_buildover.gif">\r\n			</div>\r\n\r\n			{$menu}\r\n		</div>\r\n\r\n		<div class="gTopmaincontent">\r\n			<div class="bottomMainContent">\r\n				<div class="borderMainContent">\r\n					<div class="Content" id="Content">\r\n						<div class="cache">\r\n							<img src="www/buttonover.gif">\r\n							<img src="www/firstover.gif">\r\n							<img src="www/tabover.gif">\r\n						</div>\r\n						<table class="usertable">\r\n							<tbody>\r\n							<tr>\r\n								<td class="left">\r\n									<div class="box4">\r\n										<div class="box4bottom">\r\n											<div class="box4bg">\r\n												<h2 class="h2h">Reset hasła</h2>\r\n												<div style="padding:20px;">\r\n<form action="member.php" method="post">\r\n<table border="0" cellspacing="{$theme[''borderwidth'']}" cellpadding="{$theme[''tablespace'']}" class="tborder">\r\n<tr>\r\n<td class="thead" colspan="2"><strong>{$lang->lost_pw_form}</strong></td>\r\n</tr>\r\n<tr>\r\n<td class="trow1" width="40%"><strong>{$lang->email_address}</strong></td>\r\n<td class="trow1" width="60%"><input type="text" class="textbox" name="email" /></td>\r\n</tr>\r\n</table>\r\n<br />\r\n<div align="center"><input type="submit" class="button" value="{$lang->request_user_pass}" /></div>\r\n<input type="hidden" name="action" value="do_lostpw" />\r\n</form>\r\n\r\n												</div>\r\n												<div class="clear"></div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								\r\n									\r\n								</td>\r\n								<td class="right">\r\n									\r\n									\r\n<div class="box3">\r\n										<div class="box3bottom">\r\n											<div class="box3bg">\r\n												<h2 class="h2f" >Reklama</h2>\r\n												<div style=''padding:10px;''>\r\n												\r\n\r\n\r\n													</div></div>											\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</td>\r\n							</tr>\r\n							</tbody>\r\n						</table>\r\n\r\n						\r\n\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n\r\n</body>\r\n</html>', 1, '1604', '', 1316424329),
(596, 'member_register', '<html>\r\n<head>\r\n<title>Dragon Quest</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n<body>\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n<title>tytul</title>\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n\r\n<body>\r\n<div class="topHead" id="gTop" style="">\r\n	<div class="gTopmenu">\r\n		<div class="gTopmenucontent"></div>\r\n	</div>\r\n	<div class="Head">\r\n		<a href="index.php" class="logo"><img src="www/pixel.gif" alt=""></a>\r\n		<div class="mainMenu">\r\n			<div class="cache">\r\n				<img src="www/firstover.gif">\r\n				<img src="www/tabover.gif">\r\n				<img src="www/buttonover.gif">\r\n				<img src="www/buttonsmallover.gif">\r\n				<img src="www/block_buildover.gif">\r\n			</div>\r\n\r\n			{$menu}\r\n		</div>\r\n\r\n		<div class="gTopmaincontent">\r\n			<div class="bottomMainContent">\r\n				<div class="borderMainContent">\r\n					<div class="Content" id="Content">\r\n						<div class="cache">\r\n							<img src="www/buttonover.gif">\r\n							<img src="www/firstover.gif">\r\n							<img src="www/tabover.gif">\r\n						</div>\r\n						<table class="usertable">\r\n							<tbody>\r\n							<tr>\r\n								<td class="left">\r\n									<div class="box4">\r\n										<div class="box4bottom">\r\n											<div class="box4bg">\r\n												<h2 class="h2h">Text</h2>\r\n												<div style="padding:20px;">\r\n<form action="member.php" method="post" id="registration_form"><input type="text" style="visibility: hidden;" value="" name="regcheck1" /><input type="text" style="visibility: hidden;" value="true" name="regcheck2" />\r\n{$regerrors}\r\n<table border="0" cellspacing="{$theme[''borderwidth'']}" cellpadding="{$theme[''tablespace'']}" class="tborder">\r\n<tr>\r\n<td width="50%" class="trow1" valign="top">\r\n<fieldset class="trow2">\r\n<legend><strong>Rejestracja</strong></legend>\r\n<table cellspacing="0" cellpadding="{$theme[''tablespace'']}" width="100%">\r\n<tr>\r\n<td colspan="2"><span class="smalltext"><label for="username">{$lang->username}</label></span></td>\r\n</tr>\r\n<tr>\r\n<td colspan="2"><input type="text" class="textbox" name="username" id="username"  value="{$username}" /></td>\r\n</tr>\r\n\r\n<tr>\r\n<td><span class="smalltext">Hasło:</span></td>\r\n<td><span class="smalltext">Potwierdź hasło:</span></td>\r\n</tr>\r\n\r\n\r\n<tr>\r\n<td><input type="password"  id="password" name="password" class="textbox">\r\n</td>\r\n<td><input type="password"  id="password2" name="password2" class="textbox"></td>\r\n</tr>\r\n\r\n\r\n<tr>\r\n<td><span class="smalltext"><label for="email">{$lang->email}</label></span></td>\r\n<td><span class="smalltext"><label for="email2">{$lang->confirm_email}</label></span></td>\r\n</tr>\r\n<tr>\r\n<td><input type="text" class="textbox" name="email" id="email"  maxlength="50" value="{$email}" /></td>\r\n<td><input type="text" class="textbox" name="email2" id="email2"  maxlength="50" value="{$email2}" /></td>\r\n</tr>\r\n<tr>\r\n	<td colspan="2" style="display: none;" id="email_status">&nbsp;</td>\r\n</tr>\r\n</table>\r\n</fieldset>\r\n{$requiredfields}\r\n</td>\r\n\r\n</tr>\r\n</table>\r\n<br />\r\n<div align="center">\r\n<input type="hidden" name="step" value="registration" />\r\n<input type="hidden" name="action" value="do_register" />\r\n<input type="submit" class="button" name="regsubmit" value="Zarejestruj!" />\r\n</div>\r\n</form>\r\n<script type="text/javascript">\r\n<!--\r\n	regValidator = new FormValidator(''registration_form'');\r\n	regValidator.register(''username'', ''notEmpty'', {failure_message:''{$lang->js_validator_no_username}''});\r\n    regValidator.register(''email'', ''regexp'', {match_field:''email2'', regexp:''^([a-zA-Z0-9_\\\\.\\\\+\\\\-])+\\\\@(([a-zA-Z0-9\\\\-])+\\\\.)+([a-zA-Z0-9]{2,4})+$'', failure_message:''{$lang->js_validator_invalid_email}''});\r\n	regValidator.register(''email2'', ''matches'', {match_field:''email'', status_field:''email_status'', failure_message:''{$lang->js_validator_email_match}''});\r\n{$validator_extra}\r\n	regValidator.register(''username'', ''ajax'', {url:''xmlhttp.php?action=username_availability'', loading_message:''{$lang->js_validator_checking_username}''}); // needs to be last\r\n// -->\r\n</script>\r\n												</div>\r\n												<div class="clear"></div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								\r\n									\r\n								</td>\r\n								<td class="right">\r\n									\r\n									\r\n<div class="box3">\r\n										<div class="box3bottom">\r\n											<div class="box3bg">\r\n												<h2 class="h2f" >Reklama</h2>\r\n												<div style=''padding:10px;''>\r\n												\r\n\r\n\r\n													</div></div>											\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</td>\r\n							</tr>\r\n							</tbody>\r\n						</table>\r\n\r\n						\r\n\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n\r\n</body>\r\n</html>', 1, '1604', '', 1316423951),
(597, 'member_register_agreement', '<html>\r\n<head>\r\n<title>Dragon Quest</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n<body>\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">\r\n<title>tytul</title>\r\n<link rel="stylesheet" type="text/css" href="www/design.css">\r\n<link rel="stylesheet" type="text/css" href="www/style.css">\r\n</head>\r\n\r\n<body>\r\n<div class="topHead" id="gTop" style="">\r\n	<div class="gTopmenu">\r\n		<div class="gTopmenucontent"></div>\r\n	</div>\r\n	<div class="Head">\r\n		<a href="index.php" class="logo"><img src="www/pixel.gif" alt=""></a>\r\n		<div class="mainMenu">\r\n			<div class="cache">\r\n				<img src="www/firstover.gif">\r\n				<img src="www/tabover.gif">\r\n				<img src="www/buttonover.gif">\r\n				<img src="www/buttonsmallover.gif">\r\n				<img src="www/block_buildover.gif">\r\n			</div>\r\n\r\n			{$menu}\r\n		</div>\r\n\r\n		<div class="gTopmaincontent">\r\n			<div class="bottomMainContent">\r\n				<div class="borderMainContent">\r\n					<div class="Content" id="Content">\r\n						<div class="cache">\r\n							<img src="www/buttonover.gif">\r\n							<img src="www/firstover.gif">\r\n							<img src="www/tabover.gif">\r\n						</div>\r\n						<table class="usertable">\r\n							<tbody>\r\n							<tr>\r\n								<td class="left">\r\n									<div class="box4">\r\n										<div class="box4bottom">\r\n											<div class="box4bg">\r\n												<h2 class="h2h">Rejestracja</h2>\r\n\r\n<div style="padding:20px;">\r\n\r\n<form action="member.php" method="post">\r\n<table border="0" cellspacing="{$theme[''borderwidth'']}" cellpadding="{$theme[''tablespace'']}" class="tborder">\r\n<tr>\r\n<td class="thead"><strong>Dragon Quest - Regulamin gry i forum</strong><br/><br/></td>\r\n</tr>\r\n<tr>\r\n<td class="trow1">\r\n<p>Zabrania się publikowania treści prowokacyjnych, obraźliwych, erotycznych, rasistowskich, faszystowskich itp. Zabrania się również pisania zbędnych, nie wnoszących nic do tematu wypowiedzi.\r\n<br/><br/></p>\r\n<p>Rejestrując się  oświadczasz, że masz świadomość iż NIE WOLNO Ci pisać postów łamiących te zasady.\r\n<br/><br/></p>\r\n<p>Jeśli złamiesz któreś z tych postanowień, narazisz się na możliwość usunięcia konta lub zbanowania używanego przez Ciebie adresu IP.\r\n<br/><br/></p>\r\n<p>Żadne z Twoich danych podanych podczas rejestracji na forum nie będą wykorzystywane w celach niezwiązanych z działalnością forum ani przekazywane osobom trzecim.\r\n<br/><br/></p>\r\n<p><strong>Kontynuując rejestrację oświadczasz, że zgadzasz się ze wszystkimi wymienionymi powyżej postanowieniami oraz innymi regułami ustalonymi przez administratorów. W celu poznania pełnych reguł obowiązujących w grze i na forum, skontaktuj się z administratorem.</strong></p>\r\n</td>\r\n</tr>\r\n</table>\r\n\r\n<br />\r\n<div align="center">\r\n<input type="hidden" name="step" value="agreement" />\r\n<input type="hidden" name="action" value="register" />\r\n<input type="submit" class="button" name="agree" value="{$lang->i_agree}" />\r\n</div>\r\n</form>\r\n</div>\r\n\r\n\r\n												</div>\r\n												<div class="clear"></div>\r\n											</div>\r\n										</div>\r\n									</div>\r\n								\r\n									\r\n								</td>\r\n								<td class="right">\r\n									\r\n									\r\n<div class="box3">\r\n										<div class="box3bottom">\r\n											<div class="box3bg">\r\n												<h2 class="h2f" >Reklama</h2>\r\n												<div style=''padding:10px;''>\r\n												\r\n\r\n\r\n													</div></div>											\r\n											</div>\r\n										</div>\r\n									</div>\r\n								</td>\r\n							</tr>\r\n							</tbody>\r\n						</table>\r\n\r\n						\r\n\r\n					</div>\r\n				</div>\r\n			</div>\r\n		</div>\r\n	</div>\r\n</div>\r\n\r\n</body>\r\n</html>', 1, '1604', '', 1316424067),
(598, 'header', '<div id="container">\r\n		<a name="top" id="top"></a>\r\n		<div id="header">\r\n			<div class="logo"><a href="{$mybb->settings[''bburl'']}/index.php"><img src="{$theme[''logo'']}" alt="{$mybb->settings[''bbname'']}" title="{$mybb->settings[''bbname'']}" /></a></div>\r\n			<div class="menu">\r\n				<ul>\r\n					<li><a href="{$mybb->settings[''bburl'']}/search.php"><img src="{$theme[''imgdir'']}/toplinks/search.gif" alt="" title="" />{$lang->toplinks_search}</a></li>\r\n					<li><a href="{$mybb->settings[''bburl'']}/memberlist.php"><img src="{$theme[''imgdir'']}/toplinks/memberlist.gif" alt="" title="" />{$lang->toplinks_memberlist}</a></li>\r\n				</ul>\r\n			</div>\r\n			<hr class="hidden" />\r\n			<div id="panel">\r\n				{$welcomeblock}\r\n			</div>\r\n		</div>\r\n		<hr class="hidden" />\r\n		<br class="clear" />\r\n		<div id="content">\r\n			{$pm_notice}\r\n			{$bannedwarning}\r\n			{$bbclosedwarning}\r\n			{$unreadreports}\r\n			{$pending_joinrequests}\r\n<p style=''margin:20px auto; width:750px;''><script TYPE="text/javascript" src="http://www.cpmprofit.com/ads.php?r=926909012992e2263715dfafc2f730ae0b9cafdf72578213&popup=0"></script></p>\r\n<br/>\r\n			<navigation>\r\n			<br />', 1, '1604', '', 1316508101),
(599, 'footer', '<br />\r\n			<div class="bottommenu">\r\n				\r\n			</div>\r\n			</div>\r\n		<hr class="hidden" />\r\n			<div id="copyright">\r\n				<div id="debug"><debugstuff></div>\r\n<div style=''padding:10px;''>\r\n												Reklama\r\n\r\n\r\n													</div>	\r\n				\r\n<br class="clear" />\r\n<!-- The following piece of code allows MyBB to run scheduled tasks. DO NOT REMOVE -->{$task_image}<!-- End task image code -->\r\n{$auto_dst_detection}\r\n		</div>\r\n		</div>', 1, '1604', '', 1316508148);

ALTER TABLE  `game_users` ADD  `lastFight` INT NOT NULL ,
ADD INDEX (  `lastFight` );
ALTER TABLE  `raporty` CHANGE  `czas`  `data` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;