[Puppetmaster]

Originally Posted by Puppetmaster Added multiple international servers which run the plugin off of the one main database server. Admins can now see what the plugin looks like in their own region. The database latency is around 400ms for the international servers and represents an extreme case. USA - 104.237.2.27:27125 UK - 37.247.116.239:27125 AU - 125.63.48.152:27025

Added a set of EU demo servers for testing/demoing. latency is ~390MS to the DB again demonstrating an extreme case.
EU - 178.238.225.118:27125

[Puppetmaster]

0.2.4:
Updated some query priorities so that important queries happen earlier.
Reduced the number of times new users are checked.
Removed multicolors lib.
Added Support for disconnected players.
Added fallback to attempt to write out a players rank at their disconnect.

[me-Shoe]

Hey. Is it possible for you to add the possibility, to track the time they were connected and put it into the DB as well? thx in advance! edit: since i updated to the new version it wont work:

L 06/14/2016 - 17:46:15: SourceMod error session started L 06/14/2016 - 17:46:15: Info (map "br_electrified") (file "errors_20160614.log") 
L 06/14/2016 - 17:46:15: [SM] Exception reported: Invalid database Handle 0 (error: 4) 
L 06/14/2016 - 17:46:15: [SM] Blaming: simplecsgoranks.smx() 
L 06/14/2016 - 17:46:15: [SM] Call stack trace: 
L 06/14/2016 - 17:46:15: [SM]   [0] SQL_FastQuery 
L 06/14/2016 - 17:46:15: [SM]   [1] Line 573, simplecsgoranks.sp::newDB() 
L 06/14/2016 - 17:46:15: [SM]   [2] Line 902, simplecsgoranks.sp::OnPluginStart() 
L 06/14/2016 - 17:46:15: [SM] Unable to load plugin "simplecsgoranks.smx": Error detected in plugin startup (see error logs)

[Puppetmaster]

Originally Posted by me-Shoe Hey. Is it possible for you to add the possibility, to track the time they were connected and put it into the DB as well? thx in advance! edit: since i updated to the new version it wont work: L 06/14/2016 - 17:46:15: SourceMod error session started L 06/14/2016 - 17:46:15: Info (map "br_electrified") (file "errors_20160614.log") L 06/14/2016 - 17:46:15: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 06/14/2016 - 17:46:15: [SM] Blaming: simplecsgoranks.smx() L 06/14/2016 - 17:46:15: [SM] Call stack trace: L 06/14/2016 - 17:46:15: [SM] [0] SQL_FastQuery L 06/14/2016 - 17:46:15: [SM] [1] Line 573, simplecsgoranks.sp::newDB() L 06/14/2016 - 17:46:15: [SM] [2] Line 902, simplecsgoranks.sp::OnPluginStart() L 06/14/2016 - 17:46:15: [SM] Unable to load plugin "simplecsgoranks.smx": Error detected in plugin startup (see error logs)

Good catch, this issue will need to be looked into.
For now you can probably just recompile with the following change:

ready = dbWorks(); //check if the database is set up. This  does not ever function if sourcemod does not have mysql set up                                     
if(!ready){                                        
newDB(); //create a new table in the database if its not there                                        
ready = dbWorks(); //check again                                    
}

ready = true;

[me-Shoe]

argh. Im pretty bad in compiling... I hope you will find the solution!

[ItsCEED]

//SourceMod Batch Compiler
// by the SourceMod Dev Team


//// rektrank.sp
//
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/entities.inc(33) : error 138: const was specified twice
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(154) : error 157: 'char' is a reserved keyword
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(157) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(162) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(176) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(179) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(184) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(187) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(191) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(154) : warning 204: symbol is assigned a value that is never used: "char"
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(239) : error 157: 'char' is a reserved keyword
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(241) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(242) : error 029: invalid expression, assumed zero
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(239) : warning 204: symbol is assigned a value that is never used: "char"
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/crypt.inc(426) : error 173: 'in' is a newly reserved keyword that may be used in the future; use a different name as an identifier
// C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/effects.inc(158) : warning 237: coercing functions to and from primitives is unsupported and will be removed in the future
//
// 13 Errors.
//
// Compilation Time: 0.69 sec
// ----------------------------------------

im getting this error while im trying to compile the plugin, what could be the issue?

[Puppetmaster]

Originally Posted by ItsCEED //SourceMod Batch Compiler // by the SourceMod Dev Team //// rektrank.sp // // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/entities.inc(33) : error 138: const was specified twice // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(154) : error 157: 'char' is a reserved keyword // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(157) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(162) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(176) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(179) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(184) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(187) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(191) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(154) : warning 204: symbol is assigned a value that is never used: "char" // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(239) : error 157: 'char' is a reserved keyword // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(241) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(242) : error 029: invalid expression, assumed zero // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/colors.inc(239) : warning 204: symbol is assigned a value that is never used: "char" // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/crypt.inc(426) : error 173: 'in' is a newly reserved keyword that may be used in the future; use a different name as an identifier // C:\Users\CEED\Desktop\comp\addons\sourcemod\scripting\include\smlib/effects.inc(158) : warning 237: coercing functions to and from primitives is unsupported and will be removed in the future // // 13 Errors. // // Compilation Time: 0.69 sec // ---------------------------------------- im getting this error while im trying to compile the plugin, what could be the issue?

Hmm.. which version of SMLib did you use?
The latest build (the one we use) is located on their github.

The one found on their website is quite out of date and tends to give many errors.

[ItsCEED]

Originally Posted by Puppetmaster Hmm.. which version of SMLib did you use? The latest build (the one we use) is located on their github. The one found on their website is quite out of date and tends to give many errors.

All cool now, thank you

[Puppetmaster]

Originally Posted by me-Shoe argh. Im pretty bad in compiling... I hope you will find the solution!

I have added 0.2.4a which should fix your issue ;)

[ItsCEED]

I have small issue.

https://gyazo.com/66ab2caf326f7cc9722148013937b16f

what could it be?