SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts

Reply
 
Thread Tools Display Modes
Old 13/09/2012, 11:03 PM   #1
R@f
Huge Clucker
 
Join Date: Aug 2007
Posts: 364
Reputation: 225
Default [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

RStats - Detailed player stats for SA-MP

ABOUT
RStats is a free project (SA-MP Filterscript and Web interface) for SA-MP which allows you to get detailled statistics from your players and keeps a history of it. With the well designed database of RStats you can extract a lot of information about players (time they spend each day on the server for example), use your imagination

Main features
  • Detailled players stats (connects, disonnects, spawns, vehicle usage, kills, deaths, etc.).
  • Well designed database.
  • Player stat dialog box.
  • Random stats messages.
  • Awesome web interface coming soon !

Information
I'm currently working on a V2 (complete rewrite), please don't use this version, it's old and unsecure.
The web interface is still in developement, but you can use the filterscript and collect stats to use for the coming panel.
Important : It's just a stats filterscript and not a register/login one ! The accounts are not protected, use another system for that.

Author
This project was developped by Rafael 'R@f' Keramidas <rafael [AT] keramid [DOT] as>.

Donations
If you like this project or make a commercial use for it, please donate via paypal at rafael.keramidas [AT] gmail [DOT] com. Of course you don't have to but it would be nice if you do

Credits/Thanks
BlueG : For his MySQL Plugin.

LICENCE
This project is released under GPLv3. Read the GPLv3.txt for more information.

DOWNLOAD
You can get the project on Github : http://roflc.at/8z

How to download the zip archive ?
Take a look at this screenshot : http://rafael.keramid.as/rpanel/howtodl.png

REQUIRED (SA-MP)
REQUIRED (Web Server)
  • Coming

INSTALL (SA-MP)
1. Create the tables using the SQL Code located in the "SQL" folder.
2. Get the Filterscript located in the "Filterscript" folder and place it where you want.
3. Change the MySQL Credentials and ajust the settings like you want and compile it.
4. Use it !

INSTALL (Web)
Coming

COMMANDS (SA-MP)
/mystats : Shows your own stats.
/stats [playerid] : Shows the stats of a given player ID.

SCREENSHOT
SA-MP
http://i.imgur.com/KIBDL.jpg

Web
None

DATABASE
A view on the MySQL Database design :


SUPPORT
I don't give ANY support for the installation or usage of this script, so please don't contact me for that !!
If you found a bug, write me at rafael [AT] keramid [DOT] as and don't forget to put "RStats" in the subject.

CHANGELOG
V1.0 - 13th September 2012
  • Initial release of the Filterscript.

TODO
V1.1
  • (SA-MP) Add date related stats (date with the most timeouts for example).
  • (Web) Release the web interface



Enjoy

Last edited by R@f; 06/03/2014 at 08:42 AM.
R@f is offline   Reply With Quote
Old 13/09/2012, 11:16 PM   #2
EliteDrive
Big Clucker
 
Join Date: Jul 2012
Posts: 126
Reputation: 10
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Very nice good job man!
EliteDrive is offline   Reply With Quote
Old 13/09/2012, 11:55 PM   #3
CeLo Jeaam
Little Clucker
 
Join Date: Mar 2012
Posts: 26
Reputation: 0
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

nice
CeLo Jeaam is offline   Reply With Quote
Old 14/09/2012, 12:26 AM   #4
jpeg
High-roller
 
jpeg's Avatar
 
Join Date: Jul 2012
Posts: 1,050
Reputation: 34
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Very Nice!
__________________
jpeg is offline   Reply With Quote
Old 14/09/2012, 12:39 AM   #5
Ricop522
High-roller
 
Ricop522's Avatar
 
Join Date: Feb 2010
Location: ES
Posts: 2,658
Reputation: 159
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

playerid under rstats_chatmessage?
why not the name?
__________________
"Any fool can write code that a
computer can understand. Good
programmers write code that
humans can understand."

AJUDA! Programação
Github
Ricop522 is offline   Reply With Quote
Old 14/09/2012, 09:03 AM   #6
R@f
Huge Clucker
 
Join Date: Aug 2007
Posts: 364
Reputation: 225
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Quote:
Originally Posted by Ricop522 View Post
playerid under rstats_chatmessage?
why not the name?
Playerid (foreign key) is used in every other table because it's a normalized database (http://en.wikipedia.org/wiki/Database_normalization). If you want to get the username and the message in the same query you have to do a SQL Join, like this (didn't tried it). :
Code:
SELECT u.username AS username, c.chatmsg AS message FROM rstats_chatmessages INNER JOIN rstats_users u ON u.userid = c.playerid WHERE u.username = 1;
---

Thanks for the comments.
R@f is offline   Reply With Quote
Old 14/09/2012, 10:41 AM   #7
CeLo Jeaam
Little Clucker
 
Join Date: Mar 2012
Posts: 26
Reputation: 0
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Grab em home server?
Because it's always in FilterScript bug. -.
CeLo Jeaam is offline   Reply With Quote
Old 29/09/2012, 01:52 PM   #8
Mr.Faqahat
Huge Clucker
 
Join Date: Nov 2011
Location: Île-de-France
Posts: 353
Reputation: 29
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Very nice can you put a sample picture of web
Mr.Faqahat is offline   Reply With Quote
Old 29/09/2012, 02:02 PM   #9
M3mPHi$_S3
Gangsta
 
M3mPHi$_S3's Avatar
 
Join Date: Jun 2012
Location: Quetta, pk
Posts: 650
Reputation: 35
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

That's realy nice. Forsure i will use it
__________________
~Stats|" Fully ACtive now "~
~********|" мυ∂υℓ ******** "~
~Tutorial|" How to port forword [PICS & VEDIOS] "~

Code:
public OnPlayerAskHelp(playerid, help[])
{
    SetReplyForPlayer(playerid, I Wont Help you :D ");
[/CENTER]
M3mPHi$_S3 is offline   Reply With Quote
Old 08/10/2012, 05:57 PM   #10
Edvin
Gangsta
 
Edvin's Avatar
 
Join Date: Dec 2010
Posts: 867
Reputation: 71
Default Re: [FS/PHP/MySQL]RStats - Detailed player stats for SA-MP

Another nice project
Edvin is offline   Reply With Quote
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Tool/Web/Other] [PHP/MySQL] Powerup Stats - Player stats signature generator kelvin22 Tools and Files 43 21/06/2013 12:15 AM
Mysql Stats SanAndreasVille Scripting Help 0 21/04/2012 03:37 PM
Help with player stats Face9000 Scripting Help 4 07/02/2012 01:05 PM
player stats thomas.. Help Archive 3 04/10/2010 04:10 PM
[FilterScript] [FS] Player Stats v.1.0 Eragon Filterscripts 13 22/12/2009 02:03 AM


All times are GMT. The time now is 10:50 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.