Code:
function message_box() {
global $bgcolor1, $bgcolor2, $bgcolor3, $user, $admin, $cookie, $textcolor2, $prefix, $multilingual, $currentlang, $db, $admin_file;
if ($multilingual == 1) {
$querylang = "AND (mlanguage='$currentlang' OR mlanguage='')";
} else {
$querylang = "";
}
$result = $db->sql_query("SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang");
if ($numrows = $db->sql_numrows($result) == 0) {
return;
} else {
while ($row = $db->sql_fetchrow($result)) {
$mid = intval($row['mid']);
$title = stripslashes(check_html($row['title'], "nohtml"));
$content = stripslashes($row['content']);
$mdate = $row['date'];
$expire = intval($row['expire']);
$view = intval($row['view']);
if ($title != "" && $content != "") {
if ($expire == 0) {
$remain = _UNLIMITED;
} else {
$etime = (($mdate+$expire)-time())/3600;
$etime = (int)$etime;
if ($etime < 1) {
$remain = _EXPIRELESSHOUR;
} else {
$remain = ""._EXPIREIN." $etime "._HOURS."";
}
}
if ($view == 5 AND paid()) {
echo "<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bgcolor=\"000000\" width=\"100%\"><tr><td><table border=\"2\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor3\">";
echo "<center><font class=\"option\" color=\"$textcolor2\"><b>$title</b></font></center><br /><font class=\"content\">$content<br /></font>";
echo "</td></tr>";
if (is_admin($admin)) {
echo "<tr><td bgcolor=\"$bgcolor2\" align=\"right\"><font class=\"content\"><center><font class=\"content\">[ "._MVIEWSUBUSERS." - $remain - <a href=\"".$admin_file.".php?op=editmsg&mid=$mid\">"._EDIT."</a> ]</font></center></td></tr>";
}
echo "</table></td></tr></table><br />";
} elseif ($view == 4 AND is_admin($admin)) {
echo "<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bgcolor=\"000000\" width=\"100%\"><tr><td><table border=\"2\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor3\">";
echo "<center><font class=\"option\" color=\"$textcolor2\"><b>$title</b></font></center><br /><font class=\"content\">$content<br /></font>";
echo "</td></tr>";
if (is_admin($admin)) {
echo "<tr><td bgcolor=\"$bgcolor2\" align=\"right\"><font class=\"content\"><center><font class=\"content\">[ "._MVIEWSUBUSERS." - $remain - <a href=\"".$admin_file.".php?op=editmsg&mid=$mid\">"._EDIT."</a> ]</font></center></td></tr>";
}
echo "</table></td></tr></table><br />";
} elseif ($view == 3 AND is_user($user) || is_admin($admin)) {
echo "<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bgcolor=\"000000\" width=\"100%\"><tr><td><table border=\"2\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor3\">";
echo "<center><font class=\"option\" color=\"$textcolor2\"><b>$title</b></font></center><br /><font class=\"content\">$content<br /></font>";
echo "</td></tr>";
if (is_admin($admin)) {
echo "<tr><td bgcolor=\"$bgcolor2\" align=\"right\"><font class=\"content\"><center><font class=\"content\">[ "._MVIEWUSERS." - $remain - <a href=\"".$admin_file.".php?op=editmsg&mid=$mid\">"._EDIT."</a> ]</font></center></td></tr>";
}
echo "</table></td></tr></table><br />";
} elseif ($view == 2 AND !is_user($user) || is_admin($admin)) {
echo "<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bgcolor=\"000000\" width=\"100%\"><tr><td><table border=\"2\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor3\">";
echo "<center><font class=\"option\" color=\"$textcolor2\"><b>$title</b></font></center><br /><font class=\"content\">$content<br /></font>";
echo "</td></tr>";
if (is_admin($admin)) {
echo "<tr><td bgcolor=\"$bgcolor2\" align=\"right\"><font class=\"content\"><center><font class=\"content\">[ "._MVIEWANON." - $remain - <a href=\"".$admin_file.".php?op=editmsg&mid=$mid\">"._EDIT."</a> ]</font></center></td></tr>";
}
echo "</table></td></tr></table><br />";
} elseif ($view == 1) {
echo "<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bgcolor=\"000000\" width=\"100%\"><tr><td><table border=\"2\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor3\">";
echo "<center><font class=\"option\" color=\"$textcolor2\"><b>$title</b></font></center><br /><font class=\"content\">$content<br /></font>";
echo "</td></tr>";
if (is_admin($admin)) {
echo "<tr><td bgcolor=\"$bgcolor2\" align=\"right\"><font class=\"content\"><center><font class=\"content\">[ "._MVIEWALL." - $remain - <a href=\"".$admin_file.".php?op=editmsg&mid=$mid\">"._EDIT."</a> ]</font></center></td></tr>";
}
echo "</table></td></tr></table><br />";
}
if ($expire != 0) {
$past = time()-$expire;
if ($mdate < $past) {
$db->sql_query("UPDATE ".$prefix."_message SET active='0' WHERE mid='$mid'");
}
}
}
}
}
}
|