<?php
header('Content-Type: text/html; charset=utf-8' );

error_reporting(E_ALL | E_STRICT);

define('DB_SERVER', 'server');
define('DB_USER',   'user');
define('DB_NAME',   'name');
define('DB_PASS',   'pass');

$charset    = 'utf8';
$collation  = 'utf8_slovenian_ci';

$link_id    = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die('Error establishing a database connection');
mysql_select_db(DB_NAME, $link_id);

mysql_query("SET NAMES '$charset' COLLATE '$collation'", $link_id);

$tables = array();
$result = mysql_query("SHOW TABLES", $link_id);

while (($table = mysql_fetch_array($result)) !== false) {
    if (strpos($table[0], 'phpbb') === false) {
        $tables[] = $table[0];
    }
}

// this was taken from http://g30rg3x.com/ (UTF-8 Database Converter plugin - http://g30rg3x.com/utf8-database-converter/)
foreach ( (array) $tables as $table ) {
	$resource = mysql_query("EXPLAIN $table", $link_id);
	while ( ($result = mysql_fetch_assoc($resource)) !== false ) {
		if ( preg_match('/(char)|(text)|(enum)|(set)/', $result['Type']) )
			$tables_with_fields[$table][$result['Field']] = $result['Type'] . " " . ( "YES" == $result['Null'] ? "" : "NOT " ) . "NULL " .  ( !is_null($result['Default']) ? "DEFAULT '". $result['Default'] ."'" : "" );
	}
}

// Spremenimo vse tekstovna polja v binarno obliko
foreach ( (array) $tables as $table ) dump("ALTER TABLE $table CONVERT TO CHARACTER SET binary;", $link_id);

// Bazi ter tabelam nastavimo na željeno kodno tabelo
dump("ALTER DATABASE " . DB_NAME . " CHARACTER SET $charset COLLATE '$collation';", $link_id);
foreach ( (array) $tables as $table )
	dump("ALTER TABLE $table CONVERT TO CHARACTER SET $charset COLLATE '$collation';", $link_id);

// Vsa spremenjena polja spremenimo nazaj v prvotno stanje
foreach ( (array) $tables_with_fields as $table => $fields ) {
	foreach ( (array) $fields as $field_type => $field_options ) {
		dump("ALTER TABLE $table MODIFY $field_type $field_options;", $link_id);
	}
}

foreach ( (array) $tables as $table )
	dump("OPTIMIZE TABLE $table;", $link_id);


// Pogledamo, če je prišlo do kakšnih čudnih znakov in jih nadomestimo z pravimi
foreach($tables as $table) {
    $result = mysql_query("SELECT * FROM $table", $link_id);

    while( ($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false) {
        convert($row, $table);
    }
}

function convert($data, $table) {
  $do_update = false;

  foreach($data as $k => $value) {
    if (!is_array($value)) {
      $count    = 0;
      $data[$k] = str_replace(array('Å½', 'Å¾', 'Å¡', 'Å', 'ÄŒ', 'Ä'), array('Ž', 'ž', 'š', 'Š', 'Č', 'č'), $data[$k], $count);

      if ($count > 0) {
          $do_update = true;
      }
    }
  }

  if ($do_update === true) {
    $query = createGenericUpdateSQL($data, $table, key($data), $data[key($data)]);
    dump($query);
  }
}

function createGenericUpdateSQL($values, $table, $where_field, $where_value){
	$query        = "UPDATE `$table` SET ";
	$keys         = array_keys($values);
	$last_key	  = end($keys);;
	foreach ($values as $key => $value){
		$query   .= "`$key` = '".$value."'";
		if ($last_key != $key){
			$query .= ', ';
		}
	}
	$query 		 .=  " WHERE `$where_field`='".$where_value."' LIMIT 1;";
	return $query;
}

function dump($data){
    echo "$data\n";
}
?>