 |
Menu |
 |
|
 Home |
| |
|
 Discussions |
| |
|
 Tools |
| |
|
| Affiliates |
| |
|
 Content |
| |
|
 Info |
| | |
|
|
|
|
|
User Info |
|
 Membership:
 Latest: MichaelSnaRe
 New Today: 0
 New Yesterday: 0
 Overall: 9144
 People Online:
 Visitors: 131
 Members: 0
 Total: 131
|
|
|
|
|
|
Full disclosure |
|
|
|
 |
|
 |
 |
|
 |
IT Security and Insecurity Portal |
|
|
PHP SQL Downloader Script (need help) |
|
 Posted: Sun Jan 17, 2010 5:38 pm |
 |
|
| MikeDees |
| Regular user |
 |
|
| Joined: Jan 17, 2010 |
| Posts: 8 |
|
|
|
 |
|
 |
|
I am looking for a way to output the contents of a vbulliten DB in a way I can import it to passwordpro.
From what I read the format needs to be Login:Hash:Salt:
So i need help with the following php script to allow me to do this;
| Code: | <?php
$username="dbusername";
$password="dbpassword";
$database="dbname";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tableone";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"username");
$f2=mysql_result($result,$i,"password");
$f2=mysql_result($result,$i,"salt");
echo ($f2). ":";
?>
<?php
$i++;
}
?> |
|
|
|
|
|
|
|
|
|
| Posted: Sun Jan 17, 2010 5:53 pm |
|
|
| waraxe |
| Site admin |
 |
|
| Joined: May 11, 2004 |
| Posts: 2407 |
| Location: Estonia, Tartu |
|
|
|
|
|
|
My version, written in 15 minutes:
| Code: |
<?php
error_reporting(E_ALL);
$sqlhost = 'localhost';
$sqluser = 'dbuser';
$sqlpass ='dbpass';
$database ='db';
$prefix = 'vb_';
$conn = @mysql_connect($sqlhost,$sqluser,$sqlpass) or die('Unable to connnect to sql server');
@mysql_select_db($database) or die( 'Unable to select database');
$query="SELECT username,password,salt FROM {$prefix}user ORDER BY userid ASC";
$result=mysql_query($query);
if(!$result)
{
$err = mysql_error();
die("Sql query failed: $err");
}
while($row = mysql_fetch_assoc($result))
{
$username = $row['username'];
$hash = $row['password'];
$salt = $row['salt'];
echo "$username:$hash:$salt\n";
}
?>
|
|
|
|
|
|
|
|
|
|
| Posted: Sun Jan 17, 2010 6:47 pm |
|
|
| MikeDees |
| Regular user |
|
|
| Joined: Jan 17, 2010 |
| Posts: 8 |
|
|
|
|
|
|
|
Thanks for your reply. But the output is giving me 2 per line which is messing up the import. I would just do it by hand but there is like 45K records
I tried;
echo "$username:$hash:$salt\r\n";
this as well, but it still returns the output like this per line;
$username:$hash:$salt $username:$hash:$salt |
|
Last edited by MikeDees on Sun Jan 17, 2010 6:57 pm; edited 1 time in total |
|
|
|
| Posted: Sun Jan 17, 2010 6:55 pm |
|
|
| waraxe |
| Site admin |
|
|
| Joined: May 11, 2004 |
| Posts: 2407 |
| Location: Estonia, Tartu |
|
|
|
|
|
|
Do you use it over http? I mean, do you watch results with webbrowser? Then use source look or add <BR>-s:
| Code: |
echo "$username:$hash:$salt<br>\n";
|
|
|
|
|
|
| Posted: Sun Jan 17, 2010 6:59 pm |
|
|
| MikeDees |
| Regular user |
|
|
| Joined: Jan 17, 2010 |
| Posts: 8 |
|
|
|
|
|
|
|
|
|
|
|
| Posted: Wed Mar 02, 2011 4:56 pm |
|
|
| MikeDees |
| Regular user |
|
|
| Joined: Jan 17, 2010 |
| Posts: 8 |
|
|
|
|
|
|
|
| Could this be modified to do a full sql dump and write it locally for FTP retrieval? |
|
|
|
|
www.waraxe.us Forum Index -> Php
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
|
|
|
|
|
|
