martedì 15 marzo 2011

K2 attachments

<?php

$db =& JFactory::getDBO();
$dbx =& JFactory::getDBO();
$dbpdf =& JFactory::getDBO();
$queryz = "SELECT * FROM jos_k2_items WHERE id = '".urldecode(strip_tags($_GET['id']))."' AND trash = '0'";
$db->setQuery( $queryz);
$rows = $db->loadObjectList();




foreach($rows as $row)
{


$text = $rowv->introtext;
echo "<img src='http://isforcoop.cartonianimated.com/media/k2/items/cache/".md5("Image".urldecode(strip_tags($_GET['id'])))."_L.jpg' width='280'>";
echo $text;


$querypdf = "SELECT * FROM jos_k2_attachments WHERE itemID = '".urldecode(strip_tags($_GET['id']))."'";
$dbpdf->setQuery( $querypdf);
$rowpdf = $dbpdf->loadObjectList();




foreach($rowpdf as $rowy)
{
$pdf = $rowy->filename;
$tit = $rowy->title;
echo "> <a href='media/k2/attachments/".$pdf."' target='_blank' style='margin-bottom: 10px;'>".$tit."</a>";
}
}



?>

Nessun commento:

Posta un commento