How to use data from phpnuke for other programs

Posted: Mon Jun 23, 2003 2:49 am

Hi all,

Here is what I want to do:

I want to use the register user's username, user_email, user_password when they activate their account and write it to other table in the same database.

The following is the code of function activate($username, $check_num)

Code:

if ($check_num == $row[check_num]) {
$db->sql_query("INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_password, user_avatar, user_regdate, user_lang) VALUES (NULL, '$row[username]', '$row[user_email]', '$row[user_password]', 'gallery/blank.gif', '$row[user_regdate]', '$language')");

This is the line of code I added after the above

Code:

$db->sql_query("INSERT INTO netjuke_users (email , password, name, gr_id , created, updated, nickname, web_site, img_src , last_login, login_cnt, local_music_dir ) VALUES ('$row[user_email]', '$row[user_password]', '$row[username]', NULL, '$row[user_regdate]', '$row[user_regdate]', '$row[username]', NULL, NULL, NULL, '0', NULL)");

The '$row[username]' etc, seems to me that it writes from the nuke_users_temp to nuke_users.

I want to use the same information and write it to the netjuke_user table that allows me to create an account for the user with the same user name, email address and password the user use for the registration of the phpnuke.

I have do a test on this but the netjuke_user table havn't add the record according.

What might be the problem of the above? please advise.

Thanks in advance for your time

Regards,

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

What is the error that is being written to the server error_log?

Posted: Thu Jul 03, 2003 4:59 pm

Problem solved, thanks

Posted: Sat Jul 12, 2003 12:16 pm

Hey Osward, what was the solution?

Posted: Sun Jul 13, 2003 6:09 am

I had make some error on the target table's fields, so the target data table couldn't be inserted.

The concept and function where you want to create other user account depends on when you want the account be created. If you want more data use for other database table, you might add additional fields in the nuke_user_temp table.

Personally think the right time is when user activate the phpnuke account

Hope this could help

Regards,