custom profile field as textarea / show single profilefield via button

Hi,

this hack is pretty complicate but why not share with you?

With this hack you can choose that custom user profile fields are textareas with or without HTLM, Images, Smiles, VB-Code (like the signature field).

Additionally you may specify a custom image, witch is placed left after the profile button in threads to open a new window with the information of that single user information.

Version: 0.9
VBB-Version: 2.2.4 (I installed it also on 2.2.1 to but the search-strings are a lttle bit different)
Example see attachment in the next post

Tables to change: 2
Files to change: 7
Templates to change: min 1
New templates: 4

Known bugs:
I think I really don't check the maximum text length
Extra Button only appers in normal threads. Not in PM and not in announcements

In advance please excuse the poor supoort I will give.
First, my englisch is so bad that I have to translate many words using a dictionary.
Second, I have more to do than hacking VBB.

PS: If there are errors in this text that leads to misunderstandings a moderator may edit this.

[Harvey]

here is the example.

[TheComputerGuy]

Thanks for this hack, good idea....

[bandersen]

Nice hack... I am thinking about installing it.. Any new info since post 1? Did install go OK for others...

[bandersen]

Hello Harvey - It is working now! Just trash my Emails

Thank you for a nice hack!!!!

[Harvey]

ok

Banderson wrote in email:
[quote]
1.TEMPLATE GETCUSTOMFIELD
I dont find "Profile from"... can this be Profile View?
Is $profiltfieldtitle meant to be $profilefieldtitle?

2. DB-UPDATES:
What is it... the same as when adding a new user profile in admin? Please advice...

3. WHEN ADDING A NEW PROFILE FIELD IN ADMIN I GET THIS ERROR - WHAT CAN IT BE:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder
,editable,textarea,allowhtml,allowbbimagecode,allo wsmilies,allowbbcode,button)
VALUES (NULL,'Fitness Notes','Your goals, accomplishments, and anything you would like to put in here. You may attach your training log (i.e the Ultracoach Log, the fitness test etc)',0,0,'1000','25','', '1', '1', '1', '1', '1', '1', '')
mysql error: Unknown column 'textarea' in 'field list'

mysql error number: 1054

Date: Saturday 25th of May 2002 06:42:03 PM
Script: admin/profilefield.php
Referer: admin/profilefield.php?action=add&s=17d7eaa4a2813dd364b7 91911364f96c[/url]

(PS. THE FIRST LINK HERE HAS THE DIRECTORY PATH DOUBLE...SHALL BE FORUMS/UPLOAD/PROFILEFILED.PHP)

4. WHEN MODIFYING A PROFILE IN ADMIN I GET THE FOLLOWING ERROR:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT IF(required=1,'Yes','No') as required,
IF(hidden=1, 'Yes', 'No') as hidden,
IF(editable=1, 'Yes', 'No') as editable,
IF(textarea=1, 'Yes', 'No') as textarea,
maxlength, size, title, profilefieldid
FROM profilefield
ORDER BY displayorder
mysql error: Unknown column 'textarea' in 'field list'

mysql error number: 1054
[/qoute]

1a.) Maybe it's "Profile View", I have the german templates
1b.) Misspelled $profilefieldtitle, I will correct it

2.) No, it's not the same.
2a.) There are some new options in for profilefield.
2b.) The old existing fields have a maximum length of 255 characters. I changed them to text for more characters.

3 & 4.) Your DB-UPDATES was not successfull. Should work with Firefly's Hack.


Anything else I should correct?

[bandersen]

Harvey - please remove the string showing a clickable link to my directories ... I already had someone click "log in" on my control panel. No reason to make it easy. Firefly's hack gave me IP and host....in Vietnam.
Thanks

[Harvey]

oh dear - my english. I don't understand. What must I remove???

First I edit the links away.

[bandersen]

Es ist sehr gut :cheeky:
Almost needed a dictionary for that

[dezoris]

No way, I cant believe you have to do all that just to get a larger text box and more room for characters???

Please help me with this, I am just trying to be able to have a larger text box to edit these custome fields in the admin panel for edit user.

Like I need that custome field box the size of this quick reply box, and also need it to hold more than 250 characters, I just want this in the admin panel.