PM Item: Spawn Monsters

Hey guys, this is like version 2 or whatever of my moderator item release. Now i'll explain how it works:

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

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

2) Go into your server and get the Honey Cake item with this command:

Quote:

/awarditem 743021 HoneyCake

3) Before using the item use this command if you had your server up when implementing the Mod Spawn Item:

Quote:

/reloadaction 0

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.

[Only registered and activated users can see links. Click Here To Register...]

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:

Quote:

UPDATE cq_action SET param='0 0 %user_map_id %user_map_x %user_map_y 2412000 monsterid' WHERE (`id`='7083010')

Thanks to hio77 for the help.

Awesome! i was looking for something like this xD


lol it works and its fun ^^

Thats sweet o.o

0 will reload all actions and just cause lag...

as for using an item ... its not hard at all to make a whole new one .... all the tools are easily available here now thanks to funhacker

also you only need to update the parma
so of this could be wrong its written off the top of my head..

For me, putting the item in the quick slots and just pressing is way easier than remembering the action ID... o.O

Quote:

Originally Posted by SpongeBox For me, putting the item in the quick slots and just pressing is way easier than remembering the action ID... o.O

what i posted was for changing the monster ....

You are correct hio77, but I changed the other parts of the action because originally the HoneyCake or whatever is linked to other actions that heal the user of the item. So with my query it takes off extra action links and just uses the spawn thing. But if you were correcting something in the query then thats all good im not the best with queries or whatever I just copied it from my status bar thing, let me know if theres some kind of mistake.

I'll copy your query though and put it in the first post to help people if their just updating the monster and thanks.

By the way guys, I found the monster spawning uhmmm, what to call it... template? layout? anyway I got it from a rabbit NPC in the DarkCastle quest for those of you who are wondering. But do you know what I mean by layout/template whatever? I don't know what the best word for it is, what do you reckon?

Quote:

Originally Posted by cruey You are correct hio77, but I changed the other parts of the action because originally the HoneyCake or whatever is linked to other actions that heal the user of the item. So with my query it takes off extra action links and just uses the spawn thing. But if you were correcting something in the query then thats all good im not the best with queries or whatever I just copied it from my status bar thing, let me know if theres some kind of mistake. I'll copy your query though and put it in the first post to help people if their just updating the monster and thanks. By the way guys, I found the monster spawning uhmmm, what to call it... template? layout? anyway I got it from a rabbit NPC in the DarkCastle quest for those of you who are wondering. But do you know what I mean by layout/template whatever? I don't know what the best word for it is, what do you reckon?

have to querys .... a setup one and a update lol

Quote:

Originally Posted by hio77 what i posted was for changing the monster ....

you have to pardon me.. im natually high sometimes X_X

Quote:

UPDATE cq_action SET param='0 0 %user_map_id %user_map_x %user_map_y 2412000 monsterid' WHERE (`id`='7083010')

This code can add monster in new map??

Quote:

Originally Posted by matrix89 This code can add monster in new map??

no it can't

Quote:

Originally Posted by RevolutionEO no it can't

owh..where can i find release to add monster in map...
when i search it...he say not found..

is ok..
i found it...this ->[Only registered and activated users can see links. Click Here To Register...]

hey i know im openning up old posts but this isint working for me im not sure why any ideas?

Cuz you are using the new DB..

no im not im using a old DB. i have the item and every i used the query cq_action looks like its working when i right click it but no monster spawn.