phpBB.de

Code: Alles auswählen

$sql = "SELECT * FROM " . FORMEL_DRIVERS_TABLE . " ORDER BY driver_points DESC";

Code: Alles auswählen

$sql = "SELECT * FROM " . FORMEL_DRIVERS_TABLE;

Code: Alles auswählen

DROP TABLE IF EXISTS phpbb_formel_drivers;
CREATE TABLE phpbb_formel_drivers (
  driver_id mediumint(8) NOT NULL auto_increment,
  driver_name varchar(32) NOT NULL default '',
  driver_img varchar(255) NOT NULL default '',
  driver_team mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (driver_id)
) TYPE=MyISAM;


INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (1, 'Michael Schumacher', 'ms.jpg', 5);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (2, 'Rubens Barrichello', 'rb.jpg', 5);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (3, 'Jenson Button', 'jb.jpg', 2);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (4, 'Takuma Sato', 'ts.jpg', 2);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (5, 'Fernando Alonso', 'fa.jpg', 3);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (6, 'Giancarlo Fisichella', 'gf.jpg', 3);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (7, 'Mark Webber', 'mw.jpg', 4);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (8, 'Nick Heidfeld', 'nh.jpg', 4);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (9, 'Kimi Räikkönen', 'kr.jpg', 1);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (10, 'Juan Pablo Montoya', 'jpm.jpg', 1);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (11, 'Jacques Villeneuve', 'jv.jpg', 6);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (12, 'Felipe Massa', 'fm.jpg', 6);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (13, 'David Coulthard', 'dc.jpg', 7);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (14, 'Christian Klien', 'ck.jpg', 7);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (15, 'Jarno Trulli', 'jt.jpg', 8);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (16, 'Ralf Schumacher', 'rs.jpg', 8);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (17, 'Narain Karthikeyan', 'nk.jpg', 9);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (18, 'Tiago Monteiro', 'tm.jpg', 9);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (19, 'Christijan Albers', 'ca.jpg', 10);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (20, 'Patrick Friesacher', 'pf.jpg', 10);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (21, 'Luca Badoer', 'lb.jpg', 5);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (22, 'Marc Gené', 'mg.jpg', 5);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (23, 'Antonio Pizzonia', 'ap.jpg', 4);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (24, 'Alexander Wurz', 'aw.jpg', 1);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (25, 'Pedro de la Rosa', 'pdlr.jpg', 1);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (26, 'Oliver Panis', 'op.jpg', 8);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (27, 'Chanoch Nissany', 'cn.jpg', 10);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (28, 'Ricardo Zonta', 'rz.jpg', 8);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (29, 'Vitantonio Liuzzi', 'vl.jpg', 7);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (30, 'Anthony Davidson', 'ad.jpg', 2);
INSERT INTO phpbb_formel_drivers (driver_id, driver_name, driver_img, driver_team) VALUES (31, 'Robert Doornbos', 'rd.jpg', 10);

Code: Alles auswählen

// 
// Moderator switch and options 
// 
$u_call_mod = append_sid("privmsg.$phpEx?mode=post&u=$formel_mod"); 
$l_call_mod = $lang['formel_call_mod']; 
if ($user_id == $formel_config['mod_id'] || $userdata['user_level'] == ADMIN) { 
        $u_call_mod = append_sid("./formel_results.$phpEx"); 
        $l_call_mod = $lang['formel_mod_button_text']; 
        $template->assign_block_vars('tipp_moderator', array()); 
} 
$formel_mod = $formel_config['mod_id'];

Code: Alles auswählen

// 
// Moderator switch and options 
// 
$u_call_mod = append_sid("privmsg.$phpEx?mode=post&u=$formel_mod_id"); 
$l_call_mod = $lang['formel_call_mod']; 
if ($user_id == $formel_config['mod_id'] || $userdata['user_level'] == ADMIN) { 
        $u_call_mod = append_sid("./formel_results.$phpEx"); 
        $l_call_mod = $lang['formel_mod_button_text']; 
        $template->assign_block_vars('tipp_moderator', array()); 
}

Code: Alles auswählen

in der lang_formel.php

SUCHE:

Platiert

ERSETZE

Platziert