{source}
<script language=”javascript”>
function toggleLetters() {
var ele2 = document.getElementById(“toggleText2”);
var text2 = document.getElementById(“displayText2”);
if(ele2.style.display == “block”) {
ele2.style.display = “none”;
text2.innerHTML = “Show letters menu”;
}
else {
ele2.style.display = “block”;
text2.innerHTML = “Hide letters menu”;
}
}
</script>
<?php
$letter_selection = $_GET[“letter”];
$len_letter_selection = strlen ($letter_selection);
$limit = 12;
$offset = JRequest::getVar(‘limitstart’, 0, ”, ‘int’);
$db =& JFactory::getDBO();
if ($len_letter_selection < 2 || $len_letter_selection > 3) $db->setQuery(“SELECT SQL_CALC_FOUND_ROWS id, asset_id, title, alias, introtext, imageone, imageonetext FROM studio_content WHERE catid=8 AND id<>1576 AND id<>1561 AND id<>1562 AND id<>1563 AND id<>1564 AND id<>1565 AND id<>1566 AND id<>1567 AND id<>1568 AND state=1 AND title LIKE ‘” . $letter_selection[0] . “%’ ORDER BY created DESC”, $offset, $limit);
if ($len_letter_selection == 2) $db->setQuery(“SELECT SQL_CALC_FOUND_ROWS id, asset_id, title, alias, introtext, imageone, imageonetext FROM studio_content WHERE catid=8 AND id<>1576 AND id<>1561 AND id<>1562 AND id<>1563 AND id<>1564 AND id<>1565 AND id<>1566 AND id<>1567 AND id<>1568 AND state=1 AND (title LIKE ‘” . $letter_selection[0] . “%’ OR title LIKE ‘” . $letter_selection[1] . “%’) ORDER BY created DESC”, $offset, $limit);
if ($len_letter_selection == 3) $db->setQuery(“SELECT SQL_CALC_FOUND_ROWS id, asset_id, title, alias, introtext, imageone, imageonetext FROM studio_content WHERE catid=8 AND id<>1576 AND id<>1561 AND id<>1562 AND id<>1563 AND id<>1564 AND id<>1565 AND id<>1566 AND id<>1567 AND id<>1568 AND state=1 AND (title LIKE ‘” . $letter_selection[0] . “%’ OR title LIKE ‘” . $letter_selection[1] . “%’ OR title LIKE ‘” . $letter_selection[2] . “%’) ORDER BY created DESC”, $offset, $limit);
$rL= $db->loadObjectList();
if (!empty($rL)) {
$db->setQuery(‘SELECT FOUND_ROWS();’);
jimport(‘joomla.html.pagination’);
$pageNav = new JPagination( $db->loadResult(), $offset, $limit );
$content = $pageNav->getListFooter();
?>
<ul class=”vmenu”>
<li><a id=”displayText2″ href=”javascript:toggleLetters();”>Show letters menu</a></li>
</ul>
<ul class=”vmenu”>
<div id=”toggleText2″ style=”display: none”>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=ABC”>A-C</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=DEF”>D-F</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=GHI”>G-I</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=JKL”>J-L</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=MNO”>M-O</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=PQR”>P-R</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=STU”>S-U</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=VWX”>V-X</a></li>
<li class=”arrow”><a href=”index.php/archive-mobile?letter=YZ”>Y-Z</a></li>
</div>
</ul>
<?php
foreach ($rL as $row) {
$db2 = JFactory::getDBO();
$query2 = “SELECT id FROM studio_menu WHERE alias=’” . $row->alias . “‘”;
$db2->setQuery($query2);
$url2 = $db2->loadResult();
$url2 = JRoute::_(“index.php?option=com_content&view=article&id=” . $row->id . “&Itemid=” . $url2);
?>
<div class=”containerHomeImageLeft”>
<a href=”<?php echo $url2 ?>“>
<?php
if (!empty($row->imageone)) { ?>
<img src=”image_archive.php?image=<?php echo $row->imageone; ?>” alt=”<?php echo $row->imageonetext; ?>” />
<?php
} else {
?>
<img src=”images/studio_archive.png” alt=”studio international” />
<?php
}
?>
</a>
<?php
$title_text = $row->title;
$str_title = strlen($title_text);
if ($str_title > 75) {
$str_title = 75;
$title_text = substr ($title_text, 0, 74) . “…”;
}
?>
<a href=”<?php echo $url2 ?>“>
<?php
echo ‘<h2>‘ . $title_text . ‘</h2>‘;
?>
</a>
<p>
<div class=”textHome”>
<?php
$pos_contents = strpos($row->introtext, ‘contents’);
if ($pos_contents < 1) {
$pos_contents = strpos($row->introtext, ‘<strong>‘);
$pos_contents = $pos_contents + 8;
} else {
$pos_contents = $pos_contents + 10;
}
$len_intro = 130 – $str_title;
$intro_text = substr ($row->introtext, $pos_contents, $len_intro) . “…”;
$intro_text = str_replace(“<sup>“, “”, $intro_text);
$intro_text = str_replace(“</sup>“, “”, $intro_text);
$intro_text = str_replace(“<em>“, “”, $intro_text);
$intro_text = str_replace(“</em>“, “”, $intro_text);
$intro_text = str_replace(“<b>“, “”, $intro_text);
$intro_text = str_replace(“</b>“, “”, $intro_text);
echo $intro_text;
echo “</p></div></div>“;
}
echo ‘<div class=”navigation”>‘ . $pageNav->getPagesLinks() . ‘</div>‘;
} else {
?>
<div class=”resultTitle”><b>No Results Found</b></div>
<div class=”result”><h2>No search results could be found for query: <?php echo ” ” . $searchPhrase; ?></h2></div>
<?php
}
?>
{/source}
