Is there away to remove counting Unguilded for "Guild that has suffered the most at our hands" & "Guild that has killed us the most" on the PVP stats box on the roster index page? Having it be that we have lost / won against unguilded individuals the most makes that particular stat meaningless.

I would also like a way to make this happen...

Is there a work-around for this?

This will be fixed in Roster 1.8

This edit assumes 'unguilded' is stored in the database as '' (blank or nothing)
If not, then you will need to change it in the database

Basically the SQL query is edited to disregard an empty guild name
We add `guild` != '' AND to the WHERE clause

Open pvplist.php for editing

Find Line 58

Code: Select all

    $query = "SELECT `guild`, COUNT(`guild`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC"; 

Replace with

Code: Select all

    $query = "SELECT `guild`, COUNT(`guild`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `guild` != '' AND `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC"; 

---

Find Line 83

Code: Select all

    $query = "SELECT `guild`, COUNT(`guild`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC"; 

Replace with

Code: Select all

    $query = "SELECT `guild`, COUNT(`guild`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `guild` != '' AND `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC"; 

---

Find Line 109

Code: Select all

    $query = "SELECT `name`, COUNT(`name`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC"; 

Replace with

Code: Select all

    $query = "SELECT `name`, COUNT(`name`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `guild` != '' AND `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC"; 

---

Find Line 130

Code: Select all

    $query = "SELECT `name`, COUNT(`name`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC"; 

Replace with

Code: Select all

    $query = "SELECT `name`, COUNT(`name`) AS countg FROM `".ROSTER_PVP2TABLE."` WHERE `guild` != '' AND `win` = '0' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC"; 

Zanix,
That worked like a dream!

Thanks!

No problem