<?php
$topos = $_REQUEST[‘topos’];
$nomos = $_REQUEST[‘nomos’];
$monastiri = $_REQUEST[‘monastiri’];
if ($nomos==”” && $monastiri==”” && $topos!=””) {
$result2 = mysql_query(“SELECT * FROM jos_sections WHERE published = 1 AND id = ‘$topos'”);
while($row2 = mysql_fetch_array($result2))
{
echo ‘<center><h2><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=46&monastiri=’.$row2[‘id’].'”>’.$row2[‘title’].'</a></h2></center>’;
}
//$topos = 9;
//global $mainframe;
$db =& JFactory::getDBO();
$query = “SELECT * FROM #__categories WHERE section = ‘$topos'”;
$db->setQuery( $query, 0, $count );
$rows = $db->loadObjectList();
$i = 0;
echo ‘<h4><table width=”680″ border=”0″>’;
foreach($rows as $row) {
$iid = $row->id;
if ($i==’0′) {
echo ‘<tr><td style=”vertical-align: top;”><b><center><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=46&nomos=’.$iid.'”>’.$row->title.'</a></center></b><br>’;
$result = mysql_query(“SELECT * FROM jos_content WHERE state = 1 AND catid =’$iid’ ORDER BY title ASC LIMIT 0,30”);
while($rowl = mysql_fetch_array($result))
{
echo ‘<a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br>’;
}
echo ‘<br></td>’;
}elseif ($i==’1′ || $i==’2′) {
echo ‘<td style=”vertical-align: top;”><b><center><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=46&nomos=’.$iid.'”>’.$row->title.'</a></center></b><br>’;
$result = mysql_query(“SELECT * FROM jos_content WHERE state = 1 AND catid =’$iid’ ORDER BY title ASC LIMIT 0,30”);
while($rowl = mysql_fetch_array($result))
{
echo ‘<a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br>’;
}
echo ‘</td>’;
} elseif ($i==’3′) {
echo ‘<td style=”vertical-align: top;”><b><center><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=46&nomos=’.$iid.'”>’.$row->title.'</a></center></b><br>’;
$result = mysql_query(“SELECT * FROM jos_content WHERE state = 1 AND catid =’$iid’ ORDER BY title ASC LIMIT 0,15”);
while($rowl = mysql_fetch_array($result))
{
echo ‘<a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br>’;
}
echo ‘</td></tr>’;
}
$i++;
if ($i == ‘2’) { $i=0; }
}
echo ‘</table></h4>’;
/// EDOTAMONASTIRIA
} elseif ($nomos!=”” && $monastiri==””) {
$result2 = mysql_query(“SELECT * FROM jos_categories WHERE published = 1 AND id = ‘$nomos'”);
while($row2 = mysql_fetch_array($result2))
{
echo ‘<center><h2>’.$row2[‘title’].'</h2></center>’;
}
echo ‘<h4><table width=”680″ border=”0″>’;
$result = mysql_query(“SELECT * FROM jos_content WHERE state = 1 AND catid = ‘$nomos’ ORDER BY title ASC”);
$i = 0;
while($rowl = mysql_fetch_array($result))
{
if ($i==’0′) {
echo ‘<tr><td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td>’;
} elseif ($i==’1′) {
echo ‘<td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td>’;
} elseif ($i==’2′) {
echo ‘<td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td></tr>’;
}
$i++;
if ($i == ‘3’) { $i=0; }
}
echo ‘</table></h4>’;
/// EDO OLA TA ONASTIRIA TOU GEORGAFIKOU DIAMERISMATOS
} elseif ($monastiri!=””) {
$result2 = mysql_query(“SELECT * FROM jos_sections WHERE published = 1 AND id = ‘$monastiri'”);
while($row2 = mysql_fetch_array($result2))
{
echo ‘<center><h2>’.$row2[‘title’].'</h2></center>’;
}
echo ‘<h4><table width=”680″ border=”0″>’;
$result = mysql_query(“SELECT * FROM jos_content WHERE state = 1 AND sectionid = ‘$monastiri’ ORDER BY title ASC”);
$i = 0;
while($rowl = mysql_fetch_array($result))
{
if ($i==’0′) {
echo ‘<tr><td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td>’;
} elseif ($i==’1′) {
echo ‘<td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td>’;
} elseif ($i==’2′) {
echo ‘<td style=”vertical-align: top;”><a href=”‘.$this->baseurl.’index.php?option=com_content&view=article&id=’.$rowl[‘id’].'”>’.$rowl[‘title’].'</a><br></td></tr>’;
}
$i++;
if ($i == ‘3’) { $i=0; }
}
echo ‘</table></h4>’;
}
?>