Development for Tournaments

Post a reply

Confirmation code
Enter the code exactly as it appears. All letters are case insensitive.
Smilies
:points: :-D :eyeroll: :neutral: :nmr: :razz: :raging: :-) ;) :( :sick: :o :? 8-) :x :shock: :lol: :cry: :evil: :?: :smirk: :!:
View more smilies
BBCode is ON
[img] is ON
[flash] is OFF
[url] is OFF
Smilies are ON
Topic review
   

If you wish to attach one or more files enter the details below.

Expand view Topic review: Development for Tournaments

Re: Development for Tournaments

by Squigs44 » Fri Jun 07, 2019 12:37 am

VillageIdiot wrote: ↑
Thu Jun 06, 2019 5:32 pm
 I'm just referring to the sub-header section of the Finished Tournaments tabs. That rest can be fully dynamic code but this should easily be static and manually updated given how rare a finish tournament occurs.

Or am i missing something?
We store our data in SQL tables that link up to other SQL tables. We could potentially store a string in the table for first, second, third place, but it wouldn't automatically link to the user account (ie, the username would not be a clickable link, and other things that we plan on developing in the near future also wouldn't work). Don't worry, we will find a solution to this, it just isn't easier from a data access perspective to store a username (or list of usernames) with the current way the site is set up, and with the future developments that we have planned.

Re: Development for Tournaments

by VillageIdiot » Thu Jun 06, 2019 5:32 pm

I'm just referring to the sub-header section of the Finished Tournaments tabs. That rest can be fully dynamic code but this should easily be static and manually updated given how rare a finish tournament occurs.

Or am i missing something?

Re: Development for Tournaments

by Squigs44 » Thu Jun 06, 2019 3:29 am

VillageIdiot wrote: ↑
Wed Jun 05, 2019 6:02 am
 Sounds unnecessarily complex for a block that could simply be vanilla HTML content, no?
How is using a single number that will automatically link to all the other information we need more complex than typing out the entire HTML content everytime?

We'll get something worked out though for sure.

Re: Development for Tournaments

by VillageIdiot » Wed Jun 05, 2019 6:02 am

Sounds unnecessarily complex for a block that could simply be vanilla HTML content, no?

Re: Development for Tournaments

by jmo1121109 » Wed Jun 05, 2019 12:08 am

Nope, the tables are designed to hold int's which are userID's and the site then reads a single one back out and spits it into a link. Trying to insert a string like that would be a nice error on page load.

Re: Development for Tournaments

by VillageIdiot » Tue Jun 04, 2019 11:49 pm

Can't just do..?

First Place:
Name, Name, Name, Name, Name

Second Place:
Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name, Name...

Third Place:
Name, Name, Name, Name, Name

(that second place example represents Greatest Lakes team with their 39 rotating subs)

Re: Development for Tournaments

by jmo1121109 » Tue Jun 04, 2019 9:25 pm

World Cup is unfortunately difficult to show due to it being a team tournament. I'll have a solution worked out before the next world cup, but for now I don't have a way of displaying teams.

Re: Development for Tournaments

by VillageIdiot » Tue Jun 04, 2019 9:12 pm

We need to get the World Cup results up on the completed tab. I thirst for more recognition of past glory!

Re: Development for Tournaments

by jmo1121109 » Tue Jun 04, 2019 6:36 pm

mhsmith0 wrote: ↑
Tue Jun 04, 2019 5:03 pm
 btw is it possible to have the tournaments dropdown show winner (or "winners" if there's a LOT of space to be had) under the list of each round? There might be some space to be had by cutting down "process time" to just showing day instead of full timestamp...
The process time needs to show the full time for TD's since that's the only spot they can see all tournament games and if they're stuck on WFO and if so, when they should have processed right now. I'll think about how we could show who won/drew though.

Re: Development for Tournaments

by mhsmith0 » Tue Jun 04, 2019 5:03 pm

btw is it possible to have the tournaments dropdown show winner (or "winners" if there's a LOT of space to be had) under the list of each round? There might be some space to be had by cutting down "process time" to just showing day instead of full timestamp...

Re: Development for Tournaments

by jmo1121109 » Wed May 29, 2019 4:49 am

Also, thanks everyone for giving me a better then 2 to 1 karma to post ratio with this thread. I gotta figure out how to trade karma in for some good :oil:

Re: Development for Tournaments

by jmo1121109 » Wed May 29, 2019 4:46 am

goldfinger0303 wrote: ↑
Wed May 29, 2019 3:15 am
Claesar wrote: ↑
Tue May 28, 2019 8:24 pm
 For me the most important thing here is that we can now accept almost anyone as a TD. Before we preferred (ex-)mods, but now we can be more liberal.
Wait, am I out of a job now?
Lol you wish, you're the best sucker...er I mean eager volunteer...we have to run tournaments.

Re: Development for Tournaments

by goldfinger0303 » Wed May 29, 2019 3:15 am

Claesar wrote: ↑
Tue May 28, 2019 8:24 pm
 For me the most important thing here is that we can now accept almost anyone as a TD. Before we preferred (ex-)mods, but now we can be more liberal.
Wait, am I out of a job now?

Re: Development for Tournaments

by SpaceDip » Tue May 28, 2019 10:55 pm

This is really good news :)

Re: Development for Tournaments

by Claesar » Tue May 28, 2019 8:24 pm

For me the most important thing here is that we can now accept almost anyone as a TD. Before we preferred (ex-)mods, but now we can be more liberal.

Re: Development for Tournaments

by Squigs44 » Tue May 28, 2019 6:57 pm

Peregrine Falcon wrote: ↑
Tue May 28, 2019 5:52 pm
 You two are amazing! You deserve all the plus ones. Maybe post a few more times so we can give you more.
What's that? You want me to do MORE work by posting more?

Re: Development for Tournaments

by Peregrine Falcon » Tue May 28, 2019 5:52 pm

You two are amazing! You deserve all the plus ones. Maybe post a few more times so we can give you more.

Re: Development for Tournaments

by Durga » Tue May 28, 2019 2:11 am

This is AWESOME!! Good work you two

Re: Development for Tournaments

by jmo1121109 » Tue May 28, 2019 1:20 am

Alcove wrote: ↑
Tue May 28, 2019 1:17 am
 Incredible update, and a huge boon to the online competitive Diplomacy tournament scene. Thanks jmo and squigs!
What's especially fun is I designed this with the capacity to enter F2F tournaments and easily link to their scoring results externally. So we can keep a record of any ongoing tournament and show if webdippers placed in the top 3. We'll start filling in some back tournaments too, but not all since tournament data has been recorded since 1974(?) and that's too much work to import lol.

Re: Development for Tournaments

by Alcove » Tue May 28, 2019 1:17 am

Incredible update, and a huge boon to the online competitive Diplomacy tournament scene. Thanks jmo and squigs!

Top