作者Tingyutony (踢踢歪)
看板WebRadio
标题Re: [问题] 点歌系统的待播歌曲？
时间Tue Apr 29 09:50:22 2008
samphpweb.rar (再次感谢EAFV大)
里面有个playing.php 这就是播放曲目的php
29-42行
$db->open("SELECT
songlist.ID as ID,
songlist.artist as artist,
songlist.title as title,
songlist.album as album,
queuelist.requestID as requestID
FROM queuelist, songlist
WHERE (queuelist.songID = songlist.ID)
AND (songlist.songtype='S')
AND (songlist.artist <> '')
ORDER BY queuelist.sortID
ASC LIMIT
2");
$queue = $db->rows();
reset($queue);
这个2就是会显示出来的待播曲目
同理4-27行
$db->open("SELECT
songlist.ID as ID,
songlist.balance as balance,
songlist.date_played as date_played,
songlist.date_artist_played as date_artist_played,
songlist.date_album_played as date_album_played,
songlist.date_title_played as date_title_played,
songlist.duration as duration,
songlist.artist as artist,
songlist.title as title,
songlist.album as album,
songlist.picture as picture,
songlist.lyrics as lyrics,
songlist.last_requested as last_requested,
historylist.listeners as listeners,
historylist.requestID as requestID,
historylist.date_played as starttime
FROM historylist,songlist
WHERE (historylist.songID = songlist.ID)
AND (songlist.songtype='S')
ORDER BY historylist.date_played
DESC LIMIT
6");
$history = $db->rows();
reset($history);
这个6就是目前播放曲目包括下方五首历史曲目(1+5)
如果调成11就是目前播放曲目包括下方十首历史曲目(1+10)
这个数量斟酌修改就好
太大会造成资料库的负担
如果你网路速度不够也会有影响喔
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.166.47.188
1F：推 zguest2000:感谢<(_ _)> 04/29 09:55
2F：推 i19890813:推推 爬到此文解决了 感恩 08/08 12:41