View difference between Paste ID: snkGnn8e and cRwp4LYa

 package;
 
 import openfl.Lib;
 import sys.db.Connection;
 import sys.db.Sqlite;
 
 /**
  * ...
  * @author Reka
  */
 class Database
 {
 	static var questionID:Int = 1;
 	static var myAnswerContainer:Answer;
 
 	public static function resetQuestionID()
 	{
 		questionID = 1;
 	}
 
 	/**
 	 * Load the information of the next question, answer options and correct index.
 	 * Also resets the timer variables.
 	 */
 	public static function loadQuestion()
 	{
 		var questionText:String = "";
 		var answer1Text:String = "";
 		var answer2Text:String = "";
 		var answer3Text:String = "";
 		var correctAnswer:Int = 1;
 
 		var db = Sqlite.open("img/databass.db");
 		var result = db.request("SELECT * FROM QnA WHERE QuestionID==" + questionID);
 		for (row in result)
 		{
 			questionText = row.Question;
 			answer1Text = row.Answer1;
 			answer2Text = row.Answer2;
 			if (row.Answer3 != null){
 				answer3Text = row.Answer3;
 			}
 			correctAnswer = row.CorrectAnswer;
 		}
 		db.close();
 
 		myAnswerContainer = new Answer(questionText, answer1Text, answer2Text, answer3Text, correctAnswer);
 		return myAnswerContainer;
 	}
 
 	/**
 	 * Check the given answer against the correct answer.
 	 * If correct answer, add points. Otherwise subtract.
 	 * Whichever: update the score field and load the next question.
 	 *
 	 * @param	fieldIndex The index of the answer given.
 	 */
 	public static function checkAnswer(fieldIndex:Int)
 	{
 		var newQuestionID = 0;
 		var db = Sqlite.open("img/databass.db");
 		var result = db.request("SELECT * FROM QnA WHERE QuestionID==" + questionID);
 		for (row in result)
 		{
 			if (fieldIndex == 1)
 				newQuestionID = row.A1Next;
 			else if (fieldIndex == 2)
 				newQuestionID = row.A2Next;
 			else if (fieldIndex == 3){
 				if (row.A3Next != null){
 					newQuestionID = row.A3Next;
 				} else {
 					return;
 				}
 
 			}
 		}
 		db.close();
 
 		//scoreDisplay.text = Std.string(score);
 		questionID = newQuestionID;
 	}
 
 	public static function PostScore(playerName:String, playerScore:Int)
 	{
 		var db = Sqlite.open("img/hallofame.db");
 		db.request("INSERT INTO hallofame (Player,Score) VALUES ('" + playerName + "'," + Std.string(playerScore) + ")");
 		db.close();
 	}
 
 	// Get the 10 highest scoring players from the leaderboard table in the database
 	public static function GetScores()
 	{
 		var db = Sqlite.open("img/hallofame.db");
 		var results = db.request("SELECT * FROM hallofame ORDER BY Score DESC limit 10");
 		var entries:Array<Leaderboard> = new Array<Leaderboard>();
 		for (row in results)
 		{
 			var entry:Leaderboard = new Leaderboard(row.Player, row.Score);
 			entries.push( entry );
 		}
 		db.close();
 		return entries;
 	}
 }