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");