Posts: 1,083
Threads: 8
Joined: Jun 2023
Thanks man, good amount here to take a look at.
Posts: 359
Threads: 16
Joined: Sep 2023
(11-07-2023, 06:43 AM)SunS Wrote: phonenumber=0
No phone data. Much less powerful
Posts: 100
Threads: 1
Joined: Sep 2023
Cool. Thank you very much for your data.
Ban reason: Leeching. (Permanent)
Posts: 32
Threads: 2
Joined: Oct 2023
I unlocked it and found that the link to your file wasn't working.
Thanks @Dev for the rank & pfp
Posts: 535
Threads: 22
Joined: Nov 2023
(11-06-2023, 02:55 AM)micheltoms Wrote: At the end of October, someone got into his database and backed up the user data tables, which I'm sharing today
It contains 109922 rows with 101790 job seekers.
Contains fields：username,email,phone,address,password...etc
have fun!
sample:-- MySQL dump 10.13 Distrib 8.0.35, for Linux (x86_64)
--
-- Host: localhost Database: yii2-gvm-prod
-- ------------------------------------------------------
-- Server version 8.0.35-0ubuntu0.20.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`auth_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`password_reset_token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`status` smallint NOT NULL DEFAULT '10',
`verification_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`website_id` int DEFAULT NULL,
`deleted_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`full_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`apartment` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zipcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company_phone_extension` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`profile_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`profile_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`chronic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lat` decimal(10,6) DEFAULT NULL,
`lng` decimal(10,6) DEFAULT NULL,
`current_job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dream_job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`resume_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`resume_updated_at` datetime DEFAULT NULL,
`cover_letter_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`cover_letter_updated_at` datetime DEFAULT NULL,
`portfolio_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`linkedin_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_not_a_blank_account_anymore_since` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`communication_language_id` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_connection` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`old_user_id_in_previous_platform` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_reset_password_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` enum('Candidate','Employer','Administrator','Author') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Candidate',
`is_agree_to_relocate` enum('No','Yes','Unknown') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
`allowed_to_work` enum('No','Yes','Unknown') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown',
`is_ready_to_work_now` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`current_job_search_status` enum('Active search','Not looking for a new job','Open to new opportunities') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active search',
`has_been_created_as_a_blank_account` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
`mfa_enabled` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
`is_subscribed_to_newsletter` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
`subscribed_to_newsletter_last_changed` datetime DEFAULT NULL,
`authentication_method` enum('Yii','WP') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Yii',
`profile_privacy` enum('Private','Public') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Public',
`heard_about_us` enum('internet','pub','other') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`heard_about_us_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_country_iso_code_alpha2` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zoho_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `password_reset_token` (`password_reset_token`),
UNIQUE KEY `unicity` (`website_id`,`email`,`type`),
KEY `user_country_foreign` (`user_country_iso_code_alpha2`),
KEY `idx_old_user_id_website_id` (`old_user_id_in_previous_platform`,`website_id`),
KEY `idx_email_website_id` (`email`,`website_id`),
CONSTRAINT `link_to_web` FOREIGN KEY (`website_id`) REFERENCES `website` (`website_id`),
CONSTRAINT `user_country_foreign` FOREIGN KEY (`user_country_iso_code_alpha2`) REFERENCES `country_iso_code` (`country_iso_code_alpha2`)
) ENGINE=InnoDB AUTO_INCREMENT=117146 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'ty7uOvGhas9lkfyoioZhYtrMzMJP0aLZ','$2y$13$eiKPDQBoj1w78PhErEeiCOVU2YCMWBeitIZwAdmffdegoagYsPHQi',NULL,'administrateur@groupevelanmedia.com',10,'E5BkTQlBud2dMlcZtRicC7ZMyVSX5UYI_1633456158','Administrateur','GVM',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2022-11-24 08:43:01',NULL,NULL,NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:18','2022-11-24 08:43:01',NULL,NULL),(2,'vvqAloSXKznT-1onZwURn2YBiV0pNsUQ','$2y$13$509o0L0EdWniywiIGYb/Wecysi7DDowVxF.HcPOvDWMmSJvKK26iS',NULL,'ndelanos@groupevelanmedia.com',10,'35IAg9tIbtgb8j-aLebR77rFdEe_kZwS_1633456159','Nicolas','Delanos',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://d1hbpr09pwz0sk.cloudfront.net/profile_pic/nicolas-delanos-ee410a18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2023-08-31 14:31:54',NULL,'13564',NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:19','2023-08-31 14:31:54',NULL,NULL),(3,'3mBvv11Zu40pPcx-nk4CCy6ejax9SqAG','$2y$13$C4aOWpLNLXJrIVGFqrVWIuM0PewTttHshLrABJdd8lmqmFamyBpyW',NULL,'michaeltherrien@groupevelanmedia.com',0,'wWaLtExapLgwdr9Bvp3DMS-Z0gfEp7IZ_1633456160','Michael','Therrien',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://media-exp1.licdn.com/dms/image/C5603AQHViPvjD0ybEg/profile-displayphoto-shrink_200_200/0/1516988744880?e=1636588800&v=beta&t=MbmJVq2V_WPUbz43uWTaG_IqcFIsLcavcCeOeLuZKLU',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','0000-00-00 00:00:00',NULL,NULL,NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:20','2022-03-07 13:11:17',NULL,NULL),(4,'EqbM-FkPa2Rft2gLWEy_-2FhZ4EflLmL','$2y$13$2VtlVVbh/ikMN2iAm68O4udxlehahBWzrD1nQgynA5QuH6EAzFS.y',NULL,'maximelewandowski00@gmail.com',10,'4cRSDlG5FEbixrOweNjzUgn34mGX0p3Z_1633456160','Maxime','Leveille-Lewandowski',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2023-08-10 16:12:45',NULL,'103',NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:20','2023-08-10 16:12:45',NULL,NULL),(5,'F3bOTarAiqeyem30f8rjZ9GFQtyt897q','$2y$13$f9VnU6CQhl964RMJsyBVmOGJbGCazf2pExoWFI.Su1GLP60bYaIzi',NULL,'edouard.salembier@groupevelanmedia.com',10,'lnpTcbcYCtq05Jom9zNsHOelCeyPWhI-_1633456161','Edouard','Salembier',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://media-exp1.licdn.com/dms/image/C5603AQEQE3apvU1a4w/profile-displayphoto-shrink_200_200/0/1579536794548?e=1636588800&v=beta&t=_EZ8FUHNr6IBHkkv9OPLk49ZaXd7Bog7W2bOsTYYtC4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2023-01-09 11:16:51',NULL,NULL,NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:21','2023-01-09 11:16:51',NULL,NULL),(6,'setPXYSeZURKM0KkTg235cyNQJK9EbjG','$2y$13$nTSEt1g85VD/y4MpQ2Nc2uGRVIj6IZSgKzKcUX5KaNRX0EavSUsMO',NULL,'veronique.lewandowski@groupevelanmedia.com',10,'YDymcmcUv9WnB5bHH0HS4atIDBsIXotf_1633456161','Veronique','Lewandowski',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2023-09-06 13:50:00',NULL,'15931',NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:21','2023-09-06 13:50:00',NULL,NULL),(7,'GphIg3nzkfsC9qavDQY1f719frFlwCJm','$2y$13$9th9qWNLWwj.2FOVmHOMLum6uLRiUQnWPJ1Gl9FjV853r3QEnJYd6',NULL,'xavier.dunn-beauchesne@groupevelanmedia.com',0,'GgmZPb9rT-C8SZHA3ui0yOk2XAgku0Ye_1633456162','Xavier','Dunn-Beauchesne',6,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2022-12-16 10:44:21',NULL,NULL,NULL,'Administrator','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:22','2023-01-18 06:04:00',NULL,NULL),(8,'FE8VWN7-upgSI7o2OjNWaLxTNlMTeTz7','$2y$13$qFPHGuLJ27g9ZpWKY5r7seflKRmoTkSU4sI2QfN/0RqW.MGdCNBHm',NULL,'jobseeker@groupevelanmedia.com',10,'aSmIMtEVQDlav1EnbweM5i6UH4kFL3Ae_1633456163','John','Doe',4,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/home/it/apps/yii2-gvm/storage/private/gi/resume/53413b2b77386d7c96fabc7abfe2b011/sample-file.pdf','2022-03-16 14:27:39','',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','2023-02-20 14:29:32',NULL,NULL,NULL,'Candidate','No','Unknown',NULL,'Active search','No','No','No','2021-12-20 17:08:57','Yii','Public',NULL,NULL,'2021-10-05 13:49:23','2023-02-20 14:29:32','CA',NULL),(9,'K0zEIy8em9H2wk2x6K04t4gvtW1uu5zR','$2y$13$Ti8rHCE3S8tcy6cjsJrBG.6glymyp3HRK8EpShoce9kFP9AW9zptG',NULL,'employer@groupevelanmedia.com',10,'KzQ9x7rylwFYF6Bks18cync6sg2ZLRFx_1633456163','Ross','Boss',4,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,'0000-00-00 00:00:00','fr','0000-00-00 00:00:00',NULL,NULL,NULL,'Employer','No','Unknown',NULL,'Active search','No','No','No',NULL,'Yii','Public',NULL,NULL,'2021-10-05 13:49:23','2021-10-05 13:49:23',NULL,NULL),
this looks nice thanks for this
Posts: 33
Threads: 0
Joined: Nov 2023
Posts: 3
Threads: 0
Joined: Nov 2023
Posts: 13
Threads: 0
Joined: Jul 2023
Posts: 23
Threads: 2
Joined: Jul 2023
dead link - return credit or can you send me new link!
Posts: 40
Threads: 9
Joined: Aug 2023
(11-30-2023, 03:00 PM)barbegr Wrote: dead link - return credit or can you send me new link!
Look the comment area,link is re-posted,
|
