|
Knockout's Forum Code Tool
|
| knockout |
Posted on 07-08-2022 00:03
|
Grand Tour Champion
Posts: 7753
Joined: 21-12-2010
PCM$: 400.00
|
Knockout's Forum Code Tool
I've read a couple times last year that some people struggle with coloring rider tables in previews, HQ roster presentations or wherever you might want to post rider stats. A while back i made myself an excel table that made that process a lot quicker for me and I've used it for basically every HQ post with rider stats and also for the tables you saw in the Conglomerate previews but i've only ever shared it when someone asked me if i had one because the previous version was super raw and messy. I finally decided to clean it up a bit so that i could share it with you.
What can this do? This tool creates the HTML code for colored rider stat tables and links the correct flags. You can quickly hide columns (e.g. if you only need the stats MO, HI, TT, RES, REC, ACC, DH for a stage race preview, that is done very quickly). You can also change the color and the threshold values for the used coloring of stats.
How do I use this? Basically, you copy the riders you want to include (e.g. your team, the top stage racers in a stage race or whatever) from the DB into the input sheet, change which stats are supposed to be visible and then copy the Output table into a forum reply and add the [ table=100% ] [ /table ] brackets (without the spaces obviously). Slightly more detailed explanations about the different modification options are included in the tool that should explain everything well.
Mistakes - If there are any mistakes or questions, please share them in this thread. Also report any missing or wrong flags and stuff like that.
A Big Thank You To All MG Reporters! |
| |
|
|
| jandal7 |
Posted on 07-08-2022 00:08
|
World Champion
Posts: 11406
Joined: 17-12-2014
PCM$: 1120.00
|
This is a brilliant tool, thanks knockout for sharing, will put it to great use 
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT]  Xero Racing
5x  x5
2x  x2
2x  x2 |
| |
|
|
| cio93 |
Posted on 07-08-2022 07:06
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
Instant manager of the year nomination.
|
| |
|
|
| SotD |
Posted on 07-08-2022 07:41
|
World Champion
Posts: 12200
Joined: 29-11-2006
PCM$: 2980.00
|
Indeed this is a sublime tool, and definately something I will be using.
Thanks a lot for sharing!
|
| |
|
|
| Eden95 |
Posted on 07-08-2022 07:59
|
Grand Tour Specialist
Posts: 4511
Joined: 05-10-2010
PCM$: 900.00
|
This is awesome, thank you a heap for sharing it with everyone 
Indosat - ANZ HQ
"This Schleck sandwich is going to cause serious indigestion for Evans" - Phil Liggett |
| |
|
|
| Ad Bot |
Posted on 21-12-2024 16:24
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| hillis91 |
Posted on 07-08-2022 12:26
|
Team Leader
Posts: 5901
Joined: 30-11-2006
PCM$: 1500.00
|
Absolute amazing work here.
This will make the HQ section better, for sure!
|
| |
|
|
| baseballlover312 |
Posted on 07-08-2022 13:58
|
Tour de France Champion
Posts: 16451
Joined: 27-07-2011
PCM$: 10538.70
|
+1
Amazing value this brings to the forum. Thank you knockout!
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy |
| |
|
|
| whitejersey |
Posted on 07-08-2022 15:25
|
Classics Specialist
Posts: 2919
Joined: 07-08-2011
PCM$: 300.00
|
Great tool, thanks a lot for sharing!
|
| |
|
|
| wildwind |
Posted on 07-08-2022 16:26
|
Under 23
Posts: 93
Joined: 07-07-2022
PCM$: 2100.00
|
Thanks you for sharing this great tool |
| |
|
|
| DaveTwoBob |
Posted on 07-08-2022 17:17
|
Small Tour Specialist
Posts: 2434
Joined: 07-07-2013
PCM$: 200.00
|
Great stuff, thanks Knockout
|
| |
|
|
| ember |
Posted on 07-08-2022 17:58
|
Team Leader
Posts: 6866
Joined: 27-03-2008
PCM$: 700.00
|
Amazing, knockout!
Thank you a lot, this will make setting up HQ posts a lot more manageable |
| |
|
|
| Fabianski |
Posted on 07-08-2022 20:35
|
Grand Tour Specialist
Posts: 4700
Joined: 29-09-2018
PCM$: 185.00
|
Thanks a lot!
I had already made an Excel to format the stats as well, but wasn't bored enough yet to add the country flags, so your tool is definitely an improvement over mine Great job!
|
| |
|
|
| DubbelDekker |
Posted on 10-08-2022 18:23
|
Small Tour Specialist
Posts: 2645
Joined: 20-04-2008
PCM$: 200.00
|
You're a legend!
Knocked it right out of the park with this one 
|
| |
|
|
| ivaneurope |
Posted on 11-08-2022 14:57
|
Classics Specialist
Posts: 2938
Joined: 09-05-2011
PCM$: 300.00
|
It really makes making tables a lot easier - thank you very much
|
| |
|
|
| knockout |
Posted on 11-08-2022 20:34
|
Grand Tour Champion
Posts: 7753
Joined: 21-12-2010
PCM$: 400.00
|
Thank you everybody, reading all the praise feels good!
Spoiler Fabianski wrote:
Thanks a lot!
I had already made an Excel to format the stats as well, but wasn't bored enough yet to add the country flags, so your tool is definitely an improvement over mine  Great job!
The majority of the country list was stolen from someone's else work a couple years ago and I only added those newer countries that previously were not in the DB and the excel code to link them. So sorry to whoever should have gotten credit for that part of the work
A Big Thank You To All MG Reporters! |
| |
|
|
| Gustavovskiy |
Posted on 13-08-2022 10:21
|
Team Leader
Posts: 6044
Joined: 20-07-2008
PCM$: 200.00
|
This is phenomenal! Thanks a lot, mate!
|
| |
|
|
| kandesbunzler26 |
Posted on 29-08-2022 13:17
|
Protected Rider
Posts: 1147
Joined: 07-07-2013
PCM$: 200.00
|
Thanks from me, too.
I'm using your tool vividly.
|
| |
|
|
| kandesbunzler26 |
Posted on 29-08-2022 17:06
|
Protected Rider
Posts: 1147
Joined: 07-07-2013
PCM$: 200.00
|
Just a quick correction: The country code for Monaco is MCO in the DB (not MON).
|
| |
|
|
| knockout |
Posted on 29-08-2022 17:21
|
Grand Tour Champion
Posts: 7753
Joined: 21-12-2010
PCM$: 400.00
|
Can a MG admin confirm which one is correct? Seems like both of them are used for Monaco.
- Antoine Berlin has MCO and seems to be Monegasque.
- MON is the nationality of five riders of which a few (Nicolas D'Angelo, Victor Langellotti, Arnaud Caraccioli, possibly Laurent Devalle) seem to be RL Monegasque cyclists (although some with different birthdates
A Big Thank You To All MG Reporters! |
| |
|
|
| GregPeck |
Posted on 29-08-2022 19:47
|
Free Agent
Posts: 141
Joined: 18-07-2022
PCM$: 400.00
|
This has been an immense help |
| |
|
