public static function PasswordRecovery_Execute() { $response = new WebServiceClass(); try { $parameters = WebServiceClass::collectParameters(); $account = da_account::GetAccountByID($parameters->AccountID); if ($account != NULL) { if ($account->email != "" && $parameters->Email == $account->email) { if ($account->confirmation_guid == $parameters->ConfirmationCode) { $accountModificationTime = new DateTime($account->modified_datetime); $currentDateTime = new DateTime(DA_Helper::GetServerDate()); $difference = $currentDateTime->diff($accountModificationTime); if ($difference->d == 0) { $account->pwd_hash = sha1($parameters->Password); $savedAccount = da_account::UpdateAccount($account); if ($savedAccount != NULL && $savedAccount->account_id == $account->account_id) { $response->status = "OK"; $response->message = "Contraseña Actualizada Satisfactoriamente"; WebServiceClass::sendPWRecoveryEmail($account); } else { $response->status = "ERROR"; $response->message = "Solicitud Inválida"; } } else { $response->status = "ERROR"; $response->message = "Solicitud Expirada"; } } else { $response->status = "ERROR"; $response->message = "Solicitud Inválida"; } } else { $response->status = "ERROR"; $response->message = "Solicitud Inválida"; } } else { $response->status = "ERROR"; $response->message = "Solicitud Inválida"; } } catch (Exception $ex) { $response->status = "EXCEPTION"; $response->message = $ex->getMessage(); } return $response; }
/** * * @param be_generic_value_entry $valueEntry * @return be_generic_value_entry */ public static function AddNewEntry($valueEntry) { $created_datetime = DA_Helper::GetServerDate(); $sqlCommand = "INSERT INTO generic_value_log (" . "app_id," . "value_label," . "value," . "value_type_code," . "captured_datetime," . "created_datetime " . ")" . " VALUES(?,?,?,?,?,?)"; $mysqli = DA_Helper::mysqli_connect(); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } if (!($stmt = $mysqli->prepare($sqlCommand))) { echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error; } if (!$stmt->bind_param("isssss", $valueEntry->app_id, $valueEntry->value_label, $valueEntry->value, $valueEntry->value_type_code, $valueEntry->captured_datetime, $created_datetime)) { echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error; } if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } $insertedID = $mysqli->insert_id; $stmt->close(); $retrievedValue = da_generic_value::GetEntry($insertedID); print_r($retrievedValue); return $retrievedValue; }