[XiuzSource] [v62] XiuzSource.sql Syntax Error

[Ghoul]

I've been trying my hand at creating a server and so far I've been able to get to the character select screen but no further. I think it's because when I execute the XiuzSource SQL file there's an error. Here's the code from the last bit of the SQL file:

14809 DROP TABLE IF EXISTS `viprockmaps`;
CREATE TABLE `viprockmaps` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(10) unsigned DEFAULT NULL,
`mapid` int(10) unsigned DEFAULT NULL,
`type` tinyint(1) unsigned DEFAULT NULL,
PRIMARY KEY (`id`), UNIQUE KEY `cid` (`cid`,`mapid`,`type`),
UNIQUE KEY `cid_2` (`cid`,`mapid`,`type`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;​

--​

-- Dumping data for table `viprockmaps`​

--​

/*!40000 ALTER TABLE `viprockmaps` DISABLE KEYS */;​

/*!40000 ALTER TABLE `viprockmaps` ENABLE KEYS */;

--
-- Definition of table `wishlist`
--

DROP TABLE IF EXISTS `wishlist`;
CREATE TABLE `wishlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`charid` int(11)NOT NULL,
`sn` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `charid` (`charid`,`sn`),
UNIQUE KEY `charid_2` (`charid`,`sn`),
UNIQUE KEY `charid_3` (`charid`,`sn`),
UNIQUE KEY `charid_4` (`charid`,`sn`),
UNIQUE KEY `charid_5` (`charid`,`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wishlist`
--

/*!40000 ALTER TABLE `wishlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `wishlist` ENABLE KEYS */;
--
-- Definition of table `zaksquads`
--

DROP TABLE IF EXISTS `zaksquads`;
CREATE TABLE `zaksquads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`channel` int(10) unsigned NOT NULL,
`leaderid` int(10) unsigned NOT NULL DEFAULT '0',
`status` int(10) unsigned NOT NULL DEFAULT '0',
`members` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zaksquads`
--

/*!40000 ALTER TABLE `zaksquads` DISABLE KEYS */;
/*!40000 ALTER TABLE `zaksquads` ENABLE KEYS */;

--
-- Definition of view `readable_cheatlog`
--

DROP TABLE IF EXISTS `readable_cheatlog`;
DROP VIEW IF EXISTS `readable_cheatlog`;
​

14881 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,`cl`.`offense` AS `offense`,`cl`.`count` AS `count`,`cl`.`lastoffensetime` AS `lastoffensetime`,`cl`.`param` AS `param` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`cid` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (`a`.`banned` = 0));

--
-- Definition of view `readable_gmlog`
--

DROP TABLE IF EXISTS `readable_gmlog`;
DROP VIEW IF EXISTS `readable_gmlog`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_gmlog` AS select `g`.`id` AS `logentryid`,`a`.`name` AS `accountname`,`c`.`name` AS `charname`,`g`.`command` AS `command`,`g`.`when` AS `when` from ((`characters` `c` join `gmlog` `g`) join `accounts` `a`) where ((`c`.`id` = `g`.`cid`) and (`c`.`accountid` = `a`.`id`));

--
-- Definition of view `readable_last_hour_cheatlog`
--

DROP TABLE IF EXISTS `readable_last_hour_cheatlog`;
DROP VIEW IF EXISTS `readable_last_hour_cheatlog`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_last_hour_cheatlog` AS select sql_no_cache `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`cid` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now()) < 1) and (`a`.`banned` = 0)) group by `cl`.`cid` order by sum(`cl`.`count`) desc;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
​

14907 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

The error is at line 14881. According to MySQL Query Browser it's a syntax error:

near 'DROP TABLE IF EXISTS `readable_gmlog`;
DROP VIEW IF EXISTS `readable_gmlog`;
C' at line 7

But that is actually line 14887 that it starts at. Why does it say line 14881? Not sure what the problem is.