private static function create_new_token($username) { try { $token = users::generateRandomString(); $dbObj = new dbAPI(); $query = "UPDATE users SET TOKEN = '" . $token . "' where USERNAME = '******'"; $results = $dbObj->run_query($dbObj->db_get_usersDB(), $query); if ($results) { echo $results; return $token; } debugLog::debug_log("create token for user: "******" has failed"); return null; } catch (Exception $e) { echo 'Caught exception: ', $e->getMessage(), "\n"; } }
/** * Returns the Delivery's base from user database * @param {int} $UID The UID of the requested Delivery * @return {DeliveryBase} the requested Delivery */ public static function get_edited_Delivery_by_UID($UID) { // returns the Delivery from user database $dbObj = new dbAPI(); $query = "SELECT * FROM DELIVERY_BASE where UID = '" . $UID . "' AND ENABLED = '1'"; $results = $dbObj->db_select_query($dbObj->db_get_usersDB(), $query); if (count($results) == 0) { return null; } return $results[0]; }
public static function delete_all($dbArr) { $dbObj = new dbAPI(); // $dbArr = array( $u.'.KBIT_BASE', $u.'.KBIT_FRONT', $c.'.KBIT_BASE', $c.'.KBIT_FRONT', $c.'.CONTENT_LOCK'); for ($k = 0; $k < count($dbArr); $k++) { $dbObj->run_query($dbObj->db_get_usersDB(), "DELETE FROM " . $dbArr[$k]); } }