Raised This Month: $214 Target: $400
 53% 

[CSGO] SRank - a csgo ranking system


Post New Thread Reply   
 
Thread Tools Display Modes
anaskaddar
Junior Member
Join Date: Dec 2014
Old 02-15-2015 , 08:57   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #11

Quote:
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)
anaskaddar is offline
shadowdragon
Senior Member
Join Date: Dec 2012
Old 02-16-2015 , 00:06   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #12

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.
__________________
Sorry for my poor English!
________________________________
I can do CSS/CSGO plugin request for little money!
shadowdragon is offline
anaskaddar
Junior Member
Join Date: Dec 2014
Old 02-16-2015 , 11:20   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #13

Ok thx now the plugin works.
anaskaddar is offline
Artix
New Member
Join Date: Feb 2015
Old 02-19-2015 , 14:21   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #14

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
Artix is offline
shadowdragon
Senior Member
Join Date: Dec 2012
Old 02-20-2015 , 04:53   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #15

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.
__________________
Sorry for my poor English!
________________________________
I can do CSS/CSGO plugin request for little money!
shadowdragon is offline
Artix
New Member
Join Date: Feb 2015
Old 02-20-2015 , 05:25   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #16

Quote:
Originally Posted by shadowdragon View Post
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
Artix is offline
qiuhaian
Senior Member
Join Date: Nov 2009
Old 03-07-2015 , 20:43   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #17

wish you to update it

such as !rank !top
qiuhaian is offline
Pohearts
AlliedModders Donor
Join Date: Oct 2014
Location: Hong Kong
Old 03-08-2015 , 05:05   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #18

is that only me or not that in the code is still using deprecated GetClientAuthString? :/
Should be from this..
Quote:
GetClientAuthString(client, auth, sizeof(auth));
to this..
Quote:
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
Quote:
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:

Code:
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!
__________________
HoursPlayed.net / Next Level Gaming network

Last edited by Pohearts; 05-03-2015 at 03:07.
Pohearts is offline
qiuhaian
Senior Member
Join Date: Nov 2009
Old 03-10-2015 , 06:12   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #19

wish you to update it ,man

Last edited by qiuhaian; 03-10-2015 at 06:13.
qiuhaian is offline
shadowdragon
Senior Member
Join Date: Dec 2012
Old 04-04-2015 , 09:35   Re: [CSGO] SRank - a csgo ranking system
Reply With Quote #20

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
__________________
Sorry for my poor English!
________________________________
I can do CSS/CSGO plugin request for little money!
shadowdragon is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:00.


Powered by vBulletin®
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Theme made by Freecode