. */ date_default_timezone_set("America/New_York"); function ListNews(){ global $db; $result = $db->Query("SELECT n.news_id, n.title, n.date, n.category_id, u.username AS author, c.name AS catname, c.image AS catimage ". "FROM `bayonet_news` AS n ". "INNER JOIN `bayonet_news_categories` AS c ON c.category_id = n.category_id ". "LEFT OUTER JOIN `bayonet_users` AS u ON u.user_id = n.author_id ORDER BY `date` DESC"); $row = $db->Fetch($result); foreach($row as $news) { ?>  |   
Posted By: on

Query("UPDATE `bayonet_news` SET `title` = '$title', `message` = '$text', `author_id` = '$author_id', `edited` = '$datetime', `edited_id` = '$edited_id' WHERE `news_id` = '$news_id'"); decho("UPDATE `bayonet_news` SET `title` = '$title', `message` = '$text', `author_id` = '$author_id', `edited` = '$datetime', `edited_id` = '$edited_id' WHERE `news_id` = '$news_id'"); PageRedirect(1, "?op=news"); return; } $result = $db->Query("SELECT `author_id`, `title`, `message`, `date`, `category_id`, `edited`, `edited_id` FROM `bayonet_news` WHERE `news_id` = '$news_id' LIMIT 1"); $row = $db->FetchRow($result); ?>

Edit News

Originally posted on Last edited on ".date('n/j/Y @ g:ia e', strtotime($row['edited'])); } ?>
Author
Title
Text
Query("INSERT INTO `bayonet_news` SET `title` = '$title', `message` = '$text', `author_id` = '$author_id', `date` = '$datetime', `category_id` = '$category_id'"); decho("INSERT INTO `bayonet_news` SET `title` = '$title', `message` = '$text', `author_id` = '$author_id', `date` = '$datetime', `category_id` = '$category_id'"); PageRedirect(1, "?op=news"); return; } ?>

Post News

 
'; for($m = 1;$m <= 12; $m++){ $month = date("F", mktime(0, 0, 0, $m)); if($date_arr['month'] == $m) echo ""; else echo ""; } echo ""; //List Days echo '"; //List Years [CurYear, CurYear+5] echo '"; } function SelectAuthor($author_id){ global $db; echo ""; } ?>