Help .. NPC. PKT . Password . Monsters

[guiders]

Good Guys is as follows ...
First Good Night ..

1 - PKT - How can I configure my PKT, for it is just right? I know that every DB has the same, however most often mangled, as in my case, I tried tidy - and it could not .. Could someone give me a hand? At least a start ... I have an idea for ...

2 - NPC - How do I create an NPC, so that when the player clicks on it .. gains a certain type of item, directly in the bag ...
Could someone send me a query from an NPC with this action, and it explains each command?

3 - MONSTERS - The same doubts the NPC ... how to make when the monster dies, drop an item directly in the stock who killed him and who pass a global message .. ex: guy killed the show and received X item.

4 - PASSWORD - How can I protect my server from intruders? Lest they be dropping, or even invade and modify something? I would change the password and DB server ...

Good Guys is this .. Thank you in advance .. Thank you.

Sorry my english, I'm not sure.

[~Sword~Stalker~.]

everything is just answered a plenty of times before use the search function if i got this right ..
1- cq_user - PK

(change for whatever u want)

2- cq_NPC , cq_action , npc.ini

(create a new ID in cq_NPC with the name and type of the NPC and do the same at npc.ini input the ID and type as the db and take 1 as a template then connect cq_npc to the cq_action , ofc u need to know the data types for the action )

3- use the lottery as a sample

4- ofc u can change the mysql username and password nothing's in that ..

i quit eo long time ago , i apologize for any unaccurate point

BestRegards ^^

[Timore[PM]]

1. Actually PKT or PK TOURNY is in the cq_action.
2. You forgot the cq_task
3. cq_action with the Auto-Loot action tied in.
Pretty much create an action that gives a random item.
Use forcers Action Description to learn how to use random types
Or for DROPS it should be cq_dropitemrule and cq_monstertype (Dropitemrule tab)
4. You could do that, but pretty much plain and simple. Do not use "%" for your IP access tables in mysql. Use Heavy Passwords (Example. GuidersL33T89 as a User And JcEoCp3S4265 as a Password. Make it hard to guess, and harder to brute force.
Keep windows firewall up and only open ports necessary to access the game
5816 9965 9858 etc
Keep 3306 closed except to your IP address, this allows for only you to access mysql.
Pretty much just keep your security high.
@ Sword. Don't worry, I've got ur back :P

[magewarior2]

Yes,The pkt, is in the cq_qction but the official pkt is also in cq_config.

drops are indeed cq_dropitemrule (linked by cq_monstertype)
you may also use "drop_rule" this is for a "global" drop around your server.


as for the "drop an item directly in the stock who killed him and who pass a global message" you go to cq_monstertype and enter a action param you want it to run when it is killed

you enter the drop & text into the cq-action, and dun.

(do not foget to add some to the cq_task)

type 501  (ads a item to your "bag") data "itemtype"
type 801 (drops an item on the ground) param “dropitem itemtype " or " dropmoney money "

TYPE 125 => DATA 2005 // System message. 
TYPE 125 => DATA 2011 // [GM] message.

hope this can help you.