2.3.0 Mall

[IcyHot]

Anyone know of any malls that work on 2.3.0 I tryed Julianx Mall and Illidans Mall both dont work on Dryice's 2.3.0 DB, anyone that has one +rep. Thanks =)

[entrepid]

http://www.mmowned.com/forums/emulat...ndors-etc.html

Its not a mall but i took chrispees vendors and put them in so you can spawn them

edit: this is a whole database so follow my instructions if you replace db's

[IcyHot]

i dont wanna replace my whole DB again lol, but yeah how did you put his NPCs in there?

[entrepid]

i took the vendors and dumped my sql file took those specific vendors and executed them into 2.3 db

[IcyHot]

can you make a download for the specific vendors?

[entrepid]

that might be a lil difficult , i changed a value in the table so it would be compatible to execute but ill see what i can do k?

if you want to help you can open up creature_names in navicat/sqlyog and list the names of collumns in order? like names field4 etc

[IcyHot]

Sweet, thanks. I downloaded chrispeees new DB and got the vendors, but when i try to import it into my DB it comes up with "SQL Error: Column count doesn't match value count at row 1"

[entrepid]

yea exactly what i said , can you list the collumns names for me in order

[IcyHot]

I put this into notepad and saveed it vendors.sql and then tryed to import it:

INSERT INTO `creature_names` VALUES ('50008', 'Armor', 'Raid Tier VI', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50009', 'Armor', 'Wrist', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50010', 'Armor', 'Waist', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50011', 'Armor', 'Feet', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50012', 'Armor', 'Shield', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50015', 'Weapon', 'Level 50+', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50016', 'Weapon', 'Level 60+', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50017', 'Weapon', 'Level 65+', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50018', 'Weapon', 'Level 75+', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50019', 'Weapon', 'Level 100+', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50020', 'Armor', 'Necklace', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50021', 'Armor', 'Rings', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50022', 'Armor', 'Trinket', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50023', 'Armor', 'Cloak', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50024', 'Armor', 'Shirt', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50025', 'Armor', 'Tabard', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50026', 'Armor', 'Miscellaneous', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50029', 'Armor', 'Libram/Idol/Totem', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50030', 'Arena', 'Season I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50031', 'Arena', 'Season I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50032', 'Arena', 'Season I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50033', 'Arena', 'Season II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50034', 'Arena', 'Season II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50035', 'Arena', 'Season II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50040', 'Misc', 'Gemstone I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50041', 'Misc', 'Gemstone II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50042', 'Misc', 'Mount I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50043', 'Misc', 'Mount II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50044', 'Misc', 'Projectile', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50045', 'Misc', 'Container', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50049', 'Misc', 'Currency', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50050', 'Recipe', 'Book A-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50051', 'Recipe', 'Leather A-F', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50052', 'Recipe', 'Leather G-R', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50053', 'Recipe', 'Leather S-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50054', 'Recipe', 'Tailor A-G', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50055', 'Recipe', 'Tailor H-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50056', 'Recipe', 'Engineer A-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50057', 'Recipe', 'Blacksmith A-F', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50058', 'Recipe', 'Blacksmith G-R', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50059', 'Recipe', 'Blacksmith S-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50060', 'Recipe', 'Cooking A-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50061', 'Recipe', 'Alchemy A-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50062', 'Recipe', 'Enchant A-G', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50063', 'Recipe', 'Enchant H-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50007', 'Armor', 'Raid Tier V', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50006', 'Armor', 'Raid Tier IV', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50005', 'Armor', 'Raid Tier III', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50004', 'Armor', 'Raid Tier II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50003', 'Armor', 'Raid Tier I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50002', 'Armor', 'Dungeon III', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50001', 'Armor', 'Dungeon II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50000', 'Armor', 'Dungeon I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('171171', 'Chrispee', 'Custom shop', '0', '4', '0', '3', '0', '0', '21662', '1', '1', '0', '0');
INSERT INTO `creature_names` VALUES ('50064', 'Recipe', 'Jeweler A-K', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50065', 'Recipe', 'Jeweler L-Z', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50066', 'Reagent', 'Leather I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50067', 'Reagent', 'Leather II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50068', 'Reagent', 'Tailor I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50069', 'Reagent', 'Tailor II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50070', 'Reagent', 'Engineer I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50071', 'Reagent', 'Engineer II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50072', 'Reagent', 'Blacksmith I', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50073', 'Reagent', 'Blacksmith II', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50074', 'Reagent', 'Cooking', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50075', 'Reagent', 'Alchemy', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50076', 'Reagent', 'Enchant', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50077', 'Reagent', 'Jeweler', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50078', 'Reagent', 'Miscellaneous', '0', '4', '0', '3', '0', '0', '17072', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50085', 'Weapon', 'Raid Tier VII', '0', '4', '0', '3', '0', '0', '2606', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('30001', 'Chrispeee', 'Teleporter Npc', '0', '4', '0', '3', '0', '0', '21576', '1', '1', '1', '0');
INSERT INTO `creature_names` VALUES ('50083', 'Armor', 'Raid Tier VII', '0', '4', '0', '3', '0', '0', '21322', '1', '1', '1', '0');

[entrepid]

No i mean, the table in your databse , creature_names just list the table names like name, field4, unk2 etc in order though and i can fix it

[IcyHot]

entry, name, subname, mouseflags, flags1, type, family, rank, unk4, spelldataid, male_displayid, female_displayid, male_displayid2, female_displayid2, unknown_float1, unknown float2, civilian, leader.

[IcyHot]

What if i just uploaded chrispeees DB and then just dumped creature_names out of it, and then deleted my creature_names and imported chrispeees?

[Rednexx]

then it would work if the db's are same rev

[entrepid]

INSERT INTO creature_names
(`entry`, `name`, `Subname`,`mouseflags `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(50000, 'Armor', 'Dungeon Set 1', 0, 0, 4, 0, 3, 0, 0, 20023, 0, 0, 0, 0, 0, 0, 0);


copy n save that into notepad and try executing that just to see if it works

[IcyHot]

dident work came up with huge error somthing read manual lol