Database

This addon saves player data utilizing either SQLite or Mysql (mysqloo module).

By default, this addon uses SQLite. If you wish to utilize this method; no further configurations need to be done. However, if you wish to utilize MySQL; read below.

◾ SQLite

This is the default storage method; which is the built-in Garry's Mod. If you wish to use this method; no further setup needs to be done.

All data will be saved to:

garrysmod\sv.db

In order to view these records; you must install DB Browser for SQLite.

◾ MySQL

To configure your addon to utilize MySQL; you must configure the file:

addons/identix/identix.rlib

Within the above file; first ensure you switch the database mode from sqlite to mysqloo:

"general"
{
     "mode"          "mysqloo"
}

Then insert your MySQL credentials in the same file and then save and close:

"mysql"
{
     "host"          "localhost"
     "port"          "3306"
     "user"          "db_username"
     "pass"          "db_pass"
     "name"          "db_nameu"
}

Any time you change the values within this file; you must restart the server for the changes to take affect.

In order to view these records; you must utilize your web hosts' Database Manager / PHPMyAdmin. Contact your host if you're unsure of how to do this.

In order for MySQL connections to function properly; you MUST install the MySQLOO module which can be downloaded here.

We do not provide support for setting this up. Please review the MySQLOO Installation Instructions here.

Last updated