3WiFi Wireless Database
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
api Utils: Make pin2str function Oct 28, 2017
css Search: Display Radio Off and Hidden icons Jun 25, 2017
img Map: Add link for BSSID search Sep 6, 2018
js JS: Move all JavaScript files to new folder May 9, 2017
l10n L10N: Small grammar fix (ru-RU) Jan 23, 2018
themes Search: Display Radio Off and Hidden icons Jun 25, 2017
uploads Global database update Nov 14, 2015
.gitattributes 🎪 Added .gitattributes Jul 11, 2015
.gitignore Список исключений Jul 10, 2016
.htaccess Admin: Integrate interface into user page Oct 28, 2017
3wifi.php Search: Don't do excessive calculations when no memory tables (fix #57) Sep 14, 2018
3wifi.sql DB: Parse additional extinfo columns May 8, 2018
3wifid.php 3WiFi Daemon: Add limit for error report generation May 1, 2018
404.html Web UI: Add support for localization (fix #14) Mar 19, 2017
LICENSE Initial commit Jul 11, 2015
README.md Stats: Implement statistics caching (fix #38) Oct 28, 2017
add_quadkeys.php Файл настроек Jul 10, 2016
apidoc.html API: Add new method "apiranges" Jul 16, 2017
config.php-distr Config: Generate top 100 unique Wi-Fi keys Apr 7, 2018
counter.txt Update index and counter Nov 16, 2015
db.php DB: Add another filter for the extended data May 20, 2018
devmac.html Web UI: Improve unauthorized message Dec 9, 2017
faq.html FAQ: Fix a typo Jun 21, 2018
favicon.ico Initial commit Jul 11, 2015
find.html Search: Implement pagination using history (fix #54) Sep 14, 2018
geoext.php Geoext: Add workaround fix for Yandex.Locator Dec 22, 2017
graph.html Graph: Improve overlapping hackfix Mar 5, 2018
home.html Home: Move news lists to JSON files Sep 6, 2018
import.free.php Файл настроек Jul 10, 2016
index.html Search: Implement pagination using history (fix #54) Sep 14, 2018
index.php Home: Move news lists to JSON files Sep 6, 2018
ipext.php Ranges: Move radius query to Quadkey (#39) Oct 31, 2017
map.html Map: Show balloons instead of hints on mobile devices (fix #51) Sep 6, 2018
project_news.json Search: Don't do excessive calculations when no memory tables (fix #57) Sep 14, 2018
quadkey.php Quadkey: Add condition for grouping subsequent quadkeys Apr 9, 2018
ranges.html Ranges: Add hackfix for Internet Explorer Apr 27, 2018
robots.txt Initial commit Jul 11, 2015
rules.html Web UI: Add support for localization (fix #14) Mar 19, 2017
service_news.json Home: Move news lists to JSON files Sep 6, 2018
stat.html Web UI: Implement Use Location cookie (#39) Oct 31, 2017
statext.php Statext: Generate case sensitive statistics Apr 7, 2018
upload.html Web UI: Add support for localization (fix #14) Mar 19, 2017
user.class.php User: Obtain level info from users table if exists May 6, 2017
user.html User: Set "infinite" expiration date for theme cookie Jan 17, 2018
user.php Map: Show balloons instead of hints on mobile devices (fix #51) Sep 6, 2018
utils.php Index: Fix code to work with PHP 7 interpreter (#42) Aug 22, 2018
win_login.html Web UI: Move forms into separate files Nov 26, 2017
win_newpass.html Web UI: Move forms into separate files Nov 26, 2017
win_reg.html Web UI: Move forms into separate files Nov 26, 2017
wpspin.html WPS PIN: Add new OUI for WiFire S1010 Sep 6, 2018
wpspin.php WPS PIN: Fix BSSID offset addition bug May 11, 2018

README.md

3WiFi Database

(c) 2015 Anton Kokarev

This project was created to collect data from Router Scan log reports, search for access points, obtain its geolocation coordinates, and display it on world map.

Installation steps:

  1. Copy all required files to your /www directory
  2. Create database (execute 3wifi.sql to create tables)
  3. Copy config.php-distr to config.php
  4. Edit config.php (DB_SERV, DB_NAME, DB_USER, DB_PASS etc)
  5. (optional) Turn on memory tables (in the config.php define TRY_USE_MEMORY_TABLES as true)
  6. (optional) Use import.free.php once to import old format database
  7. Start all background daemons:
# Upload routine loads data into database
php -f 3wifid.php uploads
# Finalize routine prepares tasks for finalization
php -f 3wifid.php finalize
# Geolocate routine locates new added BSSIDs on map
php -f 3wifid.php geolocate
# Stats routine caches statistics (use only when stats caching enabled)
php -f 3wifid.php stats
# Memory table manager (use only with memory tables enabled)
php -f 3wifid.php memory

Database maintenance:

# Recheck not found BSSIDs in the database
php -f 3wifid.php recheck

Before running the daemons, make sure that php-cli interpreter is accessible from your directory.