custom profile field as textarea / show single profilefield via button

[Harvey]

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=17d7eaa4a2813dd364b791911364f96c[/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 :p

[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.

[Sadie Frost]

Great hack idea! Kind of complicated, so before I begin I have a question for anyone who has installed this.

describe userfield
for all columns named field<number> query:
alter table userfield modify field<number> text;

For the above query, say the custom profilefield I create is field 5, is this the query I would run?

alter table userfield modify field5 text;

Thanks in advance for the help! :)

[Harvey]

if it already exists before installing the hack: yes

[bandersen]

Hello - I upgraded from 2.2.5 to 2.2.6 and the hack is not working anymore.

EDIT: redid the file edits and everything is working OK!

[Sadie Frost]

Works for 2.2.8 :)

[Dean C]

How did i not see this hack..

*Adds to favorites*

[Sadie Frost]

You probably don't periodically looks through the threads in this forum 'from the last millenium' lol :D

[Dean C]

I do

[Sadie Frost]

Good, that makes me feel less sad then ;) :D

[Dean C]

Congratulations :)

[PsyBlast]

what exactly does this hack do?

[Dean C]

I believe that it allows you to customize any place where you can input data such as where im typing this reply right now - and it allows you to define whether the user can put html, vbcode and smilies in it :)

- miSt

[Sadie Frost]

I do have it up on my site, though it's not being used by members yet (still setting up what it's going to be used for).

after-darkness.com

If you look at one of my posts (Vilandra) you will see a button in the postbit in the lower left. If you click on it it pulls up a page with the contents of the profile field on it.

If you install the hack as instructed, it would put that button with the pm, profile etc buttons though. :)

If you want to see the edit profile part of it,

username: test
pw: test