Probably because it's ntl :D Try having a look here.

Hi PPN,

veeery useful hack!! https://vborg.vbsupport.ru/

Something that vB is really missing,
Thanks man,
-Tom

Thanks, usefull hack.. needed one like this :D

great hack :)
How do you add a table to the Database ?

thankyou

Mike D

With phpMyAdmin

http://www.phpwizard.net/projects/phpMyAdmin/

any other way to do it ?
there must be a easyer way !!

well if you read the instructions, it tells you. phpMyAdmin IS the easiest way, otherwise you can use the cmd line mysql monitor.

I hate to bring this up, but i've encountered a problem after all:

Some users keep getting the message:

Username already exist, please go back and try again

when they simply modify their profile in any kind, say date of birth.

Anyone else got this problem? And more important: how to fix?

-Alex

I have had afew users report that to me.

make sure the code in line 352 of member.php has

at the top if not download the hack again and re apply, else it could be the characters within the persons username, can you show me one of the usernames of people who were trying to change their profile.

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:

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:

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 :(

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

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

paste the contents of member.php

1330 to 1340 please

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

Problem:

I just tested it by changing my username twice. The first time worked fine, and showed my old one in my user profile. But when I changed it again, "Previous usernames: " was blank. Any ideas?

btw...the field that holds the previous usernames in the MySQL DB is empty.

Pie'oh'pah - I had the same problem. I found that in the instructions the edit said to edit this:
Well...my version 2.0.3 ...didn't have the ending " } " in that code above...it was further down the page. I found it and added the necessary code after it and that fixed my problem.

Try that. I hope this helps. :)

...

Help... :)

Just what I was looking for!

Along the installation, it asks me to Creat A Table How do i do this?

I must say there are some bugs here:

1. Signatures don't seem to carry over. I'm not sure if it is just my site though.
2. I think it is case sensitive on the check to see if the username exists already.

although this hack seems really good... i just htink it's a bit too much power for the users.. just switiching one between another as they feel like it, is a bit too much for me..

The nice thing about it is the allowance of mandatory time intervals between username changes.

oh didn't know that... i think i'll install it then and set a 30 day period inbetween. thx for telling me

Its been so long since i last looked at these so bare with me.

The last time i checked the usernames are not case sensetive, so the username ppn and PPN are the same people. The check is also not case sensetive.

Signatures are stored in the user table, all it does is rename the username for that id to another username.

I'm having problems with it. As I said before, it tracks the first name change just fine, but after that the table is empty.

I suppose i'll re-write the logging code. I'm sure that i've done something wrong there :P

Sorry, just to verify, if I install this will it work? *lol*

I am confused :(

yes everything works apart from name logging which i have yet to get around to fiddling with.

Thanks, so far its working great :) :)

Ok, I installed this a while back... But now how do i change it where they can change there names at any time?

Im kinda confused now... lol

-Syphin

Anyone?? >_<

In the admin cpanel under User and Registration Options

Have you fixed name logging yet?