03-03-2025, 12:07 PM
SNJRP.EE Grand Theft Auto Roleplaying Forum Database Leak
Leak Date: February 28, 2025
Total Data Volume: 1612 rows in `ipb_core_members`, 22932 rows in `ipb_forums_posts`, 1890 rows in `ipb_forums_topics`
File Type: SQL
File Size: 245 MB
Organization Overview:
SNJRP.EE is a forum and associated roleplaying server for Grand Theft Auto. The "EE" part of the name is related to the server name, not the country. The forum is used for server announcements, community discussions, and roleplaying coordination.
Country: Unknown (server location unknown; "EE" is part of the name)
Website: https://snjrp.ee/
Leak Information:
Exposed fields include data from the `ipb_core_members`, `ipb_forums_posts`, and `ipb_forums_topics` tables:
`ipb_core_members` table: member_id, name, member_group_id, email, joined, ip_address, skin, warn_level, warn_lastwarn, language, restrict_post, bday_day, bday_month, bday_year (birthdate), msg_count_new, msg_count_total, msg_count_reset, msg_show_notification, last_visit, last_activity, mod_posts, auto_track, temp_ban, mgroup_others, members_seo_name, members_cache, failed_logins, failed_login_count, members_profile_views, members_pass_hash (password hash), members_pass_salt (password salt), members_bitoptions, members_day_posts, notification_cnt, pp_last_visitors, pp_main_photo, pp_main_width, pp_main_height, pp_thumb_photo, pp_thumb_width, pp_thumb_height, pp_setting_count_comments, pp_reputation_points, pp_photo_type, signature, pconversation_filters, pp_customization, timezone, pp_cover_photo, profilesync, profilesync_lastsync, allow_admin_mails, members_bitoptions2, members_disable_pm, marked_site_read, pp_cover_offset, acp_language, member_title, member_posts, member_last_post, member_streams, photo_last_update, mfa_details, failed_mfa_attempts, permission_array, completed, cm_credits, cm_return_group, award_sort, award_order, award_member_show, idm_block_submissions, conv_password, conv_password_extra, steamid, synced_password, synced_rptest, achievements_points, unique_hash, latest_alert, expert_nudge, layouts, cm_no_sev
`ipb_forums_posts` table: pid, append_edit, edit_time, author_id, author_name, ip_address, post_date, post (post content), queued, topic_id, new_topic, edit_name, post_key, post_htmlstate, post_edit_reason, post_bwoptions, pdelete_time, post_field_int, post_field_t1, post_field_t2, post_score, post_score_last_event, post_share_count, post_quote_count, post_linked_count, post_reaction_count, post_view_time, post_view_time_view_count, post_force_in_summary, post_embed_count, post_featured, post_helpful_count
`ipb_forums_topics` table: tid, title, state, posts, starter_id, start_date, last_poster_id, last_post, starter_name, last_poster_name, poll_state, last_vote, views, forum_id, approved, author_mode, pinned, moved_to, topic_firstpost, topic_queuedposts, topic_open_time, topic_close_time, topic_rating_total, topic_rating_hits, title_seo, moved_on, topic_archive_status, last_real_post, topic_answered_pid, featured, question_rating, topic_hiddenposts, topic_meta_data, is_anon, last_poster_anon, is_future_entry, publish_date, solved_reminder_sent, topic_post_score_average, topic_summary_date, assignment_id
Sample Data:
`ipb_core_members` table:
1. member_id: 1 | name: Kenth | email: ragnarvidevik@gmail.com | ip_address: 2001:1530:1016:2d96:44b:9593:583f:141d | member_group_id: 4 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$wKuPvQLIcxYN67.jR06x2.3UsM.5tqye2N8vzTH4OsKAQUDRHUDru | bday_day: NULL | bday_month: NULL | bday_year: NULL
2. member_id: 92 | name: Caupo | email: helvikcaupo@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: UTC | signature: <p><a href="toolsfortext.com" rel="">toolsfortext.com</a></p><p>\n<a href="percentcalc.net" rel="">percentcalc.net</a></p><p>\n<a href="jaanituled.ee" rel="">jaanituled.ee</a></p><p>\n<a href="downloadmorehdd.com" rel="">downloadmorehdd.com</a></p><p>\n<a href="fetchmyip.com" rel="">fetchmyip.com</a></p><p>В </p><p>\n<img alt="regular-banner-4.png" src="https://rust-servers.net/server/143970/banners/regular-banner-4.png" loading="lazy"></p> | members_pass_hash: $2y$10$I42BtJitwln3bP53ujTyJems/SQPRO339vqrrymDrdFIeCXbaSWrO | bday_day: 19 | bday_month: 3 | bday_year: 1993
3. member_id: 93 | name: Lumi | email: lumi.psfx@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$7LpH3CmmDfbnDz784S4y2e8lE7nvyMX4ScuRjTuLDWLCszRydsOwS | bday_day: 0 | bday_month: 0 | bday_year: NULL
4. member_id: 98 | name: eQuaLG | email: elvisjuus@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$QiV7ct.83kE7Zis2avTfzusIKsx5IO7MPp0GiKzrJ.78lHIZVPkSq | bday_day: 0 | bday_month: 0 | bday_year: NULL
`ipb_forums_posts` table:
5. pid: 36018 | author_name: Nuki | ip_address: 162.158.134.97 | post_date: 1614094424 | post: Müügiks tänavapildis vähe erilisem Blista. Olen sõidukil ainuke omanik olnud ja sisse pannud palju aega ja raha.... (Selling a slightly more unique Blista in street view. I have been the only owner of the vehicle and has put in a lot of time and money...)
6. pid: 36019 | author_name: MaxTract | ip_address: 172.69.138.13 | post_date: 1614095264 | post: Pakun 100,000 teie masina eest, kui teile hind sobib siis vГµtke Гјhendust.... (I offer 100,000 for your machine, if the price suits you then contact me...)
7. pid: 36020 | author_name: Albert | ip_address: 162.158.134.79 | post_date: 1614100160 | post: Tervist! MГјГјn oma vana head maja, mis asub aadressil Red County 36. Majal on Гјmber aed ning on olemas isiklik paadisild.... (Hello! I am selling my good old house, located at Red County 36. The house has a garden around it and has a private boat bridge...)
8. pid: 36025 | author_name: kri | ip_address: 162.158.134.56 | post_date: 1614104696 | post: <img class="ipsImage" alt="eGrU2vu.png" src="https://i.imgur.com/eGrU2vu.png" loading="lazy"> <span style="background-color:#2e3035;color:#ffffff;font-size:16px;"><img class="ipsImage" alt="eqj2odi.png" src="https://i.imgur.com/eqj2odi.png" loading="lazy"></span>
`ipb_forums_topics` table:
9. tid: 4014 | title: Hilltop Logistics | state: closed | starter_name: catchya | last_poster_name: catchya
10. tid: 4015 | title: Reegli muudatus (kuulivest) | state: closed | starter_name: hyena | last_poster_name: Orange (Rule Change (Bulletproof Vest))
11. tid: 4016 | title: Huvide konflikt | state: closed | starter_name: Orange | last_poster_name: abyssa (Conflict of Interest)
12. tid: 4021 | title: Cars and Coffee | state: closed | starter_name: mentaliteet | last_poster_name: kri
Leak Date: February 28, 2025
Total Data Volume: 1612 rows in `ipb_core_members`, 22932 rows in `ipb_forums_posts`, 1890 rows in `ipb_forums_topics`
File Type: SQL
File Size: 245 MB
Organization Overview:
SNJRP.EE is a forum and associated roleplaying server for Grand Theft Auto. The "EE" part of the name is related to the server name, not the country. The forum is used for server announcements, community discussions, and roleplaying coordination.
Country: Unknown (server location unknown; "EE" is part of the name)
Website: https://snjrp.ee/
Leak Information:
Exposed fields include data from the `ipb_core_members`, `ipb_forums_posts`, and `ipb_forums_topics` tables:
`ipb_core_members` table: member_id, name, member_group_id, email, joined, ip_address, skin, warn_level, warn_lastwarn, language, restrict_post, bday_day, bday_month, bday_year (birthdate), msg_count_new, msg_count_total, msg_count_reset, msg_show_notification, last_visit, last_activity, mod_posts, auto_track, temp_ban, mgroup_others, members_seo_name, members_cache, failed_logins, failed_login_count, members_profile_views, members_pass_hash (password hash), members_pass_salt (password salt), members_bitoptions, members_day_posts, notification_cnt, pp_last_visitors, pp_main_photo, pp_main_width, pp_main_height, pp_thumb_photo, pp_thumb_width, pp_thumb_height, pp_setting_count_comments, pp_reputation_points, pp_photo_type, signature, pconversation_filters, pp_customization, timezone, pp_cover_photo, profilesync, profilesync_lastsync, allow_admin_mails, members_bitoptions2, members_disable_pm, marked_site_read, pp_cover_offset, acp_language, member_title, member_posts, member_last_post, member_streams, photo_last_update, mfa_details, failed_mfa_attempts, permission_array, completed, cm_credits, cm_return_group, award_sort, award_order, award_member_show, idm_block_submissions, conv_password, conv_password_extra, steamid, synced_password, synced_rptest, achievements_points, unique_hash, latest_alert, expert_nudge, layouts, cm_no_sev
`ipb_forums_posts` table: pid, append_edit, edit_time, author_id, author_name, ip_address, post_date, post (post content), queued, topic_id, new_topic, edit_name, post_key, post_htmlstate, post_edit_reason, post_bwoptions, pdelete_time, post_field_int, post_field_t1, post_field_t2, post_score, post_score_last_event, post_share_count, post_quote_count, post_linked_count, post_reaction_count, post_view_time, post_view_time_view_count, post_force_in_summary, post_embed_count, post_featured, post_helpful_count
`ipb_forums_topics` table: tid, title, state, posts, starter_id, start_date, last_poster_id, last_post, starter_name, last_poster_name, poll_state, last_vote, views, forum_id, approved, author_mode, pinned, moved_to, topic_firstpost, topic_queuedposts, topic_open_time, topic_close_time, topic_rating_total, topic_rating_hits, title_seo, moved_on, topic_archive_status, last_real_post, topic_answered_pid, featured, question_rating, topic_hiddenposts, topic_meta_data, is_anon, last_poster_anon, is_future_entry, publish_date, solved_reminder_sent, topic_post_score_average, topic_summary_date, assignment_id
Sample Data:
`ipb_core_members` table:
1. member_id: 1 | name: Kenth | email: ragnarvidevik@gmail.com | ip_address: 2001:1530:1016:2d96:44b:9593:583f:141d | member_group_id: 4 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$wKuPvQLIcxYN67.jR06x2.3UsM.5tqye2N8vzTH4OsKAQUDRHUDru | bday_day: NULL | bday_month: NULL | bday_year: NULL
2. member_id: 92 | name: Caupo | email: helvikcaupo@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: UTC | signature: <p><a href="toolsfortext.com" rel="">toolsfortext.com</a></p><p>\n<a href="percentcalc.net" rel="">percentcalc.net</a></p><p>\n<a href="jaanituled.ee" rel="">jaanituled.ee</a></p><p>\n<a href="downloadmorehdd.com" rel="">downloadmorehdd.com</a></p><p>\n<a href="fetchmyip.com" rel="">fetchmyip.com</a></p><p>В </p><p>\n<img alt="regular-banner-4.png" src="https://rust-servers.net/server/143970/banners/regular-banner-4.png" loading="lazy"></p> | members_pass_hash: $2y$10$I42BtJitwln3bP53ujTyJems/SQPRO339vqrrymDrdFIeCXbaSWrO | bday_day: 19 | bday_month: 3 | bday_year: 1993
3. member_id: 93 | name: Lumi | email: lumi.psfx@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$7LpH3CmmDfbnDz784S4y2e8lE7nvyMX4ScuRjTuLDWLCszRydsOwS | bday_day: 0 | bday_month: 0 | bday_year: NULL
4. member_id: 98 | name: eQuaLG | email: elvisjuus@gmail.com | ip_address: 127.0.0.1 | member_group_id: 3 | timezone: Europe/Tallinn | members_pass_hash: $2y$10$QiV7ct.83kE7Zis2avTfzusIKsx5IO7MPp0GiKzrJ.78lHIZVPkSq | bday_day: 0 | bday_month: 0 | bday_year: NULL
`ipb_forums_posts` table:
5. pid: 36018 | author_name: Nuki | ip_address: 162.158.134.97 | post_date: 1614094424 | post: Müügiks tänavapildis vähe erilisem Blista. Olen sõidukil ainuke omanik olnud ja sisse pannud palju aega ja raha.... (Selling a slightly more unique Blista in street view. I have been the only owner of the vehicle and has put in a lot of time and money...)
6. pid: 36019 | author_name: MaxTract | ip_address: 172.69.138.13 | post_date: 1614095264 | post: Pakun 100,000 teie masina eest, kui teile hind sobib siis vГµtke Гјhendust.... (I offer 100,000 for your machine, if the price suits you then contact me...)
7. pid: 36020 | author_name: Albert | ip_address: 162.158.134.79 | post_date: 1614100160 | post: Tervist! MГјГјn oma vana head maja, mis asub aadressil Red County 36. Majal on Гјmber aed ning on olemas isiklik paadisild.... (Hello! I am selling my good old house, located at Red County 36. The house has a garden around it and has a private boat bridge...)
8. pid: 36025 | author_name: kri | ip_address: 162.158.134.56 | post_date: 1614104696 | post: <img class="ipsImage" alt="eGrU2vu.png" src="https://i.imgur.com/eGrU2vu.png" loading="lazy"> <span style="background-color:#2e3035;color:#ffffff;font-size:16px;"><img class="ipsImage" alt="eqj2odi.png" src="https://i.imgur.com/eqj2odi.png" loading="lazy"></span>
`ipb_forums_topics` table:
9. tid: 4014 | title: Hilltop Logistics | state: closed | starter_name: catchya | last_poster_name: catchya
10. tid: 4015 | title: Reegli muudatus (kuulivest) | state: closed | starter_name: hyena | last_poster_name: Orange (Rule Change (Bulletproof Vest))
11. tid: 4016 | title: Huvide konflikt | state: closed | starter_name: Orange | last_poster_name: abyssa (Conflict of Interest)
12. tid: 4021 | title: Cars and Coffee | state: closed | starter_name: mentaliteet | last_poster_name: kri
Ethical Security Monitoring
Publishing data is not an attack — it’s an alarm signal. The sooner the public is aware of the problem, the quicker its consequences can be mitigated.
Publishing data is not an attack — it’s an alarm signal. The sooner the public is aware of the problem, the quicker its consequences can be mitigated.