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

Yes mate the line is applied.

Usernames are mostly like this:

[NÐE]-=Pie'oh'pah=-

and this one is working perfectly, even with the ' in it.

It only happens to a few poeple. [LoC]Racoon for example

-Alex

I'm not sure how to do the beginning part:

The first thing you got to do is run these two sql queries which will create variables for use, either via phpMyAdmin

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Posts to change username', 'postuserchange', '50', 'Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.', '', '18')

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Days between user change', 'dayuserchange', '7', 'Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.', '', '19')

OR

go to http://www.yourdomain.com/forums/adm...php?action=add
Setting Category: User and registration options
Title: Posts to change username
Variable Name: postuserchange
Value: 50
Description: Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.
Code to generate option: LEAVE THIS BLANK
Display Order: 18

Setting Category: User and registration options
Title: Days between user change
Variable Name: dayuserchange
Value: 7
Description: Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.
Code to generate option: LEAVE THIS BLANK
Display Order: 18

Adding a table to your forums database

I saw that in my phpadmincenter but I had no idea how to change it or what, I didn't see any add or edit button. It's a bunch of stuff I'm not sure to do, that's the only part I'm not sure what to do on. Can someone help me?

You need to have phpMyAdmin installed.

If you do, you go to your database by clicking it's name on the left.

You'll see it's tables listed and right under it, there's a textfield named

Run SQL query/queries on database 'database name'

This is the field where you drop the text (querries)

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Posts to change username', 'postuserchange', '50', 'Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.', '', '18')

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Days between user change', 'dayuserchange', '7', 'Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.', '', '19')

and run them by pressing GO

You can run both INSERT's mentioned at the same time, or one after another.

However, since you are obviously not familiar with phpMyAdmin, make sure you backup your database before messing with it!

-Alex

Ok I see that now, I just put that stuff in that big box then hit go?

Well in that box it says this before I did anything:

SELECT * FROM setting WHERE 1

That was already in there, do I remove that then add that stuff and hit go?

Also how do I back up my database? lol

Sorry, fairly new at this heh.

Thanks

No problem

Yes, just remove that line

afterwards run those querries mentioned above.

The backup is done either via the adminCP of you vBulletin or the phpMyAdmin tool.

Using phpMyAdmin, you need to dump (thats the term for backing up) the database, by selecting Structure and Data and Send.

You may select Add drop tables, too. This tells it, to drop existing tables before restoring your database from the backup. It prevents the Table already exists error.

When you checked all the boxes I suggested, press GO and you should be getting a dialog on where to store the file on your local PC.

Depending on the size of you database, the connection and the speed of Server, the proceedure may take some minutes.

hth

-alex

Ok I'm pretty sure thats finished lol.

I'm now not sure about this part

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 )

Adding New Templates

Am I still in the the phpadmincenter for this? If so I see nothing about create new table, I see rename to: and Copy table to:

Then I see table maintenance and table comments.

I'm confused lol

Now I get an erroer when people try to register and when I tried to access the edit options and change profile and change password all in user control panel. It says

Parse error: parse error in /home/ashleigh/public_html/forum/member.php on line 1337

Hmmmph

Hey,

sorry i havent said this, yes

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

is to run with phpMyAdmin, too. Just paste this and hit GO
This is the last you need to do within phpMyAdmin.

Regarding the parse error you get, thats probably because the hack is not yet completely done.

As for the next step, adding templates, this is to be done in your adminCP

After you created those templates, the last step is to edit the necessary php-files.

I recommend making a copy of the orignals as well.
Just in case you haven't got a good editor, I would also recommend UltraEdit

Ok, hope this is it

-Alex

I did everything and the only wrong still is the pasre error, I redid it and everything

[Scott MacVicar]

paste the contents of member.php

1330 to 1340 please

I'm thinking you have pasted some code in at the wrong point.