Guild Update Delete

Data Accuracy issues

Guild Update Delete

Postby darkgoth » Wed Jul 05, 2006 4:57 pm

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.
User avatar
darkgoth
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Jul 04, 2006 7:10 pm

Guild Update Delete

Postby darkgoth » Wed Jul 05, 2006 8:50 pm

anyone? :(
User avatar
darkgoth
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Jul 04, 2006 7:10 pm

Guild Update Delete

Postby zanix » Thu Jul 06, 2006 6:02 am

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'."'"
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: Guild Update Delete

Postby Scotia » Wed Sep 06, 2006 5:06 am

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.
Scotia
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Tue Jul 25, 2006 2:53 am


Return to Data Accuracy

Who is online

Users browsing this forum: No registered users and 0 guests