index.php

一个好用的php wap cms portal

                    if (!$start) {  $start=0;   }
                    // Display Most Recent Reviews
                    $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                    $totalresults = $db->sql_numrows($db->sql_query("select * from $prefix"._mreviews." order by counter DESC"));
                    $result = $db->sql_query("select * from $prefix"._mreviews." order by counter DESC limit $start,$increment");
                    $row = $db->sql_fetchrow($result);
                    // Shorten Content
                    $content    = "";
                    if($row)
                        {
                        do {
                            $shortened  = strtr(strip_tags($row["pagename"]), $array_correction);
                            $rtitle     = ucfirst ($shortened);
                            $tit        = (strlen($rtitle) > 20) ? (substr ($rtitle,0,35)."..."):($rtitle);
                            $id         = $row["rid"];
                            $score      = $row["score"];
                            $hits       = $row["counter"];
                            
                        // Display Article Image and then details
                            $content .= _B."<a href=\"w2g_modules.php?name=mreviews&amp;op=Review&amp;id=".$id."\" title=\"Read\">- ".$tit."</a>"._B_END." Score: "._B.$score._B_END." (/5) Hits: "._B.$hits._B_END._BR;
                        } while ($row = $db->sql_fetchrow($result));
                        $title      = ""._MTOP." "._READS."";
                        $prev       = $start-10;
                        $next       = $start+10;
                        $title    = char_dec($title);
                        $content  = char_dec($content);
                        OpenTable();
                            Title($title);
                            echo _P_LEFT.$content._P_END;
                            $query = "&amp;op=".$op."";
                            doPageNavigation($start,$increment,$totalresults,$query);
                        CloseTable();
                        }
                    else {  OpenTable();
                            $title = ""._MTOP." "._READS."";
                            $content = _P_CENTER._MNORESULTS._P_END;
                            $title    = char_dec($title);
                            $content  = char_dec($content);
                            Title($title);
                            echo $content;
                            CloseTable();}
                }

else if ($op=="Cat")
        {
            if ($id){
                        // Find Category Name
                        $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                        $result1 = $db->sql_query("select * from $prefix"._mreviews_cats." where cid = '$id' limit 1");
                        $row1 = $db->sql_fetchrow($result1);
                        $title      = strtr(strip_tags($row1["title"]), $array_correction);
                        $content    = strtr(strip_tags($row1["description"]), $array_correction);

                        $title    = char_dec($title);
                        $content  = char_dec($content);
                    OpenTable();
                        Title($title);
                        echo _P_CENTER.$content._P_END;
                    CloseTable();
                                                
                        // Are there Sub-cats?
                        $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                        $result2 = $db->sql_query("select * from $prefix"._mreviews_cats." where pid = '$id' order by title asc");
                        $row2 = $db->sql_fetchrow($result2);
                        if ($row2)
                            {
                                $content = "";
                                do {
                                    $subcat_title   = strtr(strip_tags($row2["title"]), $array_correction);
                                    $subcat_desc    = strtr(strip_tags($row2["description"]), $array_correction);
                                    $subcat_id      = $row2["cid"];
                                    $subcat_image   = $row2["image"];
                                    $subcat_thumbsize = $usergfxprex/8;
                                    $content .= " <a href=\"w2g_modules.php?name=mreviews&amp;op=Cat&amp;id=".$subcat_id."\">"; 
                                    if ($usergfxpref>150)
                                            {   if ($subcat_image)  {   $content .= doimage($nukeurl."/".$subcat_image, null, $subcat_thumbsize);    } else  { $content .= "+ "; }   }
                                    else    { $content .= "+ "; }
                                    $content .= $subcat_title."</a> ";
                                } while ($row2 = $db->sql_fetchrow($result2));
                                OpenTable();
                                    $title = ""._MSUBCATEGORIES."";
                                    $title    = char_dec($title);
                                    $content  = char_dec($content);
                                    Title($title);
                                    echo _P_CENTER.$content._P_END;
                                CloseTable();
                            }
                    // Display Most Recent Reviews In CATEGORY
                    $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                    $totalresults = $db->sql_numrows($db->sql_query("select pagename, rid from $prefix"._mreviews." where cid = '$id' order by rid DESC"));
                    $result = $db->sql_query("select pagename, rid, score from $prefix"._mreviews." where cid = '$id' order by rid DESC limit $start,$increment");
                    $row = $db->sql_fetchrow($result);

                    // Shorten Content
                    if($row)
                        {
                        $content    = "";
                        do {
                            $shortened  = strtr(strip_tags($row["pagename"]), $array_correction);
                            $rtitle     = ucfirst ($shortened);
                            $tit        = (strlen($rtitle) > 20) ? (substr ($rtitle,0,35)."..."):($rtitle);
                            $rid         = $row["rid"];
                            $score      = $row["score"];
                            
                        // Display Article Image and then details
                            $content .= _B."<a href=\"w2g_modules.php?name=mreviews&amp;op=Review&amp;id=".$rid."\" title=\""._MREVIEW.": ".$tit."\">- ".$tit."</a>"._B_END." Score: "._B.$score._B_END."/5"._BR;
                        } while ($row = $db->sql_fetchrow($result));
                        $title      = ""._MRECENT." "._MREVIEWS."";
                        $title    = char_dec($title);
                        $content  = char_dec($content);
                        OpenTable();    Title($title);
                            echo _P_CENTER.$content._P_END;
                            $query = "&amp;op=".$op."&amp;id=".$id."";
                            doPageNavigation($start,$increment,$totalresults,$query);
                        CloseTable();
                        }
            }
        }
else    {
            $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
            $totalresults = $db->sql_numrows($db->sql_query("select * from $prefix"._mreviews_cats." where pid=0 order by title asc"));
            $result2 = $db->sql_query("select * from $prefix"._mreviews_cats." where pid=0 order by title asc");
            $row2 = $db->sql_fetchrow($result2);
            if ($row2)
                {
                    $content = "";                              
                    do {
                        $subcat_title   = strtr(strip_tags($row2["title"]), $array_correction);
                        $subcat_desc    = strtr(strip_tags($row2["description"]), $array_correction);
                        $subcat_id      = $row2["cid"];
                        $subcat_image   = $row2["image"];
                        $content .= "".doimage("".$nukeurl."/".$subcat_image."", $subcat_title, $thumbsize)._BR
                                   ."<a href=\"w2g_modules.php?name=mreviews&amp;op=Cat&amp;id=".$subcat_id."\">"
                                   ."".$subcat_title."</a>"._BR;
                    } while ($row2 = $db->sql_fetchrow($result2));
                $title = ""._MCATEGORIES.""; 

                $title    = char_dec($title);
                $content  = char_dec($content);
                OpenTable();
                    Title($title);
                    echo _P_CENTER.$content._P_END;
                    $query = "";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
                }
        }
// Options on ALL Pages
OpenTable();
    $title   = ""._MENUFOR." ".$modulename."";
    $content = _P_CENTER."<a href=\"w2g_modules.php?name=$moduletitle\">Categories</a> | <a href=\"w2g_modules.php?name=$moduletitle&amp;op=Recent\">"._MRECENT." "._MREVIEWS."</a> | <a href=\"w2g_modules.php?name=$moduletitle&amp;op=Popular\">"._BEST." "._MRANKING."</a> | <a href=\"w2g_modules.php?name=$moduletitle&amp;op=MostRead\">"._MTOP." "._READS."</a>"._P_END;
    $title   = char_dec($title);
    $content = char_dec($content);
    Title($title);
    echo $content;
CloseTable();
?>