Product Install Code - Adding a row for each row in user

[Nullifi3d]

Upon product install I need to add a row to a mysql table for each row that is in the table 'user'. How would I do this bring the userid and username intot he new table? I think it's something like this:

	$vbuser =& $vbulletin->userinfo;
		foreach ($vbuser AS $userid => $userid, $username => $username,) {
		$db->query_write("INSERT INTO " . TABLE_PREFIX . "banners (
		userid, username, title, url, link, ext, width, height, clicks, available, impressions, status
		) VALUES (
		'$userid', '$username', '', '', '', '', '', '', 0, '{$vbulletin->options['banner_impressions_join']}', 0, ''
		)");
    }

I know that $vbulletin->userinfo contains info for the user visiting the page, so it would not work. What do I need to do to make this work?

[Andreas]

Untested, but should work (if I havn't added a typo or smth.)

PHP Code:

$db->query_write("
    INSERT INTO " . TABLE_PREFIX . "banners
    (userid, username, title, url, link, ext, width, height, clicks, available, impressions, status)    
    (SELECT user.userid, user.username, '' AS title, '' AS url, '' AS link, '' AS ext, 0 As width, 0 AS height, 0 AS clicks, 0 AS available, 0 AS status)
    FROM " . TABLE_PREFIX . "user AS user)
"); 


[Nullifi3d]

Ahh, suprised I didn't think of that for the query, but will that add a row every user in the table 'user' when the product is installed? What if there is 300 users in the table? it looks like this will only add 1 row.

[Andreas]

It should add rows for all users.

[Nullifi3d]

Thank you it did work.