";
$q="SELECT forum_info.forum_info,user_forum.submission_count,user.login,forum.* from forum left join forum_info on forum_info.forum_id=forum.forum_id left join user on forum.forum_owner=user.id left join user_forum on (forum.forum_id=user_forum.forum_id and user_forum.user_id='$user_id')";
$q.=" where (forum_name like '%$query%' or forum_info like '%$query%')";
$q.=" order by forum_id desc ";
$forumset=$kyberia->query($q);
while ($forumset->next()) {
echo " ",$forumset->getString('forum_name')," (".$forumset->getString('login')." :: ".$forumset->getString('forum_submissions')." submissionz ";
if ($forumset->getString('submission_count')) echo "- ".$forumset->getString('submission_count')." NEW";
echo ") ";
}
}
elseif ($_POST['type']=='user') {
$q="SELECT * from user";
$q.=" where login like '%$query%'";
$q.=" order by login";
$forumset=$kyberia->query($q);
echo "
na.na.na.siel[siel{siel}] som tychto u.u.uzivatelov
";
while ($forumset->next()) {
echo " ",$forumset->getString('login'),"";
}
}
elseif ($_POST['type']=='journaux') {
$q="SELECT dennik.*,user.login from dennik left join user on user.id=dennik.autor";
$q.=" where nadpis like '%$query%'";
$q.=" order by id desc";
$dennikset1=$kyberia->query($q);
if ($dennikset1->getNumRows()) {
echo "
\"$query\" sa vyskytuje v nadpisoch tychto dennikov
";
while ($dennikset1->next()) {
echo " ",$dennikset1->getString('nadpis')," (",$dennikset1->getString('login')," :: ",$dennikset1->getString('hits')," hitz )";
}
}
$q="SELECT dennik.*,user.login from dennik left join user on user.id=dennik.autor";
$q.=" where zapis like '%$query%'";
$q.=" order by id desc";
$dennikset2=$kyberia->query($q);
if ($dennikset2->getNumRows()) {
echo "
\"$query\" sa vyskytuje v texte tychto dennikov
";
while ($dennikset2->next()) {
echo " ",$dennikset2->getString('nadpis')," (",$dennikset2->getString('login')," :: ",$dennikset2->getString('hits')," hitz )";
}
}
}
if ($_POST['type']=='article') {
if ($query=="") echo "
Nezadali ste ziadne slovo na vyhladavanie!!
";
else { $clanky=$kyberia->Search($query);
if ($clanky->_numRows==0) echo "
Zadane slovo $query sa nevyskytuje v ziadnom clanku!
";
else {
echo "
Slovo $query sa vyskytuje v ",$clanky->_numRows,". clankoch!