";
$usersonlinecheck = mysql_query("SELECT * FROM ${table_prefix}access");
$usersonline = mysql_num_rows($usersonlinecheck);
$regonlinecheck = mysql_query("SELECT * FROM ${table_prefix}access WHERE userid != 'Guest' ORDER BY userid");
$regonline = mysql_num_rows($regonlinecheck);
$guestsonline = $usersonline - $regonline;
$totuserscheck = mysql_query("SELECT * FROM ${table_prefix}users WHERE registerdate != '0000-00-00' ORDER BY registerdate DESC");
$totusers = mysql_num_rows($totuserscheck);
$lastuser = mysql_result($totuserscheck, 0, "userid");
$topicscheck = mysql_query("SELECT * FROM ${table_prefix}threads");
$tottopics = mysql_num_rows($topicscheck);
$postscheck = mysql_query("SELECT * FROM ${table_prefix}public");
$totposts = mysql_num_rows($postscheck);
echo "
$txt_userson";
if ($usersonline != 1) {
echo "$txt_thereare $usersonline $txt_usersonline";
}
else {
echo "$txt_thereis 1 $txt_useronline";
}
echo " - $regonline $txt_registered $txt_and $guestsonline ";
if ($guestsonline != 1) {
echo "$txt_guests";
}
else {
echo "$txt_guest";
}
echo ".
";
if ($regonline != 0) {
echo "$txt_regusers ";
for ($i = 0; $i < $regonline; $i++) {
$thisuser = mysql_result($regonlinecheck, $i, "userid");
echo "
$thisuser";
if ($i != $regonline - 1) {
echo ", ";
}
}
echo ".
";
}
echo "$txt_wehave $totusers ";
if ($totusers != 1) {
echo "$txt_members";
}
else {
echo "$txt_member";
}
echo " $txt_with $totposts ";
if ($totposts != 1) {
echo "$txt_posts";
}
else {
echo "$txt_post";
}
echo " $txt_in $tottopics ";
if ($tottopics != 1) {
echo "$txt_topicslc";
}
else {
echo "$txt_topic";
}
echo ".
$txt_lastreg
$lastuser.";
$thetime = time() + (3600 * $zone);
$today = date("-m-d", $thetime);
$birthdays = mysql_query("SELECT * FROM ${table_prefix}users WHERE userdob LIKE '%$today'");
if(mysql_num_rows($birthdays) > 0) {
echo "
$txt_birthday ";
}
for ($i = 0; $i < mysql_num_rows($birthdays); $i++) {
$userbd = mysql_result($birthdays, $i, "userid");
if ($i == (mysql_num_rows($birthdays) - 1) && $i != 0) {
echo "and $userbd.";
}
elseif ($i == (mysql_num_rows($birthdays) - 1)) {
echo "$userbd.";
}
else {
echo "$userbd, ";
}
}
echo "
$txt_welcomeback $sitename, $logincookie[user].";
if ($pmno > 0) {
echo " $txt_youhave $pmno ";
if ($pmno != 1) echo "$txt_newpms.";
else echo "$txt_newpm.";
echo " $txt_inbox";
}
echo "$txt_lastvisit ";
if(!isset($lastvisitunix)) {
$lastvisitunix = $logincookie[lastv];
}
$lastvisitunix = date($timeform, $lastvisitunix + (3600 * $zone));
echo "$lastvisitunix.";
$access = mysql_query("SELECT * FROM ${table_prefix}userrights WHERE userid='$logincookie[user]'");
$theaccess = mysql_result($access, 0, "mod");
if(strstr($theaccess, ",")) {
$mod = 1;
}
else {
$mod = 0;
}
if ($admincheck == 1 || $mod == 1) {
$reported = mysql_query("SELECT * FROM ${table_prefix}reported");
if (mysql_num_rows($reported) > 0) {
echo "
$txt_reporteddeal
$txt_reportedview";
}
}
echo "
$txt_markallread ";
}
else $notlogged = 1;
echo "![\"$txt_newposts\"/](\"gfx/templates/$template/icons/new.gif\"){kind=icon}
";
}
else {
$forumlocked = "![\"$txt_nonewposts\"/](\"gfx/templates/$template/icons/nonew.gif\"){kind=icon}
";
}
}
elseif ($forumlocked == 1) {
$newmsgcheck = mysql_query("SELECT * FROM threads WHERE forum='$j' ORDER BY lastreptime DESC");
$newmsgtime = mysql_result($newmsgcheck, 0, "lastreptime");
if (($lastvisit < $newmsgtime) && isset($logincookie[user])) {
$forumlocked = "![\"$txt_newposts](\"gfx/templates/$template/icons/newlocked.gif\"){kind=icon}
";
}
else {
$forumlocked = "![\"$txt_nonewposts](\"gfx/templates/$template/icons/nonewlocked.gif\"){kind=icon}
";
}
}
if($restricted == 0 || ($restricted == 1 && $allowed == 1)) {
if ($tot == 0) {
echo "