public void PLAY_NORMAL()
{
currentMacthFilter = MatchFilters.NORMAL;
PhotonHashtable NORMAL = new PhotonHashtable()
{
{ "NORMAL", 1 }
};
PhotonNetwork.JoinRandomRoom(NORMAL, (byte)3);
MainUI.SetActive(false);
}
public static List <FileInfo> Match(string searchTerm, MatchFilters filters = MatchFilters.Any)
{
switch (filters)
{
case MatchFilters.Any:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%' UNION SELECT * FROM FileCache WHERE tags LIKE '%{searchTerm}%';"));
}
case MatchFilters.Tags | MatchFilters.Files:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%' AND type=1 UNION SELECT * FROM FileCache WHERE tags LIKE '%{searchTerm}%' AND type=1;"));
}
case MatchFilters.Tags | MatchFilters.Folders:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%' AND type=0 UNION SELECT * FROM FileCache WHERE tags LIKE '%{searchTerm}%' AND type=0;"));
}
case MatchFilters.Files | MatchFilters.Folders:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%';"));
}
case MatchFilters.Tags:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE tags LIKE '%{searchTerm}%';"));
}
case MatchFilters.Files:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%' AND type=1;"));
}
case MatchFilters.Folders:
{
return(_ExecuteMatchQuery($"SELECT * FROM FileCache WHERE name LIKE '%{searchTerm}%' AND type=0;"));
}
default:
{
Console.WriteLine("Invalid search filter");
return(new List <FileInfo>());
}
}
}
