Quote:
Originally posted by Logician
try to apply Post 2 AND Post 7
|
I did apply both post #2 and #7, but the results are unchanged?
Here are the snippets from my search.php file that I am using:
PHP Code:
// ###################### Start get new #######################
if ($action=="getnew") {
// generate query
// do it!
if ($bbuserinfo[userid]!=0 or $bbuserinfo[lastvisit]!=0) {
$forumsql=getallforumsql();
if (isset($forumid)) {
$forums=$DB_site->query("SELECT forumid FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',".addslashes($forumid).",')>0");
$forumsql.=" AND forumid IN (0";
while ($forum=$DB_site->fetch_array($forums)) {
if ($forum[forumid]!=98) {$forumsql.=",$forum[forumid]";}
}
$forumsql.=") ";
}
and
PHP Code:
// ###################### Start get daily #######################
if ($action=="getdaily") {
// get allowable forums:
$forumsql=getallforumsql();
if (isset($forumid)) {
$forums=$DB_site->query("SELECT forumid FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',".addslashes($forumid).",')>0");
$forumsql.=" AND forumid IN (0";
while ($forum=$DB_site->fetch_array($forums)) {
if ($forum[forumid]!=98) {$forumsql.=",$forum[forumid]";}
}
$forumsql.=") ";
}
I hope this helps, thanks again with your help.