X-Git-Url: https://ruin.nu/git/%3CTMPL_VAR%20NAME=PAGE%3E?a=blobdiff_plain;f=Commands%2FDef.pm;h=1762e7c20129e43fb113b63456cd40110999f41b;hb=2138721402023284bb9976e4b2e636814dbbce96;hp=d7862a364fdbe6d1ddda62cfeda6a0f34e4e6096;hpb=0d63bf9da52cdfe2c9d8850b690032ff539b6398;p=NDIRC.git
diff --git a/Commands/Def.pm b/Commands/Def.pm
index d7862a3..1762e7c 100644
--- a/Commands/Def.pm
+++ b/Commands/Def.pm
@@ -172,10 +172,10 @@ sub calltake
$dbh->begin_work;
my $rows = $dbh->do(q{
-UPDATE calls SET dc = (SELECT uid FROM users WHERE hostmask ILIKE $1)
+UPDATE calls SET dc = $1
,status = $3
WHERE call = $2
- },undef,$c->host,$id,$status);
+ },undef,$c->uid,$id,$status);
if ($rows == 1){
$c->reply("Setting status on call $id to $status");
$c->def_log($id , "Changed status: [B]$status [/B]");
@@ -196,7 +196,7 @@ sub setcalc
my $dbh = $c->model;
$dbh->begin_work;
- my $rows = $dbh->do(q{UPDATE calls SET calc = $2 WHERE id = $1}
+ my $rows = $dbh->do(q{UPDATE calls SET calc = $2 WHERE call = $1}
,undef,$id, $calc);
if ($rows == 1){
$c->reply("Updated calc call $id");
@@ -219,7 +219,7 @@ sub getcalc
my $dbh = $c->model;
my $calc = $dbh->selectrow_array(q{
-SELECT calc FROM calls WHERE id = $1}
+SELECT calc FROM calls WHERE call = $1}
,undef,$id);
$calc //= "Bad call id, there is no such call.";
$c->reply("Calc for call $id: $calc");