PHP Game::query方法代码示例

 function generateForm()
 {
     // Grab data for pulldowns if we need an edit form
     $teams = $this->league->teams_as_array();
     if (!count($teams)) {
         error_exit("There may be no teams in this league");
     }
     $teams[0] = "---";
     $this->template_name = 'pages/schedule/view.tpl';
     // get the game slots for this league and this day
     $gameslots = $this->league->get_gameslots($this->day_id);
     if (count($gameslots) <= 1) {
         error_exit("There are no fields assigned to this league");
     }
     $sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
     while ($game = $sth->fetchObject('Game')) {
         $games[] = $game;
     }
     $this->smarty->assign('league', $this->league);
     $this->smarty->assign('teams', $teams);
     $this->smarty->assign('can_edit', 1);
     $this->smarty->assign('edit_week', $this->day_id);
     $this->smarty->assign('gameslots', $gameslots);
     $this->smarty->assign('rounds', $this->league->rounds_as_array());
     $this->smarty->assign('games', $games);
     return true;
 }

 function render_schedule()
 {
     if ($this->league->schedule_type == 'none') {
         error_exit("This league does not have a schedule or standings.");
     }
     $sth = Game::query(array('league_id' => $this->league->league_id, 'published' => 1, '_order' => 'g.game_date, g.game_start, field_code'));
     $currentTime = time();
     $games = array();
     while ($game = $sth->fetchObject('Game')) {
         $game->event_status = 'pre-event';
         if ($currentTime > $game->timestamp) {
             $game->event_status = 'post-event';
         }
         $games[] = $game;
     }
     $this->smarty->assign('games', $games);
 }

 function process()
 {
     $this->title = "{$this->league->fullname} » Status Report";
     $this->template_name = 'pages/league/status.tpl';
     // make sure the teams are loaded
     $this->league->load_teams();
     // TODO: we calculate_standings() here, but it's probably not necessary
     list($order, $season, $round) = $this->league->calculate_standings(array('round' => $this->league->current_round));
     $fields = array();
     $sth = Field::query(array('_extra' => '1 = 1', '_order' => 'f.code'));
     while ($field = $sth->fetchObject('Field')) {
         $fields[$field->code] = $field->region;
     }
     // Parse the schedule and accumulate per-team stats
     $sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
     while ($g = $sth->fetchObject('Game')) {
         $season[$g->home_team]->game_count++;
         $season[$g->away_team]->game_count++;
         list($code, $num) = explode(' ', $g->field_code);
         $season[$g->home_team]->region_game_counts[$fields[$code]]++;
         $season[$g->away_team]->region_game_counts[$fields[$code]]++;
         $season[$g->home_team]->home_game_count++;
         $season[$g->home_team]->opponent_counts[$g->away_name]++;
         $season[$g->away_team]->opponent_counts[$g->home_name]++;
     }
     $teams = array();
     while (list(, $tid) = each($order)) {
         $team = $season[$tid];
         $ratio = $team->preferred_field_ratio();
         if ($ratio > 1) {
             # If ratio is > 1, lower it to 1 for display purposes
             $ratio = 1;
         }
         $ratio = sprintf("%.3f", $ratio);
         $check_ratio = $ratio;
         if ($team->game_count % 2) {
             $check_ratio = ($ratio * $team->game_count + 1) / ($team->game_count + 1);
         }
         list($team->preferred_ratio, $team->preferred_ratio_bad) = array($ratio, $check_ratio < 0.5);
         list($team->home_game_ratio, $team->home_game_ratio_bad) = _ratio_helper($team->home_game_count, $team->game_count);
         $teams[] = $team;
     }
     $this->smarty->assign('teams', $teams);
     return true;
 }

 function process()
 {
     global $lr_session;
     $this->title = "{$this->league->fullname} » Schedule";
     $this->template_name = 'pages/schedule/view.tpl';
     // TODO: do load_many() and query using 'published'
     $sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
     $games = array();
     while ($game = $sth->fetchObject('Game')) {
         if (!($game->published || $lr_session->has_permission('league', 'edit schedule', $this->league->league_id))) {
             continue;
         }
         $games[] = $game;
     }
     $this->smarty->assign('can_edit', $lr_session->has_permission('league', 'edit schedule', $this->league->league_id));
     $this->smarty->assign('games', $games);
     return true;
 }

 function process()
 {
     $this->title = "Daily Schedule";
     list($year, $month, $day) = preg_split("/[\\/-]/", $_POST['edit']['date']);
     $today = getdate();
     $yyyy = is_numeric($year) ? $year : $today['year'];
     $mm = is_numeric($month) ? $month : $today['mon'];
     $dd = is_numeric($day) ? $day : $today['mday'];
     if (!validate_date_input($yyyy, $mm, $dd)) {
         error_exit('That date is not valid');
     }
     $this->smarty->assign('date', sprintf("%4d/%02d/%02d", $yyyy, $mm, $dd));
     $formattedDay = strftime('%A %B %d %Y', mktime(6, 0, 0, $mm, $dd, $yyyy));
     $this->title .= " » {$formattedDay}";
     $this->template_name = 'pages/schedule/day.tpl';
     $sth = Game::query(array('game_date' => sprintf('%d-%d-%d', $yyyy, $mm, $dd), 'published' => true, '_order' => 'g.game_start, field_code'));
     while ($g = $sth->fetchObject('Game')) {
         if (!($g->published || $lr_session->has_permission('league', 'edit schedule', $this->league->league_id))) {
             continue;
         }
         $games[] = $g;
     }
     $this->smarty->assign('games', $games);
 }

    function generateStatusPage()
    {
        global $dbh;
        // make sure the teams are loaded
        $this->league->load_teams();
        list($order, $season, $round) = $this->league->calculate_standings(array('round' => $this->league->current_round));
        $fields = array();
        $sth = Field::query(array('_order' => 'f.code'));
        while ($field = $sth->fetchObject('Field')) {
            $fields[$field->code] = $field->region;
        }
        $output = para("This is a general field scheduling balance report for the league. The first number in each cell is the number of games that team has played at a given site.  The second number, in brackets, is the team's average ranking for that site.  Zero represents an unranked field.");
        $num_teams = sizeof($order);
        $header[] = array('data' => "Rating", 'rowspan' => 2);
        $header[] = array('data' => "Team", 'rowspan' => 2);
        // now gather all possible fields this league can use
        $sth = $dbh->prepare('SELECT
				DISTINCT IF(f.parent_fid, pf.code, f.code) AS field_code,
				TIME_FORMAT(g.game_start, "%H:%i") as game_start,
				IF(f.parent_fid, pf.region, f.region) AS field_region,
				IF(f.parent_fid, pf.fid, f.fid) AS fid,
				IF(f.parent_fid, pf.name, f.name) AS name
			FROM league_gameslot_availability a
			INNER JOIN gameslot g ON (g.slot_id = a.slot_id)
			LEFT JOIN field f ON (f.fid = g.fid)
			LEFT JOIN field pf ON (pf.fid = f.parent_fid)
			WHERE a.league_id = ?
			ORDER BY field_region DESC, field_code, game_start');
        $sth->execute(array($this->league->league_id));
        $last_region = "";
        $field_region_count = 0;
        while ($row = $sth->fetch(PDO::FETCH_OBJ)) {
            $field_list[] = "{$row->field_code} {$row->game_start}";
            $subheader[] = array('data' => l($row->field_code, "field/view/{$row->fid}", array('title' => $row->name)) . " {$row->game_start}", 'class' => "subtitle");
            if ($last_region == $row->field_region) {
                $field_region_count++;
            } else {
                if ($field_region_count > 0) {
                    $header[] = array('data' => $last_region, 'colspan' => $field_region_count);
                }
                $last_region = $row->field_region;
                $field_region_count = 1;
            }
        }
        // and make the last region header too
        if ($field_region_count > 0) {
            $header[] = array('data' => $last_region, 'colspan' => $field_region_count);
        }
        $header[] = array('data' => "Games", 'rowspan' => 2);
        $rows = array();
        $rows[] = $subheader;
        $rowstyle = "standings_light";
        // get the schedule
        $schedule = array();
        $sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
        while ($g = $sth->fetchObject('Game')) {
            $schedule[] = $g;
        }
        // we'll cache these results, so we can compute avgs and highlight numbers too far from average
        $cache_rows = array();
        $total_at_field = array();
        $sum_field_rankings = array();
        while (list(, $tid) = each($order)) {
            if ($rowstyle == "standings_light") {
                $rowstyle = "standings_dark";
            } else {
                $rowstyle = "standings_light";
            }
            $row = array(array('data' => $season[$tid]->rating, 'class' => "{$rowstyle}"));
            $row[] = array('data' => l($season[$tid]->name, "team/view/{$tid}"), 'class' => "{$rowstyle}");
            // count number of games per field for this team:
            $numgames = 0;
            $count = array();
            $site_ranks = array();
            // parse the schedule
            reset($schedule);
            while (list(, $game) = each($schedule)) {
                if ($game->home_team == $tid || $game->away_team == $tid) {
                    $numgames++;
                    list($code, $num) = explode(' ', $game->field_code);
                    $count["{$code} {$game->game_start}"]++;
                    $rank = $game->get_site_ranking($tid);
                    if ($rank != 'unranked') {
                        $site_ranks["{$code} {$game->game_start}"] += $rank;
                    }
                }
            }
            foreach ($field_list as $f) {
                $thisrow = array('data' => "0", 'class' => "{$rowstyle}", 'align' => 'center');
                if ($count[$f]) {
                    $thisrow['data'] = $count[$f] . sprintf(' (%.3f)', $site_ranks[$f] / $count[$f]);
                    $total_at_field[$f] += $count[$f];
                    $sum_field_ranks[$f] += $site_ranks[$f];
                }
                $row[] = $thisrow;
            }
            $row[] = array('data' => $numgames, 'class' => "{$rowstyle}", 'align' => "center");
            $cache_rows[] = $row;
        }
        // pass through cached rows and highlight entries far from avg
//.........这里部分代码省略.........

 static function getRelatedGames($id)
 {
     $games = array();
     $result = Game::query('SELECT games.*, COUNT(*) FROM tbl_games as games
     INNER JOIN tbl_tag_relations as game_tags ON game_tags.game_id = games.game_id
     WHERE game_tags.tag_id IN (SELECT tag_id FROM tbl_tag_relations as game_tags WHERE game_id = ' . $id . ')
     AND game_tags.game_id != ' . $id . '
     GROUP BY games.game_id
     Order by count(*) desc
     ');
     $max = $result->num_rows;
     $trak = 0;
     while ($row = $result->fetch_assoc()) {
         $data['id'] = $row['game_id'];
         $data['file'] = Utils::TitleToFile($row['title']);
         $data['image'] = Utils::FileToGameImageURL(Utils::TitleToFile($row['title']), "png");
         $data['title'] = $row['title'];
         $data['plays'] = Utils::nice_number($row['plays']);
         $data['description'] = $row['desc'];
         array_push($games, $data);
     }
     return $games;
 }