SQL's úteis

**Lucky ♥** · May 22, 2011

alguem pode faser uma .sql pra mim

de todos os mob lv. 80?

UPDATE npc SET `level`=80 WHERE `type`="L2Monster"

**Rüsty ~** · May 22, 2011

isso ae so falta resetar pvp e pk ;D

**Fort ♥** · May 22, 2011

UPDATE npc SET `level`=80 WHERE `type`="L2Monster"

Obrigado ...

**oreon** · June 3, 2011

alguem pode faze uma sql pra min add uma skill de uma só vez em todos mobs para freya?

Edited June 3, 2011 by oreon

**oreon** · June 7, 2011

consegui já :D

**Caio-BrLegends** · June 8, 2011

nossa revoltado belo trabalho vc podia fazer 1 sql com backup 5 em 5 horas. eu ia te agradescer.

**AnyOne** · June 11, 2011

muito bom

**maxi** · June 21, 2011

Galera essa Sql e para Servidores Freya!!!!! Add Skill de Return Apenas eu Fiz a Atualização.;

INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1,'true','false');

INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1,'true','false');

Infelizmente no meu Freya ta dando erro ao puxar a SQL pro DB =[ Helps

**Brunoo** · June 21, 2011

Gente to começando agora sei para que serve cada sql so nao sei adiciona elas

Por exemplo essa Para dar rr a cada 6 hrs so add no navicat que vai da rr a cada 6 hrs? Quais as hrs que vai da o rr

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360");

**Lucky ♥** · June 24, 2011

Alguem faz uma sql para deletar todos os chars a 4 meses sem logar?

**Fort ♥** · June 24, 2011

Alguem faz uma sql para deletar todos os chars a 4 meses sem logar?

DELETE FROM characters WHERE lastAccess < 933120000;

DELETE FROM accounts WHERE lastactive < 933120000;

TAI NAO TESTEI MAIS AXO QUE E ESSE

:parabens:

Edited June 24, 2011 by Fort ♥

**BladeDancer** · June 24, 2011

Hehe , vlw kra vai ser bem util .

**willxd** · July 13, 2011

Pode me arrumar uma sql que deleta contas que nao logam a 1 mes?

Edited July 13, 2011 by willxd

**Mayke** · July 19, 2011

como deletar os drops da db que nao tem etcitem ?

**sandrozappi** · July 25, 2011

É só adaptar de acordo com sua DB na minha db interlude é assim tente.

INSERT INTO `skill_trees` VALUES ('0', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('10', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('18', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('25', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('31', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('38', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('44', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('49', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('53', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('123', '1050', '1', 'Return', '0', '1');
INSERT INTO `skill_trees` VALUES ('124', '1050', '1', 'Return', '0', '1');

Está serve também para colocar no banco de dados l2jdb (Crónica Epilogue) L2jlive. (testei e funcionou perfeitamente).

**WallisTeer** · July 25, 2011

otimooo ^^

**sandrozappi** · August 19, 2011

DELETE FROM characters WHERE lastAccess < 933120000;

DELETE FROM accounts WHERE lastactive < 933120000;

TAI NAO TESTEI MAIS AXO QUE E ESSE

:parabens:

Uma dúvida, como se chega a este resultado -> 933120000 ? (4 meses)

Pq, por exemplo se partir do calculo de minutos seria:

1 minuto = 60 segundos

60 seg. x 60 min.= 3600 seg. (1hora)

3600 seg. x 24 hs= 86400 seg.

86400 seg. x 30 dias= 2592000 seg.

2592000 seg. x 4 meses = 10368000 seg. --------> 4 meses seria então 10368000 e não ---> 933120000 (como dito acima)

ATENÇÃO: NÃO SEI SE ESTA É A FORMULA CORRETA PARA SE CALCULAR ISSO. APENAS PARTI DE UMA POSSÍVEL LÓGICA.

GOSTARIA DE SABER QUAL O CALCULO A SER FEITO CORRETAMENTE, CASO ESTE QUE POSTEI ACIMA, NÃO SEJA O CORRETO.

A tds, obrigado desde já pela atenção!

Edited August 19, 2011 by sandrozappi

**Boy Wonder** · September 21, 2011

Para os chars nascerem com Skill return o certo não seria esse aqui não?

INSERT INTO `skill_trees` VALUES ('0', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('1', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('2', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('3', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('4', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('5', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('6', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('7', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('8', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('9', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('10', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('11', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('12', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('13', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('14', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('15', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('16', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('18', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('19', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('20', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('21', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('22', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('23', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('24', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('25', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('26', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('27', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('28', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('29', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('31', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('32', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('33', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('34', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('35', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('36', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('37', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('38', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('39', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('40', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('41', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('42', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('43', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('44', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('45', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('46', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('47', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('48', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('49', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('50', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('51', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('52', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('53', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('54', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('55', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('56', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('57', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('58', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('59', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('60', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('61', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('62', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('63', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('64', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('65', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('66', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('67', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('68', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('69', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('70', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('71', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('72', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('73', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('74', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('75', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('76', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('77', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('78', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('79', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('80', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('81', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('82', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('83', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('84', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('85', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('86', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('87', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('88', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('89', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('90', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('91', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('92', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('93', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('94', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('95', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('96', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('97', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('98', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('99', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('100', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('101', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('102', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('103', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('104', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('105', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('106', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('107', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('108', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('109', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('110', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('111', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('112', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('113', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('114', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('115', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('116', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('117', '1050', '1', 'Return', '50', '5');
INSERT INTO `skill_trees` VALUES ('118', '1050', '1', 'Return', '50', '5');

Edited October 22, 2011 by Boy Wonder

**vert** · October 8, 2011

explendido

**IronMaiden** · November 25, 2011

Perfeito vai pros meus favoritos.

**lucas25** · June 25, 2012

como fasso pra deletar todos os itens dos l2raidboss??

**Dwbryel** · June 26, 2012

Nossa que foda vei, muito bom. parabens. tive procurando varios desses por muito tempo

**Hate** · August 21, 2012

Sql's muito uteis para administrar um server via DB.

**H4RD3C0R3** · December 23, 2015

Sera que alguem consegue/pode adaptar essa sql de:

auto server restart:

INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360");

Para L2JServer High Five ( H5 ) ??

OBS: Na minha DB Não tem essa Table `global_tasks`

**Robert-Downey** · March 26, 2023

Olá, alguém sabe me dizer como faço para alterar todos o hp de todos os mobs lvl 81?

Sign In

SQL's úteis

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Announcements

Recently Browsing

Posts

Important Information