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
}
}
