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

[N9ne]

BUMP!

PPN PLEASE READ and update this hack please I really want this hack to work perfectly

[Webmasta XT]

it stops working after some time... ive installed it, and a week later it stopped showing?

[N9ne]

I didn't have that happen, but the problem I have with my 2.2.5 is when I change my username, an error will appear at the top of the page however the username will change. It doesn't update the username around the forum either. In the profiles, their previous usernames are also not listed.

[N9ne]

PLEASE SOMEBODY? I'm having to bump up a lot of topics on this forum now, and none get answered

[N9ne]

This is unbelieveable, I've had to bump this topic up about 4 times now.

[Lucrecia]

I'm new at this. Where in your instructions it says to do this

Adding a table to your forums database
---------------------------------------
Now you will need to create this table for logging of the username and last time they updated.

CREATE TABLE namelogs (userid INT (5) not null , usernames LONGTEXT not null , lastchange INT (12) not null )

1) What do you I put in for The name and field of where it says this in my phpmyadmin (Create new table on database )

2) Also there is a screen that comes after and has options:

Field, Type, Length/Values*, Attributes, Null, Default, Extra, Primary Index Unique Fulltext

Table comments : Table type :

What do I put in for these options? Thanks in advance.

[Scott MacVicar]

I'm gonna rewrite this hack as soon as i get time, its mainly the checking in member.php that needs to be done.

[Scott MacVicar]

ok its rewritten and tested
just modification to the code in member.php and you'll need to drop the namelogs table and recreate it.

Will post it in the first post in a few moments.

[Lucrecia]

Thanks PPN

[mashby]

I'm anxious to install this hack on my new board, but I've ran into a small snag. I could be doing something wrong, so I hope someone here can help.

When I paste in the SQL queries into phpMyAdmin, I'm getting errors. For example, when I paste in

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

I get the following error from phpMyAdmin, "You have an error in your SQL syntax near '\'namelogs\' (
\'userid\' int(5) NOT NULL default \'0\',
\'username\' long' at line 1"

I'm using a text editor (EditPlus) to read the instructions and I'm pasting the info in from there. Anyone have any suggestions on what I'm doing wrong?