Send an cc mail to a second or third email on notification

[Adrian Peptine1424296193]

Hi there

 

We are using the jreviews for a marketplace site for kids only. What we need is that the parents are informed true email about what their kids put on the market place for sale.

 

The second or third mail stays on jomsocial user profile  table #__community_fields_values here is "user_id" the owner id,  "field_id" is the id of the second email field, and "value" is the email address.

 

What I need that this value is taken from the database and put on the same place where the notification takes place as cc mail address.

 

some like this

 

function getListingOwnerSecondEmail($result_id) {

$query = "SELECT User.id user_id, User.name, User.value ".

              "FROM #__community_fields_values AS User ".

              "WHERE User.id = " . (int) ($result_id);

  $this->_db->setQuery($query);

  return current($this->_db->loadObject());

  $result = $db->loadObject();

  print_r($result);}

 

ant put the result somewhere in to be processed on new post of the user

 

/com_jreviews/jreviews/controllers/components/notifications.php

 

Can someone help me on this one