Mixup between roster upload and last online timestamps

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

Mixup between roster upload and last online timestamps

Postby Fangorn » Mon Aug 28, 2006 2:48 pm

Hello all you sexy people!

I reported that on the old boards shortly before it went kaboom and I'm not sure it was taken into account. It might have been reported again since then but I don't know so I'll let you sort through it ;)

That's a pretty weird bug if you ask me:
When you update the guild roster at, say, 8:45, the minutes part of all guild members in the last online field is updated to 45 as well. You can see it on my guild's roster:
http://wow.clan-blackstar.org/Content/wow/roster/

Note the last updated time and compare with the minutes value for the "last online" field of all guild members: it's the same (well there can be a one minute difference if you make the update over the minute change, and if members update the roster with their character information it will be modified as well of course).

Thanks,


- Fang
Last edited by Fangorn on Mon Aug 28, 2006 2:49 pm, edited 1 time in total.
User avatar
Fangorn
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Mon Jul 24, 2006 4:26 am
Location: Ashburn, Virginia, USA

Mixup between roster upload and last online timestamps

Postby zanix » Tue Aug 29, 2006 11:21 am

Weird indeed

Were these members online when you quit wow?
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Mixup between roster upload and last online timestamps

Postby Fangorn » Thu Aug 31, 2006 3:30 pm

No, it updates the minutes of every character in the guild. Am I the only one experiencing this?
User avatar
Fangorn
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Mon Jul 24, 2006 4:26 am
Location: Ashburn, Virginia, USA

Mixup between roster upload and last online timestamps

Postby zanix » Thu Aug 31, 2006 4:06 pm

Perhaps...
Gonna have to take a deeper look into this
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Mixup between roster upload and last online timestamps

Postby zanix » Sun Sep 17, 2006 7:11 am

I think I fixed this in SVN
Gonna have to see if it works correctly or not
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Mixup between roster upload and last online timestamps

Postby datagears » Thu Oct 05, 2006 11:07 pm

I am having a similar issue.

Ok stupid noob question. How do I get ahold of the files that are different from the CVS. I have severl issues like that the roster diag says have changed .. how can i download updates?
datagears
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Mon Jul 10, 2006 10:44 pm

Mixup between roster upload and last online timestamps

Postby zanix » Fri Oct 06, 2006 12:44 am

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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Mixup between roster upload and last online timestamps

Postby vgjunkie » Fri Oct 06, 2006 12:49 am

I noticed this when I was doing my own hacks to the roster (to make it public). I"m trying to remember what exactly I changed in the wowdb.php file (and what caused this problem).

I want to say that in the update_guild_member function where you had:

Code: Select all

                        $this
->add_value'online'0);
                        
$lastOnline $char['LastOnline'];
                        
$lastOnlineYears intval($lastOnline['Year']);
                        
$lastOnlineMonths intval($lastOnline['Month']);
                        
$lastOnlineDays intval($lastOnline['Day']);
                        
$lastOnlineHours intval($lastOnline['Hour']);
                        
# use strtotime instead
                        #      $lastOnlineTime = $currentTimestamp - 365 * 24* 60 * 60 * $lastOnlineYears
                        #                        - 30 * 24 * 60 * 60 * $lastOnlineMonths
                        #                        - 24 * 60 * 60 * $lastOnlineDays
                        #                        - 60 * 60 * $lastOnlineHours;
                        
$timeString '-';
                        if (
$lastOnlineYears 0)
                                
$timeString .= $lastOnlineYears.' Years ';
                        if (
$lastOnlineMonths 0)
                                
$timeString .= $lastOnlineMonths.' Months ';
                        if (
$lastOnlineDays 0)
                                
$timeString .= $lastOnlineDays.' Days ';
                        if (
$lastOnlineHours 0)
                                
$timeString .= $lastOnlineHours.' Hours ';

                        
$lastOnlineTime strtotime($timeString,$currentTimestamp);
                        
$this->add_time'last_online'getDate($lastOnlineTime));

 


I changed it to:

Code: Select all

                        $this
->add_value'online'0);

                        
// If we can't figure out the "LastOnline", set a bogus stamp up
                        
if(!is_array($char['LastOnline'])){
                        
// Assuming US dateStamp!  mm/dd/yy HH:mm:ss   Adjust below for your own dateStamp!
                        
$char['LastOnline']['Day'] = (date(d) - substr($char['DateUpdated'], 3,2));
                        
$char['LastOnline']['Month'] = (date(m) - substr($char['DateUpdated'], 0,2));
                        
$char['LastOnline']['Hour'] = (date(H) - substr($char['DateUpdated'], 9,2));
                        
$char['LastOnline']['Year'] = (date(y) - substr($char['DateUpdated'], 6,2));
                        }

                        
$lastOnline $char['LastOnline'];
                        
$lastOnlineYears intval($lastOnline['Year']);
                        
$lastOnlineMonths intval($lastOnline['Month']);
                        
$lastOnlineDays intval($lastOnline['Day']);
                        
$lastOnlineHours intval($lastOnline['Hour']);
                        
# use strtotime instead
                        #      $lastOnlineTime = $currentTimestamp - 365 * 24* 60 * 60 * $lastOnlineYears
                        #                        - 30 * 24 * 60 * 60 * $lastOnlineMonths
                        #                        - 24 * 60 * 60 * $lastOnlineDays
                        #                        - 60 * 60 * $lastOnlineHours;
                        
$timeString '-';
                        if (
$lastOnlineYears 0)
                                
$timeString .= $lastOnlineYears.' Years ';
                        if (
$lastOnlineMonths 0)
                                
$timeString .= $lastOnlineMonths.' Months ';
                        if (
$lastOnlineDays 0)
                                
$timeString .= $lastOnlineDays.' Days ';
                        if (
$lastOnlineHours 0)
                                
$timeString .= $lastOnlineHours.' Hours ';

                        
$lastOnlineTime strtotime($timeString,$currentTimestamp);

                        
// Not sure we need this, but if LastOnline is all Zeros, it will not create a stamp
                        
if(!$lastOnlineTime){
                        
$lastOnlineTime strtotime("0 Days",$currentTimestamp);
                        }

                        
$this->add_time'last_online'getDate($lastOnlineTime));

 


I might be thinking of an entirely different bug that I ran into, so ignore my ramblings if that is the case :)
User avatar
vgjunkie
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 30
Joined: Wed Aug 09, 2006 11:58 pm
Location: Brooklyn NY


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron