Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Duplicate Users In mysql for php fusion
Old 01-18-2008, 04:42 PM Duplicate Users In mysql for php fusion
Junior Talker

Posts: 4
Name: Jamie Davis
Trades: 0
Hello,
Im sorry that i am not a proffesional web designer and only in charge of a gaming clan but i have a question.
I have been using php-fusion for the last couple of months and started to like it then had the idea of doing a mass overhaul on my site. what i have now is the original site skimmed down to lierally the forums and a kind of long winded set of register forms i made myself . then i have a sub site for each of the games we play so 7 fusion sites in all. but what i would like is that users register on the main site (registration links on all sub sites will lead there) and then automatically become members of the sub sites. i had a look thru fusion and becuase im not a strong coder thought maybe i would go back a step to the mysql tables. my main site is here http://exfgames.com/news.php and the site i am currently working on to get it to work is http://bf2.exfgames.com for the battlefield 2 team. these 2 sites i have installed on the same database (the others are on seperate databases at the moment) when u install fusion you put in the table prefix so the main site is fusion_ and the bf2 site bf2_ therefore the tables with the user login and password etc are "fusion_user" and "bf2_user" i have managed to insert the info into the bf2 one from the main site but i want it to be automatic. is there a way i can do this? my background with mysql is that i opened phpmyadmin today and had a play around with it, i managed to backup my site db then clear it and reinsert it all again. (newbie i know) mysql version is 4.1.22 and i wouldnt know how to update it? i have control of my site thru cpanel. please could somebody try to talk me through doing this?

Many thanks for taking the time to read this and i hope you can help.
smiler is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 01-18-2008, 04:48 PM Re: Duplicate Users In mysql for php fusion
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Would you like to reformat the post into something readable please
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-18-2008, 04:50 PM Re: Duplicate Users In mysql for php fusion
Junior Talker

Posts: 4
Name: Jamie Davis
Trades: 0
sorry read a few other posts and saw it said give as much background info as possible.............
smiler is offline
Reply With Quote
View Public Profile
 
Old 01-18-2008, 05:23 PM Re: Duplicate Users In mysql for php fusion
Junior Talker

Posts: 4
Name: Jamie Davis
Trades: 0
how do i make a fusion_user and bf2_user table contain exactly the same info automatically? they are on the same database. i am very new to mysql
smiler is offline
Reply With Quote
View Public Profile
 
Old 01-20-2008, 10:10 AM Re: Duplicate Users In mysql for php fusion
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Not a database issue.

find all references to the user table in one set of scripts and hardcode it to refer to the other one.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-21-2008, 03:07 AM Re: Duplicate Users In mysql for php fusion
Junior Talker

Posts: 4
Name: Jamie Davis
Trades: 0
yes, i figured that out and have been doing it for 2 days.
all works now!!
thanks for taking the time to read my post though.

smiler is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Duplicate Users In mysql for php fusion
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.23397 seconds with 12 queries