Azure Emulator Ranks?

[Bitrate]

Hey, I've got a hotel and well, I want it to show rank '7' Ambassadors on the staff page, and well i changed the id on our staff page as it was 4 because we was on r63 now we have moved to azure R63B as i got told it was secure, how would i display all my ambassadors?

 

[Wickd]

Well that's easy, Azure database doesn't use "ranks" table it's probably something else not sure tho.
If you can't find it, just make your own rank table using the following SQL(run it as a query).

-- ----------------------------
-- 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=8 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of ranks
-- ----------------------------
INSERT INTO `ranks` VALUES ('1', 'User', null);
INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
INSERT INTO `ranks` VALUES ('3', 'Trial Moderator', 'NWB');
INSERT INTO `ranks` VALUES ('4', 'Event Staff', 'HBA');
INSERT INTO `ranks` VALUES ('5', 'Moderator', 'HBA');
INSERT INTO `ranks` VALUES ('6', 'Manager', 'ADM');
INSERT INTO `ranks` VALUES ('7', 'Administrator', 'ADM');