It seems there is no handling for cross-faction guilds when displayed. They still hold their faction color. I'd say this red/blue coloring is perfectly fine for players shown on the stats page, but for guilds it doesn't make much sense.

Hi @FrancescoBorzi & @Helias
Please creat new project and help to update(tops pvp/pve) web.
I think it's very good and very popular!

INFORMATIONS:
The project web tops pvp and pve is for azerothcore and trinitycore last,rev 3.3.5

Ready items: (worked)
top player Achievements
top killers
top arena points
top honor points
top arena teams
top player play time

Need items: (upgrade)
top guilds = is ready but don't work listed to ranked!
top player by item level gear scoure /gs = not found, need to added
top player duel / winers = not found, need to added
top player golds = not found, need to added

On AzerothCore, relevant statistics are logged in log_arena_fights, and log_arena_memberstats, not sure about other cores. Would it be possible to extend the functionality of this repo to arenas as well?

Where guild tops should be shown, only a querry error is displayed

Error querying: SELECT guild.name, COUNT(guild.name), guild.guildid FROM pvpstats_players INNER JOIN pvpstats_battlegrounds ON pvpstats_players.battleground_id = pvpstats_battlegrounds.id INNER JOIN guild_member ON guild_member.guid = pvpstats_players.character_guid INNER JOIN guild ON guild_member.guildid = guild.guildid INNER JOIN characters ON pvpstats_players.character_guid = characters.guid WHERE characters.deleteDate IS NULL AND pvpstats_players.winner = 1 GROUP BY guild.name ORDER BY COUNT(guild.name) DESC LIMIT 0, 100

An Undead Priest's name does not have his name appear on PvPStats, presumably because his character has been deleted.

PvPStats BG link: https://chromiecraft.com/apps/pvpstats/battleground.php?id=51559

After config change this is what it displays in Firefox. Maybe tables names changed or because my pvpstats tables are empty. Not sure why I get this message... :(

 Error querying: SELECT COUNT(*) FROM pvpstats_battlegrounds WHERE winner_faction = 1 AND DATE(date) = DATE(NOW()) UNION SELECT COUNT(*) FROM pvpstats_battlegrounds WHERE winner_faction = 0 AND DATE(date) = DATE(NOW()) ;

Thanks for your work... :)

Hey there!

I'd like to report a security issue but cannot find contact instructions on your repository.

If not a hassle, might you kindly add a SECURITY.md file with an email, or another contact method? GitHub recommends this best practice to ensure security issues are responsibly disclosed, and it would serve as a simple instruction for security researchers in the future.

Thank you for your consideration, and I look forward to hearing from you!

(cc @huntr-helper)

project can updated to this items?

top player Achievements
top killers
top arena points
top honor points
top arena teams
top player golds
top player duel / winers
top player play time
top player by item level gear scoure /gs

Hi
needed to fixed slow page loadings!

Missing column in Cmangos tbc how to fix it ty

Hi

Pvpstats is just for A realm or Multiple realm ?!
And how to change port mysql!? not found in the cfg!