i got this from kandyman (B-WoW, UW-Crew, ...)
Ascent Compiled Binaries
Compiled with Visual Studio 2003 By Kandyman
2.5 Trunk
Ascent Revision 2422 +
Scripts:
[Download]
2.4 Stable Branch
Ascent Revision 2409 +
Scripts:
[Download]
2.3 - 2.4 Trunk
Ascent Revision 2401 +
Scripts:
[Download]
Ascent Revision 2400 +
Scripts:
[Download]
Ascent Revision 2372 +
Scripts:
[Download]
Ascent Revision 2364 +
Scripts:
[Download]
Ascent Revision 2351 +
Scripts:
[Download]
Ascent Revision 2345 +
Scripts:
[Download]
Ascent Revision 2340 +
Scripts:
[Download]
Ascent Revision 2313 +
Scripts:
[Download]
2.3 Stable Branch
Ascent Revision 2267 +
Scripts:
[Download]
2.1 - 2.3 Trunk
Ascent Revision 2228 +
Scripts:
[Download]
Ascent Revision 2169 +
Scripts:
[Download]
Ascent Revision 2143 +
Scripts:
[Download]
Ascent Revision 2136 +
Scripts:
[Download]
2.0 Trunk
Ascent Revision 2035 +
Scripts +
GMScripts Revison 36:
[Download]
Ascent Revision 2034 +
Scripts +
GMScripts Revison 36:
[Download]
2.0 Stable Branch
Ascent Revision 2016 +
Scripts +
GMScripts Revison 36:
[Download]
Ascent Revision 1993 +
Scripts +
GMScripts Revison 36:
[Download]
Ascent Revision 1976 +
Scripts +
GMScripts Revison 36:
[Download]
Ascent Revision 1972 +
Scripts +
GMScripts Revison 36:
[Download]
1.7 - 2.0 Trunk
Ascent Revision 1952 +
Scripts +
GMScripts Revison 36:
[Download]
Ascent Revision 1923 +
Scripts +
GMScripts Revison 34:
[Download]
Ascent Revision 1892 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1855 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1828 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1817 +
Scripts +
Gamemonkey Scripts:
[Download]
1.7 Stable Branch
Ascent Revision 1791 +
Scripts +
Gamemonkey Scripts:
[Download]
1.6 - 1.7 Trunk
Ascent Revision 1774 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1756 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1746 +
Scripts +
Gamemonkey Scripts:
[Download]
1.6 Stable Branch
Ascent Revision 1711 +
Scripts +
Gamemonkey Scripts:
[Download]
1.5 - 1.6 Trunk
Ascent Revision 1692 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1682 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1650 +
Scripts +
Gamemonkey Scripts:
[Download]
1.5 Stable Branch
Ascent Revision 1595 +
Scripts +
Gamemonkey Scripts:
[Download]
Past Trunk
Ascent Revision 1581 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1536 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1522 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1510 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1484 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1461 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1444 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1429 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1417 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1387 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1358 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1337 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1324 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1300 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1289 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1275 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1238 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1230 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1220 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1187 +
Scripts +
Gamemonkey Scripts:
[Download]
Ascent Revision 1180 +
Scripts +
Gamemonkey Scripts:
[Download]
Extras
Full Next Chapter Database (NCDB)
Milestone 0.2.2:
[Download]
Milestone 0.2.3:
[Download]
Blank Account + Character Tables:
[Download]
Additional DLL's:
[Download]
2.3.x DBC Files:
[Download]
Map Extractor:
[Download]
SQL Updates
Revision 2075+
Code:
alter table accounts add column forceLanguage varchar(5) not null default "enUS";
Revision 2099+
Code:
DROP TABLE IF EXISTS `instances`;
CREATE TABLE `instances` (
`id` int(30) NOT NULL default '0',
`mapid` int(30) NOT NULL default '0',
`creation` int(30) NOT NULL default '0',
`expiration` int(30) NOT NULL default '0',
`killed_npc_guids` text NOT NULL,
`difficulty` int(30) NOT NULL default '0',
`creator_group` int(30) NOT NULL default '0',
`creator_guid` int(30) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Revision 2188+
Code:
UPDATE worldmap_info SET type=4 WHERE entry IN (552, 554, 553, 540, 542, 543, 547, 546, 545, 560, 269, 556, 555, 557, 558 );
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_1` INTEGER(30) NOT NULL DEFAULT 0 AFTER `required_item`;
ALTER TABLE `worldmap_info` ADD COLUMN `heroic_keyid_2` INTEGER(30) NOT NULL DEFAULT 0 AFTER `heroic_keyid_1`;
UPDATE `worldmap_info` SET `heroic_keyid_1`=30633 WHERE entry IN (555,556,557,558);
UPDATE `worldmap_info` SET `heroic_keyid_1`=30634 WHERE entry IN (552,553,554);
UPDATE `worldmap_info` SET `heroic_keyid_1`=30635 WHERE entry IN (269,560);
UPDATE `worldmap_info` SET `heroic_keyid_1`=30623 WHERE entry IN (545,546,547);
UPDATE `worldmap_info` SET `heroic_keyid_1`=30637 WHERE entry IN (540,542,543);
UPDATE `worldmap_info` SET `heroic_keyid_2`=30622 WHERE entry IN (540,542,543);
Revision 2192+
Code:
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId1` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqKillMobOrGOCount4`;
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId2` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqCastSpellId1`;
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId3` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqCastSpellId2`;
ALTER TABLE `quests` ADD COLUMN `ReqCastSpellId4` INTEGER(11) NOT NULL DEFAULT 0 AFTER `ReqCastSpellId3`;
Revision 2195+
Code:
alter table characters modify column banned int(40) not null;
Revision 2243+
Code:
ALTER TABLE `creatureloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `fishingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `itemloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `pickpocketingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `prospectingloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `skinningloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
ALTER TABLE `objectloot` ADD COLUMN `ffa_loot` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `maxcount`;
Revision 2272+
Code:
alter table playeritems add column wrapped_item_id int(30) not null default 0 after entry;
alter table playeritems_external add column wrapped_item_id int(30) not null default 0 after entry;
alter table playeritems add column wrapped_creator int(30) not null default 0 after wrapped_item_id;
alter table playeritems_external add column wrapped_creator int(30) not null default 0 after wrapped_item_id;
Revision 2290+
Code:
alter table worldmap_info add column viewingDistance float(0) not null default 80.0;
Revision 2302+
Code:
DROP TABLE IF EXISTS `characters_insert_queue`;
CREATE TABLE `characters_insert_queue` (
`insert_temp_guid` int(10) unsigned NOT NULL default '0',
`acct` int(10) unsigned NOT NULL default '0',
`name` varchar(21) collate utf8_unicode_ci NOT NULL,
`race` tinyint(3) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`gender` tinyint(3) unsigned NOT NULL default '0',
`custom_faction` int(30) NOT NULL default '0',
`level` int(10) unsigned NOT NULL default '0',
`xp` int(10) unsigned NOT NULL default '0',
`exploration_data` longtext collate utf8_unicode_ci NOT NULL,
`skills` longtext collate utf8_unicode_ci NOT NULL,
`watched_faction_index` int(10) unsigned NOT NULL default '0',
`selected_pvp_title` int(10) unsigned NOT NULL default '0',
`available_pvp_titles` int(10) unsigned NOT NULL default '0',
`gold` int(10) unsigned NOT NULL default '0',
`ammo_id` int(10) unsigned NOT NULL default '0',
`available_prof_points` int(10) unsigned NOT NULL default '0',
`available_talent_points` int(10) unsigned NOT NULL default '0',
`current_hp` int(10) unsigned NOT NULL default '0',
`current_power` int(10) unsigned NOT NULL default '0',
`pvprank` tinyint(3) unsigned NOT NULL default '0',
`bytes` int(10) unsigned NOT NULL default '0',
`bytes2` int(10) unsigned NOT NULL default '0',
`player_flags` int(10) unsigned NOT NULL default '0',
`player_bytes` int(10) unsigned NOT NULL default '0',
`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(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`taximask` longtext collate utf8_unicode_ci NOT NULL,
`banned` int(40) NOT NULL,
`banReason` varchar(50) collate utf8_unicode_ci NOT NULL,
`timestamp` int(11) 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(10) unsigned NOT NULL default '0',
`bindzoneId` int(10) unsigned NOT NULL default '0',
`isResting` tinyint(3) unsigned NOT NULL default '0',
`restState` tinyint(3) unsigned NOT NULL default '0',
`restTime` int(10) unsigned NOT NULL default '0',
`playedtime` longtext collate utf8_unicode_ci NOT NULL,
`deathstate` int(10) unsigned NOT NULL default '0',
`TalentResetTimes` int(10) unsigned NOT NULL default '0',
`first_login` tinyint(3) unsigned NOT NULL default '0',
`forced_rename_pending` tinyint(3) unsigned NOT NULL default '0',
`publicNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`officerNote` varchar(32) collate utf8_unicode_ci NOT NULL,
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`arenaPoints` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) unsigned NOT NULL default '0',
`entrypointmap` int(10) unsigned 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) unsigned NOT NULL default '0',
`taxi_path` int(10) unsigned NOT NULL default '0',
`taxi_lastnode` int(10) unsigned NOT NULL default '0',
`taxi_mountid` int(10) unsigned NOT NULL default '0',
`transporter` int(10) unsigned NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` float NOT NULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext collate utf8_unicode_ci NOT NULL,
`deleted_spells` longtext collate utf8_unicode_ci NOT NULL,
`reputation` longtext collate utf8_unicode_ci NOT NULL,
`actions` longtext collate utf8_unicode_ci NOT NULL,
`auras` longtext collate utf8_unicode_ci NOT NULL,
`finished_quests` longtext collate utf8_unicode_ci NOT NULL,
`honorPointsToAdd` int(10) NOT NULL,
`killsToday` int(10) unsigned NOT NULL default '0',
`killsYesterday` int(10) unsigned NOT NULL default '0',
`killsLifeTime` int(10) unsigned NOT NULL default '0',
`honorToday` int(10) unsigned NOT NULL default '0',
`honorYesterday` int(10) unsigned NOT NULL default '0',
`honorPoints` int(10) unsigned NOT NULL default '0',
`difficulty` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `guid` (`insert_temp_guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Revision 2302+
Code:
DROP TABLE IF EXISTS `playeritems_insert_queue`;
CREATE TABLE `playeritems_insert_queue` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`entry` int(10) unsigned NOT NULL default '0',
`wrapped_item_id` int(30) NOT NULL default '0',
`wrapped_creator` int(30) NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`randomsuffix` int(30) NOT NULL,
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) NOT NULL default '-1' COMMENT 'couldnt find this being used in source',
`slot` tinyint(4) NOT NULL default '0',
`enchantments` longtext collate utf8_unicode_ci NOT NULL,
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Revision 2311+
Code:
-- Ai Agents
ALTER TABLE `ai_agents` CHANGE `entryId` `entry` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `AI_AGENT` `type` SmallINT(5) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `procEvent` `event` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `procChance` `chance` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `procCount` `maxcount` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `spellCooldown` `cooldown` INT(8) NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `spellId` `spell` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `spellType` `spelltype` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `ai_agents` CHANGE `spelltargetType` `targettype` INT(11) UNSIGNED NOT NULL DEFAULT '0';
-- ai_threattospellid
ALTER TABLE `ai_threattospellid` CHANGE `spellId` `spell` INT(11) UNSIGNED NOT NULL DEFAULT '0';
-- areatriggers
ALTER TABLE `areatriggers` CHANGE `AreaTriggerid` `entry` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `Type` `type` TinyINT(3) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `Mapid` `map` INT(11) UNSIGNED NULL;
ALTER TABLE `areatriggers` CHANGE `Screen` `screen` INT(11) UNSIGNED NULL;
ALTER TABLE `areatriggers` CHANGE `Name` `name` varchar(100) NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `x` `position_x` float NOT NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `y` `position_y` float NOT NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `z` `position_z` float NOT NULL DEFAULT '0';
ALTER TABLE `areatriggers` CHANGE `o` `orientation` float NOT NULL DEFAULT '0';
-- auctionhouse
ALTER TABLE `auctionhouse` CHANGE `entryid` `id` INT(32) NOT NULL AUTO_INCREMENT;
ALTER TABLE `auctionhouse` CHANGE `auctioneer` `creature_entry` BigINT(64) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `auctionhouse` CHANGE `AHid` `group` INT(32) NOT NULL DEFAULT '0';
-- creature_formations
ALTER TABLE `creature_formations` CHANGE `creature_sqlid` `spawn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_formations` CHANGE `followtarget_sqlid` `target_spawn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0';
-- creature_names
ALTER TABLE `creature_names` CHANGE `creature_name` `name` varchar(100) NOT NULL;
ALTER TABLE `creature_names` CHANGE `Subname` `subname` varchar(100) NOT NULL;
ALTER TABLE `creature_names` CHANGE `Family` `family` INT(10) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `creature_names` CHANGE `Rank` `rank` INT(10) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `creature_names` CHANGE `SpellDataID` `spelldataid` INT(10) UNSIGNED NULL;
ALTER TABLE `creature_names` CHANGE `unknown_int1` `male_displayid2` INT(30) NOT NULL DEFAULT '0';
ALTER TABLE `creature_names` CHANGE `unknown_int2` `female_displayid2` INT(30) NOT NULL DEFAULT '0';
ALTER TABLE `creature_names` CHANGE `Civilian` `civilian` INT(4) UNSIGNED NULL;
ALTER TABLE `creature_names` CHANGE `Leader` `leader` TinyINT(3) UNSIGNED NULL;
-- creature_proto
ALTER TABLE `creature_proto` CHANGE `resistance0_armor` `armor` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item1slotdisplay` `equipmodel1` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item2slotdisplay` `equipmodel2` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item3slotdisplay` `equipmodel3` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item1info1` `equipinfo1` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item2info1` `equipinfo2` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item3info1` `equipinfo3` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item1info2` `equipslot1` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item2info2` `equipslot2` INT(30) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_proto` CHANGE `item3info2` `equipslot3` INT(30) UNSIGNED NOT NULL DEFAULT '0';
-- creature_spawns
ALTER TABLE `creature_spawns` CHANGE `x` `position_x` float NOT NULL;
ALTER TABLE `creature_spawns` CHANGE `y` `position_y` float NOT NULL;
ALTER TABLE `creature_spawns` CHANGE `z` `position_z` float NOT NULL;
ALTER TABLE `creature_spawns` CHANGE `o` `orientation` float NOT NULL;
ALTER TABLE `creature_spawns` CHANGE `factionid` `faction` INT(30) NOT NULL DEFAULT '14';
ALTER TABLE `creature_spawns` CHANGE `Map` `map` INT(30) NOT NULL;
-- creature_waypoints
ALTER TABLE `creature_waypoints` CHANGE `creatureid` `spawnid` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `creature_waypoints` CHANGE `x` `position_x` float NOT NULL DEFAULT '0';
ALTER TABLE `creature_waypoints` CHANGE `y` `position_y` float NOT NULL DEFAULT '0';
ALTER TABLE `creature_waypoints` CHANGE `z` `position_z` float NOT NULL DEFAULT '0';
-- gameobject_quest_item_binding
ALTER TABLE `gameobject_quest_item_binding` CHANGE `gameobject_entry` `entry` INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE `gameobject_quest_item_binding` CHANGE `quest_id` `quest` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_quest_item_binding` CHANGE `item_id` `item` INT(11) NOT NULL DEFAULT '0';
-- gameobject_quest_pickup_binding
ALTER TABLE `gameobject_quest_pickup_binding` CHANGE `gameobject_entry` `entry` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_quest_pickup_binding` CHANGE `quest_id` `quest` INT(11) NOT NULL DEFAULT '0';
-- gameobject_spawns
ALTER TABLE `gameobject_spawns` CHANGE `x` `position_x` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `y` `position_y` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `z` `position_z` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `o1` `orientation1` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `o2` `orientation2` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `o3` `orientation3` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `o4` `orientation4` float NOT NULL DEFAULT '0';
ALTER TABLE `gameobject_spawns` CHANGE `Map` `map` int(10) unsigned NOT NULL DEFAULT '0';
-- graveyards
ALTER TABLE `graveyards` CHANGE `o` `orientation` float NOT NULL DEFAULT '0';
ALTER TABLE `graveyards` CHANGE `z` `position_z` float NOT NULL DEFAULT '0';
ALTER TABLE `graveyards` CHANGE `y` `position_y` float NOT NULL DEFAULT '0';
ALTER TABLE `graveyards` CHANGE `x` `position_x` float NOT NULL DEFAULT '0';
ALTER TABLE `graveyards` CHANGE `factionid` `faction` INT(10) UNSIGNED NOT NULL DEFAULT '0';
-- npc_gossip_textid
ALTER TABLE `npc_gossip_textid` CHANGE `entryid` `creatureid` INT(10) UNSIGNED NOT NULL DEFAULT '0';
-- quests
ALTER TABLE `quests` CHANGE `QuestSort` `sort` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `quests` CHANGE `QuestFlags` `flags` INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `quests` CHANGE `MaxLevel` `questlevel` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
Revision 2320+
Code:
alter table guild_ranks add column rankRights_1 int(30) not null default 0;
alter table guild_ranks add column rankRights_2 int(30) not null default 0;
alter table guild_ranks add column rankRights_3 int(30) not null default 0;
alter table guild_ranks add column rankRights_4 int(30) not null default 0;
alter table guild_ranks add column rankRights_5 int(30) not null default 0;
alter table guild_ranks add column rankRights_6 int(30) not null default 0;
alter table guild_ranks add column rankRights_7 int(30) not null default 0;
alter table guild_ranks add column rankRights_8 int(30) not null default 0;
alter table guild_ranks add column rankRights_9 int(30) not null default 0;
alter table guild_ranks add column rankRights_10 int(30) not null default 0;
alter table guild_ranks add column rankRights_11 int(30) not null default 0;
alter table guild_ranks add column rankRights_12 int(30) not null default 0;
alter table guild_ranks add column rankRights_13 int(30) not null default 0;
Revision 2321+
Code:
alter table items add column ArenaRankRequirement int(30) not null default 0 after ItemExtendedCost;
Revision 2325+
Code:
alter table creature_names add column mouseFlags int(30) not null default 0 after subname;
Revision 2368+
Code:
DROP TABLE IF EXISTS `guild_checkpoints`;
CREATE TABLE `guild_checkpoints` (
`guildid` int(30) NOT NULL,
`checkid` int(30) NOT NULL,
PRIMARY KEY (`guildid`,`checkid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Revision 2368+
Code:
DROP TABLE IF EXISTS `map_checkpoint`;
CREATE TABLE `map_checkpoint` (
`entry` int(30) NOT NULL,
`prereq_checkpoint_id` int(30) NOT NULL,
`creature_id` int(30) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Revision 2368+
Code:
alter table worldmap_info add column required_checkpoint int(30) not null default 0;
i keep it updated as Kandyman will !
credit goes to Kandyman for compiling the bins !
I am sure this will be a help for a lot of people who dont know how to compile
grtz
Username: anonymous
Leave the password blank