GPS database

In Progress

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>

Skills: Engineering, MySQL, Perl, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: the wine group, science match, perl technology, a.b.c. wine, max fashion, sports technology, php gps, music technology, gps name, gps based, sports email database, dining table, gps client, update database email, lat address php, running gps, database query failure, program theatre, initial database, database wine, determine using device, travel age, lookup table php, music database scripts, email database update

Project ID: #3869689

Awarded to:

cft1

See private message.

$51 USD in 8 days
(34 Reviews)
6.3

5 freelancers are bidding on average $145 for this job

r2andme

See private message.

$42.5 USD in 8 days
(50 Reviews)
5.5
asimarif786

See private message.

$127.5 USD in 8 days
(9 Reviews)
2.4
reemnaji

See private message.

$76.5 USD in 8 days
(5 Reviews)
1.1
taniyashah

See private message.

$425 USD in 8 days
(2 Reviews)
0.9