BGames
Olá visitante! Seja bem vindo á BGames!

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

Registre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!


BGames
Olá visitante! Seja bem vindo á BGames!

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

Registre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

BGames
Gostaria de reagir a esta mensagem? Crie uma conta em poucos cliques ou inicie sessão para continuar.

BGamesEntrar

Fórum de Desenvolvimento de Jogos e Programação


[SQL]Supreme Itens - Sets/Weapons/Miscs

power_settings_newInicie sessão para responder
+13
Sr.Supremus
monzila777
FabioSammets
Legendarios
Aquilla
Psychosocial
Swift
KAOZ
Mitts'
edenico
Dysorder
Returning
WoWCore
17 participantes

description[SQL]Supreme Itens - Sets/Weapons/Miscs Empty[SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
É uma query com sets,armas e acessórios.

- Displays exclusivos!

- Execute a query "_ALL_SQL_" na database world.
- Os ids podem ser encontrados na tabela item_template.

- Se quiser adicionar separadamente use as querys da pasta "querys individuais"
- Dentro do arquivo baixado tem imagens dos sets.

Download Aqui!

Créditos:
darksoke - ac-web.org

Gostou?
Clique Aqui!

Última edição por mthsena em Ter 20 Nov 2012 - 12:15, editado 1 vez(es)

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Tem fotos?

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Returning escreveu:
Tem fotos?

Tem sim, estão dentro do arquivo.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Mto bom , vlw por compatinhar +rep =D

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Cara eu nunca consigo dar dump no meu servidor em todas as coisas que eu baixo .sql não da man fica falando esse erro

There was error(s) while executing the queries .
The query and the error message has been logged at:
C:\Users\Returning\AppData\Roaming\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Clica no Open Error File e posta o error -.- , aqui rodou normal .

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `WDBVerified`) VALUES('80895','4','1','-1','|cffDA70D6Supreme |cffffffffGladiator\'s Cord of Dominance','65289','4','36864','0','1','0','1','6','400','32767','264','80','0','0','0','0','0','0','0','0','1','0','5','45','300','7','350','5','300','32','300','35','300','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','219','0','0','0','0','0','0','0','0','0','0','1','0','0','-1','0','-1','0','1','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','7','0','0','0','0','0','35','0','0','0','0','8','0','0','0','0','0','2872','0','-1','0','0','0','0','','0','0','0','0','0','12340')

Error occured at:2012-11-20 15:35:02
Line no.:4
Error Code: 1062 - Duplicate entry '80895' for key 'PRIMARY'


Esse é o erro.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
aqui rodou normal!,'

Aconselho usar o navicat é mais facil de usar!

Vlw por compartilhar mthsena. +REP

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Vou testar! :D

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
mano faz o seguinte , ta vendo ali no começo da query escrito ( INSERTO INTO ) muda pra REPLACE INTO , o error ai ta dizendo q ja existe um item com este id , fassa isso que creio q ira funcinar .

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
legal rodou normal aqui também !
obrigado

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
[Err] 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 '--- --------------------------------------------------------
--- 01_Weapons_Mi' at line 1
[Err] --- --------------------------------------------------------
--- 01_Weapons_Miscs.sql
--- ---------------------------------------

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Olá,
Você tem um erro em sua sintaxe SQL; verifique o manual que corresponde à sua versão do servidor MySQL para a sintaxe direita ao uso próximo.

Até mais.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Funciona em Mangos?

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
ali tem dizendo ac-web.org e o ac-web e trinity acredito qe nao funcione em mangos .

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Está,
SQL,
Não funfa para mangos se não o mathsena informava se erá pra trinity ou magos,
Pois então e trinity, porque o não infomo e o fórum a maioria usa trinity,

Acho que não funfa mangos.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Muito Bom Mais +Repp
O autor desta mensagem foi banido do fórum - Mostrar mensagem

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
da erro aqui
SQL Error: 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 '--- --------------------------------------------------------
--- 01_Weapons_Mi' at line 1

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
da erro aqui
SQL Error: 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 '--- --------------------------------------------------------
--- 01_Weapons_Mi' at line 1


Esse error é porque esta linha não pertence ao Script, apague esta linha toda :

Código:

--- --------------------------------------------------------
--- 01_Weapons_Miscs.sql
--- --------------------------------------------------------


e so deixe a do script que é INSERT INTO `item_template`..........................................................................................
Então o que não pertencer ao script e falar no error você apaga a linha que fala e tenta executar o script.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
SQL Error: Duplicate entry '80895' for key 'PRIMARY' o meu aparece esse erro aki . af

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Sr.Supremus tem uma possivel solução dada na pagina 1 desse tópico que fala em trocar o INSERT INTO por REPLACE INTO então tente fazer isto em algum item que deu error se der certo você faz isso em tudo --* (não guentei faze em tudo fiz só em uns 20 e coloquei no server e rodou sem error).
Espero que funcione [SQL]Supreme Itens - Sets/Weapons/Miscs 985951499

Edit ~~> quem disse isto foi o Dysorder na pagina 1 deste tópico ^^

Última edição por Gabrieljf em Sex 15 Fev 2013 - 22:22, editado 1 vez(es)

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
ixi vlw ai gabriel :D

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
aparece esse erro no meu alguem ajuda ae

Query:
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (18583, 2, 7, -1, 'Warglaive of Azzinoth (Right)', 30934, 6, 33792, 0, 1, 0, 246242, 13, 76, -1, 100, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 3, 7, 126, 3, 125, 44, 115, 19, 112, 38, 122, 31, 119, 32, 122, 0, 0, 0, 0, 0, 0, 0, 0, 620, 800, 0, 50, 110, 6, 0, 0, 0, 0, 0, 50, 60, 1000, 0, 0, 67355, 1, 0, 0, 0, 0, 0, 69274, 2, 0, 0, 0, 0, 0, 23951, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Battle WoW', 0, 0, 0, 0, 0, -1, 1, 0, 0, 0, 0, 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 12340)

Error occured at:2013-02-16 09:32:17
Line no.:1
Error Code: 1054 - Unknown column 'unk0' in 'field list'

Query:
REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `WDBVerified`) VALUES (18583, 2, 7, -1, 'Warglaive of Azzinoth (Right)', 30934, 6, 33792, 0, 1, 0, 246242, 13, 76, -1, 100, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 3, 7, 126, 3, 125, 44, 115, 19, 112, 38, 122, 31, 119, 32, 122, 0, 0, 0, 0, 0, 0, 0, 0, 620, 800, 0, 50, 110, 6, 0, 0, 0, 0, 0, 50, 60, 1000, 0, 0, 67355, 1, 0, 0, 0, 0, 0, 69274, 2, 0, 0, 0, 0, 0, 23951, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Battle WoW', 0, 0, 0, 0, 0, -1, 1, 0, 0, 0, 0, 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '', 0, 0, 0, 0, 12340)

Error occured at:2013-02-16 09:32:24
Line no.:1
Error Code: 1054 - Unknown column 'unk0' in 'field list'

Query:
INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`) VALUES (200501, 32837, 32375, 0)

Error occured at:2013-02-16 23:33:19
Line no.:2
Error Code: 1054 - Unknown column 'equipentry1' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `WDBVerified`) VALUES('80895','4','1','-1','|cffDA70D6Supreme |cffffffffGladiator\'s Cord of Dominance','65289','4','36864','0','1','0','1','6','400','32767','264','80','0','0','0','0','0','0','0','0','1','0','5','45','300','7','350','5','300','32','300','35','300','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','219','0','0','0','0','0','0','0','0','0','0','1','0','0','-1','0','-1','0','1','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','7','0','0','0','0','0','35','0','0','0','0','8','0','0','0','0','0','2872','0','-1','0','0','0','0','','0','0','0','0','0','12340')

Error occured at:2013-02-18 11:54:35
Line no.:4
Error Code: 1054 - Unknown column 'SoundOverrideSubclass' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `WDBVerified`) VALUES('80895','4','1','-1','|cffDA70D6Supreme |cffffffffGladiator\'s Cord of Dominance','65289','4','36864','0','1','0','1','6','400','32767','264','80','0','0','0','0','0','0','0','0','1','0','5','45','300','7','350','5','300','32','300','35','300','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','219','0','0','0','0','0','0','0','0','0','0','1','0','0','-1','0','-1','0','1','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','7','0','0','0','0','0','35','0','0','0','0','8','0','0','0','0','0','2872','0','-1','0','0','0','0','','0','0','0','0','0','12340')

Error occured at:2013-02-18 11:55:09
Line no.:4
Error Code: 1054 - Unknown column 'SoundOverrideSubclass' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `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`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `WDBVerified`) VALUES('80895','4','1','-1','|cffDA70D6Supreme |cffffffffGladiator\'s Cord of Dominance','65289','4','36864','0','1','0','1','6','400','32767','264','80','0','0','0','0','0','0','0','0','1','0','5','45','300','7','350','5','300','32','300','35','300','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','219','0','0','0','0','0','0','0','0','0','0','1','0','0','-1','0','-1','0','1','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','0','0','0','0','-1','0','-1','1','','0','0','0','0','0','7','0','0','0','0','0','35','0','0','0','0','8','0','0','0','0','0','2872','0','-1','0','0','0','0','','0','0','0','0','0','12340')

Error occured at:2013-02-18 11:56:07
Line no.:4
Error Code: 1054 - Unknown column 'SoundOverrideSubclass' in 'field list'

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
Devil troque as linhas que estão com o unk0 por 'SoundOverrideSubclass' testei aqui e deu.

description[SQL]Supreme Itens - Sets/Weapons/Miscs EmptyRe: [SQL]Supreme Itens - Sets/Weapons/Miscs

more_horiz
privacy_tip Permissões neste sub-fórum
Não podes responder a tópicos
power_settings_newInicie sessão para responder