[ANTRIX][CUSTOM] GM Vendors 2.0

nice work,ty

Some can make a macro with the coordinates like:

.npc spawn 5000 x,y,z.
.npc spawn 5001 x,y,z.
.npc spawn 5002 x,y,z.
ect.

dat would be a whole bunch of macros lol. just put an npc on one spot then just move your character to the side dats how i do it and they come out into a straight road perfectly

Why would you need macros? Just make a sql query... Spawn one, then just change coords for the rest...

Please give me an example for that. :)

I'm new to MySQL and Antrix but I'm a really fast learner so only do one or two and I can do it myself. :)

wat is so hard. STAND in the spot you wanna put the npc

do .npc spawn (id) then you simply hit the left the right arrow key or A or D key to move left or or right then you do .npc spawn (id)

WTFOMFGBBQ!! you just learned something new

Since the many leechers dont wanna keep this thread alive, I have released another update. Have fun leechers, hehe.

thanks for getting the hard part done with!

I can't add the .sql file when i try to add it it says this

Code:

---

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-09 01:52:01
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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-09 01:52:58
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `auctions` (
 `auctionId` int(32) NOT NULL auto_increment,
 `auctionhouse` int(32) default NULL,
 `item` bigint(10) default NULL,
 `owner` bigint(10) default NULL,
 `buyout` int(32) default NULL,
 `time` int(32) default NULL,
 `bidder` bigint(10) default NULL,
 `bid` int(32) default NULL,
 `deposit` int(32) default NULL,
 PRIMARY KEY  (`auctionId`)
 ) ENGINE=MyISAM AUTO_INCREMENT=11384 DEFAULT CHARSET=latin1

Error occured at:2007-07-09 01:53:28
Line no.:42
Error Code: 1050 - Table 'auctions' already exists

Query:
CREATE TABLE `auctions` (
 `auctionId` int(32) NOT NULL auto_increment,
 `auctionhouse` int(32) default NULL,
 `item` bigint(10) default NULL,
 `owner` bigint(10) default NULL,
 `buyout` int(32) default NULL,
 `time` int(32) default NULL,
 `bidder` bigint(10) default NULL,
 `bid` int(32) default NULL,
 `deposit` int(32) default NULL,
 PRIMARY KEY  (`auctionId`)
 ) ENGINE=MyISAM AUTO_INCREMENT=11384 DEFAULT CHARSET=latin1

Error occured at:2007-07-09 01:53:51
Line no.:42
Error Code: 1050 - Table 'auctions' already exists

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-09 01:53:56
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `bids` (
 `bidder` bigint(10) NOT NULL default '0',
 `Id` int(32) NOT NULL default '0',
 `auctionhouse` int(16) NOT NULL default '0',
 `amt` int(32) NOT NULL default '0'
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-09 01:54:35
Line no.:52
Error Code: 1050 - Table 'bids' already exists

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-09 01:54:42
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `characters` (
 `guid` int(6) unsigned NOT NULL default '0',
 `acct` int(20) unsigned NOT NULL default '0',
 `name` varchar(21) NOT NULL,
 `race` smallint(3) unsigned NOT NULL,
 `class` smallint(3) unsigned NOT NULL,
 `gender` tinyint(1) unsigned NOT NULL,
 `level` int(3) unsigned NOT NULL,
 `xp` int(30) unsigned NOT NULL,
 `exploration_data` longtext NOT NULL,
 `skills` longtext NOT NULL,
 `watched_faction_index` bigint(40) unsigned NOT NULL,
 `selected_pvp_title` int(30) unsigned NOT NULL,
 `available_pvp_titles` int(30) unsigned NOT NULL,
 `gold` int(30) unsigned NOT NULL,
 `ammo_id` int(30) unsigned NOT NULL,
 `available_prof_points` int(30) unsigned NOT NULL,
 `available_talent_points` int(30) unsigned NOT NULL,
 `current_hp` int(30) unsigned NOT NULL,
 `current_power` int(30) unsigned NOT NULL,
 `pvprank` int(30) unsigned NOT NULL,
 `bytes` int(30) unsigned NOT NULL,
 `bytes2` int(30) unsigned NOT NULL,
 `player_flags` int(30) unsigned NOT NULL,
 `player_bytes` int(30) unsigned NOT NULL,
 `positionX` float NOT NULL default '0',
 `positionY` float NOT NULL default '0',
 `positionZ` float NOT NULL default '0',
 `orientation` float NOT NULL default '0',
 `mapId` int(8) unsigned NOT NULL default '0',
 `zoneId` int(8) unsigned NOT NULL default '0',
 `taximask` longtext NOT NULL,
 `banned` int(6) unsigned NOT NULL default '0',
 `bannedReason` varchar(255) default NULL,
 `timestamp` text,
 `online` int(11) default NULL,
 `bindpositionX` float NOT NULL default '0',
 `bindpositionY` float NOT NULL default '0',
 `bindpositionZ` float NOT NULL default '0',
 `bindmapId` int(8) unsigned NOT NULL default '0',
 `bindzoneId` int(8) unsigned NOT NULL default '0',
 `isResting` int(3) NOT NULL default '0',
 `restState` int(5) NOT NULL default '0',
 `restTime` int(5) NOT NULL default '0',
 `playedtime` text NOT NULL,
 `deathstate` int(5) NOT NULL default '0',
 `TalentResetTimes` int(5) NOT NULL default '0',
 `first_login` tinyint(1) NOT NULL default '0',
 `forced_rename_pending` int(30) NOT NULL,
 `publicNote` varchar(32) NOT NULL default '',
 `officerNote` varchar(32) NOT NULL default '',
 `guildid` int(10) unsigned NOT NULL default '0',
 `guildRank` int(10) unsigned NOT NULL default '0',
 `charterId` int(30) unsigned NOT NULL,
 `totalstableslots` int(10) unsigned NOT NULL default '0',
 `instance_id` int(10) NOT NULL,
 `entrypointmap` int(10) NOT NULL,
 `entrypointx` float NOT NULL,
 `entrypointy` float NOT NULL,
 `entrypointz` float NOT NULL,
 `entrypointo` float NOT NULL,
 `entrypointinstance` int(10) NOT NULL,
 `taxi_path` int(10) NOT NULL,
 `taxi_lastnode` int(10) NOT NULL,
 `taxi_mountid` int(10) NOT NULL,
 `transporter` int(10) NOT NULL,
 `transporter_xdiff` float NOT NULL,
 `transporter_ydiff` float NOT NULL,
 `transporter_zdiff` float NOT NULL,
 `spells` longtext NOT NULL,
 `deleted_spells` longtext NOT NULL,
 `reputation` longtext NOT NULL,
 `actions` longtext NOT NULL,
 `auras` longtext NOT NULL,
 `finished_quests` longtext NOT NULL,
 `lastDailyReset` int(30) unsigned NOT NULL,
 `killsToday` int(10) NOT NULL default '0',
 `killsYesterday` int(10) NOT NULL default '0',
 `killsLifeTime` int(10) default '0',
 `honorToday` int(10) NOT NULL default '0',
 `honorYesterday` int(10) NOT NULL default '0',
 `honorPoints` int(10) NOT NULL default '0',
 `difficulty` int(4) NOT NULL default '0',
 UNIQUE KEY `guid` (`guid`),
 KEY `acct` (`acct`),
 KEY `guildid` (`guildid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-09 01:55:37
Line no.:143
Error Code: 1050 - Table 'characters' already exists

Query:
CREATE TABLE `characters` (
 `guid` int(6) unsigned NOT NULL default '0',
 `acct` int(20) unsigned NOT NULL default '0',
 `name` varchar(21) NOT NULL,
 `race` smallint(3) unsigned NOT NULL,
 `class` smallint(3) unsigned NOT NULL,
 `gender` tinyint(1) unsigned NOT NULL,
 `level` int(3) unsigned NOT NULL,
 `xp` int(30) unsigned NOT NULL,
 `exploration_data` longtext NOT NULL,
 `skills` longtext NOT NULL,
 `watched_faction_index` bigint(40) unsigned NOT NULL,
 `selected_pvp_title` int(30) unsigned NOT NULL,
 `available_pvp_titles` int(30) unsigned NOT NULL,
 `gold` int(30) unsigned NOT NULL,
 `ammo_id` int(30) unsigned NOT NULL,
 `available_prof_points` int(30) unsigned NOT NULL,
 `available_talent_points` int(30) unsigned NOT NULL,
 `current_hp` int(30) unsigned NOT NULL,
 `current_power` int(30) unsigned NOT NULL,
 `pvprank` int(30) unsigned NOT NULL,
 `bytes` int(30) unsigned NOT NULL,
 `bytes2` int(30) unsigned NOT NULL,
 `player_flags` int(30) unsigned NOT NULL,
 `player_bytes` int(30) unsigned NOT NULL,
 `positionX` float NOT NULL default '0',
 `positionY` float NOT NULL default '0',
 `positionZ` float NOT NULL default '0',
 `orientation` float NOT NULL default '0',
 `mapId` int(8) unsigned NOT NULL default '0',
 `zoneId` int(8) unsigned NOT NULL default '0',
 `taximask` longtext NOT NULL,
 `banned` int(6) unsigned NOT NULL default '0',
 `bannedReason` varchar(255) default NULL,
 `timestamp` text,
 `online` int(11) default NULL,
 `bindpositionX` float NOT NULL default '0',
 `bindpositionY` float NOT NULL default '0',
 `bindpositionZ` float NOT NULL default '0',
 `bindmapId` int(8) unsigned NOT NULL default '0',
 `bindzoneId` int(8) unsigned NOT NULL default '0',
 `isResting` int(3) NOT NULL default '0',
 `restState` int(5) NOT NULL default '0',
 `restTime` int(5) NOT NULL default '0',
 `playedtime` text NOT NULL,
 `deathstate` int(5) NOT NULL default '0',
 `TalentResetTimes` int(5) NOT NULL default '0',
 `first_login` tinyint(1) NOT NULL default '0',
 `forced_rename_pending` int(30) NOT NULL,
 `publicNote` varchar(32) NOT NULL default '',
 `officerNote` varchar(32) NOT NULL default '',
 `guildid` int(10) unsigned NOT NULL default '0',
 `guildRank` int(10) unsigned NOT NULL default '0',
 `charterId` int(30) unsigned NOT NULL,
 `totalstableslots` int(10) unsigned NOT NULL default '0',
 `instance_id` int(10) NOT NULL,
 `entrypointmap` int(10) NOT NULL,
 `entrypointx` float NOT NULL,
 `entrypointy` float NOT NULL,
 `entrypointz` float NOT NULL,
 `entrypointo` float NOT NULL,
 `entrypointinstance` int(10) NOT NULL,
 `taxi_path` int(10) NOT NULL,
 `taxi_lastnode` int(10) NOT NULL,
 `taxi_mountid` int(10) NOT NULL,
 `transporter` int(10) NOT NULL,
 `transporter_xdiff` float NOT NULL,
 `transporter_ydiff` float NOT NULL,
 `transporter_zdiff` float NOT NULL,
 `spells` longtext NOT NULL,
 `deleted_spells` longtext NOT NULL,
 `reputation` longtext NOT NULL,
 `actions` longtext NOT NULL,
 `auras` longtext NOT NULL,
 `finished_quests` longtext NOT NULL,
 `lastDailyReset` int(30) unsigned NOT NULL,
 `killsToday` int(10) NOT NULL default '0',
 `killsYesterday` int(10) NOT NULL default '0',
 `killsLifeTime` int(10) default '0',
 `honorToday` int(10) NOT NULL default '0',
 `honorYesterday` int(10) NOT NULL default '0',
 `honorPoints` int(10) NOT NULL default '0',
 `difficulty` int(4) NOT NULL default '0',
 UNIQUE KEY `guid` (`guid`),
 KEY `acct` (`acct`),
 KEY `guildid` (`guildid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-09 01:57:45
Line no.:143
Error Code: 1050 - Table 'characters' already exists

Query:
Unable to issue `use` statement

Error occured at:2007-07-09 06:23:31
Line no.:0
Error Code: 1049 - Unknown database 'antrix2'

Query:
Unable to issue `use` statement

Error occured at:2007-07-09 06:24:11
Line no.:0
Error Code: 1049 - Unknown database 'antrix2'

Query:
Unable to issue `use` statement

Error occured at:2007-07-09 06:24:33
Line no.:0
Error Code: 1049 - Unknown database 'antrix2'

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-09 14:31:14
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-09 14:31:53
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-09 14:33:03
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-09 14:52:42
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-09 14:53:26
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

---

lol, you dont even have a creature_names table. And why are there accounts in the query...

I got SQLy where to do it there?

Ahh they are all Sha'tar whyyyyy

Notice the last line changes faction lol.

Last line of what?
Also the Level 100+ Weapon vendor makes my server crash =\

Please tell a little guide about what to do when you got SQLyog?

Your suppose to get the items.epics or else it crashes... read the requirements.

Help i execute the custom.shop.2.5 and gets this error

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-10 00:19:00
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

And remember to apply this new fix to creature_proto table added in the newer antrix revisions.


Code:
ALTER TABLE `creature_proto` ADD COLUMN `money` INT (30) DEFAULT '0' NOT NULL AFTER `boss`;

i added the items and it still crashes =/

I am having a problem spawning the NPC's. i have updated my rev6 database with the 3 SQL files from the front page but when i try to spawn an NPc it says "Spawned alliance spirit healer". when ever i try to spawn any NPC thats what it says. Any ideas where i went wrong?

hi guys have any idea about error i get this error while last 6 kb


[PHP]Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-07-08 18:39:01
Line no.:9
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-07-08 18:39:13
Line no.:9
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-07-08 18:49:38
Line no.:9
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-07-08 18:49:52
Line no.:9
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

Error occured at:2007-07-09 00:28:35
Line no.:8
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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

Query:
INSERT INTO `creatureloo

Channel_49 where i have to apply that code?

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-10 10:26:42
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

I get that erro. how do i fix it?

Thank you very much for this,but I have 1 question:
How can I change the vendor's display ID in antrix?Which table?Creature_spawns ???I didnt found their ID's...
Or does exist some program for ANTRIX to edit tables like in QUICE for MaNGOS???

no any reply ?for my problem i have creature_names to

maby a noob question but..
how do i insert it? :P

pm me plx
Greetz Mike

Quote:

---

Originally Posted by yomie

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-10 10:26:42
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1

I get that erro. how do i fix it?

---

You need the update code in the first post, I already answered this so many times.

Quote:

---

Originally Posted by s3thapl

Thank you very much for this,but I have 1 question:
How can I change the vendor's display ID in antrix?Which table?Creature_spawns ???I didnt found their ID's...
Or does exist some program for ANTRIX to edit tables like in QUICE for MaNGOS???

---

Try searching this thread, I already posted something about how to do this.

Quote:

---

Originally Posted by chakkale

no any reply ?for my problem i have creature_names to

---

Your database is a total mess, go get your database straight before you start adding my queries into your own query files. Like I said, you need terranet rev6 before you start installing my vendors.

TerraNet DB rev6 Full i have it i already install

Quote:

---

Quote:
Originally Posted by chakkale http://forum.ragezone.com/images/exp...s/viewpost.gif
no any reply ?for my problem i have creature_names to

Your database is a total mess, go get your database straight before you start adding my queries into your own query files. Like I said, you need terranet rev6 before you start installing my vendors

---

my db workin normally

Thanks for the updates, but I'm having some trouble. I ran the SQL queries, restarted my server, deleted my cache, but I'm still getting Invalid entry id when I do .npc spawn 50000

Quote:

---

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-07-08 18:39:01
Line no.:9
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

---

Then why is this in your error log? This has nothing to do with my query.

Code:

---

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-10 07:54:42
Line no.:81
Error Code: 1136 - Column count doesn't match value count at row 1


---

This problem is easily resolved if you just add the money column in creature_proto, which I already said to do in the release post...

Quote:

---

Originally Posted by stegmite

Thanks for the updates, but I'm having some trouble. I ran the SQL queries, restarted my server, deleted my cache, but I'm still getting Invalid entry id when I do .npc spawn 50000

---

For testing run this:

Code:

---

DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50080';
DELETE FROM creature_proto WHERE entry BETWEEN '50000' AND '50080';
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 17072, 1, 1, 1, 0);
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);

---

Then restart server, delete cache and try spawning again, if it still doesnt work, it must be core based problem, or just that your query was never completed, and your problem is simply the missing columns problem.

Can we get some instructions for adding the 3 files using SQLyog? I can execute the veteran and epics files, but the custom shop one gets an error at the last 6kb of the file.
And where do I add the 2 query code bits? Both in creature_proto?

I'm getting the same problem as colt. Here is the erro log:

Code:

---

Query:
DROP TABLE IF EXISTS `ai_agents`
Error occured at:2007-07-09 01:49:04
Line no.:22
Error Code: 1142 - DROP command denied to user '-----'@'localhost' for table 'ai_agents'
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-11 00:49:01
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-11 00:49:35
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-11 01:12:23
Line no.:81
Error Code: 1265 - Data truncated for column 'bounding_radius' 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-11 01:17:37
Line no.:81
Error Code: 1265 - Data truncated for column 'bounding_radius' 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-11 01:43:17
Line no.:81
Error Code: 1265 - Data truncated for column 'bounding_radius' at row 1

---

I HAVE done the fix and I have done the test as well. I get invalid ID. Haven't retested the inputting the money column, but yeah.

If you get invalid ID, it means that the creature_proto was never inputted into the database, because the query stopped when it errored.

Quote:

---

"Error Code: 1136 - Column count doesn't match value count at row 1"

---

The only cause of this problem I can think of is the money column in the creature_proto table, which is a latest addition by antrix core. And should be fixed by this code if you have run it correctly:

Code:

---

ALTER TABLE `creature_proto` ADD COLUMN `money` INT (30) DEFAULT '0' NOT NULL AFTER `boss`;

---

If it wont work, run a test like this (this is different from the one I posted earlier), and if this test works, it means that you dont have the money column in your creature_proto:

Code:

---

DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50080';
DELETE FROM creature_proto WHERE entry BETWEEN '50000' AND '50080';
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 17072, 1, 1, 1, 0);
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);

---

And if anyone would be kind enough to write a guide for SQLyog, that would be good, since I dont use SQLyog and dont intend to download it.

Got SQLyog to input the custom vendors. I had made the mistake of putting the money column in front of the id column. So I deleted it and put it at the bottom, where it should've been.

Now the dump works.

Thanks for the help 49, even though yah said it a million times. :biggrin:

Yea, that problem with the columns is usually fixed with that query, but maybe SQLyog didnt run it properly.

Man i have a question: Why some Gladiator and all the Veteran items are with that Question Mark (?) because i`ve installed all the files item.epics , item.veterans, and custom.shop.2.5 i`m using antrix rev 800 ? what might be the problem?

Did you delete cache folder?

Yes i`ve deleted it from my WOW Game directory...

Could you please explain how to put ALTER TABLE `creature_proto` ADD COLUMN `money` INT (30) DEFAULT '0' NOT NULL AFTER `boss`; In creature_proto with navicat? I can't seem to find it.

Quote:

---

Originally Posted by Mugen-sama

Could you please explain how to put ALTER TABLE `creature_proto` ADD COLUMN `money` INT (30) DEFAULT '0' NOT NULL AFTER `boss`; In creature_proto with navicat? I can't seem to find it.

---

I'm pretty sure you put it in a SQL file, then execute it as a batchfile. The vendors should work then. You should ask somebody more experienced with it though, because i'm not positive.

Its a query, so either run it as a query from your sql manager or just put it in a .sql file and run it as a batch file.

Quote:

---

Originally Posted by pZq

Yes i`ve deleted it from my WOW Game directory...

---

Do you have wow 2.1.3?

Thanks! The vendors works, but when I went on every of my NPC were gone, any clue? When i exequted these files..
No mobs either :/ I'm new on these stuff, just opened up my own server so :)

Also wondering what terranet is for, appriciate answer (:

Quote:

---

Originally Posted by channel_49

Do you have wow 2.1.3?

---

Oh yes i think this was the problem :D i will add the 2.1.3 patch. thx mate i will tell u if the problem persists

Respect,

pZq

Thanks a lot, only problem I had whilst adding this is that I accidentally selected the wrong sql file at first haha.

Really nice stuff, helps with professions :D, which brings me onto a problem I have which is probably not connected to the sql dumps - I've learnt almost all of the leather making recipes, however now my list in the leatherworking profession window is really screwed up - nothing is in order, when I buy mats needed for a recipe it doesn't update what I have on the leatherworking profession window... Anyone know how to sort it?

its working with me but when i want to buy something i cant he say cannot find the item wat can i do???

Perhaps you dont have the needed item or gold?

yes i have both gold and item he cant find the item he say i did all 3 the steps

Hmm... which item are you trying to buy.

Sorry i see the problem the skil riding isn't go higer than 150 how can i get it higher??

to chrisie, enter the command ".learnsk 762 350 350" to raise your riding to 350.

and i also have a problem. after i ran all these querys, my players on my server and i, upon logout, lose all gear and items.

can you shine any light?

ok i got a quistion:
i have no prob with adding the vendors and stuff but i made some marcos so i can spawn them all at once then i use the command .npc come to put them on the place i want
but everytime i restart server they go back to the place i spawned them the first time

now: how do i make them stay ?
i cant seem to find any command or do i need to change the cords in the DB ? :)

thx in advance

( i know if i spawn them one by one i know they stay there but i wanne spawn them all at once :P)

(im lazy)

dont understand this plz explate more step by step plz.
am use SQLyog. Wat and were i excute it to.

When I talk to the vendor it will show a bunch of item pics with no text and then it freezes me into the server and I have to End Process my WoW.exe. And then when I reload it that vendor works. This happens the first time I talk to every vendor. After that it works fine.

Quote:

---

Originally Posted by Chris-h11

When I talk to the vendor it will show a bunch of item pics with no text and then it freezes me into the server and I have to End Process my WoW.exe. And then when I reload it that vendor works. This happens the first time I talk to every vendor. After that it works fine.

---

This has something to do with your computer and client, when it loads the items into cache it takes some memory, and your computer probably freezes while doing this. Check your specs to see if they are actually high enough for wow.

2.51 has no update to the shops itself, but there are new tweaks needed for rev7 and the requirement list has been cleaned up as well as updated with the new info.

Uhh... I executed The TNPSRev7 and the fixes, and when I log in, there are no npc's whatsoever! No creatures or just normal npc's just me and all the game objects.

Hmm, I spawned the Cooking vendor and when I try to talk to the vendor, my game crashes. Any way to fix this?

this could be useful i need terra7 though im dling 8 i think will it work with it ?

Hi,
I can't execute this file..i get an error like this :

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

Is it because im not using terranetdb 7 ?
I tried to use TerraNetDB 6 before. But it didnt have any mobs/npcs in it so i downloaded a repack instead and its running perfectly..
But now when i saw this great work i went even more happy, because im sick of ".lookupitem ****" ".additem <id>" all the time..
Is there any way i can get this working without TerraNetDB 7 ?
Please help me!

btw awesome work!Keep it up!

Yeah is this compatible with any other database?

how do i save where they are when i shut the server down?

As far as I know, if they didnt steal the items database from terranet, then theres no way they have the same number of items TNDB has. And since these are vendors, items are an important aspect I'd say.

Quote:

---

Originally Posted by skalman555

Hi,
I can't execute this file..i get an error like this :

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

Is it because im not using terranetdb 7 ?
I tried to use TerraNetDB 6 before. But it didnt have any mobs/npcs in it so i downloaded a repack instead and its running perfectly..
But now when i saw this great work i went even more happy, because im sick of ".lookupitem ****" ".additem <id>" all the time..
Is there any way i can get this working without TerraNetDB 7 ?
Please help me!

btw awesome work!Keep it up!

---

Just use rev7, it has the newest money columns which is needed.

Quote:

---

Originally Posted by Fundoctor

how do i save where they are when i shut the server down?

---

It should save automatically, if your server is configurated correctly.

Just a suggestion to add to the next revision of the "Currency" vendor:

Thottbot World of Warcraft: Arcane Rune - Arcane Rune (Scryer Currency)
Thottbot World of Warcraft: Holy Dust - Holy Dust (Aldor Currency)

The vendors work great, however the items they sell dont. I get "Item not found". I'm guessing this is becuase whenever I try to execute the rev7 missing items to my antrix database I get the error below before it finishes.

Quote:

---

There was an error while executing a query.
The query and the error message has been logged at:
C:\Program Files\SQLyog Community\sqlyog.err.
Please click on "Open Error File..." to open the error file.

---

I admit to being a antrix noob so its possiable I could be doing incorrectly. I tried a fresh install of everything so I dont know what to do next.
Thanks in advance

You have to actually click open to open the error file...

Quote:

---

Originally Posted by channel_49

Code:

---

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

---

---

I find that this code does not affect anything in the db, i get, "affected 0 rows"
This might be tied to the problem in which i can only buy from Tier 1-3 vendors with gold, the rest require tokens.

They're suppose to require tokens, go look on wowhead.

And the tokens are in the currency vendor.

Quote:

---

Originally Posted by channel_49

You have to actually click open to open the error file...

---

Yah I know.... The error is alot a text and was hoping you knew the prob with-out having to read trough it all.

Quote:

---

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-13 20:04:59
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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-13 20:08:19
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
antrixaccounts


Error occured at:2007-07-13 20:40:06
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 'antrixaccounts' at line 1

Query:
antrixaccounts


Error occured at:2007-07-13 21:52:59
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 'antrixaccounts' at line 1

Query:
CREATE TABLE `npc_monstersay` (
`entry` int(11) NOT NULL,
`event` int(11) NOT NULL,
`chance` float NOT NULL,
`language` int(11) NOT NULL,
`type` int(11) NOT NULL,
`monstername` longtext,
`text0` longtext,
`text1` longtext,
`text2` longtext,
`text3` longtext,
`text4` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-14 19:36:44
Line no.:13
Error Code: 1050 - Table 'npc_monstersay' already exists

Query:
CREATE TABLE `worldmap_info` (
`mapid` int(10) NOT NULL default '0',
`screenid` int(10) default '0',
`type` int(10) default '0',
`maxplayers` int(10) default '0',
`minlevel` int(11) unsigned zerofill default '00000000001',
`repopx` float default '0',
`repopy` float default '0',
`repopz` float default '0',
`repopmapid` int(5) unsigned zerofill default '00000',
`area_name` varchar(100) default '0',
`flags` int(11) unsigned NOT NULL default '0',
`cooldown` int(15) NOT NULL default '0',
`lvl_mod_a` int(11) NOT NULL default '0',
PRIMARY KEY (`mapid`)
) TYPE=MyISAM

Error occured at:2007-07-14 19:36:57
Line no.:17
Error Code: 1050 - Table 'worldmap_info' already exists

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-15 06:32:07
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-15 06:32:14
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-15 06:32:17
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

Query:
CREATE TABLE `characters` (
`guid` int(11) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`banReason` varchar(50) NOT NULL,
`timestamp` text NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(1) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` longtext NOT NULL,
`deathstate` int(2) NOT NULL default '0',
`TalentResetTimes` int(3) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) unsigned NOT NULL default '0',
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL default '0',
`entrypointmap` int(4) NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) NOT NULL default '0',
`taxi_path` int(10) NOT NULL default '0',
`taxi_lastnode` int(10) NOT NULL default '0',
`taxi_mountid` int(10) NOT NULL default '0',
`transporter` int(10) NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-15 16:04:27
Line no.:269
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 'flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells`' at line 68

Query:
CREATE TABLE `characters` (
`guid` int(11) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`banReason` varchar(50) NOT NULL,
`timestamp` text NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(1) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` longtext NOT NULL,
`deathstate` int(2) NOT NULL default '0',
`TalentResetTimes` int(3) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) unsigned NOT NULL default '0',
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL default '0',
`entrypointmap` int(4) NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) NOT NULL default '0',
`taxi_path` int(10) NOT NULL default '0',
`taxi_lastnode` int(10) NOT NULL default '0',
`taxi_mountid` int(10) NOT NULL default '0',
`transporter` int(10) NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-07-15 16:51:39
Line no.:269
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 'flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells`' at line 68

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 16:56:51
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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 16:56:56
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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 16:57:36
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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 16:58:04
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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 16:58:39
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

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 16:58:54
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
Unable to establish connection

Error occured at:2007-07-15 17:26:19
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)

Query:
Unable to establish connection

Error occured at:2007-07-15 17:26:29
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)

Query:
Unable to establish connection

Error occured at:2007-07-15 17:26:37
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)

Query:
Unable to establish connection

Error occured at:2007-07-15 17:27:41
Line no.:0
Error Code: 1045 - Access denied for user 'root'@'localhost' (using password: NO)

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-15 18:32:11
Line no.:1
Error Code: 1146 - Table 'lll.items' doesn't exist

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-15 18:32:58
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-15 18:37:27
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

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-15 18:54:40
Line no.:1
Error Code: 1146 - Table 'lll.items' doesn't exist

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-15 18:55:26
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-15 18:55:39
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-15 18:56:19
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

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-15 19:00:20
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist

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-15 19:07:40
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

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-15 19:07:52
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist

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-15 19:07:58
Line no.:1
Error Code: 1146 - Table 'wep.items' doesn't exist

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-15 19:19:03
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-16 06:40:59
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-16 06:41:29
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 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-16 10:26:31
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1

---

i will have error whyle step 3


[Err] 1046 - No database selected [Err] DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'; [Msg] Finished - Unsuccessfully --------------------------------------------------

Quote:

---

Originally Posted by olenjan

i will have error whyle step 3


[Err] 1046 - No database selected [Err] DELETE FROM creature_names WHERE entry BETWEEN '50000' AND '50085'; [Msg] Finished - Unsuccessfully --------------------------------------------------

---

You dont have creature tables? Mangos perhaps?

Quote:

---

Originally Posted by vr4spd

Yah I know.... The error is alot a text and was hoping you knew the prob with-out having to read trough it all.

---

First of all, it says you dont have items table, second it says that theres a duplicate entry when trying to insert into items while theres no items table. I suggest a clean install of TNDB rev7, cuz your tables seems mighty messed up.

i have a very clean install of rev7, but i have no vendors table ??? pleasw can anyone help me

do i just CREATE a new table called vendors ???

Ask someone to extract you one, my own vendor tables are for rev8 and not released yet. So cant give you mine.

Quote:

---

Originally Posted by channel_49

First of all, it says you dont have items table, second it says that theres a duplicate entry when trying to insert into items while theres no items table. I suggest a clean install of TNDB rev7, cuz your tables seems mighty messed up.

---

Thanks for the timely response. Clean install of everything but im still getting the duplicate item entry error.

Something must be wrong in your db or its configuration if you cant even execute an item query to it.

Quote:

---

Originally Posted by channel_49

Something must be wrong in your db or its configuration if you cant even execute an item query to it.

---

Thanks for the help and patience channel. I'm not really sure what the root of the problem was, but I deleted the missing items as well as the DB re-downloaded and re-installed fixed the prob. Im guess one of the files was currupt somewhere....


-Nate

i have one Question: Is the Vendors Selling Weapons that Require's lvl 100+ Or is it the lvl of the Weapon?

Quote:

---

Originally Posted by mygland

i have one Question: Is the Vendors Selling Weapons that Require's lvl 100+ Or is it the lvl of the Weapon?

---

I think you know the answer to that.

tindin's Player Vendors can be found here: TerraNet WoW Forums -> [custom] vendors for players

Descriptions are inside.

Version 2.6 has been released.

i get a few errors trying to do this

i execute everything but when i execute vendors.sql i get an error report half way through (ill have to post that another time)

when i open antrix it loads the DBC files and 2 files say this:

invalid format in creature_proto (35/36)
invalid format in quests (94/95)

and then a window pops up saying:

antrix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

the last error used to never happen before but it does now for some reason

any idea on how to fix it?

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

This may seem like a strange request but is it possible to limit who the vendors sell to by account gm flag? This would be useful or maybe make an instace where only certain people can enter?

Try Spawning them a place only GM's got acces to, like GM island.

i have an error in row 1
and i dont know about this

Dude vendors are peferct but we have some problem , we spawn em all and some vendors doesnt work! cant buy items , we delete Cache but the same, and i saw that when i try to sell anythin in this bugged vendor one of thoose is +100 Wep. Vendor says " This merchant doesnt like you " :eek6: what to do?! LOL :) Vendor dont like us ..

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

noob question:

my money drop rate is 20x, so is there a way to increase the buy price of all the item in these vendor 20 times??

How? to up price for items? :juggle:

Quote:

---

Originally Posted by themastakilla

How? to up price for items? :juggle:

---

yea how would up price the items....

What does it mean if i get-

The item was not found.

in some of the tier vendors?

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.

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

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.

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

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)