Code: Select all
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Vært: localhost
-- Genereringstid: 22. 02 2012 kl. 15:39:32
-- Serverversion: 5.1.36
-- PHP-version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `maniahost`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `rents`
--
CREATE TABLE IF NOT EXISTS `rents` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`playerLogin` varchar(25) NOT NULL,
`rentDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`duration` int(10) unsigned NOT NULL,
`cost` int(10) unsigned NOT NULL,
`serverOptions` text NOT NULL,
`gameInfos` text NOT NULL,
`maps` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Data dump for tabellen `rents`
--
INSERT INTO `rents` (`id`, `playerLogin`, `rentDate`, `duration`, `cost`, `serverOptions`, `gameInfos`, `maps`) VALUES
(1, 'rycardoo', '2012-02-14 15:50:56', 28, 28, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:37:"$fffаrै$fffа$C00Ǫ$333»$fffNadeo";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:0:"";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:2;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:360000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:2;s:17:"cupWarmUpDuration";i:2;}', 'a:65:{i:0;s:36:"Campaigns\\TMCanyon\\White\\A01.Map.Gbx";i:1;s:36:"Campaigns\\TMCanyon\\White\\A02.Map.Gbx";i:2;s:36:"Campaigns\\TMCanyon\\White\\A03.Map.Gbx";i:3;s:36:"Campaigns\\TMCanyon\\White\\A04.Map.Gbx";i:4;s:36:"Campaigns\\TMCanyon\\White\\A05.Map.Gbx";i:5;s:36:"Campaigns\\TMCanyon\\White\\A06.Map.Gbx";i:6;s:36:"Campaigns\\TMCanyon\\White\\A07.Map.Gbx";i:7;s:36:"Campaigns\\TMCanyon\\White\\A08.Map.Gbx";i:8;s:36:"Campaigns\\TMCanyon\\White\\A09.Map.Gbx";i:9;s:36:"Campaigns\\TMCanyon\\White\\A10.Map.Gbx";i:10;s:36:"Campaigns\\TMCanyon\\White\\A11.Map.Gbx";i:11;s:36:"Campaigns\\TMCanyon\\White\\A12.Map.Gbx";i:12;s:36:"Campaigns\\TMCanyon\\White\\A13.Map.Gbx";i:13;s:36:"Campaigns\\TMCanyon\\White\\A14.Map.Gbx";i:14;s:36:"Campaigns\\TMCanyon\\White\\A15.Map.Gbx";i:15;s:36:"Campaigns\\TMCanyon\\Green\\B01.Map.Gbx";i:16;s:36:"Campaigns\\TMCanyon\\Green\\B02.Map.Gbx";i:17;s:36:"Campaigns\\TMCanyon\\Green\\B03.Map.Gbx";i:18;s:36:"Campaigns\\TMCanyon\\Green\\B04.Map.Gbx";i:19;s:36:"Campaigns\\TMCanyon\\Green\\B05.Map.Gbx";i:20;s:36:"Campaigns\\TMCanyon\\Green\\B06.Map.Gbx";i:21;s:36:"Campaigns\\TMCanyon\\Green\\B07.Map.Gbx";i:22;s:36:"Campaigns\\TMCanyon\\Green\\B08.Map.Gbx";i:23;s:36:"Campaigns\\TMCanyon\\Green\\B09.Map.Gbx";i:24;s:36:"Campaigns\\TMCanyon\\Green\\B10.Map.Gbx";i:25;s:36:"Campaigns\\TMCanyon\\Green\\B11.Map.Gbx";i:26;s:36:"Campaigns\\TMCanyon\\Green\\B12.Map.Gbx";i:27;s:36:"Campaigns\\TMCanyon\\Green\\B13.Map.Gbx";i:28;s:36:"Campaigns\\TMCanyon\\Green\\B14.Map.Gbx";i:29;s:36:"Campaigns\\TMCanyon\\Green\\B15.Map.Gbx";i:30;s:35:"Campaigns\\TMCanyon\\Blue\\C01.Map.Gbx";i:31;s:35:"Campaigns\\TMCanyon\\Blue\\C02.Map.Gbx";i:32;s:35:"Campaigns\\TMCanyon\\Blue\\C03.Map.Gbx";i:33;s:35:"Campaigns\\TMCanyon\\Blue\\C04.Map.Gbx";i:34;s:35:"Campaigns\\TMCanyon\\Blue\\C05.Map.Gbx";i:35;s:35:"Campaigns\\TMCanyon\\Blue\\C06.Map.Gbx";i:36;s:35:"Campaigns\\TMCanyon\\Blue\\C07.Map.Gbx";i:37;s:35:"Campaigns\\TMCanyon\\Blue\\C08.Map.Gbx";i:38;s:35:"Campaigns\\TMCanyon\\Blue\\C09.Map.Gbx";i:39;s:35:"Campaigns\\TMCanyon\\Blue\\C10.Map.Gbx";i:40;s:35:"Campaigns\\TMCanyon\\Blue\\C11.Map.Gbx";i:41;s:35:"Campaigns\\TMCanyon\\Blue\\C12.Map.Gbx";i:42;s:35:"Campaigns\\TMCanyon\\Blue\\C13.Map.Gbx";i:43;s:35:"Campaigns\\TMCanyon\\Blue\\C14.Map.Gbx";i:44;s:35:"Campaigns\\TMCanyon\\Blue\\C15.Map.Gbx";i:45;s:34:"Campaigns\\TMCanyon\\Red\\D01.Map.Gbx";i:46;s:34:"Campaigns\\TMCanyon\\Red\\D02.Map.Gbx";i:47;s:34:"Campaigns\\TMCanyon\\Red\\D03.Map.Gbx";i:48;s:34:"Campaigns\\TMCanyon\\Red\\D04.Map.Gbx";i:49;s:34:"Campaigns\\TMCanyon\\Red\\D05.Map.Gbx";i:50;s:34:"Campaigns\\TMCanyon\\Red\\D06.Map.Gbx";i:51;s:34:"Campaigns\\TMCanyon\\Red\\D07.Map.Gbx";i:52;s:34:"Campaigns\\TMCanyon\\Red\\D08.Map.Gbx";i:53;s:34:"Campaigns\\TMCanyon\\Red\\D09.Map.Gbx";i:54;s:35:"Campaigns\\TMCanyon\\Red\\D10 .Map.Gbx";i:55;s:34:"Campaigns\\TMCanyon\\Red\\D11.Map.Gbx";i:56;s:34:"Campaigns\\TMCanyon\\Red\\D12.Map.Gbx";i:57;s:34:"Campaigns\\TMCanyon\\Red\\D13.Map.Gbx";i:58;s:34:"Campaigns\\TMCanyon\\Red\\D14.Map.Gbx";i:59;s:34:"Campaigns\\TMCanyon\\Red\\D15.Map.Gbx";i:60;s:36:"Campaigns\\TMCanyon\\Black\\E01.Map.Gbx";i:61;s:36:"Campaigns\\TMCanyon\\Black\\E02.Map.Gbx";i:62;s:36:"Campaigns\\TMCanyon\\Black\\E03.Map.Gbx";i:63;s:36:"Campaigns\\TMCanyon\\Black\\E04.Map.Gbx";i:64;s:36:"Campaigns\\TMCanyon\\Black\\E05.Map.Gbx";}'),
(2, 'mrmim', '2012-02-14 21:43:08', 48, 48, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:11:"coffee shop";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:0:"";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:2;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:300000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:2;s:17:"cupWarmUpDuration";i:2;}', 'a:4:{i:0;s:36:"Campaigns\\TMCanyon\\White\\A03.Map.Gbx";i:1;s:36:"Campaigns\\TMCanyon\\White\\A04.Map.Gbx";i:2;s:36:"Campaigns\\TMCanyon\\White\\A05.Map.Gbx";i:3;s:36:"Campaigns\\TMCanyon\\White\\A06.Map.Gbx";}'),
(3, 'kije', '2012-02-16 20:45:39', 1, 1, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:8:"Unc-test";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:0:"";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:2;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:300000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:2;s:17:"cupWarmUpDuration";i:2;}', 'a:3:{i:0;s:33:"Downloaded\\%23Like i care.Map.Gbx";i:1;s:36:"Campaigns\\TMCanyon\\White\\A01.Map.Gbx";i:2;s:37:"MX\\.FREE.PRACTISE _final__566.Map.gbx";}'),
(4, 'bryan199813', '2012-02-17 16:20:40', 1, 1, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:14:"Bryan''s Server";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:0:"";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:2;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:300000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:2;s:17:"cupWarmUpDuration";i:2;}', 'a:135:{i:0;s:33:"Downloaded\\%23Like i care.Map.Gbx";i:1;s:37:"MX\\.FREE.PRACTISE _final__566.Map.gbx";i:2;s:36:"Campaigns\\TMCanyon\\White\\A01.Map.Gbx";i:3;s:36:"Campaigns\\TMCanyon\\White\\A02.Map.Gbx";i:4;s:36:"Campaigns\\TMCanyon\\White\\A03.Map.Gbx";i:5;s:36:"Campaigns\\TMCanyon\\White\\A04.Map.Gbx";i:6;s:36:"Campaigns\\TMCanyon\\White\\A05.Map.Gbx";i:7;s:36:"Campaigns\\TMCanyon\\White\\A06.Map.Gbx";i:8;s:36:"Campaigns\\TMCanyon\\White\\A07.Map.Gbx";i:9;s:36:"Campaigns\\TMCanyon\\White\\A08.Map.Gbx";i:10;s:36:"Campaigns\\TMCanyon\\White\\A09.Map.Gbx";i:11;s:36:"Campaigns\\TMCanyon\\White\\A10.Map.Gbx";i:12;s:36:"Campaigns\\TMCanyon\\White\\A11.Map.Gbx";i:13;s:36:"Campaigns\\TMCanyon\\White\\A12.Map.Gbx";i:14;s:36:"Campaigns\\TMCanyon\\White\\A13.Map.Gbx";i:15;s:36:"Campaigns\\TMCanyon\\White\\A14.Map.Gbx";i:16;s:36:"Campaigns\\TMCanyon\\White\\A15.Map.Gbx";i:17;s:26:"MX\\Analoggins_1398.Map.gbx";i:18;s:36:"Campaigns\\TMCanyon\\Green\\B01.Map.Gbx";i:19;s:36:"Campaigns\\TMCanyon\\Green\\B02.Map.Gbx";i:20;s:36:"Campaigns\\TMCanyon\\Green\\B03.Map.Gbx";i:21;s:36:"Campaigns\\TMCanyon\\Green\\B04.Map.Gbx";i:22;s:36:"Campaigns\\TMCanyon\\Green\\B05.Map.Gbx";i:23;s:36:"Campaigns\\TMCanyon\\Green\\B06.Map.Gbx";i:24;s:36:"Campaigns\\TMCanyon\\Green\\B07.Map.Gbx";i:25;s:36:"Campaigns\\TMCanyon\\Green\\B08.Map.Gbx";i:26;s:36:"Campaigns\\TMCanyon\\Green\\B09.Map.Gbx";i:27;s:36:"Campaigns\\TMCanyon\\Green\\B10.Map.Gbx";i:28;s:36:"Campaigns\\TMCanyon\\Green\\B11.Map.Gbx";i:29;s:36:"Campaigns\\TMCanyon\\Green\\B12.Map.Gbx";i:30;s:36:"Campaigns\\TMCanyon\\Green\\B13.Map.Gbx";i:31;s:36:"Campaigns\\TMCanyon\\Green\\B14.Map.Gbx";i:32;s:36:"Campaigns\\TMCanyon\\Green\\B15.Map.Gbx";i:33;s:38:"Downloaded\\MX\\B__004_Arena-215.Map.Gbx";i:34;s:23:"MX\\Battle_12597.Map.gbx";i:35;s:24:"MX\\Bee Style_223.Map.gbx";i:36;s:25:"MX\\BetaMeta__7034.Map.gbx";i:37;s:22:"MX\\Bionic_1702.Map.gbx";i:38;s:34:"Downloaded\\Break your nose.Map.Gbx";i:39;s:35:"Campaigns\\TMCanyon\\Blue\\C01.Map.Gbx";i:40;s:35:"Campaigns\\TMCanyon\\Blue\\C02.Map.Gbx";i:41;s:35:"Campaigns\\TMCanyon\\Blue\\C03.Map.Gbx";i:42;s:35:"Campaigns\\TMCanyon\\Blue\\C04.Map.Gbx";i:43;s:35:"Campaigns\\TMCanyon\\Blue\\C05.Map.Gbx";i:44;s:35:"Campaigns\\TMCanyon\\Blue\\C06.Map.Gbx";i:45;s:35:"Campaigns\\TMCanyon\\Blue\\C07.Map.Gbx";i:46;s:35:"Campaigns\\TMCanyon\\Blue\\C08.Map.Gbx";i:47;s:35:"Campaigns\\TMCanyon\\Blue\\C09.Map.Gbx";i:48;s:35:"Campaigns\\TMCanyon\\Blue\\C10.Map.Gbx";i:49;s:35:"Campaigns\\TMCanyon\\Blue\\C11.Map.Gbx";i:50;s:35:"Campaigns\\TMCanyon\\Blue\\C12.Map.Gbx";i:51;s:35:"Campaigns\\TMCanyon\\Blue\\C13.Map.Gbx";i:52;s:35:"Campaigns\\TMCanyon\\Blue\\C14.Map.Gbx";i:53;s:35:"Campaigns\\TMCanyon\\Blue\\C15.Map.Gbx";i:54;s:29:"MX\\Canyon wulveS_6665.Map.gbx";i:55;s:34:"Downloaded\\MX\\Celcius-1700.Map.Gbx";i:56;s:29:"MX\\Chegg it out_14109.Map.gbx";i:57;s:26:"MX\\Christmas_11503.Map.gbx";i:58;s:27:"MX\\CityHunters_6661.Map.gbx";i:59;s:32:"MX\\Cliffs of Sanity_3901.Map.gbx";i:60;s:40:"Downloaded\\MX\\Coconut_Snake-1314.Map.Gbx";i:61;s:29:"Downloaded\\Cornichone.Map.Gbx";i:62;s:36:"MX\\Craggy Ridge Rockstar_953.Map.gbx";i:63;s:34:"Campaigns\\TMCanyon\\Red\\D01.Map.Gbx";i:64;s:34:"Campaigns\\TMCanyon\\Red\\D02.Map.Gbx";i:65;s:34:"Campaigns\\TMCanyon\\Red\\D03.Map.Gbx";i:66;s:34:"Campaigns\\TMCanyon\\Red\\D04.Map.Gbx";i:67;s:34:"Campaigns\\TMCanyon\\Red\\D05.Map.Gbx";i:68;s:34:"Campaigns\\TMCanyon\\Red\\D06.Map.Gbx";i:69;s:34:"Campaigns\\TMCanyon\\Red\\D07.Map.Gbx";i:70;s:34:"Campaigns\\TMCanyon\\Red\\D08.Map.Gbx";i:71;s:34:"Campaigns\\TMCanyon\\Red\\D09.Map.Gbx";i:72;s:35:"Campaigns\\TMCanyon\\Red\\D10 .Map.Gbx";i:73;s:34:"Campaigns\\TMCanyon\\Red\\D11.Map.Gbx";i:74;s:34:"Campaigns\\TMCanyon\\Red\\D12.Map.Gbx";i:75;s:34:"Campaigns\\TMCanyon\\Red\\D13.Map.Gbx";i:76;s:34:"Campaigns\\TMCanyon\\Red\\D14.Map.Gbx";i:77;s:34:"Campaigns\\TMCanyon\\Red\\D15.Map.Gbx";i:78;s:34:"Downloaded\\MX\\D___RIFT-863.Map.Gbx";i:79;s:33:"Downloaded\\Dinah-Moe Humm.Map.Gbx";i:80;s:30:"MX\\DooM Aris TM2_12718.Map.gbx";i:81;s:35:"MX\\Drinking or mapping_6256.Map.gbx";i:82;s:36:"Campaigns\\TMCanyon\\Black\\E01.Map.Gbx";i:83;s:36:"Campaigns\\TMCanyon\\Black\\E02.Map.Gbx";i:84;s:36:"Campaigns\\TMCanyon\\Black\\E03.Map.Gbx";i:85;s:36:"Campaigns\\TMCanyon\\Black\\E04.Map.Gbx";i:86;s:36:"Campaigns\\TMCanyon\\Black\\E05.Map.Gbx";i:87;s:26:"MX\\Easy_Race#5_947.Map.gbx";i:88;s:27:"Downloaded\\El Greco.Map.Gbx";i:89;s:29:"Downloaded\\Elevation .Map.Gbx";i:90;s:26:"Downloaded\\Elsweyr.Map.Gbx";i:91;s:30:"Downloaded\\MX\\Epic-682.Map.Gbx";i:92;s:36:"MX\\Escape the raffinery_6724.Map.gbx";i:93;s:35:"Downloaded\\Fearful Symmetry.Map.Gbx";i:94;s:28:"MX\\FlaschLight1_1020.Map.gbx";i:95;s:34:"MX\\Flow_er_ Power v1.2_447.Map.gbx";i:96;s:37:"Downloaded\\MX\\Fluid_Motion-77.Map.Gbx";i:97;s:31:"Downloaded\\FunkyLicious.Map.Gbx";i:98;s:36:"MX\\GEEX - Life Elevated_5827.Map.gbx";i:99;s:44:"Downloaded\\MX\\I_Believe_In__TM__-184.Map.Gbx";i:100;s:24:"MX\\Insomnia_1485.Map.gbx";i:101;s:24:"MX\\LEMONADE_8804.Map.gbx";i:102;s:38:"Downloaded\\MX\\Learning_Curve-2.Map.Gbx";i:103;s:36:"Downloaded\\MX\\Malicious-1522.Map.Gbx";i:104;s:24:"MX\\Memorize_6673.Map.gbx";i:105;s:38:"Downloaded\\MX\\Morning_Rush-721.Map.Gbx";i:106;s:27:"MX\\NascarLego_10713.Map.gbx";i:107;s:26:"Downloaded\\O-track.Map.Gbx";i:108;s:22:"MX\\RhuBarb_888.Map.gbx";i:109;s:30:"Downloaded\\RoadFight 3.Map.Gbx";i:110;s:34:"Downloaded\\MX\\Scorpio-1065.Map.Gbx";i:111;s:24:"MX\\Scrapyard_821.Map.gbx";i:112;s:41:"Downloaded\\MX\\Short_Sweet_05-2396.Map.Gbx";i:113;s:40:"Downloaded\\MX\\Slide_Life_01-1523.Map.Gbx";i:114;s:40:"Downloaded\\MX\\Slide_Life_03-1630.Map.Gbx";i:115;s:28:"MX\\Sliderscube_12492.Map.gbx";i:116;s:40:"Downloaded\\MX\\Speed_Progress-939.Map.Gbx";i:117;s:23:"MX\\Squeeze_1440.Map.gbx";i:118;s:26:"MX\\Station 101_585.Map.gbx";i:119;s:28:"Downloaded\\Sunnyside.Map.Gbx";i:120;s:34:"Downloaded\\Tech''s no shit!.Map.Gbx";i:121;s:33:"MX\\The Big Red Loop_12304.Map.gbx";i:122;s:29:"Downloaded\\The Damned.Map.Gbx";i:123;s:39:"MX\\The Night Side Eclipse_11163.Map.gbx";i:124;s:32:"MX\\The Secret Hall_12696.Map.gbx";i:125;s:40:"Downloaded\\Tortilla Chip Raceway.Map.Gbx";i:126;s:45:"Downloaded\\MX\\Tortilla_Chip_Raceway-3.Map.Gbx";i:127;s:29:"MX\\TriBuLaTions_12585.Map.gbx";i:128;s:25:"Downloaded\\Trojka.Map.Gbx";i:129;s:33:"Downloaded\\MX\\WarZone-844.Map.Gbx";i:130;s:31:"Downloaded\\White Domina.Map.Gbx";i:131;s:32:"MX\\_MTC_ Hot Wheels_6640.Map.gbx";i:132;s:32:"MX\\_Pink Hotpants__13901.Map.gbx";i:133;s:31:"Downloaded\\a Cool-Track.Map.Gbx";i:134;s:41:"MX\\mra-rounds03 dropping off_1530.Map.gbx";}'),
(5, 'mrmim', '2012-02-17 16:44:51', 1, 25, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:11:"Coffee shop";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:0:"";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:1;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:300000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:2;s:17:"cupWarmUpDuration";i:2;}', 'a:4:{i:0;s:25:"MX\\BetaMeta__7034.Map.gbx";i:1;s:22:"MX\\Bionic_1702.Map.gbx";i:2;s:34:"Downloaded\\Break your nose.Map.Gbx";i:3;s:24:"MX\\Bee Style_223.Map.gbx";}'),
(6, 'mrmim', '2012-02-22 14:45:57', 25, 25, 'a:16:{s:16:"AllowMapDownload";b:1;s:13:"CallVoteRatio";d:0.5;s:7:"Comment";s:0:"";s:10:"HideServer";i:0;s:4:"Name";s:13:"Coffee lounge";s:19:"NextCallVoteTimeOut";i:60000;s:14:"NextMaxPlayers";i:16;s:17:"NextMaxSpectators";i:16;s:8:"Password";s:5:"kaffe";s:20:"PasswordForSpectator";s:0:"";s:15:"RefereePassword";s:0:"";s:11:"RefereeMode";i:0;s:15:"AutoSaveReplays";b:0;s:25:"AutoSaveValidationReplays";b:0;s:13:"IsP2PDownload";b:1;s:11:"IsP2PUpload";b:1;}', 'O:43:"ManiaLive\\DedicatedApi\\Structures\\GameInfos":23:{s:8:"gameMode";i:4;s:6:"nbMaps";N;s:8:"chatTime";i:10000;s:13:"finishTimeout";i:1;s:17:"allWarmUpDuration";i:0;s:14:"disableRespawn";i:0;s:21:"forceShowAllOpponents";i:0;s:17:"roundsPointsLimit";i:50;s:16:"roundsForcedLaps";i:0;s:17:"roundsUseNewRules";b:0;s:25:"roundsPointsLimitNewRules";i:50;s:15:"teamPointsLimit";i:5;s:13:"teamMaxPoints";i:5;s:15:"teamUseNewRules";b:0;s:23:"teamPointsLimitNewRules";i:5;s:15:"timeAttackLimit";i:300000;s:26:"timeAttackSynchStartPeriod";i:0;s:10:"lapsNbLaps";i:5;s:13:"lapsTimeLimit";i:0;s:14:"cupPointsLimit";i:100;s:15:"cupRoundsPerMap";i:5;s:12:"cupNbWinners";i:3;s:17:"cupWarmUpDuration";i:2;}', 'a:3:{i:0;s:25:"MX\\BetaMeta__7034.Map.gbx";i:1;s:22:"MX\\Bionic_1702.Map.gbx";i:2;s:34:"Downloaded\\Break your nose.Map.Gbx";}');
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `servers`
--
CREATE TABLE IF NOT EXISTS `servers` (
`hostname` varchar(15) NOT NULL,
`port` int(10) NOT NULL,
`login` varchar(25) NOT NULL,
`superAdminPassword` varchar(50) NOT NULL DEFAULT 'SuperAdmin',
`status` varchar(50) NOT NULL,
`idRent` int(11) DEFAULT NULL,
PRIMARY KEY (`hostname`,`port`),
UNIQUE KEY `login` (`login`),
UNIQUE KEY `idRent` (`idRent`),
KEY `FK_Servers_Rents` (`idRent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Data dump for tabellen `servers`
--
INSERT INTO `servers` (`hostname`, `port`, `login`, `superAdminPassword`, `status`, `idRent`) VALUES
('127.0.0.1', 4991, 'steppie_server3', 'xxxx', 'Waiting', 6),
('127.0.0.1', 4994, 'steppie_server4', 'xxxx', 'Waiting', 4);
--
-- Begrænsninger for dumpede tabeller
--
--
-- Begrænsninger for tabel `servers`
--
ALTER TABLE `servers`
ADD CONSTRAINT `FK_Servers_Rents` FOREIGN KEY (`idRent`) REFERENCES `rents` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;