source: trunk/services/admins.php @ 432

Last change on this file since 432 was 432, checked in by anonymous, 11 years ago

Removed all usage of 'user_type' from admin management; minor update to module maker.

File size: 21.7 KB
RevLine 
[1]1<?php
2/**
[362]3 * The Strangecode Codebase - a general application development framework for PHP
4 * For details visit the project site: <http://trac.strangecode.com/codebase/>
[396]5 * Copyright 2001-2012 Strangecode, LLC
[362]6 *
7 * This file is part of The Strangecode Codebase.
8 *
9 * The Strangecode Codebase is free software: you can redistribute it and/or
10 * modify it under the terms of the GNU General Public License as published by the
11 * Free Software Foundation, either version 3 of the License, or (at your option)
12 * any later version.
13 *
14 * The Strangecode Codebase is distributed in the hope that it will be useful, but
15 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
16 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
17 * details.
18 *
19 * You should have received a copy of the GNU General Public License along with
20 * The Strangecode Codebase. If not, see <http://www.gnu.org/licenses/>.
21 */
22
23/**
[42]24 * admins.php
[1]25 */
26
27// require_once dirname(__FILE__) . '/_config.inc.php';
28
29$auth->requireLogin();
[136]30$app->sslOn();
[1]31
32require_once 'codebase/lib/PageNumbers.inc.php';
[136]33require_once 'codebase/lib/Cache.inc.php';
[1]34require_once 'codebase/lib/FormValidator.inc.php';
35require_once 'codebase/lib/SortOrder.inc.php';
36require_once 'codebase/lib/TemplateGlue.inc.php';
37require_once 'codebase/lib/Prefs.inc.php';
[137]38require_once 'codebase/lib/Lock.inc.php';
39require_once 'codebase/lib/Version.inc.php';
[1]40
41
[143]42/********************************************************************
43* CONFIG
44********************************************************************/
[42]45
[1]46// Titles and navigation header.
[202]47$nav->add(_("Administrators"), null);
[42]48
[1]49// The object to validate form input.
50$fv = new FormValidator();
51
[152]52// Configure the prefs object.
[153]53$tmp_prefs = new Prefs('admins');
54$tmp_prefs->setParam(array('persistent' => false));
[136]55
[152]56// Configure the cache object.
[153]57$cache = new Cache('admins');
[405]58$cache->setParam(array('enabled' => false)); // Better leave disabled; the list gets out of sync with the db otherwise, somehow.
[152]59
[1]60// Instantiate a sorting object with the default sort and order. Add SQL for each column.
[295]61$so = new SortOrder('admin_id', 'DESC');
62$so->setColumn('admin_id', $auth->getParam('db_primary_key') . ' ASC', $auth->getParam('db_primary_key') . ' DESC');
63$so->setColumn('username', $auth->getParam('db_username_column') . ' ASC', $auth->getParam('db_username_column') . ' DESC');
64$so->setColumn('userpass', $auth->getParam('db_table') . '.userpass ASC', $auth->getParam('db_table') . '.userpass DESC');
65$so->setColumn('first_name', $auth->getParam('db_table') . '.first_name ASC', $auth->getParam('db_table') . '.first_name DESC');
66$so->setColumn('last_name', $auth->getParam('db_table') . '.last_name ASC', $auth->getParam('db_table') . '.last_name DESC');
67$so->setColumn('email', $auth->getParam('db_table') . '.email ASC', $auth->getParam('db_table') . '.email DESC');
68$so->setColumn('seconds_online', $auth->getParam('db_table') . '.seconds_online ASC', $auth->getParam('db_table') . '.seconds_online DESC');
69$so->setColumn('last_login_datetime', $auth->getParam('db_table') . '.last_login_datetime ASC', $auth->getParam('db_table') . '.last_login_datetime DESC');
70$so->setColumn('last_access_datetime', $auth->getParam('db_table') . '.last_access_datetime ASC', $auth->getParam('db_table') . '.last_access_datetime DESC');
71$so->setColumn('last_login_ip', $auth->getParam('db_table') . '.last_login_ip ASC', $auth->getParam('db_table') . '.last_login_ip DESC');
72$so->setColumn('added_by_user_id', $auth->getParam('db_table') . '.added_by_user_id ASC', $auth->getParam('db_table') . '.added_by_user_id DESC');
73$so->setColumn('modified_by_user_id', $auth->getParam('db_table') . '.modified_by_user_id ASC', $auth->getParam('db_table') . '.modified_by_user_id DESC');
74$so->setColumn('added_datetime', $auth->getParam('db_table') . '.added_datetime ASC', $auth->getParam('db_table') . '.added_datetime DESC');
75$so->setColumn('modified_datetime', $auth->getParam('db_table') . '.modified_datetime ASC', $auth->getParam('db_table') . '.modified_datetime DESC');
[1]76
77// Instantiate page numbers. Total items are set and calculation is done in the getRecordList function.
78$page = new PageNumbers();
79$page->setPerPage(getFormData('per_page'), 50);
80$page->setPageNumber(getFormData('page_number'));
81
[408]82// Query parameters to retain only locally.
83$locally_carried_queries = array(
84    'search_query',
85);
[1]86
[143]87/********************************************************************
88* MAIN
89********************************************************************/
[42]90
[1]91// We may want to use the add/edit interface from another script, so this
92// allows us to remember which page we came from so we can go back there.
[20]93if (getFormData('boomerang', false) && isset($_SERVER['HTTP_REFERER'])) {
[136]94    $app->setBoomerangURL($_SERVER['HTTP_REFERER'], 'admins');
[1]95}
96
97if (getFormData('break_list_cache', false)) {
[152]98    // Remove any stale cached list data.
99    $cache->delete('list');
[1]100}
101
102// What action to take.
103switch (getFormData('op')) {
104
105case 'add' :
106    // Initialize variables for the form template.
107    $frm =& addRecordForm();
[266]108    $nav->add(_("Add Administrator"));
[1]109    $main_template = 'admin_form.ihtml';
110    break;
111
112case 'edit' :
113    // Initialize variables for the form template.
114    $frm =& editRecordForm(getFormData('admin_id'));
[266]115    $nav->add(_("Edit Administrator"));
[1]116    $main_template = 'admin_form.ihtml';
117    break;
118
119case 'del' :
120    deleteRecord(getFormData('admin_id'));
[136]121    if ($app->validBoomerangURL('admins')) {
[1]122        // Display boomerang page.
[408]123        $app->dieBoomerangURL('admins', $locally_carried_queries);
[1]124    }
125    // Display default page.
[408]126    $app->dieURL($_SERVER['PHP_SELF'], $locally_carried_queries);
[1]127    break;
128
129case 'insert' :
130    if (getFormdata('cancel', false)) {
[136]131        if ($app->validBoomerangURL('admins')) {
[22]132            // Display boomerang page.
[408]133            $app->dieBoomerangURL('admins', $locally_carried_queries);
[22]134        }
135        // Display default page.
[408]136        $app->dieURL($_SERVER['PHP_SELF'], $locally_carried_queries);
[1]137    }
138    validateInput();
139    if ($fv->anyErrors()) {
140        $frm =& addRecordForm();
141        $frm = array_merge($frm, getFormData());
[266]142        $nav->add(_("Add Administrator"));
[1]143        $main_template = 'admin_form.ihtml';
144    } else {
145        $admin_id = insertRecord(getFormData());
146        if (getFormdata('repeat', false)) {
147            // Display function again.
[408]148            $app->dieURL($_SERVER['PHP_SELF'] . '?op=add', $locally_carried_queries);
[136]149        } else if ($app->validBoomerangURL('admins')) {
[1]150            // Display boomerang page.
[408]151            $app->dieBoomerangURL('admins', $locally_carried_queries);
[1]152        }
153        // Display default page.
[408]154        $app->dieURL($_SERVER['PHP_SELF'], $locally_carried_queries);
[1]155    }
156    break;
157
158case 'update' :
159    if (getFormdata('reset', false)) {
[136]160        $app->raiseMsg(_("Saved values have been reloaded."), MSG_NOTICE, __FILE__, __LINE__);
[408]161        $app->dieURL($_SERVER['PHP_SELF'] . '?op=edit&admin_id=' . getFormData('admin_id'), $locally_carried_queries);
[1]162    }
163    if (getFormdata('cancel', false)) {
164        // Remove lock
[295]165        $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), getFormData('admin_id'));
[1]166        $lock->remove();
[136]167        if ($app->validBoomerangURL('admins')) {
[1]168            // Display boomerang page.
[408]169            $app->dieBoomerangURL('admins', $locally_carried_queries);
[1]170        }
171        // Display default page.
[408]172        $app->dieURL($_SERVER['PHP_SELF'], $locally_carried_queries);
[1]173    }
174    validateInput();
175    if ($fv->anyErrors()) {
176        $frm =& editRecordForm(getFormData('admin_id'));
177        $frm = array_merge($frm, getFormData());
[266]178        $nav->add(_("Edit Administrator"));
[1]179        $main_template = 'admin_form.ihtml';
180    } else {
181        updateRecord(getFormData());
182        if (getFormdata('repeat', false)) {
183            // Display edit function with next available ID.
[295]184            $qid = $db->query("SELECT " . $auth->getParam('db_primary_key') . " FROM " . $auth->getParam('db_table') . " WHERE " . $auth->getParam('db_primary_key') . " > '" . $db->escapeString(getFormData('admin_id')) . "' ORDER BY " . $auth->getParam('db_primary_key') . " ASC LIMIT 1");
[1]185            if (list($next_id) = mysql_fetch_row($qid)) {
[408]186                $app->dieURL($_SERVER['PHP_SELF'] . '?op=edit&admin_id=' . $next_id, $locally_carried_queries);
[1]187            } else {
[136]188                $app->raiseMsg(_("Cannot edit next, the end of the list was reached"), MSG_NOTICE, __FILE__, __LINE__);
[1]189            }
[136]190        } else if ($app->validBoomerangURL('admins')) {
[1]191            // Display boomerang page.
[408]192            $app->dieBoomerangURL('admins', $locally_carried_queries);
[1]193        }
194        // Display default page.
[408]195        $app->dieURL($_SERVER['PHP_SELF'], $locally_carried_queries);
[1]196    }
197    break;
198
199default :
200    $list =& getRecordList();
201    $main_template = 'admin_list.ihtml';
202    break;
203}
204
205/******************************************************************************
206 * TEMPLATE INITIALIZATION
207 *****************************************************************************/
208
209include 'header.ihtml';
[408]210$app->carryQuery($locally_carried_queries);
[1]211include 'codebase/services/templates/' . $main_template;
212include 'footer.ihtml';
213
[143]214/********************************************************************
215* FUNCTIONS
216********************************************************************/
[1]217
218
219function validateInput()
220{
221    global $fv, $auth;
222
223    // If the username was changed during edit, verify.
224    if (((getFormData('username') != getFormData('old_username')) && 'update' == getFormData('op'))
225    || 'insert' == getFormData('op')) {
226        if ($auth->usernameExists(getFormData('username'))) {
[141]227            $fv->addError('username', sprintf(_("The username %s already exists. Please choose another."), getFormData('username')));
[1]228        }
229    }
230
231    $fv->numericRange('admin_id', -32768, 32767, _("<strong>Admin id</strong> must be a valid number between -32768 and 32767."));
232
233    $fv->isEmpty('username', _("<strong>Username</strong> cannot be blank."));
234    $fv->stringLength('username', 0, 255, _("<strong>Username</strong> must contain less than 256 characters."));
[42]235
[1]236    $fv->isEmpty('userpass', _("<strong>Passwords</strong> cannot be blank."));
237    $fv->stringLength('userpass', 6, 36, _("<strong>Passwords</strong> must be between 6 and 36 characters long."));
[42]238
[1]239    $fv->stringLength('first_name', 0, 255, _("<strong>First name</strong> must contain less than 256 characters."));
[42]240
[1]241    $fv->stringLength('last_name', 0, 255, _("<strong>Last name</strong> must contain less than 256 characters."));
[19]242
243    $fv->isEmpty('email', _("<strong>Email</strong> cannot be blank."));
[1]244    $fv->stringLength('email', 0, 255, _("<strong>Email</strong> must contain less than 256 characters."));
245    $fv->validateEmail('email');
246}
247
248function &addRecordForm()
249{
[19]250    // Set default values for the reset of the fields.
251    $frm = array(
252        'admin_id' => '',
[72]253        'old_username' => '',
[19]254        'username' => '',
255        'userpass' => '',
256        'first_name' => '',
257        'last_name' => '',
258        'email' => '',
259        'seconds_online' => '0',
260        'last_login_datetime' => '0000-00-00 00:00:00',
261        'last_access_datetime' => '0000-00-00 00:00:00',
262        'last_login_ip' => '0.0.0.0',
263        'added_by_user_id' => '',
264        'modified_by_user_id' => '',
265        'added_datetime' => '0000-00-00 00:00:00',
266        'modified_datetime' => '0000-00-00 00:00:00',
267        'new_op' => 'insert',
268        'submit_buttons' => array(
[266]269            'submit' => _("Add Administrator"),
[19]270            'repeat' => _("Add &amp; repeat"),
271            'cancel' => _("Cancel"),
272        ),
273    );
[1]274
275    return $frm;
276}
277
278function &editRecordForm($id)
279{
[295]280    global $auth;
[22]281    global $lock;
[136]282    $app =& App::getInstance();
283    $db =& DB::getInstance();
284   
[295]285    $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id);
[1]286    if ($lock->isLocked() && !$lock->isMine()) {
287        $lock->dieErrorPage();
[19]288    }
289
290    // Get the information for the form.
[136]291    $qid = $db->query("
[295]292        SELECT *,
293        " . $auth->getParam('db_primary_key') . " AS admin_id
294        FROM " . $auth->getParam('db_table') . "
295        WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "'
[19]296    ");
297    if (!$frm = mysql_fetch_assoc($qid)) {
[136]298        $app->logMsg('Could not find record with admin_id: ' . $id, LOG_WARNING, __FILE__, __LINE__);
299        $app->raiseMsg(sprintf(_("The requested record %s could not be found."), $id), MSG_ERR, __FILE__, __LINE__);
[408]300        $app->dieBoomerangURL('admins', $locally_carried_queries);
[19]301    }
[42]302
[19]303    // Lock this record.
[295]304    $lock->set($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id, $frm['username']);
[42]305
[19]306    // Set misc values for the form.
307    $frm = array_merge(array(
308        'admin_id' => '',
309        'old_username' => $frm['username'],
310        'username' => '',
311//         'userpass' => '****************',
312        'first_name' => '',
313        'last_name' => '',
314        'email' => '',
315        'seconds_online' => '0',
316        'last_login_datetime' => '0000-00-00 00:00:00',
317        'last_access_datetime' => '0000-00-00 00:00:00',
318        'last_login_ip' => '0.0.0.0',
319        'added_by_user_id' => '',
320        'modified_by_user_id' => '',
321        'added_datetime' => '0000-00-00 00:00:00',
322        'modified_datetime' => '0000-00-00 00:00:00',
323        'new_op' => 'update',
[25]324        'old_username' => $frm['username'],
[19]325        'submit_buttons' => array(
326            'submit' => _("Save changes"),
327            'repeat' => _("Save &amp; edit next"),
328            'reset' => _("Reset"),
329            'cancel' => _("Cancel"),
330        ),
331    ), $frm, array('userpass' => '****************'));
332
333    return $frm;
[1]334}
335
336function deleteRecord($id)
337{
[153]338    global $auth;
339    global $lock;
340    global $cache;
[136]341    $app =& App::getInstance();
342    $db =& DB::getInstance();
343   
[295]344    $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id);
[1]345    if ($lock->isLocked() && !$lock->isMine()) {
346        $lock->dieErrorPage();
[21]347    }
348
[152]349    // Remove any stale cached list data.
350    $cache->delete('list');
[42]351
[21]352    // Get the information for this object.
[136]353    $qid = $db->query("
[432]354        SELECT " . $auth->getParam('db_username_column') . "
[295]355        WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "'
[21]356    ");
[432]357    if (! list($name) = mysql_fetch_row($qid)) {
[136]358        $app->logMsg('Could not find record with admin_id: ' . $id, LOG_WARNING, __FILE__, __LINE__);
359        $app->raiseMsg(sprintf(_("The requested record %s could not be found."), $id), MSG_ERR, __FILE__, __LINE__);
[408]360        $app->dieBoomerangURL('admins', $locally_carried_queries);
[21]361    }
[42]362
[21]363    // Get the information for this object.
[295]364    $qid = $db->query("SELECT COUNT(*) from " . $auth->getParam('db_table') . "");
[21]365    list($num_admins) = mysql_fetch_row($qid);
[432]366    if ($num_admins <= 1) {
[21]367        // There must always be at least one admnistrator!
[136]368        $app->raiseMsg(_("You cannot delete the only administrator in the database. There must be at least one to log in and create other users."), MSG_NOTICE, __FILE__, __LINE__);
[147]369    } else if ($auth->get('user_id') == $id) {
[21]370        // Do not delete yourself!
[136]371        $app->raiseMsg(_("You cannot delete yourself."), MSG_NOTICE, __FILE__, __LINE__);
[1]372    } else {
[21]373        // Delete the record.
[295]374        $db->query("DELETE FROM " . $auth->getParam('db_table') . " WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "'");
[141]375        $app->raiseMsg(sprintf(_("The admin <em>%s</em> has been deleted."), $name), MSG_SUCCESS, __FILE__, __LINE__);
[21]376    }
[1]377
[21]378    // Unlock record.
379    $lock->remove();
[1]380}
381
382function insertRecord($frm)
383{
384    global $auth;
[153]385    global $cache;
[136]386    $app =& App::getInstance();
387    $db =& DB::getInstance();
388   
[152]389    // Remove any stale cached list data.
390    $cache->delete('list');
[42]391
[1]392    // Insert record data.
[136]393    $db->query("
[295]394        INSERT INTO " . $auth->getParam('db_table') . " (
395            " . $auth->getParam('db_username_column') . ",
[1]396            first_name,
397            last_name,
398            email,
[19]399            added_by_user_id,
[1]400            added_datetime
401        ) VALUES (
[136]402            '" . $db->escapeString($frm['username']) . "',
403            '" . $db->escapeString($frm['first_name']) . "',
404            '" . $db->escapeString($frm['last_name']) . "',
405            '" . $db->escapeString($frm['email']) . "',
[147]406            '" . $db->escapeString($auth->get('user_id')) . "',
[1]407            NOW()
408        )
409    ");
[136]410    $last_insert_id = mysql_insert_id($db->getDBH());
[42]411
[1]412    // Set admin password.
413    $auth->setPassword($last_insert_id, $frm['userpass']);
[42]414
[19]415    // Create version.
[159]416    $version = Version::getInstance($auth);
[295]417    $version->create($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $last_insert_id, $frm['username']);
[42]418
[266]419    $app->raiseMsg(sprintf(_("The Administrator <em>%s</em> has been added."), $frm['username']), MSG_SUCCESS, __FILE__, __LINE__);
[42]420
[1]421    return $last_insert_id;
422}
423
424function updateRecord($frm)
425{
[153]426    global $auth;
427    global $lock;
428    global $cache;
[136]429    $app =& App::getInstance();
430    $db =& DB::getInstance();
431   
[295]432    $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $frm['admin_id']);
[1]433    if ($lock->isLocked() && !$lock->isMine()) {
434        $lock->dieErrorPage();
[21]435    }
[1]436
[152]437    // Remove any stale cached list data.
438    $cache->delete('list');
[42]439
[21]440    // If the userpass is left blank or with the filler **** characters, we don't want to update it.
441    if (!empty($frm['userpass']) && !preg_match('/[\*]{4,}/', $frm['userpass'])) {
442        // Set user password.
443        $auth->setPassword($frm['admin_id'], $frm['userpass']);
444    }
[42]445
[21]446    // Update record data.
[136]447    $db->query("
[295]448        UPDATE " . $auth->getParam('db_table') . " SET
449            " . $auth->getParam('db_username_column') . " = '" . $db->escapeString($frm['username']) . "',
[136]450            first_name = '" . $db->escapeString($frm['first_name']) . "',
451            last_name = '" . $db->escapeString($frm['last_name']) . "',
452            email = '" . $db->escapeString($frm['email']) . "',
[147]453            modified_by_user_id = '" . $db->escapeString($auth->get('user_id')) . "',
[21]454            modified_datetime = NOW()
[295]455        WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($frm['admin_id']) . "'
[21]456    ");
[1]457
[21]458    // Create version.
[159]459    $version = Version::getInstance($auth);
[295]460    $version->create($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $frm['admin_id'], $frm['username']);
[21]461
[266]462    $app->raiseMsg(sprintf(_("The Administrator <em>%s</em> has been updated."), $frm['username']), MSG_SUCCESS, __FILE__, __LINE__);
[21]463
464    // Unlock record.
465    $lock->remove();
[1]466}
467
468function &getRecordList()
469{
470    global $page;
471    global $so;
[153]472    global $tmp_prefs;
473    global $cache;
[295]474    global $auth;
[136]475    $db =& DB::getInstance();
476   
[19]477    $where_clause = '';
[42]478
[19]479    // Build search query if available.
480    if (getFormData('search_query', false)) {
481        $qry_words = preg_split('/[^\w]/', getFormData('search_query'));
[1]482        for ($i=0; $i<sizeof($qry_words); $i++) {
[19]483            $where_clause .= (empty($where_clause) ? 'WHERE' : 'AND') . "
484                (
[295]485                    " . $auth->getParam('db_table') . "." . $auth->getParam('db_username_column') . " LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
486                    OR " . $auth->getParam('db_table') . ".first_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
487                    OR " . $auth->getParam('db_table') . ".last_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
488                    OR " . $auth->getParam('db_table') . ".email LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
[1]489                )
490            ";
491        }
492    }
[19]493
[1]494    // Count the total number of records so we can do something about the page numbers.
[136]495    $qid = $db->query("
[42]496        SELECT COUNT(*)
[295]497        FROM " . $auth->getParam('db_table') . "
[19]498        $where_clause
499    ");
[1]500    list($num_results) = mysql_fetch_row($qid);
[42]501
[1]502    // Set page numbers now we know (needed for next step).
503    $page->setTotalItems($num_results);
504    $page->calculate();
[42]505
[1]506    // Final SQL, with sort and page limiters.
507    $sql = "
[42]508        SELECT
[295]509            " . $auth->getParam('db_table') . ".*,
510            " . $auth->getParam('db_table') . "." . $auth->getParam('db_primary_key') . " AS admin_id,           
511            a1." . $auth->getParam('db_username_column') . " AS added_admin_username,
512            a2." . $auth->getParam('db_username_column') . " AS modified_admin_username
513        FROM " . $auth->getParam('db_table') . "
514        LEFT JOIN " . $auth->getParam('db_table') . " a1 ON (" . $auth->getParam('db_table') . ".added_by_user_id = a1." . $auth->getParam('db_primary_key') . ")
515        LEFT JOIN " . $auth->getParam('db_table') . " a2 ON (" . $auth->getParam('db_table') . ".modified_by_user_id = a2." . $auth->getParam('db_primary_key') . ")
[1]516        $where_clause
517        " . $so->getSortOrderSQL() . "
518        " . $page->getLimitSQL() . "
519    ";
[42]520
[152]521    // Use a cash hash to determine if the result-set has changed.
[1]522    // A unique key for this query, with the total_items in case db records
523    // were added since the last cache. This identifies a unique set of
524    // cached data, but we must refer to the list that is cached by a more
525    // generic name. so that we can flush the cache (if records updated)
526    // without knowing the hash.
527    $cache_hash = md5($sql . '|' . $page->total_items);
[153]528    if ($tmp_prefs->get('cache_hash') != $cache_hash) {
[152]529        $cache->delete('list');
[153]530        $tmp_prefs->set('cache_hash', $cache_hash);
[1]531    }
[42]532
[152]533    // First try to return from the cache.
534    if ($cache->exists('list')) {
[266]535        $list = $cache->get('list');
536        return $list;
[152]537    }
538   
539    // The list was not cached, so issue the real query.
540    $qid = $db->query($sql);
541    while ($row = mysql_fetch_assoc($qid)) {
542        $list[] = $row;
543    }
[42]544
[152]545    // Save this list into the cache.
546    if (isset($list) && !empty($list)) {
547        $cache->set('list', $list);
[1]548    }
549
550    return $list;
551}
552
553?>
Note: See TracBrowser for help on using the repository browser.