WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė ZW· 2011 Bir. 14 16:06:44

filmai.php faila palik.

Tada sukurk nauja faila pervadink tarkim komedijos.php
Imesk mano duota koda.
Kode surask AND news_cat=25 bus du tokie salia. Ir skaiciu 25 pakeisk i savo kategorijos ID. Tarkim jai sukuri komedijos.php tai ir komediju kategorijos ID irasyk vietoi skaiciaus 25.
Issaugok komedijos.php ir ikelk i ftp pagrindinia direktorija.
Surink adresa

http://tavosvetaine.lt/komedijos.php

ir rodys filmus tik is kategorijos komedijos.

Kazkas neaisku klausk... Bandysiu padet.

Kodas:

<?php

require_once "maincore.php";

require_once THEMES."templates/header.php";

echo"<script type='text/javascript' src='".INCLUDES."title.js'></script>";

?>

<style type="text/css">



tooltip {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 10px;

color: #ffffff;

position: absolute;

z-index: 3000;

/*border: 1px solid #111;*/

background-color: #000;

padding: 5px;



}



tooltip h3, #tooltip div { margin: 0; }



div#qTip {

padding: 5px;

border: 0px solid #666;

display: none;

background: #000;

color: #FFFFFF;

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 10px;

text-align: left;

position: absolute;

z-index: 1000;



</style>

<?php





$items_per_page = 12;





if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { 

$_GET['rowstart'] = 0; 

}



$rows = dbcount("(*)", DB_NEWS," news_draft='0' AND news_cat=25"); 

//opentable("");



//$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");

$result = dbquery(

"SELECT * FROM ".DB_NEWS." 

WHERE news_draft='0' AND news_cat=25 ORDER BY news_datestamp DESC 

LIMIT ".$_GET['rowstart'].", $items_per_page"

);





if (dbrows($result) != 0) {

$counter = 0; $columns = 3;

echo"<table cellpadding='0' cellspacing='0' width='100%' style='padding:5px;'>\n<tr>\n";

while($data = dbarray($result)) {

//$kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);

if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }



$wynik = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='N' AND rating_item_id='".$data['news_id']."'");

$info2 = dbresult($wynik,0);

$num_rating = dbcount("(rating_vote)", DB_RATINGS, "rating_type='N' AND rating_item_id='".$data['news_id']."'");

$wyn_rating = ($num_rating ? $info2 / $num_rating : 0);

// $tas = trimlink($data['news_news'], 600);

$tas = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);



echo"<td style='padding:5px;'>";



echo "<table cellpadding='0' cellspacing='0' width='150' class='borderis' onmouseover=\"className='borderis2'\" onmouseout=\"className='borderis'\">\n<tr>\n";



echo"<td colspan='2' align='center'><a href='/news.php?readmore=".$data['news_id']."' tit='<table width=260px><tr><td class=c>

<b><span style=color:#0099FF;font-size:12px;>".$data['news_subject']."</span></b><br>$tas<br>

<b>Žiūrėjo: ".$data['news_reads']."</b>



</td></tr>

</table>'><img src='".IMAGES_N.$data['news_image']."' width='160' height='245' /></a></td>";



echo"</tr>

<td width='105' style='padding:2px;'><img src='".THEME."images/retitingai/".ceil($wyn_rating).".png' width='80' height='13' alt='".ceil($wyn_rating)."' style='vertical-align:middle;' title='".ceil($wyn_rating)."' /></td>

<td class='c' align='right'><a href='/news.php?readmore=".$data['news_id']."'>Žiūrėti</a></td>

</tr>";



echo"</table>"; 







echo "</td>\n" ;

$counter++;

}

echo "</tr>\n</table>\n";



}





//closetable(); 

echo"<div align='center'>";

if ($rows > $items_per_page) {

echo makepagenav($_GET['rowstart'], $items_per_page, $rows, 3);

}



require_once THEMES."templates/footer.php";



?>

Redagavo ZW· 2011 Bir. 14 16:06:37