-
Rollback again
The hotels server was under a DDoS attack this afternoon where it knocked out the server completely offline, this attack was sophisticated not only did it knock us offline but it was also raping our CPU and when our database had little to no CPU power behind it, it died and after 100 failed CPR attempts we declared it dead.
Rollback goes back to the 5th of October as that was the last fully functioning database copy I had.
Deal with it guys, I've spent 2 hours trying to fix it and failed, so I want my time back just as much.
-
Thank you for your service in this fight against terror
-
-
https://i.gyazo.com/a9de14b51641a2a7...6f8db6ea5e.png
We're repairing the database again, for 5th time, not sure why its fucking up so bad past few days, might keep it offline to figure that out to avoid it reoccurring
-
-
REPAIR TABLE `achievement_talents`, `achievements`, `anti_wipe`, `autoban_blacklist`, `awards`, `badge_shop`, `badges`, `bans`, `bmt_transactions`, `bots`, `bots_pets_commands`, `bots_pets_responses`, `bots_responses`, `bots_speech`, `catalog_bot_presets`, `catalog_items`, `catalog_marketplace_data`, `catalog_marketplace_offers`, `catalog_pages`, `catalog_pet_races`, `chatlogs`, `chatlogs_pms`, `cmdlogs`, `cms_activateemail`, `cms_cache`, `cms_fansites`, `cms_help_replies`, `cms_help_tickets`, `cms_passresets`, `cms_pollanswers`, `cms_polls`, `cms_rotw`, `cms_store`, `cms_store_categories`, `cms_store_info`, `cms_store_invoices`, `cms_store_transactions`, `cms_store_vouchers`, `credit_vouchers`, `dj_timetable`, `ecotron_rewards`, `emu_lottery`, `expire`, `external_texts`, `figure_cache`, `fresh_wwe`, `friend_stream`, `furni_giftids`, `furniture`, `fuse_cmds`, `fuse_permissions`, `fuserights`, `fuserights_subs`, `group_memberships`, `group_requests`, `groups`, `groups_details`, `groups_items`, `groups_memberships`, `help_subjects`, `help_topics`, `home_guestbook`, `hotelspam_whitelist`, `hotelspam_words`, `hotelview_promos`, `hotelview_rewardpromo`, `infobus_answers`, `infobus_questions`, `infobus_results`, `ip_cache`, `ipn_requests`, `irc_sessions`, `irc_users`, `items_groups`, `items_hopper`, `items_jukebox_songs`, `items_rooms_songs`, `linkfilter`, `logs_housekeeping`, `logs_payments`, `lottery_tickets`, `lotto_system`, `messenger_friendships`, `messenger_offline_messages`, `messenger_requests`, `moderation_presets`, `moderation_templates`, `moderation_tickets`, `mus_tax`, `navigator_flatcats`, `navigator_publics`, `navigator_publics_copy`, `navigator_publics_list`, `notes`, `payments`, `paymentwall_logs`, `paypal_logs`, `permissions_ranks`, `permissions_ranks4`, `permissions_users`, `permissions_vip`, `pets_color`, `pets_racesoncatalogue`, `point_products`, `point_tradelogs`, `point_transactions`, `pwlogs`, `quests`, `rank_logs`, `rankingtool_logs`, `ranks`, `requests`, `room_ads`, `room_bans`, `room_events`, `room_items_moodlight`, `room_items_songs`, `room_items_toner`, `room_links`, `room_model_static`, `room_models`, `room_models_customs`, `room_poll_answers`, `room_poll_questions`, `room_poll_results`, `room_polls`, `room_rights`, `rooms`, `rooms_2`, `rotw`, `scamstrikes_log`, `server_locale`, `server_settings`, `server_status`, `site_config`, `site_cron`, `site_help`, `site_hotcampaigns`, `site_minimail`, `site_navi`, `site_news`, `site_news_categories`, `site_news_comments`, `site_news_comments_likes`, `sleeve_settings`, `snog_subscriptions`, `songs`, `soundtracks`, `staff_info`, `staff_logs`, `strike_logs`, `stripe_payments`, `system_stats`, `tele_links`, `texts`, `trigger_in_place`, `trigger_item`, `trigger_rotation`, `unbans`, `user_achievement`, `user_achievements`, `user_badges`, `user_effects`, `user_favorites`, `user_groups`, `user_home`, `user_ignores`, `user_info`, `user_items`, `user_items_songs`, `user_pets`, `user_presents`, `user_quests`, `user_relationships`, `user_roomvisits`, `user_socialnetworks`, `user_stats`, `user_subscriptions`, `user_tags`, `user_wardrobe`, `user_wiredactived`, `users`, `values`, `vault`, `vip_commands`, `vip_ranks`, `vouchers`, `wired`, `wired_items`, `wired_prizes_recieved`, `wired_sshot`, `wordfilter` EXTENDED
We're running this code and you can see all the tables that need repairing from here.
-
Thanks Kane, very helpful!
Ookamii :o
-
Interesting, hope everything is well Kane. Very sophisticated technology but believe it or I am intrigued. Awesome work Kane!!!!
-