PHP CloseTable函数代码示例

function _vereinteammatchlist($vid, $show = 'home')
{
    global $dbi;
    // step 1 collect the teams for this verein
    // step 2 for each team we collect the schedule and create click-rows to the matchsheet
    echo '<h3>Alle Vereins Teams und ihre Heim Spiele</h3>';
    $RS = DB_listTeams($dbi, 0, 0, "", 1, "", $vid);
    foreach ($RS as $row) {
        if ($show == 'home') {
            $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 1);
        } elseif ($show = 'away') {
            $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 0);
        } elseif ($show = 'all') {
            // this doesn't work ...
            $MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", "", "", "logic");
        }
        $aTH = array("Runde", "Datum", "Spielort", "Status", "", "Sets", "Legs", "Team", "Teamname");
        echo "<div class=\"sectionhead\">Team {$row['5']} in {$row['2']} (" . sizeof($MATCHLIST) . " Matches)</div><br/>";
        echo '<div class="child">';
        OpenTable();
        echo ArrayToTableHead($aTH);
        echo RecordsetToClickTable($MATCHLIST, 4, "ls_system.php?func=showmatch&vmkey=%P1%&eventid=%P2%", 3, 0);
        CloseTable();
        echo '</div><br/>';
    }
}

function fc_wrap($id)
{
    global $xoopsDB, $xoopsConfig, $xoopsTheme, $xoopsOption;
    OpenTable();
    //query Database (returns an array)
    $fc_item = fc_query_db_on_id($id);
    //$id exists?
    if (isset($fc_item['adress']) && $fc_item['adress'] != "") {
        // include content
        $fc_include = XOOPS_ROOT_PATH . "/modules/cjaycontent/content/" . $fc_item['adress'];
        if (file_exists($fc_include)) {
            include $fc_include;
            // increment hitcounter (hits)
            $res = $xoopsDB->queryF("UPDATE " . $xoopsDB->prefix() . "_cjaycontent SET hits=hits+1 WHERE id=\"" . $id . "\"");
        } else {
            echo _CC_FILENOTFOUND . $fc_include;
        }
    } else {
        $fc_include = XOOPS_ROOT_PATH . "/modules/cjaycontent/content/DO_NOT_DELETE.php";
        if (file_exists($fc_include)) {
            include $fc_include;
            // increment hitcounter (hits)
            $res = $xoopsDB->queryF("UPDATE " . $xoopsDB->prefix() . "_cjaycontent SET hits=hits+1 WHERE id=\"" . $id . "\"");
        } else {
            echo _CC_FILENOTFOUND . $fc_include;
        }
    }
    CloseTable();
    return 1;
}

function viewdownloadeditorial()
{
    global $downloadsprefix, $db;
    $lid = intval($_GET['lid']);
    include "header.php";
    downl_menu_tpl(1);
    $result = $db->sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $downloadsprefix . "_editorials WHERE downloadid = {$lid}");
    $recordexist = $db->sql_numrows($result);
    $displaytitle = ereg_replace("_", " ", $ttitle);
    echo '<br />';
    OpenTable();
    echo "<center><font class=\"option\"><b>" . _DOWNLOADPROFILE . ": {$displaytitle}</b></font><br />";
    downl_infomenu_tpl($lid, $ttitle);
    if ($recordexist != 0) {
        while (list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle) = $db->sql_fetchrow($result)) {
            ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
            $editorialtime = strftime("%F", mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
            $date_array = explode("-", $editorialtime);
            $timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
            $formatted_date = date("F j, Y", $timestamp);
            echo "<br /><br />";
            OpenTable2();
            echo "<center><font class=\"option\"><b>'{$editorialtitle}'</b></font></center>" . "<center><font class=\"tiny\">" . _EDITORIALBY . " {$adminid} - {$formatted_date}</font></center><br /><br />" . "{$editorialtext}";
            CloseTable2();
        }
    } else {
        echo "<br /><br /><center><font class=\"option\"><b>" . _NOEDITORIAL . "</b></font></center>";
    }
    echo "<br /><br /><center>";
    downloadfooter($lid);
    echo "</center>";
    CloseTable();
    include "footer.php";
}

 function hreferer()
 {
     global $bgcolor2, $prefix, $db, $admin_file;
     include "header.php";
     GraphicAdmin();
     OpenTable();
     echo "<center><font class=\"title\"><b>" . _HTTPREFERERS . "</b></font></center>";
     CloseTable();
     echo "<br>";
     OpenTable();
     echo "<center><b>" . _WHOLINKS . "</b></center><br><br>" . "<table border=\"0\" width=\"100%\">";
     $row = $db->sql_fetchrow($db->sql_query("SELECT httprefmode from " . $prefix . "_config"));
     $httprefmode = intval($row['httprefmode']);
     $result = $db->sql_query("SELECT rid, url from " . $prefix . "_referer");
     while ($row = $db->sql_fetchrow($result)) {
         $rid = intval($row['rid']);
         $url = filter($row['url'], "nohtml");
         $url2 = urlencode($url);
         $title = $url;
         if ($httprefmode == 1) {
             $url = explode("/", $url);
             $url = "http://{$url['2']}";
         }
         echo "<tr><td bgcolor=\"{$bgcolor2}\"><font class=\"content\">{$rid}</td>" . "<td bgcolor=\"{$bgcolor2}\"><font class=\"content\"><a href=\"index.php?url={$url2}\" target=\"_new\" title=\"{$title}\">{$url}</a></td></tr>";
     }
     echo "</table>" . "<form action=\"" . $admin_file . ".php\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"delreferer\">" . "<center><input type=\"submit\" value=\"" . _DELETEREFERERS . "\"></center>";
     CloseTable();
     include "footer.php";
 }

function show($mode, $tablelist, $query)
{
    global $db, $bgcolor2, $bgcolor3, $type, $dbname;
    require_once 'header.php';
    GraphicAdmin('_AMENU0');
    OpenTable();
    if ($query === null) {
        echo 'Mode: <b>' . $mode . '</b> not available yet';
        return;
    }
    if (count($tablelist)) {
        $result = $db->sql_query($query);
        $numfields = $db->sql_numfields($result);
        echo '<span class="genmed"><strong>' . _DATABASE . ':</strong> ' . $dbname . '</span><br /><br />Here are the results of your ' . strtolower($type) . '<br /><br />
		<table border="0" cellpadding="2"><tr bgcolor="' . $bgcolor2 . '">';
        for ($j = 0; $j < $numfields; $j++) {
            echo '<td><strong>' . $db->sql_fieldname($j, $result) . '</strong></td>';
        }
        echo '</tr>';
        $bgcolor = $bgcolor3;
        while ($row = $db->sql_fetchrow($result)) {
            $bgcolor = $bgcolor == '' ? ' bgcolor="' . $bgcolor3 . '"' : '';
            echo '<tr' . $bgcolor . '>';
            for ($j = 0; $j < $numfields; $j++) {
                echo '<td>' . $row[$j] . '</td>';
            }
            echo '</tr>';
        }
        echo '</table>';
    }
    CloseTable();
}

function showfooter()
{
    echo '</td><td valign="top" align="right" width="150">
	<a href="' . URL::admin('&amp;mode=edit') . '">' . _EDITUSER . '</a><br />
	<a href="' . URL::admin('&amp;mode=add') . '">' . _ADDUSER . '</a>
	</td></tr></table>';
    CloseTable();
}

function Choice()
{
    global $xoopsModule;
    xoops_cp_header();
    OpenTable();
    echo "<a href='" . XOOPS_URL . "/modules/system/admin.php?fct=preferences&op=showmod&mod=" . $xoopsModule->getVar('mid') . "'>" . _IMP_Edit . "</a><br />";
    CloseTable();
    xoops_cp_footer();
}

function SiteSent($fname)
{
    include 'header.php';
    $fname = stripslashes(FixQuotes(check_html(removecrlf($fname))));
    OpenTable();
    echo "<center><font class=\"content\">" . _FREFERENCE . " {$fname}...<br><br>" . _THANKSREC . "</font></center>";
    CloseTable();
    include 'footer.php';
}

function StorySent($title, $fname)
{
    include "header.php";
    $title = htmlspecialchars(urldecode(check_html($title, "nohtml")));
    $fname = htmlspecialchars(urldecode($fname));
    OpenTable();
    echo "<center><font class=\"content\">" . _FSTORY . " <b>{$title}</b> " . _HASSENT . " {$fname}... " . _THANKS . "</font></center>";
    CloseTable();
    include "footer.php";
}

function error_halt($msg)
{
    global $xoopsLogger;
    xoops_cp_header();
    include './mymenu.php';
    echo $xoopsLogger->dumpQueries();
    OpenTable();
    echo $msg;
    CloseTable();
    xoops_cp_footer();
}

/**
 * Bayonet Content Management System
 * Copyright (C) 2008  Joseph Hunkeler
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
function ListModules()
{
    global $db;
    $result = $db->Query("SELECT dir_name, weight, status FROM bayonet_modules ORDER BY status DESC, weight ASC");
    $modules = $db->Fetch($result);
    OpenTable("50%");
    echo "<tr><th>Directory Name</th><th>Weight</th><th>Status</th></tr>";
    foreach ($modules as $module) {
        echo "<tr><td>" . $module['dir_name'] . "</td><td>" . $module['weight'] . "</td><td>" . $module['status'] . "</td></tr>";
    }
    CloseTable();
}

function dropcomment($username, $onwhat, $mtime, $ndate)
{
    global $module_name;
    echo "<br>";
    OpenTable();
    echo "<div align=center class=title>" . _LEAVECOMMENT . "</div><br><br>";
    echo "<form action='modules.php?name={$module_name}&file=commentsave' method='post'><input type='hidden' name='rid' value='{$onwhat}'>";
    echo "<div align=center>" . _COMMENTBOX . ":<br><textarea name=\"comment\" wrap=virtual cols=55 rows=10></textarea><br><br><input type='submit' name='submit' value='" . _POSTCOMMENT . "'></div>";
    echo "</form><br>";
    echo "<center>" . _COMMENTSNOTE . "</center>";
    CloseTable();
}

function ShowBlocks()
{
    echo "<td width=3></td>";
    echo "<td width=260>";
    OpenBlTable("Литература");
    include "blocks/bl-books.php";
    CloseTable();
    OpenBlTable("Статьи");
    include "blocks/articles.php";
    CloseTable();
    echo "</center>";
    echo "</td>";
}

function f2go()
{
    include "header.php";
    OpenTable();
    echo "Addon Sample File (f2.php) CALLED FROM Sand_Journey Theme<br>";
    echo "<ul>";
    echo "<li><a href=\"modules.php?name=Addon_Sample&amp;file=f2&amp;func=f2one\">Function f2one</a>";
    echo "<li><a href=\"modules.php?name=Addon_Sample&amp;file=index&amp;func=dos\">Go to index.php</a>";
    echo "</ul>";
    echo "As you can see now, this page doesn't show the Right Blocks, this is because at the begining " . "of this file we set \$index variable to \"0\"";
    CloseTable();
    include "footer.php";
}

function AddonSample()
{
    include "header.php";
    OpenTable();
    echo "Addon Sample File (index.php) CALLED FROM Sand_Journey Theme<br><br>";
    echo "<ul>";
    echo "<li><a href=\"modules.php?name=Addon_Sample&amp;file=index&amp;func=one\">Function One</a>";
    echo "<li><a href=\"modules.php?name=Addon_Sample&amp;file=index&amp;func=two\">Function Two</a>";
    echo "<li><a href=\"modules.php?name=Addon_Sample&amp;file=f2\">Call to file f2.php</a>";
    echo "</ul>";
    echo "You can now use Administration interface to activate or deactivate any module. As an Admin you can always " . "access to your Inactive modules for testing purpouses.";
    CloseTable();
    include "footer.php";
}