Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] The Source Code → Rename "BNET" table in SQL

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 3

1 (edited by Feofilaktt 22.05.2019 04:02)

Topic: 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?

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Planner

2

Re: Rename "BNET" table in SQL

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 = 1
Do not ask for support in PM.

3

Re: Rename "BNET" table in SQL

It's all right!

I'll do some testing and come back with the result!

Thanks HarpyWar!

Added: 23.05.2019 01:50

work! big_smile

https://forums.pvpgn.pro/uploads/images/2019/05/23/image.png

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Planner

Posts: 3

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 1 guest, 0 registered users

forums.pvpgn.pro → [EN] The Source Code → Rename "BNET" table in SQL