swish Posted May 25, 2007 Share Posted May 25, 2007 Is it possible to use the Install/Uninstall Scripts feature to run a php/mysql script? I need to insert the IP and port into a database for our stats and it would be much easyer to do this automatically... Any suggestions on how to use the Install/Uninstall Scripts feature to do this? Link to comment Share on other sites More sharing options...
kalyse Posted May 25, 2007 Share Posted May 25, 2007 Set up a cron, that reads the latest IP and Port that have been enterested and compare it against the ProcessID to make sure its not already been entered. Link to comment Share on other sites More sharing options...
kalyse Posted May 25, 2007 Share Posted May 25, 2007 A cron that calls a PHP script I mean* Link to comment Share on other sites More sharing options...
LFA Posted May 25, 2007 Share Posted May 25, 2007 The install/uninstall script is batch format. If you can do it in a batch file you can do it from the script. http://us.php.net/features.commandline http://dev.mysql.com/doc/refman/5.0/en/mysql.html c:\php\php.exe c:\path\to\file.php c:\mysql\bin\mysql.exe -uUSER -pPASSWORD --database=DATABASENAME < c:\path\to\file.sql Link to comment Share on other sites More sharing options...
swish Posted May 25, 2007 Author Share Posted May 25, 2007 Hmm....is a batch file able to contact an off server MySQL Database? Meaning the database is not local its hosted elsewhere. Link to comment Share on other sites More sharing options...
kalyse Posted May 25, 2007 Share Posted May 25, 2007 Yeah, you have to use the -h option. If you havent used mysql through command line before you can find some really good 2 minute tutorials that explain everything that you need to know. -h for host. Link to comment Share on other sites More sharing options...
swish Posted May 25, 2007 Author Share Posted May 25, 2007 I think the easyer route im gunna try now is just a simple cron query to the TCAdmin Database and pull the IP/Port from there. Sounds a bit easyer lol. Link to comment Share on other sites More sharing options...
kalyse Posted May 26, 2007 Share Posted May 26, 2007 Believe me its not. Its definately to worst way, I only recoemmended it because I didnt know about the .bat Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.