AlliedModders
Page 1 of 15 1 2311 Last »
Show 40 post(s) from this thread on one page

AlliedModders (https://forums.alliedmods.net/index.php)
-   Approved Plugins (https://forums.alliedmods.net/forumdisplay.php?f=8)
-   -   Player Status in DB (https://forums.alliedmods.net/showthread.php?t=70140)

+ARUKARI- 04-18-2008 23:13
Player Status in DB
 
8 Attachment(s)
Player Status in DB v1.10

DESCRIPTION
  • This adds up the status of the player and writes in it at a database.
  • Update DB in RoundEnd, Mapchange, Client Connected/Disconnected.
  • On your homepage, please use ranking to displaying it.

INSTALL an USING
  • Require module MySQL,CSTRIKE,CSX,GEOIP.
  • Setup MySQL Server. (I will not explain here)
  • Install and Setting any servers (Web+PHP)
  • Check, addons/amxmodx/configs/sql.cfg
    Code:
    • amx_psd_sql_host        "127.0.0.1"        // MySQL server address.

    • amx_psd_sql_user        "root"                // MySQL login user.

    • amx_psd_sql_pass        "*****"                // MySQL login password.

    • amx_psd_sql_db        "amx"                // database name. (Please make it in advance.)

  • Install this plugin.
  • ex. rankpage upload on your homepage(need PHP).

CREDIT
  • ripcurl2 : sqlstats
  • AmxxDevTeam: StatsX

ATTENTION
  • Supported AMXMODX 1.90 in CS1.6
  • I tested linux server on CS1.6+MySQL
  • "[PSD] Error: Can`t connect: 'Access denied for user 'root@'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 is wrong.


UPDATED
Code:
  • 2021.02.01. v1.10
    Added: amx_psd_serverid
    Added: database cvars (amx_psd_sql_host/user/pass/db)
    Modify: Insert Query has Threaded.
    Fixed: player name escape.

  • 2020.12.10. v1.07
    Fixed: reset command not working.
    Fixed: ERROR: client_putinserver.
    Fixed: amx_psd_reset/amx_psd_update: not updating user table. (user name)
    Fixed: ERROR: for sql_mode=only_full_group_by.

  • 2020.04.18. v1.04
    Fixed: Can't CTs Win Count for Time up.

  • 17.04.2020 v1.03
    Fixed: Create Table SQL.

  • 2020.04.11. v1.02
    Fixed: online time bug.

  • 2020.04.06. v1.00
    Big UPDATE.
    Added Tables.
    • server_map

    • server_round

    • total_stats

    • user_info

    • user_objective

    • user_rstats

    • user_stats

    • user_wrstats

    • user_wstats


  • 2008.06.10. 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..

  • 2008.05.29. v0.7 add command "amx_psd_update"
    synchronize csstats.dat and database.

  • 2008.05.28. 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.

  • 2008.04.25. v0.5 fix connecting bug for windows.

  • 2008.04.22. v0.3 cut some "public"

  • 2008.04.20. v0.2 single quotation in name no write bug fix.

  • 2008.04.19. v0.1 first release.

v1.0 over Development on GitHub

Alka 04-19-2008 02:33
Re: Player Status in DB　(sqlstats Lite)
 
Nice...gj

NelegalJke 04-19-2008 04:22
Re: Player Status in DB　(sqlstats Lite)
 
no bugs? :)

+ARUKARI- 04-19-2008 06:41
Re: Player Status in DB　(sqlstats Lite)
 
Alka:
Thanks

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

I will think that I add some functions in future.

`666 04-19-2008 07:08
Re: Player Status in DB　(sqlstats Lite)
 
any one tested on cz?

+ARUKARI- 04-19-2008 07:15
Re: Player Status in DB　(sqlstats Lite)
 
Quote:
Originally Posted by `666 (Post 613523)
any one tested on cz?
I don't have CZ.. tested CS1.6 only.

`666 04-19-2008 07:20
Re: Player Status in DB　(sqlstats Lite)
 
I guess ill be 1st :)

+ARUKARI- 04-19-2008 07:26
Re: Player Status in DB　(sqlstats Lite)
 
Quote:
Originally Posted by `666 (Post 613529)
I guess ill be 1st :)
oh thanks!:mrgreen:
I wait for a good report.:wink:

DeuX 04-21-2008 04:22
Re: Player Status in DB　(sqlstats Lite)
 
I welcome!

Plugin good me liked, but for me problem! :up:
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??? :cry:

For me fashions AmxModX 1.80...

Tuning did everything, and writes me
:arrow: "[PSD] Error: Can`t connect: 'Access denied for user 'root@'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!

+ARUKARI- 04-21-2008 05:56
Re: Player Status in DB　(sqlstats Lite)
 
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.


All times are GMT -4. The time now is 02:31.
Page 1 of 15 1 2311 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.