Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Errora meta

Parašė bruzgis· 2008 Rugp. 4 19:08:33
#3

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
|                SIB-BOARDS v 2.0
|       S.P.I.K.E.R.  Russia Krasnoyarsk
|              www.sib-fusion.ru
|               SIBERIA-FUSION
|                   2008 (c)
+----------------------------------------------------*/
require_once "../../maincore.php";
require_once BASEDIR."subheader.php";
include "core.php";
include "side_left.php";

define("SAFEMODE", @ini_get("safe_mode") ? true : false);
define("BOARDPHOTOS", IMAGES."board/");     
     
if ($brdsettings['board_images_graphic'] != "none") echo "<script type='text/javascript' src='".INFUSIONS."board/includes/grafics/".$brdsettings['board_images_graphic'].".js'></script>";     
     
if (isset($board_id) && !isNum($board_id)) fallback(BASEDIR."index.php");
$numofthreads = $brdsettings['numofthreads'];


if (strftime("%d%m%Y", $brdsettings['date_autoprune']) != strftime("%d%m%Y", time())) {
$result = dbquery("SELECT * FROM ".$db_prefix."boards WHERE board_date_end < '".time()."'");
$delboards = dbrows($result);
if ($delboards != 0) {
   while ($data = dbarray($result)) {
   $comments = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_item_id='".$data['board_id']."' and comment_type='Z'");
   $ratings = dbquery("DELETE FROM ".$db_prefix."ratings WHERE rating_item_id='".$data['board_id']."' and rating_type='Z'");
   $photo = dbquery("SELECT * FROM ".$db_prefix."board_photo WHERE photo_board_id='".$data['board_id']."'");
   while ($dataphoto = dbarray($photo)) {
   if ($dataphoto['photo_filename']) @unlink(BOARDPHOTOS.$data['board_user_id']."_".$dataphoto['photo_board_id']."/".$dataphoto['photo_filename']);
   if ($dataphoto['photo_thumb1']) @unlink(BOARDPHOTOS.$data['board_user_id']."_".$dataphoto['photo_board_id']."/".$dataphoto['photo_thumb1']);
   if ($dataphoto['photo_thumb2']) @unlink(BOARDPHOTOS.$data['board_user_id']."_".$dataphoto['photo_board_id']."/".$dataphoto['photo_thumb2']);
         }
         @unlink(BOARDPHOTOS.$data['board_user_id']."_".$data['board_id']."/index.php");         
         if (!SAFEMODE) rmdir(BOARDPHOTOS.$data['board_user_id']."_".$data['board_id']);
                }
$result = dbquery("DELETE FROM ".$db_prefix."boards WHERE board_date_end < '".time()."'");
$result = dbquery("UPDATE ".$db_prefix."board_settings SET date_autoprune='".time()."'");
redirect(FUSION_SELF);
              }
   }

if ($step == "delete") {
if (!iADMIN || !defined("iAUTH") || $aid != iAUTH) fallback(BASEDIR."index.php");
   $result = dbquery("DELETE FROM ".$db_prefix."boards WHERE board_id='$del_id'");
   $result = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_item_id='$del_id' and comment_type='Z'");
   $result = dbquery("DELETE FROM ".$db_prefix."ratings WHERE rating_item_id='$del_id' and rating_type='Z'");
   $result1 = dbquery("SELECT * FROM ".$db_prefix."board_photo WHERE photo_board_id='$del_id'");
      while ($data = dbarray($result1)) {
   if ($data['photo_filename']) @unlink(BOARDPHOTOS.$uid."_".$data['photo_board_id']."/".$data['photo_filename']);
   if ($data['photo_thumb1']) @unlink(BOARDPHOTOS.$uid."_".$data['photo_board_id']."/".$data['photo_thumb1']);
   if ($data['photo_thumb2']) @unlink(BOARDPHOTOS.$uid."_".$data['photo_board_id']."/".$data['photo_thumb2']);
         }
         @unlink(BOARDPHOTOS.$uid."_".$del_id."/index.php");         
         if (!SAFEMODE) rmdir(BOARDPHOTOS.$uid."_".$del_id);
         $result = dbquery("DELETE FROM ".$db_prefix."board_photo WHERE photo_board_id='$del_id'");
   redirect(INFUSIONS."board/index.php?cat_id=$cat_id");
}

if (!isset($cat_id)) {
   opentable($locale['sb_01']);
   
   $result = dbquery("SELECT * FROM ".$db_prefix."board_cats WHERE board_cat_up='-1' ORDER BY board_cat_order");
   $rows = dbrows($result);
   if ($rows != 0) {
      $counter = 0; $columns = $brdsettings['column_per_page'];
      $cwidth = floor (100/$columns);
      echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
      while ($data = dbarray($result)) {
         if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
         $OCnum = dbcount("(*)", "board_cats", "board_cat_up='".$data['board_cat_id']."'");
         echo "<td align='left' valign='top' width='$cwidth%' class='tbl'><b>".$data['board_cat_name']."</b><br>\n";
         if ($OCnum != 0) {
         $result1 = dbquery("SELECT * FROM ".$db_prefix."board_cats WHERE board_cat_up='".$data['board_cat_id']."' ORDER BY board_cat_order");
         while ($data1 = dbarray($result1)) {
         $OBnum = dbcount("(*)", "boards", "board_sub_cat='".$data1['board_cat_id']."'");
         echo "<a href='".FUSION_SELF."?cat_id=".$data1['board_cat_id']."'>".$data1['board_cat_name']."</a> <span class='small2'>($OBnum)</span><br>\n";
            }
         } else echo "<span class='small2'>".$locale['sb_545']."</span>";
         
         echo "</td>\n" ;
         $counter++;
      }
      echo "</tr>\n</table>\n";
   } else {
      echo "<center><span class='small2'>".$locale['sb_545']."</span></center>\n";
   }
   closetable();
} else {
   $res = 0;
   if (!isNum($cat_id)) fallback(FUSION_SELF);
   $result = dbquery("SELECT a.*, c.* FROM ".$db_prefix."boards a
   LEFT JOIN ".$db_prefix."board_cats c ON a.board_sub_cat=c.board_cat_id
   WHERE board_sub_cat='$cat_id'");
   if (dbrows($result) != 0) {
      $cdata = dbarray($result);
         $res = 1;
         opentable($cdata['board_cat_name'].": ".$cdata['board_title']);
   

   if ($brdsettings['board_no_city'] != "1"){   
if (isNum($c)) {
$subcat = dbquery("SELECT * FROM ".$db_prefix."board_city  WHERE board_city_ob='".$o."' ORDER BY board_city_name");
       if (dbrows($subcat) != 0) {
                while ($datasubcat = dbarray($subcat)) {
             $sel = ($c == $datasubcat['board_city_id'] ? " selected" : "");
                        $subcatlist .= "<option value='".$datasubcat['board_city_id']."'$sel>".$datasubcat['board_city_name']."</option>";               
                }
         }
   $select_city   = $subcatlist;   
   $disabled = " name='c'";
   } else {   
   $select_city   = "<option value=''>--------------</option>";   
    $disabled = " disabled='1'";   
}
echo "<div class='infobar'><form name='' method='post' action='".FUSION_SELF."'>
<input type='hidden' name='cat_id' value='$cat_id'>
<font id='ob'><select class='textbox'>
<option value=''>--------------</option></select></font>&nbsp;<font id='city'><select class='textbox'$disabled>$select_city</select></font>&nbsp;&nbsp;<input type='submit' name='' value='".$locale['sb_048']."' class='button'></form></div>";
$viewob = "o=".$o."&";
include "includes/jscript_ob.php";
if (isNum($o)) {$filterob = " AND board_ob='$o'"; $filterNav_o = "o=$o&amp;";} else {$filterob = ""; $filterNav_o = "";}
if (isNum($c)) {$filtercity = " AND board_city='$c'"; $filterNav_c = "c=$c&amp;";} else {$filtercity = ""; $filterNav_c = "";}
$filterAll = $filterob.$filtercity;
$filterNav = $filterNav_o.$filterNav_c;
 } else {
$filterAll = "";
$filterNav = "";
}
         $rows = dbcount("(*)", "boards", "board_sub_cat='$cat_id'".$filterAll);
         if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
         if ($rows != 0) {
            $result = dbquery("SELECT a.*, u.*, p.*, c.board_city_name AS city_name, co.board_city_name AS ob_name FROM ".$db_prefix."boards a
               LEFT JOIN ".$db_prefix."users u ON a.board_user_id=u.user_id
               LEFT JOIN ".$db_prefix."board_term p ON a.board_term=p.board_term_id
               LEFT JOIN ".$db_prefix."board_city c ON a.board_city=c.board_city_id
               LEFT JOIN ".$db_prefix."board_city co ON c.board_city_ob=co.board_city_id
            WHERE board_sub_cat='$cat_id'".$filterAll." ORDER BY board_datestamp DESC LIMIT $rowstart,$numofthreads");
       $numrows = dbrows($result); $i = 1;
       while ($data = dbarray($result)) {
         $new = ($data['board_datestamp']+604800 > time()+($settings['timeoffset']*3600) ? "<img src='".INFUSIONS."board/images/new.gif' alt='' border='0'>" : "");
       echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>
         <td><table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>
         <td class='tbl'><h2>".$data['board_title']." $new</h2></td>
         <td class='tbl' width='1%' style='white-space:nowrap'>";
   if (iADMIN) echo "<a href='#info$i' rel='facebox'>".$locale['sb_546']."</a><a href='".INFUSIONS."board/add.php?step=edit&amp;board_id=".$data['board_id']."'>".$locale['sb_547']."</a><a href='".INFUSIONS."board/photos.php?photo_id=".$data['board_id']."&amp;status=sd&amp;uid=".$data['board_user_id']."'>".$locale['sb_578']."</a><a href='".FUSION_SELF.$aidlink."&amp;step=delete&amp;uid=".$data['board_user_id']."&amp;del_id=".$data['board_id']."&amp;cat_id=".$data['board_sub_cat']."' onClick='return DeleteItem()'>".$locale['sb_548']."</a>\n";
   echo "<div id='info$i' style='display:none;white-space:nowrap'>";
   $avatar = ($data['user_avatar'] != "" ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='' align='left'>" : "<img src='".INFUSIONS."board/images/no_avatar.gif' alt='' align='left'>");
   echo $avatar;
   echo $locale['sb_549']."<b>".$data['user_name']."</b><br>\n";
   echo $locale['sb_550']."<b>".showdate("longdate", $data['user_joined'])."</b><br>\n";
   echo $locale['sb_551']."<b>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['sb_552'])."</b><br>\n";
   echo $locale['sb_553']."<b>".$data['user_ip']."</b>\n";
   echo "</div>";
   echo "</td></tr></table></td></tr>
    <tr><td class='tbl' valign='top'>".parseubb(nl2br(stripslashes($data['board_description'])))."</td></tr><tr>
    <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>
    <td class='tbl' valign='top'>";
   if($data['board_term'] != "0")  echo $locale['sb_306'].":&nbsp;".$data['board_term_name']."<br>\n";
   if($data['board_age'] != "")  echo $locale['sb_465'].":&nbsp;".$data['board_age']."<br><br>\n";
   echo "<b>".$locale['sb_554']."</b><br>\n";
   echo $locale['sb_484'].":&nbsp;";
   if ($brdsettings['board_no_city'] != "1"){
   echo $data['ob_name'].",&nbsp;".$locale['sb_414']."&nbsp;".$data['city_name']."<br>\n";
}
    echo "&nbsp;".$data['board_street']." ".opt_street($data['board_street_type']).",&nbsp;".$locale['sb_457']."&nbsp;".$data['board_house'];
   if ($data['board_corpus']) echo ",&nbsp;".$locale['sb_458']."&nbsp;".$data['board_corpus'];
   echo "<br>\n";
   if ($brdsettings['board_no_google'] != "1") {
   if ($data['board_google'] != "0") echo $locale['sb_412']."<a href=\"javascript:;\" onclick=\"window.open('includes/map.php?map_id=".$data['board_id']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=545,height=515')\">".$locale['sb_415']."</a><br>\n";
   }
   if ($data['board_telephone']) echo $locale['sb_460'].":&nbsp;".$data['board_telephone']."<br>\n";
   if ($data['board_fax']) echo $locale['sb_462'].":&nbsp;".$data['board_fax']."<br>\n";
   if ($data['board_icq']) echo $locale['sb_463'].":&nbsp;".$data['board_icq']."<br>\n";
   if ($data['board_email']) echo $locale['sb_464'].":&nbsp;<a href='mailto:".str_replace("@","&#64;",$data['board_email'])."'>".str_replace("@","&#64;",$data['board_email'])."</a><br>\n";
   if ($data['board_url']) echo $locale['sb_461'].":&nbsp;<a href='http://".$data['board_url']."'target='_blank''>".$data['board_url']."</a>";
   echo "</td>
    <td class='tbl' width='40%' valign='top' style='white-space:nowrap'>";
   $result2 = dbquery("SELECT * FROM ".$db_prefix."board_photo WHERE photo_board_id='".$data['board_id']."' ORDER BY photo_id LIMIT 0,3");
   echo "<table cellpadding='0' cellspacing='0'>\n<tr>\n";
   $k = 0;
   while ($data2 = dbarray($result2)) {
      if ($data2['photo_thumb1'] && file_exists(BOARDPHOTOS.$data['board_user_id']."_".$data['board_id']."/".$data2['photo_thumb1'])){
      echo "<td width='$photo_size' class='tbl' valign='top'>";
         echo "<a href='#photo$k' rel='facebox'><img class='".($brdsettings['board_images_graphic'] != "none" ? $brdsettings['board_images_graphic'] : "")."' src='".BOARDPHOTOS.$data['board_user_id']."_".$data['board_id']."/".$data2['photo_thumb1']."' alt='' border='0'></a></td>\n";
         echo "<div id='photo$k' style='display:none;'><img src='".BOARDPHOTOS.$data['board_user_id']."_".$data['board_id']."/".$data2['photo_filename']."' alt='' border='0'></div>";
      }
      $k++;
   }
      echo "</tr></table></td>\n";
   
   echo "</td></tr></table></td></tr></table>\n";
echo "<div class='infobar' align='center'>".$locale['sb_044']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a> &middot; ".$locale['sb_560'].showdate("longdate", $data['board_datestamp'])." (".$locale['sb_604'].$data['board_term_text'].")";

   if ($brdsettings['board_no_comments'] != "1"){
$board_comments = dbcount("(comment_id)", "comments", "comment_type='Z' AND comment_item_id='".$data['board_id']."'");
echo " &middot; <a href='read.php?board_id=".$data['board_id']."'>".$locale['sb_559']."</a>($board_comments)";
}

   if ($brdsettings['board_no_ratings'] != "1"){
   $data3 = dbarray(dbquery("SELECT SUM(rating_vote) AS sum_rating, COUNT(rating_item_id) AS count_votes FROM ".$db_prefix."ratings WHERE rating_item_id='".$data['board_id']."' AND rating_type='Z'"));
echo " &middot; <a href='read.php?board_id=".$data['board_id']."'>".$locale['sb_561']."</a>".($data3['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data3['sum_rating'] / $data3['count_votes'])) : $locale['sb_562']);
}
echo " &middot; <a href='read.php?board_id=".$data['board_id']."'>".$locale['sb_563']."</a>(".$data['board_count'].")";
echo "</div>";
   if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='30' width='1'></div>\n"; $i++; }
            }
            closetable();
            if ($rows > $numofthreads) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$numofthreads,$rows,3,FUSION_SELF."?cat_id=$cat_id&amp;".$filterNav)."\n</div>\n";
         } else {
            echo $locale['sb_049']."\n";
            closetable();
         }
   }
   if ($res == 0) redirect(FUSION_SELF);
}
echo "<script type='text/javascript'>
function DeleteItem()
{
return confirm('".$locale['sb_quest_delete']."');
}
jQuery(document).ready(function($) {
  $('a[rel*=facebox]').facebox()
})
</script>\n";
include "side_right.php";
require_once BASEDIR."footer.php";

?>




Bandyk sita