 |
Menu |
 |
|
Home |
| |
|
Discussions |
| |
|
Tools |
| |
|
Affiliates |
| |
|
Content |
| |
|
Info |
| | |
|
|
|
|
 |
User Info |
 |
Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 121
Members: 0
Total: 121
|
|
|
|
|
 |
Full disclosure |
 |
CyberDanube Security Research 20251014-0 | Multiple Vulnerabilities in Phoenix Contact QUINT4 UPS
apis.google.com - Insecure redirect via __lu parameter(exploited in the wild)
Urgent Security Vulnerabilities Discovered in Mercku Routers Model M6a
Re: Security Advisory: Multiple High-Severity Vulnerabilities in Suno.com (JWT Leakage, IDOR, DoS)
Security Advisory: Multiple High-Severity Vulnerabilities in Suno.com (JWT Leakage, IDOR, DoS)
[SBA-ADV-20250730-01] CVE-2025-39664: Checkmk Path Traversal
[SBA-ADV-20250724-01] CVE-2025-32919: Checkmk Agent Privilege Escalation via Insecure Temporary Files
CVE-2025-59397 - Open Web Analytics SQL Injection
Re: [FD]Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Re: Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Re: Defense in depth -- the Microsoft way (part 93): SRP/SAFERwhitelisting goes black on Windows 11
Re: [FD]: "Glass Cage" – Zero-Click iMessage ? Persistent iOS Compromise + Bricking (CVE-2025-24085 / 24201, CNVD-2025-07885)
Re: [FD]Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Samtools v1.22.1 Uncontrolled Memory Allocation from Large BED Intervals Causes Denial-of-Service in Samtools/HTSlib
Samtools v1.22.1 Improper Handling of Excessive Histogram Bin Counts in Samtools Coverage Leads to Stack Overflow
|
|
|
|
|
|
 |
|
 |
 |
|
 |
IT Security and Insecurity Portal |
|
 |
I have a slight problem... |
 |
Posted: Tue Sep 29, 2009 1:55 am |
|
|
tox1c |
Active user |

 |
|
Joined: Sep 22, 2009 |
Posts: 41 |
|
|
|
 |
 |
 |
|
Hey i just searched the forum but couldnt find what i was looking for.
Is there a tool around or a code that i can use to extract the emails salts and usernames from a database? i have the database in .sql format was wondering if theres a way to extract all the hashes salts and emails into a seperate notepad or something |
|
|
|
|
 |
 |
|
 |
Posted: Tue Sep 29, 2009 9:46 am |
|
|
cMD |
Advanced user |

 |
|
Joined: Sep 23, 2008 |
Posts: 67 |
|
|
|
 |
 |
 |
|
Code: | <?
error_reporting(0);
set_time_limit(0);
$filename = 'xxx.sql'; # sql дамп
$separator = ":"; # Разделитель
$mode = 1; # 2 режима, 0 - Нормальный (без чека мыла) 1 - чек мыла.
$columns = 'email,pswd'; # Выводить определенные колинки. Если не указывать, то парсится весь дамп.
$fd = fopen($filename, 'r');
while(!feof($fd)) {
$line = fgets($fd);
if(preg_match("/VALUES/i", $line))
preg_match_all("/INSERT\s+INTO\s+`.*`(\s+|)\(`(.*?)`\)/i", $line, $fields);
if($fields[1][0] != NULL)
$into = $fields[1][0];
else $into = $fields[2][0];
$parsed = explode('`, `', $into);
$column = regex($parsed, $line);
if($column[0][0] == true) {
if($columns == false)
$done = full_parse_dump($column);
else
$done = selectively($column);
if(modes($done) == true) {
qwrite($filename.'_out.txt', $done."\r\n");
//echo $done."\r\n";
}
}
}
function full_parse_dump($column) {
global $separator;
for($i = 1; $i < count($column); $i++) {
if($i == 1) $result = $column[$i][0];
else $result .= $separator.$column[$i][0];
} return $result;
}
function modes($in) {
global $mode;
if($mode == 0) {
return $in;
}
elseif ($mode == 1) {
preg_match("/([a-z0-9_\.\-]{1,20})@([a-z0-9\.\-]{1,20})\.([a-z]{2,4})/is", $in, $email);
if(validEmail($email[0]) == false)
return;
else
return $in;
}
return $cname;
}
function selectively($column) {
global $columns,$separator;
$first = true;
foreach(search_fields($columns) as $i) {
if($first == true) {
$parsed = $column[$i][0];
$first = false;
} else
$parsed .= $separator.$column[$i][0];
}
return $parsed;
}
function search_fields($fields) {
global $parsed;
$colname = explode(',', $fields);
foreach($parsed as $index => $name) {
foreach($colname as $cname) {
if($name == $cname)
$i_name[$name] = $index + 1;
}
}
if($i_name == null)
die("Fields -> ".$fields." <- Not Found!\n");
return sorting($i_name);
}
function sorting($cname) {
global $columns;
$coname = explode(',', $columns);
foreach($coname as $colname) {
foreach($cname as $index => $field) {
if($index == $colname)
$sort[] = $field;
}
}
return $sort;
}
function regex($fields, $line) {
for($i = 0; $i < count($fields); $i++) {
if($i == 0) $col = "'(.*?)'";
else $col .= ",\s+'(.*?)'";
}
preg_match_all("/VALUES\s+\(".$col."/i",$line, $column);
return $column;
}
function validEmail($email) {
$isValid = true;
if(!$atIndex = strrpos($email, "@"))
return false;
if (is_bool($atIndex) && !$atIndex) {
$isValid = false;
}
else {
$domain = substr($email, $atIndex+1);
$local = substr($email, 0, $atIndex);
$localLen = strlen($local);
$domainLen = strlen($domain);
if ($localLen < 1 || $localLen > 64) {
$isValid = false;
}
else if ($domainLen < 1 || $domainLen > 255) {
$isValid = false;
}
else if ($local[0] == '.' || $local[$localLen-1] == '.') {
$isValid = false;
}
else if (preg_match('/\\.\\./', $local)) {
$isValid = false;
}
else if (!preg_match('/^[A-Za-z0-9\\-\\.]+$/', $domain)) {
$isValid = false;
}
else if (preg_match('/\\.\\./', $domain)) {
$isValid = false;
}
else if(!preg_match('/^(\\\\.|[A-Za-z0-9!#%&`_=\\/$\'*+?^{}|~.-])+$/',
str_replace("\\\\","",$local))) {
if (!preg_match('/^"(\\\\"|[^"])+"$/',
str_replace("\\\\","",$local))) {
$isValid = false;
}
}
if ($isValid && !(checkdnsrr($domain,"MX") || checkdnsrr($domain,"A"))) {
$isValid = false;
}
}
return $email;
}
function qwrite($name, $content) {
if(!$file = @fopen($name, "a+")) exit;
fwrite($file, $content);
fclose($file);
}
?> |
|
|
|
|
|
 |
www.waraxe.us Forum Index -> Newbies corner
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|