|
|
 |
|
Nukemods Forum
> NM Staff
> Purged Topics
|
 Need help with exteded SearchThis is a discussion on Need help with exteded Search within the Purged Topics forums, part of the NM Staff category; Hi.. It's me again... :roll:
Ok.. I originally posted about making Multiple Reviews Sections here . Now I have another ... |
|
|
 |
|
|
|
|
|
Junior Member
Status: Offline
Posts: 39
Join Date: Jan 2003
Location: In my robe trying to figure this stuff out... LOL!
|
Need help with exteded Search -
02-22-2003, 11:18 PM
Hi.. It's me again... :roll:
Ok.. I originally posted about making Multiple Reviews Sections here. Now I have another Question...
I have made all of my Reviews Sections, but how do I get the SEARCH to search them all? I was looking at the index.php in the Search Folder, but I'm kinda lost. :roll:
I have 10 Reviews Sections...
- Reviews
Reviews2
Reviews3
Reviews4
Reviews5
Reviews6
Reviews7
Reviews8
Reviews9
I would like it when you Search for reviews, you get results from every Review Module. Hope this makes sense.. This shouldn't be that hard on you guys. And I don't expect a four page thread like the last one..  ..... 8O ........ I think it's just a matter of copying a few lines around in the Search Modules index.php or lang-english.php...
Thanks allot! :wink:
|
|
|
|
|
|
|
|
Junior Member
Status: Offline
Posts: 39
Join Date: Jan 2003
Location: In my robe trying to figure this stuff out... LOL!
|
02-24-2003, 07:51 AM
Er... anyone?.... anyone at all... :roll:
|
|
|
|
|
|
|
|
Senior Member
Status: Offline
Posts: 619
Join Date: Oct 2002
Location: Alabama, USA
|
02-24-2003, 07:59 AM
Not ignoring you, but I'm at a loss. Maybe someone else??????? :!:
|
|
|
|
|
|
|
|
Junior Member
Status: Offline
Posts: 39
Join Date: Jan 2003
Location: In my robe trying to figure this stuff out... LOL!
|
02-24-2003, 08:23 AM
Thank you Martin 
I'm just not sure if I have to edit the INDEX.PHP, or the LANG-ENGLISH.PHP in the Search Module. If it's a matter of adding duplicate lines in the language file, then that should be easy... But, if it's in the index.php, I'm gonna have issues... 
|
|
|
|
|
|
|
|
Moderator
Status: Offline
Posts: 737
Join Date: Nov 2002
|
02-24-2003, 10:03 AM
I'll look and see if I can find the lines you need to edit
|
|
|
|
|
|
|
|
Junior Member
Status: Offline
Posts: 39
Join Date: Jan 2003
Location: In my robe trying to figure this stuff out... LOL!
|
02-24-2003, 10:13 AM
 Thanx IACOJ! 
(Yes... I did find a smiley site...) :wink:
|
|
|
|
|
|
|
|
Moderator
Status: Offline
Posts: 737
Join Date: Nov 2002
|
02-24-2003, 10:37 AM
Ok I"m going to give this to you in parts, because there is a lot to edit in the file. Make a backup of your files first
First starting on line 26 in the index php. Find
Code:
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews */
Replace ONLY that line with
Code:
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews2 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews3 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews4 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews5 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews6 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews7 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews8 */
$queryrlang = "AND rlanguage='$currentlang' "; /* reviews9 */
Find around line 79
Code:
} elseif ($type == "reviews") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS."</font></center>
";
Replace with
Code:
} elseif ($type == "reviews") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS."</font></center>
";
} elseif ($type == "reviews2") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS2."</font></center>
";
} elseif ($type == "reviews3") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS3."</font></center>
";
} elseif ($type == "reviews4") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS4."</font></center>
";
} elseif ($type == "reviews5") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS5."</font></center>
";
} elseif ($type == "reviews6") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS6."</font></center>
";
} elseif ($type == "reviews7") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS7."</font></center>
";
} elseif ($type == "reviews8") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS8."</font></center>
";
} elseif ($type == "reviews9") {
echo "<center><font class=\"title\">"._SEARCHREVIEWS9."</font></center>
";
|
|
|
|
|
|
|
|
Moderator
Status: Offline
Posts: 737
Join Date: Nov 2002
|
02-24-2003, 10:45 AM
Find around line 96
Code:
if (($type == "users") OR ($type == "sections") OR ($type == "reviews")) {
replace with
Code:
if (($type == "users") OR ($type == "sections") OR ($type == "reviews") OR ($type == "reviews2") OR ($type == "reviews3") OR ($type == "reviews4") OR ($type == "reviews5") OR ($type == "reviews6") OR ($type == "reviews7") OR ($type == "reviews8") OR ($type == "reviews9")) {
Find
Code:
} elseif ($type == "reviews") {
$sel5 = "checked";
Replace with
Code:
} elseif ($type == "reviews") {
$sel5 = "checked";
} elseif ($type == "reviews2") {
$sel6 = "checked";
} elseif ($type == "reviews3") {
$sel7 = "checked";
} elseif ($type == "reviews4") {
$sel8 = "checked";
} elseif ($type == "reviews5") {
$sel9 = "checked";
} elseif ($type == "reviews6") {
$sel10 = "checked";
} elseif ($type == "reviews7") {
$sel11 = "checked";
} elseif ($type == "reviews8") {
$sel12 = "checked";
) elseif ($type == "reviews9") {
$sel13 = "checked";
Find
Code:
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews", $dbi), $dbi);
replace with
Code:
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews2", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews3", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews4", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews5", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews6", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews7", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews8", $dbi), $dbi);
$num_rev = sql_num_rows(sql_query("select * from ".$prefix."_reviews9", $dbi), $dbi);
|
|
|
|
|
|
|
|
Junior Member
Status: Offline
Posts: 39
Join Date: Jan 2003
Location: In my robe trying to figure this stuff out... LOL!
|
02-24-2003, 10:56 AM
Ok... I added those sections, but it still didn't find the entries in the other Review sections. No errors though... :wink:
|
|
|
|
|
|
|
|
Moderator
Status: Offline
Posts: 737
Join Date: Nov 2002
|
02-24-2003, 11:00 AM
Find
Code:
if ($num_rev > 0) {
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel5> "._REVIEWS."";
Replace with
Code:
if ($num_rev > 0) {
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel5> "._REVIEWS."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel6> "._REVIEWS2."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel7> "._REVIEWS3."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel8> "._REVIEWS4."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel9> "._REVIEWS5."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel10> "._REVIEWS6."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel11> "._REVIEWS7."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel12> "._REVIEWS8."";
echo "<input type=\"radio\" name=\"type\" value=\"reviews\" $sel13> "._REVIEWS9."";
Find
Code:
} elseif ($type=="reviews") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
Replace with
Code:
} elseif ($type=="reviews") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews2") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews2 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews2&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews2&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews2.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews3") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews3 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews3&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews3&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews3.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews4") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews4 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews4&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews4&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews4.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews5") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews5 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews5&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews5&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews5.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews6") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews6 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews6&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews6&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews6.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews7") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews7 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews7&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews7&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews7.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews8") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews8 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews8&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews8&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews8.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
} elseif ($type=="reviews9") {
$result = sql_query("select id, title, text, reviewer, score from ".$prefix."_reviews9 where (title like '%$query%' OR text like '%$query%') $queryrlang order by date DESC limit $min,$offset", $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
if ($query != "") {
echo "
<hr noshade size=\"1\"><center>"._SEARCHRESULTS."</center>
";
echo "<table width=\"99%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
if ($nrows>0) {
while(list($id, $title, $text, $reviewer, $score) = sql_fetch_row($result, $dbi)) {
$furl = "modules.php?name=Reviews9&op=showcontent&id=$id";
$pages = count(explode( "", $text ));
echo "<tr><td><img src=\"images/folders.gif\" border=\"0\" alt=\"\"><font class=\"option\"><a href=\"$furl\">$title</a></font>
"
."<font class=\"content\">"._POSTEDBY." $reviewer
"
.""._REVIEWSCORE.": $score/10
";
if ($pages == 1) {
echo "($pages "._PAGE.")";
} else {
echo "($pages "._PAGES.")";
}
if (is_admin($admin)) {
echo " [ <a href=\"modules.php?name=Reviews9&op=mod_review&id=$id\">"._EDIT."</a> | <a href=\"modules.php?name=Reviews9.php&op=del_review&id_del=$id\">"._DELETE."</a> ]";
}
print "
</font></td></tr>\n";
$x++;
}
echo "</table>";
I think that should work without changing the language files because you have seperate Review modules, so each one has it's own language file.
|
|
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
