Sql/Patch- All buildings, models, etc. as Gameobjects

This is a discussion on Sql/Patch- All buildings, models, etc. as Gameobjects within the WoW Private Server Emulation board part of the WoW Private Servers category; I am posting this because it's epic. It is not from this site and I take NO CREDIT for any ...

Results 1 to 5 of 5
  1. #1
    Matt's Avatar
    Matt is offline Bott


    Array
    Join Date
    Jun 2010
    Posts
    5,404
    Mentioned
    182 Post(s)
    Tagged
    1 Thread(s)
    Rep Power
    21
    Reputation
    2346

    Sql/Patch- All buildings, models, etc. as Gameobjects

    I am posting this because it's epic. It is not from this site and I take NO CREDIT for any of it. I jsut wish to share it with you guys because it is really fricken usefull.
    All credit goes to

    Razmataz and Dark_Spyro_003
    from ownedcore.com

    If you have any questions regarding it, You can send them a messege or I can talk to them personally.



    This had started out as a project ran by Razmataz and Dark_Spyro_003, adding the most important buildings and doodads as Gameobjects into the game, objects that are normally not spawneable in that way. They added these by manually adding entries to gameobjectdisplayinfo.dbc.
    The longer this lasted, the harder and more tiring this became. After ~2200 entries, Razmataz thought about somehow automizing the system.
    Dark_Spyro_003 wrote a rather complicated program that would write all model entries from WoW's MPQs into the DBC file, which is presented to you here.

    Instructions: Wrath of the Lich King ONLY
    Download this patch, which all users require to be able to view these objects in the game world as spawned gameobjects. You need to put this into your World of Warcraft\Data folder for it to work.

    Additionally, you'll need to unpack and execute the SQL batch in this zip (ArcEmu, TrinityCore or MaNGOS) into your database.
    Ontop of that, you need to download this file, unzip it, and replace the original dbc file with this one!

    This patch contains 29324 additional gameobjects for Wrath of the Lich King.
    Full list for WoTLK: click here!


    Instructions: Cataclysm ONLY
    Download (and unpack the 7zip file) this patch, which all users require to be able to view these objects in the game world as spawned gameobjects. You need to put this into your World of Warcraft\Data folder for it to work.

    Additionally, you'll need to unpack and execute the SQL batch in this 7zip SkyFireEMU into your database.
    Ontop of that, you need to download (and unpack the 7zip file) this file, unzip it, and replace the original dbc file with this one!

    For using our patch in Cataclysm, you (and your end user) also needs to have a custom World of Warcraft client, specifically for our patch.
    To make this, you'll need to download http://www.ownedcore.com/forums/worl...n-remover.html for 4.0.6a
    - Disable "signaturefile" checks (to make the patch load)
    - Disable "Second socket at connection" (To be able to login to private servers)

    This patch contains 39469 additional gameobjects for Cataclysm.
    Full list for Cataclysm: click here!


    You'll be able to spawn every single thing available in the game world then, from beds from the most random races, to instances, to cities, to the most beautifull houses, to anything you can find in WMV.
    Even skyboxes can be spawned.

    Note: If you wish to (re)distribute this patch, please explicitely give credits to Dark_Spyro_003 and Razmataz, AND link to this specific page. Thank you!

    Note: The SQL batch file deletes all custom objects between 500000 and 553188 and between 4000000 and 4002169 in order for the batch file to execute without errors.




    More screenshots:
    http://img85.imageshack.us/img85/512...0310140214.jpg
    http://img406.imageshack.us/img406/5...0310140207.jpg
    http://img85.imageshack.us/img85/370...0310140156.jpg
    http://img683.imageshack.us/img683/8...0310140111.jpg
    http://img683.imageshack.us/img683/6...0310140055.jpg
    http://img526.imageshack.us/img526/2...0310140020.jpg
    http://img526.imageshack.us/img526/3...0310140013.jpg
    http://img263.imageshack.us/img263/1...0310140003.jpg
    http://img406.imageshack.us/img406/9...0310135944.jpg
    http://img406.imageshack.us/img406/2...0310135937.jpg

    The spawnIDs range from 500000 to 553188.
    Legacy SpawnIDs 4000000 to 4002169 still work.



    __________________________________________________ ___________________
    [Posted at 20:42 GMT 2011-08-30]


    An update has been released :: Cataclysm 4.0.6a FULL version
    WARNING: Cataclysm works differently with patches. Although this is no longer a test version, I'm still not responsible if it breaks your server or your WoW game. It should work fine for everyone, but I cannot guarantee that.
    Changelog:
    - Added all new Cataclysm GameObjects (10145 Game objects)
    - Downloads: MPQ (7z), SQL (7z), DBC (7z): Unpack the MPQ 7zip and Place the MPQ in WoW/Data folder. Unpack the SQL 7zip file and execute the file onto your world database. The DBC 7z file should be unpacked and the resulting DBC goes into the dbc folder of your SkyfireEMU server. If you forget this last step, the emulator will state the gameobject data is invalid.

    Additional instructions:
    You'll need to download http://www.mmowned.com/forums/world-...n-remover.html for 4.0.6a
    - Disable "signaturefile" checks (to make the patch load)
    - Disable "Second socket at connection" (To be able to login to private servers)

    __________________________________________________ ___________________
    [Posted at 15:28 GMT 2011-06-03]


    An update has been released :: Cataclysm 4.0.6a
    WARNING: This is a test version of the patch. I'm not responsible if it breaks your server or your WoW game. It should work fine for everyone, but I cannot guarantee that.
    Changelog:
    - Support for SkyfireEMU only (for the moment, I don't know any other Cataclysm emulators)
    - Support for WoW version 4.0.6a (13623) only
    - This patch is a test version, and it hasn't been tested on: usUS (USA) clients. Please report if this is broken in the USA.
    - Not all cataclysm objects have been added yet (like I said, this is a test version)
    - Downloads: MPQ, SQL (7z), DBC: Place the MPQ in WoW/Data folder. Unpack the 7zip file and execute the file onto your world database. The DBC file goes into the dbc folder of your SkyfireEMU server. If you forget this last step, the emulator will state the gameobject data is invalid.

    Additional instructions:
    You'll need to download http://www.mmowned.com/forums/world-...n-remover.html for 4.0.6a
    - Disable "signaturefile" checks (to make the patch load)
    - Disable "Second socket at connection" (To be able to login to private servers)

    __________________________________________________ ___________________
    [Posted at 17:04 GMT 2010-12-22]


    An update has been released :: Additional emulators supported
    Changelog:
    - Support for TrinityCore added (SQL)
    - Support for MaNGOS added (SQL)
    - Updated the list of game-objects to something which is hopefully slightly better useable.
    - New emulator support: some emulators require our custom DBC, feel free to download it here.

    __________________________________________________ ___________________
    [Posted at 22:27 GMT 2010-08-04]


    An update has been released :: 335_001 (3.3.5 #1)
    You have two options on how to perform the update:
    Either install from scratch (follow default installation instructions, takes longer)
    or execute the update:
    - You still need to download the WoW patch at the standard location (see above)
    - Execute this SQL batch file to update your database.

    Changelog:
    - These objects have now been made spawneable: Click Me!!
    - Here's the full list of spawneable objects: Clicky
    - In initial release, I forgot to remove the "000.wmo" crashy WMOs. These have been removed aswell, just like their other numbered brethren!



    AGAIN:

    All credit goes to
    Razmataz and Dark_Spyro_003
    from ownedcore.com
    @kent





  2. The Following 2 Users Say Thank You to Matt For This Useful Post:


  3. #2
    <GM>Bumblebee's Avatar
    <GM>Bumblebee is offline I'm The Good Bee :)



    Array
    Join Date
    May 2010
    Location
    Palmdale,CA
    Posts
    1,908
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    13
    Reputation
    1146
    I remember using this myself not to long ago nice share!

    Click here To see all my Tutorials and get Help.

  4. #3
    Matt's Avatar
    Matt is offline Bott


    Array
    Join Date
    Jun 2010
    Posts
    5,404
    Mentioned
    182 Post(s)
    Tagged
    1 Thread(s)
    Rep Power
    21
    Reputation
    2346
    I used it on multiple occasions for world/city building.
    @kent





  5. #4
    Zacro's Avatar
    Zacro is offline WoW Leveling Services

    Array
    Join Date
    May 2010
    Location
    Ohio
    Posts
    1,673
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    11
    Reputation
    691
    very nice post. This may come in handy soon.

  6. #5
    Matt's Avatar
    Matt is offline Bott


    Array
    Join Date
    Jun 2010
    Posts
    5,404
    Mentioned
    182 Post(s)
    Tagged
    1 Thread(s)
    Rep Power
    21
    Reputation
    2346
    Quote Originally Posted by Zacro View Post
    very nice post. This may come in handy soon.

    I started using it on more complex projects. Such as a rebuild of my old Battle of hillsbrad. I'll upload some pictures for a whole new thread a bit later.
    @kent





Similar Threads

  1. Antihack against invincible buildings or new dh
    By Hatd in forum Warcraft 3 forum
    Replies: 2
    Last Post: 02-10-2010, 10:34 PM
  2. What about buildings?
    By razathru in forum Farmville forum
    Replies: 0
    Last Post: 01-04-2010, 04:09 PM
  3. Buildings
    By fizban in forum WoW forum
    Replies: 0
    Last Post: 11-02-2009, 12:51 AM
  4. how to que buildings for Hu.
    By DiscoInferno in forum Warcraft 3 forum
    Replies: 11
    Last Post: 05-28-2007, 01:59 AM
  5. Speed up your buildings!
    By aLLo- in forum Warcraft 3 forum
    Replies: 4
    Last Post: 05-01-2007, 01:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •