/// <summary> /// Update the filter applied to the character list data grid view. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TimerFilterUpdate(object sender, EventArgs e) { timerFilter.Stop(); string filter = ""; if (textBoxFilter.Text.Length > 2) { string filterText = textBoxFilter.Text; if (filter != "") { filter += " AND "; } filter += "((AccID = '" + FLUtility.EscapeEqualsExpressionString(filterText) + "') " + " OR (AccDir = '" + FLUtility.EscapeLikeExpressionString(filterText) + "') " + " OR (BanReason LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } if (checkBoxShowExpiredBans.Checked) { if (filter != "") { filter += " AND "; } filter += "(BanEnd < #" + String.Format("{0:s}", DateTime.Now.ToUniversalTime()) + "#)"; } banListBindingSource.Filter = filter; }
/// <summary> /// Update the filter applied to the character list data grid view. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FilterUpdate() { string filterBase = "(ItemType = '" + FLGameData.GAMEDATA_BASES + "')"; if (textBox1.Text.Length > 0) { string filterText = textBox1.Text; if (filterBase != null) { filterBase += " AND "; } filterBase += "((ItemNickName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%')"; filterBase += "OR (IDSName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } hashListBindingSource.Filter = filterBase; string filterSystem = "(ItemType = '" + FLGameData.GAMEDATA_SYSTEMS + "')"; if (textBox1.Text.Length > 0) { string filterText = textBox1.Text; if (filterSystem != null) { filterSystem += " AND "; } filterSystem += "((ItemNickName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%')"; filterSystem += "OR (IDSName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } hashListBindingSource1.Filter = filterSystem; }
private void textBox1_TextChanged(object sender, EventArgs e) { string filterText = FLUtility.EscapeLikeExpressionString(textBox1.Text); if (filterText == "") { generalStatisticsTableBindingSource.Filter = null; return; } string expr = "(Description LIKE '%" + filterText + "%')"; generalStatisticsTableBindingSource.Filter = expr; }
private void buttonSearch_Click(object sender, EventArgs e) { string filterText = FLUtility.EscapeLikeExpressionString(textBoxSearch.Text); if (filterText == "") { infocardsBindingSource.Filter = null; return; } string expr = "(desc LIKE '%" + filterText + "%')"; expr += " OR (text LIKE '%" + filterText + "%')"; infocardsBindingSource.Filter = expr; }
/// <summary> /// Update the filter applied to the character list data grid view. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FilterUpdate() { string filter = "("; if (defaultGameDataType.Length > 0) { filter += "(ItemType = '" + defaultGameDataType + "')"; } if (checkBoxShowAllTypes.Checked || defaultGameDataType.Length == 0) { if (filter.Length > 1) { filter += " OR "; } filter += "(ItemType = '" + FLGameData.GAMEDATA_GUNS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_TURRETS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_MINES + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_PROJECTILES + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_SHIELDS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_THRUSTERS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_CM + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_CLOAK + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_LIGHTS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_MISC + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_SCANNERS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_TRACTORS + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_ENGINES + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_ARMOR + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_FX + "') OR "; filter += "(ItemType = '" + FLGameData.GAMEDATA_POWERGEN + "')"; } filter += ")"; if (textBox1.Text.Length > 0) { string filterText = textBox1.Text; if (filter != null) { filter += " AND "; } filter += "((IDSName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%')"; filter += " OR (ItemNickName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%')"; filter += " OR (ItemType LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } if (filter.Length > 2) { hashListBindingSource.Filter = filter; } }
private void textBox1_TextChanged(object sender, EventArgs e) { string filterText = FLUtility.EscapeLikeExpressionString(textBox1.Text); if (filterText == "") { gameDataTableBindingSource.Filter = null; return; } string expr = "(itemInfo LIKE '%" + filterText + "%')"; expr += " OR (itemKeys LIKE '%" + filterText + "%')"; expr += " OR (itemGameDataType LIKE '%" + filterText + "%')"; expr += " OR (itemNickname LIKE '%" + filterText + "%')"; gameDataTableBindingSource.Filter = expr; }
/// <summary> /// Update the filter applied to the character list data grid view. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FilterUpdate() { // gameDataTableBindingSource.Filter string filter = "(ItemType = '" + FLGameData.GAMEDATA_SHIPS + "')"; if (textBox1.Text.Length > 0) { string filterText = textBox1.Text; if (filter != null) { filter += " AND "; } filter += "((ItemNickName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%')"; filter += "OR (IDSName LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } hashListBindingSource.Filter = filter; }
private void timer1_Tick(object sender, EventArgs e) { string filterText = FLUtility.EscapeLikeExpressionString(textBox1.Text); if (filterText == "") { hashListBindingSource.Filter = null; return; } string expr = "(ItemType = '%" + filterText + "%')"; expr += " OR (ItemNickName LIKE '%" + filterText + "%')"; expr += " OR (IDSName LIKE '%" + filterText + "%')"; expr += " OR (IDSInfo LIKE '%" + filterText + "%')"; expr += " OR (IDSInfo1 LIKE '%" + filterText + "%')"; expr += " OR (IDSInfo2 LIKE '%" + filterText + "%')"; expr += " OR (IDSInfo3 LIKE '%" + filterText + "%')"; expr += " OR (ItemKeys LIKE '%" + filterText + "%')"; hashListBindingSource.Filter = expr; }
/// <summary> /// Generate from the results dataset for the specified charNameFilter /// </summary> void GenerateActivityReport(UIDataSet results, string charNameFilter, string title, UIDataSet summaryFactions, DateTime date, bool showChangedOnlineTimeOnly) { string[] colTitles = new string[] { "Name", "Last On Line", "On Line Time" }; string[] colNames = new string[] { "Name", "LastOnLine", "OnLineTime" }; // Prepare the filepath to save the HTML. string escapedFactionName = Regex.Replace(charNameFilter, @"[?:\\/*""<>|]", ""); string filePath = String.Format("{0}\\activity_{1}.html", AppSettings.Default.setStatisticsDir, escapedFactionName); if (date > DateTime.MinValue) { filePath = String.Format("{0}\\activity_{1:yyyyMMdd}.html", AppSettings.Default.setStatisticsDir, date); } // Filter and sort the results table. string query = "(Name LIKE '" + FLUtility.EscapeLikeExpressionString(charNameFilter) + "%'" + " OR Name LIKE '%" + FLUtility.EscapeLikeExpressionString(charNameFilter) + "')"; if (showChangedOnlineTimeOnly) { query += " AND OnLineSecs > 0"; } DataRow[] rows = results.StatPlayer.Select(query, "OnLineTime DESC"); // Save it. SaveAsHTML(filePath, title, rows, colTitles, colNames, 0, rows.Length); // Update faction activity summary table to generate the index table later. string linkName = HtmlEncode(filePath.Substring(AppSettings.Default.setStatisticsDir.Length + 1)); linkName = String.Format("<a href=\"{0}\">{1}</a>", HtmlEncode(linkName), HtmlEncode(linkName)); TimeSpan totalOnLineTime = TimeSpan.Zero; foreach (UIDataSet.StatPlayerRow row in (UIDataSet.StatPlayerRow[])rows) { totalOnLineTime += row.OnLineTime; } summaryFactions.StatPlayer.AddStatPlayerRow(linkName, totalOnLineTime, 0, 0, DateTime.Now, (int)totalOnLineTime.TotalSeconds); }
private void buttonSearch_Click(object sender, EventArgs e) { label2.Text = "Matching Accounts - Searching"; string loginid = FLUtility.EscapeLikeExpressionString(textBox1.Text); dataAccess.GetLoginIDListByLoginID(damDataSet.LoginIDList, loginid); if (checkBoxOnlyNewest.Checked) { for (int i = 0; i < damDataSet.LoginIDList.Count; i++) { DamDataSet.LoginIDListRow row = damDataSet.LoginIDList[i]; if (dataAccess.GetLatestLoginIDRowByAccDir(row.AccDir).LoginID != row.LoginID) { damDataSet.LoginIDList.RemoveLoginIDListRow(row); i--; } } } label2.Text = "Matching Accounts"; }
private void buttonSearch_Click(object sender, EventArgs e) { label2.Text = "Matching Accounts - Searching"; dataAccess.GetIPListByIP(damDataSet.IPList, FLUtility.EscapeLikeExpressionString(textBox1.Text)); label2.Text = "Matching Accounts"; }