Change font size
It is currently 2020-09-24, 12:21 pm


Post a new topicPost a reply Page 1 of 3   [ 23 posts ]
Go to page 1, 2, 3  Next
Author Message
 Post subject: 100% Database [WIP]
PostPosted: 2010-09-28, 8:19 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
I'm developing the new cuenation site which is 100% database driven, using CakePHP framework.

Sandbox
^^^ 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

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 !@#$%.


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-05, 12:08 pm 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-06, 2:03 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-06, 8:05 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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 :P

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.


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-06, 8:56 am 
User avatar

Joined: 2010-09-27
Posts: 96
Location: Finlandia
frifox Wrote:
2010-10-06
  • everything is unicode friendly, even usernames & passwords :P

Gulp... Please reconsider this.


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-06, 9:02 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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 :P


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-07, 5:40 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-15, 5:20 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
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


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-15, 10:41 pm 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
frifox Wrote:
2010-10-14
  • users can login and "remember" the session for 3 months by checking "Remember Me" checkbox by storing session info in a cookie **

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


Top
 Profile  
 
 Post subject: Re: 100% Database [WIP]
PostPosted: 2010-10-26, 7:36 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
2010-10-26
  • can add/edit/delete shouts
  • homepage shows recent cues & top categories

next up: requests


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 3   [ 23 posts ]
Go to page 1, 2, 3  Next


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron