DDevil

I'll try fresh installs again and see what happens but it just kept tossing errors.

I'd try using the official MySQL Workbench tool. https://dev.mysql.com/downloads/workbench/ Did as you suggested, but instructions become a little unclear because its not the same program setup as what he uses.

I was using the complete MySQL right from the site. I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this: Query Nov_16_Backup start [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned) BEGIN DELETE FROM characters WHERE UID=_uid; DELETE FROM items WHERE Owner=_uid; DELETE FROM nobility WHERE UID=_uid; DELETE FROM proficiencies WHERE owner=_uid; DELETE FROM skills WHERE owner=_uid; DELETE FROM associates WHERE UID=_uid; DELETE FROM associates WHERE AssociateID=_uid; DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid); DELETE FROM guildattr WHERE id=_uid; DELETE FROM guild WHERE leader_id=_uid; DELETE FROM tasks WHERE owner=_uid; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned) BEGIN DELETE FROM guildattr WHERE guild_id=guildId; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1; END' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned) BEGIN DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned) BEGIN SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`() SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1 ; [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned) BEGIN SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`() BEGIN SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50; END [sql] Finished with error I scrolled through 100-some odd pages and didn't see anyone with the same error. Not sure if this helps, but the original thread says to uncheck an option called "Run multiple queries in each execution". If that doesn't help, then can you tell us what tool you're using to import the database? Also, i did that and it was still throwing the errors. i was using Navicat 16. not sure if thats the problem or not.

Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat. Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server. I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this: Query Nov_16_Backup start [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned) BEGIN DELETE FROM characters WHERE UID=_uid; DELETE FROM items WHERE Owner=_uid; DELETE FROM nobility WHERE UID=_uid; DELETE FROM proficiencies WHERE owner=_uid; DELETE FROM skills WHERE owner=_uid; DELETE FROM associates WHERE UID=_uid; DELETE FROM associates WHERE AssociateID=_uid; DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid); DELETE FROM guildattr WHERE id=_uid; DELETE FROM guild WHERE leader_id=_uid; DELETE FROM tasks WHERE owner=_uid; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned) BEGIN DELETE FROM guildattr WHERE guild_id=guildId; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1; END' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned) BEGIN DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned) BEGIN SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`() SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1 ; [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned) BEGIN SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`() BEGIN SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50; END [sql] Finished with error I scrolled through 100-some odd pages and didn't see anyone with the same error.

Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already). Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat.

So im pretty new to the CO private server scene and im trying to get started on making one. i was wondering if there were any halfway decent tutorials for a pretty dumb newbie? i tried the Comet stuff but couldnt get any of it to work cause.. well... im pretty dumb...