';
}else{
echo '
';
}
if($state == false)
{
echo "
"._THE_ADDRESS." "._UNKOWN."
";
}
else
{
$this->get_contact_form();
$action = $_SESSION['config']['businessappurl']."index.php?display=true&page=contact_addresses_up_db";
$fieldAddressClass = "address_modification_field";
$fieldSalutationClass = "salutation_modification_field";
if(!$admin)
{
$action = $_SESSION['config']['businessappurl']."index.php?display=true&page=contact_addresses_up_db&mycontact=Y";
}
if($iframe == "iframe"){
$action = $_SESSION['config']['businessappurl']."index.php?display=false&page=contact_addresses_up_db&mycontact=iframe";
$fieldAddressClass = "address_modification_field_frame";
$fieldSalutationClass = "salutation_modification_field_frame";
} else if($iframe == "iframe_add_up") {
$action = $_SESSION['config']['businessappurl']."index.php?display=false&page=contact_addresses_up_db&mycontact=iframe_add_up";
} else if($iframe == "fromContactIframe"){
$action = $_SESSION['config']['businessappurl']."index.php?display=false&page=contact_addresses_up_db&mycontact=fromContactIframe";
}
if (isset($_SESSION['contact_address']['fromContactAddressesList']) && $_SESSION['contact_address']['fromContactAddressesList'] <> "") {
$action = $_SESSION['config']['businessappurl'].'index.php?display=true&page=contact_addresses_up_db&fromContactAddressesList';
}
?>
addressinfo($mode);
$order = $_SESSION['m_admin']['address']['order'];
$order_field = $_SESSION['m_admin']['address']['order_field'];
$what = $_SESSION['m_admin']['address']['what'];
$start = $_SESSION['m_admin']['address']['start'];
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?page=contacts_v2_up&order='
. $order . '&order_field=' . $order_field . '&start='
. $start . '&what=' . $what;
$path_contacts_add_errors = $_SESSION['config']['businessappurl']
. 'index.php?page=contact_addresses_add';
$path_contacts_up_errors = $_SESSION['config']['businessappurl']
. 'index.php?page=contact_addresses_up';
if (! $admin) {
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?dir=my_contacts&page=my_contact_up&load&order='
. $order . '&order_field=' . $order_field . '&start='
. $start . '&what=' . $what;
$path_contacts_add_errors = $_SESSION['config']['businessappurl']
. 'index.php?page=contact_addresses_add&mycontact=Y';
$path_contacts_up_errors = $_SESSION['config']['businessappurl']
. 'index.php?page=contact_addresses_up&mycontact=Y';
}
if ($iframe) {
if($mode == 'add') {
if($iframe == 1){
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=create_contact_iframe&created=Y';
$path_contacts_add_errors = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=create_address_iframe';
} else if($iframe == 2) {
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=info_contact_iframe&contactid='.$_SESSION['contact']['current_contact_id'].'&addressid='.$_SESSION['contact']['current_address_id'];
$path_contacts_add_errors = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=create_address_iframe&iframe=iframe_up_add';
} else if($iframe == 3) {
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=info_contact_iframe&created=add&contactid='.$_SESSION['contact']['current_contact_id'].'&addressid='.$_SESSION['contact']['current_address_id'];
$path_contacts_add_errors = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=create_address_iframe&iframe=iframe_up_add';
}
} else if($mode == 'up') {
if ($iframe == 3) {
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=info_contact_iframe&created=Y&contactid='.$_SESSION['contact']['current_contact_id'].'&addressid='.$_SESSION['contact']['current_address_id'];
} else {
$path_contacts = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=info_contact_iframe&created=Y&contactid='.$_SESSION['contact']['current_contact_id'].'&addressid='.$_SESSION['contact']['current_address_id'];
}
$path_contacts_up_errors = $_SESSION['config']['businessappurl']
. 'index.php?display=false&dir=my_contacts&page=update_address_iframe';
}
}
if (isset($_SESSION['contact_address']['fromContactAddressesList']) && $_SESSION['contact_address']['fromContactAddressesList'] <> "") {
$path_contacts = $_SESSION['config']['businessappurl'] . 'index.php?page=contact_addresses_list';
$path_contacts_up_errors = $_SESSION['config']['businessappurl'] . 'index.php?page=contact_addresses_up&fromContactAddressesList';
$_SESSION['contact_address']['fromContactAddressesList'] = "";
}
if (! empty($_SESSION['error'])) {
if ($mode == 'up') {
if (! empty($_SESSION['m_admin']['address']['ID'])) {
$_SESSION['address_up_error'] = "true";
header(
'location: ' . $path_contacts_up_errors . '&id='
. $_SESSION['m_admin']['address']['ID']
);
exit;
} else {
header('location: ' . $path_contacts);
exit;
}
}
if ($mode == 'add') {
header('location: ' . $path_contacts_add_errors);
exit;
}
} else {
if ($_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] == "") {
$stmt = $db->query("SELECT id FROM contact_purposes WHERE label = ?", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
if ($stmt->rowCount() == 0) {
$db->query("INSERT INTO contact_purposes (label) VALUES (?)", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
$stmt = $db->query("SELECT id FROM contact_purposes WHERE label = ?", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
}
$res_purpose = $stmt->fetchObject();
$_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] = $res_purpose->id;
} else if($_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] <> "" && $_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME'] <> ""){
$stmt = $db->query("SELECT id FROM contact_purposes WHERE label = ?", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
$res_purpose = $stmt->fetchObject();
if ($res_purpose->id != $_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID']) {
$db->query("INSERT INTO contact_purposes (label) VALUES (?)", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
$stmt = $db->query("SELECT id FROM contact_purposes WHERE label = ?", array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME']));
$res_purpose = $stmt->fetchObject();
$_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] = $res_purpose->id;
}
}
if ($mode == 'add') {
if($_SESSION['user']['UserId'] == 'superadmin'){
$entity_id = 'SUPERADMIN';
} else {
$entity_id = $_SESSION['user']['primaryentity']['id'];
}
$query = 'INSERT INTO ' . $_SESSION['tablename']['contact_addresses']
. ' ( contact_id, contact_purpose_id, departement, lastname , firstname , function , '
. 'phone , email , address_num, address_street, '
. 'address_complement, address_town, '
. 'address_postal_code, address_country, other_data,'
. " title, is_private, website, occupancy, user_id, entity_id, salutation_header, salutation_footer) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$arrayPDO = array($_SESSION['contact']['current_contact_id'], $_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'], $_SESSION['m_admin']['address']['DEPARTEMENT'],
$_SESSION['m_admin']['address']['LASTNAME'], $_SESSION['m_admin']['address']['FIRSTNAME'], $_SESSION['m_admin']['address']['FUNCTION'], $_SESSION['m_admin']['address']['PHONE'],
$_SESSION['m_admin']['address']['MAIL'], $_SESSION['m_admin']['address']['ADD_NUM'], $_SESSION['m_admin']['address']['ADD_STREET'], $_SESSION['m_admin']['address']['ADD_COMP'],
$_SESSION['m_admin']['address']['ADD_TOWN'], $_SESSION['m_admin']['address']['ADD_CP'], $_SESSION['m_admin']['address']['ADD_COUNTRY'], $_SESSION['m_admin']['address']['OTHER_DATA'],
$_SESSION['m_admin']['address']['TITLE'], $_SESSION['m_admin']['address']['IS_PRIVATE'], $_SESSION['m_admin']['address']['WEBSITE'], $_SESSION['m_admin']['address']['OCCUPANCY'],
$_SESSION['user']['UserId'], $entity_id, $_SESSION['m_admin']['address']['SALUTATION_HEADER'], $_SESSION['m_admin']['address']['SALUTATION_FOOTER']);
$db->query($query, $arrayPDO);
if($_SESSION['history']['addressadd'])
{
$stmt = $db->query("SELECT id FROM ".$_SESSION['tablename']['contact_addresses']." WHERE
lastname = ? and firstname = ? and society = ? and function = ? and is_corporate_person = ?",
array($_SESSION['m_admin']['address']['LASTNAME'], $_SESSION['m_admin']['address']['FIRSTNAME'], $_SESSION['m_admin']['address']['SOCIETY'], $_SESSION['m_admin']['address']['FUNCTION'], $_SESSION['m_admin']['address']['IS_CORPORATE_PERSON']));
$res = $stmt->fetchObject();
$id = $res->contact_id;
if($_SESSION['m_admin']['address']['IS_CORPORATE_PERSON'] == 'Y')
{
$msg = _ADDRESS_ADDED.' : '.functions::protect_string_db($_SESSION['m_admin']['address']['SOCIETY']);
}
else
{
$msg = _ADDRESS_ADDED.' : '.functions::protect_string_db($_SESSION['m_admin']['address']['LASTNAME'].' '.$_SESSION['m_admin']['address']['FIRSTNAME']);
}
require_once('core'.DIRECTORY_SEPARATOR.'class'.DIRECTORY_SEPARATOR.'class_history.php');
$hist = new history();
$hist->add($_SESSION['tablename']['contact_addresses'], $id,"ADD",'contact_addresses_add',$msg, $_SESSION['config']['databasetype']);
}
if($iframe){
$this->clearcontactinfos();
}
$this->clearaddressinfos();
$_SESSION['info'] = _ADDRESS_ADDED;
header("location: ".$path_contacts);
exit;
}
elseif($mode == "up")
{
$query = "UPDATE ".$_SESSION['tablename']['contact_addresses']."
SET contact_purpose_id = ?
, departement = ?
, firstname = ?
, lastname = ?
, title = ?
, function = ?
, phone = ?
, email = ?
, occupancy = ?
, address_num = ?
, address_street = ?
, address_complement = ?
, address_town = ?
, address_postal_code = ?
, address_country = ?
, website = ?
, other_data = ?
, is_private = ?
, salutation_header = ?
, salutation_footer = ?";
$query .=" WHERE id = ?";
$arrayPDO = array($_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'], $_SESSION['m_admin']['address']['DEPARTEMENT'], $_SESSION['m_admin']['address']['FIRSTNAME'],
$_SESSION['m_admin']['address']['LASTNAME'], $_SESSION['m_admin']['address']['TITLE'], $_SESSION['m_admin']['address']['FUNCTION'], $_SESSION['m_admin']['address']['PHONE'],
$_SESSION['m_admin']['address']['MAIL'], $_SESSION['m_admin']['address']['OCCUPANCY'], $_SESSION['m_admin']['address']['ADD_NUM'], $_SESSION['m_admin']['address']['ADD_STREET'], $_SESSION['m_admin']['address']['ADD_COMP'],
$_SESSION['m_admin']['address']['ADD_TOWN'], $_SESSION['m_admin']['address']['ADD_CP'], $_SESSION['m_admin']['address']['ADD_COUNTRY'], $_SESSION['m_admin']['address']['WEBSITE'],
$_SESSION['m_admin']['address']['OTHER_DATA'], $_SESSION['m_admin']['address']['IS_PRIVATE'], $_SESSION['m_admin']['address']['SALUTATION_HEADER'], $_SESSION['m_admin']['address']['SALUTATION_FOOTER'],
$_SESSION['m_admin']['address']['ID']);
$db->query($query, $arrayPDO);
if($_SESSION['history']['contactup'])
{
$msg = _ADDRESS_EDITED.' : '.functions::protect_string_db($_SESSION['m_admin']['address']['SOCIETY']).' '.functions::protect_string_db($_SESSION['m_admin']['address']['LASTNAME'].' '.$_SESSION['m_admin']['address']['FIRSTNAME']);
require_once('core'.DIRECTORY_SEPARATOR.'class'.DIRECTORY_SEPARATOR.'class_history.php');
$hist = new history();
$hist->add($_SESSION['tablename']['contacts_v2'], $_SESSION['m_admin']['address']['ID'],"UP",'contacts_v2_up',$msg, $_SESSION['config']['databasetype']);
}
$this->clearcontactinfos();
$_SESSION['info'] = _ADDRESS_EDITED;
header("location: ".$path_contacts);
exit();
}
}
}
/**
* Return the address data in sessions vars
*
* @param string $mode add or up
*/
public function addressinfo($mode)
{
// return the user information in sessions vars
$func = new functions();
if ($_REQUEST['title'] <> '') {
$_SESSION['m_admin']['address']['TITLE'] = $func->wash(
$_REQUEST['title'], 'no', _TITLE2 . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['TITLE'] = '';
}
if ($_REQUEST['contact_purposes'] <> '') {
$_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] = $func->wash(
$_REQUEST['contact_purposes'], 'no', _CONTACT_PURPOSE . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['CONTACT_PURPOSE_ID'] = '';
}
$_SESSION['m_admin']['address']['CONTACT_PURPOSE_NAME'] = $func->wash(
$_REQUEST['new_id'], 'no', _CONTACT_PURPOSE . ' ', 'yes', 0, 255
);
if ($_REQUEST['departement'] <> '') {
$_SESSION['m_admin']['address']['DEPARTEMENT'] = $func->wash(
$_REQUEST['departement'], 'no', _DEPARTEMENT . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['DEPARTEMENT'] = '';
}
if ($_REQUEST['lastname'] <> '') {
$_SESSION['m_admin']['address']['LASTNAME'] = $func->wash(
$_REQUEST['lastname'], 'no', _LASTNAME . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['LASTNAME'] = '';
}
if ($_REQUEST['firstname'] <> '') {
$_SESSION['m_admin']['address']['FIRSTNAME'] = $func->wash(
$_REQUEST['firstname'], 'no', _FIRSTNAME . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['FIRSTNAME'] = '';
}
if ($_REQUEST['function'] <> '') {
$_SESSION['m_admin']['address']['FUNCTION'] = $func->wash(
$_REQUEST['function'], 'no', _FUNCTION . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['FUNCTION'] = '';
}
if ($_REQUEST['num'] <> '') {
$_SESSION['m_admin']['address']['ADD_NUM'] = $func->wash(
$_REQUEST['num'], 'no', _NUM . ' ', 'yes', 0, 32
);
} else {
$_SESSION['m_admin']['address']['ADD_NUM'] = '';
}
if ($_REQUEST['street'] <> '') {
$_SESSION['m_admin']['address']['ADD_STREET'] = $func->wash(
$_REQUEST['street'], 'no', _STREET . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['ADD_STREET'] = '';
}
if ($_REQUEST['add_comp'] <> '') {
$_SESSION['m_admin']['address']['ADD_COMP'] = $func->wash(
$_REQUEST['add_comp'], 'no', ADD_COMP . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['ADD_COMP'] = '';
}
if ($_REQUEST['town'] <> '') {
$_SESSION['m_admin']['address']['ADD_TOWN'] = $func->wash(
$_REQUEST['town'], 'no', _TOWN . ' ', 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['ADD_TOWN'] = '';
}
if ($_REQUEST['cp'] <> '') {
$_SESSION['m_admin']['address']['ADD_CP'] = $func->wash(
$_REQUEST['cp'], 'no', _POSTAL_CODE, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['ADD_CP'] = '';
}
if ($_REQUEST['country'] <> '') {
$_SESSION['m_admin']['address']['ADD_COUNTRY'] = $func->wash(
$_REQUEST['country'], 'no', _COUNTRY, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['ADD_COUNTRY'] = '';
}
if ($_REQUEST['phone'] <> '') {
$_SESSION['m_admin']['address']['PHONE'] = $func->wash(
$_REQUEST['phone'], 'phone', _PHONE, 'yes', 0, 20
);
} else {
$_SESSION['m_admin']['address']['PHONE'] = '';
}
if ($_REQUEST['mail'] <> '') {
$_SESSION['m_admin']['address']['MAIL'] = $func->wash(
$_REQUEST['mail'], 'mail', _MAIL, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['MAIL'] = '';
}
if ($_REQUEST['comp_data'] <> '') {
$_SESSION['m_admin']['address']['OTHER_DATA'] = $func->wash(
$_REQUEST['comp_data'], 'no', _COMP_DATA, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['OTHER_DATA'] = '';
}
if ($_REQUEST['website'] <> '') {
$_SESSION['m_admin']['address']['WEBSITE'] = $func->wash(
$_REQUEST['website'], 'no', _WEBSITE, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['WEBSITE'] = '';
}
if ($_REQUEST['occupancy'] <> '') {
$_SESSION['m_admin']['address']['OCCUPANCY'] = $func->wash(
$_REQUEST['occupancy'], 'no', _OCCUPANCY, 'yes', 0, 1024
);
} else {
$_SESSION['m_admin']['address']['occupancy'] = '';
}
if ($_REQUEST['salutation_header'] <> '') {
$_SESSION['m_admin']['address']['SALUTATION_HEADER'] = $func->wash(
$_REQUEST['salutation_header'], 'no', _SALUTATION_HEADER, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['SALUTATION_HEADER'] = '';
}
if ($_REQUEST['salutation_footer'] <> '') {
$_SESSION['m_admin']['address']['SALUTATION_FOOTER'] = $func->wash(
$_REQUEST['salutation_footer'], 'no', _SALUTATION_FOOTER, 'yes', 0, 255
);
} else {
$_SESSION['m_admin']['address']['SALUTATION_FOOTER'] = '';
}
$_SESSION['m_admin']['address']['IS_PRIVATE'] =
$_REQUEST['is_private'];
if (isset($_REQUEST['owner']) && $_REQUEST['owner'] <> '') {
if (preg_match('/\((.|\s|\d|\h|\w)+\)$/i', $_REQUEST['owner']) == 0) {
$_SESSION['error'] = _OWNER . ' ' . _WRONG_FORMAT . '.
'
. _USE_AUTOCOMPLETION;
} else {
$_SESSION['m_admin']['address']['OWNER'] = str_replace(
')', '', substr($_REQUEST['owner'],
strrpos($_REQUEST['owner'],'(')+1)
);
$_SESSION['m_admin']['address']['OWNER'] = $func->wash(
$_SESSION['m_admin']['address']['OWNER'], 'no',
_OWNER . ' ', 'yes', 0, 32
);
}
} else {
$_SESSION['m_admin']['address']['OWNER'] = '';
}
$_SESSION['m_admin']['address']['order'] = $_REQUEST['order'];
$_SESSION['m_admin']['address']['order_field'] = $_REQUEST['order_field'];
$_SESSION['m_admin']['address']['what'] = $_REQUEST['what'];
$_SESSION['m_admin']['address']['start'] = $_REQUEST['start'];
}
/**
* Return the label from an id
*
* @param int $contact_type_id
* @param string $table
*/
public function get_label_contact($contact_type_id, $table){
$db = new Database();
$stmt = $db->query('SELECT label FROM '.$table . ' WHERE id = ?',array($contact_type_id));
$res = $stmt->fetchObject();
return functions::show_string($res->label);
}
public function get_civility_contact($title){
// $core = new core_tools();
if (file_exists(
$_SESSION['config']['corepath'] . 'custom' . DIRECTORY_SEPARATOR
. $_SESSION['custom_override_id'] . DIRECTORY_SEPARATOR . 'apps'
. DIRECTORY_SEPARATOR . $_SESSION['config']['app_id']
. DIRECTORY_SEPARATOR . 'xml' . DIRECTORY_SEPARATOR
. 'entreprise.xml'
)
) {
$path = $_SESSION['config']['corepath'] . 'custom'
. DIRECTORY_SEPARATOR . $_SESSION['custom_override_id']
. DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR
. $_SESSION['config']['app_id'] . DIRECTORY_SEPARATOR . 'xml'
. DIRECTORY_SEPARATOR . 'entreprise.xml';
} else {
$path = 'apps' . DIRECTORY_SEPARATOR . $_SESSION['config']['app_id']
. DIRECTORY_SEPARATOR . 'xml' . DIRECTORY_SEPARATOR
. 'entreprise.xml';
}
$xml = simplexml_load_file($path);
// $xml = simplexml_load_file('apps'.DIRECTORY_SEPARATOR.'maarch_entreprise'.DIRECTORY_SEPARATOR.'xml'.DIRECTORY_SEPARATOR.'entreprise.xml');
if ($xml <> false) {
$result = $xml->xpath('/ROOT/titles');
foreach ($result as $key => $value) {
foreach ($value as $key2 => $value2) {
if($value2->id==$title){
$title_value=(string)$value2->label;
}
}
}
}
return functions::show_string($title_value);
}
public function type_purpose_address_del($id, $admin = true, $tablename, $mode='contact_type', $deleted_sentence, $warning_sentence, $title, $reaffect_sentence, $new_sentence, $choose_sentence, $page_return, $page_del, $name){
$nb_elements = 0;
$db = new Database();
$order = $_REQUEST['order'];
$order_field = $_REQUEST['order_field'];
$start = $_REQUEST['start'];
$what = $_REQUEST['what'];
$path = $_SESSION['config']['businessappurl']."index.php?page=".$page_return."&order=".$order."&order_field=".$order_field."&start=".$start."&what=".$what;
$path_del = $_SESSION['config']['businessappurl']."index.php?page=".$page_del."&order=".$order."&order_field=".$order_field."&start=".$start."&what=".$what;
if(!$admin)
{
if ($mode == 'contact_address'){
$path = $_SESSION['config']['businessappurl']."index.php?page=my_contact_up&dir=my_contacts&load&order=".$order."&order_field=".$order_field."&start=".$start."&what=".$what;
}
}
if(!empty($id))
{
if ($mode == 'contact_type') {
$stmt = $db->query("SELECT contact_id FROM ".$_SESSION['tablename']['contacts_v2']
. " WHERE contact_type = ?", array($id));
} else if ($mode == 'contact_purpose'){
$stmt = $db->query("SELECT id FROM ".$_SESSION['tablename']['contact_addresses']
. " WHERE contact_purpose_id = ?", array($id));
} else if ($mode == 'contact_address'){
$stmt = $db->query("SELECT address_id FROM mlb_coll_ext WHERE address_id = ?", array($id));
}
if($stmt->rowCount() > 0)$nb_elements = $nb_elements + $stmt->rowCount();
if ($mode == 'contact_address'){
$stmt = $db->query("SELECT address_id FROM contacts_res WHERE address_id = ?", array($id));
if($stmt->rowCount() > 0)$nb_elements = $nb_elements + $stmt->rowCount();
}
?>
query("DELETE FROM ".$tablename." WHERE id = ?", array($id));
if($_SESSION['history'][$page_del] == "true")
{
require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
$users = new history();
$users->add($tablename, $id,"DEL",$page_del, $title." ".strtolower(_NUM).$id."", $_SESSION['config']['databasetype']);
}
$_SESSION['error'] = $deleted_sentence;
unset($_SESSION['m_admin']);
?>
0) { ?>
query("UPDATE contacts_v2 SET enabled = ? WHERE contact_id = ?", array($mode, $userId));
$db->query("UPDATE contact_addresses SET enabled = ? WHERE contact_id = ?", array($mode, $userId));
}
function addressEnabled($addressId, $mode) {
$db = new Database();
$db->query("UPDATE contact_addresses SET enabled = ? WHERE id = ?", array($mode, $addressId));
}
}
?>