Emiliano Heyns <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> There is now a script available at
> http://www.midgard-project.org/~emiliano/sg0migrate
> Rather crude but it will do the job. It's short and simple and if your
> admin site IDs have changed it will happily carry on.
Thank you. There is a typo in the script, here's the patch fixing it and
some added 'cosmetics'.
=============================
6c6,11
< $dbh = DBI->connect($dsn, "midgard", "midgard");
---
> $user = "midgard";
> $password = "midgard";
> $doit = "no"; # script will run without making changes if set to no.
> # change to yes to make the changes happen.
>
> $dbh = DBI->connect($dsn, $user, $password);
41c46,50
< #$sth->do("UPDATE $table SET sitegroup=$sitegroup WHERE id=$id");
---
> if($doit eq "yes") {
> $dbh->do("UPDATE $table SET sitegroup=$sitegroup WHERE id=$id");
> } else
> print "[testrun:] ";
> }
========================
Cheers,
Armand.
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
