Bgames
Olá visitante! Seja bem vindo ao nosso fórum!

Para você ter total acesso ao nosso fórum é preciso que você se cadastre.

Cadastre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

[Resolvido]Como colocar itens editados no wow

Página 1 de 2 1, 2  Seguinte

Ver o tópico anterior Ver o tópico seguinte Ir em baixo

[Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Ter 8 Maio 2012 - 16:46

Galera usei o Jeuties Repack, trinity core, algue pode me dizer como coloca itens editados pelo wow-v??

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por Fox em Ter 8 Maio 2012 - 17:18

Olá,
veja este video.

Criando item no WoW-v e Dando Dump

A parte para adicionar o Item é quando ele encina a dar DUMP.
Porém.

Onde ele seleciona a opção "DUMP SQL FILE" Você irá selecionar" EXECUT SQL FILE"

Fox


Mensagens : 1912
Pontos : 11718
Evolução : 50


Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Ter 8 Maio 2012 - 19:41

mano ta dando erro na hora de colocar na pasta world pelo SQLyog

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (MUSTHAVEENTRYID, 2, 7, -1, "Warglaive of Maximus", 45479, 6, 0, 1, 1, 1, 13, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 42, 99999, 500000, 999999, 0, 100000, 200000, 4, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 1.0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-08 18:27:41
Line no.:2
Error Code: 1054 - Unknown column 'MUSTHAVEENTRYID' in 'field list'

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (MUSTHAVEENTRYID, 2, 7, -1, "Warglaive of Maximus", 45479, 6, 0, 1, 1, 1, 13, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 42, 99999, 500000, 999999, 0, 100000, 200000, 4, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 1.0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-08 18:28:51
Line no.:2
Error Code: 1054 - Unknown column 'MUSTHAVEENTRYID' in 'field list'

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (MUSTHAVEENTRYID, 2, 7, -1, "Warglaive of Maximus", 45479, 6, 0, 1, 1, 1, 13, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 42, 99999, 500000, 999999, 0, 100000, 200000, 4, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 1.0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-08 18:28:58
Line no.:2
Error Code: 1054 - Unknown column 'MUSTHAVEENTRYID' in 'field list'

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (MUSTHAVEENTRYID, 4, 3, -1, "Paladin Maximus", 45683, 6, 0, 1, 1, 1, 5, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 680, 99999999, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-08 20:41:15
Line no.:2
Error Code: 1054 - Unknown column 'MUSTHAVEENTRYID' in 'field list'

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por ildenys em Qua 9 Maio 2012 - 14:04

Ta dando esse erro pq vc ja tem os itens inguais... blz

ildenys


Mensagens : 150
Pontos : 518

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qua 9 Maio 2012 - 18:26

como assim itens iguais??? eu so peguei editei e tentei colocar explica melhor isso ae vlw +)
baixei um teleport de um outro topico e foi... consegui adicionar pelo SQLyog, queria saber onde criaram ou oque fizeram... ajuda aee

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por neroh em Qui 10 Maio 2012 - 7:35

Wanderkpot acredito eu que esse erro e por causa do "entry"
o entry ai ta "MUSTHAVEENTRYID" ta vendo ,
coloca um id do item que tu quer , tipo assim pra tu add ele la pelo comando
tipo .additem 190000 saca , mais ai tipo , em cada item tu por um entry
diferente tipo em uma tu coloca 190000 em outro 190001 e assim por diante
mais nao precisa ser nessa mesma ordem que eu falei, tu coloca os que voc quiser
eu particulamente prefiro por numeros altos para nao ter o risco de ter outros
itens com o mesmo id, tenta ai para ver :D

neroh


Mensagens : 14
Pontos : 71

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qui 10 Maio 2012 - 8:12

blz mano vo tentar aqui qualquer coisa volto no topico! vlw
Bom mano, boas noticias, fiz como voce disse, coloquei .additem 190000 e tentei colocar agora deu essa erro

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (.additem 190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 09:14:20
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, ' at line 2

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (.additem 190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 09:15:23
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, ' at line 2

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por ildenys em Qui 10 Maio 2012 - 9:05

amigo add no meu msn ai que te ajudo blz.. vou te espera....

ai te ajudo blz..

[Você precisa estar registrado e conectado para ver esta imagem.]

ildenys


Mensagens : 150
Pontos : 518

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por Fox em Qui 10 Maio 2012 - 9:14

Caro Ildenys,
Não é o primeiro Tópico que vejo você pedir para usuários te adicionar no msn, e isso não é correto.

E esta imagem que você colocou acho que esta um tanto quanto grande.

Atenciosamente.

Fox


Mensagens : 1912
Pontos : 11718
Evolução : 50


Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por ildenys em Qui 10 Maio 2012 - 9:37

amigo no outro forum o antigo cca tinha essas frescura toda não viss.. blz...

e se eu tou pedindo pra ajuda e pq o kra ta presizando manda ele add no msn pra ajuda eles tipo quando eu add vcs no msn na maioria das vezes nem ajuda a pessoal mais eu tou aqui pra ajuda todos blz.. se eu sei passo oq eu passei para os outro vlw fox.. flw

[Você precisa estar registrado e conectado para ver esta imagem.]

ildenys


Mensagens : 150
Pontos : 518

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qui 10 Maio 2012 - 9:38

ei mano ja te add no msn aceita la

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por neroh em Qui 10 Maio 2012 - 9:53

mano tu coloco assim
(.additem 190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)
nao era para ter esse .additem nao cara , tira esse .additem deixa so o numero

deixa assim
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)
roda ai pra ver se funfa agora

neroh


Mensagens : 14
Pontos : 71

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qui 10 Maio 2012 - 10:02

vo tentar ake qualquer coisa eu edito o topico
vlw

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (.additem 190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 09:14:20
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, ' at line 2

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (.additem 190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 09:15:23
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, ' at line 2

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (.additem 19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 09:17:11
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0' at line 2

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 11:04:15
Line no.:2
Error Code: 1264 - Out of range value for column 'entry' at row 1

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 11:04:40
Line no.:2
Error Code: 1264 - Out of range value for column 'entry' at row 1
deu esse erro agora

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por neroh em Qui 10 Maio 2012 - 10:14

e cara não sei mais oque pode ser rodei esse seu ai e deu certo aki
não sei por ai ta dando esse erro malz ai.

neroh


Mensagens : 14
Pontos : 71

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por BackStap em Qui 10 Maio 2012 - 19:03

Cara, eu intendi o Error...
Isso que te disseram pode desconsiderar, vamos voltar para a sua primeira mensagem.

Todos os scripts não estão funcionando pois o no canto do MUSTHAVEENTRYID
Você tem de usar um ID para o item.
Não estava dando certo, pois no canto do ID você não pode utilizar letras, apenas números.

Substitua MUSTHAVEENTRYID por IDs utilizando apenas números e me diga se funcionou.

De preferência ID's não existentes, pois como você está executando como Insert, se tiver algum item com o mesmo entry, não vai funcionar.
E eu também não te aconselho trocar por Replace, então use ID's onde não tem nenhum item com o mesmo ID.

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qui 10 Maio 2012 - 19:09

Backstap mano eu fiz isso e deu o outro erro eu tinha colocado o ip 19000000 dai nao foi...

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por BackStap em Qui 10 Maio 2012 - 20:18

Você mostrou ter tentado usar:
.additem 190000

Que com certeza não funfou por ter esse .additem, tente usar sem esse .additem e o espaço, use apenas 190000.
Se não der certo, mostre o error.

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Qui 10 Maio 2012 - 21:24

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 22:24:02
Line no.:2
Error Code: 1264 - Out of range value for column 'entry' at row 1
deu esse erro

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por BackStap em Sex 11 Maio 2012 - 13:07

O número 19000000, é muito alto para se colocar como entry. :D
Escolha um menor.

Tente esse:
190000

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Sex 11 Maio 2012 - 19:05

cara esta dando o mesmo erro
Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-10 22:24:02
Line no.:2
Error Code: 1264 - Out of range value for column 'entry' at row 1

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por BackStap em Sex 11 Maio 2012 - 19:49

VALUES (19000000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, (...)

Você novamente usou 19000000, tente esse mano.
190000

Código:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (190000, 4, 0, -1, "shield foda", 64404, 5, 0, 1, 0, 0, 23, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 99999, 4, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 15, 99999, 5, 99999, 3, 99999, 44, 99999, 0, 0, 0, 0, 0, 0, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, -1, 0, 0, 0, 99999999, 0, 99999999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Sex 11 Maio 2012 - 21:21

Query:
INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (190000, 2, 7, -1, "Warglaive of Maximus", 45479, 6, 0, 1, 1, 1, 13, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 99999, 3, 99999, 4, 99999, 5, 99999, 6, 99999, 7, 99999, 12, 99999, 13, 99999, 14, 99999, 42, 99999, 500000, 999999, 0, 100000, 200000, 4, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 1.0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 99999999, 0, 999, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Error occured at:2012-05-11 22:21:04
Line no.:2
Error Code: 1264 - Out of range value for column 'stat_value1' at row 1
TA DAndo esse erro denovo

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por BackStap em Sab 12 Maio 2012 - 7:13

É por causa que você está usando Números muitos altos mano.
Use números mais baixos.

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (190000, 2, 7, -1, "Warglaive of Maximus", 45479, 6, 0, 1, 1, 1, 13, -1, -1, 255, 100, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 1, 10, 3, 10, 4, 10, 5, 10, 6, 10, 7, 10, 12, 10, 13, 10, 14, 10, 42, 10, 5, 9, 0, 10, 10, 4, 9, 9, 9, 9, 9, 9, 9, 1.0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 1, 3, 0, 0, 9, 0, 9, 0, 0, 0, 0, 1, 0, 2, 0, 2, 0, 3877, 0, 0, 0, 'internalitemhanler', 0, 10)

Diminui os 1000000 2000000 5000000 para 10, 9.
Tente usar isso pra ver se presta, não use números escandalosos assim não, que com certeza não vai funfar em alguns cantos.

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por wanderkpot em Dom 13 Maio 2012 - 14:49

deu certo so q as espadas nao dao para equipar e os arcos nao atacam... oque eu faço agora?

wanderkpot


Mensagens : 48
Pontos : 191

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por Fdmrazor em Dom 13 Maio 2012 - 20:10

Isso, que eu saiba tem que fazer patch no proprio WoW para ele reconheçer, antigamente dava para fazer sem erros e problemas, devido algumas atualizações foram bloqueados. uma alternativa seria você editar armas antigas da versão do burning crusader, ou classic

Fdmrazor


Mensagens : 319
Pontos : 1511

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Resolvido]Como colocar itens editados no wow

Mensagem por Conteúdo patrocinado Hoje à(s) 22:51


Conteúdo patrocinado


Voltar ao Topo Ir em baixo

Página 1 de 2 1, 2  Seguinte

Ver o tópico anterior Ver o tópico seguinte Voltar ao Topo


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