Database Redesign

Moderators: flockmastoR, Gipfelstuermer, Alkworld, systemmods

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

Re: Database Redesign

Post by ATB - Racing » Sun Nov 17, 2024 8:40 pm

Sprint was pretty fast ... hehe obviously cause it was the sprint.

BUT: in normal version every 50m took 1 minute (if i am not wrong)
here it was much faster (30s? or even faster?)

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

Re: Database Redesign

Post by Hansa » Sun Nov 17, 2024 8:41 pm

ATB - Racing wrote:
Sun Nov 17, 2024 8:40 pm
Sprint was pretty fast ... hehe obviously cause it was the sprint.

BUT: in normal version every 50m took 1 minute (if i am not wrong)
here it was much faster (30s? or even faster?)
there also was no mintact during the race, was shown from 178 but never started
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by ATB - Racing » Sun Nov 17, 2024 8:43 pm

Interview is shown, i can give some answers and if i click on submit, the following pop-up shows up.

Technical Error

Error Code: 0
Error Message: ATB - Racing is not in race 212823 and therefore cannot provide an interview

....
I try to upload a screenshot.

https://ibb.co/4SgzzH4

Schnuggeritos
Posts: 141
Joined: Mon Aug 01, 2022 10:37 am
Contact:

Re: Database Redesign

Post by Schnuggeritos » Mon Nov 18, 2024 1:04 am

Hansa wrote:
Sun Nov 17, 2024 8:16 pm
schnugge now got kicked out of the race, without being offline for very long
Km: 139, Steigung: 0

Vladimír Suchý (Schnuggeritos) gibt das Rennen auf

Wilfred Elrington (Schnuggeritos) gibt das Rennen auf

Paolo Mori (Schnuggeritos) gibt das Rennen auf

Clive Bixby (Schnuggeritos) gibt das Rennen auf

Jamey Stegmaier (Schnuggeritos) gibt das Rennen auf

Martin Halm (Schnuggeritos) gibt das Rennen auf

Dávid Turczi (Schnuggeritos) gibt das Rennen auf

Jacob Fryxelius (Schnuggeritos) gibt das Rennen auf
I think i missed 5 minutes at race start and then i switched from on to off every few minutes. In total the 'offline' km should be correct as long as every km with auto refresh counts into this.

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

Re: Database Redesign

Post by Alkworld » Mon Nov 18, 2024 8:33 am

ATB - Racing wrote:
Sun Nov 17, 2024 8:43 pm
Interview is shown, i can give some answers and if i click on submit, the following pop-up shows up.

Technical Error

Error Code: 0
Error Message: ATB - Racing is not in race 212823 and therefore cannot provide an interview

....
I try to upload a screenshot.

https://ibb.co/4SgzzH4
screenshot not needed, I can reproduce that

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

Re: Database Redesign

Post by ATB - Racing » Mon Nov 18, 2024 7:54 pm

Its possible to inscribe to more races than just one.
I am inscribed for the 20h race today and for tomorrow as well.

For both races i am inscribed with all needed riders.

Schnuggeritos
Posts: 141
Joined: Mon Aug 01, 2022 10:37 am
Contact:

Re: Database Redesign

Post by Schnuggeritos » Mon Nov 18, 2024 8:46 pm

ATB - Racing wrote:
Sun Nov 17, 2024 7:53 pm
18h race:
bergwerk just signed in with Zac (thats the guy with starting number -9), see above schnuggeritos posting:
Sprintwertung:
1. Zac Goldsmith (bergwerk): 6
2. Jacob Fryxelius (Schnuggeritos): 4
3. Clive Bixby (Schnuggeritos): 2

Km: 38, Steigung: 0

500 bis zum Ziel

450 bis zum Ziel

400 bis zum Ziel

350 bis zum Ziel

300 bis zum Ziel

250 bis zum Ziel

200 bis zum Ziel

150 bis zum Ziel

100 bis zum Ziel
Clive Bixby (Schnuggeritos) sprintet von vorne
Clive Bixby (Schnuggeritos):
Jacob Fryxelius (Schnuggeritos) versucht ans Hinterrad zu kommen
Jacob Fryxelius (Schnuggeritos) geht ans Hinterrad

50 bis zum Ziel
Zac Goldsmith (bergwerk) sprintet von vorne
sneaking into a race with just one rider and stealing sprint points :mrgreen: :o 8-)
Hansa and I reproduced it, today. We both inscribed with one rider less than needed and we are part of the race but can only chat via visitor chat. Updates as soon as there is more to report about this race / test

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

Re: Database Redesign

Post by Hansa » Mon Nov 18, 2024 8:51 pm

Schnuggeritos wrote:
Mon Nov 18, 2024 8:46 pm

Hansa and I reproduced it, today. We both inscribed with one rider less than needed and we are part of the race but can only chat via visitor chat. Updates as soon as there is more to report about this race / test
all my riders have 1000 power, they hadnt have 1000 power during inscription and also dont have 1000 power on the team page
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by ATB - Racing » Mon Nov 18, 2024 9:13 pm

Hansa and Schnuggeritos are not shown as visitors in the race log.

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

Re: Database Redesign

Post by ATB - Racing » Mon Nov 18, 2024 10:25 pm

1 Max VilligerNC_CH 83 56 75 72 54 56.6 44 00:00:00 Hansa
2 Amadeu Capitãodoporto 88 59 70 53 52 56 46 00:00:00 510 ATB - Racing
3 Martin Marx 81 57 70 51 58 56.1 61 00:00:00 Hansa
4 Maximino Arciniega 86 58 79 50 50 56.2 46 00:00:00 534 ATB - Racing
5 Jamey Stegmaier 50 84 76 51 43 73.2 63 00:03:33 Schnuggeritos
6 Larry Vontobel 69 74 69 44 43 66.8 51 00:03:33 Hansa
7 Noah Rey 70 79 73 48 43 69.4 62 00:03:33 Hansa
8 Tayé Wedebiwana 73 81 73 60 55 70.8 49 00:03:33 587 ATB - Racing
9 Wilfred Elrington 62 84 70 49 46 72.9 64 00:03:33 Schnuggeritos
10 Kyshawn George 74 56 77 53 53 53.3 51 00:03:33 Hansa
11 Amogelang Tshabalala 71 78 70 47 54 71.4 45 00:08:43 271 ATB - Racing
12 Samuel Spichiger 50 86 73 50 53 76.7 38 00:08:57 Hansa
13 Martin Halm 49 89 73 51 56 78.2 36 00:23:58 Schnuggeritos
14 Vladimír Suchý 49 83 48 51 51 74.9 38 00:23:58 Schnuggeritos
15 Dávid Turczi 49 84 71 50 55 75.9 58 00:23:58 Schnuggeritos
16 Austin Lucas 61 77 47 53 54 69.2 37 00:23:58 697 ATB - Racing
17 Mario Fernandez 60 83 61 65 43 73.7 62 00:23:58 732 ATB - Racing
18 Jacob FryxeliusNC_SE 50 88 52 51 52 77.5 46 00:23:58 Schnuggeritos
19 Sampo Satamapäällikkö 59 82 68 50 54 74.2 38 00:23:58 692 ATB - Racing
Hansa winning (inscribed incomplete), winner Interview for ATB (could answer the questions again but not submit them)

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

Re: Database Redesign

Post by Hansa » Mon Nov 18, 2024 10:27 pm

ATB - Racing wrote:
Mon Nov 18, 2024 10:25 pm
1 Max VilligerNC_CH 83 56 75 72 54 56.6 44 00:00:00 Hansa
2 Amadeu Capitãodoporto 88 59 70 53 52 56 46 00:00:00 510 ATB - Racing
3 Martin Marx 81 57 70 51 58 56.1 61 00:00:00 Hansa
4 Maximino Arciniega 86 58 79 50 50 56.2 46 00:00:00 534 ATB - Racing
5 Jamey Stegmaier 50 84 76 51 43 73.2 63 00:03:33 Schnuggeritos
6 Larry Vontobel 69 74 69 44 43 66.8 51 00:03:33 Hansa
7 Noah Rey 70 79 73 48 43 69.4 62 00:03:33 Hansa
8 Tayé Wedebiwana 73 81 73 60 55 70.8 49 00:03:33 587 ATB - Racing
9 Wilfred Elrington 62 84 70 49 46 72.9 64 00:03:33 Schnuggeritos
10 Kyshawn George 74 56 77 53 53 53.3 51 00:03:33 Hansa
11 Amogelang Tshabalala 71 78 70 47 54 71.4 45 00:08:43 271 ATB - Racing
12 Samuel Spichiger 50 86 73 50 53 76.7 38 00:08:57 Hansa
13 Martin Halm 49 89 73 51 56 78.2 36 00:23:58 Schnuggeritos
14 Vladimír Suchý 49 83 48 51 51 74.9 38 00:23:58 Schnuggeritos
15 Dávid Turczi 49 84 71 50 55 75.9 58 00:23:58 Schnuggeritos
16 Austin Lucas 61 77 47 53 54 69.2 37 00:23:58 697 ATB - Racing
17 Mario Fernandez 60 83 61 65 43 73.7 62 00:23:58 732 ATB - Racing
18 Jacob FryxeliusNC_SE 50 88 52 51 52 77.5 46 00:23:58 Schnuggeritos
19 Sampo Satamapäällikkö 59 82 68 50 54 74.2 38 00:23:58 692 ATB - Racing
Hansa winning (inscribed incomplete), winner Interview for ATB (could answer the questions again but not submit them)
no palmares entry for either me or Max, no points for me but -21K

atb got the palmares entry
Hansa

est. 03.08.2009

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

Re: Database Redesign

Post by Alkworld » Mon Nov 18, 2024 10:47 pm

Now fixed (but maybe I messed up something else, as the changes were quite big)
  • Statistic tab (riders): own team is not highlighted
  • NC jerseys missing
  • no mintact
  • saving interviews is failing
  • inscription with incomplete teams works partially

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

Re: Database Redesign

Post by Hansa » Tue Nov 19, 2024 2:22 pm

Markt unknown
Verfügbar 𐌗 (falsche Liga)
Typ Auction

have this for all riders on the market, cant buy anyone
Hansa

est. 03.08.2009

Schnuggeritos
Posts: 141
Joined: Mon Aug 01, 2022 10:37 am
Contact:

Re: Database Redesign

Post by Schnuggeritos » Tue Nov 19, 2024 5:04 pm

Alkworld wrote:
Sun Nov 17, 2024 6:15 pm
A few fixes done now (v3.0.1):
[...]
- fairplay votings working again (I didn't get a crash there)
[...]
Today it's not working for me. No option to select anything at all, instant crash when selecting the vote tab in race.
Online via Chrome 131.0.6778.39 (mobile version)

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

Re: Database Redesign

Post by Chemnitz Pro Cycling Team » Wed Nov 20, 2024 12:11 am

I tried the NC area
- chat is not working, if you press the green checkmark, bit works if you click the checkmark on the phone's keyboard

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

Re: Database Redesign

Post by Alkworld » Wed Nov 20, 2024 10:26 pm

More fixes done now:
  • Selling riders retires them automatically
  • Selling riders doesn’t work
  • no riders available on the market
  • wrong training percentages for sprint training
  • whitescreen when trying to do fairplay votes

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

Re: Database Redesign

Post by ATB - Racing » Thu Nov 21, 2024 12:00 am

visitors were shown in the beginning:
Race: Gheleb - Filfil
Start Time: 22:00 CET
Day: 1 / 1

Schnuggeritos

but that hint is not shown anymore. cause i "left" the race tab for a while?

edit:
hm, Black showed up later and is still shown until the end!

Visitors
Black-Star - 29 minutes ago

edit2:
mintact still not working ---> just 30s all race long (which is ok for testing) :D

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

Re: Database Redesign

Post by Alkworld » Thu Nov 21, 2024 8:40 am

ATB - Racing wrote:
Thu Nov 21, 2024 12:00 am
visitors were shown in the beginning:
Race: Gheleb - Filfil
Start Time: 22:00 CET
Day: 1 / 1

Schnuggeritos

but that hint is not shown anymore. cause i "left" the race tab for a while?

edit:
hm, Black showed up later and is still shown until the end!

Visitors
Black-Star - 29 minutes ago

edit2:
mintact still not working ---> just 30s all race long (which is ok for testing) :D
Visitors disappear after 30min, mabe that's what you noticed.
Mintact should be fixed now, I forgot to install one part of the fix

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

Re: Database Redesign

Post by ATB - Racing » Thu Nov 21, 2024 11:32 am

Ah, thanks. Didnt know that visitors disappear.
Alkworld wrote:
Thu Nov 21, 2024 8:40 am
ATB - Racing wrote:
Thu Nov 21, 2024 12:00 am
visitors were shown in the beginning:
Race: Gheleb - Filfil
Start Time: 22:00 CET
Day: 1 / 1

Schnuggeritos

but that hint is not shown anymore. cause i "left" the race tab for a while?

edit:
hm, Black showed up later and is still shown until the end!

Visitors
Black-Star - 29 minutes ago

edit2:
mintact still not working ---> just 30s all race long (which is ok for testing) :D
Visitors disappear after 30min, mabe that's what you noticed.
Mintact should be fixed now, I forgot to install one part of the fix

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

Re: Database Redesign

Post by Alkworld » Thu Nov 21, 2024 10:27 pm

More fixes done now:
  • Replay sorted by sprint result after intermediate
  • Last km replay with multiplied riders
  • youth riders not shown in team
  • voting / replay / interviews not available the next days (via calendar)
  • team page: last login not shown, wrong flag for language
  • acronyms require at least one letter, not only numbers

Let's Go
Posts: 72
Joined: Sat Apr 06, 2013 11:38 pm
Contact:

Re: Database Redesign

Post by Let's Go » Fri Nov 22, 2024 12:56 am

So we were in a race and basically none of the actions worked unless you updated/typed in chat

Had auto update on and updated a few kms manually, tried to perform multiple actions (tempo/other changes) and ended up getting kicked from the race at km 85 (that's when I noticed it wasnt updating).

Race only updated when I typed in chat and previous messages also appeared.

Also online users in the chat was working while the race wasn't (could see offline/online teams and updates when it comes to offline time).

Unsure if the issue is because of auto tempo on or other reason

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

Re: Database Redesign

Post by ATB - Racing » Fri Nov 22, 2024 12:59 am

Race: Massawa - Asmar
Start Time: 23:00 CET
Day: 1 / 1

🟡 pinte pakkers (10*)
🟢 ATB - Racing
🟢 Alpacas

Alpacas and pinte pakkers sometime with (*), while not riding on pave..... :roll: :oops:

both were kicked out the race at the same km ... both were online, in the beginning Alpacas escaped, get catched, later pinte attacked and was part time in tempo part time not (we had the same issue with Schnuggeritos and Hansa one day)

rider who is in tempo goes out of tempo after some km, both had Auto-refresh on (if i get them right), see chat below.
Km: 85, Steigung: 2
Gonzalo Hernandez (Alpacas) gibt das Rennen auf
Johan Deslover (pinte pakkers) gibt das Rennen auf
Osvaldo Vasquez (Alpacas) gibt das Rennen auf
Richard Diependaal (pinte pakkers) gibt das Rennen auf
Camilla Cortez (Alpacas) gibt das Rennen auf
Mehmet Turan (pinte pakkers) gibt das Rennen auf
Bettina Burgos (Alpacas) gibt das Rennen auf
Steven Verhoop (pinte pakkers) gibt das Rennen auf
Domingo Dominguez (Alpacas) gibt das Rennen auf
Christian Ortega (Alpacas) gibt das Rennen auf
Jef Evendoelt (pinte pakkers) gibt das Rennen auf
Maximiliano Hernandez (Alpacas) gibt das Rennen auf
Jef Cassiers (pinte pakkers) gibt das Rennen auf
Guiomar Rodriguez (Alpacas) gibt das Rennen auf
Jan Pieter (pinte pakkers) gibt das Rennen auf
Danny Verlinden (pinte pakkers) gibt das Rennen auf
ATB - Racing(23:46): its getting better yes, test still positive but i guess i can (have to) work again next week
pinte pakkers(23:46): ohh did get money from the sprint )
ATB - Racing(23:46): no that wont, well at least i hope.
pinte pakkers(23:45): nice win )
pinte pakkers(23:45): this should happend in some races where people like 75 percent where offline lol -)
Alpacas(23:44): hope you feeling better
Alpacas(23:44): but thanks ATB
Alpacas(23:44): I couldn't see what you said before
Alpacas(23:44): gw atb
pinte pakkers(23:44): and watching
Alpacas(23:44): well
pinte pakkers(23:44): yes$
pinte pakkers(23:44): there goes my sprint test haha
ATB - Racing(23:43): i will make a note in the thread in forum
ATB - Racing(23:43): you both were on Auto-refresh setting?
pinte pakkers(23:43): hope that doesent happen in real game lol
Alpacas(23:42): till I type in chat again
Alpacas(23:42): were not registered
Alpacas(23:42): my actions
Alpacas(23:42): interesting
pinte pakkers(23:42): lol my riders are gone
ATB - Racing(23:42): huch
pinte pakkers(23:41): happend the whole race just watch i will ride and do nothing for like 10 km
pinte pakkers(23:41): you got put them in again every time
pinte pakkers(23:41): no it drops every few kms
ATB - Racing(23:40): did you stoped tempo on purpose pinte? it seems we had some issues with tempo and autorefresh
ATB - Racing(23:34): just a test
ATB - Racing(23:31): Alpacas (27*) i dont get the *
ATB - Racing(23:13): wont sieb here: Amadeu is helper for Gundermann
ATB - Racing(23:12): but well yeah, go with these two guys, we can do the sprint with the guys in back
ATB - Racing(23:11): pinte i thought we try to learn the sprint?
ATB - Racing(22:56): @nnt, i just focused on the reg thing yesterday
ATB - Racing(22:55): @pinte i would suggest that we try to learn the sprint :D
ATB - Racing(22:55): heya
pinte pakkers(22:39): hi
Alpacas(22:37): hi guys

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

Re: Database Redesign

Post by Alkworld » Fri Nov 22, 2024 6:53 am

ATB - Racing wrote:
Fri Nov 22, 2024 12:59 am
Race: Massawa - Asmar
Start Time: 23:00 CET
Day: 1 / 1

🟡 pinte pakkers (10*)
🟢 ATB - Racing
🟢 Alpacas

Alpacas and pinte pakkers sometime with (*), while not riding on pave..... :roll: :oops:

both were kicked out the race at the same km ... both were online, in the beginning Alpacas escaped, get catched, later pinte attacked and was part time in tempo part time not (we had the same issue with Schnuggeritos and Hansa one day)

rider who is in tempo goes out of tempo after some km, both had Auto-refresh on (if i get them right), see chat below.
The new online status still requires some explanation.
- The * means that autorefresh is enabled
- yellow means not active (since X km)
- grey - not online during that race

I'm still wondering where I could add that.
The chat also currently doesn't keep you online, need to implement this again with the new online status functionality.
At least taking tempo out and kicking teams out technically worked :) Were they kicked out after 60% offline? Or too early?

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

Re: Database Redesign

Post by Hansa » Fri Nov 22, 2024 11:18 am

The kickouts feel to early on one of my races schnugge was kicked out while being active in the race, but i didnt count the kms , it was for sure less than 60% consecutive
Hansa

est. 03.08.2009

Let's Go
Posts: 72
Joined: Sat Apr 06, 2013 11:38 pm
Contact:

Re: Database Redesign

Post by Let's Go » Fri Nov 22, 2024 11:19 am

Let's Go wrote:
Fri Nov 22, 2024 12:56 am
So we were in a race and basically none of the actions worked unless you updated/typed in chat

Had auto update on and updated a few kms manually, tried to perform multiple actions (tempo/other changes) and ended up getting kicked from the race at km 85 (that's when I noticed it wasnt updating).

Race only updated when I typed in chat and previous messages also appeared.

Also online users in the chat was working while the race wasn't (could see offline/online teams and updates when it comes to offline time).

Unsure if the issue is because of auto tempo on or other reason
My actions were not registering so I couldn't stay online ^^

Also kick out occured after 60% of the race and not after being offline for 60% of the race (unless online status didn't work at all)

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest