custom vendor help

[Boness]

Ok I am doing this on navicat and when I execute the batch file this shows up.

[Err] 1054 - Unknown column 'level' in 'field list'
[Err] INSERT INTO creature_proto (entry, level, faction, health, 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 (50000, 58, 814, 574754, 1, 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);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Xcynic]

the column level, is supposed to me minlevel, maxlevel so like this:


[Err] 1054 - Unknown column 'level' in 'field list'
[Err] INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, health, 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 (50000, 58, 58, 814, 574754, 1, 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);
[Msg] Finished - Unsuccessfully

add the red parts

[Boness]

ty on that part...now there is another error:yuck:
I have spawned this creature so I know it is a good display ID.

[Err] 1054 - Unknown column 'displayid' in 'field list'
[Err] INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES (90001,"Don't PVP at the MALL!","I WILL RAPE U IF U DO",0,7,1,0,0,NULL,1747,1,1,1,NULL);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Xcynic]

what database do you use?

try this:

INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unk2, unk3, Civilian, Leader)
VALUES (90001,"Don't PVP at the MALL!","I WILL RAPE U IF U DO",0,7,1,0,0,NULL,1747,1,1,1,1,NULL);


Red colored text is new: copy paste and try that.

[Boness]

Now this is my error list...btw I am using Navicat...and I haven't downloaded any repacks...for some reason they just don't feel like working for me. If you can help me fix my comp and its repack problem ty.

[Err] 1054 - Unknown column 'unk2' in 'field list'
[Err] INSERT INTO creature_names (entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unk2, unk3, Civilian, Leader)
VALUES (90007,"Don't PVP at the MALL!","I WILL RAPE U IF U DO",0,7,1,0,0,NULL,1747,1,1,1,1,NULL);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Boness]

bump6): sry...still need help =(

[Xcynic]

You dont have a database? :S

[Equ1N0X]

JulianX repack 5
works like a charm if you follow carefully

[Boness]

I can never get any repacks to work...so i guess not >.>

[Equ1N0X]

if you dint know how to use a repack, then how do you expect to get your server running? a repack is basically a premade folder with serve rfiles, if you cant sue that, how would making your own files work easyer?

[Boness]

Ya, I went to those and they never gave a good guide...for noobies like me. Just found Julianx...It has a good guide so far.

[Xcynic]

go look in the creature_names column and see if u find something called unk2, if its something else then just rename it to that

[Boness]

It is named unknown1 in navicat..I changed it to that and it still didn't work.hnoes:

[Xcynic]

well you have to look at all columns, if they match what the sql says, change everything that isnt correct.

[Boness]

I did but it isnt stil saying unknow column "unk1" in "field" list