X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=inc%2Fkyberia.inc;fp=inc%2Fkyberia.inc;h=542836db20e34c1c70c34cdb2f1b6767e9126e88;hb=bc13d5d6e1834068f8b690c32bba114e352dacdd;hp=0000000000000000000000000000000000000000;hpb=07269e54b4e79c0a5e77d8f378cf0849bd8276e5;p=mirrors%2FKyberia-bloodline.git
diff --git a/inc/kyberia.inc b/inc/kyberia.inc
new file mode 100644
index 0000000..542836d
--- /dev/null
+++ b/inc/kyberia.inc
@@ -0,0 +1,600 @@
+debug=true;
+ else $this->debug=false;
+ $this->CLASS_DATABASE();
+}
+
+
+function getJSbyId($id) {
+ $q="SELECT prispevky.telo AS telo,prispevky.jmeno AS jmeno,prispevky.*,dennik.nadpis AS nadpis, dennik.id AS node_id from prispevky left join dennik on dennik.id_diskuse=prispevky.id_diskuse where id_prispevku='$id'";
+ return $this->query($q);
+
+}
+
+function getNewJS($id,$last_login) {
+$q="SELECT prispevky.telo AS telo,prispevky.jmeno AS jmeno,prispevky.*,dennik.nadpis AS nadpis, dennik.id AS node_id from prispevky left join dennik on dennik.id_diskuse=prispevky.id_diskuse left join user on prispevky.jmeno=user.login where dennik.autor='$id' AND prispevky.vlozeno>'$last_login'";
+ return $this->query($q);
+
+}
+
+
+function getNewSubmissions($id_diskuse,$time) {
+ $q="SELECT count(*) as pocet from prispevky where id_diskuse='$id_diskuse' and TO_DAYS(vlozeno) > TO_DAYS('$time')";
+ $set=$this->query($q);
+ $set->next();
+ return $set->getString('pocet');
+}
+
+function addDennik($dennik,$nadpis,$dennik_type="journaux") {
+ global $user_id;
+ if (strlen($dennik)<10) {
+ echo "dennik je moc kratky";
+ return false;
+ }
+ $dennik=str_replace("\n","
",$dennik);
+ $dennik = preg_replace("/(http:\/\/\S+?|ftp:\/\/\S+?)([\.,:_\*]?\s)/", "$1$2", $dennik);
+ $q="insert into dennik set nadpis='$nadpis',zapis='$dennik',autor='$user_id',dennik_type='$dennik_type',datum=NOW()";
+
+ $this->update($q);
+ return true;
+}
+
+function unserial() {
+$tmp=getFile1("/home/hromi1/kyberia/images/albums/albumdb.dat");
+$albums=unserialize($tmp);
+foreach($albums as $album){
+ $file="/home/hromi1/kyberia/images/albums/".$album."/album.dat";
+ $tmp=getFile1($file);
+ $photos=unserialize($tmp);
+ $q="INSERT into albums set title=".$photos->album[fields][title];
+ $q.=",hits=".$photos->album[fields][clicks];
+ $q.=",name=".$photos->album[fields][name];
+ $this->update($q);
+
+ echo "
";
+}
+}
+
+function updateUser($id,$pole) {
+ $pole['user_info']=str_replace("\n","
",$pole['user_info']);
+ $q="UPDATE user set ";
+ if (strlen($password1)>4) {
+ if ($password1==$password2) $q.="password='".md5($password1)."'";
+ else {
+ echo "Passwordy niesu rovnake.";
+ return false;
+ }
+ }
+ $q.=" user_info='".$pole['user_info']."',email='".$pole['email']."' where id='$id'";
+ $this->query($q);
+}
+
+
+function showForumList($kat) {
+ global $user_id;
+ global $action;
+ $q="SELECT user_forum.user_bookmark as user_bookmark,user_forum.submission_count,user.login,forum.* from forum 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_category='$kat'";
+ $q.=" order by forum_id desc ";
+ $forumset=$this->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 ") --> ";
+ if ($forumset->getString('user_bookmark')=='1') echo "unbook";
+ else echo "book";
+ global $category_parent;
+// if ($user_id==38 and !$category_parent) echo "
";
+ }
+ echo "
";
+}
+
+function substanceIt($user_name,$message_text,$forum_name) {
+ $message_text= stripSlashes("$user_name [forum: $forum_name] --> $message_text\r\n");
+ $fp = fsockopen ("node.kyberia.sk", 2323, $errno, $errstr,30);
+ if (!$fp) {
+ echo "$errstr ($errno)
\n";
+ } else {
+ fgets($fp,2);
+ fputs ($fp, "hromi\r\n");
+ fputs ($fp,"ub1k23\r\n.say $message_text");
+ fclose ($fp);
+ }
+
+}
+
+function updateUserData($user_id) {
+ global $action;
+ global $node_id;
+ global $forum;
+ global $node_id;
+ global $dennik;
+ global $article;
+ global $userinfo;
+ global $id;
+ if ($action=="forum") $q="update session set user_action_name='".addslashes($forum['forum_name'])."',user_action_id='".$forum['forum_id']."', user_action='$action' where user_id='".$user_id."'";
+ elseif ($action=="journaux" && $node_id!="") $q="update session set user_action_name=' ".addslashes($dennik['nadpis'])."',user_action_id='".$node_id."', user_action='$action' where user_id='".$user_id."'";
+ elseif ($action=="article" && $node_id!="") $q="update session set user_action_name=' ".addslashes($article['nazov'])."',user_action_id='".$node_id."', user_action='$action' where user_id='".$user_id."'";
+ elseif ($userinfo) $q="update session set user_action_name=' ".addslashes($userinfo['login'])."',user_action_id='".$node_id."', user_action='$action' where user_id='".$user_id."'";
+ else $q="update session set user_action='$action', user_action_name='', user_action_id='' where user_id='".$user_id."'";
+ $set=$this->query($q);
+
+}
+
+function isLogged() {
+ $this->query('delete from session where user_idlequery($q);
+ if ($set->_numRows==0) return false;
+ else {
+ $set->next();
+ return $set->getRecord();
+ }
+}
+
+
+function logOff() {
+ $kybersession=$_COOKIE['kybersession'];
+ $this->query("DELETE FROM session where session like '$kybersession'");
+}
+
+
+function setRefererStats() {
+ global $HTTP_REFERER;
+ global $REMOTE_ADDR;
+ global $id;
+ $this->query("INSERT INTO referers set referer='$HTTP_REFERER',adresa='$REMOTE_ADDR',id='$id'");
+}
+
+function getNameById($id) {
+ $q="SELECT login from user where id='$id'";
+ $set=$this->query($q);
+ $set->next();
+ return $set->getString("login");
+}
+
+function createDennikDiskuse($id_dennik,$id_diskuse) {
+ $q="UPDATE dennik set id_diskuse='$id_diskuse' where id='$id_dennik'";
+ $this->query($q);
+}
+
+function getTopGalleries() {
+ return $this->query("SELECT * FROM albums order by hits desc limit 10");
+}
+
+function getLastGalleries() {
+ return $this->query("SELECT * FROM albums order by id_Album desc");
+}
+
+function getLoginByDennik($id) {
+ return $this->query("SELECT autor from dennik where id='$id'");
+}
+
+function getRandomDennik($last=3) {
+ $set=$this->query("SELECT id from dennik where dennik_type='journaux' and type='public' order by id desc limit $last");
+ while ($set->next()) $id[]=$set->getString("id");
+ if ($this->debug) print_r($id);
+ $randomid=rand(0,$last-1);
+ return $this->getDennik($id[$randomid],true);
+// return $this->getDennik(3183,true);
+}
+
+function getDennik($id,$random=false) {
+ if (!$random) {
+ $q="UPDATE dennik set hits=hits+1 where id='$id'";
+ $this->query($q);
+ }
+ $q="SELECT DATE_FORMAT(dennik.datum,'%k:%i:%s %e.%c.%Y') as cas, dennik.autor AS autor,dennik.id AS idarticle,dennik.*,user.login AS autorname from dennik left join user on user.id=dennik.autor where dennik.id='$id'";
+
+ return $this->query($q);
+}
+
+function getDennikByUSer($id_user,$offset=0) {
+ $q="SELECT * from dennik where autor='$id_user' order by id desc";
+ return $this->query($q);
+}
+
+function getNewestDennik($limit=5,$offset=0,$dennik_type="journaux") {
+ $q="SELECT dennik.*,user.login AS autorname from dennik left join user on user.id=dennik.autor where dennik_type='$dennik_type' order by id DESC LIMIT $offset,$limit";
+
+ return $this->query($q);
+}
+
+function getAllUsers() {
+ return $this->query("SELECT * from user order by login");
+}
+
+function getDennikAuthors() {
+ return $this->query("select distinct dennik.autor as autor,user.login as login from dennik left join user on user.id=dennik.autor order by login");
+}
+
+function getMostDiscussed() {
+ return $this->query("SELECT nazov,id_article,prispevky from articles where id_rubrika>4 OR id_rubrika<4 order by prispevky desc limit 10");
+}
+
+function putMostRead($kategorie="",$limit=10) {
+ if ($kategorie=="") return $this->query("SELECT nazov,id_article,hits from articles ORDER by hits DESC LIMIT $limit");
+ else {
+ $result=$this->isParentRubrika($kategorie);
+ if (!$result) {
+ $q="SELECT hits,id_rubrika,id_article,nazov from articles where id_rubrika='$kategorie' or id_rubrika_secondary='$kategorie' order by hits desc limit 10";
+ }
+ else {
+ $q="SELECT hits,id_rubrika,id_article,nazov 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 hits desc limit 10";
+ }
+ return $this->query($q);
+ }
+}
+
+function listRubrikyArray() {
+ $q="SELECT * FROM rubriky";
+ $set=$this->query($q);
+ while($set->next()) {
+ $data[]=$set->getString("nazov");
+ }
+ return $data;
+}
+
+
+function showMailInfo() {
+ global $PHP_SELf;
+ echo "mailinfo?";
+ echo "";
+}
+
+
+function addMailinfo($email) {
+
+ $this->query("INSERT INTO mailinfo set email='$email',datetime=NOW()");
+}
+
+
+function listArticles() {
+ $q="SELECT *.articles,id_parent.rubriky AS id_parent,nazov.rubriky AS nazov FROM articles LEFT JOIN rubriky ON id_rubriky.rubriky=id_rubriky=articles order by datum desc";
+
+ return($this->query($q));
+}
+
+/*
+function listRubrikyArray() {
+ $q="SELECT * FROM skins";
+ $set=$this->query($q);
+ while($set->next()) {
+ $data[]=$set->getString("nazov");
+ }
+ return $data;
+}
+*/
+function listSkinArray() {
+ $q="SELECT nazov FROM skins";
+ $set=$this->query($q);
+ while($set->next()) {
+ $data[]=$set->getString("nazov");
+ }
+ return $data;
+}
+
+function getRubrikaById($id_rubriky) {
+ $q="SELECT nazov from rubriky where id_rubriky=$id_rubriky";
+ $set=$this->query($q);
+ $set->next();
+ return $set->getString('nazov');
+}
+
+function getArticle($id) {
+ $q="Update articles set hits=hits+1 where id_article='$id'";
+ $this->query($q);
+ $q="SELECT * from articles where id_article=$id";
+ return $this->query($q);
+}
+
+function getArticleData($id) {
+ $q="SELECT * from articles where id_article=$id";
+ return $this->query($q);
+}
+
+function listMainRubrikyArray() {
+ $q="SELECT * FROM rubriky where id_parent=1";
+ $set=$this->query($q);
+ while($set->next()) {
+ $data[]=$set->getString("nazov");
+ }
+ return $data;
+}
+
+function getTitle() {
+
+ $set=$this->query("SELECT title from titles where id_title=1");
+ $set->next();
+ echo $set->getString("title");
+
+}
+
+function getOutro() {
+ $set=$this->query("SELECT id_outro from outro order by id_outro desc limit 1");
+ $set->next();
+ $count=$set->getString('id_outro');
+ $id=rand(1,$count);
+ $set=$this->query("SELECT outro,autor from outro where id_outro='$id'");
+ $set->next();
+ echo $set->getString("outro");
+ echo "
";
+ 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 "
(",$set->getString("id_user"),")
";
+}
+
+function showMdmaList() {
+ $set=$this->query("SELECT nazov,id_article from articles where id_rubrika=4 order by nazov");
+ echo "";
+}
+
+function showDennikTypeList() {
+ $set=$this->query("SELECT distinct dennik_type from denniky");
+ echo "";
+}
+
+function showArticleList() {
+ global $id;
+ $set=$this->query("SELECT nazov,id_article,hits from articles where id_rubrika>4 OR id_rubrika<4 order by hits desc");
+ echo "";
+}
+
+function showBookList() {
+ $set=$this->query("SELECT nazov,id_article,hits from articles where id_rubrika=27 order by nazov");
+ echo "";
+}
+ function showForumArticleList() {
+ $set=$this->query("select articles.prispevky as pocet, articles.nazov,articles.id_article from articles where prispevky>0 order by pocet desc;");
+ echo "";
+}
+
+function putGallery($id) {
+ $q="SELECT photos,gallery FROM articles where id_article=$id";
+
+ $set=$this->query($q);
+ $set->next();
+ $gallery=$set->getString("gallery");
+ if ($gallery=="") return false;
+ else {
+
+ echo "fotky z galerie
";
+ $pole=explode(";",$set->getString("photos"));
+ foreach($pole as $fotka) echo "![](http://kyberia.sk/images/albums/$gallery/$fotka.thumb.jpg)
";
+ 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 "clanky:";
+ echo "";
+}
+
+function putDennikAutorList($autor) {
+ $name=$this->getNameById($autor);
+ $set=$this->query("SELECT nadpis,id from dennik where autor='$autor' and nadpis not like '' order by hits desc limit 10");
+ $i=0;
+ if ($set->_numRows>0) echo "top denniky:";
+ echo "";
+}
+
+function putRubrikaDesc($kat) {
+ $set=$this->query("Select description from rubriky where id_rubriky=$kat");
+ $set->next();
+ echo $set->getString("description");
+}
+
+function putTitleImage($id_rubrika) {
+
+ $q="SELECT obrazok from rubriky where id_rubriky='$id_rubrika'";
+ $set=$this->query($q);
+ $set->next();
+ echo $set->getString('obrazok');
+}
+
+
+function showForm($login='',$email='',$web='',$info='') {
+ include("form.inc");
+ $this=new HTML_Form($PHP_SELF,"POST","","multipart/form-data",true);
+ $this->addText("login","Prihlasovacie meno:",$login);
+ $this->addPassword("password1","Heslo:","",10);
+ $this->addPassword("password2","Heslo pre overenie:","",10);
+ $this->addText("email:","Emailova adresa",$email);
+ $this->addText("web","Stranka:",$web);
+ $this->addSelect("skin","Skin:",$kyberia->listSkinArray());
+ $this->addFile("image","Obrazok:");
+ $this->addTextarea("info","Dodatocne informacie",$info);
+ $this->addSubmit("submit","Zaregistruj sa!","");
+ $this->addHidden("sent","ok");
+ $this->display();
+
+}
+
+function ubikMail($id="all",$text="welcome") {
+ if ($text=="welcome") {
+ $text="
+
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";
+}
+
+}
\ No newline at end of file