'Stories', 'func_search' => 'search_stories', 'func_opt' => 'search_stories_opt' ); function search_stories_opt() { global $bgcolor2, $textcolor1, $info; list($dbconn) = pnDBGetConn(); $pntable = pnDBGetTables(); $output = new pnHTML(); $output->SetInputMode(_PNH_VERBATIMINPUT); if (pnSecAuthAction(0, 'Stories::', "::", ACCESS_READ)) { $output->Text("
 
"); $output->Text(""); // categories $output->Text(""); // author $output->Text("
:
:
:
"); } return $output->GetOutput(); } function search_stories() { list($startnum, $active_stories, $total, $stories_topics, $stories_cat, $stories_author, $q, $bool) = pnVarCleanFromInput('startnum', 'active_stories', 'total', 'stories_topics', 'stories_cat', 'stories_author', 'q', 'bool'); if(!isset($active_stories) || !$active_stories) { return; } $output = new pnHTML(); if (!isset($startnum)) { $startnum = 1; } list($dbconn) = pnDBGetConn(); $pntable = pnDBGetTables(); if (empty($bool)) { $bool = 'OR'; } $flag = false; $storcol = &$pntable['stories_column']; $stcatcol = &$pntable['stories_cat_column']; $topcol = &$pntable['topics_column']; $query = ""; $query1 = "SELECT $storcol[sid] as sid, $topcol[tid] as topicid, $topcol[topicname] as topicname, $topcol[topictext] as topictext, $storcol[catid] as catid, $storcol[time] AS fdate, $storcol[title] AS story_title, $storcol[aid] AS aid, $stcatcol[title] AS cat_title FROM $pntable[stories] LEFT JOIN $pntable[stories_cat] ON ($storcol[catid]=$stcatcol[catid]) LEFT JOIN $pntable[topics] ON ($storcol[topic]=$topcol[tid]) WHERE "; // hack to get this to work, but much better than what we had before //$query .= " 1 = 1 "; // words $w = search_split_query($q); if (isset($w)) { foreach($w as $word) { if($flag) { switch($bool) { case 'AND' : $query .= ' AND '; break; case 'OR' : default : $query .= ' OR '; break; } } $query .= '('; $query .= "$storcol[title] LIKE '$word' OR "; $query .= "$storcol[hometext] LIKE '$word' OR "; $query .= "$storcol[bodytext] LIKE '$word' OR "; $query .= "$storcol[comments] LIKE '$word' OR "; $query .= "$storcol[informant] LIKE '$word' OR "; $query .= "$storcol[notes] LIKE '$word'"; $query .= ')'; $flag = true; $no_flag = false; } } else { $no_flag = true; } // topics if(isset($stories_topics) && (!empty($stories_topics))) { $flag = false; $start_flag = false; // dont set AND/OR if nothing is in front foreach($stories_topics as $v) { if (empty($v)) continue; if ( (!$no_flag) and (!$start_flag) ) { $query .= " AND ("; $start_flag = true; } if ($flag) $query .= " OR "; $query .= "$storcol[topic]=$v"; $flag = true; } if ( (!$no_flag) and ($start_flag) ) { $query .= ") "; $no_flag = false; } } // categories if (!is_array($stories_cat)) $stories_cat[0] = ''; if(isset($stories_cat[0]) &&(!empty($stories_cat[0]))) { if (!$no_flag) { $query .= " AND ("; } $flag = false; foreach($stories_cat as $v) { if($flag) { $query .= " OR "; } $query .= "$stcatcol[catid]=$v"; $flag = true; } if (!$no_flag) { $query .= ") "; $no_flag = false; } } // authors if(isset($stories_author) && $stories_author != "") { if (!$no_flag) { $query .= " AND ("; } $query .= "$storcol[informant]='$stories_author'"; $result = $dbconn->Execute("SELECT {$pntable['users_column']['uid']} as pn_uid FROM $pntable[users] WHERE {$pntable['users_column']['uname']} LIKE '%$stories_author%' OR {$pntable['users_column']['name']} LIKE '%$stories_author%'"); while(!$result->EOF) { $row = $result->GetRowAssoc(false); $query .= " OR $storcol[aid]=$row[pn_uid]"; $result->MoveNext(); } if (!$no_flag) { $query .= ") "; $no_flag = false; } } else { $stories_author = ''; } if (pnConfigGetVar('multilingual') == 1) { if (!empty($query)) $query .= " AND"; $query .= " ($storcol[alanguage]='" . pnVarPrepForStore(pnUserGetLang()) . "' OR $storcol[alanguage]='')"; } if (empty($query)) $query = "1"; $query .= " ORDER BY $storcol[time] DESC"; $query = $query1.$query; if (empty($total)) { // echo $query; $total = 0; $countres = $dbconn->Execute($query); //$total = $countres->PO_RecordCount(); while(!$countres->EOF) { $row = $countres->GetRowAssoc(false); if (pnSecAuthAction(0, 'Stories::Story', "$row[aid]:$row[cat_title]:$row[sid]", ACCESS_READ) && pnSecAuthAction(0, 'Topics::Topic', "$row[topicname]::$row[topicid]", ACCESS_READ)) { $total++; } $countres->MoveNext(); // $countres->Close(); } } $result = $dbconn->SelectLimit($query, 50, $startnum-1); if(!$result->EOF) { $output->Text(_STORIES_TOPICS . ': ' . $total . ' ' . _SEARCHRESULTS); $output->SetInputMode(_PNH_VERBATIMINPUT); // Rebuild the search string from previous information $url = "modules.php?op=modload&name=Search&file=index&action=search&active_stories=1&stories_author=".$stories_author; if (isset($stories_cat) && $stories_cat) { foreach($stories_cat as $v) { $url .= "&stories_cat%5B%5D=$v"; } } if (isset($stories_topics) && $stories_topics){ foreach($stories_topics as $v) { $url .= ("&stories_topics%5B%5D=$v"); } } $url .= "&bool=".$bool; if (isset($q)) { $url .= "&q=".$q; } $output->Text(""); $output->Linebreak(4); // Munge URL for template $urltemplate = $url . "&startnum=%%&total=$total"; $output->Pager($startnum, $total, $urltemplate, 50); } else { $output->SetInputMode(_PNH_VERBATIMINPUT); $output->Text(''._SEARCH_NO_STORIES_TOPICS.''); $output->SetInputMode(_PNH_PARSEINPUT); } $output->Linebreak(); return $output->GetOutput(); } ?>