Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
feedbackformsreport.php	3.94 KB	-rw-r--r--	2026-08-24 10:15
feedbackformsreportexport.php	1.93 KB	-rw-r--r--	2026-08-24 10:15
guideline-view.php	1.23 KB	-rw-r--r--	2026-02-13 11:49
guideline.php	4.36 KB	-rw-r--r--	2026-02-13 11:49
memorandum.php	3.7 KB	-rw-r--r--	2026-08-24 10:15

Rename

<?php
/**
 * BCE Guideline list content template.
 * Expects: $guidelines, $categoryId, $sqlfWP, $baseUrl (e.g. '/cesanet', '/cceconvenors', '/cceadmin')
 */
if (!isset($guidelines) || !isset($categoryId) || !isset($sqlfWP) || !isset($baseUrl)) {
    return;
}
if ($categoryId != 24) {
?>
    <div class="text-end">
        <a href="<?php echo htmlspecialchars($baseUrl); ?>/guideline.php" class="btn">Back to Introduction</a>
    </div>
<?php
}
?>
<div class="row">
    <?php
    foreach ($guidelines as $guideline) {
        $postMeta = $sqlfWP->getRow("SELECT * "
            . "FROM wp_4_posts p "
            . "INNER JOIN wp_4_postmeta pm ON p.ID = pm.post_id "
            . "WHERE p.ID = " . $guideline['ID'] . " "
            . "AND pm.meta_key = '_thumbnail_id'");

if (!$postMeta) {
            $postMeta = array('meta_value' => -1);
        }

$postLink = $sqlfWP->getRow("SELECT * "
            . "FROM wp_4_posts p "
            . "INNER JOIN wp_4_postmeta pm ON p.ID = pm.post_id "
            . "WHERE p.ID = " . $guideline['ID'] . " "
            . "AND pm.meta_key = 'client_url'");
        $subCat = 0;

if (!$postLink) {
            $postLink = array('meta_value' => $baseUrl . '/guideline-view.php?ID=' . $guideline['ID']);
        } else {
            $parts = explode('=', $postLink['meta_value']);
            $subCat = array_pop($parts);
            $postLink['meta_value'] = str_replace('/cesanet', $baseUrl, $postLink['meta_value']);
        }

$postThumb = $sqlfWP->getRow("SELECT * "
            . "FROM wp_4_posts p "
            . "WHERE p.ID = " . $postMeta['meta_value']);
    ?>
        <div class="col-sm-12 col-lg-6">
            <div class="well">
                <div class="text-center">
                    <img src="<?php echo htmlspecialchars($postThumb['guid']); ?>" class="img img-responsive" border="0" alt="<?php echo htmlspecialchars($postThumb['post_title']); ?>" />
                </div>
                <div class="content-block">
                    <h3><?php echo htmlspecialchars($guideline['post_title']); ?></h3>
                    <p class="text-start"><?php echo $guideline['post_excerpt']; ?></p>
                    <p class="text-end"><a href="<?php echo htmlspecialchars($postLink['meta_value']); ?>">Read more...</a></p>
                </div>
                <?php
                if ($subCat > 0) {
                    $pages = $sqlfWP->getAll("SELECT * "
                        . "FROM wp_4_posts p "
                        . "LEFT JOIN wp_4_term_relationships rel ON rel.object_id = p.ID "
                        . "LEFT JOIN wp_4_term_taxonomy tax ON tax.term_taxonomy_id = rel.term_taxonomy_id "
                        . "LEFT JOIN wp_4_terms t ON t.term_id = tax.term_id "
                        . "WHERE t.term_id = " . (int) $subCat);
                    if (count($pages)) {
                ?>
                        <ul>
                            <?php
                            foreach ($pages as $page) {

$subPostLink = $sqlfWP->getRow("SELECT * "
                                    . "FROM wp_4_posts p "
                                    . "INNER JOIN wp_4_postmeta pm ON p.ID = pm.post_id "
                                    . "WHERE p.ID = " . $page['ID'] . " "
                                    . "AND pm.meta_key = 'client_url'");
                                $subPage = 0;

if ($subPostLink) {
                                    $subParts = explode('=', $subPostLink['meta_value']);
                                    $subPage = array_pop($subParts);
                                }

if ($subPage > 0) {
                                    $subLink = $baseUrl . '/guideline.php?category_id=' . $subPage;
                                } else {
                                    $subLink = $baseUrl . '/guideline-view.php?ID=' . $page['ID'];
                                }
                            ?>
                                <li><a href="<?php echo htmlspecialchars($subLink); ?>"><?php echo htmlspecialchars($page['post_title']); ?></a></li>
                            <?php
                            }
                            ?>
                        </ul>
                <?php
                    }
                }
                ?>
            </div>
        </div>
    <?php
    }
    ?>
</div>