FilesExpand file tree

 develop

/

calc_email_hash.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

70 lines (60 loc) · 1.68 KB

 develop

/

calc_email_hash.php

Copy path

Top

File metadata and controls

• Code
• Blame

70 lines (60 loc) · 1.68 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

<?php

/**

*

* @package phpBB3

* @copyright (c) 2004 phpBB Group

* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

*

*/

//

// Security message:

//

// This script is potentially dangerous.

// Remove or comment the next line (die(".... ) to enable this script.

// Do NOT FORGET to either remove this script or disable it after you have used it.

//

die("Please read the first lines of this script for instructions on how to enable it");

@set_time_limit(300);

$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = '';

define('IN_PHPBB', 1);

define('ANONYMOUS', 1);

$phpEx = substr(strrchr(__FILE__, '.'), 1);

$phpbb_root_path='./../';

include($phpbb_root_path . 'config.'.$phpEx);

require($phpbb_root_path . 'includes/acm/acm_' . $acm_type . '.'.$phpEx);

require($phpbb_root_path . 'includes/db/' . $dbms . '.'.$phpEx);

include($phpbb_root_path . 'includes/functions.'.$phpEx);

$cache = new acm();

$db = new sql_db();

// Connect to DB

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);

$start = 0;

do

{

// Batch query for group members, call group_user_del

$sql = "SELECT user_id, user_email

FROM {$table_prefix}users

LIMIT $start, 100";

$result = $db->sql_query($sql);

if ($row = $db->sql_fetchrow($result))

{

do

{

$sql = "UPDATE {$table_prefix}users

SET user_email_hash = " . (crc32(strtolower($row['user_email'])) . strlen($row['user_email'])) . '

WHERE user_id = ' . $row['user_id'];

$db->sql_query($sql);

$start++;

}

while ($row = $db->sql_fetchrow($result));

echo "<br />Batch -> $start\n";

flush();

}

else

{

$start = 0;

}

$db->sql_freeresult($result);

}

while ($start);

echo "<p><b>Done</b></p>\n";