[Release] Updated Database Import Scripts

Eperty123 · Jun 20, 2023

Sup all,

I updated the scripts for import of the database files:

db_account_alter
dbalter

The updated scripts automatically import the necessary sk and ska files as well as their _alter counterparts and also create the database associated, if it does not exist. Very useful for those who are starting out.

What To Edit
You need to edit the following variables inside the scripts:

Code:

$db_name = "FFAccount";
$db_account = "postgres";
$db_password = "dev";

to match or customize them to your Postgresql setup. The database name can be changed to whatever you want but the account and password must match your Postgresql username and password.

How To Use

Overwrite the existing files inside the db folder or wherever you have the originals located.
Set the permission of them to 771 or 777 to make the executable, if not already.
Execute them by running:

Code:

./db_account_alter
./dbalter

Note
This does not include the script for FFMember. Should be compatible with other server files as well like the recent released Grand Fantasia and Twin Saga server files.

Enjoy.

doogydog · Jun 21, 2023

What is it?
Can you tell me exactly what the impact is?

SmallThing · Jun 27, 2023

Eperty123 said:
Sup all,

I updated the scripts for import of the database files:

db_account_alter

dbalter

The updated scripts automatically import the necessary sk and ska files as well as their _alter counterparts and also create the database associated, if it does not exist. Very useful for those who are starting out.

What To Edit
You need to edit the following variables inside the scripts:

Code:

$db_name = "FFAccount"; $db_account = "postgres"; $db_password = "dev";

to match or customize them to your Postgresql setup. The database name can be changed to whatever you want but the account and password must match your Postgresql username and password.

How To Use

Overwrite the existing files inside the db folder or wherever you have the originals located.

Set the permission of them to 771 or 777 to make the executable, if not already.

Execute them by running:

Code:

./db_account_alter ./dbalter

Note
This does not include the script for FFMember. Should be compatible with other server files as well like the recent released Grand Fantasia and Twin Saga server files.

Enjoy.

Thank you Eperty