Update to new database structure

[NDIRC.git] / Context.pm

diff --git a/Context.pm b/Context.pm
index 124da62e5ca301a33da1a18534b24ac6737c51c6..abe59b24cf538b477f794153241a11649a1865b7 100644 (file)
--- a/Context.pm
+++ b/Context.pm
@@ -113,7 +113,7 @@ sub intel_log {
        my ($c,$planet, $message) = @_;
        my $log = $c->model->prepare_cached(q{
 INSERT INTO forum_posts (ftid,uid,message) VALUES(
-       (SELECT ftid FROM planets WHERE id = $3)
+       (SELECT ftid FROM planets WHERE pid = $3)
        ,(SELECT uid FROM users WHERE hostmask ILIKE $1)
        ,$2)
                });
@@ -124,7 +124,7 @@ sub def_log {
        my ($c,$call, $message) = @_;
        my $log = $c->model->prepare(q{
 INSERT INTO forum_posts (ftid,uid,message) VALUES(
-       (SELECT ftid FROM calls WHERE id = $3)
+       (SELECT ftid FROM calls WHERE call = $3)
        ,(SELECT uid FROM users WHERE hostmask ILIKE $1),$2)
                });
        $log->execute($c->host,$message,$call);