06-30-2024, 04:32 PM
HELLO
i'm selling GGs.tv 6k user's data
Quote:what is GGs.tv?
Do you go on other social media sites and scroll endlessly through the garbage that is your timeline? Tired of seeing politics and religious debates? Fake News got ya down?
We created this site to offer gamers an outlet to be their TRUE self. A way to embrace their online persona and escape the real world for a bit. Watch clips, network with like-minded gamers, and not have to worry about being stalked or revealing too much personal information. Be who you want to be. Play the games that you want to play! This is a judgement-free zone, a safe place for gamers to be, well, GAMERS!
Quote:
PHP Code:
-- Dumping structure for table xxxx.users
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int unsigned NOT NULL AUTO_INCREMENT,
`user_group` tinyint unsigned NOT NULL DEFAULT '3',
`user_name` varchar(64) NOT NULL,
`user_email` varchar(64) NOT NULL,
`user_email_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_email_verification_code` varchar(64) DEFAULT NULL,
`user_phone` varchar(64) DEFAULT NULL,
`user_phone_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_phone_verification_code` varchar(64) DEFAULT NULL,
`user_password` varchar(64) NOT NULL,
`user_two_factor_enabled` enum('0','1') NOT NULL DEFAULT '0',
`user_two_factor_type` enum('email','sms','google') DEFAULT NULL,
`user_two_factor_key` varchar(64) DEFAULT NULL,
`user_two_factor_gsecret` varchar(64) DEFAULT NULL,
`user_activated` enum('0','1') NOT NULL DEFAULT '0',
`user_reseted` enum('0','1') NOT NULL DEFAULT '0',
`user_reset_key` varchar(64) DEFAULT NULL,
`user_subscribed` enum('0','1') NOT NULL DEFAULT '0',
`user_staff` enum('0','1') NOT NULL DEFAULT '0',
`user_mod` enum('0','1') NOT NULL DEFAULT '0',
`user_sponsored` enum('0','1') NOT NULL DEFAULT '0',
`user_package` int unsigned DEFAULT NULL,
`user_rating` enum('1','2','3','4','5') DEFAULT NULL,
`user_subscription_date` datetime DEFAULT NULL,
`user_boosted_posts` int unsigned NOT NULL DEFAULT '0',
`user_boosted_pages` int unsigned NOT NULL DEFAULT '0',
`user_started` enum('0','1') NOT NULL DEFAULT '0',
`user_verified` enum('0','1') NOT NULL DEFAULT '0',
`user_banned` enum('0','1') NOT NULL DEFAULT '0',
`reason_ban` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_live_requests_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_requests_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_messages_lastid` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_counter` int unsigned NOT NULL DEFAULT '0',
`user_live_notifications_lastid` int unsigned NOT NULL DEFAULT '0',
`user_latitude` varchar(256) NOT NULL DEFAULT '0',
`user_longitude` varchar(256) NOT NULL DEFAULT '0',
`user_location_updated` datetime DEFAULT NULL,
`user_firstname` varchar(256) DEFAULT NULL,
`user_lastname` varchar(256) DEFAULT NULL,
`user_gender` int unsigned DEFAULT NULL,
`user_picture` varchar(255) DEFAULT NULL,
`user_picture_id` int unsigned DEFAULT NULL,
`user_cover` varchar(256) DEFAULT NULL,
`user_cover_id` int unsigned DEFAULT NULL,
`user_cover_position` varchar(256) DEFAULT NULL,
`user_album_pictures` int unsigned DEFAULT NULL,
`user_album_covers` int unsigned DEFAULT NULL,
`user_album_timeline` int unsigned DEFAULT NULL,
`user_pinned_post` int unsigned DEFAULT NULL,
`user_registered` datetime DEFAULT NULL,
`user_last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_first_failed_login` datetime DEFAULT NULL,
`user_failed_login_ip` varchar(64) DEFAULT NULL,
`user_failed_login_count` int unsigned NOT NULL DEFAULT '0',
`user_country` int unsigned DEFAULT NULL,
`user_birthdate` date DEFAULT NULL,
`user_relationship` varchar(256) DEFAULT NULL,
`user_biography` text,
`user_website` varchar(256) DEFAULT NULL,
`user_work_title` varchar(256) DEFAULT NULL,
`user_work_place` varchar(256) DEFAULT NULL,
`user_work_url` varchar(256) DEFAULT NULL,
`user_current_city` varchar(256) DEFAULT NULL,
`user_hometown` varchar(256) DEFAULT NULL,
`user_edu_major` varchar(256) DEFAULT NULL,
`user_edu_school` varchar(256) DEFAULT NULL,
`user_edu_class` varchar(256) DEFAULT NULL,
`user_social_facebook` varchar(256) DEFAULT NULL,
`user_social_twitter` varchar(256) DEFAULT NULL,
`user_social_steam` varchar(256) DEFAULT NULL,
`user_social_activision` varchar(256) DEFAULT NULL,
`user_social_switch` varchar(256) DEFAULT NULL,
`user_social_battle` varchar(265) DEFAULT NULL,
`user_social_origin` varchar(256) DEFAULT NULL,
`user_social_gog` varchar(265) DEFAULT NULL,
`user_social_youtube` varchar(256) DEFAULT NULL,
`user_social_instagram` varchar(256) DEFAULT NULL,
`user_social_linkedin` varchar(256) DEFAULT NULL,
`user_social_twitch` varchar(256) DEFAULT NULL,
`user_social_playstation` varchar(256) DEFAULT NULL,
`user_social_xbox` varchar(256) DEFAULT NULL,
`user_social_tiktok` varchar(256) DEFAULT NULL,
`user_profile_background` varchar(256) DEFAULT NULL,
`user_chat_enabled` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_newsletter` enum('0','1') NOT NULL DEFAULT '1',
`user_privacy_poke` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_gifts` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_wall` enum('me','friends','public') NOT NULL DEFAULT 'friends',
`user_privacy_gender` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_birthdate` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_relationship` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_basic` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_work` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_location` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_education` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_other` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_friends` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_photos` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_pages` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_groups` enum('me','friends','public') NOT NULL DEFAULT 'public',
`user_privacy_events` enum('me','friends','public') NOT NULL DEFAULT 'public',
`email_post_likes` enum('0','1') NOT NULL DEFAULT '1',
`email_post_comments` enum('0','1') NOT NULL DEFAULT '1',
`email_post_shares` enum('0','1') NOT NULL DEFAULT '1',
`email_wall_posts` enum('0','1') NOT NULL DEFAULT '1',
`email_mentions` enum('0','1') NOT NULL DEFAULT '1',
`email_profile_visits` enum('0','1') NOT NULL DEFAULT '1',
`email_friend_requests` enum('0','1') NOT NULL DEFAULT '1',
`facebook_connected` enum('0','1') NOT NULL DEFAULT '0',
`facebook_id` varchar(128) DEFAULT NULL,
`google_connected` enum('0','1') NOT NULL DEFAULT '0',
`google_id` varchar(128) DEFAULT NULL,
`twitter_connected` enum('0','1') NOT NULL DEFAULT '0',
`twitter_id` varchar(128) DEFAULT NULL,
`instagram_connected` enum('0','1') NOT NULL DEFAULT '0',
`instagram_id` varchar(128) DEFAULT NULL,
`linkedin_connected` enum('0','1') NOT NULL DEFAULT '0',
`apple_connected` enum('0','1') NOT NULL DEFAULT '0',
`linkedin_id` varchar(128) DEFAULT NULL,
`apple_id` varchar(128) DEFAULT NULL,
`vkontakte_connected` enum('0','1') NOT NULL DEFAULT '0',
`vkontakte_id` varchar(128) DEFAULT NULL,
`user_referrer_id` int DEFAULT NULL,
`user_affiliate_balance` varchar(64) NOT NULL DEFAULT '0',
`user_wallet_balance` decimal(4,0) NOT NULL DEFAULT '0',
`user_points` int NOT NULL DEFAULT '0',
`chat_sound` enum('0','1') NOT NULL DEFAULT '0',
`notifications_sound` enum('0','1') NOT NULL DEFAULT '0',
`onesignal_user_id` varchar(100) DEFAULT NULL,
`user_language` varchar(16) DEFAULT 'en_us',
`first` varchar(254) DEFAULT NULL,
`second` varchar(254) DEFAULT NULL,
`third` varchar(254) DEFAULT NULL,
`fourth` varchar(254) DEFAULT NULL,
`fifth` varchar(254) DEFAULT NULL,
`squad_name` varchar(254) NOT NULL DEFAULT 'The Squad',
`card_cover` varchar(254) NOT NULL DEFAULT 'disabled',
`spotify` varchar(453) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`total_xp` bigint NOT NULL DEFAULT '0',
`game1` varchar(254) DEFAULT NULL,
`game2` varchar(254) DEFAULT NULL,
`game3` varchar(254) DEFAULT NULL,
`exolved` enum('0','1') NOT NULL DEFAULT '0',
`valk` enum('0','1') NOT NULL DEFAULT '0',
`titus` enum('0','1') NOT NULL DEFAULT '0',
`poss` enum('0','1') NOT NULL DEFAULT '0',
`safe` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder` enum('0','1') NOT NULL DEFAULT '0',
`firstresponder_badge` enum('0','1') NOT NULL DEFAULT '0',
`military_badge` enum('0','1') NOT NULL DEFAULT '0',
`military` enum('0','1') NOT NULL DEFAULT '0',
`gg_badge` enum('0','1') NOT NULL DEFAULT '0',
`gg` enum('0','1') NOT NULL DEFAULT '0',
`aero` enum('0','1') NOT NULL DEFAULT '0',
`zodiac` enum('0','1') NOT NULL DEFAULT '0',
`sway` enum('0','1') NOT NULL DEFAULT '0',
`partner_member` enum('0','1') NOT NULL DEFAULT '0',
`css` text,
`lfg` enum('0','1') NOT NULL DEFAULT '0',
`lfg_text` varchar(256) DEFAULT NULL,
`user_social_discord` varchar(45) DEFAULT NULL,
`user_social_epic` varchar(45) DEFAULT NULL,
`user_social_trovo` varchar(45) DEFAULT NULL,
`live` enum('0','1') NOT NULL DEFAULT '0',
`searching` enum('0','1') NOT NULL DEFAULT '0',
`layout` int NOT NULL DEFAULT '1',
`user_token` varchar(255) DEFAULT NULL,
`tickets` int DEFAULT '0',
`tag` varchar(45) DEFAULT NULL,
`grinding` int NOT NULL DEFAULT '0',
`referrals` int DEFAULT '0',
`code` enum('0','1') DEFAULT '0',
`monthly` int NOT NULL DEFAULT '0',
`cancel_sub` enum('0','1') DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`user_name`),
UNIQUE KEY `user_email` (`user_email`),
UNIQUE KEY `facebook_id` (`facebook_id`),
UNIQUE KEY `twitter_id` (`twitter_id`),
UNIQUE KEY `linkedin_id` (`linkedin_id`),
UNIQUE KEY `vkontakte_id` (`vkontakte_id`),
UNIQUE KEY `instagram_id` (`instagram_id`),
UNIQUE KEY `user_phone` (`user_phone`),
UNIQUE KEY `google_id` (`google_id`),
KEY `apple_id` (`apple_id`),
KEY `idx_last_seen_online` (`user_last_seen`) USING BTREE COMMENT 'Typically used for sorting'
) ENGINE=InnoDB AUTO_INCREMENT=6598 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- Dumping data for table xxxx.users: ~6,277 rows (approximately)