/**
* Run a given achievement
*
* @param int $iId
*/
public function runAchievement($iId)
{
$aQuery = $this->database()->select('a._table, a.type, a.has_prefix, a.col_user, a.col_operator, a.col_value, a.built_query, a.activity_points, a.title, a.change_user_group, a.moderation_col_name, a.moderation_col_operator, a.moderation_col_value, u.item_id, g.change_id as upgrade_user_group')->from($this->_sTable, 'a')->leftjoin(Phpfox::getT('ko_achievements_user'), 'u', 'u.user_id = ' . Phpfox::getUserId() . ' AND u.achievement_id = a.achieve_id')->leftjoin(Phpfox::getT('ko_achievements_group_change'), 'g', 'g.achieve_id = a.achieve_id AND g.group_id = ' . PhpFox::getUserBy('user_group_id'))->where('a.achieve_id = ' . (int) $iId)->execute('getRow');
if (count($aQuery) == 0 || isset($aQuery['item_id'])) {
return false;
}
if ($aQuery['type'] == 1) {
$iCheck = $this->database()->select('COUNT(*)')->from($aQuery['has_prefix'] == 1 ? Phpfox::getT($aQuery['_table']) : $aQuery['_table'])->where($aQuery['col_user'] . ' = ' . Phpfox::getUserId() . ' AND ' . $aQuery['built_query'])->execute('getField');
} else {
$this->setUpWhere(Phpfox::getUserId(), $aQuery['col_user'], $aQuery['moderation_col_name'], $aQuery['moderation_col_operator'], $aQuery['moderation_col_value']);
$iCheck = $this->database()->select('COUNT(*)')->from($aQuery['has_prefix'] == 1 ? Phpfox::getT($aQuery['_table']) : $aQuery['_table'])->execute('getField');
if ($iCheck > 0) {
eval('$sIf = $iCheck' . $this->operator($aQuery['col_operator']) . $aQuery['col_value'] . ';');
if ($sIf === true) {
$iCheck = true;
} else {
$iCheck = false;
}
}
}
if ($iCheck) {
$iInsert = $this->database()->insert(Phpfox::getT('ko_achievements_user'), array('user_id' => Phpfox::getUserId(), 'achievement_id' => (int) $iId, 'time' => PHPFOX_TIME), true);
if ($aQuery['change_user_group'] > 0 && isset($aQuery['upgrade_user_group'])) {
Phpfox::getService('user.process')->updateUserGroup(Phpfox::getUserId(), $aQuery['change_user_group']);
}
if ($aQuery['activity_points'] > 0) {
$this->database()->update(Phpfox::getT('user_activity'), array('activity_achievements' => array('= activity_achievements +', 1), 'activity_total' => array('= activity_total +', 1), 'activity_points' => array('= activity_points +', $aQuery['activity_points'])), 'user_id = ' . Phpfox::getUserId());
}
/**
* Depreciated
if( Phpfox::isModule('notification') && Phpfox::getParam('achievements.send_notification') )
{
Phpfox::getService('notification.process')->add('achievements_new', (int) $iId, Phpfox::getUserId());
} */
if (Phpfox::isModule('feed') && Phpfox::getParam('achievements.on_feed')) {
Phpfox::getService('feed.process')->add('achievements', $iInsert);
}
if (Phpfox::getParam('achievements.send_email')) {
$oUrl = Phpfox::getLib('url');
$aFind = array('{urlLogin}', '{urlAchievement}', '{userName}', '{achievementName}');
$aReplace = array($oUrl->makeUrl('user.login'), $oUrl->makeUrl('achievements'), Phpfox::getUserBy('full_name'), $aQuery['title']);
$sSubject = str_replace($aFind, $aReplace, Phpfox::getParam('achievements.email_subject'));
$sMessage = str_replace($aFind, $aReplace, Phpfox::getParam('achievements.email_content'));
Phpfox::getLib('mail')->to(Phpfox::getUserId())->subject($sSubject)->message($sMessage)->notification('achievements.achievements')->send();
}
}
}
