Register/Login - LOGIN IS NOT REQUIRED [ ALL THIS INFORMATION IS TAKEN FROM - CORDOVA-PLUGIN-SIM ---------------- SIM_NUMBER PHONE_NUMBER CARRIER COUNTRY_CODE IMEI COMBINED_ID Membership Status : PAID/UNPAID/FREE Membership_start_date Membeship_End_Date Membership_Transction_number Other_Membership_Details Date_Time ---------------------------------------------------------------------------------------------- My_Live_Location // Store in HTML5 Database on the MOBILE APP as a LOCATION CACHE -------------------- My_Latest_Location_1 Registered_User Yes/No paid_user yes/no ---------------------------------------------------------------------------------------------- There are roughly 12 Tables - 0to 30 Degrees of Longitude. POSTED_Information [ Table_1_NORTH ] ------------------ Posted_by_Email/PhoneNos_COMBINED RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_2_NORTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_3_NORTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_4_NORTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_5_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_6_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_7_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_8_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_9_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_10_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_11_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_12_NORTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ Table_1_SOUTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_2_SOUTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_3_SOUTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_4_SOUTH ] ------------------ Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_5_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_6_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_7_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_8_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_9_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_10_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_11_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. POSTED_Information [ TABLE_12_SOUTH ] -------------------------------------------- Posted_by_Email/PhoneNos RecordID Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. ------------------------------------------------------------------------------- VIA_SAT_SEARCH --------------- 2 DATASTORES ARE USED FOR SEARCH. Datastore 1 My_Live_Location // Stored in HTML5 Databaseon the MOBILE APP as live location [ session ] -------------------- My_Latest_Location_1 My_Latest_Location_2 My_Latest_Location_3 and Datastore 2 POSTED_Information [ Table_1,Table_2,Table_3... Table_15 ] ------------------ Posted_by_Email/PhoneNos Type: Individual/Organization short_Name web_url INFO_29_Categories INFO_29_sub_categories INFO_29GREEN_PLUS_29BLACK MESSAGE_80_CHAR Real_Latitude Real_Longitude Rounded_Lat Rounded_Long DateTime of the post. -------------------------------------------------------------------------------------- SEARCH RESULTS ARE POPULATED Into HTML5 Db and displayed on the map as the result pages are paged. NORTHAMERICA : - 180 (WEST) to -20( WEST) +10 (North) to +90 North ------------------------------------------------- Long left long right ( live_loc <= -20 west and live_loc >= -180 west ) && Lat bottom Lat Top ( live_loc >=10 north and live_loc <= 90North ) ------------------------------------------------- SOUTH AMERICA : -90 west to -35 west 12 North to -60 (South) -------------------------------------------------- long left long right ( live_loc <= -90 west and live_loc >= -35 west ) && lat bottom lat top ( live_loc >= -60 south and live_loc <=12 north ) -------------------------------------------------- EUROPE : -30 WEST TO +70 EAST +35 NORTH TO +90 NORTH ---------------------------------------------------- long left long right ( live_loc >= -30 west and live_loc <= +70 east ) && ( live_loc >=+10 north and live_loc <= +90 North ) ---------------------------------------------------- ASIA : 30 East to 180 East 10 North to 85 North ----------------------------------------------------- long left long right ( live_loc >= 30 east and live_loc <= 180 east ) && ( live_loc >=10 north and live_loc <= 90 North ) ----------------------------------------------------- AFRICA : 20 WEST TO 55 EAST 35 North to 35 South --------------------------------------------------------- long left long right ( live_loc_loc >= -20 west and live_loc <= 55 east ) && ( live_loc <= 35 north and live_loc >= - 35 south ) --------------------------------------------------------- OCEANIA : 110 EAST TO 180 EAST 5 SOUTH TO 50 SOUTH --------------------------------------------------------- long left long right ( live_loc >= 110 east and live_loc <= 180 east ) && ( live_loc <= -5 south and live_loc >= -50 south ) ---------------------------------------------------------- COUNTRY SCAN [ 15 degrees = 15 * 100 km ] --------------------------------------------------------------- Latbottom L2 Lattop L1 Longleft L4 Long right L3 ------------------------------------------------------------------------------------------------------- USA lat 39.000000 long -102.000000 [ >=24, <= 54, >= -117 <= - 87 ] MAP_ZOOM = 5 JAPAN lat 35.000000 long 140.000000 [ >=20, <= 50, >= 125, <= 155 ] MAP_ZOOM = 7 GERMANY lat 50.00000 long 9.00000 [ >=35, <= 65, >= -6, <= 24 ] MAP_ZOOM = 6 FRANCE lat 49.00000 long 2.400000 [ >=34, <= 64, >= -12.6, <= 17.4 ] MAP_ZOOM = 6 RUSSIA lat 62.00000 long 105.00000 [ >=47, <= 77, >= 90, <= 120 ] MAP_ZOOM = 3 CANADA lat 56.90 long -106.4 [ >=41.9, <= 71.9, >= -121.4 <= -91.4 ] MAP_ZOOM = 5 CHINA lat 36.000 long 104.000 [ >=21, <= 51, >= 89, <= 119 ] MAP_ZOOM = 6 SWEDEN lat 59.0000 long 18.0000 [ >=44, <= 74, >= 03, <= 33 ] MAP_ZOOM = 7 AUSTRALIA Lat -25.0000 long 133.7000 [ >=-40, <= -10, >= 118.7, <= 148.7 ] MAP_ZOOM = 5 INDIA Lat 21.0000 long 79.00000 [ >=06, <= 36, >= 64, <= 94 ] MAP_ZOOM = 5 UK Lat 51.50000 long -0.1127800 [ >=36.5, <= 66.5, >= -14.88, <= 15.1127 ] MAP_ZOOM = 7 SCANDINAVIA 62.000000 long 12.000000 [ >=47, <= 77, >= -3.00, <= 27.00 ] MAP_ZOOM = 5 BRAZIL Lat -14.00000 long -52.00000 [ >=-29, <= 1, >= -67, <= -37 ] MAP_ZOOM = 5 N/S KOREA Lat 37.50000 Long 126.97000 [ >= 22.5, <= 52.5, >= 111.97, <= 141.97 ] MAP_ZOOM = 7 LatTop [L1] Lat bottom [L2] Long left [ L4 ] Long right [L3] ------------ ------------------ ----------------- --------------------- 10 Km Scan - [ Live_Loc_lat + 0.1 ], [ live_loc_lat - 0.1], [ Live_Loc_long - 0.1 ], [ Live_Loc_long + 0.1 ] 25 Km Scan - [ Live_Loc_lat + 0.25], [live_loc_lat - 0.25], [ Live_Loc_long - 0.25], [ Live_Loc_long + 0.25 ] 50 Km Scan - [ Live_Loc_lat + 0.5] , [ live_loc_lat - 0.5] ,[ Live_Loc_long - 0.5] , [ Live_Loc_long + 0.5 ] -------------------------------------------------------------------------- The R Search Logic for a Positive search result is as follows Real latitude < L1 & Real Latitude > L2 Real Longitude < L3 & Real Longitude > L4 ------------------------------------------------------------------------- THE DATABASE/TABLE THAT WE POST/SEARCH In is AS FOLLOWS. [ USE THE HTML Local Storage to store the Array of KEY Values ] For Posting We get the [ R Live ] - R Lat, R long Take the R long and R Lat values and search the array list below to find Table_Name for Entering DATA. DETECT_DATA_STORE_NAME_FOR_POSTING_DATA ( R live - R lat, R long ) { for each item in arraylist { if ( R long < LONG RIGHT [ L3 ]) AND ( R long > Long LEFT [ l4] ) AND ( R Lat > 0 ) //TABLE_1_NORTH DATASTORE_TABLE_NAME = ARRAYLIST[ TABLE_NAME ]; else if if ( R long < LONG RIGHT [ L3 ]) AND ( R long > Long LEFT [ l4] ) AND ( R Lat < 0 ) //TABLE_1_SOUTH DATASTORE_TABLE_NAME = ARRAYLIST[ TABLE_NAME ]; } Return DATASTORE_TABLE_NAME } Latbottom L2 Lattop L1 Longleft L4 Long right L3 ------------------------------------------------------------------------------------------------------- USA lat 39.000000 long -102.000000 [ >=24, <= 54, >= -117 <= - 87 ] MAP_ZOOM = 5 JAPAN lat 35.000000 long 140.000000 [ >=20, <= 50, >= 125, <= 155 ] MAP_ZOOM = 7 GERMANY lat 50.00000 long 9.00000 [ >=35, <= 65, >= -6, <= 24 ] MAP_ZOOM = 6 FRANCE lat 49.00000 long 2.400000 [ >=34, <= 64, >= -12.6, <= 17.4 ] MAP_ZOOM = 6 RUSSIA lat 62.00000 long 105.00000 [ >=47, <= 77, >= 90, <= 120 ] MAP_ZOOM = 3 CANADA lat 56.90 long -106.4 [ >=41.9, <= 71.9, >= -121.4 <= -91.4 ] MAP_ZOOM = 5 CHINA lat 36.000 long 104.000 [ >=21, <= 51, >= 89, <= 119 ] MAP_ZOOM = 6 SWEDEN lat 59.0000 long 18.0000 [ >=44, <= 74, >= 03, <= 33 ] MAP_ZOOM = 7 AUSTRALIA Lat -25.0000 long 133.7000 [ >=-40, <= -10, >= 118.7, <= 148.7 ] MAP_ZOOM = 5 INDIA Lat 21.0000 long 79.00000 [ >=06, <= 36, >= 64, <= 94 ] MAP_ZOOM = 5 UK Lat 51.50000 long -0.1127800 [ >=36.5, <= 66.5, >= -14.88, <= 15.1127 ] MAP_ZOOM = 7 SCANDINAVIA 62.000000 long 12.000000 [ >=47, <= 77, >= -3.00, <= 27.00 ] MAP_ZOOM = 5 BRAZIL Lat -14.00000 long -52.00000 [ >=-29, <= 1, >= -67, <= -37 ] MAP_ZOOM = 5 N/S KOREA Lat 37.50000 Long 126.97000 [ >= 22.5, <= 52.5, >= 111.97, <= 141.97 ] MAP_ZOOM = 7 LONG_LEFT LONG_RIGHT Table_Name ------------------------------------- 0 30 Table_1_NORTH 30 60 Table_2_NORTH 60 90 Table_3_NORTH 90 120 Table_4_NORTH 120 150 Table_5_NORTH 150 180 Table_6_NORTH -30 0 Table_7_NORTH -60 -30 Table_8_NORTH -90 -60 Table_9_NORTH -120 -90 Table_10_NORTH -150 -120 Table_11_NORTH -180 -150 Table_12_NORTH -------------------------------------- 0 30 Table_1_SOUTH 30 60 Table_2_SOUTH 60 90 Table_3_SOUTH 90 120 Table_4_SOUTH 120 150 Table_5_SOUTH 150 180 Table_6_SOUTH -30 0 Table_7_SOUTH -60 -30 Table_8_SOUTH -90 -60 Table_9_SOUTH -120 -90 Table_10_SOUTH -150 -120 Table_11_SOUTH -180 -150 Table_12_SOUTH ---------------------------------------------------------------------------------------------------------------------- //// SEARCH DATA - PROCEDURE Get Value of LIVE Location. [ X live - X lat, X long ] Take the X long and X Lat values and search the array list below to find Table_Name for Entering DATA. DETECT_DATA_STORE_NAME_FOR_SEARCH ( X live - X lat, X long ) { for each item in arraylist { if ( X long < LONG RIGHT [ L3 ]) AND ( X long > Long LEFT [ l4] ) AND ( X Lat > 0 ) //TABLE_1_NORTH DATASTORE_TABLE_NAME = ARRAYLIST[ TABLE_NAME ]; else if if ( X long < LONG RIGHT [ L3 ]) AND ( X long > Long LEFT [ l4] ) AND ( X Lat < 0 ) // TABLE_1_SOUTH DATASTORE_TABLE_NAME = ARRAYLIST[ TABLE_NAME ]; } Return DATASTORE_TABLE_NAME } Search_logic( scan area[L1,L2,L3,L4], search STRING - key valuE, X Live ) { DATASTORE_TABLE_NAME = DETECT_DATA_STORE_NAME_FOR_SEARCH ( X live - X lat, X long ) search in DATASTORE_TABLE_NAME. }