antiblock
https://i.imgur.com/aJ17bf7.gif

  • Chatbox

    Did you check out our Discord? https://discord.gg/FFdvMjk9xA
    You don't have permission to chat.
    Load More
Sign in to follow this  
Followers 0
Sopinhas10™

Query Que Poe Os Terrenos De Guild

Started by Sopinhas10™,

4 posts in this topic

Sopinhas10™    110

Sopinhas10™
Posted (edited)

Boas pessoal em algumas files nao existe os terrenos de guild:

Print :

Imagem colocada

Deixo aqui uma query que resolve isso:

Vão ao navicat-Player-query-new query e dao run

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', '0', '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');

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');

Print depois de adicionarem a query

Imagem colocada

Espero que vos ajude.

Cumprimentos:Sopinhas10

Edited by PACIFICADOR (see edit history)
HiddeN, Hue Br, ShadowKnight and 1 other reacted to this

Share this post

Link to post
Share on other sites
antiblock
Elveron

Quityng    20

Quityng
Posted

E Não é preciso os configurar?

Share this post

Link to post
Share on other sites

Sopinhas10™    110

Sopinhas10™
Posted

E Não é preciso os configurar?

Não Quityng porque a query ja esta configurada para os sitios certos :)

Share this post

Link to post
Share on other sites

zeruffus    119

zeruffus
Posted

É preciso colocar os guardas do terreno?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing Tutoriais e Dicas