Inserting Users into PHP Forum from My Registration Page
I am working on this and have had some success with the more basic fields to insert the data using the data assist insert record app. Right now I am trying to make it so when a user signs up on my registration page they are also registered into my forum powered by phpbb3. I am having trouble getting the following fields to show up correctly if not at all.
field - user_reg_date
current value- NONE
problem- I don't know what to put here but I think it is a date field to represent when I joined. It's not a timestamp in the database just a text field.
field -user_password
current value- <?php echo WA_SHA1Encryption(((isset($_POST["password"]))?$_POST["password"]:"")); ?>
problem- the phpp databse requires a MD5 crc32 / hash encrypted password.
field -username_clean
current value- <?php echo strtolower(((isset($_POST["username"]))?$_POST["username"]:"")); ?>
problem -This works for converting all to lowercase but just want to make sure it's the right data.
field -user_email_hash
field -<?php echo strtolower(crc32(((isset($_POST["email"])))?$_POST["email"]:"")); ?>
problem- This converts the email to a numerical value but it doesn't match up to the numeric value I get when I sign up on the phpbb reg page with the same email... it's negative and lacking the Last TWO numbers....
ex- hash no. when signing up from my form= -896990891
hash no. when signing up with their form= 89699089119 (same email)
Hope someone can help, I really hate having to ask the user to register twice for my site & my forum.