[pRED*]

I hereby present my work of art (just don't look at the source code), CS Ranks extension.

I'm currently looking for people to do some beta testing. Attached is a zip file containing everything you need (unzip into your sourcemod directory) and then read the readme.txt for config instructions etc.

Please let me know on irc or by PM if you're going to give it a go and please be prepared to at least provide error logs of any problems you incur so I can have a decent go at fixing them.

I have both windows (fairly well tested) and linux (never tried it) compiles in the zip

Anyway Details Stuff:

Supports saving using a SQL database (MySQL only currently, looking for help to write the equivalent SQLite queries) and flat file saving mode.

Flat File Mode: Limited stats recording due to the crapness of flat files.
SQL: Threaded SQL queries so pretty much everything I could think of.

Has options to import from mani file "mani_stats.dat" and "mani_stats.txt". More details included in the readme file

Credits:

BAILOPAN: Lots of help with stupid c++ questions. Yeah I'm sorry. I try, I really do..
Oh and guess I can't really forget the small details.. like writing sourcemod, adding features I needed and painstakingly explaining them to me.
teame06: Spent ages talking a complete idiot through installing and preparing MSVC. And lots of other questions.
anders: Helping me with ideas, the ELO ranking formula and wrote all the MySQL Queries
EKS: Helping me steal code from BAT every step of the way
Other People: Austin, noobcannonlol, PimpinJuice and everyone else who idles #sourcemod and has been unthoughtfully forgotten by me.

Screenshots:


sm_rank command (File Mode):[IMG]http://img407.**************/img407/2817/dedust0000xa7.jpg[/IMG]

sm_session command (only available in SQL mode)[IMG]http://img76.**************/img76/9384/dedust0001wo6.jpg[/IMG]

sm_top command (SQL Mode)[IMG]http://img62.**************/img62/3747/dedust0002ab7.jpg[/IMG]

Oh and sourcecode is available here if you want to rip my terrible c++ to shreds (or check the SQL queries, hint hint)

[dubbeh]

Nice work pred

I'll see how everyone is about setting this up on the yegods dedi box

[Peoples Army]

i 2nd that . ill add it to my server later .

[S1acker]

I'll give it a go later. I like the idea of it storing in SQL, easy to migrate it on my site since I know quite a bit of PHP.

[pRED*]

If you want to write a publicly available php page for this it'd be awesome..

[GriMz]

yeah, would be very much appreciated

thanks for the ranks extension pred, keep up the good work.

if we had a publically available php page this would be the , especially the hit box stuff with different weopons.

[pRED*]

Theres currently no weapon data being recorded. I'm trying to figure out a way to add this, and at the same time make it not cs specific.

I guess the best thing to do will be make sql fields called 'weapon1' 'weapon2' etc, and depending on which mod you're running will decide what gun that refers to.

[Nican]

pRED, are you planning on having a web interface?

[pRED*]

Depends what you mean by that? I'd like to have web interface yes. I don't really think I know enough php to make a decent one

[Nican]

I think I can help you in that area...
I know PHP, Mysql, CSS, HTML, Javascript... Well you know what I can do, I belive you seen/use sm.nican132.com

Where can I get the Mysql table structure? (with some data in it, please )