Dump user table to another database

[JMH11788]

I'm trying to dump colums "userid, username, password, email, joindate, and timezoneoffset" into another database.

I've tried a bunch of different combinations and nothing works yet. I'm just trying to echo the correct values and then I know how to dump them into the database I want. Here is a string I tried:

PHP Code:

$query = $vbulletin->db->query_read("SELECT * FROM user");
$row = mysql_fetch_row($query);
print_r ($row); 


But the problem is that it only prints the first row in the table. If I change it to "SELECT * FROM user WHILE userid=*" it just errors out.

I've tried

PHP Code:

$query = $vbulletin->db->fetch_array 


but all I get is errors.

Is there a better way to do this? I sure hope so lol.

The only thing I can think of is to query the first column and pull up the userid numbers and dump it row by row based on the userid. If I loop it I think I could make it do the whole table. It sucks that I can't just use a incrementing value because if you delete a user the userid column skips that number. Like if you have userid 1,2,3,4 and you delete user 3 it would be 1,2,4.....

Can you please shed some light on what I must do here? I've searched for a long while, read manuals till my eyes bleed and had no luck

Thanks in advance,
Jordan

Originally Posted by JMH11788

I'm trying to dump colums "userid, username, password, email, joindate, and timezoneoffset" into another database.

I've tried a bunch of different combinations and nothing works yet. I'm just trying to echo the correct values and then I know how to dump them into the database I want. Here is a string I tried:

PHP Code:

$query = $vbulletin->db->query_read("SELECT * FROM user");
$row = mysql_fetch_row($query);
print_r ($row); 


But the problem is that it only prints the first row in the table. If I change it to "SELECT * FROM user WHILE userid=*" it just errors out.

I've tried

PHP Code:

$query = $vbulletin->db->fetch_array 


but all I get is errors.

Is there a better way to do this? I sure hope so lol.

The only thing I can think of is to query the first column and pull up the userid numbers and dump it row by row based on the userid. If I loop it I think I could make it do the whole table. It sucks that I can't just use a incrementing value because if you delete a user the userid column skips that number. Like if you have userid 1,2,3,4 and you delete user 3 it would be 1,2,4.....

Can you please shed some light on what I must do here? I've searched for a long while, read manuals till my eyes bleed and had no luck

Thanks in advance,
Jordan

ahhh nvm I got it!

Here is what to do for anyone else that needs help:

PHP Code:

$query = $vbulletin->db->query_read("SELECT username, password, email, joindate, timezoneoffset FROM user");
while ($row = mysql_fetch_object($query)) {
echo $row->username;
} 


[Attilitus]

This code is just off the top of my head... but it ought to work, or at least get you going along the right track.

PHP Code:

$userfield = $vbulletin->db->query_read("SELECT * FROM user");
for ($i=0; $i<count($userfield);$i++){
$userfield[$i] = mysql_fetch_row($userfield[$i];
(code to add $userfield[$i] to other database.)
} 


I doubt that will work as I took just a second to write it up, but the trick is using the "for" statement.

Edit: You could also just use Impex.