céhtelek (K)

[Madridista]

Sziasztok valaki meg tudná mondani, hogy tudok céhtelkeket csinálni a map1-ekere?

[MacTavish]

ha kézzel akarod:

navicat/player/land
Szerintem egyértelműek mit jelentenek az oszlopok. Egyedül a width és height-et nem értheted, mind2-t tedd 3000-ra. (Szerintem ez azt jelenti hogy a céhtelek mekkora legyen.


x y kordinátákat pedig:
http://metin2hungary.net/index.php/topic,163995.msg876778.html#msg876778

vagy ha nem kézzel, akkor query-vel is tudod. Persze akkor szerezni kell query-t de mingy kimentem a sf-emből.

map1 (mind 3 biri)

Kód Kijelölés Kibont

INSERT INTO land VALUES ('1', '1', '20200', '10000', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('2', '1', '23500', '13600', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('3', '1', '27600', '10900', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('4', '1', '55600', '9600', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('5', '1', '57100', '3800', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('6', '1', '60900', '5200', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('7', '1', '66100', '7900', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('8', '1', '81400', '16800', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('9', '1', '90700', '20400', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('10', '1', '94300', '23700', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('11', '1', '10800', '108500', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('12', '1', '5900', '108500', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('13', '1', '7700', '104300', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('14', '1', '23400', '46200', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('15', '1', '17200', '44400', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('16', '1', '20000', '40100', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('17', '1', '25800', '36900', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('18', '1', '16900', '35800', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('101', '21', '29400', '11400', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('102', '21', '33600', '12700', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('103', '21', '36300', '16300', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('104', '21', '55900', '17200', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('105', '21', '72800', '8500', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('106', '21', '76300', '5400', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('107', '21', '77600', '10200', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('108', '21', '84200', '47200', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('109', '21', '87800', '61000', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('110', '21', '32100', '113800', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('111', '21', '28800', '117200', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('112', '21', '24400', '118700', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('113', '21', '22600', '114400', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('114', '21', '34800', '92300', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('115', '21', '37500', '89000', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('116', '21', '35100', '73600', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('117', '21', '35400', '69200', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('118', '21', '35400', '55600', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('201', '41', '66100', '9400', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('202', '41', '70300', '7900', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('203', '41', '73600', '11500', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('204', '41', '70900', '15100', '3000', '3000', '0', '10', '45000000', 'YES');
INSERT INTO land VALUES ('205', '41', '71800', '61900', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('206', '41', '77000', '64100', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('207', '41', '60700', '66800', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('208', '41', '74500', '68200', '3000', '3000', '407', '10', '65000000', 'YES');
INSERT INTO land VALUES ('209', '41', '67900', '110800', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('210', '41', '67900', '115700', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('211', '41', '62800', '114800', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('212', '41', '16600', '95300', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('213', '41', '5400', '94100', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('214', '41', '18600', '89300', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('215', '41', '4600', '89800', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('216', '41', '11200', '36000', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('217', '41', '8200', '31800', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('218', '41', '12000', '29200', '3000', '3000', '0', '10', '70000000', 'YES');

map3 (mind3 biri)

Kód Kijelölés Kibont

INSERT INTO land VALUES ('75', '4', '9600', '13100', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('76', '4', '16100', '15600', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('77', '4', '9100', '19500', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('78', '4', '14900', '19500', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('79', '4', '27700', '19500', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('80', '4', '23600', '23000', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('81', '4', '31800', '24200', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('82', '4', '27900', '27300', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('83', '4', '35500', '35400', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('84', '4', '32800', '39300', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('85', '4', '39700', '39600', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('86', '4', '36100', '42700', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('87', '4', '24400', '39000', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('88', '4', '19900', '41600', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('89', '4', '14400', '41700', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('90', '4', '10200', '39100', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('91', '4', '7700', '34600', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('92', '4', '8400', '29500', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('175', '24', '7100', '5200', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('176', '24', '12800', '4800', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('177', '24', '9700', '9900', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('178', '24', '14500', '13300', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('179', '24', '36900', '26000', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('180', '24', '38600', '29800', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('181', '24', '36500', '33900', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('182', '24', '33600', '38600', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('183', '24', '30900', '33500', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('184', '24', '25700', '33500', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('185', '24', '25600', '37800', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('186', '24', '20900', '37800', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('187', '24', '20900', '33700', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('188', '24', '14200', '33700', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('189', '24', '10000', '37100', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('190', '24', '5800', '34800', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('191', '24', '8800', '29800', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('192', '24', '10500', '26100', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('275', '44', '5400', '7700', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('276', '44', '9700', '7300', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('277', '44', '5500', '11500', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('278', '44', '5100', '15500', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('279', '44', '8900', '17900', '3000', '3000', '0', '10', '40000000', 'YES');
INSERT INTO land VALUES ('280', '44', '22200', '15600', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('281', '44', '43000', '3700', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('282', '44', '38900', '27200', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('283', '44', '30200', '29900', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('284', '44', '40000', '34500', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('285', '44', '32800', '37000', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('286', '44', '40600', '39300', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('287', '44', '35600', '40600', '3000', '3000', '0', '10', '50000000', 'YES');
INSERT INTO land VALUES ('288', '44', '18500', '33600', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('289', '44', '17300', '38500', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('290', '44', '13500', '39400', '3000', '3000', '0', '10', '70000000', 'YES');
INSERT INTO land VALUES ('291', '44', '9100', '38700', '3000', '3000', '0', '10', '65000000', 'YES');
INSERT INTO land VALUES ('292', '44', '5000', '36300', '3000', '3000', '0', '10', '65000000', 'YES');

új gf-es guild map (mind 3 biri)

Kód Kijelölés Kibont

INSERT INTO land VALUES ('263', '163', '10300', '10400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('264', '163', '13600', '33400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('265', '163', '35500', '37000', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('266', '163', '34500', '11500', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('253', '162', '10300', '10400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('254', '162', '13600', '33400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('255', '162', '35500', '37000', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('256', '162', '34500', '11500', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('243', '161', '10300', '10400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('244', '161', '13600', '33400', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('245', '161', '35500', '37000', '3000', '3000', '0', '10', '900000000', 'YES');
INSERT INTO land VALUES ('246', '161', '34500', '11500', '3000', '3000', '0', '10', '900000000', 'YES');

Az utolsónál (gf-es guild map) az indexet ellenőrizd le, nekem 161-162-163 as indexen vanna, ha nálad te nem erre az indexre raktad be, akkor írd át arra amire te beraktad.

[Madridista]

Ezt kerestem, köszönöm. Ment a +