<?php
error_reporting(0);
/*--------------------------------------------+
| PHP-Fusion 6 - Content Management System |
|---------------------------------------------|
| author: Nick Jones (Digitanium) © 2002-2005 |
| web: http://www.php-fusion.co.uk |
| email: nick@php-fusion.co.uk |
|---------------------------------------------|
| Authors: Domi/Fetloser |
| www.venue.nu |
|---------------------------------------------|
| Released under the terms and conditions of |
| the GNU General Public License (Version 2) |
+--------------------------------------------*/
@require_once "../../config.php";
require_once "../../maincore.php";
require_once BASEDIR."subheader.php";
require_once BASEDIR."side_left.php";
if (isset($kategori)) {
redirect ("".$FUSION_SELF."?sortby=".$kategori."");
}
if (!defined("LANGUAGE")) {
// PHPFusion environment
$this_lang = str_replace("/", "", LOCALESET);
if (file_exists(INFUSIONS."the_kroax/locale/".$this_lang.".php")) {
include INFUSIONS."the_kroax/locale/".$this_lang.".php";
} else {
include INFUSIONS."the_kroax/locale/Bulgarian.php";
}
} else {
// mFusion environment
$this_lang = LANGUAGE;
if (file_exists(INFUSIONS."the_kroax/locale/".$this_lang.".php")) {
include INFUSIONS."the_kroax/locale/".$this_lang.".php";
} else {
include INFUSIONS."the_kroax/locale/Bulgarian.php";
}
}
echo'
<SCRIPT LANGUAGE=JAVASCRIPT TYPE="TEXT/JAVASCRIPT"></SCRIPT>';
$read_settingskroax = dbquery("SELECT * FROM ".$db_prefix."kroax_set");
if (dbrows($read_settingskroax) != 0) {
$settingskroax = dbarray($read_settingskroax);
$skroaxembed = $settingskroax['kroax_set_show'];
}
opentable($locale['KROAX201']);
echo"
<table width=100% align=center height=100% cellpadding=0 cellspacing=0 border=0>
<tr><td colspan=2 width=100% height=1%>
<table width=100%><tr><td width=40% valign=middle>
<font color=#880000><b> [ <a href=\"kroax.php\">".$locale['KROAX006']."</a> ] </b> </font>
<font color=#880000><b> [ <a href=\"kroax.php?click=sok\">".$locale['KROAX109']."</a> ] </b> </font> ";
if ($skroaxembed == "1")
{
echo "<font color=#880000><b> [ <a href='random.php'>".$locale['KROAX110']."</a> ]</b></font>";
}
else {
echo "
<font color=#880000><b> [ <a href='#' onclick=window.open('random.php','Randomize','scrollbars=yes,resizable=yes,width=650,height=550')>".$locale['KROAX110']."</a> ]</b></font>";
}
echo "
<font color=#880000><b> [ </font> <a href='".INFUSIONS."the_kroax/laddaupp.php'>".$locale['KROAX111']."</a> <font color=#880000> ] </font></b>
<font color=#880000><b> [ <a href=\"archive.php\">".$locale['KROAX119']."</a> ] </b> </font> ";
@$kategori = $_POST['kategori'];
$result1 = dbquery("SELECT * FROM ".$db_prefix."kroax_kategori WHERE ".groupaccess('kroax_namn_access')."");
echo "<td align='right' valign='middle' width='15%'><div align='right'>
<form name='kategori' id='kategori' method='post' action='".FUSION_SELF."'>
<select name='kategori' id='kategori' class='small' onChange=\"this.form.submit()\">";
while ($data1 = dbarray($result1)) {
echo "
<option value='".$data1['kroax_namn_cat1']."'>".$data1['kroax_namn_cat1']."</option>";
}
echo"</select><input type='submit' class='button' value='".$locale['KROAX311']."'></form>";
echo "
</td></table></div>
</tr>
</td></tr>
<tr><td colspan=2 height=3px valign=top background=img/line.gif></td></tr>";
@include ($click.".php");
$resultset = dbquery("SELECT * FROM ".$db_prefix."kroax_set WHERE kroax_set_id='1'");
while ($dataset = dbarray($resultset)) {
$moviepage ="".$dataset['kroax_set_pre']."";
$height = "".$dataset['kroax_set_hi']."";
$width = "".$dataset['kroax_set_wi']."";
$latestmovies ="".$dataset['kroax_set_pic']."";
}
if (isset($sortby)) {
$result = dbquery("Select * from ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_cat='$sortby' AND kroax_approval='' ORDER BY kroax_titel ASC");
$rows = dbrows($result);
if ($rows != 0) {
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
$result = dbquery("Select * from ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_cat='$sortby' AND kroax_approval='' ORDER BY kroax_titel ASC LIMIT $rowstart,$moviepage");
while ($data = dbarray($result)) {
$i=0;
$pres = nl2br($data['kroax_description']);
$pres = preg_replace("/^(.{255}).*$/", "$1", $pres);
$pres = preg_replace("/([^\s]{25})/", "$1\n", $pres);
echo" <table cellpadding='0' cellspacing='1' border='0' width='26%' align='right' class='tbl-border'>
<tr>
<br><td class='tbl2'><div align='left' class='small'>".$locale['KROAX307']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_cat']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX113']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_hits']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX114']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_uploader']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX115']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_date']."</div></td>
</tr>
</td>
</table>";
echo"
<table width=\"75%\" align='middle' cellspacing='0' style=\"height: 107px\" cellpadding='0' border='0'>";
if ($skroaxembed == "1")
{
echo "
<td align='left' width='10%'><a href='embed.php?url=".$data['kroax_id']."' ><IMG SRC='".$data['kroax_tumb']."' valign='top' align='left' width=$width height=$height></A>
<td valign='top' width='85%'><center><a href='embed.php?url=".$data['kroax_id']."'><b><u>".$data['kroax_titel']."</b></u></a><br><br>".stripslashes($pres)."</td></td></center>";
}
else {
echo "
<td align='left' width='10%'><a href='#' onclick=window.open('".INFUSIONS."the_kroax/click.php?url=".$data['kroax_url']."','MovieImg','scrollbars=yes,resizable=yes,width=650,height=550')><IMG SRC='".$data['kroax_tumb']."' valign='top' align='left' width=$width height=$height></A>
<td valign='top' width='85%'><center><a href='#' onclick=window.open('".INFUSIONS."the_kroax/click.php?url=".$data['kroax_url']."','MovieTitle','scrollbars=yes,resizable=yes,width=650,height=550')><b><u>".$data['kroax_titel']."</b></u></a><br><br>".stripslashes($pres)."</td></td></center>";
}
echo "</table>";
$data4 = 0;
$result3 = dbquery("SELECT * FROM ".$db_prefix."kroax_ratings WHERE rating_item_id='".$data['kroax_id']."'");
$count = dbrows($result3);
while ($data3 = dbarray($result3)) {
$data4 = $data4 + $data3['rating_vote'];
}
if ($count != 0) {
$avg = number_format(round($data4/$count*100)/100);
} else {
$avg = 0;
}
$kroax_comment_count = dbcount("(comment_id)", "kroax_comments", "comment_type='KR' AND comment_item_id='".$data['kroax_id']."'");
$kroax_rate_count = dbcount("(rating_id)", "kroax_ratings", "rating_type='F' AND rating_item_id='".$data['kroax_id']."'");
echo "<table width=\"100%\" align='middle' cellspacing='0' cellpadding='0'border='0'>
<td width='20%' class='tbl1' align='middle'><img src='".INFUSIONS."the_kroax/img/stars-".$avg.".gif'>
<td width='80%' class='tbl1'> [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/redirectvote.php?kroax_id=".$data['kroax_id']."','Ratings','scrollbars=yes,resizable=yes,width=650,height=250')>".$locale['KROAX116']." ($kroax_rate_count)</a>] [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/callcomments.php?comment_id=".$data['kroax_id']."','Comments','scrollbars=yes,resizable=yes,width=650,height=650')>".$locale['KROAX302']." ($kroax_comment_count)</A>] [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/tipafriend.php?movie_id=".$data['kroax_id']."','Tipafriend','scrollbars=yes,resizable=yes,width=350,height=300')>".$locale['KROAX303']."</a>] [<A HREF='".INFUSIONS."the_kroax/report.php?broken_id=".$data['kroax_id']."' target='_blank' onClick='return confirmreport();''>".$locale['KROAX304']."</a>]</td></td>
<tr><td colspan='2' height='3px' valign='top' background='img/line.gif'></tr></td>
</td></tr></table>";
}
$i++;
closetable();
echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$moviepage,$rows,3,FUSION_SELF."?sortby=".$sortby."&")."\n</div>\n";
}
}
else {
//No sort
echo "
<table width=100% align=center height=100% cellpadding=0 cellspacing=0 border=0>
<td><center> <font color=#880000><b>[</b></font> ".$locale['KROAX117']." $latestmovies ".$locale['KROAX118']." <font color=#880000><b>]</b></font></center></td>
<tr><td colspan=2 height=3px valign=top background=img/line.gif></td></tr>
</table>";
$result = dbquery("SELECT * FROM ".$db_prefix."kroax WHERE kroax_approval='' AND ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." ORDER BY kroax_id DESC LIMIT $latestmovies");
while ($data = dbarray($result)) {
$pres = nl2br($data['kroax_description']);
$pres = preg_replace("/^(.{255}).*$/", "$1", $pres);
$pres = preg_replace("/([^\s]{25})/", "$1\n", $pres);
echo" <table cellpadding='0' cellspacing='1' border='0' width='31%' align='right' class='tbl-border'>
<tr>
<br><td class='tbl2'><div align='left' class='small'>".$locale['KROAX307']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_cat']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX113']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_hits']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX114']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_uploader']."</div></td>
</tr>
<tr>
<td class='tbl2'><div align='left' class='small'>".$locale['KROAX115']."</div></td>
<td class='tbl2'><div align='right' class='small'>".$data['kroax_date']."</div></td>
</tr>
</td>
</table>";
echo"
<table width=\"69%\" align='middle' cellspacing='0' style=\"height: 107px\" cellpadding='0' border='0'>";
if ($skroaxembed == "1") {
echo "
<td align='left' width='10%'><a href='embed.php?url=".$data['kroax_id']."'><IMG SRC='".$data['kroax_tumb']."' valign='top' align='left' width=$width height=$height></A>
<td valign='top' width='78%'><center><a href='embed.php?url=".$data['kroax_id']."'><b><u>".$data['kroax_titel']."</b></u></a><br><br>".stripslashes($pres)."</td></td></center>";
}else {
echo "
<td align='left' width='10%'><a href='#' onclick=window.open('".INFUSIONS."the_kroax/click.php?url=".$data['kroax_url']."','MovieImg','scrollbars=yes,resizable=yes,width=650,height=550')><IMG SRC='".$data['kroax_tumb']."' valign='top' align='left' width=$width height=$height></A>
<td valign='top' width='78%'><center><a href='#' onclick=window.open('".INFUSIONS."the_kroax/click.php?url=".$data['kroax_url']."','MovieTitle','scrollbars=yes,resizable=yes,width=650,height=550')><b><u>".$data['kroax_titel']."</b></u></a><br><br>".stripslashes($pres)."</td></td></center>";
}
echo "</table>";
$data4 = 0;
$result3 = dbquery("SELECT * FROM ".$db_prefix."kroax_ratings WHERE rating_item_id='".$data['kroax_id']."'");
$count = dbrows($result3);
while ($data3 = dbarray($result3)) {
$data4 = $data4 + $data3['rating_vote'];
}
if ($count != 0) {
$avg = number_format(round($data4/$count*100)/100);
} else {
$avg = 0;
}
$kroax_comment_count = dbcount("(comment_id)", "kroax_comments", "comment_type='KR' AND comment_item_id='".$data['kroax_id']."'");
$kroax_rate_count = dbcount("(rating_id)", "kroax_ratings", "rating_type='F' AND rating_item_id='".$data['kroax_id']."'");
echo "<table width=\"100%\" align='middle' cellspacing='0' cellpadding='0'border='0'>
<td width='20%' class='tbl1' align='middle'><img src='".INFUSIONS."the_kroax/img/stars-".$avg.".gif'>
<td width='80%' class='tbl1'> [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/redirectvote.php?kroax_id=".$data['kroax_id']."','Ratings','scrollbars=yes,resizable=yes,width=650,height=250')>".$locale['KROAX116']." ($kroax_rate_count)</a>] [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/callcomments.php?comment_id=".$data['kroax_id']."','Comments','scrollbars=yes,resizable=yes,width=650,height=650')>".$locale['KROAX302']." ($kroax_comment_count)</A>] [<a href='#' onclick=window.open('".INFUSIONS."the_kroax/tipafriend.php?movie_id=".$data['kroax_id']."','Tipafriend','scrollbars=yes,resizable=yes,width=350,height=300')>".$locale['KROAX303']."</a>] [<A HREF='".INFUSIONS."the_kroax/report.php?broken_id=".$data['kroax_id']."' target='_blank' onClick='return confirmreport();''>".$locale['KROAX304']."</a>]</td></td>
<tr><td colspan='2' height='3px' valign='top' background='img/line.gif'></tr></td>
</td></tr></table>";
}
closetable();
}
require_once "footer.php";
require_once BASEDIR."side_right.php";
require_once BASEDIR."footer.php";
?>