<?php
/* +--------------------------------------------------------------
| PHPFreeNews - News Headlines on your website |
| Developed by Jim Willsher. |
| http://www.phpfreenews.co.uk |
+-------------------------------------------------------------+
*/
if (! defined('IN_PHPFN'))
die('Illegal attempt to access script directly!');
$ListOffset = isset($_GET['offset']) ? $_GET['offset'] : '0';
$ReturnText = ' Click <A href="' . $AdminScript . '?action=NewsList">here</A> to return to the news items';
// If specified, store into the session the restriction-information
SetAdminCurrentRestrictions();
$SearchString = $_SESSION['RestrictSearchString'];
$RestrictCatId = $_SESSION['RestrictCategory'];
$Archived = $_SESSION['RestrictArchived'];
$Visible = $_SESSION['RestrictVisible'];
$Sticky = $_SESSION['RestrictSticky'];
$SortMode = $_SESSION['RestrictSortMode'];
$PerPage = $_SESSION['PerPage'];
$ShowPage = isset($_REQUEST['ShowPage']) ? $_REQUEST['ShowPage'] : 1;
// Determine the number of records in the file, and work out the number of pages
$Query = "SELECT DISTINCT news_posts.*, news_users.FullName FROM (news_posts, news_users)";
// Apply any category-restriction
$Query .= ApplyAdminCategoryRestriction($RestrictCatId);
// Join the users table correctly
$Query .= " AND news_posts.AuthorID = news_users.ID";
// Restrict by Archived?
if ($Archived != '-')
$Query .= ' AND Archived=' . $Archived;
// Restrict by Visible?
if ($Visible != '-')
$Query .= ' AND Visible=' . $Visible;
// Restrict by Sticky?
if ($Sticky != '-')
$Query .= ' AND Sticky=' . $Sticky;
// User can edit any posts?
if (!$LoggedInEditAnyPost)
$Query .= ' AND news_posts.AuthorID=' . $LoggedInUserId;
// Apply any wildcard search, if specified
if ($SearchString != '')
$Query .= " AND MATCH (headline, shortpost, longpost) AGAINST('$SearchString' IN BOOLEAN MODE)";
// Now obtain the record count
$ResultSet = mysql_query($Query) or die("Query failed : " . mysql_error());
$NumRecords = mysql_num_rows($ResultSet);
$RecStart = $PerPage * ($ShowPage-1);
$PageNavBar = ConstructPagingBar($_SERVER['PHP_SELF'].'?action=NewsList', $NumRecords, $PerPage, $ShowPage, $RecStart, $AdminPageBarEntries, '', '');
DisplayGroupHeading("News Articles - Page $ShowPage");
?>
<br />
<table class="Admin">
<tr>
<td class="FieldPrompt">
<form action="<?=$AdminScript?>?action=NewsList" method="post">
Per Page <?= BuildPerPageDropdown('PerPage', $PerPage, true) ?>
Text <input type="text" name="SearchString" value="<?= $SearchString ?>" size="10" maxlength="20" />
Cat. <?= BuildUserCategoryDropdown('RestrictCatId', $RestrictCatId, false, true, true) ?>
State <?= BuildArchivedDropdown('Archived', $Archived, true) ?>
Vis. <?= BuildVisibleDropdown('Visible', $Visible, true) ?>
Sticky <?= BuildStickyDropdown('Sticky', $Sticky, true) ?>
<br />
Sort by <?= BuildNewsListSortDropdown('SortMode', $SortMode) ?>
<input class="but" type="submit" name="submit" value="Filter" />
</form>
</td>
</tr>
</table>
<?php DisplayInfoMessage(); ?>
<br />
<table class="Admin">
<tr>
<td>
<table cellpadding="1">
<?php
// Apply any sort-order
$Query .= ApplyAdminSort($SortMode);
// Apply any limits, and perform the search
$Query .= " LIMIT $RecStart, $PerPage";
$ResultSet = mysql_query($Query);
while ($newsrow = mysql_fetch_array($ResultSet))
{
$ArticleID = $newsrow['ID'];
$Sticky = $newsrow['Sticky'];
$Locked = $newsrow['Locked'];
$Visible = $newsrow['Visible'];
$Archived = $newsrow['Archived'];
// Specify the listing style colour
if ($Sticky == '1')
$liststyle = 'NewsListSticky';
else
$liststyle = 'NewsListNonSticky';
// If it's invisible then override
if ($Visible != '1')
$liststyle = 'NewsListNonVisible';
// If it's archived then override
if ($Archived == '1')
$liststyle = 'NewsListArchived';
// Determine which date and time to show
if ($AdminNewsListDateTime == 1)
$ShowDateString = date($NewsDisplay_DateFormat, strtotime($newsrow['OriginalPostDateTime'])) . ' ' . date($NewsDisplay_TimeFormat, strtotime($newsrow['OriginalPostDateTime']));
else
$ShowDateString = date($NewsDisplay_DateFormat, strtotime($newsrow['PostDateTime'])) . ' ' . date($NewsDisplay_TimeFormat, strtotime($newsrow['PostDateTime']));
?>
<tr>
<td class="<?=$liststyle?>" nowrap="nowrap">
<?php if (! $Locked) { ?>
<a href="<?=$AdminScript?>?action=news&mode=edit&id=<?=$ArticleID?>" title="Edit News">
<img src="Inc/Images/EditNews.gif" border="0" align="middle" alt="Edit Posting">
</a>
<a href="<?=$AdminScript?>?action=news&mode=copy&id=<?=$ArticleID?>" title="Copy News">
<img src="Inc/Images/CopyNews.gif" border="0" align="middle" alt="Copy to New Posting">
</a>
<a href="<?=$AdminScript?>?action=news&mode=delete&id=<?=$ArticleID?>" title="Delete News">
<img src="Inc/Images/RemoveNews.gif" border="0" align="middle" alt="Delete Posting">
</a>
<a href="<?=$AdminScript?>?action=DoSticky&id=<?=$ArticleID?>" title="Toggle Sticky">
<img src="Inc/Images/<?= ($Sticky == '1' ? '' : 'Non' ) ?>Sticky.gif" border="0" align="middle" alt="Toggle Sticky status">
</a>
<a href="<?=$AdminScript?>?action=DoVisible&id=<?=$ArticleID?>" title="Toggle Visible">
<img src="Inc/Images/<?= ($Visible == '1' ? 'V' : 'Inv' ) ?>isible.gif" border="0" align="middle" alt="Toggle Visible status">
</a>
<?php } else { ?>
<img src="Inc/Images/EditNewsLocked.gif" border="0" align="middle" alt="Locked!">
<a href="<?=$AdminScript?>?action=news&mode=copy&id=<?=$ArticleID?>" title="Copy News">
<img src="Inc/Images/CopyNews.gif" border="0" align="middle" alt="Copy to New Posting">
</a>
<img src="Inc/Images/RemoveNewsLocked.gif" border="0" align="middle" alt="Locked!">
<img src="Inc/Images/<?= ($Sticky == '1' ? '' : 'Non' ) ?>StickyLocked.gif" border="0" align="middle" alt="Locked!">
<img src="Inc/Images/<?= ($Visible == '1' ? 'V' : 'Inv' ) ?>isibleLocked.gif" border="0" align="middle" alt="Locked!">
<?php
}
if ($LoggedInCanChangeLock)
{
?>
<a href="<?=$AdminScript?>?action=DoLock&id=<?=$ArticleID?>" title="Toggle Lock">
<img src="Inc/Images/<?= ($Locked == '1' ? '' : 'Un' ) ?>Locked.gif" border="0" align="middle" alt="Toggle Lock status">
</a>
<?php
}
?>
</td>
<td class="<?=$liststyle ?>">
<?=$newsrow['Priority']?>
</td>
<td class="<?=$liststyle ?>">
<?=$newsrow['Headline']?><?= ($newsrow['Archived'] == 1 ? ' (Archived) ' : '') ?><br />
<div class="NewsListDateTime"><?= $ShowDateString ?> (ID=<?=$ArticleID?>)</div>
</td>
</tr>
<?php
}
?>
</table>
<br /><br />
<div align="center">
<?= $PageNavBar ?>
<br /><br />
<img src="Inc/Images/EditNews.gif" border="0" align="middle" alt="Edit"> Edit |
<img src="Inc/Images/RemoveNews.gif" border="0" align="middle" alt="Remove"> Delete
</div>
</td>
</tr>
</table>