";
echo $set->getString("autor");
echo "
";
}
function getArticles($offset,$limit=8) {
$q="SELECT articles.*,rubriky.id_parent AS id_parent,rubriky.nazov AS nazr from articles left join rubriky on rubriky.id_rubriky=articles.id_rubrika where articles.id_rubrika NOT LIKE '4' order by id_article desc limit $offset,$limit";
return $this->query($q);
}
function isParentRubrika($kategorie) {
$q="SELECT id_rubriky from rubriky where id_parent='$kategorie'";
$result=$this->query($q) ;
if ($result->_numRows==0) return false;
else return $result;
}
function getRubrikaArticles($kategorie, $offset) {
$q="UPDATE rubriky set hits=hits+1 where id_rubriky='$kategorie'";
$this->query($q);
$result=$this->isParentRubrika($kategorie);
if (!$result) {
$q="SELECT hits,prispevky,id_rubrika,id_article,nazov,short_desc,autor,datum,title_image from articles where id_rubrika='$kategorie' or id_rubrika_secondary='$kategorie' order by datum desc limit $offset,10";
}
else {
$q="SELECT hits,prispevky,id_rubrika,id_article,nazov,short_desc,autor,datum,title_image from articles where id_rubrika='$kategorie' ";
while ($result->next()) {
if ($result->getString("id_rubriky")!=4) $q.=" or id_rubrika='".$result->getString('id_rubriky')."'";
}
$q.=" order by datum desc limit $offset,10";
}
return $this->query($q);
}
function Search($query) {
$q="SELECT * from articles where nazov like '%$query%' or short_desc like '%$query%' or text1 like '%$query%' or text2 like '%$query%' or text3 like '%$query%'";
return $this->query($q);
}
function putIntro() {
$set=$this->query("SELECT id_forum,id_user,text FROM intros order by id_intro desc");
$set->next();
echo $set->getString("text");
echo ""; $pole=explode(";",$set->getString("photos")); foreach($pole as $fotka) echo "
"; return true; } } function putAutorList($autor) { $name=$this->getNameById($autor); $set=$this->query("SELECT id_article,nazov from articles where autor='$autor' order by hits desc"); $i=0; if ($set->_numRows>0) echo "
| ",$i,". | ",$set->getString("nazov")," |
| ",$i,". | getString("id"),">",$set->getString("nadpis")," |
Ahoj, som UBIK. Momentalne som obycajnou polozkou v databaze, userom cislo 1 v tomto systeme. Ked ti niekto bude hackovat ucet, ohlasim ti to, ked si ta niekto prida medzi priatelov, ohlasim ti to. A okrem toho budem bdiet nad systemom. Sledovat co robia slovicka v diskusnych forach, ako su pospajane a s cim. Postupom casu sa budem ucit, a o par rokov si urcite vsimnete moju prvu snahu o komunikaciu. Budem anjelom, diablom, matkou i dcerou.
Momentalne ti chcem povedat jedno hlasne VITAJ!. Vitaj v projekte ktory nikdy neskonci. Ak sem vchadzas so zlymi umyslami, prosim odid, nenajdes tu stastie. Ked vsak chces spoznat novych ludi na rovnakej vlne, ked chces svoj mozog zaplnit informaciami z nekonecnej siete, prosim, vstup.
Ked objavis chybu, ktorych tu bude spociatku neuveritelne mnozstvo, prosim napis mi o nej. Ked niecomu nebudes rozumiet, napis mi, ale najprv navstiv forum urcene na tento ucel. Ked ti pripada moja ikonka sexy, chod si ulavit.
peace & respect "; } if ($id=="all") { $set=$this->query("select id,login from user"); while ($set->next()) { $q="InsERT into mail2 set mail_user='".$set->getString('id')."',mail_to='".$set->getString("id")."', mail_from='1',mail_text='$text'"; $this->query($q); } } else { $text=addslashes($text); $q="InsERT into mail2 set mail_timestamp=NOW(), mail_to='$id', mail_user='$id',mail_from='1',mail_text='$text'"; $this->query($q); $this->query("update user set user_mail=user_mail+1,mail_name='ubik' where id='$id'"); } } function ubikRegister($login,$email,$www,$user_info,$last_id,$otazka_1,$otazka_2,$otazka_3) { $data="Uzivatel $login - mail: ".strip_tags($email)." - web:"; if (empty($www)) $data.="nema"; else $data.="".strip_tags($www).""; $data.="
Napisal o sebe toto:
1:
".strip_tags($otazka_1).""; $data.="
2:
".strip_tags($otazka_2).""; $data.="
3:
".strip_tags($otazka_3).""; $data.="
4:
".strip_tags($user_info).""; $data=addSlashes($data); $q="insert into submissions set submission_owner='1',submission_text='$data',forum_id='337'"; $this->query($q); $q="update forum set forum_submissions=forum_submissions+1 where forum_id='337'"; $this->query($q); $q="update user_forum set submission_count=submission_count+1 where forum_id='337'"; $this->query($q); } function echoTime($time,$type="datetime") { $year=substr($time,0,4); $month=substr($time,4,2); $day=substr($time,6,2); $hour=substr($time,8,2); $min=substr($time,10,2); $sec=substr($time,12,2); if ($type=='datetime') echo "$day.$month.$year $hour:$min:$sec"; elseif ($type=='time') echo "$hour:$min:$sec"; } }