return $ret; // semicolon-separated string } // end function cid lookup() function extr_digits($in_str) { return ereg_replace("[^0-9]", "", $in_str); } //$cid_str = (empty($_GET))? "0000000000": $_GET['phone']; // bad $cid_str = empty($_GET) ? "2125867000" : $_GET['phone']; // Hilton //$cid_str = (empty($_GET))? "4102242850": $_GET['phone']; // Giant pharmacy //$cid_str = (empty($_GET))? "4103533986": $_GET['phone']; // cell //$cid_str = (empty($_GET))? "4108498240": $_GET['phone']; //$cid_str = (empty($_GET))? "4108498721": $_GET['phone']; $lookup_str = cid_lookup(extr_digits($cid_str)); // given a phone no., returns data string $query = "INSERT INTO `{$GLOBALS['mysql_prefix']}caller_id` (`call_str`, `lookup_vals`, `status`) \n\tVALUES ( " . quote_smart(trim($cid_str)) . ", " . quote_smart(addslashes(trim($lookup_str))) . ", 0);"; $result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__); $retval = explode(";", $lookup_str); $received = format_date_time(mysql_format_date(now())); $sources = array("NA", "prior incidents", "Constituents data", "White pages"); $extra = rtrim(dirname($_SERVER['PHP_SELF']), '/\\'); $url = "http://{$_SERVER['HTTP_HOST']}:{$_SERVER['SERVER_PORT']}{$extra}/"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <HEAD><TITLE>Tickets - Caller ID Module</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"> <META HTTP-EQUIV="Expires" CONTENT="0">
$arys = ""; break; } $lhe = $pos + strlen($aryk[$i]); $rhe = strpos($data, "<", $lhe); $aryv[$i] = substr($data, $lhe, $rhe - $lhe); // substr ( string, start , length ) } // end for ($i...) // dump($aryv); if (!empty($arys)) { // 11/11/09 for ($i = 0; $i < count($aryk); $i++) { // append return string to match count $ret .= $aryv[$i] . $arys[$i]; // value + separator } // end for () unset($result); } } } // end no priors //dump($ret); return $ret; } // end function cid_lookup() $lookup_str = cid_lookup($phone); $query = "INSERT INTO `{$GLOBALS['mysql_prefix']}caller_id` (`call_str`, `lookup_vals`, `status`) VALUES ( " . quote_smart(trim($phone)) . ", " . quote_smart(trim($lookup_str)) . ", 0);"; $result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__); dump(explode(";", $lookup_str));