function categories($option) { global $option, $mainframe; $limit = JRequest::getVar('limit', $mainframe->getCfg('list_limit')); $limitstart = JRequest::getVar('limitstart', 0); $db =& JFactory::getDBO(); $query = "SELECT count(*) FROM #__aard_cats"; $db->setQuery($query); $total = $db->loadResult(); $query = "SELECT * FROM #__aard_cats ORDER BY ordering, cat_name"; $db->setQuery($query, $limitstart, $limit); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); HTML_classifieds::showCategories($option, $rows, $pageNav); /*global $option, $mainframe; $limit = JRequest::getVar('limit', $mainframe->getCfg('list_limit')); $limitstart = JRequest::getVar('limitstart', 0); $db =& JFactory::getDBO(); $query = "SELECT count(*) FROM #__class_cats"; $db->setQuery($query); $total = $db->loadResult(); $query = "SELECT c.*, a.ad_name FROM #__class_cats AS c LEFT JOIN #__class_ads AS a ON a.cat_id = c.id"; $db->setQuery($query, $limitstart, $limit ); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); HTML_classifieds::showCategories($option, $rows, $pageNav);*/ }
function showPublishedCategories($option) { $query = "SELECT * FROM #__aard_config WHERE id ='1'"; $db =& JFactory::getDBO(); $db->setQuery($query); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } foreach ($rows as $row) { $access = $row->access; } $query = "SELECT days_shown, emailusers FROM #__aard_config WHERE id ='1'"; $db =& JFactory::getDBO(); $db->setQuery($query); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } foreach ($rows as $row) { $dayy = $row->days_shown; $mailconf = $row->emailusers; } $today = date("Y-m-d H:i:s", mktime(date('H'), date('i'), date('s'), date('m'), date('d') - $dayy, date('y'))); //$query = "SELECT * FROM #__aard_cats WHERE published = '1' ORDER BY ordering, cat_name"; $query = "select v.id, v.label, v.name, v.default, cp.field_id from #__custom_properties_values v, #__custom_properties_fields f, (select vl.id, vl.name from #__custom_properties_values vl) vp where v.field_id=f.id and f.name='root_clasificados' and vp.name='rubro' and vp.id=v.parent_id"; $db->setQuery($query); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $user =& JFactory::getUser(); $user_id = $user->get('id'); if ($user_id == $access) { echo '<div class="componentheading">Please Log in to view this page.</div>'; } else { HTML_classifieds::showCategories($rows, $option, $today); } $db =& JFactory::getDBO(); $result = $db->setQuery("SELECT * FROM #__aard_ads WHERE published = '1' AND date_created > '" . $today . "' AND emailed = '0'"); $rows = $db->loadObjectList(); $number = count($rows); if ($mailconf == 1 & $number > 0) { $db =& JFactory::getDBO(); $result = mysql_query("SELECT * FROM #__aard_ads WHERE published = '1' AND date_created > '" . $today . "' AND emailed = '0'"); $count = 0; //if row's date_created + days_shown - 1 = today //then send mail $now = date("Y-m-d", mktime(date('m'), date('d'), date('y'))); $email[0] = ""; $id[0] = ""; $name[0] = ""; while ($rows = mysql_fetch_array($result)) { $startdate = strtotime($rows['date_created']); //The date the ad was created $datefinishstamp = strtotime("+{$dayy} days", $startdate); $datefinish = date("Y-m-d", $datefinishstamp); // The date that the ad finishes on $datefinstamp = strtotime("-1 days", $datefinishstamp); $datefin = date("Y-m-d", $datefinstamp); //The date one day from when the ad ends if ($datefin == $now) { //if today = finishdate - 1 then put email into array $email[$count] = $rows['contact_email']; $ad[$count] = $rows['ad_name']; $id[$count] = $rows['id']; $name[$count] = $rows['contact_name']; $count++; } } $query = "SELECT * FROM #__aard_email WHERE id ='1'"; $db =& JFactory::getDBO(); $db->setQuery($query); $rows = $db->loadObjectList(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $subject = ""; $fromname = ""; $fromemail = ""; foreach ($rows as $row) { $subject = $row->subject; $fromname = $row->fromname; $fromemail = $row->fromemail; } $total = count($email); $count = 1; for (;;) { if ($count > $total) { break; } $to = $email[$count - 1]; $body = '<html> Dear ' . $name[$count - 1] . ', <p> Your Ad, ' . $name[$count - 1] . ' is about to expire please renew it if it has not already been sold</p> </html> '; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers $headers .= 'From: ' . $fromname . ' <' . $fromemail . '>' . "\r\n"; mail($to, $subject, $body, $headers); $query = "UPDATE #__aard_ads SET emailed='1' WHERE id ='" . $id[$count - 1] . "'"; $db =& JFactory::getDBO(); $db->setQuery($query); $dosql = $db->query(); $count++; } //mail ends here } }