Loading...   

[Show Table of Contents]


Logging types to implement yet

Most toggled on/off based on rule

  •  Player drops an item
    • Rule: QueryServ:PlayerLogDropItem
  •  Player destroys an item
    • Rule: QueryServ:PlayerLogDeletes
mysql> describe qs_player_delete_record;
+------------+--------------+------+-----+---------+-----------------------------+
| Field      | Type         | Null | Key | Default | Extra                       |
+------------+--------------+------+-----+---------+-----------------------------+
| delete_id  | int(11)      | NO   | PRI | NULL    | auto_increment              |
| time       | timestamp    | YES  |     | NULL    | on update CURRENT_TIMESTAMP |
| char_id    | int(11)      | YES  |     | 0       |                             |
| stack_size | mediumint(7) | YES  |     | 0       |                             |
| char_items | mediumint(7) | YES  |     | 0       |                             |
+------------+--------------+------+-----+---------+-----------------------------+
5 rows in set

mysql> describe qs_player_delete_record_entries;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| event_id  | int(11)      | YES  |     | 0       |       |
| char_slot | mediumint(7) | YES  |     | 0       |       |
| item_id   | int(11)      | YES  |     | 0       |       |
| charges   | mediumint(7) | YES  |     | 0       |       |
| aug_1     | int(11)      | YES  |     | 0       |       |
| aug_2     | int(11)      | YES  |     | 0       |       |
| aug_3     | int(11)      | YES  |     | 0       |       |
| aug_4     | int(11)      | YES  |     | 0       |       |
| aug_5     | int(11)      | YES  |     | 0       |       |
+-----------+--------------+------+-----+---------+-------+
9 rows in set
  •  Player moves an item 
    • Rule: QueryServ:PlayerLogMoves
mysql> describe qs_player_move_record;
+------------+--------------+------+-----+---------+-----------------------------+
| Field      | Type         | Null | Key | Default | Extra                       |
+------------+--------------+------+-----+---------+-----------------------------+
| move_id    | int(11)      | NO   | PRI | NULL    | auto_increment              |
| time       | timestamp    | YES  |     | NULL    | on update CURRENT_TIMESTAMP |
| char_id    | int(11)      | YES  |     | 0       |                             |
| from_slot  | mediumint(7) | YES  |     | 0       |                             |
| to_slot    | mediumint(7) | YES  |     | 0       |                             |
| stack_size | mediumint(7) | YES  |     | 0       |                             |
| char_items | mediumint(7) | YES  |     | 0       |                             |
| postaction | tinyint(1)   | YES  |     | 0       |                             |
+------------+--------------+------+-----+---------+-----------------------------+
8 rows in set

mysql> describe qs_player_move_record_entries;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| event_id  | int(11)      | YES  |     | 0       |       |
| from_slot | mediumint(7) | YES  |     | 0       |       |
| to_slot   | mediumint(7) | YES  |     | 0       |       |
| item_id   | int(11)      | YES  |     | 0       |       |
| charges   | mediumint(7) | YES  |     | 0       |       |
| aug_1     | int(11)      | YES  |     | 0       |       |
| aug_2     | int(11)      | YES  |     | 0       |       |
| aug_3     | int(11)      | YES  |     | 0       |       |
| aug_4     | int(11)      | YES  |     | 0       |       |
| aug_5     | int(11)      | YES  |     | 0       |       |
+-----------+--------------+------+-----+---------+-------+
10 rows in set
  •  Player hands in an item
    • Rule: QueryServ:PlayerLogHandins
mysql> describe qs_player_handin_record;
+------------+--------------+------+-----+---------+-----------------------------+
| Field      | Type         | Null | Key | Default | Extra                       |
+------------+--------------+------+-----+---------+-----------------------------+
| handin_id  | int(11)      | NO   | PRI | NULL    | auto_increment              |
| time       | timestamp    | YES  |     | NULL    | on update CURRENT_TIMESTAMP |
| quest_id   | int(11)      | YES  |     | 0       |                             |
| char_id    | int(11)      | YES  |     | 0       |                             |
| char_pp    | int(11)      | YES  |     | 0       |                             |
| char_gp    | int(11)      | YES  |     | 0       |                             |
| char_sp    | int(11)      | YES  |     | 0       |                             |
| char_cp    | int(11)      | YES  |     | 0       |                             |
| char_items | mediumint(7) | YES  |     | 0       |                             |
| npc_id     | int(11)      | YES  |     | 0       |                             |
| npc_pp     | int(11)      | YES  |     | 0       |                             |
| npc_gp     | int(11)      | YES  |     | 0       |                             |
| npc_sp     | int(11)      | YES  |     | 0       |                             |
| npc_cp     | int(11)      | YES  |     | 0       |                             |
| npc_items  | mediumint(7) | YES  |     | 0       |                             |
+------------+--------------+------+-----+---------+-----------------------------+
15 rows in set

mysql> describe qs_player_handin_record_entries;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| event_id    | int(11)      | YES  |     | 0       |       |
| action_type | char(6)      | YES  |     | action  |       |
| char_slot   | mediumint(7) | YES  |     | 0       |       |
| item_id     | int(11)      | YES  |     | 0       |       |
| charges     | mediumint(7) | YES  |     | 0       |       |
| aug_1       | int(11)      | YES  |     | 0       |       |
| aug_2       | int(11)      | YES  |     | 0       |       |
| aug_3       | int(11)      | YES  |     | 0       |       |
| aug_4       | int(11)      | YES  |     | 0       |       |
| aug_5       | int(11)      | YES  |     | 0       |       |
+-------------+--------------+------+-----+---------+-------+
10 rows in set
  •  Player trades
    • Rule: QueryServ:PlayerLogTrades
mysql> describe qs_player_trade_record;
+-------------+--------------+------+-----+---------+-----------------------------+
| Field       | Type         | Null | Key | Default | Extra                       |
+-------------+--------------+------+-----+---------+-----------------------------+
| trade_id    | int(11)      | NO   | PRI | NULL    | auto_increment              |
| time        | timestamp    | YES  |     | NULL    | on update CURRENT_TIMESTAMP |
| char1_id    | int(11)      | YES  |     | 0       |                             |
| char1_pp    | int(11)      | YES  |     | 0       |                             |
| char1_gp    | int(11)      | YES  |     | 0       |                             |
| char1_sp    | int(11)      | YES  |     | 0       |                             |
| char1_cp    | int(11)      | YES  |     | 0       |                             |
| char1_items | mediumint(7) | YES  |     | 0       |                             |
| char2_id    | int(11)      | YES  |     | 0       |                             |
| char2_pp    | int(11)      | YES  |     | 0       |                             |
| char2_gp    | int(11)      | YES  |     | 0       |                             |
| char2_sp    | int(11)      | YES  |     | 0       |                             |
| char2_cp    | int(11)      | YES  |     | 0       |                             |
| char2_items | mediumint(7) | YES  |     | 0       |                             |
+-------------+--------------+------+-----+---------+-----------------------------+
14 rows in set

mysql> describe qs_player_trade_record_entries;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| event_id  | int(11)      | YES  |     | 0       |       |
| from_id   | int(11)      | YES  |     | 0       |       |
| from_slot | mediumint(7) | YES  |     | 0       |       |
| to_id     | int(11)      | YES  |     | 0       |       |
| to_slot   | mediumint(7) | YES  |     | 0       |       |
| item_id   | int(11)      | YES  |     | 0       |       |
| charges   | mediumint(7) | YES  |     | 0       |       |
| aug_1     | int(11)      | YES  |     | 0       |       |
| aug_2     | int(11)      | YES  |     | 0       |       |
| aug_3     | int(11)      | YES  |     | 0       |       |
| aug_4     | int(11)      | YES  |     | 0       |       |
| aug_5     | int(11)      | YES  |     | 0       |       |
+-----------+--------------+------+-----+---------+-------+
12 rows in set
  •  Player merchant purchases/sells
    • Rule: QueryServ:MerchantLogTransactions
    • qs_merchant_transaction_record
+----------------+--------------+------+-----+---------+-----------------------------+
| Field          | Type         | Null | Key | Default | Extra                       |
+----------------+--------------+------+-----+---------+-----------------------------+
| transaction_id | int(11)      | NO   | PRI | NULL    | auto_increment              |
| time           | timestamp    | YES  |     | NULL    | on update CURRENT_TIMESTAMP |
| zone_id        | int(11)      | YES  |     | 0       |                             |
| merchant_id    | int(11)      | YES  |     | 0       |                             |
| merchant_pp    | int(11)      | YES  |     | 0       |                             |
| merchant_gp    | int(11)      | YES  |     | 0       |                             |
| merchant_sp    | int(11)      | YES  |     | 0       |                             |
| merchant_cp    | int(11)      | YES  |     | 0       |                             |
| merchant_items | mediumint(7) | YES  |     | 0       |                             |
| char_id        | int(11)      | YES  |     | 0       |                             |
| char_pp        | int(11)      | YES  |     | 0       |                             |
| char_gp        | int(11)      | YES  |     | 0       |                             |
| char_sp        | int(11)      | YES  |     | 0       |                             |
| char_cp        | int(11)      | YES  |     | 0       |                             |
| char_items     | mediumint(7) | YES  |     | 0       |                             |
+----------------+--------------+------+-----+---------+-----------------------------+
15 rows in set

qs_merchant_transaction_record_entries

+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| event_id  | int(11)      | YES  |     | 0       |       |
| char_slot | mediumint(7) | YES  |     | 0       |       |
| item_id   | int(11)      | YES  |     | 0       |       |
| charges   | mediumint(7) | YES  |     | 0       |       |
| aug_1     | int(11)      | YES  |     | 0       |       |
| aug_2     | int(11)      | YES  |     | 0       |       |
| aug_3     | int(11)      | YES  |     | 0       |       |
| aug_4     | int(11)      | YES  |     | 0       |       |
| aug_5     | int(11)      | YES  |     | 0       |       |
+-----------+--------------+------+-----+---------+-------+
9 rows in set

§Events

  •  Player zoning events
  •  Player deaths
  •  Player Connect/Disconnect
  •  Player Leveling/Deleveling
  •  Player AA Rate Hourly
  •  Player QGlobal Updates
  •  Player Task Updates
  •  Player Task Completions
  •  Player Keyring Additions
  •  Player AA Purchases
  •  Player Tradeskill Events (Create/Fail)
  •  Player Issued Commands 
  •  Player Alternative Currency Updates (In/Out)
  •  Player Alternate Currency Transactions
  •  Player Item Drops
RULE_BOOL( QueryServ, PlayerChatLogging, false) // Logs Player Chat
RULE_BOOL( QueryServ, PlayerLogTrades, false) // Logs Player Trades
RULE_BOOL( QueryServ, PlayerLogHandins, false) // Logs Player Handins
RULE_BOOL( QueryServ, PlayerLogNPCKills, false) // Logs Player NPC Kills
RULE_BOOL( QueryServ, PlayerLogDeletes, false) // Logs Player Deletes
RULE_BOOL( QueryServ, PlayerLogMoves, false) // Logs Player Moves
RULE_BOOL( QueryServ, MerchantLogTransactions, false) // Logs Merchant Transactions
RULE_BOOL( QueryServ, PlayerLogPCCoordinates, false) // Logs Player Coordinates with certain events
RULE_BOOL( QueryServ, PlayerLogDropItem, false) // Logs Player Drop Item
RULE_BOOL( QueryServ, PlayerLogZone, false) // Logs Player Zone Events
RULE_BOOL( QueryServ, PlayerLogDeaths, false) // Logs Player Deaths
RULE_BOOL( QueryServ, PlayerLogLevels, false) // Logs Player Leveling/Deleveling
RULE_BOOL( QueryServ, PlayerLogEXPRate, false) // Logs Player Experience Rates
RULE_BOOL( QueryServ, PlayerLogAARate, false) // Logs Player AA Experience Rates
RULE_BOOL( QueryServ, PlayerLogQGlobalUpdate, false) // Logs Player QGlobal Updates
RULE_BOOL( QueryServ, PlayerLogTaskUpdates, false) // Logs Player Task Updates
RULE_BOOL( QueryServ, PlayerLogKeyringAddition, false) // Log PLayer Keyring additions
RULE_BOOL( QueryServ, PlayerLogAAPurchases, false) // Log Player AA Purchases
RULE_BOOL( QueryServ, PlayerLogTradeSkillEvents, false) // Log Player Tradeskill Transactions
RULE_BOOL( QueryServ, PlayerLogIssuedCommandes, false ) // Log Player Issued Commands
RULE_BOOL( QueryServ, PlayerLogMoneyTransactions, false) // Log Player Money Transaction/Splits
RULE_BOOL( QueryServ, PlayerLogAlternateCurrencyTransactions, false) // Log Ploayer Alternate Currency Transactions

§Implement Garbage Collection Table

  • Queryserv runs on a timer, checks  table that contains all logging features and dictates the logging rotation time interval in which old records should be purged.