What is the forum exactly for?

Goody · 05-01-2010, 03:57 PM

With the SQL comment up top I thought it was about website databases. But most of the comments are about the in game database. My question about online league site stuff isn't getting much of a response here. Did I put it in the right place?

kq76 · 05-02-2010, 12:36 PM

I think the problem is people see the word "database" and think that since what they're talking about has something to do with databases then their post must belong here. The problem is there are website databases, player databases, world databases, etc. I hope to get Andreas to re-structure the sub-boards here and from there it will hopefully be a bit more clear that this board is for db tools or utilities and not databases themselves.

Another problem is the answer to your question requires someone with a lot of technical expertise and the likelihood that those few people will read your thread is very low. I suggest going straight to the developers of the utilities whose databases you want to talk to each other. You'll probably still get very little help since it's most likely asking quite a lot, but that's probably your best bet.

Goody · 05-02-2010, 02:22 PM

I read awhile back somebody had did what I'm asking to their league site. I just can't remember who it was.

kq76 · 05-02-2010, 02:28 PM

Ahh. Well, you could ask on the managers' board for help in finding that league.

joe_44850 · 05-14-2010, 10:31 PM

What was your original question?

Goody · 08-06-2010, 08:27 PM

It was about how to go about making one single login for multiple database run website applications. Like drupal/joomla, message board, and StatsLab.

f.montoya · 12-16-2010, 09:43 AM

It's complicated but if you have some php background you can do it. You'll have to locate the session code, usually at the top, in all the php pages in that program require it. You'll need to change them so they are all alerted to the same session. Depending on the software, you'll need to merge them onto one database and then edit php code in the configuration.php files so that they connect to the same mysql database. Then seek the file that specifies the table names to look for in each program and where it looks for "members" or "users" table, edit them all to look for the same table in the database.

Did I forget to mention you should back up your databases and files?

05-01-2010, 03:57 PM	#1
Goody Hall Of Famer Join Date: Mar 2002 Location: South Korea Posts: 3,530	What is the forum exactly for? With the SQL comment up top I thought it was about website databases. But most of the comments are about the in game database. My question about online league site stuff isn't getting much of a response here. Did I put it in the right place? __________________ In the past: Laseron Baseball Association creator. Present: I am Rezulm on PT and OOTP Discord. Future: I wish it was the past.

05-02-2010, 12:36 PM	#2
kq76 Global Moderator Join Date: Nov 2002 Posts: 11,755	I think the problem is people see the word "database" and think that since what they're talking about has something to do with databases then their post must belong here. The problem is there are website databases, player databases, world databases, etc. I hope to get Andreas to re-structure the sub-boards here and from there it will hopefully be a bit more clear that this board is for db tools or utilities and not databases themselves. Another problem is the answer to your question requires someone with a lot of technical expertise and the likelihood that those few people will read your thread is very low. I suggest going straight to the developers of the utilities whose databases you want to talk to each other. You'll probably still get very little help since it's most likely asking quite a lot, but that's probably your best bet. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project)

05-02-2010, 02:22 PM	#3
Goody Hall Of Famer Join Date: Mar 2002 Location: South Korea Posts: 3,530	I read awhile back somebody had did what I'm asking to their league site. I just can't remember who it was. __________________ In the past: Laseron Baseball Association creator. Present: I am Rezulm on PT and OOTP Discord. Future: I wish it was the past.

05-02-2010, 02:28 PM	#4
kq76 Global Moderator Join Date: Nov 2002 Posts: 11,755	Ahh. Well, you could ask on the managers' board for help in finding that league. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project)

05-14-2010, 10:31 PM	#5
joe_44850 Minors (Single A) Join Date: Oct 2002 Posts: 66	What was your original question? __________________ Southerners are very strange about that war -- Shelby Foote

08-06-2010, 08:27 PM	#6
Goody Hall Of Famer Join Date: Mar 2002 Location: South Korea Posts: 3,530	It was about how to go about making one single login for multiple database run website applications. Like drupal/joomla, message board, and StatsLab.

12-16-2010, 09:43 AM	#7
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 6,069	It's complicated but if you have some php background you can do it. You'll have to locate the session code, usually at the top, in all the php pages in that program require it. You'll need to change them so they are all alerted to the same session. Depending on the software, you'll need to merge them onto one database and then edit php code in the configuration.php files so that they connect to the same mysql database. Then seek the file that specifies the table names to look for in each program and where it looks for "members" or "users" table, edit them all to look for the same table in the database. Did I forget to mention you should back up your databases and files? __________________ Fidel Montoya Asahi2 Baseball ex-Commissioner(Historical League Since 2004) www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!) Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)