[Final] Version 1.2014.0 - Formel 1 WebTipp - phpBB3

z4reg · Beitrag von **z4reg** » 12.06.2008 19:09

thanks problem solved!

I guess currently formel page is only viewable to register users.
So is it possible to allow guest to view only(read only) tippings/statistics/rules.

will subsilver2 changes also work on fisubice2 style

================================================
Btw.. here are some driver images taken from f1.com

nolicense.de/files/39699464/drivers.zip.html

extract drivers folder to phpbb3root/images/formel/

image path should be phpbb3root/images/formel/drivers/*.jpg

sql

Code: Alles auswählen

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 11, 2008 at 09:55 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
--

-- --------------------------------------------------------

--
-- Table structure for table `phpbb_formel_drivers`
--
-- Creation: Jun 11, 2008 at 05:36 AM
-- Last update: Jun 11, 2008 at 09:52 AM
--

DROP TABLE IF EXISTS `phpbb_formel_drivers`;
CREATE TABLE IF NOT EXISTS `phpbb_formel_drivers` (
  `driver_id` mediumint(8) unsigned NOT NULL auto_increment,
  `driver_name` varchar(255) collate utf8_bin NOT NULL default '',
  `driver_img` varchar(255) collate utf8_bin NOT NULL default '',
  `driver_team` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`driver_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=39 ;

--
-- Dumping data for table `phpbb_formel_drivers`
--

INSERT INTO `phpbb_formel_drivers` VALUES(1, 'Räikkönen, Kimi', 'drivers/kimi.jpg', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(2, 'Massa, Felipe', 'drivers/massa.jpg', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(3, 'Badoer, Luca', '', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(4, 'Gené, Mark', '', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(5, 'Heidfeld, Nick', 'drivers/nick.jpg', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(6, 'Kubica, Robert', 'drivers/kubica.jpg', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(7, 'Klien, Christian', '', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(8, 'Asmer, Marko', '', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(9, 'Vietoris, Christian', '', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(10, 'Alonso, Fernando', 'drivers/alonso.jpg', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(11, 'Piquet, Nelson Jr.', 'drivers/nelson.jpg', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(12, 'Grosjean, Romain', '', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(13, 'Yamamoto, Sakon', '', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(14, 'Grassi di, Lucas', '', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(15, 'Rosberg, Nico', 'drivers/rosberg.jpg', 4);
INSERT INTO `phpbb_formel_drivers` VALUES(16, 'Nakajima, Kazuki', 'drivers/naka.jpg', 4);
INSERT INTO `phpbb_formel_drivers` VALUES(17, 'Hülkenberg, Nico', '', 4);
INSERT INTO `phpbb_formel_drivers` VALUES(18, 'Coulthard, David', 'drivers/david.jpg', 5);
INSERT INTO `phpbb_formel_drivers` VALUES(19, 'Webber, Marc', 'drivers/weber.jpg', 5);
INSERT INTO `phpbb_formel_drivers` VALUES(20, 'Buemi, Sebstian', '', 5);
INSERT INTO `phpbb_formel_drivers` VALUES(21, 'Trulli, Jarno', 'drivers/trulli.jpg', 6);
INSERT INTO `phpbb_formel_drivers` VALUES(22, 'Glock, Timo', 'drivers/glock.jpg', 6);
INSERT INTO `phpbb_formel_drivers` VALUES(23, 'Kobayashi, Kamui', '', 6);
INSERT INTO `phpbb_formel_drivers` VALUES(24, 'Bourdais, Sébastien', 'drivers/sb.jpg', 7);
INSERT INTO `phpbb_formel_drivers` VALUES(25, 'Vettel, Sebastian', 'drivers/vettel.jpg', 7);
INSERT INTO `phpbb_formel_drivers` VALUES(26, 'Button, Jenson', 'drivers/jenson.jpg', 8);
INSERT INTO `phpbb_formel_drivers` VALUES(27, 'Barrichello, Rubens', 'drivers/ruben.jpg', 8);
INSERT INTO `phpbb_formel_drivers` VALUES(28, 'Wurz, Alexander', '', 8);
INSERT INTO `phpbb_formel_drivers` VALUES(29, 'Sato, Takuma', 'drivers/sato.jpg', 9);
INSERT INTO `phpbb_formel_drivers` VALUES(30, 'Davidson, Anthony', 'drivers/davidson.jpg', 9);
INSERT INTO `phpbb_formel_drivers` VALUES(31, 'Rossiter, James', '', 9);
INSERT INTO `phpbb_formel_drivers` VALUES(32, 'Sutil, Adrian', 'drivers/sutil.jpg', 10);
INSERT INTO `phpbb_formel_drivers` VALUES(33, 'Fisichella, Giancarlo', 'drivers/fisi.jpg', 10);
INSERT INTO `phpbb_formel_drivers` VALUES(34, 'Liuzzi, Vitantonio', '', 10);
INSERT INTO `phpbb_formel_drivers` VALUES(35, 'Hamilton, Lewis', 'drivers/lewis.jpg', 11);
INSERT INTO `phpbb_formel_drivers` VALUES(36, 'Kovalainen, Heikki', 'drivers/heikki.jpg', 11);
INSERT INTO `phpbb_formel_drivers` VALUES(37, 'Rosa de la, Pedro', '', 11);
INSERT INTO `phpbb_formel_drivers` VALUES(38, 'Paffet, Gary', '', 11);

^^^use only if Dr.Death gives it green light

Beitrag von **Dr.Death** » 12.06.2008 20:26

First: Thanks for the images... but: Do we have the license to use them ?
( copyright ? --> http://www.formula1.com/teams_and_drivers/ --> © 1999-2008 Formula One Administration Ltd
)

Second: Thanks for the SQL statements, but this code above is not "utf8" conform. This webpage show it in iso-8859-1 ( not in utf8 ).

Third: Yes, the fisubice2 is subsilver2 based.

And last but not least: Sorry, this MOD is designed for registered users only.
Reason: I did not script some code to remove the "submit, edit, delete buttons" and dropdown boxes for guests.

z4reg · Beitrag von **z4reg** » 12.06.2008 21:14

ok! i don't have license for images .. i have removed the link.

Is it possible for you to add custom logic

If field1: field1.option == field1 : resultinput1 = few points
eg:
Who will pit first : (options -drop down list of driver names) == (moderation)Who will pit first : (options -drop down list of driver names)

also if you wish take look @
totalf1.com/ppp/
f1tipping.com

Beitrag von **Dr.Death** » 12.06.2008 21:22

It would be possible, but i will not extend this mod.

The easiest way to to it:

Rename the field for " fastest lap " into " first pit stop ".

OPEN:

language/en/formel.php

FIND:

Code: Alles auswählen

	'FORMEL_PACE'					=> 'Fastest lap',

REPLACE WITH:

Code: Alles auswählen

	'FORMEL_PACE'					=> 'First pit stop',

I will not add extra fields to this mod.

z4reg · Beitrag von **z4reg** » 13.06.2008 07:00

With little phpbb knowledge ..i have already did that ..for tired count to Number of finishers. But i need more questions... just idea or request if you decide to enhance the mod in future.

OK we already have
Top 8 drivers of the race (3 points for correct placing within the top 8, 1 for any top 8 guess)
Who will do the fastest lap?
How many drivers will finish the race?

Needed..
Wet or dry race? (options: wet / Dry)
Will the safety car be utilized? (options: yes / no)
Will any team get the top 2 positions? (options: yes / no)
Will there be any accident? (options: yes / no)
Who will take pole position? (options: driver drop down list)
How many teams get both drivers in top 10 quali?

Event based ..for example canada, normally asked by the winner of previous round ...here i think admin/mod can add question manually.
Will any of drivers hit the Wall of Champions?

It would be possible, but i will not extend this mod.

I will not add extra fields to this mod.

i guess time problem!

Currently is it possible to arrange driver names in drop down list according to the points & remove the option already choosen(limited top 8 tipps) ? JavaScript!

Thanks a lot for your kind support & help

Beitrag von **Dr.Death** » 13.06.2008 12:33

Sorry, i have not planned any other changes to this existing mod.

Only Bugfixes..... this mod is nearly bugfree. ( And should be released as it is )

z4reg · Beitrag von **z4reg** » 13.06.2008 12:59

Ok! ... so after first release ..will see some new features

After deleting race its doesn't remove points allocated to users for that race ..is that bug

Had to manually remove that row from db.

btw ..can use please provide me with the sql query of phpbb_formel_races updated with result till canada ..please (lazy me )

how to show only current drivers (only race drivers eg: kimi & Massa)?

Beitrag von **Dr.Death** » 13.06.2008 14:14

Thats not a bug.

If there was a race, and points are given there is no reason to delete the race.

You should only delete a race if no results and points are given

Before you remove a race: Go into the moderation and delete the results.
After removing results you can delete the race.

The only way now is to reset the saison in ACP.

I could provide you my SQL, but it won't work with your installation.
Reason: My private website runs another database with different driver ids and race id.....

z4reg · Beitrag von **z4reg** » 13.06.2008 15:32

I have done the backup of the phpbb_formel_drivers table & remove reserved & test drivers

Code: Alles auswählen

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 13, 2008 at 06:28 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


-- --------------------------------------------------------

--
-- Table structure for table `phpbb_formel_drivers`
--

CREATE TABLE `phpbb_formel_drivers` (
  `driver_id` mediumint(8) unsigned NOT NULL auto_increment,
  `driver_name` varchar(255) collate utf8_bin NOT NULL default '',
  `driver_img` varchar(255) collate utf8_bin NOT NULL default '',
  `driver_team` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`driver_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=39 ;

--
-- Dumping data for table `phpbb_formel_drivers`
--

INSERT INTO `phpbb_formel_drivers` VALUES(1, 'Räikkönen, Kimi', 'drivers/kimi.jpg', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(2, 'Massa, Felipe', 'drivers/massa.jpg', 1);
INSERT INTO `phpbb_formel_drivers` VALUES(5, 'Heidfeld, Nick', 'drivers/nick.jpg', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(6, 'Kubica, Robert', 'drivers/kubica.jpg', 2);
INSERT INTO `phpbb_formel_drivers` VALUES(10, 'Alonso, Fernando', 'drivers/alonso.jpg', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(11, 'Piquet, Nelson Jr.', 'drivers/nelson.jpg', 3);
INSERT INTO `phpbb_formel_drivers` VALUES(15, 'Rosberg, Nico', 'drivers/rosberg.jpg', 4);
INSERT INTO `phpbb_formel_drivers` VALUES(16, 'Nakajima, Kazuki', 'drivers/naka.jpg', 4);
INSERT INTO `phpbb_formel_drivers` VALUES(18, 'Coulthard, David', 'drivers/david.jpg', 5);
INSERT INTO `phpbb_formel_drivers` VALUES(19, 'Webber, Mark', 'drivers/weber.jpg', 5);
INSERT INTO `phpbb_formel_drivers` VALUES(21, 'Trulli, Jarno', 'drivers/trulli.jpg', 6);
INSERT INTO `phpbb_formel_drivers` VALUES(22, 'Glock, Timo', 'drivers/glock.jpg', 6);
INSERT INTO `phpbb_formel_drivers` VALUES(24, 'Bourdais, Sébastien', 'drivers/sb.jpg', 7);
INSERT INTO `phpbb_formel_drivers` VALUES(25, 'Vettel, Sebastian', 'drivers/vettel.jpg', 7);
INSERT INTO `phpbb_formel_drivers` VALUES(26, 'Button, Jenson', 'drivers/jenson.jpg', 8);
INSERT INTO `phpbb_formel_drivers` VALUES(27, 'Barrichello, Rubens', 'drivers/ruben.jpg', 8);
INSERT INTO `phpbb_formel_drivers` VALUES(29, 'Sato, Takuma', 'drivers/sato.jpg', 9);
INSERT INTO `phpbb_formel_drivers` VALUES(30, 'Davidson, Anthony', 'drivers/davidson.jpg', 9);
INSERT INTO `phpbb_formel_drivers` VALUES(32, 'Sutil, Adrian', 'drivers/sutil.jpg', 10);
INSERT INTO `phpbb_formel_drivers` VALUES(33, 'Fisichella, Giancarlo', 'drivers/fisi.jpg', 10);
INSERT INTO `phpbb_formel_drivers` VALUES(35, 'Hamilton, Lewis', 'drivers/lewis.jpg', 11);
INSERT INTO `phpbb_formel_drivers` VALUES(36, 'Kovalainen, Heikki', 'drivers/heikki.jpg', 11);

Will it cause any problems?

90000 sec for deadline to stop tipping before 1 hours of qualifying(25hrs) ?

Beitrag von **Dr.Death** » 13.06.2008 20:14

This shouldn't be a problem.

Yes 90000 is correct for a deadline 1 hour before qualifying begins. ( normaly 25h )