Posted on: 03/11/04 05:16am
By: Dazzy
function phpblock_journal2 () { global $_CONF, $_TABLES, $LANG_JOURNAL; $retval = ''; $sql = "SELECT jrn_id,jrn_uid,jrn_name FROM {$_TABLES['journal']} WHERE jrn_public = 1 ORDER BY jrn_name"; $result = DB_query ($sql); $journals = DB_numRows ($result); if ($journals > 0) { $retval .= '<table border="0" width="100%">' . LB; for ($j = 1; $j <= $journals; $j++) { $J = DB_fetchArray ($result); $username = DB_getItem ($_TABLES['users'], 'username', "uid = {$J['jrn_uid']}"); $sql = "SELECT je_summary,je_mood,UNIX_TIMESTAMP(je_date) AS date FROM {$_TABLES['journal_entry']} WHERE (je_jrn_id = {$J['jrn_id']}) AND (je_public = 1) ORDER BY je_date DESC LIMIT 1"; $eresult = DB_query ($sql); $entries = DB_numRows ($eresult); if ($entries == 0) { $retval .= '<tr><td> </td>'; $retval .= '<td><a href="' . $_CONF['site_url'] . '/journal/index.php?mode=user&jrn_id=' . $J['jrn_id'] . '">' . stripslashes ($J['jrn_name']) . '</a> (' . $username . ')<br><em>' . $LANG_JOURNAL['block_no_entries'] . '</em></td></tr>' . LB; } else { $A = DB_fetchArray ($eresult); $mood = $A['je_mood']; if (empty ($mood)) { $retval .= '<tr><td> </td>'; } else { $retval .= '<tr><td valign="top"><img src="' . $_CONF['site_url'] . '/journal/images/' . $mood . '_phpbb.gif' . '" alt="[' . $LANG_JOURNAL['mood_' . $mood] . ']" title="' . $LANG_JOURNAL['mood_' . $mood] . '"></td>'; } $retval .= '<td><a href="' . $_CONF['site_url'] . '/journal/index.php?mode=user&jrn_id=' . $J['jrn_id'] . '">' . stripslashes ($J['jrn_name']) . '</a> (' . $username . ')<br>' . '<strong>' . stripslashes ($A['je_summary']) . '</strong><br>' . '<em>' . strftime ($_CONF['shortdate'], $A['date']) . '</em></td></tr>' . LB; } } $retval .= '</table>' . LB; } else { $retval .= '<em>' . $LANG_JOURNAL['block_no_journals'] . '</em>'; } return $retval; }
Posted on: 03/11/04 02:42pm
By: Dirk