[anaskaddar]

L 02/15/2015 - 14:53:49: SourceMod error session started L 02/15/2015 - 14:53:49: Info (map "de_dust") (file "errors_20150215.log") L 02/15/2015 - 14:53:49: [SM] Native "SQL_GetError" reported: Invalid statement or db Handle 0 (error: 4) L 02/15/2015 - 14:53:49: [SM] Displaying call stack trace for plugin "srank.smx": L 02/15/2015 - 14:53:49: [SM] [0] Line 15, ShadowLibs/srank_mysql.sp::RunDataBaseSetUp() L 02/15/2015 - 14:53:49: [SM] [1] Line 9, C:\Users\Laurence\Documents\Laurence\Work Area\Sourcemod\Studio\Plugins\CSGO-SRank\addons\sourcemod\scripting\srank.sp::On PluginStart() L 02/15/2015 - 14:53:49: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 02/15/2015 - 14:53:49: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 02/15/2015 - 14:53:49: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 02/15/2015 - 14:540: Error log file session closed. L 02/15/2015 - 14:540: SourceMod error session started L 02/15/2015 - 14:540: Info (map "de_dust") (file "errors_20150215.log") L 02/15/2015 - 14:540: [SM] Native "SQL_GetError" reported: Invalid statement or db Handle 0 (error: 4) L 02/15/2015 - 14:540: [SM] Displaying call stack trace for plugin "srank.smx": L 02/15/2015 - 14:540: [SM] [0] Line 15, ShadowLibs/srank_mysql.sp::RunDataBaseSetUp() L 02/15/2015 - 14:540: [SM] [1] Line 9, C:\Users\Laurence\Documents\Laurence\Work Area\Sourcemod\Studio\Plugins\CSGO-SRank\addons\sourcemod\scripting\srank.sp::On PluginStart() L 02/15/2015 - 14:540: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 02/15/2015 - 14:540: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 02/15/2015 - 14:540: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[shadowdragon]

This looks like the plugin is unable to connect to your database. because i just uploaded v2 to my test server again with the MySql Database with it and its running fine.

[anaskaddar]

Ok thx now the plugin works.

[Artix]

Hello ,

I`m interested in this mod , but i want to know some info about it
For example i see that it say`s something about the SQL , do i need to install sql on the server ...or it`s something that it`s in the csgo file ..or something ....
Sorry for asking stupid questions ...but i want to know

Thanks in advance and i wish you all a good day

[shadowdragon]

Ok well MySQL is a database which is stored on a website so in order to run this plugin you will need a website domain along with a web host if you do not have a website that allows MySQL connections from game servers you will never get my plugin to run, If i get enough people wanting the plugin compatible with SQLITE then i will add that functionality to it.

[Artix]

Originally Posted by shadowdragon Ok well MySQL is a database which is stored on a website so in order to run this plugin you will need a website domain along with a web host if you do not have a website that allows MySQL connections from game servers you will never get my plugin to run, If i get enough people wanting the plugin compatible with SQLITE then i will add that functionality to it.

Ahm , i see ..thanks for the info ..i guess i will have to find something else..that does not require so many "things" i pref. something that will write the data local .....

Thank very much for the info and reply

I wish you all the best

Kind Regards,
Artix

[qiuhaian]

wish you to update it

such as !rank !top

[Pohearts]

is that only me or not that in the code is still using deprecated GetClientAuthString? :/
Should be from this..

GetClientAuthString(client, auth, sizeof(auth));

to this..

GetClientAuthId(client, AuthId_Steam2, auth, sizeof(auth));

-----
GetClientName will return string but not an integer number.
https://sm.alliedmods.net/api/index....ad=show&id=399

GetClientName(client, PlayerName[client],sizeof(PlayerName)); Format(query, sizeof(query), "UPDATE srank SET name = %d,kills = %d,deaths = %d,headshots = %d, points = %d WHERE steamid = '%s'",PlayerName[client],PlayerKills[client],PlayerDeaths[client],PlayerHeadShots[client],PlayerPoints[client],auth);

I see you are trying to get a playername from the client index with GetClientName (correct me if i was wrong), but in sourcemod format specifier ,you can convert client index to playername string simply with %N, so the code would be like that:

Format(query, sizeof(query), "UPDATE srank SET name = '%N',kills = %d,deaths = %d,headshots = %d, points = %d WHERE steamid = '%s'",client,PlayerKills[client],PlayerDeaths[client],PlayerHeadShots[client],PlayerPoints[client],auth);

*EscapeString or else it 'll Vulnerable to SQL attack
Thanks!

[qiuhaian]

wish you to update it ,man

[shadowdragon]

Hey guys im really sorry about not updating this but school started up for my and i was unable to complete this project i am working on it again but i have no idea how fair ill get befor i need to stop work on it again i may have an update within the next 4 days maybe sooner