<?php
/********************************************************************************/ 
/*  Wap-2-Go Mobile Phone Nuke-Addon                                            */
/*          bringing the Advanced Content Management System to Mobile Format    */
/*  =========================================================================== */
/*                                              powered by Nuke SQL Database    */
/*                                                                              */
/* Copyright (c) 2007 by Philip Marsh   -   http://www.wap2go.co.uk             */
/*                                                                              */
/*  mREVIEWS MODULE                                                             */
/*                                                                              */
/*  FILE DETAILS and EXPLANATION:                                               */
/*  functions.php - Specific Functions for Module                               */
/********************************************************************************/ 
// Include the Module's Functions
// include_once "modules/mreviews/functions.php";
$thumbsize = $usergfxpref/3;
if (!$start)     { $start = 0; }
if (!$limit)     { $limit = 5; }
if (!$increment) { $increment = 5; }

// Module Content
if ($op=="Review")
        {
        if ($id) 
                {
                    // Display Review
                    $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                    $result = $db->sql_query("select * from $prefix"._mreviews." where rid = '$id'");
                    $data = $db->sql_fetchrow($result);

                    $pagename  = strtr(strip_tags($data["pagename"]), $array_correction);
                    $content   = strtr(strip_tags($data["content"]), $array_correction);
                    $author   = strtr(strip_tags($data["author"]), $array_correction);
                    $hits   = $data["counter"];
                    $score  = $data["score"];
                        // Get Any Images
                            $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                            $result1 = $db->sql_query("select * from $prefix"._mreviews_images." where rid=$id");
                            $data1 = $db->sql_fetchrow($result1);
                            if ($data1)
                                {
                                    $reviewimages = "";
                                    $reviewimage = $data1["image"];
                                    $reviewimagesize = $usergfxpref/4;
                                    do {
                                        $reviewimages .= "<a href=\"".$nukeurl."/mobile/includes/w2g_thumbs.php?src=".$nukeurl."/".$reviewimage."&amp;x=".$usergfxpref."&amp;t=".$imgtype."&amp;f=0\" title=\""._MIMAGE."\">".doimage("".$nukeurl."/".$reviewimage."", ""._MIMAGE."", $reviewimagesize)."</a> ";
                                    } while ($data1 = $db->sql_fetchrow($result1));
                                    $areimages = 1;
                                }
                    $tit_name = (strlen($pagename) > 100) ? (substr($pagename,0,10)."...") : ($pagename);
                    $tit_data = $tit_name;
                    $title = $pagename.":";
                    $content = _P_CENTER.$content._P_END;
                        if ($areimages==1) { $content.= _P_CENTER._H3._MIMAGES._H3_END._BR.$reviewimages._P_END; }
                        $content.= _P_CENTER._MREVIEWER.": "._B.$author._B_END." | "._MRANKING.": "._B.$score._B_END."/5 | "._MREADS.": "._B.$hits._B_END._P_END;
                    $title  = char_dec($title);
                    $content  = char_dec($content);
                    OpenTable();
                    Title($title);
                    echo $content;
                    CloseTable();
                }   
        else    {
                OpenTable();
                    $title = ""._MERROR.""; Title($title);
                    echo _P_CENTER._MNORESULTS._P_END;
                CloseTable();
                }
        }
else if ($op=="Recent")
                {
                    if (!$start) {  $start=0;   }
                    // Display Most Recent Reviews
                    $dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
                    $totalresults = $db->sql_numrows($db->sql_query("select pagename, rid from $prefix"._mreviews." order by rid DESC"));
                    $result = $db->sql_query("select pagename, rid from $prefix"._mreviews." order by rid DESC limit $start,$increment");
                    $row = $db->sql_fetchrow($result);
                    
                    // Shorten Content
                    $content    = "";
                    $i = 0;
                    if($row)
                        {
                        do {
                            $i = $i+1;
                            $shortened  = strtr(strip_tags($row["pagename"]), $array_correction);
                            $rtitle     = ucfirst ($shortened);
                            $tit        = (strlen($rtitle) > 20) ? (substr ($rtitle,0,35)."..."):($rtitle);
                            $id         = $row["rid"];
                            
                        // Display Article Image and then details
                            if ($i<11) {$content .= "<a href=\"w2g_modules.php?name=mreviews&amp;op=Review&amp;id=".$id."\" title=\"Read $tit\">- $tit</a>"._BR;}
                        } while ($row = $db->sql_fetchrow($result));
                        $title      = ""._MRECENT." "._MREVIEWS."";
                        $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    = ""._MRECENT." "._MREVIEWS."";
                            $content  = _P_CENTER._MNORESULTS._P_END;
                            $title    = char_dec($title);
                            $content  = char_dec($content);
                            Title($title);
                            echo $content;
                            CloseTable();}
                }
else if ($op=="Popular")
                {
                    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 score DESC"));
                    $result = $db->sql_query("select * from $prefix"._mreviews." order by score 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"];
                            
                        // 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)"._BR;
                        } while ($row = $db->sql_fetchrow($result));
                        $title      = ""._BEST." "._MRANKING.":";
                        $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 = ""._BEST." "._MRANKING."";
                            $content  = _P_CENTER._MNORESULTS._P_END;
                            $title    = char_dec($title);
                            $content  = char_dec($content);
                            Title($title);
                            echo $content;
                            CloseTable();}
                }
else if ($op=="MostRead")
                {