[Beta] WorldCup WebTip 2006 (WM Tippspiel)

In diesem Forum können Mod-Autoren ihre Mods vorstellen, die sich noch im Entwicklungsstatus befinden. Der Einbau in Foren im produktiven Betrieb wird nicht empfohlen.
Forumsregeln
phpBB 2.0 hat das Ende seiner Lebenszeit überschritten
phpBB 2.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 2.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf phpBB 3.0, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Antworten
Benutzeravatar
Dr.Urlaub
Mitglied
Beiträge: 371
Registriert: 13.01.2003 13:59
Wohnort: Magdeburg
Kontaktdaten:
Kontaktdaten von Dr.Urlaub

Beitrag 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 !!!
Wer etwas will, sucht Wege.
Wer etwas nicht will, sucht Gründe.
Nach oben
Soki Sokrates
Mitglied
Beiträge: 130
Registriert: 22.04.2005 04:58

Beitrag 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.

Nach oben
Benutzeravatar
AceVentura
Mitglied
Beiträge: 366
Registriert: 30.07.2005 02:16
Wohnort: Altenkirchen
Kontaktdaten:
Kontaktdaten von AceVentura

Beitrag 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
Nach oben
Benutzeravatar
AceVentura
Mitglied
Beiträge: 366
Registriert: 30.07.2005 02:16
Wohnort: Altenkirchen
Kontaktdaten:
Kontaktdaten von AceVentura

Beitrag 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 !
Nach oben
tomtom
Mitglied
Beiträge: 2533
Registriert: 21.05.2004 10:00

Beitrag von tomtom »

@ Lumpi: [ externes Bild ]
Gruß, Tom
Nach oben
Lumpi007
Mitglied
Beiträge: 639
Registriert: 23.05.2005 21:25
Wohnort: Hasbergen
Kontaktdaten:
Kontaktdaten von Lumpi007

Beitrag 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.
Nach oben
Lumpi007
Mitglied
Beiträge: 639
Registriert: 23.05.2005 21:25
Wohnort: Hasbergen
Kontaktdaten:
Kontaktdaten von Lumpi007

Beitrag 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 ;
Nach oben
Soki Sokrates
Mitglied
Beiträge: 130
Registriert: 22.04.2005 04:58

Beitrag 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?
Nach oben
Benutzeravatar
Dr.Urlaub
Mitglied
Beiträge: 371
Registriert: 13.01.2003 13:59
Wohnort: Magdeburg
Kontaktdaten:
Kontaktdaten von Dr.Urlaub

Beitrag 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 !
Wer etwas will, sucht Wege.
Wer etwas nicht will, sucht Gründe.
Nach oben
Soki Sokrates
Mitglied
Beiträge: 130
Registriert: 22.04.2005 04:58

Beitrag von Soki Sokrates »

Soki Sokrates hat geschrieben:Kann man eigentlich einen als MOD eingegebenes Endergebniss noch ändern?
Geht. Grad selbst getestet. Bravo!
Nach oben
Antworten

Zurück zu „phpBB 2.0: Mods in Entwicklung“