[wht]

Website - tripodo.de


Format - SQL
Size sql file - 3.3GB
Date - 2023
All Rows - 6kk


​

Code:

    INSERT INTO `trpd_users` (`userID`, `userFirstName`, `userLastName`, `userEmail`, `userEmailConfirmed`, `userEmailConfirmationEmailCode`, `userPassword`, `userIsOfficial`, `userGender`, `userPhone`, `userFreePhone`, `userClientPreferredTime`, `userCountryID`, `userCity`, `userAddress`, `userZip`, `userReceiveNewsletter`, `userReceiveCRM`, `userEmailType`, `userCompany`, `userCompanyName`, `userCompanyShortDescription`, `userCompanyRegisterID`, `userCompanyVatID`, `userCompanyHasLogo`, `userInsuranceCompanyHasLogo`, `userCompanyHomepage`, `userCompanyIsPremium`, `userCompanyProfileExtra`, `userCompanyIsTop`, `userCompanyIsForSZ`, `userCompanyIsForDM`, `userCompanyIsForWhiteLabel`, `userCompanyIsForPax`, `userCompanyIsPremiumDM`, `userCompanyIsForCRS`, `userCompanyIsForHC`, `userCompanyDisplayed`, `userCompanyBusinessType`, `userCompanyManagement`, `userCompanyFormOrganization`, `userCompanyCommercialRegisterID`, `userCompanyJurisdiction`, `userCompanyPaxShortCode`, `userPartnerCommission`, `userCompanyOfficeHours`, `userCompanyTravelInsuranceCompany`, `userCompanyColaboration`, `userAccountOwner`, `userIbanCode`, `userBicCode`, `userCompanyTomaID`, `userClient`, `userAgency`, `userAffiliate`, `userAgreesAffiliate`, `userAgreesAgency`, `userAgreesClient`, `userIsSuspendedClient`, `userIsSuspendedAgency`, `userIsSuspendedAffiliate`, `userAdminNotes`, `userActivationCode`, `userStatus`, `userInactivateComment`, `userNativeLanguage`, `userSiteLanguage`, `userIsSpammer`, `userIsFromAddInquiry`, `userRegisterDate`, `logAdminID`, `logAdminIP`, `userIsFromAffiliate`, `userNumberOfBadgesAllowed`, `userNumberOfBadgesActive`, `userNumberOfBadgesAllowedWebsite`, `userHideHeadline`, `userReferenceNumberTraffics`, `userReferenceNumberVanessa`, `userTourserverAgencyID`) VALUES

    INSERT INTO `trpd_notifications_sg_events` (`eventID`, `eventType`, `eventDate`, `eventEmail`, `eventFull`, `eventUserID`, `eventViewedByAdminID`) VALUES

SAMPLE

Code:

(110942, 'click', 1479572968, '[email protected]', '{"ip":"91.89.173.139","sg_event_id":"MDQ1ZWE5ZDItZTZlNC00YmEwLTkxNmEtNDA2ZGMxNmU4MjQ2","sg_message_id":"GGdz_AKhSrmh0vEPRYeNXg.filter0090p1las1-31773-582ACEDD-20.0","useragent":"Mozilla\\/5.0 (Windows NT 6.1; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/54.0.2840.99 Safari\\/537.36","event":"click","url_offset":{"index":1,"type":"html"},"email":"[email protected]","timestamp":1479572968,"url":"https:\\/\\/www.tripodo.de\\/ihr-reiseangebot\\/d5554f95cdecdc12abaa7549ccec3dd2\\/"}', 21121, 0),
(110943, 'open', 1479573307, '[email protected]', '{"email":"[email protected]","timestamp":1479573307,"ip":"91.89.173.139","sg_event_id":"ODNhYmVmMTctNjkxZC00NDEwLTg0Y2EtNGU3NjZkYWM1YzBl","sg_message_id":"qJsuSja2SOWAi5ZpQgz1Jg.filter0195p1las1-2092-582ACFD5-12.0","useragent":"Mozilla\\/5.0 (Windows NT 6.1; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/54.0.2840.99 Safari\\/537.36","event":"open"}', 21121, 0),
(110944, 'open', 1479573329, '[email protected]', '{"email":"[email protected]","timestamp":1479573329,"ip":"91.89.173.139","sg_event_id":"MTkzZDBmOTQtNDFhMy00NmU3LWFmZjYtYmNkNWVjMDFmNGZj","sg_message_id":"zzr6sNHtQSW7VPHVbgzYNg.filter0974p1mdw1-3253-582C2A61-23.0","useragent":"Mozilla\\/5.0 (Windows NT 6.1; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/54.0.2840.99 Safari\\/537.36","event":"open"}', 21121, 0),
(110945, 'processed', 1479573365, '[email protected]', '{"email":"[email protected]","timestamp":1479573365,"smtp-id":"<[email protected]>","sg_event_id":"8PmHHiEJSOyw4aVeXU1vEA","sg_message_id":"M6vJKaQsReaEhMr1WjNuNg.filter0960p1mdw1-15726-58307F75-1B.0","event":"processed"}', 21164, 0),
(110946, 'delivered', 1479573368, '[email protected]', '{"ip":"198.21.7.151","response":"250 Requested mail action okay, completed: id=0LfpE2-1cWxhi1Op8-00pKA6 ","sg_event_id":"ebY6MHsFSv2ZbTPWLuRZiw","sg_message_id":"M6vJKaQsReaEhMr1WjNuNg.filter0960p1mdw1-15726-58307F75-1B.0","tls":1,"event":"delivered","email":"[email protected]","timestamp":1479573368,"smtp-id":"<[email protected]>"}', 21164, 0),
(110947, 'open', 1479573595, '[email protected]', '{"email":"[email protected]","timestamp":1479573595,"ip":"91.89.173.139","sg_event_id":"NWY3YmJmNTUtYWYzNi00YTM4LThmYWEtODgyYTIzNDYwMTI0","sg_message_id":"gS10DxJnRomOhpRv2AfbhQ.filter0448p1mdw1-10836-582D7BE2-E.0","useragent":"Mozilla\\/5.0 (Windows NT 6.1; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/54.0.2840.99 Safari\\/537.36","event":"open"}', 21121, 0),
(110948, 'open', 1479573608, '[email protected]', '{"email":"[email protected]","timestamp":1479573608,"ip":"91.89.173.139","sg_event_id":"ZDdkMzM2MDAtNGI5Mi00ZDI2LWJlZDgtOWNjMDAwNTVlNjNj","sg_message_id":"1KjE_Ep6Sh66su0KRIxg9w.filter0439p1mdw1-2899-58301EE1-45.0","useragent":"Mozilla\\/5.0 (Windows NT 6.1; WOW64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/54.0.2840.99 Safari\\/537.36","event":"open"}', 21121, 0),



(21855, '', 'Kanzek', '[email protected]', 1, '81d31d7ff38e17827c7036f7fb8d6931', '903cf97fb967af7bd7d2c5e8e1528008', 0, 'm', '080331416', '', '', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, '754e66fa35e095ce0b65a67401491871', 'active', NULL, 1, 1, 0, 1, '2017-01-26 17:50:44', 0, 0, '18669', 0, 0, 0, 1, '', '', ''),
(21856, '', 'Uhlig', '[email protected]', 1, '23faec315a1f3902ed1286a938560434', '7a443b89cda504f1f5d49ce7277cf381', 0, 'f', '03062903838', '', '', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, 'ec97616a417015069e5b9567cefd34d1', 'active', NULL, 1, 1, 0, 1, '2017-01-26 18:31:13', 0, 0, '', 0, 0, 0, 1, '', '', ''),
(21857, 'Peter', 'Schmitt', '[email protected]', 1, '32071573e36f90b825a1de7bc57cc14c', 'c2f9ba711009d259af7eff7c224f4fdb', 0, 'm', '02236336532', '', '', 59, 'Wesseling', 'Max-Planck-Str. 7', '50389', 'n', 1, 'html', 'y', 'P2 ReisePortal', '', '', NULL, 0, 0, 'www.p2-reiseportal.de', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'travelOffice', NULL, NULL, NULL, '', '', 10, NULL, NULL, 'TSS', '', '', '', 10967, 0, 1, 0, 0, 1, 0, 0, 0, 0, NULL, '23fda60f0b25580da50508fc9adafb5f', 'notactive', '', 1, 1, 0, 0, '2017-01-26 19:09:36', 0, 0, '', 0, 0, 0, 1, 'TS021811001', '', ''),
(21858, '', 'Hoffmann', '[email protected]', 1, 'e655e2b3d39408f86ae01faa25f746c7', '4ca1a318c456348520ce3e7edca3eb87', 0, 'f', '0223461527', '', '17 - 19', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, 'e3f2ce4153fee255fc91c83f43c8395d', 'active', NULL, 1, 1, 0, 1, '2017-01-26 21:21:47', 0, 0, '', 0, 0, 0, 1, '', '', ''),
(21859, '', 'Von Lewicka', '[email protected]', 1, '19c00d335d04ddaffcc4e2572a8903a5', '3a7027f98aa3443353ddfce6fa45d4da', 0, 'm', '037312446080', '', '', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, '9bdc5bf4ed4b7f496ee8f477310f9507', 'active', NULL, 1, 1, 0, 1, '2017-01-26 22:05:47', 0, 0, '', 0, 0, 0, 1, '', '', ''),
(21860, '', 'Maenz', '[email protected]', 1, '8edea7226ac96e0e97e75f2a07a0546c', 'b182b3c3f06427b376f6fca72376760e', 0, 'm', '17645965040', '', '', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, '6eaaa6168dd3dd2ab1cbbe5d87ac3abb', 'active', NULL, 1, 1, 0, 1, '2017-01-26 23:12:26', 0, 0, '7364', 0, 0, 0, 1, '', '', ''),
(21861, '', 'Gricar', '[email protected]', 1, '3ddce344d8bec9a2081137d2e6882bca', '2422342f16aea194fe758b1b575b1b0f', 0, 'f', '01787801138', '', '', 0, '', '', '', 'n', 1, 'html', 'n', '', '', '', NULL, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', NULL, NULL, NULL, '', '', 10, NULL, NULL, '', '', '', '', 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, NULL, 'a2009cf993ebc14e6c58b1a83b5e336c', 'active', NULL, 1, 1, 0, 1, '2017-01-27 09:09:26', 0, 0, '', 0, 0, 0, 1, '', '', ''),

Hidden Content

You must register or login to view this content.

[JustD4rk]

nice share

[jasius]

nice thank you

[h31s3nb3rg]

nice thanks

[troubler]

Wanna see this one, thank you

[receive_userone]

nice share

[hvjgfzerxvjb]

JJFJ DF DFWEFH HERYIF FFSET HFG OADG

[Moreandadam]

many thanks

[tongli8046]

very nice!

[Theg0g08]

<!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}-->Let me check.thanks for you info

---

<!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}-->Always like this... very handy .Thanks.