Sharing user database

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Sharing user database
Donovan
CZ Active Member
 Codezwiz Site Donator
Donovan has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Web Developer
Gender: Male
Fav. Sports Team: St Louis Cardinals
Status: Offline
Joined: Dec 03, 2003
0.02 posts per day
Posts: 160
Points: 9,216
   
Hello all.

Usually spend my time at Nuke Cops or Nuke Forums. Decided to try to get this answered here since I can't get any response from those sites.

I have searched but can't find any reference. What I want to do is add multiple forums to and existing PHPNuke install. My site is up and running at
[ Register or login to view links on this board. ]

It is version 6.7 and is functioning with the forums it came with but I want to add additional forums to the same database so the general public can have more to chew on, and only login in once.

I have read where I need to change the prefix in the user tables from PHPBB to Nuke in the config file of the new PHPBB install to get it to share the same users from one database. How do I get the new forums wrapped into the PHPNuke template. I don't want it to standalone and would like it wrapped into the CMS like my current forums are.

Thanks for any assistance.



Back to top Reply with quote
#2   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
I dont see why it couldnt be done. I have personally never done it so I dont want to start guessing. I found a couple links though with lengthy discussions about porting over a standalone forum that might be useful
[ Register or login to view links on this board. ]
[ Register or login to view links on this board. ]

There where even some scripts that do it for you. The only problem I could potentialy see is where the Forum is kept. And is it going to be ok if users post in one forum but all of the information is stored in the others database. But nothing is impossible. If I hear or find out anymore info I will post it for you.

Telli




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   
Donovan
CZ Active Member
 Codezwiz Site Donator
Donovan has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Web Developer
Gender: Male
Fav. Sports Team: St Louis Cardinals
Status: Offline
Joined: Dec 03, 2003
0.02 posts per day
Posts: 160
Points: 9,216
   
I am attempting this again. I have a subdomain named realism that I have all the 2.06 PHPBB files. I want to do a fresh install of a PHPBB forum in a subdomain [ Register or login to view links on this board. ] and share the users_table located in my Nuke site at [ Register or login to view links on this board. ]

I can't seem to reach the install.php located in the realism subdomain from my browser. Wouldn't I type [ Register or login to view links on this board. ]

My other PHPBB forum I have installed that doesn't yet share the user_table from the nuke install is working in a subdirectory at [ Register or login to view links on this board. ] I want to change this and place it in a subdomain.

This would be so much simpler if PHPBB would have Parent / Child forums like vBulletin does.


Is the vBulletin port to Nuke very difficult, and could I save / import my present NukePHPBB board into vBulletin?



Back to top Reply with quote
#4   
Donovan
CZ Active Member
 Codezwiz Site Donator
Donovan has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Web Developer
Gender: Male
Fav. Sports Team: St Louis Cardinals
Status: Offline
Joined: Dec 03, 2003
0.02 posts per day
Posts: 160
Points: 9,216
   
I tried to just install it where my other standalone PHPBB forum is located and I got the same error as before.



phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'i3rd-inf_main.real__users' doesn't exist

SELECT u.*, s.* FROM real_sessions s, real__users u WHERE s.session_id = 'e0d63054ecb2b6f2ba46466cf2f541b4' AND u.user_id = s.session_user_id

Line : 235
File : /home/i3rd-inf/public_html/Forums/Realism/includes/sessions.php



I use PHPMYadmin and verify that indeed i3rd-inf_main.real_users does exist.

This I believe has to do with u.user_id and s.session_user_id

So I am stuck just like last time when I posted on the Nuke Cops forum.

Any help is mucho appreciated.


Back to top Reply with quote
#5   
Donovan
CZ Active Member
 Codezwiz Site Donator
Donovan has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Web Developer
Gender: Male
Fav. Sports Team: St Louis Cardinals
Status: Offline
Joined: Dec 03, 2003
0.02 posts per day
Posts: 160
Points: 9,216
   
Well after much head scratching, I have two forums running on my PHPNuke site has well as the default Nuke forums that it came with all sharing the same nuke_user, nuke_bbuser_group, and nuke_group table.

Now I have a doozy of an issue.

My site is a game site of the 3rd Infantry Division playing the Call of Duty game. The majority of my moderators are in the NCO group.

nuke_bbuser_group.group_id = 7

After setting both forums up and doing some tweaking I logged off and logged onto my main forum. I immedialty noticed the majority of my moderators where now administrators on my Nuke forum.

My two sub forums now wont let me login as an admin with the admin account , saying I am not authorized to admin these forums.

My admin account is nuke_user.user_id = 10 which should have a group_id of 12

The user_id of 10 in the nuke_bbuser_groups has a concantenated key group_id = 7

group_id 7 belongs to the NCO's

Is this why all my NCO's changed to administrators in my PHPNuke forum?

Can I just manually change the group_id of my admin account to 12 and hope for the best.



Back to top Reply with quote
#6   re: Sharing user database
Dauthus
CZ Addict
 Codezwiz Site Donator
Dauthus has been a member for over 20 year's 20 Year Member
usa.gif illinois.gif
Age: 61
Gender: Male
Website:
Status: Offline
Joined: Mar 17, 2004
0.06 posts per day
Posts: 426
Points: 15,917
   
I know this is a little "old" of a post, but has anything been done with this? I too am thinking of working on creating multiple forums in a single Nuke installation. I want to keep the user info, but everything else in the database must go. I ain't sure this has been done yet, but if anyone can point me in a good direction, it would be great.




_________________
[ Register or login to view links on this board.]
Vivere disce, cogita mori
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum