/**
* $.ajax({ method: confirm, user_key: x...x });
*
* status: ok / error
* message: x...x
*/
private function confirm($data)
{
$error = '';
$user_id = db_get_id('JKY_Users', 'user_key = "' . $data['user_key'] . '"');
if (!$user_id) {
$error .= BR . 'User Account already expired';
} else {
if (is_empty(meta_get_id('Contacts', $user_id, 'unconfirmed_email'))) {
$error .= BR . 'Email Address already confirmed';
}
}
$return = array();
if (is_empty($error)) {
meta_delete('User', $user_id, 'unconfirmed_email');
$this->set_user_session($user_id);
$return['status'] = 'ok';
$return['message'] = 'Email Address confirmed';
} else {
$return['status'] = 'error';
$return['message'] = $error;
}
echo json_encode($return);
}
function meta_delete($table, $parent_id, $meta_name)
{
$id = meta_get_id($table, $parent_id, $meta_name);
if (!$id) {
return;
}
$sql = 'DELETE FROM ' . $table . '_metas' . ' WHERE id = ' . $id;
$db = Zend_Registry::get('db');
$db->query($sql);
log_sql($table . '_metas', $id, 'deleted, sql=' . $sql);
}
