File indexing completed on 2024-04-14 05:53:06
0001 DROP TABLE `member_paypal`; 0002 CREATE TABLE `member_paypal` 0003 ( 0004 `id` INT(11) NOT NULL AUTO_INCREMENT, 0005 `member_id` INT(11) NULL DEFAULT NULL, 0006 `paypal_address` VARCHAR(150) NULL DEFAULT NULL, 0007 `is_active` INT(1) NOT NULL DEFAULT '1', 0008 `name` VARCHAR(150) NULL DEFAULT NULL, 0009 `address` VARCHAR(150) NULL DEFAULT NULL, 0010 `currency` VARCHAR(150) NULL DEFAULT NULL, 0011 `country_code` VARCHAR(150) NULL DEFAULT NULL, 0012 `last_payment_status` VARCHAR(150) NULL DEFAULT NULL, 0013 `last_payment_amount` DOUBLE NULL DEFAULT NULL, 0014 `last_transaction_id` VARCHAR(50) NULL DEFAULT NULL, 0015 `last_transaction_event_code` VARCHAR(50) NULL DEFAULT NULL, 0016 `created_at` TIMESTAMP NULL DEFAULT NULL, 0017 `changed_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 0018 PRIMARY KEY (`id`) 0019 ) 0020 COLLATE = 'utf8_general_ci' 0021 ENGINE = InnoDB 0022 AUTO_INCREMENT = 74 0023 ; 0024 0025 ALTER TABLE `member_paypal` 0026 ADD UNIQUE INDEX `uk_paypal_address` (`paypal_address`); 0027 0028 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0029 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0030 `created_at`) 0031 VALUES ('Алексей Варфоломеев', 'Completed', 'RUB', '-21870.12', 'varlesh@gmail.com', '7KK96863AX5754344', 0032 'Алексей, Варфоломеев', 'T0000', 'RU', NOW()); 0033 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0034 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0035 `created_at`) 0036 VALUES ('Paul Beyens', 'Completed', 'EUR', '-245.42', 'paulbeyens@gmail.com', '96661567PS4341036', 'Paul, Beyens', 0037 'T0000', 'BE', NOW()); 0038 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0039 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0040 `created_at`) 0041 VALUES ('LE MAOUT GUILLAUME', 'Completed', 'EUR', '-94.48', 'exebetche@hotmail.fr', '7F337922WT999935X', 0042 'LE MAOUT, GUILLAUME', 'T0000', 'FR', NOW()); 0043 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0044 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0045 `created_at`) 0046 VALUES ('', 'Pending', 'USD', '-92.25', 'talamelli@libero.it', '3M436460MU296622V', '', 'T0000', '', NOW()); 0047 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0048 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0049 `created_at`) 0050 VALUES ('Brook Hill', 'Completed', 'USD', '-90.20', 'music_is4thesoul@yahoo.com', '8GG56561YA353312S', 'Brook, Hill', 0051 'T0000', 'US', NOW()); 0052 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0053 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0054 `created_at`) 0055 VALUES ('Keefer Rourke', 'Completed', 'CAD', '-113.03', 'keefer.rourke@gmail.com', '1DC62380HC6218649', 0056 'Keefer, Rourke', 'T0000', 'CA', NOW()); 0057 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0058 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0059 `created_at`) 0060 VALUES ('Ahmed Alharbi', 'Completed', 'USD', '-80.26', 'rsamalmot@gmail.com', '9EY96472EY000824V', 'Ahmed, Alharbi', 0061 'T0000', 'SA', NOW()); 0062 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0063 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0064 `created_at`) 0065 VALUES ('Matthieu James', 'Completed', 'EUR', '-63.42', 'matthieu.james@gmail.com', '2SY20996GF419200K', 0066 'Matthieu, James', 'T0000', 'FR', NOW()); 0067 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0068 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0069 `created_at`) 0070 VALUES ('CHRISTOPHER HOLLAND', 'Completed', 'CAD', '-90.56', 'zrenfire@gmail.com', '1UL56145SN3373905', 0071 'CHRISTOPHER, HOLLAND', 'T0000', 'CA', NOW()); 0072 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0073 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0074 `created_at`) 0075 VALUES ('eRescue', 'Completed', 'USD', '-66.47', 'jmtodaro@gmail.com', '99J12880X84142501', 'jeremy, todaro', 'T0000', 0076 'US', NOW()); 0077 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0078 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0079 `created_at`) 0080 VALUES ('Michail Vourlakos', 'Completed', 'EUR', '-44.59', 'mvourlakos@gmail.com', '6FA17975VJ3169237', 0081 'Michail, Vourlakos', 'T0000', 'GR', NOW()); 0082 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0083 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0084 `created_at`) 0085 VALUES ('源斯 刘', 'Completed', 'USD', '-50.70', '1151548973@qq.com', '8HC22880PR727672Y', '源斯, 刘', 'T0000', 'C2', NOW()); 0086 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0087 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0088 `created_at`) 0089 VALUES ('yanev', 'Completed', 'EUR', '-42.06', 'gericom.hummer@gmail.com', '1P966741WA233501Y', 'Nikola, Yanev', 0090 'T0000', 'BG', NOW()); 0091 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0092 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0093 `created_at`) 0094 VALUES ('RAVEfinity Open Source Design Project.', 'Completed', 'USD', '-45.71', 'ravefinity@ravefinity.com', 0095 '67A45065856497501', 'Jared, Soto', 'T0000', 'US', NOW()); 0096 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0097 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0098 `created_at`) 0099 VALUES ('Doyle Harpole', 'Completed', 'USD', '-37.72', 'kubuntu4172@yahoo.com', '2UK688847E0212107', 'Doyle, Harpole', 0100 'T0000', 'US', NOW()); 0101 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0102 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0103 `created_at`) 0104 VALUES ('Dindin Hernawan', 'Completed', 'USD', '-36.56', 'dindin_hernawan@yahoo.com', '9TB91656EM146414W', 0105 'Dindin, Hernawan', 'T0000', 'ID', NOW()); 0106 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0107 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0108 `created_at`) 0109 VALUES ('Michele Guerra', 'Completed', 'EUR', '-30.66', 'mike.ieee1@gmail.com', '85J96429SE204210U', 'Michele, Guerra', 0110 'T0000', 'IT', NOW()); 0111 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0112 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0113 `created_at`) 0114 VALUES ('Charlie Henson', 'Completed', 'USD', '-35.18', 'microfreaks@gmail.com', '8LK70351BP7068617', 'Charlie, Henson', 0115 'T0000', 'US', NOW()); 0116 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0117 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0118 `created_at`) 0119 VALUES ('DRA', 'Completed', 'EUR', '-28.65', 'daniruizdealegria@gmail.com', '26N24064E8419024F', 0120 'Daniel, Ruiz De Alegría', 'T0000', 'ES', NOW()); 0121 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0122 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0123 `created_at`) 0124 VALUES ('Holger Jaintsch', 'Pending', 'USD', '-25.04', 'hjaintsch@gmail.com', '2HL03710N2255450C', 'Holger, Jaintsch', 0125 'T0000', 'DE', NOW()); 0126 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0127 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0128 `created_at`) 0129 VALUES ('Oliver Scholtz', 'Completed', 'EUR', '-20.22', 'scholli_tz@yahoo.de', '5NX21697YB5246447', 'Oliver, Scholtz', 0130 'T0000', 'ES', NOW()); 0131 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0132 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0133 `created_at`) 0134 VALUES ('Rudra Banerjee', 'Completed', 'SEK', '-182.78', 'bnrj.rudra@live.com', '7SJ50339R9869084T', 'Rudra, Banerjee', 0135 'T0000', 'SE', NOW()); 0136 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0137 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0138 `created_at`) 0139 VALUES ('Sam Hewitt', 'Completed', 'CAD', '-25.90', 'hewittsamuel@gmail.com', '7UR19536RV483230G', 'Sam, Hewitt', 0140 'T0000', 'CA', NOW()); 0141 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0142 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0143 `created_at`) 0144 VALUES ('Daniel Faust', 'Pending', 'USD', '-15.78', 'hessijames@ymail.com', '5S9857397H8836636', 'Daniel, Faust', 0145 'T0000', 'DE', NOW()); 0146 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0147 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0148 `created_at`) 0149 VALUES ('Stolmet Żywiec Michał Dybczak', 'Completed', 'PLN', '-52.91', 'biuro@stolmet-zywiec.pl', '40V40234RC0517103', 0150 'Michał, Dybczak', 'T0000', 'PL', NOW()); 0151 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0152 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0153 `created_at`) 0154 VALUES ('Milen Simic', 'Completed', 'EUR', '-12.02', 'milen.simic@gmail.com', '10809685DG1768543', 'Milen, Simic', 0155 'T0000', 'RS', NOW()); 0156 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0157 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0158 `created_at`) 0159 VALUES ('Pierre ORANGE', 'Completed', 'EUR', '-11.65', 'fruit94@msn.com', '5BD115921T533740F', 'Pierre, ORANGE', 0160 'T0000', 'FR', NOW()); 0161 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0162 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0163 `created_at`) 0164 VALUES ('Alessandro Roncone', 'Completed', 'EUR', '-11.24', 'alecive87@gmail.com', '2SN30584LL049141H', 0165 'Alessandro, Roncone', 'T0000', 'IT', NOW()); 0166 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0167 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0168 `created_at`) 0169 VALUES ('Nattapong Pullkhow', 'Completed', 'USD', '-13.03', 'exenatt@gmail.com', '0CV65795G9635992N', 0170 'Nattapong, Pullkhow', 'T0000', 'TH', NOW()); 0171 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0172 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0173 `created_at`) 0174 VALUES ('Максим Орлов', 'Completed', 'USD', '-12.56', 'uubboo@gmail.com', '36D61468MR0997132', 'Максим, Орлов', 'T0000', 0175 'RU', NOW()); 0176 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0177 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0178 `created_at`) 0179 VALUES ('John Goodland', 'Completed', 'JPY', '-1107.00', 'zan642@gmail.com', '1EG313746H690200S', 'John, Goodland', 0180 'T0000', 'AU', NOW()); 0181 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0182 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0183 `created_at`) 0184 VALUES ('alexis duca', 'Completed', 'EUR', '-8.88', 'finonino26@gmail.com', '2HD847814J4891837', 'alexis, duca', 0185 'T0000', 'FR', NOW()); 0186 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0187 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0188 `created_at`) 0189 VALUES ('stephane sansonetti', 'Completed', 'EUR', '-8.61', 'steftrikia@gmail.com', '9TK45357NR821725B', 0190 'stephane, sansonetti', 'T0000', 'FR', NOW()); 0191 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0192 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0193 `created_at`) 0194 VALUES ('Kristofer Rickheden Gustavsson', 'Completed', 'SEK', '-83.99', 'hackan@mbox301.tele2.se', '8C058888879369153', 0195 'Kristofer, Rickheden Gustavsson', 'T0000', 'SE', NOW()); 0196 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0197 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0198 `created_at`) 0199 VALUES ('chris stanko', 'Completed', 'USD', '-10.00', '3gs32g@gmail.com', '9R125975B8300333G', 'chris, stanko', 'T0000', 0200 'CA', NOW()); 0201 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0202 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0203 `created_at`) 0204 VALUES ('Jelena Narezkina', 'Completed', 'EUR', '-7.50', 'jelena.narezkina@gmail.com', '5M148944SD7341924', 0205 'Jelena, Narezkina', 'T0000', 'LT', NOW()); 0206 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0207 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0208 `created_at`) 0209 VALUES ('Karoly Barcza', 'Completed', 'GBP', '-6.20', 'donate@blackpanther.hu', '2MM70282L7713503K', 'Karoly, Barcza', 0210 'T0000', 'GB', NOW()); 0211 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0212 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0213 `created_at`) 0214 VALUES ('felipe aristizabal', 'Completed', 'USD', '-8.31', 'wfpaisa@gmail.com', '3S572330VV0356111', 0215 'felipe, aristizabal', 'T0000', 'CO', NOW()); 0216 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0217 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0218 `created_at`) 0219 VALUES ('Anton Gonzalez', 'Completed', 'USD', '-123.56', 'anzigo@gmail.com', '3L864047FA6931700', 'Anton, Gonzalez', 0220 'T0000', 'TT', NOW()); 0221 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0222 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0223 `created_at`) 0224 VALUES ('Jani Lindholm', 'Completed', 'EUR', '-6.85', 'paypal@em.tunk.org', '3SG398139W115384W', 'Jani, Lindholm', 0225 'T0000', 'FI', NOW()); 0226 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0227 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0228 `created_at`) 0229 VALUES ('Holger Jaintsch', 'Completed', 'USD', '-25.04', 'hjaintsch@gmail.com', '2HL03710N2255450C', 'Holger, Jaintsch', 0230 'T0000', 'DE', NOW()); 0231 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0232 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0233 `created_at`) 0234 VALUES ('Daniel Faust', 'Completed', 'USD', '-15.78', 'hessijames@ymail.com', '5S9857397H8836636', 'Daniel, Faust', 0235 'T0000', 'DE', NOW()); 0236 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0237 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0238 `created_at`) 0239 VALUES ('József Makay', 'Completed', 'HUF', '-2028.00', 'makay.jozsef@gmail.com', '9WE09084XB549024S', 'József, Makay', 0240 'T0000', 'HU', NOW()); 0241 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0242 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0243 `created_at`) 0244 VALUES ('Darin Liebegott', 'Completed', 'USD', '-7.65', 'newhoa@gmail.com', '6WK65505WT041512U', 'Darin, Liebegott', 0245 'T0000', 'US', NOW()); 0246 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0247 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0248 `created_at`) 0249 VALUES ('Antonio Orefice', 'Completed', 'EUR', '-6.45', 'kokoko3k@gmail.com', '2DG114378U707135L', 'Antonio, Orefice', 0250 'T0000', 'IT', NOW()); 0251 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0252 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0253 `created_at`) 0254 VALUES ('Konrad Stahlhofer', 'Completed', 'USD', '-7.43', 'bluedxca93@googlemail.com', '1H6504536W0007106', 0255 'Konrad, Stahlhofer', 'T0000', 'DE', NOW()); 0256 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0257 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0258 `created_at`) 0259 VALUES ('Everaldo Coelho', 'Completed', 'USD', '-6.99', 'everaldo@everaldo.com', '5LR93545UP308074U', 0260 'Everaldo, Coelho', 'T0000', 'US', NOW()); 0261 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0262 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0263 `created_at`) 0264 VALUES ('pling.it', 'Completed', 'USD', '-10.10', 'payment@pling.it', '2XS937018E529852G', 'Clemens, Toennies', 'T0000', 0265 'US', NOW()); 0266 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0267 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0268 `created_at`) 0269 VALUES ('pling.it', 'Completed', 'USD', '-1.00', 'payment@pling.it', '3WC96957X72670451', 'Clemens, Toennies', 'T0000', 0270 'US', NOW()); 0271 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0272 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0273 `created_at`) 0274 VALUES ('alessandro rei', 'Completed', 'EUR', '-5.81', 'mentalrey@gmail.com', '7L627466BJ432823Y', 'alessandro, rei', 0275 'T0000', 'IT', NOW()); 0276 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0277 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0278 `created_at`) 0279 VALUES ('Tobias Kaiser', 'Pending', 'USD', '-6.76', 'tobi012@gmx.de', '7YT33817RJ175681T', 'Tobias, Kaiser', 'T0000', 0280 'DE', NOW()); 0281 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0282 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0283 `created_at`) 0284 VALUES ('Christophe Bricheux-Duchossois', 'Completed', 'EUR', '-5.78', 'lefteye92@free.fr', '2HF89418AM1281924', 0285 'Christophe, Bricheux-Duchossois', 'T0000', 'FR', NOW()); 0286 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0287 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0288 `created_at`) 0289 VALUES ('Scott Ferguson', 'Completed', 'AUD', '-8.51', 's.cottscottf@gmail.com', '9VE84679U1239605B', 'Scott, Ferguson', 0290 'T0000', 'AU', NOW()); 0291 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0292 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0293 `created_at`) 0294 VALUES ('Ernesto Acosta', 'Completed', 'USD', '-6.61', 'elavdeveloper@gmail.com', '31D92286AS017950E', 0295 'Ernesto, Acosta', 'T0000', 'US', NOW()); 0296 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0297 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0298 `created_at`) 0299 VALUES ('Christopher Wood', 'Completed', 'CAD', '-8.31', 'frosspc@gmail.com', '9EC909814Y156190K', 'Christopher, Wood', 0300 'T0000', 'CA', NOW()); 0301 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0302 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0303 `created_at`) 0304 VALUES ('Tory Gaurnier', 'Completed', 'USD', '-6.18', 'KoRnKloWn@linuxmail.org', '10012372KS0103230', 'Tory, Gaurnier', 0305 'T0000', 'US', NOW()); 0306 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0307 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0308 `created_at`) 0309 VALUES ('Georg Eckert', 'Pending', 'USD', '-5.94', 'lion.d.gem.heart@gmail.com', '83C754513D680272U', 'Georg, Eckert', 0310 'T0000', 'DE', NOW()); 0311 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0312 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0313 `created_at`) 0314 VALUES ('Александр Якубов', 'Completed', 'RUB', '-330.58', 'World-fly@yandex.ru', '7NB86158FR736702N', 0315 'Александр, Якубов', 'T0000', 'RU', NOW()); 0316 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0317 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0318 `created_at`) 0319 VALUES ('Miha Čančula', 'Completed', 'EUR', '-4.95', 'miha.cancula@gmail.com', '3JM45056RV7515218', 'Miha, Čančula', 0320 'T0000', 'SI', NOW()); 0321 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0322 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0323 `created_at`) 0324 VALUES ('', 'Pending', 'USD', '-41.22', 'celli.mode@web.de', '23U45596HP4305453', '', 'T0000', '', NOW()); 0325 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0326 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0327 `created_at`) 0328 VALUES ('Daboribo Linux', 'Completed', 'USD', '-31.25', 'etles.team@gmail.com', '81232928MU912032S', 0329 'Erwin, Edy Cahyono', 'T0000', 'ID', NOW()); 0330 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0331 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0332 `created_at`) 0333 VALUES ('Антон Тихомиров', 'Completed', 'RUB', '-872.08', 'Diamond.kde@yahoo.com', '35776372FX094794U', 0334 'Антон, Тихомиров', 'T0000', 'RU', NOW()); 0335 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0336 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0337 `created_at`) 0338 VALUES ('Lars Acou', 'Completed', 'EUR', '-4.88', 'lars.acou@telenet.be', '8FP47977YF2401717', 'Lars, Acou', 'T0000', 0339 'BE', NOW()); 0340 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0341 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0342 `created_at`) 0343 VALUES ('Jean-Alexandre Anglès d\'Auriac', 'Completed', 'EUR', '-4.79', 'jagw40k@free.fr', '9J663139LD2104335', 0344 'Jean-Alexandre, Anglès d\'Auriac', 'T0000', 'FR', NOW()); 0345 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0346 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0347 `created_at`) 0348 VALUES ('James Hardy', 'Completed', 'GBP', '-4.05', 'jameshardy88@gmail.com', '0TJ05858BP1667740', 'James, Hardy', 0349 'T0000', 'GB', NOW()); 0350 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0351 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0352 `created_at`) 0353 VALUES ('Stefano Rosselli', 'Completed', 'USD', '-5.29', 'bloomind.studio@gmail.com', '43P939541K426654C', 0354 'Stefano, Rosselli', 'T0000', 'CH', NOW()); 0355 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0356 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0357 `created_at`) 0358 VALUES ('Daniel Fore', 'Completed', 'USD', '-5.29', 'Daniel.P.Fore@gmail.com', '8XX1253526902043D', 'Daniel, Fore', 0359 'T0000', 'US', NOW()); 0360 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0361 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0362 `created_at`) 0363 VALUES ('Leszek Lesner', 'Pending', 'USD', '-5.04', 'leszek.lesner@web.de', '23V003349H478045E', 'Leszek, Lesner', 0364 'T0000', 'DE', NOW()); 0365 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0366 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0367 `created_at`) 0368 VALUES ('Robert Bosak', 'Completed', 'USD', '-4.97', 'BBOSAK2143@gmail.com', '5G716149E3425380F', 'Robert, Bosak', 0369 'T0000', 'US', NOW()); 0370 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0371 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0372 `created_at`) 0373 VALUES ('Piotr Arłukowicz', 'Completed', 'EUR', '-4.03', 'piotao@gmail.com', '5P191039R5161262M', 'Piotr, Arłukowicz', 0374 'T0000', 'PL', NOW()); 0375 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0376 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0377 `created_at`) 0378 VALUES ('Stefan Siegl', 'Pending', 'USD', '-4.58', 'sis@soulinsadness.de', '1KM71136EH2876453', 'Stefan, Siegl', 0379 'T0000', 'DE', NOW()); 0380 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0381 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0382 `created_at`) 0383 VALUES ('Leszek Lesner', 'Completed', 'USD', '-5.04', 'leszek.lesner@web.de', '23V003349H478045E', 'Leszek, Lesner', 0384 'T0000', 'DE', NOW()); 0385 INSERT INTO `member_paypal` (`name`, `last_payment_status`, `currency`, `last_payment_amount`, `paypal_address`, 0386 `last_transaction_id`, `address`, `last_transaction_event_code`, `country_code`, 0387 `created_at`) 0388 VALUES ('Tobias Kaiser', 'Completed', 'USD', '-6.76', 'tobi012@gmx.de', '7YT33817RJ175681T', 'Tobias, Kaiser', 'T0000', 0389 'DE', NOW()); 0390 0391 0392 #select * from member_paypal p 0393 UPDATE `member_paypal` `p` 0394 JOIN `member` `m` ON `m`.`paypal_mail` = `p`.`paypal_address` 0395 SET `p`.`member_id` = `m`.`member_id` 0396 WHERE `p`.`member_id` IS NULL; 0397