augs (Doodman)

[kouhei]

Doodman, Could you clarify how augs are suppose to work. I was told by FNW that you had wrote the code for augs. Could you explain to us how they work. I have heard that they are suppose to be setup like tradeskill recipes. Is this true or does the code just grab the need stats to display. Can you clarify this for us. Also does it take certain forge or any special setting for those items?

[Doodman]

Augments use the Augmentation Sealer, like on live.

There are no recipes for augmentation. It it determined on what types of slots the augmentation fits in and what types of slots the item to be augmented can hold.

If you want to do custom items and custom augments, you need to do a couple of things:
1) Adjust the augslot1type-augslot5type on the base item to set which type of augments can fit in each slot. Live uses 1-12 (I think), you can use higher than that, probably 32, but I've never topped it out.

mysql> select name,augslot1type,augslot2type,augslot3type,augslot4type,augslot5type from items where id = 92231;
+-------------------------------+--------------+--------------+--------------+--------------+--------------+
| name                          | augslot1type | augslot2type | augslot3type | augslot4type | augslot5type |
+-------------------------------+--------------+--------------+--------------+--------------+--------------+
| Grandmaster's Wealdstone Helm |            7 |           11 |           12 |            0 |            0 |
+-------------------------------+--------------+--------------+--------------+--------------+--------------+
1 row in set (0.00 sec)

So here you can see that the Grandmaster's Wealdstone Helm has 2 available slots for augmentation. Slot 1 is type 7, slot 2 is type 11 and slot 3 is type 12. Live does not (afaik) use slots 4 and 5 at all.

2) On the augments themsevles, do two things:
a) Set the augtype on the augment (It's a bitmask, bit1 = slot 1, bit 2=slot2, etc) as to which slot types the augment can fit in. Not slot numbers, but slot type numbers.
b) Set the augdistiller field to the item ID that can remove this augment from an item.

mysql> select name,augtype,augdistiller from items where id=41071;
+-----------------------------------+------------+--------------+
| name                              | augtype    | augdistiller |
+-----------------------------------+------------+--------------+
| Imperfect Opal of Illness Warding | 2147483647 |        47001 |
+-----------------------------------+------------+--------------+
1 row in set (0.01 sec)

mysql> select name from items where id=47001;
+--------------------------------+
| name                           |
+--------------------------------+
| Class I Augmentation Distiller |
+--------------------------------+
1 row in set (0.00 sec)

In this example from live, you can see that Imperfect Opal of Illness Warding fits in all slot types (2147483647 = 0b1111111111111111111111111111111) and will be removed by item ID 47001 which is the Class I Augmentation Distiller.

The client -does- validate most of this before allowing the "combine" button to highlight and be clicked. i.e. if you are not using he right distiller, it won't even let you try.

I will wiki this for future reference, after I do, I'll link the to the wiki from here.

[kouhei]

I had grabed that source on that they had on here to put a forge in nexus. In game it said it was a augment forge. When we put the correct augment in the forge and item and then click augment the system stops and when I look at zone.exe it says something to the affect. error excepeted 29 but got received 35. Those numbers are off but when I get home can post the message for you.

[Doodman]

I'll check into it.. The packet may have changed and not been recollected, PM me the error.

[kouhei]

when I place the item into the container i get.
Error in database saveworldcontainer #1136 coloum does not match value count at row 1.
I tried to use to two you pasted in the thread and it said that both would make a nodrop not usuable by you and it will not let you push the insert button. Now when I replace the helm with the warrior test BP and the same aug. It will allow you to push the insert button then it gives this error Unkown Opcode: 0x02e5 size:8 client:test
0: E8 03 00 00 FF FF FF FF

invalid size of closecontainer epected 24 got 60.

[Doodman]

Thanks for the info, I'll look into it.

The saveworldcontainer issue, looks like your object_contents table might be missing the augslot entries:

mysql> desc object_contents;
+----------+-----------------------+------+-----+---------------------+-------+
| Field    | Type                  | Null | Key | Default             | Extra |
+----------+-----------------------+------+-----+---------------------+-------+
| zoneid   | int(11) unsigned      |      |     | 0                   |       |
| parentid | int(11) unsigned      |      | PRI | 0                   |       |
| bagidx   | int(11) unsigned      |      | PRI | 0                   |       |
| itemid   | int(11) unsigned      |      |     | 0                   |       |
| charges  | tinyint(3)            |      |     | 0                   |       |
| droptime | datetime              |      |     | 0000-00-00 00:00:00 |       |
| augslot1 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot2 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot3 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot4 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot5 | mediumint(7) unsigned |      |     | 0                   |       |
+----------+-----------------------+------+-----+---------------------+-------+

On the unknown opcode, looks like you don't have the right opcode for OP_AugmentItem, try setting it to 0x02e5 and try it again.

As far as the wrong size on close container, you'd have to look at the packet and see why it's off.

You might also consider moving to a more recent version, like 0.6.3 or 0.6.4.

[kouhei]

I was plan on moving to a new version was waiting for it to be a little more stable. I believe that almost looks like my object_contents. I look at when I get home.

[kouhei]

Doodman, I tried setting OP_AugmentItem, to 0x02e5 but no change in error. I even tried another OP_code forgot name but was something I thought was close to the problem. But it seems to give that opcode as soon as you click the yes button after you click insert button. Any other suggestions? Also my objects_contents is the same as below.

Originally Posted by Doodman

Thanks for the info, I'll look into it.

The saveworldcontainer issue, looks like your object_contents table might be missing the augslot entries:

mysql> desc object_contents;
+----------+-----------------------+------+-----+---------------------+-------+
| Field    | Type                  | Null | Key | Default             | Extra |
+----------+-----------------------+------+-----+---------------------+-------+
| zoneid   | int(11) unsigned      |      |     | 0                   |       |
| parentid | int(11) unsigned      |      | PRI | 0                   |       |
| bagidx   | int(11) unsigned      |      | PRI | 0                   |       |
| itemid   | int(11) unsigned      |      |     | 0                   |       |
| charges  | tinyint(3)            |      |     | 0                   |       |
| droptime | datetime              |      |     | 0000-00-00 00:00:00 |       |
| augslot1 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot2 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot3 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot4 | mediumint(7) unsigned |      |     | 0                   |       |
| augslot5 | mediumint(7) unsigned |      |     | 0                   |       |
+----------+-----------------------+------+-----+---------------------+-------+

On the unknown opcode, looks like you don't have the right opcode for OP_AugmentItem, try setting it to 0x02e5 and try it again.

As far as the wrong size on close container, you'd have to look at the packet and see why it's off.

You might also consider moving to a more recent version, like 0.6.3 or 0.6.4.

[kouhei]

here is a sql I did up. I was at least able to remove that error sayingat row #1 in the db.

# MySQL-Front 3.2 (Build 6.6)

# Host: localhost Database: dark
# ------------------------------------------------------
# Server version 4.0.24-nt

#
# Table structure for table object_contents
#

DROP TABLE IF EXISTS `object_contents`;
CREATE TABLE `object_contents` (
`zoneid` int(11) unsigned NOT NULL default '0',
`parentid` int(11) unsigned NOT NULL default '0',
`bagidx` int(11) unsigned NOT NULL default '0',
`itemid` int(11) unsigned NOT NULL default '0',
`charges` tinyint(3) NOT NULL default '0',
`droptime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`zoneid`,`parentid`)
) TYPE=MyISAM;

#
# Dumping data for table object_contents
#

INSERT INTO `object_contents` (`zoneid`,`parentid`,`bagidx`,`itemid`,`charges`,` droptime`) VALUES (152,5001,1,38010,1,'2006-01-13 17:36:31');


I wonder if augslot1 is not the coloum.
will keep testing new ideas. If you know anything let me know I hope this helps you out too.

[soulshot]

Sorry to bump an old thread but wanted to share an entry for a fountain container in the nexus.

INSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (5002, 152, '30.4', '-30', '-29.93', '140', 17909, 0, 'IT10714', 53, 1115);

Ok here is where I am stumped I have read alot of the older augment threads and still at the same situation. For example I can place a wrist item with slot 7 open and a slot 7 augment into the fountain. The insert button pops up and is ready to go. So I click insert and... the items remain the same - no combine. HELP! =) I see some servers saying thier augments are working so I suppose there is a fix out there if someone is willing to share? Edit - I have also tried other slots but none of them work as of yet.

[Havocx]

I am also haveing the same issue. I posted it in the minilogin area and havent had a reply in 2 weeks...i have tried all of the things other people has posted and nothing seems to fix it.

[kouhei]

What server version are you guys working? I had it working with the first couple of 7.0 versions. I have not had time to try the present version since I had to head to the states on Emergency leave to see my mother. She had a pacemaker installed. So will try to check out the newer versions to see if they work too.

[soulshot]

7.0-823 here