RIP Murray Walker (1923-2021)

The rebirth of the Crash Photos Database

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!
User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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:

The rebirth of the Crash Photos Database

Post by PTRACER » 5 years ago

The other day I found all the files relating to the Crash Photos Database. Unfortunately the database itself was gone, so I've recreated it manually

It's a little empty at the moment but it's...IT'S BACK *cries*

http://www.the-fastlane.co.uk/cpdb/
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

If I have some time, and people are interested, I will recreate it properly. With drop down menus and clickable bits so people don't have to struggle with spellings etc. when inputting info
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
ReneLotus
Advanced Member
Advanced Member
Posts: 2416
Joined: 14 years ago
Location: the Netherlands

Post by ReneLotus » 5 years ago

Looks nice, but also like a huge amount of work.
Is it a database containing pics from our crash threads only?

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

It's meant to be yeah. I'm so upset with myself, deleting all the work that was done previously...but that was 10 or so years ago. We can do it again in a different way now. Maybe we have too many photos, maybe we should only include what's important.

I can only support this project from afar, I don't have time to contribute too much to it. So if people want to add photos to it at their own will, that's fine. Stick to the most significant crashes only.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Cheeveer
Moderator
Moderator
Posts: 11963
Joined: 15 years ago
Location: 24 hours from Le Mans

Post by Cheeveer » 5 years ago

hey, I remember this!
***Some say you should live each day like it was your last... but who wants to live each day in wild panic and extreme death anxiety?

The universe, look at the hugeness of it... it is a dizzying thought that little ol' me is the centre of it all!***

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

Blast from the past right? :haha:

The layout looks broken though, no idea why. Will try to fix.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Senior Member
Senior Member
Posts: 3406
Joined: 10 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 5 years ago

Ok, I registered. I've seen some test images (I believe). So... what should we do?
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

Motorsportrace wrote:Ok, I registered. I've seen some test images (I believe). So... what should we do?
Have a play around with it.

When it's time to take it seriously, I'll delete all test data and we'll do it properly!
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

Installed an entirely new system, check out the first link guys!

Suggestions and improvements welcome (and necessary BEFORE we start work)
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Motorsportrace
Senior Member
Senior Member
Posts: 3406
Joined: 10 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 5 years ago

Not a suggestion, but a question: will you make the database publicly available?
Motorsportrace

User avatar
Motorsportrace
Senior Member
Senior Member
Posts: 3406
Joined: 10 years ago
Real Name: M
Location: Milan

Post by Motorsportrace » 5 years ago

I forgot to ask: could we change the field "driver" with something like "involved"?
We have a lot of crashes that involved marshals, spectators, riding mechanics, ...
Motorsportrace

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

Motorsportrace wrote:Not a suggestion, but a question: will you make the database publicly available?
Publicly available? In what way?

Regarding the 'Involved' - that's probably a good idea. I'm currently working on a solution that would allow multiple names and multiple images to be stored in each record. This wasn't possible with the original CPDB.
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
Ian-S
Ultimate Member
Ultimate Member
Posts: 9984
Joined: 13 years ago

Post by Ian-S » 5 years ago

PTRACER wrote:Installed an entirely new system, check out the first link guys!

Suggestions and improvements welcome (and necessary BEFORE we start work)
Formatting is still off, on the tablet anyway, the top listing is aligned left, the photo listing thumbnail thing is aligned right, 'new web' is a PITA as formatting never looks the same in two different browsers, see how tbk has been fubar'd with the latest phpbb for an example, the alignment of columns etc are all over the place.

Anyway I digress, I am pretty sure it previously said whether you were logged in or not, and I cannot remember if I logged in on this tablet or the PC, but just now I was able to access the edit page for one of the photos and it wasn't telling me if I was logged in or not.

So I dunno it it is by design, or whether anybody can edit the photo's, or whether it was just me because i was logged in, if that's the case, are you sure you want anybody being able to edit the database? You know what these kids are like today, any excuse to fuck something up, especially if someone else has put in the work to build it.

Also I was going to ask last night, instead of having the large photo open in a new tab/page, had you thought about using a light box to display it on the same page?

P.s is this php/mysql based?
I am very sorry if you find my posts long and boring, I like to type and often go off on a tangent.
If this is the case, you may click here to solve the problem, or alternatively here too.

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

I'm in the middle of editing it so it's not quite right at the moment.

And yes, by design it can be edited by anyone right now.

I'd like to have a lightbox yeah. At the moment the only way to get an image to display is to use $value = <img src="'.$value.'" /> I want multiple images to display, so you can put more than one URL in the box and separate it with a comma.

If you know how to get the images to display in an array based on comma separated values inside a lightbox solely using PHP code, feel free to tell me :tongue:
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

User avatar
PTRACER
Forum Administrator
Forum Administrator
Posts: 39308
Joined: 17 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 » 5 years ago

Many of these problems now solved. Who inputted the latest Bandini/Hill crash?

Just a tip - for more than one image, place each URL on a new line. Do the same for multiple drivers!

Motorsportrace: I'll eventually add another box called 'Involved' so if a spectator is killed, or a marshall, you put their name in that box instead.

This is evolving so beautifully :happy:
King of the Race Track, Destroyer of Tyres, Breaker of Lap Records

Post Reply