[MODDB] Separate Login and User Name 1.0.6

[gemohler]

Greetings, this is my first post here, and im a total virgin PHPBB admin...juuust installed it.

Ive been asked to create a www site and forum for our flight club, http://www.squadron2flightclub.com is the development site, and has a PHPBB link from the front.

But..ive been asked to ensure that our members can use their existing Schedule Master (what we use to schedule aircraft with) club ID's to log into the Forums..but being seen as user 52186 isnt very exciting.

This MOD appears to be able to have someone login as 52186, but be known as SkyBob in their posts.

If so...am I really getting in too deep to install this MOD, or..should I give up some flyin funds..and ask someone to do it for me?

Seems a bit soon to jump into a mod like this..but, its a hard pre-req that I have to meet somehow before I can spend much time on fleshing out the forum(s) themselves.

Thanks for your efforts!

[flamestone]

Your virgin phpBB admin status won't be the determining factor.

So long as you're careful/thorough, and you have at least a vague grasp of PHP and MySQL, you'll be fine.

I've installed this mod, so I can vouch for the correctness of the instructions.

[ot2pc]

This feature really should come with phpBB3 by default.

when instruced to Find/Replace With, does it only apply to the first find? or I will have to replace all the finds in the opened file?
this is for the following step in the install file

Open: includes/auth/auth_db.ph
Find:

Code: Select all

'status'	=> LOGIN_ERROR_USERNAME,
'error_msg'	=> 'LOGIN_ERROR_USERNAME',

Replace With:

Code: Select all

'status'	=> LOGIN_ERROR_LOGINNAME,
'error_msg'	=> 'LOGIN_ERROR_LOGINNAME',

[Mudjosh]

What is the reason this is still in Dev?

I know mods in development of any type should not be installed on a live board, but I would love to use this mod. I'm just curious about what errors or functionality problems are making it not able to advance farther than DEV status.

[codythecomet]

Could someone just apply all the changes to a new 3.0.4 install package and then post it somewhere? It would be so much easier to throw a new forum directory up and run the SQL changes instead of going through that nightmare of an install (I won't miss my old mods)

[nouveau]

This feature really should come with phpBB3 by default.

when instruced to Find/Replace With, does it only apply to the first find? or I will have to replace all the finds in the opened file?
this is for the following step in the install file

Open: includes/auth/auth_db.ph
Find:

Code: Select all

'status'	=> LOGIN_ERROR_USERNAME,
'error_msg'	=> 'LOGIN_ERROR_USERNAME',

Replace With:

Code: Select all

'status'	=> LOGIN_ERROR_LOGINNAME,
'error_msg'	=> 'LOGIN_ERROR_LOGINNAME',

It will usually be the first find, but there are two of those instances if I remember correctly in auth_db.php

[nouveau]

What is the reason this is still in Dev?

I know mods in development of any type should not be installed on a live board, but I would love to use this mod. I'm just curious about what errors or functionality problems are making it not able to advance farther than DEV status.

The reason for it still being in DEV has been due to my time and committments lately and the lack of spare time I have for other activities let alone phpbb mods.

I only considered it stable enough last week when I had a break over new years for me to finally submit it to the MOD validation process.

The version is currently sitting at 1.0.5

Modification Download: See first post in the topic

2008-01-12 - Version1.0.5
* Made some validation and modx corrections with install and included files

2008-01-11 - Version1.0.4
* Tested working on 3.0.4
* Changed version number to 1.0.4 for validation, 0.0.4 is stable and the same as 1.0.4

[nouveau]

Could someone just apply all the changes to a new 3.0.4 install package and then post it somewhere? It would be so much easier to throw a new forum directory up and run the SQL changes instead of going through that nightmare of an install (I won't miss my old mods)

If I get a spare 30 minutes later today I'll apply the changes to a fresh install of phpbb3 and make them available for you to test.

[codythecomet]

Yeah, that would be great. I'd really appreciate it!

[Deumus]

Hello,

At first, sorry for my english.

I found a problem with your mod. When i test to register a new account, i have this error:

SQL ERROR [ mysqli ]

Column 'username_clean' cannot be null [1048]

The modification to solve this problem is in includes/functions_user.php

Find this in user_add function

Code: Select all

// $username_clean = utf8_clean_string($user_row['username']);

and uncomment the line.



Thanks for this MOD

[nouveau]

Thanks for the find Deumus, I was streamlining the new version in cutting down the steps required.
There is also another typo just below the one you noticed as well.

I've fixed the errors and uploaded the revisions.

So it should be includes/functions_user.php

FIND

Code: Select all

	if (empty($user_row['username']) || !isset($user_row['group_id']) || !isset($user_row['user_email']) || !isset($user_row['user_type']))
	{
		return false;
	}

	$username_clean = utf8_clean_string($user_row['username']);

	if (empty($username_clean))
	{
		return false;
	}

REPLACE WITH

Code: Select all

	// Start Sep Login Name Mod
	// if (empty($user_row['username']) || !isset($user_row['group_id']) || !isset($user_row['user_email']) || !isset($user_row['user_type']))
	if (empty($user_row['username']) || empty($user_row['loginname']) || !isset($user_row['group_id']) || !isset($user_row['user_email']) || !isset($user_row['user_type']))
	{
		return false;
	}

	$username_clean = utf8_clean_string($user_row['username']);
	$loginname_clean = utf8_clean_string($user_row['loginname']);

	if (empty($username_clean))
	{
		return false;
	}
	
	if (empty($loginname_clean))
	{
		return false;
	}
	// End Sep Login Name Mod

[Spiderman2]

I have an error

SQL ERROR [ mysql4 ]

Table 'unit_joomla.phpbb_disallow_login' doesn't exist [1146]

SQL

SELECT * FROM phpbb_disallow_login

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_disallow_loginnames.php
LINE: 92
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_disallow_loginnames->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

what the structure of this table should be?

[nouveau]

I have an error

SQL ERROR [ mysql4 ]

Table 'unit_joomla.phpbb_disallow_login' doesn't exist [1146]

SQL

SELECT * FROM phpbb_disallow_login

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_disallow_loginnames.php
LINE: 92
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_disallow_loginnames->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

what the structure of this table should be?

Looks like the table phpbb_disallow_login does not exist. Have you executed the install script to install the required tables and SQL changes?

You could try and add in the SQL query below to add in the table manually

mysql_41_schema

Code: Select all

CREATE TABLE phpbb_disallow_login (
	disallow_login_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	disallow_loginname varchar(255) NOT NULL,
	PRIMARY KEY (disallow_login_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;

[alleycat]

Hi xceler8shun

Nice mod but just one question ... does this mod work with LDAP cause in the list of files to edit it's only auth_db.php thats changed, not auth_ldap.php

Thanks

[nouveau]

Hi alleycat, I don't really have any way to test for LDAP authentication.

I could try and knock something together for you to test if you like?