phpBB.de

Code: Alles auswählen

function phpbb_email_hash($email)
{
          return crc32(strtolower($email)) . strlen($email);
}

Code: Alles auswählen

<?php
$dbhost = 'localhost'; // unser Datenbankserver ist beispielsweise lokal
$dbuser = 'datenbank nutzer';
$dbpwd = 'datenbank passwort';
$dbtab = 'datenbank name';

$mydatabase = mysql_connect($dbhost, $dbuser, $dbpwd);
mysql_select_db($dbtab, $mydatabase);

$sql = "SELECT `user_email`,`user_id`,`user_email_hash` FROM `phpbb_users` WHERE 1";
$data = mysql_query($sql);

for ($i=0; $i < mysql_num_rows($data); $i++)
{
    $line = mysql_fetch_assoc($data);
    $hash = crc32(strtolower($line['user_email'])) . strlen($line['user_email']);
    if  ($line['user_email_hash'] != 0)
    {
        $sql =  "UPDATE `phpbb_users`
            SET `user_email_hash` = '".$hash."'
            WHERE `user_id` = '".$line['user_id']."'";
        mysql_query($sql);
        $erg = mysql_errno();
        if ($erg == 0)
        {
            echo "OK - hash changed from: ".$line['user_email_hash']." to ".$hash." for UserID: ".$line['user_id']."\n";
        } else {
        echo mysql_errno() . ": " . mysql_error() . "\n";
        echo "ERROR on ID: ".$line['user_id']."\n";
        }
    }
}

mysql_free_result($data);
mysql_close($mydatabase);

?>