private void DrawPublicPoint()
{
if (_rankingData != null)
{
Vector2[] publicPoint;
foreach (KeyValuePair <string, PublicDataStruct[]> dic in _publicData.publicDatas)
{
if (_rankingData.rankingData != null && (_rankingData.rankingData.ContainsKey(dic.Key) && _rankingData.rankingData[dic.Key]._show))
{
publicPoint = new Vector2[] { new Vector2(0f, 0f) };
foreach (PublicDataStruct data in dic.Value)
{
Array.Resize(ref publicPoint, publicPoint.Length + 1);
float x = 48f - ((float)(_endDt - ((DateTime)data.DateTime)).TotalMinutes / 60f);
float y = (float)data.Progress;
publicPoint[publicPoint.Length - 1] = new Vector2(x, y);
// Debug.Log(((_endDt-((DateTime)row[0])).TotalMinutes)/60);
}
GUIChartEditor.PushLineChart(publicPoint, _rankingData.rankingData[dic.Key]._color);
}
}
}
else
{
if (_rankingData == null)
{
_rankingData = ScriptableObject.CreateInstance <RankingData>();
}
RankingDataImport();
}
}
private void RankingDataImport()
{
RankingData rankingData = AssetDatabase.LoadAssetAtPath <RankingData>(GameJam2020inWinterProgress.RankingAssetPath);
if (rankingData == null)
{
return;
}
_rankingData = rankingData;
}
private void Awake()
{
if (_localData == null)
{
_localData = ScriptableObject.CreateInstance <LocalData>();
}
LocalDataImport();
if (_rankingData == null)
{
_rankingData = ScriptableObject.CreateInstance <RankingData>();
}
RankingDataImport();
MakePublicData();
}
void Awake()
{
try
{
if (_localData == null)
{
_localData = ScriptableObject.CreateInstance <LocalData>();
}
LocalDataImport();
if (_rankingData == null)
{
_rankingData = ScriptableObject.CreateInstance <RankingData>();
}
RankingDataImport();
MySQLUtil.DBConnection();
string _selectUserProgress =
"select tbl1.Name ,tbl1.UpdateTime,tbl1.Progress,tbl1.URL,tbl1.Comment,tbl1.Title " +
"FROM Cluster.GameJam2020inWinter as tbl1 " +
"INNER JOIN ( "+
" SELECT tbl2.Name,UpdateTime ,MAX(Progress) as MAXProgress " +
"FROM Cluster.GameJam2020inWinter " +
" INNER JOIN ( " +
"SELECT Name, MAX(UpdateTime) as LastTime " +
"FROM Cluster.GameJam2020inWinter " +
"GROUP BY Name " +
")as tbl2 " +
"Where UpdateTime = tbl2.LastTime " +
"GROUP BY Name "+
") as tbl3 " +
"where tbl1.UpdateTime = tbl3.UpdateTime and Progress =tbl3.MAXProgress AND tbl1.Name =tbl3.Name " +
"ORDER BY Progress DESC,tbl1.UpdateTime ASC " +
"; ";
DataTable tbl = MySQLUtil.DBSelect(_selectUserProgress);
foreach (DataRow row in tbl.Rows)
{
if (_rankingData.rankingData.ContainsKey(row["Name"].ToString()))
{
_rankingData.rankingData[row["Name"].ToString()]._progress = (int)row["Progress"];
_rankingData.rankingData[row["Name"].ToString()]._comment = row["Comment"].ToString();
_rankingData.rankingData[row["Name"].ToString()]._url = row["URL"].ToString();
_rankingData.rankingData[row["Name"].ToString()]._title = row["Title"].ToString();
_rankingData.rankingData[row["Name"].ToString()]._dateTime = (DateTime)row["UPdateTime"];
}
else
{
RankingDataStruct rankingDataStruct = new RankingDataStruct();
rankingDataStruct._progress = (int)row["Progress"];
rankingDataStruct._comment = row["Comment"].ToString();
rankingDataStruct._url = row["URL"].ToString();
rankingDataStruct._title = row["Title"].ToString();
rankingDataStruct._dateTime = (DateTime)row["UPdateTime"];
_rankingData.rankingData.Add(row["Name"].ToString(), rankingDataStruct);
}
}
MySQLUtil.DBClose();
}
catch (Exception e)
{
Debug.Log("error");
Debug.Log(e);
MySQLUtil.DBClose();
}
}