<?PHP
ob_start();
session_start();
include("../includes/globals.php.inc");
include("../includes/functions.php");
include("../lang/English.php");
if(strtolower($sxSetup['Language']) != 'english') include("../lang/".$sxSetup['Language'].".php");
include("../themes/$THEME_FOLDER/config.php.inc");
if((!userEditor())AND(!userAdmin()))  loginError($sxLang['LoginRequired']);
if((userEditor())AND(!$sxSetup['EditorRightsEventsManage']))  loginError($sxLang['LoginRequired']);

if($deactivate)
{
	$query = "UPDATE $DB_Events SET active='0' WHERE id='$deactivate'";
	$result = mysql_query($query, $Link) or queryError("914", mysql_error());
}
if($activate)
{
	$query = "UPDATE $DB_Events SET active='1' WHERE id='$activate'";
	$result = mysql_query($query, $Link) or queryError("915", mysql_error());
}

if($delete)
{
	$query = "DELETE FROM $DB_Events WHERE id='$delete'";
	$result = mysql_query($query, $Link) or queryError("901", mysql_error());
	$query = "DELETE FROM $DB_Events_Private WHERE eventid='$delete'";
	$result = mysql_query($query, $Link) or queryError("902", mysql_error());
	$message = $sxLang['MessageEventDeleted'];
}

// Time filter
if($sxViewOnly == 'future')
	$sxWhereClause = "WHERE start_timestamp>'$NOW'";
if($sxViewOnly == 'past')
	$sxWhereClause = "WHERE start_timestamp<'$NOW'";

// Page turning code
$query = "SELECT * FROM $DB_Events $sxWhereClause";
$result = mysql_query($query, $Link) or queryError("903", mysql_error());
$totalElements = mysql_num_rows($result);

$elements_per_page = $sxThemeConfig['AdminEventsPerPage'];
if(!$page)
	$page = 1;
$start = ($page - 1)*$elements_per_page;

$sxTitleAddendum = $sxLang['AdminHeading'];
include("../themes/$THEME_FOLDER/header.php");
?>
<script language="JavaScript" type="text/JavaScript">
<!--
function confirmDelete(theID,theName){
	if(confirm("<?PHP echo $sxLang['GeneralJSDeleteEntry3']; ?> '"+theName+"' <?PHP echo $sxLang['GeneralJSDeleteEntry2']; ?>")){
		window.location='<?PHP print $PHP_SELF."?delete="; ?>'+theID;
	}
}
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>    
<div class="bodyWrapper">
   <h1 class="sxAdminHeading"><?PHP echo getComponentName("8").' '.$sxLang['GeneralHeadingManager']; ?></h1>
   <div class="sxAdminBreadcrumbs"><?PHP if(userAdmin()) { ?><a href="index.php"><?PHP echo $sxLang['AdminBreadcrumb']; ?><?PHP }?><?PHP if(userEditor()) { ?><a href="editor_index.php"><?PHP echo $sxLang['EditorBreadcrumb']; ?><?PHP }?></a> > <?PHP echo getComponentName("8").' '.$sxLang['GeneralHeadingManager']; ?></div>   
   <?PHP echoMessage($message); ?>
	<table border="0" cellspacing="2" cellpadding="5">
	  <tr>
		<td colspan="4"><div class="pageTurns"><?PHP pageTurns("$PHP_SELF?sxViewOnly=$sxViewOnly&", $totalElements, $page, $elements_per_page); ?></div></td>
	  </tr>
	  <tr>
		<td colspan="3"><form name="sxForm1">
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td align="left">
			 <select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
			  <option value="<?PHP echo $PHP_SELF; ?>"<?PHP if(!$sxViewOnly) echo ' selected'; ?>><?PHP echo $sxLang['EventFilterAll']; ?></option>
			  <option value="<?PHP echo $PHP_SELF."?sxViewOnly=future"; ?>"<?PHP if($sxViewOnly == 'future') echo ' selected'; ?>><?PHP echo $sxLang['EventFilterFuture']; ?></option>
			  <option value="<?PHP echo $PHP_SELF."?sxViewOnly=past"; ?>"<?PHP if($sxViewOnly == 'past') echo ' selected'; ?>><?PHP echo $sxLang['EventFilterPast']; ?></option>
			 </select>
			</td>
			<td align="right">
			  <?PHP if((userAdmin())OR($sxSetup['EditorRightsEventsAdd'])) { ?>&nbsp;&nbsp;&nbsp;&nbsp;<input name="AddEvent" style="width:150px;" type="button" value="<?PHP echo $sxLang['EventButtonAddEventNew']; ?>" onclick="window.location='event_add.php'" /><?PHP } ?>
			</td>
		  </tr>
		  </table></form>
		</td>
	  </tr>
	  <tr>
		<td class="tableColumn"><?PHP echo $sxLang['GeneralItemActive']; ?></td>
		<td class="tableColumn"><?PHP echo $sxLang['EventItemShortName']; ?></td>
		<td class="tableColumn"><?PHP echo $sxLang['GeneralItemDate']; ?></td>
		<td class="tableColumn"><?PHP echo $sxLang['GeneralItemOptions']; ?></td>
	 </tr>
	<?PHP
	$query = "SELECT * FROM $DB_Events $sxWhereClause ORDER BY start_timestamp DESC LIMIT $start, $elements_per_page";
	$result = mysql_query($query, $Link) or queryError("904", mysql_error());
	while($ROW = mysql_fetch_object($result))
	{
		echo '  <tr bgcolor="' . $sxTheme['ColorTableRow'] . '">';
		if($ROW->active == 1)
			echo '     <td><a href="'.$PHP_SELF.'?deactivate='.$ROW->id.'" title="'.$sxLang['ImgAltDeactivate'].'"><img src="../images/check.gif" style="border: 0;" alt="'.$sxLang['ImgAltDeactivate'].'" /></a></td>';
		else
			echo '     <td><a href="'.$PHP_SELF.'?activate='.$ROW->id.'" title="'.$sxLang['ImgAltActivate'].'"><img src="../images/x.gif" style="border: 0;" alt="'.$sxLang['ImgAltActivate'].'" /></a></td>';			
		echo '     <td><a href="event_edit.php?eventid=' . $ROW->id . '">' . $ROW->shortname . '</a></td>';
		echo '     <td>' . getFormattedEventDate($ROW->allday, $ROW->start_timestamp, $ROW->end_timestamp, 0) . '</td>';
		echo '     <td><a href="#" onclick="window.location=\'event_edit.php?eventid=' . $ROW->id . '\'" title="' . $sxLang['ButtonEdit'] .'"><img src="../images/admin_edit.gif" style="border: 0;" alt="' . $sxLang['ButtonEdit'] .'" /></a> ';
		echo '         <a href="#" onclick="confirmDelete(' . $ROW->id . ',\'' . $ROW->shortname . '\')" title="' . $sxLang['ButtonDelete'] .'"><img src="../images/admin_delete.gif" style="border: 0;" alt="' . $sxLang['ButtonDelete'] .'" /></a></td>';
		echo '  </tr>';
	}
	if(mysql_num_rows($result) == 0)
		echo '<tr bgcolor="' . $sxTheme['ColorTableRow'] . '"><td colspan="3"><em>' . $sxLang['NoEntries'] . '</em></td></tr>';
	?><tr>
	<td colspan="4"><div style="padding-top:8px;padding-bottom:8px;font-size:10px;"><?PHP pageTurns("$PHP_SELF?sxViewOnly=$sxViewOnly&", $totalElements, $page, $elements_per_page); ?></div></td>
  </tr>
  </table>
</div>
<?PHP
include("../themes/$THEME_FOLDER/footer.php");
ob_end_flush();
?>