phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

[Beta] WorldCup WebTip 2006 (WM Tippspiel)

https://www.phpbb.de/community/viewtopic.php?t=113722

Seite 82 von 204

Verfasst: 08.06.2006 00:13
von Dr.Urlaub
liegt daran, dass die zeilte
$location_url = "faq.$phpEx?pane=right";
nicht existiert, sondern so lautet
$location_url = "index.$phpEx?pane=right";
ansonsten muss ich sagen. alles top. keine fehler entdeckt.
alles wunderbar.

hoffe jetzt nur, dass die tipps auch wirklich ab dem spielbeginn nicht mehr verändert werden können.
das hab ich jetzt nicht getestet.

vielel vielen dank ace !!!

Verfasst: 08.06.2006 00:13
von Soki Sokrates
Was noch endgeil wäre, wäre ne Bonusfrage "Wer wird Torschützenkönig?" und dafür nochmal 10 Punkte oder so!!!


Könnte man das noch schnell einbauen??? Das fänd ich prima!!!

Weitere Bonusfragen wären zwar denkbar, aber damit wäre ich vollaufs zufrieden.

Verfasst: 08.06.2006 00:14
von AceVentura
Lumpi007 hat geschrieben:Mir fehlt noch das gif Bild

templates/subSilver/images/icon_mini_wm.gif


Hat das wer für mich?

Is das nich dabei ?? Ich guck gleich mal nach....

edit: ist bei mir drin !!! also im Download

Verfasst: 08.06.2006 00:17
von AceVentura
hoffe jetzt nur, dass die tipps auch wirklich ab dem spielbeginn nicht mehr verändert werden können.
das hab ich jetzt nicht getestet.
Bitte unbedingt testen!!! Durch die unterschiedlichen Foren (bei manchen stimmen die Zeiten bei manchen nicht) bin ich sehr verunsichert, ob der Schutz wirklich greift


Ich werde das morgen, wenn hier etwas Ruhe eingekehrt ist selber auch nochmal testen......(Spielzeit auf morgen ändern und testen obs klappt)
Wär aber gut, wenn das noch jemand testen könnte, bei dem die Zeiten falsch angezeigt wurden !

Verfasst: 08.06.2006 00:18
von tomtom
@ Lumpi: [ externes Bild ]

Verfasst: 08.06.2006 00:18
von Lumpi007
AceVentura hat geschrieben:
Lumpi007 hat geschrieben:Mir fehlt noch das gif Bild

templates/subSilver/images/icon_mini_wm.gif


Hat das wer für mich?

Is das nich dabei ?? Ich guck gleich mal nach....

edit: ist bei mir drin !!! also im Download
Sorry, mein Fehler. Ich habe das falsch abgelegt.

Verfasst: 08.06.2006 00:21
von Lumpi007
Ich bekomme jetzt diesen Fehler angezeigt.

Allgemeiner Fehler

Could not query config information in wm configuration

DEBUG MODE

SQL Error : 1146 Table 'usr_web55_1.phpbb_wm_config' doesn't exist

SELECT * FROM phpbb_wm_config

Line : 33
File : functions_wm.php


Ich habe nur die Dateien bearbeitet.


Das habe ich nicht eingefügt, nur wo kommt das jetzt genau hin?
Stammt aus der Anleitung

Code: Alles auswählen

#
#-----[ SQL ]------------------------------------------
#

DROP TABLE IF EXISTS `phpbb_wm_config`;
CREATE TABLE `phpbb_wm_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('points_match', '5');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('points_tendency', '2');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wm_mod_id', '2');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wa', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wb', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wc', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wd', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('we', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wf', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wg', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wh', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('ra', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rb', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rc', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rd', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('re', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rf', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rg', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('rh', '');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('points_winner', '100');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('restrict_to', '0');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('points_grafical', '1');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('wm_forum_id', '0');
INSERT INTO `phpbb_wm_config` (`config_name`, `config_value`) VALUES ('points_tordiff', '3');

DROP TABLE IF EXISTS `phpbb_wm_finals`;
CREATE TABLE `phpbb_wm_finals` (
  `game_id` mediumint(8) NOT NULL auto_increment,
  `game_time` int(11) NOT NULL default '0',
  `game_home` varchar(8) NOT NULL default '',
  `game_away` varchar(8) NOT NULL default '',
  `game_loc` varchar(255) NOT NULL default '',
  `game_loclink` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`game_id`)
) TYPE=MyISAM AUTO_INCREMENT=65 ;

INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (49, 1151164800, 'wa', 'rb', 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (50, 1151179200, 'wc', 'rd', 'Leipzig', 'http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (51, 1151251200, 'wb', 'ra', 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (52, 1151265600, 'wd', 'rc', 'Nürnberg', 'http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (53, 1151337600, 'we', 'rf', 'Kaiserslautern', 'http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (54, 1151352000, 'wg', 'rh', 'Köln', 'http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (55, 1151424000, 'wf', 're', 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (56, 1151438400, 'wh', 'rg', 'Hannover', 'http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (57, 1151683200, '49', '50', 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (58, 1151697600, '53', '54', 'Hamburg', 'http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (59, 1151769600, '51', '52', 'Gelsenkirchen', 'http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (60, 1151784000, '55', '56', 'Frankfurt', 'http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (61, 1152043200, '57', '58', 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (62, 1152129600, '59', '60', 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (63, 1152388800, '61', '62', 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_finals` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (64, 1152471600, '61', '62', 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');

DROP TABLE IF EXISTS `phpbb_wm_games`;
CREATE TABLE `phpbb_wm_games` (
  `game_id` mediumint(8) NOT NULL auto_increment,
  `game_time` int(11) NOT NULL default '0',
  `game_home` mediumint(8) NOT NULL default '0',
  `game_away` mediumint(8) NOT NULL default '0',
  `game_loc` varchar(255) NOT NULL default '',
  `game_loclink` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`game_id`)
) TYPE=MyISAM AUTO_INCREMENT=51 ;

INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (1, 1149872400, 1, 2, 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (2, 1149883200, 3, 4, 'Gelsenkirchen', 'http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (3, 1150315200, 1, 3, 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (4, 1150380000, 4, 2, 'Hamburg', 'http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (5, 1150815600, 4, 1, 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (6, 1150815600, 2, 3, 'Hannover', 'http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (7, 1149948000, 5, 6, 'Frankfurt', 'http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (8, 1149958800, 7, 8, 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (9, 1150390800, 5, 7, 'Nürnberg', 'http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (10, 1150401600, 8, 6, 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (11, 1150833600, 8, 5, 'Köln', 'http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (12, 1150833600, 6, 7, 'Kaiserslautern', 'http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (13, 1149969600, 9, 10, 'Hamburg', 'http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (14, 1150034400, 11, 12, 'Leipzig', 'http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (15, 1150466400, 9, 11, 'Gelsenkirchen', 'http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (16, 1150477200, 12, 10, 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (17, 1150920000, 12, 9, 'Frankfurt', 'http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (18, 1150920000, 10, 11, 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (19, 1150045200, 13, 14, 'Nürnberg', 'http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (20, 1150056000, 15, 16, 'Köln', 'http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (21, 1150488000, 13, 15, 'Hannover', 'http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (22, 1150552800, 16, 14, 'Frankfurt', 'http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (23, 1150902000, 16, 13, 'Gelsenkirchen', 'http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (24, 1150902000, 14, 15, 'Leipzig', 'http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (25, 1150142400, 17, 18, 'Hannover', 'http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (26, 1150131600, 19, 20, 'Gelsenkirchen', 'http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (27, 1150574400, 17, 19, 'Kaiserslautern', 'http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (28, 1150563600, 20, 18, 'Köln', 'http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (29, 1150988400, 20, 17, 'Hamburg', 'http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (30, 1150988400, 18, 19, 'Nürnberg', 'http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (31, 1150228800, 21, 22, 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (32, 1150120800, 23, 24, 'Kaiserslautern', 'http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (33, 1150650000, 21, 23, 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (34, 1150639200, 24, 22, 'Nürnberg', 'http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (35, 1151006400, 24, 21, 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (36, 1151006400, 22, 23, 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (37, 1150218000, 25, 26, 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (38, 1150207200, 27, 28, 'Frankfurt', 'http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (39, 1150660800, 25, 27, 'Leipzig', 'http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (40, 1150725600, 28, 26, 'Dortmund', 'http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (41, 1151092800, 28, 25, 'Köln', 'http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (42, 1151092800, 26, 27, 'Hannover', 'http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (43, 1150293600, 29, 30, 'Leipzig', 'http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (44, 1150304400, 31, 32, 'München', 'http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (45, 1150747200, 29, 31, 'Stuttgart', 'http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (46, 1150736400, 32, 30, 'Hamburg', 'http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (47, 1151074800, 32, 29, 'Kaiserslautern', 'http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` (`game_id`, `game_time`, `game_home`, `game_away`, `game_loc`, `game_loclink`) VALUES (48, 1151074800, 30, 31, 'Berlin', 'http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');

DROP TABLE IF EXISTS `phpbb_wm_results`;
CREATE TABLE `phpbb_wm_results` (
  `result_id` mediumint(8) NOT NULL auto_increment,
  `result_game` mediumint(8) NOT NULL default '0',
  `result_home` mediumint(8) NOT NULL default '0',
  `result_away` mediumint(8) NOT NULL default '0',
  `final_winner` mediumint(8) NOT NULL default '0',
  `final_loser` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`result_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `phpbb_wm_teams`;
CREATE TABLE `phpbb_wm_teams` (
  `team_id` mediumint(8) NOT NULL auto_increment,
  `team_name` varchar(255) NOT NULL default '',
  `team_img` varchar(255) NOT NULL default '',
  `team_link` varchar(255) NOT NULL default '',
  `team_group` varchar(5) NOT NULL default '',
  `team_points` mediumint(4) NOT NULL default '0',
  `team_goals` mediumint(8) NOT NULL default '0',
  `team_gotgoals` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`team_id`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;

INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (1, 'Deutschland', 'germany.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=GER', 'A', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (2, 'Costa Rica', 'costarica.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=CRC', 'A', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (3, 'Polen', 'polen.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=POL', 'A', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (4, 'Ecuador', 'ecuador.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ECU', 'A', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (5, 'England', 'england.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ENG', 'B',  0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (6, 'Paraguay', 'paraguay.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=PAR', 'B', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (7, 'Trinidad und Tobago', 'trinidad.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=TRI', 'B', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (8, 'Schweden', 'schweden.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=SWE', 'B', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (9, 'Argentinien', 'argentinien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ARG', 'C', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (10, 'Elfenbeinküste', 'elfenbein.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=CIV', 'C', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (11, 'Serbien und Montenegro', 'serbien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=SCG', 'C', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (12, 'Niederlande', 'niederlande.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=NED', 'C', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (13, 'Mexiko', 'mexiko.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=MEX', 'D', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (14, 'Iran', 'iran.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=IRN', 'D', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (15, 'Angola', 'angola.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ANG', 'D', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (16, 'Portugal', 'portugal.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=POR', 'D', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (17, 'Italien', 'italien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ITA', 'E', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (18, 'Ghana', 'ghana.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=GHA', 'E', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (19, 'USA', 'usa.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=USA', 'E', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (20, 'Tschechische Republik', 'tschech.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=CZE', 'E', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (21, 'Brasilien', 'brasilien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=BRA', 'F', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (22, 'Kroatien', 'kroatien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=CRO', 'F', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (23, 'Australien', 'australien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=AUS', 'F', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (24, 'Japan', 'japan.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=JPN', 'F', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (25, 'Frankreich', 'frankreich.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=FRA', 'G', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (26, 'Schweiz', 'schweiz.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=SUI', 'G', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (27, 'Republik Korea', 'korea.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=KOR', 'G', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (28, 'Togo', 'togo.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=TOG', 'G', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (29, 'Spanien', 'spanien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=ESP', 'H', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (30, 'Ukraine', 'ukraine.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=UKR', 'H', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (31, 'Tunesien', 'tunesien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=TUN', 'H', 0, 0, 0);
INSERT INTO `phpbb_wm_teams` (`team_id`, `team_name`, `team_img`, `team_link`, `team_group`, `team_points`, `team_goals`, `team_gotgoals`) VALUES (32, 'Saudiarabien', 'saudiarabien.gif', 'http://fifaworldcup.yahoo.com/06/de/w/team/overview.html?team=KSA', 'H', 0, 0, 0);

DROP TABLE IF EXISTS `phpbb_wm_tipps`;
CREATE TABLE `phpbb_wm_tipps` (
  `tipp_id` mediumint(8) NOT NULL auto_increment,
  `tipp_game` mediumint(8) NOT NULL default '0',
  `tipp_time` int(11) NOT NULL default '0',
  `tipp_user` mediumint(8) NOT NULL default '0',
  `tipp_home` mediumint(8) NOT NULL default '0',
  `tipp_away` mediumint(8) NOT NULL default '0',
  `tipp_points` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`tipp_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Verfasst: 08.06.2006 00:22
von Soki Sokrates
Kann man eigentlich einen als MOD eingegebenes Endergebniss noch ändern?

Wollt das nämlich grad testen und trau mich nicht. Wollt gucken, ob die Punkte richtig zusammengezählt werden und so.

Ausserdem kann man sich ja immer wiedr mal vertippen. Kann ich also ohne Gefahr mal austesten? Bestimmt. Eigentlich mal wieder ne blöde frage, ich gebs zu.

Naja "Ich weiss, dass ich nichts weiss" - meine Standardausrede.

Geht das mit dem Torschützenkönig?

Verfasst: 08.06.2006 00:25
von Dr.Urlaub
wegen dem sql-problem:
einfach die db_update.php ausführen.

ergebnisse kansnte manuell in der datenbank ändern.
musst nur aufpassen, dass du auch die punkte wieder auf 0 zurücksetzt !

Verfasst: 08.06.2006 00:25
von Soki Sokrates
Soki Sokrates hat geschrieben:Kann man eigentlich einen als MOD eingegebenes Endergebniss noch ändern?
Geht. Grad selbst getestet. Bravo!
Alle Zeiten sind UTC+02:00
Seite 82 von 204

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de