[Help] Start out with FULL T6 all 8 pieces my SQL! menu
Follow us:

User Tag List

Results 1 to 6 of 6
  1. 04-27-2008 #1
    MisterEMU's Avatar
    MisterEMU
    MisterEMU is offline
    Banned
    Reputation
    38
    Join Date
    Feb 2008
    Posts
    307
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Help] Start out with FULL T6 all 8 pieces my SQL!

    I found this SQL file that lets you start out with 5 pieces of T6 can someone help me edit it so it will make it start out with all 8 pieces of tier 6? +Rep if you can

    Code:
    DROP TABLE IF EXISTS `playercreateinfo_items`;

-- ----------------------------
-- Table structure for playercreateinfo_items
-- ----------------------------
CREATE TABLE `playercreateinfo_items` (
  `indexid` int(4) NOT NULL default '0',
  `protoid` int(4) NOT NULL default '0',
  `slotid` int(10) NOT NULL default '0',
  `amount` int(3) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `playercreateinfo_items` VALUES ('1', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('1', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('1', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('1', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('1', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '30991', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '30987', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '30985', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '30995', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '30998', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '30991', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '30987', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '30985', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '30995', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '30998', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '31018', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '31011', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '31015', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '31021', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '31024', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '31018', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '31011', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '31015', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '31021', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '31024', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '31018', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '31011', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '31015', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '31021', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '31024', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '31052', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '31050', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '31051', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '31053', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '31054', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '31052', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '31050', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '31051', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '31053', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '31054', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '31052', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '31050', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '31051', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '31053', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '31054', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '31052', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '31050', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '31051', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '31053', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '31054', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '31042', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '31034', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '31039', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '31044', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '31048', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '31042', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '31034', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '31039', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '31044', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '31048', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '30979', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '30991', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '30987', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '30985', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '30995', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '30998', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '31018', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '31011', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '31015', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '31021', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '31024', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '30991', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '30987', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '30985', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '30995', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '30998', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '31004', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '31001', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '31003', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '31005', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '31006', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '31028', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '31026', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '31027', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '31029', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '31030', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '31066', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '31060', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '31063', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '31068', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '31069', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '31057', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '31055', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '31056', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '31058', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '31059', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '31052', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '31050', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '31051', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '31053', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '31054', '2', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '30977', '6', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '30975', '4', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '30969', '9', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '30972', '0', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '30979', '2', '1');
####
####Hearthstones, Hunter things, and other stuff \/
####
INSERT INTO `playercreateinfo_items` VALUES ('1', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('2', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('3', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('4', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('5', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('6', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('7', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('8', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('9', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('10', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('18', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('19', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('20', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('21', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('22', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('23', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('24', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('25', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('26', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('27', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('28', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('29', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('30', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('31', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('32', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('34', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('35', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('36', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('37', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('38', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('39', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('40', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('41', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('42', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('43', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('44', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('45', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('47', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('48', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('49', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('50', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('52', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('53', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('54', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('55', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('56', '6948', '24', '1');
INSERT INTO `playercreateinfo_items` VALUES ('1', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('2', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('3', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('4', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('5', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('6', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('7', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('8', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('9', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('10', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('11', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('12', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('15', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('16', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('17', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('18', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('19', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('20', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('21', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('22', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('23', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('24', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('25', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('26', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('27', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('28', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('29', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('30', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('31', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('32', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('34', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('35', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('36', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('37', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('38', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('39', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('40', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('41', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('42', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('43', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('44', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('45', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('46', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('47', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('48', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('49', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('50', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('51', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('52', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('53', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('54', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('55', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('56', '117', '23', '4');
INSERT INTO `playercreateinfo_items` VALUES ('51', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('51', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('46', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('46', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('12', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('12', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('11', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('11', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('17', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('17', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('16', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('16', '2512', '19', '200');
INSERT INTO `playercreateinfo_items` VALUES ('15', '2101', '19', '1');
INSERT INTO `playercreateinfo_items` VALUES ('15', '2512', '19', '200');
    Reply With Quote Reply With Quote
    [Help] Start out with FULL T6 all 8 pieces my SQL!
  2. 05-05-2008 #2
    EmuGod's Avatar
    EmuGod
    EmuGod is offline
    Contributor
    Reputation
    143
    Join Date
    Sep 2007
    Posts
    203
    Thanks G/R
    0/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    just change the numbers that say
    INSERT INTO `playercreateinfo_items` VALUES ('1', '30977', '6', '1')

    to amtch what you need to be sent into their inventory
    Reply With Quote Reply With Quote
  3. 05-05-2008 #3
    Lich King's Avatar
    Lich King
    Lich King is offline
    Contributor
    Reputation
    100
    Join Date
    May 2007
    Posts
    911
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to Lich King
    Add more lines, use this format:
    INSERT INTO `playercreateinfo_items` VALUES ('Race ID', 'Item ID', 'Slot ID', '1');
    Keep the 1 the same. If you want to know the race IDs, look here: http://www.mmowned.com/forums/emulat...guy-needs.html
    Reply With Quote Reply With Quote
  4. 05-07-2008 #4
    controlsx2's Avatar
    controlsx2
    controlsx2 is offline
    Member
    Reputation
    16
    Join Date
    Jun 2007
    Posts
    223
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So betrayer what about class then? I mean if its just race ID then how does it know what class there are? Why are there over 50 index numbers but only 12 races? hat is index
    Reply With Quote Reply With Quote
  5. 05-07-2008 #5
    Laveciar's Avatar
    Laveciar
    Laveciar is offline
    Member
    Reputation
    1
    Join Date
    Jan 2008
    Posts
    31
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I found a awesome spot to generate a sql file for inserting things into players starting equipment, I didn't make this, nor do I take credit for the find, I was instructed to visit this site by Gastric in another post. Simply generate many sql's and then just combine them into one big sql file is all.

    Here is the site

    ORN - SQL Generator

    Hope this helps you as much as it helped me.

    Cheers

    Laveciar
    Reply With Quote Reply With Quote
  6. 05-07-2008 #6
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    Originally Posted by controlsx2 View Post
    So betrayer what about class then? I mean if its just race ID then how does it know what class there are? Why are there over 50 index numbers but only 12 races? hat is index
    it's not race or classID its playercreateinfo index... check the player createinfo table and you will find a column "race" and "class"
    Bloodelf Warlock will be:
    "race" = 10
    "class" = 9
    you will find that in 1 row... check the indexnumber of that row and put that indexnumber in the playercreateinfo_items table...
    (ofcourse sets are only classbound so find all the indexnumbers where class = 9...)

    Playercreateinfo - Ascent Wiki
    Playercreateinfo items - Ascent Wiki
    AscentWiki is always handy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. [Request] SQL Query for starting out with all spells/skills
    By w21froster in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 05-28-2008, 09:36 AM
  2. [GUIDE] Start out with Any Items
    By Dryice in forum WoW EMU Guides & Tutorials
    Replies: 10
    Last Post: 01-22-2008, 01:35 AM
  3. Help me out with skin
    By Shadowlash in forum WoW ME Questions and Requests
    Replies: 1
    Last Post: 04-04-2007, 04:28 PM
  4. Help Me Start Out With Glider Please!
    By sneaky12313 in forum World of Warcraft General
    Replies: 9
    Last Post: 03-12-2007, 07:52 AM
  5. Can sum one help me out with that woot guide
    By WOWISFUN in forum World of Warcraft Guides
    Replies: 4
    Last Post: 12-02-2006, 06:35 PM
All times are GMT -5. The time now is 09:49 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search