adding new fields to the profile table

question:
how to add new fields to the class?
How to integrate them into the profile extension of the access user class (file ext_user_profile.php) ?


solution:
1. add new fields to the config file:

Code:

define("TBL_USERFIELD_5", "user_5");
define("TBL_USERFIELD_6", "user_6");

2. Add them to the database table too

Code:

ALTER TABLE `users_profile` ADD `user_5` VARCHAR( 150 ) NOT NULL AFTER `user_4` ,
ADD `user_6` VARCHAR( 150 ) NOT NULL AFTER `user_5` ;

3. modify these functions inside the file "ext_user_profile.php"
a. adding vars

Code:

var $field_five;
var $field_six;

b. modify the methods (function) "save_profile_date" and "get_profile_data". Note the var names like $field4 and the contants like TBL_USERFIELD_4

4. after that you can acces the vars $field_five and $field_six in you application

It's better to build this inside a new extenstion of the class because of later updates in this class (this is a hint for the more experienced user)

Easy and convinient way of doing it ! I merely just added a whole array of new items, which did mean some seraious typing had to be done ! But thanks for the good clarification !
Anders

Great class use it on all my  sites

[Guest]

[62.862]

Googlebot, Yahoo crawler, Msnbot