Add MSN Messenger Field to profile

I was fiddling around today with templates and stuff, and decided that I wanted my MSN messenger field(which was a custom field at the time) up next to the AIM and YAHOO messenger fields (it looks kind of silly down there with Location, etc). So I moved it up there, just adding a row with MSN: and $bbuserinfo[fieldx] in it. Well, the bottom one still showed up( as it is supposed to ). So I made it so it doesn't appear to users, and the name didn't appear in the new row I made; it was blank also. So I made this hack =P. (my first )

---------------------------------------------

Files Edits: 3 (member.php, register.php(2))
Templates Edits: 4 (getinfo, modifyprofile, registeradult, registercoppa)
Queries: 1
Install Time: 5 minutes

Very simple, post here if any problems. If you want a screenshot, Just Look at the AOL instant messenger field and pretend it says MSN.

[Brad]

i also did this one frist, then the intergraded one was made because people wanted the msn feild under the other contacts. my verson put a button in post, a link is in my sig. anyways nice job man

[clouds_kid]

Good job austin

[banjolawyer]

I am a beginner. Can you please answer a very simple question for me? Where do I go to comply with the following:

Step 1

Run this query:

ALTER TABLE user ADD msn varchar(40) NOT NULL;

[Link14716]

[sql]ALTER TABLE user ADD msn varchar(40) NOT NULL;[/sql]

Click the link

[Austin Dea]

Hey wow, I never knew about that [ sql] dealie =P.

[concept]

can i get a screen shot of this?

[Austin Dea]

Originally posted by Austin Dea
If you want a screenshot, Just Look at the AOL instant messenger field and pretend it says MSN.

[Hypey]

I don't mean to bug anyone (Okay, I do >_>) but I'm an idiot when it comes to SQL stuff.. I tried to install this hack (Which I thought would be simple enough) and now, when people click on Profile/Options etc within their CP, this error pops up -

"Parse error: parse error in /homepages/7/d69116374/htdocs/forums/member.php on line 596"

I tried deleting the query and reverting the Member.php file back, yet I still have that error.. Can anyone help me please? I'm desperate ;_;

[Austin Dea]

If you reverted the file to the original member.php, and you still get the error, there's nothing I can do about that.

Can you post the code in and around line 596?

[Hypey]

(NULL,'$bbuserinfo[userid]','".time()."','$activateid',0)");

^ I think thats line 596 anyway

Edit - Heres a bit of code around it -

//save to DB
$DB_site->query("INSERT INTO useractivation VALUES (NULL,'$bbuserinfo[userid]','".time()."','$activateid',0)");

$username=unhtmlspecialchars($bbuserinfo['username']);
$userid=$bbuserinfo['userid'];

I've had reports from people on my forum that they when they log out, they can't log in again afterwards.. Which is not good o_O;; I'm seriously praying that I haven't killed the forum off here >_<