[sigerman]

Thanks for reading.

I have a rather small issue with uq_jumpstats, I think if someone fixes this all people will benefit

I connected uq_jumpstats to mysql, and I find out that special characters are not working in the database, let me show you what I mean:

It should look like this: name "エ ォ オ カ ガ キ ギ ク グ ケ ゲ " ______________________________ But It looks like this in the web page: ______________________________ In the database It is the same issue:

Who's willing to fix this?
________________________

Link to the plugin:

https://forums.alliedmods.net/showthread.php?t=141586

[Napoleon_be]

You should use the player's steamid instead to save data. No support for non-steam.

[sigerman]

Originally Posted by Napoleon_be You should use the player's steamid instead to save data. No support for non-steam.

Did you at least checked the plugin before you open your mouth?

[Napoleon_be]

Yes i did, it appears you are just having trouble reading the original post. No need to be rude anyways.

PHP Code:

7. How to save Top10 (2 = steamid, 1 = Ip, 0 = name)
 
kz_uq_top_by «1»
kz_uq_save_top «1» - On/Off TOP10 (1 = on, 0 = off)
kz_uq_maptop «1» - On/Off MapTop (1 = on, 0 = off)
kz_uq_save_extras_top «1» - On/Off Extra Tops (1 = on, 0 = off) 


[sigerman]

Originally Posted by Napoleon_be Yes i did, it appears you are just having trouble reading the original post. No need to be rude anyways. PHP Code: 7. How to save Top10 (2 = steamid, 1 = Ip, 0 = name)   kz_uq_top_by «1» kz_uq_save_top «1» - On/Off TOP10 (1 = on, 0 = off) kz_uq_maptop «1» - On/Off MapTop (1 = on, 0 = off) kz_uq_save_extras_top «1» - On/Off Extra Tops (1 = on, 0 = off)

You did not understand what I asked, and yet you juged me. The database saves the three options no matter what. The field name in the database, does not save with the correct characters. Even If you put the database in utf8, something is not right.

The functionality of a top in this plugin NEEDS to have a name, If It hadn't a name, then It would not be a top.

[Napoleon_be]

Originally Posted by sigerman You did not understand what I asked, and yet you juged me. The database saves the three options no matter what. The field name in the database, does not save with the correct characters. Even If you put the database in utf8, something is not right. The functionality of a top in this plugin NEEDS to have a name, If It hadn't a name, then It would not be a top.

It doesn't matter if the names are correctly stored or not, as long as the steam id is correct which u can use to check anything, it's gucci. Imagine having two players with identical names but different steam id's. Yet you check for their names, what's gonna happen you think?

You're here for non-steam support and throwing all kinds of accusations my way.

I wish you good luck finding the right help with the way you're treating people.

[sigerman]

Grow up kid. Put yourself in places you want to be. Never underestimate anyone.

[Napoleon_be]

Originally Posted by sigerman Grow up kid. Put yourself in places you want to be. Never underestimate anyone.

Wtf is that even supposed to mean? Furthermore there's a reason why that plugin is listed as "Unapproved", not my problem you really are that simple minded.

[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:

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..

[sigerman]

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





Thanks for answering

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: 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..