Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
Jamroom Developers:
Module time stamp/band_id question
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 01/22/09 06:01 
created_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00'

Is this how I would do it to have a date and time stamp to display the latest also if i do anoher one for modified date would this be helpful or is it not needed
Is there any other field needed along with the datetime that a rookie as myself may forget or not know about.
also where you have the youtube_band_id in the schema does this correlate to the JR band ID issw somewhere wher it showed something like
youtube_band_id = band_id or something like this
IS that whatputs this as the JR band id
also you said in the released version of 4 there would be a new upload function I didnt see this anywhere.


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
smith.kyle
CodeSmith


Joined: 27 Apr 2006
Posts: 22009
Location: Southern California

Posted: 01/22/09 15:29 
For the timestamp, I would use unix epoch time, and then format it after it's been retrieved from the database.

For the band_id, yes, the youtube_band_id correlates to the band_id column - these are called "foreign keys" and are used to match records together.


_________________
kyle[at]jamroom.net

Yes...that's a soda machine...

I get bored when no one's posting...
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
Jamroom Developers

 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.