Here it is.
mysql> use peq
Database changed
mysql> SELECT short_name,ruleset FROM zone WHERE zoneidnumber = 202;
+-------------+---------+
| short_name | ruleset |
+-------------+---------+
| poknowledge | 2 |
+-------------+---------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT * FROM rule_values WHERE rule_name like 'Mercs:%';
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
| ruleset_id | rule_name | rule_value | notes
|
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
| 3 | Mercs:AllowMercs | true |
|
| 2 | Mercs:AllowMercs | true | Turns mercs on for th
e server - will not load merc data if set to false.
|
| 2 | Mercs:SuspendIntervalMS | 10000 | Time interval for sus
pend command in milliseconds.
|
| 2 | Mercs:UpkeepIntervalMS | 180000 | Time interval for mer
c upkeep in milliseconds.
|
| 2 | Mercs:SuspendIntervalS | 10 | Time interval for sus
pend command in seconds.
|
| 2 | Mercs:UpkeepIntervalS | 180 | Time interval for mer
c upkeep in seconds.
|
| 2 | Mercs:ScaleRate | 100 | Allows scaling of mer
c stats vs livelike values.
|
| 2 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro target(also used to determine the distance at wh
ich a healer merc will begin healing a group member)
|
| 2 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro target, if they have the group role of puller (a
lso used to determine the distance at which a healer merc will begin healing a g
roup member, if they have the group role of puller) |
| 1 | Mercs:AllowMercs | true | Turns mercs on for th
e server - will not load merc data if set to false.
|
| 1 | Mercs:SuspendIntervalMS | 10000 | Time interval for sus
pend command in milliseconds.
|
| 1 | Mercs:UpkeepIntervalMS | 180000 | Time interval for mer
c upkeep in milliseconds.
|
| 1 | Mercs:SuspendIntervalS | 10 | Time interval for sus
pend command in seconds.
|
| 1 | Mercs:UpkeepIntervalS | 180 | Time interval for mer
c upkeep in seconds.
|
| 1 | Mercs:ScaleRate | 100 | Allows scaling of mer
c stats vs livelike values.
|
| 1 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro target(also used to determine the distance at wh
ich a healer merc will begin healing a group member)
|
| 1 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro target, if they have the group role of puller (a
lso used to determine the distance at which a healer merc will begin healing a g
roup member, if they have the group role of puller) |
| 10 | Mercs:SuspendIntervalMS | 10000 |
|
| 10 | Mercs:UpkeepIntervalMS | 180000 |
|
| 10 | Mercs:SuspendIntervalS | 10 |
|
| 10 | Mercs:UpkeepIntervalS | 180 |
|
| 10 | Mercs:AllowMercs | true |
|
| 10 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro group member's target(also used to determine the
distance at which a healer merc will begin healing a group member)
|
| 10 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro group member's target,if they have the group rol
e of puller (also used to determine the distance at which a healer merc will beg
in healing a group member,if they have the group role of puller) |
| 10 | Mercs:ScaleRate | 100 |
|
| 1 | Mercs:ResurrectRadius | 50 | Determines the distan
ce from which a healer merc will attempt to resurrect a corpse
|
| 1 | Mercs:ChargeMercPurchaseCost | false | Turns Mercenary purch
ase costs on or off.
|
| 1 | Mercs:ChargeMercUpkeepCost | false | Turns Mercenary upkee
p costs on or off.
|
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
28 rows in set (0.00 sec)
mysql> SELECT name,class FROM npc_types WHERE class = 71 LIMIT 2;
+-------------------+-------+
| name | class |
+-------------------+-------+
| Guardian_Vaehan | 71 |
| Guardian_Adiasean | 71 |
+-------------------+-------+
2 rows in set (0.00 sec)
And again thank you very much for your help.
|