mambax7 / references

xoops_version.php

Indentation +38 added lines, -38 removed lines

@@ -46,8 +46,8 @@ 
 $modversion['min_xoops']           = '2.5.8';
 $modversion['min_admin']           = '1.2';
 $modversion['min_db']              = array(
-    'mysql'  => '5.0.7',
-    'mysqli' => '5.0.7'
+	'mysql'  => '5.0.7',
+	'mysqli' => '5.0.7'
 );
 
 // ****************************************************************************
@@ -102,13 +102,13 @@ 
  *                  $options[3] - min font size (px or %)
  */
 $modversion['blocks'][] = array(
-    'file'        => 'references_block_tag.php',
-    'name'        => _MI_REFERENCES_BNAME3,
-    'description' => 'Show tag cloud',
-    'show_func'   => 'references_tag_block_cloud_show',
-    'edit_func'   => 'references_tag_block_cloud_edit',
-    'options'     => '100|0|150|80',
-    'template'    => 'references_tag_block_cloud.tpl'
+	'file'        => 'references_block_tag.php',
+	'name'        => _MI_REFERENCES_BNAME3,
+	'description' => 'Show tag cloud',
+	'show_func'   => 'references_tag_block_cloud_show',
+	'edit_func'   => 'references_tag_block_cloud_edit',
+	'options'     => '100|0|150|80',
+	'template'    => 'references_tag_block_cloud.tpl'
 );
 
 /*
@@ -118,13 +118,13 @@ 
  *                  $options[2] - sort: a - alphabet; c - count; t - time
  */
 $modversion['blocks'][] = array(
-    'file'        => 'references_block_tag.php',
-    'name'        => _MI_REFERENCES_BNAME4,
-    'description' => 'Show top tags',
-    'show_func'   => 'references_tag_block_top_show',
-    'edit_func'   => 'references_tag_block_top_edit',
-    'options'     => '50|30|c',
-    'template'    => 'references_tag_block_top.tpl'
+	'file'        => 'references_block_tag.php',
+	'name'        => _MI_REFERENCES_BNAME4,
+	'description' => 'Show top tags',
+	'show_func'   => 'references_tag_block_top_show',
+	'edit_func'   => 'references_tag_block_top_edit',
+	'options'     => '50|30|c',
+	'template'    => 'references_tag_block_top.tpl'
 );
 
 // ****************************************************************************
@@ -161,9 +161,9 @@ 
 
 require_once XOOPS_ROOT_PATH . '/modules/references/class/references_utils.php';
 if (references_utils::getModuleOption('use_rss')) {
-    ++$cptm;
-    $modversion['sub'][$cptm]['name'] = _MI_REFERENCES_SMENU1;
-    $modversion['sub'][$cptm]['url']  = 'rss.php';
+	++$cptm;
+	$modversion['sub'][$cptm]['name'] = _MI_REFERENCES_SMENU1;
+	$modversion['sub'][$cptm]['url']  = 'rss.php';
 }
 
 // ****************************************************************************
@@ -204,16 +204,16 @@ 
  * Editor to use
  */
 if (!defined('REFERENCES_MAINTAIN')) {
-    ++$cpto;
-    $modversion['config'][$cpto]['name']        = 'form_options';
-    $modversion['config'][$cpto]['title']       = '_MI_REFERENCES_OPTION2';
-    $modversion['config'][$cpto]['description'] = '';
-    $modversion['config'][$cpto]['formtype']    = 'select';
-    $modversion['config'][$cpto]['valuetype']   = 'text';
-    $modversion['config'][$cpto]['default']     = 'dhtmltextarea';
-    xoops_load('xoopseditorhandler');
-    $editor_handler                         = XoopsEditorHandler::getInstance();
-    $modversion['config'][$cpto]['options'] = array_flip($editor_handler->getList());
+	++$cpto;
+	$modversion['config'][$cpto]['name']        = 'form_options';
+	$modversion['config'][$cpto]['title']       = '_MI_REFERENCES_OPTION2';
+	$modversion['config'][$cpto]['description'] = '';
+	$modversion['config'][$cpto]['formtype']    = 'select';
+	$modversion['config'][$cpto]['valuetype']   = 'text';
+	$modversion['config'][$cpto]['default']     = 'dhtmltextarea';
+	xoops_load('xoopseditorhandler');
+	$editor_handler                         = XoopsEditorHandler::getInstance();
+	$modversion['config'][$cpto]['options'] = array_flip($editor_handler->getList());
 }
 
 /**
@@ -370,8 +370,8 @@ 
 $modversion['config'][$cpto]['formtype']    = 'select';
 $modversion['config'][$cpto]['valuetype']   = 'text';
 $modversion['config'][$cpto]['options']     = array(
-    _MI_REFERENCES_SORT_DATE   => 'article_timestamp',
-    _MI_REFERENCES_SORT_WEIGHT => 'article_weight'
+	_MI_REFERENCES_SORT_DATE   => 'article_timestamp',
+	_MI_REFERENCES_SORT_WEIGHT => 'article_weight'
 );
 $modversion['config'][$cpto]['default']     = 'article_timestamp';
 
@@ -385,8 +385,8 @@ 
 $modversion['config'][$cpto]['formtype']    = 'select';
 $modversion['config'][$cpto]['valuetype']   = 'text';
 $modversion['config'][$cpto]['options']     = array(
-    _MI_REFERENCES_SORT_ASC  => 'ASC',
-    _MI_REFERENCES_SORT_DESC => 'DESC'
+	_MI_REFERENCES_SORT_ASC  => 'ASC',
+	_MI_REFERENCES_SORT_DESC => 'DESC'
 );
 $modversion['config'][$cpto]['default']     = 'DESC';
 
@@ -400,9 +400,9 @@ 
 $modversion['config'][$cpto]['formtype']    = 'select';
 $modversion['config'][$cpto]['valuetype']   = 'text';
 $modversion['config'][$cpto]['options']     = array(
-    _MI_REFERENCES_SORT_DATE   => 'article_timestamp',
-    _MI_REFERENCES_SORT_WEIGHT => 'article_weight',
-    _MI_REFERENCES_SORT_TITLE  => 'article_title'
+	_MI_REFERENCES_SORT_DATE   => 'article_timestamp',
+	_MI_REFERENCES_SORT_WEIGHT => 'article_weight',
+	_MI_REFERENCES_SORT_TITLE  => 'article_title'
 );
 $modversion['config'][$cpto]['default']     = 'article_weight';
 
@@ -416,8 +416,8 @@ 
 $modversion['config'][$cpto]['formtype']    = 'select';
 $modversion['config'][$cpto]['valuetype']   = 'text';
 $modversion['config'][$cpto]['options']     = array(
-    _MI_REFERENCES_SORT_ASC  => 'ASC',
-    _MI_REFERENCES_SORT_DESC => 'DESC'
+	_MI_REFERENCES_SORT_ASC  => 'ASC',
+	_MI_REFERENCES_SORT_DESC => 'DESC'
 );
 $modversion['config'][$cpto]['default']     = 'ASC';
 

include/common.php

Indentation +21 added lines, -21 removed lines

@@ -21,17 +21,17 @@ 
 defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined');
 
 if (!defined('REFERENCES_DIRNAME')) {
-    define('REFERENCES_DIRNAME', 'references');
-    define('REFERENCES_URL', XOOPS_URL . '/modules/' . REFERENCES_DIRNAME . '/');
-    define('REFERENCES_PATH', XOOPS_ROOT_PATH . '/modules/' . REFERENCES_DIRNAME . '/');
-    define('REFERENCES_IMAGES_URL', REFERENCES_URL . 'assets/images/');        // Les images du module (l'url)
-    define('REFERENCES_IMAGES_PATH', REFERENCES_PATH . 'assets/images/');    // Les images du module (le chemin)
-    define('REFERENCES_CLASS_PATH', REFERENCES_PATH . 'class/');
-    define('REFERENCES_PLUGINS_PATH', REFERENCES_PATH . 'plugins/');
-    define('REFERENCES_PLUGINS_URL', REFERENCES_URL . 'plugins/');
-    define('REFERENCES_JS_URL', REFERENCES_URL . 'js/');
-    define('REFERENCES_TEXTFILE1', 'references_index.tpl');
-    define('REFERENCES_PERM_READ', 'references_view');    // Nom de la permission de lire
+	define('REFERENCES_DIRNAME', 'references');
+	define('REFERENCES_URL', XOOPS_URL . '/modules/' . REFERENCES_DIRNAME . '/');
+	define('REFERENCES_PATH', XOOPS_ROOT_PATH . '/modules/' . REFERENCES_DIRNAME . '/');
+	define('REFERENCES_IMAGES_URL', REFERENCES_URL . 'assets/images/');        // Les images du module (l'url)
+	define('REFERENCES_IMAGES_PATH', REFERENCES_PATH . 'assets/images/');    // Les images du module (le chemin)
+	define('REFERENCES_CLASS_PATH', REFERENCES_PATH . 'class/');
+	define('REFERENCES_PLUGINS_PATH', REFERENCES_PATH . 'plugins/');
+	define('REFERENCES_PLUGINS_URL', REFERENCES_URL . 'plugins/');
+	define('REFERENCES_JS_URL', REFERENCES_URL . 'js/');
+	define('REFERENCES_TEXTFILE1', 'references_index.tpl');
+	define('REFERENCES_PERM_READ', 'references_view');    // Nom de la permission de lire
 }
 
 // Chargement des handler et des autres classes
@@ -55,15 +55,15 @@ 
 
 // Définition des images
 if (!defined('_REFERENCES_EDIT')) {
-    global $xoopsConfig;
-    if (isset($xoopsConfig) && file_exists(REFERENCES_PATH . 'language/' . $xoopsConfig['language'] . '/main.php')) {
-        require REFERENCES_PATH . 'language/' . $xoopsConfig['language'] . '/main.php';
-    } else {
-        require REFERENCES_PATH . 'language/english/main.php';
-    }
+	global $xoopsConfig;
+	if (isset($xoopsConfig) && file_exists(REFERENCES_PATH . 'language/' . $xoopsConfig['language'] . '/main.php')) {
+		require REFERENCES_PATH . 'language/' . $xoopsConfig['language'] . '/main.php';
+	} else {
+		require REFERENCES_PATH . 'language/english/main.php';
+	}
 
-    $icones = array(
-        'edit'   => "<img src='" . REFERENCES_IMAGES_URL . "edit.gif' alt='" . _REFERENCES_EDIT . "' align='middle' />",
-        'delete' => "<img src='" . REFERENCES_IMAGES_URL . "delete.gif' alt='" . _REFERENCES_DELETE . "' align='middle' />"
-    );
+	$icones = array(
+		'edit'   => "<img src='" . REFERENCES_IMAGES_URL . "edit.gif' alt='" . _REFERENCES_EDIT . "' align='middle' />",
+		'delete' => "<img src='" . REFERENCES_IMAGES_URL . "delete.gif' alt='" . _REFERENCES_DELETE . "' align='middle' />"
+	);
 }

include/search.inc.php

Indentation +57 added lines, -57 removed lines

@@ -22,66 +22,66 @@
 
 function references_search($queryarray, $andor, $limit, $offset, $userid)
 {
-    global $xoopsDB;
-    include XOOPS_ROOT_PATH . '/modules/references/include/common.php';
+	global $xoopsDB;
+	include XOOPS_ROOT_PATH . '/modules/references/include/common.php';
 
-    // Recherche dans les articles
-    $sql = 'SELECT article_id, article_title, article_text, article_timestamp, article_author FROM ' . $xoopsDB->prefix('references_articles') . ' WHERE (article_online = ' . REFERENCES_STATUS_ONLINE . ')';
-    // Permissions
-    $handlers    = references_handler::getInstance();
-    $permissions = $handlers->h_references_articles->getPermissionsCategoriesCriteria()->renderWhere();
-    $sql .= ' AND (' . trim(str_replace('WHERE ', '', $permissions)) . ')';
-    // *****
+	// Recherche dans les articles
+	$sql = 'SELECT article_id, article_title, article_text, article_timestamp, article_author FROM ' . $xoopsDB->prefix('references_articles') . ' WHERE (article_online = ' . REFERENCES_STATUS_ONLINE . ')';
+	// Permissions
+	$handlers    = references_handler::getInstance();
+	$permissions = $handlers->h_references_articles->getPermissionsCategoriesCriteria()->renderWhere();
+	$sql .= ' AND (' . trim(str_replace('WHERE ', '', $permissions)) . ')';
+	// *****
 
-    // Auteur
-    if ($userid != 0) {
-        $sql .= ' AND (article_author = ' . $userid . ') ';
-    }
+	// Auteur
+	if ($userid != 0) {
+		$sql .= ' AND (article_author = ' . $userid . ') ';
+	}
 
-    $tmpObject = new references_articles();
-    $datas     = $tmpObject->getVars();
-    $tblFields = array();
-    $cnt       = 0;
-    foreach ($datas as $key => $value) {
-        if ($value['data_type'] == XOBJ_DTYPE_TXTBOX || $value['data_type'] == XOBJ_DTYPE_TXTAREA) {
-            if ($cnt == 0) {
-                $tblFields[] = $key;
-            } else {
-                $tblFields[] = ' OR ' . $key;
-            }
-            ++$cnt;
-        }
-    }
+	$tmpObject = new references_articles();
+	$datas     = $tmpObject->getVars();
+	$tblFields = array();
+	$cnt       = 0;
+	foreach ($datas as $key => $value) {
+		if ($value['data_type'] == XOBJ_DTYPE_TXTBOX || $value['data_type'] == XOBJ_DTYPE_TXTAREA) {
+			if ($cnt == 0) {
+				$tblFields[] = $key;
+			} else {
+				$tblFields[] = ' OR ' . $key;
+			}
+			++$cnt;
+		}
+	}
 
-    $count = count($queryarray);
-    $more  = '';
-    if (is_array($queryarray) && $count > 0) {
-        $cnt = 0;
-        $sql .= ' AND (';
-        $more = ')';
-        foreach ($queryarray as $oneQuery) {
-            $sql .= '(';
-            $cond = " LIKE '%" . $oneQuery . "%' ";
-            $sql .= implode($cond, $tblFields) . $cond . ')';
-            ++$cnt;
-            if ($cnt != $count) {
-                $sql .= ' ' . $andor . ' ';
-            }
-        }
-    }
-    $sql .= $more . ' ORDER BY article_timestamp DESC';
-    $i      = 0;
-    $ret    = array();
-    $myts   = MyTextSanitizer::getInstance();
-    $result = $xoopsDB->query($sql, $limit, $offset);
-    while ($myrow = $xoopsDB->fetchArray($result)) {
-        $ret[$i]['image'] = 'assets/images/newspaper.png';
-        $ret[$i]['link']  = REFERENCES_URL . 'reference.php?article_id=' . $myrow['article_id'];
-        $ret[$i]['title'] = $myts->htmlSpecialChars($myrow['article_title']);
-        $ret[$i]['time']  = $myrow['article_timestamp'];
-        $ret[$i]['uid']   = $myrow['article_author'];
-        ++$i;
-    }
+	$count = count($queryarray);
+	$more  = '';
+	if (is_array($queryarray) && $count > 0) {
+		$cnt = 0;
+		$sql .= ' AND (';
+		$more = ')';
+		foreach ($queryarray as $oneQuery) {
+			$sql .= '(';
+			$cond = " LIKE '%" . $oneQuery . "%' ";
+			$sql .= implode($cond, $tblFields) . $cond . ')';
+			++$cnt;
+			if ($cnt != $count) {
+				$sql .= ' ' . $andor . ' ';
+			}
+		}
+	}
+	$sql .= $more . ' ORDER BY article_timestamp DESC';
+	$i      = 0;
+	$ret    = array();
+	$myts   = MyTextSanitizer::getInstance();
+	$result = $xoopsDB->query($sql, $limit, $offset);
+	while ($myrow = $xoopsDB->fetchArray($result)) {
+		$ret[$i]['image'] = 'assets/images/newspaper.png';
+		$ret[$i]['link']  = REFERENCES_URL . 'reference.php?article_id=' . $myrow['article_id'];
+		$ret[$i]['title'] = $myts->htmlSpecialChars($myrow['article_title']);
+		$ret[$i]['time']  = $myrow['article_timestamp'];
+		$ret[$i]['uid']   = $myrow['article_author'];
+		++$i;
+	}
 
-    return $ret;
+	return $ret;
 }

plugins/actions/twitter/plugins.php

Indentation +104 added lines, -104 removed lines

@@ -28,111 +28,111 @@
  */
 class referencesTwitterAction extends references_action
 {
-    public function registerEvents()
-    {
-        /**
-         * La liste des évènements traités par le plugin se présente sous la forme d'un tableau compposé comme ceci :
-         *
-         * Indice    Signification
-         * ----------------------
-         *    0        Evènement sur lequel se raccrocher (voir class/references_plugins.php::EVENT_ON_PRODUCT_CREATE
-         *    1        Priorité du plugin (de 1 à 5)
-         *    2        Script Php à inclure
-         *    3        Classe à instancier
-         *    4        Méthode à appeler
-         */
-        $events   = array();
-        $events[] = array(
-            references_plugins::EVENT_ON_REFERENCE_CREATE,
-            references_plugins::EVENT_PRIORITY_1,
-            basename(__FILE__),
-            __CLASS__,
-            'fireNewReference'
-        );
-        $events[] = array(
-            references_plugins::EVENT_ON_CATEGORY_CREATE,
-            references_plugins::EVENT_PRIORITY_1,
-            basename(__FILE__),
-            __CLASS__,
-            'fireNewCategory'
-        );
-        return $events;
-    }
+	public function registerEvents()
+	{
+		/**
+		 * La liste des évènements traités par le plugin se présente sous la forme d'un tableau compposé comme ceci :
+		 *
+		 * Indice    Signification
+		 * ----------------------
+		 *    0        Evènement sur lequel se raccrocher (voir class/references_plugins.php::EVENT_ON_PRODUCT_CREATE
+		 *    1        Priorité du plugin (de 1 à 5)
+		 *    2        Script Php à inclure
+		 *    3        Classe à instancier
+		 *    4        Méthode à appeler
+		 */
+		$events   = array();
+		$events[] = array(
+			references_plugins::EVENT_ON_REFERENCE_CREATE,
+			references_plugins::EVENT_PRIORITY_1,
+			basename(__FILE__),
+			__CLASS__,
+			'fireNewReference'
+		);
+		$events[] = array(
+			references_plugins::EVENT_ON_CATEGORY_CREATE,
+			references_plugins::EVENT_PRIORITY_1,
+			basename(__FILE__),
+			__CLASS__,
+			'fireNewCategory'
+		);
+		return $events;
+	}
 
-    /**
-     * Méthode générique chargée d'envoyer un texte sur un compte twitter avec une url
-     *
-     * @param string $textToSend Le texte à envoyer
-     * @param string $mask       Le masque à utiliser
-     * @param string $elementUrl L'url de l'élément concerné
-     * @return string                Le texte qui a été envoyé à twitter
-     */
-    private function sendTextToTwitter($textToSend, $mask, $elementUrl)
-    {
-        if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
-            define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
-        }
-        require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
-        //require_once REFERENCES_TWITTER_PLUGIN_PATH.'twitter.php';
-        require_once REFERENCES_TWITTER_PLUGIN_PATH . 'Twitter.class.php';
-        require_once REFERENCES_TWITTER_PLUGIN_PATH . 'bitly.class.php';
-        if (REFERENCES_BITLY_LOGIN == '') {
-            return '';
-        }
-        $sentText    = '';
-        $bitly       = new Bitly(REFERENCES_BITLY_LOGIN, REFERENCES_BITLY_API_KEY);
-        $shortUrl    = $bitly->shortenSingle($elementUrl);
-        $searches    = array('[itemname]', '[url]');
-        $replaces    = array($textToSend, $shortUrl);
-        $sentText    = str_replace($searches, $replaces, $mask);
-        $totalLength = strlen($sentText);
-        if ($totalLength > REFERENCES_TWITTER_TWIT_MAX_LENGTH) {
-            $tooLongOf = $totalLength - REFERENCES_TWITTER_TWIT_MAX_LENGTH;
-            $searches  = array('[itemname]', '[url]');
-            $replaces  = array(substr($textToSend, 0, strlen($textToSend) - $tooLongOf), $shortUrl);
-            $sentText  = str_replace($searches, $replaces, $mask);
-        }
-        if (trim($sentText) != '') {
-            //          $twitter = new Twitter(REFERENCES_TWITTER_USERNAME, REFERENCES_TWITTER_PASSWORD);
-            //          $twitter->setUserAgent('references');
-            //          $twitter->updateStatus($sentText);
-            $tweet = new Twitter(REFERENCES_TWITTER_USERNAME, REFERENCES_TWITTER_PASSWORD);
-            $tweet->update($sentText);
-        }
-        return $sentText;
-    }
+	/**
+	 * Méthode générique chargée d'envoyer un texte sur un compte twitter avec une url
+	 *
+	 * @param string $textToSend Le texte à envoyer
+	 * @param string $mask       Le masque à utiliser
+	 * @param string $elementUrl L'url de l'élément concerné
+	 * @return string                Le texte qui a été envoyé à twitter
+	 */
+	private function sendTextToTwitter($textToSend, $mask, $elementUrl)
+	{
+		if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
+			define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
+		}
+		require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
+		//require_once REFERENCES_TWITTER_PLUGIN_PATH.'twitter.php';
+		require_once REFERENCES_TWITTER_PLUGIN_PATH . 'Twitter.class.php';
+		require_once REFERENCES_TWITTER_PLUGIN_PATH . 'bitly.class.php';
+		if (REFERENCES_BITLY_LOGIN == '') {
+			return '';
+		}
+		$sentText    = '';
+		$bitly       = new Bitly(REFERENCES_BITLY_LOGIN, REFERENCES_BITLY_API_KEY);
+		$shortUrl    = $bitly->shortenSingle($elementUrl);
+		$searches    = array('[itemname]', '[url]');
+		$replaces    = array($textToSend, $shortUrl);
+		$sentText    = str_replace($searches, $replaces, $mask);
+		$totalLength = strlen($sentText);
+		if ($totalLength > REFERENCES_TWITTER_TWIT_MAX_LENGTH) {
+			$tooLongOf = $totalLength - REFERENCES_TWITTER_TWIT_MAX_LENGTH;
+			$searches  = array('[itemname]', '[url]');
+			$replaces  = array(substr($textToSend, 0, strlen($textToSend) - $tooLongOf), $shortUrl);
+			$sentText  = str_replace($searches, $replaces, $mask);
+		}
+		if (trim($sentText) != '') {
+			//          $twitter = new Twitter(REFERENCES_TWITTER_USERNAME, REFERENCES_TWITTER_PASSWORD);
+			//          $twitter->setUserAgent('references');
+			//          $twitter->updateStatus($sentText);
+			$tweet = new Twitter(REFERENCES_TWITTER_USERNAME, REFERENCES_TWITTER_PASSWORD);
+			$tweet->update($sentText);
+		}
+		return $sentText;
+	}
 
-    /**
-     * Méthode appelée pour indiquer qu'une nouvelle référence a été publié
-     *
-     * @param object $parameters La référence qui vient d'être publiée
-     * @return void
-     */
-    public function fireNewReference($parameters)
-    {
-        if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
-            define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
-        }
-        require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
-        $reference = $parameters['reference'];
-        $this->sendTextToTwitter(utf8_encode($reference->getVar('article_title', 'n')), utf8_encode(REFERENCES_TWITTER_NEW_REFERENCE_INTRO), $reference->getUrl());
-    }
+	/**
+	 * Méthode appelée pour indiquer qu'une nouvelle référence a été publié
+	 *
+	 * @param object $parameters La référence qui vient d'être publiée
+	 * @return void
+	 */
+	public function fireNewReference($parameters)
+	{
+		if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
+			define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
+		}
+		require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
+		$reference = $parameters['reference'];
+		$this->sendTextToTwitter(utf8_encode($reference->getVar('article_title', 'n')), utf8_encode(REFERENCES_TWITTER_NEW_REFERENCE_INTRO), $reference->getUrl());
+	}
 
-    /**
-     * Méthode appelée pour indiquer qu'une nouvelle catégorie de références a été créée
-     *
-     * @param object $parameters La catégorie qui vient d'être publiée
-     * @return void
-     */
-    public function fireNewCategory($parameters)
-    {
-        if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
-            define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
-        }
-        require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
-        if (trim(REFERENCES_TWITTER_NEW_CATEGORY_INTRO) != '') {
-            $category = $parameters['category'];
-            $this->sendTextToTwitter(utf8_encode($category->getVar('category_title', 'n')), utf8_encode(REFERENCES_TWITTER_NEW_CATEGORY_INTRO), $category->getUrl());
-        }
-    }
+	/**
+	 * Méthode appelée pour indiquer qu'une nouvelle catégorie de références a été créée
+	 *
+	 * @param object $parameters La catégorie qui vient d'être publiée
+	 * @return void
+	 */
+	public function fireNewCategory($parameters)
+	{
+		if (!defined('REFERENCES_TWITTER_PLUGIN_PATH')) {
+			define('REFERENCES_TWITTER_PLUGIN_PATH', REFERENCES_PLUGINS_PATH . 'actions' . DIRECTORY_SEPARATOR . 'twitter' . DIRECTORY_SEPARATOR);
+		}
+		require_once REFERENCES_TWITTER_PLUGIN_PATH . 'config.php';
+		if (trim(REFERENCES_TWITTER_NEW_CATEGORY_INTRO) != '') {
+			$category = $parameters['category'];
+			$this->sendTextToTwitter(utf8_encode($category->getVar('category_title', 'n')), utf8_encode(REFERENCES_TWITTER_NEW_CATEGORY_INTRO), $category->getUrl());
+		}
+	}
 }

plugins/models/references_filter.php

Indentation +5 added lines, -5 removed lines

@@ -26,9 +26,9 @@
 
 abstract class references_filter
 {
-    /**
-     * Retourne la liste des évènements traités par le plugin
-     * @return array
-     */
-    abstract public function registerEvents();
+	/**
+	 * Retourne la liste des évènements traités par le plugin
+	 * @return array
+	 */
+	abstract public function registerEvents();
 }

class/references_articles.php

Indentation +603 added lines, -603 removed lines

@@ -22,7 +22,7 @@ 
 
 require_once XOOPS_ROOT_PATH . '/kernel/object.php';
 if (!class_exists('references_XoopsPersistableObjectHandler')) {
-    require_once XOOPS_ROOT_PATH . '/modules/references/class/PersistableObjectHandler.php';
+	require_once XOOPS_ROOT_PATH . '/modules/references/class/PersistableObjectHandler.php';
 }
 
 define('REFERENCES_STATUS_ONLINE', 1);    // Articles en ligne
@@ -30,610 +30,610 @@ 
 
 class references_articles extends references_Object
 {
-    public function __construct()
-    {
-        $this->initVar('article_id', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_category_id', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_timestamp', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_weight', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_date', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_title', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_text', XOBJ_DTYPE_TXTAREA, null, false);
-        $this->initVar('article_externalurl', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture1', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture1_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture2', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture2_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture3', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture3_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture4', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture4_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture5', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture5_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture6', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture6_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture7', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture7_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture8', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture8_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture9', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture9_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture10', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_picture10_text', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_author', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_online', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('article_attached_file', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('article_readmore', XOBJ_DTYPE_TXTAREA, null, false);
-
-        // Pour autoriser le html
-        $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false);
-    }
-
-    /**
-     * Indique si l'article en cours est visible
-     *
-     * @return boolean
-     */
-    public function isArticleOnline()
-    {
-        return $this->getVar('article_online') == REFERENCES_STATUS_ONLINE ? true : false;
-    }
-
-    /**
-     * Retourne une image qui indique si l'article est en ligne ou pas
-     *
-     * @return string
-     */
-    public function getOnlinePicture()
-    {
-        if ($this->isArticleOnline()) {
-            return REFERENCES_IMAGES_URL . 'status_online.png';
-        } else {
-            return REFERENCES_IMAGES_URL . 'status_offline.png';
-        }
-    }
-
-    /**
-     * Retourne la chaine de caractères qui peut être utilisée dans l'attribut href d'une balise html A.
-     *
-     * @return string
-     */
-    public function getHrefTitle()
-    {
-        return references_utils::makeHrefTitle($this->getVar('article_title'));
-    }
-
-    /**
-     * Indique si une image de l'article existe
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return boolean Vrai si l'image existe sinon faux
-     */
-    public function pictureExists($indice)
-    {
-        $return    = false;
-        $fieldName = 'article_picture' . $indice;
-        if (xoops_trim($this->getVar($fieldName)) != '' && file_exists(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . $this->getVar($fieldName))) {
-            $return = true;
-        }
-
-        return $return;
-    }
-
-    /**
-     * Supprime l'image associée à un article
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return void
-     */
-    public function deletePicture($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if ($this->pictureExists($indice)) {
-            @unlink(references_utils::getModuleOption('images_path') . references_utils::getModuleOption('images_path') . $this->getVar($fieldName));
-        }
-        $this->setVar($fieldName, '');
-    }
-
-    /**
-     * Retourne l'URL de l'image de l'article courant
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return string  L'URL
-     */
-    public function getPictureUrl($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if (xoops_trim($this->getVar($fieldName)) != '' && $this->pictureExists($indice)) {
-            return references_utils::getModuleOption('images_url') . '/' . $this->getVar($fieldName);
-        } else {
-            return REFERENCES_IMAGES_URL . 'blank.gif';
-        }
-    }
-
-    /**
-     * Retourne le chemin de l'image de l'article courante
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return string  Le chemin
-     */
-    public function getPicturePath($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if (xoops_trim($this->getVar($fieldName)) != '') {
-            return references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . $this->getVar($fieldName);
-        } else {
-            return '';
-        }
-    }
-
-    /**
-     * Indique si la vignette de l'image de l'article existe
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return boolean Vrai si l'image existe sinon faux
-     */
-    public function thumbExists($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        $return    = false;
-        if (xoops_trim($this->getVar($fieldName)) != '' && file_exists(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName))) {
-            $return = true;
-        }
-
-        return $return;
-    }
-
-    /**
-     * Retourne l'URL de la vignette de l'article
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return string  L'URL
-     */
-    public function getThumbUrl($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if (xoops_trim($this->getVar($fieldName)) != '') {
-            return references_utils::getModuleOption('images_url') . '/' . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName);
-        } else {
-            return REFERENCES_IMAGES_URL . 'blank.gif';
-        }
-    }
-
-    /**
-     * Retourne le chemin de la vignette de l'annonce
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return string  L'URL
-     */
-    public function getThumbPath($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if (xoops_trim($this->getVar($fieldName)) != '') {
-            return references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName);
-        } else {
-            return '';
-        }
-    }
-
-    /**
-     * Indique si le fichier attaché à un article existe
-     *
-     * @return boolean
-     */
-    public function attachmentExists()
-    {
-        $return = false;
-        if (xoops_trim($this->getVar('article_attached_file')) != '' && file_exists(references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file'))) {
-            $return = true;
-        }
-
-        return $return;
-    }
-
-    /**
-     * Retourne l'URL du fichier attaché
-     *
-     * @return string    L'url du fichier attaché sinon une chaine vide
-     */
-    public function getAttachmentUrl()
-    {
-        if (xoops_trim($this->getVar('article_attached_file')) != '' && $this->attachmentExists()) {
-            return references_utils::getModuleOption('attached_url') . '/' . $this->getVar('article_attached_file');
-        } else {
-            return '';
-        }
-    }
-
-    /**
-     * Retourne le chemin du fichier attaché
-     *
-     * @return string    Le chemin du fichier attaché sinon une chaine vide
-     */
-    public function getAttachmentPath()
-    {
-        if (xoops_trim($this->getVar('article_attached_file')) != '' && $this->attachmentExists()) {
-            return references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file');
-        } else {
-            return '';
-        }
-    }
-
-    /**
-     * Supprime le fichier attaché à un article
-     */
-    public function deleteAttachment()
-    {
-        if ($this->attachmentExists()) {
-            @unlink(references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file'));
-        }
-        $this->setVar('article_attached_file', '');
-    }
-
-    /**
-     * Supprime la miniature associée à l'article
-     *
-     * @param integer $indice L'indice de l'image recherchée
-     * @return void
-     */
-    public function deleteThumb($indice)
-    {
-        $fieldName = 'article_picture' . $indice;
-        if ($this->thumbExists($indice)) {
-            @unlink(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName));
-        }
-    }
-
-    /**
-     * Supprime l'image (et vignette) d'un article (raccourcis)
-     *
-     * @return void
-     */
-    public function deletePicturesAndThumbs()
-    {
-        for ($i = 1; $i <= 10; ++$i) {
-            $this->deleteThumb($i);
-            $this->deletePicture($i);
-        }
-    }
-
-    /**
-     * Retourne le timestamp de création formaté
-     *
-     * @return string
-     */
-    public function getFormatedTimeStamp()
-    {
-        return formatTimestamp($this->getVar('article_timestamp'), 's');
-    }
-
-    /**
-     * Indique s'il existe au moins une image pour l'article
-     *
-     * @return boolean
-     */
-    public function isThereAPicture()
-    {
-        for ($i = 1; $i <= 10; ++$i) {
-            if ($this->pictureExists($i)) {
-                return true;
-            }
-        }
-
-        return false;
-    }
-
-    /**
-     * Inidique s'il existe au moins une vignette pour l'article
-     *
-     * @return boolean
-     */
-    public function isThereAThumb()
-    {
-        for ($i = 1; $i <= 10; ++$i) {
-            if ($this->thumbExists($i)) {
-                return true;
-            }
-        }
-
-        return false;
-    }
-
-    /**
-     * Retourne l'url pour atteindre l'élément
-     *
-     * @param bool $shortVersion
-     * @return string
-     */
-    public function getUrl($shortVersion = false)
-    {
-        if (!$shortVersion) {
-            return REFERENCES_URL . 'reference.php?article_id=' . $this->getVar('article_id');
-        } else {
-            return 'reference.php?article_id=' . $this->getVar('article_id');
-        }
-    }
-
-    /**
-     * Retourne les éléments de l'annnonce formatés pour affichage
-     *
-     * @param string $format Format à utiliser
-     * @return array
-     */
-    public function toArray($format = 's')
-    {
-        $ret                       = array();
-        $ret                       = parent::toArray($format);
-        $hrefTitle                 = $this->getHrefTitle();
-        $ret['article_href_title'] = $hrefTitle;
-        $ret['article_url']        = $this->getUrl();
-        // Indique si une annonce est expirée
-        $ret['article_is_online'] = $this->isArticleOnline();
-        if ($this->isThereAPicture()) {
-            $ret['article_picture_exists'] = true;
-            for ($i = 1; $i <= 10; ++$i) {
-                if ($this->pictureExists($i)) {
-                    $ret['article_picture_url' . $i]  = $this->getPictureUrl($i);
-                    $ret['article_picture_path' . $i] = $this->getPicturePath($i);
-                    $ret['article_pictures_urls'][]   = $this->getPictureUrl($i);
-                    $ret['article_pictures_paths'][]  = $this->getPicturePath($i);
-                    $fieldName                        = 'article_picture' . $i . '_text';
-                    if (xoops_trim($this->getVar($fieldName)) != '') {
-                        $ret['article_pictures_texts'][] = references_utils::makeHrefTitle($this->getVar($fieldName));
-                    } else {
-                        $ret['article_pictures_texts'][] = $hrefTitle;
-                    }
-                }
-            }
-        } else {
-            $ret['article_picture_exists'] = false;
-        }
-        $ret['article_short_text'] = references_utils::truncate_tagsafe($this->getVar('article_text'), REFERENCES_SHORTEN_TEXT);
-
-        if ($this->attachmentExists()) {
-            $ret['article_attachment_exists'] = true;
-            $ret['article_attachment_url']    = $this->getAttachmentUrl();
-            $ret['article_attachment_path']   = $this->getAttachmentPath();
-        } else {
-            $ret['attachment_exists'] = false;
-        }
-
-        if ($this->isThereAThumb()) {
-            $ret['article_thumb_exists'] = true;
-            for ($i = 1; $i <= 10; ++$i) {
-                if ($this->thumbExists($i)) {
-                    $ret['article_thumb_url' . $i]  = $this->getThumbUrl($i);
-                    $ret['article_thumb_path' . $i] = $this->getThumbPath($i);
-                    $ret['article_thumbs_urls'][]   = $this->getThumbUrl($i);
-                    $ret['article_thumbs_paths'][]  = $this->getThumbPath($i);
-                }
-            }
-        } else {
-            $ret['article_thumb_exists'] = false;
-        }
-
-        $ret['article_timestamp_formated'] = $this->getFormatedTimeStamp();
-
-        return $ret;
-    }
+	public function __construct()
+	{
+		$this->initVar('article_id', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_category_id', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_timestamp', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_weight', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_date', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_title', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_text', XOBJ_DTYPE_TXTAREA, null, false);
+		$this->initVar('article_externalurl', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture1', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture1_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture2', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture2_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture3', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture3_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture4', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture4_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture5', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture5_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture6', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture6_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture7', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture7_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture8', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture8_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture9', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture9_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture10', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_picture10_text', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_author', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_online', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('article_attached_file', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('article_readmore', XOBJ_DTYPE_TXTAREA, null, false);
+
+		// Pour autoriser le html
+		$this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false);
+	}
+
+	/**
+	 * Indique si l'article en cours est visible
+	 *
+	 * @return boolean
+	 */
+	public function isArticleOnline()
+	{
+		return $this->getVar('article_online') == REFERENCES_STATUS_ONLINE ? true : false;
+	}
+
+	/**
+	 * Retourne une image qui indique si l'article est en ligne ou pas
+	 *
+	 * @return string
+	 */
+	public function getOnlinePicture()
+	{
+		if ($this->isArticleOnline()) {
+			return REFERENCES_IMAGES_URL . 'status_online.png';
+		} else {
+			return REFERENCES_IMAGES_URL . 'status_offline.png';
+		}
+	}
+
+	/**
+	 * Retourne la chaine de caractères qui peut être utilisée dans l'attribut href d'une balise html A.
+	 *
+	 * @return string
+	 */
+	public function getHrefTitle()
+	{
+		return references_utils::makeHrefTitle($this->getVar('article_title'));
+	}
+
+	/**
+	 * Indique si une image de l'article existe
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return boolean Vrai si l'image existe sinon faux
+	 */
+	public function pictureExists($indice)
+	{
+		$return    = false;
+		$fieldName = 'article_picture' . $indice;
+		if (xoops_trim($this->getVar($fieldName)) != '' && file_exists(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . $this->getVar($fieldName))) {
+			$return = true;
+		}
+
+		return $return;
+	}
+
+	/**
+	 * Supprime l'image associée à un article
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return void
+	 */
+	public function deletePicture($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if ($this->pictureExists($indice)) {
+			@unlink(references_utils::getModuleOption('images_path') . references_utils::getModuleOption('images_path') . $this->getVar($fieldName));
+		}
+		$this->setVar($fieldName, '');
+	}
+
+	/**
+	 * Retourne l'URL de l'image de l'article courant
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return string  L'URL
+	 */
+	public function getPictureUrl($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if (xoops_trim($this->getVar($fieldName)) != '' && $this->pictureExists($indice)) {
+			return references_utils::getModuleOption('images_url') . '/' . $this->getVar($fieldName);
+		} else {
+			return REFERENCES_IMAGES_URL . 'blank.gif';
+		}
+	}
+
+	/**
+	 * Retourne le chemin de l'image de l'article courante
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return string  Le chemin
+	 */
+	public function getPicturePath($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if (xoops_trim($this->getVar($fieldName)) != '') {
+			return references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . $this->getVar($fieldName);
+		} else {
+			return '';
+		}
+	}
+
+	/**
+	 * Indique si la vignette de l'image de l'article existe
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return boolean Vrai si l'image existe sinon faux
+	 */
+	public function thumbExists($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		$return    = false;
+		if (xoops_trim($this->getVar($fieldName)) != '' && file_exists(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName))) {
+			$return = true;
+		}
+
+		return $return;
+	}
+
+	/**
+	 * Retourne l'URL de la vignette de l'article
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return string  L'URL
+	 */
+	public function getThumbUrl($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if (xoops_trim($this->getVar($fieldName)) != '') {
+			return references_utils::getModuleOption('images_url') . '/' . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName);
+		} else {
+			return REFERENCES_IMAGES_URL . 'blank.gif';
+		}
+	}
+
+	/**
+	 * Retourne le chemin de la vignette de l'annonce
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return string  L'URL
+	 */
+	public function getThumbPath($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if (xoops_trim($this->getVar($fieldName)) != '') {
+			return references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName);
+		} else {
+			return '';
+		}
+	}
+
+	/**
+	 * Indique si le fichier attaché à un article existe
+	 *
+	 * @return boolean
+	 */
+	public function attachmentExists()
+	{
+		$return = false;
+		if (xoops_trim($this->getVar('article_attached_file')) != '' && file_exists(references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file'))) {
+			$return = true;
+		}
+
+		return $return;
+	}
+
+	/**
+	 * Retourne l'URL du fichier attaché
+	 *
+	 * @return string    L'url du fichier attaché sinon une chaine vide
+	 */
+	public function getAttachmentUrl()
+	{
+		if (xoops_trim($this->getVar('article_attached_file')) != '' && $this->attachmentExists()) {
+			return references_utils::getModuleOption('attached_url') . '/' . $this->getVar('article_attached_file');
+		} else {
+			return '';
+		}
+	}
+
+	/**
+	 * Retourne le chemin du fichier attaché
+	 *
+	 * @return string    Le chemin du fichier attaché sinon une chaine vide
+	 */
+	public function getAttachmentPath()
+	{
+		if (xoops_trim($this->getVar('article_attached_file')) != '' && $this->attachmentExists()) {
+			return references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file');
+		} else {
+			return '';
+		}
+	}
+
+	/**
+	 * Supprime le fichier attaché à un article
+	 */
+	public function deleteAttachment()
+	{
+		if ($this->attachmentExists()) {
+			@unlink(references_utils::getModuleOption('attached_path') . DIRECTORY_SEPARATOR . $this->getVar('article_attached_file'));
+		}
+		$this->setVar('article_attached_file', '');
+	}
+
+	/**
+	 * Supprime la miniature associée à l'article
+	 *
+	 * @param integer $indice L'indice de l'image recherchée
+	 * @return void
+	 */
+	public function deleteThumb($indice)
+	{
+		$fieldName = 'article_picture' . $indice;
+		if ($this->thumbExists($indice)) {
+			@unlink(references_utils::getModuleOption('images_path') . DIRECTORY_SEPARATOR . REFERENCES_THUMBS_PREFIX . $this->getVar($fieldName));
+		}
+	}
+
+	/**
+	 * Supprime l'image (et vignette) d'un article (raccourcis)
+	 *
+	 * @return void
+	 */
+	public function deletePicturesAndThumbs()
+	{
+		for ($i = 1; $i <= 10; ++$i) {
+			$this->deleteThumb($i);
+			$this->deletePicture($i);
+		}
+	}
+
+	/**
+	 * Retourne le timestamp de création formaté
+	 *
+	 * @return string
+	 */
+	public function getFormatedTimeStamp()
+	{
+		return formatTimestamp($this->getVar('article_timestamp'), 's');
+	}
+
+	/**
+	 * Indique s'il existe au moins une image pour l'article
+	 *
+	 * @return boolean
+	 */
+	public function isThereAPicture()
+	{
+		for ($i = 1; $i <= 10; ++$i) {
+			if ($this->pictureExists($i)) {
+				return true;
+			}
+		}
+
+		return false;
+	}
+
+	/**
+	 * Inidique s'il existe au moins une vignette pour l'article
+	 *
+	 * @return boolean
+	 */
+	public function isThereAThumb()
+	{
+		for ($i = 1; $i <= 10; ++$i) {
+			if ($this->thumbExists($i)) {
+				return true;
+			}
+		}
+
+		return false;
+	}
+
+	/**
+	 * Retourne l'url pour atteindre l'élément
+	 *
+	 * @param bool $shortVersion
+	 * @return string
+	 */
+	public function getUrl($shortVersion = false)
+	{
+		if (!$shortVersion) {
+			return REFERENCES_URL . 'reference.php?article_id=' . $this->getVar('article_id');
+		} else {
+			return 'reference.php?article_id=' . $this->getVar('article_id');
+		}
+	}
+
+	/**
+	 * Retourne les éléments de l'annnonce formatés pour affichage
+	 *
+	 * @param string $format Format à utiliser
+	 * @return array
+	 */
+	public function toArray($format = 's')
+	{
+		$ret                       = array();
+		$ret                       = parent::toArray($format);
+		$hrefTitle                 = $this->getHrefTitle();
+		$ret['article_href_title'] = $hrefTitle;
+		$ret['article_url']        = $this->getUrl();
+		// Indique si une annonce est expirée
+		$ret['article_is_online'] = $this->isArticleOnline();
+		if ($this->isThereAPicture()) {
+			$ret['article_picture_exists'] = true;
+			for ($i = 1; $i <= 10; ++$i) {
+				if ($this->pictureExists($i)) {
+					$ret['article_picture_url' . $i]  = $this->getPictureUrl($i);
+					$ret['article_picture_path' . $i] = $this->getPicturePath($i);
+					$ret['article_pictures_urls'][]   = $this->getPictureUrl($i);
+					$ret['article_pictures_paths'][]  = $this->getPicturePath($i);
+					$fieldName                        = 'article_picture' . $i . '_text';
+					if (xoops_trim($this->getVar($fieldName)) != '') {
+						$ret['article_pictures_texts'][] = references_utils::makeHrefTitle($this->getVar($fieldName));
+					} else {
+						$ret['article_pictures_texts'][] = $hrefTitle;
+					}
+				}
+			}
+		} else {
+			$ret['article_picture_exists'] = false;
+		}
+		$ret['article_short_text'] = references_utils::truncate_tagsafe($this->getVar('article_text'), REFERENCES_SHORTEN_TEXT);
+
+		if ($this->attachmentExists()) {
+			$ret['article_attachment_exists'] = true;
+			$ret['article_attachment_url']    = $this->getAttachmentUrl();
+			$ret['article_attachment_path']   = $this->getAttachmentPath();
+		} else {
+			$ret['attachment_exists'] = false;
+		}
+
+		if ($this->isThereAThumb()) {
+			$ret['article_thumb_exists'] = true;
+			for ($i = 1; $i <= 10; ++$i) {
+				if ($this->thumbExists($i)) {
+					$ret['article_thumb_url' . $i]  = $this->getThumbUrl($i);
+					$ret['article_thumb_path' . $i] = $this->getThumbPath($i);
+					$ret['article_thumbs_urls'][]   = $this->getThumbUrl($i);
+					$ret['article_thumbs_paths'][]  = $this->getThumbPath($i);
+				}
+			}
+		} else {
+			$ret['article_thumb_exists'] = false;
+		}
+
+		$ret['article_timestamp_formated'] = $this->getFormatedTimeStamp();
+
+		return $ret;
+	}
 }
 
 class ReferencesReferences_articlesHandler extends references_XoopsPersistableObjectHandler
 {
-    public function __construct($db)
-    {    //                         Table                   Classe                Id            Descr.
-        parent::__construct($db, 'references_articles', 'references_articles', 'article_id', 'article_title');
-    }
-
-    /**
-     * Retourne le critère à utiliser pour voir les catégories en respectant les permissions
-     *
-     * @param  string $permissionsType Type de permission (pour l'instant permission de voir)
-     * @return obejct de type Criteria
-     */
-    public function getPermissionsCategoriesCriteria($permissionsType = REFERENCES_PERM_READ)
-    {
-        global $xoopsUser;
-        static $permissions = array();
-        if (is_array($permissions) && array_key_exists($permissionsType, $permissions)) {
-            return $permissions[$permissionsType];
-        }
-        $categories    = array();
-        $currentModule = references_utils::getModule();
-        $groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
-        $gperm_handler = xoops_getHandler('groupperm');
-        $categories    = $gperm_handler->getItemIds($permissionsType, $groups, $currentModule->getVar('mid'));
-        if (is_array($categories) && count($categories) > 0) {
-            $permissions[$permissionsType] = new Criteria('article_category_id', '(' . implode(',', $categories) . ')', 'IN');
-        } else {    // Ne peut rien voir
-            $permissions[$permissionsType] = new Criteria('article_category_id', '0', '=');
-        }
-
-        return $permissions[$permissionsType];
-    }
-
-    /**
-     * Retourne les articles récents en tenant compte des permissions de consultation sur les catégories
-     *
-     * @param integer  $start      Indice de début
-     * @param integer  $limit      Nombre d'objets à renvoyer
-     * @param  string  $sort       Zone de tri
-     * @param  string  $order      Sens du tri
-     * @param  boolean $onlyOnline Uniquement les articles en ligne ?
-     * @param integer  $categoryId Identifiant d'une catégorie à laquelle se limiter
-     * @return array   Objets de type references_articles
-     */
-    public function getRecentArticles($start = 0, $limit = 0, $sort = 'article_timestamp', $order = 'DESC', $onlyOnline = true, $categoryId = 0)
-    {
-        $criteria = new CriteriaCompo();
-        $criteria->add(new Criteria('article_id', 0, '<>'));
-        $criteria->add($this->getPermissionsCategoriesCriteria());
-        if ($onlyOnline) {
-            $criteria->add(new Criteria('article_online', REFERENCES_STATUS_ONLINE, '='));
-        }
-        if (is_array($categoryId) && count($categoryId) > 0) {
-            $criteria->add(new Criteria('article_category_id', '(' . implode(',', $categoryId) . ')', 'IN'));
-        } elseif ($categoryId > 0) {
-            $criteria->add(new Criteria('article_category_id', $categoryId, '='));
-        }
-        $criteria->setStart($start);
-        $criteria->setSort($sort);
-        $criteria->setOrder($order);
-        $criteria->setLimit($limit);
-
-        return $this->getObjects($criteria);
-    }
-
-    /**
-     * Retourne le nombre total d'articles en ligne
-     *
-     * @return integer
-     */
-    public function getOnlineArticlesCount()
-    {
-        return $this->getCount(new Criteria('article_online', REFERENCES_STATUS_ONLINE, '='));
-    }
-
-    /**
-     * Notification de la publication d'une nouvelle référence
-     *
-     * @param object|references_articles $article L'annonce pour laquelle on fait la notification
-     * @return bool
-     */
-    public function notifyNewArticle(references_articles $article)
-    {
-        $plugins = references_plugins::getInstance();
-        $plugins->fireAction(references_plugins::EVENT_ON_REFERENCE_CREATE, new references_parameters(array('reference' => $article)));
-
-        return true;
-    }
-
-    /**
-     * Effectue la suppression d'un article (et de ses images et fichier attaché)
-     *
-     * @param references_articles $article L'article à supprimer
-     * @return boolean    Le résultat de la suppression
-     */
-    public function deleteArticle(references_articles $article)
-    {
-        $article->deletePicturesAndThumbs();
-        $article->deleteAttachment();
-
-        return $this->delete($article, true);
-    }
-
-    /**
-     * Retourne la liste des catégories uniques utilisées par les références
-     *
-     */
-    public function getDistinctCategoriesIds()
-    {
-        $ret = array();
-        $sql = 'SELECT distinct(article_category_id) FROM ' . $this->table;
-        $sql .= ' ' . $this->getPermissionsCategoriesCriteria()->renderWhere();    // Permissions
-        $sql .= ' GROUP BY article_category_id ORDER BY article_category_id';
-        $result = $this->db->query($sql);
-        if (!$result) {
-            return $ret;
-        }
-        while ($row = $this->db->fetchArray($result)) {
-            $ret[$row['article_category_id']] = $row['article_category_id'];
-        }
-
-        return $ret;
-    }
-
-    /**
-     * Passe un article en ligne
-     *
-     * @param  references_articles $article
-     * @return boolean
-     */
-    public function onlineArticle(references_articles $article)
-    {
-        $article->setVar('article_online', REFERENCES_STATUS_ONLINE);
-
-        return $this->insert($article, true);
-    }
-
-    /**
-     * Passe un article hors ligne
-     *
-     * @param  references_articles $article
-     * @return boolean
-     */
-    public function offlineArticle(references_articles $article)
-    {
-        $article->setVar('article_online', REFERENCES_STATUS_OFFLINE);
-
-        return $this->insert($article, true);
-    }
-
-    /**
-     * Indique si une référence est visible d'un utilisateur
-     *
-     * @param object|references_articles $article L'article à controler
-     * @param integer                    $uid     L'id de l'utilisateur à controler
-     * @return bool
-     */
-    public function userCanSeeReference(references_articles $article, $uid = 0)
-    {
-        global $xoopsUser;
-        if ($uid == 0) {
-            $uid = references_utils::getCurrentUserID();
-        }
-        $currentModule = references_utils::getModule();
-        $groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
-        $gperm_handler = xoops_getHandler('groupperm');
-
-        return $gperm_handler->checkRight(REFERENCES_PERM_READ, $article->article_category_id, references_utils::getMemberGroups($uid), $currentModule->getVar('mid'));
-    }
-
-    /**
-     * Remonte un article d'un cran dans l'ordre global des articles
-     *
-     * @param  integer $currentId    L'ID de l'article courant dont on souhaite remonter l'ordre
-     * @param integer  $currentOrder L'ordre de l'élément courant à remonter
-     * @return void
-     */
-    public function moveUp($currentId, $currentOrder)
-    {
-        $sql_plus = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder - 1);
-        $res_plus = $this->db->query($sql_plus);
-        if ($this->db->getRowsNum($res_plus) == 0) {
-            return;
-        }
-        $row_plus = $this->db->fetchArray($res_plus);
-
-        $upd1 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight + 1) WHERE article_id = ' . $row_plus['article_id'];
-        $this->db->queryF($upd1);
-
-        $upd2 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . (int)$currentId;
-        $this->db->queryF($upd2);
-        $this->forceCacheClean();
-    }
-
-    /**
-     * Descend un article d'un cran dans l'ordre global des articles
-     *
-     * @param  integer $currentId    L'Id de l'article courant dont on souhaite descendre l'ordre
-     * @param integer  $currentOrder L'orde de l'élément courant à remonter
-     * @return void
-     */
-    public function moveDown($currentId, $currentOrder)
-    {
-        $sql_moins = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder + 1);
-        $res_moins = $this->db->query($sql_moins);
-        if ($this->db->getRowsNum($res_moins) == 0) {
-            return;
-        }
-
-        $row_moins = $this->db->fetchArray($res_moins);
-        $upd1      = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . $row_moins['article_id'];
-        $this->db->queryF($upd1);
-
-        $upd2 = 'UPDATE ' . $this->table . ' SET article_weight =( article_weight + 1) WHERE article_id = ' . (int)$currentId;
-        $this->db->queryF($upd2);
-        $this->forceCacheClean();
-    }
+	public function __construct($db)
+	{    //                         Table                   Classe                Id            Descr.
+		parent::__construct($db, 'references_articles', 'references_articles', 'article_id', 'article_title');
+	}
+
+	/**
+	 * Retourne le critère à utiliser pour voir les catégories en respectant les permissions
+	 *
+	 * @param  string $permissionsType Type de permission (pour l'instant permission de voir)
+	 * @return obejct de type Criteria
+	 */
+	public function getPermissionsCategoriesCriteria($permissionsType = REFERENCES_PERM_READ)
+	{
+		global $xoopsUser;
+		static $permissions = array();
+		if (is_array($permissions) && array_key_exists($permissionsType, $permissions)) {
+			return $permissions[$permissionsType];
+		}
+		$categories    = array();
+		$currentModule = references_utils::getModule();
+		$groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
+		$gperm_handler = xoops_getHandler('groupperm');
+		$categories    = $gperm_handler->getItemIds($permissionsType, $groups, $currentModule->getVar('mid'));
+		if (is_array($categories) && count($categories) > 0) {
+			$permissions[$permissionsType] = new Criteria('article_category_id', '(' . implode(',', $categories) . ')', 'IN');
+		} else {    // Ne peut rien voir
+			$permissions[$permissionsType] = new Criteria('article_category_id', '0', '=');
+		}
+
+		return $permissions[$permissionsType];
+	}
+
+	/**
+	 * Retourne les articles récents en tenant compte des permissions de consultation sur les catégories
+	 *
+	 * @param integer  $start      Indice de début
+	 * @param integer  $limit      Nombre d'objets à renvoyer
+	 * @param  string  $sort       Zone de tri
+	 * @param  string  $order      Sens du tri
+	 * @param  boolean $onlyOnline Uniquement les articles en ligne ?
+	 * @param integer  $categoryId Identifiant d'une catégorie à laquelle se limiter
+	 * @return array   Objets de type references_articles
+	 */
+	public function getRecentArticles($start = 0, $limit = 0, $sort = 'article_timestamp', $order = 'DESC', $onlyOnline = true, $categoryId = 0)
+	{
+		$criteria = new CriteriaCompo();
+		$criteria->add(new Criteria('article_id', 0, '<>'));
+		$criteria->add($this->getPermissionsCategoriesCriteria());
+		if ($onlyOnline) {
+			$criteria->add(new Criteria('article_online', REFERENCES_STATUS_ONLINE, '='));
+		}
+		if (is_array($categoryId) && count($categoryId) > 0) {
+			$criteria->add(new Criteria('article_category_id', '(' . implode(',', $categoryId) . ')', 'IN'));
+		} elseif ($categoryId > 0) {
+			$criteria->add(new Criteria('article_category_id', $categoryId, '='));
+		}
+		$criteria->setStart($start);
+		$criteria->setSort($sort);
+		$criteria->setOrder($order);
+		$criteria->setLimit($limit);
+
+		return $this->getObjects($criteria);
+	}
+
+	/**
+	 * Retourne le nombre total d'articles en ligne
+	 *
+	 * @return integer
+	 */
+	public function getOnlineArticlesCount()
+	{
+		return $this->getCount(new Criteria('article_online', REFERENCES_STATUS_ONLINE, '='));
+	}
+
+	/**
+	 * Notification de la publication d'une nouvelle référence
+	 *
+	 * @param object|references_articles $article L'annonce pour laquelle on fait la notification
+	 * @return bool
+	 */
+	public function notifyNewArticle(references_articles $article)
+	{
+		$plugins = references_plugins::getInstance();
+		$plugins->fireAction(references_plugins::EVENT_ON_REFERENCE_CREATE, new references_parameters(array('reference' => $article)));
+
+		return true;
+	}
+
+	/**
+	 * Effectue la suppression d'un article (et de ses images et fichier attaché)
+	 *
+	 * @param references_articles $article L'article à supprimer
+	 * @return boolean    Le résultat de la suppression
+	 */
+	public function deleteArticle(references_articles $article)
+	{
+		$article->deletePicturesAndThumbs();
+		$article->deleteAttachment();
+
+		return $this->delete($article, true);
+	}
+
+	/**
+	 * Retourne la liste des catégories uniques utilisées par les références
+	 *
+	 */
+	public function getDistinctCategoriesIds()
+	{
+		$ret = array();
+		$sql = 'SELECT distinct(article_category_id) FROM ' . $this->table;
+		$sql .= ' ' . $this->getPermissionsCategoriesCriteria()->renderWhere();    // Permissions
+		$sql .= ' GROUP BY article_category_id ORDER BY article_category_id';
+		$result = $this->db->query($sql);
+		if (!$result) {
+			return $ret;
+		}
+		while ($row = $this->db->fetchArray($result)) {
+			$ret[$row['article_category_id']] = $row['article_category_id'];
+		}
+
+		return $ret;
+	}
+
+	/**
+	 * Passe un article en ligne
+	 *
+	 * @param  references_articles $article
+	 * @return boolean
+	 */
+	public function onlineArticle(references_articles $article)
+	{
+		$article->setVar('article_online', REFERENCES_STATUS_ONLINE);
+
+		return $this->insert($article, true);
+	}
+
+	/**
+	 * Passe un article hors ligne
+	 *
+	 * @param  references_articles $article
+	 * @return boolean
+	 */
+	public function offlineArticle(references_articles $article)
+	{
+		$article->setVar('article_online', REFERENCES_STATUS_OFFLINE);
+
+		return $this->insert($article, true);
+	}
+
+	/**
+	 * Indique si une référence est visible d'un utilisateur
+	 *
+	 * @param object|references_articles $article L'article à controler
+	 * @param integer                    $uid     L'id de l'utilisateur à controler
+	 * @return bool
+	 */
+	public function userCanSeeReference(references_articles $article, $uid = 0)
+	{
+		global $xoopsUser;
+		if ($uid == 0) {
+			$uid = references_utils::getCurrentUserID();
+		}
+		$currentModule = references_utils::getModule();
+		$groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
+		$gperm_handler = xoops_getHandler('groupperm');
+
+		return $gperm_handler->checkRight(REFERENCES_PERM_READ, $article->article_category_id, references_utils::getMemberGroups($uid), $currentModule->getVar('mid'));
+	}
+
+	/**
+	 * Remonte un article d'un cran dans l'ordre global des articles
+	 *
+	 * @param  integer $currentId    L'ID de l'article courant dont on souhaite remonter l'ordre
+	 * @param integer  $currentOrder L'ordre de l'élément courant à remonter
+	 * @return void
+	 */
+	public function moveUp($currentId, $currentOrder)
+	{
+		$sql_plus = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder - 1);
+		$res_plus = $this->db->query($sql_plus);
+		if ($this->db->getRowsNum($res_plus) == 0) {
+			return;
+		}
+		$row_plus = $this->db->fetchArray($res_plus);
+
+		$upd1 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight + 1) WHERE article_id = ' . $row_plus['article_id'];
+		$this->db->queryF($upd1);
+
+		$upd2 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . (int)$currentId;
+		$this->db->queryF($upd2);
+		$this->forceCacheClean();
+	}
+
+	/**
+	 * Descend un article d'un cran dans l'ordre global des articles
+	 *
+	 * @param  integer $currentId    L'Id de l'article courant dont on souhaite descendre l'ordre
+	 * @param integer  $currentOrder L'orde de l'élément courant à remonter
+	 * @return void
+	 */
+	public function moveDown($currentId, $currentOrder)
+	{
+		$sql_moins = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder + 1);
+		$res_moins = $this->db->query($sql_moins);
+		if ($this->db->getRowsNum($res_moins) == 0) {
+			return;
+		}
+
+		$row_moins = $this->db->fetchArray($res_moins);
+		$upd1      = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . $row_moins['article_id'];
+		$this->db->queryF($upd1);
+
+		$upd2 = 'UPDATE ' . $this->table . ' SET article_weight =( article_weight + 1) WHERE article_id = ' . (int)$currentId;
+		$this->db->queryF($upd2);
+		$this->forceCacheClean();
+	}
 }

class/references_categories.php

Indentation +183 added lines, -183 removed lines

@@ -22,195 +22,195 @@
 
 require_once XOOPS_ROOT_PATH . '/kernel/object.php';
 if (!class_exists('references_XoopsPersistableObjectHandler')) {
-    require_once XOOPS_ROOT_PATH . '/modules/references/class/PersistableObjectHandler.php';
+	require_once XOOPS_ROOT_PATH . '/modules/references/class/PersistableObjectHandler.php';
 }
 
 class references_categories extends references_Object
 {
-    public function __construct()
-    {
-        $this->initVar('category_id', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('category_title', XOBJ_DTYPE_TXTBOX, null, false);
-        $this->initVar('category_weight', XOBJ_DTYPE_INT, null, false);
-        $this->initVar('category_description', XOBJ_DTYPE_TXTAREA, null, false);
-        // Pour autoriser le html
-        $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false);
-    }
-
-    /**
-     * Retourne la chaine de caractères qui peut être utilisée dans l'attribut href d'une balise html A.
-     *
-     * @return string
-     */
-    public function getHrefTitle()
-    {
-        return references_utils::makeHrefTitle($this->getVar('category_title'));
-    }
-
-    /**
-     * Retourne l'url à utiliser pour atteindre la catégorie
-     *
-     * @param bool $shortVersion
-     * @return string
-     */
-    public function getUrl($shortVersion = false)
-    {
-        if (!$shortVersion) {
-            return REFERENCES_URL . 'category.php?category_id=' . $this->getVar('category_id');
-        } else {
-            return 'category.php?category_id=' . $this->getVar('category_id');
-        }
-    }
-
-    /**
-     * Retourne les éléments de l'annnonce formatés pour affichage
-     *
-     * @param string $format Format à utiliser
-     * @return array
-     */
-    public function toArray($format = 's')
-    {
-        $ret                          = array();
-        $ret                          = parent::toArray($format);
-        $ret['category_href_title']   = $this->getHrefTitle();
-        $ret['category_url_rewrited'] = $this->getUrl();
-
-        return $ret;
-    }
+	public function __construct()
+	{
+		$this->initVar('category_id', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('category_title', XOBJ_DTYPE_TXTBOX, null, false);
+		$this->initVar('category_weight', XOBJ_DTYPE_INT, null, false);
+		$this->initVar('category_description', XOBJ_DTYPE_TXTAREA, null, false);
+		// Pour autoriser le html
+		$this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false);
+	}
+
+	/**
+	 * Retourne la chaine de caractères qui peut être utilisée dans l'attribut href d'une balise html A.
+	 *
+	 * @return string
+	 */
+	public function getHrefTitle()
+	{
+		return references_utils::makeHrefTitle($this->getVar('category_title'));
+	}
+
+	/**
+	 * Retourne l'url à utiliser pour atteindre la catégorie
+	 *
+	 * @param bool $shortVersion
+	 * @return string
+	 */
+	public function getUrl($shortVersion = false)
+	{
+		if (!$shortVersion) {
+			return REFERENCES_URL . 'category.php?category_id=' . $this->getVar('category_id');
+		} else {
+			return 'category.php?category_id=' . $this->getVar('category_id');
+		}
+	}
+
+	/**
+	 * Retourne les éléments de l'annnonce formatés pour affichage
+	 *
+	 * @param string $format Format à utiliser
+	 * @return array
+	 */
+	public function toArray($format = 's')
+	{
+		$ret                          = array();
+		$ret                          = parent::toArray($format);
+		$ret['category_href_title']   = $this->getHrefTitle();
+		$ret['category_url_rewrited'] = $this->getUrl();
+
+		return $ret;
+	}
 }
 
 class ReferencesReferences_categoriesHandler extends references_XoopsPersistableObjectHandler
 {
-    public function __construct($db)
-    {    //                         Table                   Classe                    Id                Descr.
-        parent::__construct($db, 'references_categories', 'references_categories', 'category_id', 'category_title');
-    }
-
-    /**
-     * Retourne le crit�re � utiliser pour voir les cat�gories en respectant les permissions
-     *
-     * @param  string $permissionsType Type de permission (pour l'instant permission de voir)
-     * @return obejct de type Criteria
-     */
-    public function getPermissionsCategoriesCriteria($permissionsType = REFERENCES_PERM_READ)
-    {
-        global $xoopsUser;
-        static $permissions = array();
-        if (references_utils::isAdmin()) {
-            return new Criteria('category_id', '0', '>');
-        }
-        if (is_array($permissions) && array_key_exists($permissionsType, $permissions)) {
-            return $permissions[$permissionsType];
-        }
-        $categories    = array();
-        $currentModule = references_utils::getModule();
-        $groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
-        $gperm_handler = xoops_getHandler('groupperm');
-        $categories    = $gperm_handler->getItemIds($permissionsType, $groups, $currentModule->getVar('mid'));
-        if (is_array($categories) && count($categories) > 0) {
-            $permissions[$permissionsType] = new Criteria('category_id', '(' . implode(',', $categories) . ')', 'IN');
-        } else {    // Ne peut rien voir
-            $permissions[$permissionsType] = new Criteria('category_id', '0', '=');
-        }
-
-        return $permissions[$permissionsType];
-    }
-
-    /**
-     * Retourne les catégories
-     *
-     * @param integer $start Indice de début
-     * @param integer $limit Nombre d'objets à renvoyer
-     * @param  string $sort  Zone de tri
-     * @param  string $order Sens du tri
-     * @return array   Objets de type references_categories
-     */
-    public function getCategories($start = 0, $limit = 0, $sort = 'category_weight', $order = 'ASC')
-    {
-        $criteria = new CriteriaCompo();
-        $criteria->add(new Criteria('category_id', 0, '<>'));
-        $criteria->add($this->getPermissionsCategoriesCriteria());
-        $criteria->setStart($start);
-        $criteria->setSort($sort);
-        $criteria->setOrder($order);
-        $criteria->setLimit($limit);
-
-        return $this->getObjects($criteria, true);
-    }
-
-    /**
-     * Retourne la liste des catégories en tant que tableau
-     * @param integer $start Position de départ
-     * @param integer $limit Nombre maximum d'objets à retourner
-     * @param  string $sort  ordre de tri
-     * @param  string $order Sens du tri
-     * @return array
-     */
-    public function getListArray($start = 0, $limit = 0, $sort = 'category_weight', $order = 'ASC')
-    {
-        $criteria = new CriteriaCompo();
-        $criteria->add(new Criteria('category_id', 0, '<>'));
-        $criteria->add($this->getPermissionsCategoriesCriteria());
-        $criteria->setStart($start);
-        $criteria->setSort($sort);
-        $criteria->setOrder($order);
-        $criteria->setLimit($limit);
-
-        return $this->getList($criteria);
-    }
-
-    /**
-     * Retourne le sélecteur à utiliser pour voir la liste des catégies
-     *
-     * @param string  $selectName Le nom du sélecteur
-     * @param integer $selected   L'élément sélectionné
-     * @return string
-     */
-    public function getCategoriesSelect($selectName = 'categoriesSelect', $selected = 0)
-    {
-        $categories = array();
-        $ret        = '';
-        $categories = $this->getListArray(0, 0, 'category_weight ASC, category_title', 'ASC');
-        if (count($categories) == 0) {
-            return $ret;
-        }
-        $jump  = REFERENCES_URL . 'category.php?category_id=';
-        $extra = " onchange='location=\"" . $jump . "\"+this.options[this.selectedIndex].value'";
-
-        return references_utils::htmlSelect($selectName, $categories, $selected, true, '', false, 1, $extra);
-    }
-
-    /**
-     * Notification de la création d'une nouvelle catégorie
-     *
-     * @param object|references_categories $category
-     * @return bool
-     */
-    public function notifyNewCategory(references_categories $category)
-    {
-        $plugins = references_plugins::getInstance();
-        $plugins->fireAction(references_plugins::EVENT_ON_CATEGORY_CREATE, new references_parameters(array('category' => $category)));
-
-        return true;
-    }
-
-    /**
-     * Indique si une catégorie est visible d'un utilisateur
-     *
-     * @param object|references_categories $category La catégorie à controler
-     * @param integer                      $uid      L'id de l'utilisateur à controler
-     * @return bool
-     */
-    public function userCanSeeCategory(references_categories $category, $uid = 0)
-    {
-        global $xoopsUser;
-        if ($uid == 0) {
-            $uid = references_utils::getCurrentUserID();
-        }
-        $currentModule = references_utils::getModule();
-        $groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
-        $gperm_handler = xoops_getHandler('groupperm');
-
-        return $gperm_handler->checkRight(REFERENCES_PERM_READ, $category->category_id, references_utils::getMemberGroups($uid), $currentModule->getVar('mid'));
-    }
+	public function __construct($db)
+	{    //                         Table                   Classe                    Id                Descr.
+		parent::__construct($db, 'references_categories', 'references_categories', 'category_id', 'category_title');
+	}
+
+	/**
+	 * Retourne le crit�re � utiliser pour voir les cat�gories en respectant les permissions
+	 *
+	 * @param  string $permissionsType Type de permission (pour l'instant permission de voir)
+	 * @return obejct de type Criteria
+	 */
+	public function getPermissionsCategoriesCriteria($permissionsType = REFERENCES_PERM_READ)
+	{
+		global $xoopsUser;
+		static $permissions = array();
+		if (references_utils::isAdmin()) {
+			return new Criteria('category_id', '0', '>');
+		}
+		if (is_array($permissions) && array_key_exists($permissionsType, $permissions)) {
+			return $permissions[$permissionsType];
+		}
+		$categories    = array();
+		$currentModule = references_utils::getModule();
+		$groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
+		$gperm_handler = xoops_getHandler('groupperm');
+		$categories    = $gperm_handler->getItemIds($permissionsType, $groups, $currentModule->getVar('mid'));
+		if (is_array($categories) && count($categories) > 0) {
+			$permissions[$permissionsType] = new Criteria('category_id', '(' . implode(',', $categories) . ')', 'IN');
+		} else {    // Ne peut rien voir
+			$permissions[$permissionsType] = new Criteria('category_id', '0', '=');
+		}
+
+		return $permissions[$permissionsType];
+	}
+
+	/**
+	 * Retourne les catégories
+	 *
+	 * @param integer $start Indice de début
+	 * @param integer $limit Nombre d'objets à renvoyer
+	 * @param  string $sort  Zone de tri
+	 * @param  string $order Sens du tri
+	 * @return array   Objets de type references_categories
+	 */
+	public function getCategories($start = 0, $limit = 0, $sort = 'category_weight', $order = 'ASC')
+	{
+		$criteria = new CriteriaCompo();
+		$criteria->add(new Criteria('category_id', 0, '<>'));
+		$criteria->add($this->getPermissionsCategoriesCriteria());
+		$criteria->setStart($start);
+		$criteria->setSort($sort);
+		$criteria->setOrder($order);
+		$criteria->setLimit($limit);
+
+		return $this->getObjects($criteria, true);
+	}
+
+	/**
+	 * Retourne la liste des catégories en tant que tableau
+	 * @param integer $start Position de départ
+	 * @param integer $limit Nombre maximum d'objets à retourner
+	 * @param  string $sort  ordre de tri
+	 * @param  string $order Sens du tri
+	 * @return array
+	 */
+	public function getListArray($start = 0, $limit = 0, $sort = 'category_weight', $order = 'ASC')
+	{
+		$criteria = new CriteriaCompo();
+		$criteria->add(new Criteria('category_id', 0, '<>'));
+		$criteria->add($this->getPermissionsCategoriesCriteria());
+		$criteria->setStart($start);
+		$criteria->setSort($sort);
+		$criteria->setOrder($order);
+		$criteria->setLimit($limit);
+
+		return $this->getList($criteria);
+	}
+
+	/**
+	 * Retourne le sélecteur à utiliser pour voir la liste des catégies
+	 *
+	 * @param string  $selectName Le nom du sélecteur
+	 * @param integer $selected   L'élément sélectionné
+	 * @return string
+	 */
+	public function getCategoriesSelect($selectName = 'categoriesSelect', $selected = 0)
+	{
+		$categories = array();
+		$ret        = '';
+		$categories = $this->getListArray(0, 0, 'category_weight ASC, category_title', 'ASC');
+		if (count($categories) == 0) {
+			return $ret;
+		}
+		$jump  = REFERENCES_URL . 'category.php?category_id=';
+		$extra = " onchange='location=\"" . $jump . "\"+this.options[this.selectedIndex].value'";
+
+		return references_utils::htmlSelect($selectName, $categories, $selected, true, '', false, 1, $extra);
+	}
+
+	/**
+	 * Notification de la création d'une nouvelle catégorie
+	 *
+	 * @param object|references_categories $category
+	 * @return bool
+	 */
+	public function notifyNewCategory(references_categories $category)
+	{
+		$plugins = references_plugins::getInstance();
+		$plugins->fireAction(references_plugins::EVENT_ON_CATEGORY_CREATE, new references_parameters(array('category' => $category)));
+
+		return true;
+	}
+
+	/**
+	 * Indique si une catégorie est visible d'un utilisateur
+	 *
+	 * @param object|references_categories $category La catégorie à controler
+	 * @param integer                      $uid      L'id de l'utilisateur à controler
+	 * @return bool
+	 */
+	public function userCanSeeCategory(references_categories $category, $uid = 0)
+	{
+		global $xoopsUser;
+		if ($uid == 0) {
+			$uid = references_utils::getCurrentUserID();
+		}
+		$currentModule = references_utils::getModule();
+		$groups        = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
+		$gperm_handler = xoops_getHandler('groupperm');
+
+		return $gperm_handler->checkRight(REFERENCES_PERM_READ, $category->category_id, references_utils::getMemberGroups($uid), $currentModule->getVar('mid'));
+	}
 }

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();
+	}
 }

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 +199 added lines, -199 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;
@@ -293,13 +293,13 @@ 
             }
         }
         if (function_exists('xoops_getMailer')) {
-            $xoopsMailer =& 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();