Index du Forum » » Le coin des codeurs

Auteur

[Résolu] - Add nbr de posts ds memberslist => bug de syntaxe...
snipe
2450       
 

  Posté : 16-12-2003 13:51

$count = "SELECT COUNT(uid) AS total FROM users as u ";
$select = "SELECT u.uid, u.name, u.uname, u.femail, u.url, u.user_regdate, u.user_from, u.email, u.is_visible, u.user_viewemail, u.user_avatar, u.mns, us.posts FROM users AS u, users_status AS us WHERE u.uid = us.uid ";
if ( ( $letter != "".translate("Other")."" ) AND ( $letter != "".translate("All")."" ) ) {
$where = " u.uname like '".$letter."%'";
} else if ( ( $letter == "".translate("Other")."" ) AND ( $letter != "".translate("All")."" ) ) {
$where = " u.uname REGEXP \"^\[1-9]\" ";
} else {
$where = "";
}
global $member_invisible;
if ($member_invisible) {
if ($admin)
$and="";
else {
$and="and u.is_visible=1 ";
}
} else {
$and="";
}

$sort = "order by u.".$sortby;

remplace le morceau de code vers la ligne 169 par ca :)



Cet article provient de NPDS

http://www.npds.org/viewtopic.php?topic=9106&forum=5