Closed

GPS database

This project was awarded to cft1 for $51 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $100 USD
Total Bids
5
Project Description

Server side program running on Web Server that will be used to find other registered users within a certain geographical distance. ? ?

## Deliverables

Listed below is the functionality that will be required to be implemented.

<pre>

The following 4 PHP/Perl scripts will be invoked by the client using HTTP GET/POST

1) setlocation

parameters: ? deviceid ? <-- device id

? ? ? ? ? ? ? ? ? ? ? ? ? lat ? <-- lattitude

? ? ? ? ? ? ? ? ? ? ? ? ? lon <- longtitude

action: ? update database table?

output: 1 (success), (0) failure

2) setemail

parameters: ? deviceid ? <-- device id

? ? ? ? ? ? ? ? ? ? ? ? ? email <-- email address

action: ? update database table?

output: 1 (success), (0) failure

3) setpreference

parameters: ? deviceid ? <-- device id

? ? ? ? ? ? ? ? ? ? ? ? ? gender_preference_id <-- Gender preference id

? ? ? ? ? ? ? ? ? ? ? ? ? interest_id <-- Interest ID

? ? ? ? ? ? ? ? ? ? ? ? ? age_group_id <-- Age Group ID

? ? ? ? ? ? ? ? ? ? ? ? ? enounter_type_id ? <-- Encounter Type ID

action: ? update database table?

output: 1 (success), (0) failure

4) ? getmatches

parameters: ? deviceid ? <-- device id

? ? ? ? ? ? ? ? ? ? ? ? ? current_lat <-- (if not specified, lookup latitude in database)

? ? ? ? ? ? ? ? ? ? ? ? ? current_lon <-- (if not specified, lookup longtitude in database)

? ? ? ? ? ? ? ? ? ? ? ? ? dist <-- max distance (in miles)

action: ? determine all other users that are?

? ? ? ? ? ? ? A) Within the maximum distance specified, based on users location, AND

? ? ? ? ? ? ? B) Have the Same Interest, Age Group, and Encounter Type AND

? ? ? ? ? ? ? C) Have a corresponding Gender Type (ie. ? if a Man Seeking Woman is calling this method, then the query against the database would be Woman Seeking Man)

? ? ? ? ? ?

output: ? XML data in the following format

<matches>

<match>

? ? <email><email1@[url removed, login to view]></email>

? ? <lat>[url removed, login to view]</lat>

? ? <lon>[url removed, login to view]</lon>

</match>

.... (other matchs

</matches)

Database Tables

----------------------------

User

? ? ? Device_Id (80 characters)

? ? ? Lattitude?

? ? ? Longtitude

? ? ? location_update_time (last time location set)

? ? ? gender_preference_id

? ? ? interest_id

? ? ? age_group_id

? ? ? encounter_type_id

Gender_Preference

? ? id

? ? name?

(Initial rows: ? Man Seeking Woman, Woman Seeking Man, Woman Seeking Woman, Man Seeking Man)

Age_Group

? ? ? id

? ? ? name

(Initial rows: ? 18-25 YRS OLD, 26-35, 36-45,46-55,56-65,66-75, 75+)

Interest

? ? ? id

? ? ? name

(Initial rows: ? The Arts, Sex, Movies/Theatre, Books/Culture, Music, Dining/Wine, Fashion/Stlye, Politics, Technology, Sports, Science, Travel)

Encounter_Type

? ? ? id

? ? ? name

(Initial rows: ? Casual Encounter, ? Misc. Romance, Strictly Platonic, 12 Step Member, Missed Encounter)

</pre>

SUBMIT DATE

LAST UPDATED

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online