private void Awake()
{
GoalSoundManager = GameObject.Find("GoalSoundManager");
source = GoalSoundManager.GetComponent <AudioSource>();
SystemObject = GameObject.Find("System");
dbscript = SystemObject.GetComponent <DatabaseScript>();
}
internal void OnAuthenticationFinished(string name, string id)
{
DatabaseScript database = new DatabaseScript();
database.initialize(name, id);
database.addToDatabase();
SceneManager.LoadScene("StartScene");
}
public void LoadButtonClicked()
{
string path = UnityEditor.EditorUtility.OpenFilePanel("Open", "", "an");
if (!string.IsNullOrEmpty(path))
{
DatabaseScript.LoadDatabase(path);
}
}
public void SaveButtonClicked()
{
string path = UnityEditor.EditorUtility.SaveFilePanel("Save", "", "default.an", "an");
if (!string.IsNullOrEmpty(path))
{
DatabaseScript.SaveDatabase(path);
}
}
public void updateDatabase()
{
DatabaseScript database = new DatabaseScript();
int prevHighest = DatabaseScript.playerScore;
if (score > prevHighest)
{
database.updateUserScoreToDatabase(score);
}
}
void Awake()
{
myTransform = transform;
goalLineGameobj = GameObject.Find("GoalLineTechnology");
goalLineScript = goalLineGameobj.GetComponent <goalLineTech>();
SystemObject = GameObject.Find("System");
dbscript = SystemObject.GetComponent <DatabaseScript>();
kickAudio = GetComponent <AudioSource>();
}
void updateDatabase()
{
DatabaseScript database = new DatabaseScript();
if (DatabaseScript.userID != null && DatabaseScript.userID != "")
{
int prevHighest = DatabaseScript.playerScore;
if (score > prevHighest)
{
database.updateUserScoreToDatabase(score);
}
}
}
private void Awake()
{
// Store the start rotation.
m_StartRotation = m_Rigidbody.rotation;
speed = 15;
sitting = false;
originalPosition = transform.position;
SoundManager = GameObject.Find("SoundManager");
bgScript = SoundManager.GetComponent <BackgroundSound> ();
SystemObject = GameObject.Find("System");
dbscript = SystemObject.GetComponent <DatabaseScript>();
}
private static void AddDbVersionEntry(DatabaseScript script)
{
_connection.Execute(
"insert into DBVersions (ScriptName, DateExecuted, ScriptMD5, BatchCount) values(@scriptName, @dateExecuted, @scriptMD5, @batchCount)",
new
{
scriptName = script.Name,
dateExecuted = DateTime.Now,
scriptMD5 = script.MD5Hash,
batchCount = script.StatementBatches.Count()
}
);
}
private void Start()
{
bSys = GetComponent <BlockSystem>();
blockData = GetComponent <BlockData>();
blockSelectCounter = 0;
buildModeOn = true;
destroyModeOn = false;
email = username_static.email;
mazeTitle = username_static.mazeTitle;
userId = username_static.userId;
database = GetComponent <DatabaseScript>();
if (!username_static.newMaze)
{
loadBlocks();
}
}
// Update is called once per frame
void Update()
{
transform.FindChild("Frame_text").GetComponent <Text>().text = string.Format("[{0}/{1}]", DatabaseScript.current_frame + 1, DatabaseScript.points_frames.Count);
if (Input.GetKeyDown(KeyCode.A))
{
DatabaseScript.SaveCurrentFrame();
DatabaseScript.MoveBackward();
RedrawFrame();
}
if (Input.GetKeyDown(KeyCode.D))
{
DatabaseScript.SaveCurrentFrame();
DatabaseScript.MoveForward();
RedrawFrame();
}
}
public List <Question> questions = new List <Question>(); // CREATE LIST OF QUESTIONS
private void Start()
{
CheckDatabaseFilesExist();
databaseAccess = FindObjectOfType <DatabaseScript>();
GameObject[] interfaces = GameObject.FindGameObjectsWithTag("Interfaces");
CanvasGroup[] canvasGroups = new CanvasGroup[interfaces.Length];
for (int i = 0; i < interfaces.Length; i++)
{
canvasGroups[i] = interfaces[i].GetComponent <CanvasGroup>();
}
HideAll(canvasGroups);
//foreach (User user in databaseAccess.ReadInAccounts(users))//prints each user out from list
//{
// Debug.Log("Printing...");
// Debug.Log(user.username + user.fullName + user.hashedPassword + user.passwordSalt);
//}
}
private void Start()
{
databaseAccess = FindObjectOfType <DatabaseScript>();
interfaceScriptAccess = FindObjectOfType <InterfaceScript>();
}
void Start()
{
databaseAccess = FindObjectOfType <DatabaseScript>();
variableAccess = FindObjectOfType <Initialisation>();
interfaceScriptAccess = FindObjectOfType <InterfaceScript>();
}
void Start()
{
instance = this;
StartCoroutine ("GetStatements");
StartCoroutine ("GetText");
}
/// <summary>
/// Set SQL2X Queue version to code version
/// </summary>
/// <returns>MVC View with outcome</returns>
//[HttpGet("increaseversiontolatest")]
public ActionResult IncreaseVersionToLatest()
{
string returnMessage = string.Empty;
try {
DatabaseManager databaseManager =
new DatabaseManager(
databaseName: "NorSolutionPim",
toRemote: true // always remote here
);
returnMessage += "Connection" + "\r\n";
returnMessage +=
" "
+ databaseManager.ConnectionStringSanitized
.Replace("=", " = ")
.Replace(";", "\r\n ");
returnMessage += "" + "\r\n";
returnMessage += "" + "\r\n";
string whyNot = string.Empty;
if (databaseManager.IsConnectionGood(out whyNot))
{
returnMessage += DateTime.UtcNow + " " + "Connection is good" + "\r\n";
}
if (databaseManager.IsDatabaseGood())
{
returnMessage += DateTime.UtcNow + " " + "Database is good" + "\r\n";
}
if (databaseManager.IsVersionTableGood())
{
returnMessage += DateTime.UtcNow + " " + "Version table is good" + "\r\n";
}
DatabaseVersion databaseVersion = databaseManager.minimumVersion;
try {
databaseVersion = databaseManager.VersionTableLastEntry();
} catch (Exception ex) {
returnMessage += DateTime.UtcNow + " " + ex.Message;
}
returnMessage += DateTime.UtcNow + " " + "Database Version is; " + databaseVersion.ToString() + "\r\n";
returnMessage += DateTime.UtcNow + " " + "Code Version is; " + databaseManager.maximumVersion.ToString() + "\r\n";
returnMessage += DateTime.UtcNow + " " + "Start Script" + "\r\n";
// execute next script
DatabaseScript nextScript = databaseManager.NextScript();
if (nextScript != null)
{
returnMessage += DateTime.UtcNow + " " + "Script Executed" + " " + "( " + databaseManager.Execute(nextScript, haltOnException: true) + " )" + "\r\n";
if (databaseManager.IsVersionTableGood()) // make sure table exists
{
returnMessage += DateTime.UtcNow + " " + databaseManager.DefaultVersion(nextScript.DatabaseVersion) + "\r\n";
}
returnMessage += DateTime.UtcNow + " " + "End Script" + "\r\n";
// check if version is as expected
try {
databaseVersion = databaseManager.VersionTableLastEntry();
} catch (Exception ex) {
returnMessage += DateTime.UtcNow + " " + ex.Message;
}
// run next script if previous went through
if (nextScript.DatabaseVersion == databaseVersion)
{
returnMessage += DateTime.UtcNow + " " + "Database version is at expected version, running next script";
ViewData["KeepRunning"] = "true";
}
else
{
returnMessage += DateTime.UtcNow + " " + "Database version is not at expected version, halting run to latest";
}
}
else
{
returnMessage += DateTime.UtcNow + " " + "Database version is at last version";
}
} catch (System.Exception ex) {
returnMessage = ExtractException(ex);
}
ViewData["Message"] = returnMessage;
return(View());
}
