15 years on The Web
miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
How To miniBB Support Forums / How To /   

How can I do to login on minibb using my users table?

Author Galileo
Partaker
#1 | Posted: 28 Oct 2006 04:32 
Hi to everyone,

I've a table called: users in my db.
This table has 3 fields:
- username
- password (md5)
- email

I see the $dbUserSheme variable but I don't understand how can I do to use this table instead the minibb users table.

I've set up this var:
$Tu='users';


$dbUserSheme=array(
'username'=>array(1,'username','login'),
'user_password'=>array(3,'password','passwd'),
'user_email'=>array(4,'email','email'),
'user_icq'=>array(5,'user_icq','icq'),
'user_website'=>array(6,'user_website','website'),
'user_occ'=>array(7,'user_occ','occupation'),
'user_from'=>array(8,'user_from','from'),
'user_interest'=>array(9,'user_interest','interest'),
'user_viewemail'=>array(10,'user_viewemail','user_viewemail'),
'user_sorttopics'=>array(11,'user_sorttopics','user_sorttopics'),
'language'=>array(14,'language','language'),
'num_topics'=>array(16,'num_topics',''),
'num_posts'=>array(17,'num_posts',''),
'user_pac'=>array(18,'user_pac','user_custom1'),
'user_custom2'=>array(19,'user_custom2','user_custom2'),
'user_custom3'=>array(20,'user_custom3','user_custom3')
);

thanks

Author Galileo
Partaker
#2 | Posted: 28 Oct 2006 04:51 
I've created a view with the follow fields:

# user_id - integer auto_increment type; stores unique user ID
# username - varchar type, stores user's login (sign in) name
# user_regdate - datetime type, sign up date
# password - varchar type, stores encrypted user's password (in miniBB, it is encrypted via MD5() function)
# user_email - varchar type, stores unique email of the user
# activity - integer type (0 or 1) - identifies user's access to forums. If this values is set to 0, user's membership is disabled for some reason. 1 by default.
# user_viewemail - integer type (0 or 1) - if 1, user has allowed to show his email publically. 0 by default.


but I have not this fields:
# user_sorttopics - integer type (0 or 1) - default sorting by latest replies or latest topics.
# language - char type, 3 letter index of forums interface language
# num_topics - integer type; number of topics user created
# num_posts - integer type; number of posts user created

Can I use a view? or I need a table?

Author Paul
Lead Developer
#3 | Posted: 28 Oct 2006 11:33 

How To miniBB Support Forums / How To / How can I do to login on minibb using my users table? Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB