yi12345 / TravianZ

travian t3.6 project (based on travianx v6.0.0)
185 stars 191 forks source link

Fixed utf8 phpmyadmin now working! #383

Open gm4st3r opened 11 years ago

gm4st3r commented 11 years ago

go to GameEngine / Database / db_MYSQL.php opened it and added it to the line 19

mysql_query("SET NAMES 'UTF8'"); //Fix utf8 phpmyadmin by gm4st3r

will look like this:

var $connection; function MYSQL_DB() { $this->connection = mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS) or die(mysql_error()); mysql_select_db(SQL_DB, $this->connection) or die(mysql_error()); mysql_query("SET NAMES 'UTF8'"); //Fix utf8 phpmyadmin by gm4st3r }

install / data / sql.sql

Find the line 1548:

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

and then this:

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

noonn commented 11 years ago

Good job ^^ I will try it.