Esempio n. 1
0
 function __construct()
 {
     $this->context = APP_EXTENSION . "_payments.";
     $this->tablename = '#__' . APP_PREFIX . '_payment_log';
     JTheFactoryHelper::tableIncludePath('payments');
     parent::__construct();
 }
Esempio n. 2
0
 function save($data)
 {
     // Get the previous configuration.
     if (is_object($data)) {
         $data = JArrayHelper::fromObject($data);
     }
     $prev = JTheFactoryHelper::getConfig();
     $prev = JArrayHelper::fromObject($prev);
     $data = array_merge($prev, $data);
     $configfile = JTheFactoryAdminHelper::getConfigFile();
     $config = new JRegistry('config');
     $config->loadArray($data);
     jimport('joomla.filesystem.path');
     jimport('joomla.filesystem.file');
     jimport('joomla.client.helper');
     // Get the new FTP credentials.
     $ftp = JClientHelper::getCredentials('ftp', true);
     // Attempt to make the file writeable if using FTP.
     if (!$ftp['enabled'] && JPath::isOwner($configfile) && !JPath::setPermissions($configfile, '0644')) {
         JError::raiseNotice(101, JText::_('FACTORY_SETTINGS_FILE_IS_NOT_WRITABLE'));
     }
     // Attempt to write the configuration file as a PHP class named JConfig.
     $configString = $config->toString('PHP', array('class' => ucfirst(APP_PREFIX) . "Config", 'closingtag' => false));
     if (!JFile::write($configfile, $configString)) {
         JError::raiseWarning(101, JText::_('FACTORY_SETTINGS_FILE_WRITE_FAILED'));
         return false;
     }
     // Attempt to make the file unwriteable if using FTP.
     if (!$ftp['enabled'] && JPath::isOwner($configfile) && !JPath::setPermissions($configfile, '0444')) {
         JError::raiseNotice(101, JText::_('FACTORY_SETTINGS_FILE_IS_NOT_WRITABLE'));
     }
     return true;
 }
Esempio n. 3
0
	function __construct($config=array())
	{
        $MyApp= JTheFactoryApplication::getInstance();
        $lang= JFactory::getLanguage();
        $lang->load('thefactory.payments');

        $config['view_path']=$MyApp->app_path_front.'payments'.DS."views";

        parent::__construct($config);
        JTheFactoryHelper::modelIncludePath('payments');
        JTheFactoryHelper::tableIncludePath('payments');

    }
Esempio n. 4
0
 function Listing()
 {
     $app = JFactory::getApplication();
     $filter_username = $app->getUserStateFromRequest(APP_EXTENSION . "_payments." . 'filter_username', 'filter_username', '', 'string');
     $cfg = JTheFactoryHelper::getConfig();
     $model = JModel::getInstance('Orders', 'JTheFactoryModel');
     $rows = $model->getOrdersList($filter_username);
     $view = $this->getView('orders');
     $view->assign('orders', $rows);
     $view->assign('filter_username', $filter_username);
     $view->assign('pagination', $model->get('pagination'));
     $view->assign('cfg', $cfg);
     $view->display('list');
 }
Esempio n. 5
0
 function display()
 {
     jimport('joomla.form.form');
     $form = JForm::getInstance('config', $this->formxml);
     $cfg = JTheFactoryHelper::getConfig();
     $data = JArrayHelper::fromObject($cfg);
     $form->bind($data);
     $groups = JTheFactoryConfigHelper::getFieldGroups($this->formxml);
     JTheFactoryEventsHelper::triggerEvent('onDisplaySettings', array($form, $groups, $data));
     $view = $this->getView('settings');
     $view->assignRef('groups', $groups);
     $view->assignRef('form', $form);
     $view->assignRef('formxml', $this->formxml);
     $view->display();
 }
Esempio n. 6
0
 function getGoogleCurrency($currency_from, $currency_to)
 {
     $url = "http://www.google.com/ig/calculator?hl=en&q=1+{$currency_from}=?{$currency_to}";
     $res = JTheFactoryHelper::remote_read_url($url);
     $matches = array();
     if (preg_match('/lhs:\\s*"([^"]*)"\\s*,rhs:\\s*"([^"]*)"\\s*,error:\\s*"([^"]*)"/', $res, $matches)) {
         $error = $matches[3];
         $rate = $matches[2];
         if ($error) {
             return false;
         }
         return floatval(substr($rate, 0, strpos($rate, " ")));
     } else {
         return false;
     }
 }
Esempio n. 7
0
 /**
  *         Field related Tasks / Admin Section
  */
 function Main()
 {
     $MyApp = JTheFactoryApplication::getInstance();
     $filename = $MyApp->getIniValue('version_root') . '/' . APP_EXTENSION . ".xml";
     $doc = JTheFactoryHelper::remote_read_url($filename);
     $xml = JFactory::getXML($doc, false);
     $view = $this->getView('main');
     if (version_compare(COMPONENT_VERSION, (string) $xml->latestversion) >= 0) {
         $view->assign('isnew_version', false);
     } else {
         $view->assign('isnew_version', true);
     }
     $view->assign('latestversion', (string) $xml->latestversion);
     $view->assign('versionhistory', (string) $xml->versionhistory);
     $view->assign('downloadlink', (string) $xml->downloadlink);
     $view->assign('aboutfactory', html_entity_decode((string) $xml->aboutfactory));
     $view->assign('otherproducts', html_entity_decode((string) $xml->otherproducts));
     $view->assign('build', (string) $xml->build);
     $view->display();
 }
Esempio n. 8
0
 function display($tpl = null)
 {
     $db = JFactory::getDBO();
     $db->setQuery("select * from #__bid_paysystems where enabled=1");
     $gateways = $db->loadObjectList();
     $db->setQuery("select * from #__bid_pricing where enabled=1");
     $items = $db->loadObjectList();
     $db->setQuery("select * from #__bid_cronlog where event='cron' order by logtime desc limit 1");
     $log = $db->loadObject();
     $cfg = JTheFactoryHelper::getConfig();
     $this->assignref('gateways', $gateways);
     $this->assignref('items', $items);
     if ($log) {
         $this->assignref('latest_cron_time', $log->logtime);
     } else {
         $this->assign('latest_cron_time', JText::_('COM_BIDS_NEVER'));
     }
     $this->assignref('cfg', $cfg);
     parent::display($tpl);
 }
 function __construct($modulename = null)
 {
     $this->modulename = $modulename;
     if (!$modulename) {
         $this->modulename = $this->name;
     }
     $MyApp = JTheFactoryApplication::getInstance();
     $this->basepath = $MyApp->app_path_admin . strtolower($this->modulename);
     $config = array('view_path' => $this->basepath . DS . "views");
     parent::__construct($config);
     $this->loadLanguage();
     $this->registerClass('toolbar');
     $this->registerClass('helper');
     $this->registerClass('submenu');
     if (file_exists($this->basepath . DS . "models")) {
         JTheFactoryHelper::modelIncludePath($this->modulename);
     }
     if (file_exists($this->basepath . DS . "tables")) {
         JTheFactoryHelper::tableIncludePath($this->modulename);
     }
 }
Esempio n. 10
0
    function getBalance() {

        JTheFactoryHelper::modelIncludePath('payments');
        $balance = JModelLegacy::getInstance('balance','JTheFactoryModel');

        return $balance->getUserBalance();
    }
Esempio n. 11
0
 function getModel($model)
 {
     jimport('joomla.application.component.model');
     JTheFactoryHelper::modelIncludePath('payments');
     return JModel::getInstance($model, 'JTheFactoryModel');
 }
Esempio n. 12
0
 public function Cronjob_Info()
 {
     $cfg = JTheFactoryHelper::getConfig();
     $db = JFactory::getDBO();
     $db->setQuery("select * from #__bid_cronlog where event='cron' order by logtime desc limit 1");
     $log = $db->loadObject();
     $view = $this->getView('settingspanel');
     $view->assignref('cfg', $cfg);
     $view->assignref('cronlog', $log);
     $view->display('cronsettings');
 }
Esempio n. 13
0
 function setCurrentTheme($theme)
 {
     $MyApp = JTheFactoryApplication::getInstance();
     $cfg = JTheFactoryHelper::getConfig();
     $cfg->theme = $theme;
     JTheFactoryHelper::modelIncludePath('config');
     $formxml = JPATH_ROOT . DS . "administrator" . DS . "components" . DS . APP_EXTENSION . DS . $MyApp->getIniValue('configxml');
     $model = JModel::getInstance('Config', 'JTheFactoryModel', array('formxml' => $formxml));
     $model->save($cfg);
 }
Esempio n. 14
0
 /**
  * JTheFactoryApplication::Initialize()
  *  loads some "magic" files like defines.php,loads the main helper file (APP_PREFIX.php)
  *  loads other helpers (through helper::loadHelperclasses)
  *  loads the needed Controller
  *  adds htmlelements and formelements to path (admin)
  *  adds tables to paths
  * 
  * @return void
  */
 function Initialize($task = null)
 {
     jimport('joomla.application.component.controller');
     if (!$this->frontpage) {
         JFormHelper::addFieldPath(JPATH_COMPONENT_ADMINISTRATOR . DS . 'formelements');
     }
     JHtml::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR . DS . 'htmlelements');
     JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR . DS . 'tables');
     if (file_exists(JPATH_COMPONENT_SITE . DS . 'defines.php')) {
         require_once JPATH_COMPONENT_SITE . DS . 'defines.php';
     }
     if (file_exists(JPATH_COMPONENT_SITE . DS . 'helpers' . DS . strtolower($this->appname) . '.php')) {
         require_once JPATH_COMPONENT_SITE . DS . 'helpers' . DS . strtolower($this->appname) . '.php';
     }
     $class_name = ucfirst($this->appname) . 'Helper';
     call_user_func(array($class_name, 'loadHelperClasses'));
     JTheFactoryEventsHelper::triggerEvent('onBeforeExecuteTask', array(&$this->_stopexecution));
     if ($this->_stopexecution) {
         return;
     }
     if (!$task) {
         $task = JRequest::getCmd('task');
     }
     $this->_controller = JTheFactoryHelper::loadController($task);
     //Try to load Framework controllers
     if (!$this->_controller) {
         $controllerClass = JRequest::getWord('controller');
         if (!$controllerClass && strpos($task, '.') !== FALSE) {
             $task = explode('.', $task);
             $controllerClass = $task[0];
         }
         if ($controllerClass) {
             $path = JPATH_COMPONENT . DS . 'controllers' . DS . basename($controllerClass) . '.php';
             file_exists($path) ? require_once $path : JError::raiseError(500, JText::_('ERROR_CONTROLLER_NOT_FOUND'));
             $controllerClass = 'J' . ucfirst($this->appname) . ($this->frontpage ? "" : "Admin") . 'Controller' . $controllerClass;
             $this->_controller = new $controllerClass();
         } else {
             $this->_controller = JControllerLegacy::getInstance('J' . ucfirst($this->appname) . ($this->frontpage ? "" : "Admin"));
         }
     }
 }
Esempio n. 15
0
    function smarty_positions($params, &$smarty) {
        if(!isset($params['position']) || empty($params['position']))
            return null;
        if(!isset($params['item']) || empty($params['item']))
            return null;
        $item=$params['item'];
        $page=(isset($params['page']))?$params['page']:"";
        $catfield=null;
        if (is_callable(array($item,'getCategoryField')))
            $catfield=$item->getCategoryField(); //make sure proper object is passed
        if (is_object($item)) $item=get_object_vars($item);

        $position=$params['position'];
        $template_file=$smarty->get_template_vars('template_file');
        JTheFactoryHelper::modelIncludePath('positions');
        $model= JModelLegacy::getInstance('Positions','JTheFactoryModel');
        $fields=$model->getFieldsForPosition($template_file,$position);       
        $result="";

        $fieldObj= JTable::getInstance('FieldsTable','JTheFactory');
        JTheFactoryHelper::modelIncludePath('fields');
        $fieldsmodel= JModelLegacy::getInstance('Fields','JTheFactoryModel');
        
        foreach($fields as $field)
            if (isset($item[$field->db_name])&&$page==$field->page)
            {
                $fieldObj->bind($field);
                if ($catfield && $fieldObj->categoryfilter && !$fieldsmodel->hasAssignedCat($fieldObj,$item->$catfield))
                    continue;
                    
                $ftype= CustomFieldsFactory::getFieldType($field->ftype);
                $field_label=$field->name;

                $field_html=$ftype->getTemplateHTML($fieldObj,$item[$field->db_name]);
                
                $result.="<div id='{$field->db_name}'><label class='custom_field'>{$field_label}</label>:&nbsp;{$field_html}</div>";
            }
        return $result;
    }
Esempio n. 16
0
 function sendNotificationMail($user)
 {
     $config = JFactory::getConfig();
     $mail_from = $config->getValue("mailfrom");
     $sitename = $config->getValue("sitename");
     JTheFactoryHelper::modelIncludePath('payments');
     $balancemodel = JModel::getInstance('Balance', 'JTheFactoryModel');
     $balance = $balancemodel->getUserBalance($user->id);
     $r = $this->loadPricingObject();
     $params = new JParameter($r->params);
     $email_text = base64_decode($params->get('email_text'));
     $link = JURI::root() . '/index.php?option=' . APP_EXTENSION . '&task=paycomission';
     $email_text = str_replace('%USERNAME%', $user->username, $email_text);
     $email_text = str_replace('%NAME%', $user->name, $email_text);
     $email_text = str_replace('%BALANCE%', $balance->balance . " " . $balance->currency, $email_text);
     $email_text = str_replace('%LINK%', $link, $email_text);
     JUTility::sendMail($mail_from, $sitename, $user->email, JText::_("COM_BIDS_COMISION_PAYMENT_NOTIFICATION"), $email_text, true);
 }
Esempio n. 17
0
 function notices()
 {
     JTheFactoryHelper::modelIncludePath('payments');
     $balancemodel = JModel::getInstance('Balance', 'JTheFactoryModel');
     $balancemodel->set('filters', 'p.balance<0');
     $rows = $balancemodel->getBalancesList();
     $viewMenu = $this->getView('menu');
     $viewMenu->display();
     $view = $this->getView('Notices');
     $view->assign('userbalances', $rows);
     $view->assign('pagination', $balancemodel->get('pagination'));
     $view->display();
 }
Esempio n. 18
0
    function cron()
    {
        /* cron script Pass and authentication*/
        $cfg=BidsHelperTools::getConfig();
        $config =JFactory::getConfig();
        $pass=JRequest::getVar('pass');
        $debug= JRequest::getVar('debug',0);

        $date=new JDate();
        $nowMysql=$date->toMySQL(false);

        $database = JFactory::getDbo();

        JTheFactoryHelper::modelIncludePath('payments');
        JTheFactoryHelper::tableIncludePath('payments');

        $log= JTable::getInstance('bidcronlog');
        $log->priority='log';
        $log->event='cron';
        $log->logtime=$nowMysql;
        $logtext="";

        if ($cfg->bid_opt_cron_password!==$pass) {
            //Bad Password, log and exit;
            $log->log=JText::_("COM_BIDS_BAD_PASSWORD_USED")." > $pass";
            $log->store();
            die(JText::_("COM_BIDS_ACCESS_DENIED"));
        }
    	@set_time_limit(0);
    	@ignore_user_abort(true);



        // reminder for due to expire suggestions
        $database->setQuery(" SELECT s.auction_id,a.userid
                                FROM #__bid_suggestions AS s
                                LEFT JOIN #__bid_auctions AS a
                                    ON s.auction_id = a.id
                                WHERE
                                    s.status=2
                                    AND UTC_TIMESTAMP() > DATE_ADD( s.modified, INTERVAL 24 HOUR)
                                    AND a.published=1
                                    AND a.close_offer=0
                                    AND a.close_by_admin=0
                                    AND UTC_TIMESTAMP() < a.end_date
                                GROUP BY s.auction_id");
        $curs = $database->loadObjectList();
        
        if(count($curs)>0) {
            $auction =  JTable::getInstance('auction');
            $userIds = array();
        
            foreach($curs as $k=>$val) {
                $userIds[] = $val->userid;
            }
            $database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ( '.implode(',',$userIds).' )');
            $mails = $database->loadObjectList();
            $auction->SendMails($mails,'suggest_reminder'); //Notyfy Sellers abour pending suggestions
        }
        
        // reject expired suggestions
        $database->setQuery(" SELECT a.id AS suggestionId,a.auction_id,b.userid
                                FROM #__bid_suggestions AS a
                                LEFT JOIN #__bid_auctions AS b
                                    ON a.auction_id = b.id
        			WHERE
                                    UTC_TIMESTAMP() > DATE_ADD( a.modified, INTERVAL 48 HOUR)
                                    AND a.status=2");
        $curs = $database->loadObjectList();
        
        if(count($curs)>0) {
            $auction =  JTable::getInstance('auction');
            $userIds = array();
            $suggestionIds = array();
        
            foreach($curs as $k=>$val) {
                $suggestionIds[] = $val->suggestionId;
                $userIds[] = $val->userid;
            }
        
            $database->setQuery('UPDATE #__bid_suggestions SET status=0 WHERE id IN ('.implode(',',$suggestionIds).')');
            $database->query();// reject the suggestions
        
            $database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ( '.implode(',',$userIds).' )');
            $mails = $database->loadObjectList();
            $auction->SendMails($mails,'suggest_rejected'); //Notyfy Bidders abour rejected suggestion
        }
        
        //CLOSE auctions
        $query = "SELECT
                        a.*,
                        a.id as auctionId,
                        GROUP_CONCAT(b.userid) AS bidderIds,
                        GROUP_CONCAT(w.userid) AS watcherIds
                    FROM #__bid_auctions AS a
                    LEFT JOIN #__bids AS b
                        ON a.id=b.auction_id
                    LEFT JOIN #__bid_watchlist AS w
                        ON a.id=w.auction_id
                    WHERE
                        UTC_TIMESTAMP() >= a.end_date
                        AND a.close_offer = 0
                        AND a.published = 1
                        AND a.close_by_admin=0
                    GROUP BY a.id";
        $database->setQuery($query);
        $rows = $database->loadObjectList('auctionId');


        $extendedAuctions = array();
        if($cfg->bid_opt_auto_extent && $cfg->bid_opt_auto_extent_nobids) {
            //these auctions have no bids and will be extended
            foreach($rows as $id=>$r) {
                if(!$r->bidderIds) {
                    $extendedAuctions[] = $id;
                }
            }
        }

        if(count($rows)>0) {
            $auction =  JTable::getInstance('auction');

            //exclude auctions that are going to be extended
            $closeAuctions = array_diff(array_keys($rows),$extendedAuctions);
            if(count($closeAuctions)) {
                $database->setQuery('UPDATE
                                        #__bid_auctions
                                     SET
                                        close_offer=1,
                                        closed_date=UTC_TIMESTAMP()
                                     WHERE
                                        id IN ('.implode(',',  $closeAuctions).')');
                $database->query();
            }
        
            foreach ($rows as $r) {
                //Notify bidders
                $auction->bind($r);
        
                //extend auctions with no bids
                if($cfg->bid_opt_auto_extent && $cfg->bid_opt_auto_extent_nobids>0 && !$r->bidderIds) {
                    $extendedPeriodSeconds = $cfg->bid_opt_auto_extent_nobids * BidsHelperDateTime::translateAutoextendPeriod($cfg->bid_opt_auto_extent_nobids_type);
                    $endTime = BidsHelperDateTime::getTimeStamp($auction->end_date);
                    $newEndTime = $endTime + $extendedPeriodSeconds;

                    $auction->end_date = gmdate('Y-m-d H:i:s',$newEndTime);
                    $auction->store();

                    continue;
                }
        
                jimport('joomla.application.component.model');
                JModelLegacy::addIncludePath(JPATH_COMPONENT_SITE.DS.'models');
                $auctionmodel = JModelLegacy::getInstance('auction','bidsModel');
                $auctionmodel->load($r->auctionId);
        
                $seller = JTable::getInstance('user');
                $seller->load($r->userid);
        
                if($r->automatic) {
        
                    $a = $auctionmodel->get('auction');
                    $highestBid = $a->highestBid;
        
                    $nrHighestBids = 1;
                    if( AUCTION_TYPE_PRIVATE == $a->auction_type ) {
                        if($highestBid) {
                            $query = 'SELECT COUNT(1) AS nrHighestBids
                                        FROM #__bids
                                        WHERE
                                            auction_id='.$r->auctionId.'
                                            AND bid_price='.$highestBid->bid_price;
                            $database->setQuery($query);
                            $nrHighestBids = $database->loadResult();
                        }
                        else {
                            $nrHighestBids = 0;
                        }
                    }
        
                    if($highestBid) {
                        if ($nrHighestBids>1) {
                            //mark auction as NOT automatic and alert owner that 2 or more bids are the same
                            $database->setQuery('UPDATE #__bid_auctions SET automatic=0 WHERE id='.$a->id);
                            $database->query();
        
                            $auctionmodel->SendMails(array($seller),'bid_choose_winner');
                        } else {
                            if ($cfg->bid_opt_global_enable_reserve_price && $a->reserve_price>0 && $a->reserve_price>=$highestBid->bid_price) {
                                //reserve price not met!
                                $auctionmodel->SendMails(array($seller),'bid_reserve_not_met');//reserve price not met
                            } else {
                                $bid = JTable::getInstance('bid');
                                $bid->bind($highestBid);
                                $auctionmodel->close($bid);
                            }
                        }
                    } else {
                        $auctionmodel->SendMails(array($seller),'bid_offer_no_winner_to_owner');
                    }
        
                } else {
                    // Notify owner to choose winner OR that his auction has no winner
                    $auctionmodel->SendMails(array($seller), $r->bidderIds ? 'bid_choose_winner' : 'bid_offer_no_winner_to_owner');
                }
        
                if($r->bidderIds) {
                    $database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ('.$r->bidderIds.')');
                    $mails = $database->loadObjectList();
                    $auctionmodel->SendMails($mails,'bid_closed'); //Notyfy Bidders abour closed Auction
        
                    $database->setQuery('DELETE FROM #__bid_watchlist WHERE auction_id='.$r->id.' AND userid IN ('.$r->bidderIds.')');
                    $database->query();//delete bidders from watchlist, to avoid double notification
                }
                //Notify  Watchlist, Clean Watchlist
                if($r->watcherIds) {
                    $database->setQuery('SELECT u.* FROM #__users AS u WHERE u.id IN ('.$r->watcherIds.')');
                    $mails = $database->loadObjectList();
                    $auctionmodel->SendMails($mails,'bid_watchlist_closed'); //Notify Watchlist
        
                    $database->setQuery('DELETE FROM #__bid_watchlist WHERE auction_id='.$r->id);
                    $database->query();
                }
            }
        }
        
        // END EXPIRED AUCTION
    
    
        //Daily Jobs (things that should run once a day )
        $daily= JRequest::getVar('daily','');
        if ($daily){
            //Notify upcoming expirations
        	$query = "SELECT a.* from #__bid_auctions AS a
        		 	  WHERE UTC_TIMESTAMP() >= DATE_ADD(end_date,INTERVAL -1 DAY) AND a.close_offer != 1 AND published = 1 AND a.close_by_admin!=1";
        	$database->setQuery($query);
        	$rows = $database->loadObjectList();
    
        	$auction =  JTable::getInstance('auction');
  	        
            $logtext.=sprintf("Soon to expire: %d auctions\r\n",count($rows));
    
            foreach ($rows as $row){
                    $auction->load($row->id);
                    $usr=JFactory::getUser($row->userid);
                    $auction->SendMails(array($usr),'bid_your_will_expire'); // Notify Owner that his auction will soon expire
    
                    $query = "SELECT u.* FROM #__users u
                            left join #__bid_watchlist w on u.id = w.userid
                            where w.auction_id = ".$row->id;
    
                    $database->setQuery($query);
                    $watchlist_mails = $database->loadObjectList();
                    $auction->SendMails($watchlist_mails,'bid_watchlist_will_expire'); //Notify Users in watchlist that an auction will expire
            }
    
        	//Close all auctions without a parent user (deleted users?)s
        	$query = "UPDATE
                        #__bid_auctions AS a
                        LEFT JOIN #__users AS b
                            ON a.userid=b.id
                        SET
                            close_by_admin=1,
                            closed_date=UTC_TIMESTAMP()
                        WHERE b.id IS NULL";
        	$database->setQuery($query);
        	$database->query();
            //delete Very old auctions (past Archived time)
        	$interval =  intval($bidCfg->bid_opt_archive);
            $d_opt = ( $bidCfg->bid_opt_archive_type!='') ? $bidCfg->bid_opt_archive_type : 'month';
            $d_opt_sql = strtoupper($d_opt);
        	if ($interval>0){
            	$query = "SELECT id
                                FROM #__bid_auctions
                                WHERE UTC_TIMESTAMP() > DATE_ADD( closed_date, INTERVAL $interval
                                {$d_opt_sql} )
                                AND (close_offer =1
                                or  close_by_admin=1)";
                $database->setQuery($query);
                $idx = $database->loadResultArray(); //select auctions that have to be purged
    
    
                $row =  JTable::getInstance('auction');
                if (count($idx)) {
                    foreach ($idx as $id){
                        $row->delete($id);
                    }
                }
        	}

            $model= JModelLegacy::getInstance('Currency','JTheFactoryModel');
            $currtable= JTable::getInstance('CurrencyTable','JTheFactory');
    
            $currencies=$model->getCurrencyList();
            $default_currency=$model->getDefault();
            $results=array();
            foreach($currencies as $currency){
                if ($currency->name==$default_currency){
                    $currtable->load($currency->id);
                    $currtable->convert=1;
                    $currtable->store();
                    $results[]=$currency->name." ---> ".$default_currency." = 1";
                    continue;
                }
                $conversion=$model->getGoogleCurrency($currency->name,$default_currency);
                if ($conversion===false){
                    $results[]=JText::_("COM_BIDS_ERROR_CONVERTING")." {$currency->name} --> $default_currency";
                    continue;
                }
                $currtable->load($currency->id);
                $currtable->convert=$conversion;
                $currtable->store();
                $results[]=$currency->name." ---> ".$default_currency." = $conversion ";
            }
            $logtext.=implode("\r\n",$results);
            $logtext.="\r\n";
            //some cleanup
        	
        }
        $log->log=$logtext;
        $log->store();
        if ($debug) return;
        ob_clean();
        exit();
        

    }