search

herrBez / Nduja

Nduja is a software that de-anonymize crypto-currencies' addresses
BSD 3-Clause "New" or "Revised" License
4 stars 4 forks source link

DB-Preelaboration - Remove False Positive not belonging to our formats #52

Closed herrBez closed 6 years ago

herrBez commented 6 years ago

User: BALLANTYNE, keep only:

ETH --> 0x7eeee742374b979dd7fec1b165dc373a0d58952b, 0xc3Cc87CFD19521e55c27832EdDb2cAFE2577F28E

DOGE --> DQCjiuyFYtqAjVsdvVKhNKA2rsmGbxt3M4 BCH --> 1HkD9GGHD9mYdQEvTiryKQcsNcYP1Stzt, 129mMPtwjKce54FGE6rsRE4Ty2wFCKeQmr LTC --> LXLfDdpxLcPZVw1mX33CaSuVim9ax4fHQ2 BTC --> 1CqyYz717jUwENBraXAVr8hZtnK8k23vPK LTC --> LPvwrQjYzTfE8DJFmpdcpjNw9zeuhxhdE6

mzanella commented 6 years ago

-.-

mzanella commented 6 years ago 
DELETE FROM Wallet WHERE Address IN(
    SELECT aw.Wallet
    FROM AccountWallet as aw INNER JOIN Account as a INNER JOIN Wallet as w 
    WHERE a._id = aw.Account AND w.Address = aw.Wallet and a.Username LIKE 'BALLANTYNE'
);

DELETE FROM AccountWallet WHERE Account = 1408;

INSERT INTO Wallet(Address, Currency, Status, Inferred) VALUES
('0x7eeee742374b979dd7fec1b165dc373a0d58952b', 'ETH', 1, 0),
('0xc3Cc87CFD19521e55c27832EdDb2cAFE2577F28E', 'ETH', 1, 0),
('DQCjiuyFYtqAjVsdvVKhNKA2rsmGbxt3M4', 'DOGE', 1, 0),
('1HkD9GGHD9mYdQEvTiryKQcsNcYP1Stzt', 'BCH', 1, 0),
('129mMPtwjKce54FGE6rsRE4Ty2wFCKeQmr', 'BCH', 1, 0),
('LXLfDdpxLcPZVw1mX33CaSuVim9ax4fHQ2', 'LTC', 1, 0),
('1CqyYz717jUwENBraXAVr8hZtnK8k23vPK', 'BTC', 1, 0),
('LPvwrQjYzTfE8DJFmpdcpjNw9zeuhxhdE6', 'LTC', 1, 0);

INSERT INTO AccountWallet(Account, Wallet, RawURL) VALUES
(1408, '0x7eeee742374b979dd7fec1b165dc373a0d58952b', 'https://raw.githubusercontent.com/ballantyne/livecoin-tcp/e843b6e16b0aff3b57dbcec045bf755899f98ef8/README.md'),
(1408, '0xc3Cc87CFD19521e55c27832EdDb2cAFE2577F28E', 'https://raw.githubusercontent.com/ballantyne/node-paperclip-mock-file-system/5108e683a17c5edc2bea4fd3b8880edd15650d73/README.md'),
(1408, 'DQCjiuyFYtqAjVsdvVKhNKA2rsmGbxt3M4', 'https://raw.githubusercontent.com/ballantyne/livecoin/5329d71854f304bf4913513ef3865c3001937b04/README.md'),
(1408, '1HkD9GGHD9mYdQEvTiryKQcsNcYP1Stzt', 'https://raw.githubusercontent.com/ballantyne/livecoin-tcp/e843b6e16b0aff3b57dbcec045bf755899f98ef8/README.md'),
(1408, '129mMPtwjKce54FGE6rsRE4Ty2wFCKeQmr', 'https://raw.githubusercontent.com/ballantyne/node-paperclip-mock-file-system/5108e683a17c5edc2bea4fd3b8880edd15650d73/README.md'),
(1408, 'LXLfDdpxLcPZVw1mX33CaSuVim9ax4fHQ2', 'https://raw.githubusercontent.com/ballantyne/livecoin-tcp/e843b6e16b0aff3b57dbcec045bf755899f98ef8/README.md'),
(1408, '1CqyYz717jUwENBraXAVr8hZtnK8k23vPK', 'https://raw.githubusercontent.com/ballantyne/node-paperclip-mock-file-system/5108e683a17c5edc2bea4fd3b8880edd15650d73/README.md'),
(1408, 'LPvwrQjYzTfE8DJFmpdcpjNw9zeuhxhdE6', 'https://raw.githubusercontent.com/ballantyne/node-paperclip-mock-file-system/5108e683a17c5edc2bea4fd3b8880edd15650d73/README.md');