awesomeforums.net
Nov 28, 2012
Database dump of Awesome Forums (awesomeforums.net), a MyBB-based online forum. The breach contains user records including usernames, hashed passwords (MD5 with salt), email addresses, IP addresses, registration dates, and various profile/preference fields. Registration timestamps cluster around late November 2012, consistent with the site's launch or breach date.
Data found in this dataset
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
Awesome_20Forums_20DB.txt97 columns197 rows
File structure
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | skip | high | uid - auto-increment user ID column |
| 1 | username | high | column named 'username', values are human-generated login names (e.g., 'Awesome', 'Atex', 'Wizard') |
| 2 | password | high | column named 'password', values are MD5 hashes with salt (32-char hex strings) |
| 3 | skip | high | salt - cryptographic salt for password hashing, not PII |
| 4 | skip | high | loginkey - session/authentication token, not PII |
| 5 | high | column named 'email', values contain @ symbol and are email addresses (e.g., '[email protected]', '[email protected]') | |
| 6 | skip | high | postnum - post count, internal metric |
| 7 | skip | high | awards - internal forum gamification metric |
| 8 | skip | high | avatar - avatar file path, not PII |
| 9 | skip | high | avatardimensions - avatar metadata |
| 10 | skip | high | avatartype - avatar upload type metadata |
| 11 | skip | high | usergroup - internal forum group assignment |
| 12 | skip | high | additionalgroups - internal forum group assignment |
| 13 | skip | high | displaygroup - internal forum display group |
| 14 | skip | high | usertitle - user-entered profile field, not standardized PII |
| 15 | skip | high | regdate - registration timestamp (non-DOB) |
| 16 | skip | high | lastactive - last activity timestamp (non-DOB) |
| 17 | skip | high | lastvisit - last visit timestamp (non-DOB) |
| 18 | skip | high | lastpost - last post timestamp (non-DOB) |
| 19 | skip | high | website - user-entered website URL, not PII |
| 20 | username | high | icq - ICQ messaging handle, social media identifier treated as username |
| 21 | username | high | aim - AIM messaging handle, social media identifier treated as username |
| 22 | username | high | yahoo - Yahoo messenger handle, social media identifier treated as username |
| 23 | username | high | msn - MSN messenger handle, social media identifier treated as username |
| 24 | username | high | skype - Skype username, social media identifier treated as username |
| 25 | dob | high | birthday - values in DD-MM-YYYY format (e.g., '17-6-1993', '23-11-1993') |
| 26 | skip | high | birthdayprivacy - privacy preference setting, not PII |
| 27 | skip | high | signature - user-entered forum signature, not standardized PII |
| 28 | skip | high | allownotices - user preference setting |
| 29 | skip | high | hideemail - email privacy preference |
| 30 | skip | high | subscriptionmethod - user preference setting |
| 31 | skip | high | invisible - user preference setting |
| 32 | skip | high | receivepms - user preference setting |
| 33 | skip | high | receivefrombuddy - user preference setting |
| 34 | skip | high | pmnotice - user preference setting |
| 35 | skip | high | pmnotify - user preference setting |
| 36 | skip | high | threadmode - user display preference |
| 37 | skip | high | showsigs - user preference setting |
| 38 | skip | high | showavatars - user preference setting |
| 39 | skip | high | showquickreply - user preference setting |
| 40 | skip | high | showredirect - user preference setting |
| 41 | skip | high | ppp - posts per page preference |
| 42 | skip | high | tpp - threads per page preference |
| 43 | skip | high | daysprune - preference setting |
| 44 | skip | high | dateformat - user date format preference |
| 45 | skip | high | timeformat - user time format preference |
| 46 | skip | high | timezone - user timezone preference |
| 47 | skip | high | dst - daylight savings preference |
| 48 | skip | high | dstcorrection - daylight savings preference |
| 49 | skip | high | buddylist - serialized friend list, not PII |
| 50 | skip | high | ignorelist - serialized ignore list, not PII |
| 51 | skip | high | style - forum theme preference |
| 52 | skip | high | away - away status flag |
| 53 | skip | high | awaydate - away status timestamp |
| 54 | skip | high | returndate - return date timestamp |
| 55 | skip | high | awayreason - away status message, not PII |
| 56 | skip | high | pmfolders - serialized PM folder data |
| 57 | skip | high | notepad - user-entered notes, not standardized PII |
| 58 | skip | high | referrer - referral source URL |
| 59 | skip | high | referrals - referral count metric |
| 60 | skip | high | reputation - forum reputation score |
| 61 | skip | high | regip - registration IP address, not direct PII identifier in this field set |
| 62 | skip | high | lastip - last login IP address, not direct PII identifier |
| 63 | skip | high | longregip - registration IP in long format |
| 64 | skip | high | longlastip - last IP in long format |
| 65 | skip | high | language - user language preference |
| 66 | skip | high | timeonline - aggregate time online metric |
| 67 | skip | high | showcodebuttons - user preference setting |
| 68 | skip | high | totalpms - total private messages count |
| 69 | skip | high | unreadpms - unread private messages count |
| 70 | skip | high | warningpoints - forum moderation metric |
| 71 | skip | high | moderateposts - moderation flag |
| 72 | skip | high | moderationtime - moderation timestamp |
| 73 | skip | high | suspendposting - suspension status flag |
| 74 | skip | high | suspensiontime - suspension timestamp |
| 75 | skip | high | suspendsignature - signature suspension flag |
| 76 | skip | high | suspendsigtime - signature suspension timestamp |
| 77 | skip | high | coppauser - COPPA user flag |
| 78 | skip | high | classicpostbit - display preference |
| 79 | skip | high | loginattempts - security metric |
| 80 | skip | high | failedlogin - security metric |
| 81 | skip | high | usernotes - internal admin notes, not PII |
| 82 | skip | high | usemobileversion - user preference setting |
| 83 | skip | high | thx - thanks count metric |
| 84 | skip | high | thxcount - thanks count metric |
| 85 | skip | high | thxpost - thanks per post metric |
| 86 | skip | high | newpoints - forum points metric |
| 87 | skip | high | newpoints_items - serialized points data |
| 88 | skip | high | akismetstopped - anti-spam metric |
| 89 | skip | high | myalerts_settings - serialized plugin settings |
| 90 | skip | high | allowtags - user preference setting |
| 91 | skip | high | default_tab - user display preference |
| 92 | skip | high | mysb_banned - ban status flag |
| 93 | skip | high | mysb_banned_reason - ban reason, not PII |
| 94 | skip | high | mystatus_twitter_posting_enabled - plugin preference |
| 95 | skip | high | mystatus_twitter_oauth_token - authentication token |
| 96 | skip | high | mystatus_twitter_oauth_token_secret - authentication token secret |
Notes: MyBB forum user table from Awesome Forums 2012 breach. Key PII fields: username (human-generated login names), password (MD5 hashes), email, date of birth, and social messaging handles. Most columns are forum configuration, preferences, metrics, or timestamps that do not constitute PII.