X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fregmod.php;h=96708eeaa4d521085cbee536a0d87e64477a6e94;hb=b6e546d1e3a81bb3b1fabc54d1ede37e7f1ce8c1;hp=5ed7642005628546069db335f818a55e97fe5971;hpb=fb69fe500b0592c77d4ad8e6fefa12016957e85b;p=friendica.git diff --git a/mod/regmod.php b/mod/regmod.php index 5ed7642005..96708eeaa4 100644 --- a/mod/regmod.php +++ b/mod/regmod.php @@ -17,19 +17,19 @@ function user_allow($hash) { $user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($register[0]['uid']) ); - + if(! count($user)) killme(); - $r = q("DELETE FROM `register` WHERE `hash` = '%s' LIMIT 1", + $r = q("DELETE FROM `register` WHERE `hash` = '%s'", dbesc($register[0]['hash']) ); - $r = q("UPDATE `user` SET `blocked` = 0, `verified` = 1 WHERE `uid` = %d LIMIT 1", + $r = q("UPDATE `user` SET `blocked` = 0, `verified` = 1 WHERE `uid` = %d", intval($register[0]['uid']) ); - + $r = q("SELECT * FROM `profile` WHERE `uid` = %d AND `is-default` = 1", intval($user[0]['uid']) ); @@ -62,7 +62,7 @@ function user_allow($hash) { if($res) { info( t('Account approved.') . EOL ); return true; - } + } } @@ -83,23 +83,23 @@ function user_deny($hash) { $user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($register[0]['uid']) ); - - $r = q("DELETE FROM `user` WHERE `uid` = %d LIMIT 1", + + $r = q("DELETE FROM `user` WHERE `uid` = %d", intval($register[0]['uid']) ); - $r = q("DELETE FROM `contact` WHERE `uid` = %d LIMIT 1", + $r = q("DELETE FROM `contact` WHERE `uid` = %d", intval($register[0]['uid']) - ); - $r = q("DELETE FROM `profile` WHERE `uid` = %d LIMIT 1", + ); + $r = q("DELETE FROM `profile` WHERE `uid` = %d", intval($register[0]['uid']) - ); + ); - $r = q("DELETE FROM `register` WHERE `hash` = '%s' LIMIT 1", + $r = q("DELETE FROM `register` WHERE `hash` = '%s'", dbesc($register[0]['hash']) ); notice( sprintf(t('Registration revoked for %s'), $user[0]['username']) . EOL); return true; - + } function regmod_content(&$a) {