News
Projects
bad IE
EIRC
EQ-tools
MPS
Contact
MPS
Description

MPS stands for MySQL+PHP Phone Search, just about the worst name I could think of. It's is meant to be a library to query a MySQL address database.

Starting with 0.5 it will be compatible with the one generated by foondump. It used to work with FoonRIP, but FoonRIP development has stopped. If you're still using a FoonRIP database, you'll want MPS-0.4, the last version supporting FoonRIP.

Apart from querying a MySQL database it's also possible to query a remote XML-RPC server (server included as xmlserver.php). XML-RPC support is broken at the moment though. Also included in this distribution is a sample html interface (index.html) which must be configured through config.php. Everthing was created with the idea of creating fast SQL queries, either by making really slow queries impossible or altering the db in such a way to take maximum advantage of indices.

The database is compatible with the foondump 4.10a database. The 090604 snapshot will remain available for those of you who still use a foondump 4.01 database. If you're using a foondump 4.07 or 4.10 database you should upgrade to 4.10a as both those foondump versions contained some nasty bugs resulting in a screwed up database.

MPS is not affiliated with foondump, nor does it in any way encourage anything not legal. It's just a way to search in an address database compatible with foondump's.

 

 
Downloads

 

 
Changes
version 0.5:
  • foondump 4.10a support added at the cost of foonrip support.
  • removed distance calculation code as the necessary data isn't included in foondump
  • better navigation links in case a query results in multiple pages
  • added verification of correctness of town,streetname and category
  • fixed numerous bugs.
version 0.4:
  • updated script and /db files to foonrip 0.74bX compliance
  • broke XML-RPC support
  • added distance calculation based on postalcode or phone number (never released foonrip version only)
  • added support for pink database (never released foonrip version only)
  • frontend now uses template system from PHPlib (see README for installation instructions!)
  • search results are exportable to CSV format
  • setting of "magic_quotes_gpc" is taken into account
  • error msgs cleaned up

version 0.3.1:

  • bugfixed: when search.php returns "No Results" part of the page doesn't align (center)

version 0.3:

  • changed cache control system, make sure you also update your config file!
  • split up clientlib in to several smaller files
  • updated db definition so it's compatible again with FoonRip 0.72. (increased size of some varchar fields)
  • sql queries and explanation how to import FoonRip txt files in to MySQL
  • wilcard searches possible
  • reverse ordering possible

version 0.2.1:

  • bugfixed: warnings about REQUEST_URI on non-Apache servers
  • bugfixed: uninitialized variable warnings when requesting extrecord.php

version 0.2:

  • bugfixed: missing info records when using MPS supplied full db definition (NOT after using alter scripts)
  • data from info table now returned in the form of extended information
  • bugfixed: no prefix when doing XML-RPC search