[Ascent]How to create vendors ?

[thedoomx]

Hello ,
I am using chrispees repack for 2.3.0.(it's very cool ) on his repack for 2.2.3 i was making vendors from wow-v.com but now they don't execute in sqlog
Can u help me i want to execute Knaur's t7 and t8 items in vendors please help me if u can.

[Dryice]

post the error please

[thedoomx]

Error occured at:2007-12-11 11:23:24
Line no.:2
Error Code: 1054 - Unknown column 'item1slotdisplay' in 'field list'
Query:
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)
VALUES (77777, 255, 255, 814, 3223, 3223, 22, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)
Error occured at:2007-12-11 18:22:19
Line no.:2
Error Code: 1054 - Unknown column 'item1slotdisplay' in 'field list'
this is help me please

[Chrispee]

the query from wow v is old to my db

y dont u make it manually more simple

[Herleybob]

it seems that chrispees repack isnt up to date with WoW-V.

[Viter]

it seems that chrispees repack isnt up to date with WoW-V.

Ore WoW-v is made for a old ascent revision?
so chrispee's repack is not out of date its WoW-V

[thedoomx]

so what will i do ?
or chrispee upload the program which u are using for npcs please to make my vendors

[Chrispee]

i dont use nay programs mate i just do it manualy if u dont know how to make it i dont think u should host a prvate server to make an npc is the most stupid thing

[latruwski]

wow-v sucks, use ascent database editor
or just insert manually...

grtz

[thedoomx]

ok thanks
Btw ADE don't works for npcs ...

[latruwski]

ok thanks
Btw ADE don't works for npcs ...

what error you get or something? report it to me
anyhow it should be working.. worked for me last time i tested!

note: if you use repacks i may happen that it does not work... becuz repacks often have their own DBstructure... ADE is working with latest structures (see ADE topic)

anyhow... report and i'll see

grtz

[thedoomx]

something like unknown colunm 'creature_name' in field list ...

[latruwski]

something like unknown colunm 'creature_name' in field list ...

did you test latest ADE version?

also ADE only works for the latest official DB structure... so repacks can be a little different from the official structure...


grtz

[thedoomx]

i made it manually but i am putting 3 hours the items