adding graveyards

Subject: adding graveyards Fri Apr 13, 2007 8:50 pm

is there any other way to add a graveyard to a zone except for the command .addgrave?

tnx

Number of posts : 89 Registration date : 2007-01-02

just add then to your graveyards table...

Subject: Re: adding graveyards Sat Apr 14, 2007 4:45 am

graveyards table db doesn't works.

edit WorldSafeLocs.dbc

Subject: Re: adding graveyards Sat Apr 14, 2007 6:09 am

yeh i noticed that after i made point for almost all of the zones xD
btw doesn't anyone else got bugged graveyards or no graveyards in zome places at all?
and you guys have a tool the edit the DBC seems like mine screws it up everytime i edit something

Code:: /*
MySQL Data Transfer
Source Host: localhost
Source Database: kobold
Target Host: localhost
Target Database: kobold
Date: 14-4-2007 5:05:33
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for graveyards
-- ----------------------------
CREATE TABLE `graveyards` (
`ID` int(60) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
`X` float NOT NULL default '0',
`Y` float NOT NULL default '0',
`Z` float NOT NULL default '0',
`O` float NOT NULL,
`zoneId` int(16) NOT NULL,
`mapId` int(16) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
`faction_id` int(32) NOT NULL,
PRIMARY KEY (`ID`),
KEY `idx_map` (`mapId`)
) ENGINE=MyISAM AUTO_INCREMENT=197451 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Graveyards ';

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `graveyards` VALUES ('1', '-14286', '283', '32', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('2', '-11550', '-228', '28', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('3', '-10836', '-2953', '13', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('4', '-10779', '-1194', '35', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('5', '-10575', '-3377', '22', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('6', '-10559', '1206', '31', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('7', '-9394', '-2022', '58', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('8', '-9341', '165', '61', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('9', '-8924', '-189', '80', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('10', '-7501', '-2145', '146', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('11', '-6807', '-2289', '280', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('12', '-6439', '-1115', '312', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('13', '-6160', '325', '399', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('14', '-5670', '-528', '398', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('15', '-5352', '-2892', '341', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('16', '-5165', '-876', '507', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('17', '-3355', '-845', '1', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('18', '-3299', '-2430', '18', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('19', '-1468', '-2625', '48', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('20', '-721', '-592', '25', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('21', '-285', '-4388', '108', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('22', '-20', '-996', '55', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('23', '324', '-2227', '137', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('24', '476', '1595', '126', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('25', '902', '-1517', '55', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('26', '1238', '-2414', '60', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('27', '1380', '-3701', '77', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('28', '1739', '-672', '45', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('29', '1882', '1641', '93', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('30', '2115', '-5299', '82', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('31', '2348', '492', '33', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('32', '2603', '-535', '89', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('33', '2641', '-4015', '106', '0', '0', '0', '0');
INSERT INTO `graveyards` VALUES ('34', '-9341', '165', '61', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('35', '-7207', '-2439', '-218', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('36', '-7200', '-3938', '9', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('37', '-6824', '892', '33', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('38', '-6442', '-290', '3', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('39', '-5530', '-3455', '-44', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('40', '-5352', '-2892', '341', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('41', '-4642', '-1778', '-41', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('42', '-4600', '3229', '9', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('43', '-4593', '1631', '93', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('44', '-4429', '370', '51', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('45', '-3518', '-4315', '6', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('46', '-3134', '-3048', '34', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('47', '-2949', '-142', '67', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('48', '-2506', '-1968', '91', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('49', '-2173', '-342', '-5', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('50', '-1434', '1967', '86', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('51', '-1073', '-3479', '63', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('52', '-983', '-75', '20', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('53', '-774', '-4988', '19', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('54', '-639', '-4298', '40', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('55', '-590', '-2515', '91', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('56', '240', '-4791', '10', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('57', '919', '436', '65', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('58', '1178', '-4467', '21', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('59', '2428', '-2953', '123', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('60', '2644', '-635', '107', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('61', '2683', '-3988', '108', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('62', '2924', '-6031', '4', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('63', '3796', '-1622', '219', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('64', '4299', '89', '42', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('65', '4798', '-6846', '89', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('66', '5943', '-1205', '382', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('67', '6736', '202', '23', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('68', '6857', '-4680', '700', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('69', '7412', '-2817', '464', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('70', '9683', '952', '1291', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('71', '10055', '2116', '1329', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('72', '10394', '825', '1317', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('73', '16320', '16243', '24', '0', '0', '1', '0');
INSERT INTO `graveyards` VALUES ('74', '667', '-306', '30', '0', '0', '30', '0');
INSERT INTO `graveyards` VALUES ('75', '-2503', '6788', '23', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('76', '-3922', '3689', '286', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('77', '-3127', '727', '-20', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('78', '-4122', '1062', '31', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('79', '259', '7083', '37', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('80', '-2996', '2454', '62', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('81', '-2023', '8485', '0', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('82', '7706', '-6731', '48', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('83', '9417', '-6853', '14', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('84', '10463', '-6369', '39', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('85', '8939', '-7443', '82', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('86', '8704', '-6670', '70', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('87', '7012', '-7312', '46', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('88', '-280', '1055', '54', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('89', '3019', '3595', '145', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('90', '-4119', '-13663', '74', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('91', '-4304', '-12422', '17', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('92', '-3329', '-12097', '28', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('93', '-2014', '-11969', '33', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('94', '-1757', '-11056', '77', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('95', '-1788', '4922', '-21', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('96', '-819', '2717', '110', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('97', '-1265', '2442', '61', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('98', '164', '2571', '78', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('99', '549', '1994', '103', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('100', '-699', '4110', '63', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('101', '178', '4362', '116', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('102', '3019', '3596', '145', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('103', '2368', '2325', '106', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('104', '2989', '1861', '143', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('105', '4373', '3103', '132', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('106', '2218', '6017', '135', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('107', '2013', '5570', '262', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('108', '1950', '6757', '164', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('109', '2318', '5080', '272', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('110', '3073', '5421', '148', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('111', '-3485', '-11652', '7', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('112', '-4132', '-13653', '74', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('113', '-4301', '-12425', '17', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('114', '-3561', '4674', '-21', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('115', '2007', '1673', '1182', '0', '0', '566', '0');
INSERT INTO `graveyards` VALUES ('116', '-4011', '2056', '97', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('117', '-213', '5593', '20', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('118', '227', '6200', '22', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('119', '349', '7627', '23', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('210', '321', '8622', '23', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('211', '2359', '1679', '1173', '0', '0', '566', '0');
INSERT INTO `graveyards` VALUES ('212', '2009', '1457', '1172', '0', '0', '566', '0');
INSERT INTO `graveyards` VALUES ('213', '-1069', '8096', '-35', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('214', '-1661', '7962', '-46', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('215', '-2531', '3860', '10', '0', '0', '530', '0');
INSERT INTO `graveyards` VALUES ('216', '2357', '1457', '1185', '0', '0', '566', '0');

Number of posts : 89 Registration date : 2007-01-02

srry just saw the table and thought it would work

Subject: Re: adding graveyards Sat Apr 14, 2007 9:27 am

aries wrote:: yeh i noticed that after i made point for almost all of the zones xD
btw doesn't anyone else got bugged graveyards or no graveyards in zome places at all?
and you guys have a tool the edit the DBC seems like mine screws it up everytime i edit something

than use dbc<->csv converter.

Subject: Re: adding graveyards Sun Apr 15, 2007 12:14 am

i used it but does anyone actualy know how to edit them at all?
this is what are in the file:
how do i know what is what?

Code:: 1246,0,1120553402,3275288347,1123987489,"Alterac Valley, Alliance Exit" (2701),0,0,0,0,0,0,0,3604492,
1247,530,1161446162,1156168292,1125096287,"Netherstorm, Cosmowrench GY" (14446),0,0,0,0,0,0,0,3604492,
1248,530,3298758041,1159220617,1115697606,"Hellfire Peninsula, Spinebreaker GY" (14474),0,0,0,0,0,0,0,3604492,

Number of posts : 33 Registration date : 2006-12-21

http://www.sourcepeek.com/wiki/WorldSafeLocs.dbc
edit the csv and convert it back to dbc. i doubt you'll be able to fix them since it's a core problem. in v4 changelog there is +++ Fixed Grave finding for World Maps ( not instances, nor BG and Arena ).

Number of posts : 11 Registration date : 2007-02-02

i've done the convert to cvs and put all the places in just like we did in the wad times but somehow converting back to dbc doesn't happen couse all the dbc that comes out is only 1kb while it was 47kb before editing. What goes wrong dbc<=>cvs converter does not know how to handle bc dbc files?

Subject: Re: adding graveyards Sun May 13, 2007 2:04 am

yeh that's the problem and the dbc coordinates are very diffrent from lud's coordinates