GP GeoForum - https://sourceforge.net/projects/geoforum $RCSfile: gp_revhist.txt,v $ $Author: evilc $ $Revision: 1.134 $ $Date: 2007/02/10 21:47:06 $ 0.18.4 1) Import window now closes when you browse away from editing a location. 2) Link added to infowindow to download original import data. 3) XINHA WYSIWYG editor working again! Download a copy from http://xinha.python-hosting.com/ put it in the dir /xinha/ in the webroot of your site and turn it on in settings mode. See the instruction files for installing further info. To upgrade from 0.18.3: 1) Replace Files ================================================================================ 0.18.3 1) Fixed bug with inserting line where two would get inserted. This seems to be a *very* old bug, I have no idea how I didn't notice this was happening... 2) Import feature improved and re-introduced. Still supports ChtiGPS for GPS trace import. To upgrade from 0.18.2: 1) Replace Files ================================================================================ 0.18.2 1) Location discussion back in. Link is in infowindow as before. 2) Select User and Select Group popups are now templated. 3) Marker icons and overlay labels now preloaded. 4) Region Mouseovers (The borders around regions) now show when you mouseover it's entry in the sidebar. To upgrade from 0.18.1: 1) Replace Files ================================================================================ 0.18.1 Category Edit finally in! Good things come to those that wait... 1) A full-featured category editing GUI has been added to the back-end admin script. Add / Delete / Edit, etc, etc. Allows you to choose iconsets, labels etc for categories. 2) Has a full preview of all icons, complete with overlays, which updates as you make selections (no refreshing). Not fully langed up yet, but it's back end, so will only be seen by the admin. 3) New label added - a red and white X. If you see this over an icon it means GP cannot find the overlay label for that category. 4) Link to back end script added into settings mode again 5) The old form to change default iconset and default tempiconset now handles just the default tempiconset. I may make a version of with preview for the tempiconset at some point. To upgrade from 0.18.0: 1) Replace Files ================================================================================ 0.18.0 Major UI recode 1) Front end is now completely templated (gp_main.tpl). All UI elements are in templates, and as such can be styled with CSS. This includes popups such as waiting messages / bars. 2) Edit mode almost completely re-written. Now uses Google Maps draggable markers. Also, icons are now drawn for each point in a line and are draggable / deleteable. 3) Region mouseover GUI added. Build region mouseovers in a GUI or convert from real world data using bunchconv.php and then edit them in the GUI! 4) Point read script (gp_read.php) updated. Now able to handle being passed a grab box that straddles the date line. Now does not return empty set @ zoom 0. Subquery modes 0 and 1 had to be cludged somewhat, subq=2 mode is better. 5) Infowindow system re-coded. Adding posts to forums temporarily disabled Note that the infowindow components are now in the gp_main.tpl template so they can be styled too 6) "templateMode" introduced. Take gp_main.tpl, rename it to a .html file (say test.html) and put gp.js in the same dir. You can now run a simulation of the GP front end CSS etc without needing google maps or phpBB. Useful for setting up or styling the default layout. 7) Mode constants moved into template so that button order can be set on a per-template basis. To upgrade from 0.17.3: 1) Replace Files ================================================================================ 0.17.3 1) bunchvonv.php script in the tools section (For reducing point count of borders etc) has been vastly improved. It now uses a PHP implimentation of the Douglas-Peucker Algorithm kindly coded by Anthony Cartmell Also is able to decode TIGER and nearby.org.uk ASCII formats. Now displays preview line in a map window on the page. 2) XINHA WYSIWYG editor support updated, HTMLArea support dropped (Project is dead anyway). The word HTMLArea has been globally replaced with xinha. To upgrade from 0.17.2: 1) Replace Files 2) Drop your settings table and then run the gp_admin.php script to rebuild it. ================================================================================ 0.17.2 Bugfix release! 1) Apologies for 0.16.0 - 0.17.0, I forgot to include an icons dir or two... There should have been 'default' and 'labels' dirs in images/gp/icons 2) Current Temp IconSet textbox in gp_admin.php is now disabled as it should be. 3) The entries in the settings table introduced in 0.17.0 should be: default_iconset = 'default' default_tmpiconset = 'default' NOT default_icon = 'default' default_tmpicon = 'default' To upgrade from 0.17.1: 1) Replace Files 2) If needed, change names of keys in settings table as directed above. ================================================================================ 0.17.1 1) Default IconSet settings are now held in the settings table and can be set using the GUI in gp_admin.php 2) Please be aware that with categories, you can now leave the icon_set field blank to use the default category (Still no Category edit GUI, that should be next release) 3) SourceForge link and Revision History now appear with Version at the bottom. To upgrade from 0.17.0: 1) Replace files 2) Add entries in the settings table: (No quotes in the value, all lowercase) default_icon = 'default' default_tmpicon = 'default' ================================================================================ 0.17.0 New icon system! 1) Each category now has a "label" associated with it that gets laid over it's marker icon. 2) "Icon Set" files now live in images/gp/icons/ Main Icon Set files are called xxx.icon.php - see default.icon.php Temp Icon Set files are called xxx.tmpicon.php - see default.tmpicon.php These define sets of icons. 3) Main Icon Sets can be referred to in the Categories table eg, put 'myset' in the "icon_set" field for a category to tell it to use the icon set in myset.icon.php This enables you to use completely different icon sets for each category as well as a label ;) 4) Temp Icon Sets will be referred to in the settings table, for now, only "default.tmpicon.php" is used. 5) Added start of google maps geocoder section. 6) default API key set to localhost, not localhost/phpbb 7) Much more error checking. To upgrade from 0.16.0: 1) It is recommended that you drop your categories table. However, it would be possible to migrate it over, drop me a line if you need to (I doubt anyone will). 2) It is also recommended that you delete the entire images/gp/icons dir as the structure has changed, and then... 3) replace files ================================================================================ 0.16.0 Major Recode of front end! 1) Re-coded layout of front page. Now uses a template (gp_main.tpl). You should be able to get GP on your website much easier now... Default template uses CSS, but as long as all named DIVs are in the template, you could use tables or whatever. The winResize javascript function is part of the template so that all things to do with fluid layout are in one file. 2) Re-coded region and category heirarchical select boxes due to (1). 3) Some functionality lost for now (eg API Patch,API URL, phpBB support) as I havent had time to fit them back in. 4) Re-Grab and Cache lines (Red and Green) work *much* better now, even across date line. 5) Misc bug-fixes, code improvements... To upgrade from 0.15.5: 1) Replace files ================================================================================ 0.15.5 1) Fixed Edit Mode Google had made some changes to the API which broke it 2) New cleaner gp.php Still not that great and not Standards-compliant 3) Fixed missing space bug in gp_read.php which caused the reading of points to not work in subq=2 mode To upgrade from 0.15.4: 1) Replace files ================================================================================ 0.15.4 17th April 2006 1) Removed DEFAULT CHARSET = latin1 from gp_admin.php 2) added alternative, cleaner gp.php it is gp2.php, rename it to gp.php to try it. 3) Fixed tooltips To upgrade from 0.15.3: 1) Replace files ================================================================================ 0.15.3 27th March 2006 1) Wrote code to simulate the subqueries. Should now be much more compatible with various db servers. set use_subqueries to 2 to enable this method. 2) Bug fixed in gp_read for temp table method table was hard coded as phpbb_gp_regions instead of the GP_REGIONS_TABLE constant 3) Improved import routine. Importing a point no longer leaves a "Ghost" marker Internals generally cleaner 4) Default use_subqueries is now 2 Hopefully this should make it compatible by default 5) Improved API key settings page - more information. To upgrade from 0.15.2: 1) Replace files If GP wasn't working before, reinstall (or at least re-install the settings table by deleting it and re-running gp_admin.php) ================================================================================ 0.15.2 22nd March 2006 1) Had to re-write alternate version of main query to work on pre-mysql 4.1 servers without subquery support 2) Added support for SQL_BIG_SELECTS which some db servers may need 3) Misc bugfixes to get non-geospatial mode working There are now two extra settings entries (both optional) use_subqueries: Set to 1 to use subqueries (mysql only supports these in version 4.1+, same as geospatial ext) To see if you can use subquery mode, try executing this query in phpmyadmin: SELECT * FROM `phpbb_gp_locations` WHERE location_id IN (SELECT location_id FROM `phpbb_gp_locations` WHERE 1) If you cannot, then if you can execute this query, you can set use_subqueries to 0 to use temporary tables CREATE TEMPORARY TABLE test SELECT * `phpbb_gp_locations` Note that if this fails, it is a rights issue. Contacting your db host and asking them to allow the user to create temp tables may fix it. use_subqueries defaults to 1 if unset big_selects: Setting this to 1 will cause an extra query to be executed to up the select size limit. If you are having errors about too big a select size then setting this in the settings table may fix it. No GUI to set these yet, I am going on holiday tomorrow and just wanted to get a working version out. To upgrade from 0.15.1: 1) Replace files ================================================================================ 0.15.1 21st March 2006 1) Comments removed from SQL 2) Main points pull now reports error if there is one 3) Defaults to geospatial mode if no geo= parameter specified. 4) Added "SET SQL_BIG_SELECTS=1;" before main query - this is what was stopping it from working. To upgrade from 0.15.0: 1) Replace files ================================================================================ 0.15.0 16th March 2006 1) Dependancy on MySQL 4.1 with geospatial extensions removed You can now run GP in "Non-Geospatial" mode on any SQL server phpBB is compatible with. You will not be able to add lines, but all other functionality should work There may be an issue with searching with non-mysql servers, but this should be sortable To upgrade from 0.14.5: 1) Replace files ================================================================================ 0.14.5 15th March 2006 1) Cosmetic / Lang fixes to the search window 2) ChtiGPS import fixed 3) Importing while editing now works 4) Geometry field no longer disabled. You need to be able to copy and paste it to do region borders 5) Basic phpBB3 ("Olympus") support added. Install does not work, copy gp tables in and it displays though. Just a little play - proves phpBB3 compatibility is feasible. 6) Region names now escaped properly in XML. So now region names with an & in them will not break things To upgrade from 0.14.4: 1) Replace files ================================================================================ 0.14.4 27th Feb 2006 1) You can now turn locations into regions again. Silly semi-intentional bug, sorry lads... To upgrade from 0.14.3: 1) Replace files ================================================================================ 0.14.3 26th Feb 2006 1) Discussions started can now be continued in another session. Thanks Pierro for the bug report ! 2) Problem with resetting an edit form for a point not in view fixed. 3) Centre button in Edit Mode now works properly 4) Geocoding functionality now in - Able to use two at ws.geonames.org so far, but adding more should be easy 5) Child count is now correct when filtering categories - for marker tooltips only. Region Filter still shows full # of locations. 6) Point List renamed to Location List 7) Region Borders should no longer get stuck. They did before in the AJAX request for the border completes after the mouse left the icon To upgrade from 0.14.2: 1) Replace files ================================================================================ 0.14.2 26th Feb 2006 1) Non-Admin users now see the profile option Can't believe i set it so only admins could see it - D'oh !!! 2) When entering edit mode, the region select box defaults to what the filter is set to. 3) Detects firefox and sets select boxes 100% wide where applicable 4) Fix for API V2 > 2.35 at low (0-2) zooms implimented Default version is now V2 (current) with a GMap2 5) Infowindows now close on replot. 6) Bunch Point is now called "Region" - it just makes more sense to non techie users Bunch Mouseover is now called "Region Border" 7) Zoom select box in edit mode is now created to only have valid options in it. This should mean that IE is now just as compatible as FF is :) To upgrade from 0.14.1: 1) Replace files ================================================================================ 0.14.1 24th Feb 2006 1) Fixed seeking for locations. 2) Removed URL from import field on submit (it's pretty useless) Import field now URL encoded in AJAX call 3) Markers now cleared on zoom before trying to get new ones. 4) Mouseovers and popups cleared too as some where getting "stuck" 5) Worked around various IE bugs Select boxes are all not ideal widths as a result though - would like to find a solution here. 6) Fixed importing of links etc. Now makes a pointer and zooms in. 7) When not logged in, clicking Edit Mode now resultsi in a "Please log in to Add / Edit locations" message. 8) Internal Geometry box deisabled. 9) Blank infowindows no longer always show "Loading..." To upgrade from 0.14.0: 1) Replace files ================================================================================ 0.14.0 23rd Feb 2006 1) User profile in User can set default view and region filter. 2) Default View boxes disabled can only be populated with the "Here" button This is to stop people putting in silly values and it stopping the map from loading 3) Install process toughened. Checks if MySQL type db and whether MySQL version is >= 4.1 4) API Key setting code re-written 5) gp_admin.php should now be fully internationalisation compatible 6) You can now no longer add a point with a blank name or set an existing point to a blank name. 7) Lots of code moved from after end of AJAX call to inside AJAX call at end. This should make execution order more reliable. 8) Now tries to load HTMLArea file whatever - it won't try to init in the JS This means HTMLArea can be turned on or off without refreshsing. 9) Quite a lot of profile and settings changes do not actually need a refresh to see the effects. To upgrade from 0.13.4: 1) Replace files 2) Run the gp_admin.php script to install the new table ================================================================================ 0.13.4 23rd Feb 2006 1) All writes to the back end database are now verified properly 2) Read and write scripts use GET and POST vars respectively now Except the action parameter - that is always a GET var. 3) Infowindow no longer gets mangled on edit 4) Fixed going to settings mode from edit mode bug Caused JS crash 5) New Group select window in Lots of code that wasn't mine removed - yay ! Less data passed to JS on page load 6) Edit Root Permissions in Admin can edit the permissions of "The World" in the settings menu To upgrade from 0.13.3: 1) Replace files ================================================================================ 0.13.3 22nd Feb 2006 1) Settings mode fixed See (2) 2) Region pull back to asynch It was breaking the settings table, workaround for editmode found, though a little clumsy. To upgrade from 0.13.2: 1) Replace files ================================================================================ 0.13.2 22nd Feb 2006 1) Admin rights for regions now filter down to child regions. So if you are in the userlist or grouplist for UK , you can edit any location in the UK (But not the UK region itself) 2) Regions pull is now Synchronous rather than Asynchronous (AJAX) This should make no difference to the handling of the program, but makes my life easier. So now, when something sets the value of a region drop-down box, the command after will execute only after the box is actually changed. To upgrade from 0.13.1: 1) Replace files ================================================================================ 0.13.1 21st Feb 2006 1) Reworking of sidebar. Widths of stuff now based upon the width of the sidebar. HTMLArea ?bug? stops HTMLArea rendering below 300px wide, so when HTMLArea is on, the sidebar is 335px wide. When HTMLArea is off, sidebar is a more reasonable 285px wide 2) Reworking of self-generating drop-down boxes. They now take up 100% of available width. 3) Fixed bug where flicking in and out of edit mode or clicking edit mode multiple times caused a hang To upgrade from 0.13.0: 1) Replace files ================================================================================ 0.13.0 21st Feb 2006 1) Tooltips now show for locations as well as bunches. Changed something a couple of versions back and didn't realise the implications. 2) Name field from regions table dropped - name field from locations table was only needed. 3) Search function in. Searches on Name and Infowindow fields. 4) Edit and Settings boxes revamped 5) Default Region setting in This will set the default region on load 6) Default View setting in This will set the default view on load If unset, the default view will be where the default region drops you. 7) Mode Displays tidied up Bit of a more consistend look and feel 8) New help system in Expanding Divs instead of popups To upgrade from 0.12.6: 1) Replace files 2) Execute the following SQL on your database: ALTER TABLE `phpbb_gp_regions` DROP `name`; CREATE FULLTEXT INDEX search ON `phpbb_gp_locations`( name , infowindow ); INSERT INTO `phpbb_gp_settings` VALUES ('default_lat', ''); INSERT INTO `phpbb_gp_settings` VALUES ('default_lng', ''); INSERT INTO `phpbb_gp_settings` VALUES ('default_zoom', ''); INSERT INTO `phpbb_gp_settings` VALUES ('default_region', '1'); ================================================================================ 0.12.6 19th Feb 2006 1) New user picking system for region permissions Uses the phpBB user search function. Now properly themed to phpBB and internationalised. 2) Bunch mouseovers no longer get mangled when you edit a location 3) User names no longer passed to JS on load 4) Minimal user settings passed to JS on load To upgrade from 0.12.5: 1) Replace files ================================================================================ 0.12.5 19th Feb 2006 1) Fixed infowindow bug. You can now edit existing data in the infowindow. 2) Dual-version compatible Trying to be ready for the API stabilising out. Code now tries to detect when something will fail (ie check if needs .lngDegrees or .x) 3) New settings passable via URL: apiver: set the API version: defaults to 2.35 atm gm2: set to enable GMap2. Do not set to enable GMap Useful for debugging (More accurately when asking people for help on conversion issues) 4) Debug window now doesn't show for "normal" users if enabled. 5) Misc other fixes, tidying of code - lots of unused variables removed. To upgrade from 0.12.4: 1) Replace files ================================================================================ 0.12.4 18th Feb 2006 1) All references to XMaps completely removed from install and all code. 2) Fixed bug with default welcome_html not being valid (\\'' instead of \') This caused the welcome_html entry not te get made at all. 3) Hopefully fixed the annoying bug stopping you from selecting stuff you selected before zoom in. 4) The admin can now set the Region Forums via the settings mode GUI To upgrade from 0.12.3: 1) Replace files ================================================================================ 0.12.3 10th Feb 2006 1) Bugfix - gp_admin.php now creates the locations table with the required category_id field 2) The "main grab" (ie the points pull routine) only includes the needed data to handle view mode. The data needed for editing is now obtained via specifying &locid=x in a normal points call. This happens when you click on the marker in edit mode. 3) The infowindow is pulled when you click on a marker in view mode or edit mode. 4) Bunch_mouseover data is called via AJAX on mouseover. 5) Did a bunch of tidying up of the code. Broke up a bunch of big functions into smaller ones. Code should now be easier to understand. To upgrade from 0.12.2: 1) Replace files ================================================================================ 0.12.2 9th Feb 2006 1) Overlay functionality removed. When using the icon "base" as the shadow, there were ordering issues Eg the overlay would go over the icon of an overlapping marker. So - Each category marker is now a directory with copies of each marker in it. 2) Categories "overlay" field now points to the dir that the category of icon is in. This is a dir in images/gp/incons/ There are two supplied demo icons - "tree" and "flag" To upgrade from 0.12.1: 1) Replace files ================================================================================ 0.12.1 31st Jan 2006 1) Markers changed The various combinations of loc (point, line) and bunch (children, no children) along with editable (black border) and non-editable (red border) are now combined with the background and shadow. this enables... 2) Custom markers in. Each category can have a transparent image (png, gif) as an overlay to it's icon. set the overlay field in the categories table to the name of an image in the images/gp/icons/ dir 3) Add / Edit button weird behaviour bug fixed It's all basic, but from a user's perspective - it all works To upgrade from 0.12.0: 1) Replace files - re-upload the lot, there are some new ones You may delete the icons in the images/gp directory - DO NOT delete the newly-created icons directory 2) execute in phpmyadmin: ALTER TABLE `phpbb_gp_categories` ADD `overlay` VARCHAR( 50) NOT NULL ; ================================================================================ 0.12.0 29th Feb 2006 1) Categories are now in ! No facility to edit category names yet, use phpmyadmin for now 2) Did some cleaning up of the interace. To upgrade from 0.11.10: 1) Replace files 2) execute in phpmyadmin: ALTER TABLE `phpbb_gp_locations` ADD `category_id` INT( 8 ) DEFAULT '0' NOT NULL ; 3) run gp_admin.php to add the new table ================================================================================ 0.11.10 29th January 2006 1) re-wrote editing system a fair bit - should be more robust now. 2) Quite a lot of internal tidying up of code To upgrade from 0.11.9: 1) Replace files ================================================================================ 0.11.9 24th January 2006 1) Editing of lines back to how it was pre V2 change (Polylines you are editing disappear while the temporary edit lines show) To upgrade from 0.11.8: 1) Replace files ================================================================================ 0.11.8 23rd January 2006 1) Fixed bugs with username or user data causing GP to not run. This should pretty much nail this one once and for all. All user data getting passed to GP is now run through rawurlencode to remove dodgy characters To upgrade from 0.11.7: 1) Replace files ================================================================================ 0.11.7 22nd January 2006 1) Moved from my rubbish debug window to the new one in Google Maps API 2) Loading messages in map window to let you know why you are waiting 3) Each request for points now has a unique id This should stop old requests getting plotted if you zoom in too quick To upgrade from 0.11.6: 1) Replace files ================================================================================ 0.11.6 21st January 2006 1) Tooltips look right in IE now 2) Region branch import files changed format. uses POINT(x y) or LINESTRING(x y,x y,...) instead of Lat and Lng feilds this enables us to import / export line regions too 3) Export region branch feature added. It is recommended you build a region tree on a dev server to make sure it doesn't have unwanted bits in it. To upgrade from 0.11.5: 1) Replace files ================================================================================ 0.11.5 20th Jan 2006 1) Cacheing of offscreen items, grab on move out of green box all working again 2) Start of region branch exporting in No actual code to do the export, but menus etc all set up in gp_admin.php 3) Icons now pre-cached on load. This should speed up IE. To upgrade from 0.11.4: 1) Replace files 2) Delete templates/SubSilver/admin/gp_settings_regbranch.tpl - it is relpaced but gp_settings_rb_import.tpl ================================================================================ 0.11.4 19th Jan 2006 1) Minor changes to tooltips code 2) No longer have red temp markers left over after making a line To upgrade from 0.11.3: 1) Replace files ================================================================================ 0.11.3 19th Jan 2006 1) Tooltips working ! Coded them myself, no need for Xmaps 2) New tool included in extras: bunchconv.php Put this somewhere on your webserver and use it to clean line data for bunch mouseovers. Only used if you are making bunch mouseovers en masse / importing from geo data. To upgrade from 0.11.2: 1) Replace files ================================================================================ 0.11.2 18th Jan 2006 1. Bunch Mouseovers can now have multiple segments Separate them with : eg x y,x y,x y:x y,x y,x y 2. Fixed Bug: Markers and polylines now clear properly and infowinfows work once zoomed. To upgrade from 0.11.1: 1) Replace files ================================================================================ 0.11.1 16th Jan 2006 1. Corrected comments in gp_read.php for point read SQL script 2. Can now hide markers, working on hiding lines. 3. Start of bounds stuff getting re-done Can draw bounds properly PVM now called properly again if view moves outside bounds To upgrade from 0.11.0: 1) Replace files ================================================================================ 0.11.0 15th Jan 2006 1. Moved to Google Maps API V2 Lots of changes in V2, so I had to disable / change some stuff. Sort of a step backwards to be able to take a step forwards. 2. Tidied up point read SQL commenting This should meake the BIG query easier to understand. Click the + next to points below the map to see it. Disabled (Due to V2 issues): 1. Hiding of regular markers when editing. 2. Culling of points pulled by viewport 3. Bounding box drawing (Boxes showing boxes (2) uses) To upgrade from 0.10.6: 1. Turn off XMaps in the settings (set xmaps_url box clear in settings table) 2. Upload the new files. 3. Execute the following SQL in phpmyadmin: UPDATE `phpbb_gp_regions` SET zoom = 17-zoom You can execute this again to change data format back to 0.10.7 ================================================================================ 0.10.7 1. XMaps is now optional Is off by default. You may optionally get an xmaps js file and put it in the gp dir. Then set it's name in settings mode. Clearing name in settings mode turns it off. 2. Icon images added in images/gp Extras dir added in the zip with PSDs of the icons so you can make custom ones. 0.10.6 11th Jan 2006 1. Format of region branch file changed: Separator is now ; not , 2. Extra field added at end: bunch_mo - for mouseover polygon coordinates. bunch_mo field can be empty 0.10.5 9th Jan 2006 1. Fixed Reset button in edit mode - now removes markers and lines properly 2. Editing of Welcome HTML text now do-able from Settings Mode 3. Tweaked some of the AJAX code - data now escaped (eg %20 instead of space) when sent to gp_write.php 0.10.4 6th Jan 2006 1. Added "added" feild to locations table - the date each location was added. update existing installs with: ALTER TABLE `phpbb_gp_locations` ADD `added` DATETIME NOT NULL ; UPDATE `phpbb_gp_locations` SET added=now() 2. Re-added in region branch import code - somehow the update_children function had disappeared 3. gp_rss.php now orders locations based upon date added not location_id 0.10.3 5th Jan 2006 1. Fixed bug (introduced in 0.10.0 due to the index on the point field) that was stopping pulling of points if there was a linesting in the data set. 2. Should have nailed infowindow special character issues (eg +, & etc). 0.10.2 4th Jan 2006 1. Infowindows should now support foreign characters and other such stuff ( eg ë ) This is a precursor to fixing the bugs with ' in name and other such things too. 0.10.1 3rd Jan 2006 1. Admin script (gp_admin.php)can now import region trees from CSV text files. example regions.uk.txt included. All SQL files now removed from install package. 2. Admin script can now set API key. 3. RSS support via gp_rss.php courtesy of pierro78. Thanks ! 0.10.0 30th Dec 2005 1. Added gp_admin.php script This will allow you to do an install without needing phpmyadmin or such. It also means that the user need not be concerned with database prefixes and such. 2. Slight DB changes. To update an existing DB with the changes, run this SQL using a tool such as phpmyadmin: ALTER TABLE `phpbb_gp_locations` CHANGE `point` `point` geometry NOT NULL ALTER TABLE `phpbb_gp_locations` ADD SPATIAL INDEX(point); 0.9.8 28th Dec 2005 1. Added security to write script. Will now terminate if user is not logged in. 2. Admins now see Settings mode as well as View and Edit All settings except those required to get the map working (API Key etc) and the welcome HTML settable in here. Cannot do the API key in the js like this as I use GXMLHttp AJAX to communicate with back end. Welcome HTML will be settable (hopefully using HTMLArea) but requires a bit more work. 0.9.7 28th Dec 2005 1. Fixed bug in gp.php, used 25 causes mousein and mouseout to be called twice for any given icon. So... 3. Workaround: Inserted code to detect the last mousein or mouseout and ignore if same as currnent one. 4. Moved from 2 map click listeners (one in edit mode, one in init) to one (one in init) One in init now checks to see if in edit mode after opening infowindow, and if so, do the stuff that was in the edit mode listener. 5. Coordinates now limited to 6 decimal places. Existing points in database not modified unless you edit them and submit again Existing Bunch Mouseovers will not be re-done by doing this. New lines built will be 6dp. 0.7.1 7th Dec 2005 1. Fixed Bug: Bunch mouseovers for line locations now actually set in the database rather than being lost. 2. When editing a region, on hitting submit it will no longer ping you up to zoomlevel 16. 3. Changed wording of Zoom Through link to be a bit more user-freindly 0.7.0 3rd Dec 2005 Quite a major recode of bits. 1. Line Editing in. Lines can now be edited in a GUI. 2. Box to edit Bunch point MouseOver added. You can use the line edit tool to build an outline, then copy and paste it into the bunch mousover box. Do not change the bunch point to a line, build it and paste ! Build it, reset, select bunch point and paste bunch mouseover into box. A bit clunky I know but it works. 3. Infowindows tidied a bit order changed (zoom through at top) horizontal rules added to divide things up better Directions section now looks better. 0.6.4 30th Nov 2005 1. GUI to change region permissions is in. Adapted from code by pankajm@writeme.com credit where credit is due... 0.6.3 29th Nov 2005 1. Fixed bug: Region Filter sticking on "The World" 2. Fixed bug: Text in infowindow being too big when linking to a location 3. Fixed bug: "To Here" not showing as link correctly 0.6.2 28th Nov 2005 1. Fixed Anonymous user able to enter edit mode bug 2. Fixed some bad divs etc in gmaps.php 3. Horizontal resizing now works a lot better. 0.6.1 25th Nov 2005 1. I finally bit the bullet and learned CSS and how phpBB impliments it. Again, no fundamental code changes, just a lot of visual alterations and layout changes. 0.6.0 25th Nov 2005 NO CHANGES IN FUNCTIONALITY - CODE REORDER ONLY 1. Most of the Javascript in gmaps.php is now in gmaps.js 2. Tidied loads of code, removed unused variables etc. 0.5.1 25th Nov 2005 1. Tooltips added ! Found a nice technique at http://www.texsoft.it/index.php?c=software&m=sw.js.htmltooltip&l=it Not 100% sold on it but it is much better than loads of text in the edit window 2. Automatically generated source code link is back. At the bottom, below the map. 3. Log in / register links fixed. 4. Settings table changed - name changed from index to primary key 0.5.0 24th Nov 2005 1. Database format changed: Regions table: feild adminlist (TEXT, NOT NULL) renamed to grouplist feild userlist (TEXT, NOT NULL) added 2. Region persmissions working: regions now have two feilds for permissions: grouplist and userlist. grouplist is a comma seperated list of group IDs (phpBB defaults: 1=Anon, 2=Admin, 3=??, 4+ are user added groups) userlist is a comma seperated list of user IDs. leaving either feild blank means do not restrict access Suggested use: Set the grouplist field in "The World" and any region you dont want users to be add locations to 2. Then only admins will be able to add points or regions to that region. There is no interface to set this yet, use phpMyAdmin or similar 3. Sample data changed. UPGRADE INFO * In regions table, rename adminlist to grouplist and set any with a value of "evilc" to "2" (or blank) * add the userlist feild at the end (TEXT, NOT NULL - same as grouplist) - leave them all blank. * only php to change is xmlgen (just changed version number in gmaps.php to make it show right version above map) 0.4.6 24th Nov 2005 1. Users may now switch between the point list side panel and the help mode sidepanel 2. Bugfix: Edit boxes will now appear if you flick back and forth between view and edit mode. 3. Settings are now stored in the settings table. BE SURE TO UPLOAD THE NEW TABLE AND ADD THE CONSTANTS.PHP ENTRY IF UPGRADING !! No interface to edit the settings yet, use phpMyAdmin for now. 0.4.5 24th Nov 2005 1. Anonymous (non logged in) users can now see points again (no, really this time !) 2. View History now in. Shows below the map. Sort of like a browser history / back button for the map. 0.4.4 23rd Nov 2005 1. Anonymous (non logged in) users can now see points again (bug introduced in 0.4.3) 2. Format of the locations table changed. feild "point" now defaults to null This is needed since I added a DISTINCT clause to the SQL select. To update your table, execute the following in phpmyadmin or such: ALTER TABLE phpbb_gm_locations MODIFY point geometry 3. Sidebar added ! Users can now select and zoom through points using the sidebar. It can be enabled or disabled by setting the $sidebar_on variable in gmaps.php 0.4.3 22nd Nov 2005 1. Optimised point select routine, now does not do seperate select to get username of point owner. 2. In edit mode, you can now see points you don't own, but you can't edit them. A red border on an icon indicates you cannot edit it. 3. Admins can now edit any point (even if it has a red border) 4. Location icons are now blue not red, so you can see the red border. 0.4.2 22nd Nov 2005 1. Infowindows now set to constant size properly with scroll bars automatically generated if needed. 0.4.1 19th Nov 2005 1. Quite a lot of refinements to the marker plotting routine. Working towards some optimisations (especially in IE) here... 2. Directions are in !! Route to or from any location. 3. Fixed broken infowindows in IE but it is still slow :( 0.4.0 18th Nov 2005 1. Added "Bunch Mouseovers". A new field has been added to the locations table: bunch_mouseover This is a coordinates string in lng lat, lng lat, lng lat... format (ie same as a path) If non-null, this will be rendered as a polygon when you mouse over that region, in addition to the text mouseover. There is currently NO INTERFACE TO ENTER THESE LINES. With PHPMyadmin, it is also hard to edit the locations table because of the GeoSpatial data in the "point" field. To add data use SQL like: UPDATE `phpbb_gm_locations` SET bunch_mouseover='0.0906 51.6878,0.2911 51.5634,0.2362 51.4266,0.1483 51.3597,0.1483 51.2962,-0.11260 51.2601,-0.2114 51.25675,-0.3405 51.31344,-0.4119 51.3048,-0.5493 51.4180,-0.4888 51.5019,-0.5438 51.5804,-0.4394 51.7100,-0.2719 51.7185,-0.2279 51.6878,0.0109 51.6776' WHERE location_id=17 This is the SQL I used to add the demo London bunch mouseover ( http://www.evilc.com/phpbb/gmaps.php?action=seek&seekmode=location&location_id=17 ) To get your own coordinates, an easy(ish) way is: a) Open notepad with a blank document. b) Go into edit mode c) Select a point, then copy the lng (top box) value, copy and paste to notepad, hit space in notepad, then copy and paste in the lat (bottom) value. Hit comma in notepad (DO NOT HIT SPACE AFTER) then repeat (b) and (c) to build up your line in notepad Once done, you can opy and paste the line into IMPORT and hit SHOW to view it. If you are happy, insert it with SQL. 2. Demo data changed. Took a copy of the data on evilc.com 0.3.1 18th Nov 2005 1. opening a link (eg http://www.evilc.com/phpbb/gmaps.php?action=seek&seekmode=location&location_id=17 ) should now pop up the infowindow for that link as well as centering and zooming on it. 0.3.0 17th Nov 2005 1. Added support for the open source HTMLArea WYSIWYG editor. 2. Re-jigged the edit window layout. It's better now in htmlarea or regular mode and it has instructions. 3. Better install instructions 4. Fixed bug that was mangling HTML entered for infowindows 0.2.4 14th Nov 2005 1. The link in each marker's InfoWindow now zooms to a better zoom One above disappearing point for bunch points, zoom 2 or the region's zoomlevel for points, whichever is least. 2. InfoWindows for bunch points now have a "Zoom Through" button which will zoom you through that region too see it's child regions 0.2.3 14th Nov 2005 1. Lines as bunch points (regions) now properly enabled (ticking bunch and hitting edit had no effect before) 2. When navigating to a region (that is a line) using the menu, you will be dropped at the END of the line not the start. This is so that, for example, like Google Maps has the names for the smaller US east coast states (eg RI, CT, NJ etc) you may have a region where the marker is in the sea, with a line pointing to the state. When you select the region, you will be centred and zoomed for the end of the line (The state) not the start (the sea). 3. Zoom is now correctly updated for lines. 0.2.2 12th Nov 2005 1. Zoom selecter now restricted to values that are between it's parent and children. This should stop users being able to make things not visible. At the moment, this only works on IE7+ and FireFox. IE6 does not support disabling of entries in drop down boxes. Possible solution found at http://www.lattimore.id.au/2005/07/01/select-option-disabled-and-the-javascript-solution/#comment-1282 but I couldn't get it to work. 0.2.1 12th Nov 2005 1. Fixed bug where region select box would no longer navigate you after editing regions. 2. Removed unsightly table borders I forgot to remove whilst setting up page. 0.2.0 12th Nov 2005 1. Users can now add / edit / delete regions (bunch points) and move them from one region to another. You must make a point first, then edit it, tick the bunch box and select a zoom level for the region. Be VERY CAREFUL setting the zoom level, get it wrong and you may not be able to see it. Editing the region's zoom value to one less than it's parent will generally fix this. If moving one region to another, be extra careful with the zoom drop-down... --- FUTURE PLANNED FUNCTIONALITY --- 2. Ultimately, you will be able to set a write permission list for these regions ie specify usernames or usergroups of people who can add points / paths / regions to this region. It will be advised to set all of your upper regions (eg "the world", "UK", "England") to admin write only so users cannot add points and regions at the highest level - they must enter them in the "leaf" regions. The ultimate idea will be to pick an admin for each region and let them moderate that part of the world. They will be able to grant permissions to other people for a smaller part of that region. Eg you (admin) have rights to "The World", you give user "hank" rights to region "USA" so he can create states, he creates the region "Texas" and gives user "JR" rights for that region. Meanwhile you give user "Claude" rights to region "France" and he can add french sub-regions as he wishes. 0.1.7 6th Nov 2005 1. Changed file names. 0.1.6 6th Nov 2005 1. gm.php now correctly recognises if you are logged in or not 0.1.5 23rd Oct 2005 1. Integrated into phpBB instead of XMB Just in and working for now, making it conform to coding conventions etc comes later. There are probably problems I don't know about, but hey, not bad for a couple afternoon's work, esp seeing as I have never modded phpBB before ;) Based upon Gmaps XMB version 0.4.2 0.4.2 21st Oct 2005 1. Specified maps.25.js as maps.26.js breaks XMaps. with .26, Infowindows will not open. 2. Moved from static icons to combineStyles in XMaps. 3. Changed nav value to "Google Maps" instead of "Administration" 4. Add make bunch tickbox to edit point window (nonfunctional) 0.4.1 19th Oct 2005 1. Fixed icon colour-coding code to discern between points and empty bunch points. 2. Fixed mouseover to only display children (in brackets) if it is a bunch point 3. Tidied up start page 0.4.0 18th Oct 2005 1. Version numbering system changed to a better one 2. As in 0.33a, a region's Zoom value is now "Bottom Up" (ie it will display from 0 up to the number specified) This means that new bunch points can be tacked on the bottom as needed. 3. Design flaw in point select SQL corrected. New SQL a little inefficient but it still does it in one query. Now regions can have children with different zoom values and things won't go crazy. 4. a location's represents_region field is now 0 if it does not represent a region, not NULL. This may change back but was a needed change to make my fix for (3) work. 5. New links below the map for no xml version of the AJAX call, these are accessed by clicking the + link next to the relevant ajax call link. The one for points will display the SQL being used by gmaps_xmb_xmlgen.php currently. 6. Download directory changed 7. Added firefox link 0.33a (Broken development version) 1. Zoom changed other way around. 0.33 1. Moved field to tie a bunch point to a region from the regions table to the locations table. 2. Updated xmlgen script to return = of children for regions 3. Added # of children in brackets after name in mouseover for bunch points 4. Bunch point icons are now different to point icons. Dark green for empty, light green for populated. 5. Region names in region filters now have # of points after their names in brackets 6. misc bugfixes in xmlgen 7. Corrected some link errors in gmaps_help.php 0.32 1. Name change again. Path / Paste is now called "Import" 2. Added gmaps_help.php with help on the import box 0.31 1. Path box in edit renamed to Path / Paste 2. You can now paste in points again properly 3. You can now paste a link from google maps or multimap into the Path / Paste box and it will work out the coordinates from the URL 0.30 Misc bugfixes 1. when linking to a point, zoomlevel will no longer be messed up - when you click edit the point will remain. 2. Optimisation of when PVM is and isn't called 0.29 1. Admin field added to header section of region XML. value = 0 : User does not have admin rights to add locations in this category value = 1 : user has admin rights to add locations in this category 2. Extra field added to regions table - adminlist. This is a standard XMB style access list (comma separated list of users). Empty = anyone cam add. This will be compatible with my membergroups mod. 3. Edit location fields will only appear if the user has rights to the selected region. 4. the upshot of (1), (2) and (3) is that you can now restrict adding of locations by general users to only certain regions. Useful, for example for stopping people adding to the top level (ie "The World", "UK" etc) regions. 5. Now uses XMaps 1c 0.28 1. Fixed bug where if you linked to a location, on page load it would go there but then go to the location of the region it started in ("The World") 2. Changed demo data to be compatible with pasting into XMB "Insert SQL" function 0.27 1. Changed "All" in Filter select to name of current region. 2. Tidied up debugging output at bottom of screen, added link to regions XML 3. neatened up layout a little. Edit menu is now thinner 0.26 - Firefox 1. Add and Edit modes are now one and the same. Another big duplicate chunk of code wasted :) 2. Dynamic Add / Edit / Delete / Reset buttons. Buttons appear and disappear as needed. 3. All known FireFox issues solved. FireFox now the preferred browser as it is much quicker at plotting points. 0.25 1. Selecting a region in the region filter will centre and zoom you to that region. Also useful as a quick navigation tool ! 2. Tweaked base data a little 0.24 - Links ! 1. Bug fixed in xmlgen - tables were hard-coded in query. 2. New link functionality ! gmaps.php can be passed info in the URL Initially implimented is a seek function which will pull the coords of a point and centre on it on load. 3. created by: entry in infowindow is now a link to the creator's profile in XMB 4. There is now a link in each marker's infowindow that will create a link using (2) Copy the link in a marker's infowindow and paste it into a message board post to discuss it ! 0.23 Tidy-up release 1. All occurences of category, categories etc have been renamed to region, regions etc. This includes in the xml, variable names etc etc. 2. Banner removed. 3. Get region code for the main filter above the map and the region select in the add / edit box is now the same function getRegion. This function makes a select box in the specified form in the specified div. 4. Interface tidy-up, div names changed and more understandable 5. Size of map div now hardcoded to 640x480 Now works with Firefox !! 0.22 1. Removed minzoom, maxzoom from point transfer protocol. 2. Removed minzoom, maxzoom from point add / edit. 3. Reverted back to addoverlay method from addoverlays as it seems quicker now. 0.21 Quite a major re-write. 1. Using category engine for regions now, so some renaming Categories will come back later as an extra filter probably. 2. Moved to nested set, or "mptt" regions The entire SQL for pulling visible points given all filters is now one *big* query. 3. Maxzoom and minzoom for points now gone, the zoomlevels a marker appears at is now decided by the region it is in. 4. Changed database format and changed categories to regions table. 5. XML format is essentially the same. Maxzoom and Minzoom are generally edited out or set to zero as they dont do anything. 6. Regions can be uploaded with the provided gmaps_xmb_admin.php script provided. This will ultimately be a system to "patch" region sets in with centoids or boundaries etc as they become available. See the format of the demo CSV file, or use it. use the admin page to import the file then use it again to update the imported adjacency list format to mptt converter. It is in it's infancy, use at own risk ! 7. Centoids for every county in England. County list should be accurate to present day, centoids are a bit haphazard. It's easy to move them around though. 0.20 1. Major rewrite to gmaps_xmb_xmlgen.php Data format between it and gmaps.php unchanged though. 2. Change of database format for xmb_gm_categories. Min and Max zoom as a part of a location abandoned. Categories now have a min and a max zoom instead. 3. Min and Max zoom on points table not removed yet, just does nothing. 4. Category selecter at top of screen currently does nothing. Will change it to centering and zooming on selected region maybe. It is not really needed any more there as categories are auto-selected based upon zoom now. 0.19 1. Optimised marker plotting / edit routines. The point and line arrays are gone. Extra data is now stored on the overlay so that when you click it all data is available to the edit routine by querying the overlay clicked 2. Polyline plotting bug fixed. Lines were being plotted for each point. Lots of overlapping lines, I never noticed... 0.18 1. Made fix to gmamps_xmb_write.php - had forgot to update infowindow when editing a line. version 0.18 of gmamps_xmb_write.php is compatible with pre Xmaps versions (ie 0.17) FYI 2. Changed some colours 3. Changed demo location data to make a better path demo. Has instructions and links too. This version of xmb_gm_locations.sql is compatible with all versions back to 0.13 (Introduction of geometry type) 0.17x - unreleased dev version 1. Integrated Chris Smoak's XMaps Google API Extension Library into project. Icons and lines are now rendered by XMaps 2. Mouseovers added for icons (Provided by XMaps) 3. Moved "Grab" area from he edge of the viewport to 0.5 screens away. Now if you can see the green "grab" line when you release the mouse on a grab, the points will be re-grabbed 4. Different colour icons for points and lines 0.17 1. Clicking on the start point of a line in Add / Edit line mode no longer removes the start point. Use Reset instead. 2. Documentation split into two files: install.txt - Installation instructions gm_revhist.txt - Revision history This saves having to add rev history to gmaps.php every time, I will just link it. 0.16 1. You can now paste paths in chtiGPS CSV format into the "Path" box in add / edit mode. ChtiGPS is a free GPS logger for PocketPC - http://www.chtisoft.com/ Support for other formats should be easy to add now - all text pasted into the "Path" box is run through the textToWkt() function 0.15 1. Realised I got lat and lng the wrong way around - x,y coordinates are lng,lat not lat,lng. All files have changes. I think I got it the right way around now. Database data is correct though, things actually stored right, just I had my names switched in the code. Add / Edit line format is lng lat,lng lat,lng lat not lat lng,lat lng,lat lng.. 0.14 1. Add / Edit line is working - basic implimentation. 2. "Show on Map" button added - Will show on the map the contents of what has been typed into the box for add / edit line or point. 0.13 1. point field is now a GEOMETRY type. 2. Lines encoded in the LINESTRING format in the point field will now be rendered as polylines ! The start point will be rendered as a point too and it holds the infowindow. There is no functionality yet for adding/editing a line, but lines added to the SQL database via other means (eg phpmyadmin) will show. Do not try to edit any points you may add this way, I am not sure what would happen. 3. SELECT for point grabbing SQL now uses Intersects() to tell if any part of a polyline or point falls within the viewport. So now caching only what is on / near the screen now works for polylines, even if the line only clips the viewport and no points fall in it. And best of all, MySQL handles all the nasty calculations ! All kinds of geekiness can now ensue ;) 0.12 1. Changed lat, lng fields into a MySQL OpenGIS Extensions Spatial format field. At the moment, it is a POINT type field but next task is to move it to a GEOMETRY type field so one table can hold points AND lines. This will open the door wide open to pulling points / lines within a polygon, finding areas of polygon, distances of lines etc etc all from MySQL queries ;) 0.11 (Unreleased development version) 0.10 1. User id for points now actually works and some other people apart from me (userid=1) may actually be able to add points properly ! 2. Exploit fixed: if you flick to edit mode, other user's points disappear to stop you editing them. If you were quick enough you could click edit, click another user's point before it refreshed and edit it. The database add script now checks current user's id against that of the owner. 3. In Edit, when moving a point, clicking on the original point or the proposed new location will now clear the proposed point and resets the lat/lng values (only) in the form. Reset still does this, but resets the whole form. 4. point cache introduced in 0.8 now holds marker objects too 5. Adding / Moving point does not re-draw points until submit now. 0.9 1. More fixes to the pre-caching algorithm 2. Different colour icon support added. 3. In edit mode, when moving a point, a polyline now appears from the old point to the new point. The new point is also now a different icon 4. Guide boxes now shown: a) Green box - when map points are grabbed from back end db, green box is drawn around where the viewport was. Panning the screen so that the centre lies outside this box will cause points to be re-queried b) Red box - This shows the limit of the cached points. Nothing outside this box was grabbed. Unless you have multi-monitor support or a high desktop resolution you will probably never see the red box though as it is hard to pan that far in one drag. 5. Cacheing reduced to one screen in each direction 0.8 1. Now caches two screens in each direction of the viewport 2. Will not re-get points unless the viewport moved half a screen or less since the last grab or zoom changed 3. Points are now cached in local memory 4. Removed some calls to server my looking at points in memory 5. All calls to back end db are now asynchronous