";
$leftcolstart = "| ";
$midcolstart = " | | ";
$rightcolstart = " | | ";
$widerightcolstart = " | | ";
$endcolumns = " | ";
if (empty($config['isclosed']) && $configured53 == "1") {
$palPictureView = $theme['PictureView'];
if ($theme['PictureView']) {
if ($user['U_PictureView'] == "off") {
$palPictureView = 0;
}
}
$Groups = $user['U_Groups'];
if (!$Groups || $forcepublic) {
$Groups = "-4-";
$groupquery = "AND Bo_Read_Perm LIKE '%-4-%'";
if (!empty($membersonly)) {
$Groups = "-3-";
$groupquery = "AND Bo_Read_Perm LIKE '%-3-%'";
}
$Grouparray = split("-",$Groups);
$gsize = sizeof($Grouparray);
}
else {
$Grouparray = split("-",$Groups);
$gsize = sizeof($Grouparray);
$groupquery = "AND (";
$g = 0;
for ($i=0; $i<$gsize;$i++) {
if (!preg_match("/[0-9]/",$Grouparray[$i])) { continue; };
$g++;
if ($g > 1) {
$groupquery .= " OR ";
}
$groupquery .= "Bo_Read_Perm LIKE '%-$Grouparray[$i]-%'";
}
$groupquery .= ")";
}
if ($Cat && !$forcepublic) {
$CatArray = split(",",$Cat);
$CatSize = count($CatArray);
$catonly = "AND (Bo_Cat = '";
for ($i=0; $i<$CatSize; $i++) {
if (!preg_match("/[0-9]/",$CatArray[$i])) { continue; };
if ($i >= 1) {
$catonly .= "' OR Bo_Cat = '";
}
$catonly .= "$CatArray[$i]";
}
$catonly .= "')";
}
else {
$CatArray[0] = "0";
$CatSize = 1;
$catonly = "";
}
if (!empty($excludedboards)) {
$excludeArray = split(",",$excludedboards);
$excludeSize = count($excludeArray);
$andexclude = "AND Bo_Keyword != '";
for ($i=0; $i<$excludeSize; $i++) {
if ($i >= 1) {
$andexclude .= "' AND Bo_Keyword != '";
}
$andexclude .= "$excludeArray[$i]";
}
$andexclude .= "'";
}
else {
$andexclude = "";
}
$query = "
SELECT Bo_Keyword,Bo_Title,Bo_Write_Perm,Bo_Reply_Perm,Bo_Read_Perm
FROM {$config['tbprefix']}Boards
WHERE Bo_Keyword != ''
$andexclude
$groupquery
$catonly
";
$sth = $dbh -> do_query($query);
$boardquery = "AND (";
$g = 0;
while (list ($BKeyword,$BTitle,$BWritePerm,$BReplyPerm,$BReadPerm) = $dbh -> fetch_array($sth)) {
$palBoardKeys[$g] = "$BKeyword";
$palBKeyword[$BKeyword] = "$BKeyword";
$palBTitle[$BKeyword] = "$BTitle";
$palBWritePerm[$BKeyword] = "$BWritePerm";
$palBReplyPerm[$BKeyword] = "$BReplyPerm";
$palBReadPerm[$BKeyword] = "$BReadPerm";
$g++;
if ($g > 1) {
$boardquery .= " OR ";
}
$boardquery .= "B_Board = '$BKeyword'";
}
$dbh -> finish_sth($sth);
$boardquery .= ")";
$html = new html;
$date = $html -> get_date();
$query = "
SELECT Ca_TimeStamp,Ca_ShortStats,Ca_TopPosters,Ca_LastSeen,Ca_LastSeen2,Ca_RandomProfile,Ca_TopThreads,Ca_CurrentThreads,Ca_HotTopic,Ca_TopRatedPosts,Ca_News,Ca_PastThreads,Ca_CustomB1,Ca_CustomB2,Ca_CustomB3,Ca_CurrentPollName,Ca_CurrentPollVote,Ca_CurrentPollResult
FROM {$config['tbprefix']}IIPcache
WHERE Ca_Number = 1
";
$sth = $dbh -> do_query($query);
list ($LastCacheTime,$ShortStatData,$TopPostersData,$LastSeenData,$LastSeenData2,$RandProfileData,$TopThreadsData,$CurrentThreadsData,$HotTopicData,$TopRatedPostsData,$NewsData,$PastThreadsData,$CustomBox1Data,$CustomBox2Data,$CustomBox3Data,$Pol1NameData,$Pol1VoteData,$Pol1ResultsData) = $dbh -> fetch_array($sth);
$dbh -> finish_sth($sth);
if ($RefCache && $user['U_Status'] = "Administrator") {
$LastCacheTime = 0;
}
if (empty($forcepublic)) {
$TopThreadsData = "";
$Pol1NameData = "";
$Pol1VoteData = "";
$Pol1ResultsData = "";
$CurrentThreadsData = "";
$HotTopicData = "";
$TopRatedPostsData = "";
$NewsData = "";
$PastThreadsData = "";
}
$numberOfBoards = $g;
$query = "
SELECT COUNT(*)
FROM {$config['tbprefix']}Users
WHERE U_Number > 1
AND U_Approved = 'yes'
";
$sth = $dbh -> do_query($query);
list ($palShowregs) = $dbh -> fetch_array($sth);
$dbh -> finish_sth($sth);
$phpSelf = find_environmental ("PHP_SELF");
$phpSelf = split("/",$phpSelf);
$num = count($phpSelf) -1;
$phpSelf = $phpSelf[$num];
if (ereg("MSIE", find_environmental('HTTP_USER_AGENT'))) {
$xnum = 0;
$mybrowser = "MSIE";
}
else if (ereg("Netscape", find_environmental('HTTP_USER_AGENT'))) {
$xnum = 1;
$mybrowser = "Netscape";
} else {
$xnum = 2;
$mybrowser = "Other";
}
}
// send the header
$config['iip_call'] = "1";
$html = new html;
$html -> send_header($config['title'],$Cat,0,$user);
list($tbopen,$tbclose) = $html -> table_wrapper();
if ($configured53 && $VersionNotice == "" && empty($config['isclosed'])) {
if (!empty($membersonly) && empty($user['U_Number'])) {
echo "$tbopen |