****************************** * * Notes for TREES DATABASE. * ****************************** * Move the login stuff into a sub-directory (with all the user maintanence) * Maybe change user levels : 0- Not logged in, can view only. 2- priv. guest (some added access?); 4- can add observations & photos & update trees; 8- Can delete stuff also; 16- Admin user maint. * Return user to their page after they log in ... not just go to home page. * Add "admin" function (mapsymbol editing). * Maybe need to re-visit the whole "current photo" thing, not store as 0/1 value. * Photo_add.php : Need to handle adding a comment attached to the photo (add field to form; clean up input (strip slashes etc) & save). * Current titoki install has limit of 1Mb file size .. need to fix that *********** php.ini set to following ... needs testing ; Maximum allowed size for uploaded files. upload_max_filesize = 4M ; Must be greater than or equal to upload_max_filesize post_max_size = 8M * Report from trial: export a list (every tree to have an observation?) in csv format. select * from observations by tree_id by date. ?with some data from trees table included. * Check what's happening with photo to display following photo upload. * Port to mobile app (see OneNote notes) * Modify to include key retrieval rather than static field declarations. * When adding an observation .. the use of an apostrophe ("it's") prevented the record from being written. * Add a search function (top RH corner?) to go to a specific tree record. * Fix the map on the tree page so it's *NOT* a google maps.