Açıkçası bu yol bana çok uzun geldi ve oturup 1 günümü bunun için harcadım.
Sabah'ın 9'undan akşamın 19'una kadar
Şimdi
<?php
// Bu script Kaan Topal tarafindan haziranmistir.
// http://www.topal.biz
//MySQL bağlantı ayarları
$db_server = 'localhost';
$db_user="Veritabani kullanıcı adı";
$db_password="Şifre";
mysql_connect($db_server, $db_user, $db_password) or die(mysql_error());
//Buraya ayarlarını değiştirmek istediğiniz veritabanı
//adını girin veya tüm veritabanı üzerinde değişiklik yapmak
//istiyorsanız boş bırakınız.
$dblist=array();
//Eğer değiştirlmesini istemediğiniz bir veritabanı varsa buraya
//girişini yapınız. information_schema veritabanı ana veritaban olduğu
//için karakter setini değiştirmenize gerek yoktur.
$skip_db_list = array('information_schema', 'mysql');
//Hangi karakter tipi kullanilacak?
$charset="utf8";
//Hangi karşılaştırma kullanılacak?
$collation="utf8_general_ci";
//Sadece kullanılan veritabnlarını göster.
//Bu özelliği false olarak kullanınız.
$printonly=false;
//Bu bölge boş bırakılırsa, kullanıcı adı üzerinde
//bulunanan tüm veritabanları üzerinde etkileşim
//uygulanır.
$skip_db_text = '"'.implode('", "', $skip_db_list).'"';
if(count($dblist)<1) {
$sql="SELECT GROUP_CONCAT(`SCHEMA_NAME` SEPARATOR ',') AS FRST FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME` NOT IN ($skip_db_text)";
$result = mysql_query($sql) or die(mysql_error());
$data = mysql_fetch_assoc ($result);
$dblist=explode(",", $data["FRST"]);
}
//Veritabanı güncellemesi
foreach ($dblist as $dbname) {
$sql="SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET $charset COLLATE $collation;') as FRST FROM `information_schema`.`TABLES` t WHERE t.`TABLE_SCHEMA` = '$dbname' ORDER BY 1";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
echo $row["FRST"]."\r\n";
if(!$printonly) {
mysql_query($row["FRST"]) or die(mysql_error());
}
}
}
?>
Bu kodu " convert.php " olarak bir dosyaya kaydedin.
Latin'den UTF-8'e değiştirmek istediğiniz veritabanı kullanıcı adını bilgilerini kodun başlangıcında belirtildiği gibi gösterilen yerlere girin.
UPDATE mybb2_adminlog SET data = REPLACE (data,'ð', 'g');
UPDATE mybb2_adminlog SET data = REPLACE (data,'ý', 'i');
UPDATE mybb2_adminlog SET data = REPLACE (data,'þ', 's');
UPDATE mybb2_adminlog SET data = REPLACE (data,'Ð', 'G');
UPDATE mybb2_adminlog SET data = REPLACE (data,'Ý', 'I');
UPDATE mybb2_adminlog SET data = REPLACE (data,'Þ', 'S');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_announcements SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_announcements SET message = REPLACE (message,'ð', 'g');
UPDATE mybb2_announcements SET message = REPLACE (message,'ý', 'i');
UPDATE mybb2_announcements SET message = REPLACE (message,'þ', 's');
UPDATE mybb2_announcements SET message = REPLACE (message,'Ð', 'G');
UPDATE mybb2_announcements SET message = REPLACE (message,'Ý', 'I');
UPDATE mybb2_announcements SET message = REPLACE (message,'Þ', 'S');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'ð', 'g');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'ý', 'i');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'þ', 's');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'Ð', 'G');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'Ý', 'I');
UPDATE mybb2_attachments SET filename = REPLACE (filename,'Þ', 'S');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'ð', 'g');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'ý', 'i');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'þ', 's');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'Ð', 'G');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'Ý', 'I');
UPDATE mybb2_badwords SET badword = REPLACE (badword,'Þ', 'S');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'ð', 'g');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'ý', 'i');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'þ', 's');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'Ð', 'G');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'Ý', 'I');
UPDATE mybb2_badwords SET replacement = REPLACE (replacement,'Þ', 'S');
UPDATE mybb2_banned SET reason = REPLACE (reason,'ð', 'g');
UPDATE mybb2_banned SET reason = REPLACE (reason,'ý', 'i');
UPDATE mybb2_banned SET reason = REPLACE (reason,'þ', 's');
UPDATE mybb2_banned SET reason = REPLACE (reason,'Ð', 'G');
UPDATE mybb2_banned SET reason = REPLACE (reason,'Ý', 'I');
UPDATE mybb2_banned SET reason = REPLACE (reason,'Þ', 'S');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'ð', 'g');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'ý', 'i');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'þ', 's');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'Ð', 'G');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'Ý', 'I');
UPDATE mybb2_datacache SET cache = REPLACE (cache,'Þ', 'S');
UPDATE mybb2_forums SET name = REPLACE (name,'ð', 'g');
UPDATE mybb2_forums SET name = REPLACE (name,'ý', 'i');
UPDATE mybb2_forums SET name = REPLACE (name,'þ', 's');
UPDATE mybb2_forums SET name = REPLACE (name,'Ð', 'G');
UPDATE mybb2_forums SET name = REPLACE (name,'Ý', 'I');
UPDATE mybb2_forums SET name = REPLACE (name,'Þ', 'S');
UPDATE mybb2_forums SET description = REPLACE (description,'ð', 'g');
UPDATE mybb2_forums SET description = REPLACE (description,'ý', 'i');
UPDATE mybb2_forums SET description = REPLACE (description,'þ', 's');
UPDATE mybb2_forums SET description = REPLACE (description,'Ð', 'G');
UPDATE mybb2_forums SET description = REPLACE (description,'Ý', 'I');
UPDATE mybb2_forums SET description = REPLACE (description,'Þ', 'S');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'ð', 'g');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'ý', 'i');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'þ', 's');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'Ð', 'G');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'Ý', 'I');
UPDATE mybb2_forums SET lastposter = REPLACE (lastposter,'Þ', 'S');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'ð', 'g');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'ý', 'i');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'þ', 's');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'Ð', 'G');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'Ý', 'I');
UPDATE mybb2_forums SET lastpostsubject = REPLACE (lastpostsubject,'Þ', 'S');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'ð', 'g');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'ý', 'i');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'þ', 's');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'Ð', 'G');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'Ý', 'I');
UPDATE mybb2_forums SET rulestitle = REPLACE (rulestitle,'Þ', 'S');
UPDATE mybb2_forums SET rules = REPLACE (rules,'ð', 'g');
UPDATE mybb2_forums SET rules = REPLACE (rules,'ý', 'i');
UPDATE mybb2_forums SET rules = REPLACE (rules,'þ', 's');
UPDATE mybb2_forums SET rules = REPLACE (rules,'Ð', 'G');
UPDATE mybb2_forums SET rules = REPLACE (rules,'Ý', 'I');
UPDATE mybb2_forums SET rules = REPLACE (rules,'Þ', 'S');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_maillogs SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_maillogs SET message = REPLACE (message,'ð', 'g');
UPDATE mybb2_maillogs SET message = REPLACE (message,'ý', 'i');
UPDATE mybb2_maillogs SET message = REPLACE (message,'þ', 's');
UPDATE mybb2_maillogs SET message = REPLACE (message,'Ð', 'G');
UPDATE mybb2_maillogs SET message = REPLACE (message,'Ý', 'I');
UPDATE mybb2_maillogs SET message = REPLACE (message,'Þ', 'S');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'ð', 'g');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'ý', 'i');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'þ', 's');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'Ð', 'G');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'Ý', 'I');
UPDATE mybb2_moderatorlog SET action = REPLACE (action,'Þ', 'S');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'ð', 'g');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'ý', 'i');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'þ', 's');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'Ð', 'G');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'Ý', 'I');
UPDATE mybb2_moderatorlog SET data = REPLACE (data,'Þ', 'S');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_massemails SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_massemails SET message = REPLACE (message,'ð', 'g');
UPDATE mybb2_massemails SET message = REPLACE (message,'ý', 'i');
UPDATE mybb2_massemails SET message = REPLACE (message,'þ', 's');
UPDATE mybb2_massemails SET message = REPLACE (message,'Ð', 'G');
UPDATE mybb2_massemails SET message = REPLACE (message,'Ý', 'I');
UPDATE mybb2_massemails SET message = REPLACE (message,'Þ', 'S');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'ð', 'g');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'ý', 'i');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'þ', 's');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'Ð', 'G');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'Ý', 'I');
UPDATE mybb2_massemails SET htmlmessage = REPLACE (htmlmessage,'Þ', 'S');
UPDATE mybb2_mycode SET title = REPLACE (title,'ð', 'g');
UPDATE mybb2_mycode SET title = REPLACE (title,'ý', 'i');
UPDATE mybb2_mycode SET title = REPLACE (title,'þ', 's');
UPDATE mybb2_mycode SET title = REPLACE (title,'Ð', 'G');
UPDATE mybb2_mycode SET title = REPLACE (title,'Ý', 'I');
UPDATE mybb2_mycode SET title = REPLACE (title,'Þ', 'S');
UPDATE mybb2_mycode SET description = REPLACE (description,'ð', 'g');
UPDATE mybb2_mycode SET description = REPLACE (description,'ý', 'i');
UPDATE mybb2_mycode SET description = REPLACE (description,'þ', 's');
UPDATE mybb2_mycode SET description = REPLACE (description,'Ð', 'G');
UPDATE mybb2_mycode SET description = REPLACE (description,'Ý', 'I');
UPDATE mybb2_mycode SET description = REPLACE (description,'Þ', 'S');
UPDATE mybb2_polls SET question = REPLACE (question,'ð', 'g');
UPDATE mybb2_polls SET question = REPLACE (question,'ý', 'i');
UPDATE mybb2_polls SET question = REPLACE (question,'þ', 's');
UPDATE mybb2_polls SET question = REPLACE (question,'Ð', 'G');
UPDATE mybb2_polls SET question = REPLACE (question,'Ý', 'I');
UPDATE mybb2_polls SET question = REPLACE (question,'Þ', 'S');
UPDATE mybb2_polls SET options = REPLACE (options,'ð', 'g');
UPDATE mybb2_polls SET options = REPLACE (options,'ý', 'i');
UPDATE mybb2_polls SET options = REPLACE (options,'þ', 's');
UPDATE mybb2_polls SET options = REPLACE (options,'Ð', 'G');
UPDATE mybb2_polls SET options = REPLACE (options,'Ý', 'I');
UPDATE mybb2_polls SET options = REPLACE (options,'Þ', 'S');
UPDATE mybb2_posts SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_posts SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_posts SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_posts SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_posts SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_posts SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_posts SET username = REPLACE (username,'ð', 'g');
UPDATE mybb2_posts SET username = REPLACE (username,'ý', 'i');
UPDATE mybb2_posts SET username = REPLACE (username,'þ', 's');
UPDATE mybb2_posts SET username = REPLACE (username,'Ð', 'G');
UPDATE mybb2_posts SET username = REPLACE (username,'Ý', 'I');
UPDATE mybb2_posts SET username = REPLACE (username,'Þ', 'S');
UPDATE mybb2_posts SET message = REPLACE (message,'ð', 'g');
UPDATE mybb2_posts SET message = REPLACE (message,'ý', 'i');
UPDATE mybb2_posts SET message = REPLACE (message,'þ', 's');
UPDATE mybb2_posts SET message = REPLACE (message,'Ð', 'G');
UPDATE mybb2_posts SET message = REPLACE (message,'Ý', 'I');
UPDATE mybb2_posts SET message = REPLACE (message,'Þ', 'S');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'ð', 'g');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'ý', 'i');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'þ', 's');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'Ð', 'G');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'Ý', 'I');
UPDATE mybb2_posts SET posthash = REPLACE (posthash,'Þ', 'S');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'ð', 'g');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'ý', 'i');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'þ', 's');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'Ð', 'G');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'Ý', 'I');
UPDATE mybb2_posts SET ipaddress = REPLACE (ipaddress,'Þ', 'S');
UPDATE mybb2_prefix SET title = REPLACE (title,'ð', 'g');
UPDATE mybb2_prefix SET title = REPLACE (title,'ý', 'i');
UPDATE mybb2_prefix SET title = REPLACE (title,'þ', 's');
UPDATE mybb2_prefix SET title = REPLACE (title,'Ð', 'G');
UPDATE mybb2_prefix SET title = REPLACE (title,'Ý', 'I');
UPDATE mybb2_prefix SET title = REPLACE (title,'Þ', 'S');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'ð', 'g');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'ý', 'i');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'þ', 's');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'Ð', 'G');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'Ý', 'I');
UPDATE mybb2_privatemessages SET recipients = REPLACE (recipients,'Þ', 'S');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_privatemessages SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'ð', 'g');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'ý', 'i');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'þ', 's');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'Ð', 'G');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'Ý', 'I');
UPDATE mybb2_privatemessages SET message = REPLACE (message,'Þ', 'S');
UPDATE mybb2_profilefields SET name = REPLACE (name,'ð', 'g');
UPDATE mybb2_profilefields SET name = REPLACE (name,'ý', 'i');
UPDATE mybb2_profilefields SET name = REPLACE (name,'þ', 's');
UPDATE mybb2_profilefields SET name = REPLACE (name,'Ð', 'G');
UPDATE mybb2_profilefields SET name = REPLACE (name,'Ý', 'I');
UPDATE mybb2_profilefields SET name = REPLACE (name,'Þ', 'S');
UPDATE mybb2_profilefields SET description = REPLACE (description,'ð', 'g');
UPDATE mybb2_profilefields SET description = REPLACE (description,'ý', 'i');
UPDATE mybb2_profilefields SET description = REPLACE (description,'þ', 's');
UPDATE mybb2_profilefields SET description = REPLACE (description,'Ð', 'G');
UPDATE mybb2_profilefields SET description = REPLACE (description,'Ý', 'I');
UPDATE mybb2_profilefields SET description = REPLACE (description,'Þ', 'S');
UPDATE mybb2_profilefields SET type = REPLACE (type,'ð', 'g');
UPDATE mybb2_profilefields SET type = REPLACE (type,'ý', 'i');
UPDATE mybb2_profilefields SET type = REPLACE (type,'þ', 's');
UPDATE mybb2_profilefields SET type = REPLACE (type,'Ð', 'G');
UPDATE mybb2_profilefields SET type = REPLACE (type,'Ý', 'I');
UPDATE mybb2_profilefields SET type = REPLACE (type,'Þ', 'S');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'ð', 'g');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'ý', 'i');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'þ', 's');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'Ð', 'G');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'Ý', 'I');
UPDATE mybb2_reportedposts SET reason = REPLACE (reason,'Þ', 'S');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'ð', 'g');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'ý', 'i');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'þ', 's');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'Ð', 'G');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'Ý', 'I');
UPDATE mybb2_reputation SET comments = REPLACE (comments,'Þ', 'S');
UPDATE mybb2_settings SET title = REPLACE (title,'ð', 'g');
UPDATE mybb2_settings SET title = REPLACE (title,'ý', 'i');
UPDATE mybb2_settings SET title = REPLACE (title,'þ', 's');
UPDATE mybb2_settings SET title = REPLACE (title,'Ð', 'G');
UPDATE mybb2_settings SET title = REPLACE (title,'Ý', 'I');
UPDATE mybb2_settings SET title = REPLACE (title,'Þ', 'S');
UPDATE mybb2_settings SET description = REPLACE (description,'ð', 'g');
UPDATE mybb2_settings SET description = REPLACE (description,'ý', 'i');
UPDATE mybb2_settings SET description = REPLACE (description,'þ', 's');
UPDATE mybb2_settings SET description = REPLACE (description,'Ð', 'G');
UPDATE mybb2_settings SET description = REPLACE (description,'Ý', 'I');
UPDATE mybb2_settings SET description = REPLACE (description,'Þ', 'S');
UPDATE mybb2_settings SET value = REPLACE (value,'ð', 'g');
UPDATE mybb2_settings SET value = REPLACE (value,'ý', 'i');
UPDATE mybb2_settings SET value = REPLACE (value,'þ', 's');
UPDATE mybb2_settings SET value = REPLACE (value,'Ð', 'G');
UPDATE mybb2_settings SET value = REPLACE (value,'Ý', 'I');
UPDATE mybb2_settings SET value = REPLACE (value,'Þ', 'S');
UPDATE mybb2_tasklog SET data = REPLACE (data,'ð', 'g');
UPDATE mybb2_tasklog SET data = REPLACE (data,'ý', 'i');
UPDATE mybb2_tasklog SET data = REPLACE (data,'þ', 's');
UPDATE mybb2_tasklog SET data = REPLACE (data,'Ð', 'G');
UPDATE mybb2_tasklog SET data = REPLACE (data,'Ý', 'I');
UPDATE mybb2_tasklog SET data = REPLACE (data,'Þ', 'S');
UPDATE mybb2_threads SET subject = REPLACE (subject,'ð', 'g');
UPDATE mybb2_threads SET subject = REPLACE (subject,'ý', 'i');
UPDATE mybb2_threads SET subject = REPLACE (subject,'þ', 's');
UPDATE mybb2_threads SET subject = REPLACE (subject,'Ð', 'G');
UPDATE mybb2_threads SET subject = REPLACE (subject,'Ý', 'I');
UPDATE mybb2_threads SET subject = REPLACE (subject,'Þ', 'S');
UPDATE mybb2_threads SET username = REPLACE (username,'ð', 'g');
UPDATE mybb2_threads SET username = REPLACE (username,'ý', 'i');
UPDATE mybb2_threads SET username = REPLACE (username,'þ', 's');
UPDATE mybb2_threads SET username = REPLACE (username,'Ð', 'G');
UPDATE mybb2_threads SET username = REPLACE (username,'Ý', 'I');
UPDATE mybb2_threads SET username = REPLACE (username,'Þ', 'S');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'ð', 'g');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'ý', 'i');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'þ', 's');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'Ð', 'G');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'Ý', 'I');
UPDATE mybb2_threads SET lastposter = REPLACE (lastposter,'Þ', 'S');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'ð', 'g');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'ý', 'i');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'þ', 's');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'Ð', 'G');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'Ý', 'I');
UPDATE mybb2_userfields SET fid1 = REPLACE (fid1,'Þ', 'S');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'ð', 'g');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'ý', 'i');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'þ', 's');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'Ð', 'G');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'Ý', 'I');
UPDATE mybb2_userfields SET fid2 = REPLACE (fid2,'Þ', 'S');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'ð', 'g');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'ý', 'i');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'þ', 's');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'Ð', 'G');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'Ý', 'I');
UPDATE mybb2_userfields SET fid3 = REPLACE (fid3,'Þ', 'S');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'ð', 'g');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'ý', 'i');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'þ', 's');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'Ð', 'G');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'Ý', 'I');
UPDATE mybb2_userfields SET fid4 = REPLACE (fid4,'Þ', 'S');
UPDATE mybb2_usergroups SET title = REPLACE (title,'ð', 'g');
UPDATE mybb2_usergroups SET title = REPLACE (title,'ý', 'i');
UPDATE mybb2_usergroups SET title = REPLACE (title,'þ', 's');
UPDATE mybb2_usergroups SET title = REPLACE (title,'Ð', 'G');
UPDATE mybb2_usergroups SET title = REPLACE (title,'Ý', 'I');
UPDATE mybb2_usergroups SET title = REPLACE (title,'Þ', 'S');
UPDATE mybb2_usergroups SET description = REPLACE (description,'ð', 'g');
UPDATE mybb2_usergroups SET description = REPLACE (description,'ý', 'i');
UPDATE mybb2_usergroups SET description = REPLACE (description,'þ', 's');
UPDATE mybb2_usergroups SET description = REPLACE (description,'Ð', 'G');
UPDATE mybb2_usergroups SET description = REPLACE (description,'Ý', 'I');
UPDATE mybb2_usergroups SET description = REPLACE (description,'Þ', 'S');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'ð', 'g');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'ý', 'i');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'þ', 's');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'Ð', 'G');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'Ý', 'I');
UPDATE mybb2_usergroups SET usertitle = REPLACE (usertitle,'Þ', 'S');
UPDATE mybb2_users SET username = REPLACE (username,'ð', 'g');
UPDATE mybb2_users SET username = REPLACE (username,'ý', 'i');
UPDATE mybb2_users SET username = REPLACE (username,'þ', 's');
UPDATE mybb2_users SET username = REPLACE (username,'Ð', 'G');
UPDATE mybb2_users SET username = REPLACE (username,'Ý', 'I');
UPDATE mybb2_users SET username = REPLACE (username,'Þ', 'S');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'ð', 'g');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'ý', 'i');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'þ', 's');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'Ð', 'G');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'Ý', 'I');
UPDATE mybb2_users SET usertitle = REPLACE (usertitle,'Þ', 'S');
UPDATE mybb2_users SET signature = REPLACE (signature,'ð', 'g');
UPDATE mybb2_users SET signature = REPLACE (signature,'ý', 'i');
UPDATE mybb2_users SET signature = REPLACE (signature,'þ', 's');
UPDATE mybb2_users SET signature = REPLACE (signature,'Ð', 'G');
UPDATE mybb2_users SET signature = REPLACE (signature,'Ý', 'I');
UPDATE mybb2_users SET signature = REPLACE (signature,'Þ', 'S');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'ð', 'g');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'ý', 'i');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'þ', 's');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'Ð', 'G');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'Ý', 'I');
UPDATE mybb2_users SET notepad = REPLACE (notepad,'Þ', 'S');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'ð', 'g');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'ý', 'i');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'þ', 's');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'Ð', 'G');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'Ý', 'I');
UPDATE mybb2_usertitles SET starimage = REPLACE (starimage,'Þ', 'S');
UPDATE mybb2_usertitles SET title = REPLACE (title,'ð', 'g');
UPDATE mybb2_usertitles SET title = REPLACE (title,'ý', 'i');
UPDATE mybb2_usertitles SET title = REPLACE (title,'þ', 's');
UPDATE mybb2_usertitles SET title = REPLACE (title,'Ð', 'G');
UPDATE mybb2_usertitles SET title = REPLACE (title,'Ý', 'I');
UPDATE mybb2_usertitles SET title = REPLACE (title,'Þ', 'S');
------------------ Eger Sorun Olursa Kullanin ----------------------
UPDATE mybb2_templates SET template = REPLACE (template,'ð', 'g');
UPDATE mybb2_templates SET template = REPLACE (template,'ý', 'i');
UPDATE mybb2_templates SET template = REPLACE (template,'þ', 's');
UPDATE mybb2_templates SET template = REPLACE (template,'Ð', 'G');
UPDATE mybb2_templates SET template = REPLACE (template,'Ý', 'I');
UPDATE mybb2_templates SET template = REPLACE (template,'Þ', 'S');
Bunlarıda " themem " isimli arkadaşın anlattığı gibi uygulayın fakat benim ayarladığım şekilde girin.
" mybb2_templates " veritabanını en sona bırakın. Eğer sorun olursa bu sorgulamayı uygulayın. Tavsiyem budur.
" convert.php " dosyasını ftpnize herhangi bir yere atıp çalıştırın.
Sayfa tamamen yüklendiğinde işleminiz tamamlanmış demektir, phpmyadmin'e girerek bir hata olup olmadığını kontrol ediniz, her ihtimale karşı tüm tabloları onar komutu ile kontrol ediniz.
Forumun ayarlarını iso-8859-9 'dan UTF-8'e geçiriniz, eğer varsa pluginlerinizinde dil ayarlarını yapmayı unutmayınız.
Eğer forum title'ında veya başka bölümlerde karakter problemi yaşarsanız bunları Forum Ayarları kısmından halledebilirsiniz.
Kolay gelsin