public IEnumerator SyncPlayerInfo()
{
LocalDBController.DeleteAll <PlayerInfo>();
LocalDBController.InsertOrReplace(_playerInfo);
if (_playerInfo.PlayerID == null)
{
yield return(RegisterPlayerToServer());
}
if (_playerInfo.PlayerID != null)
{
yield return(ServerController.Post <string>(
$@"PlayerInfo/Update?id={GetPlayerID}",
_playerInfo,
// On Successfully connect to the account
respnse =>
{
if (respnse == "Success")
{
_playerInfo.Dirty = false;
}
}));
}
LocalDBController.DeleteAll <PlayerInfo>();
LocalDBController.InsertOrReplace(_playerInfo);
}
public void CheckPlayerInfo()
{
_playerInfo =
LocalDBController
.Table <PlayerInfo>()
.FirstOrDefault();
if (_playerInfo == null)
{
FollowMachine.SetOutput("No Player Info");
}
else if (_playerInfo.PlayerID == null || _playerInfo.PlayerID == -1)
{
if (_playerInfo.PlayerID == -1)
{
_playerInfo.PlayerID = null;
LocalDBController.DeleteAll <PlayerInfo>();
LocalDBController.InsertOrReplace(_playerInfo);
}
FollowMachine.SetOutput("No Player ID");
}
else
{
FollowMachine.SetOutput("Has Player ID");
}
}
private void UpdatePlayerId(int newplayerid)
{
List <Purchases> purchaseses = new List <Purchases>();
purchaseses = LocalDBController.Table <Purchases>().ToList();
LocalDBController.DeleteAll <Purchases>();
foreach (Purchases purchases in purchaseses)
{
purchases.PlayerID = newplayerid;
purchases.Dirty = true;
LocalDBController.InsertOrReplace(purchases);
}
StartCoroutine(SyncPurchases());
}
private void UpdatePlayerId(int newplayerid)
{
List <PlayPuzzles> table = new List <PlayPuzzles>();
table = LocalDBController.Table <PlayPuzzles>().ToList();
LocalDBController.DeleteAll <PlayPuzzles>();
foreach (PlayPuzzles playPuzzle in table)
{
playPuzzle.PlayerID = newplayerid;
playPuzzle.Dirty = true;
LocalDBController.InsertOrReplace(playPuzzle);
}
StartCoroutine(Sync());
}
private IEnumerator FlashOutLocalLogins()
{
List <LogIn> logIns =
LocalDBController.Table <LogIn>().ToList();
yield return(ServerController.Post <int>(
@"/api/Login/AddRange",
logIns,
r =>
{
if (logIns.Count == r)
{
LocalDBController.DeleteAll <LogIn>();
}
}));
}
public IEnumerator SyncPlayerInfo()
{
LocalDBController.DeleteAll <PlayerInfo>();
LocalDBController.InsertOrReplace(_playerInfo);
if (_playerInfo.PlayerID == null)
{
yield return(RegisterPlayer());
}
if (_playerInfo.PlayerID != null)
{
yield return(ServerController.Post <string>(
$@"PlayerInfo/Update?id={GetPlayerID}",
_playerInfo,
// On Successfully connect to the account
respnse =>
{
if (respnse == "Success")
{
_playerInfo.Dirty = false;
LocalDBController.DeleteAll <PlayerInfo>();
LocalDBController.InsertOrReplace(_playerInfo);
}
}));
string pusheId = FindObjectsOfType <Pushe>()[0].Pid;
if (pusheId == "")
{
Debug.Log("no push id");
}
else
{
yield return(ServerControllerBase.Post <string>(
$@"PushIDs/Update?playerID={_playerInfo.PlayerID}",
pusheId,
Debug.Log
));
}
}
}
public override void OnInspectorGUI()
{
_databaseComponent = target as DatabaseComponent;
#region ReloadAll
if (GUILayout.Button("ReloadAll"))
{
// read all categories
var categories = ServerEditor.Get <List <Category> >(@"Categories", "Download categories", "Download");
if (categories == null)
{
return;
}
_databaseComponent.SetCategories(categories);
// read all puzzles
List <Puzzle> puzzles = ServerEditor.Get <List <Puzzle> >(@"Puzzles", "Download puzzles", "Download");
if (puzzles == null)
{
return;
}
_databaseComponent.SetPuzzles(puzzles);
// create game objects
_databaseComponent.ReloadAll();
}
#endregion
#region UpdateData All
if (GUILayout.Button("UpdateData All"))
{
// Update categories
var categoryComponents = _databaseComponent.GetComponentsInChildren <CategoryComponent>();
foreach (var categoryComponent in categoryComponents)
{
if (categoryComponent.Dirty)
{
CategoryEditor.UpdateServer(categoryComponent);
}
}
//Update puzzles
var puzzleComponents = _databaseComponent.GetComponentsInChildren <PuzzleComponent>();
foreach (var puzzleComponent in puzzleComponents)
{
if (puzzleComponent.Dirty)
{
PuzzleEditor.UpdateServer(puzzleComponent);
}
}
}
#endregion
#region Sync localDB
if (GUILayout.Button("Sync All with localDB"))
{
// read all categories
var categories = ServerEditor.Get <List <Category> >(@"Categories", "Download categories", "Download");
if (categories == null)
{
return;
}
// read all puzzles
List <Puzzle> puzzles = ServerEditor.Get <List <Puzzle> >(@"Puzzles", "Download puzzles", "Download");
if (puzzles == null)
{
return;
}
LocalDBController.DeleteAll <Category>();
LocalDBController.DeleteAll <Puzzle>();
foreach (Category category in categories)
{
LocalDBController.InsertOrReplace(category);
}
foreach (Puzzle puzzle in puzzles)
{
LocalDBController.InsertOrReplace(puzzle);
}
}
#endregion
}
