miniBB ®

miniBB

®
Support Forums
  
 · Start · Sign in · Register · Search · Statistics · File Bank · 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:32Reply Quote
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:51Reply Quote
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 Lead Developer
#3 · Posted: 28 Oct 2006 11:33Reply Quote

How To miniBB Support Forums / How To /
 How can I do to login on minibb using my users table?
 Share Topic's Link

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

BB code for the Bold StyleBB code for the Italic StyleBB Code for the PictureBB code for the URLUpload a File

  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.