if ($number =~ /^\+([1-9]\d+)$/){
$number = $1;
}else{
- my ($sms) = $dbh->selectrow_array(q{SELECT sms FROM users WHERE username ilike $1}
- ,undef,$number);
+ my ($sms) = $dbh->selectrow_array(q{
+SELECT sms FROM users WHERE username ilike $1
+ AND uid IN (SELECT uid FROM groupmembers WHERE gid = 'M')
+ },undef,$number);
$sms //= 'No number, or invalid user';
if ($sms =~ /^\+([1-9]\d+)$/){
$number = $1;
}
my $sms = $dbh->prepare(q{
INSERT INTO sms (uid,number,message)
-VALUES((SELECT uid FROM users WHERE hostmask ilike $1),$2,$3)
+VALUES($1,$2,$3)
RETURNING id
});
- $sms->execute($c->host,$number,$message);
+ $sms->execute($c->uid,$number,$message);
my ($id) = $sms->fetchrow_array;
$c->reply("Message added to queue, you can see the status with: .smsstatus $id");
}