What's in them? phpbbmysql_sid probably has a session id, so from there you just need to find out from the phpbb people how to query the user id from the database when given the session id. That'll be the session query for the integration generator.
######################################################################################## ## MOD Title: PHPbb2 Integration with WSNLINKS ## MOD Author: Webmaster < webmaster@allaboutdatingsites.com > http://www.allaboutdatingsites.com ## MOD Description: This MOD describes the procedure for integrating WSNLINKS and PHPbb2 ## ## Installation Level: Intermediate ## Installation Time: 10 Minutes ## Files To Edit: ## ## phpbb2: ## ## /includes/sessions.php ## ## wsnlinks: ## ## /integration/phpbb2.php ## ## ## Database / Table Modifications: ## ######################################################################################## ## Author Notes: ## ## This MOD assumes a clean,customized installation of phpbb2 and wsnlinks. ## Both applications are installed in the same database using the default ## prefix for each application. You can name the database anything you want ## but it needs to be reference in the config files for each application. ## You should be able to call the wsnlinks from someplace on the phpbb2 home ## page or a portal, if you use one (this is for convenience to call wsnlinks). ## The cookie control for wsnlinks needs to be managed by phpbb2. When you set ## the wsnlinks to phpbb integration, it uses the phpbb_user table for its user ## instead of its own. Per the wsnlinks documentation you need to turn off the ## registration process and remove the registration links from the wsnlink pages. ## You also need to remove the login/logout links on the wsnlinks pages. If they ## are not removed, it creates a big problem with the integrated users, logins ## and logouts need to be through phpbb, not wsnlinks. ## ## ## If you login to phpbb and go to the wsnlinks page, you do not see the active ## user until you do a page refresh for some reason. ## ## ## ## ######################################################################################## ## MOD History: ## ## 2006-10-7 - Version 1.0.0 ## ## - Initial release. ## ######################################################################################## ## ## Before Making Any Code Changes To Your Directory, ## You Should Back Up All Files Related To This MOD. ## ######################################################################################## ## ## Disclaimer: ## ## The MOD referenced in this document is provided "AS IS" without warranty of any kind. ## As the installer, you bear full responsibility for its application and administration. ## This MOD is completely unsupported, niether implied or intended. In the event that ## things go badly, your backup is your support vehicle.Under no circumstances shall the ## Author be held liable for incidental, special, indirect, direct or consequential damages ## or loss of profits, interruption of business, or related expenses which may srise from ## use of this software or documentation,including but not limited to those resulting from ## defects in software and/or documentation, or loss or inaccuracy of data of any kind. ## ######################################################################################## ## # #-----[ SQL ]------------------------------------------ # # Both phpbb2 and wsnlinks need to be in the same database. # #-----[ OPEN ]------------------------------------------ # # <PATHTOPHPBB2ROOT>/includes/sessions.php # #-----[ FIND ]------------------------------------------ # # # setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure); # setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure); # # # #-----[ INSERT AFTER ]------------------------------------------ # # # # $user_pw = $userdata['user_password']; # # setcookie('wsnuser', $user_id, time() + 100000, '/', false); # setcookie('wsnpass', $user_pw, time() + 100000, '/', false); # # # #-----[ FIND ]------------------------------------------ # # # # setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure); # # return true; # # #-----[ REPLACE WITH ]------------------------------------------ # # # setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure); # # setcookie('wsnuser', $user_id, time() + 100000, '/', false); # setcookie('wsnpass', $user_pw, time() + 100000, '/', false); # # return true; # # #-----[ FIND ]------------------------------------------ # # # $cookiesecure = $board_config['cookie_secure']; # # setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure); # # # # #-----[ INSERT AFTER ]------------------------------------------ # # # setcookie('wsnuser', $user_id, time() + 100000, '/', false); # setcookie('wsnpass', $user_pw, time() + 100000, '/', false); # # # #-----[ OPEN ]------------------------------------------ # # <PATHTOPHPBB2ROOT>/WSNLinks/integration/phpbb.php # #-----[ FIND ]------------------------------------------ # # $idcookiename = ''; # $passwordcookiename = ''; # #-----[REPLACE WITH]------------------------------------------ # # # $idcookiename = 'wsnuser'; # $passwordcookiename = 'wsnpass'; # # #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ # # EoM
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on PHPbb Integration Problem
Usergroup: Customer
Joined: Aug 09, 2006
Total Topics: 1
Total Comments: 10
Paul,
As I have also mentioned above, "I have three phpbb related cookies, phpbbmysql_ccip, phpbbmysql_data, and phpbbmysql_sid."
That appears not to be the problem you are describing.
mikesz
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
What's in them? phpbbmysql_sid probably has a session id, so from there you just need to find out from the phpbb people how to query the user id from the database when given the session id. That'll be the session query for the integration generator.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
I don't think anyone really has a clue what is going on.
If phpBB isn't using a cookie, how does nigelreed@forums.british-expats[2].txt get into my cookies directory?
It has been a long time since I installed phpBB but I am almost certain it doesn't ask if you want to use cookies or not.
I cannot believe this is so difficult for something that seems so very, very simple.
Usergroup: Customer
Joined: Jul 17, 2003
Total Topics: 39
Total Comments: 100
I don't think anyone really has a clue what is going on.
If phpBB isn't using a cookie, how does nigelreed@forums.british-expats[2].txt get into my cookies directory?
It has been a long time since I installed phpBB but I am almost certain it doesn't ask if you want to use cookies or not.
I cannot believe this is so difficult for something that seems so very, very simple.
Usergroup: Customer
Joined: Aug 09, 2006
Total Topics: 1
Total Comments: 10
########################################################################################
## MOD Title: PHPbb2 Integration with WSNLINKS
## MOD Author: Webmaster < webmaster@allaboutdatingsites.com > http://www.allaboutdatingsites.com
## MOD Description: This MOD describes the procedure for integrating WSNLINKS and PHPbb2
##
## Installation Level: Intermediate
## Installation Time: 10 Minutes
## Files To Edit:
##
## phpbb2:
##
## /includes/sessions.php
##
## wsnlinks:
##
## /integration/phpbb2.php
##
##
## Database / Table Modifications:
##
########################################################################################
## Author Notes:
##
## This MOD assumes a clean,customized installation of phpbb2 and wsnlinks.
## Both applications are installed in the same database using the default
## prefix for each application. You can name the database anything you want
## but it needs to be reference in the config files for each application.
## You should be able to call the wsnlinks from someplace on the phpbb2 home
## page or a portal, if you use one (this is for convenience to call wsnlinks).
## The cookie control for wsnlinks needs to be managed by phpbb2. When you set
## the wsnlinks to phpbb integration, it uses the phpbb_user table for its user
## instead of its own. Per the wsnlinks documentation you need to turn off the
## registration process and remove the registration links from the wsnlink pages.
## You also need to remove the login/logout links on the wsnlinks pages. If they
## are not removed, it creates a big problem with the integrated users, logins
## and logouts need to be through phpbb, not wsnlinks.
##
##
## If you login to phpbb and go to the wsnlinks page, you do not see the active
## user until you do a page refresh for some reason.
##
##
##
##
########################################################################################
## MOD History:
##
## 2006-10-7 - Version 1.0.0
##
## - Initial release.
##
########################################################################################
##
## Before Making Any Code Changes To Your Directory,
## You Should Back Up All Files Related To This MOD.
##
########################################################################################
##
## Disclaimer:
##
## The MOD referenced in this document is provided "AS IS" without warranty of any kind.
## As the installer, you bear full responsibility for its application and administration.
## This MOD is completely unsupported, niether implied or intended. In the event that
## things go badly, your backup is your support vehicle.Under no circumstances shall the
## Author be held liable for incidental, special, indirect, direct or consequential damages
## or loss of profits, interruption of business, or related expenses which may srise from
## use of this software or documentation,including but not limited to those resulting from
## defects in software and/or documentation, or loss or inaccuracy of data of any kind.
##
########################################################################################
##
#
#-----[ SQL ]------------------------------------------
#
# Both phpbb2 and wsnlinks need to be in the same database.
#
#-----[ OPEN ]------------------------------------------
#
# <PATHTOPHPBB2ROOT>/includes/sessions.php
#
#-----[ FIND ]------------------------------------------
#
#
# setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
# setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);
#
#
#
#-----[ INSERT AFTER ]------------------------------------------
#
#
#
# $user_pw = $userdata['user_password'];
#
# setcookie('wsnuser', $user_id, time() + 100000, '/', false);
# setcookie('wsnpass', $user_pw, time() + 100000, '/', false);
#
#
#
#-----[ FIND ]------------------------------------------
#
#
#
# setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
#
# return true;
#
#
#-----[ REPLACE WITH ]------------------------------------------
#
#
# setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
#
# setcookie('wsnuser', $user_id, time() + 100000, '/', false);
# setcookie('wsnpass', $user_pw, time() + 100000, '/', false);
#
# return true;
#
#
#-----[ FIND ]------------------------------------------
#
#
# $cookiesecure = $board_config['cookie_secure'];
#
# setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
#
#
#
#
#-----[ INSERT AFTER ]------------------------------------------
#
#
# setcookie('wsnuser', $user_id, time() + 100000, '/', false);
# setcookie('wsnpass', $user_pw, time() + 100000, '/', false);
#
#
#
#-----[ OPEN ]------------------------------------------
#
# <PATHTOPHPBB2ROOT>/WSNLinks/integration/phpbb.php
#
#-----[ FIND ]------------------------------------------
#
# $idcookiename = '';
# $passwordcookiename = '';
#
#-----[REPLACE WITH]------------------------------------------
#
#
# $idcookiename = 'wsnuser';
# $passwordcookiename = 'wsnpass';
#
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM