$secret]);
}
function wmde_getCommunityId( $email, $private = false )
{
if (!$private){
$sql = "SELECT community.community_id FROM community LEFT JOIN community_mail ON
community_mail.cmailkey = community.community_id WHERE
community_mail.cmail = :cmail OR community.email = :email";
$sqlargs = [':cmail'=>$email,':email'=>$email];
}
else {
$sql = "SELECT community.community_id FROM community
WHERE community.email = :email";
$sqlargs = [':email'=>$email];
}
// echo "Cpommunity Query = $sql - $email\n";
$t = nuRunQuery($sql, $sqlargs);
// var_dump($t);
$a = db_fetch_array($t);
if ($a) {
return $a['community_id'];
}
return null;
}
function showReset()
{
global $nuDB;
$title = "WP:@ Passwort anfordern";
include "email.tpl";
/*
*/
}
function getpw()
{
global $nuDB;
$sql = "SELECT * FROM community WHERE email = :email";
$t = nuRunQuery($sql,[':email' => 'tube@surfpoeten.de']);
var_dump($t);
$a = db_fetch_array($t);
var_dump($a);
}
function wmde_getWikiMails($community_id)
{
$sql = "SELECT cmail FROM community LEFT JOIN community_mail ON
community_mail.cmailkey = community.community_id WHERE
community.community_id = :community_id";
$t = nuRunQuery($sql,[':community_id' => $community_id]);
$mails = array();
while ( $a = db_fetch_array($t) )
{
array_push($mails,$a['cmail']);
}
return $mails;
}
function wmde_setPass($community_id,$password)
{
$pass = password_hash($password,PASSWORD_BCRYPT );
$sql = "UPDATE community SET pass='$pass' WHERE community_id = :id";
// echo "SQL: $sql\n";
$t = nuRunQuery($sql,[':id' => $community_id],true);
// var_dump($t);
return $t;
}
function wmde_getCommunityIdBySecret($secret)
{
$sql = "SELECT community_reset_id FROM community_reset WHERE secret = :secret";
// AND valid_until > NOW() ";
$t = nuRunQuery($sql, ['secret' => $secret]);
// echo "the t $secret\n";
// var_dump($t);
$a = db_fetch_array($t);
// echo "the a\n";
// var_dump($a);
if ($a) {
return $a['community_reset_id'];
}
return null;
}
function wmde_setPassByMail($email,$pass)
{
$id = wmde_getCommunityId($email);
if (!$id)
return false;
return wmde_setPass($id,$pass);
}
function wmde_sendPasswordResetMail($email)
{
$community_id = wmde_getCommunityId($email,false);
// var_dump($community_id);
// var_dump($email);
if (!$community_id)
return false;
$secret = wmde_createPasswordResetSecret($community_id);
if (!$secret ) {
return false;
}
include "mailtext.tpl";
$sender='noc@wikipedia.de';
$sendmail = "/usr/sbin/sendmail";
$text = "To: $email\n";
$text.= "From: Wikimedia Team IT \n";
$text.= "MIME-Version: 1.0\n";
$text.= "Content-Transfer-Encoding: 8bit\n";
$text.= "Content-Type: text/plain; charset=utf-8\n";
$text.= "Subject: $mail_subject\n\n";
$text.= $mail_text;
$cmd = "echo '$text' | $sendmail -f noc@wikipedia.de $email";
exec ($cmd);
return $secret;
}