chess_admin_active_games()

Complexity

Conditions	6
Paths	2

Size

Total Lines	65
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function chess_admin_active_games()
{
    global $start, $max_items_to_display, $op, $xoopsDB, $xoopsModule;

    $memberHandler = xoops_getHandler('member');

    // Two queries are performed, one without a limit clause to count the total number of rows for the page navigator,

    // and one with a limit clause to get the data for display on the current page.

    // SQL_CALC_FOUND_ROWS and FOUND_ROWS(), available in MySQL 4.0.0, provide a more efficient way of doing this.

    $games_table = $xoopsDB->prefix('chess_games');

    $result = $xoopsDB->query("SELECT COUNT(*) FROM $games_table WHERE pgn_result = '*' and suspended = ''");

    [$num_rows] = $xoopsDB->fetchRow($result);

    $xoopsDB->freeRecordSet($result);

    $result = $xoopsDB->query(
        trim(
            "
        SELECT   game_id, white_uid, black_uid, UNIX_TIMESTAMP(start_date) AS start_date, GREATEST(create_date,start_date,last_date) AS most_recent_date
        FROM     $games_table
        WHERE    pgn_result = '*' and suspended = ''
        ORDER BY most_recent_date DESC
        LIMIT    $start, $max_items_to_display
    "
        )
    );

    if ($xoopsDB->getRowsNum($result) > 0) {
        echo '<h3>' . _AM_CHESS_ACTIVE_GAMES . "</h3>\n";

        while (false !== ($row = $xoopsDB->fetchArray($result))) {
            $user_white = $memberHandler->getUser($row['white_uid']);

            $username_white = is_object($user_white) ? $user_white->getVar('uname') : '(open)';

            $user_black = $memberHandler->getUser($row['black_uid']);

            $username_black = is_object($user_black) ? $user_black->getVar('uname') : '(open)';

            $date = $row['start_date'] ? date('Y.m.d', $row['start_date']) : 'not yet started';

            $title_text = _AM_CHESS_GAME . " #{$row['game_id']}&nbsp;&nbsp;&nbsp;$username_white " . _AM_CHESS_VS . " $username_black&nbsp;&nbsp;&nbsp;($date)";

            $form = new XoopsThemeForm($title_text, "game_{$row['game_id']}", XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . "/game.php?game_id={$row['game_id']}", 'post', true);

            $form->addElement(new XoopsFormButton('', 'submit', _AM_CHESS_ARBITRATE_SUBMIT, 'submit'));

            $form->addElement(new XoopsFormHidden('show_arbiter_ctrl', 1));

            $form->display();
        }

        $pagenav = new XoopsPageNav($num_rows, $max_items_to_display, $start, 'start', "op=$op");

        echo '<div align="center">' . $pagenav->renderNav() . "&nbsp;</div>\n";
    } else {
        echo '<h3>' . _AM_CHESS_NO_ACTIVE_GAMES . "</h3>\n";
    }

    $xoopsDB->freeRecordSet($result);
}