本文整理汇总了C#中IQueryAdapter类的典型用法代码示例。如果您正苦于以下问题：C# IQueryAdapter类的具体用法？C# IQueryAdapter怎么用？C# IQueryAdapter使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
IQueryAdapter类属于命名空间，在下文中一共展示了IQueryAdapter类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ReloadQuests
public void ReloadQuests(IQueryAdapter dbClient)
{
quests.Clear();
//dbClient.setQuery("SELECT * FROM quests");
//DataTable dTable = dbClient.getTable();
//uint id;
//string category;
//int num;
//int type;
//uint goalData;
//string name;
//int reward;
//string dataBit;
//foreach (DataRow dRow in dTable.Rows)
//{
// id = Convert.ToUInt32(dRow["id"]);
// category = (string)dRow["category"];
// num = (int)dRow["series_number"];
// type = (int)dRow["goal_type"];
// goalData = Convert.ToUInt32(dRow["goal_data"]);
// name = (string)dRow["name"];
// reward = (int)dRow["reward"];
// dataBit = (string)dRow["data_bit"];
// Quest quest = new Quest(id, category, num, (QuestType)type, goalData, name, reward, dataBit);
// quests.Add(id, quest);
// AddToCounter(category);
//}
}示例2: LoadTopics
//internal void ClearCategories()
//{
// Categories.Clear();
//}
internal void LoadTopics(IQueryAdapter dbClient)
{
Topics.Clear();
DataTable TopicData = null;
dbClient.setQuery("SELECT id, title, body, subject, known_issue FROM help_topics");
TopicData = dbClient.getTable();
if (TopicData == null)
{
return;
}
foreach (DataRow Row in TopicData.Rows)
{
HelpTopic NewTopic = new HelpTopic(Convert.ToUInt32(Row["id"]), (string)Row["title"], (string)Row["body"], Convert.ToUInt32(Row["subject"]));
Topics.Add(Convert.ToUInt32(Row["id"]), NewTopic);
int Importance = int.Parse(Row["known_issue"].ToString());
if (Importance == 1)
{
KnownIssues.Add(NewTopic);
}
else if (Importance == 2)
{
ImportantTopics.Add(NewTopic);
}
}
}示例3: Group
public Group(DataRow Data, IQueryAdapter dbClient)
{
this.ID = Convert.ToInt32(Data["id"]);
this.Name = Data["name"].ToString();
this.Description = Data["description"].ToString();
this.DateCreated = Data["date_created"].ToString();
this.OwnerID = Convert.ToInt32(Data["users_id"]);
this.RoomID = Convert.ToInt32(Data["rooms_id"]);
this.ColorID1 = Convert.ToInt32(Data["color1"]);
this.ColorID2 = Convert.ToInt32(Data["color2"]);
this.Type = Convert.ToInt32(Data["type"]);
this.RightsType = Convert.ToInt32(Data["rights_type"]);
// Parse badge data
string[] rawData = Data["badge_data"].ToString().Split((char)1);
List<Tuple<int, int, int>> badgeData = new List<Tuple<int,int,int>>();
for (int i = 0; i < rawData.Length; i++)
{
int value1 = int.Parse(rawData[i++]);
int value2 = int.Parse(rawData[i++]);
int value3 = int.Parse(rawData[i]);
badgeData.Add(new Tuple<int, int, int>(value1, value2, value3));
}
this.BadgeData = badgeData;
this.Members = new List<int>();
// Load members
dbClient.setQuery("SELECT * FROM group_memberships WHERE groups_id = @id");
dbClient.addParameter("id", ID);
foreach (DataRow row in dbClient.getTable().Rows)
{
this.Members.Add((int)row["users_id"]);
}
}示例4: Initialize
internal void Initialize(IQueryAdapter dbClient)
{
quests = new Dictionary<uint, Quest>();
questCount = new Dictionary<string, int>();
ReloadQuests(dbClient);
}示例5: GetAchievementLevels
/// <summary>
/// Gets the achievement levels.
/// </summary>
/// <param name="achievements">The achievements.</param>
/// <param name="dbClient">The database client.</param>
internal static void GetAchievementLevels(out Dictionary<string, Achievement> achievements,
IQueryAdapter dbClient)
{
achievements = new Dictionary<string, Achievement>();
dbClient.SetQuery("SELECT * FROM achievements_data");
foreach (DataRow dataRow in dbClient.GetTable().Rows)
{
string achievementName = dataRow["achievement_name"].ToString();
AchievementLevel level = new AchievementLevel((uint) dataRow["achievement_level"], (uint) dataRow["reward_pixels"],
(uint) dataRow["reward_points"], (uint) dataRow["progress_needed"]);
if (!achievements.ContainsKey(achievementName))
achievements.Add(achievementName,
new Achievement((uint) dataRow["id"], achievementName,
dataRow["achievement_category"].ToString()));
if (!achievements[achievementName].CheckLevel(level))
achievements[achievementName].AddLevel(level);
else
YupiWriterManager.WriteLine(
"Was Found a Duplicated Level for: " + achievementName + ", Level: " + level.Level,
"Yupi.Achievements", ConsoleColor.Cyan);
}
}示例6: Init
/// <summary>
/// Initializes the specified database client.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal static void Init(IQueryAdapter dbClient)
{
dbClient.SetQuery("SELECT userpeak FROM server_status");
_userPeak = dbClient.GetInteger();
_lowPriorityStopWatch = new Stopwatch();
_lowPriorityStopWatch.Start();
}示例7: ReloadQuests
private void ReloadQuests(IQueryAdapter dbClient)
{
quests.Clear();
dbClient.setQuery("SELECT * FROM quests");
DataTable dTable = dbClient.getTable();
uint id;
string category;
int num;
int type;
uint goalData;
string name;
int reward;
string dataBit;
foreach (DataRow dRow in dTable.Rows)
{
id = Convert.ToUInt32(dRow["id"]);
category = (string)dRow["category"];
num = (int)dRow["series_number"];
type = (int)dRow["goal_type"];
goalData = Convert.ToUInt32(dRow["goal_data"]);
name = (string)dRow["name"];
reward = (int)dRow["reward"];
dataBit = (string)dRow["data_bit"];
Quest quest = new Quest(id, category, num, (QuestType)type, goalData, name, reward, dataBit);
quests.Add(id, quest);
AddToCounter(category);
}
}示例8: LoadBans
internal void LoadBans(IQueryAdapter dbClient)
{
this.bannedUsernames.Clear();
this.bannedIPs.Clear();
this.bannedMachines.Clear();
dbClient.setQuery("SELECT bantype,value,reason,expire FROM bans");
DataTable table = dbClient.getTable();
double num = (double)CyberEnvironment.GetUnixTimestamp();
foreach (DataRow dataRow in table.Rows)
{
string text = (string)dataRow["value"];
string reasonMessage = (string)dataRow["reason"];
double num2 = (double)dataRow["expire"];
string a = (string)dataRow["bantype"];
ModerationBanType type;
if (a == "user")
{
type = ModerationBanType.USERNAME;
}
else
{
if (a == "ip")
{
type = ModerationBanType.IP;
}
else
{
type = ModerationBanType.MACHINE;
}
}
ModerationBan moderationBan = new ModerationBan(type, text, reasonMessage, num2);
if (num2 > num)
{
if (moderationBan.Type == ModerationBanType.USERNAME)
{
if (!this.bannedUsernames.Contains(text))
{
this.bannedUsernames.Add(text, moderationBan);
}
}
else
{
if (moderationBan.Type == ModerationBanType.IP)
{
if (!this.bannedIPs.Contains(text))
{
this.bannedIPs.Add(text, moderationBan);
}
}
else
{
if (!this.bannedMachines.ContainsKey(text))
{
this.bannedMachines.Add(text, moderationBan);
}
}
}
}
}
}示例9: Init
/// <summary>
/// Initializes the specified database client.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal void Init(IQueryAdapter dbClient)
{
Polls.Clear();
dbClient.SetQuery("SELECT * FROM polls_data WHERE enabled = '1'");
var table = dbClient.GetTable();
if (table == null)
return;
foreach (DataRow dataRow in table.Rows)
{
var num = uint.Parse(dataRow["id"].ToString());
dbClient.SetQuery($"SELECT * FROM polls_questions WHERE poll_id = {num}");
var table2 = dbClient.GetTable();
var list = (from DataRow dataRow2 in table2.Rows select new PollQuestion(uint.Parse(dataRow2["id"].ToString()), (string) dataRow2["question"], int.Parse(dataRow2["answertype"].ToString()), dataRow2["answers"].ToString().Split('|'), (string) dataRow2["correct_answer"])).ToList();
var value = new Poll(num, uint.Parse(dataRow["room_id"].ToString()), (string) dataRow["caption"], (string) dataRow["invitation"], (string) dataRow["greetings"], (string) dataRow["prize"], int.Parse(dataRow["type"].ToString()), list);
Polls.Add(num, value);
}
}示例10: LoadRights
/// <summary>
/// Loads the rights.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal void LoadRights(IQueryAdapter dbClient)
{
ClearRights();
dbClient.SetQuery("SELECT * FROM server_fuses;");
DataTable table = dbClient.GetTable();
if (table == null)
return;
foreach (DataRow dataRow in table.Rows)
if (!_cmdRights.ContainsKey(dataRow["command"].ToString()))
_cmdRights.Add(dataRow["command"].ToString(), dataRow["rank"].ToString());
else
Writer.WriteLine($"Duplicate Fuse Command \"{dataRow[0]}\" found", "Yupi.Fuses");
dbClient.SetQuery("SELECT * FROM server_fuserights");
DataTable table2 = dbClient.GetTable();
if (table2 == null)
return;
foreach (DataRow dataRow2 in table2.Rows)
if ((int) dataRow2["min_sub"] > 0)
_subRights.Add(dataRow2["fuse"].ToString(), (int) dataRow2["min_sub"]);
else
if (!_rights.ContainsKey(dataRow2["fuse"].ToString()))
_rights.Add(dataRow2["fuse"].ToString(), (uint)dataRow2["min_rank"]);
}示例11: InitAchievementManager
internal static void InitAchievementManager(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT achievements.*, achievement_categories.name " +
"FROM achievements " +
"JOIN achievement_categories " +
"ON achievement_categories.id = achievements.category");
DataTable dTable = dbClient.getTable();
achievements = new Dictionary<uint, AchievementBase>();
uint achievementID;
uint levels;
uint badgelevel;
string badge;
int pixelBase;
int pixelMMPORG;
int pixelReward;
string category;
foreach (DataRow dRow in dTable.Rows)
{
achievementID = Convert.ToUInt32(dRow[0]);
levels = Convert.ToUInt32(dRow[1]);
badgelevel = Convert.ToUInt32(dRow[2]);
badge = (string)dRow[3];
pixelBase = (int)dRow[4];
pixelMMPORG = (int)dRow[5];
pixelReward = (int)dRow[6];
category = (string)dRow[8];
AchievementBase achivement = new AchievementBase(achievementID, levels, badgelevel, badge, pixelBase, pixelMMPORG, pixelReward, category);
achievements.Add(achievementID, achivement);
}
}示例12: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.itemID);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.delay = Convert.ToInt32(dRow[0].ToString());
}
else
{
delay = 20;
}
dbClient.setQuery("SELECT triggers_item FROM trigger_in_place WHERE original_trigger = " + this.itemID);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
continue;
this.items.Add(targetItem);
}
}示例13: Init
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
UserPeak = dbClient.getInteger();
_runFrequency = int.Parse(FirewindEnvironment.GetConfig().GetEntry("backgroundworker.interval", "10000")); // leon is crazy, 300!?! (THIS IS MADNESS!!)
}示例14: GetAchievementLevels
internal static void GetAchievementLevels(out Dictionary<string, Achievement> achievements, IQueryAdapter dbClient)
{
achievements = new Dictionary<string, Achievement>();
dbClient.setQuery("SELECT * FROM achievements");
DataTable table = dbClient.getTable();
foreach (DataRow dataRow in table.Rows)
{
uint id = Convert.ToUInt32(dataRow["id"]);
string category = (string)dataRow["category"];
string text = (string)dataRow["group_name"];
int level = (int)dataRow["level"];
int rewardPixels = (int)dataRow["reward_pixels"];
int rewardPoints = (int)dataRow["reward_points"];
int requirement = (int)dataRow["progress_needed"];
AchievementLevel level2 = new AchievementLevel(level, rewardPixels, rewardPoints, requirement);
if (!achievements.ContainsKey(text))
{
Achievement achievement = new Achievement(id, text, category);
achievement.AddLevel(level2);
achievements.Add(text, achievement);
}
else
{
achievements[text].AddLevel(level2);
}
}
}示例15: InitGroups
internal void InitGroups(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT * FROM groups_elements");
DataTable table = dbClient.getTable();
string type;
foreach (DataRow row in table.Rows)
{
type = (string)row["Type"];
GuildsPartsData data = new GuildsPartsData((int)row["Id"], (string)row["ExtraData1"], (string)row["ExtraData2"]);
if (type == "Base")
{
baseBadges.Add(data);
}
else if (data.ExtraData1.StartsWith("symbol_"))
{
symbolBadges.Add(data);
}
else if (type == "Color1")
{
colorBadges1.Add(data);
}
else if (type == "Color2")
{
colorBadges2.Add(data);
}
else if (type == "Color3")
{
colorBadges3.Add(data);
htmlBadges.Add(data.Id, data.ExtraData1);
}
}
}