Raised This Month: $95 Target: $400
 23% 

Player Status in DB (sqlstats Lite)


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   Counter-Strike        Category:   Statistical        Approver:   Orangutanz (13)
+ARUKARI-
Senior Member
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 00:13   Player Status in DB (sqlstats Lite)
Reply With Quote #1

Player Status in DB (sqlstats Lite) v0.7

DESCRIPTION
  • This adds up the status of the player and writes in it at a database.
  • Update DB in Mapchange.(don't hang load to the server other than it.)
  • On your homepage, please use ranking to displaying it.
  • Using DBTable is "statustable" only at once.
ATTENTION
  • Supported AMXMODX 1.80 in Counter-Strike1.6 (I don't have CSCZ.)
  • I tested linux server on CS1.6+MySQL
  • Require Module: MySQL(SQLX),CSX
  • "[PSD] Error: Can`t connect: 'Access denied for user '[email protected]'localhost' (using password: NO)'"
    You don't make a database for a MySQL server. Or you don't set a password.
    Or an IP address or user name iswrong.
CREDIT
  • ripcurl2 : sqlstats
  • AmxxDevTeam: StatsX
USING
  • Install this plugin.
  • Install and Setting any servers (Web+PHP,MySQL,Amxx-sql.cfg)
  • Create database on the MySQL Server.(psd default "cstrike",amxx default "amx")
  • ex. rankpage upload on your homepage(need PHP).
INSTALL
  • Requare module "MySQL".
  • new install 0.3 or 0.5 : A normal installation.
  • new install 0.6 -- 0.7 : A normal installation.
  • update 0.3(0.5) -> 0.7 :
    Please delete statustable from a database.
    And please carry out "amx_psd_update" after installation.
SCREENSHOT
on my homepage.(Bots server tested)


UPDATED
  • 10.06.2008 v0.73
    add "amx_psd_initialize","amx_psd_reset"
    fix VALVE_ID_PENDING,STEAM_ID_LAN don't recording.
    fix can't update bug.
    known bug: initialize cmd is wrong..
  • 29.05.2008 v0.7 add command "amx_psd_update"
    synchronize csstats.dat and database.
  • 28.05.2008 v0.6
    I unify Windows version and Linux versions.
    Speedup of the access to the database.
    add a K/D rate field to a database table.
  • 25.04.2008 v0.5 fix connecting bug for windows.
  • 22.04.2008 v0.3 cut some "public"
  • 20.04.2008 v0.2 single quotation in name no write bug fix.
  • 19.04.2008 v0.1 first release.

Now Working
I Create New Ranking System on PHP. Now working test version.
And Next plan..
Code:
  • "amx_psd_reset" - reset in database. //Successful!
  • "amx_psd_initialize" - initialize csstats.dat//Now testing. but wrong this.
  • "amx_psd_uptime" - autoupdatetime (minutes,default "15")//I'm at a loss with an online user or all players. (online user mode successful)
  • Record of the online time. - //I'm at a loss whether I should implement it with 0.8 whether I should postpone it.
  • update every player (on the server) on round end, death//it's easy
Attached Files
File Type: sma Get Plugin or Get Source (psd_006.sma - 3867 views - 7.0 KB)
File Type: sma Get Plugin or Get Source (psd_007.sma - 3383 views - 7.4 KB)
File Type: sma Get Plugin or Get Source (psd_003_linux.sma - 2955 views - 4.8 KB)
File Type: zip ranking_phpfile_v2test.zip (5.6 KB, 4270 views)
File Type: sma Get Plugin or Get Source (psd_007-3.sma - 5226 views - 10.3 KB)
__________________
English is very very difficult!
Now working.

Player Status in DB v0.8 [ 91% ]
LaserMine Entity v3.0 [ 30% ]
- I'm very very busy in real life... i can't this job...

Last edited by +ARUKARI-; 07-12-2008 at 00:49. Reason: update 0.73
+ARUKARI- is offline
Alka
AMX Mod X Plugin Approver
Join Date: Dec 2006
Location: malloc(null)
Old 04-19-2008 , 03:33   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #2

Nice...gj
__________________
Still...lovin' . Connor noob! Hello
Alka is offline
NelegalJke
Member
Join Date: Mar 2008
Location: Ukraine
Old 04-19-2008 , 05:22   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #3

no bugs?
__________________
NelegalJke is offline
Send a message via ICQ to NelegalJke
+ARUKARI-
Senior Member
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 07:41   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #4

Alka:
Thanks

NelegalJke:
It is the intention.
However, it is impossible to know all.

I will think that I add some functions in future.
__________________
English is very very difficult!
Now working.

Player Status in DB v0.8 [ 91% ]
LaserMine Entity v3.0 [ 30% ]
- I'm very very busy in real life... i can't this job...
+ARUKARI- is offline
`666
AlliedModders Donor
Join Date: Jan 2006
Location: UK
Old 04-19-2008 , 08:08   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #5

any one tested on cz?
`666 is offline
+ARUKARI-
Senior Member
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 08:15   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #6

Quote:
Originally Posted by `666 View Post
any one tested on cz?
I don't have CZ.. tested CS1.6 only.
__________________
English is very very difficult!
Now working.

Player Status in DB v0.8 [ 91% ]
LaserMine Entity v3.0 [ 30% ]
- I'm very very busy in real life... i can't this job...
+ARUKARI- is offline
`666
AlliedModders Donor
Join Date: Jan 2006
Location: UK
Old 04-19-2008 , 08:20   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #7

I guess ill be 1st
`666 is offline
+ARUKARI-
Senior Member
Join Date: Jul 2004
Location: Japan
Old 04-19-2008 , 08:26   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #8

Quote:
Originally Posted by `666 View Post
I guess ill be 1st
oh thanks!
I wait for a good report.
__________________
English is very very difficult!
Now working.

Player Status in DB v0.8 [ 91% ]
LaserMine Entity v3.0 [ 30% ]
- I'm very very busy in real life... i can't this job...
+ARUKARI- is offline
DeuX
Member
Join Date: Apr 2008
Old 04-21-2008 , 05:22   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #9

I welcome!

Plugin good me liked, but for me problem!
Business in that as though correctly did everything, but for me does
not want will unite with the server of MySql!
What can a problem be in???

For me fashions AmxModX 1.80...

Tuning did everything, and writes me
"[PSD] Error: Can`t connect: 'Access denied for user '[email protected]'localhost' (using password: NO)'"

Did I adjust parameters in the file in cfg, in a script, and in what problem?
Help, because it is very desirable to put this plugin on the server!
DeuX is offline
+ARUKARI-
Senior Member
Join Date: Jul 2004
Location: Japan
Old 04-21-2008 , 06:56   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #10

DeuX:
did you create DB on mysql server?
and "localhost" doesn't work. try "127.0.0.1"

Code:
amx_sql_host "127.0.0.1" //NOT "localhost"!
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "dbname" //you create db on mysql server.
__________________
English is very very difficult!
Now working.

Player Status in DB v0.8 [ 91% ]
LaserMine Entity v3.0 [ 30% ]
- I'm very very busy in real life... i can't this job...
+ARUKARI- 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 01:58.


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