phpBB.de

Code: Alles auswählen

[phpBB Debug] PHP Notice: in file /football/block/all_bets.php  on line 256: Invalid argument supplied for foreach()
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4278: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3499)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4280: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3499)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4281: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3499)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4282: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3499)

Code: Alles auswählen

REPLACE INTO `phpbb_footb_matches` (`season`, `league`, `match_no`, `team_id_home`, `team_id_guest`, `goals_home`, `goals_guest`, `matchday`, `status`, `match_datetime`, `group_id`, `formula_home`, `formula_guest`, `ko_match`, `goals_overtime_home`, `goals_overtime_guest`) VALUES
(2010, 6, 49, 930, 929, '', '', 4, 0, '2010-06-26 16:00:00', '', 'G A1', 'G B2', 1, '', ''),
(2010, 6, 50, 931, 910, '', '', 4, 0, '2010-06-26 20:30:00', '', 'G C1', 'G D2', 1, '', ''),
(2010, 6, 51, 906, 908, '', '', 4, 0, '2010-06-27 16:00:00', '', 'G D1', 'G C2', 1, '', ''),
(2010, 6, 52, 901, 916, '', '', 4, 0, '2010-06-27 20:30:00', '', 'G B1', 'G A2', 1, '', ''),
(2010, 6, 53, 918, 925, '', '', 4, 0, '2010-06-28 16:00:00', '', 'G E1', 'G F2', 1, '', ''),
(2010, 6, 54, 903, 904, '', '', 4, 0, '2010-06-28 20:30:00', '', 'G G1', 'G H2', 1, '', ''),
(2010, 6, 55, 921, 914, '', '', 4, 0, '2010-06-29 16:00:00', '', 'G F1', 'G E2', 1, '', ''),
(2010, 6, 56, 927, 922, '', '', 4, 0, '2010-06-29 20:30:00', '', 'G H1', 'G G2', 1, '', '');

Code: Alles auswählen

Select * from phpbb_footb_bets where user_id = 1; 

Code: Alles auswählen

"Delete from phpbb_footb_bets where user_id = 1; 

Code: Alles auswählen

Select * from phpbb_footb_bets where season = 2010 and league = 6 and  match_no >= 49 and match_no <= 56 ;

Code: Alles auswählen

Select * from phpbb_footb_matches where  season = 2010 and league = 6 and matchday = 5

Code: Alles auswählen

$tmp = array();	
$tmp2 = array();		
$sql = "SELECT * FROM phpbb_footb_bets WHERE match_no > 48";
$res = mysql_query($sql);
while($row = mysql_fetch_object($res)){
	if(!in_array($row->user_id, $tmp)){
		array_push($tmp, $row->user_id);
	}
}

$sql = "SELECT * FROM phpbb_footb_bets WHERE NOT user_id IN (".implode(',', $tmp).")";
$res = mysql_query($sql);
while($row = mysql_fetch_object($res)){
	if(!in_array($row->user_id, $tmp2)){
		array_push($tmp2, $row->user_id);
	}
}

foreach($tmp2 as $uid){
	for ($i = 49; $i <= 64; $i++) {
		mysql_query("INSERT INTO phpbb_footb_bets (season, league, match_no, user_id) VALUES ('2010','6','".$i."','".$uid."')");
	}
}

Code: Alles auswählen

				foreach ($user_id_ary as $user_id)
				{
					// Test user is member 
					$sql = 'SELECT 
							COUNT(user_id) AS total_bets
						FROM ' . FOOTB_BETS . "
						WHERE season = $season 
							AND league = $league 
							AND user_id = $user_id";
					$result = $db->sql_query($sql);
					$total_bets = (int) $db->sql_fetchfield('total_bets');
					$db->sql_freeresult($result);
					
					if ($total_bets > 0) 
					{
						$error[] =  $user->lang['MEMBER_EXISTS'];
					}
					else
					{
						$count_updates = join_league($season, $league, $user_id);
					}
				}

Code: Alles auswählen

				foreach ($user_id_ary as $user_id)
				{
					// Test user is member 
					$sql = 'SELECT 
							COUNT(user_id) AS total_bets
						FROM ' . FOOTB_BETS . "
						WHERE season = $season 
							AND league = $league 
							AND user_id = $user_id
							AND match_no > 48";
					$result = $db->sql_query($sql);
					$total_bets = (int) $db->sql_fetchfield('total_bets');
					$db->sql_freeresult($result);
					
					if ($total_bets > 0) 
					{
						$error[] =  $user->lang['MEMBER_EXISTS'];
					}
					else
					{
						$match_id = 49;
						for($m_day = 4; $m_day <= 5; $m_day++)
						{
								$sql = 'SELECT matches from ' . FOOTB_MATCHDAYS . " WHERE season = $season AND league = $league AND matchday = $m_day";
								$result = $db->sql_query($sql);
								if( $row = $db->sql_fetchrow($result))
								{
									$matches = $row['matches'];
									$db->sql_freeresult($result);
								}
								else
								{
									// Matchday doesnt exist
									$matches = 0;
								}
							for($i = 1; $i<= $matches; $i++)
							{
								$sqlup = 'REPLACE INTO ' . FOOTB_BETS . " VALUES($season, $league, $match_id, $user_id, '', '')";
								$resultup = $db->sql_query($sqlup);
								$match_id++;
							}
						}
					}
				}