[Sql/Patch] All buildings, models, etc. as Gameobjects

[Halo636]

Could you please try running this SQL in your world database and then restarting your server to see if it helps? I can't test it right now --

UPDATE `gameobject_template` SET type = 10 where entry between 500000 and 553188 and type = 5;
UPDATE `gameobject_template` SET type = 10 where entry between 4000000 and 4002169 and type = 5;

Best of luck!

This did not fix the issue. Now I just get the golden gear as if an action was possible. The highlighting and tooltip still occurs.
I tried changing them all to type 14 although this just presented me with most of the objects not spawning.

Here is the list of each GameObject_Template.Type

GAMEOBJECT_TYPE_DOOR = 0
GAMEOBJECT_TYPE_BUTTON = 1
GAMEOBJECT_TYPE_QUESTGIVER = 2
GAMEOBJECT_TYPE_CHEST = 3
GAMEOBJECT_TYPE_BINDER = 4
GAMEOBJECT_TYPE_GENERIC = 5
GAMEOBJECT_TYPE_TRAP = 6
GAMEOBJECT_TYPE_CHAIR = 7
GAMEOBJECT_TYPE_SPELL_FOCUS = 8
GAMEOBJECT_TYPE_TEXT = 9
GAMEOBJECT_TYPE_GOOBER = 10
GAMEOBJECT_TYPE_TRANSPORT = 11
GAMEOBJECT_TYPE_AREADAMAGE = 12
GAMEOBJECT_TYPE_CAMERA = 13
GAMEOBJECT_TYPE_MAP_OBJECT = 14
GAMEOBJECT_TYPE_MO_TRANSPORT = 15
GAMEOBJECT_TYPE_DUEL_ARBITER = 16
GAMEOBJECT_TYPE_FISHINGNODE = 17
GAMEOBJECT_TYPE_RITUAL = 18
GAMEOBJECT_TYPE_MAILBOX = 19
GAMEOBJECT_TYPE_AUCTIONHOUSE = 20
GAMEOBJECT_TYPE_GUARDPOST = 21
GAMEOBJECT_TYPE_SPELLCASTER = 22
GAMEOBJECT_TYPE_MEETINGSTONE = 23
GAMEOBJECT_TYPE_FLAGSTAND = 24
GAMEOBJECT_TYPE_FISHINGHOLE = 25
GAMEOBJECT_TYPE_FLAGDROP = 26
GAMEOBJECT_TYPE_MINI_GAME = 27
GAMEOBJECT_TYPE_LOTTERY_KIOSK = 28
GAMEOBJECT_TYPE_CAPTURE_POINT = 29
GAMEOBJECT_TYPE_AURA_GENERATOR = 30
GAMEOBJECT_TYPE_DUNGEON_DIFFICULTY = 31
GAMEOBJECT_TYPE_BARBER_CHAIR = 32
GAMEOBJECT_TYPE_DESTRUCTIBLE_BUILDING = 33
GAMEOBJECT_TYPE_GUILD_BANK = 34

As I mentioned earlier I already tried 14 but it made a lot of the gameobjects vanish (when spawned the GUID was there although the object was not visible).

[antodan323]

[post redacted]

[Immortalgspot]

You know how when you get a certain distance away they disappear anyway to fix that? I mean isn't a big deal but a hella lot easier than Noggit :P

[Tommyruin]

great release

[tippythop]

For those of you having issues with the tooltips, run this sql and delete your cache folder.

UPDATE `gameobject_template` SET data0 = false where entry between 500000 and 553188 and type = 5;
UPDATE `gameobject_template` SET data0 = false where entry between 4000000 and 4002169 and type = 5;
UPDATE `gameobject_template` SET data1 = false where entry between 500000 and 553188 and type = 5;
UPDATE `gameobject_template` SET data1 = false where entry between 4000000 and 4002169 and type = 5;

It takes the flags for tooltips and glowing and disables them.

If you're on mangos or trinity just edit object.h in your mangos or trinity src folder under game. In object.h youll find max_visibility_distance its usually set at 333.0f set that to say....99999. Then go into your server config and edit the visibility distance.

[c0rfairy]

Any updates or information on whether Mac users will be able to use this and/or see the objects spawned?

[husky999]

It is possible to give some of this objects like NPC shape?

[Androus]

Thank you Iotech, your SQL worked perfectly on my Trinity 4.3.4. However, the DBC file is not formatted for the 4.3.4 Trinity core. When one tries to use the DBC file on the core, it causes the World to freeze and shut down 9/10 times. It also makes it bug to where you cannot see any NPC's or type anything in say, guild, yell, general chat, etc.

I replaced the DBC file I downloaded from here for Cata with the original DBC file, and the core became nearly 100% stable with no side effects.

Now I have all of the [Patch] objects, minus the 'bad' ones, but cannot use the provided DBC file to get the game to recognize the ID's for the custom objects.

Does anyone have a suggestion on how to pull the DBC file for the custom game objects onto a trinity core DB 4.3.4 Version 15595?

Thanks Spyro and Raz for the hard work, it must have taken a while. Also thank you Ion. Any help with the DBC file problem would be greatly appreciated.


Problem SOLVED. Thanks <3

[Dark_Spyro_003]

Okay, to start off, I'm quite busy with college and do not officially support the patch anymore (as may have been noted by my very infrequent visits). I'll answer some questions though.

Any updates or information on whether Mac users will be able to use this and/or see the objects spawned?

This patch works as fine on mac as it works on windows. You just need a correctly patched client, and with available tools it is not difficult to make.

It is possible to give some of this objects like NPC shape?

You can spawn NPCs with special models such as the lich king. You cannot (correctly) spawn regular races such as humans or orcs, since they show all geosets and do not load a skin.

Thank you Iotech, your SQL worked perfectly on my Trinity 4.3.4. However, the DBC file is not formatted for the 4.3.4 Trinity core. When one tries to use the DBC file on the core, it causes the World to freeze and shut down 9/10 times. It also makes it bug to where you cannot see any NPC's or type anything in say, guild, yell, general chat, etc.

I replaced the DBC file I downloaded from here for Cata with the original DBC file, and the core became nearly 100% stable with no side effects.

Now I have all of the [Patch] objects, minus the 'bad' ones, but cannot use the provided DBC file to get the game to recognize the ID's for the custom objects.

Does anyone have a suggestion on how to pull the DBC file for the custom game objects onto a trinity core DB 4.3.4 Version 15595?

Thanks Spyro and Raz for the hard work, it must have taken a while. Also thank you Ion. Any help with the DBC file problem would be greatly appreciated.


Problem SOLVED. Thanks <3

Glad to see your problem is solved for those who are curious, I've put up an 'unsupported' version for 4.3.4 which Raz kindly helped to make.

Thank you for all your support. I'm sorry for my extremely late replies in some cases, but I'm busy and don't frequent WoW development anymore.

Best of luck!

[tyeeeee1]

I've been trying to fix this issue for the past two hours or so, but I'm having no luck whatsoever.

When I mouse over certain Gameobjects, their names, from the database, are showing up in a small tooltip along with the entire object being highlighted. This seemed like a fairly easy fix, so I went to the TrinityCore wiki and carefully combed through the information on the gameobject_template section in an attempt to fix any and all custom Gameobjects from this release. The queries executed flawlessly and updated all of the Gameobjects from the release. Upon restarting worldserver I logged in and to my dismay, the tooltips continued to show up.

I've googled around for a little bit, but I haven't found much. I have tried using both the 4 and 16 flags, but they make no difference. The one fix which may work according to this thread would require me to remove the names of each and every gameobject. I absolutely refuse to remove the names as they're necessary to know what each object is.

If anyone has a suggestion on how I might be able to fix this issue, that would be greatly appreciated.


Here is the code I used to update the Gameobjects:

UPDATE gameobject_template SET flags = 1 , data0 = 1, data1 = 3000, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0 WHERE entry >= 4000000 AND `type` = 0;
UPDATE gameobject_template SET flags = 1, data0 = 1, data1 = 0, data2 = 1, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0 WHERE entry >= 4000000 AND `type` = 1;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0 WHERE entry >= 4000000 AND `type` = 2;
UPDATE gameobject_template SET flags = 1, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 1, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0 WHERE entry >= 4000000 AND `type` = 3;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 4;
UPDATE gameobject_template SET flags = 16, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 5;
UPDATE gameobject_template SET flags = 1, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 6;
UPDATE gameobject_template SET flags = 1, data0 = 1, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 7;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 8;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 9;
UPDATE gameobject_template SET flags = 16, data0 = 0, data1 = -1, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 10;
UPDATE gameobject_template SET flags = 8, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 11;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 12;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 13;
UPDATE gameobject_template SET flags = 16, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 14;
UPDATE gameobject_template SET flags = 8, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 15;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 16;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 17;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 18;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 19;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 20;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 21;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 22;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 23;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 24;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 25;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 26;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 27;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 28;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 29;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 30;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 31;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 32;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 33;
UPDATE gameobject_template SET flags = 0, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 34;
UPDATE gameobject_template SET flags = 1, data0 = 0, data1 = 0, data2 = 0, data3 = 0, data4 = 0, data5 = 0, data6 = 0, data7 = 0, data8 = 0, data9 = 0, data10 = 0, data11 = 0, data12 = 0, data13 = 0, data14 = 0, data15 = 0, data16 = 0, data17 = 0, data18 = 0, data19 = 0, data20 = 0, data21 = 0, data22 = 0, data23 = 0  WHERE entry >= 4000000 AND `type` = 35;

Edit:
Deleting my Cache after executing the query above does nothing.

[bardh]

Hi guys. I'm not good at these (scripting,mysql etc.). I have used gameobject patch earlier on a private server(paradox wow, doesn't exist anymore) and I just had to copy/paste patch-D.mpq to data folder and it worked, now I have created my own private server (arcemu 3.3.5), and I'm trying to be able to use this patch on my server...but the problem is that i don"t understand this::Additionally, you'll need to unpack and execute the SQL batch in this zip (ArcEmu, TrinityCore or MaNGOS) into your database.
On top of that, you need to download this file, unzip it, and replace the original dbc file with this one!. Can somebody show me cuz i dont know how to execute the SQL batch?
Thanks anyway!

[bardh]

Help!
Hi guys. I'm not good at these (scripting,mysql etc.). I have used gameobject patch earlier on a private server(paradox wow, doesn't exist anymore) and I just had to copy/paste patch-D.mpq to data folder and it worked, now I have created my own private server (arcemu 3.3.5), and I'm trying to be able to use this patch on my server...but the problem is that i don"t understand this::Additionally, you'll need to unpack and execute the SQL batch in this zip (ArcEmu, TrinityCore or MaNGOS) into your database.
On top of that, you need to download this file, unzip it, and replace the original dbc file with this one!. Can somebody show me cuz i dont know how to execute the SQL batch?
Thanks anyway!

[bardh]

Link is not working! Can you post it somewhere else...like mediafire.
Thanks

[BeefPie]

I installed the (admittedly unsupported) 4.3.4 version. I can't see the objects >.<

I've put the MPQ into the WoW data folder, I've run the SQL and replaced the DBC in the server. When I spawn them the usual lines come up about the GUID, rotation, ID etc.

Any help?

[Razmataz]

To your issue, BeefPie, make sure you have a custom patched client so that the patch doesn't auto-delete. Another problem is that a massive amount of the 4.3.4 clients do not support custom patches for whatever reasons I cannot explain. I've only found one so far.

If you're still having problems with highlightable objects, my server which has the 4.3.4 patch version uses this variant:

UPDATE `gameobject_template` SET type = 10 where entry between 500000 and 553188 and type = 5;
UPDATE `gameobject_template` SET type = 10 where entry between 4000000 and 4002169 and type = 5;
UPDATE `gameobject_template` SET data1 = -1 where entry between 500000 and 553188 and type = 10;
UPDATE `gameobject_template` SET data1 = -1 where entry between 4000000 and 4002169 and type = 10;

The result is;

537119 10 58881 Helm_Robe_DungeonRobe_C_01_DrF.M2 [PATCH] 0 0 0 0 0 0 0 0 0 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1