Truice trinket creation

[shiroken]

I'm trying to create a number of powerful trinkets for my private 3.3.5a server that should allow players to solo dungeons and perhaps even raids.
I created the first one in Truice, added it to the database, and then logged in to see if and how it worked. I used the .additem command and it did appear in my inventory with the correct name, class and level restrictions, and armor, but none of the other stat bonuses I'd given it. Additionally, it equips as a Finger slot item rather than a Trinket. I double-checked the entry in HeidiSQL, but as far as I can tell, it has all the correct entries to the appropriate columns. Any ideas as to what I may have missed?

Since I'm already here, anyone know how I might make it so that only one out of all 19 of these trinkets could be equipped at one time?

[scott07]

Its possible the column "StatsCount" is set to 0, set it to 10 and it should fix the problem.

About the unique equipped, you can set the column "Flags" to 524288

[shiroken]

I took a look at the server log and found these errors:

Item (Entry: 27204) does not have a correct material (4), must be 3 .
Item (Entry: 27204) does not have a correct inventory type (12), must be 11 .
Item (Entry: 27204) does not have a correct display id (0), must be 9834 .

But I'm pretty sure those are valid values, are they not? At least for material and inventory type. I know people often have issues with the DisplayID, but it doesn't seem to be a serious problem, so I was going to handle that later.

I'll try the StatsCount fix, but 524288 is simply Unique-Equipped for that one item, no? I've already set that, but I was wondering if it was possible to make it so that if you have both the Mighty Time-Shifted Trinket of the Cyclopean Dread and the Sturdy Time-Shifted Trinket of the Cyclopean Dread, for example, you can only equip one or the other. There are items like that in WoW, but I can't think of any off the top of my head, and they may have only been added in Cata or MoP. Just checking, basically.