| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST2146/VM_Data/Data_WWW/scheduler/admin/page/ |
Upload File : |
<?
// admin/page/index.php
// Website administration main page.
$authorizedPermissions = 'Admin';
require('../../application.phpinc'); // Include application setup file. Use a relative path.
$query = "
SELECT pageId,
pageURL,
pageDescription
FROM `page`
ORDER BY pageURL
";
$pageResult = query_do($query);
$pageCount = $GLOBALS['_QUERY']['count'];
pageHeader("Page administration");
if ($pageCount) {
?>
<table>
<tr style="vertical-align:bottom;">
<th>
<form name="addPage" action="page.php" method="post">
<input type="hidden" name="pageId" id="pageId" value="0">
<input type="submit" name="task" value="Add">
</form>
</th>
<th>URL</th>
<th>Description</th>
<th>Groups</th>
</tr>
<?
query_seek($pageResult, 0);
while ($pageInfo = query_row($pageResult)) {
// Get the list of groups for this page.
$query = "
SELECT userpermission.userpermissionName
FROM `userpermission`
INNER JOIN group_page ON userpermission.userpermissionId = group_page.userpermissionId
WHERE group_page.pageId = ".$pageInfo['pageId']."
ORDER BY userpermission.userpermissionName
";
$group_pageResult = query_do($query);
$group_pageCount = $GLOBALS['_QUERY']['count'];
#if ($group_pageCount) #d_Var('$group_pageResult',$group_pageResult);
$groupList = query_to_list($group_pageResult); if ( !$groupList ) $groupList = '0';
?>
<tr>
<td>
<form name="editPage_<?=$pageInfo['pageId']?>" action="page.php" method="post">
<input type="hidden" name="pageId" id="pageId" value="<?=$pageInfo['pageId']?>">
<input type="submit" name="task" value="Edit">
</form>
</td>
<?
$f['pageURL'] = 'http://'.$_SERVER['SERVER_NAME'].'/'.$pageInfo['pageURL'];
#if (substr($f['pageURL'],strlen($f['pageURL'])-9,9) == 'index.php') $f['pageURL'] = str_replace('index.php','',$f['pageURL']);
?>
<td><?=$f['pageURL']?></td>
<td><?=$pageInfo['pageDescription']?></td>
<td><?=listAnd($groupList)?></td>
</tr>
<?
}
?>
</table>
<?
} else {
?>
<form name="addPage" action="page.php" method="post" class="inline">
<input type="hidden" name="pageId" id="pageId" value="0">
There are no pages. You can <input type="submit" name="task" value="Add" style="font-size:smaller;"> one.
</form>
<?
}
?>
<p>
<?
pageFooter();
?>