Go Back   Xisp.org Forums > Porn Password Cracking > Porn Password Cracking Help Section

how to leech email from database

Reply
Views: 1198 - Replies: 15  
Thread Tools Display Modes

how to leech email from database
Old 08-20-2005, 08:12 AM   #1
joechang
Guest
 
Posts: n/a
Threads: 5107
Default how to leech email from database

such kind of database information
how can i leech email???

INSERT INTO `members` VALUES ('ds9d9', 'asdf', '$1$b2z/pCw1$O9Iwp2j6jz3QT', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('fd9d5', '555', '$1$EUZ479dK$a2xo.uH8R8IZY', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('dsf8d', 'asdf', '$1$vQic0ZVa$i6xtXMvKdNHV/', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('d3333', 'dfdfd', '$1$Z.HWa/jN$1ht5O185mGdUu', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('asd333', 'asdf3', '$1$Ibx84jTF$ahwXMyMSQmVq/', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('test', 'testpassword', '$1$ZP55yZKA$M22Bo6B3Ub/Um', 'test@test.com', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');






and those are different


INSERT INTO `members` VALUES (602, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (642, 'BrianTest', '', '', '', '', '77580', '', 'brianscook@att.net', 'brianscook@att.net', 'password', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (603, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (1039, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";username|N;passtext|N;firstname|N;lastname|N;address|N;ci ty|N;state|N;zip|N;phone|N;email|N;number|i:1;numcurved|i:0;numfront|i:0;height| a:1:{i:0;s:2:"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1 :{i:0;s:2:"no";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666 666663587648145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544 8084771633148193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor| s:5:"white";gridwork|s:2:"no";randuser|N;', '', '15285');
INSERT INTO `members` VALUES (604, 'Sam', 'Tranchina', '2802 9th Street N', 'Texas City', 'Texas', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (679, 'Brian', '', '', '', '', '77580', '', 'brianscook@att.net', 'brianscook@att.net', 'password', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');


please help
  Reply With Quote

Old 08-20-2005, 08:16 AM   #2
Worldworier
WarLord
 
Worldworier's Avatar
 
Worldworier is offline Offline
Join Date: Jan 2005
Location: Germany
Posts: 694
Threads: 19
Worldworier is on a distinguished road
Default

try ultra edit

custumize your sort / search criteria

Looks like a user DB (SQL i think)
put any wamp on your system and work with the DB
__________________
---------------Fighting for free Porn----------------

Last edited by Worldworier; 08-20-2005 at 08:18 AM..
  Reply With Quote

Old 08-20-2005, 10:53 AM   #3
Jayman
Site Cracker
 
Jayman is offline Offline
Join Date: Jan 2005
Posts: 1,004
Threads: 104
Jayman is on a distinguished road
Default

http://home.hccnet.nl/s.j.francke/software/software.htm

CSVed

A freeware program

Notes on the Modify Tab
You will see a section under this tab called Set Seperator. The Set Seperator is a Delimiter, or how the Fields in the database are seperated. In both your examples the databases use the comma , Symbol. Another example is that Wordlists are commonly seperated by a colon :

- Select the Comma for your Set Seperator then Open your File
- Click the Edit from the Tool Menu, Click on Repair CSV
- Click on the Save Tab
- Tick on the Columns to save, (the Columns you want to leech from, you'll need to choose the column number where the email addy is)
- Tick Use Selected Columns
- Set Seperator, click on the Other Option and type in : (a colon)
- Click on the Save Selection Button and save your leeched file.

Some further Notes

Once you've got your smaller file you may want to swap columns around

- Modify Tab
- Choose your Set Seperator, if it was the file we just Saved then we'll choose the Other Option and put in : (a colon)
- Now Open your File
- Click on the Add Column Button. This will add a Column at the End
- In the Copy Column Section, Choose the Source Column (for Example Column 1, we want to copy the first Column) and then the Target Column. Lets say this is Column 3, it will be the Column you just added.
- Click on the Copy Column Button

Now you can either Delete Column 1 and Save your File, or you can save it via the Save Tab Choosing Columns 2 and 3

Last edited by Jayman; 08-20-2005 at 11:07 AM..
  Reply With Quote

Old 08-20-2005, 12:14 PM   #4
slysnake
Cheshire Cat
 
slysnake's Avatar
 
slysnake is offline Offline
Join Date: Jan 2005
Posts: 5,507
Threads: 315
slysnake is on a distinguished road
Default

Nice tool, thanks Jayman
__________________
"How do you know I'm mad?" said Alice.
"You must be," said the Cat, "or you wouldn't have come here."
  Reply With Quote

Old 08-20-2005, 02:34 PM   #5
sPlico
The sPlicster
 
sPlico's Avatar
 
sPlico is offline Offline
Join Date: Jan 2005
Location: Croatia
Posts: 9,486
Threads: 407
sPlico is on a distinguished road
Default

New tool for me aswell. Thanks Jayman. I usually use ultraedit and stupidripper for this.
  Reply With Quote

Old 08-21-2005, 12:43 AM   #6
daemon.azazel
Platinum Exploiter
 
daemon.azazel's Avatar
 
daemon.azazel is offline Offline
Join Date: Aug 2005
Location: Eastern Europe
Posts: 1,324
Threads: 104
daemon.azazel is on a distinguished road
Default

lol guys - you can do this in 3 minutes in MS Excel ;)
  Reply With Quote

Old 08-21-2005, 07:01 AM   #7
sPlico
The sPlicster
 
sPlico's Avatar
 
sPlico is offline Offline
Join Date: Jan 2005
Location: Croatia
Posts: 9,486
Threads: 407
sPlico is on a distinguished road
Default

How's your excel in loading 40 meg files?
  Reply With Quote

Old 08-22-2005, 01:14 PM   #8
daemon.azazel
Platinum Exploiter
 
daemon.azazel's Avatar
 
daemon.azazel is offline Offline
Join Date: Aug 2005
Location: Eastern Europe
Posts: 1,324
Threads: 104
daemon.azazel is on a distinguished road
Default

hahahaha splico, that's right excel supports only 65536 lines,
but to be honest, all such files i processed so far were under
this so sorry for my rude notice ;)
  Reply With Quote

Old 08-22-2005, 02:07 PM   #9
sPlico
The sPlicster
 
sPlico's Avatar
 
sPlico is offline Offline
Join Date: Jan 2005
Location: Croatia
Posts: 9,486
Threads: 407
sPlico is on a distinguished road
Default

Lol, it's ok. Was just a question as i never used excel for that as it usually hung on "bigger" files on my comp, but im on win98, so i always thought that might be the problem.
  Reply With Quote

Old 08-23-2005, 05:45 AM   #10
joechang
Guest
 
Posts: n/a
Threads: 5107
Default

thank you Jayman, it is a new tool for me
  Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -4. The time now is 09:55 AM.


vBulletin skin developed by: Xisp.org Crew
Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
2005 Copyright Xisp.org