1 |
<? |
<? |
2 |
|
|
3 |
|
set_magic_quotes_runtime(0); |
4 |
|
|
5 |
include("inc/class.FastTemplate.pinc"); |
include("inc/class.FastTemplate.pinc"); |
6 |
include("inc/conn.inc"); |
include("inc/conn.inc"); |
7 |
include("inc/fixsql.inc"); |
include("inc/fixsql.inc"); |
17 |
startnew => "startnew.html", |
startnew => "startnew.html", |
18 |
ttable => "topics-table.html", |
ttable => "topics-table.html", |
19 |
theader => "topics-header.html", |
theader => "topics-header.html", |
20 |
|
tlheader => "topics-list-header.html", |
21 |
trow => "topics-row.html", |
trow => "topics-row.html", |
22 |
|
tlrow => "topics-list-row.html", |
23 |
reply => "reply.html", |
reply => "reply.html", |
24 |
checkboxes => "checkboxes.html" |
checkboxes => "checkboxes.html" |
25 |
) |
) |
31 |
if ($row=$sth->fetchrow_hash()) { |
if ($row=$sth->fetchrow_hash()) { |
32 |
if ($row && $row[passwd] == $PHP_AUTH_PW) { |
if ($row && $row[passwd] == $PHP_AUTH_PW) { |
33 |
$md5user=md5($PHP_AUTH_USER.$PHP_AUTH_PW); |
$md5user=md5($PHP_AUTH_USER.$PHP_AUTH_PW); |
34 |
$osoba_id=$row[id]; |
$osoba_id=$row[id]; |
35 |
if ($row[analitical] == "t") { |
if ($row[analitical] == "t") { |
36 |
$analitical_room=1; |
$analitical_room=1; |
37 |
$tpl->assign(array( ROOM => "You are member of analitical room" )); |
$tpl->assign(array( ROOM => "You are member of analitical room" )); |
41 |
if ($row[solution] == "t") { |
if ($row[solution] == "t") { |
42 |
$solution_room=1; |
$solution_room=1; |
43 |
$sql_poruke_where.="and poruke.solution is true"; |
$sql_poruke_where.="and poruke.solution is true"; |
44 |
|
$tpl->assign(array( ROOM => "You are in solution room" )); |
45 |
} |
} |
46 |
$tpl->assign(array( |
$tpl->assign(array( |
47 |
FULL_NAME => $row[full_name], |
FULL_NAME => $row[full_name], |
49 |
)); |
)); |
50 |
} |
} |
51 |
} else { // try to verify user via pop3 |
} else { // try to verify user via pop3 |
52 |
include("class.POP3.php3"); |
include("auth_pop3.php"); |
53 |
$pop3 = new POP3(); |
$pop3 = new POP3(); |
54 |
|
|
55 |
if($pop3->connect("intranet.pliva.hr")) { |
if($pop3->connect("intranet.pliva.hr")) { |
56 |
$Count = $pop3->login($PHP_AUTH_USER,$PHP_AUTH_PW); |
if ($pop3->checklogin($PHP_AUTH_USER,$PHP_AUTH_PW)) { |
|
if ( $Count != -1 ) { |
|
57 |
$pop3->quit(); |
$pop3->quit(); |
58 |
// o.k., user exists now insert it in db! |
// o.k., user exists now insert it in db! |
59 |
include("finger.inc"); |
include("finger.inc"); |
65 |
$md5user=md5($PHP_AUTH_USER.$PHP_AUTH_PW); |
$md5user=md5($PHP_AUTH_USER.$PHP_AUTH_PW); |
66 |
$osoba_id=$row[id]; |
$osoba_id=$row[id]; |
67 |
$tpl->assign(array( |
$tpl->assign(array( |
68 |
FULL_NAME => $row[full_name], |
FULL_NAME => $full_name, |
69 |
RELOGIN => "$PHP_SELF?relogin=$md5user" |
RELOGIN => "$PHP_SELF?relogin=$md5user" |
70 |
)); |
)); |
71 |
} |
} |
79 |
$tpl->parse(MAIN, "main"); |
$tpl->parse(MAIN, "main"); |
80 |
$tpl->FastPrint(); |
$tpl->FastPrint(); |
81 |
exit ; |
exit ; |
82 |
|
} else { |
83 |
|
$dbh->dbh_do("update osobe set last_login=now() where login='$PHP_AUTH_USER'"); |
84 |
} |
} |
85 |
|
|
86 |
//---- insert reply into database |
//---- insert reply into database |
116 |
if (isset($GLOBALS[$what])) { |
if (isset($GLOBALS[$what])) { |
117 |
$GLOBALS[$what]="true"; |
$GLOBALS[$what]="true"; |
118 |
} else { |
} else { |
119 |
$GLOBALS[$what]="flase"; |
$GLOBALS[$what]="false"; |
120 |
} |
} |
121 |
} |
} |
122 |
|
|
123 |
fix_checkbox("analitical"); |
fix_checkbox("analitical"); |
124 |
fix_checkbox("solution"); |
fix_checkbox("solution"); |
125 |
|
|
126 |
$dbh->dbh_do(fixsql("insert into poruke (thread_id,reply_id,osoba_id,sadrzaj,level,pos,analitical,solution) values ($thread_id,$reply_id,$osoba_id,'$sadrzaj',$level,'$pos',$analitical,$solution)")); |
$sadrzaj=trim($sadrzaj); |
127 |
|
$dbh->dbh_do(fixsql("insert into poruke (thread_id,reply_id,osoba_id,sadrzaj,level,pos,analitical,solution) values ($thread_id,$p,$osoba_id,'$sadrzaj',$level,'$pos',$analitical,$solution)")); |
128 |
|
|
129 |
$sth=$dbh->prepare("select currval('poruke_id_seq') as id"); |
$sth=$dbh->prepare("select currval('poruke_id_seq') as id"); |
130 |
$sth->execute(); |
$sth->execute(); |
132 |
if ($row=$sth->fetchrow_hash()) { |
if ($row=$sth->fetchrow_hash()) { |
133 |
$p=$row[id]; // poruka_id for later |
$p=$row[id]; // poruka_id for later |
134 |
} |
} |
135 |
|
$what="show"; |
136 |
|
|
137 |
} elseif (isset($insert_newtopic)) { |
} elseif (isset($insert_newtopic)) { |
138 |
|
|
144 |
$sth->execute(); |
$sth->execute(); |
145 |
if ($row=$sth->fetchrow_hash()) { |
if ($row=$sth->fetchrow_hash()) { |
146 |
$t=$row[id]; // topic for later |
$t=$row[id]; // topic for later |
147 |
|
$title=trim($title); |
148 |
$dbh->dbh_do(fixsql("insert into topics (id,title) values ($t,'$title')")); |
$dbh->dbh_do(fixsql("insert into topics (id,title) values ($t,'$title')")); |
149 |
} |
} |
150 |
} |
} |
152 |
|
|
153 |
//----- end of inserts/updates... |
//----- end of inserts/updates... |
154 |
|
|
155 |
if ($what=="reply" && isset($t)) { |
if (($what=="reply" || $what=="show") && isset($t)) { |
156 |
$sql_where=" and topics.id=$t"; |
$sql_where=" and topics.id=$t"; |
157 |
} |
} |
158 |
|
|
159 |
|
if ($solution_room == 1) { |
160 |
|
// don't limit just to topics starts |
161 |
|
$sql_where.=" and poruke.thread_id=topics.id and poruke.thread_id!=0"; |
162 |
|
} else { |
163 |
|
// limit just to topics start |
164 |
|
$sql_where.=" and poruke.id=topics.id and poruke.thread_id=0"; |
165 |
|
} |
166 |
|
|
167 |
$sth = $dbh->prepare("select topics.id as topic_id,title,sadrzaj,full_name,poruke.datum as datum |
$sth = $dbh->prepare("select topics.id as topic_id,title,sadrzaj,full_name,poruke.datum as datum |
168 |
from topics,poruke,osobe |
from topics,poruke,osobe |
169 |
where poruke.thread_id=0 and poruke.id=topics.id and poruke.osoba_id=osobe.id $sql_where $sql_poruke_where |
where poruke.osoba_id=osobe.id $sql_where $sql_poruke_where |
170 |
order by datum asc |
order by datum asc |
171 |
"); |
"); |
172 |
|
|
173 |
$sth->execute(); |
$sth->execute(); |
174 |
$topics=""; |
$topics=""; |
175 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
178 |
AUTHOR => $row[full_name], |
AUTHOR => $row[full_name], |
179 |
DATE => $row[datum], |
DATE => $row[datum], |
180 |
SADRZAJ => $row[sadrzaj], |
SADRZAJ => $row[sadrzaj], |
181 |
COMMENTS => "<a href=\"$PHP_SELF?what=reply&t=$row[topic_id]\">comments>></a>", |
COMMENTS => "<a href=\"$PHP_SELF?what=show&t=$row[topic_id]\">comments>></a>", |
182 |
PHP_SELF => $PHP_SELF |
PHP_SELF => $PHP_SELF |
183 |
)); |
)); |
|
$tpl->parse(ROWS,".theader"); |
|
184 |
|
|
185 |
if (isset($t) && $t==$row[topic_id]) { |
if (isset($t) && $t==$row[topic_id]) { |
186 |
|
$tpl->parse(ROWS,".theader"); |
187 |
$sth2 = $dbh->prepare(" |
$sth2 = $dbh->prepare(" |
188 |
select poruke.id as id,sadrzaj as topic,level,thread_id,reply_id,full_name,poruke.datum as datum,poruke.analitical as poruka_analitical |
select poruke.id as id,sadrzaj as topic,level,thread_id,reply_id,full_name,poruke.datum as datum,poruke.analitical as poruka_analitical |
189 |
from poruke,osobe |
from poruke,osobe |
198 |
$l_ul.="<ul>"; |
$l_ul.="<ul>"; |
199 |
$r_ul.="</ul>"; |
$r_ul.="</ul>"; |
200 |
} |
} |
201 |
|
// don't indent in solution room |
202 |
|
if ($solution_room == 1) { $l_ul=$r_ul=""; } |
203 |
$tpl->assign( array( |
$tpl->assign( array( |
204 |
L_INDENT => $l_ul, |
L_INDENT => $l_ul, |
205 |
R_INDENT => $r_ul |
R_INDENT => $r_ul |
206 |
)); |
)); |
207 |
$topic=trim(strip_tags($row2[topic])); |
$topic=trim(strip_tags($row2[topic])); |
208 |
if (isset($p) && $p == $row2[id]) { |
if (isset($p) && $p == $row2[id] && $what=="reply") { |
209 |
$topic="<font color=red>$topic...</font>"; |
$topic="<font color=red>$topic...</font>"; |
210 |
$tpl->assign( array( P => $p )); |
$tpl->assign( array( P => $p, T => $t )); |
211 |
$tpl->parse(CHECKBOXES, ".checkboxes"); |
if ($analitical_room == 1) { |
212 |
|
$tpl->parse(CHECKBOXES, ".checkboxes"); |
213 |
|
} |
214 |
$tpl->parse(REPLY, ".reply"); |
$tpl->parse(REPLY, ".reply"); |
215 |
|
} elseif (isset($p) && $p == $row2[id]) { |
216 |
|
$topic="<font color=red>$topic...</font>"; |
217 |
|
$tpl->assign( array( P => $p, T => $t )); |
218 |
} else { |
} else { |
219 |
if (!isset($p)) { $p=$t; } |
if (!isset($p)) { $p=$t; } |
220 |
$tmp_t=$row2[thread_id]; |
$tmp_t=$row2[thread_id]; |
234 |
DATE => $row2[datum], |
DATE => $row2[datum], |
235 |
SADRZAJ => $topic |
SADRZAJ => $topic |
236 |
)); |
)); |
|
# $tpl->parse(ROWS,".theader"); |
|
237 |
$tpl->parse(ROWS,".trow"); |
$tpl->parse(ROWS,".trow"); |
238 |
} |
} |
239 |
} else { |
} else { |
240 |
// non-unroll topics |
// non-unroll topics (list) |
241 |
$tpl->assign( array( |
$tpl->assign( array( |
242 |
SADRZAJ => $row[sadrzaj], |
SADRZAJ => $row[sadrzaj], |
243 |
COMMENTS => "<a href=\"$PHP_SELF?what=reply&t=$row[topic_id]\">comments>></a>" |
COMMENTS => "<a href=\"$PHP_SELF?what=show&t=$row[topic_id]\">comments>></a>" |
244 |
)); |
)); |
245 |
# $tpl->parse(ROWS,".theader"); |
$tpl->parse(ROWS,".tlheader"); |
246 |
$tpl->parse(ROWS,".trow"); |
$tpl->parse(ROWS,".tlrow"); |
247 |
} |
} |
248 |
|
|
249 |
} |
} |
261 |
if ($what == "new") { |
if ($what == "new") { |
262 |
$tpl->parse(MAIN, ".newtopic"); |
$tpl->parse(MAIN, ".newtopic"); |
263 |
$tpl->assign(array( TITLE => "Start of new topic" )); |
$tpl->assign(array( TITLE => "Start of new topic" )); |
264 |
|
} elseif ($what == "show") { |
265 |
|
$tpl->assign(array( |
266 |
|
TITLE => "Select article for reply", |
267 |
|
P => $p |
268 |
|
)); |
269 |
} elseif ($what == "reply") { |
} elseif ($what == "reply") { |
270 |
$tpl->assign(array( |
$tpl->assign(array( |
271 |
TITLE => "Reply to selected article", |
TITLE => "Reply to selected article", |
272 |
P => $p |
P => $p |
273 |
)); |
)); |
|
# $tpl->parse(MAIN, ".reply"); |
|
274 |
} |
} |
275 |
$tpl->parse(MAIN, "main"); |
$tpl->parse(MAIN, "main"); |
276 |
|
|