Version 3.0a:
Always forget that damn table name in spawn query, added.
Added in custom_shop_display.sql, change your own displayids.
Printable View
Version 3.0a:
Always forget that damn table name in spawn query, added.
Added in custom_shop_display.sql, change your own displayids.
Thanks for the update :)
Your welcome.
Ok, i'm encountering some large issues. For starters i followed your directions, i got ascent 1141, and i updated my DB with the queries on the first page. I start up Logonserver.exe, it works just fine, but ascent.exe will pop up for a sec and then dissapear and create a crash dumps file. So that's not working. Then i tried my older version, ascent 1036. Everything started fine, but when I logged in and created a new char, there are humongous npcs everywhere and when i modify scale 1.0 they dont shrink. Then i went back and looked at Ascent.exe and saw written in yellow "Invalid format in creature_proto <36/40> loading anyway because we have enough data:ImageShack - Hosting :: untitled3sr2.png. So then i start over. I don't update my DB this time. Then when I try and add custom shop it doesnt work, i get an error file. Then I figure out that the custom vendors will only work when I update my DB, but that makes all the NPCs huge so i'm stuck.
Also, in the Display ID query, you have Creature_proto and there is no column for display ID in proto so i think you meant names. If anyone knows how to fix this their help is appreciated.
Yes, update your tables with the things I put in the first post, then it will work.
As i said, when i do that it makes all npcs huge and their scale can not be modified down, one of those queries screws up proto.
No, use ascent 1132+ and the problems will be gone.
Hi Evansg
Just to expand on what Channel is saying
I
Large npcs are caused by having extra columns while the core doesn't support them, so updating the core after updating the tables should work.
...oh forgot to also say, cheers for all the hard work Channel ^_^
:) cool
FYI, the display ID has nothing to do with the faction, as long as you just change the display ID, both races will be able to use them. I got sick of the lame ass ones that come with it so I changed mine to horde, alliance and neutral npc's as well as bosses. works fine.
You tried emptying your cache folder?
can someone tell me the query for updating all items buyprice in a shop to 100g ... as the tier vendors don't have any prices.
I'm geting an error while importing any sql file from custon_shop... here it is :
Code: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-08-18 18:43:16
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` lo' 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-08-18 18:44:09
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` lo' 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-08-18 18:44:58
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` lo' 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-08-18 18:45:01
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` lo' 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-08-18 19:00:54
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` lo' at line 68
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-08-18 19:01:56
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-08-18 19:02:21
Line no.:17
Error Code: 1050 - Table 'worldmap_info' 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-08-18 19:03:12
Line no.:17
Error Code: 1050 - Table 'worldmap_info' 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-08-18 19:03:37
Line no.:17
Error Code: 1050 - Table 'worldmap_info' already exists
Query:
DROP TABLE
LL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
oat NOT NULL default '0',
`text0_0` longtext NOT NULL,
`text0_1` longtext NOT NULL,
,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20
`playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25
0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2
0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14
477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216
36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180),
fault '0',
`itemtext` int(10) unsigned NOT NULL default '0',
ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove
Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga
e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin
0',
`RequiredRaces` int(11) unsigned NOT NULL
nkill` ENABLE KEYS */
Error occured at:2007-08-18 19:03:51
Line no.:149206
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 'int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scar' at line 3
Query:
able structure for table `creature_names`
DROP TABLE IF EXISTS `creature_names`
Error occured at:2007-08-18 19:05:57
Line no.:382
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 'able structure for table `creature_names`
DROP TABLE IF EXISTS `creature_names`' at line 1
Query:
DROP TABLE
LL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
oat NOT NULL default '0',
`text0_0` longtext NOT NULL,
`text0_1` longtext NOT NULL,
,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20
`playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25
0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2
0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14
477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216
36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180),
fault '0',
`itemtext` int(10) unsigned NOT NULL default '0',
ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove
Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga
e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin
0',
`RequiredRaces` int(11) unsigned NOT NULL
nkill` ENABLE KEYS */
Error occured at:2007-08-18 19:06:30
Line no.:149206
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 'int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scar' at line 3
Query:
uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_spawns`
--
DROP TABLE
-- Table structure for table `gameobject_spawns`
--
DROP TABLE IF EXISTS `gameobject_spawns`;
CREATE TABLE `gameobject_spawns` (
`ID` int(30) unsigned NOT NULL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
255) NOT NULL default '',
`displayid` int(70) unsigned NOT NULL default '0',
`quality` int(30) NOT NULL default '0',
`flags` int(30) NOT NULL default '0',
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
ble structure for table `npc_text`
DROP TABLE IF EXISTS `npc_text`
Error occured at:2007-08-18 19:11:22
Line no.:51145
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 'uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1
Query:
uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_spawns`
--
DROP TABLE
-- Table structure for table `gameobject_spawns`
--
DROP TABLE IF EXISTS `gameobject_spawns`;
CREATE TABLE `gameobject_spawns` (
`ID` int(30) unsigned NOT NULL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
255) NOT NULL default '',
`displayid` int(70) unsigned NOT NULL default '0',
`quality` int(30) NOT NULL default '0',
`flags` int(30) NOT NULL default '0',
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
ble structure for table `npc_text`
DROP TABLE IF EXISTS `npc_text`
Error occured at:2007-08-18 19:11:32
Line no.:51145
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 'uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1
Query:
LOCK TABLES `characters` WRITE
Error occured at:2007-08-19 12:08:20
Line no.:175
Error Code: 1146 - Table 'ascent.characters' doesn't exist
Query:
CREATE TABLE `command_overrides` (
`command_name` varchar(100) NOT NULL,
`access_level` varchar(10) NOT NULL,
PRIMARY KEY (`command_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-08-19 12:27:46
Line no.:5
Error Code: 1050 - Table 'command_overrides' already exists
Query:
uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */;
/*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `creature_spawns`
--
DROP TABLE
-- Table structure for table `gameobject_spawns`
--
DROP TABLE IF EXISTS `gameobject_spawns`;
CREATE TABLE `gameobject_spawns` (
`ID` int(30) unsigned NOT NULL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
255) NOT NULL default '',
`displayid` int(70) unsigned NOT NULL default '0',
`quality` int(30) NOT NULL default '0',
`flags` int(30) NOT NULL default '0',
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
ble structure for table `npc_text`
DROP TABLE IF EXISTS `npc_text`
Error occured at:2007-08-19 12:28:11
Line no.:51145
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 'uest_starter` WRITE;
/*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1
Query:
LOCK TABLES `characters` WRITE
Error occured at:2007-08-19 12:28:48
Line no.:175
Error Code: 1146 - Table 'tester.characters' doesn't exist
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-08-19 12:29:18
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` lo' at line 68
Query:
CREATE TABLE `command_overrides` (
`command_name` varchar(100) NOT NULL,
`access_level` varchar(10) NOT NULL,
PRIMARY KEY (`command_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-08-19 12:29:56
Line no.:5
Error Code: 1050 - Table 'command_overrides' already exists
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-08-19 12:30:02
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-08-19 12:30:24
Line no.:17
Error Code: 1050 - Table 'worldmap_info' already exists
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-08-19 12:50:05
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` lo' 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-08-19 12:50:25
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` lo' at line 68
Query:
DROP TABLE
LL,
`Entry` int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8
,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4.
523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5
`buyprice` int(30) NOT NULL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
oat NOT NULL default '0',
`text0_0` longtext NOT NULL,
`text0_1` longtext NOT NULL,
,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20
`playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25
0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2
0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14
477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216
36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180),
fault '0',
`itemtext` int(10) unsigned NOT NULL default '0',
ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove
Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga
e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin
0',
`RequiredRaces` int(11) unsigned NOT NULL
nkill` ENABLE KEYS */
Error occured at:2007-08-19 12:51:17
Line no.:149206
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 'int(10) unsigned NOT NULL default '0',
`Map` int
986,4.0817,1377,0,1,3,'The Scar' at line 3
Query:
r table `creature_spawns`
DROP TABLE
gned NOT NULL default '0',
`Map` int
Scarab Wall'),(94,8936.56,-7439.9,8
(215,3032.44,3594.28,145.806,4.
Waste'),(333,3216.28,2992.5
LL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
`text0_0` longtext NOT NULL,
`text0_1` longtext NOT NULL,
5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20
LUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25
38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2
,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14
9,7266),(39,7267),(39,7355),(39,8386),(39,216
8),(36,227),(36,7340),(36,203),(41,1180),
t(10) unsigned NOT NULL default '0',
Orchard',3),(242,'Brightwood Grove
h Gate Pass',1),(808,'North Ga
(2246,'Frostfire Hot Sprin
11) unsigned NOT NULL
OCK TABLES;
--
LL,1),(30213,NU
),(10947,NU
22,NULL
ULL
4,NULL,NULL,1),(20355,NULL,NULL,1),(20411,NULL,NULL,1),(20412,NULL,NULL,1),(20413,NULL,NULL,1),(20414,NULL,NULL,1),(20425,NULL,NULL,1),(20467,NULL,NULL,1),(20961,NULL,NULL,1),(20962,NULL,NULL,1),(20963,NULL,NULL,1),(20964,NULL,NULL,1),(20965,NULL,NULL,1),(20966,NULL,NULL,1),(20967,NULL,NULL,1),(20968,NULL,NULL,1),(21183,NULL,NULL,1),(21889,NULL,NULL,1),(23590,NULL,NULL,1),(24234,NULL,NULL,1),(25061,NULL,NULL,1),(25745,NULL,NULL,1),(25751,NULL,NULL,1),(25752,NULL,NULL,1),(25753,NULL,NULL,1),(25757,NULL,NULL,1),(25758,NULL,NULL,1),(25759,NULL,NULL,1),(25760,NULL,NULL,1),(25761,NULL,NULL,1),(25762,NULL,NULL,1),(25942,NULL,NULL,1),(25943,NULL,NULL,1),(25944,NULL,NULL,1),(25945,NULL,NULL,1),(27731,NULL,NULL,1),(133,NULL,NULL,1),(143,NULL,NULL,1),(145,NULL,NULL,1),(3140,NULL,NULL,1),(8400,NULL,NULL,1),(8401,NULL,NULL,1),(8402,NULL,NULL,1),(9053,NULL,NULL,1),(9487,NULL,NULL,1),(9488,NULL,NULL,1),(10148,NULL,NULL,1),(10149,NULL,NULL,1),(10150,NULL,NULL,1),(10151,NULL,NULL,1),(10578,NULL,NULL,1),(11839,NULL,NULL,1),(11921,NULL,NULL,1),(11985,NULL,NULL,1),(11988,NULL,NULL,1),(11989,NULL,NULL,1),(12466,NULL,NULL,1),(13140,NULL,NULL,1),(13375,NULL,NULL,1),(13438,NULL,NULL,1),(14034,NULL,NULL,1),(15228,NULL,NULL,1),(15242,NULL,NULL,1),(15243,NULL,NULL,1),(15285,NULL,NULL,1),(15536,NULL,NULL,1),(15662,NULL,NULL,1),(15665,NULL,NULL,1),(16101,NULL,NULL,1),(16250,NULL,NULL,1),(16412,NULL,NULL,1),(16413,NULL,NULL,1),(16415,NULL,NULL,1),(16788,NULL,NULL,1),(17203,NULL,NULL,1),(17290,NULL,NULL,1),(18082,NULL,NULL,1),(18105,NULL,NULL,1),(18108,NULL,NULL,1),(18199,NULL,NULL,1),(18392,NULL,NULL,1),(18796,NULL,NULL,1),(19391,NULL,NULL,1),(19816,NULL,NULL,1),(20420,NULL,NULL,1),(20678,NULL,NULL,1),(20692,NULL,NULL,1),(20714,NULL,NULL,1),(20793,NULL,NULL,1),(20797,NULL,NULL,1),(20808,NULL,NULL,1),(20811,NULL,NULL,1),(20815,NULL,NULL,1),(20823,NULL,NULL,1),(21072,NULL,NULL,1),(21159,NULL,NULL,1),(21162,NULL,NULL,1),(21230,NULL,NULL,1),(21402,NULL,NULL,1),(21549,NULL,NULL,1),(22088,NULL,NULL,1),(22425,NULL,NULL,1),(23024,NULL,NULL,1),(23411,NULL,NULL,1),(23512,NULL,NULL,1),(24374,NULL,NULL,1),(24611,NULL,NULL,1),(25306,NULL,NULL,1),(39416,NULL,NULL,1),(53,NULL,NULL,2),(703,NULL,NULL,2),(1329,NULL,NULL,2),(2589,NULL,NULL,2),(2590,NULL,NULL,2),(2591,NULL,NULL,2),(5221,NULL,NULL,2),(6785,NULL,NULL,2),(6787,NULL,NULL,2),(6800,NULL,NULL,2),(8627,NULL,NULL,2),(8631,NULL,NULL,2),(8632,NULL,NULL,2),(8633,NULL,NULL,2),(8676,NULL,NULL,2),(8721,NULL,NULL,2),(8724,NULL,NULL,2),(8725,NULL,NULL,2),(8992,NULL,NULL,2),(9829,NULL,NULL,2),(9830,NULL,NULL,2),(9866,NULL,NULL,2),(9867,NULL,NULL,2),(11267,NULL,NULL,2),(11268,NULL,NULL,2),(11269,NULL,NULL,2),(11279,NULL,NULL,2),(11280,NULL,NULL,2),(11281,NULL,NULL,2),(11289,NULL,NULL,2),(11290,NULL,NULL,2),(21987,NULL,NULL,2),(23959,NULL,NULL,2),(24825,NULL,NULL,2),(25300,NULL,NULL,2),(26839,NULL,NULL,2),(26863,NULL,NULL,2),(26884,NULL,NULL,2),(27001,NULL,NULL,2),(27002,NULL,NULL,2),(27005,NULL,NULL,2),(27441,NULL,NULL,2),(34411,NULL,NULL,2),(34412,NULL,NULL,2),(34413,NULL,NULL,2);
/*!40000 ALTER TABLE `spellextra` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `spelloverride`
--
DROP TABLE IF EXISTS `spelloverride`;
CREATE TABLE `spelloverride` (
`overrideId` int(30) NOT NULL default '0',
`spellId` int(30) NOT NULL default '0',
UNIQUE KEY `overrideId` (`overrideId`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `spelloverride`
--
LOCK TABLES `spelloverride` WRITE;
/*!40000 ALTER TABLE `spelloverride` DISABLE KEYS */;
INSERT INTO `spelloverride` VALUES (836,10),(836,6141),(836,8427),(836,10185),(836,10186),(836,10187),(836,27085),(836,27618),(850,5246),(850,12730),(850,19134),(850,20511),(850,29544),(850,33789),(850,38945),(850,38946),(968,5246),(968,12730),(968,19134),(968,20511),(968,29544),(968,33789),(968,38945),(968,38946),(969,5246),(969,12730),(969,19134),(969,20511),(969,29544),(969,33789),(969,38945),(969,38946),(988,10),(988,6141),(988,8427),(988,10185),(988,10186),(988,10187),(988,27085),(988,27618),(989,10),(989,6141),(989,8427
7),(5063,17),(5063,592),(5063,600),(5063,3747),(5063,6065),(5063,6066),(5063,10898),(5063,10899),(5063,10900),(5063,10901),(5063,25217),(5063,25218),(5063,27607),(5064,17),(5064,592),(5064,600),(5064,3747),(5064,6065),(5064,6066),(5064,10898),(5064,10899),(5064,10900),(5064,10901),(5064,25217),(5064,25218),(5064,27607),(5065,17),(5065,592),(5065,600),(5065,3747),(5065,6065),(5065,6066),(5065,10898),(5065,10899),(5065,10900),(5065,10901),(5065,25217),(5065,25218),(5065,27607),(5066,589),(5066,594),(5066,970),(5066,992),(5066,2767),(5066,10892),(5066,10893),(5066,10894),(5066,15407),(5066,16568),(5066,17165),(5066,17311),(5066,17312),(5066,17313),(5066,17314),(5066,18807),(5066,22919),(5066,23953),(5066,25367),(5066,25368),(5066,25387),(5066,26044),(5066,26143),(5066,27605),(5066,28310),(5066,29407),(5066,29570),(5066,32417),(5066,34914),(5066,34916),(5066,34917),(5066,35507),(5066,37276),(5066,37330),(5066,37621),(5066,38243),(5142,403),(5142,421),(5142,529),(5142,548),(5142,915),(5142,930),(5142,943),(5142,2860),(5142,6041),(5142,10391),(5142,10392),(5142,10605),(5142,15207),(5142,15208),(5142,25439),(5142,25442),(5142,25448),(5142,25449),(5142,37661),(5147,20116),(5147,20922),(5147,20923),(5147,20924),(5147,26573),(5147,27173),(5147,32773),(5147,33559),(5147,36946),(5147,37553),(5147,38385),(5148,2912),(5148,8949),(5148,8950),(5148,8951),(5148,9875),(5148,9876),(5148,21668),(5148,25298),(5148,26986),(5148,35243),(5148,38935),(5236,1130),(5236,14323),(5236,14324),(5236,14325),(5236,31615),(5237,1130),(5237,14323),(5237,14324),(5237,14325),(5237,31615),(5238,1130),(5238,14323),(5238,14324),(5238,14325),(5238,31615),(5239,1130),(5239,14323),(5239,14324),(5239,14325),(5239,31615),(5240,1130),(5240,14323),(5240,14324),(5240,14325),(5240,31615),(5494,1463),(5494,8494),(5494,8495),(5494,10191),(5494,10192),(5494,10193),(5494,17740),(5494,17741),(5494,27131),(5494,29880),(5494,30973),(5494,31635),(5494,35064),(5494,38151),(5634,17364),(5634,32175),(5634,32176);
/*!40000 ALTER TABLE `spelloverride` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `spells112`
--
DROP TABLE IF EXISTS `spells112`;
CREATE TABLE `spells112` (
`Id` int(100) default '0',
`School` int(100) default '0',
`Category` int(100) default '0',
`field4` int(100) default '0',
`DispelType` int(100) default '0',
`MechanicsType` int(100) default '0',
`Attributes` int(100) default '0',
`AttributesEx` int(100) default '0',
`Flags3` int(100) default '0',
`field10` int(100) default '0',
`field11` int(100) default '0',
`UNK12` int(100) default '0',
`UNK13` int(100) default '0',
`Targets` int(100) default '0',
`TargetCreatureType` int(100) default '0',
`RequiresSpellFocus` int(100) default '0',
`CasterAuraState` int(100) default '0',
`TargetAuraState` int(100) default '0',
`CastingTimeIndex` int(100) default '0',
`RecoveryTime` int(100) default '0',
`CategoryRecoveryTime` int(100) default '0',
`InterruptFlags` int(100) default '0',
`AuraInterruptFlags` int(100) default '0',
`ChannelInterruptFlags` int(100) default '0',
`procFlags` int(100) default '0',
`procChance` int(100) default '0',
`procCharges` int(100) default '0',
`maxLevel` int(100) default '0',
`baseLevel` int(100) default '0',
`spellLevel` int(100) default '0',
`DurationIndex` int(100) default '0',
`powerType` int(100) default '0',
`manaCost` int(100) default '0',
`manaCostPerlevel` int(100) default '0',
`manaPerSecond` int(100) default '0',
`manaPerSecondPerLevel` int(100) default '0',
`rangeIndex` int(100) default '0',
`speed` float default '0',
`modalNextSpell` int(100) default '0',
`maxstack` int(100) default '0',
`Totem1` int(100) default '0',
`Totem2` int(100) default '0',
`Reagent1` int(100) default '0',
`Reagent2` int(100) default '0',
`Reagent3` int(100) default '0',
`Reagent4` int(100) default '0',
`Reagent5` int(100) default '0',
`Reagent6` int(100) default '0',
`Reagent7` int(100) default '0',
`Reagent8` int(100) default
lags` int(100) default '0',
`ManaCostPercentage` int(100) default '0',
`unkflags` int(100) default '0',
`StartRecoveryTime` int(100) default '0',
`StartRecoveryCategory` int(100) default '0',
`SpellFamilyName` int(100) default '0',
`SpellGroupType` int(100) default '0',
`unkne` int(100) default '0',
`MaxTargets` int(100) default '0',
`Spell_Dmg_Type` int(100) default '0',
`FG` int(100) default '0',
`FH` int(100) default '0',
`dmg_multiplier_1` float default '0',
`dmg_multiplier_2` float default '0',
`dmg_multiplier_3` float default '0',
`FL` int(100) default '0',
`FM` int(100) default '0',
`FN` int(100) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-08-19 12:52:19
Line no.:198722
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 'r table `creature_spawns`
DROP TABLE
gned NOT NULL default '0',
`Map` int
Scarab' at line 1
Query:
r table `creature_spawns`
DROP TABLE
gned NOT NULL default '0',
`Map` int
Scarab Wall'),(94,8936.56,-7439.9,8
(215,3032.44,3594.28,145.806,4.
Waste'),(333,3216.28,2992.5
LL default '0',
`sellprice` int(30) NOT NULL default '0',
`inve
`text0_0` longtext NOT NULL,
`text0_1` longtext NOT NULL,
5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20
LUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25
38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2
,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14
9,7266),(39,7267),(39,7355),(39,8386),(39,216
8),(36,227),(36,7340),(36,203),(41,1180),
t(10) unsigned NOT NULL default '0',
Orchard',3),(242,'Brightwood Grove
h Gate Pass',1),(808,'North Ga
(2246,'Frostfire Hot Sprin
11) unsigned NOT NULL
OCK TABLES;
--
LL,1),(30213,NU
),(10947,NU
22,NULL
ULL
4,NULL,NULL,1),(20355,NULL,NULL,1),(20411,NULL,NULL,1),(20412,NULL,NULL,1),(20413,NULL,NULL,1),(20414,NULL,NULL,1),(20425,NULL,NULL,1),(20467,NULL,NULL,1),(20961,NULL,NULL,1),(20962,NULL,NULL,1),(20963,NULL,NULL,1),(20964,NULL,NULL,1),(20965,NULL,NULL,1),(20966,NULL,NULL,1),(20967,NULL,NULL,1),(20968,NULL,NULL,1),(21183,NULL,NULL,1),(21889,NULL,NULL,1),(23590,NULL,NULL,1),(24234,NULL,NULL,1),(25061,NULL,NULL,1),(25745,NULL,NULL,1),(25751,NULL,NULL,1),(25752,NULL,NULL,1),(25753,NULL,NULL,1),(25757,NULL,NULL,1),(25758,NULL,NULL,1),(25759,NULL,NULL,1),(25760,NULL,NULL,1),(25761,NULL,NULL,1),(25762,NULL,NULL,1),(25942,NULL,NULL,1),(25943,NULL,NULL,1),(25944,NULL,NULL,1),(25945,NULL,NULL,1),(27731,NULL,NULL,1),(133,NULL,NULL,1),(143,NULL,NULL,1),(145,NULL,NULL,1),(3140,NULL,NULL,1),(8400,NULL,NULL,1),(8401,NULL,NULL,1),(8402,NULL,NULL,1),(9053,NULL,NULL,1),(9487,NULL,NULL,1),(9488,NULL,NULL,1),(10148,NULL,NULL,1),(10149,NULL,NULL,1),(10150,NULL,NULL,1),(10151,NULL,NULL,1),(10578,NULL,NULL,1),(11839,NULL,NULL,1),(11921,NULL,NULL,1),(11985,NULL,NULL,1),(11988,NULL,NULL,1),(11989,NULL,NULL,1),(12466,NULL,NULL,1),(13140,NULL,NULL,1),(13375,NULL,NULL,1),(13438,NULL,NULL,1),(14034,NULL,NULL,1),(15228,NULL,NULL,1),(15242,NULL,NULL,1),(15243,NULL,NULL,1),(15285,NULL,NULL,1),(15536,NULL,NULL,1),(15662,NULL,NULL,1),(15665,NULL,NULL,1),(16101,NULL,NULL,1),(16250,NULL,NULL,1),(16412,NULL,NULL,1),(16413,NULL,NULL,1),(16415,NULL,NULL,1),(16788,NULL,NULL,1),(17203,NULL,NULL,1),(17290,NULL,NULL,1),(18082,NULL,NULL,1),(18105,NULL,NULL,1),(18108,NULL,NULL,1),(18199,NULL,NULL,1),(18392,NULL,NULL,1),(18796,NULL,NULL,1),(19391,NULL,NULL,1),(19816,NULL,NULL,1),(20420,NULL,NULL,1),(20678,NULL,NULL,1),(20692,NULL,NULL,1),(20714,NULL,NULL,1),(20793,NULL,NULL,1),(20797,NULL,NULL,1),(20808,NULL,NULL,1),(20811,NULL,NULL,1),(20815,NULL,NULL,1),(20823,NULL,NULL,1),(21072,NULL,NULL,1),(21159,NULL,NULL,1),(21162,NULL,NULL,1),(21230,NULL,NULL,1),(21402,NULL,NULL,1),(21549,NULL,NULL,1),(22088,NULL,NULL,1),(22425,NULL,NULL,1),(23024,NULL,NULL,1),(23411,NULL,NULL,1),(23512,NULL,NULL,1),(24374,NULL,NULL,1),(24611,NULL,NULL,1),(25306,NULL,NULL,1),(39416,NULL,NULL,1),(53,NULL,NULL,2),(703,NULL,NULL,2),(1329,NULL,NULL,2),(2589,NULL,NULL,2),(2590,NULL,NULL,2),(2591,NULL,NULL,2),(5221,NULL,NULL,2),(6785,NULL,NULL,2),(6787,NULL,NULL,2),(6800,NULL,NULL,2),(8627,NULL,NULL,2),(8631,NULL,NULL,2),(8632,NULL,NULL,2),(8633,NULL,NULL,2),(8676,NULL,NULL,2),(8721,NULL,NULL,2),(8724,NULL,NULL,2),(8725,NULL,NULL,2),(8992,NULL,NULL,2),(9829,NULL,NULL,2),(9830,NULL,NULL,2),(9866,NULL,NULL,2),(9867,NULL,NULL,2),(11267,NULL,NULL,2),(11268,NULL,NULL,2),(11269,NULL,NULL,2),(11279,NULL,NULL,2),(11280,NULL,NULL,2),(11281,NULL,NULL,2),(11289,NULL,NULL,2),(11290,NULL,NULL,2),(21987,NULL,NULL,2),(23959,NULL,NULL,2),(24825,NULL,NULL,2),(25300,NULL,NULL,2),(26839,NULL,NULL,2),(26863,NULL,NULL,2),(26884,NULL,NULL,2),(27001,NULL,NULL,2),(27002,NULL,NULL,2),(27005,NULL,NULL,2),(27441,NULL,NULL,2),(34411,NULL,NULL,2),(34412,NULL,NULL,2),(34413,NULL,NULL,2);
/*!40000 ALTER TABLE `spellextra` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `spelloverride`
--
DROP TABLE IF EXISTS `spelloverride`;
CREATE TABLE `spelloverride` (
`overrideId` int(30) NOT NULL default '0',
`spellId` int(30) NOT NULL default '0',
UNIQUE KEY `overrideId` (`overrideId`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `spelloverride`
--
LOCK TABLES `spelloverride` WRITE;
/*!40000 ALTER TABLE `spelloverride` DISABLE KEYS */;
INSERT INTO `spelloverride` VALUES (836,10),(836,6141),(836,8427),(836,10185),(836,10186),(836,10187),(836,27085),(836,27618),(850,5246),(850,12730),(850,19134),(850,20511),(850,29544),(850,33789),(850,38945),(850,38946),(968,5246),(968,12730),(968,19134),(968,20511),(968,29544),(968,33789),(968,38945),(968,38946),(969,5246),(969,12730),(969,19134),(969,20511),(969,29544),(969,33789),(969,38945),(969,38946),(988,10),(988,6141),(988,8427),(988,10185),(988,10186),(988,10187),(988,27085),(988,27618),(989,10),(989,6141),(989,8427
7),(5063,17),(5063,592),(5063,600),(5063,3747),(5063,6065),(5063,6066),(5063,10898),(5063,10899),(5063,10900),(5063,10901),(5063,25217),(5063,25218),(5063,27607),(5064,17),(5064,592),(5064,600),(5064,3747),(5064,6065),(5064,6066),(5064,10898),(5064,10899),(5064,10900),(5064,10901),(5064,25217),(5064,25218),(5064,27607),(5065,17),(5065,592),(5065,600),(5065,3747),(5065,6065),(5065,6066),(5065,10898),(5065,10899),(5065,10900),(5065,10901),(5065,25217),(5065,25218),(5065,27607),(5066,589),(5066,594),(5066,970),(5066,992),(5066,2767),(5066,10892),(5066,10893),(5066,10894),(5066,15407),(5066,16568),(5066,17165),(5066,17311),(5066,17312),(5066,17313),(5066,17314),(5066,18807),(5066,22919),(5066,23953),(5066,25367),(5066,25368),(5066,25387),(5066,26044),(5066,26143),(5066,27605),(5066,28310),(5066,29407),(5066,29570),(5066,32417),(5066,34914),(5066,34916),(5066,34917),(5066,35507),(5066,37276),(5066,37330),(5066,37621),(5066,38243),(5142,403),(5142,421),(5142,529),(5142,548),(5142,915),(5142,930),(5142,943),(5142,2860),(5142,6041),(5142,10391),(5142,10392),(5142,10605),(5142,15207),(5142,15208),(5142,25439),(5142,25442),(5142,25448),(5142,25449),(5142,37661),(5147,20116),(5147,20922),(5147,20923),(5147,20924),(5147,26573),(5147,27173),(5147,32773),(5147,33559),(5147,36946),(5147,37553),(5147,38385),(5148,2912),(5148,8949),(5148,8950),(5148,8951),(5148,9875),(5148,9876),(5148,21668),(5148,25298),(5148,26986),(5148,35243),(5148,38935),(5236,1130),(5236,14323),(5236,14324),(5236,14325),(5236,31615),(5237,1130),(5237,14323),(5237,14324),(5237,14325),(5237,31615),(5238,1130),(5238,14323),(5238,14324),(5238,14325),(5238,31615),(5239,1130),(5239,14323),(5239,14324),(5239,14325),(5239,31615),(5240,1130),(5240,14323),(5240,14324),(5240,14325),(5240,31615),(5494,1463),(5494,8494),(5494,8495),(5494,10191),(5494,10192),(5494,10193),(5494,17740),(5494,17741),(5494,27131),(5494,29880),(5494,30973),(5494,31635),(5494,35064),(5494,38151),(5634,17364),(5634,32175),(5634,32176);
/*!40000 ALTER TABLE `spelloverride` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `spells112`
--
DROP TABLE IF EXISTS `spells112`;
CREATE TABLE `spells112` (
`Id` int(100) default '0',
`School` int(100) default '0',
`Category` int(100) default '0',
`field4` int(100) default '0',
`DispelType` int(100) default '0',
`MechanicsType` int(100) default '0',
`Attributes` int(100) default '0',
`AttributesEx` int(100) default '0',
`Flags3` int(100) default '0',
`field10` int(100) default '0',
`field11` int(100) default '0',
`UNK12` int(100) default '0',
`UNK13` int(100) default '0',
`Targets` int(100) default '0',
`TargetCreatureType` int(100) default '0',
`RequiresSpellFocus` int(100) default '0',
`CasterAuraState` int(100) default '0',
`TargetAuraState` int(100) default '0',
`CastingTimeIndex` int(100) default '0',
`RecoveryTime` int(100) default '0',
`CategoryRecoveryTime` int(100) default '0',
`InterruptFlags` int(100) default '0',
`AuraInterruptFlags` int(100) default '0',
`ChannelInterruptFlags` int(100) default '0',
`procFlags` int(100) default '0',
`procChance` int(100) default '0',
`procCharges` int(100) default '0',
`maxLevel` int(100) default '0',
`baseLevel` int(100) default '0',
`spellLevel` int(100) default '0',
`DurationIndex` int(100) default '0',
`powerType` int(100) default '0',
`manaCost` int(100) default '0',
`manaCostPerlevel` int(100) default '0',
`manaPerSecond` int(100) default '0',
`manaPerSecondPerLevel` int(100) default '0',
`rangeIndex` int(100) default '0',
`speed` float default '0',
`modalNextSpell` int(100) default '0',
`maxstack` int(100) default '0',
`Totem1` int(100) default '0',
`Totem2` int(100) default '0',
`Reagent1` int(100) default '0',
`Reagent2` int(100) default '0',
`Reagent3` int(100) default '0',
`Reagent4` int(100) default '0',
`Reagent5` int(100) default '0',
`Reagent6` int(100) default '0',
`Reagent7` int(100) default '0',
`Reagent8` int(100) default
lags` int(100) default '0',
`ManaCostPercentage` int(100) default '0',
`unkflags` int(100) default '0',
`StartRecoveryTime` int(100) default '0',
`StartRecoveryCategory` int(100) default '0',
`SpellFamilyName` int(100) default '0',
`SpellGroupType` int(100) default '0',
`unkne` int(100) default '0',
`MaxTargets` int(100) default '0',
`Spell_Dmg_Type` int(100) default '0',
`FG` int(100) default '0',
`FH` int(100) default '0',
`dmg_multiplier_1` float default '0',
`dmg_multiplier_2` float default '0',
`dmg_multiplier_3` float default '0',
`FL` int(100) default '0',
`FM` int(100) default '0',
`FN` int(100) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-08-19 12:52:34
Line no.:198722
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 'r table `creature_spawns`
DROP TABLE
gned NOT NULL default '0',
`Map` int
Scarab' at line 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 16:26:50
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 16:27:11
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50000, 1, 16256.1, 16298.3, 13.1752, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0)
Error occured at:2007-08-19 16:27:34
Line no.:3
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 '(entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, e' at line 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-08-19 16:35:12
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-08-19 16:35:26
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:17:12
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:26:53
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:28:39
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:29:56
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:30:02
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:32:17
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 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, 0, 0)
Error occured at:2007-08-19 18:35:17
Line no.:84
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto
(entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES
(50000, 100, 100, 1741, 1000000, 1000000, 1000000, 1, 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, 0, 0)
Error occured at:2007-08-21 10:48:54
Line no.:86
Error Code: 1054 - Unknown column 'minlevel' in 'field list'
Query:
INSERT INTO creature_proto
(entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES
(50000, 100, 100, 1741, 1000000, 1000000, 1000000, 1, 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, 0, 0)
Error occured at:2007-08-21 10:51:06
Line no.:86
Error Code: 1054 - Unknown column 'minlevel' in 'field list'