FORUMULA1.COM Pool for 2014

Make this site better with your ideas and suggestions.
What's Burning?
Banned
Posts: 21486
Joined: 24 Feb 10, 00:09
Favourite Driver: Lewis Hamilton, Nico Hulkenberg
Favourite Team: Porsche North America, Porsche LMP1
Location: PULL IN CASE OF FIRE

Re: FORUMULA1.COM Pool for 2014

Post by What's Burning? »

That explains why I was crapping out trying to use Sequel Express to edit it.
"I don't want to be part of a forum where everyone has differing opinions." Boom...
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 »

Did you get it working in the end?
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
What's Burning?
Banned
Posts: 21486
Joined: 24 Feb 10, 00:09
Favourite Driver: Lewis Hamilton, Nico Hulkenberg
Favourite Team: Porsche North America, Porsche LMP1
Location: PULL IN CASE OF FIRE

Re: FORUMULA1.COM Pool for 2014

Post by What's Burning? »

No, but were at two weeks so we can try and figure out what's the missing component. Maybe we should ping MOA just to figure out what's missing?
"I don't want to be part of a forum where everyone has differing opinions." Boom...
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 »

What is it doing?

Sent using NCC-1701
Image
A racing car that does not win, is just art
What's Burning?
Banned
Posts: 21486
Joined: 24 Feb 10, 00:09
Favourite Driver: Lewis Hamilton, Nico Hulkenberg
Favourite Team: Porsche North America, Porsche LMP1
Location: PULL IN CASE OF FIRE

Re: FORUMULA1.COM Pool for 2014

Post by What's Burning? »

It's up cause Stephen has the hosting, we've got to edit the driver and GP info and I guess figure out a way to enter the picks unless we tie them to the forum user IDs.
"I don't want to be part of a forum where everyone has differing opinions." Boom...
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 »

It's all done in those files in the db directory. As far as I can tell it's reading them in as the database. How did you enter picks previously?
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
What's Burning?
Banned
Posts: 21486
Joined: 24 Feb 10, 00:09
Favourite Driver: Lewis Hamilton, Nico Hulkenberg
Favourite Team: Porsche North America, Porsche LMP1
Location: PULL IN CASE OF FIRE

Re: FORUMULA1.COM Pool for 2014

Post by What's Burning? »

I would log into the web site as an admin and input each person's picks manually. The database kept track of the person's name, I would choose it from a drop down an put in their picks. The picks were restricted to only the driver's initials from the database and it would not allow you to enter duplicate drivers.

At the end of the GP, I'd enter the results in the same fashion for a drop down choice names results and it would tabulate the points automatically and identify the winner for the round.
"I don't want to be part of a forum where everyone has differing opinions." Boom...
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 »

Well then do that. I assume to add drivers and tracks you'd edit those files in db/
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 »

How it getting on WB?

Sent using NCC-1701
Image
A racing car that does not win, is just art
User avatar
myownalias
Mod
Posts: 9322
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: FORUMULA1.COM Pool for 2014

Post by myownalias »

I have updated all the databases with the latest drivers and races; also reset the season and player databases.

Link: http://s517129737.onlinehome.us/f1pool.zip

The files should be able to be dropped into the root directory for f1pool.forumula1.com via ftp overwriting the original files.
myownaliasThe Englishman in KansasTwitter: @myownalias
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 »

Thanks matey :-)

Is it as Lemon suggested?

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:Thanks matey :-)

Is it as Lemon suggested?

Sent using NCC-1701


Having looked through the zip, as normal I was correct again :wink:

Glad MOA came in to save the day at the last second though :hehe:
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
myownalias
Mod
Posts: 9322
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: FORUMULA1.COM Pool for 2014

Post by myownalias »

Jabberwocky wrote:Thanks matey :-)

Is it as Lemon suggested?

Sent using NCC-1701

Yes, it's simply a flat file database, just changed the names to protect the guilty!

Stephen: You will need to make sure the files in the db directory are writable and that you have a phpbb2 forum powering the admin login, I tried to use a phpbb3 but that didn't work for me; the software was written for phpbb2; I didn't write the original software and I wasn't going to recode the the entire thing for phpbb3.
myownaliasThe Englishman in KansasTwitter: @myownalias
LRW
Banned
Posts: 6708
Joined: 28 Mar 11, 11:33
Favourite Driver: H.A.M
Favourite Team: AMG P-Dog
Location: in a glass case of emotion

Re: FORUMULA1.COM Pool for 2014

Post by LRW »

myownalias wrote: ...... and I wasn't going to recode the the entire thing for phpbb3.


You just don't put the effort in, that's your problem....

:wink:
Image
User avatar
myownalias
Mod
Posts: 9322
Joined: 27 May 09, 23:16
Favourite Driver: Jenson Button
Favourite Team: Williams
Location: Wichita, KS

Re: FORUMULA1.COM Pool for 2014

Post by myownalias »

LRW wrote:
myownalias wrote: ...... and I wasn't going to recode the the entire thing for phpbb3.


You just don't put the effort in, that's your problem....

:wink:

Maybe if everyone that played the pool bought me a case of beer, maybe I would be more motivated to put the effort in! :twisted: :wink:
myownaliasThe Englishman in KansasTwitter: @myownalias