Thread: ArcEmu Core (rev 2196) + 3.0.9 DBC

Thanks and hey can you possible to post the updated format of sql (just the sqls nothing else) i ask this because i am trying to make a nice website that works upto-date with current arcemu db layout (might expand to mangos next)

Originally Posted by runiker

Thanks and hey can you possible to post the updated format of sql (just the sqls nothing else) i ask this because i am trying to make a nice website that works upto-date with current arcemu db layout (might expand to mangos next)

Here is the 2199_gosandquests.sql source

Code:

alter table `gameobject_names` add column `Name2` varchar(100) DEFAULT '' NOT NULL after `Name`;
alter table `gameobject_names` add column `Name3` varchar(100) DEFAULT '' NOT NULL after `Name2`;
alter table `gameobject_names` add column `Name4` varchar(100) DEFAULT '' NOT NULL after `Name3`;
alter table `gameobject_names` add column `Category` varchar(100) DEFAULT '' NOT NULL after `Name4`;
alter table `gameobject_names` add column `CastBarText` varchar(100) DEFAULT '' NOT NULL after `Category`;
alter table `gameobject_names` add column `UnkStr` varchar(100) DEFAULT '' NOT NULL after `CastBarText`;

alter table `quests` add column `detailemotecount` int UNSIGNED DEFAULT '0' NOT NULL after `suggestedplayers`;
alter table `quests` add column `detailemote1` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotecount`;
alter table `quests` add column `detailemote2` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote1`;
alter table `quests` add column `detailemote3` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote2`;
alter table `quests` add column `detailemote4` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote3`;
alter table `quests` add column `detailemotedelay1` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote4`;
alter table `quests` add column `detailemotedelay2` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay1`;
alter table `quests` add column `detailemotedelay3` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay2`;
alter table `quests` add column `detailemotedelay4` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay3`;
alter table `quests` add column `completionemotecnt` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay4`;
alter table `quests` add column `completionemote1` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotecnt`;
alter table `quests` add column `completionemote2` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote1`;
alter table `quests` add column `completionemote3` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote2`;
alter table `quests` add column `completionemote4` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote3`;
alter table `quests` add column `completionemotedelay1` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote4`;
alter table `quests` add column `completionemotedelay2` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay1`;
alter table `quests` add column `completionemotedelay3` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay2`;
alter table `quests` add column `completionemotedelay4` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay3`;
alter table `quests` add column `completeemote` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay4`;
alter table `quests` add column `incompleteemote` int UNSIGNED DEFAULT '0' NOT NULL after `completeemote`;

CREATE TABLE `vendor_restrictions` (
 `entry` int(10) unsigned NOT NULL,
 `racemask` int(11) NOT NULL default '-1',
 `reqrepfaction` int(10) unsigned NOT NULL default '0',
 `reqrepfactionvalue` int(10) unsigned NOT NULL default '0',
 `canbuyattextid` int(10) unsigned NOT NULL default '0',
 `cannotbuyattextid` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `itemnames` (
 `entry` int(10) unsigned NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `slotid` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;