Forum Kurallarını Okumak İçin Lütfen Tıklayınız .

Database Leaked - Tripodo.de Sql © Chucky Credits 

Unlocking a locked block is only possible for a certain number of credits.
Sql © Chucky Credits Database Leaked - Tripodo.de
Joined
Jun 7, 2021
Messages
4,299
Reaction score
56,119
#CR
247
8286ad7639695c649e0527558c4b824c.jpg


Database Leaked tripodo.de
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

Format - .SQL
Size sql file - 3.3GB
Date - 2023
All Rows - 6kk
Website - tripodo.de


HTML:
INSERT INTO `trpd_notifications` (`nID`, `nFromID`, `nToID`, `nFromIdIsAdmin`, `nToIdIsAdmin`, `nSubject`, `nMessage`, `nMessageShort`, `nInquiryID`, `nTravelofficeID`, `nIsDeletedFrom`, `nIsDeletedTo`, `nDate`, `nIsReply`, `nTicketID`, `nIsRead`, `nHide`, `nIsReadByAdmin`, `nHasAttachment`) VALUES
(176652, 21231, 77, 0, 1, 'Fwd: Re: Ihr persönliches Reiseangebot von Holiday Check', '<html>\r\n  <head>\r\n\r\n    <meta http-equiv="content-type" content="text/html; charset=utf-8">\r\n  </head>\r\n  <body bgcolor="#FFFFFF" text="#000000">\r\n    <p><br>\r\n    </p>\r\n    <div class="moz-forward-container"><br>\r\n      <br>\r\n      -------- Weitergeleitete Nachricht --------\r\n      <table class="moz-email-headers-table" border="0" cellpadding="0"\r\n        cellspacing="0">\r\n        <tbody>\r\n          <tr>\r\n            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Betreff:\r\n            </th>\r\n            <td>Re: Ihr persönliches Reiseangebot von Holiday Check</td>\r\n          </tr>\r\n          <tr>\r\n            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Datum: </th>\r\n            <td>Fri, 2 Dec 2016 00:37:16 +0100</td>\r\n          </tr>\r\n          <tr>\r\n            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Von: </th>\r\n            <td>Klaus Düren <a class="moz-txt-link-rfc2396E" href="mailto:kdueren@ish.de">&lt;kdueren@ish.de&gt;</a></td>\r\n          </tr>\r\n          <tr>\r\n            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">An: </th>\r\n            <td>Kundenservice Tripodo GmbH\r\n              <a class="moz-txt-link-rfc2396E" href="mailto:reiseservice@tripodo.de">&lt;reiseservice@tripodo.de&gt;</a></td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n      <br>\r\n      <br>\r\n      <meta content="text/html; charset=utf-8" http-equiv="Content-Type">\r\n      <p>Hallo Frau Weber,</p>\r\n      <p><br>\r\n      </p>\r\n      <p>zunächst einmal möchte ich mich für Ihre Bemühungen bedanken.</p>\r\n      <p>Dann möchte ich Sie bitten, falls Sie das beurteilen können,\r\n        mir die Vorzüge oder Nachteile der Reisen "vom Krügerpark bis\r\n        zur Gartenroute" und "Südafrika Classics zum Kennenlernen"\r\n        aufzuzeigen.</p>\r\n      <p>Die erstgenannte Tour ist sehr preiswert und einen Tag länger,\r\n        also auf den ersten Blick sehr interessant. Da wir Südafrika\r\n        bisher nicht kennengelernt haben, können wir inhaltlich nicht\r\n        Vor- oder Nachteile erkennen.</p>\r\n      <p>Die Reise, die wir alternativ noch im Angebot haben, ist unter\r\n        folgendem Link einzusehen. <a moz-do-not-send="true"\r\n          href="http://www.e-kolumbus.de/rundreise/69195">http://www.e-kolumbus.de/rundreise/69195</a></p>\r\n      <p><br>\r\n      </p>\r\n      <p>Ich würde mich sehr freuen, wenn Sie uns bei der\r\n        Reiseentscheidung beraten könnten und werden auch gerne bei\r\n        Ihnen buchen.</p>\r\n      <p>Wenn ein Telefonat angebracht wäre, möchte ich Sie bitten, mich\r\n        Freitag ab 16 Uhr mobil unter 016097651183 zu kontaktieren.\r\n        (Natürlich nur dann, wenn Sie auch noch im Dienst sind)<br>\r\n      </p>\r\n      <p><br>\r\n      </p>\r\n      <p>Vielen Dank und herzliche Grüße</p>\r\n      <p>Klaus Düren<br>\r\n      </p>\r\n      <br>\r\n      <div class="moz-cite-prefix">Am 28.11.2016 um 16:04 schrieb\r\n        Kundenservice Tripodo GmbH:<br>\r\n      </div>\r\n      <blockquote cite="mid:583c477443726@tripodo.de" type="cite">\r\n        <meta http-equiv="Content-Type" content="text/html;\r\n          charset=utf-8">\r\n        <title>HolidayCheck Notification</title>\r\n        <style type="text/css">\r\n*{\r\nfont-family:Arial, Helvetica, Sans-serif;\r\n}\r\nhtml,body,p,table,td,form,img,h1,h2,h3,h4,h5,h6,input,#page{\r\nfont-size: 14px !important; /* 1 */\r\n-webkit-text-size-adjust: 14px !important; /* 2 */\r\n-ms-text-size-adjust: 14px !important; /* 2 */\r\n}\r\nhtml,body,div,p,table,td,form,img,h1,h2,h3,h4,h5,h6,input{\r\npadding:0px;\r\nmargin:0px;\r\nborder:none;\r\ncolor:#444444;\r\n}\r\nbody,#page{\r\nfont-size:100%;\r\n}\r\nbody{\r\nbackground-color:#EDEDED;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\n}\r\np,td,h1,h2,h3,h4,h5,h6{\r\nline-height: 19px;\r\nmargin:0px;\r\ncolor:#444444;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\nfont-size:14px;\r\n}\r\n/* <!-- HolidayCheck WL Case --> */\r\na,a:visited{\r\ncolor:#0058a3;\r\ntext-decoration:underline;\r\n}\r\na:active,a:hover{\r\ncolor:#0058a3;\r\ntext-decoration:underline;\r\n}\r\n\r\nul{\r\nmargin:0;\r\npadding:0 0 0 0px;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\n}\r\nli{\r\nmargin:0;\r\npadding:0;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\n}\r\nh1{\r\ncolor:#333333;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\nfont-size:22px !important;\r\nfont-weight:bold;\r\npadding-top:0px;\r\nmargin-bottom:3px;\r\npadding-left:0px;\r\n}\r\nh2{\r\ncolor:#333333 !important;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\nfont-size:18px !important;\r\nfont-weight:normal;\r\npadding-top:0px;\r\npadding-bottom:0px;\r\npadding-left:0px;\r\nline-height:18px;\r\n}\r\nh3{\r\ncolor:#444444;\r\nfont-family:Arial, Helvetica, Sans-serif;\r\nfont-size:14px !important;\r\nfont-weight:bold;\r\npadding-top:28px!important;\r\npadding-bottom:5px !important;\r\n}\r\n.bold{\r\nfont-weight:bold;\r\n}\r\nlabel{\r\nfont-size:14px;\r\n}\r\np,table tr td p,.tekst{\r\nline-height: 19px;\r\nfont-size:14px;\r\ncolor:#444444;\r\n}\r\n.teksttable tr td{\r\nline-height: 19px;\r\nfont-size:14px;\r\ncolor:#444444;\r\npadding-right:7px;\r\n}\r\n.footersmall p{\r\nline-height:14px;\r\nfont-size:11px !important;\r\ncolor:#777777;\r\n}\r\n.footersmall p a{\r\nfont-size:11px !important;\r\ncolor:#777777;\r\n}\r\n#page{\r\nwidth:100%;\r\nmargin:auto;\r\npadding:0;\r\nbackground-color:#EDEDED;\r\nbackground-image:url(https://www.tripodo.de/images/email/back_backgroundimage.jpg);\r\nheight:100%;\r\n}\r\nul li { list-style-type: inherit; list-style-position: inside; }\r\n#contentEmail { line-height: 19px !important; font-size: 14px; }\r\nul > br, ol > br { line-height: 0; }\r\n</style>\r\n        <div id="page" style="font-family: Arial, Helvetica,\r\n          Sans-serif;padding: 0;margin: auto;border: none;color:\r\n          #444444;width: 100%;background-color:\r\n          #EDEDED;background-image:\r\nurl(https://www.tripodo.de/images/email/back_backgroundimage.jpg);height:\r\n          100%;">\r\n          <table cellpadding="0" cellspacing="0" width="100%">\r\n            <tbody>\r\n              <tr>\r\n                <td style="text-align:left !important;" align="center"\r\n                  valign="top">\r\n                  <div align="center">\r\n                    <table style="font-size: 14px;padding: 0px;margin:\r\n                      0px;border: none;color: #444444;" align="center"\r\n                      bgcolor="#EDEDED" border="0" cellpadding="0"\r\n                      cellspacing="0" width="612">\r\n                      <tbody>\r\n                        <tr>\r\n                          <td\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#ededed"><img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/blank.gif"\r\n                              style="padding: 0px;margin: 0px;border:\r\n                              none;" height="20" width="20"> </td>\r\n                        </tr>\r\n                      </tbody>\r\n                    </table>\r\n                    <table style="font-size: 14px;padding: 0px;margin:\r\n                      0px;border: none;color: #444444;\r\n                      margin-bottom:10px;" align="center"\r\n                      bgcolor="#EDEDED" border="0" cellpadding="0"\r\n                      cellspacing="0" width="612">\r\n                      <tbody>\r\n                        <tr style="">\r\n                          <td rowspan="6" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            align="right"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            valign="top" width="16"> <img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/shadow-left.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="610" width="16"> </td>\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;" height="60"\r\n                            bgcolor="#FFFFFF" width="20"> <img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/blank.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="60" width="20"> </td>\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;" height="60"\r\n                            bgcolor="#FFFFFF" width="250"><img\r\n                              moz-do-not-send="true"\r\nsrc="https://www.tripodo.de/images/whitelabel/holidaycheck/agency-logo-email.png"\r\n                              alt="holidaycheck" style="font-size:\r\n                              14px;padding: 0px;margin: 0px;border:\r\n                              none;color: #444444; margin-top: 20px;"\r\n                              height="52" border="0" width="296"> </td>\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;" height="60"\r\n                            align="right" bgcolor="#FFFFFF"\r\n                            valign="bottom" width="290">\r\n                            <h1 style="font-size: 22px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #333333;line-height: 19px;font-weight:\r\n                              bold;padding-top: 0px;margin-bottom:\r\n                              3px;padding-left: 0px;"><!--Your Registration-->\r\n                            </h1>\r\n                            <br>\r\n                          </td>\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;" height="60"\r\n                            bgcolor="#FFFFFF" width="20"> <img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/blank.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="60" width="20"> </td>\r\n                          <td rowspan="6" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            valign="top" width="16"> <img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/shadow-right.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="610" width="16"> </td>\r\n                        </tr>\r\n                        <tr style="">\r\n                          <td colspan="4" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            height="53" bgcolor="#FFFFFF" valign="top">\r\n                            <img moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/header-bottom.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="53" width="580"> </td>\r\n                        </tr>\r\n                        <tr style="">\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;"\r\n                            bgcolor="#FFFFFF" valign="top" width="20"> </td>\r\n                          <td colspan="2" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            bgcolor="#FFFFFF" valign="top">\r\n                            <div id="contentEmail" align="left">\r\n                              <h2 style="font-size: 18px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #333333; line-height: 20px; font-weight:\r\n                                normal; padding-top: 0px;\r\n                                padding-bottom: 0px; padding-left: 0px;">Guten\r\n                                Tag Herr Klaus Mathias Düren,</h2>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;">herzlichen\r\n                                Dank für Ihre Reiseanfrage auf Holiday\r\n                                Check! Ich freue mich sehr, Ihnen ein\r\n                                individuelles Angebot für<span> die\r\n                                  Reise <em> - </em></span><em>Südafrika\r\n                                  - Südafrika - Vom Krügerpark bis zur\r\n                                  Gartenroute - </em> unterbreiten zu\r\n                                können. </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"><span>\r\n                                  <style type="text/css">\r\nul#itinerary-list { margin-top: 0px; list-style-type:none !important;}\r\nul#itinerary-list li { float:left; width:100%; margin-bottom: 12px; list-style-type:none !important; }\r\n.iconspann { width:20px; height:28px; margin-right:6px; float:left; margin-bottom: 3px; }\r\n\r\n/* <!-- HolidayCheck WL Case --> */\r\n.orangecolor { color:#6DB13F !important; }\r\n\r\n.margintop0 { margin-top:0; }\r\n</style></span></p>\r\n                              <div style="float:left;\r\n                                margin-bottom:0px;">\r\n                                <h2 style="padding-top:0px !important;\r\n                                  padding-bottom:10px;">Kurzversion\r\n                                  Ihres Reiseangebotes</h2>\r\n                                <div style="float:left;\r\n                                  margin-bottom:0px; border: 2px dotted\r\n                                  grey; padding: 10px">\r\n                                  <h3 style="display: inline-block;\r\n                                    font-size: 16px !important;\r\n                                    margin-bottom: 10px; padding-top:\r\n                                    5px !important;">Südafrika - Vom\r\n                                    Krügerpark bis zur Gartenroute</h3>\r\n                                  <table style="margin-bottom:15px;\r\n                                    border:none;" border="0"\r\n                                    cellpadding="0" cellspacing="0"\r\n                                    width="516">\r\n                                    <tbody>\r\n                                      <tr>\r\n                                        <td style="vertical-align:top;\r\n                                          border:none; padding-left:0;"\r\n                                          valign="top" width="205"> <a\r\n                                            moz-do-not-send="true"\r\nhref="https://u1377392.ct.sendgrid.net/wf/click?upn=TU8V3C-2FkVgKPZlLJMN1lahCPjG5xLZOTM9Fh4gHu6OkaS0qwqsGp-2Fs4PDmsqGdvlJoQEIiIcV8fyiZlqqDBhCn8uUDwu-2FDtWqA018Hqx8dFrt3-2B4-2BKHp1uDTkw4qIKoR_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrTS0J-2F0mjHwqh-2B12LXwyzGeD7aAolzdHhYjhLvC7PBlIabNX8DvqCDwTzf9nqbK1i-2BWqyRwIv-2B1VFTYh-2FCbJdd2Lfr4mN0Xog5pMrbQi74RdsuNoU3KSk39-2BX0vP7wk3-2FuiK4fmOvsPbSeOoMCquB3Sg-3D-3D"\r\n                                            title="Details und Buchung">\r\n                                            <img moz-do-not-send="true"\r\nsrc="http://bilder-cdn.tripodo.de/photo_941538_nv_public.jpg" alt=""\r\n                                              align="left" width="195">\r\n                                          </a> </td>\r\n                                        <td style="vertical-align:top;\r\n                                          border:none;" valign="top"\r\n                                          width="311">\r\n                                          <ul id="itinerary-list"\r\n                                            style="margin-top:0\r\n                                            !important;\r\n                                            list-style-type:none\r\n                                            !important;">\r\n                                            <li style="float:left;\r\n                                              width:100%; margin-bottom:\r\n                                              12px; list-style-type:none\r\n!important;font-weight:normal;"> <span class="iconspann"\r\n                                                style="width:20px;\r\n                                                height:28px;\r\n                                                margin-right:6px;\r\n                                                float:left;\r\n                                                margin-bottom: 3px;">\r\n                                                <!-- HolidayCheck WL Case -->\r\n                                                <img\r\n                                                  moz-do-not-send="true"\r\nsrc="https://www.tripodo.de/images/whitelabel/holidaycheck/icono-calendar-blue.png"\r\n                                                  alt="" width="19"> </span>\r\n                                              <b>Gewählter Reisezeitraum</b><br>\r\n                                              20.10.2017 - 31.10.2017</li>\r\n                                            <li style="float:left;\r\n                                              width:100%; margin-bottom:\r\n                                              12px; list-style-type:none\r\n!important;font-weight:normal;"> <span class="iconspann"\r\n                                                style="width:20px;\r\n                                                height:28px;\r\n                                                margin-right:6px;\r\n                                                float:left;\r\n                                                margin-bottom: 3px;">\r\n                                                <!-- HolidayCheck WL Case -->\r\n                                                <img\r\n                                                  moz-do-not-send="true"\r\nsrc="https://www.tripodo.de/images/whitelabel/holidaycheck/icono-users-blue.png"\r\n                                                  alt="" width="19"> </span>\r\n                                              <b>Anzahl der Reisenden</b><br>\r\n                                              2 Erwachsene </li>\r\n                                            <li style="float:left;\r\n                                              width:100%; margin-bottom:\r\n                                              12px; list-style-type:none\r\n                                              !important;\r\n                                              font-weight:normal;"> <span\r\n                                                class="iconspann"\r\n                                                style="width:20px;\r\n                                                height:28px;\r\n                                                margin-right:6px;\r\n                                                float:left;\r\n                                                margin-bottom: 3px;">\r\n                                                <!-- HolidayCheck WL Case -->\r\n                                                <img\r\n                                                  moz-do-not-send="true"\r\nsrc="https://www.tripodo.de/images/whitelabel/holidaycheck/icono-euro-blue.png"\r\n                                                  alt="" width="19"> </span>\r\n                                              <b>Grundreisepreis aller\r\n                                                Reiseteilnehmer</b><br>\r\n                                              <!-- HolidayCheck WL Case -->\r\n                                              <span class="orangecolor"\r\n                                                style="color:#6DB13F\r\n                                                !important;">€ 3.990</span>\r\n                                            </li>\r\n                                          </ul>\r\n                                          <a moz-do-not-send="true"\r\nhref="https://u1377392.ct.sendgrid.net/wf/click?upn=TU8V3C-2FkVgKPZlLJMN1lahCPjG5xLZOTM9Fh4gHu6OkaS0qwqsGp-2Fs4PDmsqGdvlJoQEIiIcV8fyiZlqqDBhCn8uUDwu-2FDtWqA018Hqx8dFrt3-2B4-2BKHp1uDTkw4qIKoR_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrT0O1sUNoq4qMTRx8tZMubfwQuZ5WewqprwXBHuKC7hzbNbGr6QOw6atc3L4cx8DYQ3FZw2sPwLsQ0nd181oEQY-2Bitnqyd9VauHXt7elEGA2ZqYqd3E6IOllgd5C0ocLlZurkzR-2FBJe54rpOPGNn66HQ-3D-3D"\r\n                                            title="Details und Buchung"\r\n                                            style="margin-top:15px;">\r\n                                            <!-- HolidayCheck WL Case -->\r\n                                            <img moz-do-not-send="true"\r\nsrc="https://www.tripodo.de/images/whitelabel/holidaycheck/detailsbutton.gif"\r\n                                              alt="Details und Buchung">\r\n                                          </a> </td>\r\n                                      </tr>\r\n                                    </tbody>\r\n                                  </table>\r\n                                </div>\r\n                              </div>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"><strong>Ihr\r\n                                  ausführliches Reiseangebot können Sie\r\n                                  bei Klick auf dem Button oberhalb\r\n                                  ansehen. </strong></p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;">Wenn Sie\r\n                                mit dem Angebot zufrieden sind, können\r\n                                Sie die Reise ganz bequem online buchen.\r\n                                Gemäß unserer Bestpreisgarantie buchen\r\n                                Sie bei HolidayCheck stets zum\r\n                                günstigsten Preis. </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"><span>Sollten\r\n                                  Sie noch Fragen oder Änderungswünsche\r\n                                  haben, stehe ich Ihnen zur\r\n                                  persönlichen Beratung gerne zur\r\n                                  Verfügung. Ich</span><span> freue mich\r\n                                  auf Ihre E-Mail an </span><span><a\r\n                                    moz-do-not-send="true"\r\n                                    class="moz-txt-link-abbreviated"\r\n                                    href="mailto:janine.weber@tripodo.de">janine.weber@tripodo.de</a></span>\r\n                                oder Ihren Anruf unter Tel. <span>089189658504</span>. </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;">Mit\r\n                                freundlichen Grüßen, </p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"><span>Janine\r\n                                  Weber</span></p>\r\n                              <p style="font-size: 14px; padding: 0px;\r\n                                margin: 0px; border: none; color:\r\n                                #444444; line-height: 17px;"> </p>\r\n                            </div>\r\n                          </td>\r\n                          <td style="font-size: 14px;padding:\r\n                            0px;margin: 0px;border: none;color:\r\n                            #444444;line-height: 19px;"\r\n                            bgcolor="#FFFFFF" valign="top" width="20"> </td>\r\n                        </tr>\r\n                        <tr style="">\r\n                          <td colspan="4" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            height="48"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#EDEDED" valign="top"> <img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/shadow-bottom.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="48" width="580"> </td>\r\n                        </tr>\r\n                        <tr style="">\r\n                          <td rowspan="2" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#ededed" width="20"> </td>\r\n                          <td colspan="2" class="footersmall"\r\n                            style="font-size: 14px;padding: 0px;margin:\r\n                            0px;border: none;color: #444444;line-height:\r\n                            19px;"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#ededed" valign="top">\r\n                            <div align="left">\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;">Haben Sie\r\n                                Fragen? Rufen Sie uns an unter 089 -\r\n                                1896585 02 oder schreiben Sie eine\r\n                                E-Mail an <a moz-do-not-send="true"\r\n                                  href="mailto://holidaycheck@tripodo.de"\r\n                                  target="_blank" style="color:\r\n                                  #777777;text-decoration:\r\n                                  underline;font-size: 11px !important;">holidaycheck@tripodo.de</a>.\r\n                                Wir sind gern für Sie da!</p>\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;"> </p>\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;"> </p>\r\n                              <table border="0" cellpadding="0"\r\n                                cellspacing="0" width="540">\r\n                                <tbody>\r\n                                  <tr>\r\n                                    <td width="270">\r\n                                      <p style="font-size: 11px\r\n                                        !important;padding: 0px;margin:\r\n                                        0px;border: none;color:\r\n                                        #777777;line-height: 14px;">\r\n                                        HolidayCheck AG<br style="">\r\n                                        Bahnweg 8<br style="">\r\n                                        8598 Bottighofen - Schweiz<br\r\n                                          style="">\r\n                                        <br style="">\r\n                                        E-Mail: <a\r\n                                          moz-do-not-send="true"\r\n                                          href="mailto://holidaycheck@tripodo.de"\r\n                                          target="_blank" style="color:\r\n                                          #777777;text-decoration:\r\n                                          underline;font-size: 11px\r\n                                          !important;">holidaycheck@tripodo.de</a>\r\n                                      </p>\r\n                                    </td>\r\n                                    <td width="270">\r\n                                      <p style="font-size: 11px\r\n                                        !important;padding: 0px;margin:\r\n                                        0px;border: none;color:\r\n                                        #777777;line-height: 14px;">\r\n                                        Geschäftsführung: Anja Keckeisen<br\r\n                                          style="">\r\n                                        Ust-ID: CHE-110.298.267 MWST<br\r\n                                          style="">\r\n                                        <br style="">\r\n                                        <br style="">\r\n                                        <br style="">\r\n                                        <a moz-do-not-send="true"\r\nhref="https://u1377392.ct.sendgrid.net/wf/click?upn=rqee373X0N-2BPFNvMhI5FLfubSefjwpe-2FZMb1aADlcKYrzV6kIBm1MUNOjYa4-2F9lA_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrTWu-2BpsodXAh-2FPy6Cn1Rr4LpPnuw72Cp1dN-2FBP50em6yJEpUMJSISVxYs72SnzTV2NLfJeJPZQ0-2BB63HdVNY0OIGgdJ1L7LMUjBjNwoAAfoS8SGyNdMx2Tjtnq0M-2F-2BkYkWQoJHIBiakhltHr-2F-2Fx0jp8w-3D-3D"\r\n                                          target="_blank" style="color:\r\n                                          #777777;text-decoration:\r\n                                          underline;font-size: 11px\r\n                                          !important;">http://www.holidaycheck.de/</a>\r\n                                      </p>\r\n                                    </td>\r\n                                  </tr>\r\n                                </tbody>\r\n                              </table>\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;"> </p>\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;"> </p>\r\n                              <p style="font-size: 11px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #777777;line-height: 14px;">© 2016 <a\r\n                                  moz-do-not-send="true"\r\n                                  class="moz-txt-link-freetext"\r\n                                  href="http://www.holidaycheck.de/">http://www.holidaycheck.de/</a>\r\n                                | Alle Beiträge und Fotos sind\r\n                                urheberrechtlich geschützt.<br style="">\r\n                              </p>\r\n                              <p style="font-size: 5px\r\n                                !important;padding: 0px;margin:\r\n                                0px;border: none;color:\r\n                                #EDEDED;line-height: 14px;">#n-176304#</p>\r\n                            </div>\r\n                          </td>\r\n                          <td rowspan="2" style="font-size:\r\n                            14px;padding: 0px;margin: 0px;border:\r\n                            none;color: #444444;line-height: 19px;"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#ededed" width="20"> </td>\r\n                        </tr>\r\n                        <tr style="">\r\n                          <td colspan="2" class="footersmall"\r\n                            style="font-size: 14px;padding: 0px;margin:\r\n                            0px;border: none;color: #444444;line-height:\r\n                            19px;"\r\n                            background="https://www.tripodo.de/images/email/back_backgroundimage.jpg"\r\n                            bgcolor="#ededed" valign="top"><img\r\n                              moz-do-not-send="true"\r\n                              src="https://www.tripodo.de/images/email/blank.gif"\r\n                              style="font-size: 14px;padding:\r\n                              0px;margin: 0px;border: none;color:\r\n                              #444444;" height="25" width="25"></td>\r\n                        </tr>\r\n                      </tbody>\r\n                    </table>\r\n                  </div>\r\n                </td>\r\n              </tr>\r\n            </tbody>\r\n          </table>\r\n        </div>\r\n        <img moz-do-not-send="true"\r\nsrc="https://u1377392.ct.sendgrid.net/wf/open?upn=prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrTGu4tDUm8Tn-2FGeSmdj3ZfDcXrTvn4mwD7mPgUIPHtxQCTJs7WiRCF9eYhcpR1pVvVbH22cgYpYFDx6De-2BvtQ4n2vqYmJWCO-2FPumhwOezydcGsvFnFq-2FBwE7OtPqSkARnJ-2B6VuDGTHAl2wy-2FLivqqqc-2BlemUv-2B8SxWx-2FESzkahCFA-3D"\r\n          alt="" style="height:1px !important;width:1px\r\n          !important;border-width:0 !important;margin-top:0\r\n          !important;margin-bottom:0 !important;margin-right:0\r\n          !important;margin-left:0 !important;padding-top:0\r\n          !important;padding-bottom:0 !important;padding-right:0\r\n          !important;padding-left:0 !important;" height="1" border="0"\r\n          width="1"> </blockquote>\r\n      <br>\r\n    </div>\r\n  </body>\r\n</html>\r\n\r\n', '\r\n\r\n\r\n-------- Weitergeleitete Nachricht --------\r\nBetreff:     Re: Ihr persönliches Reiseangebot von Holiday Check\r\nDatum:     Fri, 2 Dec 2016 00:37:16 +0100\r\nVon:     Klaus Düren <kdueren@ish.de>\r\nAn:     Kundenservice Tripodo GmbH <reiseservice@tripodo.de>\r\n\r\n\r\n\r\nHallo Frau Weber,\r\n\r\n\r\nzunächst einmal möchte ich mich für Ihre Bemühungen bedanken.\r\n\r\nDann möchte ich Sie bitten, falls Sie das beurteilen können, mir die \r\nVorzüge oder Nachteile der Reisen "vom Krügerpark bis zur Gartenroute" \r\nund "Südafrika Classics zum Kennenlernen" aufzuzeigen.\r\n\r\nDie erstgenannte Tour ist sehr preiswert und einen Tag länger, also auf \r\nden ersten Blick sehr interessant. Da wir Südafrika bisher nicht \r\nkennengelernt haben, können wir inhaltlich nicht Vor- oder Nachteile \r\nerkennen.\r\n\r\nDie Reise, die wir alternativ noch im Angebot haben, ist unter folgendem \r\nLink einzusehen. http://www.e-kolumbus.de/rundreise/69195\r\n\r\n\r\nIch würde mich sehr freuen, wenn Sie uns bei der Reiseentscheidung \r\nberaten könnten und werden auch gerne bei Ihnen buchen.\r\n\r\nWenn ein Telefonat angebracht wäre, möchte ich Sie bitten, mich Freitag \r\nab 16 Uhr mobil unter 016097651183 zu kontaktieren. (Natürlich nur dann, \r\nwenn Sie auch noch im Dienst sind)\r\n\r\n\r\nVielen Dank und herzliche Grüße\r\n\r\nKlaus Düren\r\n\r\n\r\nAm 28.11.2016 um 16:04 schrieb Kundenservice Tripodo GmbH:\r\n> HolidayCheck Notification\r\n>\r\n>         holidaycheck     \r\n>\r\n>\r\n>\r\n>         \r\n>     \r\n>\r\n>\r\n>     Guten Tag Herr Klaus Mathias Düren,\r\n>\r\n> herzlichen Dank für Ihre Reiseanfrage auf Holiday Check! Ich freue \r\n> mich sehr, Ihnen ein individuelles Angebot für die Reise /- \r\n> //Südafrika - Südafrika - Vom Krügerpark bis zur Gartenroute - / \r\n> unterbreiten zu können.\r\n>\r\n>\r\n>     Kurzversion Ihres Reiseangebotes\r\n>\r\n>\r\n>       Südafrika - Vom Krügerpark bis zur Gartenroute\r\n>\r\n> <https://u1377392.ct.sendgrid.net/wf/click?upn=TU8V3C-2FkVgKPZlLJMN1lahCPjG5xLZOTM9Fh4gHu6OkaS0qwqsGp-2Fs4PDmsqGdvlJoQEIiIcV8fyiZlqqDBhCn8uUDwu-2FDtWqA018Hqx8dFrt3-2B4-2BKHp1uDTkw4qIKoR_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrTS0J-2F0mjHwqh-2B12LXwyzGeD7aAolzdHhYjhLvC7PBlIabNX8DvqCDwTzf9nqbK1i-2BWqyRwIv-2B1VFTYh-2FCbJdd2Lfr4mN0Xog5pMrbQi74RdsuNoU3KSk39-2BX0vP7wk3-2FuiK4fmOvsPbSeOoMCquB3Sg-3D-3D> \r\n>     \r\n>\r\n>   * *Gewählter Reisezeitraum*\r\n>     20.10.2017 - 31.10.2017\r\n>   * *Anzahl der Reisenden*\r\n>     2 Erwachsene\r\n>   * *Grundreisepreis aller Reiseteilnehmer*\r\n>     € 3.990\r\n>\r\n> Details und Buchung \r\n> <https://u1377392.ct.sendgrid.net/wf/click?upn=TU8V3C-2FkVgKPZlLJMN1lahCPjG5xLZOTM9Fh4gHu6OkaS0qwqsGp-2Fs4PDmsqGdvlJoQEIiIcV8fyiZlqqDBhCn8uUDwu-2FDtWqA018Hqx8dFrt3-2B4-2BKHp1uDTkw4qIKoR_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrT0O1sUNoq4qMTRx8tZMubfwQuZ5WewqprwXBHuKC7hzbNbGr6QOw6atc3L4cx8DYQ3FZw2sPwLsQ0nd181oEQY-2Bitnqyd9VauHXt7elEGA2ZqYqd3E6IOllgd5C0ocLlZurkzR-2FBJe54rpOPGNn66HQ-3D-3D> \r\n>\r\n>\r\n> *Ihr ausführliches Reiseangebot können Sie bei Klick auf dem Button \r\n> oberhalb ansehen. *\r\n>\r\n> Wenn Sie mit dem Angebot zufrieden sind, können Sie die Reise ganz \r\n> bequem online buchen. Gemäß unserer Bestpreisgarantie buchen Sie bei \r\n> HolidayCheck stets zum günstigsten Preis.\r\n>\r\n> Sollten Sie noch Fragen oder Änderungswünsche haben, stehe ich Ihnen \r\n> zur persönlichen Beratung gerne zur Verfügung. Ich freue mich auf Ihre \r\n> E-Mail an janine.weber@tripodo.de oder Ihren Anruf unter Tel. \r\n> 089189658504.\r\n>\r\n> Mit freundlichen Grüßen,\r\n>\r\n> Janine Weber\r\n>\r\n>     \r\n>     \r\n>\r\n> Haben Sie Fragen? Rufen Sie uns an unter 089 - 1896585 02 oder \r\n> schreiben Sie eine E-Mail an holidaycheck@tripodo.de \r\n> <mailto://holidaycheck@tripodo.de>. Wir sind gern für Sie da!\r\n>\r\n> HolidayCheck AG\r\n> Bahnweg 8\r\n> 8598 Bottighofen - Schweiz\r\n>\r\n> E-Mail: holidaycheck@tripodo.de <mailto://holidaycheck@tripodo.de>\r\n>\r\n>     \r\n>\r\n> Geschäftsführung: Anja Keckeisen\r\n> Ust-ID: CHE-110.298.267 MWST\r\n>\r\n>\r\n>\r\n> http://www.holidaycheck.de/ \r\n> <https://u1377392.ct.sendgrid.net/wf/click?upn=rqee373X0N-2BPFNvMhI5FLfubSefjwpe-2FZMb1aADlcKYrzV6kIBm1MUNOjYa4-2F9lA_prmxCQ7XOMAdHPh8SLbXavF2zfoUsncv-2B9GAt7y7I-2B-2BaToP5NKECzGTeMkMT2HrTWu-2BpsodXAh-2FPy6Cn1Rr4LpPnuw72Cp1dN-2FBP50em6yJEpUMJSISVxYs72SnzTV2NLfJeJPZQ0-2BB63HdVNY0OIGgdJ1L7LMUjBjNwoAAfoS8SGyNdMx2Tjtnq0M-2F-2BkYkWQoJHIBiakhltHr-2F-2Fx0jp8w-3D-3D> \r\n>\r\n>\r\n> © 2016 http://www.holidaycheck.de/ | Alle Beiträge und Fotos sind \r\n> urheberrechtlich geschützt.\r\n>\r\n> #n-176304#\r\n>\r\n>     \r\n>\r\n\r\n\r\n', 27059, 0, 0, 0, '2016-12-02 00:40:05', 1, 0, 0, 0, 77, ''),


INSERT INTO `trpd_notifications_sg_events` (`eventID`, `eventType`, `eventDate`, `eventEmail`, `eventFull`, `eventUserID`, `eventViewedByAdminID`) VALUES
(110942, 'click', 1479572968, 'jennifermossmann100@hotmail.com', '{"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":"jennifermossmann100@hotmail.com","timestamp":1479572968,"url":"https:\\/\\/www.tripodo.de\\/ihr-reiseangebot\\/d5554f95cdecdc12abaa7549ccec3dd2\\/"}', 21121, 0),
(110943, 'open', 1479573307, 'jennifermossmann100@hotmail.com', '{"email":"jennifermossmann100@hotmail.com","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, 'jennifermossmann100@hotmail.com', '{"email":"jennifermossmann100@hotmail.com","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, 'venom.2000@gmx.de', '{"email":"venom.2000@gmx.de","timestamp":1479573365,"smtp-id":"<58307f74e36c8@tripodo.de>","sg_event_id":"8PmHHiEJSOyw4aVeXU1vEA","sg_message_id":"M6vJKaQsReaEhMr1WjNuNg.filter0960p1mdw1-15726-58307F75-1B.0","event":"processed"}', 21164, 0),
(110946, 'delivered', 1479573368, 'venom.2000@gmx.de', '{"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":"venom.2000@gmx.de","timestamp":1479573368,"smtp-id":"<58307f74e36c8@tripodo.de>"}', 21164, 0),
(110947, 'open', 1479573595, 'jennifermossmann100@hotmail.com', '{"email":"jennifermossmann100@hotmail.com","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, 'jennifermossmann100@hotmail.com', '{"email":"jennifermossmann100@hotmail.com","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),


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
(21855, '', 'Kanzek', 'xxzek@t-online.de', 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', 'hanneloreuhlig@gmx.de', 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', 'p2reiseportal@gmx.de', 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', 'kajuma@arcor.de', 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', 'rvlde@yahoo.de', 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', 'Christian.maenz@gmx.de', 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', 'silke-gricar@t-online.de', 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, '', '', ''),

DOWNLOAD LINK:


 
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.

Users who are viewing this thread

Home Register
Top Bottom