A small change to admin_links.php

[dollars5]

Hello All,

In admin_links .php there is a provision to change the status of a story to published from the admin-news management - but the problems was that the link published date was not updated - I just added the following lines to fix it:
Find the following code:

// if admin changes the link status
	if ($_GET['action'] == "bulkmod") {
		if(isset($_POST['submit'])) {
			$comment = array();
			foreach ($_POST["link"] as $k => $v) {
				$comment[intval($k)] = $v;
			}
			foreach($comment as $key => $value) {
				if ($value == "publish") {

the replace the original update query with the following code:

$db->query("UPDATE " . table_links . " SET link_status = 'published' , link_published_date = now() WHERE link_id = '$key'");

In similar manner replace the queued update query to the following

$db->query("UPDATE " . table_links . " SET link_status = 'queued' , link_published_date=0 WHERE link_id = '$key'");

so the final code block will look like:

// if admin changes the link status
	if ($_GET['action'] == "bulkmod") {
		if(isset($_POST['submit'])) {
			$comment = array();
			foreach ($_POST["link"] as $k => $v) {
				$comment[intval($k)] = $v;
			}
			foreach($comment as $key => $value) {
				if ($value == "publish") {
					$db->query("UPDATE " . table_links . " SET link_status = 'published' , link_published_date = now() WHERE link_id = '$key'");
				}
				elseif ($value == "queued") {
					$db->query("UPDATE " . table_links . " SET link_status = 'queued' , link_published_date=0 WHERE link_id = '$key'");
				}
				elseif ($value == "discard") {
					$db->query('UPDATE `' . table_links . '` SET `link_status` = "discard" WHERE `link_id` = "'.$key.'"');
				}
			}

			header("Location: ".my_pligg_base."/admin_links.php");
		}
	}

this will update the timestamps accordingly - since the site that develop made use of these parameters I noticed it. If it is changed in the SVN too - I would really be happy.

[kbeeveer46]

Thanks for the heads up. This will be put in the SVn asap.