mambax7 / references

class/references_utils.php

Indentation +1529 added lines, -1529 removed lines

@@ -36,1533 +36,1533 @@
 
 class references_utils
 {
-    // Pour la portabilité de module à module
-    const MODULE_NAME    = 'references';
-    const MODULE_DIRNAME = REFERENCES_DIRNAME;
-    const MODULE_PATH    = REFERENCES_PATH;
-    const MODULE_URL     = REFERENCES_URL;
-    const MODULE_JS_URL  = REFERENCES_JS_URL;
-
-    /**
-     * Access the only instance of this class
-     *
-     * @return object
-     *
-     * @static
-     * @staticvar   object
-     */
-    public static function getInstance()
-    {
-        static $instance;
-        if (null === $instance) {
-            $instance = new static();
-        }
-
-        return $instance;
-    }
-
-    /**
-     * Returns a module's option (with cache)
-     *
-     * @param  string  $option    module option's name
-     * @param  boolean $withCache Do we have to use some cache ?
-     * @return mixed   option's value
-     */
-    public static function getModuleOption($option, $withCache = true)
-    {
-        global $xoopsModuleConfig, $xoopsModule;
-        $repmodule = self::MODULE_NAME;
-        static $options = array();
-        if (is_array($options) && array_key_exists($option, $options) && $withCache) {
-            return $options[$option];
-        }
-
-        $retval = false;
-        if (isset($xoopsModuleConfig) && (is_object($xoopsModule) && $xoopsModule->getVar('dirname') == $repmodule && $xoopsModule->getVar('isactive'))) {
-            if (isset($xoopsModuleConfig[$option])) {
-                $retval = $xoopsModuleConfig[$option];
-            }
-        } else {
-            $module_handler = xoops_getHandler('module');
-            $module         = $module_handler->getByDirname($repmodule);
-            $config_handler = xoops_getHandler('config');
-            if ($module) {
-                $moduleConfig = $config_handler->getConfigsByCat(0, $module->getVar('mid'));
-                if (isset($moduleConfig[$option])) {
-                    $retval = $moduleConfig[$option];
-                }
-            }
-        }
-        $options[$option] = $retval;
-
-        return $retval;
-    }
-
-    /**
-     * Is Xoops 2.3.x ?
-     *
-     * @return boolean need to say it ?
-     */
-    public static function isX23()
-    {
-        $x23 = false;
-        $xv  = str_replace('XOOPS ', '', XOOPS_VERSION);
-        if ((int)substr($xv, 2, 1) >= 3) {
-            $x23 = true;
-        }
-
-        return $x23;
-    }
-
-    /**
-     * Retreive an editor according to the module's option "form_options"
-     *
-     * @param  string $caption Caption to give to the editor
-     * @param  string $name    Editor's name
-     * @param  string $value   Editor's value
-     * @param  string $width   Editor's width
-     * @param  string $height  Editor's height
-     * @param string  $supplemental
-     * @return object The editor to use
-     */
-    public static function getWysiwygForm($caption, $name, $value = '', $width = '100%', $height = '400px', $supplemental = '')
-    {
-        $editor                   = false;
-        $editor_configs           = array();
-        $editor_configs['name']   = $name;
-        $editor_configs['value']  = $value;
-        $editor_configs['rows']   = 35;
-        $editor_configs['cols']   = 60;
-        $editor_configs['width']  = '100%';
-        $editor_configs['height'] = '400px';
-
-        $editor_option = strtolower(self::getModuleOption('form_options'));
-
-        if (self::isX23()) {
-            $editor = new XoopsFormEditor($caption, $editor_option, $editor_configs);
-
-            return $editor;
-        }
-
-        // Only for Xoops 2.0.x
-        switch ($editor_option) {
-            case 'fckeditor':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php');
-                    $editor = new XoopsFormFckeditor($caption, $name, $value);
-                }
-                break;
-
-            case 'htmlarea':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php');
-                    $editor = new XoopsFormHtmlarea($caption, $name, $value);
-                }
-                break;
-
-            case 'dhtmltextarea':
-                $editor = new XoopsFormDhtmlTextArea($caption, $name, $value, 10, 50, $supplemental);
-                break;
-
-            case 'textarea':
-                $editor = new XoopsFormTextArea($caption, $name, $value);
-                break;
-
-            case 'tinyeditor':
-            case 'tinymce':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php')) {
-                    require_once XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php';
-                    $editor = new XoopsFormTinyeditorTextArea(array('caption' => $caption, 'name' => $name, 'value' => $value, 'width' => '100%', 'height' => '400px'));
-                }
-                break;
-
-            case 'koivi':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php');
-                    $editor = new XoopsFormWysiwygTextArea($caption, $name, $value, $width, $height, '');
-                }
-                break;
-        }
-        if (!is_object($editor)) {
-            trigger_error('Error, impossible to get the requested text editor', E_USER_ERROR);
-        }
-
-        return $editor;
-    }
-
-    /**
-     * Create (in a link) a javascript confirmation's box
-     *
-     * @param  string  $message Message to display
-     * @param  boolean $form    Is this a confirmation for a form ?
-     * @return string  the javascript code to insert in the link (or in the form)
-     */
-    public static function javascriptLinkConfirm($message, $form = false)
-    {
-        if (!$form) {
-            return "onclick=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
-        } else {
-            return "onSubmit=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
-        }
-    }
-
-    /**
-     * Get current user IP
-     *
-     * @return string IP address (format Ipv4)
-     */
-    public static function IP()
-    {
-        $proxy_ip = '';
-        if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
-            $proxy_ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
-        } elseif (!empty($_SERVER['HTTP_X_FORWARDED'])) {
-            $proxy_ip = $_SERVER['HTTP_X_FORWARDED'];
-        } elseif (!empty($_SERVER['HTTP_FORWARDED_FOR'])) {
-            $proxy_ip = $_SERVER['HTTP_FORWARDED_FOR'];
-        } elseif (!empty($_SERVER['HTTP_FORWARDED'])) {
-            $proxy_ip = $_SERVER['HTTP_FORWARDED'];
-        } elseif (!empty($_SERVER['HTTP_VIA'])) {
-            $proxy_ip = $_SERVER['HTTP_VIA'];
-        } elseif (!empty($_SERVER['HTTP_X_COMING_FROM'])) {
-            $proxy_ip = $_SERVER['HTTP_X_COMING_FROM'];
-        } elseif (!empty($_SERVER['HTTP_COMING_FROM'])) {
-            $proxy_ip = $_SERVER['HTTP_COMING_FROM'];
-        }
-        $regs = array();
-        if (!empty($proxy_ip) && $is_ip = ereg('^([0-9]{1,3}\.){3,3}[0-9]{1,3}', $proxy_ip, $regs) && count($regs) > 0) {
-            $the_IP = $regs[0];
-        } else {
-            $the_IP = $_SERVER['REMOTE_ADDR'];
-        }
-
-        return $the_IP;
-    }
-
-    /**
-     * Set the page's title, meta description and meta keywords
-     * Datas are supposed to be sanitized
-     *
-     * @param  string $pageTitle       Page's Title
-     * @param  string $metaDescription Page's meta description
-     * @param  string $metaKeywords    Page's meta keywords
-     * @return void
-     */
-    public static function setMetas($pageTitle = '', $metaDescription = '', $metaKeywords = '')
-    {
-        global $xoTheme, $xoTheme, $xoopsTpl;
-        $xoopsTpl->assign('xoops_pagetitle', $pageTitle);
-        if (isset($xoTheme) && is_object($xoTheme)) {
-            if (!empty($metaKeywords)) {
-                $xoTheme->addMeta('meta', 'keywords', $metaKeywords);
-            }
-            if (!empty($metaDescription)) {
-                $xoTheme->addMeta('meta', 'description', $metaDescription);
-            }
-        } elseif (isset($xoopsTpl) && is_object($xoopsTpl)) {    // Compatibility for old Xoops versions
-            if (!empty($metaKeywords)) {
-                $xoopsTpl->assign('xoops_meta_keywords', $metaKeywords);
-            }
-            if (!empty($metaDescription)) {
-                $xoopsTpl->assign('xoops_meta_description', $metaDescription);
-            }
-        }
-    }
-
-    /**
-     * Send an email from a template to a list of recipients
-     *
-     * @param         $tplName
-     * @param  array  $recipients List of recipients
-     * @param  string $subject    Email's subject
-     * @param  array  $variables  Varirables to give to the template
-     * @return bool Result of the send
-     * @internal param string $tpl_name Template's name
-     */
-    public static function sendEmailFromTpl($tplName, $recipients, $subject, $variables)
-    {
-        global $xoopsConfig;
-        require_once XOOPS_ROOT_PATH . '/class/xoopsmailer.php';
-        if (!is_array($recipients)) {
-            if (trim($recipients) == '') {
-                return false;
-            }
-        } else {
-            if (count($recipients) == 0) {
-                return false;
-            }
-        }
-        if (function_exists('xoops_getMailer')) {
-            $xoopsMailer = xoops_getMailer();
-        } else {
-            $xoopsMailer =& getMailer();
-        }
-
-        $xoopsMailer->useMail();
-        $xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH . '/modules/' . self::MODULE_NAME . '/language/' . $xoopsConfig['language'] . '/mail_template');
-        $xoopsMailer->setTemplate($tplName);
-        $xoopsMailer->setToEmails($recipients);
-        // TODO: Change !
-        // $xoopsMailer->setFromEmail('contact@monsite.com');
-        //$xoopsMailer->setFromName('MonSite');
-        $xoopsMailer->setSubject($subject);
-        foreach ($variables as $key => $value) {
-            $xoopsMailer->assign($key, $value);
-        }
-        $res = $xoopsMailer->send();
-        unset($xoopsMailer);
-        $filename = XOOPS_UPLOAD_PATH . '/logmail_' . self::MODULE_NAME . '.php';
-        if (!file_exists($filename)) {
-            $fp = @fopen($filename, 'a');
-            if ($fp) {
-                fwrite($fp, '<?php exit(); ?>');
-                fclose($fp);
-            }
-        }
-        $fp = @fopen($filename, 'a');
-
-        if ($fp) {
-            fwrite($fp, str_repeat('-', 120) . "\n");
-            fwrite($fp, date('d/m/Y H:i:s') . "\n");
-            fwrite($fp, 'Template name : ' . $tplName . "\n");
-            fwrite($fp, 'Email subject : ' . $subject . "\n");
-            if (is_array($recipients)) {
-                fwrite($fp, 'Recipient(s) : ' . implode(',', $recipients) . "\n");
-            } else {
-                fwrite($fp, 'Recipient(s) : ' . $recipients . "\n");
-            }
-            fwrite($fp, 'Transmited variables : ' . implode(',', $variables) . "\n");
-            fclose($fp);
-        }
-
-        return $res;
-    }
-
-    /**
-     * Remove module's cache
-     */
-    public static function updateCache()
-    {
-        global $xoopsModule;
-        $folder  = $xoopsModule->getVar('dirname');
-        $tpllist = array();
-        require_once XOOPS_ROOT_PATH . '/class/xoopsblock.php';
-        require_once XOOPS_ROOT_PATH . '/class/template.php';
-        $tplfile_handler = xoops_getHandler('tplfile');
-        $tpllist         = $tplfile_handler->find(null, null, null, $folder);
-        xoops_template_clear_module_cache($xoopsModule->getVar('mid'));            // Clear module's blocks cache
-
-        foreach ($tpllist as $onetemplate) {    // Remove cache for each page.
-            if ($onetemplate->getVar('tpl_type') === 'module') {
-                //  Note, I've been testing all the other methods (like the one of Smarty) and none of them run, that's why I have used this code
-                $files_del = array();
-                $files_del = glob(XOOPS_CACHE_PATH . '/*' . $onetemplate->getVar('tpl_file') . '*');
-                if (count($files_del) > 0 && is_array($files_del)) {
-                    foreach ($files_del as $one_file) {
-                        if (is_file($one_file)) {
-                            unlink($one_file);
-                        }
-                    }
-                }
-            }
-        }
-    }
-
-    /**
-     * Redirect user with a message
-     *
-     * @param string $message message to display
-     * @param string $url     The place where to go
-     * @param        integer  timeout Time to wait before to redirect
-     */
-    public static function redirect($message = '', $url = 'index.php', $time = 2)
-    {
-        redirect_header($url, $time, $message);
-        exit();
-    }
-
-    /**
-     * Internal function used to get the handler of the current module
-     *
-     * @return object The module
-     */
-    public static function getModule()
-    {
-        static $mymodule;
-        if (!isset($mymodule)) {
-            global $xoopsModule;
-            if (isset($xoopsModule) && is_object($xoopsModule) && $xoopsModule->getVar('dirname') == REFERENCES_DIRNAME) {
-                $mymodule =& $xoopsModule;
-            } else {
-                $hModule  = xoops_getHandler('module');
-                $mymodule = $hModule->getByDirname(REFERENCES_DIRNAME);
-            }
-        }
-
-        return $mymodule;
-    }
-
-    /**
-     * Returns the module's name (as defined by the user in the module manager) with cache
-     * @return string Module's name
-     */
-    public static function getModuleName()
-    {
-        static $moduleName;
-        if (!isset($moduleName)) {
-            $mymodule   = self::getModule();
-            $moduleName = $mymodule->getVar('name');
-        }
-
-        return $moduleName;
-    }
-
-    /**
-     * Create a title for the href tags inside html links
-     *
-     * @param  string $title Text to use
-     * @return string Formated text
-     */
-    public static function makeHrefTitle($title)
-    {
-        $s = "\"'";
-        $r = '  ';
-
-        return strtr($title, $s, $r);
-    }
-
-    /**
-     * Retourne la liste des utilisateurs appartenants � un groupe
-     *
-     * @param  int $groupId Searched group
-     * @return array Array of XoopsUsers
-     */
-    public static function getUsersFromGroup($groupId)
-    {
-        $users          = array();
-        $member_handler = xoops_getHandler('member');
-        $users          = $member_handler->getUsersByGroup($groupId, true);
-
-        return $users;
-    }
-
-    /**
-     * Retourne les ID des utilisateurs faisant partie de plusieurs groupes
-     * @param  array $groups Les ID des groupes dont on recherche les ID utilisateurs
-     * @return array Les ID utilisateurs
-     */
-    public static function getUsersIdsFromGroups($groups)
-    {
-        $usersIds       = array();
-        $member_handler = xoops_getHandler('member');
-        foreach ($groups as $groupId) {
-            $temporaryGroup = array();
-            $temporaryGroup = $member_handler->getUsersByGroup($groupId);
-            if (count($temporaryGroup) > 0) {
-                $usersIds = array_merge($usersIds, $temporaryGroup);
-            }
-        }
-
-        return array_unique($usersIds);
-    }
-
-    /**
-     * Retourne la liste des emails des utilisateurs membres d'un groupe
-     *
-     * @param $groupId
-     * @return array Emails list
-     * @internal param int $group_id Group's number
-     */
-    public static function getEmailsFromGroup($groupId)
-    {
-        $ret   = array();
-        $users = self::getUsersFromGroup($groupId);
-        foreach ($users as $user) {
-            $ret[] = $user->getVar('email');
-        }
-
-        return $ret;
-    }
-
-    /**
-     * V�rifie que l'utilisateur courant fait partie du groupe des administrateurs
-     *
-     * @return booleean Admin or not
-     */
-    public static function isAdmin()
-    {
-        global $xoopsUser, $xoopsModule;
-        if (is_object($xoopsUser)) {
-            if (in_array(XOOPS_GROUP_ADMIN, $xoopsUser->getGroups())) {
-                return true;
-            } elseif (isset($xoopsModule) && $xoopsUser->isAdmin($xoopsModule->getVar('mid'))) {
-                return true;
-            }
-        }
-
-        return false;
-    }
-
-    /**
-     * Returns the current date in the Mysql format
-     *
-     * @return string Date in the Mysql format
-     */
-    public static function getCurrentSQLDate()
-    {
-        return date('Y-m-d');    // 2007-05-02
-    }
-
-    public static function getCurrentSQLDateTime()
-    {
-        return date('Y-m-d H:i:s');    // 2007-05-02
-    }
-
-    /**
-     * Convert a Mysql date to the human's format
-     *
-     * @param  string $date The date to convert
-     * @param string  $format
-     * @return string The date in a human form
-     */
-    public static function SQLDateToHuman($date, $format = 'l')
-    {
-        if ($date != '0000-00-00' && xoops_trim($date) != '') {
-            return formatTimestamp(strtotime($date), $format);
-        } else {
-            return '';
-        }
-    }
-
-    /**
-     * Convert a timestamp to a Mysql date
-     *
-     * @param  integer $timestamp The timestamp to use
-     * @return string  The date in the Mysql format
-     */
-    public static function timestampToMysqlDate($timestamp)
-    {
-        return date('Y-m-d', (int)$timestamp);
-    }
-
-    /**
-     * Conversion d'un dateTime Mysql en date lisible en fran�ais
-     * @param $dateTime
-     * @return bool|string
-     */
-    public static function sqlDateTimeToFrench($dateTime)
-    {
-        return date('d/m/Y H:i:s', strtotime($dateTime));
-    }
-
-    /**
-     * Convert a timestamp to a Mysql datetime form
-     * @param  integer $timestamp The timestamp to use
-     * @return string  The date and time in the Mysql format
-     */
-    public static function timestampToMysqlDateTime($timestamp)
-    {
-        return date('Y-m-d H:i:s', $timestamp);
-    }
-
-    /**
-     * This function indicates if the current Xoops version needs to add asterisks to required fields in forms
-     *
-     * @return boolean Yes = we need to add them, false = no
-     */
-    public static function needsAsterisk()
-    {
-        if (self::isX23()) {
-            return false;
-        }
-        if (strpos(strtolower(XOOPS_VERSION), 'impresscms') !== false) {
-            return false;
-        }
-        if (strpos(strtolower(XOOPS_VERSION), 'legacy') === false) {
-            $xv = xoops_trim(str_replace('XOOPS ', '', XOOPS_VERSION));
-            if ((int)substr($xv, 4, 2) >= 17) {
-                return false;
-            }
-        }
-
-        return true;
-    }
-
-    /**
-     * Mark the mandatory fields of a form with a star
-     *
-     * @param  object $sform The form to modify
-     * @return object The modified form
-     * @internal param string $caracter The character to use to mark fields
-     */
-    public static function &formMarkRequiredFields(&$sform)
-    {
-        if (self::needsAsterisk()) {
-            $required = array();
-            foreach ($sform->getRequired() as $item) {
-                $required[] = $item->_name;
-            }
-            $elements = array();
-            $elements = &$sform->getElements();
-            $cnt      = count($elements);
-            for ($i = 0; $i < $cnt; ++$i) {
-                if (is_object($elements[$i]) && in_array($elements[$i]->_name, $required)) {
-                    $elements[$i]->_caption .= ' *';
-                }
-            }
-        }
-
-        return $sform;
-    }
-
-    /**
-     * Create an html heading (from h1 to h6)
-     *
-     * @param  string  $title The text to use
-     * @param  integer $level Level to return
-     * @return string  The heading
-     */
-    public static function htitle($title = '', $level = 1)
-    {
-        printf('<h%01d>%s</h%01d>', $level, $title, $level);
-    }
-
-    /**
-     * Create a unique upload filename
-     *
-     * @param  string  $folder   The folder where the file will be saved
-     * @param  string  $fileName Original filename (coming from the user)
-     * @param  boolean $trimName Do we need to create a short unique name ?
-     * @return string  The unique filename to use (with its extension)
-     */
-    public static function createUploadName($folder, $fileName, $trimName = false)
-    {
-        $workingfolder = $folder;
-        if (substr($workingfolder, strlen($workingfolder) - 1, 1) !== '/') {
-            $workingfolder .= '/';
-        }
-        $ext  = basename($fileName);
-        $ext  = explode('.', $ext);
-        $ext  = '.' . $ext[count($ext) - 1];
-        $true = true;
-        while ($true) {
-            $ipbits = explode('.', $_SERVER['REMOTE_ADDR']);
-            list($usec, $sec) = explode(' ', microtime());
-            $usec = (integer)($usec * 65536);
-            $sec  = ((integer)$sec) & 0xFFFF;
-
-            if ($trimName) {
-                $uid = sprintf('%06x%04x%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
-            } else {
-                $uid = sprintf('%08x-%04x-%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
-            }
-            if (!file_exists($workingfolder . $uid . $ext)) {
-                $true = false;
-            }
-        }
-
-        return $uid . $ext;
-    }
-
-    /**
-     * Replace html entities with their ASCII equivalent
-     *
-     * @param  string $chaine The string undecode
-     * @return string The undecoded string
-     */
-    public static function unhtml($chaine)
-    {
-        $search = $replace = array();
-        $chaine = html_entity_decode($chaine);
-
-        for ($i = 0; $i <= 255; ++$i) {
-            $search[]  = '&#' . $i . ';';
-            $replace[] = chr($i);
-        }
-        $replace[]='...'; $search[]='…';
-        $replace[]="'"; $search[]='‘';
-        $replace[]="'"; $search[]= '’';
-        $replace[]='-'; $search[] = '&bull;';   // $replace[] = '•';
-        $replace[]='—'; $search[]='&mdash;';
-        $replace[]='-'; $search[]='&ndash;';
-        $replace[]='-'; $search[]='&shy;';
-        $replace[]='"'; $search[]='&quot;';
-        $replace[]='&'; $search[]='&amp;';
-        $replace[]='ˆ'; $search[]='&circ;';
-        $replace[]='¡'; $search[]='&iexcl;';
-        $replace[]='¦'; $search[]='&brvbar;';
-        $replace[]='¨'; $search[]='&uml;';
-        $replace[]='¯'; $search[]='&macr;';
-        $replace[]='´'; $search[]='&acute;';
-        $replace[]='¸'; $search[]='&cedil;';
-        $replace[]='¿'; $search[]='&iquest;';
-        $replace[]='˜'; $search[]='&tilde;';
-        $replace[]="'"; $search[]='&lsquo;';    // $replace[]='‘';
-        $replace[]="'"; $search[]='&rsquo;';    // $replace[]='’';
-        $replace[]='‚'; $search[]='&sbquo;';
-        $replace[]="'"; $search[]='&ldquo;';    // $replace[]='“';
-        $replace[]="'"; $search[]='&rdquo;';    // $replace[]='”';
-        $replace[]='„'; $search[]='&bdquo;';
-        $replace[]='‹'; $search[]='&lsaquo;';
-        $replace[]='›'; $search[]='&rsaquo;';
-        $replace[]='<'; $search[]='&lt;';
-        $replace[]='>'; $search[]='&gt;';
-        $replace[]='±'; $search[]='&plusmn;';
-        $replace[]='«'; $search[]='&laquo;';
-        $replace[]='»'; $search[]='&raquo;';
-        $replace[]='×'; $search[]='&times;';
-        $replace[]='÷'; $search[]='&divide;';
-        $replace[]='¢'; $search[]='&cent;';
-        $replace[]='£'; $search[]='&pound;';
-        $replace[]='¤'; $search[]='&curren;';
-        $replace[]='¥'; $search[]='&yen;';
-        $replace[]='§'; $search[]='&sect;';
-        $replace[]='©'; $search[]='&copy;';
-        $replace[]='¬'; $search[]='&not;';
-        $replace[]='®'; $search[]='&reg;';
-        $replace[]='°'; $search[]='&deg;';
-        $replace[]='µ'; $search[]='&micro;';
-        $replace[]='¶'; $search[]='&para;';
-        $replace[]='·'; $search[]='&middot;';
-        $replace[]='†'; $search[]='&dagger;';
-        $replace[]='‡'; $search[]='&Dagger;';
-        $replace[]='‰'; $search[]='&permil;';
-        $replace[]='Euro'; $search[]='&euro;';      // $replace[]='€'
-        $replace[]='¼'; $search[]='&frac14;';
-        $replace[]='½'; $search[]='&frac12;';
-        $replace[]='¾'; $search[]='&frac34;';
-        $replace[]='¹'; $search[]='&sup1;';
-        $replace[]='²'; $search[]='&sup2;';
-        $replace[]='³'; $search[]='&sup3;';
-        $replace[]='á'; $search[]='&aacute;';
-        $replace[]='Á'; $search[]='&Aacute;';
-        $replace[]='â'; $search[]='&acirc;';
-        $replace[]='Â'; $search[]='&Acirc;';
-        $replace[]='à'; $search[]='&agrave;';
-        $replace[]='À'; $search[]='&Agrave;';
-        $replace[]='å'; $search[]='&aring;';
-        $replace[]='Å'; $search[]='&Aring;';
-        $replace[]='ã'; $search[]='&atilde;';
-        $replace[]='Ã'; $search[]='&Atilde;';
-        $replace[]='ä'; $search[]='&auml;';
-        $replace[]='Ä'; $search[]='&Auml;';
-        $replace[]='ª'; $search[]='&ordf;';
-        $replace[]='æ'; $search[]='&aelig;';
-        $replace[]='Æ'; $search[]='&AElig;';
-        $replace[]='ç'; $search[]='&ccedil;';
-        $replace[]='Ç'; $search[]='&Ccedil;';
-        $replace[]='ð'; $search[]='&eth;';
-        $replace[]='Ð'; $search[]='&ETH;';
-        $replace[]='é'; $search[]='&eacute;';
-        $replace[]='É'; $search[]='&Eacute;';
-        $replace[]='ê'; $search[]='&ecirc;';
-        $replace[]='Ê'; $search[]='&Ecirc;';
-        $replace[]='è'; $search[]='&egrave;';
-        $replace[]='È'; $search[]='&Egrave;';
-        $replace[]='ë'; $search[]='&euml;';
-        $replace[]='Ë'; $search[]='&Euml;';
-        $replace[]='ƒ'; $search[]='&fnof;';
-        $replace[]='í'; $search[]='&iacute;';
-        $replace[]='Í'; $search[]='&Iacute;';
-        $replace[]='î'; $search[]='&icirc;';
-        $replace[]='Î'; $search[]='&Icirc;';
-        $replace[]='ì'; $search[]='&igrave;';
-        $replace[]='Ì'; $search[]='&Igrave;';
-        $replace[]='ï'; $search[]='&iuml;';
-        $replace[]='Ï'; $search[]='&Iuml;';
-        $replace[]='ñ'; $search[]='&ntilde;';
-        $replace[]='Ñ'; $search[]='&Ntilde;';
-        $replace[]='ó'; $search[]='&oacute;';
-        $replace[]='Ó'; $search[]='&Oacute;';
-        $replace[]='ô'; $search[]='&ocirc;';
-        $replace[]='Ô'; $search[]='&Ocirc;';
-        $replace[]='ò'; $search[]='&ograve;';
-        $replace[]='Ò'; $search[]='&Ograve;';
-        $replace[]='º'; $search[]='&ordm;';
-        $replace[]='ø'; $search[]='&oslash;';
-        $replace[]='Ø'; $search[]='&Oslash;';
-        $replace[]='õ'; $search[]='&otilde;';
-        $replace[]='Õ'; $search[]='&Otilde;';
-        $replace[]='ö'; $search[]='&ouml;';
-        $replace[]='Ö'; $search[]='&Ouml;';
-        $replace[]='œ'; $search[]='&oelig;';
-        $replace[]='Œ'; $search[]='&OElig;';
-        $replace[]='š'; $search[]='&scaron;';
-        $replace[]='Š'; $search[]='&Scaron;';
-        $replace[]='ß'; $search[]='&szlig;';
-        $replace[]='þ'; $search[]='&thorn;';
-        $replace[]='Þ'; $search[]='&THORN;';
-        $replace[]='ú'; $search[]='&uacute;';
-        $replace[]='Ú'; $search[]='&Uacute;';
-        $replace[]='û'; $search[]='&ucirc;';
-        $replace[]='Û'; $search[]='&Ucirc;';
-        $replace[]='ù'; $search[]='&ugrave;';
-        $replace[]='Ù'; $search[]='&Ugrave;';
-        $replace[]='ü'; $search[]='&uuml;';
-        $replace[]='Ü'; $search[]='&Uuml;';
-        $replace[]='ý'; $search[]='&yacute;';
-        $replace[]='Ý'; $search[]='&Yacute;';
-        $replace[]='ÿ'; $search[]='&yuml;';
-        $replace[]='Ÿ'; $search[]='&Yuml;';
-        $chaine    = str_replace($search, $replace, $chaine);
-
-        return $chaine;
-    }
-
-    /**
-     * Création d'une titre pour être utilisé par l'url rewriting
-     *
-     * @param string  $content  Le texte à utiliser pour créer l'url
-     * @param integer $urw      La limite basse pour créer les mots
-     * @return string Le texte à utiliser pour l'url
-     *                          Note, some parts are from Solo's code
-     */
-    public static function makeSeoUrl($content, $urw = 1)
-    {
-        $s       = "ÀÁÂÃÄÅÒÓÔÕÖØÈÉÊËÇÌÍÎÏÙÚÛÜŸÑàáâãäåòóôõöøèéêëçìíîïùúûüÿñ '()";
-        $r       = 'AAAAAAOOOOOOEEEECIIIIUUUUYNaaaaaaooooooeeeeciiiiuuuuyn----';
-        $content = self::unhtml($content);    // First, remove html entities
-        $content = strtr($content, $s, $r);
-        $content = strip_tags($content);
-        $content = strtolower($content);
-        $content = htmlentities($content);    // TODO: Vérifier
-        $content = preg_replace('/&([a-zA-Z])(uml|acute|grave|circ|tilde);/', '$1', $content);
-        $content = html_entity_decode($content);
-        $content = eregi_replace('quot', ' ', $content);
-        $content = eregi_replace("'", ' ', $content);
-        $content = eregi_replace('-', ' ', $content);
-        $content = eregi_replace('[[:punct:]]', '', $content);
-        // Selon option mais attention au fichier .htaccess !
-        // $content = eregi_replace('[[:digit:]]','', $content);
-        $content = preg_replace('/[^a-z|A-Z|0-9]/', '-', $content);
-
-        $words    = explode(' ', $content);
-        $keywords = '';
-        foreach ($words as $word) {
-            if (strlen($word) >= $urw) {
-                $keywords .= '-' . trim($word);
-            }
-        }
-        if (!$keywords) {
-            $keywords = '-';
-        }
-        // Supprime les tirets en double
-        $keywords = str_replace('---', '-', $keywords);
-        $keywords = str_replace('--', '-', $keywords);
-        // Supprime un éventuel tiret à la fin de la chaine
-        if (substr($keywords, strlen($keywords) - 1, 1) == '-') {
-            $keywords = substr($keywords, 0, strlen($keywords) - 1);
-        }
-
-        return $keywords;
-    }
-
-    /**
-     * Create the meta keywords based on the content
-     *
-     * @param  string $content Content from which we have to create metakeywords
-     * @return string The list of meta keywords
-     */
-    public static function createMetaKeywords($content)
-    {
-        $keywordscount = REFERENCES_METAGEN_MAX_KEYWORDS;
-        $keywordsorder = REFERENCES_METAGEN_KEYWORDS_ORDER;
-
-        $tmp = array();
-        // Search for the "Minimum keyword length"
-        // TODO: Remplacer references_keywords_limit par une constante
-        if (isset($_SESSION['references_keywords_limit'])) {
-            $limit = $_SESSION['references_keywords_limit'];
-        } else {
-            $config_handler                        = xoops_getHandler('config');
-            $xoopsConfigSearch                     =& $config_handler->getConfigsByCat(XOOPS_CONF_SEARCH);
-            $limit                                 = $xoopsConfigSearch['keyword_min'];
-            $_SESSION['references_keywords_limit'] = $limit;
-        }
-        $myts            = MyTextSanitizer::getInstance();
-        $content         = str_replace('<br>', ' ', $content);
-        $content         = $myts->undoHtmlSpecialChars($content);
-        $content         = strip_tags($content);
-        $content         = strtolower($content);
-        $search_pattern  = array('&nbsp;', "\t", "\r\n", "\r", "\n", ',', '.', "'", ';', ':', ')', '(', '"', '?', '!', '{', '}', '[', ']', '<', '>', '/', '+', '-', '_', '\\', '*');
-        $replace_pattern = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-        $content         = str_replace($search_pattern, $replace_pattern, $content);
-        $keywords        = explode(' ', $content);
-        switch ($keywordsorder) {
-            case 0:    // Ordre d'apparition dans le texte
-                $keywords = array_unique($keywords);
-                break;
-            case 1:    // Ordre de fréquence des mots
-                $keywords = array_count_values($keywords);
-                asort($keywords);
-                $keywords = array_keys($keywords);
-                break;
-            case 2:    // Ordre inverse de la fréquence des mots
-                $keywords = array_count_values($keywords);
-                arsort($keywords);
-                $keywords = array_keys($keywords);
-                break;
-        }
-        // Remove black listed words
-        if (xoops_trim(self::getModuleOption('metagen_blacklist')) != '') {
-            $metagen_blacklist = str_replace("\r", '', self::getModuleOption('metagen_blacklist'));
-            $metablack         = explode("\n", $metagen_blacklist);
-            array_walk($metablack, 'trim');
-            $keywords = array_diff($keywords, $metablack);
-        }
-
-        foreach ($keywords as $keyword) {
-            if (strlen($keyword) >= $limit && !is_numeric($keyword)) {
-                $tmp[] = $keyword;
-            }
-        }
-        $tmp = array_slice($tmp, 0, $keywordscount);
-        if (count($tmp) > 0) {
-            return implode(',', $tmp);
-        } else {
-            if (!isset($config_handler) || !is_object($config_handler)) {
-                $config_handler = xoops_getHandler('config');
-            }
-            $xoopsConfigMetaFooter =& $config_handler->getConfigsByCat(XOOPS_CONF_METAFOOTER);
-            if (isset($xoopsConfigMetaFooter['meta_keywords'])) {
-                return $xoopsConfigMetaFooter['meta_keywords'];
-            } else {
-                return '';
-            }
-        }
-    }
-
-    /**
-     * Fonction chargée de gérer l'upload
-     *
-     * @param integer $indice L'indice du fichier à télécharger
-     * @param string  $dstpath
-     * @param null    $mimeTypes
-     * @param null    $uploadMaxSize
-     * @param null    $maxWidth
-     * @param null    $maxHeight
-     * @return mixed True si l'upload s'est bien déroulé sinon le message d'erreur correspondant
-     */
-    public static function uploadFile($indice, $dstpath = XOOPS_UPLOAD_PATH, $mimeTypes = null, $uploadMaxSize = null, $maxWidth = null, $maxHeight = null)
-    {
-        require_once XOOPS_ROOT_PATH . '/class/uploader.php';
-        global $destname;
-        if (isset($_POST['xoops_upload_file'])) {
-            require_once XOOPS_ROOT_PATH . '/class/uploader.php';
-            $fldname = '';
-            $fldname = $_FILES[$_POST['xoops_upload_file'][$indice]];
-            $fldname = get_magic_quotes_gpc() ? stripslashes($fldname['name']) : $fldname['name'];
-            if (xoops_trim($fldname != '')) {
-                $destname = self::createUploadName($dstpath, $fldname, true);
-                if ($mimeTypes === null) {
-                    $permittedtypes = explode("\n", str_replace("\r", '', self::getModuleOption('mimetypes')));
-                    array_walk($permittedtypes, 'trim');
-                } else {
-                    $permittedtypes = $mimeTypes;
-                }
-                if ($uploadMaxSize === null) {
-                    $uploadSize = self::getModuleOption('maxuploadsize');
-                } else {
-                    $uploadSize = $uploadMaxSize;
-                }
-                $uploader = new XoopsMediaUploader($dstpath, $permittedtypes, $uploadSize, $maxWidth, $maxHeight);
-                //$uploader->allowUnknownTypes = true;
-                $uploader->setTargetFileName($destname);
-                if ($uploader->fetchMedia($_POST['xoops_upload_file'][$indice])) {
-                    if ($uploader->upload()) {
-                        return true;
-                    } else {
-                        return _ERRORS . ' ' . htmlentities($uploader->getErrors());
-                    }
-                } else {
-                    return htmlentities($uploader->getErrors());
-                }
-            } else {
-                return false;
-            }
-        } else {
-            return false;
-        }
-    }
-
-    /**
-     * Resize a Picture to some given dimensions (using the wideImage library)
-     *
-     * @param string  $src_path      Picture's source
-     * @param string  $dst_path      Picture's destination
-     * @param integer $param_width   Maximum picture's width
-     * @param integer $param_height  Maximum picture's height
-     * @param boolean $keep_original Do we have to keep the original picture ?
-     * @param string  $fit           Resize mode (see the wideImage library for more information)
-     * @return bool
-     */
-    public static function resizePicture($src_path, $dst_path, $param_width, $param_height, $keep_original = false, $fit = 'inside')
-    {
-        //        require_once self::MODULE_PATH . 'class/wideimage/WideImage.php';
-        $img    = WideImage::load($src_path);
-        $result = $img->resize($param_width, $param_height, $fit);
-        $result->saveToFile($dst_path, null);
-        if (!$keep_original) {
-            @unlink($src_path);
-        }
-
-        return true;
-    }
-
-    /**
-     * Déclenchement d'une alerte Xoops suite à un évènement
-     *
-     * @param string       $category La catégorie de l'évènement
-     * @param integer      $itemId   L'ID de l'élément (trop général pour être décris précisément)
-     * @param unknown_type $event    L'évènement qui est déclencé
-     * @param unknown_type $tags     Les variables à passer au template
-     */
-    public static function notify($category, $itemId, $event, $tags)
-    {
-        $notification_handler = xoops_getHandler('notification');
-        $tags['X_MODULE_URL'] = REFERENCES_URL;
-        $notification_handler->triggerEvent($category, $itemId, $event, $tags);
-    }
-
-    /**
-     * Ajoute des jours à une date et retourne la nouvelle date au format Date de Mysql
-     *
-     * @param int     $duration
-     * @param integer $startingDate Date de départ (timestamp)
-     * @return bool|string
-     * @internal param int $durations Durée en jours
-     */
-    public static function addDaysToDate($duration = 1, $startingDate = 0)
-    {
-        if ($startingDate == 0) {
-            $startingDate = time();
-        }
-        $endingDate = $startingDate + ($duration * 86400);
-
-        return date('Y-m-d', $endingDate);
-    }
-
-    /**
-     * Retourne un breadcrumb en fonction des paramètres passés et en partant (d'office) de la racine du module
-     *
-     * @param array  $path  Le chemin complet (excepté la racine) du breadcrumb sous la forme clé=url valeur=titre
-     * @param string $raquo Le séparateur par défaut à utiliser
-     * @return string le breadcrumb
-     */
-    public static function breadcrumb($path, $raquo = ' &raquo; ')
-    {
-        $breadcrumb        = '';
-        $workingBreadcrumb = array();
-        if (is_array($path)) {
-            $moduleName          = self::getModuleName();
-            $workingBreadcrumb[] = "<a href='" . REFERENCES_URL . "' title='" . self::makeHrefTitle($moduleName) . "'>" . $moduleName . '</a>';
-            foreach ($path as $url => $title) {
-                $workingBreadcrumb[] = "<a href='" . $url . "'>" . $title . '</a>';
-            }
-            $cnt = count($workingBreadcrumb);
-            for ($i = 0; $i < $cnt; ++$i) {
-                if ($i == $cnt - 1) {
-                    $workingBreadcrumb[$i] = strip_tags($workingBreadcrumb[$i]);
-                }
-            }
-            $breadcrumb = implode($raquo, $workingBreadcrumb);
-        }
-
-        return $breadcrumb;
-    }
-
-    public static function close_tags($string)
-    {
-        // match opened tags
-        if (preg_match_all('/<([a-z\:\-]+)[^\/]>/', $string, $start_tags)) {
-            $start_tags = $start_tags[1];
-
-            // match closed tags
-            if (preg_match_all('/<\/([a-z]+)>/', $string, $end_tags)) {
-                $complete_tags = array();
-                $end_tags      = $end_tags[1];
-
-                foreach ($start_tags as $key => $val) {
-                    $posb = array_search($val, $end_tags);
-                    if (is_int($posb)) {
-                        unset($end_tags[$posb]);
-                    } else {
-                        $complete_tags[] = $val;
-                    }
-                }
-            } else {
-                $complete_tags = $start_tags;
-            }
-
-            $complete_tags = array_reverse($complete_tags);
-            for ($i = 0; $i < count($complete_tags); ++$i) {
-                $string .= '</' . $complete_tags[$i] . '>';
-            }
-        }
-
-        return $string;
-    }
-
-    public static function truncate_tagsafe($string, $length = 80, $etc = '...', $break_words = false)
-    {
-        if ($length == 0) {
-            return '';
-        }
-
-        if (strlen($string) > $length) {
-            $length -= strlen($etc);
-            if (!$break_words) {
-                $string = preg_replace('/\s+?(\S+)?$/', '', substr($string, 0, $length + 1));
-                $string = preg_replace('/<[^>]*$/', '', $string);
-                $string = self::close_tags($string);
-            }
-
-            return $string . $etc;
-        } else {
-            return $string;
-        }
-    }
-
-    /**
-     * Create an infotip
-     * @param $text
-     * @return string
-     */
-    public static function makeInfotips($text)
-    {
-        $ret      = '';
-        $infotips = self::getModuleOption('infotips');
-        if ($infotips > 0) {
-            $myts = MyTextSanitizer::getInstance();
-            $ret  = $myts->htmlSpecialChars(substr(strip_tags($text), 0, $infotips));
-        }
-
-        return $ret;
-    }
-
-    /**
-     * Retourne le type Mime d'un fichier en utilisant d'abord finfo puis mime_content
-     *
-     * @param string $filename Le fichier (avec son chemin d'accès complet) dont on veut connaître le type mime
-     * @return string
-     */
-    public static function getMimeType($filename)
-    {
-        if (function_exists('finfo_open')) {
-            $pathToMagic = REFERENCES_PATH . 'mime/magic';
-            $finfo       = new finfo(FILEINFO_MIME, $pathToMagic);
-            $mimetype    = $finfo->file($filename);
-            finfo_close($finfo);
-            unset($finfo);
-
-            return $mimetype;
-        } else {
-            if (function_exists('mime_content_type')) {
-                return mime_content_type($filename);
-            } else {
-                return '';
-            }
-        }
-    }
-
-    /**
-     * Retourne une liste d'objets XoopsUsers à partir d'une liste d'identifiants
-     *
-     * @param  array $xoopsUsersIDs La liste des ID
-     * @return array Les objets XoopsUsers
-     */
-    public static function getUsersFromIds($xoopsUsersIDs)
-    {
-        $users = array();
-        if (is_array($xoopsUsersIDs) && count($xoopsUsersIDs) > 0) {
-            $xoopsUsersIDs = array_unique($xoopsUsersIDs);
-            sort($xoopsUsersIDs);
-            if (count($xoopsUsersIDs) > 0) {
-                $member_handler = xoops_getHandler('user');
-                $criteria       = new Criteria('uid', '(' . implode(',', $xoopsUsersIDs) . ')', 'IN');
-                $criteria->setSort('uid');
-                $users = $member_handler->getObjects($criteria, true);
-            }
-        }
-
-        return $users;
-    }
-
-    /**
-     * Retourne l'ID de l'utilisateur courant (s'il est connecté)
-     * @return integer L'uid ou 0
-     */
-    public static function getCurrentUserID()
-    {
-        global $xoopsUser;
-        $uid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
-
-        return $uid;
-    }
-
-    /**
-     * Retourne la liste des groupes de l'utilisateur courant (avec cache)
-     * @param int $uid
-     * @return array Les ID des groupes auquel l'utilisateur courant appartient
-     */
-    public static function getMemberGroups($uid = 0)
-    {
-        static $buffer = array();
-        if ($uid == 0) {
-            $uid = self::getCurrentUserID();
-        }
-
-        if (is_array($buffer) && count($buffer) > 0 && isset($buffer[$uid])) {
-            return $buffer[$uid];
-        } else {
-            if ($uid > 0) {
-                $member_handler = xoops_getHandler('member');
-                $buffer[$uid]   = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
-            } else {
-                $buffer[$uid] = array(XOOPS_GROUP_ANONYMOUS);
-            }
-        }
-
-        return $buffer[$uid];
-    }
-
-    /**
-     * Indique si l'utilisateur courant fait partie d'une groupe donné (avec gestion de cache)
-     *
-     * @param integer $group Groupe recherché
-     * @param int     $uid
-     * @return bool vrai si l'utilisateur fait partie du groupe, faux sinon
-     */
-    public static function isMemberOfGroup($group = 0, $uid = 0)
-    {
-        static $buffer = array();
-        $retval = false;
-        if ($uid == 0) {
-            $uid = self::getCurrentUserID();
-        }
-        if (is_array($buffer) && array_key_exists($group, $buffer)) {
-            $retval = $buffer[$group];
-        } else {
-            $member_handler = xoops_getHandler('member');
-            $groups         = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
-            $retval         = in_array($group, $groups);
-            $buffer[$group] = $retval;
-        }
-
-        return $retval;
-    }
-
-    /**
-     * Indique si un utilisateur fait partie de plusieurs groupes
-     * La fonction renvoie vrai dès qu'on trouve que le membre fait partir d'un des groupes
-     * @param array    $groups La liste des groupes à vérifier
-     * @param  integer $uid    L'ID de l'utilisateur
-     * @return boolean
-     */
-    public static function isMemberOfGroups($groups, $uid = 0)
-    {
-        if (count($groups) == 0) {
-            return false;
-        }
-        if ($uid == 0) {
-            $uid = self::getCurrentUserID();
-        }
-        foreach ($groups as $groupId) {
-            if (self::isMemberOfGroup($groupId, $uid)) {
-                return true;
-            }
-        }
-
-        return false;
-    }
-
-    /**
-     * Retourne le nombre total de groupes (y compris les anonymes)
-     */
-    public static function getGroupsCount()
-    {
-        static $cache = -1;
-        if ($cache == -1) {
-            global $xoopsDB;
-            $sql    = 'SELECT COUNT(*) FROM ' . $xoopsDB->prefix('groups');
-            $result = $xoopsDB->query($sql);
-            if (!$result) {
-                return false;
-            }
-            list($cache) = $xoopsDB->fetchRow($result);
-        }
-
-        return $cache;
-    }
-
-    /**
-     * Fonction chargée de vérifier qu'un répertoire existe, qu'on peut écrire dedans et création d'un fichier index.html
-     *
-     * @param string $folder Le chemin complet du répertoire à vérifier
-     * @return void
-     */
-    public static function prepareFolder($folder)
-    {
-        if (!is_dir($folder)) {
-            mkdir($folder, 0777);
-            file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>');
-        } else {
-            if (!is_writable($folder)) {
-                chmod($folder, 0777);
-            }
-        }
-    }
-
-    /**
-     * Load a language file
-     *
-     * @param string $languageFile     The required language file
-     * @param string $defaultExtension Default extension to use
-     */
-    public static function loadLanguageFile($languageFile, $defaultExtension = '.php')
-    {
-        global $xoopsConfig;
-        $root = self::MODULE_PATH;
-        if (strstr($languageFile, $defaultExtension) === false) {
-            $languageFile .= $defaultExtension;
-        }
-        if (file_exists($root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile)) {
-            require_once $root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile;
-        } else {    // Fallback
-            require_once $root . 'language' . DIRECTORY_SEPARATOR . 'english' . DIRECTORY_SEPARATOR . $languageFile;
-        }
-    }
-
-    /**
-     * Création d'une vignette en tenant compte des options du module concernant le mode de création des vignettes
-     *
-     * @param  string  $src_path
-     * @param  string  $dst_path
-     * @param  integer $param_width
-     * @param  integer $param_height
-     * @param  boolean $keep_original
-     * @param string   $fit Utilisé uniquement pour la méthode 0 (redimensionnement)
-     * @return boolean
-     */
-    public static function createThumb($src_path, $dst_path, $param_width, $param_height, $keep_original = false, $fit = 'inside')
-    {
-        //        require_once self::MODULE_PATH . 'class/wideimage/WideImage.php';
-        $resize = true;
-        // On commence par vérifier que l'image originale n'est pas plus petite que les dimensions demandées auquel cas il n'y a rien à faire
-        $pictureDimensions = getimagesize($src_path);
-        if (is_array($pictureDimensions)) {
-            $pictureWidth  = $pictureDimensions[0];
-            $pictureHeight = $pictureDimensions[1];
-            if ($pictureWidth < $param_width && $pictureHeight < $param_height) {
-                $resize = false;
-            }
-        }
-        $img = WideImage::load($src_path);
-        if ($resize) { // L'image est suffisament grande pour être réduite
-            $thumbMethod = 0;
-            if ($thumbMethod == 0) { // Redimensionnement de l'image
-                $result = $img->resize($param_width, $param_height, $fit);
-            } else { // Récupération d'une partie de l'image depuis le centre
-                // Calcul de left et top
-                $left = $top = 0;
-                if (is_array($pictureDimensions)) {
-                    if ($pictureWidth > $param_width) {
-                        $left = (int)(($pictureWidth / 2) - ($param_width / 2));
-                    }
-                    if ($pictureHeight > $param_height) {
-                        $top = (int)(($pictureHeight / 2) - ($param_height / 2));
-                    }
-                }
-                $result = $img->crop($left, $top, $param_width, $param_height);
-            }
-            $result->saveToFile($dst_path, null);
-        } else {
-            if ($src_path != $dst_path) {
-                @copy($src_path, $dst_path);
-            }
-        }
-        if (!$keep_original) {
-            @unlink($src_path);
-        }
-
-        return true;
-    }
-
-    /**
-     * Create the <option> of an html select
-     *
-     * @param  array $array   Array of index and labels
-     * @param  mixed $default the default value
-     * @param bool   $withNull
-     * @return string
-     */
-    private static function htmlSelectOptions($array, $default = 0, $withNull = true)
-    {
-        $ret      = array();
-        $selected = '';
-        if ($withNull) {
-            if (!is_array($default)) {
-                if ($default === 0) {
-                    $selected = " selected = 'selected'";
-                }
-            } else {
-                if (in_array(0, $default)) {
-                    $selected = " selected = 'selected'";
-                }
-            }
-            $ret[] = '<option value=0' . $selected . '>---</option>';
-        }
-
-        foreach ($array as $index => $label) {
-            $selected = '';
-            if (!is_array($default)) {
-                if ($index == $default) {
-                    $selected = " selected = 'selected'";
-                }
-            } else {
-                if (in_array($index, $default)) {
-                    $selected = " selected = 'selected'";
-                }
-            }
-            $ret[] = "<option value=\"" . $index . "\"" . $selected . '>' . $label . '</option>';
-        }
-
-        return implode("\n", $ret);
-    }
-
-    /**
-     * Creates an html select an returns its code
-     *
-     * @param  string  $selectName Select's name
-     * @param  array   $array      Key = value of each option, value = label of each option
-     * @param  mixed   $default    Default's value
-     * @param  boolean $withNull   Do we want a null option
-     * @param  string  $style      Is there a style to apply ?
-     * @param  boolean $multiple   Can we select multiple elements ?
-     * @param  integer $size       Size of the selectbox, only used with multiple selectboxes
-     * @param string   $extra
-     * @return string
-     */
-    public static function htmlSelect($selectName, $array, $default, $withNull = true, $style = '', $multiple = false, $size = 1, $extra = '')
-    {
-        $ret = '';
-        $ret .= "<select name='" . $selectName . "' id='" . $selectName . "'";
-        if (xoops_trim($style) != '') {
-            $ret .= " style='" . $style . "' ";
-        }
-        if (xoops_trim($multiple) != '') {
-            $ret .= " multiple = 'multiple' size='" . $size . "' ";
-        }
-        $ret .= $extra . ">\n";
-        $ret .= self::htmlSelectOptions($array, $default, $withNull);
-        $ret .= "</select>\n";
-
-        return $ret;
-    }
-
-    /**
-     * Verify that a mysql table exists
-     * @param $tablename
-     * @return bool
-     */
-    public static function tableExists($tablename)
-    {
-        global $xoopsDB;
-        $result = $xoopsDB->queryF("SHOW TABLES LIKE '$tablename'");
-
-        return ($xoopsDB->getRowsNum($result) > 0);
-    }
-
-    /**
-     * Verify that a field exists inside a mysql table
-     * @param $fieldname
-     * @param $table
-     * @return bool
-     */
-    public static function fieldExists($fieldname, $table)
-    {
-        global $xoopsDB;
-        $result = $xoopsDB->queryF("SHOW COLUMNS FROM $table LIKE '$fieldname'");
-
-        return ($xoopsDB->getRowsNum($result) > 0);
-    }
-
-    /**
-     * Retourne la définition d'un champ
-     *
-     * @param  string $fieldname
-     * @param  string $table
-     * @return array
-     */
-    public static function getFieldDefinition($fieldname, $table)
-    {
-        global $xoopsDB;
-        $result = $xoopsDB->queryF("SHOW COLUMNS FROM $table LIKE '$fieldname'");
-        if ($result) {
-            return $xoopsDB->fetchArray($result);
-        }
-
-        return '';
-    }
-
-    /**
-     * Add a field to a mysql table
-     * @param $field
-     * @param $table
-     * @return resource
-     */
-    public static function addField($field, $table)
-    {
-        global $xoopsDB;
-        $result = $xoopsDB->queryF("ALTER TABLE $table ADD $field;");
-
-        return $result;
-    }
-
-    /**
-     * Maintenance des tables du module et de son cache de requêtes
-     *
-     * @return void
-     */
-    public static function maintainTablesCache()
-    {
-        global $xoopsDB;
-        define('REFERENCES_MAINTAIN', true);
-        require self::MODULE_PATH . 'xoops_version.php';
-        $tables = array();
-        foreach ($modversion['tables'] as $table) {
-            $tables[] = $xoopsDB->prefix($table);
-        }
-        if (count($tables) > 0) {
-            $list = implode(',', $tables);
-            $xoopsDB->queryF('CHECK TABLE ' . $list);
-            $xoopsDB->queryF('ANALYZE TABLE ' . $list);
-            $xoopsDB->queryF('OPTIMIZE TABLE ' . $list);
-        }
-        self::updateCache();
-        $handlers = references_handler::getInstance();
-        $handlers->h_references_articles->forceCacheClean();
-    }
-
-    /**
-     * Indique si le module Tag existe et est activé
-     *
-     * @return boolean
-     * @credit: smartfactory
-     */
-    public static function tagModuleExists()
-    {
-        static $moduleExistsAndIsActive;
-        if (!isset($moduleExistsAndIsActive)) {
-            $modules_handler = xoops_getHandler('module');
-            $tagModule       = $modules_handler->getByDirName('tag');
-            if (!$tagModule) {
-                $moduleExistsAndIsActive = false;
-            } else {
-                $moduleExistsAndIsActive = $tagModule->getVar('isactive') == 1;
-            }
-        }
-
-        return $moduleExistsAndIsActive;
-    }
+	// Pour la portabilité de module à module
+	const MODULE_NAME    = 'references';
+	const MODULE_DIRNAME = REFERENCES_DIRNAME;
+	const MODULE_PATH    = REFERENCES_PATH;
+	const MODULE_URL     = REFERENCES_URL;
+	const MODULE_JS_URL  = REFERENCES_JS_URL;
+
+	/**
+	 * Access the only instance of this class
+	 *
+	 * @return object
+	 *
+	 * @static
+	 * @staticvar   object
+	 */
+	public static function getInstance()
+	{
+		static $instance;
+		if (null === $instance) {
+			$instance = new static();
+		}
+
+		return $instance;
+	}
+
+	/**
+	 * Returns a module's option (with cache)
+	 *
+	 * @param  string  $option    module option's name
+	 * @param  boolean $withCache Do we have to use some cache ?
+	 * @return mixed   option's value
+	 */
+	public static function getModuleOption($option, $withCache = true)
+	{
+		global $xoopsModuleConfig, $xoopsModule;
+		$repmodule = self::MODULE_NAME;
+		static $options = array();
+		if (is_array($options) && array_key_exists($option, $options) && $withCache) {
+			return $options[$option];
+		}
+
+		$retval = false;
+		if (isset($xoopsModuleConfig) && (is_object($xoopsModule) && $xoopsModule->getVar('dirname') == $repmodule && $xoopsModule->getVar('isactive'))) {
+			if (isset($xoopsModuleConfig[$option])) {
+				$retval = $xoopsModuleConfig[$option];
+			}
+		} else {
+			$module_handler = xoops_getHandler('module');
+			$module         = $module_handler->getByDirname($repmodule);
+			$config_handler = xoops_getHandler('config');
+			if ($module) {
+				$moduleConfig = $config_handler->getConfigsByCat(0, $module->getVar('mid'));
+				if (isset($moduleConfig[$option])) {
+					$retval = $moduleConfig[$option];
+				}
+			}
+		}
+		$options[$option] = $retval;
+
+		return $retval;
+	}
+
+	/**
+	 * Is Xoops 2.3.x ?
+	 *
+	 * @return boolean need to say it ?
+	 */
+	public static function isX23()
+	{
+		$x23 = false;
+		$xv  = str_replace('XOOPS ', '', XOOPS_VERSION);
+		if ((int)substr($xv, 2, 1) >= 3) {
+			$x23 = true;
+		}
+
+		return $x23;
+	}
+
+	/**
+	 * Retreive an editor according to the module's option "form_options"
+	 *
+	 * @param  string $caption Caption to give to the editor
+	 * @param  string $name    Editor's name
+	 * @param  string $value   Editor's value
+	 * @param  string $width   Editor's width
+	 * @param  string $height  Editor's height
+	 * @param string  $supplemental
+	 * @return object The editor to use
+	 */
+	public static function getWysiwygForm($caption, $name, $value = '', $width = '100%', $height = '400px', $supplemental = '')
+	{
+		$editor                   = false;
+		$editor_configs           = array();
+		$editor_configs['name']   = $name;
+		$editor_configs['value']  = $value;
+		$editor_configs['rows']   = 35;
+		$editor_configs['cols']   = 60;
+		$editor_configs['width']  = '100%';
+		$editor_configs['height'] = '400px';
+
+		$editor_option = strtolower(self::getModuleOption('form_options'));
+
+		if (self::isX23()) {
+			$editor = new XoopsFormEditor($caption, $editor_option, $editor_configs);
+
+			return $editor;
+		}
+
+		// Only for Xoops 2.0.x
+		switch ($editor_option) {
+			case 'fckeditor':
+				if (is_readable(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php')) {
+					require_once(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php');
+					$editor = new XoopsFormFckeditor($caption, $name, $value);
+				}
+				break;
+
+			case 'htmlarea':
+				if (is_readable(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php')) {
+					require_once(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php');
+					$editor = new XoopsFormHtmlarea($caption, $name, $value);
+				}
+				break;
+
+			case 'dhtmltextarea':
+				$editor = new XoopsFormDhtmlTextArea($caption, $name, $value, 10, 50, $supplemental);
+				break;
+
+			case 'textarea':
+				$editor = new XoopsFormTextArea($caption, $name, $value);
+				break;
+
+			case 'tinyeditor':
+			case 'tinymce':
+				if (is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php')) {
+					require_once XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php';
+					$editor = new XoopsFormTinyeditorTextArea(array('caption' => $caption, 'name' => $name, 'value' => $value, 'width' => '100%', 'height' => '400px'));
+				}
+				break;
+
+			case 'koivi':
+				if (is_readable(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php')) {
+					require_once(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php');
+					$editor = new XoopsFormWysiwygTextArea($caption, $name, $value, $width, $height, '');
+				}
+				break;
+		}
+		if (!is_object($editor)) {
+			trigger_error('Error, impossible to get the requested text editor', E_USER_ERROR);
+		}
+
+		return $editor;
+	}
+
+	/**
+	 * Create (in a link) a javascript confirmation's box
+	 *
+	 * @param  string  $message Message to display
+	 * @param  boolean $form    Is this a confirmation for a form ?
+	 * @return string  the javascript code to insert in the link (or in the form)
+	 */
+	public static function javascriptLinkConfirm($message, $form = false)
+	{
+		if (!$form) {
+			return "onclick=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
+		} else {
+			return "onSubmit=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
+		}
+	}
+
+	/**
+	 * Get current user IP
+	 *
+	 * @return string IP address (format Ipv4)
+	 */
+	public static function IP()
+	{
+		$proxy_ip = '';
+		if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
+			$proxy_ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
+		} elseif (!empty($_SERVER['HTTP_X_FORWARDED'])) {
+			$proxy_ip = $_SERVER['HTTP_X_FORWARDED'];
+		} elseif (!empty($_SERVER['HTTP_FORWARDED_FOR'])) {
+			$proxy_ip = $_SERVER['HTTP_FORWARDED_FOR'];
+		} elseif (!empty($_SERVER['HTTP_FORWARDED'])) {
+			$proxy_ip = $_SERVER['HTTP_FORWARDED'];
+		} elseif (!empty($_SERVER['HTTP_VIA'])) {
+			$proxy_ip = $_SERVER['HTTP_VIA'];
+		} elseif (!empty($_SERVER['HTTP_X_COMING_FROM'])) {
+			$proxy_ip = $_SERVER['HTTP_X_COMING_FROM'];
+		} elseif (!empty($_SERVER['HTTP_COMING_FROM'])) {
+			$proxy_ip = $_SERVER['HTTP_COMING_FROM'];
+		}
+		$regs = array();
+		if (!empty($proxy_ip) && $is_ip = ereg('^([0-9]{1,3}\.){3,3}[0-9]{1,3}', $proxy_ip, $regs) && count($regs) > 0) {
+			$the_IP = $regs[0];
+		} else {
+			$the_IP = $_SERVER['REMOTE_ADDR'];
+		}
+
+		return $the_IP;
+	}
+
+	/**
+	 * Set the page's title, meta description and meta keywords
+	 * Datas are supposed to be sanitized
+	 *
+	 * @param  string $pageTitle       Page's Title
+	 * @param  string $metaDescription Page's meta description
+	 * @param  string $metaKeywords    Page's meta keywords
+	 * @return void
+	 */
+	public static function setMetas($pageTitle = '', $metaDescription = '', $metaKeywords = '')
+	{
+		global $xoTheme, $xoTheme, $xoopsTpl;
+		$xoopsTpl->assign('xoops_pagetitle', $pageTitle);
+		if (isset($xoTheme) && is_object($xoTheme)) {
+			if (!empty($metaKeywords)) {
+				$xoTheme->addMeta('meta', 'keywords', $metaKeywords);
+			}
+			if (!empty($metaDescription)) {
+				$xoTheme->addMeta('meta', 'description', $metaDescription);
+			}
+		} elseif (isset($xoopsTpl) && is_object($xoopsTpl)) {    // Compatibility for old Xoops versions
+			if (!empty($metaKeywords)) {
+				$xoopsTpl->assign('xoops_meta_keywords', $metaKeywords);
+			}
+			if (!empty($metaDescription)) {
+				$xoopsTpl->assign('xoops_meta_description', $metaDescription);
+			}
+		}
+	}
+
+	/**
+	 * Send an email from a template to a list of recipients
+	 *
+	 * @param         $tplName
+	 * @param  array  $recipients List of recipients
+	 * @param  string $subject    Email's subject
+	 * @param  array  $variables  Varirables to give to the template
+	 * @return bool Result of the send
+	 * @internal param string $tpl_name Template's name
+	 */
+	public static function sendEmailFromTpl($tplName, $recipients, $subject, $variables)
+	{
+		global $xoopsConfig;
+		require_once XOOPS_ROOT_PATH . '/class/xoopsmailer.php';
+		if (!is_array($recipients)) {
+			if (trim($recipients) == '') {
+				return false;
+			}
+		} else {
+			if (count($recipients) == 0) {
+				return false;
+			}
+		}
+		if (function_exists('xoops_getMailer')) {
+			$xoopsMailer = xoops_getMailer();
+		} else {
+			$xoopsMailer =& getMailer();
+		}
+
+		$xoopsMailer->useMail();
+		$xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH . '/modules/' . self::MODULE_NAME . '/language/' . $xoopsConfig['language'] . '/mail_template');
+		$xoopsMailer->setTemplate($tplName);
+		$xoopsMailer->setToEmails($recipients);
+		// TODO: Change !
+		// $xoopsMailer->setFromEmail('contact@monsite.com');
+		//$xoopsMailer->setFromName('MonSite');
+		$xoopsMailer->setSubject($subject);
+		foreach ($variables as $key => $value) {
+			$xoopsMailer->assign($key, $value);
+		}
+		$res = $xoopsMailer->send();
+		unset($xoopsMailer);
+		$filename = XOOPS_UPLOAD_PATH . '/logmail_' . self::MODULE_NAME . '.php';
+		if (!file_exists($filename)) {
+			$fp = @fopen($filename, 'a');
+			if ($fp) {
+				fwrite($fp, '<?php exit(); ?>');
+				fclose($fp);
+			}
+		}
+		$fp = @fopen($filename, 'a');
+
+		if ($fp) {
+			fwrite($fp, str_repeat('-', 120) . "\n");
+			fwrite($fp, date('d/m/Y H:i:s') . "\n");
+			fwrite($fp, 'Template name : ' . $tplName . "\n");
+			fwrite($fp, 'Email subject : ' . $subject . "\n");
+			if (is_array($recipients)) {
+				fwrite($fp, 'Recipient(s) : ' . implode(',', $recipients) . "\n");
+			} else {
+				fwrite($fp, 'Recipient(s) : ' . $recipients . "\n");
+			}
+			fwrite($fp, 'Transmited variables : ' . implode(',', $variables) . "\n");
+			fclose($fp);
+		}
+
+		return $res;
+	}
+
+	/**
+	 * Remove module's cache
+	 */
+	public static function updateCache()
+	{
+		global $xoopsModule;
+		$folder  = $xoopsModule->getVar('dirname');
+		$tpllist = array();
+		require_once XOOPS_ROOT_PATH . '/class/xoopsblock.php';
+		require_once XOOPS_ROOT_PATH . '/class/template.php';
+		$tplfile_handler = xoops_getHandler('tplfile');
+		$tpllist         = $tplfile_handler->find(null, null, null, $folder);
+		xoops_template_clear_module_cache($xoopsModule->getVar('mid'));            // Clear module's blocks cache
+
+		foreach ($tpllist as $onetemplate) {    // Remove cache for each page.
+			if ($onetemplate->getVar('tpl_type') === 'module') {
+				//  Note, I've been testing all the other methods (like the one of Smarty) and none of them run, that's why I have used this code
+				$files_del = array();
+				$files_del = glob(XOOPS_CACHE_PATH . '/*' . $onetemplate->getVar('tpl_file') . '*');
+				if (count($files_del) > 0 && is_array($files_del)) {
+					foreach ($files_del as $one_file) {
+						if (is_file($one_file)) {
+							unlink($one_file);
+						}
+					}
+				}
+			}
+		}
+	}
+
+	/**
+	 * Redirect user with a message
+	 *
+	 * @param string $message message to display
+	 * @param string $url     The place where to go
+	 * @param        integer  timeout Time to wait before to redirect
+	 */
+	public static function redirect($message = '', $url = 'index.php', $time = 2)
+	{
+		redirect_header($url, $time, $message);
+		exit();
+	}
+
+	/**
+	 * Internal function used to get the handler of the current module
+	 *
+	 * @return object The module
+	 */
+	public static function getModule()
+	{
+		static $mymodule;
+		if (!isset($mymodule)) {
+			global $xoopsModule;
+			if (isset($xoopsModule) && is_object($xoopsModule) && $xoopsModule->getVar('dirname') == REFERENCES_DIRNAME) {
+				$mymodule =& $xoopsModule;
+			} else {
+				$hModule  = xoops_getHandler('module');
+				$mymodule = $hModule->getByDirname(REFERENCES_DIRNAME);
+			}
+		}
+
+		return $mymodule;
+	}
+
+	/**
+	 * Returns the module's name (as defined by the user in the module manager) with cache
+	 * @return string Module's name
+	 */
+	public static function getModuleName()
+	{
+		static $moduleName;
+		if (!isset($moduleName)) {
+			$mymodule   = self::getModule();
+			$moduleName = $mymodule->getVar('name');
+		}
+
+		return $moduleName;
+	}
+
+	/**
+	 * Create a title for the href tags inside html links
+	 *
+	 * @param  string $title Text to use
+	 * @return string Formated text
+	 */
+	public static function makeHrefTitle($title)
+	{
+		$s = "\"'";
+		$r = '  ';
+
+		return strtr($title, $s, $r);
+	}
+
+	/**
+	 * Retourne la liste des utilisateurs appartenants � un groupe
+	 *
+	 * @param  int $groupId Searched group
+	 * @return array Array of XoopsUsers
+	 */
+	public static function getUsersFromGroup($groupId)
+	{
+		$users          = array();
+		$member_handler = xoops_getHandler('member');
+		$users          = $member_handler->getUsersByGroup($groupId, true);
+
+		return $users;
+	}
+
+	/**
+	 * Retourne les ID des utilisateurs faisant partie de plusieurs groupes
+	 * @param  array $groups Les ID des groupes dont on recherche les ID utilisateurs
+	 * @return array Les ID utilisateurs
+	 */
+	public static function getUsersIdsFromGroups($groups)
+	{
+		$usersIds       = array();
+		$member_handler = xoops_getHandler('member');
+		foreach ($groups as $groupId) {
+			$temporaryGroup = array();
+			$temporaryGroup = $member_handler->getUsersByGroup($groupId);
+			if (count($temporaryGroup) > 0) {
+				$usersIds = array_merge($usersIds, $temporaryGroup);
+			}
+		}
+
+		return array_unique($usersIds);
+	}
+
+	/**
+	 * Retourne la liste des emails des utilisateurs membres d'un groupe
+	 *
+	 * @param $groupId
+	 * @return array Emails list
+	 * @internal param int $group_id Group's number
+	 */
+	public static function getEmailsFromGroup($groupId)
+	{
+		$ret   = array();
+		$users = self::getUsersFromGroup($groupId);
+		foreach ($users as $user) {
+			$ret[] = $user->getVar('email');
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * V�rifie que l'utilisateur courant fait partie du groupe des administrateurs
+	 *
+	 * @return booleean Admin or not
+	 */
+	public static function isAdmin()
+	{
+		global $xoopsUser, $xoopsModule;
+		if (is_object($xoopsUser)) {
+			if (in_array(XOOPS_GROUP_ADMIN, $xoopsUser->getGroups())) {
+				return true;
+			} elseif (isset($xoopsModule) && $xoopsUser->isAdmin($xoopsModule->getVar('mid'))) {
+				return true;
+			}
+		}
+
+		return false;
+	}
+
+	/**
+	 * Returns the current date in the Mysql format
+	 *
+	 * @return string Date in the Mysql format
+	 */
+	public static function getCurrentSQLDate()
+	{
+		return date('Y-m-d');    // 2007-05-02
+	}
+
+	public static function getCurrentSQLDateTime()
+	{
+		return date('Y-m-d H:i:s');    // 2007-05-02
+	}
+
+	/**
+	 * Convert a Mysql date to the human's format
+	 *
+	 * @param  string $date The date to convert
+	 * @param string  $format
+	 * @return string The date in a human form
+	 */
+	public static function SQLDateToHuman($date, $format = 'l')
+	{
+		if ($date != '0000-00-00' && xoops_trim($date) != '') {
+			return formatTimestamp(strtotime($date), $format);
+		} else {
+			return '';
+		}
+	}
+
+	/**
+	 * Convert a timestamp to a Mysql date
+	 *
+	 * @param  integer $timestamp The timestamp to use
+	 * @return string  The date in the Mysql format
+	 */
+	public static function timestampToMysqlDate($timestamp)
+	{
+		return date('Y-m-d', (int)$timestamp);
+	}
+
+	/**
+	 * Conversion d'un dateTime Mysql en date lisible en fran�ais
+	 * @param $dateTime
+	 * @return bool|string
+	 */
+	public static function sqlDateTimeToFrench($dateTime)
+	{
+		return date('d/m/Y H:i:s', strtotime($dateTime));
+	}
+
+	/**
+	 * Convert a timestamp to a Mysql datetime form
+	 * @param  integer $timestamp The timestamp to use
+	 * @return string  The date and time in the Mysql format
+	 */
+	public static function timestampToMysqlDateTime($timestamp)
+	{
+		return date('Y-m-d H:i:s', $timestamp);
+	}
+
+	/**
+	 * This function indicates if the current Xoops version needs to add asterisks to required fields in forms
+	 *
+	 * @return boolean Yes = we need to add them, false = no
+	 */
+	public static function needsAsterisk()
+	{
+		if (self::isX23()) {
+			return false;
+		}
+		if (strpos(strtolower(XOOPS_VERSION), 'impresscms') !== false) {
+			return false;
+		}
+		if (strpos(strtolower(XOOPS_VERSION), 'legacy') === false) {
+			$xv = xoops_trim(str_replace('XOOPS ', '', XOOPS_VERSION));
+			if ((int)substr($xv, 4, 2) >= 17) {
+				return false;
+			}
+		}
+
+		return true;
+	}
+
+	/**
+	 * Mark the mandatory fields of a form with a star
+	 *
+	 * @param  object $sform The form to modify
+	 * @return object The modified form
+	 * @internal param string $caracter The character to use to mark fields
+	 */
+	public static function &formMarkRequiredFields(&$sform)
+	{
+		if (self::needsAsterisk()) {
+			$required = array();
+			foreach ($sform->getRequired() as $item) {
+				$required[] = $item->_name;
+			}
+			$elements = array();
+			$elements = &$sform->getElements();
+			$cnt      = count($elements);
+			for ($i = 0; $i < $cnt; ++$i) {
+				if (is_object($elements[$i]) && in_array($elements[$i]->_name, $required)) {
+					$elements[$i]->_caption .= ' *';
+				}
+			}
+		}
+
+		return $sform;
+	}
+
+	/**
+	 * Create an html heading (from h1 to h6)
+	 *
+	 * @param  string  $title The text to use
+	 * @param  integer $level Level to return
+	 * @return string  The heading
+	 */
+	public static function htitle($title = '', $level = 1)
+	{
+		printf('<h%01d>%s</h%01d>', $level, $title, $level);
+	}
+
+	/**
+	 * Create a unique upload filename
+	 *
+	 * @param  string  $folder   The folder where the file will be saved
+	 * @param  string  $fileName Original filename (coming from the user)
+	 * @param  boolean $trimName Do we need to create a short unique name ?
+	 * @return string  The unique filename to use (with its extension)
+	 */
+	public static function createUploadName($folder, $fileName, $trimName = false)
+	{
+		$workingfolder = $folder;
+		if (substr($workingfolder, strlen($workingfolder) - 1, 1) !== '/') {
+			$workingfolder .= '/';
+		}
+		$ext  = basename($fileName);
+		$ext  = explode('.', $ext);
+		$ext  = '.' . $ext[count($ext) - 1];
+		$true = true;
+		while ($true) {
+			$ipbits = explode('.', $_SERVER['REMOTE_ADDR']);
+			list($usec, $sec) = explode(' ', microtime());
+			$usec = (integer)($usec * 65536);
+			$sec  = ((integer)$sec) & 0xFFFF;
+
+			if ($trimName) {
+				$uid = sprintf('%06x%04x%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
+			} else {
+				$uid = sprintf('%08x-%04x-%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
+			}
+			if (!file_exists($workingfolder . $uid . $ext)) {
+				$true = false;
+			}
+		}
+
+		return $uid . $ext;
+	}
+
+	/**
+	 * Replace html entities with their ASCII equivalent
+	 *
+	 * @param  string $chaine The string undecode
+	 * @return string The undecoded string
+	 */
+	public static function unhtml($chaine)
+	{
+		$search = $replace = array();
+		$chaine = html_entity_decode($chaine);
+
+		for ($i = 0; $i <= 255; ++$i) {
+			$search[]  = '&#' . $i . ';';
+			$replace[] = chr($i);
+		}
+		$replace[]='...'; $search[]='…';
+		$replace[]="'"; $search[]='‘';
+		$replace[]="'"; $search[]= '’';
+		$replace[]='-'; $search[] = '&bull;';   // $replace[] = '•';
+		$replace[]='—'; $search[]='&mdash;';
+		$replace[]='-'; $search[]='&ndash;';
+		$replace[]='-'; $search[]='&shy;';
+		$replace[]='"'; $search[]='&quot;';
+		$replace[]='&'; $search[]='&amp;';
+		$replace[]='ˆ'; $search[]='&circ;';
+		$replace[]='¡'; $search[]='&iexcl;';
+		$replace[]='¦'; $search[]='&brvbar;';
+		$replace[]='¨'; $search[]='&uml;';
+		$replace[]='¯'; $search[]='&macr;';
+		$replace[]='´'; $search[]='&acute;';
+		$replace[]='¸'; $search[]='&cedil;';
+		$replace[]='¿'; $search[]='&iquest;';
+		$replace[]='˜'; $search[]='&tilde;';
+		$replace[]="'"; $search[]='&lsquo;';    // $replace[]='‘';
+		$replace[]="'"; $search[]='&rsquo;';    // $replace[]='’';
+		$replace[]='‚'; $search[]='&sbquo;';
+		$replace[]="'"; $search[]='&ldquo;';    // $replace[]='“';
+		$replace[]="'"; $search[]='&rdquo;';    // $replace[]='”';
+		$replace[]='„'; $search[]='&bdquo;';
+		$replace[]='‹'; $search[]='&lsaquo;';
+		$replace[]='›'; $search[]='&rsaquo;';
+		$replace[]='<'; $search[]='&lt;';
+		$replace[]='>'; $search[]='&gt;';
+		$replace[]='±'; $search[]='&plusmn;';
+		$replace[]='«'; $search[]='&laquo;';
+		$replace[]='»'; $search[]='&raquo;';
+		$replace[]='×'; $search[]='&times;';
+		$replace[]='÷'; $search[]='&divide;';
+		$replace[]='¢'; $search[]='&cent;';
+		$replace[]='£'; $search[]='&pound;';
+		$replace[]='¤'; $search[]='&curren;';
+		$replace[]='¥'; $search[]='&yen;';
+		$replace[]='§'; $search[]='&sect;';
+		$replace[]='©'; $search[]='&copy;';
+		$replace[]='¬'; $search[]='&not;';
+		$replace[]='®'; $search[]='&reg;';
+		$replace[]='°'; $search[]='&deg;';
+		$replace[]='µ'; $search[]='&micro;';
+		$replace[]='¶'; $search[]='&para;';
+		$replace[]='·'; $search[]='&middot;';
+		$replace[]='†'; $search[]='&dagger;';
+		$replace[]='‡'; $search[]='&Dagger;';
+		$replace[]='‰'; $search[]='&permil;';
+		$replace[]='Euro'; $search[]='&euro;';      // $replace[]='€'
+		$replace[]='¼'; $search[]='&frac14;';
+		$replace[]='½'; $search[]='&frac12;';
+		$replace[]='¾'; $search[]='&frac34;';
+		$replace[]='¹'; $search[]='&sup1;';
+		$replace[]='²'; $search[]='&sup2;';
+		$replace[]='³'; $search[]='&sup3;';
+		$replace[]='á'; $search[]='&aacute;';
+		$replace[]='Á'; $search[]='&Aacute;';
+		$replace[]='â'; $search[]='&acirc;';
+		$replace[]='Â'; $search[]='&Acirc;';
+		$replace[]='à'; $search[]='&agrave;';
+		$replace[]='À'; $search[]='&Agrave;';
+		$replace[]='å'; $search[]='&aring;';
+		$replace[]='Å'; $search[]='&Aring;';
+		$replace[]='ã'; $search[]='&atilde;';
+		$replace[]='Ã'; $search[]='&Atilde;';
+		$replace[]='ä'; $search[]='&auml;';
+		$replace[]='Ä'; $search[]='&Auml;';
+		$replace[]='ª'; $search[]='&ordf;';
+		$replace[]='æ'; $search[]='&aelig;';
+		$replace[]='Æ'; $search[]='&AElig;';
+		$replace[]='ç'; $search[]='&ccedil;';
+		$replace[]='Ç'; $search[]='&Ccedil;';
+		$replace[]='ð'; $search[]='&eth;';
+		$replace[]='Ð'; $search[]='&ETH;';
+		$replace[]='é'; $search[]='&eacute;';
+		$replace[]='É'; $search[]='&Eacute;';
+		$replace[]='ê'; $search[]='&ecirc;';
+		$replace[]='Ê'; $search[]='&Ecirc;';
+		$replace[]='è'; $search[]='&egrave;';
+		$replace[]='È'; $search[]='&Egrave;';
+		$replace[]='ë'; $search[]='&euml;';
+		$replace[]='Ë'; $search[]='&Euml;';
+		$replace[]='ƒ'; $search[]='&fnof;';
+		$replace[]='í'; $search[]='&iacute;';
+		$replace[]='Í'; $search[]='&Iacute;';
+		$replace[]='î'; $search[]='&icirc;';
+		$replace[]='Î'; $search[]='&Icirc;';
+		$replace[]='ì'; $search[]='&igrave;';
+		$replace[]='Ì'; $search[]='&Igrave;';
+		$replace[]='ï'; $search[]='&iuml;';
+		$replace[]='Ï'; $search[]='&Iuml;';
+		$replace[]='ñ'; $search[]='&ntilde;';
+		$replace[]='Ñ'; $search[]='&Ntilde;';
+		$replace[]='ó'; $search[]='&oacute;';
+		$replace[]='Ó'; $search[]='&Oacute;';
+		$replace[]='ô'; $search[]='&ocirc;';
+		$replace[]='Ô'; $search[]='&Ocirc;';
+		$replace[]='ò'; $search[]='&ograve;';
+		$replace[]='Ò'; $search[]='&Ograve;';
+		$replace[]='º'; $search[]='&ordm;';
+		$replace[]='ø'; $search[]='&oslash;';
+		$replace[]='Ø'; $search[]='&Oslash;';
+		$replace[]='õ'; $search[]='&otilde;';
+		$replace[]='Õ'; $search[]='&Otilde;';
+		$replace[]='ö'; $search[]='&ouml;';
+		$replace[]='Ö'; $search[]='&Ouml;';
+		$replace[]='œ'; $search[]='&oelig;';
+		$replace[]='Œ'; $search[]='&OElig;';
+		$replace[]='š'; $search[]='&scaron;';
+		$replace[]='Š'; $search[]='&Scaron;';
+		$replace[]='ß'; $search[]='&szlig;';
+		$replace[]='þ'; $search[]='&thorn;';
+		$replace[]='Þ'; $search[]='&THORN;';
+		$replace[]='ú'; $search[]='&uacute;';
+		$replace[]='Ú'; $search[]='&Uacute;';
+		$replace[]='û'; $search[]='&ucirc;';
+		$replace[]='Û'; $search[]='&Ucirc;';
+		$replace[]='ù'; $search[]='&ugrave;';
+		$replace[]='Ù'; $search[]='&Ugrave;';
+		$replace[]='ü'; $search[]='&uuml;';
+		$replace[]='Ü'; $search[]='&Uuml;';
+		$replace[]='ý'; $search[]='&yacute;';
+		$replace[]='Ý'; $search[]='&Yacute;';
+		$replace[]='ÿ'; $search[]='&yuml;';
+		$replace[]='Ÿ'; $search[]='&Yuml;';
+		$chaine    = str_replace($search, $replace, $chaine);
+
+		return $chaine;
+	}
+
+	/**
+	 * Création d'une titre pour être utilisé par l'url rewriting
+	 *
+	 * @param string  $content  Le texte à utiliser pour créer l'url
+	 * @param integer $urw      La limite basse pour créer les mots
+	 * @return string Le texte à utiliser pour l'url
+	 *                          Note, some parts are from Solo's code
+	 */
+	public static function makeSeoUrl($content, $urw = 1)
+	{
+		$s       = "ÀÁÂÃÄÅÒÓÔÕÖØÈÉÊËÇÌÍÎÏÙÚÛÜŸÑàáâãäåòóôõöøèéêëçìíîïùúûüÿñ '()";
+		$r       = 'AAAAAAOOOOOOEEEECIIIIUUUUYNaaaaaaooooooeeeeciiiiuuuuyn----';
+		$content = self::unhtml($content);    // First, remove html entities
+		$content = strtr($content, $s, $r);
+		$content = strip_tags($content);
+		$content = strtolower($content);
+		$content = htmlentities($content);    // TODO: Vérifier
+		$content = preg_replace('/&([a-zA-Z])(uml|acute|grave|circ|tilde);/', '$1', $content);
+		$content = html_entity_decode($content);
+		$content = eregi_replace('quot', ' ', $content);
+		$content = eregi_replace("'", ' ', $content);
+		$content = eregi_replace('-', ' ', $content);
+		$content = eregi_replace('[[:punct:]]', '', $content);
+		// Selon option mais attention au fichier .htaccess !
+		// $content = eregi_replace('[[:digit:]]','', $content);
+		$content = preg_replace('/[^a-z|A-Z|0-9]/', '-', $content);
+
+		$words    = explode(' ', $content);
+		$keywords = '';
+		foreach ($words as $word) {
+			if (strlen($word) >= $urw) {
+				$keywords .= '-' . trim($word);
+			}
+		}
+		if (!$keywords) {
+			$keywords = '-';
+		}
+		// Supprime les tirets en double
+		$keywords = str_replace('---', '-', $keywords);
+		$keywords = str_replace('--', '-', $keywords);
+		// Supprime un éventuel tiret à la fin de la chaine
+		if (substr($keywords, strlen($keywords) - 1, 1) == '-') {
+			$keywords = substr($keywords, 0, strlen($keywords) - 1);
+		}
+
+		return $keywords;
+	}
+
+	/**
+	 * Create the meta keywords based on the content
+	 *
+	 * @param  string $content Content from which we have to create metakeywords
+	 * @return string The list of meta keywords
+	 */
+	public static function createMetaKeywords($content)
+	{
+		$keywordscount = REFERENCES_METAGEN_MAX_KEYWORDS;
+		$keywordsorder = REFERENCES_METAGEN_KEYWORDS_ORDER;
+
+		$tmp = array();
+		// Search for the "Minimum keyword length"
+		// TODO: Remplacer references_keywords_limit par une constante
+		if (isset($_SESSION['references_keywords_limit'])) {
+			$limit = $_SESSION['references_keywords_limit'];
+		} else {
+			$config_handler                        = xoops_getHandler('config');
+			$xoopsConfigSearch                     =& $config_handler->getConfigsByCat(XOOPS_CONF_SEARCH);
+			$limit                                 = $xoopsConfigSearch['keyword_min'];
+			$_SESSION['references_keywords_limit'] = $limit;
+		}
+		$myts            = MyTextSanitizer::getInstance();
+		$content         = str_replace('<br>', ' ', $content);
+		$content         = $myts->undoHtmlSpecialChars($content);
+		$content         = strip_tags($content);
+		$content         = strtolower($content);
+		$search_pattern  = array('&nbsp;', "\t", "\r\n", "\r", "\n", ',', '.', "'", ';', ':', ')', '(', '"', '?', '!', '{', '}', '[', ']', '<', '>', '/', '+', '-', '_', '\\', '*');
+		$replace_pattern = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
+		$content         = str_replace($search_pattern, $replace_pattern, $content);
+		$keywords        = explode(' ', $content);
+		switch ($keywordsorder) {
+			case 0:    // Ordre d'apparition dans le texte
+				$keywords = array_unique($keywords);
+				break;
+			case 1:    // Ordre de fréquence des mots
+				$keywords = array_count_values($keywords);
+				asort($keywords);
+				$keywords = array_keys($keywords);
+				break;
+			case 2:    // Ordre inverse de la fréquence des mots
+				$keywords = array_count_values($keywords);
+				arsort($keywords);
+				$keywords = array_keys($keywords);
+				break;
+		}
+		// Remove black listed words
+		if (xoops_trim(self::getModuleOption('metagen_blacklist')) != '') {
+			$metagen_blacklist = str_replace("\r", '', self::getModuleOption('metagen_blacklist'));
+			$metablack         = explode("\n", $metagen_blacklist);
+			array_walk($metablack, 'trim');
+			$keywords = array_diff($keywords, $metablack);
+		}
+
+		foreach ($keywords as $keyword) {
+			if (strlen($keyword) >= $limit && !is_numeric($keyword)) {
+				$tmp[] = $keyword;
+			}
+		}
+		$tmp = array_slice($tmp, 0, $keywordscount);
+		if (count($tmp) > 0) {
+			return implode(',', $tmp);
+		} else {
+			if (!isset($config_handler) || !is_object($config_handler)) {
+				$config_handler = xoops_getHandler('config');
+			}
+			$xoopsConfigMetaFooter =& $config_handler->getConfigsByCat(XOOPS_CONF_METAFOOTER);
+			if (isset($xoopsConfigMetaFooter['meta_keywords'])) {
+				return $xoopsConfigMetaFooter['meta_keywords'];
+			} else {
+				return '';
+			}
+		}
+	}
+
+	/**
+	 * Fonction chargée de gérer l'upload
+	 *
+	 * @param integer $indice L'indice du fichier à télécharger
+	 * @param string  $dstpath
+	 * @param null    $mimeTypes
+	 * @param null    $uploadMaxSize
+	 * @param null    $maxWidth
+	 * @param null    $maxHeight
+	 * @return mixed True si l'upload s'est bien déroulé sinon le message d'erreur correspondant
+	 */
+	public static function uploadFile($indice, $dstpath = XOOPS_UPLOAD_PATH, $mimeTypes = null, $uploadMaxSize = null, $maxWidth = null, $maxHeight = null)
+	{
+		require_once XOOPS_ROOT_PATH . '/class/uploader.php';
+		global $destname;
+		if (isset($_POST['xoops_upload_file'])) {
+			require_once XOOPS_ROOT_PATH . '/class/uploader.php';
+			$fldname = '';
+			$fldname = $_FILES[$_POST['xoops_upload_file'][$indice]];
+			$fldname = get_magic_quotes_gpc() ? stripslashes($fldname['name']) : $fldname['name'];
+			if (xoops_trim($fldname != '')) {
+				$destname = self::createUploadName($dstpath, $fldname, true);
+				if ($mimeTypes === null) {
+					$permittedtypes = explode("\n", str_replace("\r", '', self::getModuleOption('mimetypes')));
+					array_walk($permittedtypes, 'trim');
+				} else {
+					$permittedtypes = $mimeTypes;
+				}
+				if ($uploadMaxSize === null) {
+					$uploadSize = self::getModuleOption('maxuploadsize');
+				} else {
+					$uploadSize = $uploadMaxSize;
+				}
+				$uploader = new XoopsMediaUploader($dstpath, $permittedtypes, $uploadSize, $maxWidth, $maxHeight);
+				//$uploader->allowUnknownTypes = true;
+				$uploader->setTargetFileName($destname);
+				if ($uploader->fetchMedia($_POST['xoops_upload_file'][$indice])) {
+					if ($uploader->upload()) {
+						return true;
+					} else {
+						return _ERRORS . ' ' . htmlentities($uploader->getErrors());
+					}
+				} else {
+					return htmlentities($uploader->getErrors());
+				}
+			} else {
+				return false;
+			}
+		} else {
+			return false;
+		}
+	}
+
+	/**
+	 * Resize a Picture to some given dimensions (using the wideImage library)
+	 *
+	 * @param string  $src_path      Picture's source
+	 * @param string  $dst_path      Picture's destination
+	 * @param integer $param_width   Maximum picture's width
+	 * @param integer $param_height  Maximum picture's height
+	 * @param boolean $keep_original Do we have to keep the original picture ?
+	 * @param string  $fit           Resize mode (see the wideImage library for more information)
+	 * @return bool
+	 */
+	public static function resizePicture($src_path, $dst_path, $param_width, $param_height, $keep_original = false, $fit = 'inside')
+	{
+		//        require_once self::MODULE_PATH . 'class/wideimage/WideImage.php';
+		$img    = WideImage::load($src_path);
+		$result = $img->resize($param_width, $param_height, $fit);
+		$result->saveToFile($dst_path, null);
+		if (!$keep_original) {
+			@unlink($src_path);
+		}
+
+		return true;
+	}
+
+	/**
+	 * Déclenchement d'une alerte Xoops suite à un évènement
+	 *
+	 * @param string       $category La catégorie de l'évènement
+	 * @param integer      $itemId   L'ID de l'élément (trop général pour être décris précisément)
+	 * @param unknown_type $event    L'évènement qui est déclencé
+	 * @param unknown_type $tags     Les variables à passer au template
+	 */
+	public static function notify($category, $itemId, $event, $tags)
+	{
+		$notification_handler = xoops_getHandler('notification');
+		$tags['X_MODULE_URL'] = REFERENCES_URL;
+		$notification_handler->triggerEvent($category, $itemId, $event, $tags);
+	}
+
+	/**
+	 * Ajoute des jours à une date et retourne la nouvelle date au format Date de Mysql
+	 *
+	 * @param int     $duration
+	 * @param integer $startingDate Date de départ (timestamp)
+	 * @return bool|string
+	 * @internal param int $durations Durée en jours
+	 */
+	public static function addDaysToDate($duration = 1, $startingDate = 0)
+	{
+		if ($startingDate == 0) {
+			$startingDate = time();
+		}
+		$endingDate = $startingDate + ($duration * 86400);
+
+		return date('Y-m-d', $endingDate);
+	}
+
+	/**
+	 * Retourne un breadcrumb en fonction des paramètres passés et en partant (d'office) de la racine du module
+	 *
+	 * @param array  $path  Le chemin complet (excepté la racine) du breadcrumb sous la forme clé=url valeur=titre
+	 * @param string $raquo Le séparateur par défaut à utiliser
+	 * @return string le breadcrumb
+	 */
+	public static function breadcrumb($path, $raquo = ' &raquo; ')
+	{
+		$breadcrumb        = '';
+		$workingBreadcrumb = array();
+		if (is_array($path)) {
+			$moduleName          = self::getModuleName();
+			$workingBreadcrumb[] = "<a href='" . REFERENCES_URL . "' title='" . self::makeHrefTitle($moduleName) . "'>" . $moduleName . '</a>';
+			foreach ($path as $url => $title) {
+				$workingBreadcrumb[] = "<a href='" . $url . "'>" . $title . '</a>';
+			}
+			$cnt = count($workingBreadcrumb);
+			for ($i = 0; $i < $cnt; ++$i) {
+				if ($i == $cnt - 1) {
+					$workingBreadcrumb[$i] = strip_tags($workingBreadcrumb[$i]);
+				}
+			}
+			$breadcrumb = implode($raquo, $workingBreadcrumb);
+		}
+
+		return $breadcrumb;
+	}
+
+	public static function close_tags($string)
+	{
+		// match opened tags
+		if (preg_match_all('/<([a-z\:\-]+)[^\/]>/', $string, $start_tags)) {
+			$start_tags = $start_tags[1];
+
+			// match closed tags
+			if (preg_match_all('/<\/([a-z]+)>/', $string, $end_tags)) {
+				$complete_tags = array();
+				$end_tags      = $end_tags[1];
+
+				foreach ($start_tags as $key => $val) {
+					$posb = array_search($val, $end_tags);
+					if (is_int($posb)) {
+						unset($end_tags[$posb]);
+					} else {
+						$complete_tags[] = $val;
+					}
+				}
+			} else {
+				$complete_tags = $start_tags;
+			}
+
+			$complete_tags = array_reverse($complete_tags);
+			for ($i = 0; $i < count($complete_tags); ++$i) {
+				$string .= '</' . $complete_tags[$i] . '>';
+			}
+		}
+
+		return $string;
+	}
+
+	public static function truncate_tagsafe($string, $length = 80, $etc = '...', $break_words = false)
+	{
+		if ($length == 0) {
+			return '';
+		}
+
+		if (strlen($string) > $length) {
+			$length -= strlen($etc);
+			if (!$break_words) {
+				$string = preg_replace('/\s+?(\S+)?$/', '', substr($string, 0, $length + 1));
+				$string = preg_replace('/<[^>]*$/', '', $string);
+				$string = self::close_tags($string);
+			}
+
+			return $string . $etc;
+		} else {
+			return $string;
+		}
+	}
+
+	/**
+	 * Create an infotip
+	 * @param $text
+	 * @return string
+	 */
+	public static function makeInfotips($text)
+	{
+		$ret      = '';
+		$infotips = self::getModuleOption('infotips');
+		if ($infotips > 0) {
+			$myts = MyTextSanitizer::getInstance();
+			$ret  = $myts->htmlSpecialChars(substr(strip_tags($text), 0, $infotips));
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * Retourne le type Mime d'un fichier en utilisant d'abord finfo puis mime_content
+	 *
+	 * @param string $filename Le fichier (avec son chemin d'accès complet) dont on veut connaître le type mime
+	 * @return string
+	 */
+	public static function getMimeType($filename)
+	{
+		if (function_exists('finfo_open')) {
+			$pathToMagic = REFERENCES_PATH . 'mime/magic';
+			$finfo       = new finfo(FILEINFO_MIME, $pathToMagic);
+			$mimetype    = $finfo->file($filename);
+			finfo_close($finfo);
+			unset($finfo);
+
+			return $mimetype;
+		} else {
+			if (function_exists('mime_content_type')) {
+				return mime_content_type($filename);
+			} else {
+				return '';
+			}
+		}
+	}
+
+	/**
+	 * Retourne une liste d'objets XoopsUsers à partir d'une liste d'identifiants
+	 *
+	 * @param  array $xoopsUsersIDs La liste des ID
+	 * @return array Les objets XoopsUsers
+	 */
+	public static function getUsersFromIds($xoopsUsersIDs)
+	{
+		$users = array();
+		if (is_array($xoopsUsersIDs) && count($xoopsUsersIDs) > 0) {
+			$xoopsUsersIDs = array_unique($xoopsUsersIDs);
+			sort($xoopsUsersIDs);
+			if (count($xoopsUsersIDs) > 0) {
+				$member_handler = xoops_getHandler('user');
+				$criteria       = new Criteria('uid', '(' . implode(',', $xoopsUsersIDs) . ')', 'IN');
+				$criteria->setSort('uid');
+				$users = $member_handler->getObjects($criteria, true);
+			}
+		}
+
+		return $users;
+	}
+
+	/**
+	 * Retourne l'ID de l'utilisateur courant (s'il est connecté)
+	 * @return integer L'uid ou 0
+	 */
+	public static function getCurrentUserID()
+	{
+		global $xoopsUser;
+		$uid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
+
+		return $uid;
+	}
+
+	/**
+	 * Retourne la liste des groupes de l'utilisateur courant (avec cache)
+	 * @param int $uid
+	 * @return array Les ID des groupes auquel l'utilisateur courant appartient
+	 */
+	public static function getMemberGroups($uid = 0)
+	{
+		static $buffer = array();
+		if ($uid == 0) {
+			$uid = self::getCurrentUserID();
+		}
+
+		if (is_array($buffer) && count($buffer) > 0 && isset($buffer[$uid])) {
+			return $buffer[$uid];
+		} else {
+			if ($uid > 0) {
+				$member_handler = xoops_getHandler('member');
+				$buffer[$uid]   = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
+			} else {
+				$buffer[$uid] = array(XOOPS_GROUP_ANONYMOUS);
+			}
+		}
+
+		return $buffer[$uid];
+	}
+
+	/**
+	 * Indique si l'utilisateur courant fait partie d'une groupe donné (avec gestion de cache)
+	 *
+	 * @param integer $group Groupe recherché
+	 * @param int     $uid
+	 * @return bool vrai si l'utilisateur fait partie du groupe, faux sinon
+	 */
+	public static function isMemberOfGroup($group = 0, $uid = 0)
+	{
+		static $buffer = array();
+		$retval = false;
+		if ($uid == 0) {
+			$uid = self::getCurrentUserID();
+		}
+		if (is_array($buffer) && array_key_exists($group, $buffer)) {
+			$retval = $buffer[$group];
+		} else {
+			$member_handler = xoops_getHandler('member');
+			$groups         = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
+			$retval         = in_array($group, $groups);
+			$buffer[$group] = $retval;
+		}
+
+		return $retval;
+	}
+
+	/**
+	 * Indique si un utilisateur fait partie de plusieurs groupes
+	 * La fonction renvoie vrai dès qu'on trouve que le membre fait partir d'un des groupes
+	 * @param array    $groups La liste des groupes à vérifier
+	 * @param  integer $uid    L'ID de l'utilisateur
+	 * @return boolean
+	 */
+	public static function isMemberOfGroups($groups, $uid = 0)
+	{
+		if (count($groups) == 0) {
+			return false;
+		}
+		if ($uid == 0) {
+			$uid = self::getCurrentUserID();
+		}
+		foreach ($groups as $groupId) {
+			if (self::isMemberOfGroup($groupId, $uid)) {
+				return true;
+			}
+		}
+
+		return false;
+	}
+
+	/**
+	 * Retourne le nombre total de groupes (y compris les anonymes)
+	 */
+	public static function getGroupsCount()
+	{
+		static $cache = -1;
+		if ($cache == -1) {
+			global $xoopsDB;
+			$sql    = 'SELECT COUNT(*) FROM ' . $xoopsDB->prefix('groups');
+			$result = $xoopsDB->query($sql);
+			if (!$result) {
+				return false;
+			}
+			list($cache) = $xoopsDB->fetchRow($result);
+		}
+
+		return $cache;
+	}
+
+	/**
+	 * Fonction chargée de vérifier qu'un répertoire existe, qu'on peut écrire dedans et création d'un fichier index.html
+	 *
+	 * @param string $folder Le chemin complet du répertoire à vérifier
+	 * @return void
+	 */
+	public static function prepareFolder($folder)
+	{
+		if (!is_dir($folder)) {
+			mkdir($folder, 0777);
+			file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>');
+		} else {
+			if (!is_writable($folder)) {
+				chmod($folder, 0777);
+			}
+		}
+	}
+
+	/**
+	 * Load a language file
+	 *
+	 * @param string $languageFile     The required language file
+	 * @param string $defaultExtension Default extension to use
+	 */
+	public static function loadLanguageFile($languageFile, $defaultExtension = '.php')
+	{
+		global $xoopsConfig;
+		$root = self::MODULE_PATH;
+		if (strstr($languageFile, $defaultExtension) === false) {
+			$languageFile .= $defaultExtension;
+		}
+		if (file_exists($root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile)) {
+			require_once $root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile;
+		} else {    // Fallback
+			require_once $root . 'language' . DIRECTORY_SEPARATOR . 'english' . DIRECTORY_SEPARATOR . $languageFile;
+		}
+	}
+
+	/**
+	 * Création d'une vignette en tenant compte des options du module concernant le mode de création des vignettes
+	 *
+	 * @param  string  $src_path
+	 * @param  string  $dst_path
+	 * @param  integer $param_width
+	 * @param  integer $param_height
+	 * @param  boolean $keep_original
+	 * @param string   $fit Utilisé uniquement pour la méthode 0 (redimensionnement)
+	 * @return boolean
+	 */
+	public static function createThumb($src_path, $dst_path, $param_width, $param_height, $keep_original = false, $fit = 'inside')
+	{
+		//        require_once self::MODULE_PATH . 'class/wideimage/WideImage.php';
+		$resize = true;
+		// On commence par vérifier que l'image originale n'est pas plus petite que les dimensions demandées auquel cas il n'y a rien à faire
+		$pictureDimensions = getimagesize($src_path);
+		if (is_array($pictureDimensions)) {
+			$pictureWidth  = $pictureDimensions[0];
+			$pictureHeight = $pictureDimensions[1];
+			if ($pictureWidth < $param_width && $pictureHeight < $param_height) {
+				$resize = false;
+			}
+		}
+		$img = WideImage::load($src_path);
+		if ($resize) { // L'image est suffisament grande pour être réduite
+			$thumbMethod = 0;
+			if ($thumbMethod == 0) { // Redimensionnement de l'image
+				$result = $img->resize($param_width, $param_height, $fit);
+			} else { // Récupération d'une partie de l'image depuis le centre
+				// Calcul de left et top
+				$left = $top = 0;
+				if (is_array($pictureDimensions)) {
+					if ($pictureWidth > $param_width) {
+						$left = (int)(($pictureWidth / 2) - ($param_width / 2));
+					}
+					if ($pictureHeight > $param_height) {
+						$top = (int)(($pictureHeight / 2) - ($param_height / 2));
+					}
+				}
+				$result = $img->crop($left, $top, $param_width, $param_height);
+			}
+			$result->saveToFile($dst_path, null);
+		} else {
+			if ($src_path != $dst_path) {
+				@copy($src_path, $dst_path);
+			}
+		}
+		if (!$keep_original) {
+			@unlink($src_path);
+		}
+
+		return true;
+	}
+
+	/**
+	 * Create the <option> of an html select
+	 *
+	 * @param  array $array   Array of index and labels
+	 * @param  mixed $default the default value
+	 * @param bool   $withNull
+	 * @return string
+	 */
+	private static function htmlSelectOptions($array, $default = 0, $withNull = true)
+	{
+		$ret      = array();
+		$selected = '';
+		if ($withNull) {
+			if (!is_array($default)) {
+				if ($default === 0) {
+					$selected = " selected = 'selected'";
+				}
+			} else {
+				if (in_array(0, $default)) {
+					$selected = " selected = 'selected'";
+				}
+			}
+			$ret[] = '<option value=0' . $selected . '>---</option>';
+		}
+
+		foreach ($array as $index => $label) {
+			$selected = '';
+			if (!is_array($default)) {
+				if ($index == $default) {
+					$selected = " selected = 'selected'";
+				}
+			} else {
+				if (in_array($index, $default)) {
+					$selected = " selected = 'selected'";
+				}
+			}
+			$ret[] = "<option value=\"" . $index . "\"" . $selected . '>' . $label . '</option>';
+		}
+
+		return implode("\n", $ret);
+	}
+
+	/**
+	 * Creates an html select an returns its code
+	 *
+	 * @param  string  $selectName Select's name
+	 * @param  array   $array      Key = value of each option, value = label of each option
+	 * @param  mixed   $default    Default's value
+	 * @param  boolean $withNull   Do we want a null option
+	 * @param  string  $style      Is there a style to apply ?
+	 * @param  boolean $multiple   Can we select multiple elements ?
+	 * @param  integer $size       Size of the selectbox, only used with multiple selectboxes
+	 * @param string   $extra
+	 * @return string
+	 */
+	public static function htmlSelect($selectName, $array, $default, $withNull = true, $style = '', $multiple = false, $size = 1, $extra = '')
+	{
+		$ret = '';
+		$ret .= "<select name='" . $selectName . "' id='" . $selectName . "'";
+		if (xoops_trim($style) != '') {
+			$ret .= " style='" . $style . "' ";
+		}
+		if (xoops_trim($multiple) != '') {
+			$ret .= " multiple = 'multiple' size='" . $size . "' ";
+		}
+		$ret .= $extra . ">\n";
+		$ret .= self::htmlSelectOptions($array, $default, $withNull);
+		$ret .= "</select>\n";
+
+		return $ret;
+	}
+
+	/**
+	 * Verify that a mysql table exists
+	 * @param $tablename
+	 * @return bool
+	 */
+	public static function tableExists($tablename)
+	{
+		global $xoopsDB;
+		$result = $xoopsDB->queryF("SHOW TABLES LIKE '$tablename'");
+
+		return ($xoopsDB->getRowsNum($result) > 0);
+	}
+
+	/**
+	 * Verify that a field exists inside a mysql table
+	 * @param $fieldname
+	 * @param $table
+	 * @return bool
+	 */
+	public static function fieldExists($fieldname, $table)
+	{
+		global $xoopsDB;
+		$result = $xoopsDB->queryF("SHOW COLUMNS FROM $table LIKE '$fieldname'");
+
+		return ($xoopsDB->getRowsNum($result) > 0);
+	}
+
+	/**
+	 * Retourne la définition d'un champ
+	 *
+	 * @param  string $fieldname
+	 * @param  string $table
+	 * @return array
+	 */
+	public static function getFieldDefinition($fieldname, $table)
+	{
+		global $xoopsDB;
+		$result = $xoopsDB->queryF("SHOW COLUMNS FROM $table LIKE '$fieldname'");
+		if ($result) {
+			return $xoopsDB->fetchArray($result);
+		}
+
+		return '';
+	}
+
+	/**
+	 * Add a field to a mysql table
+	 * @param $field
+	 * @param $table
+	 * @return resource
+	 */
+	public static function addField($field, $table)
+	{
+		global $xoopsDB;
+		$result = $xoopsDB->queryF("ALTER TABLE $table ADD $field;");
+
+		return $result;
+	}
+
+	/**
+	 * Maintenance des tables du module et de son cache de requêtes
+	 *
+	 * @return void
+	 */
+	public static function maintainTablesCache()
+	{
+		global $xoopsDB;
+		define('REFERENCES_MAINTAIN', true);
+		require self::MODULE_PATH . 'xoops_version.php';
+		$tables = array();
+		foreach ($modversion['tables'] as $table) {
+			$tables[] = $xoopsDB->prefix($table);
+		}
+		if (count($tables) > 0) {
+			$list = implode(',', $tables);
+			$xoopsDB->queryF('CHECK TABLE ' . $list);
+			$xoopsDB->queryF('ANALYZE TABLE ' . $list);
+			$xoopsDB->queryF('OPTIMIZE TABLE ' . $list);
+		}
+		self::updateCache();
+		$handlers = references_handler::getInstance();
+		$handlers->h_references_articles->forceCacheClean();
+	}
+
+	/**
+	 * Indique si le module Tag existe et est activé
+	 *
+	 * @return boolean
+	 * @credit: smartfactory
+	 */
+	public static function tagModuleExists()
+	{
+		static $moduleExistsAndIsActive;
+		if (!isset($moduleExistsAndIsActive)) {
+			$modules_handler = xoops_getHandler('module');
+			$tagModule       = $modules_handler->getByDirName('tag');
+			if (!$tagModule) {
+				$moduleExistsAndIsActive = false;
+			} else {
+				$moduleExistsAndIsActive = $tagModule->getVar('isactive') == 1;
+			}
+		}
+
+		return $moduleExistsAndIsActive;
+	}
 }

Spacing +198 added lines, -198 removed lines

@@ -107,7 +107,7 @@ 
     {
         $x23 = false;
         $xv  = str_replace('XOOPS ', '', XOOPS_VERSION);
-        if ((int)substr($xv, 2, 1) >= 3) {
+        if ((int) substr($xv, 2, 1) >= 3) {
             $x23 = true;
         }
 
@@ -147,15 +147,15 @@ 
         // Only for Xoops 2.0.x
         switch ($editor_option) {
             case 'fckeditor':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/fckeditor/formfckeditor.php');
+                if (is_readable(XOOPS_ROOT_PATH.'/class/fckeditor/formfckeditor.php')) {
+                    require_once(XOOPS_ROOT_PATH.'/class/fckeditor/formfckeditor.php');
                     $editor = new XoopsFormFckeditor($caption, $name, $value);
                 }
                 break;
 
             case 'htmlarea':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/htmlarea/formhtmlarea.php');
+                if (is_readable(XOOPS_ROOT_PATH.'/class/htmlarea/formhtmlarea.php')) {
+                    require_once(XOOPS_ROOT_PATH.'/class/htmlarea/formhtmlarea.php');
                     $editor = new XoopsFormHtmlarea($caption, $name, $value);
                 }
                 break;
@@ -170,15 +170,15 @@ 
 
             case 'tinyeditor':
             case 'tinymce':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php')) {
-                    require_once XOOPS_ROOT_PATH . '/class/xoopseditor/tinyeditor/formtinyeditortextarea.php';
+                if (is_readable(XOOPS_ROOT_PATH.'/class/xoopseditor/tinyeditor/formtinyeditortextarea.php')) {
+                    require_once XOOPS_ROOT_PATH.'/class/xoopseditor/tinyeditor/formtinyeditortextarea.php';
                     $editor = new XoopsFormTinyeditorTextArea(array('caption' => $caption, 'name' => $name, 'value' => $value, 'width' => '100%', 'height' => '400px'));
                 }
                 break;
 
             case 'koivi':
-                if (is_readable(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php')) {
-                    require_once(XOOPS_ROOT_PATH . '/class/wysiwyg/formwysiwygtextarea.php');
+                if (is_readable(XOOPS_ROOT_PATH.'/class/wysiwyg/formwysiwygtextarea.php')) {
+                    require_once(XOOPS_ROOT_PATH.'/class/wysiwyg/formwysiwygtextarea.php');
                     $editor = new XoopsFormWysiwygTextArea($caption, $name, $value, $width, $height, '');
                 }
                 break;
@@ -200,9 +200,9 @@ 
     public static function javascriptLinkConfirm($message, $form = false)
     {
         if (!$form) {
-            return "onclick=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
+            return "onclick=\"javascript:return confirm('".str_replace("'", ' ', $message)."')\"";
         } else {
-            return "onSubmit=\"javascript:return confirm('" . str_replace("'", ' ', $message) . "')\"";
+            return "onSubmit=\"javascript:return confirm('".str_replace("'", ' ', $message)."')\"";
         }
     }
 
@@ -282,7 +282,7 @@ 
     public static function sendEmailFromTpl($tplName, $recipients, $subject, $variables)
     {
         global $xoopsConfig;
-        require_once XOOPS_ROOT_PATH . '/class/xoopsmailer.php';
+        require_once XOOPS_ROOT_PATH.'/class/xoopsmailer.php';
         if (!is_array($recipients)) {
             if (trim($recipients) == '') {
                 return false;
@@ -295,11 +295,11 @@ 
         if (function_exists('xoops_getMailer')) {
             $xoopsMailer = xoops_getMailer();
         } else {
-            $xoopsMailer =& getMailer();
+            $xoopsMailer = & getMailer();
         }
 
         $xoopsMailer->useMail();
-        $xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH . '/modules/' . self::MODULE_NAME . '/language/' . $xoopsConfig['language'] . '/mail_template');
+        $xoopsMailer->setTemplateDir(XOOPS_ROOT_PATH.'/modules/'.self::MODULE_NAME.'/language/'.$xoopsConfig['language'].'/mail_template');
         $xoopsMailer->setTemplate($tplName);
         $xoopsMailer->setToEmails($recipients);
         // TODO: Change !
@@ -311,7 +311,7 @@ 
         }
         $res = $xoopsMailer->send();
         unset($xoopsMailer);
-        $filename = XOOPS_UPLOAD_PATH . '/logmail_' . self::MODULE_NAME . '.php';
+        $filename = XOOPS_UPLOAD_PATH.'/logmail_'.self::MODULE_NAME.'.php';
         if (!file_exists($filename)) {
             $fp = @fopen($filename, 'a');
             if ($fp) {
@@ -322,16 +322,16 @@ 
         $fp = @fopen($filename, 'a');
 
         if ($fp) {
-            fwrite($fp, str_repeat('-', 120) . "\n");
-            fwrite($fp, date('d/m/Y H:i:s') . "\n");
-            fwrite($fp, 'Template name : ' . $tplName . "\n");
-            fwrite($fp, 'Email subject : ' . $subject . "\n");
+            fwrite($fp, str_repeat('-', 120)."\n");
+            fwrite($fp, date('d/m/Y H:i:s')."\n");
+            fwrite($fp, 'Template name : '.$tplName."\n");
+            fwrite($fp, 'Email subject : '.$subject."\n");
             if (is_array($recipients)) {
-                fwrite($fp, 'Recipient(s) : ' . implode(',', $recipients) . "\n");
+                fwrite($fp, 'Recipient(s) : '.implode(',', $recipients)."\n");
             } else {
-                fwrite($fp, 'Recipient(s) : ' . $recipients . "\n");
+                fwrite($fp, 'Recipient(s) : '.$recipients."\n");
             }
-            fwrite($fp, 'Transmited variables : ' . implode(',', $variables) . "\n");
+            fwrite($fp, 'Transmited variables : '.implode(',', $variables)."\n");
             fclose($fp);
         }
 
@@ -346,17 +346,17 @@ 
         global $xoopsModule;
         $folder  = $xoopsModule->getVar('dirname');
         $tpllist = array();
-        require_once XOOPS_ROOT_PATH . '/class/xoopsblock.php';
-        require_once XOOPS_ROOT_PATH . '/class/template.php';
+        require_once XOOPS_ROOT_PATH.'/class/xoopsblock.php';
+        require_once XOOPS_ROOT_PATH.'/class/template.php';
         $tplfile_handler = xoops_getHandler('tplfile');
         $tpllist         = $tplfile_handler->find(null, null, null, $folder);
-        xoops_template_clear_module_cache($xoopsModule->getVar('mid'));            // Clear module's blocks cache
+        xoops_template_clear_module_cache($xoopsModule->getVar('mid')); // Clear module's blocks cache
 
         foreach ($tpllist as $onetemplate) {    // Remove cache for each page.
             if ($onetemplate->getVar('tpl_type') === 'module') {
                 //  Note, I've been testing all the other methods (like the one of Smarty) and none of them run, that's why I have used this code
                 $files_del = array();
-                $files_del = glob(XOOPS_CACHE_PATH . '/*' . $onetemplate->getVar('tpl_file') . '*');
+                $files_del = glob(XOOPS_CACHE_PATH.'/*'.$onetemplate->getVar('tpl_file').'*');
                 if (count($files_del) > 0 && is_array($files_del)) {
                     foreach ($files_del as $one_file) {
                         if (is_file($one_file)) {
@@ -392,7 +392,7 @@ 
         if (!isset($mymodule)) {
             global $xoopsModule;
             if (isset($xoopsModule) && is_object($xoopsModule) && $xoopsModule->getVar('dirname') == REFERENCES_DIRNAME) {
-                $mymodule =& $xoopsModule;
+                $mymodule = & $xoopsModule;
             } else {
                 $hModule  = xoops_getHandler('module');
                 $mymodule = $hModule->getByDirname(REFERENCES_DIRNAME);
@@ -510,12 +510,12 @@ 
      */
     public static function getCurrentSQLDate()
     {
-        return date('Y-m-d');    // 2007-05-02
+        return date('Y-m-d'); // 2007-05-02
     }
 
     public static function getCurrentSQLDateTime()
     {
-        return date('Y-m-d H:i:s');    // 2007-05-02
+        return date('Y-m-d H:i:s'); // 2007-05-02
     }
 
     /**
@@ -542,7 +542,7 @@ 
      */
     public static function timestampToMysqlDate($timestamp)
     {
-        return date('Y-m-d', (int)$timestamp);
+        return date('Y-m-d', (int) $timestamp);
     }
 
     /**
@@ -580,7 +580,7 @@ 
         }
         if (strpos(strtolower(XOOPS_VERSION), 'legacy') === false) {
             $xv = xoops_trim(str_replace('XOOPS ', '', XOOPS_VERSION));
-            if ((int)substr($xv, 4, 2) >= 17) {
+            if ((int) substr($xv, 4, 2) >= 17) {
                 return false;
             }
         }
@@ -643,25 +643,25 @@ 
         }
         $ext  = basename($fileName);
         $ext  = explode('.', $ext);
-        $ext  = '.' . $ext[count($ext) - 1];
+        $ext  = '.'.$ext[count($ext) - 1];
         $true = true;
         while ($true) {
             $ipbits = explode('.', $_SERVER['REMOTE_ADDR']);
             list($usec, $sec) = explode(' ', microtime());
-            $usec = (integer)($usec * 65536);
-            $sec  = ((integer)$sec) & 0xFFFF;
+            $usec = (integer) ($usec * 65536);
+            $sec  = ((integer) $sec)&0xFFFF;
 
             if ($trimName) {
-                $uid = sprintf('%06x%04x%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
+                $uid = sprintf('%06x%04x%04x', ($ipbits[0] << 24)|($ipbits[1] << 16)|($ipbits[2] << 8)|$ipbits[3], $sec, $usec);
             } else {
-                $uid = sprintf('%08x-%04x-%04x', ($ipbits[0] << 24) | ($ipbits[1] << 16) | ($ipbits[2] << 8) | $ipbits[3], $sec, $usec);
+                $uid = sprintf('%08x-%04x-%04x', ($ipbits[0] << 24)|($ipbits[1] << 16)|($ipbits[2] << 8)|$ipbits[3], $sec, $usec);
             }
-            if (!file_exists($workingfolder . $uid . $ext)) {
+            if (!file_exists($workingfolder.$uid.$ext)) {
                 $true = false;
             }
         }
 
-        return $uid . $ext;
+        return $uid.$ext;
     }
 
     /**
@@ -676,135 +676,135 @@ 
         $chaine = html_entity_decode($chaine);
 
         for ($i = 0; $i <= 255; ++$i) {
-            $search[]  = '&#' . $i . ';';
+            $search[]  = '&#'.$i.';';
             $replace[] = chr($i);
         }
-        $replace[]='...'; $search[]='…';
-        $replace[]="'"; $search[]='‘';
-        $replace[]="'"; $search[]= '’';
-        $replace[]='-'; $search[] = '&bull;';   // $replace[] = '•';
-        $replace[]='—'; $search[]='&mdash;';
-        $replace[]='-'; $search[]='&ndash;';
-        $replace[]='-'; $search[]='&shy;';
-        $replace[]='"'; $search[]='&quot;';
-        $replace[]='&'; $search[]='&amp;';
-        $replace[]='ˆ'; $search[]='&circ;';
-        $replace[]='¡'; $search[]='&iexcl;';
-        $replace[]='¦'; $search[]='&brvbar;';
-        $replace[]='¨'; $search[]='&uml;';
-        $replace[]='¯'; $search[]='&macr;';
-        $replace[]='´'; $search[]='&acute;';
-        $replace[]='¸'; $search[]='&cedil;';
-        $replace[]='¿'; $search[]='&iquest;';
-        $replace[]='˜'; $search[]='&tilde;';
-        $replace[]="'"; $search[]='&lsquo;';    // $replace[]='‘';
-        $replace[]="'"; $search[]='&rsquo;';    // $replace[]='’';
-        $replace[]='‚'; $search[]='&sbquo;';
-        $replace[]="'"; $search[]='&ldquo;';    // $replace[]='“';
-        $replace[]="'"; $search[]='&rdquo;';    // $replace[]='”';
-        $replace[]='„'; $search[]='&bdquo;';
-        $replace[]='‹'; $search[]='&lsaquo;';
-        $replace[]='›'; $search[]='&rsaquo;';
-        $replace[]='<'; $search[]='&lt;';
-        $replace[]='>'; $search[]='&gt;';
-        $replace[]='±'; $search[]='&plusmn;';
-        $replace[]='«'; $search[]='&laquo;';
-        $replace[]='»'; $search[]='&raquo;';
-        $replace[]='×'; $search[]='&times;';
-        $replace[]='÷'; $search[]='&divide;';
-        $replace[]='¢'; $search[]='&cent;';
-        $replace[]='£'; $search[]='&pound;';
-        $replace[]='¤'; $search[]='&curren;';
-        $replace[]='¥'; $search[]='&yen;';
-        $replace[]='§'; $search[]='&sect;';
-        $replace[]='©'; $search[]='&copy;';
-        $replace[]='¬'; $search[]='&not;';
-        $replace[]='®'; $search[]='&reg;';
-        $replace[]='°'; $search[]='&deg;';
-        $replace[]='µ'; $search[]='&micro;';
-        $replace[]='¶'; $search[]='&para;';
-        $replace[]='·'; $search[]='&middot;';
-        $replace[]='†'; $search[]='&dagger;';
-        $replace[]='‡'; $search[]='&Dagger;';
-        $replace[]='‰'; $search[]='&permil;';
-        $replace[]='Euro'; $search[]='&euro;';      // $replace[]='€'
-        $replace[]='¼'; $search[]='&frac14;';
-        $replace[]='½'; $search[]='&frac12;';
-        $replace[]='¾'; $search[]='&frac34;';
-        $replace[]='¹'; $search[]='&sup1;';
-        $replace[]='²'; $search[]='&sup2;';
-        $replace[]='³'; $search[]='&sup3;';
-        $replace[]='á'; $search[]='&aacute;';
-        $replace[]='Á'; $search[]='&Aacute;';
-        $replace[]='â'; $search[]='&acirc;';
-        $replace[]='Â'; $search[]='&Acirc;';
-        $replace[]='à'; $search[]='&agrave;';
-        $replace[]='À'; $search[]='&Agrave;';
-        $replace[]='å'; $search[]='&aring;';
-        $replace[]='Å'; $search[]='&Aring;';
-        $replace[]='ã'; $search[]='&atilde;';
-        $replace[]='Ã'; $search[]='&Atilde;';
-        $replace[]='ä'; $search[]='&auml;';
-        $replace[]='Ä'; $search[]='&Auml;';
-        $replace[]='ª'; $search[]='&ordf;';
-        $replace[]='æ'; $search[]='&aelig;';
-        $replace[]='Æ'; $search[]='&AElig;';
-        $replace[]='ç'; $search[]='&ccedil;';
-        $replace[]='Ç'; $search[]='&Ccedil;';
-        $replace[]='ð'; $search[]='&eth;';
-        $replace[]='Ð'; $search[]='&ETH;';
-        $replace[]='é'; $search[]='&eacute;';
-        $replace[]='É'; $search[]='&Eacute;';
-        $replace[]='ê'; $search[]='&ecirc;';
-        $replace[]='Ê'; $search[]='&Ecirc;';
-        $replace[]='è'; $search[]='&egrave;';
-        $replace[]='È'; $search[]='&Egrave;';
-        $replace[]='ë'; $search[]='&euml;';
-        $replace[]='Ë'; $search[]='&Euml;';
-        $replace[]='ƒ'; $search[]='&fnof;';
-        $replace[]='í'; $search[]='&iacute;';
-        $replace[]='Í'; $search[]='&Iacute;';
-        $replace[]='î'; $search[]='&icirc;';
-        $replace[]='Î'; $search[]='&Icirc;';
-        $replace[]='ì'; $search[]='&igrave;';
-        $replace[]='Ì'; $search[]='&Igrave;';
-        $replace[]='ï'; $search[]='&iuml;';
-        $replace[]='Ï'; $search[]='&Iuml;';
-        $replace[]='ñ'; $search[]='&ntilde;';
-        $replace[]='Ñ'; $search[]='&Ntilde;';
-        $replace[]='ó'; $search[]='&oacute;';
-        $replace[]='Ó'; $search[]='&Oacute;';
-        $replace[]='ô'; $search[]='&ocirc;';
-        $replace[]='Ô'; $search[]='&Ocirc;';
-        $replace[]='ò'; $search[]='&ograve;';
-        $replace[]='Ò'; $search[]='&Ograve;';
-        $replace[]='º'; $search[]='&ordm;';
-        $replace[]='ø'; $search[]='&oslash;';
-        $replace[]='Ø'; $search[]='&Oslash;';
-        $replace[]='õ'; $search[]='&otilde;';
-        $replace[]='Õ'; $search[]='&Otilde;';
-        $replace[]='ö'; $search[]='&ouml;';
-        $replace[]='Ö'; $search[]='&Ouml;';
-        $replace[]='œ'; $search[]='&oelig;';
-        $replace[]='Œ'; $search[]='&OElig;';
-        $replace[]='š'; $search[]='&scaron;';
-        $replace[]='Š'; $search[]='&Scaron;';
-        $replace[]='ß'; $search[]='&szlig;';
-        $replace[]='þ'; $search[]='&thorn;';
-        $replace[]='Þ'; $search[]='&THORN;';
-        $replace[]='ú'; $search[]='&uacute;';
-        $replace[]='Ú'; $search[]='&Uacute;';
-        $replace[]='û'; $search[]='&ucirc;';
-        $replace[]='Û'; $search[]='&Ucirc;';
-        $replace[]='ù'; $search[]='&ugrave;';
-        $replace[]='Ù'; $search[]='&Ugrave;';
-        $replace[]='ü'; $search[]='&uuml;';
-        $replace[]='Ü'; $search[]='&Uuml;';
-        $replace[]='ý'; $search[]='&yacute;';
-        $replace[]='Ý'; $search[]='&Yacute;';
-        $replace[]='ÿ'; $search[]='&yuml;';
-        $replace[]='Ÿ'; $search[]='&Yuml;';
-        $chaine    = str_replace($search, $replace, $chaine);
+        $replace[] = '...'; $search[] = '…';
+        $replace[] = "'"; $search[] = '‘';
+        $replace[] = "'"; $search[] = '’';
+        $replace[] = '-'; $search[] = '&bull;'; // $replace[] = '•';
+        $replace[] = '—'; $search[] = '&mdash;';
+        $replace[] = '-'; $search[] = '&ndash;';
+        $replace[] = '-'; $search[] = '&shy;';
+        $replace[] = '"'; $search[] = '&quot;';
+        $replace[] = '&'; $search[] = '&amp;';
+        $replace[] = 'ˆ'; $search[] = '&circ;';
+        $replace[] = '¡'; $search[] = '&iexcl;';
+        $replace[] = '¦'; $search[] = '&brvbar;';
+        $replace[] = '¨'; $search[] = '&uml;';
+        $replace[] = '¯'; $search[] = '&macr;';
+        $replace[] = '´'; $search[] = '&acute;';
+        $replace[] = '¸'; $search[] = '&cedil;';
+        $replace[] = '¿'; $search[] = '&iquest;';
+        $replace[] = '˜'; $search[] = '&tilde;';
+        $replace[] = "'"; $search[] = '&lsquo;'; // $replace[]='‘';
+        $replace[] = "'"; $search[] = '&rsquo;'; // $replace[]='’';
+        $replace[] = '‚'; $search[] = '&sbquo;';
+        $replace[] = "'"; $search[] = '&ldquo;'; // $replace[]='“';
+        $replace[] = "'"; $search[] = '&rdquo;'; // $replace[]='”';
+        $replace[] = '„'; $search[] = '&bdquo;';
+        $replace[] = '‹'; $search[] = '&lsaquo;';
+        $replace[] = '›'; $search[] = '&rsaquo;';
+        $replace[] = '<'; $search[] = '&lt;';
+        $replace[] = '>'; $search[] = '&gt;';
+        $replace[] = '±'; $search[] = '&plusmn;';
+        $replace[] = '«'; $search[] = '&laquo;';
+        $replace[] = '»'; $search[] = '&raquo;';
+        $replace[] = '×'; $search[] = '&times;';
+        $replace[] = '÷'; $search[] = '&divide;';
+        $replace[] = '¢'; $search[] = '&cent;';
+        $replace[] = '£'; $search[] = '&pound;';
+        $replace[] = '¤'; $search[] = '&curren;';
+        $replace[] = '¥'; $search[] = '&yen;';
+        $replace[] = '§'; $search[] = '&sect;';
+        $replace[] = '©'; $search[] = '&copy;';
+        $replace[] = '¬'; $search[] = '&not;';
+        $replace[] = '®'; $search[] = '&reg;';
+        $replace[] = '°'; $search[] = '&deg;';
+        $replace[] = 'µ'; $search[] = '&micro;';
+        $replace[] = '¶'; $search[] = '&para;';
+        $replace[] = '·'; $search[] = '&middot;';
+        $replace[] = '†'; $search[] = '&dagger;';
+        $replace[] = '‡'; $search[] = '&Dagger;';
+        $replace[] = '‰'; $search[] = '&permil;';
+        $replace[] = 'Euro'; $search[] = '&euro;'; // $replace[]='€'
+        $replace[] = '¼'; $search[] = '&frac14;';
+        $replace[] = '½'; $search[] = '&frac12;';
+        $replace[] = '¾'; $search[] = '&frac34;';
+        $replace[] = '¹'; $search[] = '&sup1;';
+        $replace[] = '²'; $search[] = '&sup2;';
+        $replace[] = '³'; $search[] = '&sup3;';
+        $replace[] = 'á'; $search[] = '&aacute;';
+        $replace[] = 'Á'; $search[] = '&Aacute;';
+        $replace[] = 'â'; $search[] = '&acirc;';
+        $replace[] = 'Â'; $search[] = '&Acirc;';
+        $replace[] = 'à'; $search[] = '&agrave;';
+        $replace[] = 'À'; $search[] = '&Agrave;';
+        $replace[] = 'å'; $search[] = '&aring;';
+        $replace[] = 'Å'; $search[] = '&Aring;';
+        $replace[] = 'ã'; $search[] = '&atilde;';
+        $replace[] = 'Ã'; $search[] = '&Atilde;';
+        $replace[] = 'ä'; $search[] = '&auml;';
+        $replace[] = 'Ä'; $search[] = '&Auml;';
+        $replace[] = 'ª'; $search[] = '&ordf;';
+        $replace[] = 'æ'; $search[] = '&aelig;';
+        $replace[] = 'Æ'; $search[] = '&AElig;';
+        $replace[] = 'ç'; $search[] = '&ccedil;';
+        $replace[] = 'Ç'; $search[] = '&Ccedil;';
+        $replace[] = 'ð'; $search[] = '&eth;';
+        $replace[] = 'Ð'; $search[] = '&ETH;';
+        $replace[] = 'é'; $search[] = '&eacute;';
+        $replace[] = 'É'; $search[] = '&Eacute;';
+        $replace[] = 'ê'; $search[] = '&ecirc;';
+        $replace[] = 'Ê'; $search[] = '&Ecirc;';
+        $replace[] = 'è'; $search[] = '&egrave;';
+        $replace[] = 'È'; $search[] = '&Egrave;';
+        $replace[] = 'ë'; $search[] = '&euml;';
+        $replace[] = 'Ë'; $search[] = '&Euml;';
+        $replace[] = 'ƒ'; $search[] = '&fnof;';
+        $replace[] = 'í'; $search[] = '&iacute;';
+        $replace[] = 'Í'; $search[] = '&Iacute;';
+        $replace[] = 'î'; $search[] = '&icirc;';
+        $replace[] = 'Î'; $search[] = '&Icirc;';
+        $replace[] = 'ì'; $search[] = '&igrave;';
+        $replace[] = 'Ì'; $search[] = '&Igrave;';
+        $replace[] = 'ï'; $search[] = '&iuml;';
+        $replace[] = 'Ï'; $search[] = '&Iuml;';
+        $replace[] = 'ñ'; $search[] = '&ntilde;';
+        $replace[] = 'Ñ'; $search[] = '&Ntilde;';
+        $replace[] = 'ó'; $search[] = '&oacute;';
+        $replace[] = 'Ó'; $search[] = '&Oacute;';
+        $replace[] = 'ô'; $search[] = '&ocirc;';
+        $replace[] = 'Ô'; $search[] = '&Ocirc;';
+        $replace[] = 'ò'; $search[] = '&ograve;';
+        $replace[] = 'Ò'; $search[] = '&Ograve;';
+        $replace[] = 'º'; $search[] = '&ordm;';
+        $replace[] = 'ø'; $search[] = '&oslash;';
+        $replace[] = 'Ø'; $search[] = '&Oslash;';
+        $replace[] = 'õ'; $search[] = '&otilde;';
+        $replace[] = 'Õ'; $search[] = '&Otilde;';
+        $replace[] = 'ö'; $search[] = '&ouml;';
+        $replace[] = 'Ö'; $search[] = '&Ouml;';
+        $replace[] = 'œ'; $search[] = '&oelig;';
+        $replace[] = 'Œ'; $search[] = '&OElig;';
+        $replace[] = 'š'; $search[] = '&scaron;';
+        $replace[] = 'Š'; $search[] = '&Scaron;';
+        $replace[] = 'ß'; $search[] = '&szlig;';
+        $replace[] = 'þ'; $search[] = '&thorn;';
+        $replace[] = 'Þ'; $search[] = '&THORN;';
+        $replace[] = 'ú'; $search[] = '&uacute;';
+        $replace[] = 'Ú'; $search[] = '&Uacute;';
+        $replace[] = 'û'; $search[] = '&ucirc;';
+        $replace[] = 'Û'; $search[] = '&Ucirc;';
+        $replace[] = 'ù'; $search[] = '&ugrave;';
+        $replace[] = 'Ù'; $search[] = '&Ugrave;';
+        $replace[] = 'ü'; $search[] = '&uuml;';
+        $replace[] = 'Ü'; $search[] = '&Uuml;';
+        $replace[] = 'ý'; $search[] = '&yacute;';
+        $replace[] = 'Ý'; $search[] = '&Yacute;';
+        $replace[] = 'ÿ'; $search[] = '&yuml;';
+        $replace[] = 'Ÿ'; $search[] = '&Yuml;';
+        $chaine = str_replace($search, $replace, $chaine);
 
         return $chaine;
     }
@@ -821,11 +821,11 @@ 
     {
         $s       = "ÀÁÂÃÄÅÒÓÔÕÖØÈÉÊËÇÌÍÎÏÙÚÛÜŸÑàáâãäåòóôõöøèéêëçìíîïùúûüÿñ '()";
         $r       = 'AAAAAAOOOOOOEEEECIIIIUUUUYNaaaaaaooooooeeeeciiiiuuuuyn----';
-        $content = self::unhtml($content);    // First, remove html entities
+        $content = self::unhtml($content); // First, remove html entities
         $content = strtr($content, $s, $r);
         $content = strip_tags($content);
         $content = strtolower($content);
-        $content = htmlentities($content);    // TODO: Vérifier
+        $content = htmlentities($content); // TODO: Vérifier
         $content = preg_replace('/&([a-zA-Z])(uml|acute|grave|circ|tilde);/', '$1', $content);
         $content = html_entity_decode($content);
         $content = eregi_replace('quot', ' ', $content);
@@ -840,7 +840,7 @@ 
         $keywords = '';
         foreach ($words as $word) {
             if (strlen($word) >= $urw) {
-                $keywords .= '-' . trim($word);
+                $keywords .= '-'.trim($word);
             }
         }
         if (!$keywords) {
@@ -875,7 +875,7 @@ 
             $limit = $_SESSION['references_keywords_limit'];
         } else {
             $config_handler                        = xoops_getHandler('config');
-            $xoopsConfigSearch                     =& $config_handler->getConfigsByCat(XOOPS_CONF_SEARCH);
+            $xoopsConfigSearch                     = & $config_handler->getConfigsByCat(XOOPS_CONF_SEARCH);
             $limit                                 = $xoopsConfigSearch['keyword_min'];
             $_SESSION['references_keywords_limit'] = $limit;
         }
@@ -923,7 +923,7 @@ 
             if (!isset($config_handler) || !is_object($config_handler)) {
                 $config_handler = xoops_getHandler('config');
             }
-            $xoopsConfigMetaFooter =& $config_handler->getConfigsByCat(XOOPS_CONF_METAFOOTER);
+            $xoopsConfigMetaFooter = & $config_handler->getConfigsByCat(XOOPS_CONF_METAFOOTER);
             if (isset($xoopsConfigMetaFooter['meta_keywords'])) {
                 return $xoopsConfigMetaFooter['meta_keywords'];
             } else {
@@ -945,10 +945,10 @@ 
      */
     public static function uploadFile($indice, $dstpath = XOOPS_UPLOAD_PATH, $mimeTypes = null, $uploadMaxSize = null, $maxWidth = null, $maxHeight = null)
     {
-        require_once XOOPS_ROOT_PATH . '/class/uploader.php';
+        require_once XOOPS_ROOT_PATH.'/class/uploader.php';
         global $destname;
         if (isset($_POST['xoops_upload_file'])) {
-            require_once XOOPS_ROOT_PATH . '/class/uploader.php';
+            require_once XOOPS_ROOT_PATH.'/class/uploader.php';
             $fldname = '';
             $fldname = $_FILES[$_POST['xoops_upload_file'][$indice]];
             $fldname = get_magic_quotes_gpc() ? stripslashes($fldname['name']) : $fldname['name'];
@@ -972,7 +972,7 @@ 
                     if ($uploader->upload()) {
                         return true;
                     } else {
-                        return _ERRORS . ' ' . htmlentities($uploader->getErrors());
+                        return _ERRORS.' '.htmlentities($uploader->getErrors());
                     }
                 } else {
                     return htmlentities($uploader->getErrors());
@@ -1055,9 +1055,9 @@ 
         $workingBreadcrumb = array();
         if (is_array($path)) {
             $moduleName          = self::getModuleName();
-            $workingBreadcrumb[] = "<a href='" . REFERENCES_URL . "' title='" . self::makeHrefTitle($moduleName) . "'>" . $moduleName . '</a>';
+            $workingBreadcrumb[] = "<a href='".REFERENCES_URL."' title='".self::makeHrefTitle($moduleName)."'>".$moduleName.'</a>';
             foreach ($path as $url => $title) {
-                $workingBreadcrumb[] = "<a href='" . $url . "'>" . $title . '</a>';
+                $workingBreadcrumb[] = "<a href='".$url."'>".$title.'</a>';
             }
             $cnt = count($workingBreadcrumb);
             for ($i = 0; $i < $cnt; ++$i) {
@@ -1096,7 +1096,7 @@ 
 
             $complete_tags = array_reverse($complete_tags);
             for ($i = 0; $i < count($complete_tags); ++$i) {
-                $string .= '</' . $complete_tags[$i] . '>';
+                $string .= '</'.$complete_tags[$i].'>';
             }
         }
 
@@ -1117,7 +1117,7 @@ 
                 $string = self::close_tags($string);
             }
 
-            return $string . $etc;
+            return $string.$etc;
         } else {
             return $string;
         }
@@ -1149,7 +1149,7 @@ 
     public static function getMimeType($filename)
     {
         if (function_exists('finfo_open')) {
-            $pathToMagic = REFERENCES_PATH . 'mime/magic';
+            $pathToMagic = REFERENCES_PATH.'mime/magic';
             $finfo       = new finfo(FILEINFO_MIME, $pathToMagic);
             $mimetype    = $finfo->file($filename);
             finfo_close($finfo);
@@ -1179,7 +1179,7 @@ 
             sort($xoopsUsersIDs);
             if (count($xoopsUsersIDs) > 0) {
                 $member_handler = xoops_getHandler('user');
-                $criteria       = new Criteria('uid', '(' . implode(',', $xoopsUsersIDs) . ')', 'IN');
+                $criteria       = new Criteria('uid', '('.implode(',', $xoopsUsersIDs).')', 'IN');
                 $criteria->setSort('uid');
                 $users = $member_handler->getObjects($criteria, true);
             }
@@ -1217,7 +1217,7 @@ 
         } else {
             if ($uid > 0) {
                 $member_handler = xoops_getHandler('member');
-                $buffer[$uid]   = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
+                $buffer[$uid]   = $member_handler->getGroupsByUser($uid, false); // Renvoie un tableau d'ID (de groupes)
             } else {
                 $buffer[$uid] = array(XOOPS_GROUP_ANONYMOUS);
             }
@@ -1244,7 +1244,7 @@ 
             $retval = $buffer[$group];
         } else {
             $member_handler = xoops_getHandler('member');
-            $groups         = $member_handler->getGroupsByUser($uid, false);    // Renvoie un tableau d'ID (de groupes)
+            $groups         = $member_handler->getGroupsByUser($uid, false); // Renvoie un tableau d'ID (de groupes)
             $retval         = in_array($group, $groups);
             $buffer[$group] = $retval;
         }
@@ -1284,7 +1284,7 @@ 
         static $cache = -1;
         if ($cache == -1) {
             global $xoopsDB;
-            $sql    = 'SELECT COUNT(*) FROM ' . $xoopsDB->prefix('groups');
+            $sql    = 'SELECT COUNT(*) FROM '.$xoopsDB->prefix('groups');
             $result = $xoopsDB->query($sql);
             if (!$result) {
                 return false;
@@ -1305,7 +1305,7 @@ 
     {
         if (!is_dir($folder)) {
             mkdir($folder, 0777);
-            file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>');
+            file_put_contents($folder.'/index.html', '<script>history.go(-1);</script>');
         } else {
             if (!is_writable($folder)) {
                 chmod($folder, 0777);
@@ -1326,10 +1326,10 @@ 
         if (strstr($languageFile, $defaultExtension) === false) {
             $languageFile .= $defaultExtension;
         }
-        if (file_exists($root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile)) {
-            require_once $root . 'language' . DIRECTORY_SEPARATOR . $xoopsConfig['language'] . DIRECTORY_SEPARATOR . $languageFile;
+        if (file_exists($root.'language'.DIRECTORY_SEPARATOR.$xoopsConfig['language'].DIRECTORY_SEPARATOR.$languageFile)) {
+            require_once $root.'language'.DIRECTORY_SEPARATOR.$xoopsConfig['language'].DIRECTORY_SEPARATOR.$languageFile;
         } else {    // Fallback
-            require_once $root . 'language' . DIRECTORY_SEPARATOR . 'english' . DIRECTORY_SEPARATOR . $languageFile;
+            require_once $root.'language'.DIRECTORY_SEPARATOR.'english'.DIRECTORY_SEPARATOR.$languageFile;
         }
     }
 
@@ -1367,10 +1367,10 @@ 
                 $left = $top = 0;
                 if (is_array($pictureDimensions)) {
                     if ($pictureWidth > $param_width) {
-                        $left = (int)(($pictureWidth / 2) - ($param_width / 2));
+                        $left = (int) (($pictureWidth / 2) - ($param_width / 2));
                     }
                     if ($pictureHeight > $param_height) {
-                        $top = (int)(($pictureHeight / 2) - ($param_height / 2));
+                        $top = (int) (($pictureHeight / 2) - ($param_height / 2));
                     }
                 }
                 $result = $img->crop($left, $top, $param_width, $param_height);
@@ -1410,7 +1410,7 @@ 
                     $selected = " selected = 'selected'";
                 }
             }
-            $ret[] = '<option value=0' . $selected . '>---</option>';
+            $ret[] = '<option value=0'.$selected.'>---</option>';
         }
 
         foreach ($array as $index => $label) {
@@ -1424,7 +1424,7 @@ 
                     $selected = " selected = 'selected'";
                 }
             }
-            $ret[] = "<option value=\"" . $index . "\"" . $selected . '>' . $label . '</option>';
+            $ret[] = "<option value=\"".$index."\"".$selected.'>'.$label.'</option>';
         }
 
         return implode("\n", $ret);
@@ -1446,14 +1446,14 @@ 
     public static function htmlSelect($selectName, $array, $default, $withNull = true, $style = '', $multiple = false, $size = 1, $extra = '')
     {
         $ret = '';
-        $ret .= "<select name='" . $selectName . "' id='" . $selectName . "'";
+        $ret .= "<select name='".$selectName."' id='".$selectName."'";
         if (xoops_trim($style) != '') {
-            $ret .= " style='" . $style . "' ";
+            $ret .= " style='".$style."' ";
         }
         if (xoops_trim($multiple) != '') {
-            $ret .= " multiple = 'multiple' size='" . $size . "' ";
+            $ret .= " multiple = 'multiple' size='".$size."' ";
         }
-        $ret .= $extra . ">\n";
+        $ret .= $extra.">\n";
         $ret .= self::htmlSelectOptions($array, $default, $withNull);
         $ret .= "</select>\n";
 
@@ -1528,16 +1528,16 @@ 
     {
         global $xoopsDB;
         define('REFERENCES_MAINTAIN', true);
-        require self::MODULE_PATH . 'xoops_version.php';
+        require self::MODULE_PATH.'xoops_version.php';
         $tables = array();
         foreach ($modversion['tables'] as $table) {
             $tables[] = $xoopsDB->prefix($table);
         }
         if (count($tables) > 0) {
             $list = implode(',', $tables);
-            $xoopsDB->queryF('CHECK TABLE ' . $list);
-            $xoopsDB->queryF('ANALYZE TABLE ' . $list);
-            $xoopsDB->queryF('OPTIMIZE TABLE ' . $list);
+            $xoopsDB->queryF('CHECK TABLE '.$list);
+            $xoopsDB->queryF('ANALYZE TABLE '.$list);
+            $xoopsDB->queryF('OPTIMIZE TABLE '.$list);
         }
         self::updateCache();
         $handlers = references_handler::getInstance();

class/PersistableObjectHandler.php

Indentation +808 added lines, -808 removed lines

@@ -25,44 +25,44 @@ 
 
 class references_Object extends XoopsObject
 {
-    public function toArray($format = 's')
-    {
-        $ret = array();
-        foreach ($this->vars as $k => $v) {
-            $ret[$k] = $this->getVar($k, $format);
-        }
-
-        return $ret;
-    }
-
-    // TODO: Rajouter une méthode intsert() et delete()
-
-    /**
-     * Permet de valoriser un champ de la table comme si c'était une propriété de la classe
-     *
-     * @example $enregistrement->nom_du_champ = 'ma chaine'
-     *
-     * @param string $key   Le nom du champ à traiter
-     * @param mixed  $value La valeur à lui attribuer
-     * @return void
-     */
-    public function __set($key, $value)
-    {
-        return $this->setVar($key, $value);
-    }
-
-    /**
-     * Permet d'accéder aux champs de la table comme à des propriétés de la classe
-     *
-     * @example echo $enregistrement->nom_du_champ;
-     *
-     * @param string $key Le nom du champ que l'on souhaite récupérer
-     * @return mixed
-     */
-    public function __get($key)
-    {
-        return $this->getVar($key);
-    }
+	public function toArray($format = 's')
+	{
+		$ret = array();
+		foreach ($this->vars as $k => $v) {
+			$ret[$k] = $this->getVar($k, $format);
+		}
+
+		return $ret;
+	}
+
+	// TODO: Rajouter une méthode intsert() et delete()
+
+	/**
+	 * Permet de valoriser un champ de la table comme si c'était une propriété de la classe
+	 *
+	 * @example $enregistrement->nom_du_champ = 'ma chaine'
+	 *
+	 * @param string $key   Le nom du champ à traiter
+	 * @param mixed  $value La valeur à lui attribuer
+	 * @return void
+	 */
+	public function __set($key, $value)
+	{
+		return $this->setVar($key, $value);
+	}
+
+	/**
+	 * Permet d'accéder aux champs de la table comme à des propriétés de la classe
+	 *
+	 * @example echo $enregistrement->nom_du_champ;
+	 *
+	 * @param string $key Le nom du champ que l'on souhaite récupérer
+	 * @return mixed
+	 */
+	public function __get($key)
+	{
+		return $this->getVar($key);
+	}
 }
 
 /**
@@ -73,778 +73,778 @@ 
  */
 class references_XoopsPersistableObjectHandler extends XoopsObjectHandler
 {
-    /**#@+
+	/**#@+
      * Information about the class, the handler is managing
      *
      * @var string
      */
-    public    $table;
-    public    $keyName;
-    public    $className;
-    public    $identifierName;
-    protected $cacheOptions = array();
-    /**#@-*/
-
-    /**
-     * Constructor - called from child classes
-     * @param object $db           {@link XoopsDatabase} object
-     * @param string $tablename    Name of database table
-     * @param string $classname    Name of Class, this handler is managing
-     * @param string $keyname      Name of the property, holding the key
-     * @param string $idenfierName Name of the property, holding the label
-     * @param array  $cacheOptions Optional, options for the cache
-     *
-     */
-    public function __construct(&$db, $tablename, $classname, $keyname, $idenfierName = '', $cacheOptions = null)
-    {
-        parent::__construct($db);
-        $this->table     = $db->prefix($tablename);
-        $this->keyName   = $keyname;
-        $this->className = $classname;
-        if (trim($idenfierName) != '') {
-            $this->identifierName = $idenfierName;
-        }
-        // To diable cache, add this line after the first one : 'caching' => false,
-        if (is_null($cacheOptions)) {
-            $this->setCachingOptions(array('cacheDir' => REFERENCES_CACHE_PATH, 'lifeTime' => null, 'automaticSerialization' => true, 'fileNameProtection' => false));
-        } else {
-            $this->setCachingOptions($cacheOptions);
-        }
-    }
-
-    public function setCachingOptions($cacheOptions)
-    {
-        $this->cacheOptions = $cacheOptions;
-    }
-
-    /**
-     * Generates a unique ID for a Sql Query
-     *
-     * @param  string  $query The SQL query for which we want a unidque ID
-     * @param  integer $start Which record to start at
-     * @param  integer $limit Max number of objects to fetch
-     * @return string  An MD5 of the query
-     */
-    protected function _getIdForCache($query, $start, $limit)
-    {
-        $id = md5($query . '-' . (string)$start . '-' . (string)$limit);
-
-        return $id;
-    }
-
-    /**
-     * create a new object
-     *
-     * @param bool $isNew Flag the new objects as "new"?
-     *
-     * @return object
-     */
-    public function &create($isNew = true)
-    {
-        $obj = new $this->className();
-        if ($isNew === true) {
-            $obj->setNew();
-        }
-
-        return $obj;
-    }
-
-    /**
-     * retrieve an object
-     *
-     * @param  mixed $id        ID of the object - or array of ids for joint keys. Joint keys MUST be given in the same order as in the constructor
-     * @param  bool  $as_object whether to return an object or an array
-     * @return mixed reference to the object, FALSE if failed
-     */
-    public function &get($id, $as_object = true)
-    {
-        if (is_array($this->keyName)) {
-            $criteria = new CriteriaCompo();
-            $vnb      = count($this->keyName);
-            for ($i = 0; $i < $vnb; ++$i) {
-                $criteria->add(new Criteria($this->keyName[$i], (int)$id[$i]));
-            }
-        } else {
-            $criteria = new Criteria($this->keyName, (int)$id);
-        }
-        $criteria->setLimit(1);
-        $obj_array = $this->getObjects($criteria, false, $as_object);
-        if (count($obj_array) != 1) {
-            $ret = null;
-        } else {
-            $ret =& $obj_array[0];
-        }
-
-        return $ret;
-    }
-
-    /**
-     * retrieve objects from the database
-     *
-     * @param null|CriteriaElement $criteria  {@link CriteriaElement} conditions to be met
-     * @param bool                 $id_as_key use the ID as key for the array?
-     * @param bool                 $as_object return an array of objects?
-     *
-     * @param string               $fields
-     * @param bool                 $autoSort
-     * @return array
-     */
-    public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true, $fields = '*', $autoSort = true)
-    {
-        require_once __DIR__ . '/lite.php';
-        $ret   = array();
-        $limit = $start = 0;
-        $sql   = 'SELECT ' . $fields . ' FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            if ($criteria->groupby != '') {
-                $sql .= $criteria->getGroupby();
-            }
-            if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
-            } elseif ($this->identifierName != '' && $autoSort) {
-                $sql .= ' ORDER BY ' . $this->identifierName;
-            }
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $id         = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData  = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            if (!$result) {
-                return $ret;
-            }
-            $ret = $this->convertResultSet($result, $id_as_key, $as_object, $fields);
-            $Cache_Lite->save($ret);
-
-            return $ret;
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * Convert a database resultset to a returnable array
-     *
-     * @param object  $result    database resultset
-     * @param boolean $id_as_key - should NOT be used with joint keys
-     * @param boolean $as_object
-     * @param string  $fields    Requested fields from the query
-     *
-     * @return array
-     */
-    protected function convertResultSet($result, $id_as_key = false, $as_object = true, $fields = '*')
-    {
-        $ret = array();
-        while ($myrow = $this->db->fetchArray($result)) {
-            $obj =& $this->create(false);
-            $obj->assignVars($myrow);
-            if (!$id_as_key) {
-                if ($as_object) {
-                    $ret[] =& $obj;
-                } else {
-                    $row     = array();
-                    $vars    = $obj->getVars();
-                    $tbl_tmp = array_keys($vars);
-                    foreach ($tbl_tmp as $i) {
-                        $row[$i] = $obj->getVar($i);
-                    }
-                    $ret[] = $row;
-                }
-            } else {
-                if ($as_object) {
-                    if ($fields === '*') {
-                        $ret[$myrow[$this->keyName]] =& $obj;
-                    } else {
-                        $ret[] =& $obj;
-                    }
-                } else {
-                    $row     = array();
-                    $vars    = $obj->getVars();
-                    $tbl_tmp = array_keys($vars);
-                    foreach ($tbl_tmp as $i) {
-                        $row[$i] = $obj->getVar($i);
-                    }
-                    $ret[$myrow[$this->keyName]] = $row;
-                }
-            }
-            unset($obj);
-        }
-
-        return $ret;
-    }
-
-    /**
-     * get IDs of objects matching a condition
-     *
-     * @param  object $criteria {@link CriteriaElement} to match
-     * @return array  of object IDs
-     */
-    public function getIds($criteria = null)
-    {
-        require_once __DIR__ . '/lite.php';
-        $limit = $start = 0;
-
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $sql        = 'SELECT ' . $this->keyName . ' FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            if ($criteria->groupby != '') {
-                $sql .= $criteria->getGroupby();
-            }
-            if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
-            } elseif ($this->identifierName != '') {
-                $sql .= ' ORDER BY ' . $this->identifierName;
-            }
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-
-        $id        = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            $ret    = array();
-            while ($myrow = $this->db->fetchArray($result)) {
-                $ret[] = $myrow[$this->keyName];
-            }
-            $Cache_Lite->save($ret);
-
-            return $ret;
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * Retrieve a list of objects as arrays - DON'T USE WITH JOINT KEYS
-     *
-     * @param object $criteria {@link CriteriaElement} conditions to be met
-     * @return array
-     */
-    public function getList($criteria = null)
-    {
-        require_once __DIR__ . '/lite.php';
-        $limit      = $start = 0;
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-
-        $ret = array();
-
-        $sql = 'SELECT ' . $this->keyName;
-        if (!empty($this->identifierName)) {
-            $sql .= ', ' . $this->identifierName;
-        }
-        $sql .= ' FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            if ($criteria->groupby != '') {
-                $sql .= $criteria->getGroupby();
-            }
-            if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
-            } elseif ($this->identifierName != '') {
-                $sql .= ' ORDER BY ' . $this->identifierName;
-            }
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-
-        $id        = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            if (!$result) {
-                $Cache_Lite->save($ret);
-
-                return $ret;
-            }
-
-            $myts = MyTextSanitizer::getInstance();
-            while ($myrow = $this->db->fetchArray($result)) {
-                //identifiers should be textboxes, so sanitize them like that
-                $ret[$myrow[$this->keyName]] = empty($this->identifierName) ? 1 : $myts->htmlSpecialChars($myrow[$this->identifierName]);
-            }
-            $Cache_Lite->save($ret);
-
-            return $ret;
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * Retourne des éléments selon leur ID
-     *
-     * @param array $ids Les ID des éléments à retrouver
-     * @param null  $additionnal
-     * @return array Tableau d'objets
-     */
-    public function getItemsFromIds($ids, $additionnal = null)
-    {
-        $ret = array();
-        if (is_array($ids) && count($ids) > 0) {
-            $criteria = new CriteriaCompo();
-            $criteria->add(new Criteria($this->keyName, '(' . implode(',', $ids) . ')', 'IN'));
-            if (!is_null($additionnal)) {
-                $criteria->add($additionnal);
-            }
-            $ret = $this->getObjects($criteria, true);
-        }
-
-        return $ret;
-    }
-
-    /**
-     * count objects matching a condition
-     *
-     * @param  object $criteria {@link CriteriaElement} to match
-     * @return int    count of objects
-     */
-    public function getCount($criteria = null)
-    {
-        $field   = '';
-        $groupby = false;
-        $limit   = $start = 0;
-        require_once __DIR__ . '/lite.php';
-
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            if ($criteria->groupby != '') {
-                $groupby = true;
-                $field   = $criteria->groupby . ', '; //Not entirely secure unless you KNOW that no criteria's groupby clause is going to be mis-used
-            }
-        }
-        $sql = 'SELECT ' . $field . 'COUNT(*) FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            if ($criteria->groupby != '') {
-                $sql .= $criteria->getGroupby();
-            }
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $id         = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData  = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            if (!$result) {
-                $ret = 0;
-                $Cache_Lite->save($ret);
-
-                return $ret;
-            }
-            if ($groupby == false) {
-                list($count) = $this->db->fetchRow($result);
-                $Cache_Lite->save($count);
-
-                return $count;
-            } else {
-                $ret = array();
-                while (list($id, $count) = $this->db->fetchRow($result)) {
-                    $ret[$id] = $count;
-                }
-                $Cache_Lite->save($ret);
-
-                return $ret;
-            }
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * Retourne le total d'un champ
-     *
-     * @param  string $field    Le champ dont on veut calculer le total
-     * @param  object $criteria {@link CriteriaElement} to match
-     * @return integer le total
-     */
-    public function getSum($field, $criteria = null)
-    {
-        $limit = $start = 0;
-        require_once __DIR__ . '/lite.php';
-
-        $sql = 'SELECT Sum(' . $field . ') as cpt FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            if ($criteria->groupby != '') {
-                $sql .= $criteria->getGroupby();
-            }
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $id         = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData  = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            if (!$result) {
-                $ret = 0;
-                $Cache_Lite->save($ret);
-
-                return $ret;
-            }
-            $row   = $this->db->fetchArray($result);
-            $count = $row['cpt'];
-            $Cache_Lite->save($count);
-
-            return $count;
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * delete an object from the database
-     *
-     * @param  XoopsObject $obj reference to the object to delete
-     * @param  bool        $force
-     * @return bool   FALSE if failed.
-     */
-    public function delete(XoopsObject $obj, $force = false)
-    {
-        if (is_array($this->keyName)) {
-            $clause = array();
-            $vnb    = count($this->keyName);
-            for ($i = 0; $i < $vnb; ++$i) {
-                $clause[] = $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
-            }
-            $whereclause = implode(' AND ', $clause);
-        } else {
-            $whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
-        }
-        $sql = 'DELETE FROM ' . $this->table . ' WHERE ' . $whereclause;
-        if (false != $force) {
-            $result = $this->db->queryF($sql);
-        } else {
-            $result = $this->db->query($sql);
-        }
-        // Clear cache
-        $this->forceCacheClean();
-
-        if (!$result) {
-            return false;
-        }
-
-        return true;
-    }
-
-    /**
-     * Quickly insert a record like this $myobject_handler->quickInsert('field1' => field1value, 'field2' => $field2value)
-     *
-     * @param  array $vars  Array containing the fields name and value
-     * @param  bool  $force whether to force the query execution despite security settings
-     * @return bool  @link insert's value
-     */
-    public function quickInsert($vars = null, $force = true)
-    {
-        $object = $this->create(true);
-        $object->setVars($vars);
-        $retval =& $this->insert($object, $force);
-        unset($object);
-
-        // Clear cache
-        $this->forceCacheClean();
-
-        return $retval;
-    }
-
-    /**
-     * insert a new object in the database
-     *
-     * @param  XoopsObject $obj         reference to the object
-     * @param  bool        $force       whether to force the query execution despite security settings
-     * @param  bool        $checkObject check if the object is dirty and clean the attributes
-     * @param bool         $ignoreInsert
-     * @return bool FALSE if failed, TRUE if already present and unchanged or successful
-     */
-
-    public function insert(XoopsObject $obj, $force = false, $checkObject = true, $ignoreInsert = false)
-    {
-        if ($checkObject != false) {
-            if (!is_object($obj)) {
-                trigger_error('Error, not object');
-
-                return false;
-            }
-            /**
-             * @TODO: Change to if (!(class_exists($this->className) && $obj instanceof $this->className)) when going fully PHP5
-             */
-            if (!is_a($obj, $this->className)) {
-                $obj->setErrors(get_class($obj) . ' Differs from ' . $this->className);
-
-                return false;
-            }
-            if (!$obj->isDirty()) {
-                $obj->setErrors('Not dirty'); //will usually not be outputted as errors are not displayed when the method returns true, but it can be helpful when troubleshooting code - Mith
-
-                return true;
-            }
-        }
-        if (!$obj->cleanVars()) {
-            foreach ($obj->getErrors() as $oneerror) {
-                trigger_error($oneerror);
-            }
-
-            return false;
-        }
-        foreach ($obj->cleanVars as $k => $v) {
-            if ($obj->vars[$k]['data_type'] == XOBJ_DTYPE_INT) {
-                $cleanvars[$k] = (int)$v;
-            } elseif (is_array($v)) {
-                $cleanvars[$k] = $this->db->quoteString(implode(',', $v));
-            } else {
-                $cleanvars[$k] = $this->db->quoteString($v);
-            }
-        }
-        if (isset($cleanvars['dohtml'])) {        // Modification Herv� to be able to use dohtml
-            unset($cleanvars['dohtml']);
-        }
-        if ($obj->isNew()) {
-            if (!is_array($this->keyName)) {
-                if ($cleanvars[$this->keyName] < 1) {
-                    $cleanvars[$this->keyName] = $this->db->genId($this->table . '_' . $this->keyName . '_seq');
-                }
-            }
-            $ignore = '';
-            if ($ignoreInsert) {
-                $ignore = 'IGNORE';
-            }
-            $sql = "INSERT $ignore INTO " . $this->table . ' (' . implode(',', array_keys($cleanvars)) . ') VALUES (' . implode(',', array_values($cleanvars)) . ')';
-        } else {
-            $sql = 'UPDATE ' . $this->table . ' SET';
-            foreach ($cleanvars as $key => $value) {
-                if ((!is_array($this->keyName) && $key == $this->keyName) || (is_array($this->keyName) && in_array($key, $this->keyName))) {
-                    continue;
-                }
-                if (isset($notfirst)) {
-                    $sql .= ',';
-                }
-                $sql .= ' ' . $key . ' = ' . $value;
-                $notfirst = true;
-            }
-            if (is_array($this->keyName)) {
-                $whereclause = '';
-                $vnb         = count($this->keyName);
-                for ($i = 0; $i < $vnb; ++$i) {
-                    if ($i > 0) {
-                        $whereclause .= ' AND ';
-                    }
-                    $whereclause .= $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
-                }
-            } else {
-                $whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
-            }
-            $sql .= ' WHERE ' . $whereclause;
-        }
-
-        if (false != $force) {
-            $result = $this->db->queryF($sql);
-        } else {
-            $result = $this->db->query($sql);
-        }
-
-        // Clear cache
-        $this->forceCacheClean();
-
-        if (!$result) {
-            return false;
-        }
-        if ($obj->isNew() && !is_array($this->keyName)) {
-            $obj->assignVar($this->keyName, $this->db->getInsertId());
-        }
-
-        return true;
-    }
-
-    /**
-     * Change a value for objects with a certain criteria
-     *
-     * @param string $fieldname  Name of the field
-     * @param string $fieldvalue Value to write
-     * @param object $criteria   {@link CriteriaElement}
-     *
-     * @param bool   $force
-     * @return bool
-     */
-    public function updateAll($fieldname, $fieldvalue, $criteria = null, $force = false)
-    {
-        $set_clause = $fieldname . ' = ';
-        if (is_numeric($fieldvalue)) {
-            $set_clause .= $fieldvalue;
-        } elseif (is_array($fieldvalue)) {
-            $set_clause .= $this->db->quoteString(implode(',', $fieldvalue));
-        } else {
-            $set_clause .= $this->db->quoteString($fieldvalue);
-        }
-        $sql = 'UPDATE ' . $this->table . ' SET ' . $set_clause;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-        }
-        if ($force) {
-            $result = $this->db->queryF($sql);
-        } else {
-            $result = $this->db->query($sql);
-        }
-
-        // Clear cache
-        $this->forceCacheClean();
-
-        if (!$result) {
-            return false;
-        }
-
-        return true;
-    }
-
-    //  check if target object is attempting to use duplicated info
-    public function isDuplicated(&$obj, $field = '', $error = '')
-    {
-        if (empty($field)) {
-            return false;
-        }
-        $criteria = new CriteriaCompo();
-        $criteria->add(new Criteria($field, $obj->getVar($field)));
-        //  one more condition if target object exisits in database
-        if (!$obj->isNew()) {
-            $criteria->add(new Criteria($this->_key, $obj->getVar($this->_key), '!='));
-        }
-        if ($this->getCount($criteria)) {
-            $obj->setErrors($error);
-
-            return true;
-        }
-
-        return false;
-    }
-
-    /**
-     * delete all objects meeting the conditions
-     *
-     * @param  object $criteria {@link CriteriaElement} with conditions to meet
-     * @return bool
-     */
-    public function deleteAll($criteria = null)
-    {
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql = 'DELETE FROM ' . $this->table;
-            $sql .= ' ' . $criteria->renderWhere();
-            if (!$this->db->queryF($sql)) {
-                return false;
-            }
-            $rows = $this->db->getAffectedRows();
-
-            // Clear cache
-            $this->forceCacheClean();
-
-            return $rows > 0 ? $rows : true;
-        }
-
-        return false;
-    }
-
-    /**
-     * Compare two objects and returns, in an array, the differences
-     *
-     * @param  XoopsObject $old_object The first object to compare
-     * @param  XoopsObject $new_object The new object
-     * @return array       differences  key = fieldname, value = array('old_value', 'new_value')
-     */
-    public function compareObjects($old_object, $new_object)
-    {
-        $ret       = array();
-        $vars_name = array_keys($old_object->getVars());
-        foreach ($vars_name as $one_var) {
-            if ($old_object->getVar($one_var, 'f') == $new_object->getVar($one_var, 'f')) {
-            } else {
-                $ret[$one_var] = array($old_object->getVar($one_var), $new_object->getVar($one_var));
-            }
-        }
-
-        return $ret;
-    }
-
-    /**
-     * Get distincted values of a field in the table
-     *
-     * @param  string $field    Field's name
-     * @param  object $criteria {@link CriteriaElement} conditions to be met
-     * @param  string $format   Format in wich we want the datas
-     * @return array  containing the distinct values
-     */
-    public function getDistincts($field, $criteria = null, $format = 's')
-    {
-        require_once __DIR__ . '/lite.php';
-        $limit = $start = 0;
-        $sql   = 'SELECT ' . $this->keyName . ', ' . $field . ' FROM ' . $this->table;
-        if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
-            $limit = $criteria->getLimit();
-            $start = $criteria->getStart();
-        }
-        $sql .= ' GROUP BY ' . $field . ' ORDER BY ' . $field;
-
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $id         = $this->_getIdForCache($sql, $start, $limit);
-        $cacheData  = $Cache_Lite->get($id);
-        if ($cacheData === false) {
-            $result = $this->db->query($sql, $limit, $start);
-            $ret    = array();
-            $obj    = new $this->className();
-            while ($myrow = $this->db->fetchArray($result)) {
-                $obj->setVar($field, $myrow[$field]);
-                $ret[$myrow[$this->keyName]] = $obj->getVar($field, $format);
-            }
-            $Cache_Lite->save($ret);
-
-            return $ret;
-        } else {
-            return $cacheData;
-        }
-    }
-
-    /**
-     * A generic shortcut to getObjects
-     *
-     * @author Herve Thouzard - Instant Zero
-     *
-     * @param  integer $start   Starting position
-     * @param  integer $limit   Maximum count of elements to return
-     * @param  string  $sort    Field to use for the sort
-     * @param  string  $order   Sort order
-     * @param  boolean $idAsKey Do we have to return an array whoses keys are the record's ID ?
-     * @return array   Array of current objects
-     */
-    public function getItems($start = 0, $limit = 0, $sort = '', $order = 'ASC', $idAsKey = true)
-    {
-        if (trim($order) == '') {
-            if (isset($this->identifierName) && trim($this->identifierName) != '') {
-                $order = $this->identifierName;
-            } else {
-                $order = $this->keyName;
-            }
-        }
-        $items   = array();
-        $critere = new Criteria($this->keyName, 0, '<>');
-        $critere->setLimit($limit);
-        $critere->setStart($start);
-        $critere->setSort($sort);
-        $critere->setOrder($order);
-        $items = $this->getObjects($critere, $idAsKey);
-
-        return $items;
-    }
-
-    /**
-     * Forces the cache to be cleaned
-     */
-    public function forceCacheClean()
-    {
-        require_once __DIR__ . '/lite.php';
-        $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $Cache_Lite->clean();
-    }
+	public    $table;
+	public    $keyName;
+	public    $className;
+	public    $identifierName;
+	protected $cacheOptions = array();
+	/**#@-*/
+
+	/**
+	 * Constructor - called from child classes
+	 * @param object $db           {@link XoopsDatabase} object
+	 * @param string $tablename    Name of database table
+	 * @param string $classname    Name of Class, this handler is managing
+	 * @param string $keyname      Name of the property, holding the key
+	 * @param string $idenfierName Name of the property, holding the label
+	 * @param array  $cacheOptions Optional, options for the cache
+	 *
+	 */
+	public function __construct(&$db, $tablename, $classname, $keyname, $idenfierName = '', $cacheOptions = null)
+	{
+		parent::__construct($db);
+		$this->table     = $db->prefix($tablename);
+		$this->keyName   = $keyname;
+		$this->className = $classname;
+		if (trim($idenfierName) != '') {
+			$this->identifierName = $idenfierName;
+		}
+		// To diable cache, add this line after the first one : 'caching' => false,
+		if (is_null($cacheOptions)) {
+			$this->setCachingOptions(array('cacheDir' => REFERENCES_CACHE_PATH, 'lifeTime' => null, 'automaticSerialization' => true, 'fileNameProtection' => false));
+		} else {
+			$this->setCachingOptions($cacheOptions);
+		}
+	}
+
+	public function setCachingOptions($cacheOptions)
+	{
+		$this->cacheOptions = $cacheOptions;
+	}
+
+	/**
+	 * Generates a unique ID for a Sql Query
+	 *
+	 * @param  string  $query The SQL query for which we want a unidque ID
+	 * @param  integer $start Which record to start at
+	 * @param  integer $limit Max number of objects to fetch
+	 * @return string  An MD5 of the query
+	 */
+	protected function _getIdForCache($query, $start, $limit)
+	{
+		$id = md5($query . '-' . (string)$start . '-' . (string)$limit);
+
+		return $id;
+	}
+
+	/**
+	 * create a new object
+	 *
+	 * @param bool $isNew Flag the new objects as "new"?
+	 *
+	 * @return object
+	 */
+	public function &create($isNew = true)
+	{
+		$obj = new $this->className();
+		if ($isNew === true) {
+			$obj->setNew();
+		}
+
+		return $obj;
+	}
+
+	/**
+	 * retrieve an object
+	 *
+	 * @param  mixed $id        ID of the object - or array of ids for joint keys. Joint keys MUST be given in the same order as in the constructor
+	 * @param  bool  $as_object whether to return an object or an array
+	 * @return mixed reference to the object, FALSE if failed
+	 */
+	public function &get($id, $as_object = true)
+	{
+		if (is_array($this->keyName)) {
+			$criteria = new CriteriaCompo();
+			$vnb      = count($this->keyName);
+			for ($i = 0; $i < $vnb; ++$i) {
+				$criteria->add(new Criteria($this->keyName[$i], (int)$id[$i]));
+			}
+		} else {
+			$criteria = new Criteria($this->keyName, (int)$id);
+		}
+		$criteria->setLimit(1);
+		$obj_array = $this->getObjects($criteria, false, $as_object);
+		if (count($obj_array) != 1) {
+			$ret = null;
+		} else {
+			$ret =& $obj_array[0];
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * retrieve objects from the database
+	 *
+	 * @param null|CriteriaElement $criteria  {@link CriteriaElement} conditions to be met
+	 * @param bool                 $id_as_key use the ID as key for the array?
+	 * @param bool                 $as_object return an array of objects?
+	 *
+	 * @param string               $fields
+	 * @param bool                 $autoSort
+	 * @return array
+	 */
+	public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true, $fields = '*', $autoSort = true)
+	{
+		require_once __DIR__ . '/lite.php';
+		$ret   = array();
+		$limit = $start = 0;
+		$sql   = 'SELECT ' . $fields . ' FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			if ($criteria->groupby != '') {
+				$sql .= $criteria->getGroupby();
+			}
+			if ($criteria->getSort() != '') {
+				$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+			} elseif ($this->identifierName != '' && $autoSort) {
+				$sql .= ' ORDER BY ' . $this->identifierName;
+			}
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$id         = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData  = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			if (!$result) {
+				return $ret;
+			}
+			$ret = $this->convertResultSet($result, $id_as_key, $as_object, $fields);
+			$Cache_Lite->save($ret);
+
+			return $ret;
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * Convert a database resultset to a returnable array
+	 *
+	 * @param object  $result    database resultset
+	 * @param boolean $id_as_key - should NOT be used with joint keys
+	 * @param boolean $as_object
+	 * @param string  $fields    Requested fields from the query
+	 *
+	 * @return array
+	 */
+	protected function convertResultSet($result, $id_as_key = false, $as_object = true, $fields = '*')
+	{
+		$ret = array();
+		while ($myrow = $this->db->fetchArray($result)) {
+			$obj =& $this->create(false);
+			$obj->assignVars($myrow);
+			if (!$id_as_key) {
+				if ($as_object) {
+					$ret[] =& $obj;
+				} else {
+					$row     = array();
+					$vars    = $obj->getVars();
+					$tbl_tmp = array_keys($vars);
+					foreach ($tbl_tmp as $i) {
+						$row[$i] = $obj->getVar($i);
+					}
+					$ret[] = $row;
+				}
+			} else {
+				if ($as_object) {
+					if ($fields === '*') {
+						$ret[$myrow[$this->keyName]] =& $obj;
+					} else {
+						$ret[] =& $obj;
+					}
+				} else {
+					$row     = array();
+					$vars    = $obj->getVars();
+					$tbl_tmp = array_keys($vars);
+					foreach ($tbl_tmp as $i) {
+						$row[$i] = $obj->getVar($i);
+					}
+					$ret[$myrow[$this->keyName]] = $row;
+				}
+			}
+			unset($obj);
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * get IDs of objects matching a condition
+	 *
+	 * @param  object $criteria {@link CriteriaElement} to match
+	 * @return array  of object IDs
+	 */
+	public function getIds($criteria = null)
+	{
+		require_once __DIR__ . '/lite.php';
+		$limit = $start = 0;
+
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$sql        = 'SELECT ' . $this->keyName . ' FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			if ($criteria->groupby != '') {
+				$sql .= $criteria->getGroupby();
+			}
+			if ($criteria->getSort() != '') {
+				$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+			} elseif ($this->identifierName != '') {
+				$sql .= ' ORDER BY ' . $this->identifierName;
+			}
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+
+		$id        = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			$ret    = array();
+			while ($myrow = $this->db->fetchArray($result)) {
+				$ret[] = $myrow[$this->keyName];
+			}
+			$Cache_Lite->save($ret);
+
+			return $ret;
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * Retrieve a list of objects as arrays - DON'T USE WITH JOINT KEYS
+	 *
+	 * @param object $criteria {@link CriteriaElement} conditions to be met
+	 * @return array
+	 */
+	public function getList($criteria = null)
+	{
+		require_once __DIR__ . '/lite.php';
+		$limit      = $start = 0;
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+
+		$ret = array();
+
+		$sql = 'SELECT ' . $this->keyName;
+		if (!empty($this->identifierName)) {
+			$sql .= ', ' . $this->identifierName;
+		}
+		$sql .= ' FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			if ($criteria->groupby != '') {
+				$sql .= $criteria->getGroupby();
+			}
+			if ($criteria->getSort() != '') {
+				$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+			} elseif ($this->identifierName != '') {
+				$sql .= ' ORDER BY ' . $this->identifierName;
+			}
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+
+		$id        = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			if (!$result) {
+				$Cache_Lite->save($ret);
+
+				return $ret;
+			}
+
+			$myts = MyTextSanitizer::getInstance();
+			while ($myrow = $this->db->fetchArray($result)) {
+				//identifiers should be textboxes, so sanitize them like that
+				$ret[$myrow[$this->keyName]] = empty($this->identifierName) ? 1 : $myts->htmlSpecialChars($myrow[$this->identifierName]);
+			}
+			$Cache_Lite->save($ret);
+
+			return $ret;
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * Retourne des éléments selon leur ID
+	 *
+	 * @param array $ids Les ID des éléments à retrouver
+	 * @param null  $additionnal
+	 * @return array Tableau d'objets
+	 */
+	public function getItemsFromIds($ids, $additionnal = null)
+	{
+		$ret = array();
+		if (is_array($ids) && count($ids) > 0) {
+			$criteria = new CriteriaCompo();
+			$criteria->add(new Criteria($this->keyName, '(' . implode(',', $ids) . ')', 'IN'));
+			if (!is_null($additionnal)) {
+				$criteria->add($additionnal);
+			}
+			$ret = $this->getObjects($criteria, true);
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * count objects matching a condition
+	 *
+	 * @param  object $criteria {@link CriteriaElement} to match
+	 * @return int    count of objects
+	 */
+	public function getCount($criteria = null)
+	{
+		$field   = '';
+		$groupby = false;
+		$limit   = $start = 0;
+		require_once __DIR__ . '/lite.php';
+
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			if ($criteria->groupby != '') {
+				$groupby = true;
+				$field   = $criteria->groupby . ', '; //Not entirely secure unless you KNOW that no criteria's groupby clause is going to be mis-used
+			}
+		}
+		$sql = 'SELECT ' . $field . 'COUNT(*) FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			if ($criteria->groupby != '') {
+				$sql .= $criteria->getGroupby();
+			}
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$id         = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData  = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			if (!$result) {
+				$ret = 0;
+				$Cache_Lite->save($ret);
+
+				return $ret;
+			}
+			if ($groupby == false) {
+				list($count) = $this->db->fetchRow($result);
+				$Cache_Lite->save($count);
+
+				return $count;
+			} else {
+				$ret = array();
+				while (list($id, $count) = $this->db->fetchRow($result)) {
+					$ret[$id] = $count;
+				}
+				$Cache_Lite->save($ret);
+
+				return $ret;
+			}
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * Retourne le total d'un champ
+	 *
+	 * @param  string $field    Le champ dont on veut calculer le total
+	 * @param  object $criteria {@link CriteriaElement} to match
+	 * @return integer le total
+	 */
+	public function getSum($field, $criteria = null)
+	{
+		$limit = $start = 0;
+		require_once __DIR__ . '/lite.php';
+
+		$sql = 'SELECT Sum(' . $field . ') as cpt FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			if ($criteria->groupby != '') {
+				$sql .= $criteria->getGroupby();
+			}
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$id         = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData  = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			if (!$result) {
+				$ret = 0;
+				$Cache_Lite->save($ret);
+
+				return $ret;
+			}
+			$row   = $this->db->fetchArray($result);
+			$count = $row['cpt'];
+			$Cache_Lite->save($count);
+
+			return $count;
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * delete an object from the database
+	 *
+	 * @param  XoopsObject $obj reference to the object to delete
+	 * @param  bool        $force
+	 * @return bool   FALSE if failed.
+	 */
+	public function delete(XoopsObject $obj, $force = false)
+	{
+		if (is_array($this->keyName)) {
+			$clause = array();
+			$vnb    = count($this->keyName);
+			for ($i = 0; $i < $vnb; ++$i) {
+				$clause[] = $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
+			}
+			$whereclause = implode(' AND ', $clause);
+		} else {
+			$whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
+		}
+		$sql = 'DELETE FROM ' . $this->table . ' WHERE ' . $whereclause;
+		if (false != $force) {
+			$result = $this->db->queryF($sql);
+		} else {
+			$result = $this->db->query($sql);
+		}
+		// Clear cache
+		$this->forceCacheClean();
+
+		if (!$result) {
+			return false;
+		}
+
+		return true;
+	}
+
+	/**
+	 * Quickly insert a record like this $myobject_handler->quickInsert('field1' => field1value, 'field2' => $field2value)
+	 *
+	 * @param  array $vars  Array containing the fields name and value
+	 * @param  bool  $force whether to force the query execution despite security settings
+	 * @return bool  @link insert's value
+	 */
+	public function quickInsert($vars = null, $force = true)
+	{
+		$object = $this->create(true);
+		$object->setVars($vars);
+		$retval =& $this->insert($object, $force);
+		unset($object);
+
+		// Clear cache
+		$this->forceCacheClean();
+
+		return $retval;
+	}
+
+	/**
+	 * insert a new object in the database
+	 *
+	 * @param  XoopsObject $obj         reference to the object
+	 * @param  bool        $force       whether to force the query execution despite security settings
+	 * @param  bool        $checkObject check if the object is dirty and clean the attributes
+	 * @param bool         $ignoreInsert
+	 * @return bool FALSE if failed, TRUE if already present and unchanged or successful
+	 */
+
+	public function insert(XoopsObject $obj, $force = false, $checkObject = true, $ignoreInsert = false)
+	{
+		if ($checkObject != false) {
+			if (!is_object($obj)) {
+				trigger_error('Error, not object');
+
+				return false;
+			}
+			/**
+			 * @TODO: Change to if (!(class_exists($this->className) && $obj instanceof $this->className)) when going fully PHP5
+			 */
+			if (!is_a($obj, $this->className)) {
+				$obj->setErrors(get_class($obj) . ' Differs from ' . $this->className);
+
+				return false;
+			}
+			if (!$obj->isDirty()) {
+				$obj->setErrors('Not dirty'); //will usually not be outputted as errors are not displayed when the method returns true, but it can be helpful when troubleshooting code - Mith
+
+				return true;
+			}
+		}
+		if (!$obj->cleanVars()) {
+			foreach ($obj->getErrors() as $oneerror) {
+				trigger_error($oneerror);
+			}
+
+			return false;
+		}
+		foreach ($obj->cleanVars as $k => $v) {
+			if ($obj->vars[$k]['data_type'] == XOBJ_DTYPE_INT) {
+				$cleanvars[$k] = (int)$v;
+			} elseif (is_array($v)) {
+				$cleanvars[$k] = $this->db->quoteString(implode(',', $v));
+			} else {
+				$cleanvars[$k] = $this->db->quoteString($v);
+			}
+		}
+		if (isset($cleanvars['dohtml'])) {        // Modification Herv� to be able to use dohtml
+			unset($cleanvars['dohtml']);
+		}
+		if ($obj->isNew()) {
+			if (!is_array($this->keyName)) {
+				if ($cleanvars[$this->keyName] < 1) {
+					$cleanvars[$this->keyName] = $this->db->genId($this->table . '_' . $this->keyName . '_seq');
+				}
+			}
+			$ignore = '';
+			if ($ignoreInsert) {
+				$ignore = 'IGNORE';
+			}
+			$sql = "INSERT $ignore INTO " . $this->table . ' (' . implode(',', array_keys($cleanvars)) . ') VALUES (' . implode(',', array_values($cleanvars)) . ')';
+		} else {
+			$sql = 'UPDATE ' . $this->table . ' SET';
+			foreach ($cleanvars as $key => $value) {
+				if ((!is_array($this->keyName) && $key == $this->keyName) || (is_array($this->keyName) && in_array($key, $this->keyName))) {
+					continue;
+				}
+				if (isset($notfirst)) {
+					$sql .= ',';
+				}
+				$sql .= ' ' . $key . ' = ' . $value;
+				$notfirst = true;
+			}
+			if (is_array($this->keyName)) {
+				$whereclause = '';
+				$vnb         = count($this->keyName);
+				for ($i = 0; $i < $vnb; ++$i) {
+					if ($i > 0) {
+						$whereclause .= ' AND ';
+					}
+					$whereclause .= $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
+				}
+			} else {
+				$whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
+			}
+			$sql .= ' WHERE ' . $whereclause;
+		}
+
+		if (false != $force) {
+			$result = $this->db->queryF($sql);
+		} else {
+			$result = $this->db->query($sql);
+		}
+
+		// Clear cache
+		$this->forceCacheClean();
+
+		if (!$result) {
+			return false;
+		}
+		if ($obj->isNew() && !is_array($this->keyName)) {
+			$obj->assignVar($this->keyName, $this->db->getInsertId());
+		}
+
+		return true;
+	}
+
+	/**
+	 * Change a value for objects with a certain criteria
+	 *
+	 * @param string $fieldname  Name of the field
+	 * @param string $fieldvalue Value to write
+	 * @param object $criteria   {@link CriteriaElement}
+	 *
+	 * @param bool   $force
+	 * @return bool
+	 */
+	public function updateAll($fieldname, $fieldvalue, $criteria = null, $force = false)
+	{
+		$set_clause = $fieldname . ' = ';
+		if (is_numeric($fieldvalue)) {
+			$set_clause .= $fieldvalue;
+		} elseif (is_array($fieldvalue)) {
+			$set_clause .= $this->db->quoteString(implode(',', $fieldvalue));
+		} else {
+			$set_clause .= $this->db->quoteString($fieldvalue);
+		}
+		$sql = 'UPDATE ' . $this->table . ' SET ' . $set_clause;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+		}
+		if ($force) {
+			$result = $this->db->queryF($sql);
+		} else {
+			$result = $this->db->query($sql);
+		}
+
+		// Clear cache
+		$this->forceCacheClean();
+
+		if (!$result) {
+			return false;
+		}
+
+		return true;
+	}
+
+	//  check if target object is attempting to use duplicated info
+	public function isDuplicated(&$obj, $field = '', $error = '')
+	{
+		if (empty($field)) {
+			return false;
+		}
+		$criteria = new CriteriaCompo();
+		$criteria->add(new Criteria($field, $obj->getVar($field)));
+		//  one more condition if target object exisits in database
+		if (!$obj->isNew()) {
+			$criteria->add(new Criteria($this->_key, $obj->getVar($this->_key), '!='));
+		}
+		if ($this->getCount($criteria)) {
+			$obj->setErrors($error);
+
+			return true;
+		}
+
+		return false;
+	}
+
+	/**
+	 * delete all objects meeting the conditions
+	 *
+	 * @param  object $criteria {@link CriteriaElement} with conditions to meet
+	 * @return bool
+	 */
+	public function deleteAll($criteria = null)
+	{
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql = 'DELETE FROM ' . $this->table;
+			$sql .= ' ' . $criteria->renderWhere();
+			if (!$this->db->queryF($sql)) {
+				return false;
+			}
+			$rows = $this->db->getAffectedRows();
+
+			// Clear cache
+			$this->forceCacheClean();
+
+			return $rows > 0 ? $rows : true;
+		}
+
+		return false;
+	}
+
+	/**
+	 * Compare two objects and returns, in an array, the differences
+	 *
+	 * @param  XoopsObject $old_object The first object to compare
+	 * @param  XoopsObject $new_object The new object
+	 * @return array       differences  key = fieldname, value = array('old_value', 'new_value')
+	 */
+	public function compareObjects($old_object, $new_object)
+	{
+		$ret       = array();
+		$vars_name = array_keys($old_object->getVars());
+		foreach ($vars_name as $one_var) {
+			if ($old_object->getVar($one_var, 'f') == $new_object->getVar($one_var, 'f')) {
+			} else {
+				$ret[$one_var] = array($old_object->getVar($one_var), $new_object->getVar($one_var));
+			}
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * Get distincted values of a field in the table
+	 *
+	 * @param  string $field    Field's name
+	 * @param  object $criteria {@link CriteriaElement} conditions to be met
+	 * @param  string $format   Format in wich we want the datas
+	 * @return array  containing the distinct values
+	 */
+	public function getDistincts($field, $criteria = null, $format = 's')
+	{
+		require_once __DIR__ . '/lite.php';
+		$limit = $start = 0;
+		$sql   = 'SELECT ' . $this->keyName . ', ' . $field . ' FROM ' . $this->table;
+		if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+			$sql .= ' ' . $criteria->renderWhere();
+			$limit = $criteria->getLimit();
+			$start = $criteria->getStart();
+		}
+		$sql .= ' GROUP BY ' . $field . ' ORDER BY ' . $field;
+
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$id         = $this->_getIdForCache($sql, $start, $limit);
+		$cacheData  = $Cache_Lite->get($id);
+		if ($cacheData === false) {
+			$result = $this->db->query($sql, $limit, $start);
+			$ret    = array();
+			$obj    = new $this->className();
+			while ($myrow = $this->db->fetchArray($result)) {
+				$obj->setVar($field, $myrow[$field]);
+				$ret[$myrow[$this->keyName]] = $obj->getVar($field, $format);
+			}
+			$Cache_Lite->save($ret);
+
+			return $ret;
+		} else {
+			return $cacheData;
+		}
+	}
+
+	/**
+	 * A generic shortcut to getObjects
+	 *
+	 * @author Herve Thouzard - Instant Zero
+	 *
+	 * @param  integer $start   Starting position
+	 * @param  integer $limit   Maximum count of elements to return
+	 * @param  string  $sort    Field to use for the sort
+	 * @param  string  $order   Sort order
+	 * @param  boolean $idAsKey Do we have to return an array whoses keys are the record's ID ?
+	 * @return array   Array of current objects
+	 */
+	public function getItems($start = 0, $limit = 0, $sort = '', $order = 'ASC', $idAsKey = true)
+	{
+		if (trim($order) == '') {
+			if (isset($this->identifierName) && trim($this->identifierName) != '') {
+				$order = $this->identifierName;
+			} else {
+				$order = $this->keyName;
+			}
+		}
+		$items   = array();
+		$critere = new Criteria($this->keyName, 0, '<>');
+		$critere->setLimit($limit);
+		$critere->setStart($start);
+		$critere->setSort($sort);
+		$critere->setOrder($order);
+		$items = $this->getObjects($critere, $idAsKey);
+
+		return $items;
+	}
+
+	/**
+	 * Forces the cache to be cleaned
+	 */
+	public function forceCacheClean()
+	{
+		require_once __DIR__ . '/lite.php';
+		$Cache_Lite = new references_Cache_Lite($this->cacheOptions);
+		$Cache_Lite->clean();
+	}
 }

Spacing +56 added lines, -56 removed lines

@@ -127,7 +127,7 @@ 
      */
     protected function _getIdForCache($query, $start, $limit)
     {
-        $id = md5($query . '-' . (string)$start . '-' . (string)$limit);
+        $id = md5($query.'-'.(string) $start.'-'.(string) $limit);
 
         return $id;
     }
@@ -162,17 +162,17 @@ 
             $criteria = new CriteriaCompo();
             $vnb      = count($this->keyName);
             for ($i = 0; $i < $vnb; ++$i) {
-                $criteria->add(new Criteria($this->keyName[$i], (int)$id[$i]));
+                $criteria->add(new Criteria($this->keyName[$i], (int) $id[$i]));
             }
         } else {
-            $criteria = new Criteria($this->keyName, (int)$id);
+            $criteria = new Criteria($this->keyName, (int) $id);
         }
         $criteria->setLimit(1);
         $obj_array = $this->getObjects($criteria, false, $as_object);
         if (count($obj_array) != 1) {
             $ret = null;
         } else {
-            $ret =& $obj_array[0];
+            $ret = & $obj_array[0];
         }
 
         return $ret;
@@ -191,19 +191,19 @@ 
      */
     public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true, $fields = '*', $autoSort = true)
     {
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
         $ret   = array();
         $limit = $start = 0;
-        $sql   = 'SELECT ' . $fields . ' FROM ' . $this->table;
+        $sql   = 'SELECT '.$fields.' FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             if ($criteria->groupby != '') {
                 $sql .= $criteria->getGroupby();
             }
             if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
             } elseif ($this->identifierName != '' && $autoSort) {
-                $sql .= ' ORDER BY ' . $this->identifierName;
+                $sql .= ' ORDER BY '.$this->identifierName;
             }
             $limit = $criteria->getLimit();
             $start = $criteria->getStart();
@@ -239,11 +239,11 @@ 
     {
         $ret = array();
         while ($myrow = $this->db->fetchArray($result)) {
-            $obj =& $this->create(false);
+            $obj = & $this->create(false);
             $obj->assignVars($myrow);
             if (!$id_as_key) {
                 if ($as_object) {
-                    $ret[] =& $obj;
+                    $ret[] = & $obj;
                 } else {
                     $row     = array();
                     $vars    = $obj->getVars();
@@ -256,9 +256,9 @@ 
             } else {
                 if ($as_object) {
                     if ($fields === '*') {
-                        $ret[$myrow[$this->keyName]] =& $obj;
+                        $ret[$myrow[$this->keyName]] = & $obj;
                     } else {
-                        $ret[] =& $obj;
+                        $ret[] = & $obj;
                     }
                 } else {
                     $row     = array();
@@ -284,20 +284,20 @@ 
      */
     public function getIds($criteria = null)
     {
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
         $limit = $start = 0;
 
         $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
-        $sql        = 'SELECT ' . $this->keyName . ' FROM ' . $this->table;
+        $sql        = 'SELECT '.$this->keyName.' FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             if ($criteria->groupby != '') {
                 $sql .= $criteria->getGroupby();
             }
             if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
             } elseif ($this->identifierName != '') {
-                $sql .= ' ORDER BY ' . $this->identifierName;
+                $sql .= ' ORDER BY '.$this->identifierName;
             }
             $limit = $criteria->getLimit();
             $start = $criteria->getStart();
@@ -327,26 +327,26 @@ 
      */
     public function getList($criteria = null)
     {
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
         $limit      = $start = 0;
         $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
 
         $ret = array();
 
-        $sql = 'SELECT ' . $this->keyName;
+        $sql = 'SELECT '.$this->keyName;
         if (!empty($this->identifierName)) {
-            $sql .= ', ' . $this->identifierName;
+            $sql .= ', '.$this->identifierName;
         }
-        $sql .= ' FROM ' . $this->table;
+        $sql .= ' FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             if ($criteria->groupby != '') {
                 $sql .= $criteria->getGroupby();
             }
             if ($criteria->getSort() != '') {
-                $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
+                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
             } elseif ($this->identifierName != '') {
-                $sql .= ' ORDER BY ' . $this->identifierName;
+                $sql .= ' ORDER BY '.$this->identifierName;
             }
             $limit = $criteria->getLimit();
             $start = $criteria->getStart();
@@ -387,7 +387,7 @@ 
         $ret = array();
         if (is_array($ids) && count($ids) > 0) {
             $criteria = new CriteriaCompo();
-            $criteria->add(new Criteria($this->keyName, '(' . implode(',', $ids) . ')', 'IN'));
+            $criteria->add(new Criteria($this->keyName, '('.implode(',', $ids).')', 'IN'));
             if (!is_null($additionnal)) {
                 $criteria->add($additionnal);
             }
@@ -408,17 +408,17 @@ 
         $field   = '';
         $groupby = false;
         $limit   = $start = 0;
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
 
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
             if ($criteria->groupby != '') {
                 $groupby = true;
-                $field   = $criteria->groupby . ', '; //Not entirely secure unless you KNOW that no criteria's groupby clause is going to be mis-used
+                $field   = $criteria->groupby.', '; //Not entirely secure unless you KNOW that no criteria's groupby clause is going to be mis-used
             }
         }
-        $sql = 'SELECT ' . $field . 'COUNT(*) FROM ' . $this->table;
+        $sql = 'SELECT '.$field.'COUNT(*) FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             if ($criteria->groupby != '') {
                 $sql .= $criteria->getGroupby();
             }
@@ -465,11 +465,11 @@ 
     public function getSum($field, $criteria = null)
     {
         $limit = $start = 0;
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
 
-        $sql = 'SELECT Sum(' . $field . ') as cpt FROM ' . $this->table;
+        $sql = 'SELECT Sum('.$field.') as cpt FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             if ($criteria->groupby != '') {
                 $sql .= $criteria->getGroupby();
             }
@@ -510,13 +510,13 @@ 
             $clause = array();
             $vnb    = count($this->keyName);
             for ($i = 0; $i < $vnb; ++$i) {
-                $clause[] = $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
+                $clause[] = $this->keyName[$i].' = '.$obj->getVar($this->keyName[$i]);
             }
             $whereclause = implode(' AND ', $clause);
         } else {
-            $whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
+            $whereclause = $this->keyName.' = '.$obj->getVar($this->keyName);
         }
-        $sql = 'DELETE FROM ' . $this->table . ' WHERE ' . $whereclause;
+        $sql = 'DELETE FROM '.$this->table.' WHERE '.$whereclause;
         if (false != $force) {
             $result = $this->db->queryF($sql);
         } else {
@@ -543,7 +543,7 @@ 
     {
         $object = $this->create(true);
         $object->setVars($vars);
-        $retval =& $this->insert($object, $force);
+        $retval = & $this->insert($object, $force);
         unset($object);
 
         // Clear cache
@@ -574,7 +574,7 @@ 
              * @TODO: Change to if (!(class_exists($this->className) && $obj instanceof $this->className)) when going fully PHP5
              */
             if (!is_a($obj, $this->className)) {
-                $obj->setErrors(get_class($obj) . ' Differs from ' . $this->className);
+                $obj->setErrors(get_class($obj).' Differs from '.$this->className);
 
                 return false;
             }
@@ -593,7 +593,7 @@ 
         }
         foreach ($obj->cleanVars as $k => $v) {
             if ($obj->vars[$k]['data_type'] == XOBJ_DTYPE_INT) {
-                $cleanvars[$k] = (int)$v;
+                $cleanvars[$k] = (int) $v;
             } elseif (is_array($v)) {
                 $cleanvars[$k] = $this->db->quoteString(implode(',', $v));
             } else {
@@ -606,16 +606,16 @@ 
         if ($obj->isNew()) {
             if (!is_array($this->keyName)) {
                 if ($cleanvars[$this->keyName] < 1) {
-                    $cleanvars[$this->keyName] = $this->db->genId($this->table . '_' . $this->keyName . '_seq');
+                    $cleanvars[$this->keyName] = $this->db->genId($this->table.'_'.$this->keyName.'_seq');
                 }
             }
             $ignore = '';
             if ($ignoreInsert) {
                 $ignore = 'IGNORE';
             }
-            $sql = "INSERT $ignore INTO " . $this->table . ' (' . implode(',', array_keys($cleanvars)) . ') VALUES (' . implode(',', array_values($cleanvars)) . ')';
+            $sql = "INSERT $ignore INTO ".$this->table.' ('.implode(',', array_keys($cleanvars)).') VALUES ('.implode(',', array_values($cleanvars)).')';
         } else {
-            $sql = 'UPDATE ' . $this->table . ' SET';
+            $sql = 'UPDATE '.$this->table.' SET';
             foreach ($cleanvars as $key => $value) {
                 if ((!is_array($this->keyName) && $key == $this->keyName) || (is_array($this->keyName) && in_array($key, $this->keyName))) {
                     continue;
@@ -623,7 +623,7 @@ 
                 if (isset($notfirst)) {
                     $sql .= ',';
                 }
-                $sql .= ' ' . $key . ' = ' . $value;
+                $sql .= ' '.$key.' = '.$value;
                 $notfirst = true;
             }
             if (is_array($this->keyName)) {
@@ -633,12 +633,12 @@ 
                     if ($i > 0) {
                         $whereclause .= ' AND ';
                     }
-                    $whereclause .= $this->keyName[$i] . ' = ' . $obj->getVar($this->keyName[$i]);
+                    $whereclause .= $this->keyName[$i].' = '.$obj->getVar($this->keyName[$i]);
                 }
             } else {
-                $whereclause = $this->keyName . ' = ' . $obj->getVar($this->keyName);
+                $whereclause = $this->keyName.' = '.$obj->getVar($this->keyName);
             }
-            $sql .= ' WHERE ' . $whereclause;
+            $sql .= ' WHERE '.$whereclause;
         }
 
         if (false != $force) {
@@ -672,7 +672,7 @@ 
      */
     public function updateAll($fieldname, $fieldvalue, $criteria = null, $force = false)
     {
-        $set_clause = $fieldname . ' = ';
+        $set_clause = $fieldname.' = ';
         if (is_numeric($fieldvalue)) {
             $set_clause .= $fieldvalue;
         } elseif (is_array($fieldvalue)) {
@@ -680,9 +680,9 @@ 
         } else {
             $set_clause .= $this->db->quoteString($fieldvalue);
         }
-        $sql = 'UPDATE ' . $this->table . ' SET ' . $set_clause;
+        $sql = 'UPDATE '.$this->table.' SET '.$set_clause;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
         }
         if ($force) {
             $result = $this->db->queryF($sql);
@@ -730,8 +730,8 @@ 
     public function deleteAll($criteria = null)
     {
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql = 'DELETE FROM ' . $this->table;
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql = 'DELETE FROM '.$this->table;
+            $sql .= ' '.$criteria->renderWhere();
             if (!$this->db->queryF($sql)) {
                 return false;
             }
@@ -777,15 +777,15 @@ 
      */
     public function getDistincts($field, $criteria = null, $format = 's')
     {
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
         $limit = $start = 0;
-        $sql   = 'SELECT ' . $this->keyName . ', ' . $field . ' FROM ' . $this->table;
+        $sql   = 'SELECT '.$this->keyName.', '.$field.' FROM '.$this->table;
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
-            $sql .= ' ' . $criteria->renderWhere();
+            $sql .= ' '.$criteria->renderWhere();
             $limit = $criteria->getLimit();
             $start = $criteria->getStart();
         }
-        $sql .= ' GROUP BY ' . $field . ' ORDER BY ' . $field;
+        $sql .= ' GROUP BY '.$field.' ORDER BY '.$field;
 
         $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
         $id         = $this->_getIdForCache($sql, $start, $limit);
@@ -843,7 +843,7 @@ 
      */
     public function forceCacheClean()
     {
-        require_once __DIR__ . '/lite.php';
+        require_once __DIR__.'/lite.php';
         $Cache_Lite = new references_Cache_Lite($this->cacheOptions);
         $Cache_Lite->clean();
     }