Need help will +rep

[LJN]

OK I got the SQL to work but the vendor wont if some one could make me a vendor I will +repx2. I dont care what they look like his/her name should be Starting vendor, sub name armor and weapons. Lvl 100 and nutral (cant't spell)
here is the SQL format,

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`)
values('700040','1','1','35','64','64','0','1.1','0','2000','163','218','0','0','0','0','33304','33490690','789','33307','33490436','1038','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');



insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values('700040','Vendor (Only GM can see it)','0','7','0','1','0','3','0',NULL,'262','0','0','0','1','1','0',NULL);

[Illidan1]

what Error are you Getting?

and link your Vendors, Creature_names, and creature_proto Format

[LJN]

/*!40101 SET NAMES utf8 */;

create table `creature_proto` (
	`entry` double ,
	`minlevel` double ,
	`maxlevel` double ,
	`faction` double ,
	`minhealth` double ,
	`maxhealth` double ,
	`mana` double ,
	`scale` float ,
	`npcflags` double ,
	`attacktime` double ,
	`mindamage` float ,
	`maxdamage` float ,
	`rangedattacktime` double ,
	`rangedmindamage` float ,
	`rangedmaxdamage` float ,
	`mountdisplayid` double ,
	`equipmodel1` double ,
	`equipinfo1` double ,
	`equipslot1` double ,
	`equipmodel2` double ,
	`equipinfo2` double ,
	`equipslot2` double ,
	`equipmodel3` double ,
	`equipinfo3` double ,
	`equipslot3` double ,
	`respawntime` double ,
	`armor` double ,
	`resistance1` double ,
	`resistance2` double ,
	`resistance3` double ,
	`resistance4` double ,
	`resistance5` double ,
	`resistance6` double ,
	`combat_reach` float ,
	`bounding_radius` float ,
	`auras` blob ,
	`boss` double ,
	`money` double ,
	`invisibility_type` double ,
	`death_state` double ,
	`walk_speed` float ,
	`run_speed` float ,
	`fly_speed` float ,
	`extra_a9_flags` double 
); 
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('1','1','1','35','64','64','0','1.1','0','2000','163','218','0','0','0','0','33304','33490690','789','33307','33490436','1038','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('3','24','25','21','596','596','0','1','0','1710','39','55','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','61','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('6','1','2','32','55','55','0','0.7','0','2000','1','3','0','0','0','0','5010','50268674','529','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','27','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('25','45','45','2','2972','2972','0','1','0','2000','72','99','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('30','5','6','22','101','101','142','0.5','0','1950','11','14.19','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('36','11','12','14','220','220','0','0.85','0','1810','22','32','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','21','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('38','3','4','17','86','86','0','1','0','1970','7','9.03','0','0','0','0','7487','33490690','781','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','11','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('40','6','7','26','138','138','54','1.15','0','1910','13','14','0','0','0','0','7493','33488898','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','12','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('43','8','9','22','175','175','220','0.55','0','1910','17','21.93','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('46','9','10','18','174','174','150','1','0','1910','19','24.51','0','0','0','0','7485','33490690','768','0','0','0','0','0','0','360000','0','2','2','2','2','2','2','1','1','0','0','17','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('48','21','22','21','419','419','557','0.85','0','1760','30','43','0','0','0','0','7426','33488898','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','49','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('54','10','10','12','303','303','0','1','4224','1910','21','27.09','0','0','0','0','7439','50267138','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('60','8','8','26','147','147','220','1.3','0','1910','17','21.93','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','14','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('61','11','11','17','220','220','0','1','0','1508','68','99','0','0','0','0','7492','33490690','768','7492','33490690','781','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','7','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('66','10','10','12','595','595','0','1','128','1910','21','27.09','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('68','65','65','11','8573','8573','0','1','1','1430','347','434','0','0','0','0','7483','218171138','3','2080','33490436','1038','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','360','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('69','2','2','32','55','55','0','1','0','1990','5','6.45','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','10','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('74','10','10','12','644','644','0','1','4224','1910','21','27.09','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('78','5','5','12','166','166','0','1','4224','1960','11','14.19','0','0','0','0','7439','50267138','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('79','10','10','26','257','257','0','1.3','0','1566','40','58','0','0','0','0','7439','50267138','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','19','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('80','3','4','32','71','71','0','0.85','0','1980','4','6','0','0','0','0','7493','33488898','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','8','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('89','60','70','32','4508','4508','3460','1','0','1510','122','174','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','300','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('92','39','40','91','1672','1672','0','1','0','1610','58','83','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','40','80','80','40','80','40','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('94','5','6','17','120','120','220','1','0','1910','11','14','0','0','0','0','7434','33492738','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','22','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('95','11','12','17','221','221','324','1','0','1860','15','22','0','0','0','0','6443','33492738','768','0','0','0','16752','419500034','0','360000','0','0','0','0','0','0','0','1','1','0','0','20','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('97','8','9','20','174','174','0','0.85','0','1910','17','21.93','0','0','0','0','7488','33490690','768','0','0','0','0','0','0','360000','0','0','9','0','0','0','0','1','1','0','0','15','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('98','17','18','20','383','383','0','1.3','0','1810','22','32','0','0','0','0','7485','33490690','768','1755','33490436','1038','0','0','0','360000','0','0','18','0','0','0','0','1','1','0','0','32','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('99','10','10','17','200','200','0','1','0','1566','40','58','0','0','0','0','6469','33492738','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','7','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('100','12','12','20','245','245','0','1','0','1550','48','68','0','0','0','0','7429','33488898','768','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','21','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('103','5','5','17','101','101','0','1','0','1960','6','6','0','0','0','0','7492','33490690','768','6537','33488900','1815','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','9','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('113','5','6','189','120','120','0','0.6','0','1960','11','14.19','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','20','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('114','14','15','14','325','325','0','1.1','0','1810','22','32','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','26','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('115','17','18','14','385','385','0','1.15','0','1810','22','32','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','32','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('116','8','9','17','157','157','220','1','0','1910','17','21.93','0','0','0','0','7487','33490690','781','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','15','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('117','11','12','20','243','243','0','1','0','1860','15','22','0','0','0','0','7488','33490690','768','0','0','0','0','0','0','360000','0','0','12','0','0','0','0','1','1','0','0','20','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('118','9','10','38','197','197','0','0.85','0','1910','19','24.51','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','1','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('121','15','16','17','461','461','436','1','0','1810','22','32','0','0','0','0','7433','33492738','768','1755','33490436','1038','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','28','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('122','17','18','17','386','386','0','1','0','1810','22','32','0','0','0','0','7434','33492738','768','7488','33490690','781','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','32','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('123','13','14','20','298','298','324','1.15','0','1860','15','22','0','0','0','0','7428','33488898','768','0','0','0','0','0','0','360000','0','0','14','0','0','0','0','1','1','0','0','24','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('124','15','16','20','525','525','436','1.15','0','1810','22','32','0','0','0','0','3502','50267394','273','0','0','0','0','0','0','360000','0','0','16','0','0','0','0','1','1','0','0','28','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('125','19','20','20','444','444','0','1.3','0','1800','23','34','0','0','0','0','7490','33490946','256','0','0','0','0','0','0','360000','0','0','20','0','0','0','0','1','1','0','0','17','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('126','12','12','18','244','244','324','1','0','1860','15','22','0','0','0','0','7434','33492738','768','0','0','0','0','0','0','360000','0','2','2','3','2','2','1','1','1','0','0','22','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('127','18','19','18','374','374','436','1.5','0','1810','22','32','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','2','3','3','2','2','2','1','1','0','0','32','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('128','59','59','18','3900','3900','2620','1.5','0','1410','135','207','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','1','0','0','586','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('151','10','10','12','196','196','0','1','128','1910','21','27.09','0','0','0','0','7443','50267138','1792','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('152','5','5','12','166','166','0','1','129','1960','11','14.19','0','0','0','0','7443','50267138','1792','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('154','16','17','73','383','383','0','1.15','0','1840','18','25','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('157','14','15','189','298','298','302','1','0','1870','14','20','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','10','0','0','0','40','10','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('167','13','13','55','524','524','0','1','4224','1840','18','25','0','0','0','0','0','0','0','0','0','0','0','0','0','360000','0','0','0','0','0','0','0','1','1','0','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('171','15','16','18','353','353','436','1.3','0','1810','22','32','0','0','0','0','7481','33490434','512','0','0','0','0','0','0','360000','0','2','3','2','3','2','2','1','1','0','0','27','0','0','2.5','8','14','0');

[Illidan1]

Try this \/

Insert into `creature_proto` VALUES (700040, 100, 100, 814,  9000,  9000,  9000,  1, 4224, 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);

INSERT INTO creature_names VALUES (700040,"Starter Vendor","Weapons and Armor",0,7,1,0,0,1298,,1,1,1,0,'3','0','0','2.5','8','14','0');

insert into `vendors` values('700040','700000','1','0','0');

insert into `vendors` values('700040','700001','1','0','0');

insert into `vendors` values('700040','700002','1','0','0');

insert into `vendors` values('700040','700003','1','0','0');

insert into `vendors` values('700040','700004','1','0','0');

insert into `vendors` values('700040','700005','1','0','0');

insert into `vendors` values('700040','700006','1','0','0');

insert into `vendors` values('700040','700007','1','0','0');

insert into `vendors` values('700040','700008','1','0','0');

insert into `vendors` values('700040','700009','1','0','0');

insert into `vendors` values('700040','700010','1','0','0');

insert into `vendors` values('700040','700011','1','0','0');

insert into `vendors` values('700040','700012','1','0','0');

insert into `vendors` values('700040','700013','1','0','0');

insert into `vendors` values('700040','700014','1','0','0');

insert into `vendors` values('700040','700015','1','0','0');

insert into `vendors` values('700040','700016','1','0','0');

insert into `vendors` values('700040','700017','1','0','0');

insert into `vendors` values('700040','700018','1','0','0');

insert into `vendors` values('700040','700019','1','0','0');

insert into `vendors` values('700040','700020','1','0','0');

insert into `vendors` values('700040','700021','1','0','0');

insert into `vendors` values('700040','700022','1','0','0');

insert into `vendors` values('700040','700023','1','0','0');

insert into `vendors` values('700040','700024','1','0','0');

insert into `vendors` values('700040','700025','1','0','0');

insert into `vendors` values('700040','700026','1','0','0');

insert into `vendors` values('700040','700027','1','0','0');

insert into `vendors` values('700040','700028','1','0','0');

insert into `vendors` values('700040','700029','1','0','0');

insert into `vendors` values('700040','700030','1','0','0');

insert into `vendors` values('700040','700031','1','0','0');

insert into `vendors` values('700040','700032','1','0','0');

insert into `vendors` values('700040','700033','1','0','0');

insert into `vendors` values('700040','700034','1','0','0');

[Cheesy]

Vendors seem correct, my guess is that something around the actual creature is wrong, you seem too miss some collums. Try this:

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`)

VALUES (700040, 100, 100, 814,  9000,  9000,  9000,  1, 4224, 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);
INSERT INTO creature_names ( `entry`, `name`, `Subname`, `info_str` `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`)
VALUES (700040,"Starter Vendor","Weapons and Armor",'0','7','1','0','0','1298','1298','1298','1298','1','1','1','0');

Try that, I've corrected the creature_names atleast.. It will work for me, rev 2732, not sure about your rev. Reply if it doesnt work

[LJN]

Doesnt work...
Now I will +rep X2 if some one is correct.

[Illidan1]

Execute this and tell me fi work \/

INSERT INTO creature_names ( `entry`, `name`, `Subname`, `info_str` `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`)
VALUES (700040,"Starter Vendor","Weapons and Armor",'0','7','1','0','0','1298','1298','1298','1298','1','1','1','0');

[Cheesy]

Tell me your error please.

[LJN]

This is what it is saying now-

Error occured at:2008-01-01 17:56:25
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `fe' at line 1

My sql-

INSERT INTO creature_names ( `entry`, `name`, `Subname`, `info_str` `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`)
VALUES (700040,"Starter Vendor","Weapons and Armor",'0','7','1','0','0','1298','1298','1298','1298','1','1','1','0');


insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`)

VALUES (700040, 100, 100, 814,  9000,  9000,  9000,  1, 4224, 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);
INSERT INTO creature_names ( `entry`, `name`, `Subname`, `info_str` `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`)
VALUES (700040,"Starter Vendor","Weapons and Armor",'0','7','1','0','0','1298','1298','1298','1298','1','1','1','0');



insert into `vendors` values('700040','700000','1','0','0');

insert into `vendors` values('700040','700001','1','0','0');

insert into `vendors` values('700040','700002','1','0','0');

insert into `vendors` values('700040','700003','1','0','0');

insert into `vendors` values('700040','700004','1','0','0');

insert into `vendors` values('700040','700005','1','0','0');

insert into `vendors` values('700040','700006','1','0','0');

insert into `vendors` values('700040','700007','1','0','0');

insert into `vendors` values('700040','700008','1','0','0');

insert into `vendors` values('700040','700009','1','0','0');

insert into `vendors` values('700040','700010','1','0','0');

insert into `vendors` values('700040','700011','1','0','0');

insert into `vendors` values('700040','700012','1','0','0');

insert into `vendors` values('700040','700013','1','0','0');

insert into `vendors` values('700040','700014','1','0','0');

insert into `vendors` values('700040','700015','1','0','0');

insert into `vendors` values('700040','700016','1','0','0');

insert into `vendors` values('700040','700017','1','0','0');

insert into `vendors` values('700040','700018','1','0','0');

insert into `vendors` values('700040','700019','1','0','0');

insert into `vendors` values('700040','700020','1','0','0');

insert into `vendors` values('700040','700021','1','0','0');

insert into `vendors` values('700040','700022','1','0','0');

insert into `vendors` values('700040','700023','1','0','0');

insert into `vendors` values('700040','700024','1','0','0');

insert into `vendors` values('700040','700025','1','0','0');

insert into `vendors` values('700040','700026','1','0','0');

insert into `vendors` values('700040','700027','1','0','0');

insert into `vendors` values('700040','700028','1','0','0');

insert into `vendors` values('700040','700029','1','0','0');

insert into `vendors` values('700040','700030','1','0','0');

insert into `vendors` values('700040','700031','1','0','0');

insert into `vendors` values('700040','700032','1','0','0');

insert into `vendors` values('700040','700033','1','0','0');

insert into `vendors` values('700040','700034','1','0','0');

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700017','1','0','0');

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700018','1','0','0');

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700019','1','0','0');

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700020','1','0','0');

insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700021','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700022','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700023','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700024','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700025','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700026','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700027','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700028','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700029','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700030','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700031','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700032','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700033','1','0','0');
insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`) values('700040','700034','1','0','0');

[Cheesy]

Fixed it? Since you've released the starter npc.
Otherwise, sorry, I tried, I'm not that good at SQL yet :P