[aur-dev] [PATCH] Fix FS#10016

[Callan Barrett]

On Tue, Jun 10, 2008 at 1:08 PM, Simo Leone <simo at 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