Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <?php |
2 | include('kyberia.inc'); | |
3 | class CLASS_REDAKCE extends CLASS_KYBERIA { | |
4 | ||
5 | ||
6 | function CLASS_REDAKCE() { | |
7 | $this->CLASS_KYBERIA(); | |
8 | } | |
9 | ||
10 | function listArticles() { | |
11 | $q="SELECT * FROM articles order by id_article desc"; | |
12 | return($this->query($q)); | |
13 | } | |
14 | ||
15 | function getAllGalleries() { | |
16 | return $this->query("SELECT * from albums"); | |
17 | } | |
18 | ||
19 | function getParentCount($id_parent) { | |
20 | $q="SELECT COUNT(*) AS pocet from rubriky where id_parent='$id_parent'"; | |
21 | $set=$this->query($q); | |
22 | $set->next(); | |
23 | return $set->getString("pocet"); | |
24 | } | |
25 | ||
26 | function getRubrikaCount($id_rubrika) { | |
27 | $q="SELECT COUNT(*) AS pocet from articles where id_rubrika='$id_rubrika'"; | |
28 | $set=$this->query($q); | |
29 | $set->next(); | |
30 | return $set->getString("pocet"); | |
31 | } | |
32 | function createMenu() { | |
33 | $q="SELECT DISTINCT id_parent from rubriky"; | |
34 | $parents=$this->query($q); | |
35 | for ($i=0;$parents->next();$i++) { | |
36 | $parent=$parents->getString("id_parent"); | |
37 | $parentcount=$this->getParentCount($parent); | |
38 | $string .= "\nMenu".$i.'=new Array("'.$this->getRubrikabyId($parent).'","http://kyberia.sk/?action=rubrika&kat='.$parent.'","",'.$parentcount.',20,110);'; | |
39 | $q="SELECT id_rubriky,nazov from rubriky where id_parent=$parent and id_parent>1"; | |
40 | $rubriky=$this->query($q); | |
41 | for ($j=1;$rubriky->next();$j++) { | |
42 | $rubrika=$rubriky->getString("id_rubriky"); | |
43 | $rubrikacount=$this->getRubrikaCount($rubrika); | |
44 | $string .= "\nMenu".$i.'_'.$j.'=new Array("'.$this->getRubrikabyId($rubrika).'","http://kyberia.sk/?action=rubrika&node_id='.$rubrika.'","",'.$rubrikacount.',20,150);'; | |
45 | $q="SELECT id_article,nazov from articles where id_rubrika=$rubrika"; | |
46 | $articles=$this->query($q); | |
47 | for ($k=1;$articles->next();$k++) { | |
48 | $article=$articles->getString("id_article"); | |
49 | $string .= "\nMenu".$i."_".$j."_".$k.'=new Array("'.$articles->getString("nazov").'","?action=article&node_id='.$article.'","",0,20,250);';; | |
50 | } | |
51 | } | |
52 | } | |
53 | // $set = $this->getAllUsers(); | |
54 | // $pocet=$set->_numRows-1; | |
55 | $string .= "\nMenu".$i.'=new Array("journaux","?action=journaux","",0,20,110);'; | |
56 | /* for ($l=0;$set->next();$l++) { | |
57 | $username=$set->getString("meno"); | |
58 | $userid=$set->getString("id"); | |
59 | $string .= "\nMenu".$i.'_'.$l.'=new Array("'.$username.'","http://kyberia.sk/journaux.php?user='.$userid.'","",0,20,115);'; | |
60 | } */ | |
61 | echo $string; | |
62 | $i++; | |
63 | $string .= "\nMenu".$i.'=new Array("photoz","http://kyberia.sk/gallery","",0,20,118);'; | |
64 | $file=fopen("/home/hromi1/kyberia/js/menu.js","w+"); | |
65 | fputs($file,$string); | |
66 | } | |
67 | ||
68 | function listRubrikyArray() { | |
69 | $q="SELECT * FROM rubriky"; | |
70 | $set=$this->query($q); | |
71 | while($set->next()) { | |
72 | $data[]=$set->getString("nazov"); | |
73 | } | |
74 | return $data; | |
75 | } | |
76 | ||
77 | function listGalleryArray() { | |
78 | $q="SELECT * FROM albums"; | |
79 | $set=$this->query($q); | |
80 | $data[]="none"; | |
81 | while($set->next()) { | |
82 | $data[]=$set->getString("name"); | |
83 | } | |
84 | return $data; | |
85 | } | |
86 | ||
87 | function addArticle($pole,$timage) { | |
88 | $text1=AddSlashes(str_replace("\n","<br>",$pole['text1'])); | |
89 | // $text1=AddSlashes($pole[text1]); | |
90 | $text3=AddSlashes($pole[text3]); | |
91 | $text2=AddSlashes($pole[text2]); | |
92 | $id_rubrika=$pole[id_rubrika]+1; | |
93 | $id_rubrika_secondary=$pole[id_rubrika_secondary]+1; | |
94 | $title_image=$pole[title_image]; | |
95 | $dd= new Diskuse(); | |
96 | $diskid=$dd->createDiskuse($id_rubrika); | |
97 | $q="INSERT INTO articles SET datum=NOW(),"; | |
98 | $q.="nazov='$pole[nazov]',short_desc='$pole[short_desc]',text1='$text1',text2='$text2',text3='$text3',autor='$pole[autor]',"; | |
99 | $q.="id_rubrika='$id_rubrika',"; | |
100 | $q.="id_rubrika_secondary='$id_rubrika_secondary',"; | |
101 | $q.="id_diskuse='$diskid',title_image='$timage',hits='0'"; | |
102 | $q.=",gallery='$gallery'"; | |
103 | $q.=",prispevky='$prispevky'"; | |
104 | $this->query($q); | |
105 | $this->createMenu(); | |
106 | } | |
107 | ||
108 | function updateArticle($pole) { | |
109 | $id_rubrika=$pole[id_rubrika]+1; | |
110 | $id_rubrika_secondary=$pole[id_rubrika_secondary]+1; | |
111 | $title_image=$pole[title_image]; | |
112 | $text1=AddSlashes($pole[text1]); | |
113 | $text3=AddSlashes($pole[text3]); | |
114 | $text2=AddSlashes($pole[text2]); | |
115 | $q="update articles SET datum=NOW(),"; | |
116 | $q.="nazov='$pole[nazov]',short_desc='$pole[short_desc]',text1='$text1',autor='$pole[autor]',"; | |
117 | $q.="id_rubrika='$id_rubrika',id_rubrika_secondary='$id_rubrika_secondary',keywords='$pole[keywords]'"; | |
118 | $q.=" where id_article=$pole[id]"; | |
119 | $this->query($q); | |
120 | } | |
121 | ||
122 | function deleteArticle($id) { | |
123 | $this->query("DELETE FROM articles where id_article=$id"); | |
124 | } | |
125 | ||
126 | function addRubrika($pole,$obrazok) { | |
127 | $rodic=($pole[id_parent])+1; | |
128 | $this->query("INSERT INTO rubriky set nazov='$pole[nazov]',id_parent='$rodic',obrazok='$obrazok',description='$pole[description]'"); | |
129 | } | |
130 | ||
131 | function addSkin($nazov,$adresa) { | |
132 | $rodic=($pole[id_parent])+1; | |
133 | $this->query("INSERT INTO skins set nazov='$nazov',adresa='$adresa'"); | |
134 | } | |
135 | ||
136 | function addIntro($pole) { | |
137 | $q="INSERT INTO intros set text='$pole[text]',id_forum='$id_forum',id_user='$pole[id_autor]'"; | |
138 | echo $q; | |
139 | $this->query($q); | |
140 | } | |
141 | ||
142 | function addTitle($pole) { | |
143 | $this->query("INSERT INTO titles set title='$pole[title]'"); | |
144 | } | |
145 | ||
146 | ||
147 | // >------------------------------koniec metod---------------< | |
148 | } | |
149 | ?> |