[thresh0ld]

Originally Posted by zaviier I reupload the image, please re-check

Can you run this instead and get back to me with the results:

select last_known_alias, survivor_killed, survivor_incapped, infected_killed, infected_headshot, total_points, rank_num from STATS_VW_PLAYER_RANKS s LIMIT 10

I need to see the stats and rank

[zaviier]

Originally Posted by thresh0ld Can you run this instead and get back to me with the results: select last_known_alias, survivor_killed, survivor_incapped, infected_killed, infected_headshot, total_points, rank_num from STATS_VW_PLAYER_RANKS s LIMIT 10 I need to see the stats and rank

here the result

[login101]

Do I need to connect myquery to use this?

[login101]

Does it work on coop?

[login101]

The plugin is loaded but no statistics are available.

[thresh0ld]

Originally Posted by login101 The plugin is loaded but no statistics are available.

What do you mean exactly? Are you saying that you are able to access the menu, but statistics are not getting recorded when you kill SI? For coop, you need to set pstats_record_bots to 1

[login101]

Originally Posted by thresh0ld What do you mean exactly? Are you saying that you are able to access the menu, but statistics are not getting recorded when you kill SI? For coop, you need to set pstats_record_bots to 1

I loaded the plug-in.
pstats_record_bots 1 Configured
in a chat
!Rank
I typed it in.

No response


I am not good at English.

I'm so sorry.

[thresh0ld]

Originally Posted by login101 I loaded the plug-in. pstats_record_bots 1 Configured in a chat !Rank I typed it in. No response I am not good at English. I'm so sorry.

Ok, if you typed !rank and the panel did not show, it is possible that the plugin did not load successfully. The reasons could be any of the following:

• The plugin was unable to connect to the database (Refer to the readme page here on how to configure/install)
• playerstats.cfg is missing or plugin failed to parse due to a syntax error

If you are sure it loaded successfully and the panel still does not show, verify that pstats_enabled is set to 1.

Also, check the error logs.

[login101]

Originally Posted by thresh0ld Ok, if you typed !rank and the panel did not show, it is possible that the plugin did not load successfully. The reasons could be any of the following: aaa thank you ! I'll write the plugin well! The plugin was unable to connect to the database (Refer to the readme page here on how to configure/install) playerstats.cfg is missing or plugin failed to parse due to a syntax error If you are sure it loaded successfully and the panel still does not show, verify that pstats_enabled is set to 1. Also, check the error logs.

thank you ! I'll write the plugin well!

[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