[Outros] Query INSERIR AIO (Skill | Nome | Level) e Item no Inventário

[Setokaiba]

Olá.
Esta é a mais nova e completa query existente para AIO.
Serve para inserir nome, level, skills de buff e determinado item no inventário, como uma dual AIO por exemplo.
Basta modificar os xxxxxxxxx pelo obj_id do personagem que irá receber.
Você encontra esta referência na tabela characters do seu banco de dados.

OBS: Em items a segunda seqüência de xxxxxxxxx marcada em vermelho é referente a finalização do ID da tabela items do char.
Ex:
Personagem Setokaiba = obj_id 268480614
Logo os itens referentes ao Setokaiba são os que estão assim
268480688
Modifique os dois últimos em amarelo para não dar conflito com algum item já existente.

Não alterar o restante dos numerais encontrados, somente onde estiver indicando ID do ITEM, QUANTIDADE DO ITEM E ENCHANT DO ITEM.


Existem tabelas que atendem com as colunas pelo nome de obj_Id
Caso a sua seja uma destas, esteja atento para onde estiver indicando a consulta com o i minúsculo na query disponibilizada.

#===========================By Setokaiba============================================
#Visite agora mesmo www.secretexperience.net | Tudo sobre Lineage II
#===========================By Setokaiba============================================
UPDATE characters SET char_name = "*Nome do AIO*" WHERE obj_id = xxxxxxxxx;
UPDATE characters SET level = 80 WHERE obj_id = xxxxxxxxx;
#===========================By Setokaiba============================================
INSERT INTO items VALUES (xxxxxxxxx, xxxxxxxxx, ID DO ITEM, QUANTIDADE DO ITEM, ENCHANT DO ITEM, "INVENTORY", 33, 0, 0, null, 0, 0, "-1", 0);
#===========================By Setokaiba============================================
DELETE FROM character_skills WHERE char_obj_id = xxxxxxxxx;
#===========================By Setokaiba============================================
UPDATE characters SET x = 81608 WHERE obj_id = xxxxxxxxx;
UPDATE characters SET y = 148594 WHERE obj_id = xxxxxxxxx;
UPDATE characters SET z = -3464 WHERE obj_id = xxxxxxxxx;
#===========================By Setokaiba============================================
INSERT INTO character_skills VALUES (xxxxxxxxx, 1085, 3, "Acumen", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1304, 3, "Advanced Block", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1087, 3, "Agility", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1354, 1, "Arcane Protection", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1062, 2, "Berserker Spirit", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1005, 3, "Blessings of Pa'agrio", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 4699, 13, "Blessing of Queen", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 4702, 3, "Blessing of Seraphim", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1243, 6, "Bless Shield", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1045, 6, "Bless the Body", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1048, 6, "Bless the Soul", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1311, 6, "Body of Avatar", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 168, 3, "Boost Attack Speed", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 213, 8, "Boost Mana", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1007, 3, "Chant of Battle", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1309, 3, "Chant of Eagle", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1552, 3, "Chant of Evasion", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1006, 3, "Chant of Fire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1229, 15, "Chant of Life", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1308, 3, "Chant of Predator", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1253, 3, "Chant of Rage", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1284, 3, "Chant of Revenge", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1009, 3, "Chant of Shielding", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1362, 1, "Chant of Spirit", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1310, 4, "Chant of Vampire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1363, 1, "Chant of Victory", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1397, 3, "Clarity", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1292, 6, "Clear Mind", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1078, 6, "Concentration", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 307, 1, "Dance of Aqua Guard", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 276, 1, "Dance of Concentration", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 309, 1, "Dance of Earth Guard", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 274, 1, "Dance of Fire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 275, 1, "Dance of Fury", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 272, 1, "Dance of Inspiration", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 277, 1, "Dance of Light", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 273, 1, "Dance of Mystic", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 311, 1, "Dance of Protection", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 366, 1, "Dance of Shadow", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 365, 1, "Dance of Siren", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 310, 1, "Dance of Vampire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 271, 1, "Dance of Warrior", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1242, 3, "Death Whisper", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1257, 3, "Decrease Weight", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1353, 1, "Divine Protection", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1391, 3, "Earth Chant", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1352, 1, "Elemental Protection", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 239, 5, "Expertise S", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 229, 7, "Fast Mana Recovery", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 228, 3, "Fast Spell Casting" ,0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1077, 3, "Focus", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1218, 28, "Greater Battle Heal", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1059, 3, "Greater Empower", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1219, 28, "Greater Group Heal", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1388, 3, "Greater Might", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1389, 3, "Greater Shield", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1240, 3, "Guidance", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1086, 2, "Haste", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1374, 1, "Heroic Valor", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 285, 27, "Higher Mana Gain", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1392, 3, "Holy Resistance", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1043, 1, "Holy Weapon", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1032, 3, "Invigor", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1073, 2, "Kiss of Eva", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1036, 2, "Magic Barrier", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1413, 1, "Magnus' Chant", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1035, 4, "Mental Shield", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1068, 3, "Might", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1323, 1, "Nobles Blessing", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1003, 3, "Pa'agrian Gift", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1282, 2, "Pa'agrian Haste", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1416, 1, "Pa'agrio's Fist", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1415, 1, "Pa'agrio's Emblem", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1355, 1, "Prophecy of Water", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1356, 1, "Prophecy of Fire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1357, 1, "Prophecy of Wind", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1044, 3, "Regeneration", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1182, 3, "Resist Aqua", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1191, 3, "Resist Fire", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1033, 3, "Resist Poison", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1259, 4, "Resist Shock", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1189, 3, "Resist Wind", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1306, 6, "Ritual of Life", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 251, 44, "Robe Mastery", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1410, 1, "Salvation", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1040, 3, "Shield", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 364, 1, "Song of Champion", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 264, 1, "Song of Earth", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 306, 1, "Song of Flame Guard", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 269, 1, "Song of Hunter", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 270, 1, "Song of Invocation", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 265, 1, "Song of Life", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 363, 1, "Song of Meditation", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 349, 1, "Song of Renewal", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 308, 1, "Song of Storm Guard", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 305, 1, "Song of Vengeance", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 304, 1, "Song of Vitality", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 267, 1, "Song of Warding", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 266, 1, "Song of Water", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 268, 1, "Song of Wind", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 341, 1, "Touch of Life", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1268, 4, "Vampiric Rage", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1393, 3, "Unholy Resistence", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1390, 3, "War Chant", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 150, 3, "Weight Limit", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1303, 2, "Wild Magic", 0);
INSERT INTO character_skills VALUES (xxxxxxxxx, 1204, 2, "Wind Walk", 0);
#===========================By Setokaiba============================================

[pilar]

quando fui colocar isso na db da erro

----------

nao tenho a tabela obj-id

[radiador22~]

verifique como está na sua database, se é obj_id ou obj_Id.

Se for maiusculo, substitua pelo minusculo na query (ou virce versa), só abrir com bloco de notas e ir em substituir, e em substituir tudo para ser mais rapido.

[pilar]

nao tem essa table na minha database n

[Setokaiba]

Sorria seu pack é mágico então.
Enquanto não postar a estrutura das tabelas pedidas nas consultas da Query, não adivinharemos qual é o design dela.

[GM-RasieL]

nem Um e nen outro... Amigo vai na sua tabela Accounts e abra ela, la procure a coluna charID ou char_Id estas sao as do seu server.... vc uma Emu ou DOT ? por isso ta se confundindo!!! pega o ID dos ACC la e faça o teste!


Quase me esquexu AEW TIO SAM.. Ops errei denovo! Aew Tio SETO VLW PELA QUERY EU TAVA PRECISANDO DESSA BULHUNFAS AEW ;D vlw mesmo Tu e 10_bravador 10taque na SW =D dkasopdka

[cleberhills]

seto, uma duvida na parte de inserir itens.
no arquivo .bat o que deveria colocar pra adicionar o object_id?
eu to usando a seguinte forma:
echo INSERT INTO `items` VALUES (%id%, xxxxxx, 16154, 1, 7, "INVENTORY", 33, 0, null, 0, 0, "-1", "-1"); > aiobuffer.sql

Não sei o que colocar nessa parte em vermelho.

[Avast]

Pega o ID do personagem e coloca ai no xxxxxxx!


Dica:

abra como bloco de notas a SQL , Segura ALT + H

em Localizar coloque , xxxxxx

em substituri por coloque, o id do char , exemplo '214487478'

e substitua todos assim ficara mais facil pra você.

[cleberhills]

Nao estou usando em sql e sim arquivo.bat
o que eu quero saber, e o que coloco pra gerar automaticamente.

[lucas5022]

mais um probleminha se alguem puder me ajudar:

então, peguei o buffer do l2jrox, fui trocar templateID para "pesar menos", e qualquer template que eu escolho,
após eu spawnar o npc ele fika "voando", como faço pra ele fikar normal??

vlw!