[fisha-medorow]

Hello my dears.

Here's the dump of russian social network for photographers club.foto.ru. 
There's ~600k rows from users table as postgresql dump. Be aware: it's windows-1251 encoded.
The leak date is unknown, but probably it's 2023.

COPY public.users (user_id, login, user_name, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_active, user_actkey, exp_id, level_id, self_portrait_text, equip_body, equip_lens, equip_flash, equip_film, equip_scan, photos_count, comments_count, awards_count, rating, posts_count, user_email_reserve, user_lastlogin, autologin, email_enabled, awards_given, awards_ratio, blocked, first_letter, comments_for_author_count, other_logins, date_of_birth, comments_count_ratio, regdate, block_gallery, block_forum, harakiri, gallery_marks, gallery_council_member, selected_photos_count, birth_day, show_email, settings, hide_value, clan_id, subscribers, linkpage, myclub_view_info, equip_studio, show_birthday, user_ip, user_last_update, rules, reged_from) FROM stdin;
122319 qwertyuiopasdfghjklzxcvbn _ d9f9487b11af5e7c43bdececb4c922a5 [email protected] \N \N \N \N \N \N 1 \N 1 1 {{"Canon S3 IS",22209},{"Canon PowerShot A75",11509},{"Panasonic DMC-LC20",9905},{"Canon EOS 400D",0},{"Canon 50D",0}} {{"Óâåëè÷èòåëüíàÿ ëèíçà",0},{"18-55 Kit",0},{"Canon 50/1.8",0},{"Sigma 17-70/2.8-4.5",0},{"Canon 70-200 4L",0}} {{"Canon 430EX",27848}} \N \N 0 246 99 0 1 [email protected] 2014-04-23 18:29:57 Diwnh$#6gyt47BA2sz%l*ZrS5oFxqJI3 2 177 0.718411565 1 _ 236 \N 0 2006-11-30 16:31:23 f f f a:4:{i:2;i:29;i:3;i:134;i:4;i:251;i:5;i:375;} \N 0 \N f a:51:{s:22:"gallery_works_per_page";i:15;s:26:"gallery_small_list_preview";i:0;s:28:"gallery_small_matrix_preview";s:1:"1";s:19:"gallery_matrix_view";s:1:"0";s:18:"gallery_thumb_view";i:1;s:28:"gallery_view_only_subscribed";i:0;s:24:"gallery_last_works_count";i:6;s:29:"gallery_use_croptool_features";s:1:"1";s:28:"gallery_show_hidden_comments";s:1:"1";s:21:"gallery_comment_popup";s:1:"0";s:27:"gallery_show_original_image";s:6:"as_set";s:27:"gallery_default_rating_rule";i:1;s:32:"gallery_mail_comments_by_default";i:0;s:17:"gallery_incognito";i:0;s:19:"gallery_color_marks";i:1;s:23:"gallery_marks_published";i:0;s:25:"gallery_double_thumbnails";i:0;s:32:"gallery_default_private_comments";i:0;s:32:"gallery_send_replays_on_comments";i:1;s:32:"gallery_send_replays_on_my_photo";i:1;s:21:"forum_view_topic_mode";s:4:"list";s:21:"forum_topics_per_page";i:20;s:20:"forum_posts_per_page";i:20;s:26:"forum_show_who_is_watching";i:0;s:21:"forum_watch_new_topic";i:0;s:23:"forum_watch_my_comments";s:1:"0";s:18:"forum_show_userpic";i:1;s:17:"forum_show_smiles";i:1;s:18:"forum_allow_bbcode";b:1;s:18:"forum_allow_smiles";b:1;s:15:"forum_allow_img";i:1;s:22:"club_draw_main_js_menu";i:1;s:10:"club_style";s:5:"basic";s:16:"chat_buffer_size";i:5;s:13:"reload_opener";i:1;s:24:"open_links_in_new_window";i:0;s:17:"sendmailfromrobot";i:0;s:22:"album_photo_thumb_size";i:1;s:22:"album_albums_list_view";i:1;s:21:"album_photo_view_size";i:0;s:26:"album_email_notify_comment";i:0;s:22:"album_albums_list_sort";i:0;s:28:"album_albums_list_sort_order";s:4:"DESC";s:19:"private_nosubscribe";i:1;s:11:"erotic_view";i:1;s:11:"advert_show";i:1;s:20:"photomodel_view_size";i:1;s:20:"photomodel_view_type";i:0;s:20:"photomodel_view_sort";i:0;s:24:"camera_wiev_all_comments";i:0;s:25:"secondhand_items_per_page";i:20;} a:3:{s:38:"limit_create_topics_in_registr_user_90";a:2:{i:0;s:0:"";i:1;s:0:"";}s:38:"limit_create_topics_in_registr_user_30";s:0:"";s:16:"old_new_proposal";s:19:"1917-12-03 00:00:00";} \N 3 \N [3:7]={NULL,TRUE,NULL,1,NULL} \N f \N 2019-07-11 15:09:22 0 0

Hidden Content

You must register or login to view this content.

[timi90]

how many email addresses are in there? in the preview I see probably a fake email address which is not encoded. But you got any idea?

[joepa]

about 615k emails.

---

password plain md5

[Plessy]

thx so much, i looking for it

[DmiMIn]

Thank you for that!

[Addka72424]

how many email addresses are in there? in the preview I see probably a fake email address which is not encoded. But you got any idea?

763.404 unique emails

---

how many email addresses are in there? in the preview I see probably a fake email address which is not encoded. But you got any idea?

By the way, the mail is not fake, which can be checked via - https://foto.ru/reset  (just try substituting any character in the mail and it will show you that it is not in the database, while the original email is there)

[seraf]

can't restore this dump into postgresql - it's broken. anybody had success with it?

[HassaMassa]

Thanks man, I'll be taking a look at it.