function EnableAccount() {
$this->logger->debug("Enable account");
$obm_q = new DB_OBM;
$query = "UPDATE Userobm set userobm_archive=0
WHERE #DAYDIFF(now(),userobm_account_dateexp)>=0 AND userobm_archive=1";
$this->logger->core($query);
$obm_q->xquery($query);
$this->logger->info($obm_q->affected_rows()." account enabled");
}
private static function storeCoords($contact) {
global $cdg_sql;
$id = sql_parse_id($contact->__get('entity_id'));
$obm_q = new DB_OBM;
$query = "DELETE FROM Phone WHERE phone_entity_id = $id";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(phone)');
$obm_q->query($query);
if(is_array($contact->phone)) {
$cpt = array();
foreach($contact->phone as $phone) {
if(trim($phone['number']) != '' ) {
if(is_array($phone['label'])) {
array_pop($phone['label']);
$phone['label'] = implode(';',$phone['label']);
} else {
$phone['label'] = str_replace('_', ';', $phone['label']);
}
$cpt[$phone['label']]++;
$query = "INSERT INTO Phone (phone_entity_id, phone_number, phone_label) VALUES ($id, '$phone[number]', '$phone[label];X-OBM-Ref".$cpt[$phone['label']]."')";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(phone)');
$obm_q->query($query);
}
}
}
$query = "DELETE FROM Address WHERE address_entity_id = $id";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(address)');
$obm_q->query($query);
if(is_array($contact->address)) {
$cpt = array();
foreach($contact->address as $address) {
if(trim($address['country_iso3166']) == 'none') $address['country_iso3166'] = '';
if(trim($address['country_iso3166']) == '' && trim($address['country']) != '') {
$address['country_iso3166'] = self::getCountryIso3166($address['country']);
}
if(trim($address['street']) != '' || trim($address['country_iso3166']) != ''
|| trim($address['zipcode']) != '' || trim($address['expresspostal']) != '') {
if(is_array($address['label'])) {
array_pop($address['label']);
$address['label'] = implode(';',$address['label']);
} else {
$address['label'] = str_replace('_', ';', $address['label']);
}
$cpt[$address['label']]++;
$query = "INSERT INTO Address (
address_entity_id,
address_street,
address_zipcode,
address_town,
address_expresspostal,
address_country,
address_label
) VALUES (
$id,
'".addslashes($address[street])."',
'".addslashes($address[zipcode])."',
'".addslashes($address[town])."',
'".addslashes($address[expresspostal])."',
'$address[country_iso3166]',
'$address[label];X-OBM-Ref".$cpt[$address['label']]."'
)";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(address)');
$obm_q->query($query);
}
}
}
$query = "DELETE FROM Website WHERE website_entity_id = $id";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(website)');
$obm_q->query($query);
if(is_array($contact->website)) {
$cpt = array();
foreach($contact->website as $website) {
if(trim($website['url']) != '' ) {
if(is_array($website['label'])) {
array_pop($website['label']);
$website['label'] = implode(';',$website['label']);
} else {
$website['label'] = str_replace('_', ';', $website['label']);
}
$cpt[$website['label']]++;
$query = "INSERT INTO Website (website_entity_id, website_url, website_label) VALUES ($id, '".addslashes($website[url])."', '$website[label];X-OBM-Ref".$cpt[$website['label']]."')";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(website)');
$obm_q->query($query);
}
}
}
$query = "DELETE FROM IM WHERE im_entity_id = $id";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(IM)');
$obm_q->query($query);
if(is_array($contact->im)) {
$cpt = array();
foreach($contact->im as $im) {
if(trim($im['address']) != '' ) {
$cpt[$im['protocol']]++;
$query = "INSERT INTO IM (im_entity_id, im_address, im_protocol, im_label) VALUES ($id, '".addslashes($im[address])."', '$im[protocol]', '$im[protocol];X-OBM-Ref".$cpt[$im['protocol']]."')";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(IM)');
$obm_q->query($query);
}
}
}
$query = "DELETE FROM Email WHERE email_entity_id = $id";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(Email)');
$obm_q->query($query);
if($obm_q->affected_rows() > 0) $updateGroup = true;
if(is_array($contact->email)) {
$cpt = array();
foreach($contact->email as $email) {
$updateGroup = true;
if(trim($email['address']) != '' ) {
if(is_array($email['label'])) {
array_pop($email['label']);
$email['label'] = implode(';',$email['label']);
} else {
$email['label'] = str_replace('_', ';', $email['label']);
}
$cpt[$email['label']]++;
$query = "INSERT INTO Email (email_entity_id, email_address, email_label) VALUES ($id, '".trim($email['address'])."', '$email[label];X-OBM-Ref".$cpt[$email['label']]."')";
display_debug_msg($query, $cdg_sql, 'OBM_Contact::storeCoords(Email)');
$obm_q->query($query);
}
}
}
if($updateGroup) {
$obm_q->query("UPDATE UGroup SET group_timeupdate = NOW() WHERE group_id IN (SELECT group_id FROM _contactgroup WHERE contact_id = ".$contact->id.")");
set_update_state();
}
}
