Awhile ago I released an item that spawns monsters but some people didn't use it because they had to completely replace their cq_action tables and itemtype.dats so I changed the way to do it and this time ill just edit what an item does. Okay so, theres an item thats called HoneyCake. I assume that TQ has used it for a christmas events but because we don't use it anymore I'll show you how to edit it into a moderator item. Here are the steps:
1) Run this query but change "monsterid" to the monster ID found in your cq_monstertype table, like SpiderQueen is 40001
2) Go into your server and get the Honey Cake item with this command:Quote:
UPDATE `cq_action` SET `id_next`='0', `id_nextfail`='0', `type`='2006', `data`='0', `param`='0 0 %user_map_id %user_map_x %user_map_y 2412000 monsterid' WHERE (`id`='7083010') LIMIT 1
3) Before using the item use this command if you had your server up when implementing the Mod Spawn Item:Quote:
/awarditem 743021 HoneyCake
4) Right click or use the item and the monster connected to the ID you put in will spawn where you are standing and whalah! You have your monster.Quote:
/reloadaction 0
Brought to you by Devils Advocate Online, reply to this thread with questions if you need answers.
UPDATING THE MONSTER:
If you need to change what monster is spawned using the item, change 'monsterid' to the new monster ID and use this query:
Thanks to hio77 for the help.Quote:
UPDATE cq_action SET param='0 0 %user_map_id %user_map_x %user_map_y 2412000 monsterid' WHERE (`id`='7083010')