Posted By

hecatomber on 10/28/06

Tagged

Versions (?)

Last Edited at 10/28/06 10:55am

Statistics

Viewed 148 times

Favorited by 1 user(s)

Related snippets

PHPBB ForumlarÄ±nda KullanÄ±cÄ±larÄ±n Åžifresini Toplu Halde Resetlemek

/ Published in: PHP

VeritabanÄ± adÄ±, admin ÅŸifresi ve tablo isimlerinde farklÄ±lÄ±k var ise manuel olarak deÄŸiÅŸtirmeniz yararÄ±nÄ±za olacaktÄ±r.

Eski ÅŸifreler MD5 ÅŸifrelenme yÃ¶ntemi ile "yedek" adÄ±nda bir tablo oluÅŸturulup iÃ§ine yerleÅŸtirilmektedir. AyrÄ±ca "User ID - KullanÄ±cÄ± adÄ± - Eski Åžifre(MD5) - Yeni Åžifre (MD5) - Yeni Åžifre (AÃ§Ä±k)" ÅŸeklinde Ã¶nlem amaÃ§lÄ± tablo yerleÅŸtirilmektedir.

"phpBB 2.0.21" Ã¼zerinde 5 kullanÄ±cÄ±lÄ± bir forum deneme amaÃ§lÄ± aÃ§Ä±larak test edilmiÅŸtir. SapasaÄŸlam Ã§alÄ±ÅŸmaktadÄ±r.

Highlighted TextExpand

<?
function md5pass($totalChar,&$password,&$clean)
{
// *******************************
// Random Password Generator-Start
// *******************************
//$totalChar = 8; // number of chars in the password
$salt = "abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ123456789"; // salt to select chars from
srand((double)microtime()*1000000); // start the random generator
$password=""; // set the inital variable
for ($i=0;$i<$totalChar;$i++) // loop and create password
 $password = $password . substr ($salt, rand() % strlen($salt), 1);
$clean = $password;
$password = md5($password);
// *****************************
// Random Password Generator-End
// *****************************
}
mysql_connect("localhost","user","password") or die("mysql e baÄŸlanamadÄ±k");
mysql_select_db("phpbb") or die("veritabanÄ±nÄ± seÃ§ilemedi");
mysql_query('CREATE TABLE IF NOT EXISTS `yedek` ( `user_id` MEDIUMINT( 8 ) NOT NULL , `user_password` VARCHAR( 32 ) NOT NULL , `user_newpassword` VARCHAR( 32 ) NOT NULL , UNIQUE ( `user_id` ) ) CHARACTER SET = utf8;'); //yedek tablosu - user id - eski sifre - yeni sifreyi icerecek
$sql = mysql_query('SELECT `user_id` , `user_password` , `username` FROM `phpbb_users`');
$id = mysql_num_rows($sql);
	echo "<table border=1><tr><td>User ID</td><td>KullanÄ±cÄ± AdÄ±</td><td>Eski Sifre(MD5)</td><td>Yeni Sifre(MD5)</td><td>Acik Sifre</td></tr>";
while($id > 0)
{
	$ulist = mysql_fetch_array($sql,MYSQL_NUM);
	$userid = $ulist[0];
	$oldpass = $ulist[1];
	$username = $ulist[2];
	md5pass("8",$password,$clean);
	if ($userid == -1)
	{
		$password = ""; //Anonim Hesap
		$clean = $password;
	}
	if ($userid == 2)
	{
		$password = "adminpass"; //Admin sifresi(her ihtimale karsi)
		$clean = $password;
		$password = md5("$password");
	}
	mysql_query("REPLACE INTO `yedek` ( `user_id` , `user_password`, `user_newpassword` ) VALUES ('".$ulist[0]."', '".$ulist[1]."', '".$password."')"); //eski sifreler her ihtimale karsi yedek
	mysql_query("UPDATE `phpbb_users` SET `user_password` = '".$password."' WHERE `user_id` = '".$ulist[0]."'");
	echo "<tr><td align='center'>".$userid."</td><td align='center'>".$username."</td><td>".$oldpass."</td><td>".$password."</td><td>".$clean."</td></tr>";
	$id--;
}
echo "</table>";
?>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.