|
PvPGN Community Forums |
You are not logged in. Please login or register.
forums.pvpgn.pro → [EN] The Source Code → Rename "BNET" table in SQL
I use PvPGN on Linux and would like to make a change in the SQL Table.
I would like to rename the table "pvpgn_BNET" to "pvpgn_users".
"BNET" to "users"
The modification in "sql_DB_layout.conf" is ok. However, it is necessary to make new modifications in PvPGN Code to read this new table name.
Is it possible to make these modifications in the PvPGN code? What files should I the modification before building/make/install in PvPGN code?
Search by "BNET" on github repo returns many results.
Files related to pvpgn server are:
src/bnetd/sql_common.cpp
src/bnetd/file_plain.cpp
src/bnetd/attrgroup.cpp
src/bnetd/mail.cpp
src/bnetd/account.cpp
src/bnetd/storage_sql.cpp
conf/icons.conf.in
conf/sql_DB_layout.conf.in
But I do not recommmend change this, cause many external scripts are also uses that table name. And you won't be able to use future server updates, without additional modifications.
If you want lowercase table names like "pvpgn_bnet", then it's enough to tune mysql server by adding an option in config. With this option tables in SQL queries will be case insensitive:
[mysql]
lower_case_table_names = 1forums.pvpgn.pro → [EN] The Source Code → Rename "BNET" table in SQL
