Database Redesign

Moderators: flockmastoR, Gipfelstuermer, Alkworld, systemmods

drei.zehn
Posts: 110
Joined: Wed Apr 08, 2015 10:09 am
Contact:

Re: Database Redesign

Post by drei.zehn » Sat Dec 28, 2024 11:43 pm

TM still with a Bug. Nobody cares or Alk in christmas holidays? :D

User avatar
flockmastoR
Posts: 3466
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Database Redesign

Post by flockmastoR » Sun Dec 29, 2024 12:20 pm

drei.zehn wrote:
Sat Dec 28, 2024 11:43 pm
TM still with a Bug. Nobody cares or Alk in christmas holidays? :D
Of course, Alk is also deserving christmas holidays. Once he is back, he will continue the development.
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

User avatar
flockmastoR
Posts: 3466
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Database Redesign

Post by flockmastoR » Sun Dec 29, 2024 12:26 pm

Another Bug that some have mentioned:

Rider limit for inscription is gone. i.e. Harryaner could ride the 2 riders race Azencross with just 3 riders >= 21 years and 7 riders in total.

Other examples were also reported. Not sure what the limit was for participating (8 or 9), but I guess Harryaners inscription shouldn't be possible.
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

drei.zehn
Posts: 110
Joined: Wed Apr 08, 2015 10:09 am
Contact:

Re: Database Redesign

Post by drei.zehn » Sun Dec 29, 2024 5:46 pm

flockmastoR wrote:
Sun Dec 29, 2024 12:26 pm
Another Bug that some have mentioned:

Rider limit for inscription is gone. i.e. Harryaner could ride the 2 riders race Azencross with just 3 riders >= 21 years and 7 riders in total.

Other examples were also reported. Not sure what the limit was for participating (8 or 9), but I guess Harryaners inscription shouldn't be possible.
Don’t know if its a Bug. I know there was this rule some years ago, but it already didn‘t exist when I come back at the end of 2023. Noticed it there but thought thats just the way it is now

ATB - Racing
Posts: 305
Joined: Fri May 04, 2012 11:57 am
Contact:

Re: Database Redesign

Post by ATB - Racing » Mon Dec 30, 2024 2:12 am

Race: Mithragan Tour
Start Time: 23:00 CET
Day: 3 / 4
Km: 176 / 175 (0km to go)

most active rider is not shown.
i voted for it every day and just recognized that i got money for stage one but i didnt had the number.
also today the number was missing.

drei.zehn
Posts: 110
Joined: Wed Apr 08, 2015 10:09 am
Contact:

Re: Database Redesign

Post by drei.zehn » Tue Dec 31, 2024 9:11 am

Kleinere Sache

Wenn man unbenannte Fahrer kauft, zb vom Jugendmarkt, dann bleibt in der Transferhistorie des Teams auch nach der Namensgebung stehen:

Purchase unnamed x…

War vorher nicht so, da wurde der Name dann übernommen.
Hat keinen Einfluss aufs Spiel, ist nur ein bisschen hässlich :D

Bugatti
Posts: 124
Joined: Sat Feb 05, 2011 5:53 pm
Contact:

Re: Database Redesign

Post by Bugatti » Thu Jan 02, 2025 2:56 pm

Kalender currently werden alle Rennen angezeigt seit der neuen Version.
Da waren vorher nur die kommenden paar Rennen drin.
Giro d´Italia 2016 - James Müller
La Vuelta 2015 - Mark McCann
La Doyenne - Helge Thomsen

Radunion
Posts: 407
Joined: Sat Mar 27, 2010 2:09 pm
Contact:

Re: Database Redesign

Post by Radunion » Thu Jan 02, 2025 3:02 pm

Not so urgent, but I want to document it. On the 31. the finance season overview was wrong. It showed very second month twice (dec, oct, ...) and missing the others all together.

Chemnitz Pro Cycling Team
Posts: 290
Joined: Mon Jul 25, 2022 12:47 pm
Contact:

Re: Database Redesign

Post by Chemnitz Pro Cycling Team » Fri Jan 03, 2025 7:53 pm

People talked about a lot of reg today with the two half stages. Can you check whether everything is correct?

Hansa
Posts: 1097
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Database Redesign

Post by Hansa » Fri Jan 03, 2025 9:12 pm

Chemnitz Pro Cycling Team wrote:
Fri Jan 03, 2025 7:53 pm
People talked about a lot of reg today with the two half stages. Can you check whether everything is correct?
can confirm there was to much reg

there was once reg at the end of the ITT Max went to 950 as he should, before the TTT start when it loaded it he got another time reg and went to full
Hansa

est. 03.08.2009

ATB - Racing
Posts: 305
Joined: Fri May 04, 2012 11:57 am
Contact:

Re: Database Redesign

Post by ATB - Racing » Fri Jan 03, 2025 10:33 pm

will have a look at the reg of my riders later on.

Edith:
we get double reg directly after the ITT and another double reg, immediatly before the TTT started.
so 4xreg .... so it was a bug.

Alkworld
Posts: 1261
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Thu Jan 09, 2025 9:55 pm

ATB - Racing wrote:
Fri Jan 03, 2025 10:33 pm
will have a look at the reg of my riders later on.

Edith:
we get double reg directly after the ITT and another double reg, immediatly before the TTT started.
so 4xreg .... so it was a bug.
I thought I fixed that and I was even right about that. However, there were three places the reg after half stages was added: for normal races, ITTs and TTTs. The latter two were missing. Fixed now

ATB - Racing
Posts: 305
Joined: Fri May 04, 2012 11:57 am
Contact:

Re: Database Redesign

Post by ATB - Racing » Tue Jan 14, 2025 1:26 am

Wenn man auf das Profil klickt (im Rennbereich) öffnet sich ja "Race Overview".

Die Sortierung nach Race Editions ist da ein wenig durcheinander:
9h, 14h, 22h, 19h

- zudem ist die Anzeige grünes / rotes Trikot (noch) vertauscht
- Anzeige /Trikot für kämpferischsten Fahrer fehlt

bergwerk cycling
Posts: 1540
Joined: Tue Apr 06, 2010 10:21 am
Contact:

Re: Database Redesign

Post by bergwerk cycling » Tue Jan 14, 2025 9:10 am

could it be that the prices of riders sold on the market are not falling or are falling far too slowly? something is wrong i believe

Alkworld
Posts: 1261
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Tue Jan 14, 2025 10:25 am

ATB - Racing wrote:
Tue Jan 14, 2025 1:26 am
Wenn man auf das Profil klickt (im Rennbereich) öffnet sich ja "Race Overview".

Die Sortierung nach Race Editions ist da ein wenig durcheinander:
9h, 14h, 22h, 19h

- zudem ist die Anzeige grünes / rotes Trikot (noch) vertauscht
- Anzeige /Trikot für kämpferischsten Fahrer fehlt
- The sorting might be wrong because the 19h and 22h editions officially started later.
- Regarding the sorting of sprint and mountain jerseys, please make sure you're using 3.1.5, where this was fixed (I didn't really announce it)
- most active rider I need to check

ATB - Racing
Posts: 305
Joined: Fri May 04, 2012 11:57 am
Contact:

Re: Database Redesign

Post by ATB - Racing » Tue Jan 14, 2025 12:35 pm

Sorting sounds reasonable (editions).
New version: check, looks fine now!

THANKS
Alkworld wrote:
Tue Jan 14, 2025 10:25 am
ATB - Racing wrote:
Tue Jan 14, 2025 1:26 am
Wenn man auf das Profil klickt (im Rennbereich) öffnet sich ja "Race Overview".

Die Sortierung nach Race Editions ist da ein wenig durcheinander:
9h, 14h, 22h, 19h

- zudem ist die Anzeige grünes / rotes Trikot (noch) vertauscht
- Anzeige /Trikot für kämpferischsten Fahrer fehlt
- The sorting might be wrong because the 19h and 22h editions officially started later.
- Regarding the sorting of sprint and mountain jerseys, please make sure you're using 3.1.5, where this was fixed (I didn't really announce it)
- most active rider I need to check

Alkworld
Posts: 1261
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Wed Jan 15, 2025 8:23 pm

bergwerk cycling wrote:
Tue Jan 14, 2025 9:10 am
could it be that the prices of riders sold on the market are not falling or are falling far too slowly? something is wrong i believe
Do you have some more specific data? Any rider to look into?

bergwerk cycling
Posts: 1540
Joined: Tue Apr 06, 2010 10:21 am
Contact:

Re: Database Redesign

Post by bergwerk cycling » Thu Jan 16, 2025 12:29 am

Name Oddur Björnsson
Am 17.12. verkauft 30 Jahre und kostet immer noch über 2,1
Gefühlt vielen die Preise vorher deutlich schneller???

drei.zehn
Posts: 110
Joined: Wed Apr 08, 2015 10:09 am
Contact:

Re: Database Redesign

Post by drei.zehn » Thu Jan 16, 2025 5:34 am

bergwerk cycling wrote:
Thu Jan 16, 2025 12:29 am
Name Oddur Björnsson
Am 17.12. verkauft 30 Jahre und kostet immer noch über 2,1
Gefühlt vielen die Preise vorher deutlich schneller???
Seit der neuen Version fallen alle Fahrer bis 85% und danach stehen sie fast. Rafael Trujillo hatte über eine Woche den selben Preis. Aktuell fallen sie wieder, aber extrem langsam. Fahrer die vorher schon unter 85% waren, sind auch betroffen und erreichen die 50% nicht mehr

bergwerk cycling
Posts: 1540
Joined: Tue Apr 06, 2010 10:21 am
Contact:

Re: Database Redesign

Post by bergwerk cycling » Thu Jan 16, 2025 8:41 am

drei.zehn wrote:
Thu Jan 16, 2025 5:34 am
bergwerk cycling wrote:
Thu Jan 16, 2025 12:29 am
Name Oddur Björnsson
Am 17.12. verkauft 30 Jahre und kostet immer noch über 2,1
Gefühlt vielen die Preise vorher deutlich schneller???
Seit der neuen Version fallen alle Fahrer bis 85% und danach stehen sie fast. Rafael Trujillo hatte über eine Woche den selben Preis. Aktuell fallen sie wieder, aber extrem langsam. Fahrer die vorher schon unter 85% waren, sind auch betroffen und erreichen die 50% nicht mehr
Genau das meine ich - aber das ist aber keine Absicht oder?

Bugatti
Posts: 124
Joined: Sat Feb 05, 2011 5:53 pm
Contact:

Re: Database Redesign

Post by Bugatti » Thu Jan 16, 2025 11:45 am

in den Rennen stimmt die Anzeige (oder auch für die Berechnung) der Höhe nicht.
Vietnam 3620m
Yuma - Moron -330m
Giro d´Italia 2016 - James Müller
La Vuelta 2015 - Mark McCann
La Doyenne - Helge Thomsen

Alkworld
Posts: 1261
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Thu Jan 16, 2025 11:48 am

drei.zehn wrote:
Thu Jan 16, 2025 5:34 am
bergwerk cycling wrote:
Thu Jan 16, 2025 12:29 am
Name Oddur Björnsson
Am 17.12. verkauft 30 Jahre und kostet immer noch über 2,1
Gefühlt vielen die Preise vorher deutlich schneller???
Seit der neuen Version fallen alle Fahrer bis 85% und danach stehen sie fast. Rafael Trujillo hatte über eine Woche den selben Preis. Aktuell fallen sie wieder, aber extrem langsam. Fahrer die vorher schon unter 85% waren, sind auch betroffen und erreichen die 50% nicht mehr
30-yo (e.g. Oddur) should decrease by 1.5% of their value per day once they dropped below 85%. Until a few days ago, there was a bug in this script, but now it should be fine.

The percentages are as follows (in code, but should be readable):
[ 'reduction' => '0.03', 'age' => '> 32' ]
[ 'reduction' => '0.025', 'age' => '= 32' ]
[ 'reduction' => '0.02', 'age' => '= 31' ]
[ 'reduction' => '0.015', 'age' => '= 30' ]
[ 'reduction' => '0.012', 'age' => '= 29' ]
[ 'reduction' => '0.01', 'age' => '= 28' ]
[ 'reduction' => '0.01', 'age' => '= 27' ]
[ 'reduction' => '0.01', 'age' => '= 26' ]
[ 'reduction' => '0.009', 'age' => '= 25' ]
[ 'reduction' => '0.008', 'age' => '= 24' ]
[ 'reduction' => '0.007', 'age' => '= 23' ]
[ 'reduction' => '0.006', 'age' => '= 22' ]
[ 'reduction' => '0.005', 'age' => '= 21' ]

bergwerk cycling
Posts: 1540
Joined: Tue Apr 06, 2010 10:21 am
Contact:

Re: Database Redesign

Post by bergwerk cycling » Thu Jan 16, 2025 12:13 pm

Danke (und vor allem für die ganze Arbeit drumherum = Hut ab) ...

Bugatti
Posts: 124
Joined: Sat Feb 05, 2011 5:53 pm
Contact:

Re: Database Redesign

Post by Bugatti » Sun Jan 19, 2025 8:45 am

Transfermarkt - Gebote
Fahrer die gekauft wurden und benannt sind, werden dort immer noch als unnamed x.... angezeigt.
Giro d´Italia 2016 - James Müller
La Vuelta 2015 - Mark McCann
La Doyenne - Helge Thomsen

Alkworld
Posts: 1261
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Database Redesign

Post by Alkworld » Sun Jan 19, 2025 11:04 am

Bugatti wrote:
Thu Jan 16, 2025 11:45 am
in den Rennen stimmt die Anzeige (oder auch für die Berechnung) der Höhe nicht.
Vietnam 3620m
Yuma - Moron -330m
OK, I also saw that somewhere. Need to check it when it happens again.

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests