vb.org Archive - Dump user table to another database

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

Quote:

Originally Posted by JMH11788 (Post 1163189)

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

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;
}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01579 seconds Memory Usage 1,730KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: