PHP-Fusion Mods - Diskusijų forumas: v7 filmai.php

Peržiūrėti temą

PHP-Fusion Mods :: PHP-Fusion modifikacijų forumas :: Pageidaujami infusionai, panelės, modifikacijos.

";

echo"

";

echo"

v7 filmai.php

klimiux

parašyta 2011-09-04 22:27

Naujokas

Reputacija: 0

Pranešimai: 19
Įstojo: 2009-12-01

Tai va susiduriau su viena problemele, parsisiunciau is jusu web faila "filmai.php" tikriuasiai visi ji zino, vienu zodziu pradejau ji redaguoti, bandziau pritaikyti tik vienai kategorijai naujienu (t.y. kad atvaizduotu tik vienos kategorijos naujienas. Bandziau daryti pagal top downloads paneles ir visur bandziau prideti "WHERE news_cat='2'" arba "news_cat='2'" ir dar visokiu kurybiniu minciu buvau pasitelkes, bet mesdavo erora arba budavo tuscias web. Nei viena nei kita nepadejo. Tad prasau tu kas tikrai ismano ir galetu padeti pritaikant faila tam tikrai kategorijai, arba bent uzvesti teisingan kelin.
------------------------------------------------------------------------
Pridedu neredaguoto "filmai.php" koda:
------------------------------------------------------------------------
require_once "maincore.php";
require_once THEMES."templates/header.php";
echo"";
?>

$items_per_page = 16;

if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) {
$_GET['rowstart'] = 0;
}

$rows = dbcount("(*)", DB_NEWS, "news_draft='0'");
//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' ORDER BY news_datestamp DESC
LIMIT ".$_GET['rowstart'].",$items_per_page"
);

if (dbrows($result) != 0) {
$counter = 0; $columns = 4;
echo"\n\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 "\n\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);
$komentarai = dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."' AND comment_hidden='0'");
// $tas = trimlink($data['news_news'], 600);
$tas = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);

echo"\n";

echo"

";

echo ">\n

".$data['news_subject']."
$tas

Žiūrėjo: ".$data['news_reads']."

Žiūrėti

";

echo "\n" ;
$counter++;
}
echo "\n\n";

}

//closetable();
echo"

";
if ($rows > $items_per_page) {
echo makepagenav($_GET['rowstart'], $items_per_page, $rows, 3);
}

require_once THEMES."templates/footer.php";

?>

P.S. kai tvarkau meta panasias klaidas: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'news_cats='2' ORDER BY news_datestamp DESC LIMIT 0,16' at line 2

Redagavo klimiux 2011-09-05 08:06

minimukas

parašyta 2011-09-05 14:53

Geradarys

Reputacija: 0

Pranešimai: 602
Įstojo: 2009-06-11

Taigi stai jau padariau kur parasiau KATEGORIJA 2 vieuose ten irasysi ID kategorijos ir tuo paciu istaisiau rowstat buga....

Code


 require_once \"maincore.php\";

 require_once THEMES.\"templates/header.php\";

 echo\"\";

 ?>

 

 




 $items_per_page = 16;





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

 $_GET['rowstart'] = 0; 

 }



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

 //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=KATEGORIJA ORDER BY news_datestamp DESC 

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

 );





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

 $counter = 0; $columns = 4;

 echo\"\n\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 \"\n\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);

 $komentarai = dbcount(\"(comment_id)\", DB_COMMENTS, \"comment_type='N' AND comment_item_id='\".$data['news_id'].\"' AND comment_hidden='0'\");

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

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


 echo\"\n\";


 echo\"

 


\";



 echo \">\n



 \".$data['news_subject'].\"
$tas


 Žiūrėjo: \".$data['news_reads'].\"



 
'>\";



 echo\"

 

 Žiūrėti

 \";



 echo\"\"; 







 echo \"\n\" ;

 $counter++;

 }

 echo \"\n\n\";



 }





 //closetable(); 

 echo\"

\";

 if ($rows > $items_per_page) {

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

 }



 require_once THEMES.\"templates/footer.php\";



 ?>

www.nusirasinek.lt - Pratybų atsakymai

Peršokti į forumą:

tabux	4 Dienos
sanper	nepamenu
Zbigniew@	nepamenu
CepelinasX	nepamenu
VV91DD	nepamenu
Minus	nepamenu
priezilviciu	nepamenu
EdvinasG1337	nepamenu
rolandas94	nepamenu
Edis2	nepamenu
klubogerbejas	nepamenu
Miskinis	nepamenu

	Neleista registracija: 39012
	Šiandien: 28