[req] problem with uq_jumpstats (mysql fix)

sigerman · **Author**

Hello, I did exactly what you posted, and still having issues, let me show you in pictures what I am seeing:

Click image for larger version

Name: sdafhsdfhsdfh.jpg
Views: 10
Size: 57.5 KB
ID: 204293

Click image for larger version

Name: zgasfgsdf.jpg
Views: 13
Size: 6.3 KB
ID: 204294

Thanks for answering

Quote:

Originally Posted by JocAnis

i guess you will need to modify utf encoding in the fields you need ("name" in your case)

open /scripting/includes/uq_jumpstats.sql

then change line for creating table for uq_players:

Code:

formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL, lastseen INT(10) NOT NULL,INDEX(name,authid))");
	SQL_ThreadQuery(DB_TUPLE,"QueryHandle", CreateInto);


to

formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL, lastseen INT(10) NOT NULL,INDEX(name,authid))");
	SQL_ThreadQuery(DB_TUPLE,"QueryHandle", CreateInto);

of course you will need to delete your existing tables/data and start over again (there is option to update utf directly in your phpmyadmin settings, but "names" wont be automatically 'translated', logically..