function search() {
global $mkportals, $DB, $mklib, $Skin, $mklib_board;
$maintit = "{$mklib->lang['re_searchf']}";
$cselect.= "<option value=\"1\">{$mklib->lang['re_title']}</option>\n";
$cselect.= "<option value=\"2\">{$mklib->lang['re_description']}</option>\n";
$cselect.= "<option value=\"3\">{$mklib->lang['re_revtext']}</option>\n";
$cselect.= "<option value=\"4\">Author</option>\n";
$content .= "
<tr>
<td class=\"modulex\">
<form action=\"index.php?ind=reviews&op=result_search\" name=\"search\" method=\"post\">
<table width=\"100%\" border=\"0\">
<tr>
<td>{$mklib->lang['re_searchin']}:</td>
<td>
<select class=\"bgselect\" name=\"campo\" size=\"1\">
{$cselect}
</select>
</td>
</tr>
<tr>
<td width=\"5%\">{$mklib->lang['re_searchtext']}</td>
<td width=\"95%\">
<input type=\"text\" name=\"testo\" size=\"52\" class=\"bgselect\" />
</td>
</tr>
<tr>
<td colspan=\"2\"><input type=\"submit\" value=\"{$mklib->lang['re_searchstart']}\" class=\"bgselect\" /></td>
</tr>
</table>
</form>
</td>
</tr>
";
$navbar = "<a href=\"index.php?ind=reviews\">{$mklib->lang['re_ptitle2']}</a>-><a href=\"#\">{$mklib->lang['re_searchf']}</a>";
$stat = $this->retrieve_stat();
$toolbar = "";
$utonline = $mklib_board->get_active_users("reviews");
$output = $this->tpl->review_show($navbar, $maintit, $content, $submit, $stat, $toolbar, $show_pages, $utonline);
$blocks = $Skin->view_block("{$mklib->lang['re_pagetitle']}", $output);
$mklib->printpage("1", "1", "{$mklib->lang['re_pagetitle']}", $blocks);
}
function result_search() {
global $mkportals, $DB, $mklib, $Skin, $mklib_board;
$campo = $mkportals->input['campo'];
$testo = $mkportals->input['testo'];
$campo = "title";
if ($mkportals->input['campo'] == 2) {
$campo = "description";
}
if ($mkportals->input['campo'] == 3) {
$campo = "review";
}
if ($mkportals->input['campo'] == 4) {
$campo = "Author";
}
if (!$testo) {
$message = "{$mklib->lang['re_reqstring']}";
$mklib->error_page($message);
exit;
}
$navbar = "<a href=\"index.php?ind=reviews\">{$mklib->lang['re_ptitle2']}</a>-><a href=\"#\">{$mklib->lang['re_searchresult']}</a>";
$maintit = "{$mklib->lang['re_searchresult']}";
$content = $this->tpl->row_main_entries();
$query = $DB->query( "SELECT id, title, description, click, date, trate, author FROM mkp_reviews where $campo LIKE '%$testo%'");
while( $row = $DB->fetch_row($query) ) {
$iden = $row['id'];
$name = $row['title'];
$description = $row['description'];
$trate = $row['trate'];
$click = $row['click'];
$data = $mklib->create_date($row['date'], "short");
$name ="<a href=\"index.php?ind=reviews&op=entry_view&iden=$iden\">$name</a>";
$content .= $this->tpl->row_main_entries_content($name, $trate, $description, $click, $data);
}
if (!$name) {
$content = "<td align=\"center\" width=\"100%\" class=\"modulecell\"><br />{$mklib->lang['re_searchnot']}<br /><br /><br /></td>";
}
$submit = "";
$stat = $this->retrieve_stat();
$toolbar = "";
$utonline = $mklib_board->get_active_users("reviews");
$output = $this->tpl->review_show($navbar, $maintit, $content, $submit, $stat, $toolbar, $show_pages, $utonline);
$blocks = $Skin->view_block("{$mklib->lang['re_pagetitle']}", $output);
$mklib->printpage("1", "1", "{$mklib->lang['re_pagetitle']}", $blocks);
}
