LD SoftwareBespoke Software, Web Design, Security Consultants and Host Services.

Menu

Sentinel
You have been warned!
We have caught 5848 shameful hackers.

NukeSentinel(tm)

Paypal Referral
Sign up for PayPal and start accepting credit card payments instantly.

Link Exchange
Join our free link exchange

Click Here
 
More than 255 characters of user extra information

12.1. More than 255 characters of user extra information

By clicking on the icon with the title "Your Info" in the user account menu (see Chapter 6), you arrive at a HTML form where you can enter various pieces of information about yourself, in addition to your personal preferences. One of the fields, the "Extra Info" field, gives you the opportunity to tell something about yourself that other visitors can read when they click on your profile. However, you will not be able to enter more than 255 characters of extra information. That's a bit too few, even for moderately turbulent biographies. To change that, you must find out where that information is stored in the database.

Figure 12-1. Extra Info field of User Personal Information (Your Info)

Extra Info field of User Personal Information (Your Info)



That extra information is stored in the field "bio" of the nuke_users table (assuming the table prefix, $prefix, is "nuke" for you, see Section 3.7). Thus, what you have to do is log in your database and change the length of the bio field. Currently, it is defined as "tinytext" which gives the limitation of 255 characters (see MySQL String Types).

Once logged in the MySQL database, do on the MySQL prompt[1]:

alter table nuke_users modify bio text;

This will give you the next possible (see MySQL Column Type Storage Requirements) maximum length of 2^16-2. That's a little less than 65KB of text. That should be enough text for your visitors to write a small story of their life.

Notes

[1]

See edit module your_acount.

 
You can syndicate our News with backend.php And our Forums with rss.php
You can also access our feeds via Feedburner Site News and LD Software Forums
© 2009 ld-software.co.uk All Rights Reserved.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.34 Seconds