[ANTRIX][CUSTOM] GM Vendors 2.0

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Quote:

Originally Posted by Neorez

In Vendors 2.6 the vendor "Weapon", "Level 100+ this buged it is not possible to be bought the arms

experiencing the same problem. there seems to be a few vendors, though i haven't pinpointed which ones yet.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

the vendors.sql freezes when restore from dump? or just extremely slow around 40445???? please help me if u think i need help!?

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Quote:

Originally Posted by Coronia

the vendors.sql freezes when restore from dump? or just extremely slow around 40445???? please help me if u think i need help!?

it takes a really long time on 40445 because it is editting A LOT of tables doing A LOT of math. it is still working just takes a lot of time, as is stated on the download thread.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Quote:

Originally Posted by channel_49

1) Use the latest dbc.
2) Post the error it its hard to help you.

ok i tried executing custom shop 2.6 ( i got an error from vendors.sql too) and i got this

Quote:

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-14 20:29:31
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-14 20:31:17
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-14 20:38:24
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 10:03:48
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 10:18:33
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-15 10:20:41
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-15 11:28:46
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 08:44:20
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 08:44:23
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-16 08:45:52
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-16 08:46:18
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-16 08:46:28
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-16 08:47:11
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-16 09:05:02
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-16 09:11:59
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:12:51
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:13:12
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:13:34
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-16 09:22:40
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')
Error occured at:2007-07-16 09:24:04
Line no.:1
Error Code: 1146 - Table 'antrix2.items' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:24:09
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:24:10
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:26:24
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:26:47
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:26:50
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:27:27
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist
Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'
Error occured at:2007-07-16 09:27:53
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-16 09:34:36
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1
Error occured at:2007-07-16 09:38:05
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-16 09:45:09
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-17 18:20:49
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)
Error occured at:2007-07-17 18:21:38
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-07-17 18:28:57
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
UPDATE items set ItemExtendedCost=0
UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'
Error occured at:2007-07-17 18:44:14
Line no.:6
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 'UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'' at line 2
Query:
UPDATE items set ItemExtendedCost=0
UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'
Error occured at:2007-07-17 18:44:20
Line no.:6
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 'UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'' at line 2
Query:
UPDATE items SET buyprice = '100000' WHERE entry ='1132'
Error occured at:2007-07-18 17:28:49
Line no.:21790
Error Code: 1194 - Table 'items' is marked as crashed and should be repaired
Query:
UPDATE items SET buyprice = (sellprice*5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080') AND sellprice > '0'
Error occured at:2007-07-20 16:04:20
Line no.:5962
Error Code: 1194 - Table 'items' is marked as crashed and should be repaired

help? lol theres a smily halfway thru there and i dont know why

EDIT* ill post vendors.sql's error (i can't tell if they are different or not i think they're the same)

Quote:

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-14 20:29:31
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-14 20:31:17
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-14 20:38:24
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-07-15 10:03:48
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-15 10:18:33
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-15 10:20:41
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-15 11:28:46
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 08:44:20
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 08:44:23
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-16 08:45:52
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-16 08:46:18
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-16 08:46:28
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-16 08:47:11
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-16 09:05:02
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-16 09:11:59
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:12:51
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:13:12
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:13:34
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-16 09:22:40
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
DELETE FROM items WHERE entry IN ('29295', '33058', '33055', '32259', '30892', '32519', '30894', '30901', '30900', '30906', '30902', '31091', '32525', '32500', '30899', '32345', '32351', '32276', '32199', '32376', '30897', '30896', '30918', '32854', '33076', '32217', '30889', '32367', '30912', '30903', '30907', '32496', '30905', '32370', '32352', '32362', '30880', '32735', '30913', '30904', '30911', '32366', '30898', '32471', '32497', '30609', '32760', '33054', '32332', '30919', '32221')

Error occured at:2007-07-16 09:24:04
Line no.:1
Error Code: 1146 - Table 'antrix2.items' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:24:09
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:24:10
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:26:24
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:26:47
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:26:50
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:27:27
Line no.:1
Error Code: 1146 - Table 'antrix3.creature_names' doesn't exist

Query:
DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'

Error occured at:2007-07-16 09:27:53
Line no.:1
Error Code: 1146 - Table 'antrix2.creature_names' doesn't exist

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-16 09:34:36
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1

Error occured at:2007-07-16 09:38:05
Line no.:177
Error Code: 1050 - Table 'clientaddons' already exists

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-16 09:45:09
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)

Error occured at:2007-07-17 18:20:49
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

Query:
INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 0.55, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0)

Error occured at:2007-07-17 18:21:38
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)

Error occured at:2007-07-17 18:28:57
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

Query:
UPDATE items set ItemExtendedCost=0
UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'

Error occured at:2007-07-17 18:44:14
Line no.:6
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 'UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'' at line 2

Query:
UPDATE items set ItemExtendedCost=0
UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'

Error occured at:2007-07-17 18:44:20
Line no.:6
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 'UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%'' at line 2

Query:
UPDATE items SET buyprice = '100000' WHERE entry ='1132'

Error occured at:2007-07-18 17:28:49
Line no.:21790
Error Code: 1194 - Table 'items' is marked as crashed and should be repaired

Query:
UPDATE items SET buyprice = (sellprice*5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080') AND sellprice > '0'

Error occured at:2007-07-20 16:04:20
Line no.:5962
Error Code: 1194 - Table 'items' is marked as crashed and should be repaired

Query:
UPDATE items SET buyprice = '100000' WHERE entry ='1132'

Error occured at:2007-07-20 17:20:56
Line no.:21790
Error Code: 1194 - Table 'items' is marked as crashed and should be repaired

sorry for the massive post

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

empty out your database and start again in this order:

1. Terrabet-projectsilvermoon rev 7
2. vendors for rev 7
3. missing items for rev 7
4. custom shops 2.5(2.6 has bugs where vendors wont sell the items)

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

@deliberd: you dont have TerraNet rev7.

------------------

@thanhnguyen: last query of custom.shop.sql, change sellprice*5, currently buyprice is at standard wow rate, 5x its sell value.

------------------

@FishCakeFoley: you need the "currency" items to buy tier armor, spawn 50049 and see for yourself.

------------------

@100+ vendor bug: I didn't really test 2.6 lol, I'll get around to testing and fixing it when I'm free. Too busy doing other stuff unrelated to wow or DB development.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Version 2.61 released. The level 100+ vendor now works. If theres more vendors that doesn't work, report it here, but be sure it's not a bug caused by your own installation faults.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

can you post the fix you made so we dont have to re-run the ENTIRE script just for the one vendor? it takes quite a while to run and id like to avoid it. thanks! :juggle:

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

How long does this script usually take? It takes about 2 minutes for me to get up to ~ 280 / 304kb, but then it just.. freezes up my server! is there something really big here? or am i just coping an error?

Oh and BTW, will my vendors remain inthe same place after a server reset? or will i have to run some sort of script.. I know in some servers such as BurningWoW they are layed out nicely in all the main towns. Is it possible to do something like that autormatically everytime the server starts?

Re: [ANTRIX][CUSTOM] GM Vendors, based on AMVendors

Quote:

Originally Posted by channel_49

Give me ideas if you have more vendors that should be added, or any other suggestions you might have.

I've seen a "Currency" Vendor on some servers so you can buy the Tier Tokens, BG Tokens, Marks Of Honor, Thrallmar/Honor Hold Tokens, Holy Dust etc...

When people ask on here ask how do you buy the Tier stuff with no tokens and people say just .additem them, that's ok if you're a GM but what about the players on your server? Or even if you're play testing your own server with a non-GM account. You need a Currency Vendor.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

When i try to run the custom shop file it says:
1136-Column count doesn't match value count at row 1
what should i do?

Re: [ANTRIX][CUSTOM] GM Vendors, based on AMVendors

Quote:

Originally Posted by ApacheLQ

I've seen a "Currency" Vendor on some servers so you can buy the Tier Tokens, BG Tokens, Marks Of Honor, Thrallmar/Honor Hold Tokens, Holy Dust etc...

When people ask on here ask how do you buy the Tier stuff with no tokens and people say just .additem them, that's ok if you're a GM but what about the players on your server? Or even if you're play testing your own server with a non-GM account. You need a Currency Vendor.

The currency vendor they have is MADE BY ME, you obviously dont read the first post? 50049 is the currency vendor, and it has those exact items because I'm the one who made it...

And if you read post 201 I've mentioned it AGAIN, please READ BEFORE YOU POST.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Quote:

Originally Posted by AO27

When i try to run the custom shop file it says:
1136-Column count doesn't match value count at row 1
what should i do?

You need TerraNet rev7.

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

Quote:

Originally Posted by fourth

can you post the fix you made so we dont have to re-run the ENTIRE script just for the one vendor? it takes quite a while to run and id like to avoid it. thanks! :juggle:

This is the line you should remove if you dont want it to run for a very long time, its the last line in the entire query:

Code:

UPDATE items SET buyprice = (sellprice*5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080') AND sellprice > '0';

Re: [ANTRIX][CUSTOM] GM Vendors 2.0

hey channel me and lilnate22 from ac web r improving ur vendors - we make custom items and vendors for them