Forum Moderators: coopster

Message Too Old, No Replies

add data fields to mySQL table

wondering if it's possible to do this

         

mutedgirl

4:27 am on Mar 14, 2004 (gmt 0)

10+ Year Member



Okay, here's what I have. I have a PERL program that uses a .db file to store username/password and other data for members. I am also going to have a PHP/MySQL based board system (phpbb) installed on the server. What I would REALLY like to do is to have users be able to register for one and be automatically registered for the other. The problem is...I don't know much about how all this works! I know just enough to get by with changing code around, etc...and also enough to screw things up now and then. ;)

Anyway, so is it possible? I'm thinking that somehow I could pull just the username/password data from the .db file (using a PHP script/file) and then put the data into the MySQL table used by the boards. But I'm not sure how to go about doing it, as far as the code and everything. If anyone has any direction on where I should begin (or if you need more information...not sure if I'm explaining everything right!) please help :) Thanks so much!

brucec

4:32 am on Mar 14, 2004 (gmt 0)

10+ Year Member



I also have a PHPBB board and I find that it does not work like a PHBP program that we can build from scratch. LOL

Although I usually offer some of my experience in PHP on this board, I am going to tell you that the PHPBB user guide is pretty good.

What advice I can offer you is this: When you develop your CGI program where the user registers, you need to have it call the URL to register at your PHPBB board and it should eventuall end up at that site.

You can open the register.php file on your web server and look at all the variables used by PHPBB. I believe they are $Register_User and $Register_Pw, but don't quote me on this. Then, you modify it to accept your CGI call.

Make sure you back up all your PHPBB files so you can easily restore them in the event of a bug. :)

I hope this helps somewhat.

mutedgirl

3:33 pm on Mar 14, 2004 (gmt 0)

10+ Year Member



blah blah blah blah blah blah...

That's mostly what I just read ;) hehe

Actually, I understand the logic of what you just said..that makes sense to me. I opened up usercp_register.php (I'm assuming that's the correct file, there was no plain register.php) I think the variables are actually $username and I think the password variable is $cur_password (but I'm not positive on this...I'm trying to follow the code but I'm not sure I'm following it correctly)

Once I figure out what the variables are...how do I call them? Do I just add something in the form in the other program to call the variables in the usercp_register.php file? And how do I do that when it's already posting to another file within the program?

(as you can tell, I really don't know what I'm doing!) Thank you! :)