PDA

View Full Version : Intergration



RNelson
22-10-2006, 08:23 PM
We have ourhabbos user system and wondering how can we make it so when they register on user system they auto register on vb forum and other way round :) + Rep

Recursion
22-10-2006, 09:07 PM
i wanted to do this with IPB, it would be quite a big job...

Jackboy
22-10-2006, 09:07 PM
Ok.

Just add this in the process register or w/e page.



include ("URLTOVBULLETINCONFIGFILE.php");
$sql = ("INSERT INTO `user` (username, password,) VALUES ('$_POST[username]','$_POST[password]');



Or w/e :)
Thanks

Colin-Roberts
22-10-2006, 09:08 PM
just change thhe mysql so it uses vbs user table and it should be good to go

Jackboy
22-10-2006, 09:08 PM
Hehe mr Joe. Just showed him. Say if i mucked up somewhere though ;)

primal
22-10-2006, 10:59 PM
Hello, yes this method would work.

Depending on which Forum you which to use it with. Simply go to phpmyadmin and see what the user table is cales.

Then see what the username and password fields are called.

Then simply, make your login_form, query the forum database when it checks for the user.

Sorry if this is a repeat of the above.

Jackboy
23-10-2006, 07:34 AM
cheers for backing me up primal :)

Kieran
23-10-2006, 02:22 PM
We have a problem. The forum and site are on different accounts. Is there ANY way for them to be able to connect to the others MYSQL?

adm
23-10-2006, 02:38 PM
Change the host in the usersystem's sql?

Jackboy
23-10-2006, 02:42 PM
More deatiled answer:

go to cpanel -> mysql databases and put in allowed hosts or w.e

The hosts name or ip

Then u can change the hostname like TurtlePie or w/e said ;)

Kieran
23-10-2006, 02:49 PM
Ah, ok :D

What would the hosts name be? At present:

www.europehabbo.com is where usersystem is. This needs acces to
wwww.europehabboforum.com

:Blob
23-10-2006, 02:50 PM
Just have the forum on same host.. easy

Kieran
23-10-2006, 02:55 PM
Its on the same host, just different username. So what host would i need to allow?

primal
23-10-2006, 03:58 PM
The easiest method would be to open up the page which quesries the database:

db.php or database.php or config.php or whatever

if the other account is on the same server, then it is simply LOCALHOST

then just change the username and db name so they are correct.:

$hostname = 'localhost'
$dbname= 'username_dbname'
$username= 'username_dbuser'
$password ='pass'

The username is usually the username you use to connect to the cpanel on the account that the database is on.

Hope this helps. no need to change any setting etc.. its perfectly fine to query a database from anywhere on the internet as long as you know the hostname and database name and pass.

==== If Database not on same server ===

You will ahve to find the hostname, ask your Host, usually server.hostname.com

======

Primal

Want to hide these adverts? Register an account for free!