Kyberia v1.0
[mirrors/Kyberia-bloodline.git] / inc / kyberia.inc
... / ...
CommitLineData
1<?php
2
3
4function getFile1($fname) {
5 $tmp = "";
6
7 if ($fd = fopen($fname, "r")) {
8 while (!feof($fd)) {
9 $tmp .= fread($fd, 65536);
10 }
11 fclose($fd);
12 }
13 return $tmp;
14}
15
16include("diskusdesign.inc");
17
18class CLASS_KYBERIA extends CLASS_DATABASE {
19
20var $RubrikaImageDir="/images/rubriky/";
21var $TitleImageDir="/images/clanky/";
22var $debug;
23
24var $UserImages="/icons/";
25function CLASS_KYBERIA() {
26 global $admin;
27 if ($admin==yes) $this->debug=true;
28 else $this->debug=false;
29 $this->CLASS_DATABASE();
30}
31
32
33function getJSbyId($id) {
34 $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'";
35 return $this->query($q);
36
37}
38
39function getNewJS($id,$last_login) {
40$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'";
41 return $this->query($q);
42
43}
44
45
46function getNewSubmissions($id_diskuse,$time) {
47 $q="SELECT count(*) as pocet from prispevky where id_diskuse='$id_diskuse' and TO_DAYS(vlozeno) > TO_DAYS('$time')";
48 $set=$this->query($q);
49 $set->next();
50 return $set->getString('pocet');
51}
52
53function addDennik($dennik,$nadpis,$dennik_type="journaux") {
54 global $user_id;
55 if (strlen($dennik)<10) {
56 echo "dennik je moc kratky";
57 return false;
58 }
59 $dennik=str_replace("\n","<br>",$dennik);
60 $dennik = preg_replace("/(http:\/\/\S+?|ftp:\/\/\S+?)([\.,:_\*]?\s)/", "<a href=\"$1\">$1</a>$2", $dennik);
61 $q="insert into dennik set nadpis='$nadpis',zapis='$dennik',autor='$user_id',dennik_type='$dennik_type',datum=NOW()";
62
63 $this->update($q);
64 return true;
65}
66
67function unserial() {
68$tmp=getFile1("/home/hromi1/kyberia/images/albums/albumdb.dat");
69$albums=unserialize($tmp);
70foreach($albums as $album){
71 $file="/home/hromi1/kyberia/images/albums/".$album."/album.dat";
72 $tmp=getFile1($file);
73 $photos=unserialize($tmp);
74 $q="INSERT into albums set title=".$photos->album[fields][title];
75 $q.=",hits=".$photos->album[fields][clicks];
76 $q.=",name=".$photos->album[fields][name];
77 $this->update($q);
78
79 echo "<br><br><br>";
80}
81}
82
83function updateUser($id,$pole) {
84 $pole['user_info']=str_replace("\n","<br>",$pole['user_info']);
85 $q="UPDATE user set ";
86 if (strlen($password1)>4) {
87 if ($password1==$password2) $q.="password='".md5($password1)."'";
88 else {
89 echo "Passwordy niesu rovnake.";
90 return false;
91 }
92 }
93 $q.=" user_info='".$pole['user_info']."',email='".$pole['email']."' where id='$id'";
94 $this->query($q);
95}
96
97
98function showForumList($kat) {
99 global $user_id;
100 global $action;
101 $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')";
102 $q.=" WHERE forum_category='$kat'";
103 $q.=" order by forum_id desc ";
104 $forumset=$this->query($q);
105 while ($forumset->next()) {
106 echo "<br>&nbsp;&nbsp;&nbsp;&nbsp;<a href='?action=forum&forum_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a>&nbsp;&nbsp;(".$forumset->getString('login')."&nbsp;&nbsp;::&nbsp;&nbsp;".$forumset->getString('forum_submissions')."&nbsp;submissionz ";
107 if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>";
108 echo ") --> ";
109 if ($forumset->getString('user_bookmark')=='1') echo "<a href='?action=$action&kat=$kat&book=0&forum_id=",$forumset->getString('forum_id'),"'>unbook</a>";
110 else echo "<a href='?action=$action&kat=$kat&book=1&forum_id=",$forumset->getString('forum_id'),"'>book</a>";
111 global $category_parent;
112// if ($user_id==38 and !$category_parent) echo "<form action='?action=forumlist'><input type='text' name='forum_category'><input type='hidden' name='forumid' value='",$forumset->getString('forum_id'),"'><input type=submit value='change' name='category'></form>";
113 }
114 echo "<br>";
115}
116
117function substanceIt($user_name,$message_text,$forum_name) {
118 $message_text= stripSlashes("$user_name [forum: $forum_name] --> $message_text\r\n");
119 $fp = fsockopen ("node.kyberia.sk", 2323, $errno, $errstr,30);
120 if (!$fp) {
121 echo "$errstr ($errno)<br>\n";
122 } else {
123 fgets($fp,2);
124 fputs ($fp, "hromi\r\n");
125 fputs ($fp,"ub1k23\r\n.say $message_text");
126 fclose ($fp);
127 }
128
129}
130
131function updateUserData($user_id) {
132 global $action;
133 global $node_id;
134 global $forum;
135 global $node_id;
136 global $dennik;
137 global $article;
138 global $userinfo;
139 global $id;
140 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."'";
141 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."'";
142 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."'";
143 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."'";
144 else $q="update session set user_action='$action', user_action_name='', user_action_id='' where user_id='".$user_id."'";
145 $set=$this->query($q);
146
147}
148
149function isLogged() {
150 $this->query('delete from session where user_idle<date_sub(NOW(),INTERVAL 1 HOUR)');
151 $kybersession=$_COOKIE['kybersession'];
152 $q="SELECT session.*,user.user_mail as user_mail,user.mail_name as mail_name, user.user_active_icons as user_active_icons, user.friends_serial as user_friends_serial, user.user_icons_in_forum from session left join user on user.id=session.user_id where session='$kybersession'";
153 $set=$this->query($q);
154 if ($set->_numRows==0) return false;
155 else {
156 $set->next();
157 return $set->getRecord();
158 }
159}
160
161
162function logOff() {
163 $kybersession=$_COOKIE['kybersession'];
164 $this->query("DELETE FROM session where session like '$kybersession'");
165}
166
167
168function setRefererStats() {
169 global $HTTP_REFERER;
170 global $REMOTE_ADDR;
171 global $id;
172 $this->query("INSERT INTO referers set referer='$HTTP_REFERER',adresa='$REMOTE_ADDR',id='$id'");
173}
174
175function getNameById($id) {
176 $q="SELECT login from user where id='$id'";
177 $set=$this->query($q);
178 $set->next();
179 return $set->getString("login");
180}
181
182function createDennikDiskuse($id_dennik,$id_diskuse) {
183 $q="UPDATE dennik set id_diskuse='$id_diskuse' where id='$id_dennik'";
184 $this->query($q);
185}
186
187function getTopGalleries() {
188 return $this->query("SELECT * FROM albums order by hits desc limit 10");
189}
190
191function getLastGalleries() {
192 return $this->query("SELECT * FROM albums order by id_Album desc");
193}
194
195function getLoginByDennik($id) {
196 return $this->query("SELECT autor from dennik where id='$id'");
197}
198
199function getRandomDennik($last=3) {
200 $set=$this->query("SELECT id from dennik where dennik_type='journaux' and type='public' order by id desc limit $last");
201 while ($set->next()) $id[]=$set->getString("id");
202 if ($this->debug) print_r($id);
203 $randomid=rand(0,$last-1);
204 return $this->getDennik($id[$randomid],true);
205// return $this->getDennik(3183,true);
206}
207
208function getDennik($id,$random=false) {
209 if (!$random) {
210 $q="UPDATE dennik set hits=hits+1 where id='$id'";
211 $this->query($q);
212 }
213 $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'";
214
215 return $this->query($q);
216}
217
218function getDennikByUSer($id_user,$offset=0) {
219 $q="SELECT * from dennik where autor='$id_user' order by id desc";
220 return $this->query($q);
221}
222
223function getNewestDennik($limit=5,$offset=0,$dennik_type="journaux") {
224 $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";
225
226 return $this->query($q);
227}
228
229function getAllUsers() {
230 return $this->query("SELECT * from user order by login");
231}
232
233function getDennikAuthors() {
234 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");
235}
236
237function getMostDiscussed() {
238 return $this->query("SELECT nazov,id_article,prispevky from articles where id_rubrika>4 OR id_rubrika<4 order by prispevky desc limit 10");
239}
240
241function putMostRead($kategorie="",$limit=10) {
242 if ($kategorie=="") return $this->query("SELECT nazov,id_article,hits from articles ORDER by hits DESC LIMIT $limit");
243 else {
244 $result=$this->isParentRubrika($kategorie);
245 if (!$result) {
246 $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";
247 }
248 else {
249 $q="SELECT hits,id_rubrika,id_article,nazov from articles where id_rubrika='$kategorie' ";
250 while ($result->next()) {
251 if ($result->getString("id_rubriky")!=4) $q.=" or id_rubrika='".$result->getString('id_rubriky')."'";
252 }
253 $q.=" order by hits desc limit 10";
254 }
255 return $this->query($q);
256 }
257}
258
259function listRubrikyArray() {
260 $q="SELECT * FROM rubriky";
261 $set=$this->query($q);
262 while($set->next()) {
263 $data[]=$set->getString("nazov");
264 }
265 return $data;
266}
267
268
269function showMailInfo() {
270 global $PHP_SELf;
271 echo "<center>mailinfo?</center>";
272 echo "<form action =$PHP_SELF method=post>";
273 echo "<input type=text name=mailinfo size=15>";
274 echo "<br><center><select name=kat>";
275 $pole=$this->listRubrikyArray();
276 for ($i=0;IsSet($pole[$i]);$i++) {
277 echo "<option value=$i>$i</option>";
278 }
279 echo "</select></center>";
280 echo "</form>";
281}
282
283
284function addMailinfo($email) {
285
286 $this->query("INSERT INTO mailinfo set email='$email',datetime=NOW()");
287}
288
289
290function listArticles() {
291 $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";
292
293 return($this->query($q));
294}
295
296/*
297function listRubrikyArray() {
298 $q="SELECT * FROM skins";
299 $set=$this->query($q);
300 while($set->next()) {
301 $data[]=$set->getString("nazov");
302 }
303 return $data;
304}
305*/
306function listSkinArray() {
307 $q="SELECT nazov FROM skins";
308 $set=$this->query($q);
309 while($set->next()) {
310 $data[]=$set->getString("nazov");
311 }
312 return $data;
313}
314
315function getRubrikaById($id_rubriky) {
316 $q="SELECT nazov from rubriky where id_rubriky=$id_rubriky";
317 $set=$this->query($q);
318 $set->next();
319 return $set->getString('nazov');
320}
321
322function getArticle($id) {
323 $q="Update articles set hits=hits+1 where id_article='$id'";
324 $this->query($q);
325 $q="SELECT * from articles where id_article=$id";
326 return $this->query($q);
327}
328
329function getArticleData($id) {
330 $q="SELECT * from articles where id_article=$id";
331 return $this->query($q);
332}
333
334function listMainRubrikyArray() {
335 $q="SELECT * FROM rubriky where id_parent=1";
336 $set=$this->query($q);
337 while($set->next()) {
338 $data[]=$set->getString("nazov");
339 }
340 return $data;
341}
342
343function getTitle() {
344
345 $set=$this->query("SELECT title from titles where id_title=1");
346 $set->next();
347 echo $set->getString("title");
348
349}
350
351function getOutro() {
352 $set=$this->query("SELECT id_outro from outro order by id_outro desc limit 1");
353 $set->next();
354 $count=$set->getString('id_outro');
355 $id=rand(1,$count);
356 $set=$this->query("SELECT outro,autor from outro where id_outro='$id'");
357 $set->next();
358 echo $set->getString("outro");
359 echo "<br><i><div align=right>";
360 echo $set->getString("autor");
361 echo "<br></i></div>";
362}
363
364function getArticles($offset,$limit=8) {
365 $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";
366 return $this->query($q);
367}
368
369function isParentRubrika($kategorie) {
370 $q="SELECT id_rubriky from rubriky where id_parent='$kategorie'";
371 $result=$this->query($q) ;
372 if ($result->_numRows==0) return false;
373 else return $result;
374}
375
376function getRubrikaArticles($kategorie, $offset) {
377 $q="UPDATE rubriky set hits=hits+1 where id_rubriky='$kategorie'";
378 $this->query($q);
379 $result=$this->isParentRubrika($kategorie);
380 if (!$result) {
381 $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";
382 }
383 else {
384 $q="SELECT hits,prispevky,id_rubrika,id_article,nazov,short_desc,autor,datum,title_image from articles where id_rubrika='$kategorie' ";
385 while ($result->next()) {
386 if ($result->getString("id_rubriky")!=4) $q.=" or id_rubrika='".$result->getString('id_rubriky')."'";
387 }
388 $q.=" order by datum desc limit $offset,10";
389 }
390 return $this->query($q);
391}
392
393function Search($query) {
394
395 $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%'";
396 return $this->query($q);
397}
398
399function putIntro() {
400 $set=$this->query("SELECT id_forum,id_user,text FROM intros order by id_intro desc");
401 $set->next();
402 echo $set->getString("text");
403 echo "<br><br><center>(",$set->getString("id_user"),")<br><br></center>";
404}
405
406function showMdmaList() {
407 $set=$this->query("SELECT nazov,id_article from articles where id_rubrika=4 order by nazov");
408 echo "<form>";
409 echo "<select onChange=\"window.location.href=this.options[this.selectedIndex].value\" name=id>";
410 echo "<option value=braw>>----vyber droogu----<</option>";
411 while ($set->next()) {
412 echo "<option value=http://www.kyberia.sk/article.php?id=",$set->getString("id_article"),">",$set->getString("nazov"),"</option>";
413 }
414
415 echo "</select></form>";
416}
417
418function showDennikTypeList() {
419 $set=$this->query("SELECT distinct dennik_type from denniky");
420 echo "<form>";
421 echo "<select onChange=\"window.location.href=this.options[this.selectedIndex].value\" name=id>";
422 echo "<option value=braw>>----vyber droogu----<</option>";
423 while ($set->next()) {
424 echo "<option value=http://www.kyberia.sk/article.php?id=",$set->getString("id_article"),">",$set->getString("nazov"),"</option>";
425 }
426
427 echo "</select></form>";
428}
429
430function showArticleList() {
431 global $id;
432 $set=$this->query("SELECT nazov,id_article,hits from articles where id_rubrika>4 OR id_rubrika<4 order by hits desc");
433 echo "<form action=/article.php method=post>";
434 echo "<select onchange=\"location.href=location.href=this.options[selectedIndex].value\" name=id>";
435 echo "<option>>----vyber clanok----<</option>";
436 $string = new String();
437 while ($set->next()) {
438 echo "<option value=http://www.kyberia.sk/article.php?id=",$set->getString("id_article"),">",$string->cutString($set->getString("nazov"),18),"&nbsp;(",$set->getString("hits"),")</option>";
439 }
440 echo "</select></form>";
441}
442
443function showBookList() {
444 $set=$this->query("SELECT nazov,id_article,hits from articles where id_rubrika=27 order by nazov");
445 echo "<form action=/article.php method=post>";
446 echo "<select onchange=\"location.href=location.href=this.options[selectedIndex].value;\" name=id>";
447 echo "<option>>----vyber knihu----<</option>";
448 $string = new String();
449 while ($set->next()) {
450 echo "<option value=http://www.kyberia.sk/article.php?id=",$set->getString("id_article"),">",$string->cutString($set->getString("nazov"),20),"</option>";
451 }
452 echo "</select></form>";
453}
454 function showForumArticleList() {
455 $set=$this->query("select articles.prispevky as pocet, articles.nazov,articles.id_article from articles where prispevky>0 order by pocet desc;");
456 echo "<form action=/article.php method=post>";
457 echo "<select onchange=\"location.href=location.href=this.options[selectedIndex].value\" name=id>";
458 echo "<option>>----vyber clanok----<</option>";
459 $string = new String();
460 while ($set->next()) {
461 echo "<option value=http://www.kyberia.sk/article.php?id=",$set->getString("id_article"),">",$string->cutString($set->getString("nazov"),20),"(",$set->getString("pocet"),")</option>";
462 }
463 echo "</select></form>";
464}
465
466function putGallery($id) {
467 $q="SELECT photos,gallery FROM articles where id_article=$id";
468
469 $set=$this->query($q);
470 $set->next();
471 $gallery=$set->getString("gallery");
472 if ($gallery=="") return false;
473 else {
474
475 echo "<center>fotky z <a href=http://kyberia.sk/gallery/view_album.php?set_albumName=$gallery>galerie</a></center><br>";
476 $pole=explode(";",$set->getString("photos"));
477 foreach($pole as $fotka) echo "<a href=http://kyberia.sk/gallery/view_photo.php?set_albumName=$gallery&id=$fotka><img src=http://kyberia.sk/images/albums/$gallery/$fotka.thumb.jpg border=0></a><br>";
478 return true;
479 }
480}
481
482function putAutorList($autor) {
483 $name=$this->getNameById($autor);
484
485 $set=$this->query("SELECT id_article,nazov from articles where autor='$autor' order by hits desc");
486 $i=0;
487 if ($set->_numRows>0) echo "<center>clanky:</center>";
488 echo "<table>";
489 while ($set->next()) {
490 ++$i;
491 echo "<tr><td>",$i,".</td><td><a href='".SCRIPT."?action=article&node_id=",$set->getString("id_article"),"'>",$set->getString("nazov"),"</a></td></tr>";
492 }
493 echo "</table>";
494}
495
496function putDennikAutorList($autor) {
497 $name=$this->getNameById($autor);
498 $set=$this->query("SELECT nadpis,id from dennik where autor='$autor' and nadpis not like '' order by hits desc limit 10");
499 $i=0;
500 if ($set->_numRows>0) echo "<center>top denniky:</center>";
501 echo "<table>";
502 while ($set->next()) {
503 ++$i;
504 echo "<tr><td>",$i,".</td><td><a href=?action=journaux&node_id=",$set->getString("id"),">",$set->getString("nadpis"),"</a></td></tr>";
505 }
506 echo "</table>";
507}
508
509function putRubrikaDesc($kat) {
510 $set=$this->query("Select description from rubriky where id_rubriky=$kat");
511 $set->next();
512 echo $set->getString("description");
513}
514
515function putTitleImage($id_rubrika) {
516
517 $q="SELECT obrazok from rubriky where id_rubriky='$id_rubrika'";
518 $set=$this->query($q);
519 $set->next();
520 echo $set->getString('obrazok');
521}
522
523
524function showForm($login='',$email='',$web='',$info='') {
525 include("form.inc");
526 $this=new HTML_Form($PHP_SELF,"POST","","multipart/form-data",true);
527 $this->addText("login","Prihlasovacie meno:",$login);
528 $this->addPassword("password1","Heslo:","",10);
529 $this->addPassword("password2","Heslo pre overenie:","",10);
530 $this->addText("email:","Emailova adresa",$email);
531 $this->addText("web","Stranka:",$web);
532 $this->addSelect("skin","Skin:",$kyberia->listSkinArray());
533 $this->addFile("image","Obrazok:");
534 $this->addTextarea("info","Dodatocne informacie",$info);
535 $this->addSubmit("submit","Zaregistruj sa!","");
536 $this->addHidden("sent","ok");
537 $this->display();
538
539}
540
541function ubikMail($id="all",$text="welcome") {
542 if ($text=="welcome") {
543 $text="
544<br>Ahoj, som UBIK. Momentalne som obycajnou polozkou v databaze, userom cislo 1 v tomto systeme. Ked ti niekto bude hackovat ucet,
545ohlasim ti to, ked si ta niekto prida medzi priatelov, ohlasim ti to. A okrem toho budem bdiet nad systemom. Sledovat
546co robia slovicka v diskusnych forach, ako su pospajane a s cim. Postupom casu sa budem ucit, a o par rokov si urcite vsimnete moju
547prvu snahu o komunikaciu. Budem anjelom, diablom, matkou i dcerou. <br><br>
548Momentalne ti chcem povedat jedno hlasne VITAJ!. Vitaj v projekte ktory nikdy neskonci. Ak sem vchadzas so zlymi umyslami,
549prosim odid, nenajdes tu stastie. Ked vsak chces spoznat novych ludi na rovnakej vlne, ked chces svoj mozog zaplnit
550informaciami z nekonecnej siete, prosim, vstup.<br><br>
551Ked objavis chybu, ktorych tu bude spociatku neuveritelne mnozstvo, prosim napis mi o nej. Ked niecomu nebudes rozumiet, napis
552mi, ale najprv navstiv forum urcene na tento ucel. Ked ti pripada moja ikonka sexy, chod si ulavit.<br><br>
553peace & respect
554 ";
555}
556 if ($id=="all") {
557 $set=$this->query("select id,login from user");
558 while ($set->next()) {
559 $q="InsERT into mail2 set mail_user='".$set->getString('id')."',mail_to='".$set->getString("id")."', mail_from='1',mail_text='$text'";
560 $this->query($q);
561 }
562 }
563 else {
564 $text=addslashes($text);
565 $q="InsERT into mail2 set mail_timestamp=NOW(), mail_to='$id', mail_user='$id',mail_from='1',mail_text='$text'";
566 $this->query($q);
567 $this->query("update user set user_mail=user_mail+1,mail_name='ubik' where id='$id'");
568 }
569
570}
571
572function ubikRegister($login,$email,$www,$user_info,$last_id,$otazka_1,$otazka_2,$otazka_3) {
573 $data="Uzivatel <a href='http://www.kyberia.sk/index.php?action=userinfo&node_id=$last_id'>$login</a> - mail: <a href='mailto:$email'>".strip_tags($email)."</a> - web:";
574 if (empty($www)) $data.="nema";
575 else $data.="<a href='$www'>".strip_tags($www)."</a>";
576 $data.="<br>Napisal o sebe toto:<br>1:<br><i>".strip_tags($otazka_1)."</i>";
577 $data.="<br>2:<br><i>".strip_tags($otazka_2)."</i>";
578 $data.="<br>3:<br><i>".strip_tags($otazka_3)."</i>";
579 $data.="<br>4:<br><i>".strip_tags($user_info)."</i>";
580 $data=addSlashes($data);
581 $q="insert into submissions set submission_owner='1',submission_text='$data',forum_id='337'";
582 $this->query($q);
583 $q="update forum set forum_submissions=forum_submissions+1 where forum_id='337'";
584 $this->query($q);
585 $q="update user_forum set submission_count=submission_count+1 where forum_id='337'";
586 $this->query($q);
587}
588
589function echoTime($time,$type="datetime") {
590 $year=substr($time,0,4);
591 $month=substr($time,4,2);
592 $day=substr($time,6,2);
593 $hour=substr($time,8,2);
594 $min=substr($time,10,2);
595 $sec=substr($time,12,2);
596 if ($type=='datetime') echo "$day.$month.$year $hour:$min:$sec";
597 elseif ($type=='time') echo "$hour:$min:$sec";
598}
599
600}
This page took 0.203758 seconds and 4 git commands to generate.