index.php

一个好用的php wap cms portal

                    } while ($row = $db->sql_fetchrow($result));
                $title = "Latest Episodes:";
                $title   = char_dec($title);
                $content = char_dec($content);
                OpenTable();    Title($title);
                    echo _P_CENTER.$content._P_END;
                    $query = "&op=Channel&id=".$id."";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
        }   else    {
                // Fetch All Channels
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                $totalresults = $db->sql_numrows($db->sql_query("SELECT * FROM $prefix"._podcastv2_channels." WHERE access <= '$userlevel'"));
                $result = $db->sql_query("SELECT * FROM $prefix"._podcastv2_channels." WHERE access <= '$userlevel' LIMIT $start,$increment");
                $row = $db->sql_fetchrow($result);
                $content="";
                if ($row) {
                        do {
                            $channel    = strtr(strip_tags($row["title"]), $array_correction);
                            $subtitle   = strtr(strip_tags($row["subtitle"]), $array_correction);
                            $cid = $row["cid"];
                            $content .= _B."<a href=\"w2g_modules.php?name=$moduletitle&amp;op=Channel&amp;id=".$cid."\">";
                            if ($usergfxpref>20)    {   
                                    $image  = $imagedir;
                                    $image  .= $row["image"];
                                    $content .= doimage($nukeurl."/".$image, null, $thumbsize);}
                            $content .= " ".$channel."</a>"._B_END." - ".$subtitle._BR;
                        } while($row = $db->sql_fetchrow($result));
                    }
                $title = ""._PODCASTV2_CHANNEL_LISTING."";
                $title   = char_dec($title);
                $content = char_dec($content);
                OpenTable();    Title($title);
                    echo _P_CENTER.$content._P_END;
                    $query = "&amp;op=Channel";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
        }
} else if ($op=="Popular") {
        // Most Popular Podcasts
                $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);                
                $totalresults = $db->sql_numrows($db->sql_query("SELECT * FROM $prefix"._podcastv2_items." WHERE access <= '$userlevel' ORDER BY downloads DESC"));
                $result = $db->sql_query("SELECT * FROM $prefix"._podcastv2_items." WHERE access <= '$userlevel' ORDER BY downloads DESC LIMIT $start,$increment");
                $row = $db->sql_fetchrow($result);
                $content="";
                if ($row) {
                        do {
                                    $title      = strtr(strip_tags($row["title"]), $array_correction);
                                    $url        = $row["enclosure"];
                                    $subtitle   = strtr(strip_tags($row["subtitle"]), $array_correction);
                                    $iid        = $row["iid"];
                                    $hits       = $row["downloads"];
                                    $cid        = $row["cid"];
            
                                    // Fetch Channel and Image
                                    $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                                    $result3 = $db->sql_query("SELECT title, image FROM $prefix"._podcastv2_channels." WHERE cid = $cid LIMIT 1");
                                    $row3 = $db->sql_fetchrow($result3);
                                    $channel = strtr(strip_tags($row3["title"]), $array_correction);
                                    $content .= "<a href=\"w2g_modules.php?name=$moduletitle&amp;op=Info&amp;id=".$iid."\">"; 
                                    $content .= "".doimage("".$nukeurl."/modules/Podcasts/images/".$row3["image"]."", $title, $thumbsize)."</a> ";
                                    $content .= _B."<a href=\"w2g_modules.php?name=$moduletitle&amp;op=Info&amp;id=".$iid."\">".$channel."  ".$title."</a>"._B_END." - ".$subtitle." "._I."(".$hits." "._READS.")"._I_END._BR;
                            } while ($row = $db->sql_fetchrow($result));
                        $title="Most Popular:";}
                else { $title = "Sorry"; $content = "No Podcasts Found!";}
                $title   = char_dec($title);
                $content = char_dec($content);
                OpenTable();    Title($title);
                    echo _P_CENTER.$content._P_END;
                    $query = "&amp;op=Popular";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
}   else if ($op=="Latest") {
            $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
            $totalresults = $db->sql_numrows($db->sql_query("SELECT * FROM $prefix"._podcastv2_items." WHERE access <= '$userlevel' ORDER BY iid DESC"));
            $result2 = $db->sql_query("SELECT * FROM $prefix"._podcastv2_items." WHERE access <= '$userlevel' ORDER BY iid DESC LIMIT $start,$increment");
            $row2 = $db->sql_fetchrow($result2);
            if ($row2)
                    {
                    $content = "";                              
                    do {
                        $title      = strtr(strip_tags($row2["title"]), $array_correction);
                        $url        = $row2["enclosure"];
                        $subtitle   = strtr(strip_tags($row2["subtitle"]), $array_correction);
                        $cid        = $row2["cid"];
                        $iid        = $row2["iid"];
                            // Fetch Channel and Image
                            $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                            $result3 = $db->sql_query("SELECT title, image FROM $prefix"._podcastv2_channels." WHERE cid = '$cid' LIMIT 1");
                            $row3 = $db->sql_fetchrow($result3);
                            $channel = strtr(strip_tags($row3["title"]), $array_correction);
                        $content .= "<a href=\"w2g_modules.php?name=$moduletitle&amp;op=Info&amp;id=".$iid."\">"; 
                        $content .= "".doimage("".$nukeurl."/modules/Podcasts/images/".$row3["image"]."", $title, $thumbsize)."</a> ";
                        $content .= "<a href=\"w2g_modules.php?name=$moduletitle&amp;op=Info&amp;id=".$iid."\">".$channel." "._B.$title._B_END."</a> - ".$subtitle._BR;
                    } while ($row2 = $db->sql_fetchrow($result2));
                    $title = ""._PODCASTV2_LATEST_LISTING.":";
                $title   = char_dec($title);
                $content = char_dec($content);
                OpenTable();
                    Title($title);
                    echo _P_CENTER.$content._P_END;
                    $query = "&amp;op=Latest";
                    doPageNavigation($start,$increment,$totalresults,$query);
                CloseTable();
                }

}   else    {
            $content = $welcome; // Slash this out to remove welcome message
            $title   = char_dec($title);
            $content = char_dec($content);
            OpenTable();
                echo _P_CENTER.$content._P_END;
            CloseTable();
        }
// Options on ALL Pages
OpenTable();
    $title = ""._MENUFOR." ".$modulename."";
    $content = _P_CENTER."<a href=\"w2g_modules.php?name=".$moduletitle."&amp;op=Channel\">"._PODCASTV2_SHOW_CHANNELS."</a> | <a href=\"w2g_modules.php?name=".$moduletitle."&amp;op=Latest\">"._PODCASTV2_LATEST_LISTING."</a> | <a href=\"w2g_modules.php?name=".$moduletitle."&amp;op=Popular\">Most Popular</a>"._P_END;
    $title   = char_dec($title);
    $content = char_dec($content);
    Title($title);
    echo $content;
CloseTable();
?>