GetOne("SELECT contact_id FROM contacts WHERE id=".$delid." and fk_user_id=".$user_id); if ($contact_id) { $epp=new eppConn(); if ($epp->send_receive('contact','delete',$contact_id)) { $conn->Execute("DELETE FROM contacts WHERE id=".$delid); echo ''; } else { //print_r($epp); echo ''; } } } //lista me ta contacts tou echo ''; //ola ektos ta pros tranfer fullname='' $my_contacts=$conn->GetArray("SELECT id,ifnull(ITE,0) as ITE,ifnull(contacts.ITE,0)as ITE,CONCAT(contacts.fullName, CASE isnull(contacts.companyName) WHEN 1 THEN '' ELSE CONCAT('-',contacts.companyName) END) as contact,fullName,contact_id, count(fk_contact_id) as linked FROM contacts LEFT JOIN domains_contacts ON contacts.id=domains_contacts.fk_contact_id WHERE ifnull(fullName,'')<>'' and fk_user_id=".$user_id." GROUP BY id,fullName ORDER BY ASCII(fullName)"); if ($my_contacts) { echo ''; foreach ($my_contacts as $row_contact) { echo ''; } } else { echo ''; } ?>

'.contact_delete_success_txt.'
'.ERROR_ITE_txt.'
'.add_new_contact_txt.'
'.Contact_profile_name_txt.'		'.Contact_Role_txt.'				'.Action_txt.'
'.$row_contact['contact'].'	['.$row_contact['contact_id'].']	'; if ($row_contact['id']==$user_defaults['contactO']) echo Role_O_txt; else echo ' '; echo '	'; if ($row_contact['id']==$user_defaults['contactT']) echo Role_T_txt; else echo ' '; echo '	'; if ($row_contact['id']==$user_defaults['contactA']) echo Role_A_txt; else echo ' '; echo '	'; if ($row_contact['id']==$user_defaults['contactB']) echo Role_B_txt; else echo ' '; echo '	'.update_txt.'	'; if ($row_contact['linked']==0) { echo ''.Delete_txt.''; } else { /* $contact_domains=$conn->GetArray("SELECT distinct domain FROM domains INNER JOIN domains_contacts ON domains.id=domains_contacts.fk_domain_id WHERE fk_contact_id=".$row_contact['id']); $domainsList=''; foreach ($contact_domains as $contact_domain) { $domainsList.=$contact_domain['domain']."\n"; } echo ''.LINKED_txt.''; */ $contact_domains=$conn->GetArray("SELECT domain,fk_contact_type_id FROM domains INNER JOIN domains_contacts ON domains.id=domains_contacts.fk_domain_id WHERE fk_contact_id=".$row_contact['id']." ORDER BY domain, fk_contact_type_id"); $domainsList=''; $isOwner=0; foreach ($contact_domains as $contact_domain) { switch ($contact_domain['fk_contact_type_id']) { case 1 : $contact_type='OWNER'; $isOwner=1; break; case 2 : $contact_type='TECHNICAL'; break; case 3 : $contact_type='ADMINISTRATOR'; break; case 4 : $contact_type='BILLING'; break; } $domainsList.=$contact_domain['domain']."-".$contact_type."\n\r"; } echo ''.LINKED_txt.'	'; if ($isOwner==1 && $row_contact['ITE']=="0") { echo ''; } } echo '
'.NO_contacts_txt.'