Como criar AIOX

[Luchina]

qeria cria aio meu table characts tem opçao aio e id_aio SO q nao sei fazer ensina ai ou manda ttorial pra por aio e skill la cerinho vlw AI

 

[djneg0]

Caro amigo onde esta  "268483768"  é onde você vai manualmente colocar

a id do char onde você quer que as skill´s seja add espero ter ajudado.

Segue códigos

Query para deletar todas as skill de certo char

DELETE FROM character_skills WHERE char_obj_id =  268483768;

Query para add itens ao char exemplo DualxAIO TatuxAIO

Fazendo isso os itens irá para o Char.

UPDATE characters SET x = 81608 WHERE obj_id =  268483768;

UPDATE characters SET y = 148594 WHERE obj_id =  268483768;

UPDATE characters SET z = -3464 WHERE obj_id =  268483768;

UPDATE characters SET level = 80 WHERE obj_id =  268483768;

Query para criar Skill AIOx

INSERT INTO character_skills VALUES ("268483768", 4409, 20, "MP Modifiers", 0);

INSERT INTO character_skills VALUES ("268483768", 1040, 3, "Shield", 0);

INSERT INTO character_skills VALUES ("268483768", 1068, 3, "Might", 0);

INSERT INTO character_skills VALUES ("268483768", 1035, 4, "Mental Shield", 0);

INSERT INTO character_skills VALUES ("268483768", 1033, 1, "Holy weapon", 0);

INSERT INTO character_skills VALUES ("268483768", 1044, 3, "regeneration", 0);

INSERT INTO character_skills VALUES ("268483768", 1040, 3, "Shield", 0);

INSERT INTO character_skills VALUES ("268483768", 1062, 2, "Berserker Spirit", 0);

INSERT INTO character_skills VALUES ("268483768", 1073, 2, "Kiss of Eva", 0);

INSERT INTO character_skills VALUES ("268483768", 1077, 3, "Focus", 0);

INSERT INTO character_skills VALUES ("268483768", 1078, 6, "Concentration", 0);

INSERT INTO character_skills VALUES ("268483768", 1085, 3, "Acumen", 0);

INSERT INTO character_skills VALUES ("268483768", 1204, 2, "Wind Walk", 0);

INSERT INTO character_skills VALUES ("268483768", 1032, 3, "Invigor", 0);

INSERT INTO character_skills VALUES ("268483768", 1036, 2, "Magic Barrier", 0);

INSERT INTO character_skills VALUES ("268483768", 1045, 6, "Bless the Body", 0);

INSERT INTO character_skills VALUES ("268483768", 1048, 6, "Bless the Soul", 0);

INSERT INTO character_skills VALUES ("268483768", 1086, 2, "Haste", 0);

INSERT INTO character_skills VALUES ("268483768", 1240, 3, "Guidance", 0);

INSERT INTO character_skills VALUES ("268483768", 1242, 3, "Death Whisper", 0);

INSERT INTO character_skills VALUES ("268483768", 1243, 6, "Bless Shield", 0);

INSERT INTO character_skills VALUES ("268483768", 1388, 3, "Greater Might", 0);

INSERT INTO character_skills VALUES ("268483768", 1389, 3, "Greater Shield", 0);

INSERT INTO character_skills VALUES ("268483768", 1393, 3, "Unholy Resistence", 0);

INSERT INTO character_skills VALUES ("268483768", 1392, 3, "Holy Resistence", 0);

INSERT INTO character_skills VALUES ("268483768", 1352, 1, "Elemental Protection", 0);

INSERT INTO character_skills VALUES ("268483768", 1356, 1, "Prophecy of Fire", 0);

INSERT INTO character_skills VALUES ("268483768", 1311, 6, "Body of Avatar", 0);

INSERT INTO character_skills VALUES ("268483768", 1356, 1, "Prophecy of Fire", 0);

INSERT INTO character_skills VALUES ("268483768", 1353, 1, "Divine Protection", 0);

INSERT INTO character_skills VALUES ("268483768", 1410, 1, "Salvation", 0);

INSERT INTO character_skills VALUES ("268483768", 1303, 2, "Wild Magic", 0);

INSERT INTO character_skills VALUES ("268483768", 1087, 3, "Agility", 0);

INSERT INTO character_skills VALUES ("268483768", 1304, 3, "Advanced Block", 0);

INSERT INTO character_skills VALUES ("268483768", 1005, 3, "Blessings of Pa'agrio", 0);

INSERT INTO character_skills VALUES ("268483768", 1397, 3, "Clarity", 0);

INSERT INTO character_skills VALUES ("268483768", 1007, 3, "Chant of Battle", 0);

INSERT INTO character_skills VALUES ("268483768", 1309, 3, "Chant of Eagle", 0);

INSERT INTO character_skills VALUES ("268483768", 1552, 3, "Chant of Evasion", 0);

INSERT INTO character_skills VALUES ("268483768", 1006, 3, "Chant of Fire", 0);

INSERT INTO character_skills VALUES ("268483768", 1229, 15, "Chant of Life", 0);

INSERT INTO character_skills VALUES ("268483768", 1308, 3, "Chant of Predator", 0);

INSERT INTO character_skills VALUES ("268483768", 1253, 3, "Chant of Rage", 0);

INSERT INTO character_skills VALUES ("268483768", 1284, 3, "Chant of Revenge", 0);

INSERT INTO character_skills VALUES ("268483768", 1009, 3, "Chant of Shielding", 0);

INSERT INTO character_skills VALUES ("268483768", 1310, 4, "Chant of Vampire", 0);

INSERT INTO character_skills VALUES ("268483768", 1363, 1, "Chant of Victory", 0);

INSERT INTO character_skills VALUES ("268483768", 1362, 1, "Chant of Spirit", 0);

INSERT INTO character_skills VALUES ("268483768", 307, 1, "Dance of Aqua Guard", 0);

INSERT INTO character_skills VALUES ("268483768", 276, 1, "Dance of Concentration", 0);

INSERT INTO character_skills VALUES ("268483768", 309, 1, "Dance of Earth Guard", 0);

INSERT INTO character_skills VALUES ("268483768", 274, 1, "Dance of Fire", 0);

INSERT INTO character_skills VALUES ("268483768", 275, 1, "Dance of Fury", 0);

INSERT INTO character_skills VALUES ("268483768", 272, 1, "Dance of Inspiration", 0);

INSERT INTO character_skills VALUES ("268483768", 277, 1, "Dance of Light", 0);

INSERT INTO character_skills VALUES ("268483768", 273, 1, "Dance of Mystic", 0);

INSERT INTO character_skills VALUES ("268483768", 311, 1, "Dance of Protection", 0);

INSERT INTO character_skills VALUES ("268483768", 366, 1, "Dance of Shadow", 0);

INSERT INTO character_skills VALUES ("268483768", 365, 1, "Dance of Siren", 0);

INSERT INTO character_skills VALUES ("268483768", 310, 1, "Dance of Vampire", 0);

INSERT INTO character_skills VALUES ("268483768", 271, 1, "Dance of Warrior", 0);

INSERT INTO character_skills VALUES ("268483768", 1059, 3, "Greater Empower", 0);

INSERT INTO character_skills VALUES ("268483768", 1219, 33, "Greater Group Heal", 0);

INSERT INTO character_skills VALUES ("268483768", 1217, 33, "Greater Heal", 0);

INSERT INTO character_skills VALUES ("268483768", 1182, 3, "Resist Aqua", 0);

INSERT INTO character_skills VALUES ("268483768", 1191, 3, "Resist Fire", 0);

INSERT INTO character_skills VALUES ("268483768", 1033, 3, "Resist Poison", 0);

INSERT INTO character_skills VALUES ("268483768", 1189, 3, "Resist Wind", 0);

INSERT INTO character_skills VALUES ("268483768", 1259, 4, "Resist Shock", 0);

INSERT INTO character_skills VALUES ("268483768", 1306, 6, "Ritual of Life", 0);

INSERT INTO character_skills VALUES ("268483768", 364, 1, "Song of Champion", 0);

INSERT INTO character_skills VALUES ("268483768", 264, 1, "Song of Earth", 0);

INSERT INTO character_skills VALUES ("268483768", 306, 1, "Song of Flame Guard", 0);

INSERT INTO character_skills VALUES ("268483768", 269, 1, "Song of Hunter", 0);

INSERT INTO character_skills VALUES ("268483768", 270, 1, "Song of Invocation", 0);

INSERT INTO character_skills VALUES ("268483768", 265, 1, "Song of Life", 0);

INSERT INTO character_skills VALUES ("268483768", 363, 1, "Song of Meditation", 0);

INSERT INTO character_skills VALUES ("268483768", 349, 1, "Song of Renewal", 0);

INSERT INTO character_skills VALUES ("268483768", 308, 1, "Song of Storm Guard", 0);

INSERT INTO character_skills VALUES ("268483768", 305, 1, "Song of Vengeance", 0);

INSERT INTO character_skills VALUES ("268483768", 304, 1, "Song of Vitality", 0);

INSERT INTO character_skills VALUES ("268483768", 267, 1, "Song of Warding", 0);

INSERT INTO character_skills VALUES ("268483768", 266, 1, "Song of Water", 0);

INSERT INTO character_skills VALUES ("268483768", 268, 1, "Song of Wind", 0);

INSERT INTO character_skills VALUES ("268483768", 1390, 3, "War Chant", 0);

INSERT INTO character_skills VALUES ("268483768", 4699, 13, "blessing of queen", 0);

INSERT INTO character_skills VALUES ("268483768", 4702, 3, "blessing of Seraphim", 0);

INSERT INTO character_skills VALUES ("268483768", 1413, 1, "Magnus chant", 0);

INSERT INTO character_skills VALUES ("268483768", 1323, 1, "Nobles Blessing", 0);

INSERT INTO character_skills VALUES ("268483768", 1374, 1, "Heroic Valor", 0);

INSERT INTO character_skills VALUES ("268483768", 1003, 3, "Pa'agrian Gift", 0);

INSERT INTO character_skills VALUES ("268483768", 1282, 2, "Pa'agrian Haste", 0);

INSERT INTO character_skills VALUES ("268483768", 1416, 1, "Pa'agrio's Fist", 0);

INSERT INTO character_skills VALUES ("268483768", 1415, 1, "Pa'agrio's Emblem", 0);

INSERT INTO character_skills VALUES ("268483768", 341, 1, "Touch of Life", 0);

======================= CREDITOS DjNeg0 =======================

 

[Shion]

topico resolvido!