Issue Information
-
#003317
-
1 - Low
-
Needs More Info
Issue Confirmations
-
Yes (0)No (0)
0
not all SQL tables can be set in inter_athena.conf
Posted by Hercules Bot on 01 July 2009 - 05:48 AM
Originally posted by BrianL
http://www.eathena.w...er&showbug=3317
In inter_athena.conf, there are settings to allow custom SQL table names.
There are settings for all tables in the "ragnarok" database except:
Also, the 'loginlog' table was moved to the "log" database, but it still has a config.
We could leave it as is, or for consistency remove the 'loginlog' config (or add all the log tables).
http://www.eathena.w...er&showbug=3317
In inter_athena.conf, there are settings to allow custom SQL table names.
There are settings for all tables in the "ragnarok" database except:
homunculus ipbanlist login mercenary mercenary_owner ragsrvinfo skill_homunculus sstatus
Also, the 'loginlog' table was moved to the "log" database, but it still has a config.
We could leave it as is, or for consistency remove the 'loginlog' config (or add all the log tables).
Originally posted by Xantara
Confirmed. Additionally, table item_db_re should also have this custom setting.
Confirmed. Additionally, table item_db_re should also have this custom setting.
Originally posted by Ind
Added item_db_re rename support from inter_athena.conf in [rev=15114]
Added item_db_re rename support from inter_athena.conf in [rev=15114]
Originally posted by Xantara
I've finished all that was needed but I have a question regarding sstatus.
The table sstatus is no longer supported according to [rev=12491]
However, the changeset said 'to be resolved later', what does that mean? Should the SVN actually support it or can this table just be taken out of the main.sql file?
-----------------------------------
PS.
The table name for ipbanlist can be set in the trunk/conf/login_athena.conf file under the setting ipban.sql.ipban_table
The table name for login can be set in the trunk/conf/login_athena.conf file under the setting account.sql.account_db
All log table names can be set in trunk/conf/log_athena.conf. Loginlog is a special case since it has to be dealt with on login - the placing of the setting is just incorrect (it should be a few lines up with the other log settings).
I've finished all that was needed but I have a question regarding sstatus.
The table sstatus is no longer supported according to [rev=12491]
However, the changeset said 'to be resolved later', what does that mean? Should the SVN actually support it or can this table just be taken out of the main.sql file?
-----------------------------------
PS.
The table name for ipbanlist can be set in the trunk/conf/login_athena.conf file under the setting ipban.sql.ipban_table
The table name for login can be set in the trunk/conf/login_athena.conf file under the setting account.sql.account_db
All log table names can be set in trunk/conf/log_athena.conf. Loginlog is a special case since it has to be dealt with on login - the placing of the setting is just incorrect (it should be a few lines up with the other log settings).
Originally posted by Xantara
All except sstatus (see above) have been added for renaming in [rev=15508]
All except sstatus (see above) have been added for renaming in [rev=15508]
