$q .= " LIMIT " . (JOURNAL_DISPLAYLIMIT + 1); } $r = mysql_query($q); if ($nsidebars = JOURNAL_SIDEBARS) { $sidebars = mysql_fetch_all(mysql_query("SELECT * FROM sidebars \n\t\t\t\tWHERE username = '******' \n\t\t\t\tORDER BY timestamp DESC\n\t\t\t\tLIMIT {$nsidebars}")); print "<div class='sidebars'>"; foreach ($sidebars as $sidebar) { extract($sidebar); print "<div class='sidebar'><h2\n\t\t\tclass='title'>{$title}</h2><div class='content'>" . wiki_render($data) . "</div></div>"; } print "</div>"; } if ($r) { $r = mysql_fetch_all($r); if (count($r) > 1) { print format_rows($r, JOURNAL_DISPLAYLIMIT); } else { print format_entry(array_shift($r)); } if ($date and !$time) { $q = "SELECT date_format(date, '%Y-%m-%d') AS date \n\t\t\t\tFROM journal \n\t\t\t\tWHERE username = '******' \n\t\t\t\t\tAND date_format(date, '%Y-%m-%d') > '{$date}' \n\t\t\t\tORDER BY date LIMIT 1"; $r = mysql_query($q); $row = mysql_fetch_assoc($r); $nextdate = $row['date']; $q = "SELECT date_format(date, '%Y-%m-%d') AS date \n\t\t\t\tFROM journal \n\t\t\t\tWHERE username = '******' \n\t\t\t\t\tAND date_format(date, '%Y-%m-%d') < '{$date}' \n\t\t\t\tORDER BY date DESC LIMIT 1"; $r = mysql_query($q); $row = mysql_fetch_assoc($r); $prevdate = $row['date']; } } else { print "No journal entries, sadly";
if (defined("JOURNAL_FRIENDSENTRIES")) { $limit = JOURNAL_FRIENDSENTRIES; } else { $limit = 25; } function get_cached_friends($username, $limit = 0) { if (!$limit) { $limit = JOURNAL_FRIENDSENTRIES; } $r = mysql_fetch_all(mysql_query("SELECT * FROM cache \n\t\t\t\tINNER JOIN friends ON (friends.uri = cache.friend_uri)\n\t\t\t\tWHERE friends.username = '******' \n\t\t\t\tORDER BY cache.date DESC \n\t\t\t\tLIMIT {$limit}")); foreach ($r as $key => $row) { $r[$key]['data'] = $row['body']; if (ereg('opendiary.com', $r[$key]['friend_uri'])) { $r[$key]['friend'] .= '(OD)'; } elseif (ereg('diaryland.com', $r[$key]['friend_uri'])) { $r[$key]['friend'] .= '(DL)'; } elseif (ereg('livejournal.com', $r[$key]['friend_uri'])) { $r[$key]['friend'] .= '(LJ)'; } unset($r[$key]['body']); } return $r; } $friendsentries = get_cached_friends(JOURNAL_USERNAME, $limit); if (count($friendsentries) > 0 and is_array($friendsentries)) { print format_rows($friendsentries, $limit); } else { print "No friend entries, sadly"; }