[Release] Custom Vendors [Season 4 Vendor+Items]

[raer901]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_proto` VALUES ('50000', '70', '70', '35', '303', '303', '0', '0.5', '4224', '1910', '0', '21', '27.09', '0', '0', '0', '0', '7439', '50267138', '781', '0', '0', '0', '0', '0', '0', '360000', '518', '0', '0', '0', '0', '0', '0', '1.5', '0.208', '0', '0', '0', '0', '0', '2.5', '8', '14', '0');
[Msg] Finished - Unsuccessfully




what do i have to do ?

[mager1794]

I LIke + Rep I Will be putting as an additional for my repack

[raer901]

ERROR 1136 (21S01) at line 201: Column count doesn't match value count at row 1

this comes when i try to use the Tool and import the vendors

[Wolverine77]

ERROR 1136 (21S01) at line 201: Column count doesn't match value count at row 1

this comes when i try to use the Tool and import the vendors

same issue for me

[foxconn]

how to use it after install??

[tcslasher20]

When ever i try to import the the files from the "vendor" folder after it was extracted my HeidiSQL loads a portion of "vendors" before it just goes un responsive... Should i just wait a long to for it to do something or am i doing something i shouldnt im... im just very confizzled:confused:

[fylo]

Sweet this is just what i needed ++ rep 4 u man tyvm ! =D

[samsk8]

i dont get how i need to install can u make a movie on youtube plz

[tcslasher20]

I dont think my HeidiSQL can handle 3143 lines. i get it to the point where its at about 3/4 of the way through then it just freezes... i looked around another forum that is just about HeidiSQL and other people have had this problamo aswell... so is there any way to import the files in chunks? and if not, can i reset my HeidiSQL database?

[BmxAudio]

This is confusing from all hell. I have my database open (Heidisql) and my panex repack 6.4 running but when i try to import the vendors i cant because in the revisions it tells me to open them with notepad but doesnt allow me to all i can do is run the program not open it with note pad which is a bit confusing. If some one could help me that would be excellent.

[robertor]

for the love of god will somebody less lazy than me convert this for use with mangos

Im trying to do that, but IDK what the "creature_proto" mangos equivalent is


NVM, its harder than I thought

[ducky69247]

Im trying to do that, but IDK what the "creature_proto" mangos equivalent is


NVM, its harder than I thought

What kind of stuff does creature_proto have in it? I'll dig around in my Db and find out what has the same stuff

[robertor]

What kind of stuff does creature_proto have in it? I'll dig around in my Db and find out what has the same stuff

I think it has the same stuff "crature_template" has in mangos, so "creature_proto"+"creature_names"(ascent)="creature_template"(mangos) [Correct me if i'm wrong]
And stuff isn't in the same order, so converting it will be a challenge.

[ducky69247]

SS of world db tables,


and an example entry from creature_template, i.e. cloth armour vendor already friendly to all players

INSERT INTO creature_template
   (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`)
VALUES
   (26301, 23762, 0, 23762, 0, 'Cloth Armor Vendor', '', '', 70, 70, 5000000, 5000000, 0, 0, 10000, 35, 35, 4224, 2, 1, 2, 4000, 7000, 0, 0, 2000, 0, 768, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, '');

[krattan]

how to install this ? it just comming up error for me ? :'( plzz help!?