Actionhooks connecting to DB

[stevewilliams]

Can someone tell me whats wrong with my actionhooks.php?

 

Each time a customer signs up, it gets to step5 in the order process and when they submit their information, the screen goes blank and the information is NOT passed to the DB outlined in actionhooks.php.

 

Here's what I have:

 

define("ACTIONHOOKSINC",true);

function actionhook_ClientSignup($vars) {


# This function runs when a new user signs up through the shopping cart or registration page
# $vars["ID"]     df_users id, df_users_permissions id, df_users_permissions uid 
# $vars["FirstName"]      df_users name
# $vars["LastName"]     
# $vars["CompanyName"]      df_users username
# $vars["Email"]      df_users email
# $vars["Address1"]     
# $vars["Address2"]
# $vars["City"]
# $vars["State"]
# $vars["Postcode"]
# $vars["Country"]
# $vars["PhoneNumber"]
# $vars["Password"]     df_users password

// Make a MySQL Connection
mysql_connect("localhost", "user", "password") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

mysql_query("INSERT INTO df_users 
(id, username, password, activated, email, name) VALUES('$vars["ID"]', '$vars["CompanyName"]', '1', '$vars["Email"]', '$vars["FirstName"]' ) ") 
or die(mysql_error());  

mysql_query("INSERT INTO df_users_permissions 
(id, uid, admin_type, upload, download, email, share, users_may_see) VALUES('$vars["ID"]', '$vars["ID"]', 'indep', '1', '1', '1', '1', '-ALL-' ) ") 


or die(mysql_error());  


}

 

Of course, I have replaced the DB name, username and password with the correct information.

 

Any help is certianly appreciated.

 

Thank you!