Lestat, вот
$violation = mysql_result(mysql_query("SELECT COUNT(*) FROM `violation` WHERE `user_id` = '" . $user['id'] . "'"), 0);
if (!empty($violation)) echo '<div class="alarm">Предупреждение <a href="' . $set['homeurl'] . '/users/profile.php?act=ban&mod=violation&user=' . $user['id'] . '">' . $lng['in_detail'] . '</a></div>';