[MODDB] Separate Login and User Name 1.0.6

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Ideas Centre
Locked
gemohler
Registered User
Posts: 3
Joined: Thu Oct 30, 2008 7:47 am

Re: [DEV] Separate Login and User Name 0.0.4

Post by 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
Registered User
Posts: 5
Joined: Wed Oct 22, 2008 8:19 pm

Re: [DEV] Separate Login and User Name 0.0.4

Post by 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
Registered User
Posts: 1
Joined: Sat Sep 15, 2007 2:29 am

Re: [DEV] Separate Login and User Name 0.0.4

Post by 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
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [DEV] Separate Login and User Name 0.0.4

Post by 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
Registered User
Posts: 4
Joined: Thu Jan 15, 2009 3:20 am

Re: [DEV] Separate Login and User Name 0.0.4

Post by 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
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 0.0.4

Post by nouveau »

ot2pc wrote: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
Formerly known as xceler8shun

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by nouveau »

Mudjosh wrote: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
Formerly known as xceler8shun

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by nouveau »

codythecomet wrote: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.
Last edited by nouveau on Wed Mar 18, 2009 6:14 am, edited 1 time in total.
Formerly known as xceler8shun

codythecomet
Registered User
Posts: 4
Joined: Thu Jan 15, 2009 3:20 am

Re: [DEV] Separate Login and User Name 1.0.5

Post by codythecomet »

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

Deumus
Registered User
Posts: 7
Joined: Sun Sep 12, 2004 1:43 am

Re: [DEV] Separate Login and User Name 1.0.5

Post by 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
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by 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
Formerly known as xceler8shun

Spiderman2
Registered User
Posts: 1
Joined: Fri Mar 13, 2009 1:24 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by 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
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by nouveau »

Spiderman2 wrote: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`;
Formerly known as xceler8shun

User avatar
alleycat
Registered User
Posts: 6
Joined: Fri May 02, 2008 6:32 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by alleycat »

Hi xceler8shun

Nice mod but just one question :o ... 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 :mrgreen:
If I know I'm going crazy, I must not be insane

nouveau
Registered User
Posts: 256
Joined: Tue Mar 27, 2007 1:51 pm

Re: [DEV] Separate Login and User Name 1.0.5

Post by 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?
Formerly known as xceler8shun

Locked

Return to “[3.0.x] MODs in Development”