public static void InitWords(DatabaseClient dbClient)
{
ChatCommandHandler.list_0.Clear();
ChatCommandHandler.list_1.Clear();
ChatCommandHandler.list_2.Clear();
ChatCommandHandler.list_3.Clear();
DataTable dataTable = dbClient.ReadDataTable("SELECT * FROM wordfilter ORDER BY word ASC;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
ChatCommandHandler.list_0.Add(dataRow["word"].ToString());
ChatCommandHandler.list_1.Add(dataRow["replacement"].ToString());
ChatCommandHandler.list_2.Add(GoldTree.smethod_2(dataRow["strict"].ToString()));
}
}
DataTable dataTable2 = dbClient.ReadDataTable("SELECT * FROM linkfilter;");
if (dataTable2 != null)
{
foreach (DataRow dataRow in dataTable2.Rows)
{
ChatCommandHandler.list_3.Add(dataRow["externalsite"].ToString());
}
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Navigator..");
this.list_0.Clear();
this.dictionary_0.Clear();
this.dictionary_1.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT Id,caption,min_rank,cantrade FROM navigator_flatcats WHERE enabled = '1'");
DataTable dataTable2 = class6_0.ReadDataTable("SELECT Id,bannertype,caption,image,image_type,room_id,category,category_parent_id FROM navigator_publics ORDER BY ordernum ASC;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
this.list_0.Add(new FlatCat((int)dataRow["Id"], (string)dataRow["caption"], (int)dataRow["min_rank"], GoldTree.smethod_3(dataRow["cantrade"].ToString())));
}
}
if (dataTable2 != null)
{
foreach (DataRow dataRow in dataTable2.Rows)
{
this.dictionary_0.Add((int)dataRow["Id"], new PublicItem((int)dataRow["Id"], int.Parse(dataRow["bannertype"].ToString()), (string)dataRow["caption"], (string)dataRow["image"], (dataRow["image_type"].ToString().ToLower() == "internal") ? PublicImageType.INTERNAL : PublicImageType.EXTERNAL, (uint)dataRow["room_id"], GoldTree.smethod_3(dataRow["category"].ToString()), (int)dataRow["category_parent_id"]));
if (!this.dictionary_0[(int)dataRow["Id"]].bool_0)
{
this.dictionary_1.Add((int)dataRow["Id"], this.dictionary_0[(int)dataRow["Id"]]);
}
}
}
Logging.WriteLine("completed!");
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Bot data..");
this.list_0 = new List<RoomBot>();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM bots;");
DataTable dataTable2 = class6_0.ReadDataTable("SELECT Id, bot_id, keywords, response_text, mode, serve_id FROM bots_responses;");
DataTable dataTable3 = class6_0.ReadDataTable("SELECT text, shout, bot_id FROM bots_speech;");
List<BotResponse> list = new List<BotResponse>();
List<RandomSpeech> list2 = new List<RandomSpeech>();
foreach (DataRow dataRow in dataTable2.Rows)
{
list.Add(new BotResponse((uint)dataRow["Id"], (uint)dataRow["bot_id"], (string)dataRow["keywords"], (string)dataRow["response_text"], dataRow["mode"].ToString(), (int)dataRow["serve_id"]));
}
foreach (DataRow dataRow in dataTable3.Rows)
{
list2.Add(new RandomSpeech((string)dataRow["text"], GoldTree.smethod_3(dataRow["shout"].ToString()), (uint)dataRow["bot_id"]));
}
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
string text = (string)dataRow["ai_type"];
string text2 = text;
if (text2 == null)
{
goto IL_201;
}
AIType enum2_;
if (!(text2 == "generic"))
{
if (!(text2 == "guide"))
{
if (!(text2 == "pet"))
{
goto IL_201;
}
enum2_ = AIType.const_0;
}
else
{
enum2_ = AIType.const_1;
}
}
else
{
enum2_ = AIType.const_2;
}
IL_204:
this.list_0.Add(new RoomBot((uint)dataRow["Id"], (uint)dataRow["room_id"], enum2_, (string)dataRow["walk_mode"], (string)dataRow["name"], (string)dataRow["motto"], (string)dataRow["look"], (int)dataRow["x"], (int)dataRow["y"], (int)dataRow["z"], (int)dataRow["rotation"], (int)dataRow["min_x"], (int)dataRow["min_y"], (int)dataRow["max_x"], (int)dataRow["max_y"], ref list2, ref list, (int)dataRow["effect"]));
continue;
IL_201:
enum2_ = AIType.const_2;
goto IL_204;
}
Logging.WriteLine("completed!");
}
}
public static void smethod_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading groups...");
Groups.smethod_1();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM groups;");
foreach (DataRow dataRow in dataTable.Rows)
{
Groups.GroupsManager.Add((int)dataRow["Id"], new GroupsManager((int)dataRow["Id"], dataRow, class6_0));
}
Logging.WriteLine("completed!");
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Help Categories..");
this.dictionary_0.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT Id, caption FROM help_subjects");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
this.dictionary_0.Add((uint)dataRow["Id"], new HelpCategory((uint)dataRow["Id"], (string)dataRow["caption"]));
}
Logging.WriteLine("completed!");
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Room Adverts..");
this.RoomAdvertisements.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM room_ads WHERE enabled = '1'");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
this.RoomAdvertisements.Add(new RoomAdvertisement((uint)dataRow["Id"], (string)dataRow["ad_image"], (string)dataRow["ad_link"], (int)dataRow["views"], (int)dataRow["views_limit"]));
}
Logging.WriteLine("completed!");
}
}
public GroupsManager(int int_2, DataRow Row, DatabaseClient class6_0)
{
this.int_0 = int_2;
this.string_0 = (string)Row["name"];
this.string_1 = (string)Row["desc"];
this.int_1 = (int)Row["OwnerId"];
this.string_2 = (string)Row["badge"];
this.uint_0 = (uint)Row["roomid"];
this.string_3 = (string)Row["locked"];
this.list_0 = new List<int>();
DataTable dataTable = class6_0.ReadDataTable("SELECT userid FROM group_memberships WHERE groupid = " + int_2 + ";");
foreach (DataRow dataRow in dataTable.Rows)
{
this.method_0((int)dataRow["userid"]);
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading bans..");
this.list_0.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT bantype,value,reason,expire FROM bans WHERE expire > '" + GoldTree.GetUnixTimestamp() + "'");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
ModerationBanType Type = ModerationBanType.IP;
if ((string)dataRow["bantype"] == "user")
{
Type = ModerationBanType.USERNAME;
}
this.list_0.Add(new ModerationBan(Type, (string)dataRow["value"], (string)dataRow["reason"], (double)dataRow["expire"]));
}
Logging.WriteLine("completed!");
}
}
public static void smethod_3(DatabaseClient class6_0, int int_0)
{
GroupsManager @class = Groups.smethod_2(int_0);
if (@class != null)
{
DataRow Row = class6_0.ReadDataRow("SELECT * FROM groups WHERE Id = " + int_0 + " LIMIT 1");
@class.string_0 = (string)Row["name"];
@class.string_2 = (string)Row["badge"];
@class.uint_0 = (uint)Row["roomid"];
@class.string_1 = (string)Row["desc"];
@class.string_3 = (string)Row["locked"];
@class.list_0.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT userid FROM group_memberships WHERE groupid = " + int_0 + ";");
foreach (DataRow dataRow2 in dataTable.Rows)
{
@class.method_0((int)dataRow2["userid"]);
}
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Items..");
this.dictionary_0 = new Dictionary<uint, Item>();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM furniture;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
try
{
this.dictionary_0.Add((uint)dataRow["Id"], new Item((uint)dataRow["Id"], (int)dataRow["sprite_id"], (string)dataRow["public_name"], (string)dataRow["item_name"], (string)dataRow["type"], (int)dataRow["width"], (int)dataRow["length"], (double)dataRow["stack_height"], GoldTree.smethod_3(dataRow["can_stack"].ToString()), GoldTree.smethod_3(dataRow["is_walkable"].ToString()), GoldTree.smethod_3(dataRow["can_sit"].ToString()), GoldTree.smethod_3(dataRow["allow_recycle"].ToString()), GoldTree.smethod_3(dataRow["allow_trade"].ToString()), GoldTree.smethod_3(dataRow["allow_marketplace_sell"].ToString()), GoldTree.smethod_3(dataRow["allow_gift"].ToString()), GoldTree.smethod_3(dataRow["allow_inventory_stack"].ToString()), (string)dataRow["interaction_type"], (int)dataRow["interaction_modes_count"], (string)dataRow["vending_ids"], dataRow["height_adjustable"].ToString(), Convert.ToByte((int)dataRow["EffectF"]), Convert.ToByte((int)dataRow["EffectM"]), GoldTree.smethod_3(dataRow["HeightOverride"].ToString())));
}
catch (Exception e)
{
Logging.WriteLine("Could not load item #" + (uint)dataRow["Id"] + ", please verify the data is okay.");
Logging.LogItemError(e.Message);
}
}
}
Logging.WriteLine("completed!");
/*Logging.smethod_0("Loading Soundtracks.."); //OMA LUOTU :3
this.dictionary_1 = new Dictionary<int, Soundtrack>();
DataTable dataTable2 = class6_0.ReadDataTable("SELECT * FROM soundtracks;");
if (dataTable2 != null)
{
foreach (DataRow dataRow in dataTable2.Rows)
{
try
{
this.dictionary_1.Add((int)dataRow["Id"], new Soundtrack((int)dataRow["Id"], (string)dataRow["name"], (string)dataRow["author"], (string)dataRow["track"], (int)dataRow["length"]));
}
catch (Exception)
{
Logging.WriteLine("Could not load item #" + (uint)dataRow["Id"] + ", please verify the data is okay.");
}
}
}
Logging.WriteLine("completed!");*/
Logging.smethod_0("Loading Soundtracks..");
SongManager.Initialize();
Logging.WriteLine("completed!");
}
public static void smethod_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Achievements..");
AchievementManager.dictionary_0.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM achievements");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
AchievementManager.dictionary_0.Add((uint)dataRow["Id"], new Achievement((uint)dataRow["Id"], (string)dataRow["type"], (int)dataRow["levels"], (string)dataRow["badge"], (int)dataRow["pixels_base"], (double)dataRow["pixels_multiplier"], GoldTree.smethod_3(dataRow["dynamic_badgelevel"].ToString()), (int)dataRow["score_base"], (int)dataRow["pixels_base"]));
}
AchievementManager.dictionary_1.Clear();
dataTable = class6_0.ReadDataTable("SELECT * FROM badges");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
AchievementManager.dictionary_1.Add((string)dataRow["badge"], (uint)dataRow["Id"]);
}
Logging.WriteLine("completed!");
}
}
}
public void method_0(DatabaseClient class6_0)
{
this.dataTable_0 = class6_0.ReadDataTable("SELECT * FROM group_memberships WHERE userid = " + this.Id);
if (this.dataTable_0 != null)
{
foreach (DataRow dataRow in this.dataTable_0.Rows)
{
GroupsManager @class = Groups.smethod_2((int)dataRow["groupid"]);
if (@class == null)
{
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM groups WHERE Id = " + (int)dataRow["groupid"] + " LIMIT 1;");
IEnumerator enumerator2 = dataTable.Rows.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
DataRow dataRow2 = (DataRow)enumerator2.Current;
if (!Groups.GroupsManager.ContainsKey((int)dataRow2["Id"]))
{
Groups.GroupsManager.Add((int)dataRow2["Id"], new GroupsManager((int)dataRow2["Id"], dataRow2, class6_0));
}
}
continue;
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
if ([email protected]_0.Contains((int)this.Id))
{
@class.method_0((int)this.Id);
}
}
int num = class6_0.ReadInt32("SELECT groupid FROM user_stats WHERE Id = " + this.Id + " LIMIT 1");
GroupsManager class2 = Groups.smethod_2(num);
if (class2 != null)
{
this.int_0 = num;
}
else
{
this.int_0 = 0;
}
}
else
{
this.int_0 = 0;
}
}
public void method_8(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Room Models..");
this.Models.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT Id,door_x,door_y,door_z,door_dir,heightmap,public_items,club_only FROM room_models");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
string text = (string)dataRow["Id"];
this.Models.Add(text, new RoomModel(text, (int)dataRow["door_x"], (int)dataRow["door_y"], (double)dataRow["door_z"], (int)dataRow["door_dir"], (string)dataRow["heightmap"], (string)dataRow["public_items"], GoldTree.smethod_3(dataRow["club_only"].ToString())));
}
Logging.WriteLine("completed!");
}
}
internal void method_19(DatabaseClient class6_0, bool bool_0)
{
try
{
if (this.list_1.Count > 0 || this.hashtable_1.Count > 0 || this.hashtable_0.Count > 0)
{
StringBuilder stringBuilder = new StringBuilder();
foreach (Pet @class in this.hashtable_0.Values)
{
if (@class.DBState == DatabaseUpdateState.NeedsInsert)
{
class6_0.AddParamWithValue("petname" + @class.PetId, @class.Name);
class6_0.AddParamWithValue("petcolor" + @class.PetId, @class.Color);
class6_0.AddParamWithValue("petrace" + @class.PetId, @class.Race);
stringBuilder.Append(string.Concat(new object[]
{
"INSERT INTO `user_pets` VALUES ('",
@class.PetId,
"', '",
@class.OwnerId,
"', '",
@class.RoomId,
"', @petname",
@class.PetId,
", @petrace",
@class.PetId,
", @petcolor",
@class.PetId,
", '",
@class.Type,
"', '",
@class.Expirience,
"', '",
@class.Energy,
"', '",
@class.Nutrition,
"', '",
@class.Respect,
"', '",
@class.CreationStamp,
"', '",
@class.X,
"', '",
@class.Y,
"', '",
@class.Z,
"');"
}));
}
else
{
if (@class.DBState == DatabaseUpdateState.NeedsUpdate)
{
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE user_pets SET room_id = '",
@class.RoomId,
"', expirience = '",
@class.Expirience,
"', energy = '",
@class.Energy,
"', nutrition = '",
@class.Nutrition,
"', respect = '",
@class.Respect,
"', x = '",
@class.X,
"', y = '",
@class.Y,
"', z = '",
@class.Z,
"' WHERE Id = '",
@class.PetId,
"' LIMIT 1; "
}));
}
}
@class.DBState = DatabaseUpdateState.Updated;
}
if (stringBuilder.Length > 0)
{
class6_0.ExecuteQuery(stringBuilder.ToString());
}
}
if (bool_0)
{
Console.WriteLine("Inventory for user: "******" saved.");
}
}
catch (Exception ex)
{
Logging.LogCacheError("FATAL ERROR DURING DB UPDATE: " + ex.ToString());
}
}
internal void method_1(DatabaseClient class6_0)
{
this.list_6.Clear();
class6_0.AddParamWithValue("name", this.Username);
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM rooms WHERE owner = @name ORDER BY Id ASC");
foreach (DataRow dataRow in dataTable.Rows)
{
this.list_6.Add(GoldTree.GetGame().GetRoomManager().method_17((uint)dataRow["Id"], dataRow));
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0(GoldTreeEnvironment.smethod_1("emu_loadroles"));
this.method_10();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM ranks ORDER BY Id ASC;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
this.dictionary_2.Add((uint)dataRow["Id"], dataRow["badgeid"].ToString());
}
}
dataTable = class6_0.ReadDataTable("SELECT * FROM permissions_users ORDER BY userid ASC;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
List<string> list = new List<string>();
if (GoldTree.smethod_3(dataRow["cmd_update_settings"].ToString()))
{
list.Add("cmd_update_settings");
}
if (GoldTree.smethod_3(dataRow["cmd_update_bans"].ToString()))
{
list.Add("cmd_update_bans");
}
if (GoldTree.smethod_3(dataRow["cmd_update_bots"].ToString()))
{
list.Add("cmd_update_bots");
}
if (GoldTree.smethod_3(dataRow["cmd_update_catalogue"].ToString()))
{
list.Add("cmd_update_catalogue");
}
if (GoldTree.smethod_3(dataRow["cmd_update_navigator"].ToString()))
{
list.Add("cmd_update_navigator");
}
if (GoldTree.smethod_3(dataRow["cmd_update_items"].ToString()))
{
list.Add("cmd_update_items");
}
if (GoldTree.smethod_3(dataRow["cmd_award"].ToString()))
{
list.Add("cmd_award");
}
if (GoldTree.smethod_3(dataRow["cmd_coords"].ToString()))
{
list.Add("cmd_coords");
}
if (GoldTree.smethod_3(dataRow["cmd_override"].ToString()))
{
list.Add("cmd_override");
}
if (GoldTree.smethod_3(dataRow["cmd_coins"].ToString()))
{
list.Add("cmd_coins");
}
if (GoldTree.smethod_3(dataRow["cmd_pixels"].ToString()))
{
list.Add("cmd_pixels");
}
if (GoldTree.smethod_3(dataRow["cmd_ha"].ToString()))
{
list.Add("cmd_ha");
}
if (GoldTree.smethod_3(dataRow["cmd_hal"].ToString()))
{
list.Add("cmd_hal");
}
if (GoldTree.smethod_3(dataRow["cmd_freeze"].ToString()))
{
list.Add("cmd_freeze");
}
if (GoldTree.smethod_3(dataRow["cmd_enable"].ToString()))
{
list.Add("cmd_enable");
}
if (GoldTree.smethod_3(dataRow["cmd_roommute"].ToString()))
{
list.Add("cmd_roommute");
}
if (GoldTree.smethod_3(dataRow["cmd_setspeed"].ToString()))
{
list.Add("cmd_setspeed");
}
if (GoldTree.smethod_3(dataRow["cmd_masscredits"].ToString()))
{
list.Add("cmd_masscredits");
}
if (GoldTree.smethod_3(dataRow["cmd_globalcredits"].ToString()))
{
list.Add("cmd_globalcredits");
}
if (GoldTree.smethod_3(dataRow["cmd_masspixels"].ToString()))
{
list.Add("cmd_masspixels");
}
if (GoldTree.smethod_3(dataRow["cmd_globalpixels"].ToString()))
{
list.Add("cmd_globalpixels");
}
if (GoldTree.smethod_3(dataRow["cmd_roombadge"].ToString()))
{
list.Add("cmd_roombadge");
}
if (GoldTree.smethod_3(dataRow["cmd_massbadge"].ToString()))
{
list.Add("cmd_massbadge");
}
if (GoldTree.smethod_3(dataRow["cmd_userinfo"].ToString()))
{
list.Add("cmd_userinfo");
}
if (GoldTree.smethod_3(dataRow["cmd_userinfo_viewip"].ToString()))
{
list.Add("cmd_userinfo_viewip");
}
if (GoldTree.smethod_3(dataRow["cmd_shutdown"].ToString()))
{
list.Add("cmd_shutdown");
}
if (GoldTree.smethod_3(dataRow["cmd_givebadge"].ToString()))
{
list.Add("cmd_givebadge");
}
if (GoldTree.smethod_3(dataRow["cmd_removebadge"].ToString()))
{
list.Add("cmd_removebadge");
}
if (GoldTree.smethod_3(dataRow["cmd_summon"].ToString()))
{
list.Add("cmd_summon");
}
if (GoldTree.smethod_3(dataRow["cmd_invisible"].ToString()))
{
list.Add("cmd_invisible");
}
if (GoldTree.smethod_3(dataRow["cmd_ban"].ToString()))
{
list.Add("cmd_ban");
}
if (GoldTree.smethod_3(dataRow["cmd_superban"].ToString()))
{
list.Add("cmd_superban");
}
if (GoldTree.smethod_3(dataRow["cmd_roomkick"].ToString()))
{
list.Add("cmd_roomkick");
}
if (GoldTree.smethod_3(dataRow["cmd_roomalert"].ToString()))
{
list.Add("cmd_roomalert");
}
if (GoldTree.smethod_3(dataRow["cmd_mute"].ToString()))
{
list.Add("cmd_mute");
}
if (GoldTree.smethod_3(dataRow["cmd_unmute"].ToString()))
{
list.Add("cmd_unmute");
}
if (GoldTree.smethod_3(dataRow["cmd_alert"].ToString()))
{
list.Add("cmd_alert");
}
if (GoldTree.smethod_3(dataRow["cmd_motd"].ToString()))
{
list.Add("cmd_motd");
}
if (GoldTree.smethod_3(dataRow["cmd_kick"].ToString()))
{
list.Add("cmd_kick");
}
if (GoldTree.smethod_3(dataRow["cmd_update_filter"].ToString()))
{
list.Add("cmd_update_filter");
}
if (GoldTree.smethod_3(dataRow["cmd_update_permissions"].ToString()))
{
list.Add("cmd_update_permissions");
}
if (GoldTree.smethod_3(dataRow["cmd_sa"].ToString()))
{
list.Add("cmd_sa");
}
if (GoldTree.smethod_3(dataRow["receive_sa"].ToString()))
{
list.Add("receive_sa");
}
if (GoldTree.smethod_3(dataRow["cmd_ipban"].ToString()))
{
list.Add("cmd_ipban");
}
if (GoldTree.smethod_3(dataRow["cmd_spull"].ToString()))
{
list.Add("cmd_spull");
}
if (GoldTree.smethod_3(dataRow["cmd_disconnect"].ToString()))
{
list.Add("cmd_disconnect");
}
if (GoldTree.smethod_3(dataRow["cmd_update_achievements"].ToString()))
{
list.Add("cmd_update_achievements");
}
if (GoldTree.smethod_3(dataRow["cmd_update_texts"].ToString()))
{
list.Add("cmd_update_texts");
}
if (GoldTree.smethod_3(dataRow["cmd_teleport"].ToString()))
{
list.Add("cmd_teleport");
}
if (GoldTree.smethod_3(dataRow["cmd_points"].ToString()))
{
list.Add("cmd_points");
}
if (GoldTree.smethod_3(dataRow["cmd_masspoints"].ToString()))
{
list.Add("cmd_masspoints");
}
if (GoldTree.smethod_3(dataRow["cmd_globalpoints"].ToString()))
{
list.Add("cmd_globalpoints");
}
if (GoldTree.smethod_3(dataRow["cmd_empty"].ToString()))
{
list.Add("cmd_empty");
}
if (GoldTree.smethod_3(dataRow["ignore_roommute"].ToString()))
{
list.Add("ignore_roommute");
}
if (GoldTree.smethod_3(dataRow["acc_anyroomrights"].ToString()))
{
list.Add("acc_anyroomrights");
}
if (GoldTree.smethod_3(dataRow["acc_anyroomowner"].ToString()))
{
list.Add("acc_anyroomowner");
}
if (GoldTree.smethod_3(dataRow["acc_supporttool"].ToString()))
{
list.Add("acc_supporttool");
}
if (GoldTree.smethod_3(dataRow["acc_chatlogs"].ToString()))
{
list.Add("acc_chatlogs");
}
if (GoldTree.smethod_3(dataRow["acc_enter_fullrooms"].ToString()))
{
list.Add("acc_enter_fullrooms");
}
if (GoldTree.smethod_3(dataRow["acc_enter_anyroom"].ToString()))
{
list.Add("acc_enter_anyroom");
}
if (GoldTree.smethod_3(dataRow["acc_restrictedrooms"].ToString()))
{
list.Add("acc_restrictedrooms");
}
if (GoldTree.smethod_3(dataRow["acc_unkickable"].ToString()))
{
list.Add("acc_unkickable");
}
if (GoldTree.smethod_3(dataRow["acc_unbannable"].ToString()))
{
list.Add("acc_unbannable");
}
if (GoldTree.smethod_3(dataRow["ignore_friendsettings"].ToString()))
{
list.Add("ignore_friendsettings");
}
if (GoldTree.smethod_3(dataRow["wired_give_sql"].ToString()))
{
list.Add("wired_give_sql");
}
if (GoldTree.smethod_3(dataRow["wired_give_badge"].ToString()))
{
list.Add("wired_give_badge");
}
if (GoldTree.smethod_3(dataRow["wired_give_effect"].ToString()))
{
list.Add("wired_give_effect");
}
if (GoldTree.smethod_3(dataRow["wired_give_award"].ToString()))
{
list.Add("wired_give_award");
}
if (GoldTree.smethod_3(dataRow["wired_give_dance"].ToString()))
{
list.Add("wired_give_dance");
}
if (GoldTree.smethod_3(dataRow["wired_give_send"].ToString()))
{
list.Add("wired_give_send");
}
if (GoldTree.smethod_3(dataRow["wired_give_credits"].ToString()))
{
list.Add("wired_give_credits");
}
if (GoldTree.smethod_3(dataRow["wired_give_pixels"].ToString()))
{
list.Add("wired_give_pixels");
}
if (GoldTree.smethod_3(dataRow["wired_give_points"].ToString()))
{
list.Add("wired_give_points");
}
if (GoldTree.smethod_3(dataRow["wired_give_rank"].ToString()))
{
list.Add("wired_give_rank");
}
if (GoldTree.smethod_3(dataRow["wired_give_respect"].ToString()))
{
list.Add("wired_give_respect");
}
if (GoldTree.smethod_3(dataRow["wired_give_handitem"].ToString()))
{
list.Add("wired_give_handitem");
}
if (GoldTree.smethod_3(dataRow["wired_give_alert"].ToString()))
{
list.Add("wired_give_alert");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_roomusers"].ToString()))
{
list.Add("wired_cnd_roomusers");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasachievement"].ToString()))
{
list.Add("wired_cnd_userhasachievement");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasbadge"].ToString()))
{
list.Add("wired_cnd_userhasbadge");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasvip"].ToString()))
{
list.Add("wired_cnd_userhasvip");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhaseffect"].ToString()))
{
list.Add("wired_cnd_userhaseffect");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userrank"].ToString()))
{
list.Add("wired_cnd_userrank");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_usercredits"].ToString()))
{
list.Add("wired_cnd_usercredits");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userpixels"].ToString()))
{
list.Add("wired_cnd_userpixels");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userpoints"].ToString()))
{
list.Add("wired_cnd_userpoints");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_usergroups"].ToString()))
{
list.Add("wired_cnd_usergroups");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_wearing"].ToString()))
{
list.Add("wired_cnd_wearing");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_carrying"].ToString()))
{
list.Add("wired_cnd_carrying");
}
if (GoldTree.smethod_3(dataRow["wired_give_wiredactived"].ToString()))
{
list.Add("wired_give_wiredactived");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_wiredactived"].ToString()))
{
list.Add("wired_cnd_wiredactived");
}
if (GoldTree.smethod_3(dataRow["wired_unlimitedselects"].ToString()))
{
list.Add("wired_unlimitedselects");
}
if (GoldTree.smethod_3(dataRow["cmd_dance"].ToString()))
{
list.Add("cmd_dance");
}
if (GoldTree.smethod_3(dataRow["cmd_rave"].ToString()))
{
list.Add("cmd_rave");
}
if (GoldTree.smethod_3(dataRow["cmd_roll"].ToString()))
{
list.Add("cmd_roll");
}
if (GoldTree.smethod_3(dataRow["cmd_control"].ToString()))
{
list.Add("cmd_control");
}
if (GoldTree.smethod_3(dataRow["cmd_makesay"].ToString()))
{
list.Add("cmd_makesay");
}
if (GoldTree.smethod_3(dataRow["cmd_sitdown"].ToString()))
{
list.Add("cmd_sitdown");
}
if (GoldTree.smethod_3(dataRow["cmd_lay"].ToString()))
{
list.Add("cmd_lay");
}
if (GoldTree.smethod_3(dataRow["cmd_push"].ToString()))
{
list.Add("cmd_push");
}
if (GoldTree.smethod_3(dataRow["cmd_pull"].ToString()))
{
list.Add("cmd_pull");
}
if (GoldTree.smethod_3(dataRow["cmd_flagme"].ToString()))
{
list.Add("cmd_flagme");
}
if (GoldTree.smethod_3(dataRow["cmd_mimic"].ToString()))
{
list.Add("cmd_mimic");
}
if (GoldTree.smethod_3(dataRow["cmd_moonwalk"].ToString()))
{
list.Add("cmd_moonwalk");
}
if (GoldTree.smethod_3(dataRow["cmd_follow"].ToString()))
{
list.Add("cmd_follow");
}
if (GoldTree.smethod_3(dataRow["cmd_handitem"].ToString()))
{
list.Add("cmd_handitem");
}
if (GoldTree.smethod_3(dataRow["cmd_startquestion"].ToString()))
{
list.Add("cmd_startquestion");
}
if (GoldTree.smethod_3(dataRow["cmd_vipha"].ToString()))
{
list.Add("cmd_vipha");
}
if (GoldTree.smethod_3(dataRow["cmd_spush"].ToString()))
{
list.Add("cmd_spush");
}
if (GoldTree.smethod_3(dataRow["cmd_roomeffect"].ToString()))
{
list.Add("cmd_roomeffect");
}
if (GoldTree.smethod_3(dataRow["cmd_viphal"].ToString()))
{
list.Add("cmd_viphal");
}
if (GoldTree.smethod_3(dataRow["acc_moveotheruserstodoor"].ToString()))
{
list.Add("acc_moveotheruserstodoor");
}
this.dictionary_0.Add((uint)dataRow["userid"], list);
}
}
dataTable = class6_0.ReadDataTable("SELECT * FROM permissions_ranks ORDER BY rank ASC;");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
this.dictionary_3.Add((uint)dataRow["rank"], (int)dataRow["floodtime"]);
}
foreach (DataRow dataRow in dataTable.Rows)
{
List<string> list = new List<string>();
if (GoldTree.smethod_3(dataRow["cmd_update_settings"].ToString()))
{
list.Add("cmd_update_settings");
}
if (GoldTree.smethod_3(dataRow["cmd_update_bans"].ToString()))
{
list.Add("cmd_update_bans");
}
if (GoldTree.smethod_3(dataRow["cmd_update_bots"].ToString()))
{
list.Add("cmd_update_bots");
}
if (GoldTree.smethod_3(dataRow["cmd_update_catalogue"].ToString()))
{
list.Add("cmd_update_catalogue");
}
if (GoldTree.smethod_3(dataRow["cmd_update_navigator"].ToString()))
{
list.Add("cmd_update_navigator");
}
if (GoldTree.smethod_3(dataRow["cmd_update_items"].ToString()))
{
list.Add("cmd_update_items");
}
if (GoldTree.smethod_3(dataRow["cmd_award"].ToString()))
{
list.Add("cmd_award");
}
if (GoldTree.smethod_3(dataRow["cmd_coords"].ToString()))
{
list.Add("cmd_coords");
}
if (GoldTree.smethod_3(dataRow["cmd_override"].ToString()))
{
list.Add("cmd_override");
}
if (GoldTree.smethod_3(dataRow["cmd_coins"].ToString()))
{
list.Add("cmd_coins");
}
if (GoldTree.smethod_3(dataRow["cmd_pixels"].ToString()))
{
list.Add("cmd_pixels");
}
if (GoldTree.smethod_3(dataRow["cmd_ha"].ToString()))
{
list.Add("cmd_ha");
}
if (GoldTree.smethod_3(dataRow["cmd_hal"].ToString()))
{
list.Add("cmd_hal");
}
if (GoldTree.smethod_3(dataRow["cmd_freeze"].ToString()))
{
list.Add("cmd_freeze");
}
if (GoldTree.smethod_3(dataRow["cmd_enable"].ToString()))
{
list.Add("cmd_enable");
}
if (GoldTree.smethod_3(dataRow["cmd_roommute"].ToString()))
{
list.Add("cmd_roommute");
}
if (GoldTree.smethod_3(dataRow["cmd_setspeed"].ToString()))
{
list.Add("cmd_setspeed");
}
if (GoldTree.smethod_3(dataRow["cmd_masscredits"].ToString()))
{
list.Add("cmd_masscredits");
}
if (GoldTree.smethod_3(dataRow["cmd_globalcredits"].ToString()))
{
list.Add("cmd_globalcredits");
}
if (GoldTree.smethod_3(dataRow["cmd_masspixels"].ToString()))
{
list.Add("cmd_masspixels");
}
if (GoldTree.smethod_3(dataRow["cmd_globalpixels"].ToString()))
{
list.Add("cmd_globalpixels");
}
if (GoldTree.smethod_3(dataRow["cmd_roombadge"].ToString()))
{
list.Add("cmd_roombadge");
}
if (GoldTree.smethod_3(dataRow["cmd_massbadge"].ToString()))
{
list.Add("cmd_massbadge");
}
if (GoldTree.smethod_3(dataRow["cmd_userinfo"].ToString()))
{
list.Add("cmd_userinfo");
}
if (GoldTree.smethod_3(dataRow["cmd_userinfo_viewip"].ToString()))
{
list.Add("cmd_userinfo_viewip");
}
if (GoldTree.smethod_3(dataRow["cmd_shutdown"].ToString()))
{
list.Add("cmd_shutdown");
}
if (GoldTree.smethod_3(dataRow["cmd_givebadge"].ToString()))
{
list.Add("cmd_givebadge");
}
if (GoldTree.smethod_3(dataRow["cmd_removebadge"].ToString()))
{
list.Add("cmd_removebadge");
}
if (GoldTree.smethod_3(dataRow["cmd_summon"].ToString()))
{
list.Add("cmd_summon");
}
if (GoldTree.smethod_3(dataRow["cmd_invisible"].ToString()))
{
list.Add("cmd_invisible");
}
if (GoldTree.smethod_3(dataRow["cmd_ban"].ToString()))
{
list.Add("cmd_ban");
}
if (GoldTree.smethod_3(dataRow["cmd_superban"].ToString()))
{
list.Add("cmd_superban");
}
if (GoldTree.smethod_3(dataRow["cmd_roomkick"].ToString()))
{
list.Add("cmd_roomkick");
}
if (GoldTree.smethod_3(dataRow["cmd_roomalert"].ToString()))
{
list.Add("cmd_roomalert");
}
if (GoldTree.smethod_3(dataRow["cmd_mute"].ToString()))
{
list.Add("cmd_mute");
}
if (GoldTree.smethod_3(dataRow["cmd_unmute"].ToString()))
{
list.Add("cmd_unmute");
}
if (GoldTree.smethod_3(dataRow["cmd_alert"].ToString()))
{
list.Add("cmd_alert");
}
if (GoldTree.smethod_3(dataRow["cmd_motd"].ToString()))
{
list.Add("cmd_motd");
}
if (GoldTree.smethod_3(dataRow["cmd_kick"].ToString()))
{
list.Add("cmd_kick");
}
if (GoldTree.smethod_3(dataRow["cmd_update_filter"].ToString()))
{
list.Add("cmd_update_filter");
}
if (GoldTree.smethod_3(dataRow["cmd_update_permissions"].ToString()))
{
list.Add("cmd_update_permissions");
}
if (GoldTree.smethod_3(dataRow["cmd_sa"].ToString()))
{
list.Add("cmd_sa");
}
if (GoldTree.smethod_3(dataRow["receive_sa"].ToString()))
{
list.Add("receive_sa");
}
if (GoldTree.smethod_3(dataRow["cmd_ipban"].ToString()))
{
list.Add("cmd_ipban");
}
if (GoldTree.smethod_3(dataRow["cmd_spull"].ToString()))
{
list.Add("cmd_spull");
}
if (GoldTree.smethod_3(dataRow["cmd_disconnect"].ToString()))
{
list.Add("cmd_disconnect");
}
if (GoldTree.smethod_3(dataRow["cmd_update_achievements"].ToString()))
{
list.Add("cmd_update_achievements");
}
if (GoldTree.smethod_3(dataRow["cmd_update_texts"].ToString()))
{
list.Add("cmd_update_texts");
}
if (GoldTree.smethod_3(dataRow["cmd_teleport"].ToString()))
{
list.Add("cmd_teleport");
}
if (GoldTree.smethod_3(dataRow["cmd_points"].ToString()))
{
list.Add("cmd_points");
}
if (GoldTree.smethod_3(dataRow["cmd_masspoints"].ToString()))
{
list.Add("cmd_masspoints");
}
if (GoldTree.smethod_3(dataRow["cmd_globalpoints"].ToString()))
{
list.Add("cmd_globalpoints");
}
if (GoldTree.smethod_3(dataRow["cmd_empty"].ToString()))
{
list.Add("cmd_empty");
}
if (GoldTree.smethod_3(dataRow["ignore_roommute"].ToString()))
{
list.Add("ignore_roommute");
}
if (GoldTree.smethod_3(dataRow["acc_anyroomrights"].ToString()))
{
list.Add("acc_anyroomrights");
}
if (GoldTree.smethod_3(dataRow["acc_anyroomowner"].ToString()))
{
list.Add("acc_anyroomowner");
}
if (GoldTree.smethod_3(dataRow["acc_supporttool"].ToString()))
{
list.Add("acc_supporttool");
}
if (GoldTree.smethod_3(dataRow["acc_chatlogs"].ToString()))
{
list.Add("acc_chatlogs");
}
if (GoldTree.smethod_3(dataRow["acc_enter_fullrooms"].ToString()))
{
list.Add("acc_enter_fullrooms");
}
if (GoldTree.smethod_3(dataRow["acc_enter_anyroom"].ToString()))
{
list.Add("acc_enter_anyroom");
}
if (GoldTree.smethod_3(dataRow["acc_restrictedrooms"].ToString()))
{
list.Add("acc_restrictedrooms");
}
if (GoldTree.smethod_3(dataRow["acc_unkickable"].ToString()))
{
list.Add("acc_unkickable");
}
if (GoldTree.smethod_3(dataRow["acc_unbannable"].ToString()))
{
list.Add("acc_unbannable");
}
if (GoldTree.smethod_3(dataRow["ignore_friendsettings"].ToString()))
{
list.Add("ignore_friendsettings");
}
if (GoldTree.smethod_3(dataRow["wired_give_sql"].ToString()))
{
list.Add("wired_give_sql");
}
if (GoldTree.smethod_3(dataRow["wired_give_badge"].ToString()))
{
list.Add("wired_give_badge");
}
if (GoldTree.smethod_3(dataRow["wired_give_effect"].ToString()))
{
list.Add("wired_give_effect");
}
if (GoldTree.smethod_3(dataRow["wired_give_award"].ToString()))
{
list.Add("wired_give_award");
}
if (GoldTree.smethod_3(dataRow["wired_give_dance"].ToString()))
{
list.Add("wired_give_dance");
}
if (GoldTree.smethod_3(dataRow["wired_give_send"].ToString()))
{
list.Add("wired_give_send");
}
if (GoldTree.smethod_3(dataRow["wired_give_credits"].ToString()))
{
list.Add("wired_give_credits");
}
if (GoldTree.smethod_3(dataRow["wired_give_pixels"].ToString()))
{
list.Add("wired_give_pixels");
}
if (GoldTree.smethod_3(dataRow["wired_give_points"].ToString()))
{
list.Add("wired_give_points");
}
if (GoldTree.smethod_3(dataRow["wired_give_rank"].ToString()))
{
list.Add("wired_give_rank");
}
if (GoldTree.smethod_3(dataRow["wired_give_respect"].ToString()))
{
list.Add("wired_give_respect");
}
if (GoldTree.smethod_3(dataRow["wired_give_handitem"].ToString()))
{
list.Add("wired_give_handitem");
}
if (GoldTree.smethod_3(dataRow["wired_give_alert"].ToString()))
{
list.Add("wired_give_alert");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_roomusers"].ToString()))
{
list.Add("wired_cnd_roomusers");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasachievement"].ToString()))
{
list.Add("wired_cnd_userhasachievement");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasbadge"].ToString()))
{
list.Add("wired_cnd_userhasbadge");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhasvip"].ToString()))
{
list.Add("wired_cnd_userhasvip");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userhaseffect"].ToString()))
{
list.Add("wired_cnd_userhaseffect");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userrank"].ToString()))
{
list.Add("wired_cnd_userrank");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_usercredits"].ToString()))
{
list.Add("wired_cnd_usercredits");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userpixels"].ToString()))
{
list.Add("wired_cnd_userpixels");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_userpoints"].ToString()))
{
list.Add("wired_cnd_userpoints");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_usergroups"].ToString()))
{
list.Add("wired_cnd_usergroups");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_wearing"].ToString()))
{
list.Add("wired_cnd_wearing");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_carrying"].ToString()))
{
list.Add("wired_cnd_carrying");
}
if (GoldTree.smethod_3(dataRow["wired_give_wiredactived"].ToString()))
{
list.Add("wired_give_wiredactived");
}
if (GoldTree.smethod_3(dataRow["wired_cnd_wiredactived"].ToString()))
{
list.Add("wired_cnd_wiredactived");
}
if (GoldTree.smethod_3(dataRow["wired_unlimitedselects"].ToString()))
{
list.Add("wired_unlimitedselects");
}
if (GoldTree.smethod_3(dataRow["cmd_dance"].ToString()))
{
list.Add("cmd_dance");
}
if (GoldTree.smethod_3(dataRow["cmd_rave"].ToString()))
{
list.Add("cmd_rave");
}
if (GoldTree.smethod_3(dataRow["cmd_roll"].ToString()))
{
list.Add("cmd_roll");
}
if (GoldTree.smethod_3(dataRow["cmd_control"].ToString()))
{
list.Add("cmd_control");
}
if (GoldTree.smethod_3(dataRow["cmd_makesay"].ToString()))
{
list.Add("cmd_makesay");
}
if (GoldTree.smethod_3(dataRow["cmd_sitdown"].ToString()))
{
list.Add("cmd_sitdown");
}
if (GoldTree.smethod_3(dataRow["cmd_lay"].ToString()))
{
list.Add("cmd_lay");
}
if (GoldTree.smethod_3(dataRow["cmd_push"].ToString()))
{
list.Add("cmd_push");
}
if (GoldTree.smethod_3(dataRow["cmd_pull"].ToString()))
{
list.Add("cmd_pull");
}
if (GoldTree.smethod_3(dataRow["cmd_flagme"].ToString()))
{
list.Add("cmd_flagme");
}
if (GoldTree.smethod_3(dataRow["cmd_mimic"].ToString()))
{
list.Add("cmd_mimic");
}
if (GoldTree.smethod_3(dataRow["cmd_moonwalk"].ToString()))
{
list.Add("cmd_moonwalk");
}
if (GoldTree.smethod_3(dataRow["cmd_follow"].ToString()))
{
list.Add("cmd_follow");
}
if (GoldTree.smethod_3(dataRow["cmd_handitem"].ToString()))
{
list.Add("cmd_handitem");
}
if (GoldTree.smethod_3(dataRow["cmd_startquestion"].ToString()))
{
list.Add("cmd_startquestion");
}
if (GoldTree.smethod_3(dataRow["cmd_vipha"].ToString()))
{
list.Add("cmd_vipha");
}
if (GoldTree.smethod_3(dataRow["cmd_spush"].ToString()))
{
list.Add("cmd_spush");
}
if (GoldTree.smethod_3(dataRow["cmd_roomeffect"].ToString()))
{
list.Add("cmd_roomeffect");
}
if (GoldTree.smethod_3(dataRow["cmd_viphal"].ToString()))
{
list.Add("cmd_viphal");
}
if (GoldTree.smethod_3(dataRow["acc_moveotheruserstodoor"].ToString()))
{
list.Add("acc_moveotheruserstodoor");
}
this.dictionary_1.Add((uint)dataRow["rank"], list);
}
}
dataTable = class6_0.ReadDataTable("SELECT * FROM permissions_vip;");
if (dataTable != null)
{
LicenseTools.Boolean_8 = false;
LicenseTools.Boolean_10 = false;
LicenseTools.Boolean_11 = false;
LicenseTools.Boolean_12 = false;
LicenseTools.Boolean_13 = false;
LicenseTools.Boolean_9 = false;
foreach (DataRow dataRow in dataTable.Rows)
{
if (GoldTree.smethod_3(dataRow["cmdPush"].ToString()))
{
LicenseTools.Boolean_8 = true;
}
if (GoldTree.smethod_3(dataRow["cmdPull"].ToString()))
{
LicenseTools.Boolean_10 = true;
}
if (GoldTree.smethod_3(dataRow["cmdFlagme"].ToString()))
{
LicenseTools.Boolean_11 = true;
}
if (GoldTree.smethod_3(dataRow["cmdMimic"].ToString()))
{
LicenseTools.Boolean_12 = true;
}
if (GoldTree.smethod_3(dataRow["cmdMoonwalk"].ToString()))
{
LicenseTools.Boolean_13 = true;
}
if (GoldTree.smethod_3(dataRow["cmdFollow"].ToString()))
{
LicenseTools.Boolean_9 = true;
}
}
}
this.dictionary_5.Clear();
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_sleep"), 1);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_free"), 2);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_sit"), 3);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_lay"), 4);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_stay"), 5);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_here"), 6);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_dead"), 7);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_beg"), 8);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_jump"), 9);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_stfu"), 10);
this.dictionary_5.Add(GoldTreeEnvironment.smethod_1("pet_cmd_talk"), 11);
this.dictionary_4.Clear();
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_about_name"), 1);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_alert_name"), 2);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_award_name"), 3);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_ban_name"), 4);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_buy_name"), 5);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_coins_name"), 6);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_coords_name"), 7);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_disablediagonal_name"), 8);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_emptyitems_name"), 9);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_empty_name"), 10);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_enable_name"), 11);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_flagme_name"), 12);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_follow_name"), 13);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_freeze_name"), 14);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_givebadge_name"), 15);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_globalcredits_name"), 16);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_globalpixels_name"), 17);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_globalpoints_name"), 18);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_hal_name"), 19);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_ha_name"), 20);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_invisible_name"), 21);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_ipban_name"), 22);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_kick_name"), 23);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_massbadge_name"), 24);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_masscredits_name"), 25);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_masspixels_name"), 26);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_masspoints_name"), 27);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_mimic_name"), 28);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_moonwalk_name"), 29);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_motd_name"), 30);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_mute_name"), 31);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_override_name"), 32);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_pickall_name"), 33);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_pixels_name"), 34);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_points_name"), 35);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_pull_name"), 36);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_push_name"), 37);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_redeemcreds_name"), 38);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_removebadge_name"), 39);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_ride_name"), 40);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roomalert_name"), 41);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roombadge_name"), 42);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roomkick_name"), 43);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roommute_name"), 44);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_sa_name"), 45);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_setmax_name"), 46);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_setspeed_name"), 47);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_shutdown_name"), 48);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_spull_name"), 49);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_summon_name"), 50);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_superban_name"), 51);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_teleport_name"), 52);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_unload_name"), 53);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_unmute_name"), 54);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_achievements_name"), 55);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_bans_name"), 56);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_bots_name"), 57);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_catalogue_name"), 58);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_filter_name"), 59);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_items_name"), 60);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_navigator_name"), 61);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_permissions_name"), 62);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_settings_name"), 63);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_userinfo_name"), 64);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_update_texts_name"), 65);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_disconnect_name"), 66);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_commands_name"), 67);
this.dictionary_4.Add("about", 68);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roominfo_name"), 69);
this.dictionary_4.Add("neto737", 70);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_dance_name"), 71);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_rave_name"), 72);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roll_name"), 73);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_control_name"), 74);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_makesay_name"), 75);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_sitdown_name"), 76);
this.dictionary_4.Add("exe", 77);
this.dictionary_4.Add("giveitem", 79);
this.dictionary_4.Add("sit", 80);
this.dictionary_4.Add("dismount", 81);
this.dictionary_4.Add("getoff", 82);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_emptypets_name"), 83);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_startquestion_name"), 94);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_lay_name"), 86);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_handitem_name"), 85);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_vipha_name"), 87);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_spush_name"), 88);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_roomeffect_name"), 91);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_redeempixel_name"), 95);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_redeemshell_name"), 96);
this.dictionary_4.Add(GoldTreeEnvironment.smethod_1("cmd_viphal_name"), 97);
Logging.WriteLine("completed!");
try
{
if (int.Parse(GoldTree.GetConfig().data["debug"]) == 1)
{
Logging.WriteLine("Commands loaded:" + this.dictionary_4.Count.ToString());
}
}
catch
{
}
}
public void method_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Catalogue..");
this.dictionary_0 = new Dictionary<int, CatalogPage>();
this.list_0 = new List<EcotronReward>();
DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM catalog_pages WHERE order_num >= '0' ORDER BY order_num ASC");
DataTable dataTable2 = class6_0.ReadDataTable("SELECT * FROM ecotron_rewards ORDER BY item_id");
DataTable dataTable4 = class6_0.ReadDataTable("SELECT * FROM catalog_pages WHERE order_num = '-1' ORDER BY caption ASC");
try
{
this.uint_0 = (uint)class6_0.ReadDataRow("SELECT ID FROM items ORDER BY ID DESC LIMIT 1")[0];
}
catch
{
this.uint_0 = 0u;
}
this.uint_0 += 1u;
Hashtable hashtable = new Hashtable();
DataTable dataTable3 = class6_0.ReadDataTable("SELECT * FROM catalog_items");
if (dataTable3 != null)
{
foreach (DataRow dataRow in dataTable3.Rows)
{
if (!(dataRow["item_ids"].ToString() == "") && (int)dataRow["amount"] > 0)
{
string BadgeID = dataRow["BadgeID"].ToString();
if (string.IsNullOrEmpty(BadgeID) || string.IsNullOrWhiteSpace(BadgeID)) BadgeID = string.Empty;
hashtable.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"], GoldTree.smethod_2(dataRow["vip"].ToString()), (uint)dataRow["achievement"], (int)dataRow["song_id"], BadgeID));
}
}
}
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
bool bool_ = false;
bool bool_2 = false;
if (dataRow["visible"].ToString() == "1")
{
bool_ = true;
}
if (dataRow["enabled"].ToString() == "1")
{
bool_2 = true;
}
this.dictionary_0.Add((int)dataRow["Id"], new CatalogPage((int)dataRow["Id"], (int)dataRow["parent_id"], (string)dataRow["caption"], bool_, bool_2, (uint)dataRow["min_rank"], GoldTree.smethod_3(dataRow["club_only"].ToString()), (int)dataRow["icon_color"], (int)dataRow["icon_image"], (string)dataRow["page_layout"], (string)dataRow["page_headline"], (string)dataRow["page_teaser"], (string)dataRow["page_special"], (string)dataRow["page_text1"], (string)dataRow["page_text2"], (string)dataRow["page_text_details"], (string)dataRow["page_text_teaser"], (string)dataRow["page_link_description"], (string)dataRow["page_link_pagename"], ref hashtable));
}
}
if (dataTable4 != null)
{
foreach (DataRow dataRow in dataTable4.Rows)
{
bool bool_ = false;
bool bool_2 = false;
if (dataRow["visible"].ToString() == "1")
{
bool_ = true;
}
if (dataRow["enabled"].ToString() == "1")
{
bool_2 = true;
}
this.dictionary_0.Add((int)dataRow["Id"], new CatalogPage((int)dataRow["Id"], (int)dataRow["parent_id"], (string)dataRow["caption"], bool_, bool_2, (uint)dataRow["min_rank"], GoldTree.smethod_3(dataRow["club_only"].ToString()), (int)dataRow["icon_color"], (int)dataRow["icon_image"], (string)dataRow["page_layout"], (string)dataRow["page_headline"], (string)dataRow["page_teaser"], (string)dataRow["page_special"], (string)dataRow["page_text1"], (string)dataRow["page_text2"], (string)dataRow["page_text_details"], (string)dataRow["page_text_teaser"], (string)dataRow["page_link_description"], (string)dataRow["page_link_pagename"], ref hashtable));
}
}
if (dataTable2 != null)
{
foreach (DataRow dataRow in dataTable2.Rows)
{
this.list_0.Add(new EcotronReward((uint)dataRow["Id"], (uint)dataRow["display_id"], (uint)dataRow["item_id"], (uint)dataRow["reward_level"]));
}
}
Logging.WriteLine("completed!");
}
public void method_3(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Help Topics..");
this.dictionary_1.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT Id, title, body, subject, known_issue FROM help_topics");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
HelpTopic @class = new HelpTopic((uint)dataRow["Id"], (string)dataRow["title"], (string)dataRow["body"], (uint)dataRow["subject"]);
this.dictionary_1.Add((uint)dataRow["Id"], @class);
int num = int.Parse(dataRow["known_issue"].ToString());
if (num == 1)
{
this.list_1.Add(@class);
}
else
{
if (num == 2)
{
this.list_0.Add(@class);
}
}
}
Logging.WriteLine("completed!");
}
}
public static void smethod_0(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Chat Filter..");
ChatCommandHandler.list_0 = new List<string>();
ChatCommandHandler.list_1 = new List<string>();
ChatCommandHandler.list_2 = new List<int>();
ChatCommandHandler.list_3 = new List<string>();
ChatCommandHandler.InitWords(class6_0);
Logging.WriteLine("completed!");
}
public void method_2(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Current Help Tickets..");
DataTable dataTable = class6_0.ReadDataTable("SELECT Id,score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp FROM moderation_tickets WHERE status = 'open' OR status = 'picked'");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
SupportTicket @class = new SupportTicket((uint)dataRow["Id"], (int)dataRow["score"], (int)dataRow["type"], (uint)dataRow["sender_id"], (uint)dataRow["reported_id"], (string)dataRow["message"], (uint)dataRow["room_id"], (string)dataRow["room_name"], (double)dataRow["timestamp"], (uint)dataRow["moderator_id"]);
if (dataRow["status"].ToString().ToLower() == "picked")
{
@class.method_0((uint)dataRow["moderator_id"], false);
}
this.Tickets.Add(@class);
}
Logging.WriteLine("completed!");
}
}
public void method_1(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Pre-set Help Messages..");
this.UserMessagePresets.Clear();
this.RoomMessagePresets.Clear();
DataTable dataTable = class6_0.ReadDataTable("SELECT type,message FROM moderation_presets WHERE enabled = '1'");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
string item = (string)dataRow["message"];
string text = dataRow["type"].ToString().ToLower();
if (text != null)
{
if (!(text == "message"))
{
if (text == "roommessage")
{
this.RoomMessagePresets.Add(item);
}
}
else
{
this.UserMessagePresets.Add(item);
}
}
}
Logging.WriteLine("completed!");
}
}
internal void method_65(DatabaseClient class6_0)
{
try
{
Dictionary<uint, bool> dictionary = new Dictionary<uint, bool>();
StringBuilder stringBuilder = new StringBuilder();
if (this.list_14.Count > 0)
{
foreach (RoomItem @class in this.list_14)
{
try
{
if (!dictionary.ContainsKey(@class.uint_0))
{
class6_0.AddParamWithValue(@class.uint_0 + "Extra1", @class.string_2);
class6_0.AddParamWithValue(@class.uint_0 + "Extra2", @class.string_3);
class6_0.AddParamWithValue(@class.uint_0 + "Extra3", @class.string_4);
class6_0.AddParamWithValue(@class.uint_0 + "Extra4", @class.string_5);
class6_0.AddParamWithValue(@class.uint_0 + "Extra5", @class.string_6);
stringBuilder.Append(string.Concat(new object[]
{
"DELETE FROM wired_items WHERE item_id = '",
@class.uint_0,
"' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('",
@class.uint_0,
"',@",
@class.uint_0,
"Extra1,@",
@class.uint_0,
"Extra2,@",
@class.uint_0,
"Extra3,@",
@class.uint_0,
"Extra4,@",
@class.uint_0,
"Extra5); "
}));
}
dictionary.Add(@class.uint_0, true);
}
catch
{
}
}
}
if (this.list_15.Count > 0)
{
foreach (RoomItem @class in this.list_15)
{
try
{
if (!dictionary.ContainsKey(@class.uint_0))
{
class6_0.AddParamWithValue(@class.uint_0 + "Extra1", @class.string_2);
class6_0.AddParamWithValue(@class.uint_0 + "Extra2", @class.string_3);
class6_0.AddParamWithValue(@class.uint_0 + "Extra3", @class.string_4);
class6_0.AddParamWithValue(@class.uint_0 + "Extra4", @class.string_5);
class6_0.AddParamWithValue(@class.uint_0 + "Extra5", @class.string_6);
stringBuilder.Append(string.Concat(new object[]
{
"DELETE FROM wired_items WHERE item_id = '",
@class.uint_0,
"' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('",
@class.uint_0,
"',@",
@class.uint_0,
"Extra1,@",
@class.uint_0,
"Extra2,@",
@class.uint_0,
"Extra3,@",
@class.uint_0,
"Extra4,@",
@class.uint_0,
"Extra5); "
}));
}
dictionary.Add(@class.uint_0, true);
}
catch
{
}
}
}
if (this.list_16.Count > 0)
{
foreach (RoomItem @class in this.list_16)
{
try
{
if (!dictionary.ContainsKey(@class.uint_0))
{
class6_0.AddParamWithValue(@class.uint_0 + "Extra1", @class.string_2);
class6_0.AddParamWithValue(@class.uint_0 + "Extra2", @class.string_3);
class6_0.AddParamWithValue(@class.uint_0 + "Extra3", @class.string_4);
class6_0.AddParamWithValue(@class.uint_0 + "Extra4", @class.string_5);
class6_0.AddParamWithValue(@class.uint_0 + "Extra5", @class.string_6);
stringBuilder.Append(string.Concat(new object[]
{
"DELETE FROM wired_items WHERE item_id = '",
@class.uint_0,
"' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('",
@class.uint_0,
"',@",
@class.uint_0,
"Extra1,@",
@class.uint_0,
"Extra2,@",
@class.uint_0,
"Extra3,@",
@class.uint_0,
"Extra4,@",
@class.uint_0,
"Extra5); "
}));
}
dictionary.Add(@class.uint_0, true);
}
catch
{
}
}
}
dictionary.Clear();
if (this.hashtable_3.Count > 0 || this.hashtable_1.Count > 0 || this.hashtable_2.Count > 0 || this.Boolean_4)
{
foreach (RoomItem @class in this.hashtable_1.Values)
{
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE items SET room_id = 0 WHERE Id = '",
@class.uint_0,
"' AND room_id = '",
this.Id,
"' LIMIT 1; "
}));
}
this.hashtable_1.Clear();
IEnumerator enumerator2;
if (this.hashtable_3.Count > 0)
{
enumerator2 = this.hashtable_3.Values.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
RoomItem @class = (RoomItem)enumerator2.Current;
stringBuilder.Append("UPDATE items SET room_id = 0 WHERE Id = '" + @class.uint_0 + "' LIMIT 1; ");
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
int num = 0;
int num2 = 0;
enumerator2 = this.hashtable_3.Values.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
RoomItem @class = (RoomItem)enumerator2.Current;
if (@class.Boolean_2)
{
num2++;
}
else
{
num++;
}
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
if (num2 > 0)
{
enumerator2 = this.hashtable_3.Values.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
RoomItem @class = (RoomItem)enumerator2.Current;
if (@class.Boolean_2)
{
class6_0.AddParamWithValue("extra_data" + @class.uint_0, @class.ExtraData);
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE items SET room_id = '",
this.Id,
"', base_item = '",
@class.uint_2,
"', extra_data = @extra_data",
@class.uint_0,
", x = '",
@class.Int32_0,
"', y = '",
@class.Int32_1,
"', z = '",
@class.Double_0.ToString().Replace(",", "."),
"', rot = '",
@class.int_3,
"', wall_pos = '' WHERE Id = '",
@class.uint_0,
"' LIMIT 1; "
}));
}
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
if (num > 0)
{
enumerator2 = this.hashtable_3.Values.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
RoomItem @class = (RoomItem)enumerator2.Current;
if (@class.Boolean_1)
{
class6_0.AddParamWithValue("extra_data" + @class.uint_0, @class.ExtraData);
class6_0.AddParamWithValue("pos" + @class.uint_0, @class.string_7);
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE items SET room_id = '",
this.Id,
"', base_item = '",
@class.uint_2,
"', extra_data = @extra_data",
@class.uint_0,
", x = '0', y = '0', z = '0', rot = '0', wall_pos = @pos",
@class.uint_0,
" WHERE Id = '",
@class.uint_0,
"' LIMIT 1; "
}));
}
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
this.hashtable_3.Clear();
}
enumerator2 = this.hashtable_2.Values.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
RoomItem @class = (RoomItem)enumerator2.Current;
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE items SET x = '",
@class.Int32_0,
"', y = '",
@class.Int32_1,
"', z = '",
@class.Double_0.ToString().Replace(",", "."),
"', rot = '",
@class.int_3,
"', wall_pos = '' WHERE Id = '",
@class.uint_0,
"' LIMIT 1; "
}));
}
}
finally
{
IDisposable disposable = enumerator2 as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
this.hashtable_2.Clear();
foreach (Pet current in this.method_2())
{
if (current.DBState == DatabaseUpdateState.NeedsInsert)
{
class6_0.AddParamWithValue("petname" + current.PetId, current.Name);
class6_0.AddParamWithValue("petcolor" + current.PetId, current.Color);
class6_0.AddParamWithValue("petrace" + current.PetId, current.Race);
stringBuilder.Append(string.Concat(new object[]
{
"INSERT INTO `user_pets` VALUES ('",
current.PetId,
"', '",
current.OwnerId,
"', '",
current.RoomId,
"', @petname",
current.PetId,
", @petrace",
current.PetId,
", @petcolor",
current.PetId,
", '",
current.Type,
"', '",
current.Expirience,
"', '",
current.Energy,
"', '",
current.Nutrition,
"', '",
current.Respect,
"', '",
current.CreationStamp,
"', '",
current.X,
"', '",
current.Y,
"', '",
current.Z,
"');"
}));
}
else
{
if (current.DBState == DatabaseUpdateState.NeedsUpdate)
{
stringBuilder.Append(string.Concat(new object[]
{
"UPDATE user_pets SET room_id = '",
current.RoomId,
"', expirience = '",
current.Expirience,
"', energy = '",
current.Energy,
"', nutrition = '",
current.Nutrition,
"', respect = '",
current.Respect,
"', x = '",
current.X,
"', y = '",
current.Y,
"', z = '",
current.Z,
"' WHERE Id = '",
current.PetId,
"' LIMIT 1; "
}));
}
}
current.DBState = DatabaseUpdateState.Updated;
}
}
if (stringBuilder.Length > 0)
{
class6_0.ExecuteQuery(stringBuilder.ToString());
}
}
catch (Exception ex)
{
Logging.LogCriticalException(string.Concat(new object[]
{
"Error during saving furniture for room ",
this.Id,
". Stack: ",
ex.ToString()
}));
}
}
public void method_0(DatabaseClient class6_0, int int_0)
{
Logging.smethod_0(GoldTreeEnvironment.smethod_1("emu_cleandb"));
bool flag = true;
try
{
if (int.Parse(GoldTree.GetConfig().data["debug"]) == 1)
{
flag = false;
}
}
catch
{
}
if (flag)
{
class6_0.ExecuteQuery("UPDATE users SET online = '0' WHERE online != '0'");
class6_0.ExecuteQuery("UPDATE rooms SET users_now = '0' WHERE users_now != '0'");
class6_0.ExecuteQuery("UPDATE user_roomvisits SET exit_timestamp = UNIX_TIMESTAMP() WHERE exit_timestamp <= 0");
class6_0.ExecuteQuery(string.Concat(new object[]
{
"UPDATE server_status SET status = '",
int_0,
"', users_online = '0', rooms_loaded = '0', server_ver = '",
GoldTree.PrettyVersion,
"', stamp = UNIX_TIMESTAMP() LIMIT 1;"
}));
}
Logging.WriteLine("completed!");
}
public void method_17(DatabaseClient class6_0)
{
Logging.smethod_0("Loading your settings..");
DataRow dataRow = class6_0.ReadDataRow("SELECT * FROM server_settings LIMIT 1");
LicenseTools.Int32_4 = (int)dataRow["MaxRoomsPerUser"];
LicenseTools.String_4 = (string)dataRow["motd"];
LicenseTools.Int32_0 = (int)dataRow["timer"];
LicenseTools.Int32_1 = (int)dataRow["credits"];
LicenseTools.Int32_3 = (int)dataRow["pixels"];
LicenseTools.Int32_2 = (int)dataRow["points"];
LicenseTools.int_3 = (int)dataRow["pixels_max"];
LicenseTools.int_5 = (int)dataRow["credits_max"];
LicenseTools.int_4 = (int)dataRow["points_max"];
LicenseTools.int_2 = (int)dataRow["MaxPetsPerRoom"];
LicenseTools.int_0 = (int)dataRow["MaxMarketPlacePrice"];
LicenseTools.int_1 = (int)dataRow["MarketPlaceTax"];
LicenseTools.AntiDDoSEnabled = GoldTree.smethod_3(dataRow["enable_antiddos"].ToString());
LicenseTools.Boolean_3 = GoldTree.smethod_3(dataRow["vipclothesforhcusers"].ToString());
LicenseTools.Boolean_4 = GoldTree.smethod_3(dataRow["enable_chatlogs"].ToString());
LicenseTools.Boolean_5 = GoldTree.smethod_3(dataRow["enable_cmdlogs"].ToString());
LicenseTools.Boolean_6 = GoldTree.smethod_3(dataRow["enable_roomlogs"].ToString());
LicenseTools.String_2 = (string)dataRow["enable_externalchatlinks"];
LicenseTools.Boolean_2 = GoldTree.smethod_3(dataRow["enable_securesessions"].ToString());
LicenseTools.Boolean_1 = GoldTree.smethod_3(dataRow["allow_friendfurnidrops"].ToString());
LicenseTools.Boolean_0 = GoldTree.smethod_3(dataRow["enable_cmd_redeemcredits"].ToString());
LicenseTools.bool_18 = GoldTree.smethod_3(dataRow["unload_crashedrooms"].ToString());
LicenseTools.bool_19 = GoldTree.smethod_3(dataRow["ShowUsersAndRoomsInAbout"].ToString());
LicenseTools.int_14 = (int)dataRow["idlesleep"];
LicenseTools.int_15 = (int)dataRow["idlekick"];
LicenseTools.bool_20 = GoldTree.smethod_3(dataRow["ip_lastforbans"].ToString());
LicenseTools.int_16 = (int)dataRow["StaffPicksCategoryID"];
LicenseTools.vipha_interval = (double)dataRow["vipha_interval"];
LicenseTools.bool_21 = GoldTree.smethod_3(dataRow["enable_cmd_redeempixels"].ToString());
LicenseTools.bool_22 = GoldTree.smethod_3(dataRow["enable_cmd_redeemshells"].ToString());
LicenseTools.viphal_interval = (double)dataRow["viphal_interval"];
LicenseTools.DisableOtherUsersToMovingOtherUsersToDoor = GoldTree.smethod_3(dataRow["DisableOtherUsersToMovingOtherUsersToDoor"].ToString());
Logging.WriteLine("completed!");
}
