public function __construct() { $token = Request::header('X-Auth-Token'); $this->user = json_decode(AuthToken::validate($token)); $this->api_token = Input::get('api_token'); $this->page = Input::get('page'); $this->per_page = Input::get('per_page'); $this->type = Input::get('type'); $this->dbConnect = Helpers::dbConnect(); }
public static function SK_registerUser($data = 0) { $dbConnect = Helpers::dbConnect(); //$dbConnect = mysqli_connect($sql_host, $sql_user, $sql_pass, $sql_name,$sql_port); mysqli_set_charset($dbConnect, "utf8"); // Check connection if (mysqli_connect_errno($dbConnect)) { exit(mysqli_connect_error()); } if (!is_array($data)) { return false; } if (!empty($data['name']) && !empty($data['username']) && !empty($data['email']) && !empty($data['password']) && !empty($data['gender'])) { $name = $data['name']; $username = $data['username']; $email = $data['email']; $password = trim($data['password']); $md5_password = md5($password); $gender = $data['gender']; //echo SK_validateUsername($username) . " " . is_numeric($username) . " " . !SK_validateEmail($email) . " " . !preg_match('/(male|female)/', $gender); if (!Helpers::SK_validateUsername($username)) { return false; } if (is_numeric($username)) { return false; } if (!Helpers::SK_validateEmail($email)) { return false; } if (!preg_match('/(male|female)/', $gender)) { return false; } $query_one = "INSERT INTO accounts (active,cover_id,email,email_verification_key,name,password,time,type,username) VALUES (1,0,'{$email}','" . md5(Helpers::SK_generateKey()) . "','{$name}','{$md5_password}'," . time() . ",'user','{$username}')"; $sql_query_one = mysqli_query($dbConnect, $query_one); if ($sql_query_one) { $user_id = mysqli_insert_id($dbConnect); $query_two = "INSERT INTO users (id,gender) VALUES ({$user_id},'{$gender}')"; $sql_query_two = mysqli_query($dbConnect, $query_two); if ($sql_query_two) { //$get = SK_getUser($user_id, true); //return $get; } } } }
public function changePassword() { $params = Input::all(); $old_password = md5(Helpers::SK_secureEncode($params['old_password'])); $new_password = md5(Helpers::SK_secureEncode($params['new_password'])); //$hash = md5($password); $userId = (int) $this->user->id; $dbConnect = Helpers::dbConnect(); if ($old_password && $old_password != $new_password) { $find = mysqli_query($dbConnect, "SELECT password from accounts WHERE id = {$userId} AND password = '******'"); $sql_numrows = mysqli_num_rows($find); if ($sql_numrows == 1) { //$sql_fetch = mysqli_fetch_assoc($sql_query); $res = mysqli_query($dbConnect, "UPDATE accounts SET password = '******' WHERE id = {$userId}"); if ($res) { return Response::json(array('status' => '1', 'message' => 'Success, your password is changed', 'user_id' => $userId)); } else { return Response::json(array('status' => '0', 'message' => 'Failed', 'user_id' => $userId)); } } return Response::json(array('status' => '0', 'message' => 'Failed, more than 1 user found', 'user_id' => $userId)); } return Response::json(array('status' => '0', 'message' => 'Failed, new password should not be same as old password', 'user_id' => $userId)); }