Loading...   

[Show Table of Contents]


Other than selecting this task, it's entire operation is independent of the Perl quest system.

§Task Row

INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`) VALUES 
(1, 0, 'Example Task 1', '[1,Deliver this bottle of wine to my friend, Guard Brookrock who is defending Kelethin against the Crushbone orcs.  He is usually found near one of the lifts.][2,Hail friend.  Thank Master V`Lynn for this fine wine.
A camp of outsiders has appeared to the South. Scout that camp and bring back your report to me.][4, Bandits? You must return kill three of them.  Return to me when you have finished.][6,7, Now you must find the entrance to Crushbone and slay 5 Orc Centurions.][9,Very good. Return to Master V`Lynn.]', 'Short Sword Of The Ykesha (and a Scimitar of the Ykesha)', 6, 4444, 0, 1, 54, 0, 0, 1);

id

  • This task has been given a taskid of 1

duration

  • The duration is 0, meaning there is no time limit on the task.

title

  • The title of the task is 'Example Task 1'.

description

  • This task uses a multi-step description. The number following the [ indicates for which activity each part of the description will be displayed. The first part of the description will be displayed in the task selector prior to task selection, and also when the first activity is active. The second part will be displayed when the second activity is active, and so on.

reward

  • This is a text field and can contain anything. In this case it contains the name of the item specified in the rewardid field.

rewardid

  • 36068 is the id for the item 'Note About Your First Trial'. 

cashreward

  • 4444 is the cash the player will receive on completing the task, expressed in copper pieces. This equates to 4 plat, 4 gold, 4 silver and 4 copper pieces.

xpreward

  • As this field is 0, there is no XP given for completing this task.

rewardmethod

  • This field is used in conjunction with the reward field. A value of 0 indicates that the reward field contains a single itemid. Setting this field to 1 indicates that the reward field is a reference to a list of items in the goallist table.

startzone

  • 54 is the zoneid for Greater Faydark. This field is used in the task selector window to show which zone the task begins in.

minlevel
maxlevel

  • As these are set to 0, there is no level restriction.

repeatable

  • This task is repeatable.

§Activity Rows

INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`) VALUES 
(1, 0, 1, 1, 'Guard Brookrock', 'Elven Bottle Of Wine', '', 36078, 0, 1, 54124, 54, 0),
(1, 1, 2, 5, 'Camp of Outsiders', '', '', 1, 0, 1, 0, 54, 0),
(1, 2, 3, 4, 'Guard Brookrock', '', '', 54124, 0, 1, 0, 54, 0),
(1, 3, 4, 2, 'Bandits', '', '', 7, 1, 3, 0, 54, 0),
(1, 4, 5, 4, 'Guard Brookrock', '', '', 54124, 0, 1, 0, 54, 0),
(1, 5, 6, 5, 'the entrance to Crushbone Citadel', '', '', 2, 0, 1, 0, 54, 0),
(1, 6, 6, 2, 'Orcs', '', '', 1, 1, 5, 0, 54, 0),
(1, 7, 7, 4, 'Guard Brookrock', '', '', 54124, 0, 1, 0, 54, 0),
(1, 8, 8, 4, 'V''Lynn Renloe', '', '', 202291, 0, 1, 0, 202, 0);

§Activities

  • The taskid for each activity is 1. This relates these activities to the task with id 1 in the task table.
  • The activityid values must be consecutive and must start at 0. 
  • The step field can range from 0 upwards. In this example, one activity must be completed before the next is revealed until activity 4 is completed. Activities 5 and 6 both have the same step number (6) and so both of these activities will be displayed and active at the same time. Once these two activities are completed, the task reverts to sequential mode, with activity 7 having to be completed before the final activity, 8, is revealed.

§Activity 0

This activity is to deliver 1 Elven Bottle of Wine to Guard Brookrock in Greater Faydark. Guard Brookrock is at a nearby lift when you #zone into gfaydark.

  • ActivityType 1 indicates a 'Deliver' activity.
  • text1 indicates 'Guard Brookrock' and is purely for display purposes in the client.
  • text2 indicates 'Elven Bottle of Wine' and again is purely for display purposes.
  • text3 is unused in this activity.
  • goalid is the id of 'Elven Bottle of Wine' in the item table.
  • goalmethod A value of 0 indicates that the goalid contains a single itemid and that this goal will be handled by the task code without interaction with a Perl quest.
  • goalcount This is how many of goalid must be delivered (1 in this case).
  • npctypeid indicates the NPCTypeID of the NPC that the item must be delivered to.
  • zoneid indicates the activity must be performed in zone 54 (Greater Faydark).
  • optional A value of 0 means this activity is not optional.

§Activity 1

This activity is to explore the 'Camp of Outsiders'. This is a bandit camp located near X=-755, Y=-1160.

  • ActivityType 5 indicates an 'Explore' activity.
  • text1 indicates 'Camp of Outsiders' and is purely for display purposes.
  • text2 and text3 are unused.
  • goalid This refers to entry 1 for this zone in the proximity table.
  • goalmethod A value of 0 indicates that goalid contains a single proximity reference and that goal completion will be handled by the Task proximity code rather than using quest NPC proximities.
  • goalcount Indicates that the proximity must be triggered once. 

The proximity row for this task defines a cube which the player must enter for this activity to be completed.

§Activity 2

This activity is to return and 'Speak With' Guard Brookrock.

  • ActivityType 4 indicates a 'Speak With' activity.
  • text1 indicates 'Guard Brookrock' and is purely for display purposes in the client.
  • text2 and text3 are unused.
  • goalid This refers to entry Guard Brookrock's entry in the npc_types table.
  • goalmethod A value of 0 indicates that goalid contains a single NPCTypeID and that goal completion will be handled by the Task system rather than in the sub EVENT_SAY part of a Perl quest.
  • goalcount Indicates that Guard Brookrock must be spoken with once.

To complete this activity you must target Guard Brookrock and say anything, or Hail him when nearby.

§Activity 3

This activity is to kill 3 bandits.

  • ActivityType 2 indicates a 'Kill' activity.
  • text1 indicates 'Bandits' and is purely for display purposes in the client.
  • text2 and text3 are unused.
  • goalid This refers to list number 7 in the goallists table.
  • goalmethod A value of 1 indicates that goalid contains a list number and that goal completion will be handled by the Task system rather than a Perl quest.
  • goalcount is 3 (kill 3 bandits).

If you look at the goallist rows further down this page, you will see that list 7 contains entries 54035, 54036, 54207, 54235, 54250 and 54254. These are all the entries for 'Bandits' in the npc_types table that have spawn2 entries for gfaydark. The query that was used to gather these entries was:

select distinct n.id, n.name
from npc_types n
inner join spawnentry se on n.id = se.npcID
inner join spawn2 s on se.spawngroupID = s.spawngroupID
where s.zone = 'gfaydark' and n.name like '%andit%' ;

§Activity 4

  • This is the same as activity 2 (return and speak with Guard Brookrock again).

§Activity 5

  • This activity and the next (activity 6) both have the same step number and so become active at the same time (completion of activity 4).
  • Activity 5 is to explore the entrance to crushbone. It is the same as activity 1 with the exception that the proximity entry is 2 in the proximity table.

§Activity 6

  • This activity is to kill 5 Orc Centurions. It is similar to activity 3, the difference being that a different goalllist (1) is specified. This list contains all the Orc Centurion NPCTypeIDs that spawn in gfaydark.

§Activity 7

  • This is the same as activities 2 and 4 (Speak to Guard Brookrock). Once completed, the Task Description will update, directing you to return to V'Lynn Renloe in the Plane Of Knowledge, and the following activity will unlock.

§Activity 8

Speak with V'Lynn Renloe.

  • This is similar to the other Speak activities listed above, with the exception that zoneid is 202 for Plane Of Knowledge. 
  • As this is the last activity, once you Hail V'Lynn Renloe, the green 'Task Example Task 1' Completed' message will appear on your screen, the item reward summoned onto your cursor and the cash reward placed in your player profile. The task will be removed from your active tasks and, if you have the relevant rule enabled, moved into your completed tasks tab.

§Proximity Rows

These two proximity entries define an area around the bandit camp and the entrance to Crushbone respectively.

INSERT INTO `proximities` (`zoneid`, `exploreid`, `minx`, `maxx`, `miny`, `maxy`, `minz`, `maxz`) VALUES 
(54, 1, -833.000000, -457.000000, -1368.000000, -997.000000, -100.000000, 100.000000),
(54, 2, -211.000000, 211.000000, 2181.000000, 2389.000000, -100.000000, 100.000000);

§GoalList Rows

Goallist 7 lists the NPCTypeIDs for bandits that spawn in gfaydark, while 1 lists the entries for Orcs