function last20($bgcolor1, $bgcolor2, $bgcolor3, $username) { global $prefix, $user_prefix, $db, $module_name; OpenTable(); echo "<div align=\"center\" class=title>" . _20ACTIVE . "</div><br>"; echo "<table align=center border=1 cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<td bgcolor={$bgcolor1} width=150> <strong>" . _MEMBER . "</strong> " . _CLICKTOVIEW . "</td>"; echo "<td bgcolor={$bgcolor1} width=70 align=center><strong>" . _VIEWJOURNAL . "</strong></td>"; echo "<td bgcolor={$bgcolor1} width=70 align=center><strong>" . _MEMBERPROFILE . "</strong></td>"; if (empty($username)) { echo "<td bgcolor={$bgcolor1} width=70 align=center><strong>" . _CREATEACCOUNT2 . "</strong></td>"; } else { if (is_active("Private_Messages")) { echo "<td bgcolor={$bgcolor1} width=70 align=center><strong>" . _PRIVMSGJ . "</strong></td>"; } } echo "</tr>"; $sql = "SELECT j.id, j.joid, j.nop, j.ldp, j.ltp, j.micro, u.user_id, u.username FROM " . $prefix . "_journal_stats j, " . $user_prefix . "_users u where u.username=j.joid ORDER BY 'ldp' DESC"; $result = $db->sql_query($sql); $dcount = 1; while ($row = $db->sql_fetchrow($result)) { $row['id'] = intval($row['id']); $row['joid'] = filter($row['joid'], "nohtml"); $row['nop'] = filter($row['nop'], "nohtml"); $row['ldp'] = filter($row['ldp'], "nohtml"); $row['ltp'] = filter($row['ltp'], "nohtml"); $row['micro'] = filter($row['micro'], "nohtml"); $row['user_id'] = filter($row['user_id'], "nohtml"); if ($dcount >= 21) { echo "</table>"; CloseTable(); journalfoot(); die; } else { $dcount = $dcount + 1; print "<tr>"; printf("<td bgcolor={$bgcolor2}> <a href=\"modules.php?name={$module_name}&file=search&bywhat=aid&exact=1&forwhat=%s\">%s</a></td>", $row['joid'], $row['joid']); printf("<td bgcolor={$bgcolor2} align=center><div class=title><a href=\"modules.php?name={$module_name}&file=search&bywhat=aid&exact=1&forwhat=%s\"><img src=\"modules/{$module_name}/images/binocs.gif\" border=0 alt=\"" . _VIEWJOURNAL2 . "\" title=\"" . _VIEWJOURNAL2 . "\"></a></td>", $row['joid'], $row['joid']); printf("<td bgcolor={$bgcolor2} align=center><a href=\"modules.php?name=Your_Account&op=userinfo&username=%s\"><img src=\"modules/{$module_name}/images/nuke.gif\" alt=\"" . _USERPROFILE2 . "\" title=\"" . _USERPROFILE2 . "\" border=0></a></td>", $row['joid'], $row['joid'], $row['joid']); if (empty($username)) { print "<td align=center bgcolor={$bgcolor2}><a href=\"modules.php?name=Your_Account&op=new_user\"><img src=\"modules/{$module_name}/images/folder.gif\" border=0 alt=\"" . _CREATEACCOUNT . "\" title=\"" . _CREATEACCOUNT . "\"></a></td>"; } else { if (is_active("Private_Messages")) { printf("<td align=center bgcolor={$bgcolor2}><a href=\"modules.php?name=Private_Messages&mode=post&u=" . $row['user_id'] . "\"><img src='modules/{$module_name}/images/chat.gif' border='0' alt='" . _PRIVMSGJ2 . "'></a></td>", $row['joid'], $row['joid']); } } echo "</tr>"; } } echo "</table>"; CloseTable(); }
/* it under the terms of the GNU General Public License as published by */ /* the Free Software Foundation; either version 2 of the License. */ /************************************************************************/ /* Additional security checking code 2003 by chatserv */ /* http://www.nukefixes.com -- http://www.nukeresources.com */ /************************************************************************/ if (!eregi("modules.php", $_SERVER['PHP_SELF'])) { die("You can't access this file directly..."); } require_once "mainfile.php"; $module_name = basename(dirname(__FILE__)); get_lang($module_name); $pagetitle = "- " . _USERSJOURNAL . ""; include "header.php"; include "modules/{$module_name}/functions.php"; cookiedecode($user); $username = $cookie[1]; if ($debug == "true") { echo "UserName:{$username}<br>SiteName: {$sitename}"; } startjournal($sitename, $user); $onwhat = intval($onwhat); $sql = "DELETE FROM " . $prefix . "_journal_comments WHERE cid = '{$onwhat}'"; $db->sql_query($sql); echo "<br>"; openTable(); echo "<div align=center>" . _COMMENTDELETED . "<br><br>"; echo "[ <a href=\"modules.php?name={$module_name}&file=display&jid={$ref}\">" . _RETURNJOURNAL . "</a> ]</div>"; closeTable(); journalfoot();
function list20($username, $bgcolor1, $bgcolor2, $bgcolor3) { global $prefix, $user_prefix, $db, $module_name; openTable(); echo "<div align=\"center\" class=title>" . _LAST20FOR . " {$username}</div><br>"; echo "<table align=center border=1 width=\"90%\">"; echo "<tr>"; echo "<td align=center bgcolor={$bgcolor1} width=70><strong><div align=\"center\">" . _DATE . "</div></strong></td>"; echo "<td align=center bgcolor={$bgcolor1} width=70><strong><div align=\"center\">" . _TIME . "</div></strong></td>"; echo "<td align=center bgcolor={$bgcolor1}><strong>" . _TITLE . "</strong> " . _CLICKTOVIEW . "</td>"; echo "<td align=center bgcolor={$bgcolor1} width=\"5%\"><strong><div align=\"center\">" . _PUBLIC . "</div></strong></td>"; echo "<td align=center bgcolor={$bgcolor1} width=\"5%\"><strong><div align=\"center\">" . _EDIT . "</div></strong></td>"; echo "<td align=center bgcolor={$bgcolor1} width=\"5%\"><strong><div align=\"center\">" . _DELETE . "</div></strong></td>"; echo "</tr>"; $sql = "SELECT jid, aid, title, pdate, ptime, mdate, mtime, status, mood FROM " . $prefix . "_journal WHERE aid='{$username}' order by 'jid' DESC"; $result = $db->sql_query($sql); $dcount = 1; while ($row = $db->sql_fetchrow($result)) { if ($dcount >= 21) { echo "</tr></table>"; closeTable(); echo "<br>"; journalfoot(); die; } else { $dcount = $dcount + 1; print "<tr>"; $jid = intval($row['jid']); $title = filter($row['title'], "nohtml"); $jaid = filter($row['aid'], "nohtml"); $pdate = filter($row['pdate'], "nohtml"); $ptime = filter($row['ptime'], "nohtml"); printf("<td align=center bgcolor={$bgcolor2}><div align=\"center\">%s</div></td>", $pdate); printf("<td align=center bgcolor={$bgcolor2}><div align=\"center\">%s</div></td>", $ptime); printf("<td align=left bgcolor={$bgcolor2}> <a href=\"modules.php?name={$module_name}&file=display&jid=%s\">%s</a>", $jid, $title); $sqlscnd = "SELECT cid from " . $prefix . "_journal_comments where rid='{$jaid}'"; $rstscnd = $db->sql_query($sqlscnd); $scndcount = 0; while ($rowscnd = $db->sql_fetchrow($rstscnd)) { $scndcount = $scndcount + 1; } if ($scndcount == 1) { printf(" —— {$scndcount} " . _COMMENT . "</td>"); } else { printf(" —— {$scndcount} " . _COMMENTS . "</td>"); } if ($row['status'] == "yes") { $row['status'] = _YES; } else { $row['status'] = _NO; } printf("<td align=center bgcolor={$bgcolor2}><div align=\"center\">%s</div></td>", $row['status']); printf("<td align=center bgcolor={$bgcolor2}><div align=\"center\"><a href=\"modules.php?name={$module_name}&file=modify&jid=%s\"><img src='modules/{$module_name}/images/edit.gif' border='0' alt=\"" . _EDIT . "\" title=\"" . _EDIT . "\"></a></div></td>", $jid, $title); printf("<td align=center bgcolor={$bgcolor2}><div align=\"center\"><a href=\"modules.php?name={$module_name}&file=delete&jid=%s\"><img src='modules/{$module_name}/images/trash.gif' border='0' alt=\"" . _DELETE . "\" title=\"" . _DELETE . "\"></a></div></td>", $jid, $title); print "</tr>"; } } echo "</table>"; closeTable(); }