[DEV] My Profile Space

MG90 · Post by **MG90** » Tue Jun 12, 2007 8:03 pm

Im too! I wait and wait and wait. I hope it come soon.

leelo_x · Post by **leelo_x** » Mon Jun 18, 2007 2:46 pm

Hi.
I get this error message when I try to register as a new user...can anyone tell me what the problem is?

An Error Occurred

DEBUG MODE

INSERT INTO phpbb_mps (mps_id) VALUES ('8')

Line : 645
File : usercp_register.php

also, since I installed mps, the site requires me to login 3 times to access admin and as a regular (non-admin user) you have to login twice to access the site...here's my login.php code..

Code: Select all

<?php

define("IN_LOGIN", true);

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Set page ID for session management
//
$userdata = session_pagestart($user_ip, PAGE_LOGIN);
init_userprefs($userdata);
//
// End session management
//

// session id check
if (!empty($HTTP_POST_VARS['sid']) || !empty($HTTP_GET_VARS['sid']))
{
	$sid = (!empty($HTTP_POST_VARS['sid'])) ? $HTTP_POST_VARS['sid'] : $HTTP_GET_VARS['sid'];
}
else
{
	$sid = '';
}

if( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) || isset($HTTP_POST_VARS['logout']) || isset($HTTP_GET_VARS['logout']) )
{
	if( ( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) ) && (!$userdata['session_logged_in'] || isset($HTTP_POST_VARS['admin'])) )
	{
		$username = isset($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
		$password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';$sql = "SELECT *, user_login_tries, user_last_login_try
			FROM " . USERS_TABLE . "
			WHERE username = '" . str_replace("\\'", "''", $username) . "'";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);
		}

		if( $row = $db->sql_fetchrow($result) )
		{
			if( $row['user_level'] != ADMIN && $board_config['board_disable'] )
			{
				redirect(append_sid("index.$phpEx", true));
			}
			else
			{
				// If the last login is more than x minutes ago, then reset the login tries/time
				if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] < (time() - ($board_config['login_reset_time'] * 60)))
				{
					$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
					$row['user_last_login_try'] = $row['user_login_tries'] = 0;
				}
				
				// Check to see if user is allowed to login again... if his tries are exceeded
				if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] && 
					$row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts'] && $userdata['user_level'] != ADMIN)
				{
					message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time']));
				}

				if( md5($password) == $row['user_password'] && $row['user_active'] )
				{
					$autologin = ( isset($HTTP_POST_VARS['autologin']) ) ? TRUE : 0;

					$admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0;
					$session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin);

					// Reset login tries
					$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);

					if( $session_id )
					{
					// BEGIN MPS MOD
						if($row['friend_pending'] || $row['comment_pending'])
						{
						
							//
							// Include Language Begin
							//
							$language = $board_config['default_lang'];

							if ( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_mps_main.'.$phpEx) )
							{
								$language = 'english';
							}

							include($phpbb_root_path . 'language/lang_' . $language . '/lang_mps_main.' . $phpEx);
							//
							// Include Language End
							//

							if ($row['mps_new_comment'] == 1)
							{
								$template->assign_vars(array(
									'META' => "<meta http-equiv=\"refresh\" content=\"1;url=login.$phpEx?redirect=$redirect\"><script language=\"Javascript\" type=\"text/javascript\">
										window.open('mps_friends.php?mode=popup', '_phpbb_snw', 'HEIGHT=225,resizable=yes,WIDTH=400');
										</script>" )
								);
							}
							else
							{
								$template->assign_vars(array(
									'META' => "<meta http-equiv=\"refresh\" content=\"1;url=login.$phpEx?redirect=$redirect\"><script language=\"Javascript\" type=\"text/javascript\">
										window.open('mps_friends.php?mode=popup', '_phpbb_snw', 'HEIGHT=225,resizable=yes,WIDTH=400');
										</script>" )
								);
							}
							message_die(GENERAL_MESSAGE, $lang['logging_in']);
						}
// END MPS MOD
						$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
						redirect(append_sid($url, true));
					}
					else
					{
						message_die(CRITICAL_ERROR, "Couldn't start session : login", "", __LINE__, __FILE__);
					}
				}
				// Only store a failed login attempt for an active user - inactive users can't login even with a correct password
				elseif( $row['user_active'] )
				{
					// Save login tries and last login
					if ($row['user_id'] != ANONYMOUS)
					{
						$sql = 'UPDATE ' . USERS_TABLE . '
							SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . '
							WHERE user_id = ' . $row['user_id'];
						$db->sql_query($sql);
					}
				}

				$redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : '';
				$redirect = str_replace('?', '&', $redirect);

				if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
				{
					message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
				}

				$template->assign_vars(array(
					'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
				);

				$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

				message_die(GENERAL_MESSAGE, $message);
			}
		}
		else
		{
			$redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "";
			$redirect = str_replace("?", "&", $redirect);

			if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
			{
				message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
			}

			$template->assign_vars(array(
				'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
			);

			$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

			message_die(GENERAL_MESSAGE, $message);
		}
	}
	else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
	{
		// session id check
		if ($sid == '' || $sid != $userdata['session_id'])
		{
			message_die(GENERAL_ERROR, 'Invalid_session');
		}

		if( $userdata['session_logged_in'] )
		{
			session_end($userdata['session_id'], $userdata['user_id']);
		}

		if (!empty($HTTP_POST_VARS['redirect']) || !empty($HTTP_GET_VARS['redirect']))
		{
			$url = (!empty($HTTP_POST_VARS['redirect'])) ? htmlspecialchars($HTTP_POST_VARS['redirect']) : htmlspecialchars($HTTP_GET_VARS['redirect']);
			$url = str_replace('&', '&', $url);
			redirect(append_sid($url, true));
		}
		else
		{
			redirect(append_sid("index.$phpEx", true));
		}
	}
	else
	{
	// BEGIN MPS MOD
					if ($board_config['allow_mps'] == 1)
					{
						$sql = "SELECT *
								FROM " . MPS_TABLE . "
								WHERE mps_id = " .$row['user_id'];
						if( !($result = $db->sql_query($sql)) )
						{
								message_die(GENERAL_ERROR, $lang['MPS_no_query'], '', __LINE__, __FILE__, $sql);
						}
						$mps_info = $db->sql_fetchrow($result);


						if ( $board_config['force_mps'] == 1 && !$mps_info  )
						{
							$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
							redirect(append_sid($url, true));
						}
						else if ($board_config['force_mps_home'] == 1 && $mps_info)
						{
							$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
							redirect(append_sid($url, true));
						}
						else if ($mps_info['mps_home_page'] == 1 && $mps_info)
						{
							$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "mps.$phpEx";
							redirect(append_sid($url, true));
						}
						else
						{
							$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
							redirect(append_sid($url, true));
						}
					}
					else
					{
		$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
		redirect(append_sid($url, true));
							}
// END MPS MOD
	}
}
else
{
	//
	// Do a full login page dohickey if
	// user not already logged in
	//
	if( !$userdata['session_logged_in'] || (isset($HTTP_GET_VARS['admin']) && $userdata['session_logged_in'] && $userdata['user_level'] == ADMIN))
	{
		$page_title = $lang['Login'];
		include($phpbb_root_path . 'includes/page_header.'.$phpEx);

		$template->set_filenames(array(
			'body' => 'login_body.tpl')
		);

		$forward_page = '';

		if( isset($HTTP_POST_VARS['redirect']) || isset($HTTP_GET_VARS['redirect']) )
		{
			$forward_to = $HTTP_SERVER_VARS['QUERY_STRING'];

			if( preg_match("/^redirect=([a-z0-9\.#\/\?&=\+\-_]+)/si", $forward_to, $forward_matches) )
			{
				$forward_to = ( !empty($forward_matches[3]) ) ? $forward_matches[3] : $forward_matches[1];
				$forward_match = explode('&', $forward_to);

				if(count($forward_match) > 1)
				{
					for($i = 1; $i < count($forward_match); $i++)
					{
						if( !ereg("sid=", $forward_match[$i]) )
						{
							if( $forward_page != '' )
							{
								$forward_page .= '&';
							}
							$forward_page .= $forward_match[$i];
						}
					}
					$forward_page = $forward_match[0] . '?' . $forward_page;
				}
				else
				{
					$forward_page = $forward_match[0];
				}
			}
		}

		$username = ( $userdata['user_id'] != ANONYMOUS ) ? $userdata['username'] : '';

		$s_hidden_fields = '<input type="hidden" name="redirect" value="' . $forward_page . '" />';
		$s_hidden_fields .= (isset($HTTP_GET_VARS['admin'])) ? '<input type="hidden" name="admin" value="1" />' : '';

		make_jumpbox('viewforum.'.$phpEx);
		$template->assign_vars(array(
			'USERNAME' => $username,

			'L_ENTER_PASSWORD' => (isset($HTTP_GET_VARS['admin'])) ? $lang['Admin_reauthenticate'] : $lang['Enter_password'],
			'L_SEND_PASSWORD' => $lang['Forgotten_password'],

			'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword"),

			'S_HIDDEN_FIELDS' => $s_hidden_fields)
		);

		$template->pparse('body');

		include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
	}
	else
	{
		redirect(append_sid("index.$phpEx", true));
	}

}

?>

any suggestions would be greatly appreciated. Thanks.

MG90 · Post by **MG90** » Mon Jun 18, 2007 3:33 pm

Where do you get that mod for phpbb3?

Yautja_cetanu · Post by **Yautja_cetanu** » Tue Jun 19, 2007 12:07 am

there will be one thing that i find to be a major pain... the friends section of phpbb3 i do not like it... More info on that at a later date...

I agree!

There is someone on startrekguide who has been developing an advanced friends mod that allows approval. I'm wanting something more similar to facebook (Therefore allowing "limited" friends so you can put more private information like phone numbers on your space and not worry about offending people who you don't want to see your phone number).

But for anything that uses friends to any degree phpbb3's friends has to go! The question is, how can you do friends so that its seamless with any future mods that may use phpbb's friends.

Jadestone · Post by **Jadestone** » Tue Jun 19, 2007 4:53 pm

leelo_x~ this is not the place for support for MPS for phpbb2... try this link http://www.phpbb.com/community/viewtopi ... =#p2059907

as for the friends system.. i am not fully rewriting it, i will be using the same friends table. for the most part it will function like the current system in MPS but with a few changes.

unfortunately i am in such a tight deadline at my job that time with MPS has been 0 but after july i can start to get MPS on the roll again... yeah, i know that sucks... asides from that i am also moving in the middle of July so you can see my hands are going to be full just a lil bit longer. Sorry for the inconvenience

jerx · Post by **jerx** » Thu Jul 05, 2007 4:54 am

What kind of gallery do you integrate into this mod? Phpbb2 version had the full album mod, but I think that has not been ported to phpbb3 yet. There is a promising photo gallery by grooveplugs (http://www.phpbb.com/community/viewtopi ... 0&t=544915). He might have released the gallery before you start working on phpbb3 version.

Thanks for your hard work on this and the phpbb2 version!

Gleasonator · Post by **Gleasonator** » Thu Jul 05, 2007 6:21 am

jerx wrote:What kind of gallery do you integrate into this mod? Phpbb2 version had the full album mod, but I think that has not been ported to phpbb3 yet. There is a promising photo gallery by grooveplugs (http://www.phpbb.com/community/viewtopi ... 0&t=544915). He might have released the gallery before you start working on phpbb3 version.

Thanks for your hard work on this and the phpbb2 version!

I agree with jerx about Grooveplug's mod. I plan to install his mod regardless, and it would all work nicely if you integrated it.

Man I'm really excited about this mod.

Thanks for working on it, but I feel like peeing my pants from the wait.

nickdh · Post by **nickdh** » Thu Aug 09, 2007 9:21 pm

how is the progress going?

Jadestone · Post by **Jadestone** » Mon Aug 13, 2007 2:20 am

Not bad actually. Took me a bit to get used to the new system but its coming along nicely. It will still be awhile till i can get an alpha out but it is working nicely so far for what i have.

RedTrinity · Post by **RedTrinity** » Mon Aug 13, 2007 5:46 am

I have upgraded our forum to PHPBB3 now, so look forward to using this version!!!

BeautyGal · Post by **BeautyGal** » Fri Aug 17, 2007 12:43 am

I CANT WAIT FOR THIS MOD - Literally screaming for joy!!

Myspoonistoobig · Post by **Myspoonistoobig** » Fri Aug 17, 2007 3:49 am

You shouldn't refer to this as a "myspace mod" if it doesn't interact with or have the endorsement of MySpace.com. "Myspace" is a trademark.

Jadestone · Post by **Jadestone** » Fri Aug 17, 2007 1:14 pm

Myspoonistoobig wrote:You shouldn't refer to this as a "myspace mod" if it doesn't interact with or have the endorsement of MySpace.com. "Myspace" is a trademark.

then its a good thing this is called my profile space then

I can refer to this as a myspace mod because it is giving the feel of myspace, i`m not saying it is myspace so there are no legal issues. i can use the name i just can't call it myspace and i can't use their logos obviously. i can use myspace as a description because that is what the mod is like, there is no legal concern there

thanks for your concern

passingby · Post by **passingby** » Mon Sep 03, 2007 10:30 pm

Hi ,
how is the development of this mod going ? when can we expect an RC of it ?
thanx

playerfr · Post by **playerfr** » Tue Sep 04, 2007 11:19 am

Waoo did not know there was such mod in developement saw the demo and it looks nice. How is the proegress now ? still no Beta version to test ?

Thanks