I have these three tables in database:
Code: Select all
CREATE TABLE IF NOT EXISTS `wc3_player_race` (
`player_id` int(8) unsigned NOT NULL DEFAULT '0',
`race_id` tinyint(4) unsigned NOT NULL DEFAULT '0',
`race_xp` int(8) DEFAULT NULL,
PRIMARY KEY (`player_id`,`race_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table `wc3_player_race`
--
INSERT INTO `wc3_player_race` (`player_id`, `race_id`, `race_xp`) VALUES
(3, 4, 215),
Code: Select all
CREATE TABLE IF NOT EXISTS `wc3_player` (
`player_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`player_steamid` varchar(25) NOT NULL DEFAULT '',
`player_ip` varchar(20) NOT NULL DEFAULT '',
`player_name` varchar(35) NOT NULL DEFAULT '',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`player_id`),
KEY `player_name` (`player_name`),
KEY `player_ip` (`player_ip`),
KEY `player_steamid` (`player_steamid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5430;
--
-- Table `wc3_player`
--
INSERT INTO `wc3_player` (`player_id`, `player_steamid`, `player_ip`, `player_name`, `time`) VALUES
(3, '', '', 'UserName', '2010-10-24 15:11:20');
Code: Select all
CREATE TABLE IF NOT EXISTS `wc3_config` (
`config_id` varchar(50) NOT NULL,
`config_value` varchar(255) NOT NULL,
PRIMARY KEY (`config_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table `wc3_config`
--
INSERT INTO `wc3_config` (`config_id`, `config_value`) VALUES
('level0_xp', '0'),
('level1_xp', '400'),
('level2_xp', '800'),
('level3_xp', '1600'),
('level4_xp', '3200'),
('level5_xp', '6400'),
('level6_xp', '12800'),
('level7_xp', '25600'),
('level8_xp', '51200'),
('level9_xp', '102400'),
('level10_xp', '204800'),
('version', '3.0 RC13'),
('sql_conversion', '1');