jo buvo laikai.. Senukai jau mes. Bega laikas greiciau nei noretusi. Smagu matyti kad uzsuka seni nariai, ne as vienas 
Peržiūrėti temą
PHP-Fusion Mods :: PHP-Fusion modifikacijų forumas :: Patobulinimai
\n\" ;$counter++;
}
echo \"\n
 Kampai
|
||||||
| extN |
parašyta 2012-02-17 20:04
|
|||||
Savekas Reputacija: 0 Pranešimai: 144 Įstojo: 2010-04-03 |
I?kart sakau naudoju Weberio sistema Taigi. Reiketu man, kad paveiksleliau b�tu su apvaliais kampais, ma�iau forume yra, bet tik ant paprastu naujienu. Ne?inau koki kod� jum duot, duodu filmai.php weberio sistemoi:  Code
/*-------------------------------------------------------+ | |||||
if ($rows > $items_per_page) echo \"
\n\".makepagenav($_GET['rowstart'],$items_per_page,$rows,3).\"\n
\n\";}
closetable();
} else { //pagal kategorija
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$rresult = dbquery(\"SELECT * FROM \".DB_FILMAI_KAT.\" WHERE filmai_kat_id = '\".$_GET['kat_id'].\"'\");
if (dbrows($rresult)) {
$kddata = dbarray($rresult);
opentable($kddata['filmai_kat_pav']);
$veikia=1;
} else {
opentable(\"klaida!\");
echo \"tokia kategorija neegzistoja\";
$veikia=0;
}
$rows = dbcount(\"(*)\", DB_FILMAI, \"filmai_kat0 = '\".$_GET['kat_id'].\"' OR filmai_kat1 = '\".$_GET['kat_id'].\"'
OR filmai_kat2 = '\".$_GET['kat_id'].\"' OR filmai_kat3 = '\".$_GET['kat_id'].\"'
OR filmai_kat4 = '\".$_GET['kat_id'].\"' OR filmai_kat5 = '\".$_GET['kat_id'].\"'
OR filmai_kat6 = '\".$_GET['kat_id'].\"' OR filmai_kat7 = '\".$_GET['kat_id'].\"'
OR filmai_kat8 = '\".$_GET['kat_id'].\"' OR filmai_kat9 = '\".$_GET['kat_id'].\"'\");
$result = dbquery(\"SELECT * FROM \".DB_FILMAI.\"
WHERE filmai_kat0 = '\".$_GET['kat_id'].\"' OR filmai_kat1 = '\".$_GET['kat_id'].\"'
OR filmai_kat2 = '\".$_GET['kat_id'].\"' OR filmai_kat3 = '\".$_GET['kat_id'].\"'
OR filmai_kat4 = '\".$_GET['kat_id'].\"' OR filmai_kat5 = '\".$_GET['kat_id'].\"'
OR filmai_kat6 = '\".$_GET['kat_id'].\"' OR filmai_kat7 = '\".$_GET['kat_id'].\"'
OR filmai_kat8 = '\".$_GET['kat_id'].\"' OR filmai_kat9 = '\".$_GET['kat_id'].\"'
ORDER BY filmai_date DESC LIMIT \".$_GET['rowstart'].\",$items_per_page\");
if (dbrows($result) != 0 && $veikia != 0) {
$counter = 0; $columns = 3;
echo\"\n\n\";
while($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo \"\n\n\"; }
$result1 = dbquery(\"SELECT SUM(rating_vote) FROM \".DB_RATINGS.\" WHERE rating_type='F' AND rating_item_id='\".$data['filmai_id'].\"'\");
$sudietas = dbresult($result1,0);
$kiekyra = dbcount(\"(rating_vote)\", DB_RATINGS, \"rating_type='F' AND rating_item_id='\".$data['filmai_id'].\"'\");
$reitingas = ($kiekyra ? $sudietas / $kiekyra : 0);
$komentarai = dbcount(\"(comment_id)\", DB_COMMENTS, \"comment_type='F' AND comment_item_id='\".$data['filmai_id'].\"' AND comment_hidden='0'\");
$tas = nl2br(stripslashes($data['filmai_apr']));
echo\"
echo \"
$kategorijo=\"\"; $kkk = 0;
while ($kkk != 9) {
if ($data['filmai_kat'.$kkk] != 0) {
$rresult = dbquery(\"SELECT * FROM \".DB_FILMAI_KAT.\" WHERE filmai_kat_id = '\".$data['filmai_kat'.$kkk].\"'\");
if (dbrows($rresult)) {
$kdata = dbarray($rresult);
$kategorijo .= \" \".$kdata['filmai_kat_pav'].\",\";
}
}
$kkk++;
}
$kategorijos = substr($kategorijo, 0, -1);
if ($reitingas >= 4.51) { $reitas = \"r5\";}
elseif ($reitingas >= 4.01) { $reitas = \"r4-5\";}
elseif ($reitingas >= 3.51) { $reitas = \"r4\";}
elseif ($reitingas >= 3.01) { $reitas = \"r3-5\";}
elseif ($reitingas >= 2.51) { $reitas = \"r3\";}
elseif ($reitingas >= 2.01) { $reitas = \"r2-5\";}
elseif ($reitingas >= 1.51) { $reitas = \"r2\";}
elseif ($reitingas >= 1.01) { $reitas = \"r1-5\";}
elseif ($reitingas >= 0.51) { $reitas = \"r1\";}
elseif ($reitingas >= 0.01) { $reitas = \"r0-5\";}
else { $reitas = \"r0\";}
echo\"\";
echo\"
\";
echo\"
\".$data['filmai_pav'].\"::Kategorijos: \".$kategorijos.\" Metai: \".$data['filmai_metai'].\" \".trump($tas,1000).\" | |
![]('\".INFUSIONS.\"filmai_panel/img/\".$reitas.\".png' "'\\".round($reitingas,2).\\"'") | Žiūrėti |
echo \"\n\" ;
$counter++;
}
echo \"\n\n\";
if ($rows > $items_per_page) echo \"
\n\".makepagenav($_GET['rowstart'],$items_per_page,$rows,3,FUSION_SELF.\"?kat_id=\".$kddata['filmai_kat_id'].\"&\").\"\n
\n\";} else {
echo(\"Šioje kategorija nėra filmu\");
}
closetable();
}
if ($topasonline == 1) {
$result = dbquery(\"
SELECT P1.rating_item_id, AVG(P1.rating_vote) AS topas, FL.filmai_id, FL.filmai_img, FL.filmai_pav, FL.filmai_apr, FL.filmai_trailler, FL.filmai_metai, FL.filmai_kalba, FL.filmai_kat0, FL.filmai_kat1, FL.filmai_kat2, FL.filmai_kat3, FL.filmai_kat4, FL.filmai_kat5, FL.filmai_kat6, FL.filmai_kat7, FL.filmai_kat8, FL.filmai_kat9
FROM \".DB_RATINGS.\" AS P1, \".DB_RATINGS.\" AS P2, \".DB_FILMAI.\" AS FL
WHERE P1.rating_type='F' AND P1.rating_item_id=P2.rating_item_id AND FL.filmai_id=P1.rating_item_id
GROUP BY P1.rating_item_id
HAVING (
SUM(CASE WHEN P2.rating_vote <= P1.rating_vote THEN 1 ELSE 0 END) >= ((COUNT(*) + 1) / 2)
AND
SUM(CASE WHEN P2.rating_vote >= P1.rating_vote THEN 1 ELSE 0 END) >= (COUNT(*)/2 + 1)
)
OR (
SUM(CASE WHEN P2.rating_vote >= P1.rating_vote THEN 1 ELSE 0 END) >= ((COUNT(*) + 1) / 2)
AND
SUM(CASE WHEN P2.rating_vote <= P1.rating_vote THEN 1 ELSE 0 END) >= (COUNT(*)/2 + 1)
)
ORDER BY topas DESC LIMIT 4\");
if (dbrows($result) != 0) {
opentable(\"Top reitingojami filmai\");
echo \"\";
while($data = dbarray($result)) {
$tas = nl2br(stripslashes($data['filmai_apr']));
echo \"\";
}
echo \"
| \n\n\"; $kategorijo=\"\"; $kkk = 0; while ($kkk != 9) { if ($data['filmai_kat'.$kkk] != 0) { $rresult = dbquery(\"SELECT * FROM \".DB_FILMAI_KAT.\" WHERE filmai_kat_id = '\".$data['filmai_kat'.$kkk].\"'\"); if (dbrows($rresult)) { $kdata = dbarray($rresult); $kategorijo .= \" \".$kdata['filmai_kat_pav'].\",\";} } $kkk++; } $kategorijos = substr($kategorijo, 0, -1); echo\"\"; echo\" \"; } echo \" \"; echo\"
|
closetable();
}
}
echo \"\";
require_once THEMES.\"templates/footer.php\";
?>
