winkhere

I have PHPBB, PHPAuction, OSCommerce and Photopost, all of which use MySQL and have seperate logins. I would really like to have one login for all of them, so the user only has to sign up and login one time, verses 4 as it is now. I am not sure how difficult it is for all four but if not, I found at one time a mod that would join the PHPBB and the PHPAuction but I lost it in an upgrade. Does anyone have any info on this?

I have the PHPBB and the PHPAuction. I used a mod (I think it was pass addon v2) and it is supposed to make it where you can signup one time with either and then only have to login once. This works if you login to PHPBB first and then go to PHPAuction, but if you login to PHPAuction first it just resets you back to the login page like you never logged in. There is no error but no result. I need to at least fix this, but if I could accomplish the following, I would be ecstatic!!! I have the PHPBB, PHPAuction, PhotoPost and an OSCommerce(store) that all have login... I would rather make one initial login at the beginning that link all of them but am not sure how to do it. They are all MySQL, is this something easy to do or no?

Yes! Very useful trick! Thank you

Ok... I was doing that and it wasn't working. Turns out, the first error was in users_login.php and the second error was in login.php... I was going to the same one. Thanks for the help! After eight hours in a row, everything looks the same!

Ok, it let me login twice, and now it is giving me this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhouse/public_html/tradingspace/login.php on line 9 Warning: Cannot modify header information - headers already sent by (output started at /home/myhouse/public_html/tradingspace/login.php:9) in /home/myhouse/public_html/tradingspace/login.php on line 18 There is nothing on line 9 or 18...

I had a brainfart...lol. I went into the PHPAdmin and the column was titled "nick", so I changed it to "username" and now it works. Do you foresee any issues I may have with this fix? I figured it was more standard than changing the other to nick... Thanks so much for your help!

Ok, when I did that, this is what came up: Error: Unknown column 'username' in 'where clause' with query select id from PHPAUCTION_users where username='myhouse' and password='645036f7dc456ff666d194daf21be791' and suspended=0 Not sure how to fix that error either...

When any of my users try to login it is giving this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhouse/public_html/tradingspace/user_login.php on line 42 I went to this file and this is what the paragraph says: $query = "select id from PHPAUCTION_users where username='$username' and password='".md5($MD5_PREFIX.$password)."' and suspended=0"; $res = mysql_query($query); //print $query;; if(mysql_num_rows($res) > 0) { $PHPAUCTION_LOGGED_IN = mysql_result($res,0,"id"); $PHPAUCTION_LOGGED_IN_USERNAME = $HTTP_POST_VARS[username]; session_name($SESSION_NAME);