function display($tpl = null) {
global $mainframe;
$app = JFactory::getApplication('site');
$albumModel = & $this->getModel('awdjomalbum');
$Itemid=AwdwallHelperUser::getComItemId();
$db =& JFactory :: getDBO();
$user =& JFactory::getUser();
$albumid=$_REQUEST['albumid'];
$pid=$_REQUEST['pid'];
// checking privacy
$albumview=isalbumviewable($albumid);
if(!$albumview)
{
$msg= JText::_('User has set privacy.');
$app->Redirect(JRoute::_('index.php?option=com_awdwall&view=awdwall&layout=main&Itemid='.$Itemid,false),$msg);
}
if($albumid!='' && $pid!='')
{
//load images related to one album id
$albumid=$_REQUEST['albumid'];
$imagequery= 'SELECT * from #__awd_jomalbum_photos where albumid='.$albumid.' '.' and id='.$pid.' order by id';
$db->setQuery($imagequery);
$photorows=$db->loadObjectList();
$photorow=$photorows[0];
if(count($photorow)==0)
{
$msg="It seems that image deleted by user";
$app->Redirect(JRoute::_('index.php?option=com_awdwall&view=awdwall&layout=main&Itemid='.$Itemid,false),$msg);
exit;
}
$this->assignRef('photorow', $photorow);
$sql= 'SELECT count(*) from #__awd_jomalbum_photos where albumid='.$albumid;
$db->setQuery($sql);
$totRecord=$db->loadResult();
$this->assignRef('totRecord',$totRecord);
$sql="select count(*) from #__awd_jomalbum_photos where id <= ".$pid." and albumid=".$albumid." order by id asc ";
//echo $sql;
$db->setQuery($sql);
$curPosition=$db->loadResult();
$this->assignRef('curPosition',$curPosition);
//load user name and user id to one album id
$sql="Select u.*,aj.name as albumname from #__users as u left join #__awd_jomalbum as aj on u.id=aj.userid where aj.id=".$albumid;
$db->setQuery($sql);
$userdatas=$db->loadObjectList();
$userdata=$userdatas[0];
$userid=$userdata->id;
$username=$userdata->username;
$albumname=$userdata->albumname;
$this->assignRef('albumname', $albumname);
$this->assignRef('username', $username);
$this->assignRef('userid', $userid);
//set prev and next record
$sql="SELECT (SELECT MAX(id) FROM #__awd_jomalbum_photos ph1 WHERE ph1.id < ph2.id ) as PreviousID, (SELECT MIN(id) FROM #__awd_jomalbum_photos ph1 WHERE ph1.id > ph2.id ) as NextID FROM #__awd_jomalbum_photos ph2 WHERE id =".$pid;
$db->setQuery($sql);
$results=$db->loadobjectList();
$result=$results[0];
$next=$result->NextID;
$prev=$result->PreviousID;
$sql1="SELECT id from #__awd_jomalbum_photos where albumid=".$albumid." order by id ASC LIMIT 1";
$db->setQuery($sql1);
$firstRec=$db->loadResult();
$sql2="SELECT * from #__awd_jomalbum_photos where albumid=".$albumid." order by id DESC LIMIT 1";
$db->setQuery($sql2);
$lastRec=$db->loadResult();
if($pid==$firstRec)
{
$prev=$lastRec;
}
else if($pid==$lastRec)
{
$next=$firstRec;
}
$this->assignRef('nextR', $next);
$this->assignRef('prevR', $prev);
//comments
$commentqry='SELECT ajc.*, u.id as uid, u.name as cname,u.username FROM #__awd_jomalbum_comment as ajc left join #__users as u on ajc.userid=u.id where ajc.photoid='.$pid.' order by ajc.id desc limit 5';
$db->setQuery($commentqry);
$commentrows=$db->loadObjectList();
$commentqry='SELECT ajc.*, u.id as uid, u.name as cname,u.username FROM #__awd_jomalbum_comment as ajc left join #__users as u on ajc.userid=u.id where ajc.photoid='.$pid.' order by ajc.id desc';
$db->setQuery($commentqry);
$totalcommentrows=$db->loadObjectList();
$tagqry='SELECT * from #__awd_jomalbum_tags where photoid='.$pid;
$db->setQuery($tagqry);
$tagrows=$db->loadObjectList();
$app = JFactory::getApplication('site');
$config = & $app->getParams('com_awdwall');
$display_group = $config->get('display_group', 1);
$display_group_for_moderators = $config->get('display_group_for_moderators', 1);
$moderator_users = $config->get('moderator_users', '');
$moderator_users=explode(',',$moderator_users);
$this->assignRef('display_group', $display_group);
$this->assignRef('display_group_for_moderators', $display_group_for_moderators);
$this->assignRef('moderator_users', $moderator_users);
//print_r($commentrows);
$this->assignRef('totalcommentrows', $totalcommentrows);
$this->assignRef('commentrows', $commentrows);
$this->assignRef('tagrows', $tagrows);
$this->assignRef('pid', $pid);
parent::display($tpl);
}
else
{
echo JText::_('Opps! You are in wrong page');
}
}
<div style="clear:both; height:10px;"></div>
<form action="" method="post" name="adminForm">
<?php if(count($this->rows)>0) {?>
<div id="imgList">
<?php
$db =& JFactory::getDBO();
for ($i=0, $n=count( $this->rows ); $i < $n; $i++)
{
$db =& JFactory :: getDBO();
$row =$this->rows[$i];
$albumview=isalbumviewable($row->id);
if($albumview)
{
$sql='Select * from #__awd_jomalbum_photos where albumid='.$row->id .' and userid='.$row->userid;
//echo $sql;
$db->setQuery($sql);
$photos=$db->loadObjectList();
$photo=$photos[0];
//print_r($photo);
$totalphotos=count($photos);
//$link =JRoute::_('index.php?option=com_awdjomalbum&view=awdimagelist&pid='.$photo->id.'&albumid='. $row->id.'&Itemid='.AwdwallHelperUser::getComItemId());
$link =JRoute::_('index.php?option=com_awdjomalbum&view=awdalbumimages&albumid='. $row->id.'&Itemid='.AwdwallHelperUser::getComItemId());
$link2 =JRoute::_('index.php?option=com_awdjomalbum&view=awd_addphoto&id='. $row->id.'&Itemid='.AwdwallHelperUser::getComItemId());
if($row->userid==$user->id) {
?>