Scratch
archived forums
#1 2011-04-23 22:23:04
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
mysql help
I need help. I want my sql database to update when a new user signs up on my forums. I need it to sync with my other forum on my website. Any help?
Offline
#2 2011-04-23 22:50:25
#4 2011-04-23 22:56:25
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
Re: mysql help
ssss wrote:
Bump for thebuilderdd
I posted something for you oj my forums. Yes it is for scratch.
Offline
#5 2011-04-24 08:34:30
#6 2011-04-24 10:25:47
- TheSuccessor
- Scratcher
- Registered: 2010-04-23
- Posts: 1000+
Re: mysql help
You seem to be using FluxBB, so...
Make sure both forums are on the same database, but when you set one of them up give it your choice of prefix (in the setup form). The delete the table named "(your_prefix)users" from the database, then go through all of the PHP files for the second forum, and where you find "'.$db->prefix.'users", replace it with "users".
Et voilà!
/* No comment */
Offline
#7 2011-04-24 16:08:03
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
Re: mysql help
TheSuccessor wrote:
You seem to be using FluxBB, so...
Make sure both forums are on the same database, but when you set one of them up give it your choice of prefix (in the setup form). The delete the table named "(your_prefix)users" from the database, then go through all of the PHP files for the second forum, and where you find "'.$db->prefix.'users", replace it with "users".
Et voilà!
For database, can they be on the same mysql host? I use mysql9.000webhost.com
I think i messed up though.
Offline
#8 2011-04-24 19:23:53
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
Re: mysql help
Mega bump. I think i messed up.
Offline
#9 2011-04-24 20:52:02
#10 2011-04-25 16:50:33
#11 2011-04-25 17:01:30
- thebuilderdd
- Scratcher
- Registered: 2008-01-26
- Posts: 1000+
Re: mysql help
TheSuccessor wrote:
You seem to be using FluxBB, so...
Make sure both forums are on the same database, but when you set one of them up give it your choice of prefix (in the setup form). The delete the table named "(your_prefix)users" from the database, then go through all of the PHP files for the second forum, and where you find "'.$db->prefix.'users", replace it with "users".
Et voilà!
Wait... I noticed alot in one file. Should I change them all?
Offline