$v) //any of the variables retrieved from here can be overridden in the query string if(isset($_GET[$k])) $variables[$k] = $_GET[$k]; if("".$variables[$variable].""==="") ddie("Invalid get_mlsvar($variable), may not return '' "); return $variables[$variable]; } function mls_getquerydata() { global $mls_shortname; if ($mls_shortname == 'GLVAR') { $querydata = array ( 'extidkey' => 'sysid', 'propidkey' => 'sysid', 'statuskey' => '242', 'propclass' => '1', 'maxupdate' => '3000', //the max number of properties to check for removal 'propquery' => array ( 'Date' => "(135=SINCEDATE+)", 'BeforeDate' => "(135=BEFOREDATE-)", 'ListingStatus' => '(242=|EA,ER,AU)', 'Property Subtype' => '(2452=|SFR)', 'ListPrice' => '(144=50000+)', 'Zip' => "(10=ZIPLIST)", ), 'officekey' => '1652', 'propexid_notlike' => 'man_nv%', //skip any external ids that look like this ); if(false) { //hack to force return of only one MLS number without any other criteria for testing //http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1 //unset($querydata[propquery] ); /// unset($querydata[propquery]['Date']); $querydata[propquery][listingid] = "(163=1356761)"; } if(false) { //another hcack trying to find a property //http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1 unset($querydata[propquery] ); $querydata[propquery][price] = "(144=180000+)"; $querydata[propquery][price2] = "(144=190000-)"; } if(false) { //another hcack trying to find a property //http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1 unset($querydata[propquery] ); $querydata[propquery][price] = "(2953=1896)"; //$querydata[propquery][price2] = "(144=190000-)"; } } else if ($mls_shortname == 'NEFMLS') { $querydata = array ( 'extidkey' => 'listid', 'propidkey' => 'LIST_1', 'statuskey' => 'LIST_15', 'propclass' => 'A', 'propquery' => array ( 'Date' => "(LIST_16=SINCEDATE+)", 'BeforeDate' => "(LIST_16=BEFOREDATE-)", 'ListingStatus' => '(LIST_15=B70IQH1IDA9)', 'Zip' => "(LIST_43=ZIPLIST)", ), ); } else if ($mls_shortname == 'MAAR') { $querydata = array ( 'extidkey' => 'mls#', 'propidkey' => 'L_ListingID', 'statuskey' => 'L_Status', 'propclass' => 'RE_1', 'propquery' => array ( 'ListingStatus' => '(L_Status=|1_0)', 'Date' => "(L_ListingDate=SINCEDATE+)", 'BeforeDate' => "(L_ListingDate=BEFOREDATE-)", 'Zip' => "(L_Zip=ZIPLIST)", ), 'headerinfo' => array ( "RETS-Version" => "RETS/1.7.2", 'User-Agent' => 'RIOGenesisRETS/1.0', ), ); } else if ($mls_shortname == 'OLD_MAAR') //switched to new 4/18/2014 { $querydata = array ( 'extidkey' => 'sysid', 'propidkey' => 'sysid', 'propclass' => '2', 'statuskey' => '45', 'propquery' => array ( 'Date' => "(41=SINCEDATE+)", 'BeforeDate' => "(41=BEFOREDATE-)", 'ListingStatus' => '(45=|ACT)', 'YearBuilt' => '(102=1900+)', 'PriceRange' => '(43=1+)', 'Zip' => "(103=ZIPLIST)", ), 'headerinfo' => array ( "RETS-Version" => "RETS/1.7.2", 'User-Agent' => 'RIOGenesisRETS/1.0', ), ); } else if ($mls_shortname == 'BAKMLS') { $querydata = array ( 'extidkey' => 'listingrid', 'propidkey' => 'ListingRid', 'statuskey' => 'status', 'propclass' => 'RESI', 'propquery' => array ( 'ListingStatus' => '(Status=|A)', 'Date' => "(ListingDate=SINCEDATE+)", 'BeforeDate' => "(ListingDate=BEFOREDATE-)", 'Zip' => "(ZipCode=ZIPLIST)", ), 'headerinfo' => array ( "RETS-Version" => "RETS/1.7.2", 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'GNWR') { $querydata = array ( 'extidkey' => 'ml#', 'propidkey' => 'MLSNUM', 'statuskey' => 'status', 'propclass' => 'RES', 'usepost' => true, //'skiphours' => '23,0', //skip 11pm and 12am hours for updates 'maxupdate' => '3000', //the max number of properties to check for removal 'propquery' => array ( 'ListingStatus' => '(LISTSTATUS=|ACT)', 'Date' => '(LISTDATE=SINCEDATE+)', 'BeforeDate' => "(LISTDATE=BEFOREDATE-)", 'Zip' => "(ZIPCODE=ZIPLIST)", ), 'imagetype' => 'PROPERTY', 'imageclass' => 'Photo', 'imageidkey' => 'MLSNUM', 'imagequery' => array ( 'PropID' => '(UID=PROPIDS)', 'Date' => '(MODIFIED=SINCEDATE+)', 'BeforeDate' => "(MODIFIED=BEFOREDATE-)", ), 'imagehandler' => 'tx_imagedownload', 'imagelocation' => 1, 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', "RETS-Version" => "RETS/1.7.2", ), ); } else if ($mls_shortname == 'GAMLS-SFD') { $querydata = array ( 'extidkey' => 'reinsightkey', 'propidkey' => 'REInsightKey', 'statuskey' => 'STAT', 'propclass' => 'SFD', 'maxupdate' => '6000', 'propquery' => array ( 'ListingStatus' => '(STAT=|A,N)', 'Date' => '(RECMODDATE=SINCEDATE+)', 'BeforeDate' => "(RECMODDATE=BEFOREDATE-)", 'Zip' => '(ZIP=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'GAMLS-SFA') { $querydata = array ( 'extidkey' => 'reinsightkey', 'propidkey' => 'REInsightKey', 'statuskey' => 'STAT', 'propclass' => 'SFA', 'maxupdate' => '6000', 'propquery' => array ( 'ListingStatus' => '(MC=|A)', 'Date' => '(RECMODDATE=SINCEDATE+)', 'BeforeDate' => "(RECMODDATE=BEFOREDATE-)", 'Zip' => '(ZIP=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'SWFLAMLS') { $querydata = array ( 'extidkey' => 'matrixuniqueid', 'propidkey' => 'matrix_unique_id', 'statuskey' => 'Status', 'propclass' => 'RES', 'propquery' => array ( 'ListingStatus' => '(Status=|A)', 'Date' => '(CreatedDate=SINCEDATE+)', 'BeforeDate' => "(CreatedDate=BEFOREDATE-)", 'Zip' => '(PostalCode=ZIPLIST)', 'YearBuilt' => '(YearBuilt=1990+)', 'ResidenceType' => '(OwnershipDesc=SINFAM)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'RMLS') { $querydata = array ( 'extidkey' => 'listingid', 'propidkey' => 'ListingID', 'statuskey' => 'RetsStatus', 'propclass' => 'Residential', 'propquery' => array ( 'ListingStatus' => '(RetsStatus=|Active)', 'Date' => '(DateList=SINCEDATE+)', //'Zip' => '(ZipCode=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'GFLR') { $querydata = array ( 'extidkey' => 'sysid', 'propidkey' => 'sysid', 'statuskey' => '246', 'propclass' => '1', 'propquery' => array ( 'ListingStatus' => '(246=A)', 'County' => '(61=|BROWARD,DADE,OTHER,PALMBCH)', //the only four counties offered at the time, may want to double check to see if there are more added from tiem to tiem //'YearBuilt' => '(314=1990+)', //'BedMin' => '(25=3+)', //'BedMax' => '(25=4-)', //'PriceMin' => '(137=125000+)', //'PriceMax' => '(137=325000-)', 'Date' => '(135=SINCEDATE+)', 'Zip' => '(10=ZIPLIST)', //'BeforeDate' => "", ), 'headerinfo' => array ( 'User-Agent' => 'chWaRiS', 'User-Agent-Password' => 'fard8942', "RETS-Version" => "RETS/1.7.2", ), ); } else if ($mls_shortname == 'ARMLS') { $querydata = array ( 'extidkey' => 'listid', 'propidkey' => 'LIST_1', 'statuskey' => 'LIST_15', 'propclass' => 'A', 'propquery' => array ( 'ListingStatus' => '(LIST_15=OV61GOJ13C0)', 'Date' => '(LIST_87=SINCEDATE+)', 'BeforeDate' => '(LIST_87=BEFOREDATE-)', 'Zip' => '(LIST_43=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), 'preprocessfunc' => array ( 'staffidxmlszipcodelist' => 'mls_remapzipcodes', ), ); } else if ($mls_shortname == 'NTREIS') { $querydata = array ( 'extidkey' => 'matrixuniqueid', 'propidkey' => 'Matrix_Unique_ID', 'statuskey' => 'Status', 'propclass' => 'Listing', 'idxmlsurl' => 'http://matrixrets.ntreis.net/rets/login.ashx', 'propquery' => array ( 'ListingStatus' => '(Status=A)', 'Date' => '(MatrixModifiedDT=SINCEDATE+)', 'BeforeDate' => '(MatrixModifiedDT=BEFOREDATE-)', 'Zip' => '(PostalCode=ZIPLIST)', 'PropertyType' => '(PropertyType=RES)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'OLD_NTREIS') { $querydata = array ( 'extidkey' => 'mls#', 'propidkey' => 'MLSNUM', 'statuskey' => 'LISTSTATUS', 'propclass' => 'RES', 'propquery' => array ( 'ListingStatus' => '(LISTSTATUS=ACT)', 'Date' => '(MODIFIED=SINCEDATE+)', 'BeforeDate' => '(MODIFIED=BEFOREDATE-)', 'Zip' => '(ZIPCODE=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'DAYMLS') { $querydata = array ( 'extidkey' => 'listingid', 'propidkey' => 'ListingID', 'statuskey' => 'ListingStatus', 'propclass' => 'ResidentialProperty', 'propquery' => array ( 'ListingStatus' => '(ListingStatus=A)', 'Date' => '(ModificationTimestamp=SINCEDATE+)', 'BeforeDate' => '(ModificationTimestamp=BEFOREDATE-)', 'Zip' => '(PostalCode=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'MIBOR') { $querydata = array ( 'propclass' => 'Listing', 'statuskey' => 'A', 'propidkey' => 'matrix_unique_id', 'extidkey' => 'matrix_unique_id', 'propquery' => array ( 'ListingPrice' => '(ListPrice=1+)', 'ListingStatus' => '(Status=A)', 'PropertyType' => '(PropertyType=RES)', 'TransactionType' => '(TransType=SALE)', 'Date' => '(ListingContractDate=SINCEDATE+)', 'BeforeDate' => '(ListingContractDate=BEFOREDATE-)', 'Zip' => '(ZipCode=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'OLD_MIBOR') { $querydata = array ( 'propclass' => '2', 'statuskey' => '134', 'propidkey' => 'sysid', 'extidkey' => 'sysid', 'propquery' => array ( 'ListingPrice' => '(131=1+)', 'ListingStatus' => '(134=ACT)', 'Date' => '(123=SINCEDATE+)', 'BeforeDate' => '(123=BEFOREDATE-)', 'Zip' => '(312=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else if ($mls_shortname == 'MFRMLS') { $querydata = array ( 'propclass' => 'Listing', 'statuskey' => 'Status', 'propidkey' => 'Matrix_Unique_ID', 'extidkey' => 'matrixuniqueid', 'idxmlsurl' => 'http://rets.mfrmls.com/contact/rets/login', 'usepost' => true, 'propquery' => array ( 'ListingStatus' => '(Status=|ACT)', 'PropertyType' => '(PropertyType=|RES)', 'ListingPrice' => '(ListPrice=1+)', 'Date' => '(StatusChangeTimestamp=SINCEDATE+)', 'BeforeDate' => '(StatusChangeTimestamp=BEFOREDATE-)', 'Zip' => '(PostalCode=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS/1.0', ), ); } else if ($mls_shortname == 'OLD_MFRMLS') { $querydata = array ( 'propclass' => '4', 'statuskey' => '178', 'extidkey' => 'sysid', 'propidkey' => 'sysid', 'propquery' => array ( 'ListingPrice' => '(176=1+)', 'ListingStatus' => '(178=ACT)', 'Date' => '(108=SINCEDATE+)', 'BeforeDate' => '(108=BEFOREDATE-)', 'Zip' => '(46=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS/1.0', ), ); } else if ($mls_shortname == 'FMLS') { $querydata = array ( 'propclass' => 'RES', 'statuskey' => 'STATUS', 'extidkey' => 'sysid', 'propidkey' => 'sysid', 'propquery' => array ( 'ListingPrice' => '(LISTPRICE=1+)', 'ListingStatus' => '(STATUS=ACT)', 'Date' => '(STATUSCHANGEDATE=SINCEDATE+)', 'BeforeDate' => '(STATUSCHANGEDATE=BEFOREDATE-)', 'Zip' => '(ZIPCODE=ZIPLIST)', ), 'headerinfo' => array ( 'User-Agent' => 'RioGenesis/1.0', ), ); } else if ($mls_shortname == 'NWMLS') { $querydata = array ( 'custom_getproperties' => 'mls_getproperties_nwmls', 'custom_getimages' => 'mls_getimages_nwmls', 'custom_getoffices' => 'mls_getoffices_nwmls', 'custom_getpropertystatus' => 'mls_getpropertystatus_nwmls', 'propclass' => '', 'statuskey' => '', 'extidkey' => 'LN', 'propidkey' => 'LN', 'propquery' => array ( 'ListingStatus' => 'A', 'Date' => 'SINCEDATET00:00:00', 'BeforeDate' => 'BEFOREDATET00:00:00', 'NowDate' => 'NOWDATET00:00:00', 'Zip' => 'ZIPLIST', ), 'propfilter' => array ( 'ListingNumber' => 'LN' ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } else { $querydata = array ( 'donotrun' => true, 'propclass' => '', 'statuskey' => '', 'extidkey' => '', 'propidkey' => '', 'propquery' => array ( 'ListingStatus' => '', 'Date' => '', 'BeforeDate' => "", 'Zip' => '', ), 'headerinfo' => array ( 'User-Agent' => 'RIOGenesisRETS', ), ); } return $querydata; } function mls_mappropertydata($records) { if ($records) { $pemap = mls_getdatamap(($_REQUEST[strictmap] > 0 || $_REQUEST[showmapping] > 0)); d(pemap, $pemap); $pemap_function = $pemap[func]; unset($pemap[func]); $pemap_mfunction = $pemap[mfunc]; unset($pemap[mfunc]); if (gc_enabled()) gc_collect_cycles(); $properties = array(); d(Records, $records); if ($_REQUEST[strictmap]) $errorcountmax = min($_REQUEST[strictmap], count($records)); foreach($records as $k=>$record) { $rarr=array(); foreach($pemap as $typ=>$columns) { foreach($columns as $column=>$match) { //I want to take not of the key if it exists //even if it doesn't have any legitimate data with it if(array_key_exists($match, $record)) { $func = $pemap_function[$typ][$column][$match]; $mfunc = $pemap_mfunction[$typ][$column][$match]; if($_REQUEST[displaymappingtable]) $displaymapping[$typ][$column][$match]++; if ($_REQUEST[showmapping]) $rarr[$typ][$column][] = '['.$match.']'; elseif (function_exists($func)) $rarr[$typ][$column] = $func($record[$match]); elseif (function_exists($mfunc)) $rarr[$typ][$column] = $mfunc($record); else $rarr[$typ][$column] = $record[$match]; unset($mfunc,$func); } //find a match to $item and remove / replace the key with the selected item //if we are running strict types //and we didn't get a match on a column if (($_REQUEST[displaymappingtable]||$_REQUEST[strictmap]) && !isset($rarr[$typ][$column])) $missingfields[$typ][$column]++; } } if ($_REQUEST[strictmap] > 0) { $errorcount++; $proprecord['missing data'] = $missingfields; $proprecord['mapped data'][$errorcount]['mapped'] = $rarr; $proprecord['mapped data'][$errorcount]['data'] = $record; if ($errorcount >= $errorcountmax || $_REQUEST[showmapping]) { d('Field Data', $proprecord); d(request,$_REQUEST); ddie("strictmap"); } } unset($records[$k]); $properties[$k]=$rarr; unset($rarr); $properties[$k][record]=$record; if (gc_enabled()) gc_collect_cycles(); } } if($_REQUEST[displaymappingtable]) { $out['mapping']['mapped'] = $displaymapping; $out['mapping']['missing'] = $missingfields; } if ($_REQUEST[showmapping]) ddie('killed for showmapping argument to prevent bad data being put into database'); $out[properties] = $properties; return $out; } function mls_getproperties_nwmls($mlsdata, $querydata, $filterdata='') { $query[startdate] = $querydata[Date]; $query[enddate] = ($querydata[BeforeDate])?$querydata[BeforeDate]:$querydata[NowDate]; $query[status] = $querydata[ListingStatus]; return mls_propertyquery_nwmls($mlsdata, implode('', $query), $filterdata); } function mls_connect_nwmls($mlsdata) { global $nwmls_client; if (!$nwmls_client) { try { $queryWSDL = $mlsdata[staffidxmlsurl]; $creds = array('_login' => '', '_password' => '', 'trace' => 1); $nwmls_client = new SoapClient($queryWSDL, $creds); } catch (Exception $ex) { developer_error("NWMLS Connection error:", "An exception was thrown while attempting to connect to NWMLS: ".print_r($ex, true)); unset($nwmls_client); return false; } } return $nwmls_client; } function mls_disconnect_nwmls() { global $nwmls_client; unset($nwmls_client); } function mls_getpropertystatus_nwmls($mlsdata, $querydata, $propids) { $rval = array(); if ($propids) { if (!is_array($propids)) $propids = explode(',', $propids); $rval = array(); $filter = "LN"; foreach ($propids as $propid) { $result = mls_propertyquery_nwmls($mlsdata, "A$propid", $filter); $rval[] = $result[records]; } } return $rval; } function mls_propertyquery_nwmls($mlsdata, $querydata, $filterdata='') { if (is_array($querydata)) $querydata = implode($querydata); //d(querydata, $querydata); try { $client = mls_connect_nwmls($mlsdata); $query['v_strXmlQuery'] = ' '.$mlsdata[staffidxmlsusername].' '.$mlsdata[staffidxmlspassword].' StandardXML1_2 NWMLS RESI '.$querydata.' '.$filterdata.' '; $listingsXML = $client -> RetrieveListingData($query) -> RetrieveListingDataResult; $proparray = parsexml_array($listingsXML); if ($proparray[ResponseMessages]) developer_error("NWMLS ResponseMessages:", "An response message NWMLS: ".print_r($proparray[ResponseMessages], true)); $rval[records] = $proparray[Residential]; unset($proparray); return $rval; } catch (Exception $ex) { d('Connection Exception', $ex); return false; } } function mls_getimages_nwmls($mlsdata, $propids) { global $tmp_imagedir, $nwmls_client; d(mlsdata, $mlsdata); d(propids, $propids); if (!is_array($propids)) $propids = explode(',', $propids); $imagequeryWSDL = 'http://images.idx.nwmls.com/imageservice/imagequery.asmx?WSDL'; $creds = array('_login' => '', '_password' => '', 'trace' => 1); $client = new SoapClient($imagequeryWSDL, $creds); d(client, $client); $rval = array(); $image_limit = mls_getvariable('images_limit'); foreach ($propids as $propid) { $XMLQuery = ' '.$mlsdata[staffidxmlsusername].' '.$mlsdata[staffidxmlspassword].' '.$propid.' NWMLS:EverNet:ImageData:1.0 '; d(xmlquery, $XMLQuery); $params = array ('query' => $XMLQuery); // catching the SOAP errors so the program doesn't stop abruptly try { $fullstr = $client -> RetrieveImages($params) -> RetrieveImagesResult; ; } catch (Exception $e) { d("NWMLS soap exception", $e); } $array = parsexml_array($fullstr); if (count($array['Images']['Image']) != 0) { // check to see if it is a one pic property if ($array['Images']) foreach ( $array['Images'] as $image ) { $image_count = 0; if ($image['ImageId'] > 0) $imagearr = $array['Images']; else $imagearr = $array['Images']['Image']; foreach ($imagearr as $image) { $data = base64_decode($image['BLOB']); $imageid = $image['ImageOrder']; $filename = "image_{$propid}_{$imageid}.jpg"; $picsize = strlen($data); if (trim($image['ImageOrder']) != "" && $picsize > 0 && file_put_contents($tmp_imagedir.'/'.$filename, $data)) { $rval[$propid][$imageid] = $filename; $image_count++; } if ($image_limit <= $image_count) break; } } } } return $rval; } function mls_remapzipcodes($zipcodes) { $zipmap = mls_getzipcodemap(); if (isset($zipmap)) { $tmp_codes = (is_array($zipcodes))?$zipcodes:explode(',', $zipcodes); $mlscodes = array(); foreach ($tmp_codes as $code) $mlscodes[] = ($zipmap[$code])?$zipmap[$code]:$code; $mlscodes = implode(",", $mlscodes); } return $mlscodes; } function mls_getdatamap($showbasemap = 0) { global $mls_shortname; /** If a field is added to one of the mls map sets below * please make sure to add it to the base map as well **/ if ($showbasemap || !mls_hasshortname()) { //can add to the array structure, //but do not add mappings to this array //these are intended to help debug future mls $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertylistingagent] = ''; $pemap[property][propertyaddress] = ''; $pemap[property][propertycity] = ''; $pemap[property][propertystate] = ''; $pemap[property][propertyzip] = ''; $pemap[property][propertycounty] = ''; $pemap[ext][propertyextensionparcelapn] = ''; $pemap[ext][propertyextensionmls] = ''; $pemap[ext][propertyextensiondaysonmarket] = ''; $pemap[ext][propertyextensionstatus] = ''; $pemap[ext][propertyextensionlistdate] = ''; $pemap[ext][propertyextensionlistprice] = ''; $pemap[ext][propertyextensionsubdivision] = ''; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionbedrooms] = ''; $pemap[ext][propertyextensionbathrooms] = ''; $pemap[ext][propertyextensionsqft] = ''; $pemap[ext][propertyextensiongarage] = ''; $pemap[ext][propertyextensionyearbuilt] = ''; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionfinishedbasement] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionhoafeesforacqprops] = ''; $pemap[ext][propertyextension2012taxes] = ''; $pemap[ext][propertyextensionremarks] = ''; $pemap[ext][propertyextensionofficecode] = ''; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = ''; $pemap[office][officename] = ''; $pemap[office][officephone] = ''; $pemap[office][desigbroker] = ''; $pemap[office][desigbrokercode] = ''; $pemap[office][designatedbrokername] = ''; } if ($mls_shortname == 'GLVAR') //GLVAR: Nevada, Las Vegas { $pemap[property][propertyassignmenttype] = "shortsale"; $pemap[func][property][propertyassignmenttype]["shortsale"] = "assignmenttypeshortsalecheck"; //nv $pemap[property][propertyaddress] = "publi_2861"; $pemap[property][propertycity] = "citytwn"; $pemap[property][propertycounty] = "county"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'parcel#'; $pemap[ext][propertylistingagent] = "laname"; $pemap[ext][propertyextensionstatus] = 'stat'; $pemap[ext][propertyextensionlistdate] = "listdate"; $pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate"; $pemap[ext][propertyextensionlistprice] = "listprice"; $pemap[ext][propertyextensionyearbuilt] = 'yearblt'; $pemap[ext][propertyextensiontype] = 'proptype'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bdrs'; $pemap[ext][propertyextensionbathrooms] = 'bthstot'; $pemap[ext][propertyextensionsqft] = 'approxtotallivarea'; $pemap[ext][propertyextensiongarage] = 'garage'; $pemap[ext][propertyextensiondaysonmarket] = 'adom'; $pemap[func][ext][propertyextensiondaysonmarket]['adom'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'pvpool'; $pemap[ext][propertyextensionbasement] = "bldgdesc"; $pemap[func][ext][propertyextensionbasement]["bldgdesc"] = "mlsbasementcheck"; $pemap[ext][propertyextensionsubdivision] = "subdivision"; $pemap[ext][propertyextensionhoafeesforacqprops] = "assocfee"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["assocfee"] = "nv_importhoaannualfee"; $pemap[ext][propertyextensionofficecode] = "listofccode"; $pemap[ext][propertyextensionmls] = "ml#"; $pemap[ext][propertyextension2012taxes] = "taxes"; } //GLVAR: Nevada, Las Vegas else if ($mls_shortname == 'NEFMLS') //NEFMLS: north east florida { $pemap[property][propertyassignmenttype] = "ownerapprpublicmktg"; $pemap[func][property][propertyassignmenttype]["ownerapprpublicmktg"] = "assignmenttypeshortsalecheck2"; //fl $pemap[property][propertyaddress] = "housenbr"; $pemap[mfunc][property][propertyaddress]["housenbr"] = "get_fl_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = "state"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'parcelnbr'; $pemap[ext][propertylistingagent] = "listmbrname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'statuschan'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionyearbuilt] = 'yrbuilt'; $pemap[ext][propertyextensiontype] = 'type'; $pemap[ext][propertyextensionoccupancystatus] = 'occupancy'; $pemap[ext][propertyextensionbedrooms] = 'totalbr'; $pemap[ext][propertyextensionbathrooms] = 'totalbath'; $pemap[ext][propertyextensionsqft] = 'totalsqft'; $pemap[mfunc][ext][propertyextensiongarage]['garcarpt'] = 'get_garagetype'; $pemap[ext][propertyextensiondaysonmarket] = 'pictimestamp'; $pemap[func][ext][propertyextensiondaysonmarket]['pictimestamp'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensionremarks] = 'remark1'; $pemap[ext][propertyextensioningroundpool] = 'poolhottub'; $pemap[ext][propertyextensionsubdivision] = 'subdivisio'; $pemap[ext][propertyextensionhoafeesforacqprops] = "assessedva"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["assessedva"] = "fl_importhoaannualfee"; $pemap[ext][propertyextensionofficecode] = "listoffshort"; $pemap[ext][propertyextensionmls] = 'listingid'; $pemap[office][fulladdress] = "listoffaddy"; $pemap[office][officecode] = "listoffshort"; $pemap[office][officename] = "listofcname"; $pemap[office][officephone] = "listoffphone"; $pemap[office][desigbroker] = "listmbrshort"; $pemap[office][designatedbrokername] = "listmbrname"; } //NEFMLS: north east florida else if ($mls_shortname == 'ARMLS') { $pemap[property][propertyassignmenttype] = ""; $pemap[property][propertyaddress] = "housenbr"; //housenbr,streetdirp,streetname,streetdirs,streetsuff $pemap[mfunc][property][propertyaddress]["housenbr"] = "get_ar_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = "state"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'parcelnbr'; $pemap[ext][propertylistingagent] = "listmbrname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'timestamp'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionbasement] = 'basementyn'; $pemap[ext][propertyextensionyearbuilt] = 'yrbuilt'; $pemap[ext][propertyextensiontype] = 'booksec'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'totalbr'; $pemap[ext][propertyextensionbathrooms] = 'totalbath'; $pemap[ext][propertyextensionsqft] = 'totalsqft'; $pemap[ext][propertyextensiongarage] = 'garagespaces'; $pemap[ext][propertyextensiondaysonmarket] = 'pictimestamp'; $pemap[func][ext][propertyextensiondaysonmarket]['pictimestamp'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensionremarks] = 'remark1'; $pemap[ext][propertyextensionhoafeesforacqprops] = "hoafee"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoafee"] = "get_ar_importhoaannualfee"; $pemap[ext][propertyextensioningroundpool] = 'pool-private'; $pemap[mfunc][ext][propertyextensioningroundpool]['pool-private'] = 'get_ar_groundpool'; $pemap[ext][propertyextensionsubdivision] = ''; $pemap[ext][propertyextensionofficecode] = "listoffshort"; $pemap[ext][propertyextensionmls] = 'listingid'; $pemap[ext][propertyextension2012taxes]='taxes'; $pemap[office][fulladdress] = "listoffaddy"; $pemap[office][officecode] = "listoffshort"; $pemap[office][officename] = "listofcname"; $pemap[office][officephone] = "listoffphone"; $pemap[office][desigbroker] = "listmbrshort"; $pemap[office][designatedbrokername] = "listmbrname"; } //ARMLS: Arizon MLS else if ($mls_shortname == 'NTREIS') //NTREIS: Dallas TX MLSD { $pemap[property][propertyassignmenttype] = "propertytype"; $pemap[property][propertyaddress] = "streetnumber"; $pemap[mfunc][property][propertyaddress]["streetnumber"] = 'get_dtx_streetaddress'; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "countyorparish"; $pemap[property][propertystate] = "stateorprovince"; $pemap[property][propertyzip] = "postalcode"; $pemap[ext][propertyextensionparcelapn] = 'parcelnumber';//'uid'; $pemap[ext][propertylistingagent] = "listagentfullname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'dateavailable'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bedstotal'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; $pemap[ext][propertyextensionsqft] = 'sqfttotal'; $pemap[ext][propertyextensiongarage] = 'garagelength'; $pemap[ext][propertyextensiondaysonmarket] = 'dateavailable'; $pemap[ext][propertyextensionremarks] = 'publicremarks'; $pemap[ext][propertyextensionhoafeesforacqprops] = "associationfee"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["associationfee"] = 'get_dtx_hoafees'; $pemap[ext][propertyextensioningroundpool] = 'poolyn'; $pemap[mfunc][ext][propertyextensioningroundpool]['poolyn'] = 'get_dtx_groundpool'; $pemap[ext][propertyextensionsubdivision] = 'subdivisionname'; $pemap[ext][propertyextensionofficecode] = "listofficemlsid"; $pemap[ext][propertyextensionmls] = 'mlsnumber'; $pemap[ext][propertyextension2012taxes]=''; $pemap[office][fulladdress] = ""; $pemap[office][officecode] = "listofficemlsid"; $pemap[office][officename] = "listofficename"; $pemap[office][officephone] = ""; $pemap[office][desigbroker] = "listagentfullname"; $pemap[office][designatedbrokername] = "listagentfullname"; } //NTREIS: Dallas TX MLS else if ($mls_shortname == 'OLD_NTREIS') //NTREIS: Dallas TX MLSD { $pemap[property][propertyassignmenttype] = ""; $pemap[property][propertyaddress] = "st#"; $pemap[mfunc][property][propertyaddress]["st#"] = 'get_odtx_streetaddress'; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = "state"; $pemap[property][propertyzip] = "zipcode"; $pemap[ext][propertyextensionparcelapn] = 'parcelid';//'uid'; $pemap[ext][propertylistingagent] = "laid"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'modified'; $pemap[ext][propertyextensionlistprice] = 'listpr'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionyearbuilt] = 'yb'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'beds'; $pemap[ext][propertyextensionbathrooms] = 'totbths'; $pemap[ext][propertyextensionsqft] = 'sqft'; $pemap[ext][propertyextensiongarage] = '#gar'; $pemap[ext][propertyextensiondaysonmarket] = 'modified'; $pemap[ext][propertyextensionremarks] = 'pubrmks'; $pemap[ext][propertyextensionhoafeesforacqprops] = "hoadues"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoadues"] = 'get_dtx_importhoaannualfee'; $pemap[ext][propertyextensioningroundpool] = 'poolonprop'; $pemap[ext][propertyextensionsubdivision] = 'subdivision'; $pemap[ext][propertyextensionofficecode] = ""; $pemap[ext][propertyextensionmls] = 'mls#'; $pemap[ext][propertyextension2012taxes]=''; $pemap[office][fulladdress] = ""; $pemap[office][officecode] = "locode"; $pemap[office][officename] = "officenam2"; $pemap[office][officephone] = ""; $pemap[office][desigbroker] = "laid"; $pemap[office][designatedbrokername] = ""; } //NTREIS: Dallas TX MLS else if ($mls_shortname == 'MAAR') //MAAR: Tennessee { $pemap[property][propertyassignmenttype] = 'salestype'; $pemap[property][propertyaddress] = 'address'; //$pemap[mfunc][property][propertyaddress]['stname'] = "get_tn_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = 'state'; $pemap[property][propertyzip] = "zip5"; $pemap[ext][propertyextensionparcelapn] = 'parcelid'; $pemap[ext][propertylistingagent] = 'la1firstnm'; $pemap[mfunc][ext][propertylistingagent]['la1firstnm'] = 'get_tn_propertylistingagent'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'lstdate'; //$pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate"; $pemap[ext][propertyextensionlistprice] = "listprice"; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = 'listngtype'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bedrmsdown'; //$pemap[func][ext][propertyextensionbedrooms]['bedrooms'] = 'tn_gettotalbedrooms'; $pemap[ext][propertyextensionbathrooms] = 'fullbaths'; $pemap[ext][propertyextensionsqft] = 'aprxhtdsqf'; $pemap[ext][propertyextensiongarage] = 'prkngdsply'; $pemap[ext][propertyextensiondaysonmarket] = 'statusdetl'; $pemap[func][ext][propertyextensiondaysonmarket]['statusdetl'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'pooldescr'; $pemap[ext][propertyextensionsubdivision] = 'legalsubdi'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'anassocfee'; $pemap[ext][propertyextensionofficecode] = 'listofc1'; //$pemap[mfunc][ext][propertyextensionofficecode]["listofficecode"] = 'get_tn_officecode'; $pemap[ext][propertyextensionmls]="mls#"; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionremarks] = 'premarks'; $pemap[ext][propertyextension2012taxes]='anlcitytax'; $pemap[mfunc][ext][propertyextension2012taxes]["anlcitytax"] = 'get_tn_2012taxes'; $pemap[office][officecode] = "listofc1"; //$pemap[mfunc][office][officecode]['listofficecode'] = "get_tn_officecode"; $pemap[office][officename] = "lo1ofcname"; $pemap[office][officephone] = "la1phon1ar"; $pemap[mfunc][office][officephone]["la1phon1ar"] = 'get_tn_officephone'; $pemap[office][desigbroker] = "agent"; $pemap[office][desigbrokercode] = ""; $pemap[office][designatedbrokername] = ""; } //MAAR: Tennessee else if ($mls_shortname == 'OLD_MAAR') //OLD_MAAR: Tennessee { $pemap[property][propertyassignmenttype] = 'salestype'; $pemap[property][propertyaddress] = 'stname'; $pemap[mfunc][property][propertyaddress]['stname'] = "get_tn_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = 'state'; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'parcelid'; $pemap[ext][propertylistingagent] = "listagentname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = "listdate"; $pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate"; $pemap[ext][propertyextensionlistprice] = "listprice"; $pemap[ext][propertyextensionyearbuilt] = ''; $pemap[ext][propertyextensiontype] = 'type'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'br'; $pemap[ext][propertyextensionbathrooms] = 'totalbaths'; $pemap[ext][propertyextensionsqft] = 'sfrange'; $pemap[ext][propertyextensiongarage] = 'cvparking'; $pemap[ext][propertyextensiondaysonmarket] = 'dom'; $pemap[func][ext][propertyextensiondaysonmarket]['dom'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionsubdivision] = "subd"; $pemap[ext][propertyextensionhoafeesforacqprops] = "assocfee"; $pemap[ext][propertyextensionofficecode] = "listofficecode"; $pemap[mfunc][ext][propertyextensionofficecode]["listofficecode"] = 'get_tn_officecode'; $pemap[ext][propertyextensionmls]="mls#"; $pemap[ext][propertyextensionbasement] = "basementdim"; $pemap[ext][propertyextensionremarks] = 'remarks'; $pemap[ext][propertyextension2012taxes]="annualctytax"; //$pemap[mfunc][ext][propertyextension2012taxes]["annualctytax"] = 'get_tn2012taxes'; $pemap[office][officecode] = "listofficecode"; $pemap[mfunc][office][officecode]['listofficecode'] = "get_tn_officecode"; $pemap[office][officename] = "listofficename"; $pemap[office][officephone] = "listofficephone"; $pemap[office][desigbroker] = "listagentname"; $pemap[office][desigbrokercode] = "listingpublicid"; $pemap[office][designatedbrokername] = "listagentname"; } //OLD_MAAR: Tennessee else if ($mls_shortname == 'BAKMLS') //BAKMLS: California { $pemap[property][propertyassignmenttype] = 'disclosures'; $pemap[property][propertyaddress] = 'streetnumber'; $pemap[mfunc][property][propertyaddress]["streetnumber"] = "get_ca_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = "state"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = ''; $pemap[ext][propertylistingagent] = "listingagtfullname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = "listingdate"; $pemap[func][ext][propertyextensionlistdate]["listingdate"] = "formatlistdate"; $pemap[ext][propertyextensionlistprice] = "listingprice"; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = 'propertysubtype1'; $pemap[mfunc][ext][propertyextensiontype]['propertytype'] = 'format_propertytype'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bedrooms'; $pemap[ext][propertyextensionbathrooms] = 'bathrooms'; $pemap[ext][propertyextensionsqft] = 'squarefootage'; $pemap[ext][propertyextensiongarage] = 'parking'; $pemap[ext][propertyextensioningroundpool] = 'pooltype'; $pemap[ext][propertyextensionofficecode] = "listingofficenumber"; $pemap[mfunc][ext][propertyextensionofficecode]["listingofficenumber"] = 'get_ca_officecode'; $pemap[ext][propertyextensionmls]="listingnumber"; $pemap[ext][propertyextensionremarks] = 'marketingremark'; $pemap[office][officecode] = "listingofficenumber"; $pemap[mfunc][office][officecode]["listingofficenumber"] = 'get_ca_officecode'; $pemap[office][officename] = "listingofficename"; $pemap[office][desigbroker] = "listingagtfullname"; $pemap[office][desigbrokercode] = "listingagentmlsid"; $pemap[office][designatedbrokername] = "listingagtfullname"; } //BAKMLS: California else if ($mls_shortname == 'GNWR') //GNWR: Texas { $pemap[property][propertyassignmenttype] = 'discl'; $pemap[func][property][propertyassignmenttype]['discl'] = 'get_tx_assignmenttype'; $pemap[property][propertyaddress] = 'stname'; $pemap[mfunc][property][propertyaddress]["stname"] = "get_tx_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "county"; $pemap[property][propertystate] = "st"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'taxid'; $pemap[ext][propertylistingagent] = "t_fullname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = "lstdate"; $pemap[func][ext][propertyextensionlistdate]["lstdate"] = "formatlistdate"; $pemap[ext][propertyextensionlistprice] = "lp"; $pemap[ext][propertyextensionyearbuilt] = 'yrblt'; $pemap[ext][propertyextensiontype] = 'proptype'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'beds'; $pemap[ext][propertyextensionbathrooms] = 'fb'; $pemap[ext][propertyextensionsqft] = 'bldgsf'; $pemap[ext][propertyextensiongarage] = 'gar#'; $pemap[ext][propertyextensiondaysonmarket] = 'lstdate'; $pemap[func][ext][propertyextensiondaysonmarket]['lstdate'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'prvtpool'; $pemap[ext][propertyextensionsubdivision] = "legalsub"; $pemap[ext][propertyextensionhoafeesforacqprops] = "mntfeeamt"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["mntfeeamt"] = "tx_importhoaannualfee"; $pemap[ext][propertyextensionofficecode] = "laid"; $pemap[ext][propertyextensionmls]="ml#"; $pemap[ext][propertyextension2012taxes]="taxes"; $pemap[ext][propertyextensionremarks] = 'pubrmrks'; $pemap[office][fulladdress] = "lcaddr"; $pemap[office][officecode] = "laid"; $pemap[office][officename] = "officename"; $pemap[office][officephone] = "list_phone"; $pemap[office][desigbroker] = "t_fullname"; $pemap[office][desigbrokercode] = "laid"; $pemap[office][designatedbrokername] = "t_fullname"; } //GNWR: Texas else if ($mls_shortname == 'GAMLS-SFD' || $mls_shortname == 'GAMLS-SFA') //GAMLS: Georgia { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'str'; $pemap[mfunc][property][propertyaddress]["str"] = "get_ga_streetaddress"; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "cnty"; $pemap[func][property][propertycounty]["cnty"] = "get_ga_county"; $pemap[property][propertystate] = "state"; $pemap[property][propertyzip] = "zip"; $pemap[ext][propertyextensionparcelapn] = 'tid'; $pemap[ext][propertylistingagent] = "listagentname"; $pemap[ext][propertyextensionstatus] = 'stat'; $pemap[ext][propertyextensionlistdate] = "ld"; $pemap[ext][propertyextensionlistprice] = "lp"; $pemap[ext][propertyextensionyearbuilt] = 'yr'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = 'sho'; $pemap[ext][propertyextensionbedrooms] = 'br'; $pemap[ext][propertyextensionbathrooms] = 'baf'; $pemap[mfunc][ext][propertyextensionbathrooms]['baf'] = 'get_ga_bathroom'; $pemap[ext][propertyextensionsqft] = 'sqft_tot'; $pemap[ext][propertyextensiongarage] = 'prk'; $pemap[ext][propertyextensiondaysonmarket] = 'ld'; $pemap[func][ext][propertyextensiondaysonmarket]['ld'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = "bsmt"; $pemap[ext][propertyextensionsubdivision] = "subd"; $pemap[ext][propertyextensionhoafeesforacqprops] = ""; $pemap[ext][propertyextensionofficecode] = "lb"; $pemap[ext][propertyextensionmls]="ln"; //$pemap[ext][propertyextensionmls]="reinsightkey"; $pemap[ext][propertyextension2012taxes]="tax"; //mfunc $pemap[ext][propertyextensionremarks] = 'public_remarks'; $pemap[office][fulladdress] = "loadd1"; $pemap[mfunc][office][fulladdress]["loadd1"] = 'get_ga_officeaddress'; $pemap[office][officecode] = "lb"; $pemap[mfunc][office][officecode]["lb"] = ''; //mfunc $pemap[office][officename] = "listofficename"; $pemap[office][officephone] = "lophone"; $pemap[office][desigbroker] = "listagentname"; $pemap[office][desigbrokercode] = "lb"; $pemap[office][designatedbrokername] = "listagentname"; } //GAMLS: Georgia else if ($mls_shortname=='SWFLAMLS') //SWFLAMLS: Naples Florida { $pemap[property][propertyassignmenttype] = 'foreclosedreoyn'; $pemap[mfunc][property][propertyassignmenttype]['foreclosedreoyn'] = 'get_fln_propertyassignmenttype'; $pemap[property][propertyaddress] = 'fulladdress'; $pemap[property][propertycity] = "city"; $pemap[property][propertycounty] = "countyorparish"; $pemap[property][propertystate] = "stateorprovince"; $pemap[property][propertyzip] = "postalcode"; $pemap[ext][propertyextensionparcelapn] = 'parcelnumber'; $pemap[ext][propertylistingagent] = "listagentfullname"; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = "createddate"; $pemap[ext][propertyextensionlistprice] = "listprice"; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = 'ownershipdesc'; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bedstotal'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; $pemap[ext][propertyextensionsqft] = 'totalarea'; $pemap[ext][propertyextensiongarage] = 'garagespaces'; $pemap[ext][propertyextensiondaysonmarket] = 'dom'; $pemap[func][ext][propertyextensiondaysonmarket]['dom'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'privatepoolyn'; $pemap[ext][propertyextensionbasement] = ""; $pemap[ext][propertyextensionsubdivision] = "subcondoname"; $pemap[ext][propertyextensionhoafeesforacqprops] = "hoafee"; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoafee"] = 'get_fln_gethoafees'; $pemap[ext][propertyextensionofficecode] = "listofficemui"; $pemap[ext][propertyextensionmls]="mlsnumber"; $pemap[ext][propertyextension2012taxes]="taxes"; $pemap[ext][propertyextensionremarks] = 'propertyinformation'; $pemap[office][fulladdress] = ""; $pemap[office][officecode] = "listofficemui"; $pemap[office][officename] = "listofficename"; $pemap[office][officephone] = "listofficephone"; $pemap[office][desigbroker] = "listagentfullname"; $pemap[office][desigbrokercode] = "listagentmui"; $pemap[office][designatedbrokername] = "listagentfullname"; } //SWFLAMLS: Naples Florida else if ($mls_shortname == 'RMLS') //RMLS: Oregon { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'fullstreetaddress'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'county'; $pemap[property][propertystate] = 'state'; $pemap[property][propertyzip] = 'zipcode'; $pemap[ext][propertyextensionparcelapn] = 'taxid'; $pemap[ext][propertylistingagent] = 'listagentfullname'; $pemap[ext][propertyextensionstatus] = 'listingstatus'; $pemap[ext][propertyextensionlistdate] = 'datelist'; $pemap[ext][propertyextensionlistprice] = 'pricelist'; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'beds'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; $pemap[ext][propertyextensionsqft] = 'sqftapproximatetotal'; $pemap[ext][propertyextensiongarage] = 'garagetype'; $pemap[ext][propertyextensiondaysonmarket] = 'daysonmarket'; $pemap[func][ext][propertyextensiondaysonmarket]['daysonmarket'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = 'basementfoundation'; $pemap[ext][propertyextensionsubdivision] = 'subdivision'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_or_gethoafees'; $pemap[ext][propertyextensionofficecode] = 'listofficeid'; $pemap[ext][propertyextensionmls]='mlsnumber'; $pemap[ext][propertyextension2012taxes]='taxamount'; $pemap[ext][propertyextensionremarks] = 'remarkspublic'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'listofficeid'; $pemap[office][officename] = 'listofficename'; $pemap[office][officephone] = 'listagentphone'; $pemap[office][desigbroker] = 'listagentfullname'; $pemap[office][desigbrokercode] = 'listagentid'; $pemap[office][designatedbrokername] = 'listagentfullname'; } //RMLS: Oregon else if ($mls_shortname == 'GFLR') //GFLR: Miami Florida { $pemap[property][propertyassignmenttype] = 'reo'; $pemap[mfunc][property][propertyassignmenttype]['reo'] = 'get_flr_getpropertyassignment'; $pemap[property][propertyaddress] = 'address'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'ct'; $pemap[property][propertystate] = 'st'; $pemap[property][propertyzip] = 'zip'; $pemap[ext][propertyextensionparcelapn] = 'f#'; $pemap[ext][propertylistingagent] = 'ls'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'statuschng'; $pemap[ext][propertyextensionlistprice] = 'lp$'; $pemap[ext][propertyextensionyearbuilt] = 'yr'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = '#beds'; $pemap[ext][propertyextensionbathrooms] = '#fb'; $pemap[mfunc][ext][propertyextensionbathrooms]['#fb'] = 'get_fl_bathtotal'; $pemap[ext][propertyextensionsqft] = 'txsqft'; $pemap[ext][propertyextensiongarage] = '#gar'; $pemap[ext][propertyextensiondaysonmarket] = 'adom'; $pemap[func][ext][propertyextensiondaysonmarket]['adom'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionsubdivision] = 'sn'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'fee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['fee'] = 'get_flr_hoafees'; $pemap[ext][propertyextensionofficecode] = ''; $pemap[ext][propertyextensionmls]='ml#'; $pemap[ext][propertyextension2012taxes]='taxes$'; $pemap[ext][propertyextensionremarks] = 'rem'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = ''; $pemap[office][officename] = 'of'; $pemap[office][officephone] = 'oph'; $pemap[office][desigbroker] = 'ls'; $pemap[office][desigbrokercode] = 'lpid'; $pemap[office][designatedbrokername] = 'ls'; } //GFLR: Miami Florida else if ($mls_shortname == 'DAYMLS') //DAYMLS: Daytona Florida { $pemap[property][propertyassignmenttype] = 'listingtype'; $pemap[property][propertyaddress] = 'streetname'; $pemap[mfunc][property][propertyaddress]['streetname'] = 'get_dfl_getstreetaddress'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'county'; $pemap[property][propertystate] = 'stateorprovince'; $pemap[property][propertyzip] = 'postalcode'; $pemap[ext][propertyextensionparcelapn] = 'parcelnumber'; $pemap[ext][propertylistingagent] = ''; $pemap[ext][propertyextensionstatus] = 'listingstatus'; $pemap[ext][propertyextensionlistdate] = 'modificationtimestamp'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = 'showing'; $pemap[ext][propertyextensionbedrooms] = 'bedrooms'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; $pemap[ext][propertyextensionsqft] = 'sqfttotal'; $pemap[ext][propertyextensiongarage] = 'parking'; $pemap[ext][propertyextensiondaysonmarket] = 'modificationtimestamp'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionsubdivision] = 'subdivision'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'maintexpenses'; $pemap[ext][propertyextensionofficecode] = ''; $pemap[ext][propertyextensionmls]='listingid'; $pemap[ext][propertyextension2012taxes]=''; $pemap[ext][propertyextensionremarks] = 'publicremarks'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = ''; $pemap[office][officename] = ''; $pemap[office][officephone] = ''; $pemap[office][desigbroker] = ''; $pemap[office][desigbrokercode] = 'listingagentuid'; $pemap[office][designatedbrokername] = 'listingofficeuid'; } //DAYMLS: Daytona Florida else if ($mls_shortname == 'MIBOR') //MIBOR: Indiana MLS { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'streetname'; $pemap[mfunc][property][propertyaddress]['streetname'] = 'get_ind_address'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'countyorparish'; $pemap[property][propertystate] = 'stateorprovince'; $pemap[property][propertyzip] = 'zipcode'; $pemap[ext][propertyextensionparcelapn] = '';//'taxid'; $pemap[ext][propertylistingagent] = 'colistagentfullname'; $pemap[ext][propertyextensionstatus] = 'propertyextensionstatus'; $pemap[ext][propertyextensionlistdate] = 'dateavailable'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'bedstotal'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; $pemap[ext][propertyextensionsqft] = 'sqfttotal'; $pemap[ext][propertyextensiongarage] = 'garage'; //$pemap[mfunc][ext][propertyextensiongarage]['garde_1309'] = 'get_ind_garage'; $pemap[ext][propertyextensiondaysonmarket] = ''; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = 'basement'; //$pemap[mfunc][ext][propertyextensionbasement]['sfoptamt'] = 'get_ind_basement';//'sqftbasement'; $pemap[ext][propertyextensionfinishedbasement] = 'basementdescription'; //$pemap[mfunc][ext][propertyextensionbasement]['%optlvlfin'] = 'get_ind_basementfinished'; $pemap[ext][propertyextensionsubdivision] = 'subdivision'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'mandatoryfee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['mandatoryfee'] = 'get_ind_hoafees'; $pemap[ext][propertyextensionofficecode] = 'colistofficemlsid'; $pemap[ext][propertyextensionmls]='mlsnumber'; $pemap[ext][propertyextension2012taxes]=''; $pemap[ext][propertyextensionremarks] = 'agentremarks'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'colistofficemlsid'; $pemap[office][officename] = 'colistofficename'; $pemap[office][officephone] = 'colistagentdirectwor'; $pemap[office][desigbroker] = 'colistagentfullname'; $pemap[office][desigbrokercode] = 'colistagentmlsid'; $pemap[office][designatedbrokername] = 'colistagentfullname'; } //MIBOR: Indiana MLS else if ($mls_shortname == 'OLD_MIBOR') //MIBOR: Indiana MLS { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'address'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'countyname'; $pemap[property][propertystate] = 'state'; $pemap[property][propertyzip] = 'zip'; $pemap[ext][propertyextensionparcelapn] = 'cotaxid';//'taxid'; $pemap[ext][propertylistingagent] = 'lagtname'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'lstdate'; $pemap[ext][propertyextensionlistprice] = 'lp'; $pemap[ext][propertyextensionyearbuilt] = 'yrblt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = 'physocc'; $pemap[ext][propertyextensionbedrooms] = '#bdrms'; $pemap[ext][propertyextensionbathrooms] = 'bthareas'; $pemap[ext][propertyextensionsqft] = 'totsf';//'mnsf'; $pemap[ext][propertyextensiongarage] = 'garde_1309'; $pemap[mfunc][ext][propertyextensiongarage]['garde_1309'] = 'get_ind_garage'; $pemap[ext][propertyextensiondaysonmarket] = 'cumulativedom';//'dom'; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = 'sfoptamt';//'sqftbasement'; $pemap[mfunc][ext][propertyextensionbasement]['sfoptamt'] = 'get_ind_basement';//'sqftbasement'; $pemap[ext][propertyextensionfinishedbasement] = '%optlvlfin';//previously unmapped $pemap[mfunc][ext][propertyextensionbasement]['%optlvlfin'] = 'get_ind_basementfinished'; $pemap[ext][propertyextensionsubdivision] = 'subdiv'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'mandfee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['mandfee'] = 'get_ind_hoafees'; $pemap[ext][propertyextensionofficecode] = 'loffice'; $pemap[ext][propertyextensionmls]='l#'; $pemap[ext][propertyextension2012taxes]='semitax'; $pemap[ext][propertyextensionremarks] = 'remarks'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'loffice'; $pemap[office][officename] = ''; $pemap[office][officephone] = 'lagtph#'; $pemap[office][desigbroker] = 'lagtname'; $pemap[office][desigbrokercode] = 'lagt'; $pemap[office][designatedbrokername] = 'lagtname'; } //MIBOR: Indiana MLS else if ($mls_shortname == 'MFRMLS') //MFRMLS: Florida MLS { $pemap[property][propertyassignmenttype] = 'specialsaleprovision'; $pemap[property][propertyaddress] = 'address'; $pemap[mfunc][property][propertyaddress]['address'] = 'get_orl_streetaddress'; $pemap[property][propertycity] = 'streetcity'; $pemap[property][propertystate] = 'stateorprovince'; $pemap[property][propertyzip] = 'postalcode'; $pemap[property][propertycounty] = 'countyorparish'; $pemap[ext][propertylistingagent] = 'listagentfullname'; $pemap[ext][propertyextensionparcelapn] = 'parcelnumber'; $pemap[ext][propertyextensionmls] = 'mlsnumber'; $pemap[ext][propertyextensiondaysonmarket] = 'cdom'; $pemap[func][ext][propertyextensiondaysonmarket]['dcdomom'] = 'get_datefromnumberofdays'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = ''; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionsubdivision] = 'legalsubdivisionname'; $pemap[ext][propertyextensiontype] = 'propertytype'; $pemap[ext][propertyextensionbedrooms] = 'bedstotal'; $pemap[ext][propertyextensionbathrooms] = 'bathstotal'; //$pemap[mfunc][ext][propertyextensionbathrooms]['fullbaths'] = 'get_orl_bathrooms'; $pemap[ext][propertyextensionsqft] = 'sqfttotal'; $pemap[ext][propertyextensiongarage] = 'garagecarport'; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionfinishedbasement] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_orl_hoafees'; $pemap[ext][propertyextension2012taxes] = 'taxes'; $pemap[ext][propertyextensionremarks] = 'publicremarksnew'; $pemap[ext][propertyextensionofficecode] = 'listofficemlsid'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'listofficemlsid'; $pemap[office][officename] = 'listofficename'; $pemap[office][officephone] = 'listofficephone'; $pemap[office][desigbroker] = 'listagentfullname'; $pemap[office][desigbrokercode] = 'listagentmlsid'; $pemap[office][designatedbrokername] = 'listagentfullname'; } //MFRMLS: Florida MLS else if ($mls_shortname == 'OLD_MFRMLS') //MFRMLS: Florida MLS { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'address'; $pemap[property][propertycity] = 'city'; $pemap[property][propertystate] = 'stateid'; $pemap[property][propertyzip] = 'zipcode'; $pemap[property][propertycounty] = 'county'; $pemap[ext][propertylistingagent] = 'agentname'; $pemap[ext][propertyextensionparcelapn] = 'taxid'; $pemap[ext][propertyextensionmls] = 'mls#'; $pemap[ext][propertyextensiondaysonmarket] = 'cdom'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'listingdate'; $pemap[ext][propertyextensionlistprice] = 'listprice'; $pemap[ext][propertyextensionsubdivision] = 'legalsubdivisionname'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionbedrooms] = 'beds'; $pemap[ext][propertyextensionbathrooms] = 'fullbaths'; $pemap[mfunc][ext][propertyextensionbathrooms]['fullbaths'] = 'get_orl_bathrooms'; $pemap[ext][propertyextensionsqft] = 'totalbldgsf'; $pemap[ext][propertyextensiongarage] = 'garagecarport'; $pemap[ext][propertyextensionyearbuilt] = 'yearbuilt'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionfinishedbasement] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_orl_hoafees'; $pemap[ext][propertyextension2012taxes] = 'taxes'; $pemap[ext][propertyextensionremarks] = 'publicremarksxp'; $pemap[ext][propertyextensionofficecode] = 'officeid#'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'officeid#'; $pemap[office][officename] = 'officename'; $pemap[office][officephone] = ''; $pemap[office][desigbroker] = 'agentname'; $pemap[office][desigbrokercode] = 'agentid'; $pemap[office][designatedbrokername] = 'agentname'; } //MFRMLS: Florida MLS else if ($mls_shortname == 'FMLS') //FMLS: Georgia MLS { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = 'address'; $pemap[property][propertycity] = 'city'; $pemap[property][propertycounty] = 'county'; $pemap[property][propertystate] = 'state'; $pemap[property][propertyzip] = 'zip'; $pemap[ext][propertyextensionparcelapn] = ''; $pemap[ext][propertylistingagent] = 'listagentname'; $pemap[ext][propertyextensionstatus] = 'status'; $pemap[ext][propertyextensionlistdate] = 'modified'; $pemap[ext][propertyextensionlistprice] = 'lp'; $pemap[ext][propertyextensionyearbuilt] = 'yrblt'; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = 'totbeds'; $pemap[ext][propertyextensionbathrooms] = 'totfb'; $pemap[mfunc][ext][propertyextensionbathrooms]['totfb'] = 'get_fga_bathrooms'; $pemap[ext][propertyextensionsqft] = 'squarefootage'; $pemap[ext][propertyextensiongarage] = ''; $pemap[ext][propertyextensiondaysonmarket] = 'modified'; $pemap[ext][propertyextensioningroundpool] = 'pool'; $pemap[ext][propertyextensionbasement] = 'basementdesc'; $pemap[mfunc][ext][propertyextensionbasement]['basementdesc'] = 'get_fga_basement'; $pemap[ext][propertyextensionsubdivision] = 'subdcomplex'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'asscfee'; $pemap[ext][propertyextensionofficecode] = 'listingofficecode'; $pemap[ext][propertyextensionmls]='fmls#'; $pemap[ext][propertyextension2012taxes]='taxes'; $pemap[ext][propertyextensionremarks] = 'publicremarks-consumerview'; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = 'listingofficecode'; $pemap[office][officename] = 'listofficename'; $pemap[office][officephone] = 'listofficephone'; $pemap[office][desigbroker] = 'listagentname'; $pemap[office][desigbrokercode] = 'listagentid'; $pemap[office][designatedbrokername] = 'listagentname'; } //FMLS: Georgia MLS else if ($mls_shortname == 'NWMLS') { $pemap[property][propertyassignmenttype] = 'BREO'; $pemap[func][property][propertyassignmenttype]['BREO'] = 'get_wa_assignmenttype'; $pemap[property][propertylistingagent] = ''; $pemap[property][propertyaddress] = 'HSN'; $pemap[mfunc][property][propertyaddress]['HSN'] = 'get_wa_propertyaddress'; $pemap[property][propertycity] = 'CIT'; $pemap[property][propertystate] = 'STA'; $pemap[property][propertyzip] = 'ZIP'; $pemap[property][propertycounty] = 'COU'; $pemap[ext][propertyextensionparcelapn] = 'TAX'; $pemap[ext][propertyextensionmls] = 'LN'; $pemap[ext][propertyextensiondaysonmarket] = 'CDOM'; $pemap[ext][propertyextensionstatus] = 'ST'; $pemap[ext][propertyextensionlistdate] = 'LD'; $pemap[ext][propertyextensionlistprice] = 'LP'; $pemap[ext][propertyextensionsubdivision] = 'DSR'; $pemap[ext][propertyextensiontype] = 'PTYP'; $pemap[ext][propertyextensionbedrooms] = 'BR'; $pemap[ext][propertyextensionbathrooms] = 'BTH'; $pemap[ext][propertyextensionsqft] = 'ASF'; $pemap[ext][propertyextensiongarage] = 'GAR'; $pemap[ext][propertyextensionyearbuilt] = 'YBT'; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = 'VEW'; //place holder to just map a N back to the DB $pemap[func][ext][propertyextensionbasement]['VEW'] = 'get_wa_basement'; //place holder to just map a N back to the DB $pemap[ext][propertyextensionfinishedbasement] = 'VEW'; $pemap[func][ext][propertyextensionfinishedbasement]['VEW'] = 'get_wa_basement'; //place holder to just map a N back to the DB $pemap[ext][propertyextensionoccupancystatus] = 'VEW'; $pemap[func][ext][propertyextensionoccupancystatus]['VEW'] = 'get_wa_occupancy'; $pemap[ext][propertyextensionhoafeesforacqprops] = 'HOD'; $pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['HOD'] = 'get_wa_hoafees'; $pemap[ext][propertyextension2012taxes] = 'TX'; $pemap[ext][propertyextensionremarks] = 'MR'; $pemap[ext][propertyextensionofficecode] = ''; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = ''; $pemap[office][officename] = ''; $pemap[office][officephone] = ''; $pemap[office][desigbroker] = ''; $pemap[office][desigbrokercode] = ''; $pemap[office][designatedbrokername] = ''; } else if ($mls_shortname) { $pemap[property][propertyassignmenttype] = ''; $pemap[property][propertyaddress] = ''; $pemap[property][propertycity] = ''; $pemap[property][propertycounty] = ''; $pemap[property][propertystate] = ''; $pemap[property][propertyzip] = ''; $pemap[ext][propertyextensionparcelapn] = ''; $pemap[ext][propertylistingagent] = ''; $pemap[ext][propertyextensionstatus] = ''; $pemap[ext][propertyextensionlistdate] = ''; $pemap[ext][propertyextensionlistprice] = ''; $pemap[ext][propertyextensionyearbuilt] = ''; $pemap[ext][propertyextensiontype] = ''; $pemap[ext][propertyextensionoccupancystatus] = ''; $pemap[ext][propertyextensionbedrooms] = ''; $pemap[ext][propertyextensionbathrooms] = ''; $pemap[ext][propertyextensionsqft] = ''; $pemap[ext][propertyextensiongarage] = ''; $pemap[ext][propertyextensiondaysonmarket] = ''; $pemap[ext][propertyextensioningroundpool] = ''; $pemap[ext][propertyextensionbasement] = ''; $pemap[ext][propertyextensionsubdivision] = ''; $pemap[ext][propertyextensionhoafeesforacqprops] = ''; $pemap[ext][propertyextensionofficecode] = ''; $pemap[ext][propertyextensionmls]=''; $pemap[ext][propertyextension2012taxes]=''; $pemap[ext][propertyextensionremarks] = ''; $pemap[office][fulladdress] = ''; $pemap[office][officecode] = ''; $pemap[office][officename] = ''; $pemap[office][officephone] = ''; $pemap[office][desigbroker] = ''; $pemap[office][desigbrokercode] = ''; $pemap[office][designatedbrokername] = ''; } return $pemap; } function mls_getimagehandler() { $querydata = mls_getquerydata(); $querydata['imagehandler'] = trim($querydata['imagehandler']); return ($querydata['imagehandler'] != '')?$querydata['imagehandler']:false; } function mls_downloadimage($fromurl, $todir) { $ch = curl_init($fromurl); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1); $rawdata=curl_exec($ch); curl_close($ch); if(file_exists($todir)){ unlink($todir); } $fp = fopen($todir,'x'); $r = fwrite($fp, $rawdata); fclose($fp); return $r; } /* mapping function area - start */ function formatlistdate($date) { return date("m/d/Y", strtotime($date)); } function mlsbasementcheck($val) { if(strstr($val,base)) return "Y"; return "N"; } function assignmenttypeshortsalecheck($val) { if(strstr($val,'Y'))// check to see if it has a 'y' for yes, if so, then this is a Short Sale, otherwise it is a REO return "SHORT SALE"; return "REO"; } function assignmenttypeshortsalecheck2($val) { //d(shortsale,$val); if(stristr($val,'Short Sale'))// check to see if it has a 'Short Sale', if so, then this is a Short Sale, otherwise it is a REO return "SHORT SALE"; return "REO"; } function nv_importhoaannualfee($val) { return formathoaannualfee($val[assocfee], $val[assocfeepaymenttype]); } function get_ar_importhoaannualfee($val) { //hoafee,hoapaid(freq),hoa2fee,hoa2paid(freq) return formathoaannualfee($val['hoafee'], $val['hoapaid(freq)'])+formathoaannualfee($val['hoa2fee'], $val['hoa2paid(freq)']); } function get_ar_groundpool($val) { if (stristr($val['pool-private'],'pool - private')) return 'Y'; else if (stristr($val['pool-private'],'no pool')) return 'N'; } function fl_importhoaannualfee($val) { return formathoaannualfee($val[assessedva], $val[permbookms]); } function tn_gettotalbedrooms($val) { return $val[fullbaths]+($val[halfbaths]*(0.5)); } function tx_importhoaannualfee($val) { return formathoaannualfee($val[mntfeeamt], $val[maintenancefeepaymentschedule]); } function formathoaannualfee($fee, $type) { $basefee = db_number($fee); switch (trim(strtolower($type))){ case "monthly payment": case "monthly": case "month": case "mo": return ($basefee*12); case "quarterly payment": case "quarterly": case "quart": case 'qtr': return ($basefee*4); case "semi-annual payment": case "semi annually": case "semiannual": case "semia": case '6mo': return ($basefee*2); default: return $basefee; } } function get_tn_streetaddress($record) { $address = array(); $address[] = $record['st#']; $address[] = $record[streetdir]; $address[] = $record[postdir]; $address[] = $record[stname]; $address[] = $record[stsuffix]; return combine_arraystrings($address); } function get_ca_streetaddress($record) { $address = array(); $address[] = $record[streetnumber]; $address[] = $record[streetnumbermodifier]; $address[] = $record[streetdirection]; $address[] = $record[streetpostdirection]; $address[] = $record[streetname]; $address[] = $record[streetsuffix]; return combine_arraystrings($address); } function get_ar_streetaddress($record) { $address = array(); $address[] = $record[housenbr]; $address[] = $record[streetdirp]; $address[] = $record[streetname]; $address[] = $record[streetdirs]; $address[] = $record[streetsuff]; return combine_arraystrings($address); } function get_fl_streetaddress($record) { $address = array(); $address[] = $record[housenbr]; $address[] = $record[streetdirp]; $address[] = $record[streetname]; $address[] = $record[streetdirs]; $address[] = $record[streetsuff]; return combine_arraystrings($address); } function get_tx_assignmenttype($record) { if(stristr($record, 'foreclosure')) return 'foreclosure'; elseif(stristr($record, 'shortsale') || stristr($record, 'short sale')) return 'short sale'; return ''; } function get_dtx_importhoaannualfee($record) { return formathoaannualfee($record[hoadues], $record[hoafreq]); } function get_wa_propertyaddress($record) { $address = array(); $address[] = $record['HSN']; $address[] = $record['DRP']; $address[] = $record['STR']; $address[] = $record['SSUF']; $address[] = $record['DRS']; return combine_arraystrings($address); } function get_wa_hoafees($record) { return formathoaannualfee($record[HOD], 'monthly'); } function get_wa_basement($record) { return 'N'; } function get_wa_occupancy($record) { return 'Vacant'; } function get_wa_assignmenttype($record) { if ($record[BREO] == 'Y') return 'REO'; else if ($record[BREO] == 'N') return 'Equity Sale'; return $record[BREO]; } function get_dtx_streetaddress($record) { $address = array(); $address[] = $record['streetnumber']; $address[] = $record['streetdirprefix']; $address[] = $record['streetdirsuffix']; $address[] = $record['streetname']; $address[] = $record['streetsuffix']; return combine_arraystrings($address); } function get_dtx_groundpool($record) { return (trim($record[poolyn]) == 1)?'Y':'N'; } function get_dtx_hoafees($record) { return formathoaannualfee($record[associationfee], $record[associationfeefrequenc]); } function get_odtx_streetaddress($record) { $address = array(); $address[] = $record['st#']; $address[] = $record['strdir']; $address[] = $record['strdirsuffix']; $address[] = $record['stname']; $address[] = $record['sttype']; return combine_arraystrings($address); } function get_tx_streetaddress($record) { $address = array(); $address[] = $record[stnum]; $address[] = $record[stdir]; $address[] = $record[stname]; return combine_arraystrings($address); } function get_ga_streetaddress($record) { $address = array(); $address[] = $record[stn]; $address[] = $record[str]; return combine_arraystrings($address); } function get_ga_county($record) { if (trim($record) == 'De Kalb') return 'DeKalb'; return $record; } function get_ga_officeaddress($record) { $address = array(); $address[] = $record[loadd1]; $address[] = $record[loadd2]; $address[] = $record[locity]; $address[] = $record[lostate]; $address[] = $record[lozip]; return combine_arraystrings($address); } function get_garagetype($record) { $garage = array(); $garage[] = $record[attdet]; $garage[] = $record[garcarpt]; return combine_arraystrings($garage); } function combine_arraystrings($arrstr, $delim = ' ') { foreach ($arrstr as $key => $val) if (!$val) unset($arrstr[$key]); return implode($delim, $arrstr); } function format_propertytype($record) { return $record[propertytype].' - '.$record[propertysubtype1]; } function get_tn_officecode($record) { return $record[listofficecode].'-'.$record[listingpublicid]; } function get_tn_officephone($record) { return $record[la1phon1ar].$record[la1phn1nbr]; } function get_tn_2012taxes($record) { return db_number($record[anlcitytax])+db_number($record[annlcotax]); } function get_tn_propertylistingagent($record) { return $record[la1firstnm]." ".$record[la1lastnam]; } function get_ca_officecode($record) { return $record[listingofficenumber].'-'.$record[listingagentmlsid]; } function get_daysonmarket($record) { $nowtime = strtotime(date('Y-m-d')); $thentime = strtotime(get_daysonmarketdate($record)); $datediff = ceil(abs($nowtime - $thentime) / 86400); return $datediff; } function get_fln_propertyassignmenttype($record) { if ($record[foreclosedreoyn]) return 'REO'; return ($record[potentialshortsaleyn])?"Short Sale":""; } function get_fln_gethoafees($record) { return formathoaannualfee($record[hoafee], $record[hoafeefreq])+formathoaannualfee($record[masterhoafee], $record[masterhoafeefreq]); } function get_or_gethoafees($record) { return formathoaannualfee($record[hoafee], $record[hoapaymentfreq])+formathoaannualfee($record[hoafee2], $record[hoapaymentfreq2]); } function get_daysonmarketdate($record) { if ($record) { $record = explode('T', $record); $thentime = $record[0]; } else $thentime = date('Y-m-d'); return $thentime; } function get_fga_basement($record) { return (trim($record['basementdesc']) != '')?'Y':'N'; } function get_fga_bathrooms($record) { return db_number($record['totfb'])+(.5*$record['tothb']); } function get_ga_bathrooms($record) { return (1*$record['baf'])+(.5*$record['bah']); } function tx_imagedownload($image) { global $tmp_imagedir; $fromurl = $image['Location']; $propertyid = $image['Content-ID']; $imageid = $image['Object-ID']; $imagename = "image_{$propertyid}_{$imageid}.jpg"; $todir = "{$tmp_imagedir}/{$imagename}"; if (mls_downloadimage($fromurl, $todir)) $retval[$propertyid][$imageid] = $imagename; return ($retval)?$retval:false; } function get_fl_bathtotal($records) { return $records['#fb']+($records['#hb']*.5); } function get_flr_hoafees($records) { if (strtolower($records['toa']) == 'homeowners') return formathoaannualfee($records['fee'], $records['feepd']); return; } function get_ind_hoafees($records) { return formathoaannualfee($records['mandfee'], $records['mndfeepd']); } function get_ind_address($records) { $address = array(); $address[] = $records[streetnumber]; $address[] = $records[streetdirprefix]; $address[] = $records[streetname]; $address[] = $records[streetdirsuffix]; $address[] = $records[streetsuffix]; return combine_arraystrings($address); } function get_orl_streetaddress($records) { if ($address = $records[address]) return $address; $address = array(); $address[] = $records[streetnumber]; $address[] = $records[streetdirprefix]; $address[] = $records[streetname]; $address[] = $records[streetdirsuffix]; $address[] = $records[streetsuffix]; return combine_arraystrings($address); } function get_orl_hoafees($records) { return formathoaannualfee($records['hoafee'], $records['hoapaymentschedule']); } function get_orl_bathrooms($records) { return db_number($records['fullbaths'])+ (.5*db_number($records['halfbaths'])); } function get_ind_basement($records) { return (trim($records['sfoptamt']) != '')?'Y':'N'; } function get_ind_garage($records) { //some of the values are comma separated, I am ending //up using the first no zero value I get, zero otherwise foreach (explode(',', $records['garde_1309']) as $type) { switch (trim($type)) { case "1CarAttach": case "1CarDetach": $rval = '1'; break; case "2CarAttach": case "2CarDetach": $rval = '2'; break; case "3CarAttach": case "3CarDetach": $rval = '3'; break; case "4+CarAttch": case "4+CarDet": case "MultipleGarages": $rval = '4+'; break; //left the ones below so it could be //seen which were getting skipped case "1CarBltIn": case "1CarCarprt": case "2CarBltIn": case "2CarCarprt": case "3CarBltIn": case "3CarCarprt": case "4+CarBltIn": case "None": case "Other": case "TANDEM": default: } //d("HERE $type ".++$cnt." $rval"); if (trim($rval) != '') return $rval; } return '0'; } function get_ind_basementfinished($records) { return (db_number($records['%optlvlfin']) > 0)?'Y':'N'; } function get_flr_getpropertyassignment($records) { if (strtolower($record[reo]) == 'y') return 'REO'; return (strtolower($record[ssl]) == 'y')?"Short Sale":""; } function get_dfl_getstreetaddress($record) { $address = array(); $address[] = $record[streetnumber]; $address[] = $record[streetdirectionsuffix]; $address[] = $record[streetname]; return combine_arraystrings($address); } /* mapping function area - end */ function mls_getzipcodemap() { global $mls_shortname; if ($mls_shortname == 'ARMLS') { $zipmap['86442'] = 'OW54TF1GIGR'; $zipmap['85019'] = 'OW542DCL8WT'; $zipmap['85018'] = 'OW542DCK6YU'; $zipmap['85017'] = 'OW542DCJ4FX'; $zipmap['85016'] = 'OW542DCI0DK'; $zipmap['85015'] = 'OW542DCGSKI'; $zipmap['85014'] = 'OW542DCFSF5'; $zipmap['85013'] = 'OW542DCENCK'; $zipmap['85012'] = 'OW542DCDIN9'; $zipmap['85011'] = 'OW54KGOSL9U'; $zipmap['85010'] = 'OW54KGMYG1H'; $zipmap['85009'] = 'OW542DCCEI3'; $zipmap['85008'] = 'OW542DCB7WX'; $zipmap['85007'] = 'OW542DCA66W'; $zipmap['85006'] = 'OW542DC8URY'; $zipmap['85005'] = 'OW54KGL08TA'; $zipmap['85004'] = 'OW542DC7OT9'; $zipmap['85003'] = 'OW542DC6LJJ'; $zipmap['85002'] = 'OW54KGJ5CFF'; $zipmap['85001'] = 'OW54KGHB432'; $zipmap['85000'] = 'OW542DC5KCU'; $zipmap['84351'] = 'OW542DC4G7A'; $zipmap['84248'] = 'OW542DC38KI'; $zipmap['84243'] = 'OW542DC25RE'; $zipmap['84242'] = 'OW542DC10GM'; $zipmap['83935'] = 'OW542DBZZBB'; $zipmap['83574'] = 'OW542DBYYAN'; $zipmap['83550'] = 'OW542DBXVE2'; $zipmap['83293'] = 'OW542DBWORS'; $zipmap['82521'] = 'OW542DBVGSO'; $zipmap['82326'] = 'OW542DBUISP'; $zipmap['82014'] = 'OW542DBTAA1'; $zipmap['78746'] = 'OW542DBS9J4'; $zipmap['78735'] = 'OW542DBR6MV'; $zipmap['58296'] = 'OW542DBNYZK'; $zipmap['58202'] = 'OW542DBMT67'; $zipmap['37320'] = 'OW542DBLOWF'; $zipmap['35035'] = 'OW542DBKM90'; $zipmap['33196'] = 'OW542DBJKTZ'; $zipmap['33176'] = 'OW542DBJ3GX'; $zipmap['33033'] = 'OW542DBHX8E'; $zipmap['29212'] = 'OW542DBGVL0'; $zipmap['25705'] = 'OW542DBFSU1'; $zipmap['15351'] = 'OW542DBEODJ'; $zipmap['3000'] = 'OW542DBDJ82'; //as defined by ARMLS $zipmap['0'] = 'OW542DBBRCX'; //as defined by ARMLS $zipmap['85068'] = 'OW54KJPG2M1'; $zipmap['85067'] = 'OW54KJL9Z8L'; $zipmap['85066'] = 'OW54KITCPA2'; $zipmap['85065'] = 'OW54KILBV4Q'; $zipmap['85064'] = 'OW54KIGIM41'; $zipmap['85063'] = 'OW54KIASVGI'; $zipmap['85062'] = 'OW54KI7KJED'; $zipmap['85061'] = 'OW542DDH7P1'; $zipmap['85060'] = 'OW54KI4KMRX'; $zipmap['85057'] = 'OW542DDG7W4'; $zipmap['85056'] = 'OW542DDF8Z6'; $zipmap['85055'] = 'OW54KI228JT'; $zipmap['85054'] = 'OW542DDE59T'; $zipmap['85053'] = 'OW542DDD50G'; $zipmap['85051'] = 'OW542DDBY0Z'; $zipmap['85050'] = 'OW542DDAVXF'; $zipmap['85049'] = 'OW542DD9PY3'; $zipmap['85048'] = 'OW542DD8NAJ'; $zipmap['85046'] = 'OW54KHZTZ1P'; $zipmap['85045'] = 'OW542DD7KU9'; $zipmap['85044'] = 'OW542DD6F04'; $zipmap['85043'] = 'OW542DD5ECI'; $zipmap['85042'] = 'OW542DD48PX'; $zipmap['85041'] = 'OW542DD3395'; $zipmap['85040'] = 'OW542DD1ZLE'; $zipmap['85039'] = 'OW54KH6JX01'; $zipmap['85038'] = 'OW54KH3NI87'; $zipmap['85037'] = 'OW542DD0VWZ'; $zipmap['85036'] = 'OW54KH0IS1N'; $zipmap['85035'] = 'OW542DCZUDB'; $zipmap['85034'] = 'OW542DCYRDM'; $zipmap['85033'] = 'OW542DCXLVA'; $zipmap['85032'] = 'OW542DCWHWH'; $zipmap['85031'] = 'OW542DCVC7R'; $zipmap['85030'] = 'OW54KGXC7DL'; $zipmap['85029'] = 'OW542DCUA94'; $zipmap['85028'] = 'OW542DCT1SQ'; $zipmap['85027'] = 'OW542DCS0IT'; $zipmap['85026'] = 'OW54KGTS9AK'; $zipmap['85025'] = 'OW54KGQZVQ2'; $zipmap['85024'] = 'OW542DCQTEL'; $zipmap['85023'] = 'OW542DCPSVU'; $zipmap['85022'] = 'OW542DCOM29'; $zipmap['85021'] = 'OW542DCNIPD'; $zipmap['85020'] = 'OW542DCMGWW'; $zipmap['85178'] = 'UB5EZMJD795'; $zipmap['85173'] = 'UB5EZRQNPBL'; $zipmap['85172'] = 'UB5EZRK2LWA'; $zipmap['85147'] = 'UB5EZRG5BV9'; $zipmap['85145'] = 'UB5EZRCES8M'; $zipmap['85143'] = 'UB5EZR93JKA'; $zipmap['85142'] = 'UB5EZQ266S6'; $zipmap['85141'] = 'UB5EZPROFWZ'; $zipmap['85140'] = 'UB5EZPVAL1L'; $zipmap['85139'] = 'UB5EZPMPME2'; $zipmap['85138'] = 'UB5EZPITB9V'; $zipmap['85137'] = 'UB5EZOQF12J'; $zipmap['85135'] = 'UB5EZOMN75J'; $zipmap['85132'] = 'UB5EZOHMLD8'; $zipmap['85131'] = 'UB5EZODI25H'; $zipmap['85130'] = 'UB5EZN56V9U'; $zipmap['85128'] = 'UB5EZO8XJIH'; $zipmap['85127'] = 'UB5EZO59T5B'; $zipmap['85123'] = 'UB5EZMREDJH'; $zipmap['85122'] = 'UB5EZN0H7BA'; $zipmap['85121'] = 'UB5EZMWM9NF'; $zipmap['85120'] = 'UB5EZME5FR2'; $zipmap['85119'] = 'UB5EZG5H8O7'; $zipmap['85118'] = 'UB5EZG1K42H'; $zipmap['85117'] = 'UB5EZFXMAAC'; $zipmap['85099'] = 'OW54KLLF4B8'; $zipmap['85098'] = 'OW54KLIV0WG'; $zipmap['85096'] = 'OW542DDMTA5'; $zipmap['85087'] = 'OW542DDLRTE'; $zipmap['85086'] = 'OW542DDKO8R'; $zipmap['85085'] = 'OW542DDJHK9'; $zipmap['85083'] = 'OW542DDIEGK'; $zipmap['85082'] = 'OW54KLG8WQG'; $zipmap['85080'] = 'OW54KLE9T4Q'; $zipmap['85079'] = 'OW54KLBPXED'; $zipmap['85078'] = 'OW54KL8K6RR'; $zipmap['85077'] = 'OW54KKHSIHA'; $zipmap['85076'] = 'OW54KKF0M8W'; $zipmap['85075'] = 'OW54KKCDEV0'; $zipmap['85074'] = 'OW54KK9NCTA'; $zipmap['85073'] = 'OW54KK718JF'; $zipmap['85072'] = 'OW54KK4XUQ5'; $zipmap['85071'] = 'OW54KK263P6'; $zipmap['85070'] = 'OW54KJZVESX'; $zipmap['85069'] = 'OW54KJT4W5V'; $zipmap['85241'] = 'OW5U65BHE3X'; $zipmap['85240'] = 'OW542DEN3XZ'; $zipmap['85239'] = 'OW542DEM1ST'; $zipmap['85238'] = 'OW542DEL164'; $zipmap['85237'] = 'OW542DEJT7W'; $zipmap['85236'] = 'OW542DEIOZ1'; $zipmap['85235'] = 'OW542DEHMNW'; $zipmap['85234'] = 'OW542DEGLPF'; $zipmap['85233'] = 'OW542DEFHPO'; $zipmap['85232'] = 'OW542DEEE63'; $zipmap['85231'] = 'OW542DED9GX'; $zipmap['85230'] = 'OW54TFJ2DH0'; $zipmap['85228'] = 'OW542DEC57W'; $zipmap['85227'] = 'OW542DEB16V'; $zipmap['85226'] = 'OW542DE9XMC'; $zipmap['85225'] = 'OW542DE8US5'; $zipmap['85224'] = 'OW542DE7R3H'; $zipmap['85223'] = 'OW542DE6MCR'; $zipmap['85222'] = 'OW542DE5HTA'; $zipmap['85221'] = 'OW54TCEU27P'; $zipmap['85220'] = 'OW542DE4CZ7'; $zipmap['85219'] = 'OW542DE39H5'; $zipmap['85218'] = 'OW542DE266B'; $zipmap['85217'] = 'OW54TBUCBIR'; $zipmap['85216'] = 'OW54IJACWVP'; $zipmap['85215'] = 'OW542DE14LJ'; $zipmap['85214'] = 'OWBV4KWKBPI'; $zipmap['85213'] = 'OW542DDZZ5Q'; $zipmap['85212'] = 'OW542DDYW96'; $zipmap['85211'] = 'OWBV4KTBMCJ'; $zipmap['85210'] = 'OW542DDXSKB'; $zipmap['85209'] = 'OW542DDWQ14'; $zipmap['85208'] = 'OW542DDVIM9'; $zipmap['85207'] = 'OW542DDUG36'; $zipmap['85206'] = 'OW542DDTF2E'; $zipmap['85205'] = 'OW542DDSB95'; $zipmap['85204'] = 'OW542DDRAGI'; $zipmap['85203'] = 'OW542DDQ73Q'; $zipmap['85202'] = 'OW542DDP1GT'; $zipmap['85201'] = 'OW542DDNX4Z'; $zipmap['85194'] = 'UB5EZO13EDM'; $zipmap['85193'] = 'UB5EZNWZHHV'; $zipmap['85192'] = 'UB5EZS0QZBA'; $zipmap['85191'] = 'UB5EZRWFPF4'; $zipmap['85190'] = 'UB5EZMNTGB1'; $zipmap['85290'] = 'OW54TC5YDK2'; $zipmap['85289'] = 'OW542DFO00X'; $zipmap['85287'] = 'OW5U6GZRTEY'; $zipmap['85286'] = 'OW542DFN3BI'; $zipmap['85285'] = 'OW5U6GWPC5J'; $zipmap['85284'] = 'OW542DFLWNR'; $zipmap['85283'] = 'OW542DFKRKY'; $zipmap['85282'] = 'OW542DFJNZU'; $zipmap['85281'] = 'OW542DFIK4T'; $zipmap['85280'] = 'OW542DFHIRG'; $zipmap['85279'] = 'OW5U63BXQQS'; $zipmap['85278'] = 'OW54TC0OCMX'; $zipmap['85277'] = 'OW54IJJMU0G'; $zipmap['85275'] = 'OW54IJG4U87'; $zipmap['85274'] = 'OW54IJDUAPU'; $zipmap['85273'] = 'OW542DFGBOO'; $zipmap['85272'] = 'OW542DFF6ZS'; $zipmap['85271'] = 'OW5U6CB5FGG'; $zipmap['85269'] = 'OW54TXQB1QG'; $zipmap['85268'] = 'OW542DFE41C'; $zipmap['85267'] = 'OW5U6C8E28E'; $zipmap['85266'] = 'OW542DFCW9Y'; $zipmap['85264'] = 'OW542DF747G'; $zipmap['85263'] = 'OW542DF601Q'; $zipmap['85262'] = 'OW542DF4YOW'; $zipmap['85261'] = 'OW5U6C4PWQ2'; $zipmap['85260'] = 'OW542DF3UN1'; $zipmap['85259'] = 'OW542DF2PIT'; $zipmap['85258'] = 'OW542DF1Q82'; $zipmap['85257'] = 'OW542DF0LCW'; $zipmap['85256'] = 'OW5U6C0ZGHX'; $zipmap['85255'] = 'OW542DEZEH3'; $zipmap['85254'] = 'OW542DEYALG'; $zipmap['85253'] = 'OW542DEX5Z8'; $zipmap['85252'] = 'OW5U68QNEK3'; $zipmap['85251'] = 'OW542DEW1WL'; $zipmap['85250'] = 'OW542DEUXQM'; $zipmap['85249'] = 'OW542DETU91'; $zipmap['85248'] = 'OW542DESQ85'; $zipmap['85247'] = 'OW542DERN69'; $zipmap['85246'] = 'OW54TITTQDD'; $zipmap['85245'] = 'OW5U6723GOQ'; $zipmap['85244'] = 'OW542DEQI7A'; $zipmap['85243'] = 'OW542DEPGIH'; $zipmap['85242'] = 'OW542DEOD1H'; $zipmap['85341'] = 'OW54TM7HZRW'; $zipmap['85340'] = 'OW542DGU5RJ'; $zipmap['85339'] = 'OW542DGT0EK'; $zipmap['85338'] = 'OW542DGS0IC'; $zipmap['85337'] = 'OW542DGQTES'; $zipmap['85336'] = 'OW54TXWP9OM'; $zipmap['85335'] = 'OW542DGPOTW'; $zipmap['85334'] = 'OW542DGOLQW'; $zipmap['85333'] = 'OW542DGNGTA'; $zipmap['85332'] = 'OW542DGMDDS'; $zipmap['85331'] = 'OW542DGL95N'; $zipmap['85329'] = 'OW542DGK50D'; $zipmap['85328'] = 'OW54TJ1QRXQ'; $zipmap['85327'] = 'OW542DGIZIK'; $zipmap['85326'] = 'OW542DGHUIO'; $zipmap['85325'] = 'OW542DGH057'; $zipmap['85324'] = 'OW542DGFWDI'; $zipmap['85323'] = 'OW542DGET0X'; $zipmap['85322'] = 'OW542DGDPW9'; $zipmap['85321'] = 'OW542DGCMHR'; $zipmap['85320'] = 'OW542DGBJ7R'; $zipmap['85318'] = 'OW54F1N7UC7'; $zipmap['85316'] = 'OW542DGAFF9'; $zipmap['85313'] = 'OW542DG9BDT'; $zipmap['85312'] = 'OW54TYUCVXX'; $zipmap['85311'] = 'OW54TYSA7KU'; $zipmap['85310'] = 'OW542DG87YO'; $zipmap['85309'] = 'OW542DG75Y7'; $zipmap['85308'] = 'OW542DG619B'; $zipmap['85307'] = 'OW542DG4XYL'; $zipmap['85306'] = 'OW542DG3TQY'; $zipmap['85305'] = 'OW542DG2Q6U'; $zipmap['85304'] = 'OW542DG1MGF'; $zipmap['85303'] = 'OW542DG0MNY'; $zipmap['85302'] = 'OW542DFZFO3'; $zipmap['85301'] = 'OW542DFYD78'; $zipmap['85299'] = 'OW542DFX7N0'; $zipmap['85298'] = 'OW542DFW45D'; $zipmap['85297'] = 'OW542DFUZPC'; $zipmap['85296'] = 'OW542DFTXA3'; $zipmap['85295'] = 'OW542DFSWUW'; $zipmap['85294'] = 'OW542DFRQZ0'; $zipmap['85293'] = 'OW542DFRCWB'; $zipmap['85292'] = 'OW542DFQBYZ'; $zipmap['85291'] = 'OW542DFP3YZ'; $zipmap['85392'] = 'OW542DHQ858'; $zipmap['85390'] = 'OW542DHP5AK'; $zipmap['85388'] = 'OW542DHO3N9'; $zipmap['85387'] = 'OW542DHMVNO'; $zipmap['85385'] = 'OW5U6562SWI'; $zipmap['85383'] = 'OW542DHLSCT'; $zipmap['85382'] = 'OW542DHKLBE'; $zipmap['85381'] = 'OW542DHJKXO'; $zipmap['85380'] = 'OW5U652MS1C'; $zipmap['85379'] = 'OW542DHIEHY'; $zipmap['85378'] = 'OW542DHHBVW'; $zipmap['85377'] = 'OW542DHG7L9'; $zipmap['85376'] = 'OW5U6FCCABV'; $zipmap['85375'] = 'OW542DHF2FD'; $zipmap['85374'] = 'OW542DHDYMX'; $zipmap['85373'] = 'OW542DHCU64'; $zipmap['85372'] = 'OW542DHBQ57'; $zipmap['85371'] = 'OW5U66KQSJK'; $zipmap['85369'] = 'OW5U6K1SUV1'; $zipmap['85367'] = 'OW5U6NJMUX8'; $zipmap['85366'] = 'OW5U6JYZP77'; $zipmap['85365'] = 'OW54TN8A7EK'; $zipmap['85364'] = 'OW5U6JORWE2'; $zipmap['85363'] = 'OW542DHAK5R'; $zipmap['85362'] = 'OW542DH9HW1'; $zipmap['85361'] = 'OW542DH8F1G'; $zipmap['85360'] = 'OW542DH7C4H'; $zipmap['85359'] = 'OW5U66WOE4W'; $zipmap['85358'] = 'OW542DH69H9'; $zipmap['85357'] = 'OW542DH54HH'; $zipmap['85356'] = 'OW5U6ID97ST'; $zipmap['85355'] = 'OW542DH3ZHM'; $zipmap['85354'] = 'OW542DH2Y95'; $zipmap['85353'] = 'OW542DH1QT9'; $zipmap['85352'] = 'OW5U6GR3CKB'; $zipmap['85351'] = 'OW542DH0LDI'; $zipmap['85350'] = 'OW5U6EYAH6V'; $zipmap['85349'] = 'OW5U68HZV1U'; $zipmap['85348'] = 'OW542DGZGYA'; $zipmap['85347'] = 'OW542DGYHTO'; $zipmap['85346'] = 'OW5U66TJZOB'; $zipmap['85345'] = 'OW542DGXM9A'; $zipmap['85344'] = 'OWBUQXP9NCS'; $zipmap['85343'] = 'OW542DGWGN7'; $zipmap['85342'] = 'OW542DGVD47'; $zipmap['85618'] = 'OW542DIE0K4'; $zipmap['85617'] = 'OW54TKLFT4L'; $zipmap['85616'] = 'OW542DID0PV'; $zipmap['85615'] = 'OW542DIBTD4'; $zipmap['85614'] = 'OW54TMCMEYQ'; $zipmap['85613'] = 'OW54TXFC03A'; $zipmap['85611'] = 'OW54TFFUJRH'; $zipmap['85610'] = 'OW542DIASS2'; $zipmap['85609'] = 'OW54TPIEK8J'; $zipmap['85608'] = 'OW5U61QWHAN'; $zipmap['85607'] = 'OW542DI9S27'; $zipmap['85606'] = 'OW54TJS5EXT'; $zipmap['85605'] = 'OW54TDE80W1'; $zipmap['85603'] = 'OW54TD880W3'; $zipmap['85602'] = 'OW542DI8NOD'; $zipmap['85601'] = 'OW54TC9DSBJ'; $zipmap['85554'] = 'OW542DI6QQB'; $zipmap['85553'] = 'OW542DI5KWN'; $zipmap['85552'] = 'OW542DI4GYL'; $zipmap['85551'] = 'OW5U6EVO3QY'; $zipmap['85550'] = 'OW5U68C8G04'; $zipmap['85548'] = 'OW5U689BUF0'; $zipmap['85547'] = 'OW5U64ZJZ74'; $zipmap['85546'] = 'OW542DI3GTX'; $zipmap['85545'] = 'OW542DI2AY5'; $zipmap['85544'] = 'OW542DI13PR'; $zipmap['85543'] = 'OW542DHZZJO'; $zipmap['85542'] = 'OW5U658LQJK'; $zipmap['85541'] = 'OW542DHZPXI'; $zipmap['85540'] = 'OW5U63KLL3W'; $zipmap['85539'] = 'OW542DHZ2UO'; $zipmap['85536'] = 'OW54TXSNF1X'; $zipmap['85535'] = 'OW5U61ZWUOR'; $zipmap['85534'] = 'OW5U61WJ27H'; $zipmap['85533'] = 'OW542DHY160'; $zipmap['85532'] = 'OW542DHWY3C'; $zipmap['85531'] = 'OW54TGK3RSL'; $zipmap['85530'] = 'OWBUQANKLIP'; $zipmap['85502'] = 'OW54TYWODNM'; $zipmap['85501'] = 'OW542DHVUY6'; $zipmap['85441'] = 'OW542DHUQM1'; $zipmap['85431'] = 'OW54WIJL5NH'; $zipmap['85401'] = 'OW542DHTM1N'; $zipmap['85396'] = 'OW542DHSJ76'; $zipmap['85395'] = 'OW542DHRCT4'; $zipmap['85706'] = 'OW542DIOZAD'; $zipmap['85705'] = 'OW542DINVF4'; $zipmap['85704'] = 'OW542DIMS77'; $zipmap['85703'] = 'OW54S6KPD9H'; $zipmap['85702'] = 'OW54S6IFBN0'; $zipmap['85701'] = 'OW54S6F0M8X'; $zipmap['85671'] = 'OW5UCFJPJIY'; $zipmap['85670'] = 'OW54TXI1WKX'; $zipmap['85662'] = 'OW5U63ZOMRV'; $zipmap['85658'] = 'OW54TN3A2DL'; $zipmap['85655'] = 'OW5U61TU635'; $zipmap['85654'] = 'OW5U67EAIPQ'; $zipmap['85653'] = 'OW542DILNS2'; $zipmap['85652'] = 'OW54TKG467B'; $zipmap['85651'] = 'OW542DIL77W'; $zipmap['85650'] = 'OW5U6DIY09D'; $zipmap['85648'] = 'OW5U63XBQH7'; $zipmap['85646'] = 'OW542DIKFIY'; $zipmap['85645'] = 'OW5U6I4T3AI'; $zipmap['85644'] = 'OW54TBQORTS'; $zipmap['85643'] = 'OW542DIJAIB'; $zipmap['85642'] = 'OW54TBN7GD1'; $zipmap['85641'] = 'OW542DII61X'; $zipmap['85640'] = 'OW54TBJR69W'; $zipmap['85639'] = 'OW5U6I27PWP'; $zipmap['85638'] = 'OW542DIHSKQ'; $zipmap['85637'] = 'OW54TZ57AR1'; $zipmap['85636'] = 'OW5U6DG5DF6'; $zipmap['85635'] = 'OW5U6DCVD2Q'; $zipmap['85634'] = 'OW54TM0EK6U'; $zipmap['85633'] = 'OW5U68NHK6P'; $zipmap['85632'] = 'OW54TVGONIJ'; $zipmap['85631'] = 'OW5U68KVDXF'; $zipmap['85630'] = 'OW5U6F2M1FR'; $zipmap['85629'] = 'OW542DIHDP6'; $zipmap['85628'] = 'OW542DIH17N'; $zipmap['85627'] = 'OW542DIGNH7'; $zipmap['85626'] = 'OW5U65KB9A3'; $zipmap['85625'] = 'OW542DIG7HM'; $zipmap['85624'] = 'OW54TLVQDP8'; $zipmap['85623'] = 'OW542DIF5RX'; $zipmap['85622'] = 'OW54TUCH3S3'; $zipmap['85621'] = 'OW5U625W6XL'; $zipmap['85620'] = 'OW5U63PBRVT'; $zipmap['85619'] = 'OW5U63N389D'; $zipmap['85751'] = 'OW54SEKDBG5'; $zipmap['85750'] = 'OW542DJ4QFJ'; $zipmap['85749'] = 'OW542DJ3ICS'; $zipmap['85748'] = 'OW54SEHY4I3'; $zipmap['85747'] = 'OW54SDO1A8G'; $zipmap['85746'] = 'OW542DJ2EKS'; $zipmap['85745'] = 'OW542DJ1CAA'; $zipmap['85744'] = 'OW54SDK81IP'; $zipmap['85743'] = 'OW542DJ09HS'; $zipmap['85742'] = 'OW542DIZXXF'; $zipmap['85741'] = 'OW54SCUC64X'; $zipmap['85740'] = 'OW54SCRSBY4'; $zipmap['85739'] = 'OW542DIYX36'; $zipmap['85738'] = 'OW54SBJRL1D'; $zipmap['85737'] = 'OW542DIXSQE'; $zipmap['85736'] = 'OW542DIWPDK'; $zipmap['85735'] = 'OW54SBCDDP5'; $zipmap['85734'] = 'OW54SB9MSUZ'; $zipmap['85733'] = 'OW54SB7DG9Z'; $zipmap['85732'] = 'OW54SB52OUU'; $zipmap['85731'] = 'OW54SACFSA6'; $zipmap['85730'] = 'OW542DIVNV7'; $zipmap['85729'] = 'OW54SA6WDCM'; $zipmap['85728'] = 'OW54SA3Q2EW'; $zipmap['85727'] = 'OW54SA11SWR'; $zipmap['85726'] = 'OW54S9XV22N'; $zipmap['85725'] = 'OW54S9VM9JE'; $zipmap['85724'] = 'OW54S9TC86E'; $zipmap['85723'] = 'OW54S9Q80P4'; $zipmap['85722'] = 'OW54S9NVM4P'; $zipmap['85721'] = 'OW54S9L7EVX'; $zipmap['85720'] = 'OW54S9HB671'; $zipmap['85719'] = 'OW54S9ETTEF'; $zipmap['85718'] = 'OW54S8MXHLJ'; $zipmap['85717'] = 'OW54S8KEWYF'; $zipmap['85716'] = 'OW542DIUHJ1'; $zipmap['85715'] = 'OW54S8EHKCE'; $zipmap['85714'] = 'OW54S8BLB2H'; $zipmap['85713'] = 'OW542DITCUI'; $zipmap['85712'] = 'OW542DISBFR'; $zipmap['85711'] = 'OW542DIR7G7'; $zipmap['85710'] = 'OW542DIQ3SG'; $zipmap['85709'] = 'OW54S7WMCL0'; $zipmap['85708'] = 'OW54S7SCSNP'; $zipmap['85707'] = 'OW54S71EYN2'; $zipmap['86022'] = 'OW54TFDDCFR'; $zipmap['86021'] = 'OW54TJZ9VTL'; $zipmap['86020'] = 'OW54TFBAWQH'; $zipmap['86018'] = 'OW542DJY9K0'; $zipmap['86017'] = 'OW542DJX7B7'; $zipmap['86016'] = 'OW542DJW0BC'; $zipmap['86015'] = 'OW542DJUWQP'; $zipmap['86011'] = 'OW5U637R8GI'; $zipmap['86005'] = '15B31AMQ46WG'; $zipmap['86004'] = 'OW542DJTTPR'; $zipmap['86003'] = 'OW5U62GRQEO'; $zipmap['86002'] = 'OW5U62E921V'; $zipmap['86001'] = 'OW542DJSQNI'; $zipmap['85942'] = 'OW5U6ESIFUD'; $zipmap['85941'] = 'OW5U6IGIBXJ'; $zipmap['85940'] = 'OW542DJROHY'; $zipmap['85939'] = 'OW542DJQIQ4'; $zipmap['85938'] = 'OW542DJPC9S'; $zipmap['85937'] = 'OW542DJOC7E'; $zipmap['85936'] = 'OW5U6F8O5KM'; $zipmap['85935'] = 'OW542DJN405'; $zipmap['85934'] = 'OW542DJLOPH'; $zipmap['85933'] = 'OW542DJKKN5'; $zipmap['85932'] = 'OW542DJJG0Q'; $zipmap['85931'] = 'OW542DJIQB4'; $zipmap['85930'] = 'OW54TNBYG0L'; $zipmap['85929'] = 'OW542DJHLEU'; $zipmap['85928'] = 'OW542DJGJ2R'; $zipmap['85927'] = 'OW542DJFE3P'; $zipmap['85926'] = 'OW54TX7X3WK'; $zipmap['85925'] = 'OW542DJE9SY'; $zipmap['85924'] = 'OW542DJD5F9'; $zipmap['85923'] = 'OW542DJC4CY'; $zipmap['85922'] = 'OW542DJB1L4'; $zipmap['85920'] = 'OW542DJ9UD9'; $zipmap['85912'] = 'OW5U6IS4F1J'; $zipmap['85911'] = 'OW54TIY16IR'; $zipmap['85902'] = 'OW542DJ8PWM'; $zipmap['85901'] = 'OW542DJ7MJN'; $zipmap['85777'] = 'OWBVA85511W'; $zipmap['85775'] = 'OWBVABKGWB0'; $zipmap['85757'] = 'OW542DJ6J3R'; $zipmap['85755'] = 'OW542DJ5DK9'; $zipmap['85754'] = 'OWBVA7ZD410'; $zipmap['85752'] = 'OW54SEN6JWX'; $zipmap['86324'] = 'OW542DKLDYE'; $zipmap['86323'] = 'OW542DKKB67'; $zipmap['86322'] = 'OW542DKJ655'; $zipmap['86321'] = 'OW54TCCAFUC'; $zipmap['86320'] = 'OW542DKI0EH'; $zipmap['86315'] = '12EH4CWBWR57'; $zipmap['86314'] = 'OW542DKGX68'; $zipmap['86313'] = 'OW5U66O05O1'; $zipmap['86312'] = 'OW5UC2KO60Y'; $zipmap['86305'] = 'OW542DKFRP0'; $zipmap['86304'] = 'OW542DKER2Q'; $zipmap['86303'] = 'OW542DKDJLR'; $zipmap['86302'] = 'OW5U66QB7UF'; $zipmap['86301'] = 'OW542DKCG5V'; $zipmap['86268'] = 'OW542DKBBEI'; $zipmap['86260'] = 'OW542DKA9AS'; $zipmap['86258'] = 'OW542DK953U'; $zipmap['86235'] = 'OW542DK80LJ'; $zipmap['86205'] = 'OW542DK7019'; $zipmap['86204'] = 'OW542DK5W8V'; $zipmap['86086'] = 'OW542DK5F9W'; $zipmap['86054'] = 'OW5U6D7H7RP'; $zipmap['86053'] = 'OW54TQCHHPV'; $zipmap['86052'] = 'OW54TX1D1CU'; $zipmap['86047'] = 'OW542DK4DNL'; $zipmap['86046'] = 'OW542DK3AH4'; $zipmap['86045'] = 'OW542DK27UU'; $zipmap['86044'] = 'OW5U66ZAPKD'; $zipmap['86043'] = 'OW54TNSP6BF'; $zipmap['86042'] = 'OW5U62BA7WO'; $zipmap['86040'] = 'OW542DK1JYM'; $zipmap['86039'] = 'OW54TLECD91'; $zipmap['86038'] = 'OW542DK0HB5'; $zipmap['86036'] = 'OW54TN5RYKU'; $zipmap['86035'] = 'OW54TLP0HEJ'; $zipmap['86034'] = 'OW54TPC9LK3'; $zipmap['86033'] = 'OW54TGOPWMB'; $zipmap['86032'] = 'OW54TPKLRFM'; $zipmap['86031'] = 'OW54TP7AHWX'; $zipmap['86030'] = 'OW54TVVXFHD'; $zipmap['86029'] = 'OW54TVQ2HVJ'; $zipmap['86028'] = 'OW54TVNK8RB'; $zipmap['86025'] = 'OW54TVKPPPV'; $zipmap['86024'] = 'OW542DJZCU3'; $zipmap['86023'] = 'OW5U6I7CTFL'; $zipmap['86441'] = 'OW5U61NL1L7'; $zipmap['86440'] = 'OW542DL58C7'; $zipmap['86439'] = 'OW54TEZG726'; $zipmap['86438'] = 'OW5U6IXRX5W'; $zipmap['86437'] = 'OW54TSOC8I0'; $zipmap['86436'] = 'OW54TYZ1Y59'; $zipmap['86435'] = 'OW5U6FFF32L'; $zipmap['86434'] = 'OW54TYPMF5K'; $zipmap['86433'] = 'OW5U6429ND3'; $zipmap['86432'] = 'OW54TLS6KSV'; $zipmap['86431'] = 'OW54WG49BWI'; $zipmap['86430'] = 'OW54TDSQ7HX'; $zipmap['86429'] = 'OW54TDOTVM1'; $zipmap['86427'] = 'OW54TDM3JLM'; $zipmap['86426'] = 'OW54TDIEFHR'; $zipmap['86413'] = 'OW54TR7BSMY'; $zipmap['86412'] = 'OW54TSHVT5L'; $zipmap['86411'] = 'OW54TR1PXMJ'; $zipmap['86409'] = 'OW542DL4522'; $zipmap['86406'] = 'OW542DL2ZUI'; $zipmap['86405'] = 'OW54TUMK103'; $zipmap['86404'] = 'OW542DL1V5L'; $zipmap['86403'] = 'OW54TUJWK5L'; $zipmap['86402'] = 'OW54TQQSDTX'; $zipmap['86401'] = 'OW54TQO34FC'; $zipmap['86364'] = 'OWBVAMT4FZC'; $zipmap['86351'] = 'OW542DL0U96'; $zipmap['86343'] = 'OW542DKZOOP'; $zipmap['86342'] = 'OW54TSYXK42'; $zipmap['86341'] = 'OW5U6D4YRJI'; $zipmap['86340'] = 'OW5U6CE7XVT'; $zipmap['86339'] = 'OW542DKYML4'; $zipmap['86338'] = 'OW542DKXIOF'; $zipmap['86337'] = 'OW542DKWIBQ'; $zipmap['86336'] = 'OW542DKVC8B'; $zipmap['86335'] = 'OW542DKUAZA'; $zipmap['86334'] = 'OW542DKT4W4'; $zipmap['86333'] = 'OW542DKS3JE'; $zipmap['86332'] = 'OW542DKQVUF'; $zipmap['86331'] = 'OW54TPFT5O0'; $zipmap['86330'] = 'OW54TP9HER4'; $zipmap['86329'] = 'OW542DKPT3F'; $zipmap['86327'] = 'OW542DKOPV5'; $zipmap['86326'] = 'OW542DKNKXT'; $zipmap['86325'] = 'OW542DKMJ38'; $zipmap['96740'] = 'OW542DLL9IQ'; $zipmap['96353'] = 'OW542DLK7TJ'; $zipmap['95338'] = 'OW542DLJ778'; $zipmap['89327'] = 'OW542DLI4RK'; $zipmap['89297'] = 'OW542DLFS90'; $zipmap['87420'] = 'OWBURF9OYGW'; $zipmap['87401'] = 'OWBV9OIRZ1S'; $zipmap['86601'] = 'OW542DL695J'; $zipmap['86556'] = 'OW54TIPTV66'; $zipmap['86547'] = 'OW54TIKP23U'; $zipmap['86545'] = 'OW54TICPYZH'; $zipmap['86544'] = 'OW5U6GTK0QL'; $zipmap['86540'] = 'OW5U63SEA45'; $zipmap['86538'] = 'OW54TI3QCNR'; $zipmap['86535'] = 'OW54TKNSSPH'; $zipmap['86520'] = 'OW54TDBUFMZ'; $zipmap['86515'] = 'OW5U6IJ527W'; $zipmap['86514'] = 'OW54TNKJ04N'; $zipmap['86512'] = 'OW5U68F2HBN'; $zipmap['86511'] = 'OW54TKJ2H3I'; $zipmap['86510'] = 'OW5U65HO5XY'; $zipmap['86508'] = 'OW54TM9POZH'; $zipmap['86507'] = 'OW54TGUM6CZ'; $zipmap['86506'] = 'OW54TVZL9AG'; $zipmap['86505'] = 'OW54TK3TMG0'; $zipmap['86504'] = 'OW54TXARJKQ'; $zipmap['86503'] = 'OW54TGS2LVB'; $zipmap['86502'] = 'OW54TGMOF0D'; $zipmap['86446'] = 'OW54TF6ZT47'; $zipmap['86445'] = 'OW54TSRJ3QR'; $zipmap['86444'] = 'OW54TNI6RH2'; $zipmap['86443'] = 'OWBV9UL0PI1'; } return $zipmap; } ?>