if(!empty($elementName) && !empty($resource[$element]))
        {
            $data = array();
            if($element >= 0 && $element <  100 || $element >= 200 && $element < 407 || $element >= 409 && $element < 600)
            {
                $record = doquery(sprintf(
                    'SELECT GROUP_CONCAT(DISTINCT u.username ORDER BY u.username DESC SEPARATOR ", ") AS players, p.%2$s AS level ' .
                    'FROM %1$susers AS u ' .
                    'LEFT JOIN %1$splanets AS p ON (u.id=p.id_owner) ' .
                    'WHERE p.%2$s=(SELECT MAX(p2.%2$s) FROM %1$splanets AS p2) AND p.%2$s>0 ' .
                    'GROUP BY p.%2$s ORDER BY u.username ASC ', __DB_PREFIX, $resource[$element]), '', true);
            }
            else if($element >= 100 && $element < 200)
            {
                $record = doquery(sprintf(
                    'SELECT GROUP_CONCAT(u.username SEPARATOR ", ") AS players, u.%2$s AS level ' .
                    'FROM %1$susers AS u ' .
                    'WHERE u.%2$s=(SELECT MAX(u2.%2$s) FROM %1$susers AS u2) AND u.%2$s>0 ' .
                    'GROUP BY u.%2$s ORDER BY u.username ASC ', __DB_PREFIX, $resource[$element]), '', true);
            }

Salut voila j'aimerais rajouté une fonction LIMIT mais je trouve toujours des erreurs

[php] if(!empty($elementName) && !empty($resource[$element]))
{
$data = array();
if($element >= 0 && $element < 100 || $element >= 200 && $element < 407 || $element >= 409 && $element < 600)
{
$record = doquery(sprintf(
'SELECT GROUP_CONCAT(DISTINCT u.username ORDER BY u.username DESC SEPARATOR ", ") AS players, p.%2$s AS level ' .
'FROM %1$susers AS u ' .
'LEFT JOIN %1$splanets AS p ON (u.id=p.id_owner) ' .
'WHERE p.%2$s=(SELECT MAX(p2.%2$s) FROM %1$splanets AS p2) AND p.%2$s>0 ' .
'GROUP BY p.%2$s ORDER BY u.username ASC ', __DB_PREFIX, $resource[$element]), '', true);
}
else if($element >= 100 && $element < 200)
{
$record = doquery(sprintf(
'SELECT GROUP_CONCAT(u.username SEPARATOR ", ") AS players, u.%2$s AS level ' .
'FROM %1$susers AS u ' .
'WHERE u.%2$s=(SELECT MAX(u2.%2$s) FROM %1$susers AS u2) AND u.%2$s>0 ' .
'GROUP BY u.%2$s ORDER BY u.username ASC ', __DB_PREFIX, $resource[$element]), '', true);
}[/php]


Au niveau du select de la variable username