[cpdb] Fixes/Revisions List

Our pioneering project aims to identify and catalogue every crash photo in racing history. We cannot do it alone, so if you have any spare time, view this forum and sign up to help!
Post Reply
User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

[cpdb] Fixes/Revisions List

Post by PTRACER » 4 years ago

[x] Error in database design - Year column ordering not working as expected
[x] Changes to the administrative side of the database
[x] Add multiple lines to the Vehicle box in case multiple vehicles were involved
[x] Add a welcome message to the top of the List page
[x] Write a paragraph including an email address where people can send Copyright claims
[x] Provide an upload link so people can upload photos from other sites to The Fastlane or Benhuset server
[x] Fix the 'Contains' search box at the top of list page. It moves out of line when you use Search then click 'Show All'.
[x] Adjust Fatal column width
[x] Add an option to NOT display Fatal crashes by default
[x] Link to return to The Fastlane Forum
[x] Separate Categories from Series
[x] Add copyright notice to footer
[x] Bug where 'Sorting' was by item ID, not the name
[x] Revise Latest Entries page to include more entries
[x] Add User Login info, forcing users to create an account before they can browse the CPdB

To Do List (07/01/2019)

[ ] Change the default Advanced Search paramater to 'All terms', not 'Any terms'
[ ] Add a 'Thanks To...' credits page
[ ] Add a new field for car numbers
[ ] Replace the clunky 'Warning' image system by separating gory pics into a second field, which is hidden behind a button and a collapsible <div>
[ ] Along with the above, remove the 'Safe' version of CPdB
[ ] Give contributors individual accounts rather than one blanket admin account
[ ] Create a 'behind the scenes' log of exactly who contributes what to the CPdB so due credit can be given
[ ] Eventually replace the entire front end and search aspect of the CPdB with a standard homepage like MMorg, with clickable search terms etc.
[ ] Receive the blessings of LAT, Getty, etc. etc. etc....
------------------------

Previous Updates:

21 Oct 2015
Added a max-width of 1280px to the View Record window
Placed an 'Advanced Search' button on the Index
Removed the 'Contains/Equal To/Less Than/More Than' dropdown box as it doesn't work as intended
Removed the header from every page but the index

06 Dec 2015
Made a major revision to the database query. Now when you 'Sort' each field, it's ordered by the name of the Series/Category/Circuit alphabetically and not the order it was entered into the database
Revised the search function. The dropdown options are now more appropriate to the Search - for example, Fatal: Yes/No used to appear as a textbox which you could type in, unless you clicked the dropdown box and changed it to 'Equals'

09 Jun 2016
Right-click now fully disabled throughout the database. This will protect photos against unauthorised saving.

18 Jun 2016
The database front end has received a major overhaul. I wanted to make it look a little more presentable before we release it to the general public.

23 Jun 2016
Advanced Search Page now in its final version.

04 Aug 2016
Clicking on a driver's name will now display all crashes by that particular driver.

31 Oct 2016
- Empty fields are now hidden from the 'View Record' page. So, for entries where there is no description, rather than it saying 'Description' and showing an empty box, it now just hides the field label.
- There is now a link at the bottom of each entry called Suggest a correction for this entry. If someone reading spots an error or they have additional information to provide, they may use this link to email us directly and suggest updates/corrections. The 'Subject' field of the email is automatically populated with the race details (e.g. "1972 ADAC 1000km") so we can quickly find the entry that needs updating.
- Final update, the one that took all bloody afternoon. In the case of shared drives, we usually write something like Jacky Ickx/Clay Regazzoni. The problem was, you could not click on their names individually to find more of their crashes. Now you can.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

Big list of fixes done tonight

Fatal crashes are now hidden by default, but a quick click of a button and they are all there.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

Motorsportrace - I'm separating 'Category' into 'Category' and 'Series'.

Category will now show Single Seaters, Saloon Cars, Touring Cars etc., Series will show Formula 1, Renault Clio Cup UK, BTCC etc.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

Ok, thanks for the information.
Motorsportrace

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

Another questions: should we add a "session" field?
If the crash happened during practice, race, private test, etc. (although I had to add a "private test" record in the "category" field: I can't find a category for those crashes, at least when they weren't testing the car for a specific purpose. For example: Bob Anderson was testing his car for the Canadian F1 Grand Prix, so I'd say it was a F1 accident. But I don't really know if Tom Kincaid was testing his car for a specific race or championship).
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

I think 'Private Test'/'Testing' can fit into the Event field pretty easily. The others would just be "Open wheel" (Category) "Formula 1" (Series) etc.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

Added a max-width of 1280px to the View Record window
Placed an 'Advanced Search' button on the Index
Removed the 'Contains/Equal To/Less Than/More Than' dropdown box as it doesn't work as intended
Removed the header from every page but the index
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

There's a character limit on the "photos" field (I suppose). I can't add more photos to the Vukovich crash.
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

I've renamed the files simply vukovich1.jpg through to vukovich10.jpg

If you have many images, please keep filenames short (and without spaces) :)
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

Ok, thanks for that.
Motorsportrace

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

Well... now even renaming the pictures as "N1", "N2", etc. doesn't solve the problem of the character limit (I'm uploading Gordon Smiley's pictures).
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

Ok, I'm going to increase the character limit for you shortly. Please either finish off your current entry or leave it on the screen while I upload the new files.

P.S. For the IndyCar crashes, can we add their 'nicknames' to the Driver(s) field? For example: James "Jim" Malloy?
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Advanced Member
Advanced Member
Posts: 3183
Joined: 9 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 4 years ago

PTRACER wrote:Ok, I'm going to increase the character limit for you shortly. Please either finish off your current entry or leave it on the screen while I upload the new files.
Ok, I'll leave it on my screen.
PTRACER wrote:P.S. For the IndyCar crashes, can we add their 'nicknames' to the Driver(s) field? For example: James "Jim" Malloy?
I was thinking about it.
So John Hrankey should be renamed as John "Johnny" "Hannon" Hrankey? And William Denver Orem should be William "Bill" Denver Orem? Or something like that?

I've also thought of a picture of the driver's face, but that would be "useful" only for fatal crashes, so I don't think it's a good idea.
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 4 years ago

Something like that. I think I was just going to keep their formal names. E.g. Just write Jim Malloy if that's how we know them.

The database is currently being updated, in a few minutes you should be able to edit as before.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 36804
Joined: 16 years ago
Real Name: Paul
Favourite Motorsport: Formula 1
Favourite Racing Car: Lotus 49
Favourite Driver: Gilles Villeneuve, James Hunt
Favourite Circuit: Nordschleife
Location: U.K.
Contact:

Post by PTRACER » 3 years ago

- Made a major revision to the database query. Now when you 'Sort' each field, it's ordered by the name of the Series/Category/Circuit alphabetically and not the order it was entered into the database

- Revised the search function. The dropdown options are now more appropriate to the Search - for example, Fatal: Yes/No used to appear as a textbox which you could type in, unless you clicked the dropdown box and changed it to 'Equals'

Still to do: Put a really good Search guide at the top of the Search page, to tell people the best way to use it.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

Post Reply