function renderNav($forum = false, $announcement = false, $page = "") { global $locale, $settings, $fb4, $fdata, $db_prefix, $userdata; $caption = ""; if ($fdata['forum_parent'] !== "0") { $p_data = dbarray(dbquery("select * from " . $db_prefix . "forums f\n\t\tleft join " . $db_prefix . "fb_forums f2 on f2.forum_id=f.forum_id\n\t\twhere f.forum_id='" . $fdata['forum_parent'] . "'")); $caption .= renderParents($p_data['forum_parent']); if ($p_data['forum_parent'] == "0") { define("ROOTPARENT", $p_data['forum_id']); } $caption .= " » <a href='" . FORUM . "viewforum.php?forum_id=" . $p_data['forum_id'] . "'>" . $p_data['forum_name'] . "</a>"; } if (defined("ROOTPARENT")) { $root = dbarray(dbquery("SELECT f.*, f2.forum_name AS forum_cat_name FROM " . DB_FORUMS . " f\n\t\t\tLEFT JOIN " . DB_FORUMS . " f2 ON f.forum_cat=f2.forum_id\n\t\t\tWHERE f.forum_id='" . ROOTPARENT . "'")); $catName = $root['forum_cat_name']; } else { $catName = $fdata['forum_cat_name']; } if ($fb4['vb_nav']) { if ($fb4['forum_rules']) { $columns = 6; } else { $columns = 5; } $width = ceil(100 / $columns); $nav = "<tr>\n<td class='tbl2' colspan='2' style='padding:0px;'>\n"; $nav .= "<table width='100%' cellspacing='0' cellspacing='0'><tr>"; $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'>"; if (iMEMBER) { $nav .= "<a href='" . INFUSIONS . "fusionboard4/usercp.php'>" . $locale['fb922'] . "</a>"; } else { $nav .= "<a href='" . BASEDIR . "register.php'>" . $locale['fb910'] . "</a>"; } $nav .= "</td>\n"; if ($fb4['forum_rules']) { $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'>"; $nav .= "<a href='" . INFUSIONS . "fusionboard4/rules.php'>" . $locale['fb911'] . "</a></td>\n"; } $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'><a href='" . BASEDIR . "faq.php'>" . $locale['fb912'] . "</a></td>\n"; $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'><a href='" . BASEDIR . "members.php'>" . $locale['fb913'] . "</a></td>\n"; $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'><a href='" . INFUSIONS . "fusionboard4/today.php'>" . $locale['fb914'] . "</a></td>\n"; $nav .= "<td class='tbl2' style='text-align:center;width:{$width}%'><a href='" . BASEDIR . "search.php'>" . $locale['fb915'] . "</a></td>\n"; $nav .= "</tr>\n</table>\n</td>\n</tr>\n"; if (iMEMBER) { $login = "******"; $login .= $locale['fb923'] . "<a href='" . BASEDIR . "profile.php?lookup=" . $userdata['user_id'] . "'><b>" . $userdata['user_name'] . "</b></a>!"; if (iADMIN && !INVISIBLEMODE) { $login .= " <a href='" . FUSION_SELF . (FUSION_QUERY ? "?" . FUSION_QUERY . "&invisible=on" : "?invisible=on") . "'>[" . $locale['uc365'] . "]</a>"; } $login .= "<br />\n"; $login .= $locale['fb924'] . "<span class='small'>" . timepassed($userdata['user_lastvisit']) . "</span><br />\n"; $unread = dbcount("(message_id)", DB_MESSAGES, "message_to='" . $userdata['user_id'] . "' and message_read='0'"); $total = dbcount("(message_id)", DB_MESSAGES, "message_to='" . $userdata['user_id'] . "' and message_folder='0'"); $login .= "<a href='" . BASEDIR . "messages.php'>" . $locale['fb925'] . "</a>: " . $unread . " " . $locale['fb926'] . ", " . $total . " " . $locale['fb927'] . "\n"; $login .= "</td>\n"; } else { $login = "******" . FUSION_SELF . "'>\n"; $login .= "<img src='" . INFUSIONS . "fusionboard4/images/user.png' alt='" . $locale['global_101'] . "' title='" . $locale['global_101'] . "'> "; $login .= "<input type='text' name='user_name' class='textbox' style='width:100px' /><br />\n"; $login .= "<img src='" . INFUSIONS . "fusionboard4/images/key.png' alt='" . $locale['global_102'] . "' title='" . $locale['global_102'] . "'> "; $login .= " <input type='password' name='user_pass' class='textbox' style='width:100px' />\n"; $login .= "<input type='checkbox' name='remember_me' value='y' /> \n"; $login .= "<input type='submit' name='login' value='" . $locale['global_104'] . "' class='button' />\n"; $login .= "</form></td>\n"; } } else { $columns = false; $nav = ""; $login = ""; } $sfimage1 = file_exists(THEME . "images/folder_open.png") ? THEME . "images/folder_open.png" : INFUSIONS . "fusionboard4/images/folder_open.png"; $sfimage2 = file_exists(THEME . "images/subforum.png") ? THEME . "images/subforum.png" : INFUSIONS . "fusionboard4/images/subforum.png"; if ($forum) { $caption = $catName . $caption; echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n\t\t<tr>\n\t\t\t<td class='tbl1'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td width='1'><img src='{$sfimage1}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><a href='" . FORUM . "index.php'>" . $settings['sitename'] . "</a> » " . $caption . "</td></tr>\n\t\t\t</table>\n\t\t\t<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td style='width:31px;' align='right'><img src='{$sfimage2}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><b><a href='viewforum.php?forum_id=" . $fdata['forum_id'] . "'>" . $fdata['forum_name'] . "</a></b></td></tr>\n\t\t\t</table>\n\t\t\t</td>{$login}\n\t\t</tr>"; } elseif ($announcement) { echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n\t\t<tr>\n\t\t\t<td class='tbl1'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td width='1'><img src='{$sfimage1}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><a href='" . FORUM . "index.php'>" . $settings['sitename'] . "</a> » " . $locale['fb900'] . "</td></tr>\n\t\t\t</table>\n\t\t\t<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td style='width:31px;' align='right'><img src='" . INFUSIONS . "fusionboard4/images/exclamation.png' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><b><a href='" . FUSION_SELF . "?thread_id=" . $fdata['thread_id'] . "&rowstart=0'>" . $fdata['thread_subject'] . "</a></b></td></tr>\n\t\t\t</table>\n\t\t\t</td>{$login}\n\t\t</tr>"; } elseif ($page) { $caption = $catName . $caption . " » <a href='viewforum.php?forum_id=" . $fdata['forum_id'] . "'>" . $fdata['forum_name'] . "</a>"; echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n\t\t<tr>\n\t\t\t<td class='tbl1'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td width='1'><img src='{$sfimage1}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><a href='" . FORUM . "index.php'>" . $settings['sitename'] . "</a></td></tr>\n\t\t\t</table>\n\t\t\t<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td style='width:31px;' align='right'><img src='{$sfimage2}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><b><a href='" . $page[0] . "'>" . $page[1] . "</a></b></td></tr>\n\t\t\t</table>\n\t\t\t</td>{$login}\n\t\t</tr>"; } else { $caption = $catName . $caption . " » <a href='viewforum.php?forum_id=" . $fdata['forum_id'] . "'>" . $fdata['forum_name'] . "</a>"; echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n\t\t<tr>\n\t\t\t<td class='tbl1'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td width='1'><img src='{$sfimage1}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><a href='" . FORUM . "index.php'>" . $settings['sitename'] . "</a> » " . $caption . "</td></tr>\n\t\t\t</table>\n\t\t\t<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n\t\t\t<tr><td style='width:31px;' align='right'><img src='{$sfimage2}' alt=''></td>\n\t\t\t<td style='padding-left:3px;'><b><a href='" . FUSION_SELF . "?thread_id=" . $fdata['thread_id'] . "&rowstart=0'>" . $fdata['thread_subject'] . "</a></b></td></tr>\n\t\t\t</table>\n\t\t\t</td>{$login}\n\t\t</tr>"; } echo $nav; if (INVISIBLEMODE) { echo "<tr>\n<td class='tbl2' style='text-align:center;font-weight:bold;padding:7px;' colspan='" . ($columns + 2) . "'>"; echo $locale['uc358'] . "<a href='" . FUSION_SELF . (FUSION_QUERY ? "?" . FUSION_QUERY . "&invisible=off" : "?invisible=off") . "'>"; echo $locale['uc359'] . "</a>" . $locale['uc360']; echo "</td>\n</tr>\n"; } echo "</table><br />\n"; }
function showcomments($ctype, $cdb, $ccol, $cid, $clink, $ingroup) { global $settings, $locale, $userdata, $aidlink; if (iMEMBER && (isset($_GET['c_action']) && $_GET['c_action'] == "edit") && (isset($_GET['comment_id']) && isnum($_GET['comment_id']))) { $eresult = dbquery("SELECT tcm.*,user_name FROM " . DB_COMMENTS . " tcm\n\t\t\tLEFT JOIN " . DB_USERS . " tcu ON tcm.comment_name=tcu.user_id\n\t\t\tWHERE comment_id='" . $_GET['comment_id'] . "' AND comment_item_id='" . $cid . "' AND comment_type='" . $ctype . "'"); if (dbrows($eresult)) { $edata = dbarray($eresult); if (iADMIN && checkrights("C") || iMEMBER && $edata['comment_name'] == $userdata['user_id'] && isset($edata['user_name'])) { $clink .= "&c_action=edit&comment_id=" . $edata['comment_id']; $comment_message = $edata['comment_message']; } } else { $comment_message = ""; } } else { $comment_message = ""; } if (iMEMBER && $ingroup) { add_to_head("<script type='text/javascript'>window.onload=setTimeout(\"hideall()\", 250);\n\t\tfunction hideall(){\n\t\t\tdocument.getElementById('bbcode').style.display='none';\n\t\t}\n\t\tfunction showhide(msg_id) {\n\t\t document.getElementById(msg_id).style.display = document.getElementById(msg_id).style.display == 'none' ? 'block' : 'none';\n\t\t}</script>\n"); require_once INCLUDES . "bbcode_include.php"; echo "<a id='edit_comment' name='edit_comment'></a>\n"; echo "<form name='inputform' method='post' action='" . $clink . "'>\n"; echo "<div align='center'>\n"; echo "<textarea name='comment_message' rows='2' class='textbox' style='width:90%'>" . $comment_message . "</textarea><br />\n"; echo "<input type='submit' name='post_comment' value='" . $locale['uc283'] . "' class='button' /> :: <a onClick='showhide(\"bbcode\")'>" . $locale['uc285'] . "</a>\n"; echo "<div id='bbcode'><br />" . display_bbcodes("360px", "comment_message") . "</div>\n"; echo "</div>\n</form>\n"; } else { echo "<div align='center'>" . $locale['uc289'] . "</div>\n"; } echo "</td>\n</tr>\n"; echo "<tr>\n<td class='tbl1' style='padding:6px;'>\n"; if (iMEMBER && (isset($_GET['c_action']) && $_GET['c_action'] == "delete") && (isset($_GET['comment_id']) && isnum($_GET['comment_id']))) { if (iADMIN && checkrights("C") || iMEMBER && dbcount("(comment_id)", DB_COMMENTS, "comment_id='" . $_GET['comment_id'] . "' AND comment_name='" . $userdata['user_id'] . "'")) { $result = dbquery("DELETE FROM " . DB_COMMENTS . " WHERE comment_id='" . $_GET['comment_id'] . "'" . (iADMIN ? "" : " AND comment_name='" . $userdata['user_id'] . "'")); } redirect($clink); } if ((iMEMBER || $settings['guestposts'] == "1") && isset($_POST['post_comment'])) { if (iMEMBER) { $comment_name = $userdata['user_id']; } elseif ($settings['guestposts'] == "1") { $comment_name = trim(stripinput($_POST['comment_name'])); $comment_name = preg_replace("(^[0-9]*)", "", $comment_name); if (isnum($comment_name)) { $comment_name = ""; } } $comment_message = trim(stripinput(censorwords($_POST['comment_message']))); if (iMEMBER && (isset($_GET['c_action']) && $_GET['c_action'] == "edit") && (isset($_GET['comment_id']) && isnum($_GET['comment_id']))) { $comment_updated = false; if (iADMIN && checkrights("C") || iMEMBER && dbcount("(comment_id)", DB_COMMENTS, "comment_id='" . $_GET['comment_id'] . "' AND comment_name='" . $userdata['user_id'] . "'")) { if ($comment_message) { $result = dbquery("UPDATE " . DB_COMMENTS . " SET comment_message='{$comment_message}' WHERE comment_id='" . $_GET['comment_id'] . "'" . (iADMIN ? "" : " AND comment_name='" . $userdata['user_id'] . "'")); $comment_updated = true; } } if ($comment_updated) { $c_start = (ceil(dbcount("(comment_id)", DB_COMMENTS, "comment_id<='" . $_GET['comment_id'] . "' AND comment_item_id='" . $cid . "' AND comment_type='" . $ctype . "'") / 10) - 1) * 10; } redirect($clink . "&rstart=" . (isset($c_start) && isnum($c_start) ? $c_start : "")); } else { if (!dbcount("(" . $ccol . ")", $cdb, $ccol . "='" . $cid . "'")) { redirect(BASEDIR . "index.php"); } if ($comment_name && $comment_message) { require_once INCLUDES . "flood_include.php"; if (!flood_control("comment_datestamp", DB_COMMENTS, "comment_ip='" . USER_IP . "'")) { $result = dbquery("INSERT INTO " . DB_COMMENTS . " (comment_item_id, comment_type, comment_name, comment_message, comment_datestamp, comment_ip) VALUES ('{$cid}', '{$ctype}', '{$comment_name}', '{$comment_message}', '" . time() . "', '" . USER_IP . "')"); } } $c_start = (ceil(dbcount("(comment_id)", DB_COMMENTS, "comment_item_id='" . $cid . "' AND comment_type='" . $ctype . "'") / 10) - 1) * 10; redirect($clink . "&rstart=" . $c_start); } } echo "<a id='comments' name='comments'></a>"; $c_rows = dbcount("(comment_id)", DB_COMMENTS, "comment_item_id='{$cid}' AND comment_type='{$ctype}'"); if (!isset($_GET['c_start']) || !isnum($_GET['c_start'])) { $_GET['c_start'] = 0; } $result = dbquery("SELECT tcm.*,tcu.* FROM " . DB_COMMENTS . " tcm\n\t\tLEFT JOIN " . DB_USERS . " tcu ON tcm.comment_name=tcu.user_id\n\t\tWHERE comment_item_id='{$cid}' AND comment_type='{$ctype}'\n\t\tORDER BY comment_datestamp DESC LIMIT " . $_GET['c_start'] . ",10"); if (dbrows($result)) { $i = $_GET['c_start'] + 1; if ($c_rows > 10) { echo "<div style='text-align:center;margin-bottom:5px;'>" . makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink . "&") . "</div>\n"; } echo "<table width='100%' cellspacing='1' cellpadding='0'>\n"; while ($data = dbarray($result)) { echo "<tr><td class='tbl2' rowspan='2' width='1'>\n"; if ($data['user_avatar']) { list($width, $height) = getimagesize(IMAGES . "avatars/" . $data['user_avatar']); $new_width = 70; $new_height = $height * ($new_width / $height); echo "<img src='" . IMAGES . "avatars/" . $data['user_avatar'] . "' alt='' style='width:" . $new_width . "px;height:" . $new_height . "px'>\n"; } else { echo "<img src='" . IMAGES . "noav.gif' alt='' style='width:70px;height:70px'>\n"; } echo "</td>\n<td class='tbl2' style='height:30px;'>"; if (iADMIN && checkrights("C") || iMEMBER && $data['comment_name'] == $userdata['user_id'] && isset($data['user_name'])) { echo "<div style='float:right'>\n<a href='" . FUSION_REQUEST . "&c_action=edit&comment_id=" . $data['comment_id'] . "#edit_comment'>" . $locale['c108'] . "</a> |\n"; echo "<a href='" . FUSION_REQUEST . "&c_action=delete&comment_id=" . $data['comment_id'] . "'>" . $locale['c109'] . "</a>\n</div>\n"; } echo "<a href='" . FUSION_REQUEST . "#c" . $data['comment_id'] . "' id='c" . $data['comment_id'] . "' name='c" . $data['comment_id'] . "'>#" . $i . "</a> | "; echo "<a href='" . BASEDIR . "profile.php?lookup=" . $data['comment_name'] . "'>" . showLabel($data['comment_name']) . "</a>\n"; echo "<span class='small'>" . timepassed($data['comment_datestamp']) . "</span></td></tr>\n<tr><td class='tbl1' style='vertical-align:top;'>\n"; echo nl2br(parseubb(parsesmileys($data['comment_message']))) . "</td></tr>\n"; $i++; } echo "</table>"; if (iADMIN && checkrights("C")) { echo "<div align='right' class='tbl2'><a href='" . ADMIN . "comments.php" . $aidlink . "&ctype={$ctype}&cid={$cid}'>" . $locale['c106'] . "</a></div>\n"; } if ($c_rows > 10) { echo "<div style='text-align:center;margin-top:5px;'>" . makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink . "&") . "</div>\n"; } } else { echo $locale['uc284'] . "\n"; } }
while ($data = dbarray($result)) { $members = dbquery("SELECT * FROM " . DB_USERS . " WHERE user_groups REGEXP('^\\\\.{$data['group_id']}\$|\\\\.{$data['group_id']}\\\\.|\\\\.{$data['group_id']}\$') or user_groups='" . $data['group_id'] . "' ORDER BY user_level DESC, user_name"); $members = dbrows($members); $wallposts = dbcount("(comment_id)", DB_COMMENTS, "comment_type='g' and comment_item_id='" . $data['group_id'] . "'"); echo "<tr>\n<td class='tbl2' style='padding:7px;'><span style='font-size:13px;'><a href='" . FUSION_SELF . "?section=groups&view=" . $data['group_id'] . "' style='text-decoration:underline;'>" . $data['group_name'] . "</a></span>\n"; if ($data['group_description']) { echo "<br />\n<span class='small'>" . trimlink($data['group_description'], 30) . "</span>\n"; } echo "</td>\n"; echo "<td class='tbl1' style='white-space:nowrap;padding:7px;'>" . timePassed($data['group_created'], false) . "</td>\n"; echo "<td class='tbl2' style='text-align:center;padding:7px;'>{$members}</td>\n"; echo "<td class='tbl1' style='text-align:center;padding:7px;'>{$wallposts}</td>\n"; echo "<td class='tbl2' style='padding:7px;'>"; if ($wallposts) { $latest = dbarray(dbquery("select c.*, u.* from " . DB_COMMENTS . " c\n\t\t\t\tleft join " . DB_USERS . " u on u.user_id=c.comment_name\n\t\t\t\twhere c.comment_type='g' and c.comment_item_id='" . $data['group_id'] . "' order by c.comment_datestamp desc limit 1")); echo timepassed($latest['comment_datestamp']) . "<br />\n"; echo $locale['uc282'] . "<a href='" . BASEDIR . "profile.php?lookup=" . $latest['user_id'] . "'>" . showLabel($latest['user_id']) . "</a>\n"; } else { echo $locale['uc281']; } echo "</td>\n</tr>\n"; } } else { echo "<tr>\n<td class='tbl1' style='text-align:center;'>" . $locale['uc258'] . "</td>\n</tr>\n"; } echo "<tr>\n<td class='tbl1' style='text-align:center;'" . ($rows ? " colspan='5'" : "") . ">" . (checkgroup($fb4['group_create']) ? "<a href='" . FUSION_SELF . "?section=groups&action=create'>" . $locale['uc256'] . "</a> :: " : "") . "<a href='" . FUSION_SELF . "?section=groups&action=search'>" . $locale['uc257'] . "</a></td>\n</tr>\n"; } if (!defined("USER_CP")) { echo "</table>\n</td>\n</tr>\n</table>\n"; closetable(); require_once THEMES . "templates/footer.php";
} echo "<td>\n<div class='tbl2 users'>\n"; if ($user['user_avatar']) { list($width, $height) = getimagesize(IMAGES . "avatars/" . $user['user_avatar']); $new_width = 70; $new_height = $height * ($new_width / $height); echo "<div style='float:left;height:70px;'>\n<img src='" . IMAGES . "avatars/" . $user['user_avatar'] . "' alt='' style='padding-right:5px;width:" . $new_width . "px;height:" . $new_height . "px'>\n</div>\n"; } else { echo "<div style='float:left;height:70px;'>\n<img src='" . IMAGES . "noav.gif' alt='' style='padding-right:5px;width:70px;height:70px'>\n</div>\n"; } echo "<div style='float:right;'><a href='" . FUSION_SELF . "?section=buddies&cancel=" . $data['buddy_id'] . "'>" . $locale['uc232'] . "</a></div>\n"; echo "<a href='" . BASEDIR . "profile.php?lookup=" . $user['user_id'] . "'>" . showLabel($user['user_id']) . "</a>\n"; if ($fb4['user_titles']) { echo "<br />" . showtitle($user) . "\n"; } echo "<br /><span class='small'>Last Seen: " . timepassed($user['user_lastvisit'], false) . "</span><br /><br />\n"; echo "</div>\n</td>\n"; $counter++; } echo "</tr>\n</table>\n"; } else { echo "<div align='center'>" . $locale['uc223'] . "</div>\n"; } echo "</fieldset>\n</div>\n</td></tr>\n"; echo "<tr>\n<td class='tbl2 navsection'>" . $locale['uc222'] . "</td>\n</tr>\n<tr>\n<td class='tbl1'>\n"; echo "<div align='center'>\n"; echo "<fieldset class='fields' style='width:500px;'><legend><a name=''>" . $locale['uc222'] . "</a></legend>\n"; add_to_title(" :: " . $locale['uc220']); echo "<form action='" . FUSION_SELF . "?section=buddies' method='post' name='addform'>\n"; echo $locale['uc225'] . "<br />\n<br />\n<input type='text' name='username' class='textbox' style='width:200px;'>\n"; echo "<input type='submit' name='addBuddy' value='" . $locale['uc222'] . "' class='button'><br /><br />\n" . $locale['uc226'] . "\n</form>\n";