# MySQL dump 4.0 # # Host: localhost Database: buildit #-------------------------------------------------------- use buildit; # # Table structure for table 'Author' # CREATE TABLE Author ( author_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, username varchar(10), firstname varchar(255), lastname varchar(255), email varchar(50), profile longblob, date timestamp(14), PRIMARY KEY (author_id) ); # # Dumping data for table 'Author' # INSERT INTO Author VALUES (1,'flygirl','Fly','Girl','barbara@panix.com',NULL,20000226150634); INSERT INTO Author VALUES (2,'Petapaw','Steve','Jamieson','stevenjamieson@hotmail.com',NULL,20000424225747); INSERT INTO Author VALUES (3,'2Big2Stop','2Big','2Stop','2Big2Stop@radio.fm',NULL,20000926194225); INSERT INTO Author VALUES (4,'neon toad','Dave','Johnson','neontoad@uswest.net',NULL,20001022183116); INSERT INTO Author VALUES (5,'Deadbot','Your','Toast','toast@yahoo.com',NULL,20001222002625); # # Table structure for table 'Guestbook' # CREATE TABLE Guestbook ( guestbook_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, guestbook_text mediumblob, firstname varchar(255), lastname varchar(255), email varchar(50), url varchar(100), date timestamp(14), PRIMARY KEY (guestbook_id) ); # # Dumping data for table 'Guestbook' # # # Table structure for table 'Homepage' # CREATE TABLE Homepage ( homepage_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, homepage_url varchar(100), homepage_email varchar(100), homepage_text mediumblob, firstname varchar(255), lastname varchar(255), date timestamp(14), author_id mediumint(8), PRIMARY KEY (homepage_id) ); # # Dumping data for table 'Homepage' # # # Table structure for table 'Logbook' # CREATE TABLE Logbook ( logbook_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, logbook_title varchar(100), logbook_text longblob, date timestamp(14), author_id mediumint(8), PRIMARY KEY (logbook_id) ); # # Dumping data for table 'Logbook' # # # Table structure for table 'Story' # CREATE TABLE Story ( story_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, story_title varchar(100), story_text longblob, format char(1), date timestamp(14), sc_id mediumint(8), author_id mediumint(8), PRIMARY KEY (story_id) ); # # Dumping data for table 'Story' # INSERT INTO Story VALUES (1,'What it takes','I have gotten a lot of questions on how to build something like RFM. I am
happy to share any knowledge I have acquired over this adventure, which
started in March 1997 for James and Roger, and July 1998, for me.

The reason I don\'t mind giving out any knowledge I have is that the main
thing it takes to build anything is time. If someone really has the
commitment, then they can build something, and those are people we want to
get to know here at RFM.

So ask away, and we will try to answer your questions as best we can.

Good Luck!
','P',20000226151238,1,1); INSERT INTO Story VALUES (2,'Video quality','We are using a Dell Precision Workstation with a 733 mhz processor to run
a Pinnacle 500 DV card and software. Their TitleDeko plug-in goes with
Adobe Premiere. It is incredible because it allows you to alter the
quality of the live broadcast in very subtle ways. (The live broadcast is
being encoded on another computer.)

So James was using an RCA jack to connect the video from the Pinnacle card
to the encoding computer, and the quality of the video that was being
encoded was not great, yet the quality of the video on the Pinnacle
computer was fabulous.

How to fix this? Change the wire. Put an S-video cable to connect the two
computers so you get a digital connection, instead of an analog one. Then
the video on the encoding computer improved 100% and we are still able to
play with the live broadcast file in Premiere.

I have no idea who this will help. But James had the idea of cataloging
our tech stories in the hope that they will help someone.','P',20000229152658,2,1); INSERT INTO Story VALUES (3,'mp3 files','I set up a mailbox on my softarc intranet server, which is on an NT box upstairs. I can control the file size of the mail I accept so it can be big enough to accept mp3s.

Jumpman sent me an mp3. I downloaded it from the mail server onto the computer where the mail server is installed. Took all of 2 seconds. Then I opened Network Neighborhood and put the file on the Baby Dell, the dj\'s pc, which holds all the music files. She opened it and played Jump\'s song, while Jump was in the chatroom, 10 minutes after he told us that he had sent it.

This was cool, and I think it probably speaks to where customer service software on the web is going. Of course, we do everything first here at RFM. :-)

And it speaks to another point-- part of my rebellion about the way networks are run in the professional world. Well, they have to be run that way because so much money is at stake. But the network is very far away from the people. There are network administrators, technological shields of every kind. And I wonder, well, what would happen if you have a network that is completely responsive to the individual? So that is what that exercise in playing the mp3 file in real time was about.','N',20000229152552,2,1); INSERT INTO Story VALUES (4,'The installation design','I am proposing this design for an online training studio
at work. I don\'t know whether it will be approved or not
but this is James\'s design. It is beautiful. The only
thing you ever have to change about it is what goes
into the mixing boards. I thought I\'d share. I also
want to take this opportunity to say bravo James.


Here\'s the link to the diagrams','P',20000702194107,1,1); INSERT INTO Story VALUES (5,'The music goes round & round, and it comes out...','Hi, FlyGirl! Hey, I\'ve tried a few jukebox-type mp3 players, and haven\'t yet found software that is stable enough to use 24/7. I\'m edging ever closer to webcasting, with 10gb of mp3\'s, a DSL line, behringer compressor, fostex mixer, and an old rca ribbon mic. RFM is so reliably ON-AIR, and I was hoping that you might (at the risk of boring some guests) reveal some of the magic. What dj package, what fx, jukebox, library, etc. Email me if you don\'t wish to post it on-line.','N',20000926195740,2,3); INSERT INTO Story VALUES (6,'Re: The music goes round and round','Big Stop wrote: Hi, FlyGirl! Hey, I\'ve tried a few jukebox-type mp3 players, and haven\'t yet found software that is stable enough to use 24/7. I\'m edging ever closer to webcasting, with 10gb of mp3\'s, a DSL line, behringer compressor, fostex mixer, and an old rca ribbon mic. RFM is so reliably ON- AIR, and I was hoping that you might (at the risk of boring some guests) reveal some of the magic. What dj package, what fx, jukebox, library, etc. Email me if you don\'t wish to post it on-line.

----------------------------------------

10 gb of mp3\'s will make great content. Don\'t forget to mix that in with sound files you produce yourself, to give a personal edge to the music and let your own voice ring.

DSL sounds like a good start. Make sure your server has a public routable IP, as opposed to a private IP only viewable within the LAN and using NAT (network address translation). See how it goes. We webcast with RealServer Plus 7.0 and Real Producer over an dedicated ISDN. Our server is a Dell PowerEdge 2300 with 2 300 Mhz processors that I bought two years ago.

However, I have heard wonderful things about Quicktime Streaming with Sorenson broadcast software. Quicktime is done on a Macintosh G4, and I would encourage you to look at it before you make your software decision.

When you stream yourself, even if you get a license for 60 streams, as you would with Real Server Plus, you might not have the bandwith with DSL to serve more than a few listeners without your picture breaking up. So you might want to stream from a remote service that specializes in it. The closer the server with your live file on it is to the internet backbone, the more the ISP will charge you. Webcasting is expensive.

I think it is a terrific idea that you are starting by putting together equipment you already own. The art of this is all in the plugs. RFM is indeed an audio/visual studio combined with a local area network. And you have to start somewhere.

Do you go to school? Perhaps they have a streaming server. This would save you a lot of money.

We use Music Match Jukebox software, I think a program called ACDC for slide show. But more importantly, we have spent two years making a video and audio tape library of our shows. We make sound files and promos and taped interviews etc. It\'s just as important to create music and speech as it is to play it.

I did a replica of the RFM installation for the software company I work for. Yes, this equipment is expensive because the company could afford to pay for it, and I don\'t mean to imply that someone can\'t webcast for less, but I am sharing it to give you an idea.

http://www.radiofreemonterey.org/pages/specs.html

Hope this helps. Thanks for posting to this board!

FlyGirl','N',20001005020143,2,1); # # Table structure for table 'Story_Category' # CREATE TABLE Story_Category ( sc_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, sc_name char(60) DEFAULT '' NOT NULL, PRIMARY KEY (sc_id) ); # # Dumping data for table 'Story_Category' # INSERT INTO Story_Category VALUES (1,'Concepts'); INSERT INTO Story_Category VALUES (2,'Tech Stories');