ArcEmu: Gameobject always Visible, at any distance, whenever and wherever menu

User Tag List

Results 1 to 12 of 12
  1. #1
    ScDK's Avatar Contributor
    Reputation
    119
    Join Date
    Dec 2007
    Posts
    96
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ArcEmu: Gameobject always Visible, at any distance, whenever and wherever

    So, most of you might have run into the annoying issue of gameobjects disappearing after you leave the zone for a while or relog.
    Or the disappointment of your custom town appearing only after you've walked up close enough for the buildings to randomly pop up on the map? Sucks, really...


    Well, this no longer needs to be the case!

    The solution to this lies inside your DB, and it will require that you have a SQL editor and actual access to the server's SQL database.

    So, how does this work?

    Step 1:
    Spawn your Game object via
    Code:
    .go <ID> 1
    as you know, by doing so, it writes the GO into your database to spawn it upon server restart. Adjust things like scale, placement, rotation, etc until you're happy, as editing this later won't be so straightforward :P


    Step 2:
    Given that deleting entries in the SQL table sometimes causes the most recent spawn to appear somewhere in the gaps created by deleting other entries, we need to know the entry ID of the object. So type
    Code:
    .go select
    .go info
    the game will print out the SQL ID needed to find the gameobject inside the gameobject_spawns table.


    Step 3: Depending on if your SQL client has the filter function (I personally got Navicat and Navicat Lite, and the Lite version lacks this feature), you can either order the list by the "entry" column, or filter it by entering the exact ID you got from the game. Either way, find the ID on hand inside the table.


    Step 4: Once you found the GO, copy the whole line. Now open the gameobject_staticspawns table, and paste the line there.


    Step 5: Delete the line from your gameobject_spawns and restart your server.

    If everything worked out fine, your GO should now be static, appearing like an actual map object, rather than a interactive gameobject.


    Now, note this:
    ArcEmu currently has no control over static gameobjects. You won't be able to select it ingame anymore, or interact with it in any way. To edit or delete it, you will have to make changes to the Gameobject_staticspawns table and restart, or, easier but needing to restart the server several times, cut and paste it back to the normal gameobject_spawns table, restart, adjust things, and then move it back, and restart again.

    I do not have screenshots at hand, since the private server i've been working is currently unavailable, but i assure you it's working, perfectly.
    Last edited by ScDK; 01-21-2011 at 11:22 AM.

    ArcEmu: Gameobject always Visible, at any distance, whenever and wherever
  2. #2
    DarkVanir's Avatar Master Sergeant
    Reputation
    25
    Join Date
    Jul 2010
    Posts
    126
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Perfect, exactly what I needed. Rep cookiez added for you.
    Γαια αγια

  3. #3
    Xees's Avatar Contributor

    Reputation
    92
    Join Date
    Aug 2009
    Posts
    189
    Thanks G/R
    0/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    its actually not true that you can make it a static gameobject , since its not coded inside each users copy of wow .

    but you can make it spawn on the server when its started , but players would still need to load it when they come near it , and lagged players might not see it
    Doooooo+Repoooooooo+Repoooooood

  4. #4
    ScDK's Avatar Contributor
    Reputation
    119
    Join Date
    Dec 2007
    Posts
    96
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Xees View Post
    its actually not true that you can make it a static gameobject , since its not coded inside each users copy of wow.
    Well, it works like one, which is what really matters here. So minor details like that are unimportant.
    Originally Posted by Xees View Post
    ... but players would still need to load it when they come near it , and lagged players might not see it
    With "near it" meaning Stormwind City, while it's placed in Duskwood. It spawns along with the map, and is visible at the same distance as the distance of the fog allows.
    And i don't think anyone lags THAT bad that they will not see a static spawn by the time the loading screen disappears.

  5. #5
    Frezer's Avatar Sergeant
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    43
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    how it is in trinity ? i need this guide too but for trinity =(

  6. #6
    ScDK's Avatar Contributor
    Reputation
    119
    Join Date
    Dec 2007
    Posts
    96
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Frezer View Post
    how it is in trinity ? i need this guide too but for trinity =(
    I sadly have never worked with Trinity, but if their world DB has any gameobject_spawns or similar table, and a _static version of it, it should basically be the same treatment.

  7. #7
    shadowknight513's Avatar Knight
    Reputation
    11
    Join Date
    Apr 2008
    Posts
    197
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you, I will be using this in my server. +Rep to you sir.

  8. #8
    AZO's Avatar Banned
    Reputation
    370
    Join Date
    Mar 2007
    Posts
    621
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I thought this was common knowledge... I hope all of you haven't been spawning your game objects without putting a 1 behind them...

  9. #9
    zarrion11's Avatar Member
    Reputation
    2
    Join Date
    Dec 2008
    Posts
    33
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome. Thank you

  10. #10
    MadameGrip's Avatar Contributor

    Reputation
    150
    Join Date
    Aug 2010
    Posts
    528
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is kinda derp I thought it was for the view distance, and then it was something as silly as the save function xD

  11. #11
    Atlamillia's Avatar Private
    Reputation
    3
    Join Date
    Dec 2013
    Posts
    14
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there any way to mass do this?

  12. #12
    Atlamillia's Avatar Private
    Reputation
    3
    Join Date
    Dec 2013
    Posts
    14
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bumping :P!

Similar Threads

  1. [ArcEmu 3.3.2][lua] Vendor gossip question and going beyond 80?
    By xyrusazabi in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 03-13-2010, 02:43 PM
  2. [ArcEmu] Players don't make any threat on mobs
    By SirRFI in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 08-17-2009, 11:37 AM
  3. ArcEmu WOTLK Compiles with dbc, wotlk scripts . restarted and DB
    By Fantomass in forum WoW EMU General Releases
    Replies: 0
    Last Post: 12-15-2008, 06:42 PM
  4. Always get out of over agro and instances with 100 mobs on you
    By nexes1337 in forum World of Warcraft Exploits
    Replies: 13
    Last Post: 07-09-2008, 08:35 AM
  5. [2.4] Pull any mob from any distance.
    By Ball in forum World of Warcraft Exploits
    Replies: 27
    Last Post: 04-14-2008, 04:07 AM
All times are GMT -5. The time now is 03:12 AM. 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