I had a member quit the guild, so I opened the roster and saved it. I uploaded my character with the admin password and the roster was updated. I checked the roster only to find that person still there.

I checked the CharacterProfiler.lua file and that character is not in it, so I repeated the process taking extra care at every step. Same result.

So I did some searching and found out that is is likely due to time of last update. Can some one explain how this time compaison works in a little more detail?

same issue plz tell me how to remove members!

Members are removed automatically when you update the guild. The problem is that somewhere the roster stores the last update date and time. It will then refuse any upload of the guild that is before that date.

I am having problems with it being confused. Say Monday Joe Leaves the Guild, so I log into WOW, export the guild info, exit the game, and upload to the roster. Unfortunately the roster doesn't delete this person. Eventually, sometimes as much as a day or two later it will with subsequent uploads.

What I need to know is where are the dates stored so that I can begin troubleshooting this problem.

Same issue for me too >_<

Not sure if others had to do this or even if this is right but I adjusted the memberslist.php file in order to check for that update_time. That made the folks drop off.

Here's what I did.

[Find]
$guildFaction = $guild_info['faction'];

[Add after]
$guildLastUpdate = $guild_info['update_time'];

[Find]
"LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' ".

[Replace with]
"LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' where members.update_time = '" . $guildLastUpdate . "' ".

What I would like to know is where are the dates stored in both the roster and the update file. Where are they being compared so that I can troubleshoot the problem I am having with the updates.

In lib/wowdb.php

Try changing this

Code: Select all

    function remove_guild_members($guild_id, $date)
    {
        $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'."'"; 

To this

Code: Select all

    function remove_guild_members($guild_id, $date)
    {
        $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'."'"; 

I am having the same problem, and have been for a week now. When will this be fixed?

carpenoctem wrote:I am having the same problem, and have been for a week now. When will this be fixed?

Did you even read the above suggestions and try them?