Names

[piersk]

What about having display names that we can change? This might solve Dannys' problems of wanting to change his username...

[jmcneese]

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=46

[piersk]

I wasnt suggesting that people should change their username, but maybe if they want to change the name that is displayed on the posts...

[jmcneese]

btw,

the site admins should re-enable the "Powered by: vBulletin Version 2.2.6" in the footer template, you are not allowed to remove it from sight. (this includes changing it to a comment or changing the font color to the background).

just a word of caution.

[piersk]

You and I REALLY need to get out more...

[jmcneese]

Originally posted by piersk
I wasnt suggesting that people should change their username, but maybe if they want to change the name that is displayed on the posts...

well with vb this isn't a big deal, because everyone's username by post is referenced via an id that is contained in the user table. so, if you change the name in the table, it is reflected automagically in all posts, as the userid never changes.

[piersk]

And does it tell you how to do that in the hack?

[jmcneese]

there's nothing to do, for a user, that is. vb works via templates, and this hack modifies the user control panel templates, as well as a bit of code underneath to do the actual UPDATE and keep track of who changed their username.

here's a sample vb user table:

CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(50) NOT NULL default '',
styleid smallint(5) unsigned NOT NULL default '0',
parentemail varchar(50) NOT NULL default '',
coppauser smallint(6) NOT NULL default '0',
homepage varchar(100) NOT NULL default '',
icq varchar(20) NOT NULL default '',
aim varchar(20) NOT NULL default '',
yahoo varchar(20) NOT NULL default '',
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL default '0',
showemail smallint(6) NOT NULL default '0',
invisible smallint(6) NOT NULL default '0',
usertitle varchar(250) NOT NULL default '',
customtitle smallint(6) NOT NULL default '0',
joindate int(10) unsigned NOT NULL default '0',
cookieuser smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
posts smallint(5) unsigned NOT NULL default '0',
timezoneoffset varchar(4) NOT NULL default '',
emailnotification smallint(6) NOT NULL default '0',
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL default '0',
emailonpm smallint(6) NOT NULL default '0',
pmpopup smallint(6) NOT NULL default '0',
avatarid smallint(6) NOT NULL default '0',
options smallint(6) NOT NULL default '15',
birthday date NOT NULL default '0000-00-00',
maxposts smallint(6) NOT NULL default '-1',
startofweek smallint(6) NOT NULL default '1',
ipaddress varchar(20) NOT NULL default '',
referrerid int(10) unsigned NOT NULL default '0',
nosessionhash smallint(6) NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
receivebulletin smallint(5) unsigned NOT NULL default '1',
receivebulletin_type smallint(5) unsigned NOT NULL default '1',
starlevel varchar(5) NOT NULL default '0',
starimg varchar(25) NOT NULL default '0',
rooms varchar(128) NOT NULL default '',
reg_time int(11) NOT NULL default '0',
gender tinyint(1) NOT NULL default '0',
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
KEY inforum (inforum),
KEY referrerid (referrerid)
) TYPE=MyISAM;


and a sample vb post table:

CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
attachmentid smallint(5) unsigned NOT NULL default '0',
pagetext longtext NOT NULL,
allowsmilie smallint(6) NOT NULL default '0',
showsignature smallint(6) NOT NULL default '0',
ipaddress varchar(16) NOT NULL default '',
iconid smallint(5) unsigned NOT NULL default '0',
visible smallint(6) NOT NULL default '0',
edituserid int(10) unsigned NOT NULL default '0',
editdate int(10) unsigned NOT NULL default '0',
editreason varchar(200) NOT NULL default '',
PRIMARY KEY (postid),
KEY iconid (iconid),
KEY userid (userid),
KEY threadid (threadid,userid)
) TYPE=MyISAM;

[piersk]

Presumably you have to be an admin on the board.
Im just mentioning something the admins might want to do on this board.

[jmcneese]

oh yes, the admin(s) would have to apply the hack, but from then on there would be an entry in the user control panel allowing you to change your username.

[piersk]

i dont think Id want to change my username tho, id just get really confused :confused: .

All Id want to do is change the name that is displayed on all my posts.

[daynah]

I think he wants to change his 'title', the one below his username. To do that, try this:

User CP -> Edit Profile -> Custom User Text

Edit the text box and save. :)

[piersk]

Nope, there is no "Custom User Text" box.

[daynah]

This is what I see....

:confused: I don't know why you don't have that option.

[piersk]

I get the birthday bit, but then it goes straight to the additional info bit

[jstarkey]

Originally posted by jmcneese
there's nothing to do, for a user, that is. vb works via templates, and this hack modifies the user control panel templates, as well as a bit of code underneath to do the actual UPDATE and keep track of who changed their username.



here's a sample vb user table:



We'll be avoiding hacks as much as possible. We need to be able to follow upgrades, without crazy costs.

We also need to keep user names intact. It's only going to cause confusion and extra posts if people start changing their names.

[mattr]

Could you change the case of my username? IIRC it was 'MattR' in the old forums, it is MattR on virtually every forum I go to, and now it's all lower case which bothers me. :D