PHP rankingTribe_getRowsByOffset Examples

Example #1

File: ranking.html.php Project: microlefes/Game

function rankingTribe_getContent()
{
    global $template;
    // open template
    $template->setFile('rankingTribe.tmpl');
    $template->setShowResource(false);
    $numRows = rankingTribe_getMaxRows();
    $offset = 0;
    $row = array();
    if ($numRows > 0) {
        $search = Request::getVar('search', '');
        $page = Request::getVar('page', 0);
        if ($search !== '') {
            $offset = rankingTribe_checkOffsetBySearch($search, $numRows);
            if ($offset < 0) {
                $offset = 0;
                $template->addVar('status_msg', array('type' => 'error', 'message' => 'Der gesuchte Stamm wurde nicht gefunden'));
            }
        } else {
            $offset = rankingTribe_checkOffsetByPage($_SESSION['player']->tribeID, $page, $numRows);
        }
        $row = rankingTribe_getRowsByOffset($offset);
    }
    $template->addVars(array('page' => ceil($offset / RANKING_ROWS) + 1, 'max_pages' => ceil($numRows / RANKING_ROWS), 'rows_per_page' => RANKING_ROWS, 'row' => $row));
}

Example #2

File: ranking.html.php Project: norter/Game

function rankingTribe_getContent($caveID, $offset)
{
    global $template;
    // open template
    $template->setFile('rankingTribe.tmpl');
    $template->setShowRresource(false);
    $row = rankingTribe_getRowsByOffset($caveID, $offset);
    $template->addVars(array('offset_up' => $offset - RANKING_ROWS > 0 ? $offset - RANKING_ROWS : 0, 'offset_down' => $offset + RANKING_ROWS, 'row' => $row));
}

Example #3

File: ranking.html.php Project: agatho/uaenhanced

function rankingTribe_getContent($caveID, $offset)
{
    global $no_resource_flag, $config, $params;
    $no_resource_flag = 1;
    // ADDED by chris--- for ranking sorting
    $order = $params->POST->order;
    if ($order != "rank" && $order != "tribe" && $order != "points" && $order != "fame" && $order != "points_rank" && $order != "members" && $order != "playerAverage" && $order != "caves") {
        $order = "rank";
    }
    $direct = $params->POST->direct;
    if ($direct != "ASC" && $direct != "DESC") {
        $direct = "ASC";
    }
    $row = rankingTribe_getRowsByOffset($caveID, $offset, $order, $direct);
    // ADDED by chris--- for ranking sorting
    //  $up   = array('link' => "?modus=" . RANKING_TRIBE . "&offset=" . ($offset - RANKING_ROWS));
    //  $down = array('link' => "?modus=" . RANKING_TRIBE . "&offset=" . ($offset + RANKING_ROWS));
    $up_link = "?modus=" . RANKING_TRIBE . "&offset=" . ($offset - RANKING_ROWS);
    $down_link = "?modus=" . RANKING_TRIBE . "&offset=" . ($offset + RANKING_ROWS);
    if ($order) {
        $up_link .= "&order=" . $order;
        $down_link .= "&order=" . $order;
    }
    if ($direct) {
        $up_link .= "&direct=" . $direct;
        $down_link .= "&direct=" . $direct;
    }
    $up = array('link' => $up_link);
    $down = array('link' => $down_link);
    // Header links
    $link_rank = "?modus=" . RANKING_TRIBE . "&order=rank";
    $link_points_rank = "?modus=" . RANKING_TRIBE . "&order=points_rank";
    $link_caves = "?modus=" . RANKING_TRIBE . "&order=caves";
    $link_points = "?modus=" . RANKING_TRIBE . "&order=points";
    $link_tribe = "?modus=" . RANKING_TRIBE . "&order=tribe";
    $link_fame = "?modus=" . RANKING_TRIBE . "&order=fame";
    $link_members = "?modus=" . RANKING_TRIBE . "&order=members";
    $link_playerAverage = "?modus=" . RANKING_TRIBE . "&order=playerAverage";
    if ($direct) {
        $link_rank .= "&direct=" . $direct;
        $link_points_rank .= "&direct=" . $direct;
        $link_caves .= "&direct=" . $direct;
        $link_points .= "&direct=" . $direct;
        $link_tribe .= "&direct=" . $direct;
        $link_fame .= "&direct=" . $direct;
        $link_members .= "&direct=" . $direct;
        $link_playerAverage .= "&direct=" . $direct;
    }
    if ($order == "rank" && $direct == "ASC") {
        $link_rank = "?modus=" . RANKING_TRIBE . "&order=rank&direct=DESC";
    }
    if ($order == "rank" && $direct == "DESC") {
        $link_rank = "?modus=" . RANKING_TRIBE . "&order=rank&direct=ASC";
    }
    if ($order == "points_rank" && $direct == "ASC") {
        $link_points_rank = "?modus=" . RANKING_TRIBE . "&order=points_rank&direct=DESC";
    }
    if ($order == "points_rank" && $direct == "DESC") {
        $link_points_rank = "?modus=" . RANKING_TRIBE . "&order=points_rank&direct=ASC";
    }
    if ($order == "caves" && $direct == "ASC") {
        $link_caves = "?modus=" . RANKING_TRIBE . "&order=caves&direct=DESC";
    }
    if ($order == "caves" && $direct == "DESC") {
        $link_caves = "?modus=" . RANKING_TRIBE . "&order=caves&direct=ASC";
    }
    if ($order == "points" && $direct == "ASC") {
        $link_points = "?modus=" . RANKING_TRIBE . "&order=points&direct=DESC";
    }
    if ($order == "points" && $direct == "DESC") {
        $link_points = "?modus=" . RANKING_TRIBE . "&order=points&direct=ASC";
    }
    if ($order == "tribe" && $direct == "ASC") {
        $link_tribe = "?modus=" . RANKING_TRIBE . "&order=tribe&direct=DESC";
    }
    if ($order == "tribe" && $direct == "DESC") {
        $link_tribe = "?modus=" . RANKING_TRIBE . "&order=tribe&direct=ASC";
    }
    if ($order == "members" && $direct == "ASC") {
        $link_members = "?modus=" . RANKING_TRIBE . "&order=members&direct=DESC";
    }
    if ($order == "members" && $direct == "DESC") {
        $link_members = "?modus=" . RANKING_TRIBE . "&order=members&direct=ASC";
    }
    if ($order == "fame" && $direct == "ASC") {
        $link_fame = "?modus=" . RANKING_TRIBE . "&order=fame&direct=DESC";
    }
    if ($order == "fame" && $direct == "DESC") {
        $link_fame = "?modus=" . RANKING_TRIBE . "&order=fame&direct=ASC";
    }
    if ($order == "playerAverage" && $direct == "ASC") {
        $link_playerAverage = "?modus=" . RANKING_TRIBE . "&order=playerAverage&direct=DESC";
    }
    if ($order == "playerAverage" && $direct == "DESC") {
        $link_playerAverage = "?modus=" . RANKING_TRIBE . "&order=playerAverage&direct=ASC";
    }
    // ------------------------------------------------------
    $hidden = array(array('name' => "modus", 'value' => RANKING_TRIBE));
    $template = tmpl_open($params->SESSION->player->getTemplatePath() . 'rankingTribe.ihtml');
    for ($i = 0; $i < sizeof($row); ++$i) {
        tmpl_iterate($template, 'ROWS');
        if ($i % 2) {
            tmpl_set($template, 'ROWS/ROW_ALTERNATE', $row[$i]);
        } else {
            tmpl_set($template, 'ROWS/ROW', $row[$i]);
        }
    }
    tmpl_set($template, array('modus' => RANKING, 'UP' => $up, 'DOWN' => $down, 'update' => getUpdateTime(), 'HIDDEN' => $hidden, 'link_rank' => $link_rank, 'link_caves' => $link_caves, 'link_points' => $link_points, 'link_tribe' => $link_tribe, 'link_fame' => $link_fame, 'link_points_rank' => $link_points_rank, 'link_members' => $link_members, 'link_playerAverage' => $link_playerAverage));
    return tmpl_parse($template);
}