[thresh0ld]

Originally Posted by foquaxticity 13:43:13 CREATE FUNCTION IF NOT EXISTS `APPLY_MODIFIER`( `name` VARCHAR(50), `value` INT ) RETURNS double BEGIN DECLARE modifier FLOAT; SELECT s.modifier INTO modifier FROM STATS_SKILLS s WHERE s.name = name; IF modifier IS NULL THEN SELECT 1.0 INTO modifier; END IF; RETURN value * modifier; END Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `APPLY_MODIFIER`( `name` VARCHAR(50), `value` INT ) RETURNS doub' at line 1 0.000 sec (i just copied error row) Underlines: CREATE FUNCTION IF NOT EXISTS and CREATE VIEW IF NOT EXISTS I've never used mysql in my life, i don't even know whats what. Using tutorials got this far: https://imgur.com/a/BB0HrB0 Mysql version is 8.0.17

You are using an older version of mysql which does not support some of the special keywords on the create statement. Remove "IF NOT EXISTS" and try running it again.

e.g.

CREATE FUNCTION IF NOT EXISTS `APPLY_MODIFIER`......

will become

CREATE FUNCTION `APPLY_MODIFIER`........

[BeliyKrol]

Hi,

I have problems with dropping .sql file in phpMyAdmin mysql
I have Server version: 5.7.24-27 - Percona Server (GPL), Release 27, Revision bd42700 last one

Maybe your's .sql files are not updated? What I can do




But with the problem like other guy. Please can you write me in discord? I can pay you if you can install me it with PayPal.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `APPLY_MODIFIER`(
`name` VARCHAR(50),
`value` INT
) RETURNS d' at line 1




My discord: Белый Кроль#7638

Thank you

[Raikage]

Can you make for left 4 dead 1?

Originally Posted by thresh0ld Features Note: This is still in alpha, which means anything can be added, changed or removed at a later point in time. Records statistics gathered from human players and saves it to a database. Stats are displayed in-game to the player via a Menu/Panel interface. (No web frontend for stats, yet) Survivors Kils - Number of times an infected has killed a survivor Survivors Incapped - Number of times an infected player has incapped a survivor Infected Kills - Number of times a survivor player has killed a Special Infected (Commons not counted) Infected Headshots - Number of times a survivor killed a Special Infected by Headshot Hunter Skeets (Sniper) - Number of hunters skeeted with sniper by a survivor Hunter Skeets (SG) - Number of hunters skeeted with shotgun by a survivor Hunter Skeets (Melee) - Number of hunters skeeted with melee by a survivor Tank Rock Skeets - Number rocks skeeted by a survivor Witch Crown (Standard) - Number of standard witch crowns by a survivor (up close) Witch Crown (Draw) - Number of witch draw crowns by a survivor (chip from a distance and kill up-close) Boomer Pops - Number of boomer pops by a survivor Charger Levels - Number of chargers leveled by a survivor Smoker Tongue Cuts - Number of smoker tongues cut by a survivor Hunter Deadstops - Number of hunter deadstops by a survivor Quad Booms - Number of times survivors have been quad boomed (all 4 boomed) 25 Hunter Pounces - Number of 25 point hunter pounces Death Charges - Number of times a charger has death charged a survivor Tank Rock Hits - Number of times a tank rocked a survivor A customizable connect announce feature. Allows you to display current ranking/steam id/total points of the player. This feature also supports colour coded messages. A display panel showing the player statistics of a user. This can be triggered by issuing sm_rank on the console or by typing !rank in chat. A display panel showing additional stats such as skeets, levels, boomer pops etc. (disabled by default) A display panel showing the top N players sorted by their ranking. This feature also allows the the requesting player to be able to view other player's statistics/ranking on the server. A display panel showing the ranks of the players currently present in the server. Each can be selected and preview their details. A basic points and rankings system is also implemented and can be further customized by modifying the point multipliers from the plugin configuration file (playerstats.cfg) Requirements A working database system (Mysql/Mariadb 8.0 above) skill_detect plugin. This is only required if you need the extra statistics enabled SourceMod version 1.7 above ConVars pstats_enabled - Enable/Disable this plugin pstats_debug_enabled - Enable/Disable debug messages pstats_versus_exclusive - If set, the plugin will only work for versus gamemodes pstats_record_bots - Sets whether we should record bots. By default only human players are recorded. pstats_menu_timeout - The timeout value for the player stats panel pstats_max_top_players - The max top N players to display pstats_extras_enabled - Include extra stats to be recorded pstats_display_type - 1 = Display points, 2 = Display the count, 3 = Both points and count pstats_show_rank_onjoin - If set, player rank will be displayed to the user on the start of each map pstats_cannounce_enabled - If set, connect announce will be displayed to chat when a player joins Commands sm_rank - Display the current stats & ranking of the requesting player. A panel will be displayed to the player. sm_top - Display the top N players. A menu panel will be displayed to the requesting player sm_ranks - Display the ranks of the players currently playing in the server. A menu panel will be displayed to the requesting player. sm_pstats_reload - Reloads plugin configuration. This is useful if you have modified the playerstats.cfg file. This command also synchronizes the modifier values set from the configuration file to the database (This is done by passing 'sync' as an argument) sm_pstats_wipe - Reset a player record (all stats set to 0) sm_hidestats - This will hide player's the extra stats from public view (except if the viewing user is an admin) Change Log 1.0.1-alpha - 6/4/2019 - Bug Fix: Extra stats item from player rank panel does not execute when selected - Bug Fix: Error 'Client index is invalid' thrown during player initialization - Verify if steamid is valid for ShowInGamePlayerRanks - Bug Fix: Views in the database were hardcoded to query from 'playerstats' database. This will not work for those who use a different database name. - Added console command 'sm_hidestats'. Allow players to hide their extra stats from others. - Bug Fix: Fixed wrong parameter count for Notify(). 1.0.0-alpha - 6/1/2019 - Initial Release External Resources GitHub Page (How to Install) - To get the latest updates and for more detailed information about this plugin. Any suggestions to improve the plugin are always welcome

[ajaixal11]

i got this error

[l4d2_simpleplayerstats.smx] [ERROR] TQ_ShowPlayerRankPanel :: Query failed (Reason: Table 'np2_3eab02c93793xxxx.STATS_VW_PLAYER_RANKS' doesn't exist)

how do i fix this?

Iam Already Import that But Still Getting Only STATS_SKILLS and STATS_PLAYERS

[Toffo]

good morning.

The multiplier does not take into account for the extra stats

"survivor_killed" "8"
"survivor_incapped" "4"
"infected_killed" "1"
"infected_headshot" "2"
"skeet_hunter_sniper" "8"
"skeet_hunter_shotgun" "4"
"skeet_hunter_melee" "5"
"skeet_tank_rock" "2"
"witch_crown_standard" "3"
"witch_crown_draw" "5"
"boomer_pop" "3"
"charger_level" "5"
"smoker_tongue_cut" "3"
"hunter_dead_stop" "1"
"boomer_quad" "3"
"hunter_twenty_five" "10"
"death_charge" "10"
"tank_rock_hits" "4"

Only work with:
"survivor_killed" "8"
"survivor_incapped" "4"
"infected_killed" "1"
"infected_headshot" "2"

Sorry my english.

[GoGetSomeSleep]

[RDiver]

Originally Posted by BeliyKrol Hi, I have problems with dropping .sql file in phpMyAdmin mysql I have Server version: 5.7.24-27 - Percona Server (GPL), Release 27, Revision bd42700 last one Maybe your's .sql files are not updated? What I can do But with the problem like other guy. Please can you write me in discord? I can pay you if you can install me it with PayPal. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `APPLY_MODIFIER`( `name` VARCHAR(50), `value` INT ) RETURNS d' at line 1 My discord: Белый Кроль#7638 Thank you

Same issue right here. How to fix this so far to make this plugin works?

[Denizsunar62]

hi, i want to use this on my server. I saved everything in mysql. but when I enter the game and type !rank, the rank information does not appear. I wrote some cvar but it still didn't work. Can you help. Sorry for my bad english

[nidzo]

Hello.
First of all thank you for developing this addon!

I have installed it to my L4D2 Server, but when I list the addons with "sm plug list" I get the following:

4d2_srs.smx: Unable to load plugin (unsupported feature set; code is too new)

as well as

 03 <Bad Load> l4d2_srs.smx

I have installed and configured the database according to the instructions on https://github.com/sourcemod-plugins/l4d2-player-stats.

The source mod version is:

SourceMod Version Information:
    SourceMod Version: 1.10.0.6497
    SourcePawn Engine: 1.10.0.6497, jit-x86 (build 1.10.0.6497)
    SourcePawn API: v1 = 5, v2 = 12
    Compiled on: Sep 24 2020 19:39:13
    Built from: https://github.com/alliedmodders/sourcemod/commit/39c2dc6
    Build ID: 6497:39c2dc6
    http://www.sourcemod.net/

And the metamod version is:

 Metamod:Source Version Information
    Metamod:Source version 1.11.0-dev+1143
    Plugin interface version: 16:14
    SourceHook version: 5:5
    Loaded As: Valve Server Plugin
    Compiled on: Aug 19 2020 14:56:50
    Built from: https://github.com/alliedmodders/metamod-source/commit/b8d1fd4
    Build ID: 1143:b8d1fd4
    http://www.metamodsource.net/

Could someone be kind to help me with this problem as I want to be able to use stats on my server. Thank you in advance.

[GoGetSomeSleep]

can anybody add
if player away for 3 months purge his data?

and
plugins using too much mysql / mariadb so cpu %100