[Fixed] (Tournament) valuable items? (in General)

KittehShinobu May 26 2012 6:35 AM EDT

^_^' I like to make a point that this system is a little odd to me. A lot of the slots in the valuable items are cluttered with tournament based items, and not Normal In Game items. Is there a reason why this is so? =< I feel that I don't have something of a goal to look forward to having a valuable item when its clearly been cleaned out by tournament based characters. Is there a way to Isolate the most valuable items STRICTLY to in game characters that are not part of a tourny?

Zenai [Cult of the Valaraukar] May 26 2012 8:25 AM EDT

Nat has said this is a bug that they are trying to fix. Honestly I am with you on this, even if it has to be done manually I think T-Char rankings should be wiped from the system. Just my personal opinion though.

Quyen May 26 2012 9:12 AM EDT

if it was that easy though.. I suppose it will take a while for them to fix it :P

Zenai [Cult of the Valaraukar] May 26 2012 10:32 AM EDT

Just a Question to the Admins. No worries I am not trying to make more work for you! How difficult would it be to classify T-Chars in their own Realm?

AdminNemesia [Demonic Serenity] May 26 2012 11:58 AM EDT

They already are Zen.

Unappreciated Misnomer May 26 2012 12:06 PM EDT

but what I believe she is asking for isnt what you [fixed] its that the most valuable items are still showing T charter items which no regualr charater will attain at this moment. since Tchars are in their own realm can they be filtered out from the valuable items page?

Fishead May 26 2012 12:52 PM EDT

It's east to see the non tounament items sepatared from the tourney items. Click on the specific item you are looking at and you get a new list that excludes the tourney items.

Zenai [Cult of the Valaraukar] May 26 2012 1:01 PM EDT

Let me rephrase then Nat: How hard is it to separate the T-Char Rankings from everyone else's? (In effect making it solely for them kinda like they have their own store now.)

Waldo May 26 2012 2:05 PM EDT

Since t-char are temporary by nature wouldn't it take care of all the stats issues if t-char (& their equipment along with them) were deleted (as opposed to staying retired) a few days after the tourney ended?

This would mean t-chars would still be included during the tourney and there would still be time to verify tourney results but would not show up during non-tourney times

Just a thought

AdminNightStrike May 26 2012 10:52 PM EDT

Are we talking about this page?


Zenai [Cult of the Valaraukar] May 26 2012 11:08 PM EDT

Wow it looks awesome! Thanks NS!!!!!

AdminNightStrike May 26 2012 11:15 PM EDT

I actually didn't completely remove tournaments from that list. I removed inactive tournaments from it. So, during a tournament, the list will still contain tournament items. They'll be flushed out within 3600 seconds (1 hour) of the tournament ending, or at cache flush.

AdminNemesia [Demonic Serenity] May 26 2012 11:43 PM EDT

It's still counting them towards the top 5 items even if it isn't showing them. Some items are only showing 1 top 5 item.

AdminNemesia [Demonic Serenity] May 26 2012 11:44 PM EDT

And we also need the separation for strongest tattoos section as well.

Zenai [Cult of the Valaraukar] May 26 2012 11:46 PM EDT

True but not even seeing them is a big step in the right direction! I imagine, from NSs explanation, that this would auto correct at Cache Flush.

Gohan [Ka-Tet of the Serene] May 27 2012 12:57 AM EDT

Ahh NS comes through again. Def a great fix that everyone wanted to see. Can't say it enough but thanks for the hard work NS.

Fishead May 27 2012 1:29 AM EDT

Very cool, where are the TSA's? Just have to pump up my ego a little :)

ResistanZ2 [The Knighthood] May 27 2012 1:40 AM EDT

SoDs be gone too.

Quyen May 27 2012 6:08 AM EDT

aah, the tournament items are indeed out of the list, but they still occupy a "topspot".

KittehShinobu May 27 2012 11:05 AM EDT

=3 praise your local Kitteh Goddess for hitting up a well needed fix =3

AdminNightStrike May 27 2012 9:12 PM EDT

I moved the "limit 5" to the correct place in the sql query, but now the page rendering takes forever. I'll have to run it by some people who are better at sql than I am.
This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=003Ifb">[Fixed] (Tournament) valuable items?</a>