Thread: ArcEmu vechicles!

This is not created by me or Mmotop staff!

Posted by dfighter 05 September 2011 - 07:44 PM on ArcEmu's offical site.

Hi there!
As you might have noticed, some time ago I started working on vehicles.
Finally they are working somewhat.
If you want to help in the development, feel free to check out my branch and post bug reports, or suggestions.

In order to help or just try them you need to check out my branch, to do that you have to use a different SVN address.

[Only registered and activated users can see links. ]

You can build it the very same way as you would build Arcemu otherwise.
The difference is, you need to apply some DB changes for this to work, so you are strongly urged to make a copy of your world database and apply these on that :)
You will have to apply the following db updates for this branch to work:

Structure

ALTER TABLE `creature_proto` ADD COLUMN `vehicleid` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `spelldataid`;
UPDATE `arcemu_db_version` SET `LastUpdate` = '4429';

ALTER TABLE `creature_proto` ADD COLUMN `spell5` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `spell4`, ADD COLUMN `spell6` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `spell5`, ADD COLUMN `spell7` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `spell6`, ADD COLUMN `spell8` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `spell7`, CHANGE `spell1` `spell1` INT UNSIGNED DEFAULT '0' NOT NULL, CHANGE `spell2` `spell2` INT UNSIGNED DEFAULT '0' NOT NULL, CHANGE `spell3` `spell3` INT UNSIGNED DEFAULT '0' NOT NULL, CHANGE `spell4` `spell4` INT UNSIGNED DEFAULT '0' NOT NULL;
UPDATE `arcemu_db_version` SET `LastUpdate`='4533';

CREATE TABLE `vehicle_accessories` (
`creature_entry` int(10) unsigned NOT NULL DEFAULT '0',
`accessory_entry` int(10) unsigned NOT NULL DEFAULT '0',
`seat` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`creature_entry`,`accessory_entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

UPDATE `arcemu_db_version` SET `LastUpdate` = '4553';

ALTER TABLE `creature_proto` ADD COLUMN `rooted` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `vehicleid`;
UPDATE `arcemu_db_version` SET `LastUpdate` = '4583';

Vehicle IDs
[Only registered and activated users can see links. ]

Spells
[Only registered and activated users can see links. ]

Vehicle Accessories
[Only registered and activated users can see links. ]

( The vehicle IDs, spells and vehicle accessories are all from TDB, so credits go to them )

Known Issues

• When in a group, the group frame for group members on a vehicle is messed up
• On the client of the controller, it looks like projectiles are fired twice ( in reality it's just a visual bug )
• Sometimes there are weird spells on the vehicle spellbar, when in reality there are no spells ( it's a visual bug as well )

How can you use them?

You can use them by spawning a vehicle, and going close to it. When you move your mouse pointer over the vehicle NPC, it will show a green arrow, if you click it, your character will hop on the vehicle. Just like on the video above!


Vehicles I've tried
Havenshire Stallion ( 28605 )
Wintergrasp Siege Engine ( alliance version ) ( 28312 )
Frostbrood Vanquisher ( 28670 )


You can spawn them with the .npc spawn GM command!

Have fun!

99.9% credits to ArcEmu and 0,01% credits to me for share! :)

Can anyone please try this and tell me if its working? Send me a picture of it and i will +rep you :)