Contents of the SQL dump from ironmarch.org, a defunct neo-Nazi/white supremacist message board.
Data were acquired via the Bellingcat-linked iron_march_201911_archive.torrent.
im_core_dfs im_orig_dfs im_forums_dfs im_other_dfs combo_members_df combo_messages_df
Each object is a list() of tibble::tibble()s.
An object of class list of length 87.
An object of class list of length 92.
An object of class list of length 3.
An object of class list of length 7.
An object of class tbl_df (inherits from tbl, data.frame) with 1542 rows and 25 columns.
An object of class tbl_df (inherits from tbl, data.frame) with 22309 rows and 9 columns.
im_core_dfs#> $core_acp_search_index #> # A tibble: 1,123 x 5 #> url app lang_key restriction keyword #> <chr> <chr> <chr> <chr> <chr> #> 1 app=core&module=support&… core system_logs NA sql error … #> 2 app=core&module=support&… core system_logs NA sql logs #> 3 app=core&module=support&… core system_logs NA system logs #> 4 app=core&module=support&… core system_logs NA driver err… #> 5 app=core&module=support&… core system_logs NA logs #> 6 app=core&module=support&… core menu__core_suppor… support_dashb… troublesho… #> 7 app=core&module=support&… core menu__core_suppor… support_dashb… support #> 8 app=core&module=support&… core menu__core_suppor… support_dashb… system #> 9 app=core&module=support&… core menu__core_suppor… support_dashb… tech suppo… #> 10 app=core&module=support&… core menu__core_suppor… support_dashb… technical … #> # … with 1,113 more rows #> #> $core_acronyms #> # A tibble: 3 x 4 #> a_id a_short a_long a_casesensitive #> <int> <chr> <chr> <lgl> #> 1 1 GTKRWN Gas the Kikes Race War Now FALSE #> 2 2 NA National Action TRUE #> 3 3 RWDS Race War Death Squads FALSE #> #> $core_admin_login_logs #> # A tibble: 23 x 4 #> admin_id admin_ip_address admin_time admin_request #> <int> <chr> <dttm> <chr> #> 1 6119 162.158.93.88 2017-11-10 00:51:08 "{\"adsess\":\"ek3ium1343v4ipp… #> 2 6120 162.158.93.88 2017-11-12 07:54:35 "{\"adsess\":\"ek3ium1343v4ipp… #> 3 6124 162.158.93.88 2017-11-15 04:42:11 "{\"adsess\":\"ek3ium1343v4ipp… #> 4 6116 162.158.91.198 2017-11-06 20:21:13 "{\"adsess\":\"ek3ium1343v4ipp… #> 5 6117 162.158.91.198 2017-11-06 21:52:07 "{\"adsess\":\"ek3ium1343v4ipp… #> 6 6109 162.158.91.198 2017-10-26 20:19:13 "{\"adsess\":\"ek3ium1343v4ipp… #> 7 6121 162.158.93.88 2017-11-13 21:17:26 "{\"adsess\":\"ek3ium1343v4ipp… #> 8 6122 162.158.93.88 2017-11-14 04:47:22 "{\"adsess\":\"ek3ium1343v4ipp… #> 9 6125 172.68.182.89 2017-11-18 10:12:12 "{\"adsess\":\"mpiq2ka3o3o4i12… #> 10 6126 162.158.93.88 2017-11-20 20:59:00 "{\"adsess\":\"ek3ium1343v4ipp… #> # … with 13 more rows #> #> $core_admin_logs #> # A tibble: 14,595 x 11 #> id member_id ctime note ip_address appcomponent module #> <int> <int> <dttm> <chr> <chr> <chr> <chr> #> 1 4.94… 1 2011-09-12 16:05:48 Cate… 178.140.1… forums forums #> 2 9.88… 1 2011-09-12 16:07:59 Foru… 178.140.1… forums forums #> 3 1.48… 1 2011-09-12 16:08:15 Foru… 178.140.1… forums forums #> 4 1.97… 1 2011-09-12 16:11:38 Foru… 178.140.1… forums forums #> 5 2.47… 1 2011-09-12 16:15:13 Edit… 178.140.1… members groups #> 6 2.96… 1 2011-09-12 16:15:53 Edit… 178.140.1… members groups #> 7 3.45… 1 2011-09-12 16:16:06 Edit… 178.140.1… members groups #> 8 3.95… 1 2011-09-12 16:16:28 Edit… 178.140.1… members groups #> 9 4.44… 1 2011-09-12 16:20:31 Adde… 178.140.1… members groups #> 10 4.94… 1 2011-09-12 17:54:03 Foru… 178.140.1… forums forums #> # … with 14,585 more rows, and 4 more variables: controller <chr>, do <chr>, #> # lang_key <chr>, member_name <chr> #> #> $core_applications #> # A tibble: 3 x 10 #> app_id app_description app_directory app_added app_position #> <int> <chr> <chr> <dttm> <int> #> 1 1 Manage global … core 2011-09-12 15:47:14 1 #> 2 3 Manage forums … forums 2011-09-12 15:47:19 3 #> 3 4 NA calendar 2015-05-12 14:21:25 4 #> # … with 5 more variables: app_protected <lgl>, app_location <chr>, #> # app_update_last_check <int>, app_update_version <chr>, app_default <lgl> #> #> $core_attachments #> # A tibble: 101 x 12 #> attach_id attach_ext attach_file attach_location attach_thumb_lo… #> <int> <chr> <chr> <chr> <chr> #> 1 338 jpg 461022_456… monthly_03_201… monthly_03_2013… #> 2 2 jpg 1056.jpg monthly_09_201… monthly_09_2011… #> 3 3 jpg 1057.jpg monthly_09_201… monthly_09_2011… #> 4 4 jpg 1091.jpg monthly_09_201… monthly_09_2011… #> 5 5 jpg 1108.jpg monthly_09_201… monthly_09_2011… #> 6 6 jpg FASCIST UN… monthly_09_201… monthly_09_2011… #> 7 7 jpg post-2711-… monthly_09_201… monthly_09_2011… #> 8 8 jpg post-2842-… monthly_09_201… monthly_09_2011… #> 9 9 jpg 1029.jpg monthly_09_201… monthly_09_2011… #> 10 10 jpg 1030.jpg monthly_09_201… monthly_09_2011… #> # … with 91 more rows, and 7 more variables: attach_is_image <lgl>, #> # attach_hits <int>, attach_date <dttm>, attach_member_id <int>, #> # attach_filesize <int>, attach_img_width <int>, attach_img_height <int> #> #> $core_attachments_map #> # A tibble: 101 x 3 #> attachment_id id1 id2 #> <int> <int64> <int64> #> 1 2 2.322109e-322 1.007894e-321 #> 2 3 2.322109e-322 1.007894e-321 #> 3 4 2.322109e-322 1.007894e-321 #> 4 5 2.322109e-322 1.007894e-321 #> 5 6 2.322109e-322 1.007894e-321 #> 6 7 2.322109e-322 1.007894e-321 #> 7 8 2.322109e-322 1.007894e-321 #> 8 9 2.322109e-322 1.012835e-321 #> 9 10 2.322109e-322 1.012835e-321 #> 10 11 2.322109e-322 1.012835e-321 #> # … with 91 more rows #> #> $core_banfilters #> # A tibble: 52 x 5 #> ban_id ban_type ban_content ban_date ban_reason #> <int> <chr> <chr> <dttm> <chr> #> 1 1 ip 62.97.238.198 2011-09-18 13:48:53 Tribbles #> 2 2 ip 80.202.110.65 2011-09-18 13:49:39 Also Tribbles #> 3 3 email jacksonhaddress@hotma… 2011-10-06 16:15:37 NA #> 4 4 ip 65.19.38.199 2011-10-06 16:15:37 NA #> 5 5 ip 75.173.64.190 2011-10-06 16:15:37 NA #> 6 6 email a6428490@nepwk.com 2011-10-07 15:03:48 NA #> 7 7 name JackW2 2011-10-07 15:03:48 NA #> 8 8 ip 173.236.27.154 2011-10-07 15:03:48 NA #> 9 9 ip 80.82.69.119 2011-10-07 15:03:48 NA #> 10 10 ip 115.249.239.138 2011-12-19 10:52:08 Spammer - commerc… #> # … with 42 more rows #> #> $core_cache #> # A tibble: 171 x 3 #> cache_key cache_value cache_expire #> <chr> <chr> <int> #> 1 embed_e4cab4adff065e1c4… "\"<div id=\\\"fb-root\\\"><\\/div>\\n… 1511322224 #> 2 embed_6b4bb904504f9db82… "\"<blockquote class=\\\"instagram-med… 1511313994 #> 3 page_5b6871451314a763e2… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237711 #> 4 page_0520ce0fd94d072691… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237756 #> 5 page_8b0b82300d1957b4f8… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237760 #> 6 page_1471b8a5e4fb244e7a… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237768 #> 7 page_77fa5a9b770109ce88… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237749 #> 8 page_cd26222ed1107a2710… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237755 #> 9 page_cee4024758e5a03f7d… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237745 #> 10 page_8129275e64c9925d82… "{\"output\":\"\\n<!DOCTYPE html>\\n<h… 1511237734 #> # … with 161 more rows #> #> $core_deletion_log #> # A tibble: 14 x 9 #> dellog_id dellog_content_… dellog_content_… dellog_content_… dellog_deleted_… #> <int64> <int64> <chr> <chr> <int64> #> 1 5.829975… 1.013423e-318 Nordic Resistan… nordic-resistan… 6.521667e-322 #> 2 5.879381… 1.013427e-318 Nordic Resistan… nordic-resistan… 6.521667e-322 #> 3 5.928788… 1.017849e-318 romansoldier sp… romansoldier-sp… 4.940656e-324 #> 4 5.978194… 1.018343e-318 SRN PROPAGANDA … srn-propaganda-… 4.940656e-324 #> 5 6.027601… 1.018299e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 6 6.077007… 1.018388e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 7 6.126414… 1.018393e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 8 6.175821… 1.018408e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 9 6.225227… 1.018437e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 10 6.274634… 1.018467e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 11 6.324040… 1.018477e-318 IRONMARCH IN TH… ironmarch-in-th… 4.940656e-324 #> 12 6.373447… 1.018531e-318 Unofficial AR p… unofficial-ar-p… 4.940656e-324 #> 13 6.422853… 8.772432e-319 Trivial HAPPENI… trivial-happeni… 4.620996e-320 #> 14 6.472260… 8.696593e-319 Trivial HAPPENI… trivial-happeni… 4.620996e-320 #> # … with 4 more variables: dellog_deleted_by_name <chr>, #> # dellog_deleted_date <dttm>, dellog_deleted_by_seo_name <chr>, #> # dellog_content_permissions <chr> #> #> $core_email_templates #> # A tibble: 50 x 7 #> template_id template_app template_name template_data template_conten… #> <int64> <chr> <chr> <chr> <chr> #> 1 8.300303e-… core account_lock… $member, $lo… "<br />\n{$emai… #> 2 8.349709e-… core unsubscribeD… $member, $em… "<tr>\n\t<td di… #> 3 8.399116e-… core digests__are… $output, $ap… "<!-- Add item … #> 4 8.448523e-… core upgrade $version, $r… "\n{$email->lan… #> 5 8.497929e-… core notification… $club, $memb… "<br />\n{$emai… #> 6 8.547336e-… core notification… $comment, $m… "\n{{$item = ( … #> 7 8.596742e-… core email_addres… $member, $ol… "\n{$email->lan… #> 8 8.646149e-… core notification… $container, … "\n{{if $member… #> 9 8.695555e-… core contact_form $member, $na… "{$email->langu… #> 10 8.744962e-… core notification… $comment, $e… "\n{$email->lan… #> # … with 40 more rows, and 2 more variables: template_content_plaintext <chr>, #> # template_key <chr> #> #> $core_emoticons #> # A tibble: 116 x 7 #> id typed image clickable emo_set emo_position emo_set_position #> <int> <chr> <chr> <lgl> <chr> <int> <int> #> 1 110 :berg: emoticons… TRUE 84ba4fa006a… 4 8 #> 2 109 :derp: emoticons… TRUE 84ba4fa006a… 14 8 #> 3 108 :uwot: emoticons… TRUE 84ba4fa006a… 13 8 #> 4 107 :srsly: emoticons… TRUE 84ba4fa006a… 10 8 #> 5 106 :gibsm… emoticons… TRUE 84ba4fa006a… 12 8 #> 6 105 :wat: emoticons… TRUE f700487c16e… 2 6 #> 7 104 :handy: emoticons… TRUE f700487c16e… 24 6 #> 8 174 :arrow… emoticons… TRUE f539dc6131b… 6 3 #> 9 171 :ropec… emoticons… TRUE ebad4264c1c… 9 1 #> 10 101 :moonm… emoticons… TRUE f700487c16e… 20 6 #> # … with 106 more rows #> #> $core_file_logs #> # A tibble: 2,014 x 7 #> log_id log_filename log_msg log_date log_data log_container #> <int6> <chr> <chr> <dttm> <chr> <chr> #> 1 4.103… NA contai… 2017-09-13 14:20:17 "{\"ads… css_built_7 #> 2 4.322… 1200px-Brit… file_d… 2017-09-29 02:40:02 NA monthly_2017… #> 3 4.322… 1200px-Flag… file_d… 2017-09-29 02:40:04 NA monthly_2017… #> 4 4.385… root_map.js… file_d… 2017-10-04 22:02:56 NA javascript_g… #> 5 4.386… root_map.js… file_d… 2017-10-04 22:02:56 NA javascript_g… #> 6 4.386… root_map.js… file_d… 2017-10-04 22:02:56 NA javascript_g… #> 7 4.387… root_map.js… file_d… 2017-10-04 22:03:00 NA javascript_g… #> 8 4.450… Screenshot_… file_d… 2017-10-09 21:33:08 NA monthly_2017… #> 9 4.451… Screenshot_… file_d… 2017-10-09 21:33:08 NA monthly_2017… #> 10 4.451… integra.png… file_d… 2017-10-09 21:34:21 NA monthly_2017… #> # … with 2,004 more rows, and 1 more variable: log_url <chr> #> #> $core_follow #> # A tibble: 8,066 x 13 #> follow_id follow_app follow_area follow_rel_id follow_member_id #> <chr> <chr> <chr> <int64> <int> #> 1 fd493920… forums topic 1.778636e-322 12 #> 2 1b179c39… forums topic 3.063207e-322 12 #> 3 af062e78… forums topic 2.322109e-322 12 #> 4 bbf8f01f… forums topic 2.173889e-322 12 #> 5 b85184ca… forums topic 3.211427e-322 12 #> 6 e7328cad… forums topic 3.656086e-322 12 #> 7 625eb2d4… forums topic 3.705492e-322 12 #> 8 a87febdf… forums topic 3.606679e-322 12 #> 9 e5f6841c… forums topic 2.223295e-322 12 #> 10 6f7a3413… forums topic 3.853712e-322 12 #> # … with 8,056 more rows, and 8 more variables: follow_is_anon <lgl>, #> # follow_added <dttm>, follow_notify_do <lgl>, follow_notify_meta <chr>, #> # follow_notify_freq <chr>, follow_notify_sent <dttm>, follow_visible <lgl>, #> # follow_index_id <int64> #> #> $core_groups #> # A tibble: 11 x 45 #> g_id g_view_board g_other_topics g_edit_profile g_post_new_topi… #> <int> <lgl> <lgl> <lgl> <lgl> #> 1 2 TRUE TRUE FALSE TRUE #> 2 3 TRUE TRUE TRUE TRUE #> 3 4 TRUE TRUE TRUE TRUE #> 4 6 TRUE TRUE TRUE TRUE #> 5 7 TRUE TRUE FALSE TRUE #> 6 10 TRUE TRUE TRUE TRUE #> 7 13 TRUE TRUE TRUE TRUE #> 8 14 FALSE NA TRUE NA #> 9 15 FALSE NA TRUE NA #> 10 16 FALSE NA TRUE NA #> 11 17 TRUE NA TRUE NA #> # … with 40 more variables: g_reply_own_topics <lgl>, #> # g_reply_other_topics <lgl>, g_edit_posts <chr>, g_delete_own_posts <chr>, #> # g_open_close_posts <lgl>, g_delete_own_topics <lgl>, g_post_polls <lgl>, #> # g_vote_polls <lgl>, g_use_pm <lgl>, g_append_edit <lgl>, #> # g_access_offline <lgl>, g_avoid_q <lgl>, g_avoid_flood <lgl>, g_icon <chr>, #> # prefix <chr>, g_max_messages <int>, g_max_mass_pm <int>, #> # g_search_flood <int>, g_edit_cutoff <int>, g_hide_from_list <lgl>, #> # g_post_closed <lgl>, g_photo_max_vars <chr>, g_edit_topic <lgl>, #> # g_bypass_badwords <lgl>, g_can_msg_attach <lgl>, #> # g_topic_rate_setting <int>, g_dname_changes <int>, g_dname_date <int>, #> # g_mod_preview <lgl>, g_rep_max_positive <int>, g_rep_max_negative <int>, #> # g_signature_limits <chr>, g_bitoptions <int>, g_pm_perday <int>, #> # g_pm_flood_mins <int>, g_bitoptions2 <int>, g_hide_own_posts <chr>, #> # g_lock_unlock_own <chr>, g_can_report <chr>, g_promote_exclude <lgl> #> #> $core_hooks_files #> # A tibble: 8 x 7 #> hook_file_id hook_hook_id hook_file_stored hook_file_real hook_classname #> <int> <int> <chr> <chr> <chr> #> 1 39 1 boardIndexSideB… boardIndexSid… boardIndexSid… #> 2 43 2 boardIndexStatu… boardIndexSta… boardIndexSta… #> 3 40 3 boardIndexRecen… boardIndexRec… boardIndexRec… #> 4 41 4 boardIndexFaceb… boardIndexFac… boardIndexFac… #> 5 42 5 boardIndexTags_… boardIndexTag… boardIndexTags #> 6 44 9 boardIndexCalen… boardIndexCal… boardIndexCal… #> 7 45 10 calendarUpcomin… calendarUpcom… calendarUpcom… #> 8 46 11 calendarUpcomin… calendarUpcom… calendarUpcom… #> # … with 2 more variables: hook_data <chr>, hooks_source <chr> #> #> $core_ignored_users #> # A tibble: 22 x 6 #> ignore_id ignore_owner_id ignore_ignore_id ignore_messages ignore_topics #> <int> <int> <int> <lgl> <lgl> #> 1 2 143 84 FALSE FALSE #> 2 31 13558 72 FALSE FALSE #> 3 4 255 279 FALSE FALSE #> 4 32 14399 6260 TRUE TRUE #> 5 7 991 1109 FALSE FALSE #> 6 8 288 91 FALSE FALSE #> 7 11 54 6113 FALSE FALSE #> 8 13 7364 132 FALSE FALSE #> 9 15 7901 7508 TRUE TRUE #> 10 17 7643 7481 FALSE FALSE #> # … with 12 more rows, and 1 more variable: ignore_mentions <lgl> #> #> $core_item_markers #> # A tibble: 32,032 x 6 #> item_key item_member_id item_app item_read_array item_global_res… #> <chr> <int> <chr> <chr> <int> #> 1 a0a92a5… 1 forums "[]" 1511237486 #> 2 400d1e9… 1 forums "[]" 1507271991 #> 3 06a3790… 1 forums "[]" 1510886634 #> 4 1aefba1… 1 forums "[]" 1511095618 #> 5 1589e34… 1 calendar "{\"69\":14591… 1459164193 #> 6 6229be0… 1 forums "[]" 1511211533 #> 7 b360186… 1 forums "[]" 1511211533 #> 8 7972acd… 1 forums "[]" 1511211533 #> 9 ba0737a… 1 forums "[]" 1511200946 #> 10 dabd5bf… 132 forums "[]" 1458909380 #> # … with 32,022 more rows, and 1 more variable: item_app_key_1 <int> #> #> $core_javascript #> # A tibble: 251 x 8 #> javascript_id javascript_type javascript_cont… javascript_app javascript_path #> <int> <chr> <chr> <chr> <chr> #> 1 1121 framework "/*\n * transfo… global jquery #> 2 1122 framework "/* jstz.min.js… global jstz #> 3 1123 framework "\"use strict\"… global linkify #> 4 1124 framework "!function(){\"… global linkify #> 5 1125 mixins "/**\n * Invisi… core mixins #> 6 1126 mixins "/**\n * Invisi… global mixins #> 7 1127 mixins "/**\n * Invisi… global mixins #> 8 1128 model "/**\n * Invisi… global models/core #> 9 1129 model "/**\n * Invisi… core models/messages #> 10 1130 model "/**\n * Invisi… core models/messages #> # … with 241 more rows, and 3 more variables: javascript_location <chr>, #> # javascript_position <int>, javascript_name <chr> #> #> $core_leaders #> # A tibble: 3 x 2 #> leader_id leader_type_id #> <int64> <int> #> 1 4.940656e-324 4 #> 2 9.881313e-324 6 #> 3 1.482197e-323 10 #> #> $core_like_cache #> # A tibble: 5,304 x 6 #> like_cache_id like_cache_app like_cache_area like_cache_rel_… like_cache_data #> <chr> <chr> <chr> <int64> <chr> #> 1 321571a7b843… forums forums 1.482197e-322 "a:3:{s:7:\"me… #> 2 5b1fb15ebe04… forums topics 1.805810e-320 "a:3:{s:7:\"me… #> 3 4ed3d61094ba… forums topics 1.806798e-320 "a:3:{s:7:\"me… #> 4 b5067d6b91ca… forums topics 7.855644e-322 "a:3:{s:7:\"me… #> 5 81d82ffa5b6d… forums forums 6.422853e-323 "a:3:{s:7:\"me… #> 6 d9409ca5f0c5… forums topics 2.535051e-320 "a:3:{s:7:\"me… #> 7 296567d2dffd… forums topics 2.698587e-320 "a:3:{s:7:\"me… #> 8 6ee661dd69ab… forums topics 2.674871e-320 "a:3:{s:7:\"me… #> 9 98ca3d02b4a1… forums topics 2.603726e-320 "a:3:{s:7:\"me… #> 10 a7aac8b0f1a9… forums topics 1.482197e-323 "a:3:{s:7:\"me… #> # … with 5,294 more rows, and 1 more variable: like_cache_expire <int> #> #> $core_log #> # A tibble: 7,238 x 9 #> id exception_class exception_code message backtrace time category url #> <int> <chr> <lgl> <chr> <chr> <int> <chr> <chr> #> 1 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 2 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 3 1.25… NA NA "\nIPS… "#0 /usr… 1.51e9 uncaugh… http… #> 4 1.25… NA NA "\nIPS… "#0 /usr… 1.51e9 uncaugh… http… #> 5 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 6 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 7 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 8 1.25… NA NA "\nIPS… "#0 /usr… 1.51e9 uncaugh… http… #> 9 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> 10 1.25… OutOfRangeExce… FALSE NA "#0 /usr… 1.51e9 embed_e… http… #> # … with 7,228 more rows, and 1 more variable: member_id <int> #> #> $core_login_handlers #> # A tibble: 10 x 5 #> login_key login_settings login_order login_acp login_enabled #> <chr> <chr> <int> <lgl> <lgl> #> 1 Internal "{\"auth_types\":1}" 1 TRUE TRUE #> 2 Ldap "{\"auth_types\":1}" 4 FALSE FALSE #> 3 External "{\"auth_types\":1}" 5 FALSE FALSE #> 4 Facebook "{\"app_id\":null,\"app_secre… 6 FALSE FALSE #> 5 Twitter "{\"consumer_key\":null,\"con… 7 FALSE FALSE #> 6 Live "[]" 8 FALSE FALSE #> 7 Linkedin "[]" 9 FALSE FALSE #> 8 Google "[]" 10 FALSE FALSE #> 9 Ipsconnect "[]" 11 FALSE FALSE #> 10 Convert "[]" 12 FALSE FALSE #> #> $core_member_history #> # A tibble: 3,481 x 7 #> log_id log_member log_by log_type log_data log_date log_ip_address #> <int6> <int64> <int6> <chr> <chr> <dttm> <chr> #> 1 4.940… 7.905050e… 0 display… "{\"old… 2011-09-14 05:33:58 152.33.17.196 #> 2 9.881… 7.905050e… 0 display… "{\"old… 2011-09-14 05:43:54 152.33.17.196 #> 3 1.482… 3.952525e… 0 display… "{\"old… 2011-09-14 20:57:39 98.198.24.90 #> 4 1.976… 5.434722e… 0 display… "{\"old… 2011-10-04 18:52:06 109.77.91.235 #> 5 2.470… 5.632348e… 0 display… "{\"old… 2012-01-19 22:52:07 79.67.83.218 #> 6 2.964… 5.632348e… 0 display… "{\"old… 2012-01-21 19:26:39 79.67.83.218 #> 7 3.458… 7.905050e… 0 display… "{\"old… 2012-02-23 06:11:55 188.95.153.254 #> 8 3.952… 6.916919e… 0 display… "{\"old… 2012-02-28 20:45:34 24.229.117.252 #> 9 4.446… 1.976263e… 0 display… "{\"old… 2012-03-05 16:17:43 82.17.111.92 #> 10 4.940… 9.733093e… 0 display… "{\"old… 2012-03-28 00:33:49 89.136.88.101 #> # … with 3,471 more rows #> #> $core_member_status_replies #> # A tibble: 487 x 7 #> reply_id reply_status_id reply_member_id reply_date reply_content #> <int> <int> <int> <int> <chr> #> 1 1 2 35 1324554161 "<p>Try livi… #> 2 2 2 132 1328301526 "<p>Try livi… #> 3 3 23 143 1330034455 "<p>Omg, blo… #> 4 5 27 164 1332465964 "<p>Yeah it'… #> 5 710 3024 9446 1486996408 "<p>\n\tI co… #> 6 7 29 132 1333328200 "<p>*hmm...s… #> 7 8 29 130 1333757777 "<p>lolgenoc… #> 8 9 29 130 1333758050 "<p>I didn't… #> 9 10 26 84 1335455835 "<p>I thank … #> 10 11 49 246 1338862771 "<p>I prefer… #> # … with 477 more rows, and 2 more variables: reply_approved <int>, #> # reply_ip_address <chr> #> #> $core_member_status_updates #> # A tibble: 553 x 12 #> status_id status_member_id status_date status_content status_replies #> <int> <int> <int> <chr> <int> #> 1 2 14 1316397519 <p>Cold... *b… 3 #> 2 6 35 1319211330 <p>I am so fu… 0 #> 3 7 35 1319935567 <p>Queensrych… 0 #> 4 8 35 1319935570 <p>Queensrych… 0 #> 5 11 35 1321967601 <p>Getting in… 0 #> 6 12 89 1324039690 <p>National S… 0 #> 7 28 143 1332804371 <p>Ahaha, gna… 0 #> 8 29 130 1332911151 <p>Dreams of … 3 #> 9 19 143 1328730328 <p>Numbess of… 0 #> 10 20 143 1328846880 <p>Sleep addi… 0 #> # … with 543 more rows, and 7 more variables: status_last_ids <chr>, #> # status_is_latest <lgl>, status_is_locked <lgl>, status_hash <chr>, #> # status_author_id <int>, status_author_ip <chr>, status_approved <int> #> #> $core_members #> # A tibble: 1,207 x 66 #> member_id name member_group_id email joined ip_address #> <int> <chr> <int> <chr> <dttm> <chr> #> 1 1 Алек… 4 slav… 2011-09-12 15:46:59 178.140.1… #> 2 14875 Poet… 17 Gray… 2017-08-29 15:39:22 199.66.88… #> 3 14918 Vale… 17 oliv… 2017-09-10 15:51:00 86.10.127… #> 4 14926 cucc… 14 nigg… 2017-09-12 18:29:13 172.104.1… #> 5 14921 Hier… 17 Prow… 2017-09-11 11:07:06 2600:8804… #> 6 2 Phal… 13 illu… 2011-09-12 15:52:30 68.37.21.… #> 7 14057 Righ 13 righ… 2017-02-20 16:13:25 46.28.53.… #> 8 14040 Zaxon 14 helv… 2017-02-18 09:36:32 185.93.18… #> 9 14041 Солд… 13 mrel… 2017-02-18 12:06:20 2a02:c7d:… #> 10 3 Bloo… 13 rene… 2011-09-12 18:10:11 68.10.255… #> # … with 1,197 more rows, and 60 more variables: allow_admin_mails <list>, #> # skin <int>, warn_level <int>, warn_lastwarn <int>, language <int>, #> # restrict_post <int>, bday_day <int>, bday_month <int>, bday_year <int>, #> # msg_count_new <int>, msg_count_total <int>, msg_count_reset <int>, #> # msg_show_notification <lgl>, last_visit <dttm>, last_activity <dttm>, #> # mod_posts <int>, auto_track <chr>, temp_ban <int>, mgroup_others <chr>, #> # member_login_key_expire <dttm>, members_seo_name <chr>, #> # members_cache <chr>, members_disable_pm <int>, failed_logins <chr>, #> # failed_login_count <int>, members_profile_views <int>, #> # members_pass_hash <chr>, members_pass_salt <chr>, members_bitoptions <int>, #> # members_day_posts <chr>, notification_cnt <int>, pp_last_visitors <chr>, #> # pp_main_photo <chr>, pp_main_width <int>, pp_main_height <int>, #> # pp_thumb_photo <chr>, pp_thumb_width <int>, pp_thumb_height <int>, #> # pp_setting_count_comments <lgl>, pp_reputation_points <int>, #> # pp_gravatar <chr>, pp_photo_type <chr>, signature <chr>, #> # fb_bwoptions <lgl>, tc_last_sid_import <chr>, tc_bwoptions <lgl>, #> # pp_customization <chr>, timezone <chr>, pp_cover_photo <chr>, #> # members_bitoptions2 <int>, create_menu <chr>, marked_site_read <int>, #> # pp_cover_offset <int>, acp_skin <lgl>, acp_language <lgl>, #> # member_title <chr>, member_posts <int>, member_last_post <int>, #> # member_streams <chr>, photo_last_update <dttm> #> #> $core_members_known_devices #> # A tibble: 4,637 x 7 #> device_key member_id user_agent login_key last_seen anonymous login_handler #> <chr> <int64> <chr> <chr> <int> <lgl> <chr> #> 1 00082373c8… 6.615539… Mozilla/5.… 87d2e29b… 1.51e9 FALSE Internal #> 2 000cc82a64… 7.429265… Mozilla/5.… 499daed4… 1.51e9 FALSE NA #> 3 001984f07a… 4.745995… Mozilla/5.… 2834e20c… 1.51e9 FALSE Internal #> 4 00273c660c… 6.593800… Mozilla/5.… d2fa09c1… 1.51e9 FALSE Internal #> 5 00301de9d1… 7.427289… Mozilla/5.… 7c5b4eac… 1.51e9 FALSE Internal #> 6 004e28b744… 7.315630… Mozilla/5.… NA 1.50e9 FALSE NA #> 7 00574e72b1… 4.047386… Mozilla/5.… 1c8f47d6… 1.51e9 FALSE Internal #> 8 0058c48a38… 7.388752… Mozilla/5.… NA 1.51e9 FALSE Internal #> 9 005ee0ee6a… 7.195572… Mozilla/5.… 829c2395… 1.51e9 FALSE Internal #> 10 009368382d… 7.116522… Mozilla/5.… NA 1.50e9 FALSE Internal #> # … with 4,627 more rows #> #> $core_members_known_ip_addresses #> # A tibble: 14,903 x 4 #> device_key member_id ip_address last_seen #> <chr> <int64> <chr> <int> #> 1 72c8beef2683dca41ab7c92ab41ca964 4.940656e-324 84.85.45.210 1501826677 #> 2 270fc3e4ff80f6e6c6b0b011b79d5bbd 4.940656e-324 84.85.45.210 1502042815 #> 3 729d5284c9efc85e57a372ca55ac533d 4.940656e-324 5.228.86.255 1502124078 #> 4 4e7fb2ffc0a94cbe812aee8dfabf8fa6 4.940656e-324 89.200.4.210 1503523918 #> 5 4e7fb2ffc0a94cbe812aee8dfabf8fa6 4.940656e-324 84.85.45.210 1504544107 #> 6 ca626a411d361d01057e95d108d9fc34 4.940656e-324 5.228.86.255 1505271409 #> 7 ca626a411d361d01057e95d108d9fc34 4.940656e-324 109.188.126.136 1505289399 #> 8 ca626a411d361d01057e95d108d9fc34 4.940656e-324 109.188.125.197 1505310055 #> 9 ca626a411d361d01057e95d108d9fc34 4.940656e-324 5.228.74.139 1505453063 #> 10 ca626a411d361d01057e95d108d9fc34 4.940656e-324 5.228.78.239 1505972949 #> # … with 14,893 more rows #> #> $core_members_warn_logs #> # A tibble: 187 x 17 #> wl_id wl_member wl_moderator wl_date wl_reason wl_points #> <int> <int> <int> <dttm> <int> <int> #> 1 2 40 4 2011-10-27 23:38:28 0 1 #> 2 3 40 4 2011-10-27 23:39:35 0 0 #> 3 4 40 4 2011-12-04 00:16:19 0 0 #> 4 5 89 7 2011-12-17 22:04:47 0 1 #> 5 6 49 14 2011-12-17 22:07:40 0 1 #> 6 7 40 14 2011-12-23 20:27:50 0 0 #> 7 8 40 14 2011-12-25 14:33:04 0 0 #> 8 9 40 4 2012-01-01 19:56:58 0 0 #> 9 10 40 4 2012-01-28 21:05:49 0 0 #> 10 11 49 4 2012-01-28 21:06:46 0 0 #> # … with 177 more rows, and 11 more variables: wl_note_member <chr>, #> # wl_note_mods <chr>, wl_mq <chr>, wl_rpa <chr>, wl_suspend <chr>, #> # wl_acknowledged <lgl>, wl_content_app <chr>, wl_content_id1 <chr>, #> # wl_content_id2 <chr>, wl_expire_date <int>, wl_content_module <chr> #> #> $core_members_warn_reasons #> # A tibble: 6 x 5 #> wr_id wr_points_override wr_remove_unit wr_remove_override wr_order #> <int> <lgl> <chr> <lgl> <int> #> 1 1 FALSE h FALSE 1 #> 2 2 FALSE h FALSE 2 #> 3 3 FALSE h FALSE 5 #> 4 4 FALSE h FALSE 4 #> 5 5 FALSE h FALSE 3 #> 6 6 TRUE NA TRUE 0 #> #> $core_menu #> # A tibble: 18 x 8 #> id app extension config position parent permissions is_menu_child #> <int6> <chr> <chr> <chr> <int> <int> <chr> <lgl> #> 1 4.940… core CustomItem "{\"menu_c… 1 NA * FALSE #> 2 9.881… core CustomItem "{\"menu_c… 2 NA * FALSE #> 3 1.482… core AllActivi… "[]" 1 2 * FALSE #> 4 1.976… core YourActiv… "[]" 2 2 * FALSE #> 5 2.470… core YourActiv… "{\"menu_s… 3 2 * FALSE #> 6 2.964… core YourActiv… "{\"menu_s… 4 2 * FALSE #> 7 3.458… core Search "[]" 5 2 * FALSE #> 8 4.446… cale… Calendar "[]" 3 1 * FALSE #> 9 4.940… core Guidelines "[]" 2 1 * FALSE #> 10 5.434… core StaffDire… "[]" 4 1 * FALSE #> 11 5.928… core OnlineUse… "[]" 5 1 * FALSE #> 12 6.422… core Menu "[]" 3 NA * FALSE #> 13 6.916… core CustomItem "{\"menu_c… 3 13 * TRUE #> 14 7.410… core CustomItem "{\"menu_c… 2 13 * TRUE #> 15 8.399… core CustomItem "{\"menu_c… 1 13 * TRUE #> 16 8.893… core Promoted "[]" 6 NA NA FALSE #> 17 9.387… core Clubs "[]" 7 NA NA FALSE #> 18 9.881… core Leaderboa… "[]" 8 NA NA FALSE #> #> $core_message_posts #> # A tibble: 21,715 x 8 #> msg_id msg_topic_id msg_date msg_post msg_post_key msg_author_id #> <int> <int> <dttm> <chr> <chr> <int> #> 1 1 1 2011-09-16 03:49:58 "<p>The… 3320f7f06c4… 1 #> 2 2 2 2011-09-16 11:54:08 "\n<p>W… 9204e488332… 11 #> 3 3 2 2011-09-16 14:39:59 "<p>Cri… 12fd0309239… 1 #> 4 4 2 2011-09-16 15:29:01 "<p>Tha… 0658c6f99ac… 11 #> 5 5 2 2011-09-16 15:32:58 "<p>If … 570257864e3… 1 #> 6 6 2 2011-09-16 15:44:51 "<p>The… aabeacc8f4c… 11 #> 7 7 3 2011-09-17 01:43:49 "<p>I d… a36f67c0d72… 16 #> 8 8 3 2011-09-17 01:59:50 "\n<blo… 327b933d818… 14 #> 9 12 5 2011-09-20 14:20:14 "<p>The… 0667258c387… 1 #> 10 13 5 2011-09-20 14:42:17 "<p>Don… de1d7fd2737… 20 #> # … with 21,705 more rows, and 2 more variables: msg_ip_address <chr>, #> # msg_is_first_post <lgl> #> #> $core_message_topic_user_map #> # A tibble: 8,787 x 12 #> map_id map_user_id map_topic_id map_folder_id map_read_time #> <int> <int> <int> <chr> <dttm> #> 1 1 23 1 myconvo 2011-11-04 06:53:06 #> 2 2 1 1 myconvo 2011-09-20 14:19:38 #> 3 3 1 2 myconvo 2011-09-16 15:46:25 #> 4 4 11 2 myconvo 2011-09-20 04:03:38 #> 5 5 14 3 myconvo 2011-09-17 01:59:51 #> 6 6 16 3 myconvo 2011-09-17 18:19:01 #> 7 9 20 5 myconvo 2011-09-20 14:42:17 #> 8 10 1 5 myconvo 2011-11-07 01:36:40 #> 9 11 11 6 myconvo 2011-09-22 14:18:00 #> 10 12 1 6 myconvo 2011-09-22 14:33:52 #> # … with 8,777 more rows, and 7 more variables: map_user_active <lgl>, #> # map_user_banned <lgl>, map_has_unread <lgl>, map_is_starter <lgl>, #> # map_left_time <int>, map_ignore_notification <lgl>, #> # map_last_topic_reply <dttm> #> #> $core_message_topics #> # A tibble: 4,475 x 12 #> mt_id mt_date mt_title mt_starter_id mt_start_time #> <int> <dttm> <chr> <int> <dttm> #> 1 1 2011-09-16 03:49:58 Introdu… 1 2011-09-16 03:49:58 #> 2 2 2011-09-16 11:54:08 Our hos… 11 2011-09-16 11:54:07 #> 3 3 2011-09-17 01:43:49 Re: Nov… 16 2011-09-17 01:43:49 #> 4 5 2011-09-20 14:20:14 Introdu… 1 2011-09-20 14:20:14 #> 5 6 2011-09-22 14:12:17 msn 1 2011-09-22 14:12:17 #> 6 8 2011-09-22 21:21:22 Do you … 2 2011-09-22 21:21:22 #> 7 10 2011-09-23 20:44:56 Introdu… 1 2011-09-23 20:44:56 #> 8 11 2011-09-24 09:40:39 Introdu… 1 2011-09-24 09:40:39 #> 9 12 2011-09-25 17:18:50 Welcome… 14 2011-09-25 17:18:50 #> 10 13 2011-09-26 01:05:50 Could I… 2 2011-09-26 01:05:49 #> # … with 4,465 more rows, and 7 more variables: mt_last_post_time <dttm>, #> # mt_to_count <int>, mt_to_member_id <int>, mt_replies <int>, #> # mt_first_msg_id <int>, mt_is_draft <lgl>, mt_is_deleted <lgl> #> #> $core_moderator_logs #> # A tibble: 32,547 x 13 #> id member_id ctime note ip_address appcomponent module #> <int> <int> <dttm> <chr> <chr> <chr> <chr> #> 1 4.94… 0 2011-09-12 17:13:41 NA 178.140.1… core task #> 2 9.88… 1 2011-09-12 18:14:50 "{\"… 178.140.1… forums NA #> 3 1.48… 1 2011-09-12 18:14:50 "{\"… 178.140.1… forums NA #> 4 1.97… 1 2011-09-12 21:42:16 "{\"… 178.140.1… forums NA #> 5 2.47… 0 2011-09-12 22:05:07 NA 178.140.1… core task #> 6 2.96… 1 2011-09-13 08:52:25 "{\"… 178.140.1… forums NA #> 7 3.45… 1 2011-09-13 09:13:02 "{\"… 178.140.1… forums NA #> 8 3.95… 1 2011-09-13 09:47:48 "{\"… 178.140.1… forums NA #> 9 4.44… 1 2011-09-13 09:52:23 "{\"… 178.140.1… forums NA #> 10 4.94… 1 2011-09-13 09:55:16 "{\"… 178.140.1… forums NA #> # … with 32,537 more rows, and 6 more variables: controller <chr>, do <chr>, #> # lang_key <chr>, class <chr>, item_id <int>, member_name <chr> #> #> $core_moderators #> # A tibble: 3 x 3 #> id perms updated #> <int64> <chr> <int> #> 1 1.976263e-… "*" 1.46e9 #> 2 2.964394e-… "{\"can_manage_sidebar\":false,\"can_use_ip_tools\":tru… 1.50e9 #> 3 4.940656e-… "{\"can_manage_sidebar\":false,\"can_use_ip_tools\":tru… 1.50e9 #> #> $core_modules #> # A tibble: 41 x 8 #> sys_module_id sys_module_appl… sys_module_key sys_module_prot… #> <int> <chr> <chr> <lgl> #> 1 1 core overview FALSE #> 2 2 core system TRUE #> 3 3 core applications FALSE #> 4 4 core settings FALSE #> 5 5 core members FALSE #> 6 6 core membersettings FALSE #> 7 7 core staff FALSE #> 8 8 core customization FALSE #> 9 9 core languages FALSE #> 10 10 core editor FALSE #> # … with 31 more rows, and 4 more variables: sys_module_position <int>, #> # sys_module_area <chr>, sys_module_default <lgl>, #> # sys_module_default_controller <chr> #> #> $core_notification_defaults #> # A tibble: 17 x 2 #> notification_key default #> <chr> <chr> #> 1 member_follow inline #> 2 profile_comment inline #> 3 profile_reply inline #> 4 new_status inline #> 5 new_private_message email #> 6 private_message_added email #> 7 new_content email #> 8 new_comment email #> 9 new_review email #> 10 follower_content inline #> 11 quote inline #> 12 mention inline #> 13 new_likes inline #> 14 warning_mods inline #> 15 report_center email #> 16 unapproved_content email #> 17 event_reminder email #> #> $core_notification_preferences #> # A tibble: 14,486 x 3 #> member_id notification_key preference #> <int> <chr> <chr> #> 1 2 private_message_added email #> 2 3 private_message_added email #> 3 3 new_private_message email #> 4 4 private_message_added email #> 5 4 new_private_message email #> 6 5 profile_comment inline #> 7 5 member_follow inline #> 8 14852 new_content email #> 9 8 private_message_added email #> 10 8 new_private_message email #> # … with 14,476 more rows #> #> $core_notifications #> # A tibble: 34,802 x 13 #> id member notification_key item_class item_id member_data sent_time #> <int> <int> <chr> <chr> <int64> <chr> <int> #> 1 1.02… 14201 new_likes "IPS\\for… 1.0029… NA 1.51e9 #> 2 1.02… 14852 new_comment "IPS\\for… 2.0553… "{\"follow… 1.51e9 #> 3 1.01… 14041 new_likes "IPS\\for… 9.8428… NA 1.50e9 #> 4 1.01… 14127 new_likes "IPS\\for… 1.0008… NA 1.50e9 #> 5 1.03… 14404 new_likes "IPS\\for… 1.0040… NA 1.51e9 #> 6 1.03… 9668 new_likes "IPS\\for… 1.0041… NA 1.51e9 #> 7 1.02… 14450 new_comment "IPS\\for… 2.8300… "{\"follow… 1.51e9 #> 8 1.02… 13839 new_likes "IPS\\for… 9.8020… NA 1.51e9 #> 9 1.02… 14102 new_comment "IPS\\for… 4.1145… "{\"follow… 1.51e9 #> 10 1.02… 14450 new_comment "IPS\\for… 4.1145… "{\"follow… 1.51e9 #> # … with 34,792 more rows, and 6 more variables: read_time <int>, #> # notification_app <chr>, updated_time <int>, item_sub_class <chr>, #> # item_sub_id <int64>, extra <chr> #> #> $core_permission_index #> # A tibble: 202 x 10 #> perm_id app perm_type perm_type_id perm_view perm_2 perm_3 perm_4 perm_6 #> <int> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 memb… profile_… 1 2,3,4,6,… NA NA NA NA #> 2 2 core help 1 2,3,4,6,… NA NA NA NA #> 3 3 foru… forum 1 2,13,4,6… NA NA NA NA #> 4 125 foru… forum 2 6,10,13,… 6,10,… 4 6,10,… NA #> 5 110 foru… forum 92 4,2,13,6… 4,2,1… 4,13,… 4,13,… NA #> 6 7 foru… forum 5 4,2,13,6… 4,2,1… 4,13,… 4,13,… 4,6,10 #> 7 118 foru… forum 100 4,2,13,6… 4,2,1… 4,13,… 4,13,… NA #> 8 9 foru… forum 7 4,2,13,6… NA NA NA NA #> 9 109 foru… forum 91 4,2,13,6… 4,2,1… 4,13,… 4,13,… NA #> 10 108 foru… forum 90 4,2,13,6… 4,2,1… 4,13,… 4,13,… NA #> # … with 192 more rows, and 1 more variable: owner_only <lgl> #> #> $core_pfields_content #> # A tibble: 1,208 x 8 #> member_id field_3 field_5 field_6 field_7 field_11 field_12 field_13 #> <int> <chr> <chr> <chr> <chr> <chr> <chr> <chr> #> 1 1 NA Male Third R… NA FASCISM NA NA #> 2 2 NA Male NA NA Out of co… NA NA #> 3 3 NA Male Dixie Muay Tha… ≠ NA NA #> 4 4 http://… Male Babylon You Theonomy "\n<p>\n\… NA #> 5 5 NA Male Great B… Politics… Republica… NA NA #> 6 7 NA Male United … NA Post-Irony NA NA #> 7 8 NA Male NA NA Syndicali… "<p>\n\tE… NA #> 8 9 NA Female AWOL NA Classic F… NA NA #> 9 11 NA Male Ireland NA Fascist-e… NA NA #> 10 12 NA Not Tel… NA NA Integrali… NA NA #> # … with 1,198 more rows #> #> $core_pfields_data #> # A tibble: 7 x 9 #> pf_id pf_content pf_type pf_not_null pf_position pf_show_on_reg pf_format #> <int> <chr> <chr> <lgl> <int> <lgl> <chr> #> 1 3 "null" Url FALSE 0 FALSE NA #> 2 5 "[\"Not T… Select TRUE 2 TRUE NA #> 3 6 "null" Text TRUE 3 TRUE "<span c… #> 4 7 "null" TextAr… FALSE 4 FALSE NA #> 5 13 "null" Url FALSE 5 FALSE NA #> 6 11 "null" Text TRUE 1 TRUE "<span c… #> 7 12 "null" Editor FALSE 0 FALSE NA #> # … with 2 more variables: pf_group_id <int>, pf_search_type <chr> #> #> $core_pfields_groups #> # A tibble: 3 x 1 #> pf_group_id #> <int> #> 1 1 #> 2 2 #> 3 3 #> #> $core_polls #> # A tibble: 40 x 7 #> pid start_date choices starter_id votes poll_question #> <int> <dttm> <chr> <int> <int> <chr> #> 1 1 2011-12-13 15:25:38 "{\"1\… 4 13 NA #> 2 3 2012-02-14 00:03:33 "{\"1\… 4 27 THERE WAS A … #> 3 4 2012-03-06 16:28:36 "{\"1\… 14 41 Answer the Q… #> 4 6 2012-05-11 01:31:58 "{\"1\… 0 40 Do you have … #> 5 11 2012-09-06 04:27:51 "{\"1\… 274 20 How would pe… #> 6 18 2013-08-10 01:03:42 "{\"1\… 6201 25 How Gay is t… #> 7 20 2013-08-19 20:44:13 "{\"1\… 0 23 Mexican or M… #> 8 23 2013-10-22 13:27:17 "{\"1\… 35 53 Where do you… #> 9 24 2014-03-15 05:34:15 "{\"1\… 6122 22 NA #> 10 25 2014-04-30 20:33:11 "{\"1\… 0 28 Climate Chan… #> # … with 30 more rows, and 1 more variable: poll_view_voters <lgl> #> #> $core_profile_steps #> # A tibble: 2 x 5 #> step_id step_completion_… step_required step_extension step_subcompletion_act #> <int64> <chr> <list> <chr> <chr> #> 1 4.94065… profile_fields <raw [1]> core_ProfileF… "[\"core_pfield_11\",… #> 2 9.88131… basic_profile <raw [1]> core_Core "[\"photo\"]" #> #> $core_question_and_answer #> # A tibble: 4 x 2 #> qa_id qa_answers #> <int> <chr> #> 1 17 "[\"JEWISH QUESTION\",\"THE JEWISH QUESTION\"]" #> 2 16 "[\"FASCIST ALMA MATER\"]" #> 3 15 "[\"GAS THE KIKES RACE WAR NOW 1488 BOOTS ON THE GROUND\",\"GAS THE KIK… #> 4 18 "[\"CONCENTRATION CAMP\",\"THE CONCENTRATION CAMP\",\"SHOWERS\",\"THE S… #> #> $core_ratings #> # A tibble: 91 x 5 #> id item_id member rating ip #> <int64> <int64> <int> <int> <chr> #> 1 4.940656e-324 2.118059e-3… 1558 5 83.233.70.12 #> 2 9.881313e-324 2.118059e-3… 958 5 188.228.43.35 #> 3 1.482197e-323 2.118059e-3… 6359 5 69.35.163.246 #> 4 2.569141e-322 4.115073e-3… 13901 5 2605:6000:554a:f600:70ab:e9c2:a48b:… #> 5 2.470328e-323 2.118059e-3… 7 5 91.125.204.107 #> 6 2.964394e-323 2.118059e-3… 125 5 77.38.156.66 #> 7 3.458460e-323 2.118059e-3… 2820 5 99.249.195.215 #> 8 3.952525e-323 2.118059e-3… 2306 5 88.193.135.245 #> 9 4.446591e-323 2.118059e-3… 6310 5 75.157.149.158 #> 10 4.940656e-323 2.899671e-3… 9679 5 66.169.97.70 #> # … with 81 more rows #> #> $core_rc_comments #> # A tibble: 53 x 7 #> id rid comment comment_by comment_date author_name ip_address #> <int> <int> <chr> <int> <dttm> <chr> <chr> #> 1 1 1 "This is a… 9 2011-12-24 09:57:56 Woman in B… 88.147.17… #> 2 13 10 "done" 49 2012-12-27 20:38:44 Владимир_Б… 72.78.105… #> 3 26 74 "<p>Don't … 4 2014-01-02 11:51:34 Mierce 82.25.135… #> 4 30 89 "<p>No.</p… 1 2015-05-13 16:30:24 Александр … 5.228.66.… #> 5 31 89 "<p>I'll n… 2170 2015-05-13 20:18:43 Zeiger 69.70.181… #> 6 32 89 "<p>this i… 9475 2015-05-13 21:47:00 mengligira… 95.142.13… #> 7 33 89 "<p>>Pu… 2220 2015-05-15 02:16:03 Kulturkampf 122.128.1… #> 8 34 90 "Who are y… 2170 2015-05-21 06:36:39 Zeiger 66.102.6.… #> 9 35 90 "<p>He's t… 9475 2015-05-21 06:57:15 mengligira… 95.142.13… #> 10 36 90 "<p>Oh yea… 1 2015-05-21 07:40:49 Александр … 5.228.66.… #> # … with 43 more rows #> #> $core_rc_index #> # A tibble: 99 x 10 #> id class content_id perm_id num_reports num_comments first_report_by #> <int> <chr> <int64> <int64> <int> <int> <int> #> 1 4.94… "IPS… 2.988603e… 5.0888… 1 1 11 #> 2 4.94… "IPS… 2.302741e… 5.7805… 1 1 2099 #> 3 6.91… "IPS… 2.541523e… 5.2370… 1 0 2 #> 4 2.86… "IPS… 3.113058e… 0.000… 1 0 6174 #> 5 3.26… "IPS… 3.231091e… 5.2370… 1 0 6173 #> 6 3.40… "IPS… 3.402828e… 9.5354… 1 0 2 #> 7 3.45… "IPS… 3.402778e… 5.2370… 1 0 2 #> 8 3.65… "IPS… 3.561373e… 5.1876… 1 1 0 #> 9 4.39… "IPS… 4.303806e… 1.5810… 1 4 0 #> 10 4.44… "IPS… 5.591440e… 6.1758… 1 5 0 #> # … with 89 more rows, and 3 more variables: first_report_date <dttm>, #> # last_updated <dttm>, author <int> #> #> $core_rc_reports #> # A tibble: 106 x 6 #> id rid report report_by date_reported ip_address #> <int> <int> <chr> <int> <int> <chr> #> 1 1 1 "\n<blockquote data-ipsquote=… 11 1324684384 NA #> 2 10 10 "\n<blockquote data-ipsquote=… 2099 1356640292 NA #> 3 14 14 "\n<blockquote data-ipsquote=… 2 1361245960 NA #> 4 59 55 "<p>spam profile</p>" 1209 1366310513 NA #> 5 60 56 "<p>more spam profile's</p>" 1209 1366310573 NA #> 6 62 58 "\n<blockquote data-ipsquote=… 6174 1374646450 NA #> 7 71 66 "\n<blockquote data-ipsquote=… 6173 1377089209 NA #> 8 74 69 "\n<blockquote data-ipsquote=… 2 1380356286 NA #> 9 75 70 "\n<blockquote data-ipsquote=… 2 1380356292 NA #> 10 79 74 "\n<blockquote data-ipsquote=… 0 1388660127 NA #> # … with 96 more rows #> #> $core_reputation_index #> # A tibble: 272,129 x 10 #> id member_id app type type_id rep_date member_received #> <int> <int> <chr> <chr> <int> <dttm> <int> #> 1 4.94… 14 foru… pid 4 2011-09-13 23:02:39 1 #> 2 1.48… 14 foru… pid 124 2011-09-14 20:30:25 13 #> 3 1.97… 13 foru… pid 119 2011-09-14 21:57:39 9 #> 4 2.47… 9 foru… pid 180 2011-09-15 16:49:00 3 #> 5 6.29… 11 foru… pid 8457 2012-01-28 19:41:56 7 #> 6 3.45… 3 foru… pid 182 2011-09-15 23:40:19 9 #> 7 3.95… 3 foru… pid 213 2011-09-16 03:46:29 7 #> 8 4.44… 9 foru… pid 227 2011-09-16 07:07:43 16 #> 9 5.43… 13 foru… pid 293 2011-09-16 22:35:02 14 #> 10 5.92… 9 foru… pid 345 2011-09-17 13:06:42 1 #> # … with 272,119 more rows, and 3 more variables: rep_class <chr>, #> # item_id <int>, class_type_id_hash <chr> #> #> $core_reputation_leaderboard_history #> # A tibble: 8,912 x 4 #> leader_date leader_member_id leader_position leader_rep_total #> <int> <int> <int> <int> #> 1 1316001597 0 4 0 #> 2 1316001598 0 3 0 #> 3 1316001600 9 2 1 #> 4 1316001600 13 1 1 #> 5 1316087997 0 4 0 #> 6 1316087998 0 3 0 #> 7 1316088000 3 1 1 #> 8 1316088000 9 2 1 #> 9 1316174397 0 4 0 #> 10 1316174400 7 1 1 #> # … with 8,902 more rows #> #> $core_reputation_levels #> # A tibble: 16 x 2 #> level_id level_points #> <int> <int> #> 1 18 6000000 #> 2 17 40001 #> 3 3 0 #> 4 4 100 #> 5 5 500 #> 6 6 1000 #> 7 7 1488 #> 8 8 1489 #> 9 9 1490 #> 10 10 2000 #> 11 11 3000 #> 12 12 9001 #> 13 13 10000 #> 14 14 40000 #> 15 15 6000001 #> 16 16 50 #> #> $core_search_index #> # A tibble: 196,042 x 17 #> index_class index_id index_object_id index_item_id index_container… #> <chr> <int64> <int> <int> <int> #> 1 "IPS\\core… 4.94065… 3053 3053 9446 #> 2 "IPS\\core… 9.88131… 3051 3051 9622 #> 3 "IPS\\core… 1.48219… 3050 3050 14382 #> 4 "IPS\\core… 1.97626… 3049 3049 9872 #> 5 "IPS\\core… 2.47032… 3048 3048 14568 #> 6 "IPS\\core… 2.96439… 3047 3047 14568 #> 7 "IPS\\core… 3.45846… 3045 3045 7 #> 8 "IPS\\core… 3.95252… 3044 3044 8232 #> 9 "IPS\\core… 4.44659… 3043 3043 7986 #> 10 "IPS\\core… 4.94065… 3042 3042 14450 #> # … with 196,032 more rows, and 12 more variables: index_content <chr>, #> # index_permissions <chr>, index_author <int>, index_title <chr>, #> # index_date_created <dttm>, index_date_updated <dttm>, index_hidden <int>, #> # index_item_index_id <int64>, index_item_author <int>, #> # index_is_last_comment <lgl>, index_class_type_id_hash <chr>, #> # index_container_class <chr> #> #> $core_search_index_item_map #> # A tibble: 80,727 x 3 #> index_author_id index_item_id index_class #> <int> <int> <chr> #> 1 1 1 "IPS\\calendar\\Event" #> 2 13661 1 "IPS\\calendar\\Event" #> 3 1 2 "IPS\\calendar\\Event" #> 4 14 2 "IPS\\core\\Statuses\\Status" #> 5 1 3 "IPS\\calendar\\Event" #> 6 0 3 "IPS\\forums\\Topic" #> 7 1 3 "IPS\\forums\\Topic" #> 8 2 3 "IPS\\forums\\Topic" #> 9 3 3 "IPS\\forums\\Topic" #> 10 4 3 "IPS\\forums\\Topic" #> # … with 80,717 more rows #> #> $core_search_index_tags #> # A tibble: 5,057 x 3 #> index_id index_tag index_is_prefix #> <int64> <chr> <lgl> #> 1 3.937703e-321 james mason FALSE #> 2 3.937703e-321 siege FALSE #> 3 3.937703e-321 siegeculture FALSE #> 4 4.693624e-321 newcomer TRUE #> 5 5.291443e-321 last FALSE #> 6 5.291443e-321 will FALSE #> 7 5.291443e-321 russian FALSE #> 8 5.291443e-321 fascist FALSE #> 9 5.291443e-321 konstantin rodzaevsky FALSE #> 10 5.291443e-321 konstantin FALSE #> # … with 5,047 more rows #> #> $core_sessions #> # A tibble: 522 x 21 #> id member_name seo_name member_id ip_address browser running_time #> <chr> <chr> <chr> <int> <chr> <chr> <int> #> 1 0 NA NA NA NA NA NA #> 2 31hi… NA NA NA 162.158.7… Mozill… 1511236789 #> 3 97b1… NA NA NA 108.162.2… Mozill… 1511237308 #> 4 lkec… NA NA NA 162.158.7… Mozill… 1511236955 #> 5 mfpd… NA NA NA 162.158.1… Mozill… 1511236584 #> 6 sga7… NA NA NA 108.162.2… Mozill… 1511235889 #> 7 261f… NA NA NA 108.162.2… Mozill… 1511236691 #> 8 6ad8… NA NA NA 108.162.2… Mozill… 1511237780 #> 9 oiba… NA NA NA 108.162.2… Mozill… 1511237452 #> 10 gpbb… NA NA NA 108.162.2… Mozill… 1511237664 #> # … with 512 more rows, and 14 more variables: login_type <int>, #> # member_group <int>, current_appcomponent <chr>, current_module <chr>, #> # uagent_key <chr>, uagent_version <chr>, uagent_type <chr>, #> # current_controller <chr>, location_url <chr>, location_lang <chr>, #> # location_data <chr>, location_permissions <chr>, current_id <int>, #> # data <list> #> #> $core_share_links #> # A tibble: 10 x 5 #> share_id share_title share_key share_enabled share_position #> <int> <chr> <chr> <lgl> <int> #> 1 1 Twitter twitter TRUE 1 #> 2 2 Facebook facebook TRUE 2 #> 3 3 Google Plus One googleplusone TRUE 3 #> 4 4 Digg digg TRUE 4 #> 5 5 Del.icio.us delicious TRUE 5 #> 6 6 Reddit reddit TRUE 6 #> 7 7 StumbleUpon stumble TRUE 7 #> 8 8 Email email TRUE 8 #> 9 12 Linkedin linkedin FALSE 9 #> 10 13 Pinterest pinterest TRUE 12 #> #> $core_sitemap #> # A tibble: 22 x 4 #> data updated sitemap last_id #> <chr> <int> <chr> <int64> #> 1 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_cal… 0.00000… #> 2 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 1.288029… #> 3 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 9.095749… #> 4 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 6.057245… #> 5 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_cal… 1.437731… #> 6 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 3.152139… #> 7 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 0.00000… #> 8 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_cor… 1.487632… #> 9 "<?xml version=\"1.0\" encoding=\"U… 1.51e9 sitemap_content_for… 1.658578… #> 10 NA 1.51e9 sitemap_profiles_1 0.00000… #> # … with 12 more rows #> #> $core_social_promote_sharers #> # A tibble: 3 x 2 #> sharer_id sharer_key #> <int> <chr> #> 1 1 Facebook #> 2 2 Twitter #> 3 3 Internal #> #> $core_soft_delete_log #> # A tibble: 1,035 x 6 #> sdl_id sdl_obj_id sdl_obj_key sdl_obj_member_… sdl_obj_date #> <int> <int> <chr> <int> <dttm> #> 1 21 3202 topic 1 2014-06-30 02:31:55 #> 2 22 795 topic 1 2014-06-30 02:32:22 #> 3 25 3202 topic 1 2014-09-07 19:20:25 #> 4 27 4652 topic 132 2015-01-06 17:42:21 #> 5 33 5647 topic 1 2015-11-17 17:11:20 #> 6 959 3023 status_sta… 1 2017-02-18 04:56:01 #> 7 958 4991 topic 1 2016-12-06 10:18:27 #> 8 36 6281 topic 1 2016-04-07 22:48:09 #> 9 38 6483 topic 1 2016-05-18 19:13:13 #> 10 39 153418 post 1 2016-06-09 06:51:02 #> # … with 1,025 more rows, and 1 more variable: sdl_obj_reason <chr> #> #> $core_statistics #> # A tibble: 21,508 x 4 #> id value_1 value_4 time #> <int64> <int64> <chr> <int> #> 1 4.940656e-324 2.816174e-322 guests 1501782962 #> 2 9.881313e-324 9.881313e-324 members 1501782962 #> 3 1.482197e-323 3.903119e-322 guests 1501783809 #> 4 1.976263e-323 9.881313e-324 members 1501783809 #> 5 2.470328e-323 3.804305e-322 guests 1501784650 #> 6 2.964394e-323 9.881313e-324 members 1501784650 #> 7 3.458460e-323 4.545404e-322 guests 1501785500 #> 8 3.952525e-323 9.881313e-324 members 1501785500 #> 9 4.446591e-323 3.507866e-322 guests 1501786369 #> 10 4.940656e-323 9.881313e-324 members 1501786369 #> # … with 21,498 more rows #> #> $core_streams #> # A tibble: 17 x 14 #> id classes containers read follow position member date_type #> <int> <chr> <chr> <chr> <chr> <int> <int> <chr> #> 1 4.94… NA NA unre… all 1 NA all #> 2 9.88… NA NA all all 2 NA all #> 3 1.48… NA NA all follo… 3 NA all #> 4 1.97… NA NA all follo… 4 NA all #> 5 2.47… NA NA all all 5 NA all #> 6 2.96… "IPS\\… NA all all 1 9620 all #> 7 3.45… "IPS\\… NA all all 2 9620 all #> 8 4.44… "IPS\\… "{\"IPS\\… unre… all 2 9217 all #> 9 4.94… "IPS\\… NA unre… all 1 2170 relative #> 10 5.43… NA NA all all 1 6113 all #> 11 6.91… "IPS\\… NA unre… all 1 9510 all #> 12 6.42… "IPS\\… "{\"IPS\\… all all 4 9217 all #> 13 7.41… "IPS\\… NA unre… all 2 9510 all #> 14 7.90… "IPS\\… NA unre… all 1 9694 all #> 15 8.39… NA NA unre… all 1 53 all #> 16 8.89… NA NA all all 3 9510 relative #> 17 9.38… NA NA unre… all 2 9694 relative #> # … with 6 more variables: date_relative_days <int>, followed_types <chr>, #> # ownership <chr>, include_comments <lgl>, title <chr>, default <lgl> #> #> $core_sys_conf_settings #> # A tibble: 371 x 6 #> conf_id conf_key conf_value conf_default conf_keywords conf_app #> <int> <chr> <chr> <chr> <chr> <chr> #> 1 15 gl_title "Iron March Forum Ch… NA NA NA #> 2 16 gl_link NA NA NA NA #> 3 20 site_offli… "\n<p style=\"text-a… NA NA NA #> 4 533 file_log_p… "90" 90 NA core #> 5 534 google_map… NA NA NA core #> 6 21 use_coppa "0" 0 NA NA #> 7 22 coppa_fax NA NA NA NA #> 8 23 coppa_addr… NA NA NA NA #> 9 24 coppa_cons… NA NA NA NA #> 10 25 ipb_copy_n… NA NA NA NA #> # … with 361 more rows #> #> $core_sys_lang #> # A tibble: 2 x 5 #> lang_id lang_short lang_title lang_default lang_protected #> <int> <chr> <chr> <lgl> <lgl> #> 1 1 en_US English (USA) TRUE TRUE #> 2 4 ru_RU.UTF-8 Русский (RU) FALSE FALSE #> #> $core_sys_lang_words #> # A tibble: 26,118 x 11 #> word_id lang_id word_app word_key word_default word_custom word_default_ve… #> <int> <int> <chr> <chr> <chr> <chr> <chr> #> 1 38289 4 core core_em… Nazi Memeti… NA NA #> 2 2 1 core core_gr… Validating Validating NULL #> 3 3 1 core core_gr… Visitors Visitors NULL #> 4 4 1 core core_gr… Newcomer Newcomer NULL #> 5 5 1 core core_gr… The Adminsh… The Admins… NULL #> 6 6 1 core core_gr… Gassed Gassed NULL #> 7 7 1 core core_gr… Black Corps Black Corps NULL #> 8 8 1 core core_gr… Prisoner Prisoner NULL #> 9 9 1 core core_gr… Black Corps… Black Corp… NULL #> 10 10 1 core core_gr… Members Members NULL #> # … with 26,108 more rows, and 4 more variables: word_custom_version <chr>, #> # word_js <lgl>, word_export <lgl>, word_theme <int> #> #> $core_sys_login #> # A tibble: 4 x 2 #> sys_login_id sys_cookie #> <int> <chr> #> 1 2 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> 2 9 "a:1:{s:12:\"memberFilter\";a:19:{s:15:\"c_member_status\";s:3:\… #> 3 1 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> 4 7 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> #> $core_sys_settings_titles #> # A tibble: 37 x 8 #> conf_title_id conf_title_title conf_title_desc conf_title_count #> <int> <chr> <chr> <int> #> 1 1 Ad Code Integra… These settings… 13 #> 2 2 Community Guide… This section a… 7 #> 3 3 Community Offli… Use this setti… 2 #> 4 4 COPPA Set-up This section a… 4 #> 5 5 Copyright Remov… This section a… 2 #> 6 6 CPU Saving &… This section a… 22 #> 7 7 Date, Time and … This section c… 12 #> 8 8 Email Set-up This section w… 11 #> 9 9 General Configu… These settings… 16 #> 10 10 IP.Board Extern… NA 1 #> # … with 27 more rows, and 4 more variables: conf_title_noshow <lgl>, #> # conf_title_keyword <chr>, conf_title_app <chr>, conf_title_tab <chr> #> #> $core_tags #> # A tibble: 5,053 x 11 #> tag_id tag_aai_lookup tag_aap_lookup tag_meta_app tag_meta_area tag_meta_id #> <int6> <chr> <chr> <chr> <chr> <int> #> 1 4.940… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 2 9.881… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 3 1.482… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 4 1.976… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 5 2.470… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 6 2.964… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 7 3.458… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 8 3.952… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 9 4.446… 811c8c75196b3… 956ad2d293909… forums forums 111 #> 10 4.940… 811c8c75196b3… 956ad2d293909… forums forums 111 #> # … with 5,043 more rows, and 5 more variables: tag_meta_parent_id <int>, #> # tag_member_id <int>, tag_added <dttm>, tag_prefix <lgl>, tag_text <chr> #> #> $core_tags_cache #> # A tibble: 6,919 x 3 #> tag_cache_key tag_cache_text tag_cache_date #> <chr> <chr> <dttm> #> 1 811c8c75196b3ff83da… "{\"tags\":[\"father charles coughl… 2015-05-11 15:09:03 #> 2 8bda5c23a73f4a53e66… "{\"tags\":[\"political compass\"],… 2015-05-11 15:09:03 #> 3 c81c72e023eedaf1085… "{\"tags\":[\"actual idealism\",\"g… 2015-05-11 15:09:09 #> 4 1b15ddd5286635d6004… "{\"tags\":[],\"prefix\":\"\"}" 2015-05-11 15:09:16 #> 5 49f0aabee7caac9fd60… "{\"tags\":[\"Monarchy\",\"Britain\… 2015-05-11 15:09:09 #> 6 127c73f84b3ff08e0a8… "{\"tags\":[],\"prefix\":\"\"}" 2015-05-11 15:09:03 #> 7 ef9c553b27602531af9… "{\"tags\":[\"Introduction\"],\"pre… 2015-05-11 15:09:13 #> 8 43ac6adba8bf95da384… "{\"tags\":[\"Religion\"],\"prefix\… 2015-05-11 15:09:13 #> 9 462c5b3fb75a8e34d3f… "{\"tags\":[],\"prefix\":\"\"}" 2015-05-11 15:09:52 #> 10 a81354916f466c0b3f0… "{\"tags\":[\"Iron Will\",\"greetin… 2015-05-11 15:09:13 #> # … with 6,909 more rows #> #> $core_tags_perms #> # A tibble: 3,311 x 4 #> tag_perm_aai_lookup tag_perm_aap_lookup tag_perm_text tag_perm_visible #> <chr> <chr> <chr> <lgl> #> 1 811c8c75196b3ff83dad05… d63cdc08d52e02e1b82fc… 4,2,3,6,8,1 TRUE #> 2 8bda5c23a73f4a53e664b0… 85aa9178b923fa1878ad8… 4,2,3,6,1 TRUE #> 3 c81c72e023eedaf1085a9f… 51deea4867472642fba67… 4,2,3,6,1 TRUE #> 4 74188d2b121682dfe30279… e8b9aa1927d352c4af047… 4,2,3,6,1 TRUE #> 5 49f0aabee7caac9fd601bd… a8ec894f1cd7456aede97… 4,2,3,6,1 TRUE #> 6 ef9c553b27602531af9b1a… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 7 43ac6adba8bf95da384761… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 8 afd1964ed1a568511941a2… 1d7b8a34d35bb07bc2f38… 4,2,3,6,1 TRUE #> 9 a81354916f466c0b3f0cdf… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 10 a22a57b42eb6dd2fa966ce… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> # … with 3,301 more rows #> #> $core_tasks #> # A tibble: 26 x 7 #> id key frequency next_run enabled app last_run #> <int64> <chr> <chr> <int64> <list> <chr> <int64> #> 1 9.337841e-… profilesync P0Y0M0DT1H0… 7.466524e-… <raw [1… core 7.466506e-… #> 2 9.387247e-… updatecheck P0Y0M1DT0H0… 7.466771e-… <raw [1… core 7.466344e-… #> 3 9.436654e-… cleanup P0Y0M1DT0H0… 7.466780e-… <raw [1… core 7.466353e-… #> 4 9.486060e-… sitemapgener… P0Y0M0DT0H1… 7.466511e-… <raw [1… core 7.466506e-… #> 5 9.535467e-… connect P0Y0M0DT1H0… 7.431353e-… <raw [1… core 7.431335e-… #> 6 9.584874e-… queue P0Y0M0DT0H1… 7.463404e-… <raw [1… core 7.463404e-… #> 7 9.634280e-… pop P0Y0M0DT0H1… 7.431323e-… <raw [1… core 7.431320e-… #> 8 9.683687e-… digest P0Y0M0DT0H1… 7.466509e-… <raw [1… core 7.466506e-… #> 9 9.733093e-… publish P0Y0M0DT0H1… 7.466510e-… <raw [1… core 7.466507e-… #> 10 9.782500e-… clearcache P0Y0M0DT0H1… 7.466509e-… <raw [1… core 7.466506e-… #> # … with 16 more rows #> #> $core_tasks_log #> # A tibble: 3,085 x 2 #> log time #> <chr> <int> #> 1 "[\"sitemap_ping_already24\"]" 1509570324 #> 2 "[\"sitemap_ping_already24\"]" 1509569480 #> 3 "[\"sitemap_ping_already24\"]" 1509568634 #> 4 "[\"sitemap_ping_already24\"]" 1509567793 #> 5 "[\"sitemap_ping_already24\"]" 1509566949 #> 6 "[\"sitemap_ping_already24\"]" 1509566103 #> 7 "[\"sitemap_ping_already24\"]" 1509719105 #> 8 "[\"sitemap_ping_already24\"]" 1509718250 #> 9 "[\"sitemap_ping_already24\"]" 1509717407 #> 10 "[\"sitemap_ping_already24\"]" 1509716564 #> # … with 3,075 more rows #> #> $core_theme_content_history #> # A tibble: 98 x 10 #> content_id content_type content_app content_location content_path #> <int> <chr> <chr> <chr> <chr> #> 1 1 template core admin forms #> 2 2 template core admin support #> 3 3 template core front forms #> 4 4 template core front forms #> 5 5 template core front global #> 6 6 template core front global #> 7 7 template core front global #> 8 8 template core front global #> 9 9 template core front global #> 10 10 template core front global #> # … with 88 more rows, and 5 more variables: content_name <chr>, #> # content_data <chr>, content_content <chr>, content_long_version <int>, #> # content_date <int> #> #> $core_theme_css #> # A tibble: 146 x 12 #> css_id css_set_id css_updated css_location css_content css_added_to css_app #> <int> <int> <int> <chr> <chr> <int> <chr> #> 1 577 0 1504115595 global "#ipsLayou… 0 core #> 2 578 0 1504115595 global "/* Lightb… 0 core #> 3 673 0 1504115606 front "\n\n/*.ip… 0 forums #> 4 674 0 1504115610 front "/* BOTH *… 0 calend… #> 5 675 0 1504115610 front ".cCalenda… 0 calend… #> 6 676 0 1504115610 front ".ipsRichE… 0 calend… #> 7 677 0 1504115610 front ".cCalenda… 0 calend… #> 8 667 0 1504115595 admin "/*.cMenuM… 0 core #> 9 663 0 1504115595 admin "#acpPageH… 0 core #> 10 664 0 1504115595 admin "table.dif… 0 core #> # … with 136 more rows, and 5 more variables: css_path <chr>, css_name <chr>, #> # css_version <chr>, css_user_edited <int>, css_unique_key <chr> #> #> $core_theme_settings_fields #> # A tibble: 308 x 12 #> sc_id sc_set_id sc_key sc_type sc_content sc_updated sc_default sc_tab_key #> <int> <int> <chr> <chr> <chr> <int> <chr> <chr> #> 1 1 1 ajax_… YesNo "[{\"key\… 1458844927 1 custom #> 2 2 1 alter… Color "[{\"key\… 1458844927 #3e4148 buttoncol… #> 3 3 1 alter… Color "[]" 1458844927 #ffffff buttoncol… #> 4 4 1 area_… Color "[]" 1458844927 #e6e8eb frontendc… #> 5 5 1 area_… Color "[]" 1458844927 #353c41 frontendc… #> 6 6 1 area_… Color "[]" 1458844927 #f8f8f8 frontendc… #> 7 7 1 area_… Color "[]" 1458844927 #ffffff frontendc… #> 8 8 1 butto… Color "[]" 1458844927 #ffffff buttoncol… #> 9 9 1 enabl… YesNo "[{\"key\… 1458844927 0 custom #> 10 10 1 fluid… Number "[]" 1458844927 95 custom #> # … with 298 more rows, and 4 more variables: sc_show_in_vse <lgl>, #> # sc_title <chr>, sc_order <int>, sc_condition <chr> #> #> $core_theme_settings_values #> # A tibble: 370 x 2 #> sv_id sv_value #> <int> <chr> #> 1 1 1 #> 2 2 #3e4148 #> 3 3 #ffffff #> 4 4 #e6e8eb #> 5 5 #353c41 #> 6 6 #f8f8f8 #> 7 7 #ffffff #> 8 8 #ffffff #> 9 9 0 #> 10 10 95 #> # … with 360 more rows #> #> $core_theme_templates #> # A tibble: 814 x 14 #> template_id template_set_id template_group template_content template_name #> <int> <int> <chr> <chr> <chr> #> 1 3646 7 global "{{if !\\IPS\\C… reactionBlurb #> 2 3644 7 global "{{if \\IPS\\IP… reputation #> 3 3645 7 global "{{$allowRep = … reputationMi… #> 4 3641 0 widgets "<h3 class='ips… recentReviews #> 5 3642 0 widgets "<h3 class='ips… todaysBirthd… #> 6 3643 0 widgets "<h3 class='ips… upcomingEven… #> 7 3640 0 view "\n{{if $club =… view #> 8 3639 0 view "<!-- Don't use… rsvpControls #> 9 3634 0 view "{{$coverPhoto … eventStreamB… #> 10 3635 0 view "<div data-cont… reminder #> # … with 804 more rows, and 9 more variables: template_data <chr>, #> # template_updated <int>, template_removable <lgl>, template_added_to <int>, #> # template_user_edited <int>, template_app <chr>, template_version <chr>, #> # template_location <chr>, template_unique_key <chr> #> #> $core_themes #> # A tibble: 3 x 18 #> set_id set_name set_key set_parent_array set_child_array set_permissions #> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 Default default NA NA NA #> 2 5 NA NA [] [] NA #> 3 7 Carbon … NA [] [] 4 #> # … with 12 more variables: set_is_default <lgl>, set_author_name <chr>, #> # set_author_url <chr>, set_emo_dir <chr>, set_order <int>, #> # set_template_settings <chr>, set_logo_data <chr>, set_long_version <int>, #> # set_css_map <chr>, set_resource_map <chr>, set_is_acp_default <lgl>, #> # set_cache_key <chr> #> #> $core_upgrade_history #> # A tibble: 83 x 6 #> upgrade_id upgrade_version… upgrade_version… upgrade_date upgrade_mid #> <int> <int> <chr> <dttm> <lgl> #> 1 1 32005 3.2.2 NA FALSE #> 2 2 32005 3.2.2 NA FALSE #> 3 3 32005 3.2.2 NA FALSE #> 4 4 32006 3.2.3 2013-07-20 14:15:55 FALSE #> 5 5 33000 3.3.0 Alpha 1 2013-07-20 14:16:45 FALSE #> 6 6 33006 3.3.0 Alpha 2 2013-07-20 14:16:47 FALSE #> 7 7 33007 3.3.0 Beta 1 2013-07-20 14:16:50 FALSE #> 8 8 33008 3.3.0 Beta 2 2013-07-20 14:16:53 FALSE #> 9 9 33009 3.3.0 Beta 3 2013-07-20 14:16:57 FALSE #> 10 10 33010 3.3.0 Beta 4 2013-07-20 14:17:02 FALSE #> # … with 73 more rows, and 1 more variable: upgrade_app <chr> #> #> $core_validating #> # A tibble: 7 x 8 #> vid member_id entry_date new_reg email_chg ip_address prev_email #> <chr> <int> <dttm> <lgl> <lgl> <chr> <chr> #> 1 aa64… 14926 2017-09-20 02:21:44 FALSE TRUE 172.104.1… ggleenzzb… #> 2 1bc6… 15217 2017-11-20 21:41:40 TRUE FALSE 162.158.2… 0 #> 3 f099… 15218 2017-11-20 22:08:23 TRUE FALSE 108.162.2… 0 #> 4 dc22… 13881 2017-11-19 05:57:23 FALSE TRUE 108.162.2… fnzles@gm… #> 5 7c6d… 13780 2017-11-19 06:39:02 FALSE TRUE 162.158.7… patrick.w… #> 6 09e5… 9861 2017-11-03 11:18:11 FALSE TRUE 162.158.2… svartskjo… #> 7 cfb4… 15012 2017-11-10 14:45:01 FALSE TRUE 162.158.1… 0 #> # … with 1 more variable: email_sent <int> #> #> $core_view_updates #> # A tibble: 30 x 1 #> id #> <int64> #> 1 1.679823e-322 #> 2 7.015732e-322 #> 3 2.055313e-321 #> 4 2.055313e-321 #> 5 2.055313e-321 #> 6 2.529616e-321 #> 7 3.152139e-321 #> 8 3.670908e-321 #> 9 4.945597e-321 #> 10 5.355672e-321 #> # … with 20 more rows #> #> $core_voters #> # A tibble: 1,729 x 8 #> vid ip_address vote_date tid member_id forum_id member_choices poll #> <int> <chr> <int> <int> <int> <int> <chr> <int> #> 1 1 77.249.103.2… 1323790101 370 13 88 "{\"1\":[\"2\"… 1 #> 2 2 86.21.53.46 1323790499 370 4 88 "{\"1\":[\"1\"… 1 #> 3 3 108.13.155.97 1323791995 370 29 88 "{\"1\":[\"1\"… 1 #> 4 4 86.7.229.239 1323800768 370 0 88 "{\"1\":[\"1\"… 1 #> 5 5 31.220.211.18 1323801140 370 7 88 "{\"1\":[\"1\"… 1 #> 6 6 152.33.21.65 1323805321 370 16 88 "{\"1\":[\"1\"… 1 #> 7 7 192.101.250.… 1323822724 370 68 88 "{\"1\":[\"1\"… 1 #> 8 8 71.185.163.2… 1323843605 370 49 88 "{\"1\":[\"1\"… 1 #> 9 9 131.181.251.… 1323871708 370 65 88 "{\"1\":[\"2\"… 1 #> 10 27 201.236.119.… 1324958167 370 44 88 "{\"1\":[\"1\"… 1 #> # … with 1,719 more rows #> #> $core_widget_areas #> # A tibble: 7 x 6 #> id widgets app module controller area #> <int64> <chr> <chr> <chr> <chr> <chr> #> 1 4.940656… "[]" core system register head… #> 2 9.881313… "[]" core system register foot… #> 3 4.891250… "[{\"app\":\"core\",\"key\":\"whosOnl… foru… forums index foot… #> 4 4.990063… "[{\"app\":\"calendar\",\"key\":\"upc… foru… forums index side… #> 5 4.841843… "[{\"app\":\"core\",\"key\":\"announc… foru… forums index head… #> 6 4.347778… "[{\"app\":\"core\",\"key\":\"activeU… foru… forums topic foot… #> 7 4.397184… "[{\"app\":\"core\",\"key\":\"activeU… foru… forums forums foot… #> #> $core_widgets #> # A tibble: 19 x 9 #> id key app class caches restrict default_area allow_reuse menu_style #> <int6> <chr> <chr> <chr> <chr> <chr> <chr> <lgl> <chr> #> 1 4.940… acti… core "\\I… NA "[]" NA FALSE menu #> 2 9.881… anno… core "\\I… NA "[\"sid… header FALSE menu #> 3 1.482… stats core "\\I… "{\"wi… "[]" NA FALSE menu #> 4 1.976… rela… core "\\I… NA "[]" NA FALSE menu #> 5 2.470… rece… core "\\I… NA "[]" NA FALSE menu #> 6 2.964… topC… core "\\I… NA "[]" NA FALSE menu #> 7 3.458… whos… core "\\I… NA "[]" NA FALSE menu #> 8 3.952… memb… core "\\I… "{\"wi… "[\"sid… NA TRUE modal #> 9 4.446… foru… foru… "\\I… "{\"wi… "[]" NA FALSE menu #> 10 4.940… hotT… foru… "\\I… NA "[]" NA FALSE menu #> 11 5.434… topi… foru… "\\I… "{\"wi… "[]" NA TRUE modal #> 12 5.928… post… foru… "\\I… NA "[]" NA TRUE modal #> 13 6.422… poll foru… "\\I… NA "[\"sid… NA TRUE modal #> 14 6.916… toda… cale… "\\I… NA "[]" NA FALSE menu #> 15 7.410… upco… cale… "\\I… "{\"wi… "[]" NA FALSE menu #> 16 7.905… rece… cale… "\\I… NA "[]" NA FALSE menu #> 17 8.399… gues… core "\\I… NA "[\"sid… NA FALSE modal #> 18 8.893… prom… core "\\I… NA "[\"sid… NA FALSE menu #> 19 9.387… clubs core "\\I… NA "[\"sid… NA TRUE modal #>im_orig_dfs#> $orig_admin_login_logs #> # A tibble: 45 x 6 #> admin_id admin_ip_address admin_username admin_time admin_success #> <int> <chr> <chr> <dttm> <lgl> #> 1 5447 5.228.77.158 Alexander Sla… 2016-03-01 06:09:38 TRUE #> 2 5446 5.228.77.158 Alexander Sla… 2016-02-29 22:17:57 TRUE #> 3 5445 5.228.77.158 Alexander Sla… 2016-02-29 21:33:12 TRUE #> 4 5444 5.228.77.158 Alexander Sla… 2016-02-29 20:57:19 TRUE #> 5 5443 5.228.77.158 Alexander Sla… 2016-02-27 22:36:39 TRUE #> 6 5420 5.228.77.158 Alexander Sla… 2016-01-28 16:04:07 TRUE #> 7 5421 5.228.77.158 Alexander Sla… 2016-01-29 06:22:19 TRUE #> 8 5422 5.228.77.158 Alexander Sla… 2016-02-01 17:35:57 TRUE #> 9 5423 5.228.77.158 Alexander Sla… 2016-02-01 20:23:29 TRUE #> 10 5424 5.228.77.158 Alexander Sla… 2016-02-01 22:26:30 TRUE #> # … with 35 more rows, and 1 more variable: admin_post_details <chr> #> #> $orig_admin_logs #> # A tibble: 7,836 x 9 #> id member_id ctime note ip_address appcomponent module #> <int> <int> <dttm> <chr> <chr> <chr> <chr> #> 1 4.94… 1 2011-09-12 16:05:48 Cate… 178.140.1… forums forums #> 2 9.88… 1 2011-09-12 16:07:59 Foru… 178.140.1… forums forums #> 3 1.48… 1 2011-09-12 16:08:15 Foru… 178.140.1… forums forums #> 4 1.97… 1 2011-09-12 16:11:38 Foru… 178.140.1… forums forums #> 5 2.47… 1 2011-09-12 16:15:13 Edit… 178.140.1… members groups #> 6 2.96… 1 2011-09-12 16:15:53 Edit… 178.140.1… members groups #> 7 3.45… 1 2011-09-12 16:16:06 Edit… 178.140.1… members groups #> 8 3.95… 1 2011-09-12 16:16:28 Edit… 178.140.1… members groups #> 9 4.44… 1 2011-09-12 16:20:31 Adde… 178.140.1… members groups #> 10 4.94… 1 2011-09-12 17:54:03 Foru… 178.140.1… forums forums #> # … with 7,826 more rows, and 2 more variables: section <chr>, do <chr> #> #> $orig_attachments #> # A tibble: 101 x 15 #> attach_id attach_ext attach_file attach_location attach_thumb_lo… #> <int> <chr> <chr> <chr> <chr> #> 1 338 jpg 461022_456… monthly_03_201… monthly_03_2013… #> 2 2 jpg 1056.jpg monthly_09_201… monthly_09_2011… #> 3 3 jpg 1057.jpg monthly_09_201… monthly_09_2011… #> 4 4 jpg 1091.jpg monthly_09_201… monthly_09_2011… #> 5 5 jpg 1108.jpg monthly_09_201… monthly_09_2011… #> 6 6 jpg FASCIST UN… monthly_09_201… monthly_09_2011… #> 7 7 jpg post-2711-… monthly_09_201… monthly_09_2011… #> 8 8 jpg post-2842-… monthly_09_201… monthly_09_2011… #> 9 9 jpg 1029.jpg monthly_09_201… monthly_09_2011… #> 10 10 jpg 1030.jpg monthly_09_201… monthly_09_2011… #> # … with 91 more rows, and 10 more variables: attach_is_image <lgl>, #> # attach_hits <int>, attach_date <dttm>, attach_post_key <chr>, #> # attach_member_id <int>, attach_filesize <int>, attach_rel_id <int>, #> # attach_img_width <int>, attach_img_height <int>, attach_parent_id <int> #> #> $orig_attachments_type #> # A tibble: 31 x 5 #> atype_id atype_extension atype_mimetype atype_post atype_img #> <int> <chr> <chr> <lgl> <chr> #> 1 1 aiff audio/x-aiff TRUE style_extra/mime_typ… #> 2 2 bmp image/x-MS-bmp TRUE style_extra/mime_typ… #> 3 3 css unknown/unknown TRUE style_extra/mime_typ… #> 4 4 doc application/msword TRUE style_extra/mime_typ… #> 5 5 gif image/gif TRUE style_extra/mime_typ… #> 6 6 gz application/x-gzip TRUE style_extra/mime_typ… #> 7 7 hqx application/mac-bi… TRUE style_extra/mime_typ… #> 8 8 htm unknown/unknown TRUE style_extra/mime_typ… #> 9 9 html unknown/unknown TRUE style_extra/mime_typ… #> 10 10 ico image/ico TRUE style_extra/mime_typ… #> # … with 21 more rows #> #> $orig_banfilters #> # A tibble: 52 x 5 #> ban_id ban_type ban_content ban_date ban_reason #> <int> <chr> <chr> <dttm> <chr> #> 1 1 ip 62.97.238.198 2011-09-18 13:48:53 Tribbles #> 2 2 ip 80.202.110.65 2011-09-18 13:49:39 Also Tribbles #> 3 3 email jacksonhaddress@hotma… 2011-10-06 16:15:37 NA #> 4 4 ip 65.19.38.199 2011-10-06 16:15:37 NA #> 5 5 ip 75.173.64.190 2011-10-06 16:15:37 NA #> 6 6 email a6428490@nepwk.com 2011-10-07 15:03:48 NA #> 7 7 name JackW2 2011-10-07 15:03:48 NA #> 8 8 ip 173.236.27.154 2011-10-07 15:03:48 NA #> 9 9 ip 80.82.69.119 2011-10-07 15:03:48 NA #> 10 10 ip 115.249.239.138 2011-12-19 10:52:08 Spammer - commerc… #> # … with 42 more rows #> #> $orig_bbcode_mediatag #> # A tibble: 9 x 4 #> mediatag_id mediatag_name mediatag_match mediatag_replace #> <int> <chr> <chr> <chr> #> 1 1 YouTube "http(?:s)?://(www.)?yo… "<iframe id=\"ytplayer\" … #> 2 9 GameTrailers "http://www.gametrailer… "<embed src=\"http://medi… #> 3 2 Flash Movie/G… "{1}.swf" "<embed src=\"$1.swf\" pl… #> 4 3 Google Video "http://video.google.co… "<embed style=\"width:400… #> 5 4 MySpace Video "http://www.myspace.com… "<object width=\"425px\" … #> 6 10 YouTu.be "http://(www.)?youtu.be… "<iframe id=\"ytplayer\" … #> 7 6 Flickr Image … "http://www.flickr.com/… "<iframe align=\"center\"… #> 8 7 MP3 "{1}.mp3" "<object type=\"applicati… #> 9 8 Vimeo "http{1}://vimeo.com/{2… "<iframe src=\"http$1://p… #> #> $orig_cache_store #> # A tibble: 49 x 4 #> cs_key cs_value cs_array cs_updated #> <chr> <chr> <lgl> <int> #> 1 bbcode "a:34:{s:7:\"acronym\";a:21:{s:9:\"bbcode_id\"… TRUE 1414352133 #> 2 moderato… "a:0:{}" TRUE 1458514682 #> 3 multimod "a:0:{}" TRUE 1414352127 #> 4 banfilte… "a:35:{i:0;s:13:\"62.97.238.198\";i:1;s:13:\"8… TRUE 1456812672 #> 5 attachty… "a:30:{s:4:\"aiff\";a:4:{s:15:\"atype_extensio… TRUE 1414352127 #> 6 emoticons "a:98:{i:0;a:4:{s:5:\"typed\";s:2:\":)\";s:5:\… TRUE 1455876496 #> 7 badwords "a:0:{}" TRUE 1414352133 #> 8 systemva… "a:5:{s:10:\"mail_queue\";i:0;s:13:\"task_next… TRUE 1458844081 #> 9 adminnot… "You can use this section to keep notes for al… FALSE 1315842847 #> 10 ranks "a:0:{}" TRUE 1414352133 #> # … with 39 more rows #> #> $orig_cal_event_ratings #> # A tibble: 7 x 5 #> rating_id rating_eid rating_member_id rating_value rating_ip_address #> <int> <int> <int> <int> <chr> #> 1 1 14 7508 5 80.212.44.94 #> 2 2 27 9288 5 87.116.152.228 #> 3 3 4 3 5 68.10.238.177 #> 4 4 35 9240 5 193.153.191.93 #> 5 5 79 1558 1 83.233.71.27 #> 6 6 80 9510 5 86.15.81.183 #> 7 7 82 1558 1 83.233.71.27 #> #> $orig_cal_events #> # A tibble: 108 x 17 #> event_id event_member_id event_content event_title event_smilies event_perms #> <int> <int> <chr> <chr> <lgl> <chr> #> 1 1 1 "[url=\"http… Joseph Goe… FALSE 6,10,5,13,… #> 2 2 1 "[url=\"http… Niccolò M… FALSE * #> 3 3 1 "[url=\"http… Oswald Spe… FALSE * #> 4 4 1 "[url=\"http… Oswald Spe… FALSE * #> 5 5 1 "[url=\"http… Julius Evo… FALSE * #> 6 6 1 "Niccolò Ma… Niccolò M… FALSE * #> 7 7 1 "[url=\"http… Summer Sol… FALSE * #> 8 8 1 "[url=\"http… Martin Bor… TRUE * #> 9 9 1 "[url=\"http… Fidél Pá… FALSE * #> 10 10 1 "[url=\"http… Baldur von… FALSE * #> # … with 98 more rows, and 11 more variables: event_saved <dttm>, #> # event_lastupdated <dttm>, event_recurring <int>, event_start_date <dttm>, #> # event_end_date <dttm>, event_title_seo <chr>, event_rating_total <int>, #> # event_rating_hits <lgl>, event_rating_avg <int>, event_post_key <chr>, #> # event_sequence <lgl> #> #> $orig_content_cache_posts #> # A tibble: 39,103 x 3 #> cache_content_id cache_content cache_updated #> <int> <chr> <dttm> #> 1 25733 "<blockquote class='ipsBlockquote' data… 2016-03-18 03:51:34 #> 2 25732 "<blockquote class='ipsBlockquote' data… 2016-03-18 03:51:34 #> 3 25730 "<blockquote class='ipsBlockquote' data… 2016-03-18 03:51:34 #> 4 147440 "<div><iframe id=\"ytplayer\" class=\"E… 2016-03-20 17:34:03 #> 5 147691 "<p><a href='http://www.breitbart.com/2… 2016-03-17 15:32:16 #> 6 141523 "<p>Where can I find the adult swim pil… 2016-03-17 19:20:35 #> 7 141525 "<blockquote class=\"ipsBlockquote\" d… 2016-03-17 19:20:35 #> 8 96938 "<p>Remove the term class entirely. It'… 2016-03-17 03:59:43 #> 9 96951 "Volksgemeinschaft - <a href='http://ir… 2016-03-17 03:59:43 #> 10 96956 "<blockquote class=\"ipsBlockquote\" d… 2016-03-17 03:59:43 #> # … with 39,093 more rows #> #> $orig_content_cache_sigs #> # A tibble: 280 x 3 #> cache_content_id cache_content cache_updated #> <int> <chr> <dttm> #> 1 805 "<p><span>“Neither let us be slandere… 2015-11-15 19:30:28 #> 2 364 "<p>\"Either write something worth read… 2015-11-15 19:30:28 #> 3 287 "<p><em>Speak softly, and carry a big s… 2016-03-19 06:43:48 #> 4 16 "<span rel='lightbox'><img class='bbc_i… 2016-03-15 22:35:44 #> 5 8 ""We want less liberal verbiage an… 2015-11-23 17:14:25 #> 6 161 "<p class='bbc_center'><em class='bbc'>… 2016-02-25 18:03:49 #> 7 6120 "<p><span rel='lightbox'><img class='bb… 2015-10-12 23:36:32 #> 8 255 "<strong class='bbc'>\t"Bereiten S… 2016-02-07 05:56:41 #> 9 130 "<p><span style=\"font-size:10px;\">\"F… 2016-02-25 18:03:49 #> 10 7760 "<p><span style=\"font-size:10px;\"><sp… 2016-03-19 06:43:48 #> # … with 270 more rows #> #> $orig_core_applications #> # A tibble: 4 x 14 #> app_id app_title app_public_title app_description app_author app_version #> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 System Help Files Manage global … Invision … 3.4.7 #> 2 2 Members Members Manage members… Invision … 3.4.7 #> 3 3 Forums Forums Manage forums … Invision … 3.4.7 #> 4 4 Fascist … Fascist Calendar NA NA NA #> # … with 8 more variables: app_long_version <int>, app_directory <chr>, #> # app_added <dttm>, app_position <int>, app_protected <lgl>, #> # app_location <chr>, app_website <chr>, app_update_check <chr> #> #> $orig_core_hooks #> # A tibble: 8 x 15 #> hook_id hook_enabled hook_name hook_desc hook_author hook_email hook_website #> <int> <lgl> <chr> <chr> <chr> <chr> <chr> #> 1 1 TRUE Ad Code … Displays… Invision P… NA http://www.… #> 2 2 FALSE Status U… Displays… Invision P… NA http://www.… #> 3 3 TRUE Recent T… Adds a l… Invision P… NA www.invisio… #> 4 4 FALSE Facebook… Displays… Invision P… NA http://www.… #> 5 5 FALSE Tags Sid… Adds a l… Invision P… NA NA #> 6 9 FALSE Calendar Displays… Invision P… NA http://www.… #> 7 10 TRUE Upcoming… Shows up… Invision P… support@i… http://invi… #> 8 11 TRUE Upcoming… Shows up… Invision P… support@i… http://invi… #> # … with 8 more variables: hook_requirements <chr>, hook_version_human <chr>, #> # hook_version_long <chr>, hook_installed <dttm>, hook_updated <dttm>, #> # hook_position <int>, hook_extra_data <chr>, hook_key <chr> #> #> $orig_core_hooks_files #> # A tibble: 8 x 7 #> hook_file_id hook_hook_id hook_file_stored hook_file_real hook_classname #> <int> <int> <chr> <chr> <chr> #> 1 39 1 boardIndexSideB… boardIndexSid… boardIndexSid… #> 2 43 2 boardIndexStatu… boardIndexSta… boardIndexSta… #> 3 40 3 boardIndexRecen… boardIndexRec… boardIndexRec… #> 4 41 4 boardIndexFaceb… boardIndexFac… boardIndexFac… #> 5 42 5 boardIndexTags_… boardIndexTag… boardIndexTags #> 6 44 9 boardIndexCalen… boardIndexCal… boardIndexCal… #> 7 45 10 calendarUpcomin… calendarUpcom… calendarUpcom… #> 8 46 11 calendarUpcomin… calendarUpcom… calendarUpcom… #> # … with 2 more variables: hook_data <chr>, hooks_source <chr> #> #> $orig_core_item_markers #> # A tibble: 4,622 x 9 #> item_key item_member_id item_app item_last_update item_last_saved #> <chr> <int> <chr> <int> <dttm> #> 1 f802c0c… 1 forums 1458516124 2016-03-20 23:22:04 #> 2 66931e5… 1 forums 1458550878 2016-03-21 09:01:18 #> 3 1d45d85… 1 forums 1458550876 2016-03-21 09:01:16 #> 4 9b51b6f… 9555 forums 1458397436 2016-03-19 14:23:56 #> 5 427cd62… 7543 forums 1456516956 2016-02-26 20:02:36 #> 6 66931e5… 4 forums 1458142789 2016-03-16 15:39:49 #> 7 e1aac5f… 1 forums 1458550828 2016-03-21 09:00:28 #> 8 068d4d2… 7424 forums 1458544359 2016-03-21 07:12:39 #> 9 068d4d2… 1558 forums 1458547314 2016-03-21 08:01:54 #> 10 f802c0c… 25 forums 1458435302 2016-03-20 00:55:02 #> # … with 4,612 more rows, and 4 more variables: item_unread_count <int>, #> # item_read_array <chr>, item_global_reset <int>, item_app_key_1 <int> #> #> $orig_core_item_markers_storage #> # A tibble: 16 x 3 #> item_member_id item_markers item_last_saved #> <int> <chr> <dttm> #> 1 2 "a:2:{s:4:\"core\";a:1:{s:32:\"d86530f90f… 2013-07-20 12:30:09 #> 2 6134 "a:1:{s:6:\"forums\";a:25:{s:32:\"e579e6f… 2013-07-20 12:37:56 #> 3 1 "a:2:{s:4:\"core\";a:1:{s:32:\"d86530f90f… 2013-07-20 13:42:10 #> 4 6171 "a:1:{s:6:\"forums\";a:62:{s:32:\"2d63352… 2013-07-20 13:57:47 #> 5 53 "a:1:{s:6:\"forums\";a:40:{s:32:\"66931e5… 2013-07-20 12:52:07 #> 6 100 "a:1:{s:6:\"forums\";a:53:{s:32:\"19c7cdf… 2013-07-20 12:53:50 #> 7 333 "a:1:{s:6:\"forums\";a:62:{s:32:\"063bc0b… 2013-07-20 13:46:10 #> 8 158 "a:1:{s:6:\"forums\";a:64:{s:32:\"e579e6f… 2013-07-20 13:52:03 #> 9 6173 "a:1:{s:6:\"forums\";a:2:{s:32:\"a0a92a50… 2013-07-20 13:26:20 #> 10 1558 "a:1:{s:6:\"forums\";a:52:{s:32:\"a27da7d… 2013-07-20 13:29:02 #> 11 326 "a:1:{s:6:\"forums\";a:64:{s:32:\"e179fb6… 2013-07-20 13:56:21 #> 12 67 "a:1:{s:6:\"forums\";a:64:{s:32:\"02334ce… 2013-07-20 13:59:35 #> 13 16 "a:2:{s:4:\"core\";a:1:{s:32:\"d86530f90f… 2013-07-20 12:29:24 #> 14 2306 "a:1:{s:6:\"forums\";a:68:{s:32:\"e579e6f… 2013-07-20 13:05:14 #> 15 6122 "a:1:{s:6:\"forums\";a:36:{s:32:\"a27da7d… 2013-07-20 13:20:49 #> 16 861 "a:1:{s:6:\"forums\";a:56:{s:32:\"14e846e… 2013-07-20 13:30:53 #> #> $orig_core_like #> # A tibble: 3,706 x 14 #> like_id like_lookup_id like_lookup_area like_app like_area like_rel_id #> <chr> <chr> <chr> <chr> <chr> <int64> #> 1 566ef5… 3caa34857a82b… 5bfcef749155abe… forums topics 1.778636e-… #> 2 b1d0c5… 62cff97fc731b… 5bfcef749155abe… forums topics 3.063207e-… #> 3 20be4f… 931c090caa276… 5bfcef749155abe… forums topics 2.322109e-… #> 4 1434a9… 6f4697434da82… 5bfcef749155abe… forums topics 2.173889e-… #> 5 d44c69… 3c56c2b66d924… 5bfcef749155abe… forums topics 3.211427e-… #> 6 419626… 69ba2d75c9f6b… 5bfcef749155abe… forums topics 3.656086e-… #> 7 ac34f2… f7bc87f248ac8… 5bfcef749155abe… forums topics 3.705492e-… #> 8 4ae380… 7c140e71cf209… 5bfcef749155abe… forums topics 3.606679e-… #> 9 61f9d6… ff09767e2af56… 146d17a150010d5… forums topics 6.141236e-… #> 10 c67159… 5569f85f692c4… 5bfcef749155abe… forums topics 2.223295e-… #> # … with 3,696 more rows, and 8 more variables: like_member_id <int>, #> # like_is_anon <lgl>, like_added <int>, like_notify_do <lgl>, #> # like_notify_meta <chr>, like_notify_freq <chr>, like_notify_sent <int>, #> # like_visible <lgl> #> #> $orig_core_like_cache #> # A tibble: 5,304 x 6 #> like_cache_id like_cache_app like_cache_area like_cache_rel_… like_cache_data #> <chr> <chr> <chr> <int64> <chr> #> 1 321571a7b843… forums forums 1.482197e-322 "a:3:{s:7:\"me… #> 2 5b1fb15ebe04… forums topics 1.805810e-320 "a:3:{s:7:\"me… #> 3 4ed3d61094ba… forums topics 1.806798e-320 "a:3:{s:7:\"me… #> 4 b5067d6b91ca… forums topics 7.855644e-322 "a:3:{s:7:\"me… #> 5 81d82ffa5b6d… forums forums 6.422853e-323 "a:3:{s:7:\"me… #> 6 d9409ca5f0c5… forums topics 2.535051e-320 "a:3:{s:7:\"me… #> 7 296567d2dffd… forums topics 2.698587e-320 "a:3:{s:7:\"me… #> 8 6ee661dd69ab… forums topics 2.674871e-320 "a:3:{s:7:\"me… #> 9 98ca3d02b4a1… forums topics 2.603726e-320 "a:3:{s:7:\"me… #> 10 a7aac8b0f1a9… forums topics 1.482197e-323 "a:3:{s:7:\"me… #> # … with 5,294 more rows, and 1 more variable: like_cache_expire <int> #> #> $orig_core_share_links #> # A tibble: 10 x 5 #> share_id share_title share_key share_position share_canonical #> <int> <chr> <chr> <int> <lgl> #> 1 1 Twitter twitter 1 TRUE #> 2 2 Facebook facebook 2 TRUE #> 3 3 Google Plus One googleplusone 3 TRUE #> 4 4 Digg digg 4 TRUE #> 5 5 Del.icio.us delicious 6 TRUE #> 6 6 Reddit reddit 7 TRUE #> 7 7 StumbleUpon stumble 8 TRUE #> 8 8 Email email 9 TRUE #> 9 10 Print print 10 FALSE #> 10 11 Download download 11 FALSE #> #> $orig_core_share_links_log #> # A tibble: 83,860 x 7 #> log_id log_date log_member_id log_url log_title log_share_key #> <int> <dttm> <int> <chr> <chr> <chr> #> 1 1 2011-10-07 06:30:51 0 http:/… Women in… stumble #> 2 2 2011-10-10 15:30:45 0 http:/… Germany … stumble #> 3 3 2011-10-10 16:03:20 0 http:/… Germany … delicious #> 4 4 2011-10-10 16:17:08 0 http:/… Germany … email #> 5 5 2011-10-10 18:19:39 0 http:/… Germany … twitter #> 6 6 2011-10-10 18:45:46 0 http:/… Germany … print #> 7 7 2011-10-10 20:23:55 0 http:/… Germany … digg #> 8 8 2011-10-10 22:19:18 0 http:/… Germany … facebook #> 9 9 2011-10-11 00:42:53 0 http:/… Germany … reddit #> 10 10 2011-10-11 01:27:17 0 http:/… Germany … download #> # … with 83,850 more rows, and 1 more variable: log_ip_address <chr> #> #> $orig_core_soft_delete_log #> # A tibble: 7 x 5 #> sdl_id sdl_obj_id sdl_obj_member_id sdl_obj_date sdl_obj_reason #> <int> <int> <int> <dttm> <chr> #> 1 21 3202 1 2014-06-30 02:31:55 " Pending verificatio… #> 2 22 795 1 2014-06-30 02:32:22 " Pending verificatio… #> 3 25 3202 1 2014-09-07 19:20:25 NA #> 4 27 4652 132 2015-01-06 17:42:21 NA #> 5 33 5647 1 2015-11-17 17:11:20 NA #> 6 34 4991 1 2015-11-17 17:11:57 NA #> 7 35 4991 1 2015-11-17 19:08:55 NA #> #> $orig_core_sys_conf_settings #> # A tibble: 357 x 14 #> conf_id conf_title conf_description conf_group conf_type conf_key conf_value #> <int> <chr> <chr> <int> <chr> <chr> <chr> #> 1 1 Enable Ad… This setting wi… 1 yes_no ad_code… NA #> 2 2 Groups ex… Any groups that… 1 multi ad_code… NA #> 3 3 Header Co… This code will … 1 textarea ad_code… NA #> 4 4 Footer Co… This code will … 1 textarea ad_code… NA #> 5 5 Override … Using this sett… 1 textarea ad_code… NA #> 6 6 Override … Using this sett… 1 textarea ad_code… NA #> 7 7 Sidebar C… This code will … 1 textarea ad_code… NA #> 8 8 Override … Using this sett… 1 textarea ad_code… NA #> 9 9 Override … Using this sett… 1 textarea ad_code… NA #> 10 10 Code to d… This ad code wi… 1 textarea ad_code… NA #> # … with 347 more rows, and 7 more variables: conf_default <chr>, #> # conf_extra <chr>, conf_evalphp <chr>, conf_position <int>, #> # conf_start_group <chr>, conf_add_cache <lgl>, conf_keywords <chr> #> #> $orig_core_sys_lang_words #> # A tibble: 10,603 x 7 #> word_id word_app word_pack word_key word_default word_default_ve… word_js #> <int> <chr> <chr> <chr> <chr> <chr> <lgl> #> 1 1 core admin_ajax ls_groups "Groups Form" 32005 FALSE #> 2 2 core admin_ajax ls_view_m… "View more g… 32005 FALSE #> 3 3 core admin_ajax ls_groupt… "Groups" 32005 FALSE #> 4 4 core admin_ajax ls_view_m… "View more m… 32005 FALSE #> 5 5 core admin_ajax ls_members "Members" 32005 FALSE #> 6 6 core admin_ajax lsnoresul… "No results" 32005 FALSE #> 7 7 core admin_ajax livesearc… "ID: " 32005 FALSE #> 8 8 core admin_ajax ls_help "Help Files" 32005 FALSE #> 9 9 core admin_ajax ls_acppag… "ACP Pages" 32005 FALSE #> 10 10 core admin_ajax ls_settin… "Settings" 32005 FALSE #> # … with 10,593 more rows #> #> $orig_core_sys_login #> # A tibble: 4 x 2 #> sys_login_id sys_cookie #> <int> <chr> #> 1 2 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> 2 9 "a:1:{s:12:\"memberFilter\";a:19:{s:15:\"c_member_status\";s:3:\… #> 3 1 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> 4 7 "a:1:{s:12:\"memberFilter\";a:0:{}}" #> #> $orig_core_sys_module #> # A tibble: 41 x 9 #> sys_module_id sys_module_title sys_module_appl… sys_module_key #> <int> <chr> <chr> <chr> #> 1 1 Global core global #> 2 2 User CP core usercp #> 3 3 Task Manager core task #> 4 4 Attachments core attach #> 5 5 Logs core logs #> 6 6 Look & Feel core templates #> 7 7 My Control Panel core mycp #> 8 8 Diagnostics core diagnostics #> 9 9 System Settings core settings #> 10 10 Post Content core posts #> # … with 31 more rows, and 5 more variables: sys_module_description <chr>, #> # sys_module_version <chr>, sys_module_protected <lgl>, #> # sys_module_position <int>, sys_module_admin <lgl> #> #> $orig_core_sys_settings_titles #> # A tibble: 37 x 8 #> conf_title_id conf_title_title conf_title_desc conf_title_count #> <int> <chr> <chr> <int> #> 1 1 Ad Code Integra… These settings… 13 #> 2 2 Community Guide… This section a… 7 #> 3 3 Community Offli… Use this setti… 2 #> 4 4 COPPA Set-up This section a… 4 #> 5 5 Copyright Remov… This section a… 2 #> 6 6 CPU Saving &… This section a… 22 #> 7 7 Date, Time and … This section c… 12 #> 8 8 Email Set-up This section w… 11 #> 9 9 General Configu… These settings… 16 #> 10 10 IP.Board Extern… NA 1 #> # … with 27 more rows, and 4 more variables: conf_title_noshow <lgl>, #> # conf_title_keyword <chr>, conf_title_app <chr>, conf_title_tab <chr> #> #> $orig_core_tags #> # A tibble: 3,129 x 8 #> tag_id tag_aai_lookup tag_aap_lookup tag_meta_id tag_meta_parent… #> <int6> <chr> <chr> <int> <int> #> 1 4.940… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 2 9.881… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 3 1.482… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 4 1.976… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 5 2.470… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 6 2.964… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 7 3.458… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 8 3.952… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 9 4.446… 2cd36a5d4c630… 956ad2d293909… 111 75 #> 10 4.940… 2cd36a5d4c630… 956ad2d293909… 111 75 #> # … with 3,119 more rows, and 3 more variables: tag_member_id <int>, #> # tag_added <dttm>, tag_text <chr> #> #> $orig_core_tags_cache #> # A tibble: 4,499 x 3 #> tag_cache_key tag_cache_text tag_cache_date #> <chr> <chr> <dttm> #> 1 2cd36a5d4c630ce3802… "a:2:{s:4:\"tags\";a:10:{i:0;s:23:\… 2015-05-11 15:09:03 #> 2 4ce4adba46f760c9b88… "a:2:{s:4:\"tags\";a:1:{i:0;s:17:\"… 2015-05-11 15:09:03 #> 3 b3b80a1bea32e7e8a6c… "a:2:{s:4:\"tags\";a:4:{i:0;s:15:\"… 2015-05-11 15:09:09 #> 4 1b15ddd5286635d6004… "a:2:{s:4:\"tags\";a:0:{}s:6:\"pref… 2015-05-11 15:09:16 #> 5 efee20aa641a2fa3671… "a:2:{s:4:\"tags\";a:2:{i:0;s:8:\"M… 2015-05-11 15:09:09 #> 6 127c73f84b3ff08e0a8… "a:2:{s:4:\"tags\";a:0:{}s:6:\"pref… 2015-05-11 15:09:03 #> 7 43ca3f67301b77f135a… "a:2:{s:4:\"tags\";a:1:{i:0;s:12:\"… 2015-05-11 15:09:13 #> 8 d9eb242b0c991f1e1e7… "a:2:{s:4:\"tags\";a:1:{i:0;s:8:\"R… 2015-05-11 15:09:13 #> 9 462c5b3fb75a8e34d3f… "a:2:{s:4:\"tags\";a:0:{}s:6:\"pref… 2015-05-11 15:09:52 #> 10 679dbd12c814a0ed5e4… "a:2:{s:4:\"tags\";a:5:{i:0;s:9:\"I… 2015-05-11 15:09:13 #> # … with 4,489 more rows #> #> $orig_core_tags_perms #> # A tibble: 891 x 4 #> tag_perm_aai_lookup tag_perm_aap_lookup tag_perm_text tag_perm_visible #> <chr> <chr> <chr> <lgl> #> 1 2cd36a5d4c630ce3802cb8… d63cdc08d52e02e1b82fc… 4,2,3,6,8,1 TRUE #> 2 4ce4adba46f760c9b88d21… 85aa9178b923fa1878ad8… 4,2,3,6,1 TRUE #> 3 b3b80a1bea32e7e8a6cb28… 51deea4867472642fba67… 4,2,3,6,1 TRUE #> 4 74188d2b121682dfe30279… e8b9aa1927d352c4af047… 4,2,3,6,1 TRUE #> 5 efee20aa641a2fa36717fd… a8ec894f1cd7456aede97… 4,2,3,6,1 TRUE #> 6 43ca3f67301b77f135a3c7… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 7 d9eb242b0c991f1e1e7041… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 8 8aee0d7062abe55f54920a… 1d7b8a34d35bb07bc2f38… 4,2,3,6,1 TRUE #> 9 679dbd12c814a0ed5e4c74… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> 10 a9152cee70f17ba6f23da0… f723ce15197189561d1a0… 4,5,2,3,6,7,1 TRUE #> # … with 881 more rows #> #> $orig_core_uagents #> # A tibble: 59 x 8 #> uagent_id uagent_key uagent_name uagent_regex uagent_regex_ca… uagent_type #> <int> <chr> <chr> <chr> <int> <chr> #> 1 215 lotus Lotus Notes "Lotus[ \\-… 1 browser #> 2 214 firefox Firefox "Firefox/([… 1 browser #> 3 213 firebird Firebird "Firebird/(… 1 browser #> 4 212 curl Curl "curl[ /]([… 1 browser #> 5 15 msnbot MSN/Bing "msnbot[ /]… 1 search #> 6 211 chrome Chrome "Chrome/([0… 1 browser #> 7 210 chimera Chimera "chimera/([… 1 browser #> 8 209 camino Camino "camino/([0… 1 browser #> 9 208 aol AOL "aol[ /\\-]… 1 browser #> 10 207 amaya Amaya "amaya/([0-… 1 browser #> # … with 49 more rows, and 2 more variables: uagent_position <int>, #> # uagent_default_regex <chr> #> #> $orig_custom_bbcode #> # A tibble: 34 x 16 #> bbcode_id bbcode_title bbcode_desc bbcode_tag bbcode_replace bbcode_useoption #> <int> <chr> <chr> <chr> <chr> <lgl> #> 1 1 Post Snap B… This tag d… snapback NA FALSE #> 2 2 Right Aligns con… right "<p class='bb… FALSE #> 3 3 Left Aligns con… left "<p class='bb… FALSE #> 4 4 Center Aligns con… center "<p class='bb… FALSE #> 5 5 Topic Link This tag p… topic "<a href='{ba… TRUE #> 6 6 Post Link This tag p… post "<a href='{ba… TRUE #> 7 7 Spoiler Spoiler tag spoiler "<div class='… FALSE #> 8 8 Acronym Allows you… acronym "<acronym tit… TRUE #> 9 9 Bold Text Makes text… b "<strong clas… FALSE #> 10 10 Italic Text Makes the … i "<em class='b… FALSE #> # … with 24 more rows, and 10 more variables: bbcode_example <chr>, #> # bbcode_menu_option_text <chr>, bbcode_menu_content_text <chr>, #> # bbcode_single_tag <lgl>, bbcode_php_plugin <chr>, bbcode_no_parsing <lgl>, #> # bbcode_protected <lgl>, bbcode_aliases <chr>, bbcode_optional_option <lgl>, #> # bbcode_image <chr> #> #> $orig_dnames_change #> # A tibble: 500 x 7 #> dname_id dname_member_id dname_date dname_ip_address dname_previous #> <int> <int> <int> <chr> <chr> #> 1 1 16 1315978438 152.33.17.196 Talleyrand #> 2 2 16 1315979034 152.33.17.196 The Normish #> 3 3 8 1316033859 98.198.24.90 Mr. Elegy #> 4 4 17 1316047013 97.119.6.169 social_justice #> 5 55 164 1349431769 134.88.170.184 Yorick #> 6 6 11 1317754326 109.77.91.235 Four Suited J… #> 7 8 114 1327013527 79.67.83.218 Stork #> 8 9 114 1327173999 79.67.83.218 Alabama Crims… #> 9 10 160 1329977515 188.95.153.254 Cricket #> 10 11 140 1330461934 24.229.117.252 SchwarzFrontU… #> # … with 490 more rows, and 2 more variables: dname_current <chr>, #> # dname_discount <lgl> #> #> $orig_emoticons #> # A tibble: 98 x 6 #> id typed image clickable emo_set emo_position #> <int> <chr> <chr> <lgl> <chr> <int> #> 1 1 :) smile.png FALSE default 1 #> 2 2 ;) wink.png FALSE default 2 #> 3 3 :P tongue.png FALSE default 3 #> 4 4 :D biggrin.png FALSE default 4 #> 5 5 :lol: laugh.png FALSE default 5 #> 6 6 :( sad.png FALSE default 6 #> 7 7 :angry: angry.png FALSE default 7 #> 8 8 :mellow: mellow.png FALSE default 8 #> 9 9 :huh: huh.png FALSE default 9 #> 10 10 ^_^ happy.png FALSE default 10 #> # … with 88 more rows #> #> $orig_error_logs #> # A tibble: 61 x 7 #> log_id log_member log_date log_error log_error_code log_ip_address #> <int> <int> <dttm> <chr> <chr> <chr> #> 1 103794 0 2016-03-01 00:26:16 "You are… 1001 173.245.203.69 #> 2 103793 0 2016-03-01 00:26:10 "You are… 1001 173.245.203.69 #> 3 103792 0 2016-03-01 00:25:58 "You are… 1001 173.245.203.69 #> 4 103791 0 2016-03-01 00:25:54 "You are… 1001 173.245.203.69 #> 5 103790 0 2016-03-01 00:24:12 "You are… 1001 173.245.203.69 #> 6 103789 0 2016-03-01 00:24:08 "You are… 1001 173.245.203.69 #> 7 103788 0 2016-03-01 00:23:38 "You are… 1001 173.245.203.69 #> 8 103787 0 2016-03-01 00:23:06 "You are… 1001 173.245.203.69 #> 9 103786 0 2016-03-01 00:22:45 "You are… 1001 173.245.203.69 #> 10 103785 0 2016-03-01 00:21:05 "You are… 1001 173.245.203.69 #> # … with 51 more rows, and 1 more variable: log_request_uri <chr> #> #> $orig_faq #> # A tibble: 10 x 6 #> id title text description position app #> <int> <chr> <chr> <chr> <int> <chr> #> 1 1 Searching "The search feature … How to use the search f… 8 core #> 2 2 Your Set… "<p>\n\tYou can acce… Editing contact informa… 3 core #> 3 3 How to R… "To be able to enjoy… How to register and the… 1 core #> 4 4 Logging … "<strong>Loggi… How to log in and out f… 2 core #> 5 5 Contacti… "If you need to cont… Where to find a list of… 10 core #> 6 6 Personal… "The personal messen… How to send personal me… 6 memb… #> 7 7 Members "<strong>Membe… A guide to the member l… 7 memb… #> 8 8 Posting "<!-- isHtml:1 --><!… A guide to the features… 5 foru… #> 9 9 Topics a… "<p>\n\t<em><b>Viewi… A guide to forums, topi… 4 foru… #> 10 10 Calendar "The calendar can be… More information on the… 11 cale… #> #> $orig_forum_perms #> # A tibble: 8 x 2 #> perm_id perm_name #> <int> <chr> #> 1 1 Validating Forum Set #> 2 3 Member Forum Set #> 3 2 Guest Forum Set #> 4 4 Admin Forum Set #> 5 5 Banned Forum Set #> 6 6 Moderator Forum Set #> 7 7 Prisoner #> 8 12 Newcomer #> #> $orig_forums #> # A tibble: 132 x 36 #> id topics posts last_post last_poster_id last_poster_name name #> <int> <int> <int> <dttm> <int> <chr> <chr> #> 1 1 0 0 NA 0 NA Iron… #> 2 92 25 517 2016-02-07 18:26:19 9503 "HermannTheGerm… Acti… #> 3 2 14 307 2016-02-19 08:35:50 2820 "ZHICA" Admi… #> 4 10 0 0 NA 0 NA The … #> 5 5 33 1382 2016-03-18 12:26:14 1 "Ð\u0090лекх The … #> 6 7 0 0 NA 0 NA The … #> 7 97 51 1101 2016-03-13 17:16:33 9510 "TheDrifter" Movi… #> 8 90 19 561 2016-03-21 07:07:09 9521 "Unity" Spor… #> 9 12 105 3997 2016-03-20 22:56:42 9149 "Oskar Dirlewan… Gene… #> 10 11 937 18143 2016-03-21 08:37:42 9950 "Schmiss" Intr… #> # … with 122 more rows, and 29 more variables: description <chr>, #> # position <int>, use_ibc <lgl>, last_title <chr>, last_id <int>, #> # sort_key <chr>, sort_order <chr>, prune <int>, topicfilter <chr>, #> # show_rules <lgl>, allow_poll <lgl>, allow_pollbump <lgl>, #> # inc_postcount <lgl>, skin_id <lgl>, parent_id <int>, #> # notify_modq_emails <chr>, sub_can_post <lgl>, permission_showtopic <lgl>, #> # forum_allow_rating <lgl>, forum_last_deletion <int>, newest_title <chr>, #> # newest_id <int>, can_view_others <lgl>, name_seo <chr>, #> # seo_last_title <chr>, seo_last_name <chr>, last_x_topic_ids <chr>, #> # deleted_topics <lgl>, viglink <lgl> #> #> $orig_groups #> # A tibble: 9 x 47 #> g_id g_view_board g_mem_info g_other_topics g_use_search g_edit_profile #> <int> <lgl> <lgl> <lgl> <lgl> <lgl> #> 1 1 TRUE TRUE TRUE TRUE FALSE #> 2 2 TRUE TRUE TRUE TRUE FALSE #> 3 3 TRUE TRUE TRUE TRUE TRUE #> 4 4 TRUE TRUE TRUE TRUE TRUE #> 5 5 FALSE FALSE FALSE FALSE FALSE #> 6 6 TRUE TRUE TRUE TRUE TRUE #> 7 7 TRUE TRUE TRUE TRUE TRUE #> 8 10 TRUE TRUE TRUE TRUE TRUE #> 9 13 TRUE TRUE TRUE TRUE TRUE #> # … with 41 more variables: g_post_new_topics <lgl>, g_reply_own_topics <lgl>, #> # g_reply_other_topics <lgl>, g_edit_posts <lgl>, g_delete_own_posts <lgl>, #> # g_open_close_posts <lgl>, g_delete_own_topics <lgl>, g_post_polls <lgl>, #> # g_vote_polls <lgl>, g_use_pm <lgl>, g_is_supmod <lgl>, g_access_cp <lgl>, #> # g_title <chr>, g_append_edit <lgl>, g_access_offline <lgl>, #> # g_avoid_q <lgl>, g_avoid_flood <lgl>, g_icon <chr>, g_attach_max <int64>, #> # prefix <chr>, suffix <chr>, g_max_mass_pm <int>, g_search_flood <int>, #> # g_edit_cutoff <int>, g_promotion <chr>, g_hide_from_list <lgl>, #> # g_post_closed <lgl>, g_perm_id <chr>, g_photo_max_vars <chr>, #> # g_dohtml <lgl>, g_edit_topic <lgl>, g_bypass_badwords <lgl>, #> # g_can_msg_attach <lgl>, g_topic_rate_setting <int>, g_dname_changes <int>, #> # g_dname_date <int>, g_rep_max_positive <int>, g_rep_max_negative <int>, #> # g_signature_limits <chr>, g_can_add_friends <lgl>, g_bitoptions <int> #> #> $orig_ignored_users #> # A tibble: 15 x 5 #> ignore_id ignore_owner_id ignore_ignore_id ignore_messages ignore_topics #> <int> <int> <int> <lgl> <lgl> #> 1 2 143 84 FALSE FALSE #> 2 3 143 190 FALSE FALSE #> 3 4 255 279 FALSE FALSE #> 4 5 288 234 TRUE FALSE #> 5 6 331 2 FALSE FALSE #> 6 7 991 1109 FALSE FALSE #> 7 8 288 91 FALSE FALSE #> 8 11 54 6113 FALSE FALSE #> 9 12 6209 2 FALSE FALSE #> 10 13 7364 132 FALSE FALSE #> 11 15 7901 7508 TRUE TRUE #> 12 17 7643 7481 FALSE FALSE #> 13 19 9304 9727 FALSE FALSE #> 14 20 293 6113 FALSE FALSE #> 15 21 9835 9679 TRUE TRUE #> #> $orig_inline_notifications #> # A tibble: 47,066 x 13 #> notify_id notify_to_id notify_sent notify_read notify_title #> <int> <int> <dttm> <int> <chr> #> 1 344972 9217 2016-01-12 03:58:13 1 <a href='ht… #> 2 344973 6155 2016-01-12 03:59:14 1 <a href='ht… #> 3 344971 9679 2016-01-12 03:56:20 1 <a href='ht… #> 4 345399 7424 2016-01-12 23:28:12 1 <a href='ht… #> 5 344817 8232 2016-01-11 21:35:06 1 <a href='ht… #> 6 335396 7903 2015-12-28 17:43:16 1 <a href='ht… #> 7 335397 1109 2015-12-28 17:43:16 0 <a href='ht… #> 8 335398 67 2015-12-28 17:43:16 0 <a href='ht… #> 9 335399 131 2015-12-28 17:43:16 1 <a href='ht… #> 10 350561 8310 2016-01-20 03:59:57 1 <a href='ht… #> # … with 47,056 more rows, and 8 more variables: notify_text <chr>, #> # notify_from_id <int>, notify_type_key <chr>, notify_url <chr>, #> # notify_meta_app <chr>, notify_meta_area <chr>, notify_meta_id <int>, #> # notify_meta_key <chr> #> #> $orig_login_methods #> # A tibble: 3 x 8 #> login_id login_title login_descripti… login_folder_na… login_settings #> <int> <chr> <chr> <chr> <lgl> #> 1 1 IPB Intern… The standard me… internal FALSE #> 2 2 LDAP Authe… LDAP / Active D… ldap TRUE #> 3 3 External D… Authentication … external FALSE #> # … with 3 more variables: login_enabled <lgl>, login_safemode <lgl>, #> # login_order <int> #> #> $orig_member_status_actions #> # A tibble: 927 x 7 #> action_id action_status_id action_reply_id action_member_id action_date #> <int> <int> <int> <int> <int> #> 1 1 1 0 22 1316098429 #> 2 2 2 0 14 1316397519 #> 3 6 6 0 35 1319211330 #> 4 7 7 0 35 1319935567 #> 5 8 8 0 35 1319935570 #> 6 10 11 0 35 1321967601 #> 7 11 12 0 89 1324039690 #> 8 12 2 1 35 1324554161 #> 9 17 2 2 132 1328301526 #> 10 19 19 0 143 1328730328 #> # … with 917 more rows, and 2 more variables: action_key <chr>, #> # action_status_owner <int> #> #> $orig_member_status_replies #> # A tibble: 475 x 5 #> reply_id reply_status_id reply_member_id reply_date reply_content #> <int> <int> <int> <int> <chr> #> 1 1 2 35 1324554161 Try living in Indiana. #> 2 2 2 132 1328301526 Try living in Finland. -… #> 3 3 23 143 1330034455 Omg, blocked. #> 4 5 27 164 1332465964 Yeah it's so annoyin… #> 5 6 26 191 1333131553 And I'm a country gi… #> 6 7 29 132 1333328200 *hmm...slavsicles...* #> 7 8 29 130 1333757777 lolgenocide #> 8 9 29 130 1333758050 I didn't even know y… #> 9 10 26 84 1335455835 I thank God for that too… #> 10 11 49 246 1338862771 I prefer the "count… #> # … with 465 more rows #> #> $orig_member_status_updates #> # A tibble: 560 x 12 #> status_id status_member_id status_date status_content status_replies #> <int> <int> <int> <chr> <int> #> 1 1 22 1316098429 Testing 0 #> 2 2 14 1316397519 Cold... *brrr* 3 #> 3 6 35 1319211330 I am so fucki… 0 #> 4 7 35 1319935567 Queensryche 0 #> 5 8 35 1319935570 Queensryche 0 #> 6 11 35 1321967601 Getting into … 0 #> 7 12 89 1324039690 National Soci… 0 #> 8 28 143 1332804371 Ahaha, gnat s… 0 #> 9 29 130 1332911151 Dreams of Sta… 3 #> 10 19 143 1328730328 Numbess of bo… 0 #> # … with 550 more rows, and 7 more variables: status_last_ids <chr>, #> # status_is_latest <lgl>, status_is_locked <int>, status_hash <chr>, #> # status_author_id <int>, status_author_ip <chr>, status_approved <lgl> #> #> $orig_members #> # A tibble: 763 x 51 #> member_id name member_group_id email joined ip_address posts #> <int> <chr> <int> <chr> <dttm> <chr> <int> #> 1 1 Alex… 4 slav… 2011-09-12 15:46:59 178.140.1… 5613 #> 2 2 Kacen 13 illu… 2011-09-12 15:52:30 68.37.21.… 1267 #> 3 3 Bloo… 13 rene… 2011-09-12 18:10:11 68.10.255… 487 #> 4 4 Mier… 13 homi… 2011-09-12 20:27:35 82.29.169… 1704 #> 5 5 Will… 5 tash… 2011-09-12 20:58:17 90.214.15… 463 #> 6 6 Inte… 13 mich… 2011-09-12 21:14:03 86.7.229.… 9 #> 7 7 Benj… 4 benj… 2011-09-13 01:22:58 81.141.31… 3127 #> 8 8 Mr. … 13 elei… 2011-09-13 04:24:07 98.198.24… 167 #> 9 9 Woma… 5 sol.… 2011-09-13 10:27:52 88.147.27… 997 #> 10 10 Dene… 13 8056… 2011-09-13 12:13:09 72.76.138… 96 #> # … with 753 more rows, and 44 more variables: title <chr>, #> # allow_admin_mails <lgl>, time_offset <chr>, skin <int>, warn_level <int>, #> # warn_lastwarn <int>, last_post <dttm>, restrict_post <chr>, #> # view_sigs <lgl>, bday_day <int>, bday_month <int>, bday_year <int>, #> # msg_count_new <int>, msg_count_total <int>, msg_count_reset <lgl>, #> # msg_show_notification <lgl>, last_visit <dttm>, last_activity <dttm>, #> # dst_in_use <lgl>, mod_posts <chr>, auto_track <chr>, temp_ban <chr>, #> # login_anonymous <chr>, ignored_users <chr>, mgroup_others <chr>, #> # org_perm_id <chr>, member_login_key <chr>, member_login_key_expire <dttm>, #> # members_auto_dst <lgl>, members_display_name <chr>, members_seo_name <chr>, #> # members_cache <chr>, members_disable_pm <int>, #> # members_l_display_name <chr>, members_l_username <chr>, #> # failed_logins <chr>, members_profile_views <int>, members_pass_hash <chr>, #> # members_pass_salt <chr>, member_banned <lgl>, member_uploader <chr>, #> # members_bitoptions <int>, members_day_posts <chr>, notification_cnt <int> #> #> $orig_members_warn_logs #> # A tibble: 163 x 20 #> wl_id wl_member wl_moderator wl_date wl_reason wl_points #> <int> <int> <int> <dttm> <int> <int> #> 1 1 33 9 2011-09-21 11:32:21 0 1 #> 2 2 40 4 2011-10-27 23:38:28 0 1 #> 3 3 40 4 2011-10-27 23:39:35 0 0 #> 4 4 40 4 2011-12-04 00:16:19 0 0 #> 5 5 89 7 2011-12-17 22:04:47 0 1 #> 6 6 49 14 2011-12-17 22:07:40 0 1 #> 7 7 40 14 2011-12-23 20:27:50 0 0 #> 8 8 40 14 2011-12-25 14:33:04 0 0 #> 9 9 40 4 2012-01-01 19:56:58 0 0 #> 10 10 40 4 2012-01-28 21:05:49 0 0 #> # … with 153 more rows, and 14 more variables: wl_note_member <chr>, #> # wl_note_mods <chr>, wl_mq <int>, wl_mq_unit <chr>, wl_rpa <int>, #> # wl_rpa_unit <chr>, wl_suspend <int>, wl_suspend_unit <chr>, #> # wl_ban_group <int>, wl_expire <int>, wl_expire_unit <chr>, #> # wl_content_app <chr>, wl_content_id1 <chr>, wl_expire_date <lgl> #> #> $orig_members_warn_reasons #> # A tibble: 5 x 3 #> wr_id wr_name wr_order #> <int> <chr> <int> #> 1 1 Spamming 1 #> 2 2 Inappropriate Language 2 #> 3 3 Signature Violation 3 #> 4 4 Abusive Behaviour 4 #> 5 5 Topic Bumping 5 #> #> $orig_message_posts #> # A tibble: 13,341 x 8 #> msg_id msg_topic_id msg_date msg_post msg_post_key msg_author_id #> <int> <int> <dttm> <chr> <chr> <int> #> 1 1 1 2011-09-16 03:49:58 "The be… 3320f7f06c4… 1 #> 2 2 2 2011-09-16 11:54:08 "Who ar… 9204e488332… 11 #> 3 3 2 2011-09-16 14:39:59 "Crisis… 12fd0309239… 1 #> 4 4 2 2011-09-16 15:29:01 "Thank … 0658c6f99ac… 11 #> 5 5 2 2011-09-16 15:32:58 "If you… 570257864e3… 1 #> 6 6 2 2011-09-16 15:44:51 "The fu… aabeacc8f4c… 11 #> 7 7 3 2011-09-17 01:43:49 "I don'… a36f67c0d72… 16 #> 8 8 3 2011-09-17 01:59:50 "[quote… 327b933d818… 14 #> 9 12 5 2011-09-20 14:20:14 "The be… 0667258c387… 1 #> 10 13 5 2011-09-20 14:42:17 "Done a… de1d7fd2737… 20 #> # … with 13,331 more rows, and 2 more variables: msg_ip_address <chr>, #> # msg_is_first_post <lgl> #> #> $orig_message_topic_user_map #> # A tibble: 6,025 x 11 #> map_id map_user_id map_topic_id map_folder_id map_read_time #> <int> <int> <int> <chr> <dttm> #> 1 1 23 1 myconvo 2011-11-04 06:53:06 #> 2 2 1 1 myconvo 2011-09-20 14:19:38 #> 3 3 1 2 myconvo 2011-09-16 15:46:25 #> 4 4 11 2 myconvo 2011-09-20 04:03:38 #> 5 5 14 3 myconvo 2011-09-17 01:59:51 #> 6 6 16 3 myconvo 2011-09-17 18:19:01 #> 7 9 20 5 myconvo 2011-09-20 14:42:17 #> 8 10 1 5 myconvo 2011-11-07 01:36:40 #> 9 11 11 6 myconvo 2011-09-22 14:18:00 #> 10 12 1 6 myconvo 2011-09-22 14:33:52 #> # … with 6,015 more rows, and 6 more variables: map_user_active <lgl>, #> # map_user_banned <lgl>, map_has_unread <lgl>, map_is_starter <lgl>, #> # map_ignore_notification <lgl>, map_last_topic_reply <dttm> #> #> $orig_message_topics #> # A tibble: 3,101 x 14 #> mt_id mt_date mt_title mt_starter_id mt_start_time #> <int> <dttm> <chr> <int> <dttm> #> 1 1 2011-09-16 03:49:58 Introdu… 1 2011-09-16 03:49:58 #> 2 2 2011-09-16 11:54:08 Our hos… 11 2011-09-16 11:54:07 #> 3 3 2011-09-17 01:43:49 Re: Nov… 16 2011-09-17 01:43:49 #> 4 5 2011-09-20 14:20:14 Introdu… 1 2011-09-20 14:20:14 #> 5 6 2011-09-22 14:12:17 msn 1 2011-09-22 14:12:17 #> 6 8 2011-09-22 21:21:22 Do you … 2 2011-09-22 21:21:22 #> 7 10 2011-09-23 20:44:56 Introdu… 1 2011-09-23 20:44:56 #> 8 11 2011-09-24 09:40:39 Introdu… 1 2011-09-24 09:40:39 #> 9 12 2011-09-25 17:18:50 Welcome… 14 2011-09-25 17:18:50 #> 10 13 2011-09-26 01:05:50 Could I… 2 2011-09-26 01:05:49 #> # … with 3,091 more rows, and 9 more variables: mt_last_post_time <dttm>, #> # mt_invited_members <chr>, mt_to_count <int>, mt_to_member_id <int>, #> # mt_replies <int>, mt_last_msg_id <int>, mt_first_msg_id <int>, #> # mt_is_draft <lgl>, mt_is_deleted <lgl> #> #> $orig_moderator_logs #> # A tibble: 11,937 x 12 #> id forum_id topic_id post_id member_id member_name ip_address http_referer #> <int> <int> <int> <int> <int> <chr> <chr> <chr> #> 1 1 0 0 0 0 Guest 178.140.1… http://iron… #> 2 2 2 1 0 1 Alexander … 178.140.1… http://iron… #> 3 3 0 0 0 1 Alexander … 178.140.1… http://iron… #> 4 4 4 0 0 1 Alexander … 178.140.1… http://iron… #> 5 5 0 0 0 0 Guest 178.140.1… http://iron… #> 6 6 53 0 0 1 Alexander … 178.140.1… http://iron… #> 7 7 5 0 0 1 Alexander … 178.140.1… http://iron… #> 8 8 61 0 0 1 Alexander … 178.140.1… http://iron… #> 9 9 8 0 0 1 Alexander … 178.140.1… http://iron… #> 10 10 9 0 0 1 Alexander … 178.140.1… http://iron… #> # … with 11,927 more rows, and 4 more variables: ctime <dttm>, #> # topic_title <chr>, action <chr>, query_string <chr> #> #> $orig_permission_index #> # A tibble: 135 x 12 #> perm_id app perm_type perm_type_id perm_view perm_2 perm_3 perm_4 perm_5 #> <int> <chr> <chr> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 memb… profile_… 1 * NA NA NA NA #> 2 2 core help 1 * NA NA NA NA #> 3 3 foru… forum 1 ,1,2,3,4… ,6, ,6, ,6, ,, #> 4 125 foru… forum 2 ,4,2,3,6… ,4,2,… ,4,3,… ,4,6, ,, #> 5 110 foru… forum 92 ,4,2,3,6… ,4,2,… ,4,3,… ,4,3,… ,, #> 6 7 foru… forum 5 ,4,2,3,6… ,4,2,… ,4,3,… ,4,3,… ,6, #> 7 118 foru… forum 100 ,4,2,3,6… ,4,2,… ,4,3,… ,4,3,… ,, #> 8 9 foru… forum 7 ,4,2,3,6… ,, ,, ,, ,, #> 9 109 foru… forum 91 ,4,2,3,6… ,4,2,… ,4,3,… ,4,3,… ,, #> 10 108 foru… forum 90 ,4,2,3,6… ,4,2,… ,4,3,… ,4,3,… ,, #> # … with 125 more rows, and 3 more variables: perm_6 <chr>, perm_7 <chr>, #> # owner_only <lgl> #> #> $orig_pfields_content #> # A tibble: 764 x 12 #> member_id field_1 field_2 field_3 field_4 field_5 field_6 field_7 field_8 #> <int> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> #> 1 1 NA NA NA NA m Third … NA NA #> 2 2 NA NA NA NA m NA NA NA #> 3 9882 NA NA NA NA NA NA NA NA #> 4 3 NA NA NA NA m Dixie "Worki… NA #> 5 4 NA NA http:/… NA m Babylon "You" NA #> 6 5 NA NA NA NA m Great … "Polit… NA #> 7 6 NA NA NA NA m United… NA NA #> 8 7 NA NA NA NA m United… "http:… NA #> 9 8 NA NA NA NA m NA NA NA #> 10 9 NA NA NA NA f AWOL NA NA #> # … with 754 more rows, and 3 more variables: field_9 <chr>, field_10 <chr>, #> # field_11 <chr> #> #> $orig_pfields_data #> # A tibble: 11 x 12 #> pf_id pf_title pf_content pf_type pf_not_null pf_position pf_show_on_reg #> <int> <chr> <chr> <chr> <lgl> <int> <lgl> #> 1 1 AIM NA input FALSE 0 FALSE #> 2 2 MSN NA input FALSE 0 FALSE #> 3 3 Website… NA input FALSE 0 FALSE #> 4 4 ICQ NA input FALSE 0 FALSE #> 5 5 Gender u=Not Tel… drop FALSE 2 FALSE #> 6 6 Locatio… NA input FALSE 3 FALSE #> 7 7 Interes… NA textar… FALSE 4 FALSE #> 8 8 Yahoo NA input FALSE 0 FALSE #> 9 9 Jabber NA input FALSE 0 FALSE #> 10 10 Skype NA input FALSE 0 FALSE #> 11 11 Ideology NA input TRUE 1 TRUE #> # … with 5 more variables: pf_topic_format <chr>, pf_group_id <int>, #> # pf_icon <chr>, pf_key <chr>, pf_search_type <chr> #> #> $orig_pfields_groups #> # A tibble: 2 x 3 #> pf_group_id pf_group_name pf_group_key #> <int> <chr> <chr> #> 1 1 Contact Methods contact #> 2 2 Profile Information profile_info #> #> $orig_polls #> # A tibble: 24 x 9 #> pid tid start_date choices starter_id votes forum_id #> <int> <int> <dttm> <chr> <int> <int> <int> #> 1 1 370 2011-12-13 15:25:38 "a:1:{… 4 13 88 #> 2 3 599 2012-02-14 00:03:33 "a:1:{… 4 12 13 #> 3 4 682 2012-03-06 16:28:36 "a:1:{… 14 41 99 #> 4 6 939 2012-05-11 01:31:58 "a:1:{… 0 39 99 #> 5 11 1422 2012-09-06 04:27:51 "a:1:{… 274 20 24 #> 6 18 2784 2013-08-10 01:03:42 "a:1:{… 6201 22 99 #> 7 20 2830 2013-08-19 20:44:13 "a:1:{… 0 25 78 #> 8 23 3136 2013-10-22 13:27:17 "a:1:{… 35 52 45 #> 9 24 3731 2014-03-15 05:34:15 "a:1:{… 6122 22 88 #> 10 25 3897 2014-04-30 20:33:11 "a:1:{… 6306 23 26 #> # … with 14 more rows, and 2 more variables: poll_question <chr>, #> # poll_view_voters <lgl> #> #> $orig_posts #> # A tibble: 139,068 x 17 #> pid append_edit edit_time author_id author_name use_sig use_emo #> <int> <lgl> <dttm> <int> <chr> <lgl> <lgl> #> 1 202 FALSE NA 7 MoonmanKKK TRUE TRUE #> 2 203 FALSE NA 16 Talleyrand TRUE TRUE #> 3 532 FALSE 2011-09-19 23:14:09 5 Will to Po… TRUE TRUE #> 4 114067 FALSE NA 7508 RIGHT WING… TRUE TRUE #> 5 114068 FALSE 2015-05-16 18:07:42 9486 Nihonjin M… TRUE TRUE #> 6 114069 FALSE 2015-05-16 19:12:42 7481 ¡VIVA LA … TRUE TRUE #> 7 114070 FALSE NA 9144 Neizbezhno… TRUE TRUE #> 8 114071 FALSE NA 6321 Culius Jae… TRUE TRUE #> 9 4 FALSE NA 1 Alexander … TRUE TRUE #> 10 83 FALSE NA 16 Talleyrand TRUE TRUE #> # … with 139,058 more rows, and 10 more variables: ip_address <chr>, #> # post_date <dttm>, post <chr>, queued <int>, topic_id <int>, #> # new_topic <lgl>, edit_name <chr>, post_key <chr>, post_edit_reason <chr>, #> # pdelete_time <dttm> #> #> $orig_profile_friends #> # A tibble: 4,593 x 5 #> friends_id friends_member_id friends_friend_id friends_approved friends_added #> <int> <int> <int> <lgl> <int> #> 1 1 10 2 TRUE 1315921996 #> 2 2 2 10 TRUE 1315921996 #> 3 218 13 10 TRUE 1327664896 #> 4 217 10 13 TRUE 1327664896 #> 5 5 2 1 TRUE 1315937852 #> 6 6 1 2 TRUE 1315937852 #> 7 259 2 132 TRUE 1328295675 #> 8 260 132 2 TRUE 1328295675 #> 9 9 22 1 TRUE 1316098018 #> 10 10 1 22 TRUE 1316098018 #> # … with 4,583 more rows #> #> $orig_profile_portal #> # A tibble: 764 x 23 #> pp_member_id pp_last_visitors pp_rating_hits pp_rating_value pp_rating_real #> <int> <chr> <int> <int> <int> #> 1 1 a:6:{i:14585562… 30 136 5 #> 2 9659 a:1:{i:14429407… 1 1 1 #> 3 6180 a:6:{i:13927958… 0 0 0 #> 4 2 a:6:{i:14559000… 10 45 5 #> 5 3 a:6:{i:14571305… 3 14 5 #> 6 4 a:6:{i:14571393… 7 31 4 #> 7 5 a:6:{i:13747911… 2 2 1 #> 8 6 a:6:{i:14343615… 0 0 0 #> 9 7 a:6:{i:14585121… 24 108 5 #> 10 8 a:6:{i:14551305… 2 10 5 #> # … with 754 more rows, and 18 more variables: pp_main_photo <chr>, #> # pp_main_width <int>, pp_main_height <int>, pp_thumb_photo <chr>, #> # pp_thumb_width <int>, pp_thumb_height <int>, #> # pp_setting_moderate_comments <lgl>, pp_setting_moderate_friends <lgl>, #> # pp_setting_count_friends <lgl>, pp_setting_count_comments <lgl>, #> # pp_setting_count_visitors <lgl>, pp_about_me <chr>, #> # pp_reputation_points <int>, pp_gravatar <chr>, pp_photo_type <chr>, #> # signature <chr>, pp_customization <chr>, pp_profile_update <dttm> #> #> $orig_profile_ratings #> # A tibble: 1,253 x 5 #> rating_id rating_for_member… rating_by_member_… rating_ip_addre… rating_value #> <int> <int> <int> <chr> <int> #> 1 1 44 22 178.7.118.182 5 #> 2 2 1 89 86.145.168.97 4 #> 3 3 1 11 109.77.25.198 5 #> 4 4 1 2 68.37.21.125 5 #> 5 5 1 10 71.255.83.251 5 #> 6 6 61 134 99.22.216.224 5 #> 7 7 64 13 77.249.103.246 1 #> 8 8 64 101 92.251.65.142 1 #> 9 9 100 101 92.251.65.142 5 #> 10 10 84 13 77.249.103.246 1 #> # … with 1,243 more rows #> #> $orig_question_and_answer #> # A tibble: 4 x 3 #> qa_id qa_question qa_answers #> <int> <chr> <chr> #> 1 17 Name the specialized subforum from … "JEWISH QUESTION\r\nTHE JEWISH QUE… #> 2 16 Input the second key term listed in… "FASCIST ALMA MATER" #> 3 15 The Slogan of IronMarch is (answer … "GAS THE KIKES RACE WAR NOW 1488 B… #> 4 18 The place where you will end up if … "CONCENTRATION CAMP\r\nTHE CONCENT… #> #> $orig_rc_classes #> # A tibble: 5 x 8 #> com_id class_title class_desc my_class group_can_report mod_group_perm #> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 Simple Plu… Plugin th… default ,3,4,6,7,8,9,10… ,4,6,10, #> 2 2 Forum Plug… This is t… post ,1,2,3,4,6,7,8,… ,4,6,10, #> 3 3 Private Me… This plug… messages ,1,2,3,4,6,7,8,… ,4,6,10, #> 4 4 Member Pro… Allows yo… profiles ,1,2,3,4,6,7,8,… ,4,6,10, #> 5 5 Calendar P… Allows ca… calendar ,1,2,3,4,6, ,4,6, #> # … with 2 more variables: extra_data <chr>, app <chr> #> #> $orig_rc_comments #> # A tibble: 21 x 7 #> id rid comment comment_by comment_date author_name ip_address #> <int> <int> <chr> <int> <dttm> <chr> <chr> #> 1 1 1 "This is … 9 2011-12-24 09:57:56 "Woman in B… 88.147.17… #> 2 13 10 "done" 49 2012-12-27 20:38:44 "Влади… 72.78.105… #> 3 26 74 "<p>Don't… 4 2014-01-02 11:51:34 "Mierce" 82.25.135… #> 4 30 89 "<p>No.</… 1 2015-05-13 16:30:24 "Ð\u0090лЅ 5.228.66.… #> 5 31 89 "<p>I'll … 2170 2015-05-13 20:18:43 "Zeiger" 69.70.181… #> 6 32 89 "<p>this … 9475 2015-05-13 21:47:00 "mengligira… 95.142.13… #> 7 33 89 "<p>>P… 2220 2015-05-15 02:16:03 "Kulturkamp… 122.128.1… #> 8 34 90 "Who are … 2170 2015-05-21 06:36:39 "Zeiger" 66.102.6.… #> 9 35 90 "<p>He's … 9475 2015-05-21 06:57:15 "mengligira… 95.142.13… #> 10 36 90 "<p>Oh ye… 1 2015-05-21 07:40:49 "Ð\u0090лЅ 5.228.66.… #> # … with 11 more rows #> #> $orig_rc_modpref #> # A tibble: 21 x 3 #> mem_id rss_key rss_cache #> <int> <chr> <chr> #> 1 1 a31e419a0c3ec13258bcf… NA #> 2 4 570882a0ed9e1c0b83c8c… NA #> 3 14 40cf3bd33995c06ae9639… NA #> 4 0 NA "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n… #> 5 7 d8a331ee70aba8ad92f8b… NA #> 6 9 1c0febd1e77291c90b057… NA #> 7 132 2c47a8124da7d34842c65… NA #> 8 13 2b4ae5b7d09b495defbc2… NA #> 9 35 ce51ea7ca7936a0bfd871… NA #> 10 2 aa6ce80b32ecf26829563… NA #> # … with 11 more rows #> #> $orig_rc_reports #> # A tibble: 25 x 5 #> id rid report report_by date_reported #> <int> <int> <chr> <int> <int> #> 1 1 1 "[quote name='Frost Hammer']Before I sta… 11 1324684384 #> 2 10 10 "[quote name='Sir Barza']Please, delete … 2099 1356640292 #> 3 14 14 "[quote name='AlbertSakas']СебÑ\u008f… 2 1361245960 #> 4 59 55 "spam profile" 1209 1366310513 #> 5 60 56 "more spam profile's" 1209 1366310573 #> 6 62 58 "<blockquote class=\"ipsBlockquote\" da… 6174 1374646450 #> 7 71 66 "<blockquote class=\"ipsBlockquote\" da… 6173 1377089209 #> 8 74 69 "<blockquote class=\"ipsBlockquote\" da… 2 1380356286 #> 9 75 70 "<blockquote class=\"ipsBlockquote\" da… 2 1380356292 #> 10 79 74 "<blockquote class=\"ipsBlockquote\" da… 0 1388660127 #> # … with 15 more rows #> #> $orig_rc_reports_index #> # A tibble: 23 x 14 #> id uid title url rc_class updated_by date_updated date_created exdat1 #> <int> <chr> <chr> <chr> <int> <int> <int> <int> <int> #> 1 1 0b3a… Why … /ind… 2 9 1324720676 1324684384 57 #> 2 10 d94e… Worl… /ind… 2 4 1356645256 1356640292 22 #> 3 14 4007… Oper… /ind… 2 1 1361248006 1361245960 4 #> 4 58 264d… IRA … /ind… 2 1 1374646833 1374646450 9 #> 5 66 cd32… Jews… /ind… 2 4 1377095062 1377089209 8 #> 6 69 933f… Belg… /ind… 2 16 1380356859 1380356286 8 #> 7 70 3a36… Belg… /ind… 2 16 1380356859 1380356292 8 #> 8 74 9ca0… Gabo… /ind… 2 4 1388663494 1388660127 9 #> 9 89 7b4b… Libe… /ind… 2 2170 1431658980 1431533699 30 #> 10 90 f557… Iron… /ind… 2 2170 1432309218 1432177523 2 #> # … with 13 more rows, and 5 more variables: exdat2 <int>, exdat3 <int>, #> # num_comments <int>, seoname <chr>, seotemplate <chr> #> #> $orig_rc_status #> # A tibble: 3 x 8 #> status title points_per_repo… minutes_to_apoi… is_new is_complete is_active #> <int> <chr> <lgl> <dbl> <lgl> <lgl> <lgl> #> 1 1 New … TRUE 5 TRUE FALSE TRUE #> 2 2 Unde… TRUE 5 FALSE FALSE TRUE #> 3 3 Comp… FALSE 0 FALSE TRUE FALSE #> # … with 1 more variable: rorder <int> #> #> $orig_rc_status_sev #> # A tibble: 11 x 4 #> id status points img #> <int> <int> <int> <chr> #> 1 1 1 1 style_extra/report_icons/flag_gray.png #> 2 2 1 2 style_extra/report_icons/flag_blue.png #> 3 3 1 4 style_extra/report_icons/flag_green.png #> 4 4 1 7 style_extra/report_icons/flag_orange.png #> 5 5 1 12 style_extra/report_icons/flag_red.png #> 6 6 2 1 style_extra/report_icons/flag_gray_review.png #> 7 7 3 0 style_extra/report_icons/completed.png #> 8 8 2 2 style_extra/report_icons/flag_blue_review.png #> 9 9 2 4 style_extra/report_icons/flag_green_review.png #> 10 10 2 7 style_extra/report_icons/flag_orange_review.png #> 11 11 2 12 style_extra/report_icons/flag_red_review.png #> #> $orig_reputation_cache #> # A tibble: 55 x 5 #> id type_id rep_points rep_like_cache cache_date #> <int64> <int> <int> <chr> <dttm> #> 1 2.80585… 117582 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 2 2.80585… 117681 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 3 2.80585… 117682 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 4 2.80585… 117695 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 5 2.80585… 117702 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 6 2.49127… 117573 2 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 7 2.80585… 117578 1 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 8 2.80585… 117577 2 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 9 2.80585… 117576 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-23 07:28:57 #> 10 3.84452… 147832 0 "a:2:{s:10:\"cache_data\";a:… 2016-03-22 06:24:36 #> # … with 45 more rows #> #> $orig_reputation_index #> # A tibble: 141,550 x 6 #> id member_id app type type_id rep_date #> <int64> <int> <chr> <chr> <int> <dttm> #> 1 4.940656e-324 14 forums pid 4 2011-09-13 23:02:39 #> 2 1.482197e-323 14 forums pid 124 2011-09-14 20:30:25 #> 3 1.976263e-323 13 forums pid 119 2011-09-14 21:57:39 #> 4 2.470328e-323 9 forums pid 180 2011-09-15 16:49:00 #> 5 6.294396e-321 11 forums pid 8457 2012-01-28 19:41:56 #> 6 3.458460e-323 3 forums pid 182 2011-09-15 23:40:19 #> 7 3.952525e-323 3 forums pid 213 2011-09-16 03:46:29 #> 8 4.446591e-323 9 forums pid 227 2011-09-16 07:07:43 #> 9 2.322109e-322 41 forums pid 1170 2011-09-29 08:03:42 #> 10 5.434722e-323 13 forums pid 293 2011-09-16 22:35:02 #> # … with 141,540 more rows #> #> $orig_reputation_levels #> # A tibble: 5 x 3 #> level_id level_points level_title #> <int> <int> <chr> #> 1 1 -20 Bad #> 2 2 -10 Poor #> 3 3 0 Neutral #> 4 4 10 Good #> 5 5 20 Excellent #> #> $orig_reputation_totals #> # A tibble: 145,845 x 4 #> rt_key rt_app_type rt_total rt_type_id #> <chr> <chr> <int> <int> #> 1 f569df187fe4fb506119366eb62… a17de1b4e5015b2ca6ba5cb6ca3… 2 3 #> 2 4541627f84f4558678ebfd2c23f… a17de1b4e5015b2ca6ba5cb6ca3… 1 4 #> 3 36ee8a9877305932043b8e83f0d… a17de1b4e5015b2ca6ba5cb6ca3… 1 15 #> 4 9629b004883a463f9caaa0245d8… a17de1b4e5015b2ca6ba5cb6ca3… 1 35 #> 5 9679d18bb14119059ad833a65be… a17de1b4e5015b2ca6ba5cb6ca3… 1 43 #> 6 0cac233272c7966e1227ba401fe… a17de1b4e5015b2ca6ba5cb6ca3… 4 46 #> 7 a378e216c62e758dac8361a5a04… a17de1b4e5015b2ca6ba5cb6ca3… 3 54 #> 8 99e865095aab71ffb7f96591f19… a17de1b4e5015b2ca6ba5cb6ca3… 1 67 #> 9 d1c7f59602e6b8be00c2cdd0a9e… a17de1b4e5015b2ca6ba5cb6ca3… 1 78 #> 10 55a9e27a0cf8c5c536152c9a3fc… a17de1b4e5015b2ca6ba5cb6ca3… 2 97 #> # … with 145,835 more rows #> #> $orig_search_keywords #> # A tibble: 20,079 x 2 #> keyword count #> <chr> <int> #> 1 #jesuiscouteau ironmarch.org 1 #> 2 #rekt gif 1 #> 3 #shrekt 1 #> 4 $hre.kersan.photo 1 #> 5 'craig fraser' sigurd 1 #> 6 'elementos - urkultur 1 #> 7 'Hammer of the Patriot A handbook By Charles Chapel. 1 #> 8 'the whole of National Socialism [the Nazi political philosophy] i… 1 #> 9 >I am a fierce goddess warrior who embraces the human spirit fully.… 1 #> 10 " central Asian albinos" 1 #> # … with 20,069 more rows #> #> $orig_search_sessions #> # A tibble: 1,274 x 5 #> session_id session_created session_updated session_member_… #> <chr> <dttm> <dttm> <int> #> 1 6e420afb2… 2016-03-21 01:39:32 2016-03-21 01:39:32 0 #> 2 d7f949091… 2016-03-21 03:59:10 2016-03-21 03:59:10 0 #> 3 8e9e710ab… 2016-03-21 00:30:03 2016-03-21 00:30:03 0 #> 4 9271fa2f1… 2016-03-21 00:30:39 2016-03-21 00:30:40 6113 #> 5 42c32a7f7… 2016-03-21 02:52:17 2016-03-21 02:52:17 0 #> 6 51255c281… 2016-03-20 14:13:22 2016-03-20 14:13:23 0 #> 7 c82c6c810… 2016-03-20 15:38:41 2016-03-20 15:38:41 0 #> 8 8d8a85409… 2016-03-20 15:40:02 2016-03-20 15:40:02 0 #> 9 ee348f4d0… 2016-03-21 06:46:55 2016-03-21 06:46:55 0 #> 10 e181d0d63… 2016-03-20 21:21:33 2016-03-20 21:21:36 0 #> # … with 1,264 more rows, and 1 more variable: session_data <chr> #> #> $orig_search_visitors #> # A tibble: 696 x 6 #> id member date engine keywords url #> <int> <int> <dttm> <chr> <chr> <chr> #> 1 42351 0 2016-02-18 17:59:40 Google file:///porn/288… showuser=288&tab=r… #> 2 42352 0 2016-02-18 19:28:31 Bing evola yuga showuser=7508&tab=… #> 3 42353 0 2016-02-18 19:28:32 Bing evola yuga showuser=7508&tab=… #> 4 42354 0 2016-02-18 20:08:43 Bing pros and cons of… showtopic=2869 #> 5 42355 0 2016-02-18 20:55:28 Google fascist authors showtopic=92 #> 6 42356 0 2016-02-18 21:15:31 Google Light skin vs sh… showtopic=5378 #> 7 42357 0 2016-02-18 21:27:47 Google sigurd legion showtopic=4447 #> 8 42358 0 2016-02-19 00:17:57 Bing were there any r… showtopic=2064 #> 9 42359 0 2016-02-19 03:05:49 Google kike on a stick app=core&module=se… #> 10 42360 0 2016-02-19 06:37:51 Google Ironmarch chines… showtopic=206 #> # … with 686 more rows #> #> $orig_sessions #> # A tibble: 240 x 19 #> id member_name seo_name member_id ip_address browser running_time #> <chr> <chr> <chr> <int> <chr> <chr> <int> #> 1 60f2… NA NA 0 166.137.1… Mozill… 1458838967 #> 2 ca7c… NA NA 0 180.76.15… Mozill… 1458840813 #> 3 b6a6… Goeth goeth 9363 99.92.244… Mozill… 1458838996 #> 4 828d… GladiumSpi… gladium… 9634 45.21.34.… Mozill… 1458839012 #> 5 d356… NA NA 0 180.76.15… Mozill… 1458843698 #> 6 5451… NA NA 0 213.205.2… Mozill… 1458843368 #> 7 869d… NA NA 0 97.67.240… Mozill… 1458842942 #> 8 afd3… NA NA 0 86.3.91.23 Mozill… 1458842308 #> 9 2cc2… NA NA 0 91.144.13… Wget/1… 1458837947 #> 10 7082… NA NA 0 212.21.66… Mozill… 1458839341 #> # … with 230 more rows, and 12 more variables: login_type <lgl>, #> # member_group <int>, location_1_type <chr>, location_1_id <int>, #> # location_2_type <chr>, location_2_id <int>, current_appcomponent <chr>, #> # current_module <chr>, current_section <chr>, uagent_key <chr>, #> # uagent_version <chr>, uagent_type <chr> #> #> $orig_skin_cache #> # A tibble: 350 x 17 #> cache_id cache_updated cache_type cache_set_id cache_key_1 #> <int> <dttm> <chr> <int> <chr> #> 1 3022 2014-10-26 19:34:17 replaceme… 0 NA #> 2 3023 2014-10-26 19:35:36 phptempla… 1 group #> 3 3028 2014-10-26 19:35:36 phptempla… 1 group #> 4 3024 2014-10-26 19:35:36 phptempla… 1 group #> 5 3026 2014-10-26 19:35:36 phptempla… 1 group #> 6 3027 2014-10-26 19:35:36 phptempla… 1 group #> 7 3025 2014-10-26 19:35:36 phptempla… 1 group #> 8 3030 2014-10-26 19:35:36 phptempla… 1 group #> 9 3033 2014-10-26 19:35:36 phptempla… 1 group #> 10 3031 2014-10-26 19:35:36 phptempla… 1 group #> # … with 340 more rows, and 12 more variables: cache_value_1 <chr>, #> # cache_key_2 <chr>, cache_value_2 <chr>, cache_value_3 <chr>, #> # cache_content <chr>, cache_key_3 <chr>, cache_key_4 <chr>, #> # cache_value_4 <chr>, cache_key_5 <chr>, cache_value_5 <chr>, #> # cache_key_6 <chr>, cache_value_6 <chr> #> #> $orig_skin_collections #> # A tibble: 4 x 15 #> set_id set_name set_key set_is_default set_author_name set_author_url #> <int> <chr> <chr> <lgl> <chr> <chr> #> 1 1 IP.Board default FALSE Invision Power… http://www.in… #> 2 2 IP.Boar… mobile FALSE Invision Power… http://www.in… #> 3 6 IP.Boar… xmlskin FALSE Invision Power… http://www.in… #> 4 9 ironmar… ipbfsC… TRUE NA NA #> # … with 9 more variables: set_image_dir <chr>, set_css_groups <chr>, #> # set_added <int>, set_output_format <chr>, set_locked_uagent <chr>, #> # set_hide_from_list <lgl>, set_minify <lgl>, set_master_key <chr>, #> # set_order <int> #> #> $orig_skin_css #> # A tibble: 50 x 11 #> css_id css_set_id css_updated css_group css_content css_position css_app #> <int> <int> <int> <chr> <chr> <int> <chr> #> 1 195 0 1414352049 ipb_ucp "/********… 1 core #> 2 186 0 1414352049 ipb_cked… "/********… 1 core #> 3 187 0 1414352049 ipb_comm… "/********… 1 core #> 4 188 0 1414352049 ipb_edit… "/********… 1 core #> 5 189 0 1414352049 ipb_help "/********… 0 core #> 6 190 0 1414352049 ipb_ie "/********… 0 core #> 7 191 0 1414352049 ipb_logi… "/********… 1 core #> 8 192 0 1414352049 ipb_print "* {\n\tfo… 1 core #> 9 193 0 1414352049 ipb_sear… "/********… 2 core #> 10 194 0 1414352049 ipb_styl… "/********… 1 core #> # … with 40 more rows, and 4 more variables: css_app_hide <lgl>, #> # css_attributes <chr>, css_modules <chr>, css_master_key <chr> #> #> $orig_skin_css_previous #> # A tibble: 35 x 7 #> p_css_id p_css_group p_css_content p_css_app p_css_attributes p_css_modules #> <int> <chr> <chr> <chr> <chr> <chr> #> 1 1 ipb_ucp "/**********… core "title=\"Main\"… usercp #> 2 2 ipb_ckedit… "/**********… core "title=\"Main\"… NA #> 3 3 ipb_common "/**********… core "title=\"Main\"… NA #> 4 4 ipb_editor "/**********… core "title=\"Main\"… NA #> 5 5 ipb_help "/**********… core "title=\"Main\"… help #> 6 6 ipb_ie "/**********… core NA NA #> 7 7 ipb_login_… "/**********… core "title=\"Main\"… global #> 8 8 ipb_print "* {\n\tfont… core "media=\"print\… NA #> 9 9 ipb_search "/**********… core "title=\"Main\"… search #> 10 10 ipb_styles "/**********… core "title=\"Main\"… NA #> # … with 25 more rows, and 1 more variable: p_css_master_key <chr> #> #> $orig_skin_replacements #> # A tibble: 201 x 6 #> replacement_id replacement_key replacement_con… replacement_set… #> <int> <chr> <chr> <int> #> 1 1 add_folder <img src='{styl… 0 #> 2 2 add_friend <img src='{styl… 0 #> 3 3 add_poll_choice <img src='{styl… 0 #> 4 4 add_poll_quest… <img src='{styl… 0 #> 5 5 blog_add_entry <img src='{styl… 0 #> 6 6 blog_banish <img src='{styl… 0 #> 7 7 blog_blocks <img src='{styl… 0 #> 8 8 blog_blog <img src='{styl… 0 #> 9 9 blog_category <img src='{styl… 0 #> 10 10 blog_comments <img src='{styl… 0 #> # … with 191 more rows, and 2 more variables: replacement_added_to <int>, #> # replacement_master_key <chr> #> #> $orig_skin_templates #> # A tibble: 1,002 x 12 #> template_id template_set_id template_group template_content template_name #> <int> <int> <chr> <chr> <chr> #> 1 3389 0 skin_stats "<h1 class='ips… top_posters #> 2 3388 0 skin_stats "<if test=\"has… group_strip #> 3 3385 0 skin_search "<div class='re… searchRowGen… #> 4 3386 0 skin_search "<if test=\"whi… topicPostSea… #> 5 3387 0 skin_search "<php>\n\t$date… userPostsView #> 6 3384 0 skin_search "<input type='h… searchResult… #> 7 3382 0 skin_search "{parse stripin… searchResults #> 8 3383 0 skin_search "{parse js_modu… searchResult… #> 9 3381 0 skin_search "<style type='t… searchAdvanc… #> 10 3377 0 skin_search "<php>\n$st = I… helpSearchRe… #> # … with 992 more rows, and 7 more variables: template_data <chr>, #> # template_updated <int>, template_removable <lgl>, template_added_to <int>, #> # template_user_added <lgl>, template_user_edited <lgl>, #> # template_master_key <chr> #> #> $orig_skin_templates_previous #> # A tibble: 786 x 6 #> p_template_id p_template_group p_template_cont… p_template_name #> <int> <chr> <chr> <chr> #> 1 1 skin_stats "<h1 class='ips… top_posters #> 2 2 skin_stats "<if test=\"has… group_strip #> 3 3 skin_search "<div class='re… searchRowGener… #> 4 4 skin_search "<if test=\"whi… topicPostSearc… #> 5 5 skin_search "<php>\n\t$date… userPostsView #> 6 6 skin_search "<input type='h… searchResultsW… #> 7 7 skin_search "{parse stripin… searchResults #> 8 8 skin_search "{parse js_modu… searchResultsA… #> 9 9 skin_search "<style type='t… searchAdvanced… #> 10 10 skin_search "<span class='i… memberSearchRe… #> # … with 776 more rows, and 2 more variables: p_template_data <chr>, #> # p_template_master_key <chr> #> #> $orig_spam_service_log #> # A tibble: 97 x 5 #> id log_date log_code email_address ip_address #> <int> <dttm> <int> <chr> <chr> #> 1 9891 2016-03-03 05:59:36 1 shadoomoken@hotmail.com 64.150.252.2… #> 2 9890 2016-03-03 01:03:48 1 jeff.foxworthy.1488@gmail.c… 93.72.237.41 #> 3 9889 2016-03-03 00:46:47 1 tinobraga101@gmail.com 24.78.212.91 #> 4 9888 2016-03-02 14:39:36 1 notcute@gmail.com 46.233.9.234 #> 5 9887 2016-03-02 13:09:17 1 caleb133.me@hotmail.com 58.110.49.210 #> 6 9886 2016-03-02 12:46:44 1 count_dusseldorf@yahoo.com 74.128.184.1… #> 7 9885 2016-03-01 13:26:57 1 hatecrime.jonez@gmail.com 172.58.40.119 #> 8 9884 2016-03-01 06:11:21 1 caseyjcooper2012@gmail.com 73.82.53.143 #> 9 9883 2016-03-01 04:52:06 1 adil902@hotmail.com 90.229.153.1… #> 10 9882 2016-03-01 02:52:46 1 douglas@blaglab.com 203.12.30.50 #> # … with 87 more rows #> #> $orig_task_logs #> # A tibble: 18,240 x 5 #> log_id log_title log_date log_ip log_desc #> <int> <chr> <dttm> <chr> <chr> #> 1 551033 Archiver 2016-01-28 09:18:11 82.145.2… 0 items archived #> 2 551034 Daily Topic &… 2016-01-28 09:22:36 72.169.9… Daily Topic & Forum D… #> 3 551032 RSS Import Update 2016-01-28 09:09:13 174.4.16… RSS Import completed … #> 4 551031 Archiver 2016-01-28 09:03:25 69.143.9… 0 items archived #> 5 551030 Daily Topic &… 2016-01-28 09:02:25 101.173.… Daily Topic & Forum D… #> 6 551029 Clean Up MySQL 2016-01-28 09:02:16 104.238.… Cleaned up sleeping m… #> 7 551028 Hourly Clean Out 2016-01-28 08:54:08 46.177.1… Old reg_images, sessi… #> 8 551027 Archiver 2016-01-28 08:48:05 212.93.2… 0 items archived #> 9 551026 Daily Topic &… 2016-01-28 08:42:06 195.156.… Daily Topic & Forum D… #> 10 551025 RSS Import Update 2016-01-28 08:38:16 46.177.1… RSS Import completed … #> # … with 18,230 more rows #> #> $orig_task_manager #> # A tibble: 28 x 15 #> task_id task_title task_file task_next_run task_week_day task_month_day #> <int> <chr> <chr> <int> <int> <int> #> 1 1 Hourly Cl… cleanout… 1458844680 -1 -1 #> 2 2 Content C… contentc… 1458874800 -1 -1 #> 3 3 Item Mark… itemmark… 1458864000 -1 -1 #> 4 4 Prune Logs logprune… 1459058400 -1 27 #> 5 5 Clean Up … mysqlcle… 1458845400 -1 -1 #> 6 24 Archiver archive.… 1458844560 -1 -1 #> 7 7 Optimize … optimize… 1458878400 -1 -1 #> 8 8 POP3 Inco… pop3emai… 1315842488 -1 -1 #> 9 9 Daily Sta… rebuilds… 1458864000 -1 -1 #> 10 10 Send Bulk… bulkmail… 1374129660 -1 -1 #> # … with 18 more rows, and 9 more variables: task_hour <int>, #> # task_minute <int>, task_cronkey <chr>, task_log <lgl>, #> # task_description <chr>, task_enabled <lgl>, task_key <chr>, #> # task_safemode <lgl>, task_application <chr> #> #> $orig_topic_ratings #> # A tibble: 17 x 5 #> rating_id rating_tid rating_member_id rating_value rating_ip_address #> <int> <int> <int> <int> <chr> #> 1 1 4287 1558 5 83.233.70.12 #> 2 2 4287 958 5 188.228.43.35 #> 3 3 4287 6359 5 69.35.163.246 #> 4 4 4287 7888 5 54.87.97.146 #> 5 5 4287 7 5 91.125.204.107 #> 6 6 4287 125 5 77.38.156.66 #> 7 7 4287 2820 5 99.249.195.215 #> 8 8 4287 2306 5 88.193.135.245 #> 9 9 4287 6310 5 75.157.149.158 #> 10 10 5869 9679 5 66.169.97.70 #> 11 11 5869 6113 5 74.65.55.196 #> 12 12 5869 9568 5 58.7.200.210 #> 13 13 5869 1558 1 83.233.71.27 #> 14 14 5869 7600 5 24.51.110.134 #> 15 15 5869 6249 5 108.71.197.158 #> 16 16 5869 9388 5 86.93.229.17 #> 17 17 5869 9769 5 92.18.10.232 #> #> $orig_topics #> # A tibble: 5,073 x 27 #> tid title state posts starter_id start_date last_poster_id #> <int> <chr> <chr> <int> <int> <dttm> <int> #> 1 5182 "Hei… clos… 8 9491 2015-05-20 07:29:54 7504 #> 2 3 "The… clos… 50 1 2011-09-13 01:06:06 16 #> 3 3674 "“… open 11 7346 2014-03-01 23:36:53 49 #> 4 7 "Sup… clos… 0 1 2011-09-13 09:47:48 1 #> 5 8 "Wha… clos… 0 1 2011-09-13 09:52:23 1 #> 6 9 "Wha… clos… 0 1 2011-09-13 09:55:16 1 #> 7 5167 "The… open 13 6321 2015-05-16 18:16:41 6269 #> 8 5168 "Chi… open 19 7508 2015-05-16 22:42:30 7508 #> 9 11 "Rag… open 752 1 2011-09-13 10:23:27 9571 #> 10 4306 "Vol… open 2 1 2014-09-22 19:22:56 1 #> # … with 5,063 more rows, and 20 more variables: last_post <dttm>, #> # icon_id <lgl>, starter_name <chr>, last_poster_name <chr>, #> # poll_state <chr>, last_vote <int>, views <int>, forum_id <int>, #> # approved <int>, author_mode <lgl>, pinned <lgl>, topic_hasattach <int>, #> # topic_firstpost <int>, topic_rating_total <int>, topic_rating_hits <int>, #> # title_seo <chr>, seo_last_name <chr>, seo_first_name <chr>, #> # tdelete_time <int>, last_real_post <dttm> #> #> $orig_upgrade_history #> # A tibble: 68 x 6 #> upgrade_id upgrade_version… upgrade_version… upgrade_date upgrade_mid #> <int> <int> <chr> <dttm> <lgl> #> 1 1 32005 3.2.2 NA FALSE #> 2 2 32005 3.2.2 NA FALSE #> 3 3 32005 3.2.2 NA FALSE #> 4 4 32006 3.2.3 2013-07-20 14:15:55 FALSE #> 5 5 33000 3.3.0 Alpha 1 2013-07-20 14:16:45 FALSE #> 6 6 33006 3.3.0 Alpha 2 2013-07-20 14:16:47 FALSE #> 7 7 33007 3.3.0 Beta 1 2013-07-20 14:16:50 FALSE #> 8 8 33008 3.3.0 Beta 2 2013-07-20 14:16:53 FALSE #> 9 9 33009 3.3.0 Beta 3 2013-07-20 14:16:57 FALSE #> 10 10 33010 3.3.0 Beta 4 2013-07-20 14:17:02 FALSE #> # … with 58 more rows, and 1 more variable: upgrade_app <chr> #> #> $orig_validating #> # A tibble: 19 x 9 #> vid member_id real_group temp_group entry_date lost_pass new_reg #> <chr> <int> <int> <int> <dttm> <lgl> <lgl> #> 1 2132… 9571 13 13 2016-02-08 02:38:29 TRUE FALSE #> 2 28f2… 9955 3 1 2016-03-16 20:13:58 FALSE TRUE #> 3 77b9… 6208 13 13 2016-01-26 04:01:15 TRUE FALSE #> 4 6cf7… 9800 13 13 2016-03-21 15:56:10 TRUE FALSE #> 5 f601… 9780 13 13 2016-03-23 21:14:46 TRUE FALSE #> 6 3a07… 9211 13 13 2016-02-04 14:11:54 TRUE FALSE #> 7 f013… 9112 13 13 2016-03-18 20:58:14 TRUE FALSE #> 8 bd80… 9916 3 3 2016-03-02 03:06:15 TRUE FALSE #> 9 fa74… 9303 13 13 2016-03-04 21:59:12 TRUE FALSE #> 10 e4db… 9666 13 13 2016-03-05 15:09:55 TRUE FALSE #> 11 63be… 9954 3 1 2016-03-15 22:04:25 FALSE TRUE #> 12 b6d3… 9952 3 1 2016-03-15 00:00:14 FALSE TRUE #> 13 ea85… 9953 3 1 2016-03-15 02:31:59 FALSE TRUE #> 14 87ab… 9956 3 1 2016-03-17 18:36:53 FALSE TRUE #> 15 0530… 9957 3 1 2016-03-18 18:48:49 FALSE TRUE #> 16 85ca… 9958 3 1 2016-03-19 00:45:15 FALSE TRUE #> 17 60c7… 9959 3 1 2016-03-19 08:48:44 FALSE TRUE #> 18 cc41… 9959 0 1 2016-03-19 08:54:03 TRUE FALSE #> 19 bbd0… 9960 3 1 2016-03-19 19:11:43 FALSE TRUE #> # … with 2 more variables: ip_address <chr>, user_verified <lgl> #> #> $orig_voters #> # A tibble: 789 x 7 #> vid ip_address vote_date tid member_id forum_id member_choices #> <int> <chr> <int> <int> <int> <int> <chr> #> 1 1 77.249.103.2… 1.32e9 370 13 88 "a:1:{i:1;a:1:{i:0;s:… #> 2 2 86.21.53.46 1.32e9 370 4 88 "a:1:{i:1;a:1:{i:0;s:… #> 3 3 108.13.155.97 1.32e9 370 29 88 "a:1:{i:1;a:1:{i:0;s:… #> 4 4 86.7.229.239 1.32e9 370 6 88 "a:1:{i:1;a:1:{i:0;s:… #> 5 5 31.220.211.18 1.32e9 370 7 88 "a:1:{i:1;a:1:{i:0;s:… #> 6 6 152.33.21.65 1.32e9 370 16 88 "a:1:{i:1;a:1:{i:0;s:… #> 7 7 192.101.250.… 1.32e9 370 68 88 "a:1:{i:1;a:1:{i:0;s:… #> 8 8 71.185.163.2… 1.32e9 370 49 88 "a:1:{i:1;a:1:{i:0;s:… #> 9 9 131.181.251.… 1.32e9 370 65 88 "a:1:{i:1;a:1:{i:0;s:… #> 10 27 201.236.119.… 1.32e9 370 44 88 "a:1:{i:1;a:1:{i:0;s:… #> # … with 779 more rows #> #> $orig_warn_logs #> # A tibble: 64 x 8 #> wlog_id wlog_mid wlog_notes wlog_contact wlog_contact_co… wlog_date wlog_type #> <int> <int> <chr> <chr> <chr> <int> <chr> #> 1 1 33 "a:15:{s:… none NA 1.32e9 neg #> 2 2 40 "a:15:{s:… none NA 1.32e9 neg #> 3 3 40 "a:15:{s:… none NA 1.32e9 custom #> 4 4 40 "a:15:{s:… none NA 1.32e9 custom #> 5 5 89 "a:15:{s:… none NA 1.32e9 neg #> 6 6 49 "a:15:{s:… none NA 1.32e9 neg #> 7 7 40 "a:15:{s:… none NA 1.32e9 nochan #> 8 8 40 "a:15:{s:… none NA 1.32e9 custom #> 9 14 40 "a:15:{s:… none NA 1.33e9 custom #> 10 11 40 "a:15:{s:… none NA 1.33e9 nochan #> # … with 54 more rows, and 1 more variable: wlog_addedby <int> #>im_forums_dfs#> $forums_forums #> # A tibble: 144 x 39 #> id topics posts last_post last_poster_id last_poster_name #> <int> <int> <int> <dttm> <int> <chr> #> 1 1 0 0 NA 0 NA #> 2 92 36 676 2017-10-26 21:13:19 9549 Riftbolt #> 3 2 18 475 2017-10-06 06:39:51 1 Александр Славр… #> 4 10 0 0 NA 0 NA #> 5 5 39 1680 2017-11-20 21:48:41 9288 Змајевит #> 6 7 0 0 NA 0 NA #> 7 97 72 1409 2017-08-17 00:45:31 14542 Hank Hill #> 8 90 31 762 2017-10-27 01:03:10 13771 BloodEagle #> 9 12 150 5596 2017-11-10 03:40:21 12999 Stribog #> 10 11 1740 33616 2017-11-21 02:58:31 9668 MOONLORD #> # … with 134 more rows, and 33 more variables: position <int>, use_ibc <lgl>, #> # use_html <lgl>, last_title <chr>, last_id <int>, sort_order <chr>, #> # prune <int>, topicfilter <chr>, show_rules <lgl>, allow_poll <lgl>, #> # allow_pollbump <lgl>, inc_postcount <lgl>, skin_id <lgl>, parent_id <int>, #> # notify_modq_emails <chr>, sub_can_post <lgl>, permission_showtopic <lgl>, #> # forum_allow_rating <lgl>, forum_last_deletion <int>, newest_title <chr>, #> # newest_id <int>, can_view_others <lgl>, name_seo <chr>, #> # seo_last_title <chr>, seo_last_name <chr>, last_x_topic_ids <chr>, #> # forums_bitoptions <int>, disable_sharelinks <lgl>, deleted_topics <lgl>, #> # viglink <lgl>, qa_rate_questions <chr>, qa_rate_answers <chr>, icon <chr> #> #> $forums_posts #> # A tibble: 195,128 x 15 #> pid append_edit edit_time author_id author_name ip_address #> <int> <lgl> <dttm> <int> <chr> <chr> #> 1 202 FALSE NA 7 MoonmanKKK 81.141.31… #> 2 203 FALSE NA 16 Talleyrand 152.33.58… #> 3 532 FALSE 2011-09-19 23:14:09 5 Will to Po… 90.219.24… #> 4 114067 FALSE NA 7508 RIGHT WING… 80.212.44… #> 5 114068 FALSE 2015-05-16 18:07:42 0 Nihonjin M… 73.222.21… #> 6 114069 FALSE 2015-05-16 19:12:42 7481 ¡VIVA LA R… 86.181.21… #> 7 114070 FALSE NA 9144 Neizbezhno… 121.215.1… #> 8 114071 FALSE NA 6321 Culius Jae… 65.28.106… #> 9 4 FALSE NA 1 Alexander … 178.140.1… #> 10 83 FALSE NA 16 Talleyrand 152.33.17… #> # … with 195,118 more rows, and 9 more variables: post_date <dttm>, post <chr>, #> # queued <int>, topic_id <int>, new_topic <lgl>, edit_name <chr>, #> # post_key <chr>, post_edit_reason <chr>, pdelete_time <dttm> #> #> $forums_topics #> # A tibble: 7,168 x 25 #> tid title state posts starter_id start_date last_poster_id #> <int> <chr> <chr> <int> <int> <dttm> <int> #> 1 5182 Heil… clos… 9 0 2015-05-20 07:29:54 7504 #> 2 3 The … clos… 51 1 2011-09-13 01:06:06 16 #> 3 3674 “Non… open 12 7346 2014-03-01 23:36:53 49 #> 4 7 Supp… clos… 1 1 2011-09-13 09:47:48 1 #> 5 8 What… clos… 1 1 2011-09-13 09:52:23 1 #> 6 9 What… clos… 1 1 2011-09-13 09:55:16 1 #> 7 5167 The … open 14 6321 2015-05-16 18:16:41 6269 #> 8 5168 Chin… open 20 7508 2015-05-16 22:42:30 7508 #> 9 11 Rage… open 833 1 2011-09-13 10:23:27 14238 #> 10 4306 Volg… open 3 1 2014-09-22 19:22:56 1 #> # … with 7,158 more rows, and 18 more variables: last_post <dttm>, #> # icon_id <lgl>, starter_name <chr>, last_poster_name <chr>, #> # poll_state <chr>, last_vote <int>, views <int>, forum_id <int>, #> # approved <int>, author_mode <lgl>, pinned <lgl>, topic_firstpost <int>, #> # topic_rating_total <int>, topic_rating_hits <int>, title_seo <chr>, #> # last_real_post <dttm>, popular_time <int>, topic_hiddenposts <int> #>im_other_dfs#> $bbcode_mediatag #> # A tibble: 9 x 4 #> mediatag_id mediatag_name mediatag_match mediatag_replace #> <int> <chr> <chr> <chr> #> 1 1 YouTube "http(?:s)?://(www.)?yo… "<iframe id=\"ytplayer\" … #> 2 9 GameTrailers "http://www.gametrailer… "<embed src=\"http://medi… #> 3 2 Flash Movie/G… "{1}.swf" "<embed src=\"$1.swf\" pl… #> 4 3 Google Video "http://video.google.co… "<embed style=\"width:400… #> 5 4 MySpace Video "http://www.myspace.com… "<object width=\"425px\" … #> 6 10 YouTu.be "http://(www.)?youtu.be… "<iframe id=\"ytplayer\" … #> 7 6 Flickr Image … "http://www.flickr.com/… "<iframe align=\"center\"… #> 8 7 MP3 "{1}.mp3" "<object type=\"applicati… #> 9 8 Vimeo "http{1}://vimeo.com/{2… "<iframe src=\"http$1://p… #> #> $calendar_calendars #> # A tibble: 12 x 4 #> cal_id cal_position cal_title_seo cal_color #> <int> <int> <chr> <chr> #> 1 1 5 italian-nationalist-calendar #000000 #> 2 2 8 serbian-nationalist-calendar #0050a1 #> 3 3 6 russian-nationalist-calendar #c2c2c2 #> 4 4 10 orthodox-christian-calendar #d4a900 #> 5 5 11 catholic-christian-calendar #6e4f99 #> 6 6 4 greek-nationalist-calendar #0091ff #> 7 7 3 german-nationalist-calendar #e60000 #> 8 8 1 american-nationalist-calendar #17d4cd #> 9 9 12 uncategorized-dates #667070 #> 10 10 7 romanian-nationalist-calendar #249637 #> 11 11 2 british-nationalist-calendar #514999 #> 12 12 9 spanish-nationalist-calendar #eb9500 #> #> $calendar_event_comments #> # A tibble: 170 x 10 #> comment_id comment_eid comment_mid comment_date comment_text #> <int> <int> <int> <dttm> <chr> #> 1 1 150 7636 2016-03-30 12:25:46 "<p>\n\tArr… #> 2 2 150 7508 2016-04-01 19:17:45 "<p>\n\tIt'… #> 3 3 150 0 2016-04-01 21:15:34 "<p>\n\tHav… #> 4 4 154 7636 2016-04-17 13:36:49 "<p>\n\tRes… #> 5 5 147 9876 2016-04-20 05:24:10 "\n<p>\n\tI… #> 6 6 147 9621 2016-04-20 06:37:56 "\n<p>\n\t<… #> 7 7 147 4873 2016-04-20 07:02:33 "\n<p>\n\tH… #> 8 8 147 9679 2016-04-20 07:09:12 "<p>\n\twha… #> 9 9 147 9510 2016-04-20 14:22:09 "\n<blockqu… #> 10 10 147 9519 2016-04-20 17:10:30 "<p>\n\tRIP… #> # … with 160 more rows, and 5 more variables: comment_append_edit <lgl>, #> # comment_edit_time <int>, comment_edit_name <chr>, comment_ip_address <chr>, #> # comment_author <chr> #> #> $calendar_events #> # A tibble: 277 x 28 #> event_id event_calendar_… event_member_id event_content event_title #> <int> <int> <int> <chr> <chr> #> 1 1 7 1 "\n<p>\n\t<a… Joseph Goe… #> 2 2 1 1 "\n<p>\n\t<a… Niccolò Ma… #> 3 3 7 1 "\n<p>\n\t<a… Oswald Spe… #> 4 4 7 1 "\n<p>\n\t<a… Oswald Spe… #> 5 5 1 1 "\n<p>\n\t<a… Julius Evo… #> 6 6 1 1 "\n<p>\n\tNi… Niccolò Ma… #> 7 7 9 1 "\n<p>\n\t<a… Summer Sol… #> 8 8 7 1 "\n<p>\n\t<a… Martin Bor… #> 9 9 9 1 "\n<p>\n\t<a… Fidél Pálf… #> 10 10 7 1 "\n<p>\n\t<a… Baldur von… #> # … with 267 more rows, and 23 more variables: event_comments <int>, #> # event_approved <lgl>, event_saved <dttm>, event_lastupdated <dttm>, #> # event_recurring <chr>, event_start_date <dttm>, event_end_date <dttm>, #> # event_title_seo <chr>, event_rating <int>, event_post_key <chr>, #> # event_sequence <lgl>, event_all_day <lgl>, event_ip_address <chr>, #> # event_last_comment <dttm>, event_last_review <dttm>, #> # event_approved_by <int64>, event_approved_on <dttm>, event_location <chr>, #> # event_rsvp_limit <int>, event_cover_photo <chr>, event_cover_offset <int>, #> # event_unapproved_reviews <lgl>, event_hidden_reviews <lgl> #> #> $custom_bbcode #> # A tibble: 34 x 16 #> bbcode_id bbcode_title bbcode_desc bbcode_tag bbcode_replace bbcode_useoption #> <int> <chr> <chr> <chr> <chr> <lgl> #> 1 1 Post Snap B… This tag d… snapback NA FALSE #> 2 2 Right Aligns con… right "<p class='bb… FALSE #> 3 3 Left Aligns con… left "<p class='bb… FALSE #> 4 4 Center Aligns con… center "<p class='bb… FALSE #> 5 5 Topic Link This tag p… topic "<a href='{ba… TRUE #> 6 6 Post Link This tag p… post "<a href='{ba… TRUE #> 7 7 Spoiler Spoiler tag spoiler "<div class='… FALSE #> 8 8 Acronym Allows you… acronym "<acronym tit… TRUE #> 9 9 Bold Text Makes text… b "<strong clas… FALSE #> 10 10 Italic Text Makes the … i "<em class='b… FALSE #> # … with 24 more rows, and 10 more variables: bbcode_example <chr>, #> # bbcode_menu_option_text <chr>, bbcode_menu_content_text <chr>, #> # bbcode_single_tag <lgl>, bbcode_php_plugin <chr>, bbcode_no_parsing <lgl>, #> # bbcode_protected <lgl>, bbcode_aliases <chr>, bbcode_optional_option <lgl>, #> # bbcode_image <chr> #> #> $rc_reports_index #> # A tibble: 23 x 14 #> id uid title url rc_class updated_by date_updated date_created exdat1 #> <int> <chr> <chr> <chr> <int> <int> <int> <int> <int> #> 1 1 0b3a… Why … /ind… 2 9 1324720676 1324684384 57 #> 2 10 d94e… Worl… /ind… 2 4 1356645256 1356640292 22 #> 3 14 4007… Oper… /ind… 2 1 1361248006 1361245960 4 #> 4 58 264d… IRA … /ind… 2 1 1374646833 1374646450 9 #> 5 66 cd32… Jews… /ind… 2 4 1377095062 1377089209 8 #> 6 69 933f… Belg… /ind… 2 16 1380356859 1380356286 8 #> 7 70 3a36… Belg… /ind… 2 16 1380356859 1380356292 8 #> 8 74 9ca0… Gabo… /ind… 2 4 1388663494 1388660127 9 #> 9 89 7b4b… Libe… /ind… 2 2170 1431658980 1431533699 30 #> 10 90 f557… Iron… /ind… 2 2170 1432309218 1432177523 2 #> # … with 13 more rows, and 5 more variables: exdat2 <int>, exdat3 <int>, #> # num_comments <int>, seoname <chr>, seotemplate <chr> #> #> $x_utf_convert_session_tables #> # A tibble: 152 x 2 #> table_name table_schema #> <chr> <chr> #> 1 admin_login_logs "{\"name\":\"admin_login_logs\",\"definition\":{\"name\":… #> 2 admin_logs "{\"name\":\"admin_logs\",\"definition\":{\"name\":\"admi… #> 3 admin_permission_… "{\"name\":\"admin_permission_rows\",\"definition\":{\"na… #> 4 announcements "{\"name\":\"announcements\",\"definition\":{\"name\":\"a… #> 5 api_log "{\"name\":\"api_log\",\"definition\":{\"name\":\"api_log… #> 6 api_users "{\"name\":\"api_users\",\"definition\":{\"name\":\"api_u… #> 7 attachments "{\"name\":\"attachments\",\"definition\":{\"name\":\"att… #> 8 attachments_type "{\"name\":\"attachments_type\",\"definition\":{\"name\":… #> 9 backup_log "{\"name\":\"backup_log\",\"definition\":{\"name\":\"back… #> 10 backup_queue "{\"name\":\"backup_queue\",\"definition\":{\"name\":\"ba… #> # … with 142 more rows #>im_other_dfs#> $bbcode_mediatag #> # A tibble: 9 x 4 #> mediatag_id mediatag_name mediatag_match mediatag_replace #> <int> <chr> <chr> <chr> #> 1 1 YouTube "http(?:s)?://(www.)?yo… "<iframe id=\"ytplayer\" … #> 2 9 GameTrailers "http://www.gametrailer… "<embed src=\"http://medi… #> 3 2 Flash Movie/G… "{1}.swf" "<embed src=\"$1.swf\" pl… #> 4 3 Google Video "http://video.google.co… "<embed style=\"width:400… #> 5 4 MySpace Video "http://www.myspace.com… "<object width=\"425px\" … #> 6 10 YouTu.be "http://(www.)?youtu.be… "<iframe id=\"ytplayer\" … #> 7 6 Flickr Image … "http://www.flickr.com/… "<iframe align=\"center\"… #> 8 7 MP3 "{1}.mp3" "<object type=\"applicati… #> 9 8 Vimeo "http{1}://vimeo.com/{2… "<iframe src=\"http$1://p… #> #> $calendar_calendars #> # A tibble: 12 x 4 #> cal_id cal_position cal_title_seo cal_color #> <int> <int> <chr> <chr> #> 1 1 5 italian-nationalist-calendar #000000 #> 2 2 8 serbian-nationalist-calendar #0050a1 #> 3 3 6 russian-nationalist-calendar #c2c2c2 #> 4 4 10 orthodox-christian-calendar #d4a900 #> 5 5 11 catholic-christian-calendar #6e4f99 #> 6 6 4 greek-nationalist-calendar #0091ff #> 7 7 3 german-nationalist-calendar #e60000 #> 8 8 1 american-nationalist-calendar #17d4cd #> 9 9 12 uncategorized-dates #667070 #> 10 10 7 romanian-nationalist-calendar #249637 #> 11 11 2 british-nationalist-calendar #514999 #> 12 12 9 spanish-nationalist-calendar #eb9500 #> #> $calendar_event_comments #> # A tibble: 170 x 10 #> comment_id comment_eid comment_mid comment_date comment_text #> <int> <int> <int> <dttm> <chr> #> 1 1 150 7636 2016-03-30 12:25:46 "<p>\n\tArr… #> 2 2 150 7508 2016-04-01 19:17:45 "<p>\n\tIt'… #> 3 3 150 0 2016-04-01 21:15:34 "<p>\n\tHav… #> 4 4 154 7636 2016-04-17 13:36:49 "<p>\n\tRes… #> 5 5 147 9876 2016-04-20 05:24:10 "\n<p>\n\tI… #> 6 6 147 9621 2016-04-20 06:37:56 "\n<p>\n\t<… #> 7 7 147 4873 2016-04-20 07:02:33 "\n<p>\n\tH… #> 8 8 147 9679 2016-04-20 07:09:12 "<p>\n\twha… #> 9 9 147 9510 2016-04-20 14:22:09 "\n<blockqu… #> 10 10 147 9519 2016-04-20 17:10:30 "<p>\n\tRIP… #> # … with 160 more rows, and 5 more variables: comment_append_edit <lgl>, #> # comment_edit_time <int>, comment_edit_name <chr>, comment_ip_address <chr>, #> # comment_author <chr> #> #> $calendar_events #> # A tibble: 277 x 28 #> event_id event_calendar_… event_member_id event_content event_title #> <int> <int> <int> <chr> <chr> #> 1 1 7 1 "\n<p>\n\t<a… Joseph Goe… #> 2 2 1 1 "\n<p>\n\t<a… Niccolò Ma… #> 3 3 7 1 "\n<p>\n\t<a… Oswald Spe… #> 4 4 7 1 "\n<p>\n\t<a… Oswald Spe… #> 5 5 1 1 "\n<p>\n\t<a… Julius Evo… #> 6 6 1 1 "\n<p>\n\tNi… Niccolò Ma… #> 7 7 9 1 "\n<p>\n\t<a… Summer Sol… #> 8 8 7 1 "\n<p>\n\t<a… Martin Bor… #> 9 9 9 1 "\n<p>\n\t<a… Fidél Pálf… #> 10 10 7 1 "\n<p>\n\t<a… Baldur von… #> # … with 267 more rows, and 23 more variables: event_comments <int>, #> # event_approved <lgl>, event_saved <dttm>, event_lastupdated <dttm>, #> # event_recurring <chr>, event_start_date <dttm>, event_end_date <dttm>, #> # event_title_seo <chr>, event_rating <int>, event_post_key <chr>, #> # event_sequence <lgl>, event_all_day <lgl>, event_ip_address <chr>, #> # event_last_comment <dttm>, event_last_review <dttm>, #> # event_approved_by <int64>, event_approved_on <dttm>, event_location <chr>, #> # event_rsvp_limit <int>, event_cover_photo <chr>, event_cover_offset <int>, #> # event_unapproved_reviews <lgl>, event_hidden_reviews <lgl> #> #> $custom_bbcode #> # A tibble: 34 x 16 #> bbcode_id bbcode_title bbcode_desc bbcode_tag bbcode_replace bbcode_useoption #> <int> <chr> <chr> <chr> <chr> <lgl> #> 1 1 Post Snap B… This tag d… snapback NA FALSE #> 2 2 Right Aligns con… right "<p class='bb… FALSE #> 3 3 Left Aligns con… left "<p class='bb… FALSE #> 4 4 Center Aligns con… center "<p class='bb… FALSE #> 5 5 Topic Link This tag p… topic "<a href='{ba… TRUE #> 6 6 Post Link This tag p… post "<a href='{ba… TRUE #> 7 7 Spoiler Spoiler tag spoiler "<div class='… FALSE #> 8 8 Acronym Allows you… acronym "<acronym tit… TRUE #> 9 9 Bold Text Makes text… b "<strong clas… FALSE #> 10 10 Italic Text Makes the … i "<em class='b… FALSE #> # … with 24 more rows, and 10 more variables: bbcode_example <chr>, #> # bbcode_menu_option_text <chr>, bbcode_menu_content_text <chr>, #> # bbcode_single_tag <lgl>, bbcode_php_plugin <chr>, bbcode_no_parsing <lgl>, #> # bbcode_protected <lgl>, bbcode_aliases <chr>, bbcode_optional_option <lgl>, #> # bbcode_image <chr> #> #> $rc_reports_index #> # A tibble: 23 x 14 #> id uid title url rc_class updated_by date_updated date_created exdat1 #> <int> <chr> <chr> <chr> <int> <int> <int> <int> <int> #> 1 1 0b3a… Why … /ind… 2 9 1324720676 1324684384 57 #> 2 10 d94e… Worl… /ind… 2 4 1356645256 1356640292 22 #> 3 14 4007… Oper… /ind… 2 1 1361248006 1361245960 4 #> 4 58 264d… IRA … /ind… 2 1 1374646833 1374646450 9 #> 5 66 cd32… Jews… /ind… 2 4 1377095062 1377089209 8 #> 6 69 933f… Belg… /ind… 2 16 1380356859 1380356286 8 #> 7 70 3a36… Belg… /ind… 2 16 1380356859 1380356292 8 #> 8 74 9ca0… Gabo… /ind… 2 4 1388663494 1388660127 9 #> 9 89 7b4b… Libe… /ind… 2 2170 1431658980 1431533699 30 #> 10 90 f557… Iron… /ind… 2 2170 1432309218 1432177523 2 #> # … with 13 more rows, and 5 more variables: exdat2 <int>, exdat3 <int>, #> # num_comments <int>, seoname <chr>, seotemplate <chr> #> #> $x_utf_convert_session_tables #> # A tibble: 152 x 2 #> table_name table_schema #> <chr> <chr> #> 1 admin_login_logs "{\"name\":\"admin_login_logs\",\"definition\":{\"name\":… #> 2 admin_logs "{\"name\":\"admin_logs\",\"definition\":{\"name\":\"admi… #> 3 admin_permission_… "{\"name\":\"admin_permission_rows\",\"definition\":{\"na… #> 4 announcements "{\"name\":\"announcements\",\"definition\":{\"name\":\"a… #> 5 api_log "{\"name\":\"api_log\",\"definition\":{\"name\":\"api_log… #> 6 api_users "{\"name\":\"api_users\",\"definition\":{\"name\":\"api_u… #> 7 attachments "{\"name\":\"attachments\",\"definition\":{\"name\":\"att… #> 8 attachments_type "{\"name\":\"attachments_type\",\"definition\":{\"name\":… #> 9 backup_log "{\"name\":\"backup_log\",\"definition\":{\"name\":\"back… #> 10 backup_queue "{\"name\":\"backup_queue\",\"definition\":{\"name\":\"ba… #> # … with 142 more rows #>im_other_dfs#> $bbcode_mediatag #> # A tibble: 9 x 4 #> mediatag_id mediatag_name mediatag_match mediatag_replace #> <int> <chr> <chr> <chr> #> 1 1 YouTube "http(?:s)?://(www.)?yo… "<iframe id=\"ytplayer\" … #> 2 9 GameTrailers "http://www.gametrailer… "<embed src=\"http://medi… #> 3 2 Flash Movie/G… "{1}.swf" "<embed src=\"$1.swf\" pl… #> 4 3 Google Video "http://video.google.co… "<embed style=\"width:400… #> 5 4 MySpace Video "http://www.myspace.com… "<object width=\"425px\" … #> 6 10 YouTu.be "http://(www.)?youtu.be… "<iframe id=\"ytplayer\" … #> 7 6 Flickr Image … "http://www.flickr.com/… "<iframe align=\"center\"… #> 8 7 MP3 "{1}.mp3" "<object type=\"applicati… #> 9 8 Vimeo "http{1}://vimeo.com/{2… "<iframe src=\"http$1://p… #> #> $calendar_calendars #> # A tibble: 12 x 4 #> cal_id cal_position cal_title_seo cal_color #> <int> <int> <chr> <chr> #> 1 1 5 italian-nationalist-calendar #000000 #> 2 2 8 serbian-nationalist-calendar #0050a1 #> 3 3 6 russian-nationalist-calendar #c2c2c2 #> 4 4 10 orthodox-christian-calendar #d4a900 #> 5 5 11 catholic-christian-calendar #6e4f99 #> 6 6 4 greek-nationalist-calendar #0091ff #> 7 7 3 german-nationalist-calendar #e60000 #> 8 8 1 american-nationalist-calendar #17d4cd #> 9 9 12 uncategorized-dates #667070 #> 10 10 7 romanian-nationalist-calendar #249637 #> 11 11 2 british-nationalist-calendar #514999 #> 12 12 9 spanish-nationalist-calendar #eb9500 #> #> $calendar_event_comments #> # A tibble: 170 x 10 #> comment_id comment_eid comment_mid comment_date comment_text #> <int> <int> <int> <dttm> <chr> #> 1 1 150 7636 2016-03-30 12:25:46 "<p>\n\tArr… #> 2 2 150 7508 2016-04-01 19:17:45 "<p>\n\tIt'… #> 3 3 150 0 2016-04-01 21:15:34 "<p>\n\tHav… #> 4 4 154 7636 2016-04-17 13:36:49 "<p>\n\tRes… #> 5 5 147 9876 2016-04-20 05:24:10 "\n<p>\n\tI… #> 6 6 147 9621 2016-04-20 06:37:56 "\n<p>\n\t<… #> 7 7 147 4873 2016-04-20 07:02:33 "\n<p>\n\tH… #> 8 8 147 9679 2016-04-20 07:09:12 "<p>\n\twha… #> 9 9 147 9510 2016-04-20 14:22:09 "\n<blockqu… #> 10 10 147 9519 2016-04-20 17:10:30 "<p>\n\tRIP… #> # … with 160 more rows, and 5 more variables: comment_append_edit <lgl>, #> # comment_edit_time <int>, comment_edit_name <chr>, comment_ip_address <chr>, #> # comment_author <chr> #> #> $calendar_events #> # A tibble: 277 x 28 #> event_id event_calendar_… event_member_id event_content event_title #> <int> <int> <int> <chr> <chr> #> 1 1 7 1 "\n<p>\n\t<a… Joseph Goe… #> 2 2 1 1 "\n<p>\n\t<a… Niccolò Ma… #> 3 3 7 1 "\n<p>\n\t<a… Oswald Spe… #> 4 4 7 1 "\n<p>\n\t<a… Oswald Spe… #> 5 5 1 1 "\n<p>\n\t<a… Julius Evo… #> 6 6 1 1 "\n<p>\n\tNi… Niccolò Ma… #> 7 7 9 1 "\n<p>\n\t<a… Summer Sol… #> 8 8 7 1 "\n<p>\n\t<a… Martin Bor… #> 9 9 9 1 "\n<p>\n\t<a… Fidél Pálf… #> 10 10 7 1 "\n<p>\n\t<a… Baldur von… #> # … with 267 more rows, and 23 more variables: event_comments <int>, #> # event_approved <lgl>, event_saved <dttm>, event_lastupdated <dttm>, #> # event_recurring <chr>, event_start_date <dttm>, event_end_date <dttm>, #> # event_title_seo <chr>, event_rating <int>, event_post_key <chr>, #> # event_sequence <lgl>, event_all_day <lgl>, event_ip_address <chr>, #> # event_last_comment <dttm>, event_last_review <dttm>, #> # event_approved_by <int64>, event_approved_on <dttm>, event_location <chr>, #> # event_rsvp_limit <int>, event_cover_photo <chr>, event_cover_offset <int>, #> # event_unapproved_reviews <lgl>, event_hidden_reviews <lgl> #> #> $custom_bbcode #> # A tibble: 34 x 16 #> bbcode_id bbcode_title bbcode_desc bbcode_tag bbcode_replace bbcode_useoption #> <int> <chr> <chr> <chr> <chr> <lgl> #> 1 1 Post Snap B… This tag d… snapback NA FALSE #> 2 2 Right Aligns con… right "<p class='bb… FALSE #> 3 3 Left Aligns con… left "<p class='bb… FALSE #> 4 4 Center Aligns con… center "<p class='bb… FALSE #> 5 5 Topic Link This tag p… topic "<a href='{ba… TRUE #> 6 6 Post Link This tag p… post "<a href='{ba… TRUE #> 7 7 Spoiler Spoiler tag spoiler "<div class='… FALSE #> 8 8 Acronym Allows you… acronym "<acronym tit… TRUE #> 9 9 Bold Text Makes text… b "<strong clas… FALSE #> 10 10 Italic Text Makes the … i "<em class='b… FALSE #> # … with 24 more rows, and 10 more variables: bbcode_example <chr>, #> # bbcode_menu_option_text <chr>, bbcode_menu_content_text <chr>, #> # bbcode_single_tag <lgl>, bbcode_php_plugin <chr>, bbcode_no_parsing <lgl>, #> # bbcode_protected <lgl>, bbcode_aliases <chr>, bbcode_optional_option <lgl>, #> # bbcode_image <chr> #> #> $rc_reports_index #> # A tibble: 23 x 14 #> id uid title url rc_class updated_by date_updated date_created exdat1 #> <int> <chr> <chr> <chr> <int> <int> <int> <int> <int> #> 1 1 0b3a… Why … /ind… 2 9 1324720676 1324684384 57 #> 2 10 d94e… Worl… /ind… 2 4 1356645256 1356640292 22 #> 3 14 4007… Oper… /ind… 2 1 1361248006 1361245960 4 #> 4 58 264d… IRA … /ind… 2 1 1374646833 1374646450 9 #> 5 66 cd32… Jews… /ind… 2 4 1377095062 1377089209 8 #> 6 69 933f… Belg… /ind… 2 16 1380356859 1380356286 8 #> 7 70 3a36… Belg… /ind… 2 16 1380356859 1380356292 8 #> 8 74 9ca0… Gabo… /ind… 2 4 1388663494 1388660127 9 #> 9 89 7b4b… Libe… /ind… 2 2170 1431658980 1431533699 30 #> 10 90 f557… Iron… /ind… 2 2170 1432309218 1432177523 2 #> # … with 13 more rows, and 5 more variables: exdat2 <int>, exdat3 <int>, #> # num_comments <int>, seoname <chr>, seotemplate <chr> #> #> $x_utf_convert_session_tables #> # A tibble: 152 x 2 #> table_name table_schema #> <chr> <chr> #> 1 admin_login_logs "{\"name\":\"admin_login_logs\",\"definition\":{\"name\":… #> 2 admin_logs "{\"name\":\"admin_logs\",\"definition\":{\"name\":\"admi… #> 3 admin_permission_… "{\"name\":\"admin_permission_rows\",\"definition\":{\"na… #> 4 announcements "{\"name\":\"announcements\",\"definition\":{\"name\":\"a… #> 5 api_log "{\"name\":\"api_log\",\"definition\":{\"name\":\"api_log… #> 6 api_users "{\"name\":\"api_users\",\"definition\":{\"name\":\"api_u… #> 7 attachments "{\"name\":\"attachments\",\"definition\":{\"name\":\"att… #> 8 attachments_type "{\"name\":\"attachments_type\",\"definition\":{\"name\":… #> 9 backup_log "{\"name\":\"backup_log\",\"definition\":{\"name\":\"back… #> 10 backup_queue "{\"name\":\"backup_queue\",\"definition\":{\"name\":\"ba… #> # … with 142 more rows #>