/**
* reset the jcoins for user
*/
public function resetJCoins()
{
$condition = new PreparedStatementConditionBuilder();
$condition->add('user.userID IN (?)', array($this->objectIDs));
// reset it, without set transfer-log
$stmt = WCF::getDB()->prepareStatement('UPDATE wcf' . WCF_N . '_user user SET user.jCoinsBalance = 0 ' . $condition);
$stmt->execute($condition->getParameters());
// trash statements
$list = new UserJcoinsStatementList();
$list->getConditionBuilder()->add('user_jcoins_statement.userID IN (?)', array($this->objectIDs));
$list->readObjectIDs();
// trash statements
$action = new UserJcoinsStatementAction($list->objectIDs, 'trashAll');
$action->executeAction();
$this->unmarkItems();
}
/**
* @see wcf\system\cronjob\ICronjob::execute()
*/
public function execute(Cronjob $cronjob)
{
parent::execute($cronjob);
$statementList = new UserJcoinsStatementList();
$statementList->getConditionBuilder()->add('user_jcoins_statement.time < ?', array(TIME_NOW - 86400 * JCOINS_STATEMENTS_DELETEAFTER));
if (JCOINS_STATEMENTS_DELETEONLYTRASHED) {
$statementList->getConditionBuilder()->add('user_jcoins_statement.isTrashed = ?', array(1));
}
$statementList->readObjects();
if (!$statementList->count()) {
return;
}
$statementAction = new UserJcoinsStatementAction($statementList->getObjects(), 'delete');
$statementAction->executeAction();
}