- Posts: 46
- Thank you received: 0
Support for SermonSpeaker 4.x is canceled as it is for Joomla 2.5. I will gladly assist you with minor issues but I will not fix any bugs anymore in this releases.
The fix is to upgrade to SermonSpeaker 5.x and Joomla 3.x, which is better anyway.
The fix is to upgrade to SermonSpeaker 5.x and Joomla 3.x, which is better anyway.
Related Sermons slightly options
- Thomas Hunziker
-
- Offline
- Administrator
-
16 Jun 2012 08:16 #2085
by Thomas Hunziker
Replied by Thomas Hunziker on topic Re: Related Sermons slightly options
Modules are built quite simple. You could change that in your installation.
There are two files involved:
To show the hits and speakers you would first need to add those to the SQL query in the helper file. The query for the sermons starts on line #216, the one for articles on line #108.
To get the hits you can just add this line to the sermons and article queries:
To show the speaker you need an additional join like this:
For the articles you would probably have to load the author since they don't have a speaker.
The next step is to display the newly acquired infos in the layout. It is basically a HTML file with some PHP tags where dynamic data is displayed.
will display the hits and speakername respectively. Add this code where you want it to show 
There are two files involved:
- /modules/mod_related_sermons/helper.php which contains the database queries and some logic.
- /modules/mod_related_sermons/tmpl/default.php which contains the (very simple) HTML layout.
To show the hits and speakers you would first need to add those to the SQL query in the helper file. The query for the sermons starts on line #216, the one for articles on line #108.
To get the hits you can just add this line to the sermons and article queries:
Code:
$query->select('a.hits');
Code:
$query->select('b.name');
$query->leftJoin('#__sermon_speakers AS b ON b.id = a.speaker_id');
The next step is to display the newly acquired infos in the layout. It is basically a HTML file with some PHP tags where dynamic data is displayed.
Code:
<?php echo $item->hits; ?>
<?php echo $item->name; ?>
Please Log in or Create an account to join the conversation.
16 Jun 2012 13:30 #2087
by tobisagt
Replied by tobisagt on topic Re: Related Sermons slightly options
That works for me! Thank you a lot for your help and your awesome work! 
Please Log in or Create an account to join the conversation.
Time to create page: 0.136 seconds