[Guide] Make item auto loot on inventory

[zombaxcrop]

Basicly, people want some item auto loot that mean auto in to the inventory.So here the query template that i want to guide you sorry for my bad english.

Action Side

INSERT INTO `cq_action` VALUES ('58500000', '58500001', '0000', '1001', '0', 'e_money += 50000');
INSERT INTO `cq_action` VALUES ('58500001', '58500002', '0000', '0501', '1020260', '10 10');
INSERT INTO `cq_action` VALUES ('58500002', '58500003', '0000', '0501', '1020250', '10 10');
INSERT INTO `cq_action` VALUES ('58500003', '58500004', '0000', '0801', '0', 'dropitem 1020250');
INSERT INTO `cq_action` VALUES ('58500004', '58500005', '0000', '0801', '0', 'dropitem 1020260');
INSERT INTO `cq_action` VALUES ('58500005', '58500006', '0000', '0801', '0', 'dropitem 1020250');
INSERT INTO `cq_action` VALUES ('58500006', '58500007', '0000', '0801', '0', 'dropitem 1020260');
INSERT INTO `cq_action` VALUES ('58500007', '0000', '0000', '1010', '2005', 'You found 50,000 EudemonPoints from GoldMachine!');


Blue = Item ID's
Red = Ammount of item.example: 10 10 mean it loot 10 item stacked in your inventory and max ammount are 10.
Purple = Type ID's. 501 are auto loot type
Lime = Basic drop on map

Monster Side

After that 1 more thing you need to change,it is Monster Action ID.Where can you change it?
just open your cq_monstertype and for example the picture above are MadBull Action ID just change it into your beginning Autoloot action ID

Screenshot:



Uploaded with


Push thank wont format your PC

[~Zero~]

Isn't the param for type 501 defining the item details like sockets, item bonus number etc?

[Eurion]

Originally Posted by ~Zero~

Isn't the param for type 501 defining the item details like sockets, item bonus number etc?

I haven' tested this but, usually the tyoe 501's first param is the "amount_limit" from cq_itemtype, while the second one is the "ident" field.

[~Zero~]

I guess the cq_item structure for EO it's mostly the same as the CO one and yes you're right. A random param for the type 501 for CO would be "0 0 0 255 255 0 0 12 7 255". First two 255s standing for the item sock amount, 12 standing for the item bonus value (+n), 7 standing for the damage decrease attribute and the last 255 standing for the enchanted HP. It follows the cq_item structure and I guess for EO would be the same but with minor changes.

Edit: When you just want to auto-loot a specific item with type 501 (like a quest item or something that cannot be worn (non-equipment type)) you can just leave the param field blank. It will get the pre-defined amount set in the cq_itemtype.

[funhacker]

Originally Posted by Eurion

I haven' tested this but, usually the tyoe 501's first param is the "amount_limit" from cq_itemtype, while the second one is the "ident" field.

Depends on how many fields you include in the param.

With the above method however you could just use the amount

Example

501 ItemtypeID "Amount"

The same can be done for deleting multiple amounts.

[deltajunior]

hey, if i want to add this query in my cq_action table , there comes a error and says "[SQL] INSERT INTO `cq_action` VALUES ('58500000', '58500001', '0000', '1001', '0', 'e_money += 50000');
[Err] 1062 - Duplicate entry '58500000' for key 1"
what does this mean? o

[zombaxcrop]

Originally Posted by deltajunior

hey, if i want to add this query in my cq_action table , there comes a error and says "[SQL] INSERT INTO `cq_action` VALUES ('58500000', '58500001', '0000', '1001', '0', 'e_money += 50000');
[Err] 1062 - Duplicate entry '58500000' for key 1"
what does this mean? o

Mean,you have already the query on your database if you want to add them back,you must run delete query and run the query back

[~Zero~]

Change this id "58500000" to another one.

[amirrozlan]

Nice!

[nomercyskin1]

Good Zombax!