2.4.3 GM Vendors menu

User Tag List

Results 1 to 2 of 2
  1. #1
    benjon's Avatar Private
    Reputation
    1
    Join Date
    Jan 2011
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    2.4.3 GM Vendors

    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:
    Code:
    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

    2.4.3 GM Vendors
  2. #2
    benjon's Avatar Private
    Reputation
    1
    Join Date
    Jan 2011
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?...

Similar Threads

  1. Epic vendor!!!
    By handyman in forum Community Chat
    Replies: 12
    Last Post: 04-26-2007, 02:13 AM
  2. unlimited limited supply items from vendors
    By PolishMaster1 in forum World of Warcraft Exploits
    Replies: 12
    Last Post: 02-12-2007, 07:21 PM
  3. LS recipe Vendors
    By Erlon in forum World of Warcraft Guides
    Replies: 5
    Last Post: 01-07-2007, 03:05 PM
  4. can u mail/ trade/ buy from vendor on trail accnt
    By xkisses in forum World of Warcraft General
    Replies: 1
    Last Post: 10-24-2006, 03:17 PM
  5. I think i can edit what one Vendor sells!
    By LiquidShizzles in forum World of Warcraft Exploits
    Replies: 17
    Last Post: 08-15-2006, 06:29 PM
All times are GMT -5. The time now is 07:28 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search