Jump to content

SQL's úteis

RevoltadO

By RevoltadO
in Utils and Tools

 Share

Recommended Posts

RevoltadO Newbie

RevoltadO

Posted
Posted (edited)

Algumas sql's querys para seu servidor.

 

0 de peso para itens/amors/weapons

UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id);
UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id);

 

Drop de Adena 100%

UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';

 

Venda de itens/armors/weapons por 0 de adena

UPDATE `armor` SET price=0 where price > 1;
UPDATE `etcitem` SET price=0 where price > 1;
UPDATE `weapon` SET price=0 where price > 1;

 

Updat todos raidbosses com 5000k de HP

UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';

 

delete todos materiais e recipes da droplist

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

 

delete todos os caracters sem logar a 2 meses

DELETE FROM characters WHERE lastAccess < 466560000; 
DELETE FROM accounts WHERE lastactive < 466560000;

 

Add em todos mobs qualquer item no caso aqui goldbar id: 3470

insert into droplist (mobId, itemid, chance, min, max,category) select id, 3470, 1000000, 1, 1, 52 from npc where type='L2Monster';

 

top no grade todos novos chars

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

 

Todos novos chares com

Mage: Arcana mace e Dc robe

Fight: algel slayer e draconic armor

REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 6608);

 

delete todos spellboocks da drolist

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

 

Increases Guards (p.def, m.def, p.atk, hp) by 50%:

UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard';
UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard';

 

auto server restart:

Toda semana

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

 

a cada 2 dias

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

 

24 horas

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

 

12 horas

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

 

6 horas

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

 

3 horas

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

 

colocar todos raiboss level 80

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

 

colocar todos grandboss level 80

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

 

deletar toda sua database "CUIDADO"

 

DROP DATABASE `Database_name`;

 

deleta qualquer item da droplist

 

DELETE FROM `droplist` WHERE `itemId`=[color="#FF0000"]Item_Id[/color];

 

Todos Mobs drop de 1kk a 10kk de adena

 

UPDATE `droplist` SET `droplist`.`min`=1000000 WHERE `droplist`.`itemId`=57;
UPDATE `droplist` SET `droplist`.`max`=10000000 WHERE `droplist`.`itemId`=57;

 

Skill return em todos novos chares

 

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

 

Todas skills para clan

 

INSERT INTO `clan_skills` VALUES
('id clana','370','3','Clan Vitality'),
('id clana','371','3','Clan Spirituality'),
('id clana','372','3','Clan Essence'),
('id clana','373','3','Clan Lifeblood'),
('id clana','374','3','Clan Morale'),
('id clana','375','3','Clan  Clarity'),
('id clana','376','3','Clan  Might'),
('id clana','377','3','Clan Aegis'),
('id clana','378','3','Clan Empowerment'),
('id clana','379','3','Clan Magic Protection'),
('id clana','380','3','Clan Guidance'),
('id clana','381','3','Clan Agility'),
('id clana','382','3','Clan Withstand-Attack'),
('id clana','383','3','Clan Shield Boost'),
('id clana','384','3','Clan Cyclonic Resistance'),
('id clana','385','3','Clan Magmatic Resistance'),
('id clana','386','3','Clan Fortitude'),
('id clana','387','3','Clan Freedom'),
('id clana','388','3','Clan Vigilance'),
('id clana','389','3','Clan March'),
('id clana','390','3','Clan Luck'),
('id clana','391','1','Clan Imperium');

 

 

Fonte: lekino

 

 

Edited by RevoltadO
  • Like 12
  • Thanks 2

...

Link to comment
Share on other sites

F0RTUN4 Newbie

F0RTUN4

Posted
Posted (edited)

Simplesmente Perfeito, isso irá ajudar muitos usuários aqui do fórum.

 

 

 

@FlavsHunterZ

Na verdade não seria preciso de um tutorial, é apenas ver o que contem na SQL e ter um pouco de capacidade mental para assimilar o que contem nela para que você posso alterar de acordo com a sua necessidade.

 

 

@annonimooO

Nesse tópico ai tem coisas que não tem nesse aqui do Revoltad0, e nesse do Revoltad0 tem coisas que não tem nesse, emtão um complementa o outro.

Edited by Fortunato

Voltando a ATIVA!


Aguardem.......


Link to comment
Share on other sites
wesleybr Newbie

wesleybr

Posted
Posted (edited)

Pessoal to com um problema venho procurando sql da skill return e encontrei aqui ae add mais nao tah pegando..

Tipo criei um arquivo em estenssão.sql colei o codigo dito a cima e executei no navicat deu sucesso pego certinho ae criei uma conta e a skill nao aparece e então gente me ajuda a ter essa skill em meu server ..

 

Eu suspeito que seja por causa do comando /unstuck que pega no meu server, mais caso alguem saiba como resolver meu problema me ajuda to na espera..

Edited by wesleybr
Link to comment
Share on other sites
Mino3d Newbie

Mino3d

Posted
Posted

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

Link to comment
Share on other sites
RevoltadO Newbie

RevoltadO

Posted
  • Author
Posted
Hum pow na espera de resposta porque que as skill nao tam aparecendo?/

 

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

...

Link to comment
Share on other sites
  • 2 weeks later...
ola Newbie

ola

Posted
Posted

muito bom o topico , muito obrigado ajudo muito .

 

mas to com uma duvida para deleta characters em 2 meses qual e o codigo para deleta 4 meses?

 

pq tem o topico aki no l2jbrasil deleta characters 3 meses com o msm codigo desse topico!

 

agora nao sei se e 2 meses ou 3 meses

Evite Floods ou Respostas desnecessárias para que você nao tenha uma má resposta.

Campanha: Vamos manter o Forum Limpo :D

Antes de criar um Tópico de uma olhada <a href='http://projeto.l2jbrasil.com/index.php?/forum/51-archives/' Archivesa resposta da sua pergunta ja pode esta la.

 

O sábio nunca diz tudo o que pensa, mas pensa sempre em tudo o que diz.

<span>Spoiler</span> <input type='button' class='bbc_spoiler_show' value='Show' />

<div class='bbc_spoiler_wrapper'><div class='bbc_spoiler_content' style="display:none;"><span style='color: #808080'><span style='font-size: 15px;'><strong class='bbc'>Tem nada aki não!</strong></span></span></div></div>

</div></div>

</div>

Link to comment
Share on other sites
wesleybr Newbie

wesleybr

Posted
Posted

Pow to prescizando muito dessa skill de return so que executei e nao pego pego nas sub classe aew quebra kk

Alguem aew que sabe como concerta ou disponabilizar uma skill valida pra classe base me aviza

Link to comment
Share on other sites
  • 3 weeks later...
RevoltadO Newbie

RevoltadO

Posted
  • Author
Posted

Pow to prescizando muito dessa skill de return so que executei e nao pego pego nas sub classe aew quebra kk

Alguem aew que sabe como concerta ou disponabilizar uma skill valida pra classe base me aviza

 

 

Man isso é uma sql que vai no banco de dados e serve pra todas as classes, não é um mod ou um script de quest.

é claro que vai pegar na sub

...

Link to comment
Share on other sites
heero Newbie

heero

Posted
Posted

esse post deveria virar fixo!

muito bom ele

Faço o que posso com o que eu tenho, Saber é Poder,

Sabedoria é a maior riqueza que temos, não importa se ela é boa ou ruim o que importa é como a usaremos.

Link to comment
Share on other sites
  • 3 weeks later...
 Share
Go to topic listing



×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.