/**
* Delete reputation page/action
*
* @param int $rid Reputation ID taken from the URL
* @return null
* @access public
*/
public function delete($rid)
{
$this->user->add_lang_ext('pico/reputation', 'reputation_system');
$is_ajax = $this->request->is_ajax();
$submit = false;
$post_type_id = (int) $this->reputation_manager->get_reputation_type_id('post');
$sql_array = array('SELECT' => 'r.*, rt.reputation_type_name, p.post_id, uf.username AS username_from, ut.username AS username_to', 'FROM' => array($this->reputations_table => 'r', $this->reputation_types_table => 'rt'), 'LEFT_JOIN' => array(array('FROM' => array(POSTS_TABLE => 'p'), 'ON' => 'p.post_id = r.reputation_item_id
AND r.reputation_type_id = ' . $post_type_id), array('FROM' => array(USERS_TABLE => 'uf'), 'ON' => 'r.user_id_from = uf.user_id '), array('FROM' => array(USERS_TABLE => 'ut'), 'ON' => 'r.user_id_to = ut.user_id ')), 'WHERE' => 'r.reputation_id = ' . $rid);
$sql = $this->db->sql_build_query('SELECT', $sql_array);
$result = $this->db->sql_query($sql);
$row = $this->db->sql_fetchrow($result);
$this->db->sql_freeresult($result);
//We couldn't find this reputation. May be it was deleted meanwhile?
if (empty($row)) {
$message = $this->user->lang('RS_NO_REPUTATION');
$json_data = array('error_msg' => $message);
$redirect = append_sid("{$this->root_path}index.{$this->php_ext}");
$redirect_text = 'RETURN_INDEX';
$this->reputation_manager->response($message, $json_data, $redirect, $redirect_text, $is_ajax);
}
if ($this->request->is_set_post('cancel')) {
redirect($this->helper->route('reputation_details_controller', array('uid' => $row['user_id_to'])));
}
if ($this->auth->acl_gets('m_rs_moderate') || $row['user_id_from'] == $this->user->data['user_id'] && $this->auth->acl_get('u_rs_delete')) {
if ($is_ajax) {
$submit = true;
} else {
$s_hidden_fields = build_hidden_fields(array('r' => $rid));
if (confirm_box(true)) {
$submit = true;
} else {
confirm_box(false, $this->user->lang('RS_REPUTATION_DELETE_CONFIRM'), $s_hidden_fields);
}
}
} else {
$message = $this->user->lang('RS_USER_CANNOT_DELETE');
$json_data = array('error_msg' => $message);
$redirect = $this->helper->route('reputation_details_controller', array('uid' => $row['user_id_to']));
$redirect_text = 'RETURN_PAGE';
$this->reputation_manager->response($message, $json_data, $redirect, $redirect_text, $is_ajax);
}
if ($submit) {
try {
$this->reputation_manager->delete_reputation($row);
} catch (\pico\reputation\exception\base $e) {
// Catch exception
trigger_error($e->get_message($this->user));
}
$user_reputation = $this->reputation_manager->get_user_reputation($row['user_id_to']);
$message = $this->user->lang('RS_POINTS_DELETED');
$json_data = array('rid' => $rid, 'user_reputation' => $user_reputation);
if (isset($row['post_id'])) {
$post_reputation = $this->reputation_manager->get_post_reputation($row['post_id']);
$json_data = array_merge($json_data, array('poster_id' => $row['user_id_to'], 'post_id' => $row['post_id'], 'post_reputation' => $post_reputation, 'reputation_class' => $this->reputation_helper->reputation_class($post_reputation), 'own_vote' => $row['user_id_from'] == $this->user->data['user_id'] ? true : false));
}
$redirect = $this->helper->route('reputation_details_controller', array('uid' => $row['user_id_to']));
$redirect_text = 'RETURN_PAGE';
$this->reputation_manager->response($message, $json_data, $redirect, $redirect_text, $is_ajax);
}
}
