// Start is called before the first frame update void Start() { #region Test jsn drop JSONDropService jsDrop = new JSONDropService { Token = "6c420424-62ad-4218-8b1f-d6cf2115facd" }; // Create table person jsDrop.Create <tblPerson, JsnReceiver>(new tblPerson { PersonID = "UUUUUUUUUUUUUUUUUUUUUUUUUUU", HighScore = 0, Password = "******" }, jsnReceiverDel); /* * // Store people records * jsDrop.Store<tblPerson,JsnReceiver> (new List<tblPerson> * { * new tblPerson{PersonID = "Jack",HighScore = 100,Password ="******"}, * new tblPerson{PersonID = "Jonny",HighScore = 200,Password ="******"}, * new tblPerson{ PersonID = "Jill",HighScore = 300,Password ="******"} * }, jsnReceiverDel); * * // Retreive all people records * jsDrop.All<tblPerson, JsnReceiver>(jsnListReceiverDel, jsnReceiverDel); * * jsDrop.Select<tblPerson,JsnReceiver>("HighScore > 200",jsnListReceiverDel, jsnReceiverDel); * * jsDrop.Delete<tblPerson, JsnReceiver>("PersonID = 'Jonny'", jsnReceiverDel); */ jsDrop.Drop <tblPerson, JsnReceiver>(jsnReceiverDel); #endregion }
// 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"); }