void Update()
{
// Don't check chat messages for main menu or end screen
if (Level < 0)
{
return;
}
// Check the number of chat messages for the current level in the database every second (chatUpdateInterval)
if (Time.time > lastChatUpdate + chatUpdateInterval)
{
lastChatUpdate = Time.time;
string query = "Level = '" + Level + "'";
JSON.Select <Chat, JsnReceiver>(query, CheckChatMessageCount, ChatMessageFail);
}
}
// Start is called before the first frame update
void Start()
{
#region Test jsn drop
JSONDropService jsDrop = new JSONDropService {
Token = "6af89c87-4bff-4941-aa38-d306bf9b5690"
};
//Create table person
jsDrop.Create <Player, JsnReceiver>(new Player
{
Room = "UUUUUUUUUUUUUUUUUUUUUUUUUUU",
Password = "******",
Name = "UUUUUUUUUUUUUUUUUUUUUUUUUUU",
Score = 111111
}, jsnReceiverDel);
// Store people records
jsDrop.Store <Player, JsnReceiver>(new List <Player>
{
new Player {
Room = "Starting Room", Password = "******", Name = "John", Score = 1
},
new Player {
Room = "Starting Room", Password = "******", Name = "Joe", Score = 1
},
new Player {
Room = "Starting Room", Password = "******", Name = "Jim", Score = 1
}
}, jsnReceiverDel);
// Retreive all people records
jsDrop.All <Player, JsnReceiver>(jsnListReceiverDel, jsnReceiverDel);
jsDrop.Select <Player, JsnReceiver>("ID > 20", jsnListReceiverDel, jsnReceiverDel);
jsDrop.Delete <Player, JsnReceiver>("ID = 1", jsnReceiverDel);
jsDrop.Drop <Player, JsnReceiver>(jsnReceiverDel);
#endregion
}
// As soon as the script wakes up, set the script up as a singleton and set it to not destroy on level change.
void OnLevelFinishedLoading(Scene scene, LoadSceneMode mode)
{
DontDestroyOnLoad(this.gameObject);
JSON = new JSONDropService {
Token = "d341e18b-b0b5-4d33-a33d-9239ea617e5a"
};
string query = "Level = '" + Level + "'";
JSON.Select <Chat, JsnReceiver>(query, CheckChatMessageCount, ChatMessageFail);
if (instance == null)
{
instance = this;
}
// Find or create necessary objects
player = Object.FindObjectOfType <Player>();
inventory = Object.FindObjectOfType <InventoryManager>();
cmdLine = Object.FindObjectOfType <CommandLine>();
database = new DatabaseManager("GameData.db");
}
