Gecko [ admjudic.com.br ]

Name	Size	Permission
backup	[ DIR ]	drwxr-xr-x
classes	[ DIR ]	drwxr-xr-x
db	[ DIR ]	drwxr-xr-x
formats	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
pix	[ DIR ]	drwxr-xr-x
tests	[ DIR ]	drwxr-xr-x
README.txt	1.7 KB	-rw-r--r--
TODO.txt	607 B	-rw-r--r--
approve.php	2.22 KB	-rw-r--r--
deleteentry.php	2.76 KB	-rw-rw-r--
deprecatedlib.php	2.27 KB	-rw-r--r--
edit.php	3.24 KB	-rw-rw-r--
edit_form.php	6.72 KB	-rw-r--r--
editcategories.html	3.29 KB	-rw-r--r--
editcategories.php	10.82 KB	-rw-r--r--
export.php	2.62 KB	-rw-rw-r--
exportentry.php	4.36 KB	-rw-r--r--
formats.php	9.49 KB	-rw-r--r--
import.php	15.35 KB	-rw-rw-r--
import_form.php	1.14 KB	-rw-rw-r--
index.php	4.34 KB	-rw-r--r--
lib.php	163.62 KB	-rw-rw-r--
locallib.php	29.11 KB	-rw-r--r--
mod_form.php	10.57 KB	-rw-r--r--
print.php	6.89 KB	-rw-r--r--
rsslib.php	7.87 KB	-rw-r--r--
settings.php	2.7 KB	-rw-r--r--
showentry.php	3.12 KB	-rw-rw-r--
showentry_ajax.php	3.77 KB	-rw-r--r--
sql.php	3.83 KB	-rw-r--r--
styles.css	2.5 KB	-rw-r--r--
tabs.php	3.86 KB	-rw-rw-r--
upgrade.txt	1.25 KB	-rw-r--r--
version.php	1.2 KB	-rw-rw-r--
view.php	19.53 KB	-rw-rw-r--

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