Update to new database structure

[NDIRC.git] / Context.pm

diff --git a/Context.pm b/Context.pm
index 6831bdef9c0ddae934e21413d4467a4284088aa3..abe59b24cf538b477f794153241a11649a1865b7 100644 (file)
--- a/Context.pm
+++ b/Context.pm
@@ -113,13 +113,23 @@ 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)
                });
        $log->execute($c->host,$message,$planet);
 }
 
+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 call = $3)
+       ,(SELECT uid FROM users WHERE hostmask ILIKE $1),$2)
+               });
+       $log->execute($c->host,$message,$call);
+}
+
 sub _build_roles {
        my ($self) = @_;