$help

" . translate ("Select forums with discussions of your interest, participate and have a lot of fun!") . "
" . translate ("The only rule here is: Stay on topic of the discussions.") . "

"; $formatstring = translate("forumdatestring"); echo "" . translate ("Today is ") . translate (date ("l")) . date (", $formatstring") . "
"; if ($userdata['lastvisit']) { echo translate ("Your last visit was on ") . "$last

" . translate ("New Posts since your last Visit") . ""; } CloseTable (); echo ""; if (isSet ($siteid)) { list ($default) = mysql_fetch_row (mysql_query ("select `default` from {$mpnTables['sites']} where siteid = $siteid")); if ($default == 'T') $add = "c.showondefault = 'T' or "; $new_sql = "select s.siteid, s.sitename, f.*, c.cat_title, cfp.totaltopics, cfp.totalposts, cfp.topic_id, ft.topic_title, ft.topic_time, cfp.post_id, cfp.poster_id, p.post_time, p.image, u.uname, cfp.modlist from {$mpnTables['forums']} f, {$mpnTables['sites']} s, {$mpnTables['categories']} c, {$mpnTables['site_categories_rel']} scr left join {$mpnTables['currentforumposts']} cfp on f.forum_id = cfp.forum_id left join {$mpnTables['posts']} p on cfp.post_id = p.post_id left join {$mpnTables['forumtopics']} ft on cfp.topic_id = ft.topic_id left join {$mpnTables['users']} u on cfp.poster_id = u.uid where s.siteid = scr.siteid and scr.cat_id = c.cat_id and ($add s.siteid = $siteid) and c.cat_id = f.cat_id"; if (isset($fcid)) $new_sql .= " and c.cat_id = $fcid"; $new_sql .= " group by f.forum_id order by s.siteid"; if (isset($fcid)) $new_sql .= ", f.forum_id"; } else { $new_sql = "select '' as siteid, '' as sitename, f.*, c.cat_title, cfp.totaltopics, cfp.totalposts, cfp.topic_id, ft.topic_title, ft.topic_time, cfp.post_id, cfp.poster_id, p.post_time, p.image, u.uname, cfp.modlist from {$mpnTables['forums']} f, {$mpnTables['categories']} c left join {$mpnTables['currentforumposts']} cfp on f.forum_id = cfp.forum_id left join {$mpnTables['posts']} p on cfp.post_id = p.post_id left join {$mpnTables['forumtopics']} ft on cfp.topic_id = ft.topic_id left join {$mpnTables['users']} u on cfp.poster_id = u.uid where c.cat_id = f.cat_id"; if (isset($fcid)) $new_sql .= " and c.cat_id = $fcid"; $new_sql .= " group by f.forum_id"; if (isset($fcid)) $new_sql .= "order by f.forum_id"; } if (!$sub_result = mysql_query($new_sql)) { echo ""; forumerror('0022'); } if(!isSet($forumborder)) $forumborder = ""; if ($myrow = mysql_fetch_array($sub_result)) { $lasttitle = ""; $loop_check = "Z"; $loopcount = 0; do { if ($loop_check != $myrow['sitename']) { if ($loopcount != 0) echo ""; echo "
" . $myrow['sitename'] . " Forums: "; } $title = stripslashes($myrow['cat_title']); if (strcmp($title, $lasttitle) != 0) { echo " "; $lasttitle = $title; } if (isSet ($myrow['post_id']) && $myrow['post_id'] != "" && $myrow['post_id'] != NULL && $myrow['post_id'] != 0) { $val2 = $myrow['image']; $val3 = strftime(translate("forumdatestring2"),strtotime($myrow['post_time'])); $val4 = $myrow['uname']; $val5 = $myrow['topic_id']; $val6 = translate("by"); $val7 = $myrow['topic_title']; if (strlen($val7) > '30') { $valT = substr($val7, 0, 27); $val8 = "$valT..."; } else $val8 = $val7; if ($myrow['forum_type'] == "1") $val8 = translate("Privates Forum"); if ($val2 != "") $pimage = ""; else $pimage = ""; $last_post = array($val2, $val3, $val4, $val5, $val6, $val8, $pimage, $myrow['forum_id']); } else $last_post = "No posts"; $newtheme = stripslashes($last_post[5]); echo " "; $total_topics = ($myrow['totaltopics'] == "" ? 0 : $myrow['totaltopics']); if (!is_null ($myrow['topic_time'])) $ulastposting = strtotime ($myrow['topic_time']); else $ulastposting = ""; if (($visit < $ulastposting) && $last_post != "No posts") echo " "; else echo " "; $name = stripslashes($myrow['forum_name']); echo " \n"; if ($myrow['forum_access']=="0" && $myrow['forum_type']=="0") echo " \n"; if ($myrow['forum_type'] == "1") echo " \n"; if ($myrow['forum_access']=="1" && $myrow['forum_type'] == "0") echo " \n"; if ($myrow['forum_access']=="2" && $myrow['forum_type'] == "0") echo " \n"; echo " \n"; $total_posts = ($myrow['totalposts'] == "" ? 0 : $myrow['totalposts']); echo " \n"; if ($last_post == "No posts") echo " \n"; else echo " \n"; $moderators = $myrow['modlist']; echo " \n"; $loop_check = $myrow['sitename']; $loopcount++; } while ($myrow = mysql_fetch_array($sub_result)); } echo "

	Forum	Type	Topics	Posts	Last Posts	Moderator
$title
		$name \n"; $desc = stripslashes($myrow['forum_desc']); echo " $desc					$total_topics	$total_posts	" . translate("No posts") . "	$last_post[6] $newtheme ($last_post[2]) $last_post[1]	"; $modlist = explode (",", $moderators); $count = 0; for ($i = 0; $i < count ($modlist); $i++) { if ($count > 0) echo ", "; echo "$modlist[$i]"; $count++; } echo "

" . translate ("Private Message") . "    " . translate ("Private Message Read/Write") . "
"; if (!$user) { echo " " . translate ("Log in to check your private message") . " "; } else { $user = base64_decode ($user); $userdata = explode (":", $user); $total_messages = mysql_num_rows (mysql_query ("SELECT msg_id FROM {$mpnTables['priv_msgs']} WHERE to_userid = '$userdata[0]'")); $new_messages = mysql_num_rows (mysql_query ("SELECT msg_id FROM {$mpnTables['priv_msgs']} WHERE to_userid = '$userdata[0]' AND read_msg='0'")); echo " "; if ($total_messages > 0) { if ($new_messages > 0) echo "$new_messages " . translate ("New Messages") . " | "; else echo translate ("No New Messages") . " | "; echo "$total_messages " . translate ("Total Messages.") . ""; } else echo translate ("You don't have any Messages.") . ""; } echo " "; searchblock (); OpenTable (); echo "

= " . translate ("New Posts since your last visit.") . " = " . translate ("No New Posts since your last visit.") . "

" . translate ("All User can Read/Write") . " " . translate ("All User can Read/Only registrated User can Write") . " " . translate ("All User can Read/Only Moderator can Write") . " " . translate ("Private Area") . "

"; CloseTable (); include ("footer.$phpEx"); ?>