Céh telek sql

[mikee0121]

Mivel a mai napon kerestem egy darabig és alig akadtam rá megosztom veletek is ha véletlen valakinek még hibás lenne a céh telek épületek object protoja

Kód Kijelölés Kibont


CREATE TABLE `object_proto` (
  `vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  `materials` varchar(64) NOT NULL DEFAULT '',
  `upgrade_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `upgrade_limit_time` int(10) unsigned NOT NULL DEFAULT '0',
  `life` int(11) NOT NULL DEFAULT '0',
  `reg_1` int(11) NOT NULL DEFAULT '0',
  `reg_2` int(11) NOT NULL DEFAULT '0',
  `reg_3` int(11) NOT NULL DEFAULT '0',
  `reg_4` int(11) NOT NULL DEFAULT '0',
  `npc` int(10) unsigned NOT NULL DEFAULT '0',
  `group_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `dependent_group` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of object_proto
-- ----------------------------
INSERT INTO `object_proto` VALUES ('14013', '?? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20044', '2', '1');
INSERT INTO `object_proto` VALUES ('14014', '??? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20045', '2', '1');
INSERT INTO `object_proto` VALUES ('14015', '???? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20046', '2', '1');
INSERT INTO `object_proto` VALUES ('14043', '????? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20060', '3', '1');
INSERT INTO `object_proto` VALUES ('14045', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20062', '3', '1');
INSERT INTO `object_proto` VALUES ('14046', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20063', '3', '1');
INSERT INTO `object_proto` VALUES ('14047', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20064', '3', '1');
INSERT INTO `object_proto` VALUES ('14048', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20065', '3', '1');
INSERT INTO `object_proto` VALUES ('14049', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20066', '3', '1');
INSERT INTO `object_proto` VALUES ('14050', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20067', '3', '1');
INSERT INTO `object_proto` VALUES ('14051', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20068', '3', '1');
INSERT INTO `object_proto` VALUES ('14052', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20069', '3', '1');
INSERT INTO `object_proto` VALUES ('14053', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20070', '3', '1');
INSERT INTO `object_proto` VALUES ('14054', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20071', '3', '1');
INSERT INTO `object_proto` VALUES ('14055', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20072', '3', '1');
INSERT INTO `object_proto` VALUES ('14061', '?? ??', '25000000', '90010,25/90011,25/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20077', '4', '1');
INSERT INTO `object_proto` VALUES ('14062', '?? ??', '500000000', '90010,50/90011,50/90012,50', '0', '0', '0', '-10', '-10', '10', '10', '20078', '4', '4');
INSERT INTO `object_proto` VALUES ('14063', '?? ??', '750000000', '90010,75/90011,75/90012,75', '0', '0', '0', '-10', '-10', '10', '10', '20079', '4', '4');
INSERT INTO `object_proto` VALUES ('14100', '?(1)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14110', '?(2)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14120', '?(3)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14200', '?? ??', '3000000', '90011,5/90012,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '1');
INSERT INTO `object_proto` VALUES ('14300', '?1', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14301', '?2', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14302', '?3', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14303', '?4', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14304', '?5', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14305', '?6', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14306', '?7', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14307', '?8', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14308', '?9', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14309', '?10', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14400', '??1', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14401', '??2', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14402', '??3', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14403', '??4', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14404', '??5', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14405', '??6', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14406', '??7', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14407', '??8', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14408', '??9', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');