Merhaba,
ben bu Modulde yeni üyelerin degil de dogum günü olan üyeleri listelemek istiyorum biraz denedim ama yapamadim ...
yardimci olursaniz sevinirim..
<?php
if (!defined("mxMainFileLoaded")) die ("You can't access this file directly...");
$module_name = basename(dirname(__FILE__));
#mxGetLangfile($module_name);
$index = 0;
################# Einstell Variablen ##############
//// Anzahl der anzuzeigenden User
$ucount = 30;
###################################################
global $user_prefix;
$ucount = intval($ucount);
$qry="SELECT uname, user_regtime, user_sexus, user_avatar, (YEAR( CURRENT_DATE ) - YEAR( user_bday )) -
( RIGHT( CURRENT_DATE, 5 ) < RIGHT( user_bday, 5 ) ) AS user_age FROM ${user_prefix}_users WHERE user_stat=1 AND user_sexus=2 ORDER BY user_regtime DESC LIMIT ".$ucount.";";
$result = sql_query($qry);
while (list($uname, $user_regtime, $user_sexus, $user_avatar, $user_age) = sql_fetch_row($result)) {
$avatarFile = mxIsAvatarUploaded($uname);
if(!empty($avatarFile['werist'])){
$avatar="images/camera.jpg";
}
else
{
$avatar="images/forum/blanko.gif";
}
if ($user_sexus=="2" || $user_sexus=="0") {
$lasts2[] .= '<img src="images/m.gif" border="0" align="absmiddle" Alt="GayAlem newest Users"> <a href="modules.php?name=Userinfo&uname='.$uname.'"><b>'.$uname.'</b>><img src="'.$avatar.'" >
</a>';
}
}
global $user_prefix;
$ucount = intval($ucount);
$qry="SELECT uname, user_regtime, user_sexus, user_avatar, (YEAR( CURRENT_DATE ) - YEAR( user_bday )) -
( RIGHT( CURRENT_DATE, 5 ) < RIGHT( user_bday, 5 ) ) AS user_age FROM ${user_prefix}_users WHERE user_stat=1 AND user_sexus=1 ORDER BY user_regtime DESC LIMIT ".$ucount.";";
$result = sql_query($qry);
while (list($uname, $user_regtime, $user_sexus, $user_avatar, $user_age) = sql_fetch_row($result)) {
$avatarFile = mxIsAvatarUploaded($uname);
if(!empty($avatarFile['werist'])){
$avatar="images/camera.jpg";
}
else
{
$avatar="images/forum/blanko.gif";
}
if ($user_sexus=="1") {
$lasts1[] .= '<img src="images/f.gif" border="0" align="absmiddle" Alt="GayAlem newest Users"> <a href="modules.php?name=Userinfo&uname='.$uname.'"><b>'.$uname.'</b>><img src="'.$avatar.'" >
</a>';
}
}
include("header.php");
OpenTable();
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\">\n";
echo"<tr>\n";
echo"<td>\n";
echo "<table width=\"310\" border=\"1\" cellspacing=\"1\">\n";
echo"<b>Yeni Bayan Üyeler</b>\n";
while (list($k,$v1) = each($lasts1))
{
echo"<tr><td height=\"30\">$v1</td></tr>\n";
}
echo"</table>\n";
echo"</td>\n";
echo"<td>\n";
echo "<table width=\"310\" border=\"1\" cellspacing=\"1\">\n";
echo"<b>Yeni Erkek Üyeler</b>\n";
while (list($k,$v2) = each($lasts2))
{
echo"<tr><td height=\"30\">$v2</td></tr>\n";
}
echo"</table>\n";
echo"</td>\n";
echo"</tr>\n";
echo"</table>\n";
CloseTable();
include ("footer.php");
?>
pragmaMx Support Forum
