lineage2
Bem Vindos Ao Servers L2
Aqui Voce Encontrara Diversos Recursos Para Seu server/ e Outras coisas
Como L2PHX./




Agradeço a Todos...
Cadastrem-se e Postem espero que gostem

Varias SQL importantes ^^

Ir em baixo

Varias SQL importantes ^^

Mensagem  setkaiba em Qui Maio 05, 2011 8:35 am

Venho postar aki varias sql que vao ajuda los muitos Exclamation


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`=Item_Id;


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');
avatar
setkaiba
Noob
Noob

Mensagens : 2
Data de inscrição : 05/05/2011
Idade : 36

Voltar ao Topo Ir em baixo

Voltar ao Topo

- Tópicos similares

 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum