PDA

View Full Version : sql module for perl?


Doomhead
09-18-2003, 08:34 AM
Anyone know if there is a module for PERL that can access an sql database?

When the devs come out with a stable 5.0, I want to make some web cgi apps that can access and alter the database. I also want to use the web apps to allow users to sign up before they can play on my server (use default status of -2 then webapp will set to 0 once registered. I could use the shell to do this while the server is up using the commands to world.exe but would rather go directly to the db.)

09-18-2003, 08:45 AM
I Googled for mysql and Perl and got this link ... not sure if this is the sort of thing you are looking for

http://www.mysql.com/portal/software/item-77.html

http://search.cpan.org/author/RUDY/DBD-mysql-2.9002/lib/DBD/mysql.pm

Rogean
09-18-2003, 10:05 AM
Doomhead:

Your avatar is asking for an Admin Login to Guildmaster.Wox.Org. I Recomend you check it out :)

krich
09-20-2003, 04:28 PM
PHP is good for that too.

Just a thought,

krich

Doomhead
09-22-2003, 09:02 AM
Lost my power and someone else got my IP. It's updated now so it will work now.

BTW thanks for the info, i'll look into it.

Eglin
11-26-2003, 10:47 PM
Anyone know if there is a module for PERL that can access an sql database?

Yeah. DBI/DBD work wonderfully. I usually use DBI via ODBC, since almost all dists. include the ODBC bridge. You can, however, download the DBD for your db (e.g. DBD::mysql) to go directly through your dbms. I posted some code that does just that in another thread (http://www.everquestserver.com/forums/viewtopic.php?t=11185&start=15#59285). Feel free to rip it off.