augs (Doodman)

[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.