Question - Accessing an external or remote database

[dcpaq2xx]

Group,

Vbulletin.org communicates with Vbulletin.com to verifiy if a member holds a valid Vbulletin license or not and then decides what access to give them. We are wanting to know how they do this so that we can do the same with our site, but 'they' (Jelsoft/VB Staff) avoid the question and say it cannot be done, and they are able to do this now only because both sites reside on the same server, and the thing is that I can put both ours on the same server too, but they still avoid the question by never replying back when I asked again how...

With our site we are looking for a way to have our board communicate with an external database located on another server using a 'soap' API or some other way of communicating and providing data to our board. (We have the option too to place the database on the same server as the board) We would like to create a database that contains all the current valid licenses issued for a program of ours and add new entries as licenses get sold, then the board would read from this and determine who has access to which things.

Does anyone know how we could go about doing this?

Thanks for reading this.

Doug

[snakes1100]

I doubt you will get a reply telling you how to do this, this is most likely going to be a paid job for a coder to do, i would suggest posting in the "paid request forum".

[Marco van Herwaarden]

With PHP you can connect to any database you want, providing the MySQL permits connections from teh host where the script is ran. How to connect in a custom script to a custom database, is something your programmer should know.

[dcpaq2xx]

Who said anything about having a programmer?

Doug

[Eikinskjaldi]

Originally Posted by dcpaq2

Who said anything about having a programmer?

Doug

Funny.

If the dbs reside on the same server then mysql simply doesnt care, you can write the query directly

select db1.table1.field1, db2.table2.field2 from db1.table1
join db2.table2 on (db1.table1.field2 = db2.table2.field3)

if on a separate server you just need to set permissions on the remote server so that it can be accessed remotely, and set up a mysql connection that connect to remote.ip.address rather than localhost.

[Marco van Herwaarden]

Well i expect that you have a programmer (or you do this yourself) who is writing that script for you.

Scripts do not fall out of the air, they must be coded by someone.

[dcpaq2xx]

I dont have a programmer as of yet. But the guy who coded the program that issues out liceneses to, would probably be the one who would set this up, but he is not familiar with Vbulletin and asked me to ask for help on how to go about doing this. That is why I am asking you guys for your help and input on this. And yes I am aware that scripts do not fall out of the sky.

Doug