WifiDB Logo
login

WiFiDB Version History

Project Name...Vistumbler WiFiDB 0.40
Project State...Beta
Project Dev(s)...ACalcutt
Vistumbler WiFiDB GitHub

Change Log

Author: Andrew CalcuttVersion: 0.40
Date: 09-04-2018Codename: Phoenix
Changes :WiFiDB GitHub : Branch 'ac-wifidb-prod'
  1. Forked project. Vistumbler WifiDB is now independent from the Random Intervals Wireless Database iteration.
  2. New mapping features using Mapbox GL and a TileServer GL backend.
  3. New GeoJSON api.
  4. Fixes to live ap pages and api.
  5. Various bug fixes.

Author: Phillip Ferland, Andrew CalcuttVersion: 0.30v Build 1
Date: 08-27-2014Codename: Peabody
Changes :WiFiDB GitHub : Branch 'ac-wifidb-prod'
  1. Minor modifications of WifiDB Alpha 0.30 to get a working release for the Vistumbler WiFiDB. The point of this release was to get the basics working.
  2. Fixes to imports
  3. Fixes to KML exports
  4. Fixes to GPS conversions
  5. Fixes to user login (though this needs a lot of work)
  6. Removed Mysicache from menu since it still needs a lot of work

Author: Phillip FerlandVersion: 0.30 Build 1
Date: 05-21-2013Codename: Peabody
Changes :WiFiDB GitHub : Branch 'dev'
  1. Re-wrote the back end storage, there is no longer 2 tables per Access Point in a seperate database called wifi_st. There are now three tables in the wifi database called; wifi_ap (Holds the general Information for each AP), wifi_signals (holds all the signal history data with an ID pointer for GPS), wifi_gps (holds all the GPS Coord data).
  2. Re-wrote the core of WiFiDB. All pages start off by calling /lib/init.inc.php, this sets up the environment, checks to see if the database is in the correct state, and then starts doing what the user asked.
    1. $dbcore The main Object that everything gets attached to.
      1. Core object variables include file system paths to library's, URL paths, and the current theme for the user, and any other system wide items like the manufactures list.
      2. SQL Object ($dbcore->sql)
        1. SQL Connection object.
        2. SQL Host name/IP string.
        3. WiFiDB DB Name.
      3. Frontend Class (lib/frontend.inc.php)
        1. Contains all the functions for interacting with the database and collecting data for output.
        2. Extends DBCore, Not to be used with the Daemon Class
      4. Daemon Class (lib/daemon.inc.php)
        1. Contains all the functions for interacting with the database and collecting data for output.
        2. Extends DBCore, Not to be used with Frontend Class.
      5. Export Class (lib/export.inc.php)
        1. Contains all the functions for interacting with the database and collecting data for output.
        2. Can be used with either the Daemon or Frontend Classes.
      6. Security Class (lib/security.inc.php)
        1. All the functions that involve security and users permissions within WiFiDB.
        2. Can be used with either the Daemon or Frontend Classes.
  3. Fixed lots of WTF moments in the code, which includes increasing the speed of the imports by, well... a whole lot. I can not import all 240k AP's in just over 8hrs, versus the 5 days it was taking on the old code. By no longer checking for duplicate GPS points on import.
  4. Added a globe icon for APs that have GPS, APs that do not have GPS have a grayed out globe.
  5. Fixed errors with handling UTF8 characters.
  6. Fixed errors with exporting data for APs with some special characters.
  7. *BROKEN* Added the ability for the search page to show the first 15 results on the same page as you type.
  8. Added Temp File and output cleanup for unneeded Daemon KML files.
  9. Implemented Smarty Templeting across all web pages.
  10. Moved Exporting functions out of the database.inc.php file and into their own export.inc.php and class.
  11. Renamed database.inc.php to frontend.inc.php
  12. Depreciated login_bar(), my_caches(), and user_panel_bar()
  13. Moved the header() and footer() functions back from the themes folder and into the mainline code. Themes will just have a header and footer `.tpl` file now.
  14. Implemented PDO prepared statements in all interactions with the SQL Servers.
  15. Removed all HTML elements from the import/export functions.

Author: Phillip FerlandVersion: 0.20 Build 1
Date: 2010-July-31Codename: Hyannis
Changes :
  1. Added Auto detect of Time zone and DST to the core. Now when it is the first time you visit the site, it will load a JavaScript to detect it and write a cookie. (wifidb_client_timezone, wifidb_client_dst, and wifidb_client_check)
  2. Fixed a bug in the graphing index page where it was not using the new SSID make function to generate the proper SSIDs for SQL tables, File names, and General usage. KB409
  3. Fixed a bug in the scheduling page where it would not calculate the correct Time zone stamp, but the time was correct. KB411
  4. Fixed a bug in the default theme where the page name was not being called correctly and was outputting an error or no text.
  5. Changed the All APs page to only show a few pages before and after the current page number.
  6. Added a User based login system. KB444
  7. Added User Control Panel. KB444
  8. Added Mysticache support (GPX / LOC / CSV). KB444
  9. Added XML Support.
  10. Fixed a bug with GPS conversions. If one of the Cords has only 2 digits before the decimal the geo-cord was converted wrong. KB478
  11. Fixed in Index and Import page. (This is only ever seen on my domains) Apparently I didn't know how to spell "Environment".
  12. Changed the name of the User Imports lists table from `users` to `users_imports`. (I was getting confused with the other new user's tables.)
  13. Added Administrator Panel. More info: KB475
    • Overview
      • Access Points
      • Geocache's
      • Users
      • Daemon Stats
      • Graphs
    • Users and Groups
      • Manage Users
      • Manage Groups
      • Manage Titles
    • Maintenance
      • Empty Temp folder
      • Archive Upload folders
      • Empty AP Graphing folder
      • Check For bad Dates in APs
      • Check for bad Geo-cords in APs
    • System
      • Edit Daemon configuration
      • Edit Front end configuration
  14. Fixed, Forgot to add the '@' before $lat_exp[1] on line 5583 in database.inc.php. This was causing an unknown variable warning.
  15. Fixed, There was a problem with importing SSID's that have backslashes (\). This would then parse to read from MySQL and wouldn't find the table. KB511
  16. Changed the Install and Upgrade scripts, cleaned up and improved the code layout a little more.
  17. Added alternating colors to the rows in most if not all tables. This is based per-theme with the .dark, .light, .sub_head, .style4[ha,td] in themes/[theme]/sytles.css
  18. Changed mail_admin() function to mail_users(), So Administrators and other users can be updated with new imports and other updates. Based off of XpertMailer
  19. Added another Daemon called 'geonamed.php'
    • Geonaming of Country and Administrative Names of Access Points with GPS.
    • Data gathered from this page: http://ws.geonames.org/countrySubdivision?lat=43.5762033&lng=7.02199666
    • GeoNames.org
  20. Support for Wardrive on android.
    • The wardriving application stores the database as "Wardrive.db3" on the root of your phones sd card.
    • Contact me and I'll add your app in.
  21. Build 1.1 Fixes
    1. Fixed an error in the converter function, was not telling it the location to write the file, resulted in a file being imported, but not saved to the disc.
    2. Fixed a bug in the import page, when there was an unsupported file being uploaded an Email was sent out. This is no longer done.
    3. The Last import date on the main page was changing even when the import had finished.
    4. The console viewer had an error with some modifications that I made, and didn't fix before the release.
    5. Some small HTML tag issues are fixed.
  22. Build 1.2 Fixes
    1. Fixed an issue some may have with installing from scratch.

Author: Phillip Ferland Version: 0.16 Build 4
Date: 2009-Sept-28
Changes :
  1. Added Daemon Generated KML exports. Details here.
  2. Fixed some HTML mode issues. KB385
  3. Fixed some issues that relate to WiFiDB running on a shared server host.KB385
  4. Forgot to remove a mysql_error() function from a verbose statement, in the update portion of the import_vs1() function
  5. Added Daemon Console Viewer.
  6. Fixed the issue with some tables in the 'Vistumbler' theme where not centered.
  7. Fixed an issue with the user stat page, where the second AP import list was not showing up.
  8. Fixed an issue with the daemon where it would not start to import a file if said file was uploaded when the daemon was in the middle of an import. You would have to wait till the next import.
  9. Added Daemon Generated KML History page, along with a link to it in the main menu.
  10. Made the output log and PID file for the daemon vars in the config file for the daemon.
  11. Disabled fields in the daemon section of the install page, via checkbox, if the daemon is not going to be used.
  12. Disabled the submit buttons on the Exports page if there is no imports/APs in the database.
  13. Extended `title` and `user` fields to 255 chars.
  14. Fixed a bug where the time was severely off in some cases, in Andrews instance, UTC said it was 01:11 (real UTC was 00:56), also local [-5] was reported as 21:11 (real time 20:40)
  15. Removed the "This is just a test" line on the import page after an import with the daemon enabled.
  16. Daemon now checks if the log file is longer than 500 lines, if so the file is moved to [tools_dir]/backups/logs/console_wifidbd_[date-time].log
  17. Added a bash script written by Andrew, was adapted from the Plone startup bash script. Use either wifidbd or wifidbd.sh
  18. Fixed some bugs with the KMZ exports being generated in the opt folder, and not the out/kmz folder.
    19. \
  19. Some others that I can�t remember, but were done.

Author: Phillip Ferland Version: 0.16 Build 3.1
Date: 2009-Aug-12
Changes :
  1. Changed the Scheduling page, so that there are now three parts to it:
    1. Default, shows the same as the old page, just the first 10 imports waiting now.
    2. Waiting, shows the remaining waiting lists
    3. Done, shows all the imports that have finished.
  2. Changed the install index page to give a more explicit navigation and what is available for patches.
  3. Added in locate.php for returning GPS points to Vistumbler based on Mac addresses that are around you. If none are found, it will ask if you want to upload a file.
  4. Changed the search.php, export.php, usersats.php pages' and apfetch() HTML so that when you customize your theme it keeps the page centered.
  5. Fixed some errors in the way the daemon compares the files that are being prepared to import.
  6. Re-generated manufatures.inc.php to get new manufactures.
  7. Removed Export Single AP to KML from the exports page, since there is more detailed exports on the APs fetch page, where you can choose what signal history row, or all the history rows, was also causing the page to take forever to load with lots of APs.
  8. Added $header variable for > Meta < tags and the such
  9. Added the Random Intervals Logo to the header
  10. Added support for Themes, please read this thread on how to use it / make your own.
  11. Changed scheduling.php so it has cookies support, now it is per-browser not per-server.
  12. Import upload script now only accepts .VS1 files, which it is how it should have been since I dropped .txt support.
  13. Fixed a Time zone issue conversion in the daemon and general core of WiFiDB.
  14. Added cookie based Time zone settings on the scheduling page.
  15. Fixed a bug in the individual User stats page, where it was not showing the first import for any user.
  16. Fixed an error where I didn�t have the 'exp_single_ap' on the exports page.
  17. Fixed an error in the Export all DB to KML, where if the last AP had no valid GPS cords, the link for the final file would not be shown.
  18. Changed the Full DB KML so that it is now a KMZ file not a KML, to save on bandwidth.

Author: Phillip Ferland Version: 0.16 Build 3
Date: 2009-Jul-09
Changes :
  1. Added Token support on almost every page that takes user input, or input from the URL.
  2. Fixed an issue where if you had sent a file from Vistumbler the token would not be able to be compared.
  3. Added signal strength to Access Point Signal Plot KML export.
  4. Changed Individual User Stat Page to new layout.
  5. Standardized SSID usage, there are three types :
    1. <ny-paq>|sayz oh-my this is fun (Is the non-sanitized, but still safe SSID, used to name APs, 32 char limit, no special chars.)
    2. <ny-paq>_sayz oh-my this is fun (Safe for file names, no special chars, 32 char limit.)
    3. _ny-paq__sayz oh-my this (Safe for table names, max 25 char, no special chars.)
  6. Changed the way WiFiDB looks for the install folder.
  7. Daemon now has all SQL based errors being echoed out to the screen, even if Verbose is off.
  8. Changed the table hide for GPS history, so it is now hidden by default. Has a +/- symbol to either expand or contract the table next to the GPS History Title.
  9. For some reason the Save Search link was missing after 0.16 Build 1, is now back, with a few enhancements.
  10. Fixed the No Token error with imports directly from Vistumbler.
  11. Fixed the formatting of the file location that is in the URL from the import directly from Vistumbler that gets printed on the page.
  12. Also made the drop down for selecting the refresh time on the scheduled imports page, so it has a default of the current selection instead of going back to 5 sec.
  13. Fixed the Upgrade script in /install/upgrade/patch.php. (Was broken in Build 2 and 2.1.)
  14. Fixed the Install script in /install/install.php. (Was broken in Build 2 and 2.1.)
  15. Added Daemon Status to the scheduling.php page.
  16. Fixed an issue where the Signal history was being corrupted by being sanitized. The 'special' characters '-' and ',' were being encoded.
  17. Fixed Some Issues with the daemon, details are in the Tools Read-me.
  18. The WiFiDB Web log vars $log_level and $log_interval where interfering with the Daemon vars, they are now changed to $log_level_W and $log_interval_W.
  19. The User-name in the 'Files already imported' table was pointing to the All APs for that user page, when it is supposed to point to the Users stat page.
  20. Fixed an issue where if some AP Pointers are removed from the `wifi0` table, some APs will fail to import or have the same ID as another AP and not be linkable to their data.
  21. [ Issues reported by ACalcutt ]
    1. "Access" is spelled incorrectly multiple times on Export page.
    2. (Export an Access Point to KML) "User-name" should be "SSID".
    3. Fix the links for Access Points on the All AP page. (Add tokens to the SSID URLs in the "View all APs" page.)
    4. Refresh time on the scheduling page went to 15 seconds when I set it to 5 seconds. On the next refresh it went back to 30 seconds.
  22. Unified the import_vs1() and importvs1d() functions, added an $out var to import_vs1() and verbose(), valid values are "CLI" and "HTML".
  23. Moved the Install folder warning code to the database.inc.php file from config.inc.php.
  24. All Messages in import_vs1 are in a group of variables in the beginning of the function, for easy editing.
  25. Added in some code to handle obscure APs that get tagged as new when they are not new.
  26. There was missing Token links on the Associated Lists section of the AP Fetch page.
  27. Numerous other small fixes that I have forgotten about.
  28. Spell-checked the Ver.php page.
  29. Added sorting and pages to the Search results page.
  30. Rearranged the exports page.
  31. Added MAC, sectype, chan, and radio to Single AP export.
  32. Added Date and number of APs for User list export.
  33. All AP page could not go to other pages to see more APs then that are on the first page.
  34. GPS array creation for import had wrong matching so duplicate data was being entered.

Author: Phillip Ferland Version: 0.16 Build 2.1
Date: 2009-May-05
Changes :
  1. Daemon was unable to remove files from `files_tmp` table and put them into the uploaded `files` table.
  2. The importvs1 function for the daemon was not returning the AP and GPS totals, and 0 was being entered into the users table.
  3. Added a link to the side for "Files Waiting to be imported" (/opt/scheduling.php).
  4. Fixed the issue where the Import page would not switch to 'non-daemon' mode when $daemon var was set to 0.
  5. Rearranged the table for scheduling.php, and added in Current AP, Importing? (Yes/No), Current AP/Total APs.
  6. Added color for Files waiting to be imported, Green = Currently Importing, Yellow = Waiting.
  7. Had to alter SQL statement for Total APs in the Main Stats Page. This is because I have added the next Import run as an element in the `settings` table.
  8. Main Stats Page Last Import list link didn't have a row id in the URL.
  9. The Corrupted dates on GPS cords was, I stupidly moved the Date conversion check outside the GPS array creation, which is dependent on the number of segments returned for the GPS in the VS1 file, so for the newer VS1 file that has 12 segments it was grabbing the wrong data.
  10. Fixed an issue where on windows based systems the file size wouldn't be correct.

Author: Phillip Ferland Version: 0.16 Build 2
Date: 2009-Apr-29
Changes :
  1. Changed the Import Page Layout so that it now summarizes the GPS import into,
    1. New: Good, Bad
    2. Update: Good, Bad
    3. Already in Database:
  2. Finished AP Fetch Page so that GPS can be hidden.
  3. Most, if not all pages now have the footer() and pageheader() function to standardize page layout.
  4. Fixed an issue where if there is no MAC/Sectype/Chan/Radio it would just be blank, and cause errors on fetch.
      5. New Defaults:
    1. Mac (00:00:00:00:00:00)
    2. Sectype (0)
    3. Chan (0)
    4. Radio (u)
  5. Added support for Exporting to GPX files, for Garmin Devices.
  6. Moved the code from insertnew.php into the index.php file; this is for the token that has been added for validation.
  7. Added a comment tag to `line 2`of the KML exports to tell if it was a Full DB/Users list/Single AP/All Users APs/All Signal for AP.
  8. Made the tables that hold the page one table so when there is a skew in the page doesn't get deformed like it did before. (I'm not a GUI person).
  9. Fixed some formatting issues with the install/upgrade/patching paths.
  10. For Security reasons temporally will be using hard links for the side menu, until further notice.
  11. Added a 'daemon' of sorts. This is optional upon install and changeable afterwards in the configuration file.
    Notes are in the Readme.txt of the tools folder.

Author: Phillip Ferland Version: 0.16 Build 1
Date: 2009-Mar-20
Changes :
  1. Started moving all HTML code outside PHP code.
  2. Fixed an error in the GPS conversion.
  3. Added a footer function to take over the "*THIS PAGE* has been last edited on..." at the end of all forms, to standardize it, seeing how it was on all forms anyway.
  4. Moved the "*THIS PAGE* was last modified on: YYYY-MMM-DD @ HH:MM:SS" to the bottom of the page in the bottom cell.
  5. Working on changing the layout of the AP fetch page. Soon it will be :

    1. ---------------------------------------
         Associated list
           |_> Signal history for that list
             |_> GPS points for that Signal
      ---------------------------------------
    2. Would like to have it so the GPS history is hide able via Java-script or something.
    3. So far the changes are, all the previous separate functions (fetch GPS, fetch associate list, and fetch signal) are all now one function (fetch AP).
    4. Unfortunately this is going to require a change in the back end. Previous databases will not be compatible with this update.
    5. Reason being, in the previous versions (0.14 & 0.15[all builds]) did not store the signal history row in the Users table.
      1. Old way ex 1,1-0,2-0,6-1,10-... / 0,6 : 0 is the update or new flag 1 = Updated AP 0 = New AP, the 6 is the AP ID number in the Database
      2. New way ex 1,6:1-0,2:2-0,6:3-1,10:1-... /
        0,6:2 ; 0 is the update or new flag 1 = Updated AP / 0 = New AP, the 6 is the Unique Access Point ID (UAPID) in the Database, and the 2 is the Signal History row number for the access point.)
  6. The users table holds all the list imports for each user.
  7. Fixed a bug when a search has no results, the page would output a PHP error, now it says "There were no results, please try again".
  8. Fixed an issue, where on install there would be an SQL error and fail to install.
  9. Added link to Last User on Index page.
  10. Cleaned up the tables on the new version page.
  11. Dates are now standardized as YYYY-MM-DD, to coincide with Vistumblers' save file.
  12. Fixed up the List KML export, there is a link to the KML file now.
  13. Finished KML export for entire database.
  14. Added option for a black background on the Signal Graphs.
  15. Empty Imports are no longer allowed (should have been like that since the beginning). Also if there were any empty imports, they will not be printed out on the All Users page.
  16. Added some friendly informational links.
  17. Set the default values for function variables, in case one value is left out.
  18. Initial code for Export Newest AP to KML is written, not tested yet.
  19. Added Export Page at /opt/export.php, also a link on the left hand side.
    1. Have Export users list to KML, all APs for a user to KML, export all APs in the DB to KML, and export a single AP to KML.
    2. Going to add the same for export to VS1.
  20. The warning for the install folder still being available was not added into the installer. It now is, and also in the upgrade too.
  21. Made the Default App internal time zone, GMT+0(Zulu).
    1. Soon you will be able to make the viewing time as your local time zone.
    2. greenwichmeantime.com
    3. wikipedia -< Greenwich_Mean_Time

Author: Phillip Ferland Version: 0.15 Build 80
Date: 2009-Jan-29
Changes :
  1. Small Code fixes that needed to be fixed. Most only showed up if verbose errors were on in PHP.
  2. Fixed Export to KML files from the Users List and Individual Access Points.
  3. Dates are now standardized as YYYY-MM-DD.

Author: Phillip Ferland Version: 0.15 Build 79
Date: 2009-Jan-24
Changes :
  1. Made a repair script to check the Storage tables for erroneous data, to replace or remove.
  2. Some other small typos and coding fixes.

Author: Phillip Ferland Version: 0.15 Build 78
Date: 2009-Jan-22
Changes :
  1. Extra include_once_onces for database.inc.php slipped back in.
  2. Install script had a bug with the Links table.

Author: Phillip Ferland Version: 0.15 Build 77
Date: 2009-Jan-11
Changes :
  1. Some headers had duplicate include_once_onces for database.inc.php.
  2. Fixed import of GPS points.

Author: Phillip Ferland Version: 0.15 Build 76
Date: 2008-Dec-20
Changes :
  1. There were a few major bugs in the install script that are now fixed.
  2. There was no Upgrade script in the install folder to do a safe upgrade from v0.14 to v0.15. Go to /install/upgrade.php.

Author: Phillip Ferland Version: 0.15 Build 75
Date: 2008-Dec-19
Changes :
  1. Added in a very basic (to start) search page, to search for Access Points.
  2. (Work in progress) Changing the GPS check so that it checks the DB for the GPS point and from there, if there is a return, point to that GPS, if not add it to the table.
  3. Added associated Import list for Access Points.
  4. Added in Security warning in case the /install folder is not removed.
  5. Added some more user input sanitation.

Author: Phillip Ferland Version: 0.15 Build 73
Date: 2008-Nov-28
Changes :
  1. Changed the import report page to have tables for the output, so that it is more organized and is easier to tell whether the access point is a new or updated.
  2. (Work in progress) Changed the GPS check so that it checks the DB for the GPS point and from there, if there is a return, point to that GPS, if not add it to the table.

Author: Phillip Ferland Version: 0.15 Build 67
Date: 2008-Nov-19
Changes :
  1. Added GPS history to Access Point Fetch page.
  2. Added View all APs for a given user.
  3. Fixed bug in the import_vs1 function where the page was not rendering right, even though it was importing correctly.
  4. Fixed a bug where the AP fetch page wasn't showing more than one row of signal history even though there was more than one.

Author: Phillip Ferland Version: 0.14
Date: 2008-Nov-14
Changes :
  1. Changed the All users list, so that it displays only the first ID for a user (which is considered the users Unique ID).
  2. Fixed an issue where randomly an AP would have more signal history points then GPS history points.
  3. Added installer for easy setup. Just go to /[WiFiDB path]/install/.
  4. Fixed a few more bugs/PEBKAC errors.

Author: Phillip Ferland Version: 0.13
Date: 2008-Oct-30
Changes :
  1. Rearranged functions.php into database.inc.php(all database related functions) and graph.inc.php (all graphing and image related functions).
  2. Fixed a few more bugs/PEBKAC errors.

Author: Phillip Ferland Version: 0.12
Date: 2008-Aug-19
Changes :
  1. Added in graphing for APs signal history, one row of history at a time for the moment.
  2. Added in Users Stats page to view what users have imported / updated what APs.
  3. Added in KML exports, right now it is just a Full DB export, soon to be added is Individual APs and groups of selected APs.

Author: Phillip Ferland Version: 0.11
Date: 2008-Aug-12
Changes :
  1. Fixed the issue where the signal history was getting corrupted and adding in way more signal points then there actually where for the AP. [functions.php-<import_vs1()].
  2. Added in a `Users` table to keep track of what users imported/updated APs.
  3. Added in `notes` for the group of APs to be added into the `Users` table, by the user upon import.
  4. Fixed most if not all CSS issues.
  5. Added `VS1` and `VSZ` folders to the `out` dir (exports soon to be added).

Author: Phillip FerlandVersion: 0.1
Date: 2008-Jun-10
Changes :
  1. This is a work in progress. Most if not all the features are in their infancy and need much work.
WifiDB v0.40 Beta | © 2008–2026 TechIdiots LLC. All rights reserved.
About | Contact | Privacy Policy | Terms of Use | Cookie Policy