locate(); $userCountry = $geoplugin->countryName; $objDb = new Database(); // Courselisting function getcourseListing($type){ $objCourse = new Course(); $objJobs = new Jobs(); $objDb = new Database(); $objStud = new Student(); $page = 2; $limit = 100; $userCurrDetails = $objStud->getCurrencyFromCountry($userCountry); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $courseDetails = $objDb->getTableValuesArray("course_type","idcourse_type ='".$type."'"); $courseTypeName = trim($courseDetails['courseTypeName']); if ( $courseDetails['courseTypeName'] == "CELTA Courses") { $courseTypeName = "Classroom courses"; } $table ="courses,course_hours"; $cond =" courses.course_type_idcourse_type = '$type' AND active='1' AND idcourses != '75' AND idcourses != '77' AND idcourses != '78' AND idcourses != '79' AND idcourses != '80' AND idcourses != '81' AND idcourses != '82' AND idcourses != '83' AND idcourses != '87' AND idcourses != '88' AND idcourses != '89' AND course_hours.idcourse_hours = courses.course_hours_idcourse_hours "; $sortquery ="ORDER BY course_hours.hours DESC "; $directPage="sitemap.html"; $fields = " * "; $listing=$objCourse->listDetailsWithPaging($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry); return $listing; } //end courselisting //========Start of List shop Items=================================== $objItem = new Item(); $objOrder = new Order(); $qry=""; $limit =100; $table ="items"; $cond ="AND `stockCount` >'0' AND active='1'".$cond1; $sortquery ="ORDER BY `itemName` ASC"; $directPage="sitemap.html"; $fields=" * "; $shopItems_listing=$objItem->listDetails($limit, $page, $table, $directPage, $fields, $cond, $sortquery,$qry); ////function for list Items //=======End of list shop Items===================================== ?>