SQL Char Aiox Buffer + Dual AioxBuffer + Spawn Giran Level 80

[l2l2l2]

Vamos Direto Ao Assunto . !

Lembrando Que Só Foi Testado Na Rev L2JFree , e Em Interlude , Infelizmente ! So tenho esse client --'.

Mais Se Vocês Quiserem Testar . é Bom

A SQL Char AioxBuffer Contem : Buffs Normais , Songs , Dances , Chants , Hot Springs Malaria Lv 4 ( No Meu Server Não Aparece :( ) E o Player Aiox Ja Nasce Em Giran Level 80 Com o Nick Mudado Pela SQL . Bom . Ta Ai Pra Vocês Verem .

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

 

 

UPDATE characters SET char_name = "NickDoAioxAqui" WHERE obj_id = xxxxxxxxx;

UPDATE characters SET level = 80 WHERE obj_id = xxxxxxxxx;

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;

DELETE FROM character_skills WHERE char_obj_id = xxxxxxxxx;

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, 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, 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, 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, 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, 1303, 2, "Wild Magic", 0);

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

INSERT INTO character_skills VALUES (xxxxxxxxx, 4554, 4, "Hot Springs Malaria", 0);

INSERT INTO `items` VALUES ('xxxxxxxxx', '9DigitosAqui', '44445', '1', '0', 'INVENTORY', '0', '0', '0', null, '0', '0', '-1');

 

Bom COmo Vocês Viram Ai. Você Vai Troca o " xxxxxxxxx " Pelo " Obj_ID " Do Char . Onde Tem " NickDoAioxAqui " É Obvio Q é o Nome Do Player Aiox . Onde Tem " 9DigitosAqui " Você Vai Colocar Qualquer Numero , Qui Não Seja Igual A Algum Na Table " item " . E Onde Tem " 44445 É o ID Da Sua Dual AioxBuffer ( Se Você Tiver Uma )

Caso Não Tenho Delete a Linha " INSERT INTO `items` VALUES ('xxxxxxxxx', '9DigitosAqui', '44445', '1', '0', 'INVENTORY', '0', '0', '0', null, '0', '0', '-1'); "

 

Espero Que Tenham Gostado ! . Comentem .

 

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

 

 

CREDITOS : Michel.

Editado Agosto 3, 2011 por l2l2l2

[FaRM]

Funciona em Freya?

L2jserver?

 

coloca essas informações!

[Bluur]

otimo :happy:

[gabriel dias campos]

OS BUFFS SOMEM QUANDO DOU ALT+K :(

[ByOrion]

que erro pode se esse

 

[WariinG]

 

Não existe a tabela AIOXEDM na sua revisão, simplesmente a sql não está adaptada para a sua revisão.

Se não for isso, esse char não existe, não se esqueçe que não é o nome do char, e sim o ID dele .