Le laboratoire de Darathor

<?php

/**
 */
define('GROUPE_A_COLORER', 4);
define('COULEUR_A_APPLIQUER', 5);
/**
 */

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.' . $phpEx);

$sql = 'SELECT user_id
        FROM ' . USER_GROUP_TABLE . '
        WHERE group_id = ' . GROUPE_A_COLORER;
$result = $db->sql_query($sql);

$user_ids = array();
while ($row = $db->sql_fetchrow($result))
{
    $user_ids[] = $row['user_id'];
}
$db->sql_freeresult($result);

$sql = 'UPDATE ' . USERS_TABLE . '
        SET user_qeel_color = ' . COULEUR_A_APPLIQUER . '
        WHERE user_id IN (' . implode(', ', $user_ids) . ')';
if ($db->sql_query($sql))
{
    echo 'Groupe coloré ;-)';
}

$db->sql_close();

?>

<span class="color_qeel_x">pseudo</span>