Seems either i'm doing something wrong or new version doesn't do this?
New version seems to not be removing members who are no longer in the guild?
I removed someone from the guild last night, saved the guild but it's not removing them from the roster.

anyone?

This happens for very few people and hopfully will be fixed in 1.7.1

If I can remember correctly, you need to edit lib/wowdb.php
Find

Code: Select all

        $querystr = "SELECT `member_id`, `name` FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = '$guild_id' AND `update_time` < '".
            $date['year'].'-'.$date['mon'].'-'.$date['mday'].' '.$date['hours'].':'.$date['minutes'].':00'."'"; 

Change to

Code: Select all

        $querystr = "SELECT `member_id`, `name` FROM `".ROSTER_MEMBERSTABLE."` WHERE `guild_id` = '$guild_id' AND `update_time`<> '".
            $date['year'].'-'.$date['mon'].'-'.$date['mday'].' '.$date['hours'].':'.$date['minutes'].':00'."'"; 

Just wanted to say thank you for this post. We recently moved to a new host and for some reason on the new host we were having this behavior. On the old host it worked fine.

This fix works like a charm.