[Antrix] Custom creature loot Help!

[acn545]

im having a problem with my creature loot. no matter what i set the drop rate to nothing but some coins drop from the creature, heres what my loot thing looks like.

INSERT INTO `creatureloot` VALUES ('2000000','250000','120000','60.48')

if theres anything wrong with it please post it would be very helpful thanks.

[MentaL]

[mayoking]

im getting the same problem

[blizzhackerd]

You're `creatureloot` table is completely devoid of entries, am I right?

You'll probably need to reload your database to correct the problem, and remember that you shouldn't need to run the creatureloot.sql file in the sql directory of Ascent.

[Julian_X]

Creatureloot:

INSERT INTO `creatureloot` VALUES
(`IndexID`,`CreatureID`,`Itemid`,`Percentchance`)
Exapmple:

INSERT INTO `creatureloot` VALUES (999999,22917,32837,8.8);

Just follow that guideline to make it look somewhat like the example and you should not get an error.

[Paperz]

I can't get loot when killing mobs in BT EPL and some others...my settings are:


/*Column Information For - ascent.creatureloot*/
------------------------------------------------

Field Type Collation Null Key Default Extra Privileges Comment
------------- ------- --------- ------ ------ ------- -------------- ------------------------------- -------
index int(11) (NULL) NO PRI (NULL) auto_increment select,insert,update,references
entryid int(11) (NULL) NO 0 select,insert,update,references
itemid int(11) (NULL) NO 0 select,insert,update,references
percentchance float (NULL) YES (NULL) select,insert,update,references

/*Index Information For - ascent.creatureloot*/
-----------------------------------------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
------------ ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
creatureloot 0 PRIMARY 1 index A 277443 (NULL) (NULL) BTREE
creatureloot 0 index 1 index A 277443 (NULL) (NULL) BTREE

/*DDL Information For - ascent.creatureloot*/
---------------------------------------------

Table Create Table
------------ ---------------------------------------------------------------
creatureloot CREATE TABLE `creatureloot` (
`index` int(11) NOT NULL auto_increment,
`entryid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`percentchance` float default NULL,
PRIMARY KEY (`index`),
UNIQUE KEY `index` (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=2136811 DEFAULT CHARSET=latin1


Please tell me what need to be changed so the loot drops, thank you.

[robban67]

i get this error SQL ERROR: Column count doesn't match value at row 1
pls help...