reviews module, hack?

reino4 · **reviews module, hack? -** 05-25-2003, 09:18 AM

I searched these forums and couldn't find an answer, so here goes.

Though I saw posts for multiple reviews modules, is there a way to show more than the standard last 10 reviews/10 most pop reviews? Say last 20 or 30. Instead of searching through the alphabet links.

Also saw in the forum search that there is a block for last 10 reiviews that is in all versions of nuke. But not in mine.

thanks
warren
http://wdubradio.com

MrGeekDude · 05-25-2003, 09:29 AM

Quote:

Also saw in the forum search that there is a block for last 10 reiviews that is in all versions of nuke. But not in mine.

really? it's in mine... the block file (what you select to add the block) is called "reviews" as for changing the top #... let me get on that...

MrGeekDude · 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!

reino4 · **reviews block -** 05-25-2003, 09:35 AM

It's uploaded and in the blocks directory, it just isn't visible on the admin/blocks page.

reino4 · **major problem -** 05-25-2003, 09:51 AM

Changed the code like you said, it worked fine on the reviews page, problem is, now when you click on a review you get this - "Sorry, such file doesn't exist..."

did I just lose all my reviews???

If you click on, say, the letter E and click on the review there you can read the review, just can't from the main reviews page after chaging the code...help!!!!!!!!!!!!!!!!

reino4 · **fixed?? -** 05-25-2003, 03:46 PM

I uploaded the old reviews module and this put me back at the beginning. Why would changing the code like we tried result in the story not available message?

MrGeekDude · 05-25-2003, 05:16 PM

ya got me puzzled on that one... let me take a look at the code... see the reviews module is one file, and I think it wanted to go to a different file... I'll check

MrGeekDude · 05-25-2003, 05:19 PM

truthfully... I have no idea why that cuased it to not work... It's odd... we didn't edit anything with links... are you sure the reviews worked BEFORE you edited it?

reino4 · **they worked before -** 05-25-2003, 09:52 PM

I uploaded the original reviews-index.php and language file and it went back to 10 most/10 recent and everything worked fine. Tried your code one more time and got the same result, story not available......

MrGeekDude · 05-26-2003, 07:48 AM

can I see your site, so I have more of an idea of what's wrong?