How to make a custom City/Instance/Area Detailed and advanced!

[Panda94]

nice work^^ i will try it

[Desinate]

I get an error when i try execute the batch file.. "[Err] 1136 - Column count doesn't match value count at row 1" and something. Got any ideas?

[04watkinsg]

Hi! i'm a bit of a noob to all of this i got the HeidiSQL everytime i do password and username root it just says error cant conect why can you help me! and btw this guide looks awsome if i under stood it!! thank yo so much

[04watkinsg]

ahh ma bad didnt have sql running! everytime i pess f9 it says please secent a data base... but i dont understand, can someone help!!

[breaksthings1]

dude this is a crazy guide but i keep haveing a problem. after i load the sql. i have to execute sql and when i do that it says: SQL error: Column count doesn't match value count at row 1: dude plz help

[sasoritail]

What repack u guys got?

[fer182]

I get an error when i try execute the batch file.. "[Err] 1136 - Column count doesn't match value count at row 1" and something. Got any ideas?

i have same problem.

[culo]

Error.

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `gameobject_names` VALUES ('99871', '5', '7266', 'Spike', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully

[Matochio]

Really detailed but its good.

[doomed461]

Everytime i try to execute the batch file, or query them in Heidisql it just says Column count doesn't match value count at row 1 can anyone help me?

[winddragon]

the problem some are having is that the gameobject table structure has changed since the release of these SQLs. this is the current readout of the structure.

/*
SQLyog Community Edition- MySQL GUI
MySQL - 5.0.27-community-nt
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `gameobject_custom` (
`entry` double ,
`Type` double ,
`DisplayID` double ,
`Name` varchar (300),
`Name2` varchar (300),
`Name3` varchar (300),
`Name4` varchar (300),
`Category` varchar (300),
`CastBarText` varchar (300),
`UnkStr` varchar (300),
`spellfocus` double ,
`sound1` double ,
`sound2` double ,
`sound3` double ,
`sound4` double ,
`sound5` double ,
`sound6` double ,
`sound7` double ,
`sound8` double ,
`sound9` double ,
`unknown1` double ,
`unknown2` double ,
`unknown3` double ,
`unknown4` double ,
`unknown5` double ,
`unknown6` double ,
`unknown7` double ,
`unknown8` double ,
`unknown9` double ,
`unknown10` double ,
`unknown11` double ,
`unknown12` double ,
`unknown13` double ,
`unknown14` double
);


if you add the missing columes it should work.

[kingofwc]

this is good man..keep up the good work

[kingofwc]

thx for the pictures man =D

[Hellami1]

ty +Rep this really helped

[Kreach]

This is a sweet guide so +rep!