2.4.3 GM Vendors

[benjon]

I wonder if there is a way to get vendors on the GM island? I have tried with adding one, but then the SQLYog just got messed up, and didn't like me doing that..

---------- Post added at 06:38 PM ---------- Previous post was at 06:31 PM ----------

This is the error I get when I try to add the one I have downloaded:

Query:
insert into `creature_proto` values('50080','70','70','35','10000','10000','1000','1','4225','100','0','1000','1001','0','0','0','0','0','0','0','0','0','0','0','0','0','500','1212','0','0','0','0','0','0','1.5','0.208','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0')

Error occured at:2011-02-21 21:38:11
Line no.:102
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
insert into `creature_proto` values('50080','70','70','35','10000','10000','1000','1','4225','100','0','1000','1001','0','0','0','0','0','0','0','0','0','0','0','0','0','500','1212','0','0','0','0','0','0','1.5','0.208','0','0','0','0','0','2.5','8','14','0','0','0','0','0','0','0')

Error occured at:2011-02-21 21:38:53
Line no.:102
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_proto` VALUES ('30040', '100', '100', '1741', '1000000', '1000000', '1000000', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:39:00
Line no.:14
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:40:34
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:43:53
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:44:00
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:44:23
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:44:26
Line no.:200
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:45:56
Line no.:15
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:47:55
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:48:03
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:48:22
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null)

Error occured at:2011-02-21 21:48:28
Line no.:11
Error Code: 1062 - Duplicate entry '30052' for key 1

Query:
INSERT INTO `creature_names` VALUES ('30052', 'Global GM Trainer', '', '', '16', '4', '0', '3', '0', null, '23195', '0', '0', '0', '1', '1', '0', null)

Error occured at:2011-02-21 21:48:32
Line no.:11
Error Code: 1062 - Duplicate entry '30052' for key 1

Query:
ALTER TABLE `creature_proto` ADD COLUMN `modImmunities` INT(30) UNSIGNED NOT NULL DEFAULT 0

Error occured at:2011-02-21 21:49:07
Line no.:1
Error Code: 1060 - Duplicate column name 'modImmunities'

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:49:21
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:57:47
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 21:58:32
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 22:09:19
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO `creature_spawns` VALUES ('9660670', '50002', '1', '16255.3', '16296', '13.1745', '3.0377', '0', '18106', '1741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2011-02-21 22:09:21
Line no.:201
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
CREATE TABLE `ai_agents` (
  `entry` int(11) unsigned NOT NULL default '0',
  `type` smallint(5) unsigned NOT NULL default '0',
  `event` int(11) unsigned NOT NULL default '0',
  `chance` int(11) unsigned NOT NULL default '0',
  `maxcount` int(11) unsigned NOT NULL default '0',
  `spell` int(11) unsigned NOT NULL default '0',
  `spelltype` int(11) unsigned NOT NULL default '0',
  `targettype` int(11) unsigned NOT NULL default '0',
  `cooldown` int(8) NOT NULL default '0',
  `floatMisc1` float NOT NULL default '0',
  `Misc2` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2011-02-21 23:22:43
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
DELETE FROM creature_names WHERE entry BETWEEN 50000 AND 50085

Error occured at:2011-02-24 20:35:46
Line no.:2
Error Code: 1046 - No database selected

Query:
DELETE FROM creature_names WHERE entry BETWEEN 50000 AND 50085

Error occured at:2011-02-24 20:35:48
Line no.:2
Error Code: 1046 - No database selected

[benjon]

Is there any other way to add custom vendors to the GM island? Any good downloads for it?..

---------- Post added at 10:45 PM ---------- Previous post was at 09:39 PM ----------

How to I get it to match row 1?... And not being duplicate and such?...