Database

JM-NPCRoadRage includes an optional database integration. Without it, every feature works normally — only the /npcrage-history command will return empty results.

Table Schema#

The included database.sql file creates one table:

npc_road_rage_incidents  id              INT (auto-increment primary key)  citizenid       VARCHAR(50)  coords          TEXT  weapon_used     VARCHAR(50)  police_notified TINYINT(1)  timestamp       INT  created_at      TIMESTAMP

Importing the Schema#

Run the SQL file against your server database once:

mysql -u YOUR_USER -p YOUR_DATABASE < /path/to/JM-NPCRoadRage/database.sql

Or import it via phpMyAdmin or HeidiSQL using the Import option.

Enabling Database Logging#

Database writes are present in the resource but commented out by default. To activate them you would need to uncomment the oxmysql execute calls inside server/database.lua. The resource uses oxmysql syntax — make sure that resource is running on your server.

What Gets Logged#

Each road rage incident can record:

• The citizen ID of the player involved.
• The coordinates where the incident occurred.
• The weapon used by the NPC (or none for fists).
• Whether police were notified.
• A Unix timestamp of the event.