You're welcome. If anyone needs the database, I replaced the 'ranks' table and used this one here:
Code:
-- ----------------------------
-- Table structure for `ranks`
-- ----------------------------
DROP TABLE IF EXISTS `ranks`;
CREATE TABLE `ranks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`badgeid` varchar(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of ranks
-- ----------------------------
INSERT INTO `ranks` VALUES ('1', 'User', 'DU1');
INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
INSERT INTO `ranks` VALUES ('3', 'Trial Events Staff', 'NWB');
INSERT INTO `ranks` VALUES ('4', 'Events Staff', 'HBA');
INSERT INTO `ranks` VALUES ('5', 'Event Co-ordinator', 'HBA');
INSERT INTO `ranks` VALUES ('6', 'Trial Moderator', 'NWB');
INSERT INTO `ranks` VALUES ('7', 'Moderator', 'MOD');
INSERT INTO `ranks` VALUES ('8', 'Senior Moderator', 'ADM');
INSERT INTO `ranks` VALUES ('9', 'Support Team', 'ADM');
INSERT INTO `ranks` VALUES ('10', 'Administrator', 'ADM');
INSERT INTO `ranks` VALUES ('11', 'Hotel Manager', 'ADM');
INSERT INTO `ranks` VALUES ('12', 'Owner', 'ADM');