}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '1' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '1' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
}
}
else
{
$slider_q1 = "SELECT SLIDER_PAGE.SLIDER_PAGE_ID,SLIDER_PAGE.UNIQ,SLIDER_PAGE.LANG_ID,SLIDER_PAGE.SLIDER_TITLE,SLIDER_PAGE.SLIDER_SUB_TITLE,SLIDER_PAGE.SLIDER_DESC,SLIDER_PAGE.SLIDER_LINK1,SLIDER_PAGE.SLIDER_LINK2,SLIDER_PAGE.SLIDER_BUTON1,SLIDER_PAGE.SLIDER_BUTON2 FROM SLIDER_PAGE
INNER JOIN SLIDER ON SLIDER.UNIQ = SLIDER_PAGE.UNIQ
WHERE SLIDER_PAGE.LANG_ID = '{$GLOBALS["defaultlang"]}' AND SLIDER.SLIDER_CAT_ID = '2' AND SLIDER.STATUS = '1' ORDER BY SLIDER_PAGE.SLIDER_LINK2 ASC";
$slider1 = $db->loadObjectList($slider_q1);
foreach ($slider1 as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$value->LANG_ID}'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->UNIQ}' AND LANG_ID = '{$GLOBALS["defaultlang"]}'";
$image = $db->loadObject($image_q);
$url = $image->URL;
}
?>
