Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Kategorijos torrenttrader

Parašė Pario· 2008 Lie. 15 20:07:31
#1
Tai va susidūriau su šioke tokia problema nesugalvoju niekaip kaip pasidaryti prie kategorijų kad man rodytų ir kategorijo paveiksliuką



Gal kas gali padėt ?

čia browse.php failas
<?
//
// - Theme And Language Updated 25.Nov.05
//
ob_start("ob_gzhandler");
require_once("backend/functions.php");

dbconn(false);

loggedinorreturn();
if ($RATIO_WARNINGON && $CURUSER)
{
    include("ratiowarn.php");
}

function getmicrotime(){
    list($usec, $sec) = explode(" ",microtime());
    return ((float)$usec + (float)$sec);
}

$time_start = getmicrotime();

$cats = genrelist();

$searchstr = unesc($_GET["search"]);
$cleansearchstr = searchfield($searchstr);
if (empty($cleansearchstr))
unset($cleansearchstr);

$orderby = "ORDER BY torrents.id DESC";

$addparam = "";
$wherea = array();
$wherecatina = array();


$category = $_GET["cat"];

$all = $_GET["all"];

if (!$all)
if (!$_GET && $CURUSER["notifs"])
{
  $all = True;
  foreach ($cats as $cat)
  {
    $all &= $cat[id];
    if (strpos($CURUSER["notifs"], "[cat" . $cat[id] . "]") !== False)
    {
      $wherecatina[] = $cat[id];
      $addparam .= "c$cat[id]=1&amp;";
    }
  }
}
elseif ($category)
{
  if (!is_valid_id($category))
    stderr("Klaida", "Netinkamas kategorijos ID $category.");
  $wherecatina[] = $category;
  $addparam .= "cat=$category&amp;";
}
else
{
  $all = True;
  foreach ($cats as $cat)
  {
    $all &= $_GET["c$cat[id]"];
    if ($_GET["c$cat[id]"])
    {
      $wherecatina[] = $cat[id];
      $addparam .= "c$cat[id]=1&amp;";
    }
  }
}

if ($all)
{
$wherecatina = array();
 $addparam = "";
}

if (count($wherecatina) > 1)
$wherecatin = implode(",",$wherecatina);
elseif (count($wherecatina) == 1)
$wherea[] = "category = $wherecatina[0]";

$wherebase = $wherea;

if ($_GET["incldead"] == 2)
$wherea[] = "visible = 'no'";
else
$wherea[] = "visible = 'yes'";

if (isset($cleansearchstr))
{
$wherea[] = "MATCH (search_text, ori_descr) AGAINST (" . sqlesc($searchstr) . ")";
//$wherea[] = "0";
$addparam .= "search=" . urlencode($searchstr) . "&amp;";
$orderby = "";
}

$where = implode(" AND ", $wherea);
if ($wherecatin)
$where .= ($where ? " AND " : "") . "category IN(" . $wherecatin . ")";

if ($where != "")
$where = "WHERE $where";

$res = mysql_query("SELECT COUNT(*) FROM torrents $where") or die(mysql_error());
$row = mysql_fetch_array($res);
$count = $row[0];

if (!$count && isset($cleansearchstr)) {
$wherea = $wherebase;
$orderby = "ORDER BY id DESC";
$searcha = explode(" ", $cleansearchstr);
$sc = 0;
foreach ($searcha as $searchss) {
 if (strlen($searchss) <= 1)
  continue;
 $sc++;
 if ($sc > 5)
  break;
 $ssa = array();
 foreach (array("search_text", "ori_descr") as $sss)
  $ssa[] = "$sss LIKE '%" . sqlwildcardesc($searchss) . "%'";
 $wherea[] = "(" . implode(" OR ", $ssa) . ")";
}
if ($sc) {
 $where = implode(" AND ", $wherea);
 if ($where != "")
  $where = "WHERE $where";
 $res = mysql_query("SELECT COUNT(*) FROM torrents $where");
 $row = mysql_fetch_array($res);
 $count = $row[0];
}
}


if ($count)
{
list($pagertop, $pagerbottom, $limit) = pager(25, $count, "browse.php?" . $addparam);
   $query = "SELECT torrents.id, torrents.category, torrents.leechers, torrents.nfo, torrents.seeders, torrents.name, torrents.times_completed, torrents.size,torrents.added, torrents.comments,torrents.numfiles,torrents.filename,torrents.owner,IF(torrents.nfo <> '', 1, 0) as nfoav," .

   "IF(torrents.numratings < $minvotes, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, categories.name AS cat_name, categories.image AS cat_pic, users.username, users.privacy FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where $orderby $limit";
$res = mysql_query($query) or die(mysql_error());
}
else
unset($res);


if (isset($cleansearchstr))
stdhead("Search results for \"$searchstr\"");
else
stdhead();

begin_frame("" . BROWSE_TORRENTS . "", center);
?>


<form method="get" action="browse.php">
<table align="center" class=bottom>
<tr>
 <td class=bottom>
  <table class=bottom align="center">
   <tr align='right'>

<?
$i = 0;
foreach ($cats as $cat)
{
$catsperrow = 7;
print(($i && $i % $catsperrow == 0) ? "</tr><tr align='right'>" : "");
print("<td style=\"padding-bottom: 2px;padding-left: 2px\"><a class=catlink href=browse.php?cat={$cat["id"]}>" . htmlspecialchars($cat["name"]) . "</a><input name=c{$cat["id"]} type=\"checkbox\" " . (in_array($cat["id"], $wherecatina) ? "checked " : "") . "value=1></td>\n");
$i++;
}

$alllink = "<div align=left>(<a href=browse.php?all=1><b>Žiūrėti visus</b></a>)</div>";

$ncats = count($cats);
$nrows = ceil($ncats/$catsperrow);
$lastrowcols = $ncats % $catsperrow;

if ($lastrowcols != 0)
{
if ($catsperrow - $lastrowcols != 1)
 {
  print("<td class=bottom rowspan=" . ($catsperrow  - $lastrowcols - 1) . ">&nbsp;</td>");
 }
print("<td class=bottom style=\"padding-left: 5px\">$alllink</td>\n");
}
?>
   </tr>
  </table>
 </td>
</tr>
<?
if ($ncats % $catsperrow == 0)
print("<tr><td class=bottom style=\"padding-left: 15px\" rowspan=$nrows valign=center align=right>$alllink</td></tr>\n");
?> 
 <tr>
  <td class=bottom style="padding: 1px;padding-left: 10px">
  <div align=center>
   <input type="submit" class=btn value="Žiūrėti"/>
  </div>
  </td>
 </tr>
</table>
</form>

<br>

<?

if (isset($cleansearchstr))
print("<h2>Search results for \"" . htmlspecialchars($searchstr) . "\"</h2>\n");

if (!$LOGGEDINONLY){
   if ($count) {
         torrenttable($res);
         print($pagerbottom);
   }else {
      if (isset($cleansearchstr)) {
         bark2("" . NOTHING_FOUND . "", "" . NO_UPLOADS . "");
      }else{
         bark2("" . NOTHING_FOUND . "", "" . NO_RESULTS . "");
      }
   }
}//end

if ($LOGGEDINONLY){
   if (!$CURUSER){
      echo "<BR><BR><b><CENTER>Jūs esate neprisijunges tik prisijunge narei gali matyi torentus</CENTER><BR><BR>";
   }else{
      if ($count) {
            torrenttable($res);
            print($pagerbottom);
      }else {
         if (isset($cleansearchstr)) {
            bark2("" . NOTHING_FOUND . "", "" . NO_UPLOADS . "");
         }else{
            bark2("" . NOTHING_FOUND . "", "" . NO_RESULTS . "");
      }
   }
   }
}//end

end_Frame();
//update users last browse time
//REMOVE THIS IF YOUR LOAD IS HIGH.
mysql_query("UPDATE users SET last_browse=".gmtime()." where id=".$CURUSER['id']);

stdfoot();

?>




Kiek supratau šitą failą reike redaguot tik gal gait pasakyt kur ir į kurią eilutę reike yrasyt ką kad rodytų kategorijos paveiksliukus
Redagavo Pario· 2008 Lie. 15 20:07:24

Parašė ramon· 2008 Lie. 15 21:07:11
#2
Galima padarit taip:
kategorijos pavadnima rasai koki nors "games" poto sukuri img su pavadinimu games.jpg ir ikeli i ftp ir td ieskai ten kur turi atvaizduoti kategorijos pavadinima tai vietoi pavadinimo rasai <img src='".$kat_name.".jpg'>... :D

Parašė Pario· 2008 Lie. 15 21:07:24
#3
Kašką sumalei :D bet pabandysiu :?

Parašė MAnjack· 2008 Lie. 15 21:07:49
#4
Šiaip čia PHP-Fusion support, o ne TorrentTrader. Jie turi oficialų saitą.

Parašė frix· 2008 Lie. 15 22:07:57
#5
Net ir lietuvišką puslapį apie visokius torrenttraderius mačiau kažkada.

Parašė Pario· 2008 Lie. 15 23:07:56
#6
Bet tema Kitos TVS nėra lietuviško saito apie tottenttrader :|
Redagavo Pario· 2008 Lie. 15 23:07:16

Parašė starka· 2008 Lie. 16 00:07:53
#7
frix parašė:
Net ir lietuvišką puslapį apie visokius torrenttraderius mačiau kažkada.


noreciau ir as pamatyti :]:o rimtai yra toks LT saitas?:?

Parašė MAnjack· 2008 Lie. 16 09:07:42
#8
Pario parašė:
Bet tema Kitos TVS nėra lietuviško saito apie tottenttrader :|


Ir fusiono kažka nebuvo, bet kur papuolė niekas nerašinėdavo.

Parašė Takashis· 2008 Lie. 23 01:07:52
#9
surask eilute:
print("<td style=\"padding-bottom: 2px;padding-left: 2px\"><a class=catlink href=browse.php?cat={$cat["id"]}>" . htmlspecialchars($cat["name"]) . "</a><input name=c{$cat["id"]} type=\"checkbox\" " . (in_array($cat["id"], $wherecatina) ? "checked " : "") . "value=1></td>\n");




pakeisk i:
print("<td style=\"padding-bottom: 2px;padding-left: 2px\"><a class=catlink href=browse.php?cat={$cat["id"]}><img src=images/categories/" . htmlspecialchars($cat['image']) . "></a></td>\n");




Turetu veikti. bent man veikia :)