mydata($query); if(ss($data[password][0])!=ss($password)) { return(0); } else { return(1); } } // get employee access info function get_emp_info($u_id,$code,$cdc) { global $CDC_GROUP_ORGANIZE; $query = "select group_id, admin_level from $CDC_GROUP_ORGANIZE where employee_id = '$u_id' and brand = '$code' order by group_id "; $data = $cdc->mydata($query); return($data); } /* function: get_end_user_uid_email vars: $email,$code,$cdc use: get the internal id (uid) using the email address of a user */ function get_end_user_uid_email($email,$code,$cdc) { global $CDC; if(!$email) { echo"DWERROR: No end user email address."; exit(); } $query = "select cdc_id from $CDC where email = '".ass($email)."' and brand = '$code' "; $data = $cdc->mydata($query); if(!$data[cdc_id][0]) { echo"DWERROR: No id found for owner email, \"$email\"."; exit(); } return($data[cdc_id][0]); } /* function: get_uid_email vars: $email,$password,$code,$cdc use: get the internal id (uid) using the email address of a user */ function get_uid_email($email,$password,$code,$cdc) { global $CDC; $query = "select cdc_id from $CDC where email = '".ass($email)."' and password = '".ass($password)."' and brand = '$code' "; $data = $cdc->mydata($query); return($data[cdc_id][0]); } /* function: valid_email vars: email use: make sure an email is valid and has a real mx record */ function valid_email($email) { if (eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,4}$", $email, $check)) { if( getmxrr(substr(strstr($check[0], '@'), 1), $validate_email_temp) ) { return TRUE; } } return FALSE; } /* function: tracker vars: echos tracking messages to sto use: enable with setting $debug to yes */ function tracker($message) { global $debug; if($debug == "yes") { echo"\n\n
\n$message ;\n
\n"; // el("$message"); } } /* function: insert_company vars: $new_array,$sql use: create a company in the cdc */ function insert_company($new_array,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$code,$now,$u_id; $cdc_id = make_rand(); $query ="insert into $CDC set cdc_id = '$cdc_id', company_name = '".ass($new_array[company_name])."', website = '".ass($new_array[website])."', telephone_1 = '".ass($new_array[telephone_1])."', telephone_2 = '".ass($new_array[telephone_2])."', fax_1 = '".ass($new_array[fax_1])."', address_1_1 = '".ass($new_array[address_1_1])."', city_1 = '".ass($new_array[city_1])."', province_1 = '".ass($new_array[province_1])."', zipcode_1 = '".ass($new_array[zipcode_1])."', country_1 = '".ass($new_array[country_1])."', created_by = '$u_id', modified_by = 'cron_job', created = '".date("Y-m-d H:i:s")."', modified = '".date("Y-m-d H:i:s")."', brand = '$code' "; $sql->Insert($query); $query = "insert into $CDC_HISTORY set cdc_id = '$cdc_id', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); return($cdc_id); } function update_company($cdc_id, $new_array,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$code,$now,$u_id; $query ="update $CDC set company_name = '".ass($new_array[company_name])."', website = '".ass($new_array[website])."', telephone_1 = '".ass($new_array[telephone_1])."', telephone_2 = '".ass($new_array[telephone_2])."', fax_1 = '".ass($new_array[fax_1])."', address_1_1 = '".ass($new_array[address_1_1])."', city_1 = '".ass($new_array[city_1])."', province_1 = '".ass($new_array[province_1])."', zipcode_1 = '".ass($new_array[zipcode_1])."', country_1 = '".ass($new_array[country_1])."', modified_by = 'cron_job', modified = '".date("Y-m-d H:i:s")."' where cdc_id = '".ass($cdc_id)."' and brand = '$code' "; $sql->Update($query); $query = "insert into $CDC_HISTORY set cdc_id = '".ass($cdc_id)."', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); } /* function: insert_contact vars: $new_array,$sql use: create a contact in the cdc */ function insert_contact($new_array,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$code,$now,$u_id; $cdc_id = make_rand(); $query ="insert into $CDC set cdc_id = '$cdc_id', first_name = '".ass($new_array[first_name])."', last_name = '".ass($new_array[last_name])."', email = '".ass($new_array[email])."', telephone_1 = '".ass($new_array[telephone_1])."', title = '".ass($new_array[title])."', telephone_2 = '".ass($new_array[telephone_2])."', telephone_3 = '".ass($new_array[telephone_3])."', cell = '".ass($new_array[cell])."', fax_1 = '".ass($new_array[fax_1])."', address_1_1 = '".ass($new_array[address_1_1])."', city_1 = '".ass($new_array[city_1])."', province_1 = '".ass($new_array[province_1])."', zipcode_1 = '".ass($new_array[zipcode_1])."', country_1 = '".ass($new_array[country_1])."', department = '".ass($new_array[department])."', salutation = '".ass($new_array[salutation])."', created_by = '$u_id', modified_by = 'cron_job', created = '".date("Y-m-d H:i:s")."', modified = '".date("Y-m-d H:i:s")."', brand = '$code' "; $sql->Insert($query); $query = "insert into $CDC_HISTORY set cdc_id = '$cdc_id', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); return($cdc_id); } function update_contact($cdc_id,$new_array,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$code,$now,$u_id; $query ="update $CDC set first_name = '".ass($new_array[first_name])."', last_name = '".ass($new_array[last_name])."', email = '".ass($new_array[email])."', telephone_1 = '".ass($new_array[telephone_1])."', title = '".ass($new_array[title])."', telephone_2 = '".ass($new_array[telephone_2])."', telephone_3 = '".ass($new_array[telephone_3])."', cell = '".ass($new_array[cell])."', fax_1 = '".ass($new_array[fax_1])."', address_1_1 = '".ass($new_array[address_1_1])."', city_1 = '".ass($new_array[city_1])."', province_1 = '".ass($new_array[province_1])."', zipcode_1 = '".ass($new_array[zipcode_1])."', country_1 = '".ass($new_array[country_1])."', department = '".ass($new_array[department])."', salutation = '".ass($new_array[salutation])."', modified_by = 'cron_job', modified = '".date("Y-m-d H:i:s")."' where cdc_id = '".ass($cdc_id)."' and brand = '$code' "; $sql->Insert($query); $query = "insert into $CDC_HISTORY set cdc_id = '".ass($cdc_id)."', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); } /* function: insert_cdc vars: $new_array,$sql use: create a new profile in the cdc */ function insert_cdc($new_array,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$code,$now,$u_id; $cdc_id = make_rand(); $query ="insert into $CDC set cdc_id = '$cdc_id', email = '".ass($new_array[email])."', first_name = '".ass($new_array[first_name])."', last_name = '".ass($new_array[last_name])."', website = '".ass($new_array[website])."', ff_1 = '".ass($new_array[address])."', telephone_1 = '".ass($new_array[telephone_1])."', fax_1 = '".ass($new_array[fax_1])."', cell = '".ass($new_array[cell])."', external_id = '".ass($new_array[external_id])."', created_by = '$u_id', modified_by = '$u_id', created = '".date("Y-m-d H:i:s")."', modified = '".date("Y-m-d H:i:s")."', brand = '$code' "; $sql->Insert($query); $query = "insert into $CDC_HISTORY set cdc_id = '$cdc_id', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); return($cdc_id); } /* function: update_cdc vars: $new_array,$sql,$code,$cdc_id use: create a new profile in the cdc */ function update_cdc($new_array,$cdc_id,$code,$sql) { global $CDC_HISTORY,$CDC,$debug,$u_id; $query ="update $CDC set email = '".ass($new_array[email])."', first_name = '".ass($new_array[first_name])."', last_name = '".ass($new_array[last_name])."', website = '".ass($new_array[website])."', ff_1 = '".ass($new_array[address])."', telephone_1 = '".ass($new_array[telephone_1])."', fax_1 = '".ass($new_array[fax_1])."', cell = '".ass($new_array[cell])."', external_id = '".ass($new_array[external_id])."', modified_by = '$u_id', modified = '".date("Y-m-d H:i:s")."' where cdc_id = '".ass($cdc_id)."' and brand = '$code' "; $sql->Update($query); $query = "insert into $CDC_HISTORY set cdc_id = '".ass($cdc_id)."', time_stamp = '".date("Y-m-d H:i:s")."', employee_id = '$u_id', old_data = '".ass(wddx_serialize_value($new_array))."', brand = '$code' "; $sql->Insert($query); return($id); } /* function: insert_crm_cdc vars: $vars,$cdc_id,$sql use: create the link between the cdc and the crm */ function insert_crm_cdc($vars,$cdc_id,$code,$crm) { global $CRM_CDC,$debug,$u_id,$code; $query = "insert into $CRM_CDC set cdc_id = '".ass($cdc_id)."', first_name = '".ass($vars[first_name])."', last_name = '".ass($vars[last_name])."', type_id = '1', private = 'N', company_name = '".ass($vars[company_name])."', employee_id = '$u_id', created = '".date("Y-m-d H:i:s")."', brand = '$code' "; $crm->Insert($query); } /* function: insert_crm_cdc vars: $vars,$cdc_id,$sql use: create the link between the cdc and the crm */ function update_crm_cdc($vars,$cdc_id,$code,$crm) { global $CRM_CDC,$debug,$u_id; $query = "update $CRM_CDC set first_name = '".ass($vars[first_name])."', last_name = '".ass($vars[last_name])."', type_id = '1', private = 'N', company_name = '".ass($vars[company_name])."', employee_id = '$u_id' where cdc_id = '".ass($cdc_id)."' and brand = '$code' "; $crm->Update($query); } /* function: create_relation vars: $contact_id,$company_id,$crm use: create a relation for a cdc entry */ function create_relation($contact_id,$company_id,$crm) { global $CRM_RELATION,$debug,$u_id,$code; $relation_id = make_rand(); $query = "insert into $CRM_RELATION set relation_id = '".ass($relation_id)."', contact_id = '".ass($contact_id)."', company_id = '".ass($company_id)."', employee_id = '$u_id', brand = '$code' "; $crm->Insert($query); } /* function: validate_profile_vars vars: vars use: validate submitted vars */ function validate_profile_vars($vars) { $valid[] = 'email'; $valid[] = 'first_name'; $valid[] = 'last_name'; $valid[] = 'website'; $valid[] = 'address'; $valid[] = 'external_id'; $valid[] = 'telephone_1'; $valid[] = 'fax_1'; $valid[] = 'cell'; $keys = array_keys($vars); for($a=0;$aDelete($query); } $words[]=''; for($a=0;$aInsert($query); $words[] = trim($word[$a]); } } } } /* function: get_cdc vars: array,code,cdcdb use: get a persons/companies profile from the cdc */ function get_cdc($id,$code,$sql) { global $CDC; $query = "select * from $CDC where cdc_id = '".ass($id)."' and cdc_id != '' and brand = '$code' "; $data=$sql->mydata($query); $keys = array_keys($data); for($a=0;$a"."([^<]+|.*?)?<\/a>/"; preg_match_all(trim($preg),$html_body, $out, PREG_PATTERN_ORDER); $keys = $out[1]; $values = $out[2]; array_walk($values, 'remove_html'); for($a=0;$a