How to automate SQL database creation upon new user creation

I would like to set up whm so that whenever a user is created a certain database with tables will be installed automatically on to the users domain, how can that be done? I guess I have to write some code, but I don't know where..

 

Code:

#!/usr/bin/perl
# cpanel - wwwacct                                Copyright(c) 2008 cPanel, Inc.
#                                                           All rights Reserved.
# [email]copyright@cpanel.net[/email]                                         [url=http://cpanel.net]cPanel Inc.[/url]
# This code is subject to the cPanel license. Unauthorized copying is prohibited

my $wwwacct = -x '/usr/local/cpanel/bin/wwwacct.pl' ? '/usr/local/cpanel/bin/wwwacct.pl' : '/usr/local/cpanel/bin/wwwacct';
exec $wwwacct, @ARGV;

Is in that file, what do I do with that?
Where do I find the syntax that I can use?

 

Step by step

Is it possible to describe it step by step and in more detial, I'm new to WHM server administration.

 

I got it sorted out!

Modified a little bit to create user and add it to the database.
NB! Make sure that postwwwacct has 755 permissions, otherwise it won't start at all

Code:

#!/usr/bin/perl

##
# This script is for making queries against WHM for testing purposes.
# it uses /root/.accesshash for grabbing authentication information
##

use strict;
use warnings;

use LWP::UserAgent;
use MIME::Base64;

#convert input data to hash
my %OPTS = @ARGV;
my $dbname = "db";
my $dbuser = int(rand(10000));
my $dbpassword = int(rand(100000));
my $perms = "select insert update delete create";
my $create_db = '/xml-api/cpanel?user=' . $OPTS{'user'} . '&cpanel_xmlapi_apiversion=1&cpanel_xmlapi_module=Mysql&cpanel_xmlapi_func=adddb&arg-0=' . $dbname;
my $create_db_user = '/xml-api/cpanel?user=' . $OPTS{'user'} . '&cpanel_xmlapi_apiversion=1&cpanel_xmlapi_module=Mysql&cpanel_xmlapi_func=adduser&arg-0=' . $dbuser . '&arg-1=' . $dbpassword;
my $add_db_user = '/xml-api/cpanel?user=' . $OPTS{'user'} . '&cpanel_xmlapi_apiversion=1&cpanel_xmlapi_module=Mysql&cpanel_xmlapi_func=adduserdb&arg-0=' . $dbname . '&arg-1=' . $dbuser . '&arg-2=' . $perms;

query($create_db);
query($create_db_user);
query($add_db_user);

sub query {
	my ($call) = @_;
	
	# grab hash data
	my $accesshash;
	open(my $hash_fh, "<", "/root/.accesshash");
	while (my $line = readline($hash_fh ) ) {
		$accesshash .= $line;
	}
	close ($hash_fh);
	
	# clean of new lines
	$accesshash =~ s/\n//g;
	# create auth string
	my $auth = "WHM root:$accesshash";
	
	#setup query object
	my $ua = LWP::UserAgent->new;

	# perform query
	my $res = $ua->get("http://127.0.0.1:2086" . $call, Authorization =>$auth);

	# print response from query
	print $res->content;
}

Thanks cPanelMatt!