public static CountCondition ( string tableName, bool dbconOpened, string condition, string operand, string myValue ) : int | ||
tableName | string | |
dbconOpened | bool | |
condition | string | |
operand | string | |
myValue | string | |
return | int |
/* * this is only called on client */ public static string [] StatsMine() { ArrayList stats = new ArrayList(); Sqlite.Open(); /* * is good to add the string stuff like "Pings" * because then client will show this data or not * depending if it matches what want to show. * Maintain the ':' as separator */ stats.Add("Sessions:" + Sqlite.CountCondition(Constants.SessionTable, true, "serverUniqueID", ">", "0").ToString()); stats.Add("Persons:" + Sqlite.CountCondition(Constants.PersonTable, true, "serverUniqueID", ">", "0").ToString()); stats.Add("Jumps:" + Sqlite.CountCondition(Constants.JumpTable, true, "simulated", ">", "0").ToString()); stats.Add("JumpsRj:" + Sqlite.CountCondition(Constants.JumpRjTable, true, "simulated", ">", "0").ToString()); stats.Add("Runs:" + Sqlite.CountCondition(Constants.RunTable, true, "simulated", ">", "0").ToString()); stats.Add("RunsInterval:" + Sqlite.CountCondition(Constants.RunIntervalTable, true, "simulated", ">", "0").ToString()); stats.Add("ReactionTimes:" + Sqlite.CountCondition(Constants.ReactionTimeTable, true, "simulated", ">", "0").ToString()); stats.Add("Pulses:" + Sqlite.CountCondition(Constants.PulseTable, true, "simulated", ">", "0").ToString()); stats.Add("MultiChronopic:" + Sqlite.CountCondition(Constants.MultiChronopicTable, true, "simulated", ">", "0").ToString()); Sqlite.Close(); string [] statsString = Util.ArrayListToString(stats); return(statsString); }