loadObjectList($hizmetler_page_q);
if($hizmetler_page)
{
foreach ($hizmetler_page as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->PAGE_UNIQ}' AND LANG_ID = '{$value->LANG_ID}' AND MAIN = '1'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
unset($url);
}
echo '
';
}
}
$hizmetler_page_q2 = "SELECT PAGE_DESC.PAGE_LINK, PAGE_DESC.PAGE_SHORT_DESC, PAGE.PAGE_UNIQ, PAGE_DESC.LANG_ID, PAGE_DESC.SEO_LINK AS P_SEO_LINK, PAGE_CAT_DESC.SEO_LINK AS C_SEO_LINK FROM PAGE_DESC
INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ
INNER JOIN PAGE_CAT ON PAGE_CAT.PAGE_CAT_ID = PAGE.CAT_ID
INNER JOIN PAGE_CAT_DESC ON PAGE_CAT_DESC.PAGE_CAT_UNIQ = PAGE_CAT.PAGE_CAT_UNIQ
WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_ID > '0' AND PAGE.CAT_PAGE = '0'";
$hizmetler_page2 = $db->loadObjectList($hizmetler_page_q2);
if($hizmetler_page2)
{
foreach ($hizmetler_page2 as $key2 => $value2) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value2->PAGE_UNIQ}' AND LANG_ID = '{$value2->LANG_ID}' AND MAIN = '1'";
$image = $db->loadObject($image_q);
if($image)
{
$url1 = $image->URL;
}
else
{
unset($url1);
}
echo '
';
}
}
$hizmetler_page_q1 = "SELECT PAGE_DESC.SEO_LINK,PAGE_DESC.PAGE_LINK,PAGE_DESC.PAGE_TITLE,PAGE_DESC.PAGE_SHORT_DESC,PAGE_DESC.PAGE_UNIQ,PAGE_DESC.LANG_ID FROM PAGE_DESC
INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ
WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_PAGE = '1' ORDER BY PAGE.SORTBY ASC";
$hizmetler_page1 = $db->loadObjectList($hizmetler_page_q1);
if($hizmetler_page1)
{
foreach ($hizmetler_page1 as $key1 => $value1) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value1->PAGE_UNIQ}' AND LANG_ID = '{$value1->LANG_ID}' AND MAIN = '1'";
$image = $db->loadObject($image_q);
if($image)
{
$url1 = $image->URL;
}
else
{
unset($url1);
}
echo '
';
}
}
?>
