Longest time between sightings

Suggestions for WarcraftRealms.com
Post Reply
superxdude
Census Taker
Posts: 76
Joined: Tue Nov 18, 2008 10:14 am
Location: Hawaii

Longest time between sightings

Post by superxdude »

Strange idea here, and perhaps utterly useless, but...

Perhaps on a toon's individual page, perhaps a note with their longest absence in sightings?

User avatar
bringoutyourdead
Forums Admin & general flunky
Posts: 1432
Joined: Fri Nov 07, 2008 1:11 pm
Location: Texas, USA

Post by bringoutyourdead »

I think I will leave that as an exercise for the class...
http://www.warcraftrealms.com/char/50529109

looks to me like more then five years.

However do be aware our data is not and never will be complete.
When we discovered the Cyrillic data being improperly stored into the database that was not prepared, Metalbeast decided to shrink the table size by removing all low level (<40) records except for Battleground twink levels.

While recognizing shrinking the character table by about 40% did help speed up the clean out and complete rebuild, I was very unhappy, and I let Metalbeast know that fact.

The continued process of purging the on site character history by only retaining the *0 and *5 levels remains a irritant to me, but I have to admit I understand the concerns.
We currently have almost 300 million character history records... without the purge that number would probably be in the range of 2 billion records.

After all there are only two reasons this site is even looked at by people interested in World of Warcraft:
First we are the only site that reports actual in game sightings (via /who) of characters, the other sites use web page scraping to find character in the armory and guild lists.
Second we provided fairly accurate history of the characters we find via census rums. Guild masters and others could check our site to see if there was activity on a character that might not be good for the guild.

superxdude
Census Taker
Posts: 76
Joined: Tue Nov 18, 2008 10:14 am
Location: Hawaii

Post by superxdude »

Unfortunately that toon will never be coming back...I was an idiot and botted. I got caught and banned.

Perhaps I can reword my idea though...longest time between sightings. Thats what I think I meant earlier but did not explain it clearly.

Probably not enough coffee when I posted that.

superxdude
Census Taker
Posts: 76
Joined: Tue Nov 18, 2008 10:14 am
Location: Hawaii

Post by superxdude »

Have not uploaded alot since I last read this...reason is we seem to be wasting time scanning 20-110 if only the 5/0 levels are being saved.

If the addon can be updated to reflect this, i'll keep uploading but otherwise it seems like a lost cause.

User avatar
bringoutyourdead
Forums Admin & general flunky
Posts: 1432
Joined: Fri Nov 07, 2008 1:11 pm
Location: Texas, USA

Post by bringoutyourdead »

I would agree with you... which is why I have prevailed upon Metalbeast to stop using that procedure.. which was manual anyway.

If you look at characters from active playing uploaders, you will see that the 5/0 level purge stopped some time ago.

As noted.. hmm. I forget where... I will edit this message with a pointer to that thread.

Edit: see 2nd message of thread http://www.warcraftrealms.com/forum/vie ... ght=#42266

I forget what the date was for the last 5/0 process but I think it was early 2014.
Edit2: make that early 2015, based upon one of my posts.

Post Reply