WoltLab Community Forum

PHP Source code

<?php
include "global.php";
$q=mysql_query("select * from wbb1_1_post");
while($r=mysql_fetch_array($q)){
mysql_query("update wbb1_1_post set subject='".mysql_real_escape_string(utf8_decode($r["subject"]))."', message='".mysql_real_escape_string(utf8_decode($r["message"]))."' where postID=".$r["postID"]);
}

$q=mysql_query("select * from wbb1_1_thread");
while($r=mysql_fetch_array($q)){
mysql_query("update wbb1_1_thread set topic='".mysql_real_escape_string(utf8_decode($r["topic"]))."' where threadID=".$r["threadID"]);
}

$q=mysql_query("select * from wcf1_user");
while($r=mysql_fetch_array($q)){
mysql_query("update wcf1_user set signature='".mysql_real_escape_string(utf8_decode($r["signature"]))."' where userID=".$r["userID"]);
}

$q=mysql_query("select * from wbb1_1_board");
while($r=mysql_fetch_array($q)){
mysql_query("update wbb1_1_board set title='".mysql_real_escape_string(utf8_decode($r["title"]))."', description='".mysql_real_escape_string(utf8_decode($r["description"]))."' where boardID=".$r["boardID"]);
}
?>

MySQL queries

UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, 'ß', 'ß') WHERE languageItemValue LIKE '%ß%';
UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, '´', '') WHERE languageItemValue LIKE '%´%';
UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, 'ä', 'ä') WHERE languageItemValue LIKE '%ä%';
UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, 'ö', 'ö') WHERE languageItemValue LIKE '%ö%';
UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, 'ü', 'ü') WHERE languageItemValue LIKE '%ü%';
UPDATE wcf1_language_item SET languageItemValue = REPLACE(languageItemValue, 'Ä', 'Ä') WHERE languageItemValue LIKE '%Ä%';