summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-04-26 09:25:45 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-04-26 09:25:45 +0000
commit88853c1168a333c7c7b7951b2931852e6df7da55 (patch)
treefbad6f17f0820c89ce5dd8da748cf37b56549d14 /util
parentd2efb163c11a11e02abd7251fdfde3cb54c710ef (diff)
Stupid comments - like I can keep track of everything I change...
git-svn-id: svn://vndb.org/vndb@5 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r--util/OLD/cleanimg.pl (renamed from util/cleanimg.pl)0
-rwxr-xr-xutil/OLD/cron_daily.sh (renamed from util/cron_daily.sh)0
-rw-r--r--util/OLD/cron_daily.sql (renamed from util/cron_daily.sql)0
-rw-r--r--util/OLD/relgraph.pl (renamed from util/relgraph.pl)0
-rw-r--r--util/OLD/sitemap.pl (renamed from util/sitemap.pl)0
-rw-r--r--[-rwxr-xr-x]util/multi.pl7
-rw-r--r--util/updates/update_1.14.pl2
-rw-r--r--util/updates/update_1.14.sql8
8 files changed, 13 insertions, 4 deletions
diff --git a/util/cleanimg.pl b/util/OLD/cleanimg.pl
index 45032106..45032106 100644
--- a/util/cleanimg.pl
+++ b/util/OLD/cleanimg.pl
diff --git a/util/cron_daily.sh b/util/OLD/cron_daily.sh
index 743a9839..743a9839 100755
--- a/util/cron_daily.sh
+++ b/util/OLD/cron_daily.sh
diff --git a/util/cron_daily.sql b/util/OLD/cron_daily.sql
index c30f30f1..c30f30f1 100644
--- a/util/cron_daily.sql
+++ b/util/OLD/cron_daily.sql
diff --git a/util/relgraph.pl b/util/OLD/relgraph.pl
index a4ae486d..a4ae486d 100644
--- a/util/relgraph.pl
+++ b/util/OLD/relgraph.pl
diff --git a/util/sitemap.pl b/util/OLD/sitemap.pl
index 6fde2f80..6fde2f80 100644
--- a/util/sitemap.pl
+++ b/util/OLD/sitemap.pl
diff --git a/util/multi.pl b/util/multi.pl
index b4b4cad2..4c22bced 100755..100644
--- a/util/multi.pl
+++ b/util/multi.pl
@@ -26,9 +26,6 @@
# -a Don't do anything, just add the commands specified on
# the command line to the shared memory processing queue.
-
-# TODO: error handling
-
#
# Multi - core namespace for initialisation and global variables
#
@@ -46,7 +43,9 @@ use DBI;
use lib '/www/vndb/lib';
use Multi::Core;
use Multi::RG;
+use Multi::Image;
use Multi::Sitemap;
+use Multi::Maintenance;
use Multi::IRC;
BEGIN { require 'global.pl' }
@@ -79,7 +78,9 @@ our $SQL = DBI->connect(@VNDB::DBLOGIN,
Multi::Core->spawn();
Multi::RG->spawn();
+Multi::Image->spawn();
Multi::Sitemap->spawn();
+Multi::Maintenance->spawn();
Multi::IRC->spawn(
server => 'irc.synirc.net',
user => 'Multi_'.$$,
diff --git a/util/updates/update_1.14.pl b/util/updates/update_1.14.pl
index 9c4e787d..af9840c5 100644
--- a/util/updates/update_1.14.pl
+++ b/util/updates/update_1.14.pl
@@ -34,7 +34,7 @@ for (0..49) {
# rename relation graphs
-system('util/relgraph.pl');
+system('util/multi.pl -c "relgraph all"');
# rename cover images
diff --git a/util/updates/update_1.14.sql b/util/updates/update_1.14.sql
index 70ae8ef0..77f9ee71 100644
--- a/util/updates/update_1.14.sql
+++ b/util/updates/update_1.14.sql
@@ -17,6 +17,14 @@ DROP FUNCTION get_new_id(text);
+-- remove users.p* columns (Why haven't I done so earlier?)
+ALTER TABLE users DROP COLUMN pvotes;
+ALTER TABLE users DROP COLUMN pfind;
+ALTER TABLE users DROP COLUMN plist;
+ALTER TABLE users DROP COLUMN pign_nsfw;
+
+
+
-- relation graphs get ID numbers
CREATE SEQUENCE relgraph_seq;
ALTER TABLE vn ALTER COLUMN rgraph DROP NOT NULL;