FilesExpand file tree

 develop

/

change_smiley_ref.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

52 lines (43 loc) · 1.61 KB

 develop

/

change_smiley_ref.php

Copy path

Top

File metadata and controls

• Code
• Blame

52 lines (43 loc) · 1.61 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

<?php

/**

*

* This file is part of the phpBB Forum Software package.

*

* @copyright (c) phpBB Limited <https://www.phpbb.com>

* @license GNU General Public License, version 2 (GPL-2.0)

*

* For full copyright and license information, please see

* the docs/CREDITS.txt file.

*

*/

//

// 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(2400);

// This script adds missing permissions

$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);

$sql = "SELECT post_id, post_text FROM {$table_prefix}posts WHERE post_text LIKE '%{SMILE_PATH}%'";

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

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

{

$db->sql_query("UPDATE {$table_prefix}posts SET post_text = '" . $db->sql_escape(str_replace('{SMILE_PATH}', '{SMILIES_PATH}', $row['post_text'])) . "' WHERE post_id = " . $row['post_id']);

}

$db->sql_freeresult($result);

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