14 |
# echo "<TT><B>[SQL]</B> $sql<BR>\n"; |
# echo "<TT><B>[SQL]</B> $sql<BR>\n"; |
15 |
} |
} |
16 |
function newsEdit($art, $trigger = "") { |
function newsEdit($art, $trigger = "") { |
17 |
global $phptmp, $picdir, $syspicdir, $section, $dbh, $tpl; |
global $phptmp, $picdir, $syspicdir, $section, $section_menu, $dbh, $tpl; |
18 |
global $ed_id, $ed_cat; |
global $ed_id, $ed_cat; |
19 |
$i = 1; |
$i = 1; |
20 |
global $ed_delete_main, $ed_del_main; |
global $ed_delete_main, $ed_del_main; |
61 |
if ($row) MyDelete($syspicdir."/".$row); |
if ($row) MyDelete($syspicdir."/".$row); |
62 |
} |
} |
63 |
global $ed_title, $ed_lead, $ed_titlepic_alt, |
global $ed_title, $ed_lead, $ed_titlepic_alt, |
64 |
$ed_titlepic_pos, $ed_more, $ed_cat; |
$ed_titlepic_pos, $ed_more, $ed_more_title, |
65 |
|
$ed_cat; |
66 |
$ed_title = MyQuote($ed_title); |
$ed_title = MyQuote($ed_title); |
67 |
$ed_lead = MyQuote($ed_lead); |
$ed_lead = MyQuote($ed_lead); |
68 |
$ed_titlepic_nm = MyQuote(basename($titlepic_name)); |
$ed_titlepic_nm = MyQuote(basename($titlepic_name)); |
69 |
$ed_titlepic_alt = MyQuote($ed_titlepic_alt); |
$ed_titlepic_alt = MyQuote($ed_titlepic_alt); |
70 |
$ed_more = MyQuote($ed_more); |
$ed_more = MyQuote($ed_more); |
71 |
|
$ed_more_title = MyQuote($ed_more_title); |
72 |
if (!$ed_titlepic_pos) $ed_titlepic_pos = 0; |
if (!$ed_titlepic_pos) $ed_titlepic_pos = 0; |
73 |
if ($ed_id > 0) { |
if ($ed_id > 0) { |
74 |
$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, url = $ed_more, date = CURRENT_TIMESTAMP 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, url = $ed_more, url_title = $ed_more_title, date = CURRENT_TIMESTAMP WHERE (news_id = $ed_id)"; |
75 |
sql($sql); |
sql($sql); |
76 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
77 |
} else { |
} else { |
78 |
$sql = "INSERT INTO news (category, title, lead, title_pic, title_alt, title_pos, url, date) VALUES ('$ed_cat', $ed_title, $ed_lead, $ed_titlepic_nm, $ed_titlepic_alt, $ed_titlepic_pos, $ed_more, CURRENT_TIMESTAMP)"; |
$sql = "INSERT INTO news (category, title, lead, title_pic, title_alt, title_pos, url, url_title, date) VALUES ('$ed_cat', $ed_title, $ed_lead, $ed_titlepic_nm, $ed_titlepic_alt, $ed_titlepic_pos, $ed_more, $ed_more_title, CURRENT_TIMESTAMP)"; |
79 |
sql($sql); |
sql($sql); |
80 |
$dbh->dbh_do($sql); |
$dbh->dbh_do($sql); |
81 |
$sql = "SELECT news_id FROM news WHERE (title = $ed_title)"; |
$sql = "SELECT news_id FROM news WHERE (title = $ed_title)"; |
212 |
$tp->assign("levels", $levels); |
$tp->assign("levels", $levels); |
213 |
// ----- |
// ----- |
214 |
global $ed_id, $ed_title, $ed_lead, $ed_titlepic_pos, |
global $ed_id, $ed_title, $ed_lead, $ed_titlepic_pos, |
215 |
$ed_titlepic_alt, $ed_cat, $ed_more; |
$ed_titlepic_alt, $ed_cat, $ed_more, |
216 |
|
$ed_more_title; |
217 |
global $ed_edit, $ed_preview, $preview, $add; |
global $ed_edit, $ed_preview, $preview, $add; |
218 |
if (!$ed_preview) $ed_preview = ($preview ? true : false); |
if (!$ed_preview) $ed_preview = ($preview ? true : false); |
219 |
if ($ed_edit) $ed_preview = false; |
if ($ed_edit) $ed_preview = false; |
228 |
$ed_warning = 0; |
$ed_warning = 0; |
229 |
if ($ed_edit || $ed_preview || $add || $delete || $clear) { |
if ($ed_edit || $ed_preview || $add || $delete || $clear) { |
230 |
global $ed_title, $ed_lead, $ed_titlepic_pos, |
global $ed_title, $ed_lead, $ed_titlepic_pos, |
231 |
$ed_titlepic_alt, $ed_cat, $ed_more; |
$ed_titlepic_alt, $ed_cat, $ed_more, |
232 |
|
$ed_more_title; |
233 |
if (!$HTTP_POST_FILES["ed_titlepic_url"]["name"]) $titlepic_url = ""; |
if (!$HTTP_POST_FILES["ed_titlepic_url"]["name"]) $titlepic_url = ""; |
234 |
if (!$titlepic_url) $titlepic_url = $titlepic_url2; |
if (!$titlepic_url) $titlepic_url = $titlepic_url2; |
235 |
if (!$titlepic_url && !($clear_main || $clr_main)) |
if (!$titlepic_url && !($clear_main || $clr_main)) |
264 |
} else { |
} else { |
265 |
list($ed_title, $ed_lead, $ed_titlepic_pos, $titlepic_url, |
list($ed_title, $ed_lead, $ed_titlepic_pos, $titlepic_url, |
266 |
$titlepic_url2, $titlepic_name, $ed_titlepic_alt, |
$titlepic_url2, $titlepic_name, $ed_titlepic_alt, |
267 |
$ed_cat, $ed_more, $width, $height) = array($art["title"], |
$ed_cat, $ed_more, $ed_more_title, $width, $height) = |
268 |
$art["lead"], $art["pic_pos"], $art["pic_url"], |
array($art["title"], $art["lead"], $art["pic_pos"], |
269 |
$art["pic_url"], $art["pic_url"], $art["pic_alt"], |
$art["pic_url"], $art["pic_url"], $art["pic_url"], |
270 |
$art["category"], $art["more"], $art["pic_w"], $art["pic_h"]); |
$art["pic_alt"], $art["category"], $art["more"], |
271 |
|
$art["more_title"], $art["pic_w"], $art["pic_h"]); |
272 |
while ($art["text"] && list($id, $val) = each($art["text"])) { |
while ($art["text"] && list($id, $val) = each($art["text"])) { |
273 |
list($id, $txt, $title, $lev, $cls, $pic, $alt, $pos, $w, $h) = array( |
list($id, $txt, $title, $lev, $cls, $pic, $alt, $pos, $w, $h) = array( |
274 |
$val["id"], $val["text"], $val["title"], $val["level"], |
$val["id"], $val["text"], $val["title"], $val["level"], |
350 |
$tp->assign("ed_titlepic_width", $width); |
$tp->assign("ed_titlepic_width", $width); |
351 |
$tp->assign("ed_titlepic_height", $height); |
$tp->assign("ed_titlepic_height", $height); |
352 |
$tp->assign("ed_more", MyEscape($ed_more)); |
$tp->assign("ed_more", MyEscape($ed_more)); |
353 |
|
$tp->assign("ed_more_title", MyEscape($ed_more_title)); |
354 |
$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); |
355 |
$tp->assign("ed_text", $ed_text); |
$tp->assign("ed_text", $ed_text); |
356 |
$tp->assign("ed_empty", $ed_empty); |
$tp->assign("ed_empty", $ed_empty); |
360 |
$tp->assign("newspicdir", "$picdir/"); |
$tp->assign("newspicdir", "$picdir/"); |
361 |
$params = array(); |
$params = array(); |
362 |
if ($section) array_push($params, "section=$section"); |
if ($section) array_push($params, "section=$section"); |
363 |
|
if ($section_menu) array_push($params, "section_menu=$section_menu"); |
364 |
if ($ed_id) array_push($params, "ed_id=$ed_id"); |
if ($ed_id) array_push($params, "ed_id=$ed_id"); |
365 |
if ($ed_preview) array_push($params, "ed_preview=$ed_preview"); |
if ($ed_preview) array_push($params, "ed_preview=$ed_preview"); |
366 |
if ($trigger) array_push($params, "$trigger=1"); |
if ($trigger) array_push($params, "$trigger=1"); |