Hello,

bidders can recieve E-mails when new entries have been filled.
But most bidders only want to recieve e-mails with entries located in specific states ... is there a simple work around to achieve this

greetings

Hi Sorin,

Your first impression is right ... almost all first impressions are always right 

about adjusting the cron file ... that means this option goes for everbody.

it would be nicer if a bidder could choose what he wants.
Because some bidders live near borders of two states

for example
i want to recieve new entries mails from

category A  - state a and c
category B  - state d
category C  - all states

I think to achieve this the categories template + database does need a modification as well
This would be a great plus for the service abbility from the component.





 



 

Again this is a matter of coding style.
But, here is a sample of code (untested - the code is just explanatory for the algorithm ) assuming the following:
1. You have an state field in the user profile table (reverse default or CB )
2. You will create a category_state table wich you will be filling manually - in the example bellow #__rbid_cats_states
(The category will have a structure of primary key, category_id, state_id )

Add  this above the watchlist processing in the foreach (   foreach($rows as $i => $row){ )
// it should be on line 55 - 56
                // get the states of the categories to send mails
      $query = "select state_field from #__rbid_cats_states a where catid=$row->cat ";
      $database->setQuery($query);
      $states = $database->loadResultArray();
      $states_string = implode(',',$states);
                // get the users of the states selected
      $query = "select a.userid from #__rbid_USR_PROFILE_TABLE a where state_field IN ($states_string) AND a.userid <> $row->userid ";
      $database->setQuery($query);
      $ids = $database->loadResultArray();
      $id_string = implode(',',$ids);
      
      $query = "select u.* from #__users u
              where u.id in ($id_string)";
      
      $database->setQuery($query);
      $mails = $database->loadObjectList();
      $r = new mosrBidOffers( $database );
      $r->load( $row->id );
      $r->SendMails($mails,'new_auction_watch');

      //Notify Category  Watchlist
 ...

Cheers,
Sorin