Database reading

Hello,

Is there any possible way if you know your SQL to write a database entry for one site into the sermon speaker sermons. Here's what I'm trying to achieve we have one website that we use a MySQL database to pretty much make an entry for a media archive with a preview pic. Would this work? The only thing i'm wondering is this what would we have to write so that the MP3 is only written to the sermon speaker sermon for a specific series.

Here's a basic idea of what i'm trying to achieve

DB Fields in db we have Sermon Speaker
StreamName < Reads this Writes into > Videofile Field and the DB already setup knows the location so the path doesn't have to be inputted.
mp4:filename.mp4

I'm not exactly sure if I understood you correct.
You want an extern script/site to add sermons to SermonSpeaker? This would be possible as long as the script has access to the Joomla database. SermonSpeaker takes all it's infos from the database tables. #__sermon_sermons is the one responsible for the sermons. There are two more tables for speakers and series. Have a look at them and fill it how you need it.

If you want your extern script take the info from SermonSpeaker and populate its own tables from it, then you have to use either the RSS feed for it or again directly access the database tables (if possible).

How do i change the color of the lists so that they all are the same color. If you go to www.southsidealliance.org then go to ssa.tv > Media Archive you will notice the pattern goes light dark light dark i would like to make it so that it all goes dark because of the template change.

try this. put it all the way in the bottom of your general.css file for template.

by the way if you have chrome, you can use element inspector and see what styles you need to disable or change.

Andrei Chernyshev wrote: by the way if you have chrome, you can use element inspector and see what styles you need to disable or change.

IE has such a function built in as well (F12 - Development Tools) and FireFox has the Firebug Addon which also has such a function.
It helps a lot if you use one of this tools