X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Context.pm;h=abe59b24cf538b477f794153241a11649a1865b7;hp=124da62e5ca301a33da1a18534b24ac6737c51c6;hb=ae37bc6b64270f8c65298a36fce1f4bad761231f;hpb=0d6e6e233601ba9b1dd9fe874e804424a10fa09c diff --git a/Context.pm b/Context.pm index 124da62..abe59b2 100644 --- 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);