Ad:

PHP Discussion Thread
Unsolved
Views: 976

Nov 23rd, 2008

Encoding and saving password during login

Expand Post »

Hello all.
I am having some questions about a subject.
I am running a small social community using SocialEngine and i want to include phpbb3 with an arcade mod or any arcade board that support high scores.
My problem is that i do not want my users to re-register into the board. So if I manage to encode the password during login, into the encoding system of phpbb3 or just md5, I will make the registrations my self through the database.

That means they will login every time they want to access the arcade unless they press remember me, but they will not register themselves.

I know that this is something that is able to be made.
Also is there any chance to make the login into the arcade automatic?
There is tutorial and a script that it is used for phpbb2 and it is available here http://www.socialengine.net/tutorial...tutorial_id=44

Thank you all.

Punkis448

Reputation Points: 8

Solved Threads: 0

Light Poster

Offline

31 posts
since May 2008

Permalink

Nov 23rd, 2008

Re: Encoding and saving password during login

This is a code i found into the socialengine's plugin.
I think this does all the work

PHP Syntax (Toggle Plain Text)
	// THIS METHOD CREATES A FORUM USER WITH THE SAME USERNAME AS THE CURRENT USER
	// INPUT: 
	// OUTPUT: 
	function forum_user_create() {
	  global $db, $board_config;
 
	  // GET NEXT USER ID
	  $row = $db->sql_fetchrow($db->sql_query("SELECT MAX(user_id) AS max_user_id FROM " . USERS_TABLE));
	  $forum_user_id = $row['max_user_id'] + 1;
 
	  // ENCRYPT PASSWORD
	  $password_md5 = md5(randomcode());
 
	  // SET DEFAULT VALUES FOR SOME VARIABLES
	  $viewemail          = FALSE;
	  $allowviewonline    = TRUE;
	  $notifyreply        = FALSE;
	  $notifypm           = TRUE;
	  $popup_pm           = TRUE;
	  $attachsig          = $board_config['allow_sig'];
	  $allowhtml          = $board_config['allow_html'];
	  $allowbbcode        = $board_config['allow_bbcode'];
	  $allowsmilies       = $board_config['allow_smilies'];
	  $user_style         = $board_config['default_style'];
	  $user_dateformat    = $board_config['default_dateformat'];
	  $user_timezone      = $board_config['board_timezone'];
	  $user_lang          = $board_config['default_lang'];
 
	  // BEGIN PHPBB2 INSERT
	  $db->sql_query("INSERT INTO " . USERS_TABLE . "(user_id,
							username,
							user_regdate,
							user_password,
							user_email,
							user_viewemail,
							user_attachsig,
							user_allowsmile,
							user_allowhtml,
							user_allowbbcode,
							user_allow_viewonline,
							user_notify,
							user_notify_pm,
							user_popup_pm,
							user_timezone,
							user_dateformat,
							user_lang,
							user_style,
							user_level,
							user_allow_pm,
							user_active,
							user_actkey
							) VALUES (
							'$forum_user_id',
							'".$this->user_info[user_username]."',
							'".time()."', 
							'$password_md5',
							'".$this->user_info[user_email]."',
							'$viewemail',
							'$attachsig',
							'$allowsmilies',
							'$allowhtml',
							'$allowbbcode',
							'$allowviewonline',
							'$notifyreply',
							'$notifypm',
							'$popup_pm',
							'$user_timezone',
							'".str_replace("\'", "''", $user_dateformat)."',
							'".str_replace("\'", "''", $user_lang)."',
							'$user_style',
							0,
							1,
							1,
							'')");
	// THIS METHOD CREATES A FORUM USER WITH THE SAME USERNAME AS THE CURRENT USER
	// INPUT: 
	// OUTPUT: 
	function forum_user_create() {
	  global $db, $board_config;

	  // GET NEXT USER ID
	  $row = $db->sql_fetchrow($db->sql_query("SELECT MAX(user_id) AS max_user_id FROM " . USERS_TABLE));
	  $forum_user_id = $row['max_user_id'] + 1;
    
	  // ENCRYPT PASSWORD
	  $password_md5 = md5(randomcode());
		
	  // SET DEFAULT VALUES FOR SOME VARIABLES
	  $viewemail          = FALSE;
	  $allowviewonline    = TRUE;
	  $notifyreply        = FALSE;
	  $notifypm           = TRUE;
	  $popup_pm           = TRUE;
	  $attachsig          = $board_config['allow_sig'];
	  $allowhtml          = $board_config['allow_html'];
	  $allowbbcode        = $board_config['allow_bbcode'];
	  $allowsmilies       = $board_config['allow_smilies'];
	  $user_style         = $board_config['default_style'];
	  $user_dateformat    = $board_config['default_dateformat'];
	  $user_timezone      = $board_config['board_timezone'];
	  $user_lang          = $board_config['default_lang'];
    
	  // BEGIN PHPBB2 INSERT
	  $db->sql_query("INSERT INTO " . USERS_TABLE . "(user_id,
							username,
							user_regdate,
							user_password,
							user_email,
							user_viewemail,
							user_attachsig,
							user_allowsmile,
							user_allowhtml,
							user_allowbbcode,
							user_allow_viewonline,
							user_notify,
							user_notify_pm,
							user_popup_pm,
							user_timezone,
							user_dateformat,
							user_lang,
							user_style,
							user_level,
							user_allow_pm,
							user_active,
							user_actkey
							) VALUES (
							'$forum_user_id',
							'".$this->user_info[user_username]."',
							'".time()."', 
							'$password_md5',
							'".$this->user_info[user_email]."',
							'$viewemail',
							'$attachsig',
							'$allowsmilies',
							'$allowhtml',
							'$allowbbcode',
							'$allowviewonline',
							'$notifyreply',
							'$notifypm',
							'$popup_pm',
							'$user_timezone',
							'".str_replace("\'", "''", $user_dateformat)."',
							'".str_replace("\'", "''", $user_lang)."',
							'$user_style',
							0,
							1,
							1,
							'')");

Punkis448

Reputation Points: 8

Solved Threads: 0

Light Poster

Offline

31 posts
since May 2008

Permalink

Nov 24th, 2008

Re: Encoding and saving password during login

Why don't you create an activate service page. E.g. imagine not all users want to participate in the arcade, but by mistake they click on the game page....
I think it would be better you create a single php page that explains the puspose of the arcade, etc. and you present there a link saying e.g. Activate your free arcade account, or Enable arcade for me, etc....
In this way once the user clicks this link a simple php will work and create new account only for those members who have requested this service, by simply re-registering the user into PHPBB with their current password and username.
If, by chance someone wants to register only to your arcade application, you create a custom page that checks in your social application login tables. If such user exists, it will offer one of the following - e.g. First to login with social account and go to the activate function, or, offer to create a new social account and then activate the arcade....
I hope you understand my suggestion.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

Nov 24th, 2008

Re: Encoding and saving password during login

Hi there thank you for your reply.
It is because I want it to be "automatic". However I figured a way, kinda same like yours..

Punkis448

Reputation Points: 8

Solved Threads: 0

Light Poster

Offline

31 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Not getting data in list box

Next Thread in PHP Forum Timeline: Insert Multiple Records

DaniWeb Message

Cancel Changes

User Name
Password