Need wordpress expert - question/help regarding automatic postings

I'm creating a new site where authors will register and then have a post automatically generated by wordpress. Each author will have one page, and be able to edit that one page.

That's the gist of it, but I'm having the damndest time getting WP to automatically create that post after a new user registers. I'll be more than happy to pay someone to make a solution in either plugin or core file hack form.

In the install.php file, there's this code:

// First post
$now = date('Y-m-d H:i:s');
$now_gmt = gmdate('Y-m-d H:i:s');
$wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date, post_date_gmt, post_content, post_excerpt, post_title, post_category, post_name, post_modified, post_modified_gmt, comment_count, to_ping, pinged, post_content_filtered) VALUES ('1', '$now', '$now_gmt', '".$wpdb->escape(__('Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!'))."', '', '".$wpdb->escape(__('Hello world!'))."', '0', '".$wpdb->escape(__('hello-world'))."', '$now', '$now_gmt', '1', '', '', '')");

$wpdb->query( "INSERT INTO $wpdb->post2cat (`rel_id`, `post_id`, `category_id`) VALUES (1, 1, 1)" );


I believe this is the code that I can use, but not sure how to apply it and how to advance the post counter to the database.