[Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular) menu

User Tag List

Page 1 of 5 12345 LastLast
Results 1 to 15 of 68
  1. #1
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    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 !


    report broken links: United World Crew -[ Forums ]-



    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





    EDIT: for people who dont know... ascent SVN moved from svn://emupedia.com/svn/ascent to http://projects.emupedia.com/svn/ascent



    Username: anonymous



    Leave the password blank


    Last edited by latruwski; 11-24-2007 at 03:35 PM.

    [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)
  2. #2
    mafiaboy's Avatar Contributor
    Reputation
    235
    Join Date
    May 2007
    Posts
    698
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    I love this! Although my im using chrispee's newest database that came with his repack. All i have to do i update it?

  3. #3
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    to update your rev just replace the files in your ascent folder with the ones posted above...

  4. #4
    mafiaboy's Avatar Contributor
    Reputation
    235
    Join Date
    May 2007
    Posts
    698
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    ya thnx dude. this fixed my logging into game server erro! This is amazing! Should be stickied

  5. #5
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    well thx man i think too much people are too lazy to open this topic maybe? i dunno maybe the topic title is confusing? mods will probably not put this as sticky lol

    anyway thx again

    grtz

  6. #6
    aznboy's Avatar Active Member
    Reputation
    45
    Join Date
    Jun 2007
    Posts
    807
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    can u plz reupload the blank character sql?? thnx cuz i need it real bad

  7. #7
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    updated the whole posts with newer revs also !!
    Updated to Revision 2267 [8-Nov-07]

    grtz

  8. #8
    [Shon3m]'s Avatar Banned
    Reputation
    128
    Join Date
    Apr 2007
    Posts
    669
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    /bump HEhe

  9. #9
    weaselking1973's Avatar Member
    Reputation
    30
    Join Date
    Oct 2007
    Posts
    332
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    got a install write up for this.

    having some issues with the database install and the guide thats with it dont help none, and can't get the "tool" for the database to work
    "In the event of an emergency, dont ask me, I crashed my server a few hundered times before I realized kicking the CPU wont make it work"


    pet mod guide Maps For Blondes creating weapons Hunter set

  10. #10
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    Originally Posted by weaselking1973 View Post
    got a install write up for this.

    having some issues with the database install and the guide thats with it dont help none, and can't get the "tool" for the database to work
    if you have isues installing the DB.. then try getting ncdb 0.2.1 and then use the update-db.sql to update it

    grtz

  11. #11
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    Originally Posted by dhomeli View Post
    Awesome! Would +Rep if I could.
    after a number of posts and rep you can just try contribute to the community and before you post make sure you use search to see if it hasn't been posted already
    thx for the comment

    grtz

  12. #12
    iccy's Avatar Member
    Reputation
    44
    Join Date
    Jul 2007
    Posts
    300
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    i am very impressed... +Rep

    EDIT:
    Ugh I already gave you rep need to spread some more first
    Last edited by iccy; 11-10-2007 at 10:55 AM.

  13. #13
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    Originally Posted by iccy View Post
    i am very impressed... +Rep

    EDIT:
    Ugh I already gave you rep need to spread some more first
    np lol i have the same problem sometimes

  14. #14
    weaselking1973's Avatar Member
    Reputation
    30
    Join Date
    Oct 2007
    Posts
    332
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    so no write up then

    anyone have a issue with doing a extract of the DB-full with navcat... thing runs for hourslitterally and gets no where
    "In the event of an emergency, dont ask me, I crashed my server a few hundered times before I realized kicking the CPU wont make it work"


    pet mod guide Maps For Blondes creating weapons Hunter set

  15. #15
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)

    Originally Posted by weaselking1973 View Post
    so no write up then

    anyone have a issue with doing a extract of the DB-full with navcat... thing runs for hourslitterally and gets no where
    hmm did you try the 0.2.2 full-db.sql from the SVN?
    http://projects.emupedia.com/svn/ncd...lestone-0.2.x/
    login: anonymous
    leave password blank...

    if you cant get it to work then download 0.2.1 and then update to 0.2.2.. that should work...

    i also downloaded 0.2.1 and updated to 0.2.2 myself to help someone with the same problem like you... this is the link:
    Filebeam - Free Fast File Hosting
    (its the full DB)

    grtz

Page 1 of 5 12345 LastLast

Similar Threads

  1. [Release] BillyBob's Ascent Rev Core Compiles and NCDB " UPDATED HOURLY "
    By BillyBob31 in forum World of Warcraft Emulator Servers
    Replies: 89
    Last Post: 07-05-2008, 06:08 PM
  2. [Release]Latest Ascent Rev for Linux
    By L'Lawliet in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 06-04-2008, 05:23 PM
  3. [Release] Venice WoW/Ascent/DB 2.4 Updates/Patches ~~~Repack~~~
    By ~SaiLyn~ in forum World of Warcraft Emulator Servers
    Replies: 100
    Last Post: 04-02-2008, 08:31 PM
  4. What's the information for latest Ascent Rev & NCDB ?
    By Wheeze201 in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 03-29-2008, 08:33 AM
  5. [MOD] Remove the level cap from latest ascent revs!
    By latruwski in forum World of Warcraft Emulator Servers
    Replies: 25
    Last Post: 12-31-2007, 03:20 AM
All times are GMT -5. The time now is 06:26 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search