On Tue, Jun 10, 2008 at 1:08 PM, Simo Leone <simo@archlinux.org> wrote:
On Sun, Jun 08, 2008 at 09:24:36PM +0800, Callan Barrett wrote:
Gonna have to resubmit packages before results are correct.
An SQL query or simple php script can also do this. You might want to write one and send it to the list so we can just run it when it's deployed.
-S
This should work: <?php // Run the script from within lib include('config.inc'); include('aur.inc'); $dbh = db_connect(); $query = "UPDATE Packages SET " . "FSPath = CONCAT('" . INCOMING_DIR . "', Name, '/', Name, '.tar.gz'), " . "URLPath = CONCAT('" . URL_DIR . "', Name, '/', Name, '.tar.gz') " . "WHERE DummyPKG = 0 AND LocationID = 2;"; db_query($query, $dbh); ?> -- Callan Barrett