localscode (ie 'the codebase') 3.0 stable
please send any bugs or feature requests to harry, who maintains the codebase for all locals sites, and look/feel for cblocals. as you can see, there's always work to go around.. so if you're a mysql/php wizard and want to help out, please fire me off an email.
bugs
- FIXED! mysql 4.0 query caching to the rescue! picture listings take a long time to load despite a fast db server and efficient sql statement. help? (sql: select n1.picture_id,n1.description, n1.filename, n1.filesize,UNIX_TIMESTAMP(n1.date_added), n1.photographer,n1.cat_id, n1.year,n2.cat_id,n2.cat_name from pictures as n1, pictures_cat as n2 where n1.cat_id = n2.cat_id order by n1.date_added desc limit 60)
- preview guestbook function adds slashes to comments box -- fixed!!
- nasty 'page has expired' warnings forcing a page reload (like when hitting the back button to get to the pictures list after viewing a pic).. fixed!!!
- user/vote settings are sometimes temporarily lost when an admin with a user account logs into locals admin. temporary fix: close your browser window after using locals admin.
- FIXED! softlinks don't accept some special characters like ',;"!: and some others..
- function for automatically adding spaces to really long text strings doesn't work. fixed!! thanks warren k!!
- netscape 4x support is lacking.. fixed! should render correctly in all 4x+ browsers
- random pictures will for some reason occasionally not return an id, causing no picture to load. this is different than a broken image -- that would be caused by an invalid picture id getting passed. not sure what is happening here.
- FIXED! php mail function doesn't send carbon copy properly all the time.
wishlist / upcoming features
- ability for users to add pictures to their profiles
- exact matching on searches
- guestbook searching for logged in users
- guestbook request deletion for logged in users
- picture keywords change request form for logged in users
- user to user messaging
- bands should have more status options, status notes (ie on hiatus, still willing to play, etc)
- option for percentile results in voting
- user prefs for fonts and colors
- cblocals.com/blah instead of cblocals.com/secondary.html?_function=blah. requires apache wizardry
- documentation, developer's guide
- when adding a group of pictures, locals admin should remember the category you last chose and make that the default
about the codebase
locals runs its own multi-user news/events/guestbook system, written and maintained by harry using php/mysql/apache. it's got a few layers of seperation, with a central non-web-accessable codebase which provides core functionality for news, events, pictures, links, users, voting, etc.. this is essentially a variation of the original tango code from 1997, but rewritten in php, and cleaned up quite a bit. the idea behind the codebase is that i can easily setup other sites like hfx/pei locals, which can have their own look and feel, but all rely on the same underlying code -- this way i can make additions/fixes to one piece of code and not 2 or 3.
you can have your own copy for free.. it takes me about 20 minutes to set up a new locals site now, instead of 2 days. the install is a manual process, but might be made automated in the future. the site relies on mysql/php/apache on unix, but may run on windows. there is currently no documentation, but i'll be working on a function list and notes, as well as a sql dump of the general database structure.
code history
- feb 1997: static page, hosted on 6100/66 running webstar
- june 1997: first database content for cbloals guestbook. db server: 7200/120 running butler sql. dynamic content by tango 2 ppc. hosted by chatsubo design.
- oct 1997: localscode v1 with multiuser news.
- late 1998: migration to p200 webserver running windows nt 4 and iis, tango 3 cgi for windows, and mssql 6
- late 1999: migration to tango 2000 for windows nt 4
- august 2000: localscode v2 with vote polls, searchable news, bandlistings, new layout. khi buys chatsubo.
- october 2001: localscode v2, migration from nt to linux. port from tango to php.. database exported from mssql to mysql 3.23. hosting by locals.ca through w3 internet solutions
- november 2001: encyclopedia functions, user logons, searching..
- january 2002: picture database
- january 2002: encyclopedia pulled due to major bugs
- march 2002: migration from linux to freebsd. hosted by locals.ca through in-house internet connection
- september 2002: migration to localscode 3, tidying up all earlier code, blending in encyclopedia functionality, and genericising cb/pei/hfx structure
|