In code/classes/class.song.php I found this code at line 87:
Code:
->where('s.songtype = ?', 'S') //Only return song of type S
I know what I have to add to the query that's being generated here to do what I want to do; just need to add an OR songtype = 'C' so that the podcast-type files (which I have set to songtype C) will show up in the Now Playing page. This exact query is what I need to generate:
SELECT s.*, h.listeners, h.requestID, h.date_played AS starttime, r.name AS dedicationName, r.msg AS dedicationMessage FROM songlist AS s INNER JOIN historylist AS h ON h.songID = s.ID LEFT JOIN requestlist AS r ON r.id = h.requestID WHERE ((s.songtype = 'S') OR (s.songtype = 'C')) ORDER BY h.date_played DESC LIMIT 6
This runs perfectly if I send it as a query using MySQL Workbench.
However, I will be the first to fess up to the fact that my PHP skills aren't the best. Within this code:
Code:
$select = $db->select()
->from(array('s' => 'songlist'),
array('*'))
->join(array('h' => 'historylist'),
'h.songID = s.ID',
array('listeners', 'requestID', 'starttime' => 'date_played'))
->joinLeft(array('r' => 'requestlist'),
'r.id = h.requestID',
array('dedicationName' => 'name',
'dedicationMessage' => 'msg'))
->where('s.songtype = ?', 'S') //Only return song of type S
->order('h.date_played DESC')
->limit(HISTORY_COUNT + 1);
... what do I need to do to generate the query I show above to insure that songs with songtype = 'C' show up in my now playing page?
This is very much a learning experience for me. Thanks in advance.
EDIT 5/21/18: never mind; figured it out.
Login
Register
FAQ
Search
