FORUMULA1.COM Pool for 2014

Make this site better with your ideas and suggestions.
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

1Lemon wrote:Drop table drivers;

It's okay they're wearing helmets.

Geek humour at its best

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

I have never managed to edit a database off line. I always fail at it.

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

I don't actually think these tables contain any of the data....

EDIT: Ignore me, I be lookin' at it.

Edit Edit: Has anyone else who has looked through the PHP and DB structure thing that this is needlessly complicated?
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

I've updated the /include/driverslist.php

https://dl.dropboxusercontent.com/u/927 ... rslist.php
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

1Lemon wrote:Edit Edit: Has anyone else who has looked through the PHP and DB structure thing that this is needlessly complicated?


Yes, but I did not want to fiddle too much in case it caught fire.
Image
A racing car that does not win, is just art
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

Jabberwocky wrote:
1Lemon wrote:Edit Edit: Has anyone else who has looked through the PHP and DB structure thing that this is needlessly complicated?


Yes, but I did not want to fiddle too much in case it caught fire.


I may just create another one for 2015 at some stage...
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

I did not realize how rusty my php skills had gotten until I tried doing a version where you log into it that we discussed a while ago
Image
A racing car that does not win, is just art
User avatar
Stephen
Site Admin
Posts: 2182
Joined: 24 Sep 05, 12:47
Favourite Driver: Kimi Raikkonen
Favourite Team: McLaren

Re: FORUMULA1.COM Pool for 2014

Post by Stephen »

I'll take another look today - could be hard coded potentially...
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

Have you tried Lemons version?

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
Stephen
Site Admin
Posts: 2182
Joined: 24 Sep 05, 12:47
Favourite Driver: Kimi Raikkonen
Favourite Team: McLaren

Re: FORUMULA1.COM Pool for 2014

Post by Stephen »

Ah yes, missed that, shame it's not in the DB itself.

BTW, how was this updated after each race before?
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

WB did magic

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

Stephen wrote:Ah yes, missed that, shame it's not in the DB itself.

BTW, how was this updated after each race before?


I thought that the PHP used the file I updated to generate the drivers list in the table when running the create database script.
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

1Lemon wrote:
Stephen wrote:Ah yes, missed that, shame it's not in the DB itself.

BTW, how was this updated after each race before?


I thought that the PHP used the file I updated to generate the drivers list in the table when running the create database script.


Ah bollocks I edited the wrong place. In DB/drivers.php I assume they are what is created on DB creation

Edit: Oh look at that I quoted myself.

Is it an actual DB as far as normal sql databases go? in DB/Drivers there seems to be files that I would assume WB would edit. The function ptb_select that the code seems to be called every time it wants to do a DB call just seems to be reading from the files in DB/... Especially as the function ptb_connect only loads a file.

So editing the files in DB/.... would seem like how this works.
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams
User avatar
Jabberwocky
Mod
Posts: 16412
Joined: 31 Jul 07, 19:51
Favourite Driver: 5 Iron
Favourite Team: Williams
Location: Oxford

Re: FORUMULA1.COM Pool for 2014

Post by Jabberwocky »

So it is not really an SQL program, the database is only really being used as a register

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
1Lemon
Posts: 3143
Joined: 28 Jun 12, 15:10
Favourite Driver: The Finnish driver that actually talks
Favourite Team: Williams Grand Prix Engineering
Location: Royal Cider Land, UK

Re: FORUMULA1.COM Pool for 2014

Post by 1Lemon »

Jabberwocky wrote:So it is not really an SQL program, the database is only really being used as a register

Sent using NCC-1701


Yeah pretty much
Mark my words, Bottas will be world champion by 2020 - Me 24/11/14

"Inherently, we at Williams just want to win races. We love going motor racing, we have a real passion for it and that never diminishes." Claire Williams