} // Get page link URL $sql = 'SELECT `link` FROM `' . TABLE_PREFIX . 'pages` WHERE `page_id`=' . (int) $page_id; $oldLink = $database->get_one($sql); // Include WB functions file require_once WB_PATH . '/framework/functions.php'; // Work-out what the link should be $newLink = '/posts/' . page_filename($title) . PAGE_SPACER . $post_id; // create new accessfile createNewsAccessFile($newLink, $oldLink, $page_id, $section_id, $post_id); // get publisedwhen and publisheduntil $publishedwhen = jscalendar_to_timestamp($admin->get_post_escaped('publishdate')); if ($publishedwhen == '' || $publishedwhen < 1) { $publishedwhen = 0; } $publisheduntil = jscalendar_to_timestamp($admin->get_post_escaped('enddate'), $publishedwhen); if ($publisheduntil == '' || $publisheduntil < 1) { $publisheduntil = 0; } // Update row $sql = 'UPDATE `' . TABLE_PREFIX . 'mod_news_posts` '; $sql .= 'SET `group_id`=' . (int) $group_id . ', '; $sql .= '`title`=\'' . $title . '\', '; $sql .= '`link`=\'' . $newLink . '\', '; $sql .= '`content_short`=\'' . $short . '\', '; $sql .= '`content_long`=\'' . $long . '\', '; $sql .= '`commenting`=\'' . $commenting . '\', '; $sql .= '`active`=' . (int) $active . ', '; $sql .= '`published_when`=' . (int) $publishedwhen . ', '; $sql .= '`published_until`=' . (int) $publisheduntil . ', '; $sql .= '`posted_when`=' . time() . ', ';
if (isset($_POST['comp_date']) && $_POST['comp_date'] != "") { if ($resultquery != "") { $resultquery .= ") AND"; } $resultquery .= " (login_when"; $xmlstoresearch .= "<datelastlogin>"; if ($_POST['datesearch'] == "after") { $resultquery .= ">"; $xmlstoresearch .= "<after>true</after>"; } else { $resultquery .= "<"; $xmlstoresearch .= "<before>true</before>"; } // convert date to timestamp format to compare $resultquery .= jscalendar_to_timestamp($_POST['comp_date'], TIMEZONE); $xmlstoresearch .= "<date>" . jscalendar_to_timestamp($_POST['comp_date'], TIMEZONE) . "</date>"; $xmlstoresearch .= "</datelastlogin>"; } // if a group was choosen modify the sql query if (isset($_POST['groups']) && $_POST['groups'] != "-1") { $g_id = $_POST['groups']; if ($resultquery != "") { $resultquery .= ") AND"; } $g_id = str_replace(",", '%', $g_id); $resultquery .= " (groups_id LIKE '%{$g_id}%'"; $xmlstoresearch .= "<idgroup>" . $g_id . "</idgroup>"; // retrieve the group name $result = $database->query("SELECT name from `" . TABLE_PREFIX . "groups` WHERE group_id = '{$g_id}'"); $group_name = $result->fetchRow(); $xmlstoresearch .= "<groupname>" . $group_name["name"] . "</groupname>";
} // named sections patch if (isset($_POST['namesection' . $section_id])) { $sql .= ", namesection = '" . $admin->add_slashes($_POST['namesection' . $section_id]) . "'"; } // update publ_start and publ_end, trying to make use of the strtotime()-features like "next week", "+1 month", ... if (isset($_POST['start_date' . $section_id]) && isset($_POST['end_date' . $section_id])) { if (trim($_POST['start_date' . $section_id]) == '0' || trim($_POST['start_date' . $section_id]) == '') { $publ_start = 0; } else { $publ_start = jscalendar_to_timestamp($_POST['start_date' . $section_id]); } if (trim($_POST['end_date' . $section_id]) == '0' || trim($_POST['end_date' . $section_id]) == '') { $publ_end = 0; } else { $publ_end = jscalendar_to_timestamp($_POST['end_date' . $section_id], $publ_start); } if ($sql != '') { $sql .= ","; } $sql .= " publ_start = '" . $admin->add_slashes($publ_start) . "'"; $sql .= ", publ_end = '" . $admin->add_slashes($publ_end) . "'"; } $query = "UPDATE " . TABLE_PREFIX . "sections SET {$sql} WHERE section_id = '{$section_id}' LIMIT 1"; if ($sql != '') { $database->query($query); } } } } // Check for error or print success message