Change Username via UserCP v2.0

This hack has been completely rewritten, i recommend that you simply uninstall this hack and install the new version. If you don't want to do that then this is what has changed.

Table structure of namelogs, drop and readd from install file and all the coding within member.php has changed. There has been NO template changes or changes in the admin panel.

This was written in 2.2.6 and worked fine with no problems.

Scott

[mashby]

Anyone? I can't even begin the install because phpMyAdmin won't accept the queries.

[Scott MacVicar]

Its

CREATE TABLE `namelogs` (
  `userid` int(5) NOT NULL default '0',
  `username` longtext NOT NULL,
  `time` int(12) NOT NULL default '0'
) TYPE=MyISAM;

note the use of ` and not '

[mashby]

meaning that it SHOULD or SHOULD not use the '?

[Scott MacVicar]

use the code i posted

it should be `

[Merjawy]

Thank I been needing something like this.. and thnx for the question about where the control is.. found it


thnx PPN

[ghroob]

Thank you
very nice hack

[Larry@IOG]

3 questions will this work with 2.2.7? And is there a script to allow name changes only once every 30 days? How about someone changes their name and someone else takes it? Is three a script where they can not take or choose a name that was already reigstered

Thanks

Larry

[Decoder]

SQL-query :

CREATE TABLE `namelogs` (
`userid` int(5) NOT NULL default '0',
`username` longtext NOT NULL,
`time` int(12) NOT NULL default '0'
) TYPE=MyISAM

MySQL said:


You have an error in your SQL syntax near '`namelogs` (
`userid` int(5) NOT NULL default '0',
`username` longtext NOT' at line 1

[ZiRu$]

I just installed it......works perfectly! thx

[Fuitad]

My users are having a problem with this hack. When someone have a space in their names and they do any kind of modification to their profile, even if they don't change their username, it says that the name is already taken. Any ideas?