0) { for ($i = 0; $tmp = sql_fetch_array($result1); $i++) { $data1[$tmp['session_id'].'-'.$tmp['team_id'].'-'.$tmp['num']]['valid_session_id'] = $tmp['session_id']; $data1[$tmp['session_id'].'-'.$tmp['team_id'].'-'.$tmp['num']]['qr_id'] = $tmp['num']; } } @mysqli_free_result($result1); $result2 = sql_query($_dbc, "SELECT * FROM soongsil_memo WHERE delete_date IS NULL"); $cnt2 = sql_num_rows($result2); if ($cnt2 > 0) { for ($i = 0; $tmp = sql_fetch_array($result2); $i++) { $data2[$tmp['qr_value']]['session_id'] = $tmp['session_id']; $data2[$tmp['qr_value']]['team_id'] = $tmp['team_id']; $data2[$tmp['qr_value']]['qr_id'] = $tmp['qr_num']; $data2[$tmp['qr_value']]['value1'] = $tmp['value1']; $data2[$tmp['qr_value']]['value2'] = $tmp['value2']; $data2[$tmp['qr_value']]['value3'] = $tmp['value3']; } } @mysqli_free_result($result2); $result3 = sql_query($_dbc, "SELECT * FROM soongsil_team WHERE delete_date IS NULL"); $cnt3 = sql_num_rows($result3); if($cnt3 > 0) { for($i = 0; $tmp = sql_fetch_array($result3); $i++) { $data3[$tmp['id']]['team_id'] = $tmp['id']; $data3[$tmp['id']]['team_name'] = $tmp['team_name']; } @mysqli_free_result($result3); } require_once('_header.html'); $agent = $_SERVER['HTTP_USER_AGENT']; if(strpos($agent,'Android')!==false) { $type = 'android'; } else if(strpos($agent,'iPhone') !== false) { $type = 'ios'; } else if(strpos($agent,'iPad') !== false) { $type = 'ios'; } else if(strpos($agent,'Macintosh') !== false) { $type = 'ios'; } ?>