EQEmulator Forums - Augment Pools, the mystery!

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Augment Pools, the mystery! (https://www.eqemulator.org/forums/showthread.php?t=36286)

Augment Pools, the mystery!

How does one go about making a Augment pool, I was told to download a program, did, and it doesn't work, maybe I'm doing someone wrong?

Add it as an object.

Augment pool data is found in the 'object' table. Note that the type field needs to be 53.

So I found the one in butcher block - and I can't replicate it, I've tried, changing the placement cords and it was like 'Ha, no.' So... I need a little more indepth walk through if possible please. It's been annoying me.

Alrighty, I wrote it out and tried it two different ways, I guess I'm doing something wrong still, this is the error tried both way, the way they had me paste it was different then what was listed in the DB table...

http://i48.tinypic.com/16qh45.jpg

old guide is old, apparently (2008).

it lists 24 fields for the table, and there are only 22 (and in a different order)

use describe <tablename>; to get an overview of the table you are working with in mysql

output:

Code:

mysql> describe object;

+------------+----------------------+------+-----+---------+----------------+

| Field      | Type                 | Null | Key | Default | Extra          |

+------------+----------------------+------+-----+---------+----------------+

| id         | int(11)              | NO   | PRI | NULL    | auto_increment |

| zoneid     | int(11) unsigned     | NO   | MUL | 0       |                |

| version    | smallint(5)          | NO   |     | 0       |                |

| xpos       | float                | NO   |     | 0       |                |

| ypos       | float                | NO   |     | 0       |                |

| zpos       | float                | NO   |     | 0       |                |

| heading    | float                | NO   |     | 0       |                |

| itemid     | int(11)              | NO   |     | 0       |                |

| charges    | smallint(3) unsigned | NO   |     | 0       |                |

| objectname | varchar(32)          | YES  |     | NULL    |                |

| type       | int(11)              | NO   |     | 0       |                |

| icon       | int(11)              | NO   |     | 0       |                |

| unknown08  | mediumint(5)         | NO   |     | 0       |                |

| unknown10  | mediumint(5)         | NO   |     | 0       |                |

| unknown20  | int(11)              | NO   |     | 0       |                |

| unknown24  | int(11)              | NO   |     | 0       |                |

| unknown60  | int(11)              | NO   |     | 0       |                |

| unknown64  | int(11)              | NO   |     | 0       |                |

| unknown68  | int(11)              | NO   |     | 0       |                |

| unknown72  | int(11)              | NO   |     | 0       |                |

| unknown76  | int(11)              | NO   |     | 0       |                |

| unknown84  | int(11)              | NO   |     | 0       |                |

+------------+----------------------+------+-----+---------+----------------+

22 rows in set (1.33 sec)

then you'll need to make corrections to you query to match the order in the current database and add/remove fields that are incorrect in the guide.

this line is quite obviously misleading:

Quote:

Basic SQL knowledge (Not necessary but useful)

might be handy to update the guide after you get it working. :)

If you are not very familiar with MySQL command prompt, you can always use a GUI like Navicat, which makes DB editing pretty easy, even for the less experienced.

Quote:

Originally Posted by trevius (Post 216709)

If you are not very familiar with MySQL command prompt, you can always use a GUI like Navicat, which makes DB editing pretty easy, even for the less experienced.

It works great for Trevius :D

Too true lol. I use it whenever I am not needing to do multiple changes at once.