my $password = generate_random_string 10;
my $update = $dbh->do(q{
UPDATE users SET password = MD5( ? )
-WHERE uid ? AND password =''
+WHERE uid = ? AND password =''
},undef,$password,$c->uid);
if ($update > 0){
$c->reply("Password set to: $password (you can change it on webbie)");