arma3-life-db
v1.0.8
Published
Connects to your life server's database on arma 3 to pull or update information.
Downloads
7
Maintainers
Readme
arma3-life-db
Connects to your life server's database on arma 3 to pull or update information.
Features
- Get cash, bank, levels, etc.. for a player
- Get a value from any table
- Update a value from any table
Requirements
- Node.JS
- NPM
- Database(MySQL/MariaDB)
Installation
- Install the package using NPM with command
npm i --save arma3-life-db
- Done! Now time to configure.
Configuration
Package
Add this to the top of your file.
const {Config, Query_Get, Query_Update} = require("arma3-life-db")
Database Setup
Add this function to your file and change the key values.
Config({
IP: "127.0.0.1",
Port: "3306",
Database: "altislife",
Username: "test",
Password: "123321"
})
Functions
Config(ConfigObject)
This function configures and starts up the SQL pool.
- Parameters
- "ConfigObject" (Object) - The configuration for a3ldb
- "IP" (string) - The IPv4 of the SQL server
- "Port" (string) - The port of the SQL server
- "Database" (string) - The database in the SQL server where the info is stored
- "Username" (string) - The SQL username that has access to the database
- "Password" (string) - The SQL username's password that has access to the database
- "ConfigObject" (Object) - The configuration for a3ldb
Query_Get(Table, Column, Search_Column, Search_Value)
This function gets a value for the supplied player.
- Parameters
- "Table" (String) - The SQL table to search from
- "Column" (String) - The SQL column to get the value from
- "Search_Column" (String) - The SQL column to search from
- "Search_Value" (String) - The value to search the Search_Column for
async function Get_Player_Cop_And_Medic_Levels() {
console.log("Cop level", await Query_Get("players", "coplevel", "pid", "76561198325855765"))
console.log("Medic level", await Query_Get("players", "mediclevel", "pid", "76561198325855765"))
}
Get_Player_Cop_And_Medic_Levels()
Query_Update(Table, Column, Column_Value, Search_Column, Search_Value)
This function updates a value for the supplied table and for the supplied search value.
- Parameters
- "Table" (String) - The SQL table to update
- "Column" (String) - The SQL column to update
- "Column_Value" (String) - The new value to replace the old value
- "Search_Column" (String) - The SQL column to search from
- "Search_Value" (String) - The value to search the Search_Column for
async function Update_Player_Cash() {
console.log("Cash update", await Query_Update("players", "cash", "1000000", "pid", "76561198325855765"))
}
Update_Player_Cash()
To-Do List
- Optimize project
- Write less code