Ignore replace, item was created via my dev in peq then edited in peq for me to get the query. Im at work on a phone.
REPLACE INTO items (`Name`, `lore`, `artifactflag`, `color`, `fvnodrop`, `icon`, `id`, `idfile`, `itemclass`, `itemtype`, `loregroup`, `magic`, `material`, `minstatus`, `nodrop`, `norent`, `pendingloreflag`, `tradeskills`, `comment`, `created`, `deity`, `evolvinglevel`, `light`, `serialization`, `serialized`, `source`, `updated`, `verified`, `favor`, `guildfavor`, `ldonprice`, `ldonsellbackrate`, `ldonsold`, `ldontheme`, `pointtype`, `price`, `sellrate`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `classes`, `races`, `slots`, `reclevel`, `recskill`, `reqlevel`, `potionbelt`, `potionbeltslots`, `stackable`, `stacksize`, `attuneable`, `expendablearrow`, `nopet`, `notransfer`, `size`, `weight`, `heroic_cr`, `heroic_dr`, `heroic_fr`, `heroic_mr`, `heroic_pr`, `heroic_svcorrup`, `cr`, `dr`, `fr`, `mr`, `pr`, `svcorruption`, `ac`, `endur`, `hp`, `mana`, `aagi`, `acha`, `adex`, `aint`, `asta`, `astr`, `awis`, `heroic_agi`, `heroic_cha`, `heroic_dex`, `heroic_int`, `heroic_sta`, `heroic_str`, `heroic_wis`, `accuracy`, `attack`, `avoidance`, `clairvoyance`, `combateffects`, `damageshield`, `dotshielding`, `dsmitigation`, `enduranceregen`, `healamt`, `manaregen`, `regen`, `shielding`, `spellshield`, `strikethrough`, `stunresist`, `damage`, `delay`, `haste`, `banedmgamt`, `banedmgbody`, `banedmgrace`, `banedmgraceamt`, `elemdmgamt`, `elemdmgtype`, `extradmgamt`, `extradmgskill`, `backstabdmg`, `range`, `spelldmg`, `augdistiller`, `augrestrict`, `augslot1type`, `augslot1unk2`, `augslot1visible`, `augslot2type`, `augslot2unk2`, `augslot2visible`, `augslot3type`, `augslot3unk2`, `augslot3visible`, `augslot4type`, `augslot4unk2`, `augslot4visible`, `augslot5type`, `augslot5unk2`, `augslot5visible`, `augtype`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `bardeffect`, `bardeffecttype`, `bardtype`, `bardvalue`, `casttime`, `casttime_`, `clickeffect`, `clicklevel`, `clicklevel2`, `clicktype`, `maxcharges`, `recastdelay`, `recasttype`, `focuseffect`, `focuslevel`, `focuslevel2`, `focustype`, `proceffect`, `proclevel`, `proclevel2`, `procrate`, `proctype`, `scrolleffect`, `scrolllevel`, `scrolllevel2`, `scrolltype`, `clickname`, `focusname`, `procname`, `scrollname`, `wornname`, `worneffect`, `wornlevel`, `wornlevel2`, `worntype`, `UNK012`, `UNK013`, `UNK014`, `UNK033`, `UNK054`, `UNK059`, `UNK060`, `UNK120`, `UNK121`, `UNK123`, `UNK124`, `UNK127`, `UNK132`, `UNK134`, `UNK137`, `UNK142`, `UNK147`, `UNK152`, `UNK157`, `UNK193`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `augslot6type`, `augslot6unk2`, `augslot6visible`, `bardlevel`, `bardlevel2`, `bardname`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardunk7`, `benefitflag`, `book`, `booktype`, `charmfile`, `charmfileid`, `clickunk5`, `clickunk6`, `clickunk7`, `elitematerial`, `epicitem`, `evoid`, `evoitem`, `evomax`, `filename`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `heirloom`, `herosforgemodel`, `lorefile`, `placeable`, `powersourcecapacity`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `purity`, `questitemflag`, `scriptfileid`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `skillmodmax`, `skillmodtype`, `skillmodvalue`, `summonedflag`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`) VALUES ('Valarons earing', 'Valarons enagement earing', '0', '0', '0', '0', '132476', 'IT', '0', '29', '0', '0', '-1', '0', '1', '1', '0', '0', '', '201612015211', '0', '0', '0', '', '0000-00-00 00:00:00', 'CUSTOM', '2016-01-20 15:21:01', '2016-01-20 15:21:01', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '2', '0', '0', '66', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '555', '555', '555', '555', '55', '55', '55', '55', '55', '55', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '192', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '-1', '0', '0', '0', '0', '-1', '0', '0', '0', '', '', '', '', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0000000000000000000', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '', '0');
|