paul999 / phpbb_2fa

	 *

	 * @return bool

	 */

	protected function check_table_for_user($table, $user_id)

	{

		$sql = 'SELECT COUNT(registration_id) as reg_id 

					FROM ' . $table . ' 

					WHERE 

						user_id = ' . (int) $user_id;

		$result = $this->db->sql_query($sql);

		$row = $this->db->sql_fetchrow($result);

		$this->db->sql_freeresult($result);

		return $row && $row['reg_id'] > 0;

	}

}

	 *

	 * @return bool

	 */

	public function is_usable($user_id)

	{

		$sql = 'SELECT COUNT(registration_id) as reg_id 

					FROM ' . $this->otp_registration_table . ' 

					WHERE 

						user_id = ' . (int) $user_id;

		$result = $this->db->sql_query($sql);

		$row = $this->db->sql_fetchrow($result);

		$this->db->sql_freeresult($result);

		return $row && $row['reg_id'] > 0;

	}

	/**

	 * Check if the user can potentially use this.

	 * @param integer $user_id

	 * @return array

	 */

	private function getRegistrations($user_id)

	{

		$sql = 'SELECT * FROM ' . $this->otp_registration_table . ' WHERE user_id = ' . (int) $user_id;

		$result = $this->db->sql_query($sql);

		$rows = $this->db->sql_fetchrowset($result);

		$this->db->sql_freeresult($result);

		return $rows;

	}

}