Quote:
Originally Posted by nineteeneleven
|
lol you reversed the Collation
e.g replace this:
PHP Code:
CREATE TABLE IF NOT EXISTS `player_tracker` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`steamid` varchar(255) CHARACTER SET latin1 NOT NULL,
`playername` varchar(255) CHARACTER SET latin1 NOT NULL,
`playerip` varchar(255) CHARACTER SET latin1 NOT NULL,
`servertype` varchar(255) CHARACTER SET latin1 NOT NULL,
`serverip` varchar(255) CHARACTER SET latin1 NOT NULL,
`serverport` varchar(255) CHARACTER SET latin1 NOT NULL,
`geoipcountry` varchar(255) CHARACTER SET latin1 NOT NULL,
`status` varchar(255) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `steamid` (`steamid`),
KEY `playername` (`playername`),
KEY `playerip` (`playerip`),
KEY `servertype` (`servertype`),
KEY `serverip` (`serverip`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
with this:
PHP Code:
CREATE TABLE IF NOT EXISTS `player_tracker` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`steamid` varchar(255) NOT NULL,
`playername` varchar(255) NOT NULL,
`playerip` varchar(255) NOT NULL,
`servertype` varchar(255) NOT NULL,
`serverip` varchar(255) NOT NULL,
`serverport` varchar(255) NOT NULL,
`geoipcountry` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `steamid` (`steamid`),
KEY `playername` (`playername`),
KEY `playerip` (`playerip`),
KEY `servertype` (`servertype`),
KEY `serverip` (`serverip`),
KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
and update in GitHub also ....
I forgot my login on GitHub