Easy question: Staffrank - sql query

[Ala21]

Hello,

i installed the staff rank hack, though it looks like it is limiting the characters allowed in the field so this is a problem if I am using html code and want to format the text.
I am not a SQL expert but I think it's because of this query:

ALTER TABLE user ADD (
staffrank varchar(100) not null default ''
)


How do I edit it to increase the maximum characters allowed? IF it's that limiting the characters, but i'd guess so.

Thank you

[jugo]

I don't think it's that cause that has a character limit of 100.

Check the template and see what the form has set as the character limit. and change it there.

[Ala21]

Hello jugo thanks for your help

These are the instructions for the hack installation, can you tell me exactly where I should look? Thank you

====================================
Run this query
====================================
+---------------------+

ALTER TABLE user ADD (
        staffrank varchar(100) not null default ''
)

+---------------------+

====================================
open admincp/user.php Find:
====================================
+---------------------+

        print_select_row($vbphrase['language'] , 'user[languageid]', array('0' => $vbphrase['use_forum_default']) + fetch_language_titles_array('', 0), $user['languageid']);

+---------------------+

====================================
Add Under:
====================================
+---------------------+

        print_input_row($vbphrase['staff_title'], 'user[staffrank]', $user['staffrank']);

+---------------------+

====================================
Add Phrase:
====================================
+---------------------+
Phrase Type: Global
Varname: staff_title
Text: Staff Title
+---------------------+

====================================
In your postbit or postbit_legacy Add where you want to show your staff title:
====================================
+---------------------+
$post[staffrank]
+---------------------+

All Done :)

Or anyone else?

Fixed. As i thought it was the VARCHAR limiting to 100, i set it to 250 and now everything works like it should
Thanks for the help

[Logikos]

Yes it would only allow 100 as the query sets the limit, you would just have to go into phpmyadmin and change it to what ever you would like it to be.