1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

 
$msql="SELECT uid,name,seedbonus,forradalom,ujev,szabadsagharc,oldalevfordulo,trianon,szabadsagharc,csendornap FROM xbt_users WHERE uid=$uid";
$asd = @mysql_query($msql) or die(mysql_error());
 
$res = @mysql_query("SELECT * FROM xbt_users WHERE uid='$uid';");
$jobbikos = mysql_query("select $unnep from xbt_users where uid = $uid")
 
if ($unnep == 'semmi') { } else {
print("<div class='ajandekbox'><img src='pic/ajandekozo/$unnep/nagy.png' width='300' height='300' /></div>");
 
if ($unnep == $unnep['yes']) {
 
print("<br><br><br><div class='ajandek_mezo3'><p><font color='yellow'>Már megkaptad az ajándékod. :)</font></p></div>");
}
else {
 
print("<div class='ajandekok'><div class='ajandek'><a href='ajandekozok.php?ajandek=1'><img src='pic/ajandekozo/$unnep/kep1.png' width='82' height='102' /></a></div>");
print("<div class='ajandek'><a href='ajandekozok.php?ajandek=2'><img src='pic/ajandekozo/$unnep/kep2.png' width='82' height='102' /></a></div>");
print("<div class='ajandek'><a href='ajandekozok.php?ajandek=3'><img src='pic/ajandekozo/$unnep/kep3.png' width='82' height='102' /></a></div><div><div>");
 
?><br><br><br><br><br><br><br><br>
 
<div class='ajandek_mezo3'>A Három kép közül választhatsz egy ajándékot.</div>
</center>
 
<?
} 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

 
CREATE TABLE IF NOT EXISTS `xbt_users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `account_state` enum('unconfirmed','enabled','disabled','deleted') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'enabled',
  `name` varchar(15) CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
  `pass` blob NOT NULL,
  `peers_limit` int(11) NOT NULL DEFAULT '0',
  `seedbonus` decimal(10,0) NOT NULL DEFAULT '1000',
  `ujev` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `forradalom` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `husvet` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `oldalevfordulo` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `trianon` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `csendornap` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  `szabadsagharc` enum('yes','no') COLLATE latin2_hungarian_ci NOT NULL DEFAULT 'no',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `name` (`name`),
  KEY `xbt_users_account_state` (`account_state`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci AUTO_INCREMENT=93213 ;