Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Has anyone access a MySQL VBulletin database?

by NeilF (Sexton)
on Jan 31, 2006 at 16:29 UTC ( #526786=perlquestion: print w/replies, xml ) Need Help??

NeilF has asked for the wisdom of the Perl Monks concerning the following question:

I'm completely new to both MySQL (& VBulletin), but I'm wondering if given the username/id and password (held in cookies) if a perl script could then access the database and check it's valid?

ie: I only want particular people registered (infact subscribed) members to be able to run certain perl scripts...

I'm hoping someone has a working example to show me the basic workings?

Thanks...
  • Comment on Has anyone access a MySQL VBulletin database?

Replies are listed 'Best First'.
Re: Has anyone access a MySQL VBulletin database?
by marto (Cardinal) on Jan 31, 2006 at 16:37 UTC
    Hi NeilF,

    The VBulletin configuration scripts should have the database connection details (host,username and password) that it is using to connect to the MySQL database. You could then usen DBI (you will also require DBD::MYSQL if you do not already have it) to connect to the database via Perl. Check out Reading from a database from the Tutorials section of this site to give you an introduction to DBI.

    Once you have a working database connection set up you will be able to run a query using the user login details to validate their accounts.

    Hope this helps.

    Martin

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://526786]
Approved by marto
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2022-05-23 00:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (81 votes). Check out past polls.

    Notices?