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 viaas 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 :PCode:.go <ID> 1
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
the game will print out the SQL ID needed to find the gameobject inside the gameobject_spawns table.Code:.go select .go info
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.