Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
cleanup-images.php	1.14 KB	-rw-r--r--	2025-06-27 10:14
php_errors.log	6.04 KB	-rw-r--r--	2026-08-21 08:11
reading-library.html.php	5.2 KB	-rw-r--r--	2026-04-29 07:23
recommended-reading.html.php	4.41 KB	-rw-r--r--	2026-04-29 07:23
resource-centre.html.php	4.7 KB	-rw-r--r--	2026-06-01 08:49
templates.html.php	3.25 KB	-rw-r--r--	2026-04-29 07:23

Rename

<?php
//ini_set('display_errors', 1);
//error_reporting(E_ALL);

include($_SERVER['DOCUMENT_ROOT'] . "/cesanet/inc_functions.php");

$searchText = setSessionVar('library_search_text', getRequestVar('library_search_text', ''));
$resourceGroupID = setSessionVar('library_cce_resource_group_id', getRequestVar('library_cce_resource_group_id', ''));
$archived = setSessionVar('library_archived', getRequestVar('library_archived', 0));
?>
<h1> Resource Centre
    <?php
    if (!CurrentStudent())
        echo " - Archived " . $_SESSION["StudentYear"];
    ?>
</h1>
<?php
$pageNum = getRequestVar('pageNum', 1);
$ipp = getRequestVar('ipp', 20);
$docSQL = "CCEResourceGroups rg "
        . "WHERE (rg.CCEResourceGroupName <> '' OR rg.CCEResourceGroupURL <> '') ";

if (strlen($searchText) > 0) {
    $searchText = str_replace(' ', '%', $searchText);
    $docSQL .= " AND ("
//            . "r.ResourceName LIKE '%" . $searchText . "%' OR r.ResourceURL LIKE '%" . $searchText . "%' OR "
            . "rg.CCEResourceGroupName LIKE '%" . $searchText . "%'" . " OR rg.CCEResourceGroupURL LIKE '%" . $searchText . "%')";
}

//if ($resourceGroupID > 0) {
//    $docSQL .= " AND rg.CCEResourceGroupID = " . $resourceGroupID;
//}
//if (CurrentStudent() && $archived == 0) {
//    $docSQL .= " AND r.Archived=0";
//} elseif ($archived == 1) {
//    $docSQL .= " AND r.Archived=1";
//} else {
//    $docSQL .= " AND r.Archived=1 AND r.ArchiveYear<=" . $_SESSION["StudentYear"];
//}
//$docSQL .= 'GROUP BY rg.CCEResourceGroupName';
//echo $docSQL;

$resources = HTMLHelper::getPaginated(
                $sqlf,
                $docSQL,
                array('rg.CCEResourceGroupName' => 'ASC'),
                $ipp,
                $pageNum,
                array('select-all-class' => 'resource-center-pager-links')
);

if ($resources['totalRecords'] > 0) {
    $prevResourceGroup = 0;
    ?>
    <table class="table" border="0" cellpadding="4" cellspacing="0">
        <tr>
            <th colspan="8">
                <?php echo $resources['pageSentences'] ?>
                <?php echo $resources['pageNav'] ?>
            </th>
        </tr>
        <?php
        foreach ($resources['records'] as $resourcesLink) {

//            var_dump($resourcesLink);
//            exit;
            if ($prevResourceGroup != $resourcesLink['CCEResourceGroupID'] && $resourcesLink['CCEResourceGroupName'] != '') {
                ?>
                <tr>
                    <th colspan="2">
                        <?php
                        if (trim($resourcesLink["CCEResourceGroupURL"]) != '') {

$resourcesLink["CCEResourceGroupURL"] = str_replace('https//', 'https://', trim($resourcesLink["CCEResourceGroupURL"]));
                            
                            ?>
                            <a href="<?php
                            
                            if (substr($resourcesLink["CCEResourceGroupURL"], 0, 7) != "http://" && substr($resourcesLink["CCEResourceGroupURL"], 0, 8) != "https://") {
                                echo 'http://';
                            }

echo $resourcesLink['CCEResourceGroupURL'];
                            
                            ?>" target="_blank"><?php echo $resourcesLink['CCEResourceGroupName']; ?></a>
                               <?php
                           } else {
                               echo $resourcesLink['CCEResourceGroupName'];
                           }
                           ?>
                    </th>
                </tr>
                <?php
                ?>
            
                <?php
                $prevResourceGroup = $resourcesLink['CCEResourceGroupID'];
            }

/*
              if ($resourcesLink['ResourceName'] != '' && $resourcesLink['ResourceURL'] != '') {
              ?>
              <tr>
              <td>&nbsp;</td>
              <td colspan="2">
              <a href="<?php
              if (substr($resourcesLink["ResourceURL"], 0, 7) != "http://" || substr($resourcesLink["ResourceURL"], 0, 8) != "https://") {
              echo 'http://';
              }
              echo $resourcesLink['ResourceURL'];
              ?>" target="_blank"><?php echo $resourcesLink['ResourceName']; ?></a>
              </td>
              </tr>
              <?php
              }
             *
             */
        } //foreach
        ?>
    </table>
    <?php
} else {
    ?>
    <div class="alert alert-warning">No Resources found</div>
    <?php
    if (strlen($resources['error']) > 0) {
        echo $resources['error'];
    }
}