Catalyst v2.5 Goblin error's?

[CursedOne]

Does anyone actually know how to make it so goblins can speak & equip stuff?

[Haith]

I haven't actually used Catalyst Repack (or any repack for that matter ), but I believe that it uses a MaNGOS core.

If it is in fact a MaNGOS core, you'll want to go into the database and find the playercreateinfo_spell table.

Once in that table, you want to add 10 new rows (1 for each class), with the race column being set to 9 the class column being set to 1-10 (increasing from 1, each row) and the "Spell" column set to 669 (this is the orcish language spell). The note column is optional, but if you want to keep your DB clean, you can put "Orcish" in the notes for each row. This will allow your goblins to speak orcish, upon creation.

As far as the gear equipping goes, that is a core issue which I am unable to help out with, unfortunately. I do know, however, that some cores out there do have goblin equipment working. One core I know has this feature is Fabi's DiamondCore which can be found here:

Fabi's diamondcore at master - GitHub

Hope this helps!

-Haith

[Edit]:: Actually, I decided to just quickly write up an SQL query that will do the languages for you.

REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '1', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '2', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '3', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '4', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '5', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '6', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '7', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '8', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '9', '669', 'Orcish');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '10', '669', 'Orcish');

[CursedOne]

Thank you so much I wish other people here would be as helpful as you :P
Would it be possible if I changed the orcish to the common one so that every player can chat?

[Haith]

No problem

You could make them learn common, which is 668, rather than 669. The alternative, is changing "AllowTwoSide.Interaction.Chat" in the mangosd.conf file. I believe this would do the same, but both work equally well.

-Haith

[CursedOne]

I tried that but it still wouldnt let my gobo talk so I thought this would work and it did
I'm going to see if I can use this in the DB to make them be able to equip weapons maybe?

---------- Post added at 05:40 PM ---------- Previous post was at 05:12 PM ----------

Hey I got the armour and weapons to work on goblin but I have to type .learn all when I logon and it give my chars the gm spells and stuff..
Is there a way I could make it so all the class's in goblin can automatically learn combat skill - cloth/leather/mail/plate - dagger/fist/stave etc but what they should actually be
Also when I put the helmet's on my goblins it comes up with a blue and white box thing is this to do with the core or something else?

---------- Post added at 05:41 PM ---------- Previous post was at 05:40 PM ----------

Edit: I tried adding it to the db with that sql code you gave me but it didnt work i dont think

[Haith]

Ohh, I wasn't aware that your problem was the item proficiencies. I figured your client crashed upon equip :P

You're going to want to use the same format SQL query, but just change up the 669 in it. You will need to make rows, once again, for class #1-10, and race 9, but this time add in the proficiency spells where the language spell ID's were previously.

For example, you will put in a

REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '5', '750', 'Plate Mail');

This will give class #5 (whatever that may be) the ability to wear plate armor (spell ID 750), upon character creation.

Give this a shot

-Haith

[Edit]: And regarding the blue box, that is a miscommunication between the client and the server, as to which model to display. I don't personally know how to fix this, but it likely can be done.

And just to be helpful, I grabbed the ID's out of my mangos source

So basically match all the appropriate item skill ID's up with their classes, and execute many, many SQL queries lol.

Class ID's:

    CLASS_WARRIOR       = 1
    CLASS_PALADIN       = 2
    CLASS_HUNTER        = 3
    CLASS_ROGUE         = 4
    CLASS_PRIEST        = 5
    CLASS_DEATH_KNIGHT  = 6
    CLASS_SHAMAN        = 7
    CLASS_MAGE          = 8
    CLASS_WARLOCK       = 9
    CLASS_DRUID         = 11

Item Skill ID's:

                ITEM_SUBCLASS_WEAPON_AXE:     196
                ITEM_SUBCLASS_WEAPON_AXE2:    197
                ITEM_SUBCLASS_WEAPON_BOW:     264
                ITEM_SUBCLASS_WEAPON_GUN:     266
                ITEM_SUBCLASS_WEAPON_MACE:    198
                ITEM_SUBCLASS_WEAPON_MACE2:   199
                ITEM_SUBCLASS_WEAPON_POLEARM: 200
                ITEM_SUBCLASS_WEAPON_SWORD:   201
                ITEM_SUBCLASS_WEAPON_SWORD2:  202
                ITEM_SUBCLASS_WEAPON_STAFF:   227
                ITEM_SUBCLASS_WEAPON_DAGGER:  1180
                ITEM_SUBCLASS_WEAPON_THROWN:  2567
                ITEM_SUBCLASS_WEAPON_SPEAR:   3386
                ITEM_SUBCLASS_WEAPON_CROSSBOW:5011
                ITEM_SUBCLASS_WEAPON_WAND:    5009

                ITEM_SUBCLASS_ARMOR_CLOTH:    9078
                ITEM_SUBCLASS_ARMOR_LEATHER:  9077
                ITEM_SUBCLASS_ARMOR_MAIL:     8737
                ITEM_SUBCLASS_ARMOR_PLATE:    750
                ITEM_SUBCLASS_ARMOR_SHIELD:   9116

[CursedOne]

:d thanks so much I tried what you said about adding the rows. I made a new char but it only has the languages in the skills tab :/ Ill try your code now and see what happens

---------- Post added at 11:49 AM ---------- Previous post was at 11:25 AM ----------

Didnt work mate,,
I dont know why it worked the first time and now it wont :confused:
Im going to reset the DB and try do it all again Lucky if it works though

[Haith]

Did you execute my SQL query for each class? Or just the one I linked; cause that one specifically gives Goblin Priests the Plate skill upon creation, and doesn't do anything for the other classes.

-Haith

[CursedOne]

No I used the other code the long one and changed the spell ID
Will it only work if the Notes are different because ive been just leaving the note as orcish,
Any ideas?

---------- Post added at 12:12 PM ---------- Previous post was at 12:11 PM ----------

Will it just write over the one with the note as orcish

[Haith]

Gah, that really should work, even without the note change >.<

Could you post the new query you made so I can look through it?

[CursedOne]

REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '1', '750', 'te Mail');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '2', '750', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '3', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '4', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '5', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '6', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '7', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '8', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '9', '9078', 'Cloth');
REPLACE INTO playercreateinfo_spell (`race`, `class`, `Spell`, `Note`) VALUES('9', '10', '9078', 'Cloth');

It says 1 row affected is that right?

[Haith]

Looked that over, and it should be working : \

You may however, be using a newer MaNGOS rev than me, does your playecreateinfo_spell table have only 4 columns? Or has it been updated since I last fixed mine.

-Haith

---------- Post added at 12:54 PM ---------- Previous post was at 12:46 PM ----------

Maybe replace into isn't what we want to use here.

Try this:

INSERT  INTO `playercreateinfo_spell`(`race`,`class`,`Spell`,`Note`) VALUES
(9,1,750,'Plate Mail'),
(9,2,750,'Plate Mail'),
(9,3,750,'Plate Mail'),
(9,4,750,'Plate Mail'),
(9,5,750,'Plate Mail'),
(9,6,750,'Plate Mail'),
(9,7,750,'Plate Mail'),
(9,8,750,'Plate Mail'),
(9,9,750,'Plate Mail'),
(9,11,750,'Plate Mail');

[Edit]: I tried running my INSERT INTO query on a clean DB, and it worked perfectly. Hopefully yours does the same!

[CursedOne]

It's only got 4 columns the same as in that query ill try that now

---------- Post added at 04:15 PM ---------- Previous post was at 04:04 PM ----------

This time seems to have gone nicely it said all 10 rows instead of just the 1 =)

[Haith]

Woohoo lol.

Took some effort, but sounds like you finally got it

[CursedOne]

Apart from I don't think its working ingame ;/