community builder db feilds????

16 years 6 months ago #50406 by jmiller1
community builder db feilds???? was created by jmiller1
Hi there -

We really need a messenger service that lets our Non profits message their group - We are working at getting PhP121 running for a trial.

I've been editing the php121config.php - however I'm not sure of what feilds in my mysql database to change this file's default vaules to match?? see below..

/*****************************************************************************************
** Extra Database Options **
** DO NOT CHANGE THESE unless you are wanting to use your existing user database **

I really want to use our CB for this -

** If you want to use your existing user database (with existing usernames and **
** passwords, you MUST first alter your database to include the extra PHP121 fields. **
** To do this, do the following: **
** **
** 1. EDIT sql/alter_existing_usertable.sql and change the name of the table on the **
** first line to be the name of your existing users table. **
** **
** 2. EXECUTE sql/alter_existing_usertable.sql within your existing database **
** (You can do this easily with PHPMyAdmin if your host has it, or simply 'source' **
** it on the mysql console after selecting the appropriate database ('use')) **
** **
** 3. CHANGE the options below to match your user table configuration. **
** **
******************************************************************************************/


# db_usertable: name of the existing user table (e.g. php121_users)
$db_usertable = "jos_comprofiler" #php121_users";

# dbf_uid: name of the user id field (e.g. uid)
# (must be an integer field)
$dbf_uid = "uid";

# dbf_uname: name of the username field (e.g. uname)
$dbf_uname = "uname";

# dbf_upassword: name of the password field (e.g. upassword)
$dbf_upassword = "upassword";

# dbf_passwordtype: password type, either md5 or plaintext
$dbf_passwordtype = "md5";

# dbf_uemail: name of the email field (e.g. uemail)
$dbf_uemail = "uemail";

# dbf_user_chatting: name of the php121 user_chatting field (e.g. php121_user_chatting)
$dbf_user_chatting = "php121_user_chatting";

# dbf_smilies: name of the php121 smilies field (e.g. php121_smilies)
$dbf_smilies = "php121_smilies";

# dbf_level: name of the php121 level field (e.g. php121_level)
$dbf_level = "php121_level";

# dbf_showrequest: name of the php121 showrequest field (e.g. php121_showrequest)
$dbf_showrequest = "php121_showrequest";

# dbf_uname_len: the length of the username field
$dbf_uname_len = 25;

# dbf_upassword_len: the length of the password field
$dbf_upassword_len = 40;

# dbf_uemail_len: the length of the email field
$dbf_uemail_len = 255;

# dbf_upassword_input_min_length: the minimum password length allowed
$dbf_upassword_input_min_length = 6;

# dbf_upassword_input_max_length: the maximum password length allowed
$dbf_upassword_input_max_length = 10;

# dbf_beep_newmsg: name of the php121 beep on new msg field (e.g. php121_beep_newmsg)
$dbf_beep_newmsg = "php121_beep_newmsg";

# dbf_focus_newmsg: name of the php121 focus on new msg field (e.g. php121_focus_newmsg)
$dbf_focus_newmsg = "php121_focus_newmsg";

# dbf_banned: name of the php121 user banned field (e.g. php121_banned)
$dbf_banned = "php121_banned";

# dbf_timezone: name of the php121 user timezone field (e.g. php121_timezone)
$dbf_timezone = "php121_timezone";

# dbf_timestamp: name of the php121 user timestamp field (e.g. php121_timestamp)
$dbf_timestamp = "php121_timestamp";

# dbf_language: name of the php121 user language field (e.g. php121_language)
$dbf_language = "php121_language";

# dbf_auto_email_transcript: name of the php121 auto_email_transcript field (e.g. php121_auto_email_transcript)
$dbf_auto_email_transcript = "php121_auto_email_transcript";

?>


Could you provide some guidance???

best regards,

John Miller - evo admin
www.evopayz.com

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.160 seconds

Facebook Twitter LinkedIn