[Master53]

ZPS Ranking

Description
Hello and welcome to an actual zps plugin purposly build for zps. This plugin will keep track of almost all statistics you will ever need and want. Also this plugin contains the most common stats features plus extras.

Cvars
sm_sqltype - default = 1

Credits
All Credits go to MasterD + Sammy Rocks for general ideas gathering.

Commands
sm_rank - view your total:
sm_top - view the top person on the leaderboard
sm_top5 - view the top 5 people on the leaderboard
sm_top10 - view the top 10 people on the leaderboard
sm_session - view your session since you've connected.
sm_players/sm_playerList - list all the connected players ingame.

sm_rankinfo = view plugin infomation and details.

Notes
When Editing/Changing the sourcecode, there is a built in debug and fail state built into the code, so if you feel like editing or changing use the DEBUG to trace any errors.

Please report any bugs/glitches in the code.

Setting up SQL
When the ConVar "sm_sqltype" is set to 1 the plugin will automaticly create and connect to a local SQLite database, When "sm_sqltype" is set to 2 the plugin will use an external configeration folder which a MySQL or a custom SQLite database can be set up.

Pending Features
i will be adding a "Next" feature to view the next 10 ranks above you on the leaderboard.

How to install
Place the Plugin file (HeyRank.smx) into your sourcemod plugins folder (zps/addons/sourcemod/plugins).


Requires SDK Hooks 1.1 or later

[psychonic]

Buffers for sql-escaped strings need to be sized at least (2*x)-1, where x is the size of the original string. Otherwise, values can be cut off.

Ex., to escape a 32-byte string, you should use at least 63 for the size of the buffer that you write the escaped version to, to leave room for escape characters.

[Master53]

Originally Posted by psychonic Buffers for sql-escaped strings need to be sized at least (2*x)-1, where x is the size of the original string. Otherwise, values can be cut off. Ex., to escape a 32-byte string, you should use at least 63 for the size of the buffer that you write the escaped version to, to leave room for escape characters.

Okay, i will edit and update.

UPDATED.

[Master53]

Hum, Would it be much better if i used a threaded based sql saving/loading/querys for this?

[Shepard62700FR]

Headshots aren't counted