public void Initialize(DatabaseClient dbClient)
{
Logging.Write("Loading Catalogue..");
this.Pages = new Dictionary<int, CatalogPage>();
this.EcotronRewards = new List<EcotronReward>();
DataTable Table = dbClient.ReadDataTable("SELECT * FROM catalog_pages ORDER BY order_num ASC");
DataTable dataTable2 = dbClient.ReadDataTable("SELECT * FROM ecotron_rewards ORDER BY item_id");
try
{
this.mCacheID = (uint)dbClient.ReadDataRow("SELECT ID FROM items ORDER BY ID DESC LIMIT 1")[0];
}
catch
{
this.mCacheID = 0;
}
this.mCacheID += 1;
Hashtable cataItems = new Hashtable();
DataTable dataTable3 = dbClient.ReadDataTable("SELECT * FROM catalog_items");
if (dataTable3 != null)
{
foreach (DataRow dataRow in dataTable3.Rows)
{
if (!(dataRow["item_ids"].ToString() == "") && (int)dataRow["amount"] > 0)
{
cataItems.Add((uint)dataRow["Id"], new CatalogItem((uint)dataRow["Id"], (string)dataRow["catalog_name"], (string)dataRow["item_ids"], (int)dataRow["cost_credits"], (int)dataRow["cost_pixels"], (int)dataRow["cost_snow"], (int)dataRow["amount"], (int)dataRow["page_id"], PhoenixEnvironment.EnumToInt(dataRow["vip"].ToString()), (uint)dataRow["achievement"], (int)dataRow["song_id"]));
}
}
}
if (Table != null)
{
foreach (DataRow Row in Table.Rows)
{
bool Visible = false;
bool Enabled = false;
if (Row["visible"].ToString() == "1")
{
Visible = true;
}
if (Row["enabled"].ToString() == "1")
{
Enabled = true;
}
this.Pages.Add((int)Row["Id"], new CatalogPage((int)Row["Id"], (int)Row["parent_id"], (string)Row["caption"], Visible, Enabled, (uint)Row["min_rank"], PhoenixEnvironment.EnumToBool(Row["club_only"].ToString()), (int)Row["icon_color"], (int)Row["icon_image"], (string)Row["page_layout"], (string)Row["page_headline"], (string)Row["page_teaser"], (string)Row["page_special"], (string)Row["page_text1"], (string)Row["page_text2"], (string)Row["page_text_details"], (string)Row["page_text_teaser"], (string)Row["page_link_description"], (string)Row["page_link_pagename"], ref cataItems));
}
}
if (dataTable2 != null)
{
foreach (DataRow dataRow in dataTable2.Rows)
{
this.EcotronRewards.Add(new EcotronReward((uint)dataRow["Id"], (uint)dataRow["display_id"], (uint)dataRow["item_id"], (uint)dataRow["reward_level"]));
}
}
Logging.WriteLine("completed!");
}
public static void UpdateGroup(DatabaseClient dbClient, int id)
{
Group group = GroupManager.GetGroup(id);
if (group != null)
{
DataRow Row = dbClient.ReadDataRow("SELECT * FROM groups WHERE Id = " + id + " LIMIT 1");
group.Name = (string)Row["name"];
group.Badge = (string)Row["badge"];
group.RoomId = (uint)Row["roomid"];
group.Desc = (string)Row["desc"];
group.Locked = (string)Row["locked"];
group.List.Clear();
DataTable dataTable = dbClient.ReadDataTable("SELECT userid FROM group_memberships WHERE groupid = " + id + ";");
foreach (DataRow row2 in dataTable.Rows)
{
group.AddMember((int)row2["userid"]);
}
}
}
public void LoadSettings(DatabaseClient adapter)
{
Logging.Write("Loading your settings..");
DataRow Row = adapter.ReadDataRow("SELECT * FROM server_settings LIMIT 1");
GlobalClass.MaxRoomsPerUser = (int)Row["MaxRoomsPerUser"];
GlobalClass.Motd = (string)Row["motd"];
GlobalClass.Timer = (int)Row["timer"];
GlobalClass.Credits = (int)Row["credits"];
GlobalClass.Pixels = (int)Row["pixels"];
GlobalClass.Points = (int)Row["points"];
GlobalClass.pixels_max = (int)Row["pixels_max"];
GlobalClass.credits_max = (int)Row["credits_max"];
GlobalClass.points_max = (int)Row["points_max"];
GlobalClass.MaxPetsPerRoom = (int)Row["MaxPetsPerRoom"];
GlobalClass.MaxMarketPlacePrice = (int)Row["MaxMarketPlacePrice"];
GlobalClass.MarketPlaceTax = (int)Row["MarketPlaceTax"];
GlobalClass.AntiDDoSEnabled = PhoenixEnvironment.EnumToBool(Row["enable_antiddos"].ToString());
GlobalClass.VIPclothesforHCusers = PhoenixEnvironment.EnumToBool(Row["vipclothesforhcusers"].ToString());
GlobalClass.RecordChatlogs = PhoenixEnvironment.EnumToBool(Row["enable_chatlogs"].ToString());
GlobalClass.RecordCmdlogs = PhoenixEnvironment.EnumToBool(Row["enable_cmdlogs"].ToString());
GlobalClass.RecordRoomVisits = PhoenixEnvironment.EnumToBool(Row["enable_roomlogs"].ToString());
GlobalClass.ExternalLinkMode = (string)Row["enable_externalchatlinks"];
GlobalClass.SecureSessions = PhoenixEnvironment.EnumToBool(Row["enable_securesessions"].ToString());
GlobalClass.AllowFriendlyFurni = PhoenixEnvironment.EnumToBool(Row["allow_friendfurnidrops"].ToString());
GlobalClass.cmdRedeemCredits = PhoenixEnvironment.EnumToBool(Row["enable_cmd_redeemcredits"].ToString());
GlobalClass.UnloadCrashedRooms = PhoenixEnvironment.EnumToBool(Row["unload_crashedrooms"].ToString());
GlobalClass.ShowUsersAndRoomsInAbout = PhoenixEnvironment.EnumToBool(Row["ShowUsersAndRoomsInAbout"].ToString());
GlobalClass.IdleSleep = (int)Row["idlesleep"];
GlobalClass.IdleKick = (int)Row["idlekick"];
GlobalClass.UseIP_Last = PhoenixEnvironment.EnumToBool(Row["ip_lastforbans"].ToString());
Logging.WriteLine("completed!");
}