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>

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