Create($crm_db,$crm_user,$crm_host2,$crm_pass); $sql = $crm; // connect SEARCH DB $crm_search = new MySQL_class; $crm_search->Create($crm_search_db,$crm_search_user,$crm_search_host2,$crm_search_pass); $cdc = new MySQL_class; $cdc->Create($cdc_db,$cdc_user,$cdc_host_2,$cdc_pass); // connect mysql $brnd = new MySQL_class; $brnd->Create($db,$user,$host2,$pass); $tmp = new MySQL_class; $tmp->Create($template_db,$template_user,$template_host_2,$template_pass); // start search class $search = new search_class; // foil hackers unset($u_type,$u_id,$session_email); // page configuration $conf = get_conf2(7); // start session start_session($php_sessid); $staging = ""; if(page_auth(3,$u_type,$cdc) == "yes") { $staging = "yes"; } unset($u_type,$u_id,$session_email); start_session($sessid); // log it app_log('donation',$PHP_SELF,$simple_search,$u_id,'search',$code,$array); // page starts echo''; echo' '; // list all the teams if(!$search_type || $show_all_teams) { $query = "select dt.name as team_name, dt.id, c.name from $DONATION_TEAM dt, $DONATION d, $CAMPAIGN c where d.campaign_id = c.id and dt.donation_id = d.id and c.brand = '$code' and c.activates_on <= '".gmdate("Y-m-d H:i:s")."' and c.disables_on >= '".gmdate("Y-m-d H:i:s")."' order by d.name "; $data = $crm->mydata($query); echo''; for($a=0;$a"; } echo"
Team NameCampaign Name
".$data[team_name][$a]."".$data[name][$a]."
"; exit(); } // search teams if($search_type=='team') { $query = "select dt.name as team_name, dt.id, c.name from $DONATION_TEAM dt, $DONATION d, $CAMPAIGN c where d.campaign_id = c.id and dt.name like '%".ass($simple_search)."%' and dt.donation_id = d.id and c.brand = '$code' and c.activates_on <= '".gmdate("Y-m-d H:i:s")."' and c.disables_on >= '".gmdate("Y-m-d H:i:s")."' order by d.name "; $data = $crm->mydata($query); echo''; for($a=0;$a"; } if(!$data[id][0]) { echo""; } echo"
Team NameCampaign Name
".$data[team_name][$a]."".$data[name][$a]."

Searched: ".strip_tags($simple_search)."

"; exit(); } // search people if($search_type=='last_name') { $query = "select first_name, last_name, dtm.id, c.name, 'team_member' type from $DONATION_TEAM dt, $DONATION_TEAM_MEMBER dtm, $CRM_CDC cc, $DONATION d, $CAMPAIGN c where d.campaign_id = c.id and dt.id = dtm.donation_team_id and dtm.contact_id = cc.cdc_id and last_name like '%".ass($simple_search)."%' and dt.donation_id = d.id and c.brand = '$code' and c.activates_on <= '".gmdate("Y-m-d H:i:s")."' and c.disables_on >= '".gmdate("Y-m-d H:i:s")."' order by cc.last_name "; $data = $crm->mydata($query); $query = "select first_name, last_name, di.id, c.name, 'solo' type from $DONATION_INDIVIDUAL di, $CRM_CDC cc, $DONATION d, $CAMPAIGN c where d.campaign_id = c.id and di.contact_id = cc.cdc_id and last_name like '%".ass($simple_search)."%' and di.donation_id = d.id and c.brand = '$code' and c.activates_on <= '".gmdate("Y-m-d H:i:s")."' and c.disables_on >= '".gmdate("Y-m-d H:i:s")."' order by cc.last_name "; $data1 = $crm->mydata($query); if(!$data[first_name][0]) { $data = $data1; } if($data1[first_name][0] && $data[first_name][0]) { $data = array_merge_recursive($data,$data1); } @array_multisort($data[last_name],SORT_ASC,SORT_STRING, $data[first_name],SORT_ASC,SORT_STRING, $data[name],SORT_ASC,SORT_STRING, $data[type],SORT_ASC,SORT_STRING, $data[id],SORT_ASC,SORT_STRING); echo''; for($a=0;$a".$data[last_name][$a].", ".$data[first_name][$a].""; if($now!=$last) { echo $now; } $last = $now; } if(!$data[id][0]) { echo""; } echo"
NameCampaign Name
".$data[name][$a]."

Searched: ".strip_tags($simple_search)."

"; exit(); } ?>