MPOS / php-mpos

   * @return value string Value

   **/

  public function getToken($strToken, $strType=NULL) {

    if (empty($strType) || ! $iToken_id = $this->tokentype->getTypeId($strType)) {

      $this->setErrorMessage('Invalid token type: ' . $strType);

      return false;

    }

    $stmt = $this->mysqli->prepare("SELECT * FROM $this->table WHERE token = ? LIMIT 1");

    if ($stmt && $stmt->bind_param('s', $strToken) && $stmt->execute() && $result = $stmt->get_result())

      return $result->fetch_assoc();

    return $this->sqlError();

   * @return mixed Number of rows on success, false on failure

   */

  public function doesTokenExist($strType=NULL, $account_id=NULL) {

    if (!$iToken_id = $this->tokentype->getTypeId($strType)) {

      $this->setErrorMessage('Invalid token type: ' . $strType);

      return false;

    }

    $stmt = $this->mysqli->prepare("SELECT * FROM $this->table WHERE account_id = ? AND type = ? LIMIT 1");

    if ($stmt && $stmt->bind_param('ii', $account_id, $iToken_id) && $stmt->execute())

      return $stmt->get_result()->num_rows;

    return $this->sqlError();

   * @return mixed Token string on success, false on failure

   **/

  public function createToken($strType, $account_id=NULL) {

    if (!$iToken_id = $this->tokentype->getTypeId($strType)) {

      $this->setErrorMessage('Invalid token type: ' . $strType);

      return false;

    }

    $strToken = bin2hex(openssl_random_pseudo_bytes(32));

    $stmt = $this->mysqli->prepare("

      INSERT INTO $this->table (token, type, account_id)

      VALUES (?, ?, ?)