Nukemods Forum - View Single Post

MrGeekDude · #3 (**permalink**) 05-25-2003, 09:32 AM

OK... I was wrong before... here's what you have to do... (this is for 20 most pop and recent)
find the code (modules/Reviews/index.php)

Code:

echo "<tr><td width=\"50%\" bgcolor=\"$bgcolor2\">"._10MOSTPOP."</td>";
    echo "<td width=\"50%\" bgcolor=\"$bgcolor2\">"._10MOSTREC."</td></tr>";
    $result_pop = sql_query("select id, title, hits from ".$prefix."_reviews $querylang order by hits DESC limit 10", $dbi);
    $result_rec = sql_query("select id, title, date, hits from ".$prefix."_reviews $querylang order by date DESC limit 10", $dbi);
    $y = 1;
    for ($x = 0; $x < 10; $x++)	{
	$myrow = sql_fetch_array($result_pop, $dbi);
	$id = $myrow["id"];
	$title = $myrow["title"];
	$hits = $myrow["hits"];
	echo "<tr><td width=\"50%\" bgcolor=\"$bgcolor4\">$y) <a href=\"modules.php?name=$module_name&rop=showcontent&id=$id\">$title</a></td>";
	$myrow = sql_fetch_array($result_rec, $dbi);
	$id = $myrow["id"];
	$title = $myrow["title"];
	$hits = $myrow["hits"];
	echo "<td width=\"50%\" bgcolor=\"$bgcolor4\">$y) <a href=\"modules.php?name=$module_name&rop=showcontent&id=$id\">$title</a></td></tr>";
	$y++;
    }
    echo "<tr><td colspan=\"2\">
</td></tr>";
    $result = sql_query("SELECT * FROM ".$prefix."_reviews $querylang", $dbi);
    $numresults = sql_num_rows($result, $dbi);
    echo "<tr><td colspan=\"2\">
<center>"._THEREARE." $numresults "._REVIEWSINDB."</center></td></tr></table>";
    CloseTable();

and replace it with the code

Code:

echo "<tr><td width=\"50%\" bgcolor=\"$bgcolor2\">"._10MOSTPOP."</td>";
    echo "<td width=\"50%\" bgcolor=\"$bgcolor2\">"._10MOSTREC."</td></tr>";
    $result_pop = sql_query("select id, title, hits from ".$prefix."_reviews $querylang order by hits DESC limit 20", $dbi);
    $result_rec = sql_query("select id, title, date, hits from ".$prefix."_reviews $querylang order by date DESC limit 20", $dbi);
    $y = 1;
    for ($x = 0; $x < 20; $x++)	{
	$myrow = sql_fetch_array($result_pop, $dbi);
	$id = $myrow["id"];
	$title = $myrow["title"];
	$hits = $myrow["hits"];
	echo "<tr><td width=\"50%\" bgcolor=\"$bgcolor4\">$y) <a href=\"modules.php?name=$module_name&rop=showcontent&id=$id\">$title</a></td>";
	$myrow = sql_fetch_array($result_rec, $dbi);
	$id = $myrow["id"];
	$title = $myrow["title"];
	$hits = $myrow["hits"];
	echo "<td width=\"50%\" bgcolor=\"$bgcolor4\">$y) <a href=\"modules.php?name=$module_name&rop=showcontent&id=$id\">$title</a></td></tr>";
	$y++;
    }
    echo "<tr><td colspan=\"2\">
</td></tr>";
    $result = sql_query("SELECT * FROM ".$prefix."_reviews $querylang", $dbi);
    $numresults = sql_num_rows($result, $dbi);
    echo "<tr><td colspan=\"2\">
<center>"._THEREARE." $numresults "._REVIEWSINDB."</center></td></tr></table>";
    CloseTable();

(note: see where I changed 10 to 20?)

ok, then you need to go into modules/Reviews/language/lang-english.php and find

Code:

define("_10MOSTPOP","10 most popular reviews");
define("_10MOSTREC","10 most recent reviews");

replace that with

Code:

define("_10MOSTPOP","20 most popular reviews");
define("_10MOSTREC","20 most recent reviews");

and you're done!