I'm developing the new cuenation site which is 100% database driven, using CakePHP framework.

Sandbox

• url: http://cuenation.com/dev

^^^ demo username & password are already prefilled, but if needed use "user" & "user" respectively or just register with your own username & password, but be aware that this is a sandbox and database is flushed quite often resulting in loss of old data.

Changelog

• 2010-09-28 - init
• 2010-10-04 - see post
• 2010-10-05 - see post
• 2010-10-06 - see post
• 2010-10-14 - see post
• 2010-10-26 - see post
• 2010-11-14 - see post
  

I'll keep a log here so you guys can see the progress. The goal is to complete all PHP functions and interactions first, and only then bother with the layout (HTML/CSS/JS), which is why atm the site look like !@#$%.

2010-10-04

• can manage categories
• can view all cuesheets in specific category
• can delete a category, removing associated cues as well (or maybe move them to Misc category instead)
• as soon as you select file to upload, form auto-submits
• can edit cuesheet tracks in track-view mode (*), and the old cue-sheet mode
• can edit cuesheet's meta (source, release group, duration, etc)
• a nice page generation timer in the footer
• new homepage logo

new ideas for future: after user uploads cue file, on the next page where selecting meta, auto-detect probable category/releasers (can be parsed from cue title). but this will be later on, next i'm tackling user management.

* can't "add" new tracks using track-view mode yet, but will will come in later. edit/remove is good enough for now

2010-10-05

• can add/edit/remove users
• cuesheets can be assigned to a user
• can see user's cuesheets

next up: to implement user authentication and automatically assign cuesheets to whoever is logged in at the time
note to self: modify cuesheet parser class to match cakephp's naming/data-organizing conventions

2010-10-06

• users can self-register
• non-users are denied access to member-only pages (all pages for now, except home/login/register)
• uploaded cuesheets are attached to currently logged-in user
• everything is unicode friendly, even usernames & passwords

next up, cuesheet comments & shouts. requests will come later since i will be handling them differently (aka, threaded requests, for display replies below request user replied to)

ps: right now all authenticated users are admins, site has no privilege differentiation, at least not yet.
note to self: do sql rewrites where categories/cuesheet-titles/usernames/etc are used in urls instead of their ID's. make url's unicode compatible as well.

Gulp... Please reconsider this.

i probably should rephrase that... everything is unicode CAPABLE, but not every single fields have to actually accept non-english text once the site launches

also, google translate can translate non-english crap if ever needed to

was doing some coding and realised something interesting... if you logout and try logging in again by clicking "login" button (not clicking some page and it redirects you to login page because it's restricted) - upon successful authentication it will redirect you to a page you were on when you logged out.

feature? bug? lol

2010-10-14

• users can add/edit/delete comments for cuesheets
• user entries are now sanitized for any malicious crap *
• users can login and "remember" the session for 3 months by checking "Remember Me" checkbox by storing session info in a cookie **

* tho they still can "hack" the site by manually editing html form fields which will allow users to add/edit unwanted fields such as adding/editing other's cuesheets and other various data. this will be patched later by whitelisting fields for each controller's method (add/edit/delete/etc).
** username/password arent stored in the cookie and the cookie itself is encrypted, all for obvious reasons. also, if user was suspended/banned/deleted/etc for any reason, cookie will be rebuilt/invalidated next time the user loads the site.

next up: shouts

dam, it works but not always. need to fix/redo this

2010-10-26

• can add/edit/delete shouts
• homepage shows recent cues & top categories

next up: requests