Terrain de Guilde ! Augmenter la taille des terrains

[Tha SmokKe 182]

Bonjour,

Bon voilà une petite liste de QUERIES qui va vous permettre d'augmenter de 50% la taille des terres de guildes ou même de les implanter si ce n'est pas déjà fait.

INSERT INTO `land` VALUES ('347', '4', '85000', '14500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('348', '4', '9000', '20500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('349', '4', '15000', '17000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('350', '4', '14000', '20500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('351', '4', '26500', '20500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('352', '4', '23000', '24000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('353', '4', '30500', '25500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('354', '4', '28000', '27000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('355', '4', '35000', '36500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('356', '4', '33000', '40500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('357', '4', '39000', '41000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('358', '4', '36000', '43000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('359', '4', '8000', '31000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('360', '4', '8000', '36000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('361', '4', '9500', '40500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('362', '4', '13500', '43000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('363', '4', '19000', '42000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('364', '4', '23500', '40000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('365', '24', '6500', '6500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('366', '24', '12000', '6000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('367', '24', '8500', '11500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('368', '24', '13500', '14500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('369', '24', '10500', '27500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('370', '24', '9000', '31500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('371', '24', '5500', '36000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('372', '24', '9500', '37000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('373', '24', '13500', '35000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('374', '24', '21000', '34500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('375', '24', '25500', '34500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('376', '24', '21000', '37500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('377', '24', '25500', '37500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('378', '24', '31500', '34500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('379', '24', '33000', '40000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('380', '24', '36000', '35500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('381', '24', '37500', '31000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('382', '24', '35500', '27500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('383', '44', '43500', '4500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('384', '44', '9500', '8500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('385', '44', '5500', '9000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('386', '44', '5000', '12500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('387', '44', '5000', '16500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('388', '44', '8500', '19500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('389', '44', '21500', '17000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('390', '44', '32500', '38500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('391', '44', '4500', '37500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('392', '44', '8000', '38500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('393', '44', '12500', '39500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('394', '44', '17000', '38000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('395', '44', '17500', '34500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('396', '44', '29000', '30500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('397', '44', '38000', '27500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('398', '44', '35000', '41500', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('399', '44', '39500', '40000', '3000', '3000', '0', '11', '12000000', 'YES');
INSERT INTO `land` VALUES ('400', '44', '39000', '36000', '3000', '3000', '0', '11', '12000000', 'YES');

Exécuter simplement ça dans votre console Navicat.

N.B : Je n'ai pas modifié les prix des terrains. Je vous laisse vous occuper de ceux-ci.

Cordialement,

[Chris 4]

Merci

[PaJa41 51]

à mettre dans quelle partie de navicat?

[tmoitoi 1]

à mettre dans quelle partie de navicat?

Côté PLAYER.land

 

INSERT INTO `land`

 

Merci du partage, cordialement.

[Stayms 37]

Merci

[Safop 0]

+1 SmokKiz

[XxcriminalxX 0]

Merci

[Fushiida 21]

La valeur qui change ?

[Calypso 6880]

A ré-écrire.

Peut être proposer un sujet qui explique comment modifier la taille/etc d'un terrain de guilde.

[ASIKOO 6270]

Bonjour,

 

Le partage / tutoriel ici présent doit être réécrit. Le lien de téléchargement est probablement mort... Message automatique de masse...

 

Cordialement,

ASIKOO