inc/libs/grade_functions.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 10/21/2012 *
   4  * ===================                          Last change: 10/21/2012 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : grade_functions.php                              *
   8  * -------------------------------------------------------------------- *
   9  * Short description : Functions for ext-                               *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Funktionen fuer ext-                             *
  12  * -------------------------------------------------------------------- *
  13  * $Revision::                                                        $ *
  14  * $Date::                                                            $ *
  15  * $Tag:: 0.2.1-FINAL                                                 $ *
  16  * $Author::                                                          $ *
  17  * -------------------------------------------------------------------- *
  18  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  19  * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  20  * For more information visit: http://mxchange.org                      *
  21  *                                                                      *
  22  * This program is free software; you can redistribute it and/or modify *
  23  * it under the terms of the GNU General Public License as published by *
  24  * the Free Software Foundation; either version 2 of the License, or    *
  25  * (at your option) any later version.                                  *
  26  *                                                                      *
  27  * This program is distributed in the hope that it will be useful,      *
  28  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
  29  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
  30  * GNU General Public License for more details.                         *
  31  *                                                                      *
  32  * You should have received a copy of the GNU General Public License    *
  33  * along with this program; if not, write to the Free Software          *
  34  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
  35  * MA  02110-1301  USA                                                  *
  36  ************************************************************************/
  37
  38 // Some security stuff...
  39 if (!defined('__SECURITY')) {
  40         die();
  41 } // END - if
  42
  43 // Generates a option "list" for all created "parent" grade ids
  44 function generateGradeDataParentIdOptions ($defaultId = NULL) {
  45         // Do we have cache?
  46         if (!isset($GLOBALS[__FUNCTION__][$defaultId])) {
  47                 // Default is no parent (NULL)
  48                 $whereStatement = '';
  49
  50                 // Is default set?
  51                 if (!is_null($defaultId)) {
  52                         // Then exlude it
  53                         $whereStatement = sprintf('WHERE `grade_id`=%s', bigintval($defaultId));
  54                 } // END - if
  55
  56                 // Look for all
  57                 $result = sqlQuery('SELECT
  58         `grade_id`,
  59         `grade_name`
  60 FROM
  61         `{?_MYSQL_PREFIX?}_grade_data`
  62 ' . $whereStatement . '
  63 ORDER BY
  64         `grade_id` ASC', __FUNCTION__, __LINE__);
  65
  66                 // Init entries arrays
  67                 $gradeKeys = array();
  68                 $gradeValues = array();
  69
  70                 // Are there entries?
  71                 if (!ifSqlHasZeroNums($result)) {
  72                         // Load all entries
  73                         while ($grade = sqlFetchArray($result)) {
  74                                 // Add it to arrays
  75                                 array_push($gradeKeys  , $grade['grade_id']);
  76                                 array_push($gradeValues, $grade['grade_name']);
  77                         } // END - while
  78                 } // END - if
  79
  80                 // Generate option "list"
  81                 $GLOBALS[__FUNCTION__][$defaultId] = generateOptions(
  82                         '/ARRAY/',
  83                         $gradeKeys,
  84                         $gradeValues,
  85                         $defaultId
  86                 );
  87
  88                 // Free result
  89                 sqlFreeResult($result);
  90         } // END - if
  91
  92         // Return cache
  93         return $GLOBALS[__FUNCTION__][$defaultId];
  94 }
  95
  96 // ----------------------------------------------------------------------------
  97 //                             XML call-back functions
  98 // ----------------------------------------------------------------------------
  99
 100 // For 'doing' add grade data, the column-index is required
 101 function addXmlSpecialAdminAddDoGradeData () {
 102         // So set it all here
 103         $GLOBALS['__COLUMN_INDEX']['doXmlCallbackFunction']  = 'column';
 104         $GLOBALS['__XML_ARGUMENTS']['doXmlCallbackFunction']['column_index'] = 'column';
 105 }
 106
 107 // [EOF]
 108 ?>