[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,allowsmilies,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

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

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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*