public static function getCurrentInvoices($userID) { $query = MySQL::getInstance()->prepare("SELECT invoiceID, downloadID, amount, UNIX_TIMESTAMP(dueDate) as dueDate, isPending FROM AuthUserInvoices WHERE userID=:userID AND isPaid=0 ORDER BY dueDate"); $query->bindValue(':userID', $userID); $query->execute(); return $query->fetchAll(PDO::FETCH_ASSOC); }
public static function delPaymentProfile($userID, $paymentProfileID) { $query = MySQL::getInstance()->prepare("DELETE FROM AuthUserPaymentProfiles WHERE userID=:userID AND paymentProfileID=:paymentProfileID"); $query->bindValue(':userID', $userID); $query->bindValue(':paymentProfileID', $paymentProfileID); $query->execute(); return $query->rowCount(); }
public static function getEmailVariable($emailKey, $emailLang) { $query = MySQL::getInstance()->prepare("SELECT emailText FROM EmailVariables WHERE emailKey=:emailKey AND emailLang=:emailLang"); $query->bindValue(':emailKey', $emailKey); $query->bindValue(':emailLang', $emailLang); $query->execute(); $temp = $query->fetch(PDO::FETCH_ASSOC); return $temp['emailText']; }
public static function getAvailablePaymentMethods() { $query = MySQL::getInstance()->prepare("SELECT paymentMethodID, paymentMethodName FROM AvailablePaymentMethods WHERE paymentMethodAvailable=1"); $query->execute(); return $query->fetchAll(PDO::FETCH_ASSOC); }
public static function getAvailableFactors() { $query = MySQL::getInstance()->prepare("SELECT factorID, factorType, factorDesc, available FROM AvailableFactors"); $query->execute(); return $query->fetchAll(PDO::FETCH_ASSOC); }
public static function delAuthUserSessions($userID) { $query = MySQL::getInstance()->prepare("DELETE FROM AuthUserSessions WHERE userID=:userID"); $query->bindValue(':userID', $userID); return $query->execute(); }
public static function getAvailablePackages() { $query = MySQL::getInstance()->prepare("SELECT packageID, packageGroup, packageName, packageDesc, packageCycle, packageCyclePrice FROM AvailablePackages WHERE packageAvailable=1 ORDER BY packageGroup, packageID"); $query->execute(); return $query->fetchAll(PDO::FETCH_ASSOC); }