[Interlude] Como adicionar aiox ao char

[bonco1234]

Eu escolhi essa REV [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Porem nunca montei uma que tivesse sistema aiox, e tenho duvida de como add aiox ao char... alguem poderia explicar? agradeço...

[advanced]

Essa Query aqui é do grandioso Setokaiba e ela adiciona nome no AIO, level, arma...
::::::::::::::::::::::::::::::::::::::::::::::
Basta modificar o "xxxxxxxxxxx" pelo obj_id do personagem.
No seu Navicat, vá em (character) na segunda coluna obj_id ou obj_Id
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]


Uploaded with [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

#===========================By Setokaiba============================================
#Visite agora mesmo [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

 | 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============================================

Para adicionar a Query, clique em: File, Query Table
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar] , irá abrir uma tela, após isso basta colar a Query editada por você e clicar em RUN

[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Créditos: Setokaiba o MESTRE!