Tom,

I wasn't able to get the code {series_text} or {seriestext} to show up using the custom codes for my podcast. I poked around in the php and noticed that the series table wasn't being joined to. (i'm running 6.2.4)

Any how I modified the query and added se.series_text and (. ' LEFT JOIN #__bsms_series AS se ON (se.id = s.series_id)') to the joins...

Could this be added in the future?

Thanks

Travis

Great catch, Travis. You should help us develop the component

Can you specify for me what file and line you modified? I'll be sure to add it to version 7.

Tom

Tom,

Sorry for the delayed response...busy weekend. Basically, the change was made to /helpers/writexml.php with the addition of the aliased column call in the select and the addition of a LEFT JOIN (see the two arrows below)...

The other reference that was a bit of a concern was in /lib/biblestudy.podcast.class.php (similar query...but i dont know if it is used)

I'm not really a PHP guy... I have a ms sql server background with some asp coding experience - dont know if i would be much help to you all.

by His grace,

Travis



$query = 'SELECT p.id AS pid, p.podcastlimit,'
. ' mf.id AS mfid, mf.study_id, mf.server, mf.path, mf.filename, mf.size, mf.mime_type, mf.podcast_id, mf.published AS mfpub, mf.createdate, mf.params,'
. ' mf.docMan_id, mf.article_id,'
. ' s.id AS sid, s.studydate, s.teacher_id, s.booknumber, s.chapter_begin, s.verse_begin, s.chapter_end, s.verse_end, s.studytitle, s.studyintro, s.published AS spub,'
. ' s.media_hours, s.media_minutes, s.media_seconds,'
---------------->. 'se.series_text,'
. ' sr.id AS srid, sr.server_path,'
. ' f.id AS fid, f.folderpath,'
. ' t.id AS tid, t.teachername,'
. ' b.id AS bid, b.booknumber AS bnumber, b.bookname,'
. ' mt.id AS mtid, mt.mimetype'
. ' FROM #__bsms_mediafiles AS mf'
. ' LEFT JOIN #__bsms_studies AS s ON (s.id = mf.study_id)'
---------------->. ' LEFT JOIN #__bsms_series AS se ON (se.id = s.series_id)'
. ' LEFT JOIN #__bsms_servers AS sr ON (sr.id = mf.server)'
. ' LEFT JOIN #__bsms_folders AS f ON (f.id = mf.path)'
. ' LEFT JOIN #__bsms_books AS b ON (b.booknumber = s.booknumber)'
. ' LEFT JOIN #__bsms_teachers AS t ON (t.id = s.teacher_id)'
. ' LEFT JOIN #__bsms_mimetype AS mt ON (mt.id = mf.mime_type)'
. ' LEFT JOIN #__bsms_podcast AS p ON (p.id = mf.podcast_id)'
. $where.'s.published = 1 AND mf.published = 1 ORDER BY createdate DESC '.$limit;

tom...

did you get the post i sent with the entire query?

travis

Got the code, Travis. I will add it to the codebase for 7.0

Thanks!

Hi, guys, I'm not technically savvy in MySQL, and was wondering for some help in regard to this. Instead of custom code for {{seriestext}} in podcast, I'm simply wanting to use it in the study details custom view, and it's not showing up. any help in getting it to show up would be greatly appreciated! Thanks!