/** * $.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); }