diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-08-30 01:15:40 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-08-30 01:15:40 +0000 |
| commit | 3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6 (patch) | |
| tree | fe35a4c0d26f3d1a9566e3b79915914d20ba4df7 /phpBB/includes/acp/acp_reasons.php | |
| parent | bb3034eb263cf001be0ce002e4442b29dd2ed33f (diff) | |
| download | forums-3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6.tar forums-3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6.tar.gz forums-3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6.tar.bz2 forums-3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6.tar.xz forums-3f6318f2b10a1e5f8ede1d7a17a58409c1ddc1e6.zip | |
- Bug #4028
git-svn-id: file:///svn/phpbb/trunk@6333 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/acp/acp_reasons.php')
| -rw-r--r-- | phpBB/includes/acp/acp_reasons.php | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/phpBB/includes/acp/acp_reasons.php b/phpBB/includes/acp/acp_reasons.php index 2234871bce..f94240b925 100644 --- a/phpBB/includes/acp/acp_reasons.php +++ b/phpBB/includes/acp/acp_reasons.php @@ -214,9 +214,17 @@ class acp_reasons case 'mssql': case 'mssql_odbc': // Change the reports using this reason to 'other' - $sql = 'UPDATE ' . REPORTS_TABLE . ' - SET reason_id = ' . $other_reason_id . ", report_text = '" . $db->sql_escape($reason_row['reason_description']) . "\n\n' + report_text - WHERE reason_id = $reason_id"; + $sql = "DECLARE @ptrval binary(16) + + SELECT @ptrval = TEXTPTR(report_text) + FROM " . REPORTS_TABLE . " + WHERE reason_id = " . $reason_id . " + + UPDATETEXT " . REPORTS_TABLE . ".report_text @ptrval 0 0 '" . $db->sql_escape($reason_row['reason_description']) . "\n\n'" + + 'UPDATE ' . REPORTS_TABLE . ' + SET reason_id = ' . $other_reason_id . " + WHERE reason_id = $reason_id"; break; // Teh standard |