Nu er jeg kommet så langt at jeg kan se det jeg hiver ud fra db, så jeg tror at det er over i siden hvor jeg trykker på linket.
Jeg smider lige hele koden så du kan se den.....
>>>>KODEN<<<<<
<body>
<head>
<script language="javascript1.2" type="text/JavaScript">
<!--
function ShowHideLayer() {
var i,p,v,obj,args=ShowHideLayer.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=FindObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
function DisplayImage(ImgName) {
Layer.style.posTop=document.body.scrollTop+event.clientY-90;
Layer.style.posLeft= 400;
ImageShow.src = ImgName;
Layer.style.visibility="visible";
}
//-->
</script>
</head>
</body>
<?php
/*---------------------------------------------------
PHP-Fusion 5 - Content Management System
-------------------------------------------
© Nick Jones (Digitanium) 2002-2005
http://www.php-fusion.co.uknick@php-fusion.co.uk
-------------------------------------------
Released under the terms and conditions of
the GNU General Public License (Version 2)
---------------------------------------------------*/
require_once "../../maincore.php";
require_once "../../subheader.php";
require_once "../../side_left.php";
//@require_once "../../fusion_config.php";
//require_once "../../fusion_core.php";
//require_once BASEDIR."subheader.php";
//require_once BASEDIR."side_left.php";
@include INFUSIONS."dvdinfos_system/lang/".$settings['language'].".php";
@include INFUSIONS."dvdinfos_system/lang/English.php";
echo "<script language=javascript>
function PopUp(url,name,width,height,center,resize,scroll,posleft,postop){
if (posleft != 0) { x = posleft }
if (postop != 0) { y = postop }
if (!scroll) { scroll = 1 }
if (!resize) { resize = 1 }
if ((parseInt (navigator.appVersion) >= 4 ) && (center)) {
X = (screen.width - width ) / 2;
Y = (screen.height - height) / 2;
}
if (scroll != 0) { scroll = 1 }
var Win = window.open( url, name,'width='+width+',height='+height+',top='+Y+',left='+X+',resizable='+resize+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no');
Win.focus();
}
</script>";
if (isset($dvdinfos_id)) {
$result = dbquery("UPDATE ".$db_prefix."dvdinfos SET dvdinfos_count=dvdinfos_count+1 WHERE dvdinfos_id='$dvdinfos_id'");
$result = dbquery("SELECT dvdinfos_cover FROM ".$db_prefix."dvdinfos WHERE dvdinfos_id='$dvdinfos_id'");
$data = dbarray($result);
header ("Location: ".$data['dvdinfos_cover'].$data['dvdinfos_cover2'].$data['dvdinfos_cover3']);
}
$items = dbrows(dbquery("SELECT * FROM ".$db_prefix."dvdinfos"));
if ($items != 0) {
if (empty($cat_id)) {
opentable(DVD_400);
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos_cats ORDER BY dvdinfos_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$columns = 3;
$counter = 0;
echo "<table width='100%' cellspacing='0' cellpadding='0' class='tbl'>\n<tr>\n";
while($data = dbarray($result)) {
if ($counter != 0) {
if($counter % $columns == 0) echo "</tr>\n<tr>\n";
}
$result2 = dbquery("SELECT count(dvdinfos_cat) FROM ".$db_prefix."dvdinfos WHERE dvdinfos_cat='".$data['dvdinfos_cat_id']."'");
$num = dbresult($result2, 0);
echo "<td align='center' valign='top'><a href='$PHP_SELF?cat_id=".$data['dvdinfos_cat_id']."'>".$data['dvdinfos_cat_name']."</a> <span class='small2'>($num)</span>";
if ($data[dvdinfos_cat_description] != "") {
echo "<br>
<span class='small'>".$data['dvdinfos_cat_description']."</span>";
}
echo "</td>\n";
$counter++;
}
echo "</tr>\n</table>\n";
} else {
echo "<center><br>
".DVD_430."<br><br>
</center>\n";
}
closetable();
tablebreak();
/*opentable(DVD_483);
$result=dbquery("SELECT * FROM ".$db_prefix."dvdinfos, ".$db_prefix."dvdinfos_cats where dvdinfos_cat=dvdinfos_cat_id ORDER BY dvdinfos_datestamp DESC LIMIT 3");
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";
while($data=dbarray($result)){
echo "<tr>\n<td class=\"small\" align=\"center\"><hr>\n</td>\n</tr>\n";
echo "<tr>\n<td class=\"small\" align=\"center\"><b><font size=3>$data[dvdinfos_name]</b></font></td>\n</tr>\n";
echo "<tr>\n<td class=\"small\" align=\"center\"><hr>\n</td>\n</tr>\n";
echo "<tr>\n<td class=\"small\" align=\"center\"><img src=".$data[dvdinfos_cover]." width='170' height='100'> </td>\n</tr>\n";
echo "<tr>\n<td class=\"small\" align=\"center\"><hr>\n</td>\n</tr>\n";
echo "<tr>\n<td class=\"small\" align=\"center\">$data[dvdinfos_description]</td>\n</tr>\n";
}
echo "</table>";
closetable();*/
openside("5 Nyeste dvdfilm");
$result=dbquery("SELECT * FROM ".$db_prefix."dvdinfos, ".$db_prefix."dvdinfos_cats where dvdinfos_cat=dvdinfos_cat_id ORDER BY dvdinfos_datestamp DESC LIMIT 5");
if (dbrows($result) != 0) {
echo "<center><table>";
while($data = dbarray($result)) {
echo " <img src=".$data[dvdinfos_cover]." width='80' height='110'> </a>\n";
}
echo "</table></center>";
} else {
echo "<center>".LAN_04."</center>\n";
}
closeside();
tablebreak();
$rows2show = 25;
if(!isset($rowstart)) $rowstart = 0;
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos, ".$db_prefix."dvdinfos_cats where dvdinfos_cat=dvdinfos_cat_id");
$numrows = dbrows($result);
opentable(DVD_417);
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos, ".$db_prefix."dvdinfos_cats where dvdinfos_cat=dvdinfos_cat_id ORDER BY dvdinfos_nr ASC LIMIT ".$rowstart.", ".$rows2show);
if(dbrows($result)!=0){
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">";
while($data=dbarray($result)){
//DET ER DETTE LINK DER SKAL BRUGES
echo "<tr><td class=\"small\" align=\"left\"><a href='".BASEDIR."viewpage.php?page_id=10?dvdid=".$data['dvdinfos_id']."'>".$data['dvdinfos_name']."</b></a></td>";
//ORG
//echo "<tr>\n<td class=\"small\" align=\"left\"><a href=\"java script:PopUp('$PHP_SELF?cat_id=$cat_id&dvdinfos_id=".$data['dvdinfos_id']."','Bild','200','280','0','0','0','0')\"><b>".$data['dvdinfos_name']."</b></a></td>\n";
echo "<td class=\"small\" align=\"left\">".trimlink($data[dvdinfos_alter], 30)."</td>\n";
echo "<td class=\"small\" align=\"left\">$data[dvdinfos_cat_name]</td>\n";
echo "<td class=\"small\" align=\"right\">$data[dvdinfos_count]</td>\n</tr>\n";
/*Mig der leger med en skuespillerliste*/
/*".$data['dvdinfos_name']."*/
}
}
echo "</table>";
closetable();
tablebreak();
echo "<div align='center' style='margin-top:5px;margin-bottom:5px;'> \n ".makePageNav($rowstart,$rows2show,$numrows,3)." \n </div> \n ";
tablebreak();
opentable(DVD_418);
$filmcount = dbquery("SELECT count(dvdinfos_id) FROM ".$db_prefix."dvdinfos");
$filmkategoriecount = dbquery("SELECT count(dvdinfos_cat_id) FROM ".$db_prefix."dvdinfos_cats");
echo "<center>".DVD_419."<span class='alt'>".dbresult($filmkategoriecount, 0)."</span><br>";
echo "".DVD_420."<span class='alt'>".dbresult($filmcount, 0)."</span></center>";
closetable();
tablebreak();
} else {
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos_cats WHERE dvdinfos_cat_id='$cat_id'");
$data = dbarray($result);
opentable(DVD_400.": ".$data['dvdinfos_cat_name']);
//Her sætter du hvilken tal du vil have der skal vises på siden.
$itemsperpage = 4;
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos WHERE dvdinfos_cat='$cat_id'");
$rows = dbrows($result);
if (!$rowstart) {
$rowstart = 0;
}
if ($rows != 0) {
//Her kan du rette så info listen stå med navnet føst, i
//( dvdinfos_cat='$cat_id' ORDER BY dvdinfos_nr ASC LIMIT )
//HUSK IKKE AT RETTE NÅDET ANDET
$result = dbquery("SELECT * FROM ".$db_prefix."dvdinfos WHERE dvdinfos_cat='$cat_id' ORDER BY dvdinfos_nr ASC LIMIT $rowstart,$itemsperpage");
$numrows = dbrows($result);
$i = 1;
while ($data = dbarray($result)) {
$dateposted = strftime("%d.%m.%y", $data['dvdinfos_datestamp']+($settings['timeoffset']*3600));
if ($data['dvdinfos_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " <span class='small'>".DVD_410."</span>";
} else {
$new = "";
}
echo "<font size=2><b>".$data['dvdinfos_name']."</font></b></a>$new<br>\n";
if ($data['dvdinfos_description'] != "") {
echo $data['dvdinfos_description']."<br><br>\n";
}
echo "<span class='small'><font class='alt'>".DVD_411."</font> $dateposted |
<font class='alt'>".DVD_506."</font> ".$data['dvdinfos_alter']." |
<font class='alt'>".DVD_507."</font> ".$data['dvdinfos_time']." |
<font class='alt'>".DVD_508."</font> ".$data['dvdinfos_count']." |
<br><br>
<class=\"small\" align=\"center\"><img src=".$data[dvdinfos_cover2]." width='150' height='70'> <img src=".$data[dvdinfos_cover3]." width='150' height='70'>
<class=\"small\" align=\"left\"><hr>
</span>\n";
if ($i != $numrows) {
echo "\n";
} else {
echo "\n";
}
$i++;
}
closetable();
echo "<br>\n";
echo "<div align='center'>\n";
echo "<a href='dvdinfos.php' target='_self'>Tilbage til DVD Kategorier</a>\n";
echo "</div>\n";
echo "<br>\n";
echo "<div align='center' style='margin-top:5px;'>
".makePageNav($rowstart,$itemsperpage,$rows,3,"$PHP_SELF?cat_id=$cat_id&")."
</div>\n";
} else {
echo DVD_431."\n";
closetable();
}
}
} else {
opentable('Keine DVD Infos');
echo 'Keine DVD Infos im System vorhanden';
closetable();
}
require_once BASEDIR."side_right.php";
require_once BASEDIR."footer.php";
?>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<