index.php

一个好用的php wap cms portal

            OpenTable();
            // Get Forum Title
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $result = $db->sql_query("select forum_id, cat_id, forum_name, forum_desc, forum_status from $prefix"._bbforums." WHERE forum_id = '$f' AND auth_view <= '$userlevel'");
                $row = $db->sql_fetchrow($result);
                $forumtitle = strtr(htmlentities($row["forum_name"]), $array_correction);
                $id = $row["forum_id"];
                $breadcrumbs = "<a href=\"w2g_modules.php?name=Forums\" title=\""._FORUM." "._FINDEX."\">"._FORUM." "._FINDEX."</a> &gt; <a href=\"w2g_modules.php?name=Forums&amp;f=".$id."\" title=\""._FSELECTF." ".$forumtitle."\">".$forumtitle."</a>";
            // Set Member Functions
                $memberfunctions = "";
                $forumtitle      = char_dec($forumtitle);
                $memberfunctions = char_dec($memberfunctions);
                $breadcrumbs     = char_dec($breadcrumbs);
                doForumHead($forumtitle,$memberfunctions,$breadcrumbs);
            // Display Topics in Forum
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $totalresults = $db->sql_numrows($db->sql_query("select topic_id, forum_id, topic_title, topic_poster from $prefix"._bbtopics." WHERE forum_id = '$f'"));
                $result = $db->sql_query("select topic_id, forum_id, topic_title, topic_poster, topic_type from $prefix"._bbtopics." WHERE forum_id = '$f' ORDER BY topic_type DESC, topic_last_post_id DESC LIMIT $start,$increment");
                $row = $db->sql_fetchrow($result);
                do {
                    $topic_title = strtr(htmlentities($row["topic_title"]), $array_correction);
                    $id = $row["topic_id"];
                    $uid = $row["topic_poster"];
                    $topic_title = "<a href=\"w2g_modules.php?name=Forums&amp;t=".$id."\" title=\""._FTOPICS." ".$topic_title."\">".$topic_title."</a>";
                    if ($row["topic_type"]==1) { $topic_title = _B."&raquo;"._B_END." - ".$topic_title; }
                    else if ($row["topic_type"]==2) { $topic_title = _B."&iexcl;"._B_END." - ".$topic_title; }
                    else { $topic_title = " - ".$topic_title; }
                        // Fetch Username
                        $result2 = $db->sql_query("select username from $prefix"._users." WHERE user_id = '$uid'");
                        $data2 = $db->sql_fetchrow($result2);
                        $author = $data2["username"];
                        $posted_by = _I."<a href=\"w2g_modules.php?name=Your_Account&amp;op=userinfo&amp;username=".$author."\" title=\"".$author." "._FAPROFIL."\">".$author."</a>"._I_END;
                        // Fetch Last Post
                        $result3 = $db->sql_query("select poster_id from $prefix"._bbposts." WHERE forum_id = $forum_id ORDER BY post_id DESC LIMIT 0,1");
                        if ($result3)   { $data3 = $db->sql_fetchrow($result3); $uid = $data3["poster_id"]; 
                                            // Fetch Username
                                                $result4 = $db->sql_query("select username from $prefix"._users." WHERE user_id = $uid");
                                                $data4 = $db->sql_fetchrow($result4);
                                                $lastpost = $data4["username"];}
                            else        { $lastpost = $author; }
                        $lastpost = _I."<a href=\"w2g_modules.php?name=Your_Account&amp;op=userinfo&amp;username=".$lastpost."\" title=\"".$lastpost." "._FAPROFIL."\">".$lastpost."</a>"._I_END;
                        $topic_title = char_dec($topic_title);
                        $posted_by   = char_dec($posted_by);
                        $lastpost    = char_dec($lastpost);
                        doForumTopic($id,$uid,$posted_by,$topic_title,$lastpost);                   
                } while ($row = $db->sql_fetchrow($result));
                doForumFoot($memberfunctions,$breadcrumbs);
                $query = "&amp;f=".$f."";
                doPageNavigation($start,$increment,$totalresults,$query);
            CloseTable();           
        }
        
// Forums
else if ($c!="") 
         {
         $query = "&amp;c=".$c."";
         $limit = 8;
            // What Forum in Category $c?
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $result1 = $db->sql_query("select cat_id,cat_title from $prefix"._bbcategories." WHERE cat_id = '$c' LIMIT 1");
                $row = $db->sql_fetchrow($result1);
                $category = strtr(strip_tags($row["cat_title"]), $array_correction);
                $breadcrumbs = "<a href=\"w2g_modules.php?name=Forums\" title=\""._FORUM." "._FINDEX."\">"._FORUM." "._FINDEX."</a> &gt; <a href=\"w2g_modules.php?name=Forums&amp;c=".$c."\" title=\""._FCATT." ".$category."\">".$category."</a>";
            // Set Member Functions
                $memberfunctions = "";
            // Display Forums
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $totalresults = $db->sql_numrows($db->sql_query("select forum_id, cat_id, forum_name, forum_desc, forum_status from $prefix"._bbforums." WHERE cat_id = '$c' AND auth_view <= '$userlevel' ORDER BY forum_order ASC"));
                $result = $db->sql_query("select forum_id, cat_id, forum_name, forum_desc, forum_status from $prefix"._bbforums." WHERE cat_id = '$c' AND auth_view <= '$userlevel' ORDER BY forum_order ASC LIMIT $start,$increment");
                $row = $db->sql_fetchrow($result);
                OpenTable();
                $category        = char_dec($category);
                $memberfunctions = char_dec($memberfunctions);
                $breadcrumbs     = char_dec($breadcrumbs);
                doCatHead($category,$memberfunctions,$breadcrumbs);
                $content = "";
                do {
                    $shorten    = strtr(strip_tags($row["forum_name"]), $array_correction);
                    $forum_name= ucfirst($shorten);
                    $shorten = strtr(strip_tags($row["forum_desc"]), $array_correction);
                    $forum_desc    = ucfirst ($shorten);
                    $desc     = (strlen($forum_desc) > 50) ? (substr ($forum_desc,0,50)."..."):($forum_desc);
                    $id = $row["forum_id"];
                    $cat_title = "<a href=\"w2g_modules.php?name=Forums&amp;f=".$id."\" title=\""._FORUM." ".$forum_name."\">".$forum_name."</a>";
                    $cat_desc =  "".$desc."";
                    $cat_title = char_dec($cat_title);
                    $cat_desc = char_dec($cat_desc);
                    doCat($cat_title,$cat_desc,$cat_posts,$cat_replies);
                } while ($row = $db->sql_fetchrow($result));
                doCatFoot($memberfunctions,$breadcrumbs);
                doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();

} else    // Display Categories
        {
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $totalresults = $db->sql_numrows($db->sql_query("select cat_id,cat_title from $prefix"._bbcategories." order by cat_order ASC"));
                $result1 = $db->sql_query("select cat_id,cat_title from $prefix"._bbcategories." order by cat_order ASC LIMIT $start,$increment");
                $row = $db->sql_fetchrow($result1);
                $title =  ""._FCATE.":";
                $title  = char_dec($title);
                $content = _P_CENTER;
                do {
                    $shorten    = strtr(strip_tags($row["cat_title"]), $array_correction);
                    $forum_title= ucfirst($shorten);
                    $tit        = (strlen($forum_title) > 39) ? (substr ($forum_title,0,39)."..."):($forum_title);
                    $c  = $row["cat_id"];
                    $content .= "<b><a href=\"w2g_modules.php?name=Forums&amp;c=".$c."\" title=\""._FCATT." ".$tit."\">".$tit."</a></b><br/>";
                } while ($row = $db->sql_fetchrow($result1));
                $content .= _P_END;
                $content  = char_dec($content);
                OpenTable();
                    Title($title);
                    echo $content;
                    $query = "";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
        }

// Forum Footer
echo    _P_CENTER."Forum Powered by "._B."phpBB"._B_END._P_END;

?>