root/trunk/wifidog-auth/ChangeLog @ 682

Revision 682, 37.2 KB (checked in by fproulx, 8 years ago)

2005-07-25 Francois Proulx <francois.proulx@…>

  • Added Geocoders
    • /classes/AbstractGeocoder.php
    • /classes/Geocoders/GeocoderCanada.php
    • /classes/Geocoders/GeocoderUsa.php
  • This will be used for enterring GIS data
  • Coming in the next few days : set hotspot gis using Google Maps + Geocoding
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
12005-07-25 Francois Proulx <francois.proulx@gmail.com>
2        * Added Geocoders
3                * /classes/AbstractGeocoder.php
4                * /classes/Geocoders/GeocoderCanada.php
5                * /classes/Geocoders/GeocoderUsa.php
6        * This will be used for enterring GIS data
7        * Coming in the next few days : set hotspot gis using Google Maps + Geocoding
8               
92005-01-25 Pascal Leclerc  <pascal@plec.ca>
10        * Fix hardcoded images path in classes/MainUI.php
11
122005-07-25 Francois Proulx <francois.proulx@gmail.com>
13        * Fixed bug in hotspot_status , added htmlspecialchars();
14        * This solved the bug where ampersands would break the XML
15       
162005-07-17 Francois Proulx <francois.proulx@gmail.com>
17        * Fixed bugs in gen.sh, compile.sh locale scripts
18       
192005-07-12 Francois Proulx <francois.proulx@gmail.com>
20        * Changed XML element from hotspotsMetadata to hotspots and added networkUri element to networkMetadata
21       
222005-07-12 Francois Proulx <francois.proulx@gmail.com>
23        * Fixed XML protocol for exchanging hotspots status.
24                * Should now be considered stable (stamped v1.0)
25        * Fixed hotspots status map to reflect the changes
26        * Added french translations
27       
282005-07-11 Francois Proulx <francois.proulx@gmail.com>
29        * Changed link to hotspots map using NON ssl because Google Keys are sensitive to the whole path.
30       
312005-07-11 Benoit Grégoire  <bock@step.polymtl.ca>
32        * classes/RssPressReview.php: Begin rewrite.
33        * classes/MainUI.php: Add addFooterScript() function.
34        * venues_map.php:  Workaround the IE DOM problem.
35
362005-07-05 Francois Proulx <francois.proulx@gmail.com>
37        * Changed wording in hotspots status page added legend
38       
392005-07-05 Francois Proulx <francois.proulx@gmail.com>
40        * Minor adjustements to icon positionning
41       
422005-07-05 Francois Proulx <francois.proulx@gmail.com>
43        * Changed google maps marker icons
44       
452005-07-05 Francois Proulx <francois.proulx@gmail.com>
46        * Added missing elements in XML exchange format
47        * Stable v1.0 for XML exchange format and Google Maps mapping
48        * Added GMaps constants to config file
49        * Unsmartied index.php , added link to map
50        * Check config.php to set corresponding values
51        * You can now use hotspot_status.php?format=XML along with xslt query string parament to convert your XML document
52        * For this to work, You need to have activated XSLT ( see config file )
53       
542005-07-05 Francois Proulx <francois.proulx@gmail.com>
55        * Added Google Maps mapping venues_map.php
56        * /js/venues_status_map.js  JavaScript code for Mapping
57        * In beta : tested successfuly with 48 nodes in the Montreal area, loads in a snap
58       
592005-07-03 Francois Proulx <francois.proulx@gmail.com>
60        * Updated the XML venues status format ( version 1.0, once approved )
61        * Added long / lat fields to nodes table ( for mapping purposes )
62       
632005-06-17 Francois Proulx <francois.proulx@gmail.com>
64        * Added IFrame and SimpleIFrame content types.
65       
662005-06-28 Benoit Grégoire  <bock@step.polymtl.ca>
67        * classes/Content/Langstring.php:  Bug fix:  Langstring was always non-persistent, no matter the checkbox.  Move the code to TrivialLangstring.php where it belongs.
68
692005-06-21 Benoit Grégoire  <bock@step.polymtl.ca>
70        * portal/inted.php:  Implement the start button functionnality (maybe it would be better to call it
71         "use the Internet").  From now on, once authenticated and when pressing the start
72          button on the portal, the user will be sent to the page he originally tried to
73          access.  A second window will be popped with the portal page so he can come back
74           to it. The window is collapsed, and can be expanded back by clicking on the link.
75           I tried to make it cross platform (and mostly did) but it's still buggy in IE.
76         
77          At the same time, this fixes the goof reported by Rob Kelley of nycwireless.net
78
79        * portal/missing_original_url.php:  Displayed when the user tries to use the start button but for some reason the original url is unavailable
80        * common.php:  New define CURRENT_REQUEST_URL, hopefully containing the full URL in
81        the user's URL bar.
82
83
842005-06-17 Francois Proulx <francois.proulx@gmail.com>
85        * Removed forced Pattern Language on all hotspots
86        * Do not show hotspot logo in portal page, only on login, until we find a better layout
87
882005-06-16 Francois Proulx <francois.proulx@gmail.com>
89        * Added XML output format for hotspot_status.php
90        * Rough draft v1.0
91        * TODO move to different classes once stabilized
92        * Can use XSLT, if activated ( XSLT_SUPPORT constant )
93        * ie : http://wifidog-auth.org/hotspot_status.php?format=XML&xslt=http://wifidog-auth.org/xslt/hotspot_status.xsl
94        * or simply : http://wifidog-auth.org/hotspot_status.php?format=XML
95
962005-06-06 Francois Proulx <francois.proulx@gmail.com>
97        * Added long description field to content table
98        * MUST use schema_validate
99        * Modified Pattern Language to be more generic
100        * resend changelog
101       
1022005-06-06 Francois Proulx <francois.proulx@gmail.com>
103        * Made changes to Pattern Language ( Kate Armstrong )
104       
1052005-05-30 Philippe April <philippe@ilesansfil.org>
106        * Show username in user_stats.php instead of user_id
107          and in other admin pages
108
1092005-05-30 Francois Proulx <francois.proulx@gmail.com>
110        * Changed language selectbox name so it does not clash with ISF's domain cookie
111        * Fixed setlocale algorithm in Locale.php
112       
1132005-05-29 Francois Proulx <francois.proulx@gmail.com>
114        * Missing null check in validate.php
115       
1162005-05-27 Francois Proulx <francois.proulx@gmail.com>
117        * Changed the signup process to make it smoother for users
118                * The user will automatically be granted the 15 minutes if he's signing up at a real hotspot
119                * If the user closes his browser during the 15 minutes and loses its session, we will regenerate it
120        * Added big red message to the top of the portal page, warning user to validate as soon as possible
121        * Fixed translation typos
122
1232005-05-26 Benoit Grégoire  <bock@step.polymtl.ca>
124        * Someone moved the fallback gettext functions definition (for when gettext isn't installed) inside the static setCurrentLocale method, completely breaking the system when PHP doesn't have gettext support.  This is an untested fix.
125       
1262005-05-24 Francois Proulx <francois.proulx@gmail.com>
127        * Fixed bug in auth.php to let users go through when the click twice on the login button
128        * Fixed bug in hotspot_log.php
129       
1302005-05-24 Francois Proulx <francois.proulx@gmail.com>
131        * Added "Get access statistics" button to Node admin to get hotspot specific stats
132        * Added search box in Users log to get a specific user stats quickly
133       
1342005-05-24 Francois Proulx <francois.proulx@gmail.com>
135        * Fixed typo in some translations
136        * Cleaned-up todos
137       
1382005-05-18 Francois Proulx <francois.proulx@gmail.com>
139        * Added strip_tags in RssPreview ( some malformed HTML would break the page layout )
140       
1412005-05-16 Francois Proulx <francois.proulx@gmail.com>
142        * Changed login message in MainUI to make it clearer what the login button will do
143
1442005-05-13 Philippe April <philippe@ilesansfil.org>
145        * Added deployment status to node_list
146
1472005-05-11 Francois Proulx <francois.proulx@gmail.com>
148        * Began writing user profiles
149        * Added many methods to User class
150        * Added node quota fields in DB ( bandwidth, throttling ...)
151
1522005-05-10 Francois Proulx <francois.proulx@gmail.com>
153        * Fixed Login link in signup page ( MainUI.php ) if the Session has gw_id, gw_address, gw_port
154          show physical login link
155         
1562005-05-10 Francois Proulx <francois.proulx@gmail.com>
157        * Added download button CSS class to style button
158       
1592005-05-10 Francois Proulx <francois.proulx@gmail.com>
160        * Fixed wrong method name in File.php
161        * Added strip tags to Langstring
162        * Basic styling of content_admin table
163       
1642005-05-04 Francois Proulx <francois.proulx@gmail.com>
165        * Fixed serialization issue ( flickr)
1662005-05-04 Francois Proulx <francois.proulx@gmail.com>
167        * Improved caching
168        * Wrote very basic gridview code for Flickr
169       
1702005-05-04 Francois Proulx <francois.proulx@gmail.com>
171        * Implemented caching for Flickr
172        * Need to contact Phlickr to see how we could do better, since serialize does not work OK on objects
173       
1742005-05-04 Francois Proulx <francois.proulx@gmail.com>
175        * Fixed bug concerning Content-Length header
176        * Changed default Unit size for setLocalFileSize to bytes
177       
1782005-05-04 Francois Proulx <francois.proulx@gmail.com>
179        * Added BLOB support
180        * modified file_download.php to support new header attributes
181        * Added ImportLargeObject, UnlinkLargeObject to PG SQL abtraction
182        * Make sure your PHP.ini contains the right value to allow big downloads
183        * Check : http://ca3.php.net/manual/en/features.file-upload.common-pitfalls.php
184        * ISF Live server is now configured to support 100 megabytes files
185       
1862005-05-04 Francois Proulx <francois.proulx@gmail.com>
187        * Fixed CSS IE Bug
188        * Fixed SQL query
189        * NEED HELP FROM A WEB DESIGNER !!!!!
190       
1912005-05-03 Francois Proulx <francois.proulx@gmail.com>
192        * Disabled logging in Pattern Language archives
193       
1942005-05-03 Francois Proulx <francois.proulx@gmail.com>
195        * Having for SQL query... :-(
196       
1972005-05-02 Francois Proulx <francois.proulx@gmail.com>
198        * PatternLanguage is now completed
199       
2002005-04-30 Francois Proulx <francois.proulx@gmail.com>
201        * Logout button will now destroy session AND render token USED
202       
2032005-04-30 Francois Proulx <francois.proulx@gmail.com>
204        * Fixed bug that could potentially let non owners add content in /content through content groups
205        * Admin menu won't show node selector if the user is not owner of at least one hotspot
206        * Added Width, height support for Picture
207       
2082005-04-30 Francois Proulx <francois.proulx@gmail.com>
209        * Did my best for content styling ... ( it's 5h00 am )
210       
2112005-04-30 Francois Proulx <francois.proulx@gmail.com>
212        * Updated sync_sql_for_cvs.sh
213
2142005-04-30 François Proulx <francois.proulx@gmail.com>
215        * ChangeLog entry missed by CVS ?!
216        * Locale now decomposes the locale string by '_' 
217        * Now works on Mac OS X ( but you must use fr_CA, en_CA or fr_FR ... )
218       
2192005-04-30 François Proulx <francois.proulx@gmail.com>
220        * Trying to solve RSS encoding bug...
221        * Testing on live server
222       
2232005-04-29 François Proulx <francois.proulx@gmail.com>
224        * Removed all inline unuseful javascript code on submit buttons onclick='submit()'
225        * This conflicted with the actual click on the submit button in Safari
226        * Fixed check in Network for isOwner, only check superAdmin
227        * Fixed bug so you can't add an existing content group to itself ( deadlock )
228        * Started coding Pattern language narrative display
229
2302005-04-29 François Proulx <francois.proulx@gmail.com>
231        * Wrote User.php addcontent, removeContent, getAllContent()
232        * Wrote Content.php subscrite() and unsubscribe()
233        * Added parameters to getAllContent() in Node and Network ( exclude_subscribed_content )
234        * These will be used for subscribing a to some content
235        * Pattern Language will be the first to use it
236        * Online users lists
237        * Fixed bugs in Node and Network ( isOwner check )
238       
2392005-04-28 François Proulx <francois.proulx@gmail.com>
240        * Logout button build a query string containing gw_id, gw_address, gw_port ( if available ), so that a user at a physical hotspot will get the login page from the hotspot he is.
241        * Fixed but in Locale ( did not propertly set the locale in the session )
242       
2432005-04-28 François Proulx <francois.proulx@gmail.com>
244        * Added check in MainUI toolbar so that it won't show "NOT logged in ?" message when connect to a real hotspot ( not virtual )
245                * This message confused many users ( they clicked and got the virtual login instead ! )
246        * Hide adminstration features ( statistics, hotspot creation, network wide content etc...) from all but Super admins
247        * Fixed getAllLocativeArtisticContent in Node.php added is_persistent check
248        * Added $associate_existing_content parameter to processNewContentUI to allows reuse for existing content ( in ContentGroup )
249        * Fixed bug in FlickrPhotoStream delete ( missing return from parent )
250        * Added security check in all content classes ( ProcessAdminUI )
251       
2522005-04-26 François Proulx <francois.proulx@gmail.com>
253        * Replaced show only content groups by show persistent
254       
2552005-04-26 François Proulx <francois.proulx@gmail.com>
256        * Added missing /content directory
257       
2582005-04-26 François Proulx <francois.proulx@gmail.com>
259        * Added /content/ for displaying all content elements
260                * Logging is disable when viewing them
261                * All content elements will expand
262                * Pattern languages won't display everything ( special property ) isExpandable
263        * Added a link in portal pages to go to /content/
264        * Added Show all contents button in content_admin.php
265       
2662005-04-27 Benoit Grégoire  <bock@step.polymtl.ca>
267        * Content.php, ContentGroup.php:  All Content now implement the isDisplayableAt($node).  Used by the portal, if content has nothing displayabel, the entire content is skipped.
268       
2692005-04-27 Benoit Grégoire  <bock@step.polymtl.ca>
270        * FlickrPhotostream.php:  Fix the object so it doesn't crash when flicker is disabled.
271       
2722005-04-27 Benoit Grégoire  <bock@step.polymtl.ca>
273        * ContentGroup.php:  Fully functionnal content rotation engine, with all options supported.    Rotation based on session may not be reliable if the user isn't truly logged in (from a node).
274
2752005-04-26 François Proulx <francois.proulx@gmail.com>
276        * Most of the missing translations
277       
2782005-04-26 François Proulx <francois.proulx@gmail.com>
279        * Changed back File to non trivial
280        * portal page stylesheet
281       
2822005-04-26 Benoit Grégoire  <bock@step.polymtl.ca>
283        * ContentGroupElement.php:  It shouldn't be allowed to create a new content element in isolation.  Unfortunately the UI allows if for now.  Such content will now be deleted.
284        * Locale:  Fix string selection algorithm to pick the right language.
285        * Content:  Implement display logging.
286       
2872005-04-26 François Proulx <francois.proulx@gmail.com>
288        * stylesheet rework
2892005-04-26 François Proulx <francois.proulx@gmail.com>
290        * Fixed wrong location for change password link
2912005-04-25 François Proulx <francois.proulx@gmail.com>
292        * Portal page styling
293       
2942005-04-26 Benoit Grégoire  <bock@step.polymtl.ca>
295        * ContentGroup.php:  Previous fix didn't work.  New fix.
296
2972005-04-26 Benoit Grégoire  <bock@step.polymtl.ca>
298        * ContentGroup.php:  Make bad selection mode eror non-fatal.
2992005-04-25 Benoit Grégoire  <bock@step.polymtl.ca>
300        * Fix bug in ContentGroup enumeration
301
3022005-04-25 François Proulx <francois.proulx@gmail.com>
303        * More stylesheets work
304       
3052005-04-25 François Proulx <francois.proulx@gmail.com>
306        * Much better stylesheet
307               
3082005-04-25 Benoit Grégoire  <bock@step.polymtl.ca>
309        * UI fully functionnal
310
3112005-04-25 François Proulx <francois.proulx@gmail.com
312        * More interface work
3132005-04-25 François Proulx <francois.proulx@gmail.com
314        * Completed integration of new interface with new objects
315       
3162005-04-25 Benoit Grégoire  <bock@step.polymtl.ca>
317        * Integration merge, should work, but there will be display problems everywhere.  Expect further commits today.
318        * Almost 100% complete Network abstraction
319        * Much better object encapsulation.  Deprecated methods not removed yet.
320        * Add MainUI class.  Used to display the interface.  Inner workings still need work.
321       
3222005-04-23 François Proulx <francois.proulx@gmail.com>
323        * Added Preferred Size support for Flickr pictures
324       
3252005-04-23 François Proulx <francois.proulx@gmail.com>
326        * Completed missing translations
327       
3282005-04-23 François Proulx <francois.proulx@gmail.com>
329        * Fixed bugs in File and EmbeddedContent
330        * Completed first iteration of EmbeddedContent
331        * Can now play multimedia content
332        * Could not test fallback with my browser ( Safari and Firefox )
333        * Need help to test content in different browser to see how it reacts...
334       
3352005-04-22 François Proulx <francois.proulx@gmail.com>
336        * Fixed bug in FlickrPhotostream.php
337        * Params did not match new methods requirements ( getUserByEmail )
338        * Changed stylesheet class name for Flickr to match new changes
339        * Fixed bugs in File
340        * Wrote part of EmbeddedContent ( partially working )
341        * TODO: add support for parameters and attributes in EmbeddedContent
342       
3432005-04-22 François Proulx <francois.proulx@gmail.com>
344        * Fix schema version in François's commit
345       
3462005-04-21 François Proulx <francois.proulx@gmail.com>
347        * Added explicit admin UI exceptions support for Flickr
348        * Completed File and Picture objects
349       
3502005-04-20 François Proulx <francois.proulx@gmail.com>
351        * Completed Flickr support ( explicit exceptions catching )
352        * Most of File object is done
353        * Fixed bug in generic_object_admin.php
354        * changed stylesheet class tags for Flickr
355       
3562005-04-18 François Proulx <francois.proulx@gmail.com>
357        * Added Flickr content support
358        * Part of File object is done
359       
3602005-04-19 Benoit Grégoire  <bock@step.polymtl.ca>
361        * Working (beta...) content manager and portal.
362        * Add content preview mode
363       
3642005-04-18 Benoit Grégoire  <bock@step.polymtl.ca>
365        * Hotspot and network content association, continue access control work.
366        * hotspot_owner.php: Fix wrong assignement of user_id that prevented the script from working.
367        * All files:  Remove whitespace and carriage return after the ?> closing tags.
368       
3692005-04-18 Benoit Grégoire  <bock@step.polymtl.ca>
370        * Much more complete admin, initial access control work.
371
3722005-04-15 Benoit Grégoire  <bock@step.polymtl.ca>
373        * Support more of the content object model, do a half-decent CSS for the admin interface.
374
3752005-04-14 Benoit Grégoire  <bock@step.polymtl.ca>
376        * Content.php:  Use full langstring interface by default;
377
3782005-04-14 Benoit Grégoire  <bock@step.polymtl.ca>
379        * Content.php:  Fix db reference;
380
3812005-04-14 Benoit Grégoire  <bock@step.polymtl.ca>
382        * Fix Content object enumeration preventing usage of admin interface
383        * Partial fix for RSS feed encoding (multiple feed aggregation still broken);
384
3852005-04-14 Benoit Grégoire  <bock@step.polymtl.ca>
386        * First part of the future content delivery infrastructure.  Many files added.
387
3882005-04-01 François Proulx  <francois.proulx@gmail.com>
389        * Modified gen.sh script to match UTF-8
390        * Added PAP RADIUS encryption support ( asked by Paris Sans Fil )
391       
3922005-04-01 Benoit Grégoire  <bock@step.polymtl.ca>
393        * wifidog/templates/auth_sources_selection.html:  Add missing file from francois's commit.
394
3952005-04-01 Philippe April <philippe@ilesansfil.org>
396        * Fixed missing parenthesis in classes/User.php
397        * Removed unused files
398        * fixed schema_validate.php (typos)
399
4002005-04-01 Francois Proulx  <francois.proulx@gmail.com>
401        * EVERYTHING IS NOW UTF-8 YOU MUST EDIT YOUR FILES WITH AN UTF-8 COMPLIANT EDITOR
402        * The database will be converted to UTF-8 (version 5)
403        * Added select boxes ( or hidden ) html form elements to choose the network for signup, lost password, username
404       
4052005-04-01 Benoit Grégoire  <bock@step.polymtl.ca>
406        * Add constraints to account_origin to detect errors on inserts.
407        * Remove IDRC test server
408
4092005-04-01 Philippe April <philippe@ilesansfil.org>
410        * User.php: Add reference to $db global variable.
411        * Tagged v0_1_0_alpha1
412        * Removed spaces in AuthenticatorLocalUser.php
413       
4142005-03-31 Benoit Grégoire  <bock@step.polymtl.ca>
415        * Remove spaces after php blocks in various files.
416        * Temporarily fix single authentication source not present bug in login smarty template.  All other places where we select the network will be fixed tommorow.
417        * Fix initial schema errors.
418       
4192005-03-31 Benoit Grégoire  <bock@step.polymtl.ca>
420        * More RADIUS install documentation.
421        * Fix schema_validate.php
422       
4232005-03-31 Francois Proulx  <francois.proulx@gmail.com>
424        * Moved language definition
425        * Moved e-mail subjects to User class ( each e-mail functions )
426       
4272005-03-31 Francois Proulx  <francois.proulx@gmail.com>
428        * Added missing schema_validate.php modifs.
429
4302005-03-31 Francois Proulx  <francois.proulx@gmail.com>
431        * Added PEAR install procedure
432       
4332005-03-30 François Proulx  <francois.proulx@gmail.com>
434        * Finished RADIUS authentication and accounting
435        * Accounting Unique session ID is now based on the same token we use
436        * Fixed all issues with lost_username, lost_password etc...
437        * User class has new static function getUsersByEmail and getUsersByUsername
438        * Added translations for new features
439        * Translated the validation, lost password, username e-mails
440        * Tested quite a bit, this version is considered stable
441        * A few examples on how set different RADIUS or local authenticators can be found in the config.php
442       
4432005-03-29 François Proulx  <francois.proulx@gmail.com>
444        * schema_validate.php : Modified schema : dropped e-mail + account unique index, dropped email not empty constraint
445        * Schema is now at version 3
446        * Coded RADIUS authentication
447        * Modified templates to show a select box when more than one server is configured
448        * Coded RADIUS accounting and backward compatibility accounting
449        * Modified many statistics SQL queries to match new Users table
450        * modified statistics templates to match user_id and account_origin
451        * TODO : Fix lost_username and lost_password ( issue since we dropped the unique constraint on emails... )
452        * TODO : Heavy testing possibly with remote RADIUS servers
453       
4542005-03-28 Benoit Grégoire  <bock@step.polymtl.ca>
455        * sql:  Put initial data in a transaction, and specify the wifidog user so you do not have to su to it while using sync_sql_for_svs
456       
4572005-03-28 Benoit Grégoire  <bock@step.polymtl.ca>
458        * common.php:  Add get_guid() function
459        * validate_schema.php: New auto-upgrade script to allow autaumatic schema upgrade.  Note that you must still update dump_initial_data_postgres.sh and use sync_sql_for_cvs.sh so new users aren't left in the cold.
460        * New class Authenticator (and subclasses):  Begin virtualizing the login process.
461         
4622005-03-24 Benoit Grégoire  <bock@step.polymtl.ca>
463        * Statistics.php: Fix getMostGreedyUsers returning bad values when incoming and outgoing for all connections from a user have null values.
464        * wifidog/local_content/default/portal.html: Fix layout so it resizes properly.  This in an interim measure.
465        * Update schema.  This will allow automatic schema updates in the future.  TO update a live server:
466                BEGIN;
467                CREATE TABLE schema_info (
468                    tag text PRIMARY KEY,
469                    value text
470                );
471                INSERT INTO schema_info (tag, value) VALUES ('schema_version', '1');
472                COMMIT;
473       
4742005-03-16 Matthew Asham <matthewa@bcwireless.net>
475 * config.php: will use "local.config.php" instead, if present.  avoid cvs over-writing.
476 * signup.php: if CUSTOM_SIGNUP_URL is defined, signup.php will re-direct.  For integration with existing auth systems
477 * hotspot_status.php: ob_clean may complain about buffering.  muted.
478 * ./classes/RssPressReview.inc: if rss_source['url'] is blank, ignore the feed.
479 
4802005-02-22 Benoit Grégoire  <bock@step.polymtl.ca>
481        * sql/dump_initial_data_postgres.sh, wifidog-postgres-initial-data.sql, wifidog-postgres-schema.sql:-Widen the connections size to fix int4 wraparound problems.  To update a running server, execute the following sql sniplet:
482BEGIN;
483ALTER TABLE connections RENAME incoming TO incoming_old;
484ALTER TABLE connections ADD COLUMN incoming int8;
485ALTER TABLE connections RENAME outgoing TO outgoing_old;
486ALTER TABLE connections ADD COLUMN outgoing int8;
487UPDATE connections set incoming=incoming_old, outgoing=outgoing_old;
488ALTER TABLE connections DROP COLUMN incoming_old;
489ALTER TABLE connections DROP COLUMN outgoing_old;
490COMMIT;
491        * wifidog/admin/hotspot.php: Missing file from phil's commit.
492        * wifidog/locale/fr/LC_MESSAGES/messages.mo, messages.po:  New translation by Benoit St-André
493
4942005-02-14 Philippe April <philippe@ilesansfil.org>
495        * gw_message.php: the "activate" message was not properly defined and
496        would cause an error to show up instead of the nice activate your account
497        message
498
4992005-02-14 Philippe April <philippe@ilesansfil.org>
500        * wifidog/locale/gen.s: Was not working as expected, it will now get the
501        gettext from smarty properly.
502        * Updated TODO with ideas on making config better
503
5042005-01-31 Benoit Grégoire  <bock@step.polymtl.ca>
505        * wifidog/templates/hotspot_status.html:  Restore the number of nodes
506        * wifidog/hotspot_status.php: Restore the number of nodes, add formatting and more information to the RSS feed.
507
5082005-01-26 Philippe April <isf_lists@philippeapril.com>
509        * Some kind of virtual login (we need to talk about this).
510        * New User and Node classes
511        * Modified all files to work with the classes.
512        * Remove mgmt_helpers (all done in User class now)
513
5142005-01-25 Benoit Grégoire  <bock@step.polymtl.ca>
515        * classes/Node.php:  New file, untested code example
516        * wifidog/admin/admin_common.php: Remove double-defined BASEPATH
517       
5182005-01-25 Philippe April <isf_lists@philippeapril.com>
519        * Changed initial postgres inserts sql file, it wasn't working properly
520
5212005-01-25 Pascal Leclerc  <pascal@plec.ca>
522        * Added admin and owner administration pages
523
5242005-01-23 Philippe April <isf_lists@philippeapril.com>
525        * Added gateway error messages (validation period, etc.)
526
5272005-01-20 Philippe April <isf_lists@philippeapril.com>
528        * Modularized the admin interface, added functions
529
5302005-01-18 Philippe April <isf_lists@philippeapril.com>
531        * Smarty'ized more, I think it's done now
532
5332005-01-12 Philippe April <isf_lists@philippeapril.com>
534        * i18n and smarty'ized parts
535
5362005-01-11 Benoit Grégoire  <bock@step.polymtl.ca>
537        * INSTALL: Mandate PHP5
538        * wifidog/hotspot_status.php: Allow export of the list as a RSS feed
539        * wifidog/classes/RssPressReview.inc:  Make it truly functionnal.
540        * wifidog/portal/index.php:  Support multiple RSS feeds.  The system will automatically pick the best 5 entries from all the feeds.  It will compensate for disparate publication intervals.  An entry from a feed that does not publish often will live longer than an entry from a feed that publishes very often.  If a feed doesn't have any entry that makes the cut, it will not appear at all.
541        * wifidog/templates/hotspot_status.html:  Add link to the RSS version.
542
5432005-01-11 Benoit Grégoire  <bock@step.polymtl.ca>
544        * wifidog/config.php:  Add list of hotspot to network rss feed list (not yet functionnal)
545        * wifidog/hotspot_status.php:  Allow RSS export of the list of deployed HotSpots.
546        * wifidog/admin/incoming_outgoing_swap.php:  Script to swap incoming and outgoing in your data.  only use this if you had gateways before 1.0.2 and wish to correct your logs before you upgrade.
547        * wifidog/classes/RssPressReview.inc:  Missing file from previous commit.
548        * wifidog/portal/index.php: Preliminary work to enable smart press review of multiple RSS feeds.
549
5502005-01-10 Benoit Grégoire  <bock@step.polymtl.ca>
551        * include/common.php: Fix SSL security warnings.  If SSL is enabled and the page was actually served over SSL, all media in the file will be served over SSL. Add a new define (BASE_NON_SSL_PATH) to allow us to make links that break out of SSL mode.  From now on, use the self adapting BASE_URL_PATH in most circumstance, BASE_SSL_PATH to enter SSL mode, and BASE_URL_PATH to break out of it.
552
5532005-01-10 Benoit Grégoire  <bock@step.polymtl.ca>
554        * admin/user_stats.php: Add three top tens to the statistics:  Top ten apetite for bandwidth, top ten travelers, most addicted users.
555
5562005-01-04 Benoit Grégoire  <bock@step.polymtl.ca>
557        * wifidog/local_content/default/hotspot_logo_banner.jpg: Make it much thinner.
558        * wifidog/local_content/default/login.html: Remove announcements
559        * wifidog/include/user_management_menu.php: Fix mailto:
560        * wifidog/auth/index.php: Fix auth server part of the no data transmited statistics bug.
561        * wifidog/admin/index.php: Add link to statistics
562        * wifidog/admin/user_stats.php: Activate security.
563        * wifidog/index.php: Make the distinction between the two hotspot status pages clearer.
564
5652004-12-08 Benoit Grégoire  <bock@step.polymtl.ca>
566        * wifidog/index.php: Add menu
567        * wifidog/include/user_management_menu.php: Editorial change, make translateable
568        * wifidog/portal/index.php:  Fix RSS feeds
569
5702004-12-03 Benoit Grégoire  <bock@step.polymtl.ca>
571        * wifidog/admin/user_stats.php,  wifidog/classes/Statistics.php:  Embryonic aggregate user stats.  Currently allows you to find out the rate at which your users subscribe.
572        * wifidog/config.php, wifidog/local_content/default/login.html, wifidog/include/user_management_menu.php:  Add hotspot status page to login page.
573        * wifidog/hotspot_status.php: Cosmetic
574        * wifidog/admin/hotspot_log.php: Stats now need admin privileges
575        * wifidog/index.php: Cosmetic.
576
5772004-11-19 Benoit Grégoire  <bock@step.polymtl.ca>
578        * TODO: Add email domains to blacklist
579        * wifidog/config.php, wifidog/include/user_management_menu.php: Add tech support email address
580        * wifidog/hotspot_status.php: List of HotSpots that are open with summary of information.  Designed to be included as part of another page.
581        * wifidog/local_content/common/wifidog_logo_banner.gif: Add wifidog logo
582        * wifidog/local_content/default/hotspot_logo_banner.jpg: Shrink the logo and write unknown hotspot, however this is still really ugly
583        * wifidog/local_content/default/login.html, portal.html, stylesheet.css: Cosmetic fixes
584        * wifidog/local_content/default/login.html.fr, portal.html.fr: Delete the files, this isn't the approach we will use for translation.
585        * sql/wifidog-postgres-initial-data.sql, wifidog-postgres-schema.sql: Update with new node information structures.
586
5872004-11-04 Benoit Grégoire  <bock@step.polymtl.ca>
588        * wifidog/admin/hotspot_log.php: Add number of currently connected users here as well.
589
5902004-11-03 Benoit Grégoire  <bock@step.polymtl.ca>
591        * wifidog/ping/index.php: Log user-agent
592        * extensive statistics work
593        * sql/wifidog-postgres-schema.sql: Add description field for hotspots and log user-agent
594
5952004-10-28 Benoit Grégoire  <bock@step.polymtl.ca>
596        * sql/wifidog-postgres-schema.sql:  Add constraints to avoid empty string in email or user_id.
597        * Some statistics fixes
598
5992004-09-29 Alexandre Carmel-Veilleux <acv@acv.ca>
600        * wifidog/admin/index.php: Integrated the changes contributed
601        on the mailing list by Rikhardur EGILSSON (fname.lname@oecd.org),
602        mainly a missing ' in some HTML.
603
6042004-09-28 Yanik Crépeau <yanik@exScriptis.com>
605        * wifidog/include/common.php: Added commented header with cvs
606        keywords.
607        * wifidog/include/common.php: Added commented code (not executing) for
608        further testing with language/localization issues.
609
6102004-09-27 Benoit Grégoire  <bock@step.polymtl.ca>
611        * sql/wifidog-postgres-schema.sql:  Remove non SQL standard "COMMENT ON" comments
612
6132004-09-27 Benoit Grégoire  <bock@step.polymtl.ca>
614        * sql/wifidog-postgres-schema.sql:  Drop procedural language stuff
615
6162004-09-27 Benoit Grégoire  <bock@step.polymtl.ca>
617        * sql/wifidog-postgres-schema.sql:  Fix layout for the node_owners table
618        * Begin integrating Patrick Tanguay's new layout and generate the css dynamically to allow for background images.
619
6202004-09-22 Benoit Grégoire  <bock@step.polymtl.ca>
621        * portal/index.php:  Fix users appearing online at every hotspot.
622        * wifidog/classes/Style.php, wifidog/login/index.php:  Fix some potential cache problems and help with validation.
623       
6242004-09-18 Benoit Grégoire  <bock@step.polymtl.ca>
625        * wifidog/config.php:  Add VALIDATION_GRACE_TIME configuration parameter.
626        * wifidog/auth/index.php:  Move grace time date arithmetics to the database, fixes validation period not working.  Stop storing VALIDATION_FAILES status to the database.  Add check for validation period expiration at stage login, not just stage counters, this will fix one minute validation period.
627        * wifidog/login/index.php:  Check validation period activation, and if period is expired, explain to the user instead of redirecting to the gateway.
628        * wifidog/user_management/index.php:  Fix SQL error at new user registration. 
629       
6302004-09-02 Benoit Grégoire  <bock@step.polymtl.ca>
631        * wifidog/node_list.php: Complete the status page
632        * Add images
633        * Add hotspot creation date
634       
6352004-08-31 Benoit Grégoire  <bock@step.polymtl.ca>
636        * sql/: Update the postgres schemas and add scripts to ease maintaining it.
637        * sql/sync_sql_for_cvs.sh: Should you modify the schema in your db, run this script to the chances will be available in the cvs schemas and initial data.
638        * sql/dump_initial_data_postgres.sh: This does the actual dump of the data in a runnable form.  Note that this needs to be edited manually if you add a new table requiring initial data.
639        * INSTALL:  Update for postgres.  Somebody please test this.
640
6412004-08-31 Benoit Grégoire  <bock@step.polymtl.ca>
642        * wifidog/ping/index.php: Implement logging of which hotspot sent the heartbeat, from which ip and when.
643        * wifidog/node_list.php:  Primitive but functionnal hotspot status page.
644        * wifidog/include/user_management_menu.php:  Change menu labels
645        * wifidog/local_content/default/login.html: Improve layout.  Someone needs to make this stylesheet correct, I took shortcuts...
646        * wifidog/local_content/default/stylesheet.css:  Reduce H1 font size.
647        * wifidog/user_management/index.php:  Display the menu, will eventually allow us to present proper help text.
648
6492004-08-30 Benoit Grégoire  <bock@step.polymtl.ca>
650        * Add link to original requested site.
651        * wifidog/node_list.php:  New file.  Will become the main node status page.
652
6532004-08-28 Benoit Grégoire  <bock@step.polymtl.ca>
654        * Primitive network status available form the index page
655        * Administrative security is implemented.
656
6572004-08-28 Benoit Grégoire  <bock@step.polymtl.ca>
658        * Fix big gaping security hole in login page (password would be ignored if the username was used to login)
659        * PostgreSql port
660        * Change the method to determine who is online
661        * Stop keeping unused token once user successfully logs in.
662        * Fix missing update of token update date.
663        * Counters wouldn't get updated for stage=LOGOUT
664        * wifidog/auth/index.php:  Added a Messages: response in addition to Auth: so we can know what the hell the server is up to.  Currently you need to run wifidog in debug level 7 to see it. That message should be parsed so it is visible in debug level 6.
665        * wifidog/auth/index.php:   Fix code injection vulnerability.
666       
6672004-08-27 Benoit Grégoire  <bock@step.polymtl.ca>
668        * SSL support and RSS improvement
669        * Last commit tested with mysql support
670       
6712004-08-24 Pascal Leclerc  <pascal@plec.ca>
672        * wifidog/admin/user_log.php: Add total to incoming and outgoing
673        * Replace all SERVER_NAME by HTTP_HOST to fix non-standard server ports
674
6752004-08-11 Benoit Grégoire  <bock@step.polymtl.ca>
676        * wifidog/config.php: Add USER_MANAGEMENT_PAGE
677        * wifidog/include/user_management_menu.php:  Code meant to deal with non-standard ports broke the menu.  Hopefully fixed.
678        * Add alex's mising changelog entry...
679       
6802004-08-11 Alexandre Carmel-Veilleux <acv@acv.ca>
681        * wifidog/ping/index.php: will now reply if the wifidog auth server is up. to be used by wifidog to do heartbeats.
682
6832004-08-07 Benoit Grégoire  <bock@step.polymtl.ca>
684        * Add code to import a NoCat user database (passwd).  The username will be generated from the first part of the email if the name was en email.
685        * Change password hashing algorithm to make it compatible with NoCat (For the curious among you, the hashing algorithm is now:  take the md5 digest in binary format of the password, and base64 encode it.
686        * Table schema changed to accomodate newhash length (users.pass is now varchar(32))
687        * The user is now allowed to login with either his username or his email.
688       
6892004-08-03 Pascal Leclerc  <pascal@plec.ca>
690        * wifidog/classes/SmartyWifidog.php: Fix path validation bug, replace NODE_CONTENT_URL with NODE_CONTENT_PHP_RELATIVE_PATH
691        * wifidog/classes/AbstractDb.php: Add class=warning for better display
692        * wifidog/config.php: Add SYSTEM_PATH and test/fix non-standard server ports
693
6942004-08-03 Benoit Grégoire  <bock@step.polymtl.ca>
695        * Make gettext support optionnal, and define GETTEXT_AVAILABLE, will be set to true if gettext is available.  If false, blank _() and gettext() functions will be defined so the system still works.
696
6972004-08-03 Benoit Grégoire  <bock@step.polymtl.ca>
698        * Fix BASE_URL_PATH to properly detect non-standard server ports (hopefully).
699
7002004-08-02 Benoit Grégoire  <bock@step.polymtl.ca>
701        * wifidog-auth lives! New since the dark ages
702        * Demo page to allow people to hack more easely on it
703        * Support for multiple nodes.  TODO:  Merge with the database project.
704        * Very cool local content architecture.  Every hotspot can have a folder in the local_content directory.  This folder can be filed by a single logo, leaving all the rest to the default content, or be completely custom (stylesheet, login page, portal page, header, etc.)
705        * Everything in local content is templated with smarty, no problem with web designer wrecking havoc on the auth server.  You can edit everything in local_content/default even if you only speak html.
706        * No need to set any path in the web server config files (that one was a bitch to implement)
707        * RSS feed support (optionnal, with magpierss), one feed per node (url stored in the database, works great, but no gui to edit it yet) and one network-wide RSS feed.
708        * All path are editable from the config file
709        * "Productize" the thing, so it make sense for other groups to install it (the network name, url, default RSS, and such are set from the config file.
710        * Put most strings in gettext calls for easy future translation.
711        * User can request that the server send the validation email again
712        * User can change password
713        * User who forgot his username can have it mailed to him.
714        * User who lost his password can ask the system to generate a new one and mail it to him.
715        * Email is now a separate field to preserve user privacy.
716        * Enforces (politely) that there are no duplicate emails in the database
717        * Database abstraction layer with very nice debugging features (just append true at the end of the call, and you'll see the query, the results, the query plan and number of affected rows.  Also allow future upgrade to postgres.
718        * Lots of other things I forgot.
719       
720        * User who forgot his username can have it mailed to him.
721        * User who lost his password can ask the system to generate a new one and mail it to him.
722        * Email is now a separate field to preserve user privacy.
723        * Enforces (politely) that there are no duplicate emails in the database
724        * Database abstraction layer with very nice debugging features (just append true at the end of the call, and you'll see the query, the results, the query plan and number of affected rows.  Also allow future upgrade to postgres.
725        * Lots of other things I forgot.
726       
Note: See TracBrowser for help on using the browser.