Closed xackery closed 8 years ago
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 ('Dragon Card', 'Dragon Card', '0', '2147483647', '0', '900', '100100', 'IT63', '0', '54', '-1', '1', '0', '0', '1', '1', '0', '0', '', '2003-11-13 04:01:16', '0', '0', '0', '', '0000-00-00 00:00:00', '13THFLOOR', '2012-12-27 10:34:28', '2009-05-08 22:01:35', '0', '0', '0', '70', '0', '0', '0', '100', '1111', '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', '50', '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', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '1', '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', '1', '0', '0', '0', '0', '0', '-1', '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', '-1', '0', '0', '0', '', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '', '-1', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '', '-1');
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
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 ('Dragon Card', 'Dragon Card', '0', '2147483647', '0', '900', '100100', 'IT63', '0', '54', '-1', '1', '0', '0', '1', '1', '0', '0', '', '2003-11-13 04:01:16', '0', '0', '0', '', '0000-00-00 00:00:00', '13THFLOOR', '2012-12-27 10:34:28', '2009-05-08 22:01:35', '0', '0', '0', '70', '0', '0', '0', '100', '1111', '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', '50', '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', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '1', '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', '1', '0', '0', '0', '0', '0', '-1', '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', '-1', '0', '0', '0', '', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '', '-1', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '', '-1');