[TrappaTroopa]

Originally Posted by yash1441 Zephyrus Store Credits upon finishing the map (bonus and practice included). Not tested but should work.

Can someone compile this for me with latest SM 1.8? Maybe send me Full plugin in a PM? I can not get it to compile. I would very much appreciate it!

Edit: I used SM 1.8 and its respective compile.exe. With all of the includes required (store, cksurf, etc). kept getting 1 error. cksurf not found or something. Even though it was in the folder.

[justaFluffypanda]

Originally Posted by CdogTV 03/20/2017 - 23:572: [SM] Exception reported: [ckSurf] Unable to connect to database (Configuration "cksurf" not found) L 03/20/2017 - 23:572: [SM] Blaming: ckSurf.smx L 03/20/2017 - 23:572: [SM] Call stack trace: L 03/20/2017 - 23:572: [SM] [0] SetFailState L 03/20/2017 - 23:572: [SM] [1] Line 158, ckSurf/sql.sp::db_setupDatabase L 03/20/2017 - 23:572: [SM] [2] Line 1849, D:\ckSurf\csgo\addons\sourcemod\scripting\ckS urf.sp::OnPluginStart L 03/20/2017 - 23:572: [SM] Unable to load plugin "ckSurf.smx": Error detected in plugin startup (see error logs)

This error means you haven't added the cksurf section to your csgo/addons/sourcemod/configs/databases.cfg file. Have you set up your databases yet?

[ASKER_CZ]

BTW some players lose points even when they for example complete map and beat their time . (I didnt add any new map) How is this possible and why is it happening? Thanks. Its important.

[CookieB]

Originally Posted by justaFluffypanda I've discovered the problem with server displaying the wrong name next to the map record. In the csgo/addons/sourcemod/scripting/ckSurf/sql.sp file the line char sql_selectMapRecord[] = "SELECT MIN(runtimepro), name, steamid FROM ck_playertimes WHERE mapname = '%s' AND runtimepro > -1.0"; is poorly written and returns the wrong value. In fact, in MySQL >= 5.7 this line will cause MySQL to throw an error. I've changed it to this: char sql_selectMapRecord[] = "SELECT runtimepro, name, steamid FROM ck_playertimes WHERE mapname = '%s' AND runtimepro = (SELECT MIN(runtimepro) FROM ck_playertimes) AND runtimepro > -1.0"; There are several more poorly written SQL statements in this file, I will report back once I track them all down. Happy coding. EDIT: Don't forget to recompile ckSurf and move the new smx file into your csgo/addons/sourcemod/plugins directory after you make changes to sql.sp ;)

I tested your expression in the mysql command line and it returns an empty set for the maps.

-- Your fault seems to be that your second query selects the minimal runtime first and isn't executed upon the first query.

-- Fixing it with minimal change would be:

SELECT runtimepro, name, steamid FROM ck_playertimes WHERE mapname = '%s' AND runtimepro = (SELECT MIN(runtimepro) FROM ck_playertimes WHERE mapname = '%s' ) AND runtimepro > -1.0;

Though having 2 %s in there means probably usage code needs to be adjusted so not a very good solution.

mysql  Ver 14.14 Distrib 5.5.54, for debian-linux-gnu (x86_64) using readline 6.3

[justaFluffypanda]

Originally Posted by CookieB I tested your expression in the mysql command line and it returns an empty set for the maps. -- Your fault seems to be that your second query selects the minimal runtime first and isn't executed upon the first query. -- Fixing it with minimal change would be: SELECT runtimepro, name, steamid FROM ck_playertimes WHERE mapname = '%s' AND runtimepro = (SELECT MIN(runtimepro) FROM ck_playertimes WHERE mapname = '%s' ) AND runtimepro > -1.0; Though having 2 %s in there means probably usage code needs to be adjusted so not a very good solution. mysql Ver 14.14 Distrib 5.5.54, for debian-linux-gnu (x86_64) using readline 6.3

I should have posted the version of mysql I'm running as my code is working and I did not test it against MySQL 5.5

I'm running MySQL 5.6.16, I'll edit my original post to show this and point the 5.5 users towards your solution

[CookieB]

That's lovely, want to ask about some help for ck surf now though.

I have this problem:

Ranks are not shown fully but seem clipped ( like in what should be EXPERIENCED ), I had a look into the code and on first glance buffers seem big enough. Is it a server setting?

[justaFluffypanda]

Originally Posted by CookieB That's lovely, want to ask about some help for ck surf now though. I have this problem: Ranks are not shown fully but seem clipped ( like in what should be EXPERIENCED ), I had a look into the code and on first glance buffers seem big enough. Is it a server setting?

I haven't experienced this issue, to troubleshoot does it cut them off if you disable the Country code being shown on the names?

Should be the ck_country_tag cvar in csgo/cfg/sourcemod/cksurf.cfg, or I believe you can change it via the !ckadmin menu in game.

 // on/off - Country clan tag
 // -
 // Default: "1"
 // Minimum: "0.000000"
 // Maximum: "1.000000"
 ck_country_tag "0"

[CookieB]

I'd much rather fix it than work around it, I like the country tags.

[sneaK]

You're limited by what CS:GO itself has to offer. There is a maximum displayable clan tag length (not sure what it is off hand), but I'm sure you can count the characters.

[CookieB]

Originally Posted by blackhawk74 You're limited by what CS:GO itself has to offer. There is a maximum displayable clan tag length (not sure what it is off hand), but I'm sure you can count the characters.

If it's that I'll probably go with changing

scripting/ckSurf/timer.sp

447: Format(tag, 154, "%s | %s", g_szCountryCode[client], g_pr_rankname[client]);
to
447: Format(tag, 154, "%s|%s", g_szCountryCode[client], g_pr_rankname[client]);