PHP-Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Datenbank: `92_gutscheinseite`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `vms_ralleydaten`
--
CREATE TABLE IF NOT EXISTS `vms_ralleydaten` (
`ralley` varchar(50) NOT NULL default '',
`start` int(11) NOT NULL default '0',
`ende` int(11) NOT NULL default '0',
`art` varchar(50) NOT NULL default '',
`pro` double(10,2) NOT NULL default '0.00',
`jackpot` double(10,2) NOT NULL default '0.00',
`plaetze` int(2) NOT NULL default '0',
`p1` double(10,2) NOT NULL default '0.00',
`p2` double(10,2) NOT NULL default '0.00',
`p3` double(10,2) NOT NULL default '0.00',
`p4` double(10,2) NOT NULL default '0.00',
`p5` double(10,2) NOT NULL default '0.00',
`p6` double(10,2) NOT NULL default '0.00',
`p7` double(10,2) NOT NULL default '0.00',
`p8` double(10,2) NOT NULL default '0.00',
`p9` double(10,2) NOT NULL default '0.00',
`p10` double(10,2) NOT NULL default '0.00',
`mclick` int(10) NOT NULL default '0',
PRIMARY KEY (`ralley`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `vms_ralleydaten`
--
INSERT INTO `vms_ralleydaten` (`ralley`, `start`, `ende`, `art`, `pro`, `jackpot`, `plaetze`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`, `mclick`) VALUES
('refralley', 1267459200, 1270123200, 'statisch', 1000000.00, 0.00, 3, 10000000.00, 5000000.00, 2500000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0),
('aktivralley', 1265475600, 1270555200, 'statisch', 10000000.00, 0.00, 4, 3000000.00, 1000000.00, 750000.00, 250000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0),
('klickralley', 1264953600, 1270040400, 'statisch', 3.00, 0.00, 5, 1000000.00, 500000.00, 250000.00, 100000.00, 50000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0),
('tgameralley', 1268002860, 1268089260, 'dynamisch', 0.50, 0.00, 3, 40.00, 37.00, 18.00, 10.00, 5.00, 0.00, 0.00, 0.00, 0.00, 0.00, 50000),
('spendenklickralley', 1104534000, 1230764400, 'dynamisch', 5.00, 0.00, 2, 75.00, 25.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0);
Irgendwie laufen die Ralleys Slot of the Week und Tagesgamerally nicht mehr, sie zählen nicht mehr die Aktivpunkte.