minibb®
Fight the automated spam - protect your miniBB-forums,
getting the Captcha addon! Click here to read more.
Captcha Addon for miniBB
Community Forum
 | Forums | File Bank | Sign Up | Reply | Search | Statistics | Manual |
Master Class miniBB Community Forum / Master Class /

Integration with external DB and Session management

 Page:  ««  1  2  3  4  5 
Paul
CEO
#61 | Posted: 8 Jan 2008 05:38
Reply 
my current database doesnt have a userid, only username which is a primary key

- No it won't work. Having integer unique ID is a main condition.

my password field is stored as clear text..not encrypted. Can it still work?

- Yes it can. You just need to modify bb_cookie.php's function writePwd() - and probably some few other things.

my regdate is defined as VARCHAR storing only the date without time. Can it still work?

- Yes it can.
perx
Guest
#62 | Posted: 8 Jan 2008 06:27
Reply 
Thanks for the lightning fast reply! ....one more questions..as mention, i already have a username which is a primary key....when i try to add another auto increment id field it fails...so i guess i cant get it to integrate..is there any workaround?
Paul
CEO
#63 | Posted: 8 Jan 2008 09:29
Reply 
All I could say that you must have a numerical auto increment field for ID. Since database handles it automatically, I don't know why it would be not possible just add this field. This is the only workaround ;-)

alter table users add user_id integer(10) not null auto_increment primary key;
perx
Guest
#64 | Posted: 8 Jan 2008 20:39
Reply 
oh because my username is already a primary key and hence i couldn't add user_id as another primary key...unless of course i drop the primary key that belongs to username...let me go and see if dropping it will affect any part of my code...thanks alot..really appreciate it...=D
Anonymous
Guest
#65 | Posted: 10 Jan 2008 07:09
Reply 
ok..i managed to get it to work..didn't expect it to be that simple...I have tried other forums and its almost impossible to integrate any exisiting member database...Thanks minibb team for making this so easy!
Paul
CEO
#66 | Posted: 10 Jan 2008 08:38
Reply 
These are gold words which I've been even put under our "People Says" section on the first page. Thank you - we're glad our software's worth for you!
Tim
Guest
#67 | Posted: 24 Jun 2008 22:51
Reply 
Got a quick question here I have 2 cookies from my script
1 is the user name the other is the id
it does not store the password cookie

So is it possible to drop the password side of the log in so that
it will work with the username cookie only

or as in if cookie 'username' login
Paul
CEO
#68 | Posted: 25 Jun 2008 02:08
Reply 
It is possible, in bb_cookie.php there is a function user_logged_in() which should you need to modify to compare by the received ID and the username.
 Page:  ««  1  2  3  4  5 
Your reply
Bold Style  Italic Style  Image Link  URL Link 


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

Before posting, be sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.

 
Online now: Guests - 36
Members - 0
Most users ever online: 191 [24 Dec 2007 14:33]
Guests - 191 / Members - 0

Forums are powered by miniBB®