92 |
// ----- |
// ----- |
93 |
$newsi = array(); |
$newsi = array(); |
94 |
#$sql = "SELECT news_id, title FROM news WHERE (".($isMed?"":"NOT ")."plivamed) ORDER BY title"; |
#$sql = "SELECT news_id, title FROM news WHERE (".($isMed?"":"NOT ")."plivamed) ORDER BY title"; |
95 |
$sql = "SELECT news_id, title FROM news ORDER BY title"; |
$sql = "SELECT news_id, title FROM news"; |
96 |
|
if ($ed_id && $ed_id > 0) $sql .= " WHERE (news_id != $ed_id)"; |
97 |
|
$sql .= " ORDER BY title"; |
98 |
sql($sql); |
sql($sql); |
99 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
100 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
156 |
global $ed_title, $ed_lead, $ed_titlepic_alt, |
global $ed_title, $ed_lead, $ed_titlepic_alt, |
157 |
$ed_titlepic_pos, $ed_more, $ed_more_title, |
$ed_titlepic_pos, $ed_more, $ed_more_title, |
158 |
$ed_cat, $ed_author_alt, $ed_author_info, |
$ed_cat, $ed_author_alt, $ed_author_info, |
159 |
$ed_author_ime, $ed_author_cv, $ed_prikazi; |
$ed_author_ime, $ed_author_cv, $ed_exclusive, |
160 |
|
$ed_prikazi; |
161 |
$ed_title = MyQuote($ed_title); |
$ed_title = MyQuote($ed_title); |
162 |
$ed_lead = MyQuote($ed_lead); |
$ed_lead = MyQuote($ed_lead); |
163 |
$ed_author_nm = urldecode(MyQuote(basename($author_name))); |
$ed_author_nm = urldecode(MyQuote(basename($author_name))); |
170 |
$ed_more_title = MyQuote($ed_more_title); |
$ed_more_title = MyQuote($ed_more_title); |
171 |
if (!$ed_titlepic_pos) $ed_titlepic_pos = 0; |
if (!$ed_titlepic_pos) $ed_titlepic_pos = 0; |
172 |
if (!$ed_author_cv) $ed_author_cv = 0; |
if (!$ed_author_cv) $ed_author_cv = 0; |
173 |
|
if (!isset($ed_exclusive)) $ed_exclusive = false; |
174 |
if ($ed_id > 0) { |
if ($ed_id > 0) { |
175 |
$sql = "UPDATE news SET category = '$ed_cat', title = $ed_title, lead = $ed_lead, title_pic = $ed_titlepic_nm, title_alt = $ed_titlepic_alt, title_pos = $ed_titlepic_pos, author_pic = $ed_author_nm, author_alt = $ed_author_alt, author_info = $ed_author_info, author_name = $ed_author_ime, autor_cv = $ed_author_cv, url = $ed_more, url_title = $ed_more_title, plivamed = ".($isMed?"true":"false").", prikazi = ".($ed_prikazi?"true":"false").", ord = 0, d_change = NOW() WHERE (news_id = $ed_id)"; |
$sql = "UPDATE news SET category = '$ed_cat', title = $ed_title, lead = $ed_lead, title_pic = $ed_titlepic_nm, title_alt = $ed_titlepic_alt, title_pos = $ed_titlepic_pos, author_pic = $ed_author_nm, author_alt = $ed_author_alt, author_info = $ed_author_info, author_name = $ed_author_ime, autor_cv = $ed_author_cv, exclusive = ".($ed_exclusive?"true":"false").", url = $ed_more, url_title = $ed_more_title, plivamed = ".($isMed?"true":"false").", prikazi = ".($ed_prikazi?"true":"false").", ord = 0, d_change = NOW() WHERE (news_id = $ed_id)"; |
176 |
sql($sql); |
sql($sql); |
177 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
178 |
} else { |
} else { |
179 |
$sql = "INSERT INTO news (category, title, lead, title_pic, title_alt, title_pos, author_pic, author_alt, author_info, author_name, autor_cv, url, url_title, plivamed, prikazi, d_orig, d_change) VALUES ('$ed_cat', $ed_title, $ed_lead, $ed_titlepic_nm, $ed_titlepic_alt, $ed_titlepic_pos, $ed_author_nm, $ed_author_alt, $ed_author_info, $ed_author_ime, $ed_author_cv, $ed_more, $ed_more_title, ".($isMed?"true":"false").", ".($ed_prikazi?"true":"false").", NOW(), NOW())"; |
$sql = "INSERT INTO news (category, title, lead, title_pic, title_alt, title_pos, author_pic, author_alt, author_info, author_name, autor_cv, exclusive, url, url_title, plivamed, prikazi, d_orig, d_change) VALUES ('$ed_cat', $ed_title, $ed_lead, $ed_titlepic_nm, $ed_titlepic_alt, $ed_titlepic_pos, $ed_author_nm, $ed_author_alt, $ed_author_info, $ed_author_ime, $ed_author_cv, ".($ed_exclusive?"true":"false").", $ed_more, $ed_more_title, ".($isMed?"true":"false").", ".($ed_prikazi?"true":"false").", NOW(), NOW())"; |
180 |
sql($sql); |
sql($sql); |
181 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
182 |
$sql = "SELECT currval('news_news_id_seq')::text"; |
$sql = "SELECT currval('news_news_id_seq')::text"; |
235 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
236 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
237 |
while ($row = $sth->fetchrow_array()) { |
while ($row = $sth->fetchrow_array()) { |
238 |
list($pic) = $row; |
list($pic2) = $row; |
239 |
MyDelete($syspicdir."/".$pic); |
MyDelete($syspicdir."/".$pic2); |
240 |
} |
} |
241 |
$sth->finish(); |
$sth->finish(); |
242 |
} |
} |
247 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
248 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
249 |
while ($row = $sth->fetchrow_array()) { |
while ($row = $sth->fetchrow_array()) { |
250 |
list($pic) = $row; |
list($pic2) = $row; |
251 |
MyDelete($syspicdir."/".$pic); |
MyDelete($syspicdir."/".$pic2); |
252 |
} |
} |
253 |
$sth->finish(); |
$sth->finish(); |
254 |
} |
} |
421 |
global $ed_title, $ed_lead, $ed_titlepic_pos, |
global $ed_title, $ed_lead, $ed_titlepic_pos, |
422 |
$ed_titlepic_alt, $ed_cat, $ed_more, $ed_more_title, |
$ed_titlepic_alt, $ed_cat, $ed_more, $ed_more_title, |
423 |
$ed_author_url, $ed_author_alt, $ed_author_info, |
$ed_author_url, $ed_author_alt, $ed_author_info, |
424 |
$ed_author_ime, $ed_author_cv, $ed_prikazi; |
$ed_author_ime, $ed_author_cv, $ed_exclusive, $ed_prikazi; |
425 |
if (!$HTTP_POST_FILES["ed_titlepic_url"]["name"]) $titlepic_url = ""; |
if (!$HTTP_POST_FILES["ed_titlepic_url"]["name"]) $titlepic_url = ""; |
426 |
if (!$titlepic_url) $titlepic_url = $titlepic_url2; |
if (!$titlepic_url) $titlepic_url = $titlepic_url2; |
427 |
if (!$titlepic_url && !($clear_main || $clr_main)) $titlepic_url = $art["pic_url"]; |
if (!$titlepic_url && !($clear_main || $clr_main)) $titlepic_url = $art["pic_url"]; |
497 |
} |
} |
498 |
$sth->finish(); |
$sth->finish(); |
499 |
} else { |
} else { |
500 |
$art["show"] = true; |
$art["show"] = false; |
501 |
for ($j = 0; $j < count($specs); $j++) |
for ($j = 0; $j < count($specs); $j++) |
502 |
$nspecs[$specs[$j]["id"]] = ($specs[$j]["id"] == $spec) ? true : false; |
$nspecs[$specs[$j]["id"]] = ($specs[$j]["id"] == $spec) ? true : false; |
503 |
} |
} |
506 |
$ed_cat, $ed_more, $ed_more_title, $width, $height, |
$ed_cat, $ed_more, $ed_more_title, $width, $height, |
507 |
$author_url, $author_url2, $author_name, |
$author_url, $author_url2, $author_name, |
508 |
$ed_author_alt, $ed_author_info, $width2, $height2, |
$ed_author_alt, $ed_author_info, $width2, $height2, |
509 |
$ed_author_ime, $ed_author_cv, $ed_prikazi) = array($art["title"], |
$ed_author_ime, $ed_author_cv, $ed_exclusive, $ed_prikazi) = |
510 |
$art["lead"], $art["pic_pos"], $art["pic_url"], $art["pic_url"], |
array($art["title"], $art["lead"], $art["pic_pos"], $art["pic_url"], |
511 |
urldecode($art["pic_url"]), $art["pic_alt"], $art["category"], |
$art["pic_url"], urldecode($art["pic_url"]), $art["pic_alt"], |
512 |
$art["more"], $art["more_title"], $art["pic_w"], $art["pic_h"], |
$art["category"], $art["more"], $art["more_title"], $art["pic_w"], |
513 |
$art["au_pic"], $art["au_pic"], urldecode($art["au_pic"]), |
$art["pic_h"], $art["au_pic"], $art["au_pic"], urldecode($art["au_pic"]), |
514 |
$art["au_alt"], $art["au_info"], $art["au_w"], $art["au_h"], |
$art["au_alt"], $art["au_info"], $art["au_w"], $art["au_h"], |
515 |
$art["au_name"], $art["au_cv"], $art["show"]); |
$art["au_name"], $art["au_cv"], $art["ex"], $art["show"]); |
516 |
if ($art["text"]) reset($art["text"]); |
if ($art["text"]) reset($art["text"]); |
517 |
while ($art["text"] && list($id, $val) = each($art["text"])) { |
while ($art["text"] && list($id, $val) = each($art["text"])) { |
518 |
array_push($ed_pgfs, array($val["id"], $val["text"], $val["title"], |
array_push($ed_pgfs, array($val["id"], $val["text"], $val["title"], |
644 |
$tp->assign("ed_more_title", MyEscape($ed_more_title)); |
$tp->assign("ed_more_title", MyEscape($ed_more_title)); |
645 |
$tp->assign("ed_prikazi", $ed_prikazi); |
$tp->assign("ed_prikazi", $ed_prikazi); |
646 |
$tp->assign("ed_author_cv", $ed_author_cv); |
$tp->assign("ed_author_cv", $ed_author_cv); |
647 |
|
$tp->assign("ed_exclusive", $ed_exclusive); |
648 |
$tp->assign("ed_clr_main", ($clear_main || $clr_main || !$titlepic_url) ? true : false); |
$tp->assign("ed_clr_main", ($clear_main || $clr_main || !$titlepic_url) ? true : false); |
649 |
$tp->assign("ed_clr_author", ($clear_author || $clr_author || !$author_url) ? true : false); |
$tp->assign("ed_clr_author", ($clear_author || $clr_author || !$author_url) ? true : false); |
650 |
$tp->assign("ed_text", $ed_text); |
$tp->assign("ed_text", $ed_text); |