Quote Originally Posted by runiker View Post
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;