[Ascent/SQL Editing] How to add a weapon/shield/armor to a NPC?

[earthful]

Hello everyone,

I've used search button but nothing came up... also I tried using google but nothing helpful came up.

Here is my question "How can I add a weapon/shield/armor to a NPC/Creature in an Ascent server?". I need to know how the following columns to work.

Database --> creature_proto --> equipmodel1, equipinfo1, and equipslot1

Basically, I do know that equipmodel1 is the weapon display ID, but rest of them... I know nothing. If anyone can answer me or direct me to a thread that is 100% helpful then I'll +Rep you.

[The-Eradicator]

Tag your threads. Read the sticky.

[earthful]

Tag your threads. Read the sticky.

Tagged

10char

[Kiev]

EquipInfo = How it sheaths i would presume.
EquipSlot = Where it goes, such as shield weapon etc

[earthful]

EquipInfo = How it sheaths i would presume.
EquipSlot = Where it goes, such as shield weapon etc

If what you said is correct, then how do I know which values to enter in the database for correct sheathing and item slot?

Thanks for helping me out so far

[stoneharry]

It's far easier to do this in game imo, then look at how the database has changed so that you understand how it works.

.npc equip1 itemid // Item held in left hand
.npc equip2 itemid // Item held in right hand
.npc equip3 itemid // bow/gun etc, 3rd slot

.mod bytes2 0 // makes all weapons sheathed
.mod bytes2 1 // makes any items in hands unsheathed
.mod bytes2 2 // makes any items in slot 3 unsheathed

Good luck.

[earthful]

It's far easier to do this in game imo, then look at how the database has changed so that you understand how it works.

.npc equip1 itemid // Item held in left hand
.npc equip2 itemid // Item held in right hand
.npc equip3 itemid // bow/gun etc, 3rd slot

.mod bytes2 0 // makes all weapons sheathed
.mod bytes2 1 // makes any items in hands unsheathed
.mod bytes2 2 // makes any items in slot 3 unsheathed

Good luck.

I've tried that, I think its not supported on a 2.4.3 server

[stoneharry]

I've tried that, I think its not supported on a 2.4.3 server

Ah that explains a lot... You should have said.
In that case I believe you add the displayid of the item into the correct column in creature_proto, then reload + respawn npc... Might be wrong though.

[Kiev]

If that dont work (Im not sure if this was 2.4.3), but go to creature_spawns, then find the spawn ID (Can get it from .npc info), and there might be a column in it in there.

[earthful]

Ah that explains a lot... You should have said.
In that case I believe you add the displayid of the item into the correct column in creature_proto, then reload + respawn npc... Might be wrong though.

Can you read the main post again, you only answered one part of my question.

I'm still wondering how I know equipinfo1, and equipslot1 works?

[Kiev]

Look at previous mobs with this already done, then take a look at where there weapons are held, then copy that over .

I dont think there is a list for this one laying around.

[stoneharry]

Can you read the main post again, you only answered one part of my question.

I'm still wondering how I know equipinfo1, and equipslot1 works?

I didn't answer this because I didn't know, as I have said:

It's far easier to do this in game imo, then look at how the database has changed so that you understand how it works