Problems Updating Guild

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Problems Updating Guild

Postby carlpalmer » Fri Aug 04, 2006 12:30 am

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?
User avatar
carlpalmer
WR.net Apprentice
WR.net Apprentice
 
Posts: 24
Joined: Fri Jul 21, 2006 4:27 am

Problems Updating Guild

Postby Bright10 » Fri Aug 04, 2006 7:31 am

same issue plz tell me how to remove members!
Bright10
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Mon Jul 31, 2006 11:55 pm

Re: Problems Updating Guild

Postby carlpalmer » Fri Aug 04, 2006 5:29 pm

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.
Last edited by carlpalmer on Fri Aug 04, 2006 5:30 pm, edited 1 time in total.
User avatar
carlpalmer
WR.net Apprentice
WR.net Apprentice
 
Posts: 24
Joined: Fri Jul 21, 2006 4:27 am

Problems Updating Guild

Postby bratkat64 » Sat Aug 05, 2006 1:10 pm

Same issue for me too >_<
bratkat64
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Jul 25, 2006 7:53 pm

Problems Updating Guild

Postby Lirae » Sat Aug 05, 2006 11:46 pm

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 . "' ".
Lirae
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Sat Aug 05, 2006 7:56 pm

Re: Problems Updating Guild

Postby carlpalmer » Mon Aug 07, 2006 2:48 am

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.
User avatar
carlpalmer
WR.net Apprentice
WR.net Apprentice
 
Posts: 24
Joined: Fri Jul 21, 2006 4:27 am

Problems Updating Guild

Postby zanix » Mon Aug 07, 2006 3:17 am

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'."'"
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problems Updating Guild

Postby carpenoctem » Sat Oct 07, 2006 10:22 pm

I am having the same problem, and have been for a week now. When will this be fixed?
carpenoctem
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Aug 12, 2006 6:36 pm

Problems Updating Guild

Postby zanix » Sun Oct 08, 2006 3:59 am

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?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron