$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]");
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 <b>$id</b>");
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 <b>$id</b>: $calc");