İncelemeler için süper blok. Ben incelemeler bloğunu ders notları şeklinde kullanıyordum. Son 5 İnceleme, Popüler İncelemeler, En Çok Oy Alanlar, heepsi tek blok halinde.
<?
/*
+--------------------------------------------------------------------------
| MkPortal Reviews 3in1 Combo Block 1.0 (for center block) 02.01.2005
| for MKP x IPB2, SMF, phpBB
| by visiblesoul <visiblesoul.net>
| Adapted from news.php by Meo & Recensioni.php by CioMpO
+--------------------------------------------------------------------------
| MkPortal
| ========================================
| by Meo aka Luponero <Amedeo de longis>
|
| (c) 2004 mkportal.it
| http://www.mkportal.it
| Email: luponero@mclink.it
+---------------------------------------------------------------------------
|
| > MKPortal
| > Written By Amedeo de longis
| > Date started: 9.2.2004
|
+--------------------------------------------------------------------------
*/
$limit = 5; // number of reviews to show
$cutoff = 24; // number of characters to display in title
$dateformat = "short"; // Formats the date. Options are short, time, small, normal, or leave blank for default.
// Last Reviews ------
$query = $DB->query( "SELECT r.id, r.id_cat, r.idauth, r.title, r.author, r.click, r.rate, r.trate, r.date, s.id as category_id, s.title as cat_title
FROM mkp_reviews r
LEFT JOIN mkp_reviews_sections s on (r.id_cat=s.id)
GROUP BY r.id
ORDER BY r.id DESC
LIMIT $limit");
$content .= "
<table width='100%' border='0' cellspacing='0' cellpadding='2'>
<tbody>
<tr>
<td id=\"tdglobal\"><b>Son $limit İnceleme:</b></td>
</tr>
</tbody>
</table>
";
while( $row = $DB->fetch_row($query) ) {
$idcat = $row['category_id'];
$category[$idcat]['cat_title'] = $row['cat_title'];
$idnt = $row['id'];
$query1 = $DB->query( "SELECT id FROM mkp_reviews_comments where identry = '$idnt'");
$totcomments = $DB->get_num_rows($query1);
$id_orig_name = $row['idauth'];
$idcategory = $row['id_cat'];
$title = stripslashes($row['title']);
if (strlen($title) > $cutoff) {
$title = substr( $title,0,($cutoff - 3) ) . "...";
$title = preg_replace( '/&(#(\d+;?)?)?(\.\.\.)?$/', '...',$title );
}
$name = $row['author'];
$views = $row['click'];
$rate = $row['rate'];
$votes = $row['trate'];
if ($row['trate'] == 0){
$ratestring = "<b>Not rated</b>";
} else {
$ratestring = "<b>Rated:</b> $rate/5";
}
$section = $category[$idcategory]['cat_title'];
$cdate = $this->create_date($row['date'], $dateformat);
$content .= "
<table cellspacing=\"0\" cellpadding=\"2\" width=\"100%\">
<tbody>
<tr>
<td id=\"tdblock\">
<b>• <a class='uno' href='index.php?ind=reviews&op=entry_view&iden={$row['id']}'>$title</a></b>
</td></tr><tr>
<td id=\"tdglobal\">
</td>
</tr>
</tbody>
</table>
";
}
unset($row);
unset($idcat);
unset($category);
unset($idnt);
unset($query);
unset($query1);
unset($totcomments);
unset($id_orig_name);
unset($idcategory);
unset($title);
unset($name);
unset($section);
unset($cdate);
unset($views);
unset($rate);
unset($votes);
unset($ratestring);
unset($dateformat);
// Most Popular ------
$query2 = $DB->query( "SELECT r.id, r.id_cat, r.idauth, r.title, r.author, r.click, r.rate, r.trate, r.date, s.id as category_id, s.title as cat_title
FROM mkp_reviews r
LEFT JOIN mkp_reviews_sections s on (r.id_cat=s.id)
GROUP BY r.id
ORDER BY r.click DESC
LIMIT $limit");
$content .= "
<table width='100%' border='0' cellspacing='0' cellpadding='2'>
<tbody>
<tr>
<td id=\"tdglobal\"><b>Popüler İncelemeler:</b></td>
</tr>
</tbody>
</table>
";
while( $row = $DB->fetch_row($query2) ) {
$idcat = $row['category_id'];
$category[$idcat]['cat_title'] = $row['cat_title'];
$idnt = $row['id'];
$query3 = $DB->query( "SELECT id FROM mkp_reviews_comments where identry = '$idnt'");
$totcomments = $DB->get_num_rows($query3);
$id_orig_name = $row['idauth'];
$idcategory = $row['id_cat'];
$title = stripslashes($row['title']);
if (strlen($title) > $cutoff) {
$title = substr( $title,0,($cutoff - 3) ) . "...";
$title = preg_replace( '/&(#(\d+;?)?)?(\.\.\.)?$/', '...',$title );
}
$name = $row['author'];
$views = $row['click'];
$rate = $row['rate'];
$votes = $row['trate'];
if ($row['trate'] == 0){
$ratestring = "<b>Not rated</b>";
} else {
$ratestring = "<b>Rated:</b> $rate/5";
}
$section = $category[$idcategory]['cat_title'];
$cdate = $this->create_date($row['date'], $dateformat);
$content .= "
<table cellspacing=\"0\" cellpadding=\"2\" width=\"100%\">
<tbody>
<tr>
<td id=\"tdblock\">
<b>• <a class='uno' href='index.php?ind=reviews&op=entry_view&iden={$row['id']}'>$title</a></b>
</td></tr><tr>
<td id=\"tdglobal\">
</td>
</tr>
</tbody>
</table>
";
}
unset($row);
unset($idcat);
unset($category);
unset($idnt);
unset($query2);
unset($query3);
unset($totcomments);
unset($id_orig_name);
unset($idcategory);
unset($title);
unset($name);
unset($section);
unset($cdate);
unset($views);
unset($rate);
unset($votes);
unset($ratestring);
unset($dateformat);
// Top Rated ------
$query4 = $DB->query( "SELECT r.id, r.id_cat, r.idauth, r.title, r.author, r.click, r.rate, r.trate, r.date, s.id as category_id, s.title as cat_title
FROM mkp_reviews r
LEFT JOIN mkp_reviews_sections s on (r.id_cat=s.id)
GROUP BY r.id
ORDER BY r.rate DESC
LIMIT $limit");
$content .= "
<table width='100%' border='0' cellspacing='0' cellpadding='2'>
<tbody>
<tr>
<td id=\"tdglobal\"><b>En Çok Oy Alanlar:</b></td>
</tr>
</tbody>
</table>
";
while( $row = $DB->fetch_row($query4) ) {
$idcat = $row['category_id'];
$category[$idcat]['cat_title'] = $row['cat_title'];
$idnt = $row['id'];
$query5 = $DB->query( "SELECT id FROM mkp_reviews_comments where identry = '$idnt'");
$totcomments = $DB->get_num_rows($query5);
$id_orig_name = $row['idauth'];
$idcategory = $row['id_cat'];
$title = stripslashes($row['title']);
if (strlen($title) > $cutoff) {
$title = substr( $title,0,($cutoff - 3) ) . "...";
$title = preg_replace( '/&(#(\d+;?)?)?(\.\.\.)?$/', '...',$title );
}
$name = $row['author'];
$views = $row['click'];
$rate = $row['rate'];
$votes = $row['trate'];
if ($row['trate'] == 0){
$ratestring = "<b>Not rated</b>";
} else {
$ratestring = "<b>Rated:</b> $rate/5";
}
$section = $category[$idcategory]['cat_title'];
$cdate = $this->create_date($row['date'], $dateformat);
$content .= "
<table cellspacing=\"0\" cellpadding=\"2\" width=\"100%\">
<tbody>
<tr>
<td id=\"tdblock\">
<b>• <a class='uno' href='index.php?ind=reviews&op=entry_view&iden={$row['id']}'>$title</a></b>
</td></tr><tr>
<td id=\"tdglobal\">
</td>
</tr>
</tbody>
</table>
";
}
$output .= "{$content}";
$content = "<tr><td id=\"tdglobal\">";
$content .= $output;
$content .= "</td></tr>";
unset($row);
unset($idcat);
unset($category);
unset($idnt);
unset($query4);
unset($query5);
unset($totcomments);
unset($id_orig_name);
unset($idcategory);
unset($title);
unset($name);
unset($section);
unset($cdate);
unset($views);
unset($rate);
unset($votes);
unset($ratestring);
unset($dateformat);
unset($output);
?>
