public function getListVotesByEntryId($iEntryId)
{
$aRows = $this->database()->select('*')->from(Phpfox::getT('contest_entry_vote'), 'env')->join(PHpfox::getT('user'), 'u', 'u.user_id = env.user_id')->where('env.entry_id = ' . $iEntryId)->execute('getRows');
return $aRows;
}
public function getInfoForAction($aItem)
{
if (is_numeric($aItem)) {
$aItem = array('item_id' => $aItem);
}
$aRow = $this->database()->select('p.post_id, p.thread_id, p.title, pt.text_parsed, p.user_id, u.gender, u.full_name')->from(PHpfox::getT('forum_post'), 'p')->join(Phpfox::getT('forum_post_text'), 'pt', 'pt.post_id = p.post_id')->join(Phpfox::getT('user'), 'u', 'u.user_id = p.user_id')->where('p.post_id = ' . (int) $aItem['item_id'])->execute('getSlaveRow');
if (empty($aRow['title'])) {
$aRow['title'] = $aRow['text_parsed'];
}
$aRow['link'] = Phpfox_Url::instance()->permalink('forum.thread', $aRow['thread_id'], $aRow['title']);
return $aRow;
}
/**
* @TODO: add detai later
*/
public function getTotalPendings()
{
$iCnt = $this->database()->select('count(*)')->from(PHpfox::getT('contest'), 'ct')->where('ct.contest_status = 2')->execute('getField');
return $iCnt;
}
public function getInfoForAction($aItem)
{
// now we check if its a music-album or a music-song
if ($aItem['item_type_id'] == 'music-song') {
$aRow = $this->database()->select('ms.song_id, ms.title, ms.user_id, u.gender, u.full_name')->from(PHpfox::getT('music_song'), 'ms')->join(Phpfox::getT('user'), 'u', 'u.user_id = ms.user_id')->where('ms.song_id = ' . (int) $aItem['item_id'])->execute('getSlaveRow');
$aRow['link'] = Phpfox::getLib('url')->permalink('music', $aRow['song_id'], $aRow['title']);
return $aRow;
}
// else its a music-album
$aRow = $this->database()->select('ma.album_id, ma.name as title, ma.user_id, u.gender, u.full_name')->from(PHpfox::getT('music_album'), 'ma')->join(Phpfox::getT('user'), 'u', 'u.user_id = ma.user_id')->where('ma.album_id = ' . (int) $aItem['item_id'])->execute('getSlaveRow');
$aRow['link'] = Phpfox::getLib('url')->permalink('music.album', $aRow['album_id'], $aRow['title']);
return $aRow;
}
public function winningEntry($aListVals)
{
$iLastEntryId = null;
foreach ($aListVals as $key => $aVals) {
$this->database()->delete(PHpfox::getT('contest_winner'), 'entry_id = ' . $aVals['entry_id']);
$aInserts = array('entry_id' => $aVals['entry_id'], 'user_id' => $aVals['user_id'], 'award' => $aVals['award'], 'rank' => $aVals['rank'], 'time_stamp' => PHPFOX_TIME);
$this->database()->insert(Phpfox::getT('contest_winner'), $aInserts, 'entry_id = ' . $aVals['entry_id']);
$iLastEntryId = $aVals['entry_id'];
}
$aEntry = Phpfox::getService('contest.entry')->getContestEntryById($iLastEntryId);
Phpfox::getService('contest.contest.process')->sendNotificationAndEmail('inform_winning_entry', $aEntry['contest_id']);
}
