TERA 92/100 Steer Server + Box Server (Item Claim System)

[hsdn]

Steer server is designed to manage administrator rules (integration to a WebApp and a Box Server). The Box Server is required to implement the Item Claim system. Requires Python 2.6 (x86) and MySQL 5.7 to work.

Download: https://disk.yandex.ru/d/7fkO7LbzYPrjtw

Installation

1. Install the Python 2.6 to directory C:\Python26.
2. Unpack the python-2.6-Lib.zip archive into the C:\Python26 directory.
3. Unpack the box.zip and steer.zip archives to your TERA Server directory.

Create Database

1. Open Navicat or HeidiSQL and connect to your MySQL server.
2. Create two databases named box2db and steer3db.
   Important! Specify the utf8 encoding with collation utf8_unicode_ci when creating the database.
3. Import sql files from the directory box\DB to database box2db in the following order:
   - BOX_schema_2.16.1.db50.sql
   - BOX_sp_2.16.1.db50.sql
   - BOX_data_2.16.1.db50.sql
   - BOX_update_2.16.1.db50.sql.
4. Import sql files from the directory steerserver\DB to database steer3db in the following order:
   - STEER_schema_3.3.1.db15.sql
   - STEER_sp_3.3.1.db15.sql
   - STEER_data_3.3.1.db15.sql
   - STEER_update_3.3.1.db15.sql.

Configuration

1. Open the file box\BoxConfig.ini and set the db_user and db_passwd parameters according to your database settings.
2. Open the file steerserver\SteerConfig.ini and set all db_user and db_passwd parameters according to your database settings.
3. Open the file boxadminweb\boxadminweb.ini and change the value of the nation_code parameter as en.
4. Open the file steerweb\steeradminweb.ini and change the value of the nation_code parameter as en.

Servers Starting

1. To start the Box Server API, run the 1_Box.bat file in the box directory.
2. To start the Steer Server, run the .bat files in the steer directory in order.
3. To start the Box Web Admin, run the Start.bat file in the boxadminweb directory.
4. To start the Steer Web Admin, run the Start.bat file in the steerweb directory.
   
   Box Web Admin panel: http://127.0.0.1:8070/ or http://YOUR_SERVER_IP:8070/
   Steer Web Admin panel: http://127.0.0.1:8060/ or http://YOUR_SERVER_IP:8060/
   Logins: boxadmin and steeradmin
   Password: password

Import the Translation

1. Unpack the archive steer_translation_EN_RU.zip to any directory.
2. Go to the Steer Web panel and select 언어 데이터 가져오기 from the 가져오기/내보내기 menu:
   
3. Click File upload button and select the file L10N_DisplayGroup_steeradmin_en.csv.
4. Click File upload button and select the file L10N_Function_steeradmin_en.csv.

Integration WebApp 100.02 with Steer Server

1. Download the patch https://disk.yandex.ru/d/Kbl7mL85m7UQ1w.
2. Unpack the patch to the WebApp\bin directory.
3. Open the file WebApp\AppResource\WebAppConfig.xml and change like that:
   

     <SteerServer addr="127.0.0.1" port="8105" />
     <Admin id="gadmin" />
     <DbSync option="execute" />

4. Restart WebApp ApplicationPool or IIS Service.
5. Login to Steer Web and set new password for the user gadmin:
   
   Spoiler:

   
   Now you can enter WebApp panel with login gadmin and your password set via Steer.

Installation of FCGI Gateway and FCGI WebServer (optional)

Spoiler:

1. Unpack the fcgi_gw.zip and fcgi_webapi.zip archives to your TERA server directory.
2. To start the FCGI Gateway, run the Start.bat file in the fcgi_gw directory.
3. To start the FCGI WebServer (nginx), run the Start.bat file in the fcgi_webapi directory.
4. The FCGI Web API will be available by default at: http://127.0.0.1:8020/
   To send an Item Box to a player, you need to send a POST request in JSON to the /make_box.json endpoint.
   Then send a GET request to the /box_noti endpoint so that the user receives a Item Claim notification.
   
   FCGI Web API reference description available here: https://disk.yandex.ru/i/-SVs5f3nk5vklg
   Requests scheme:
   
   Spoiler:

   

Integration FCGI Gateway with TeraAPI (deprecated)
The latest version of Tera API no longer requires FCGI integration for the Item Claim system to work.

Spoiler:

Integration with old version of Tera API:

1. Make sure that the Box System and the FCGI Gateway Web Server are configured correctly (see previous steps).
2. Go to the Box Web panel and create Service Items that will be sent when the premium is activated.
3. Open the config file config\chronoScroll.js and customize the boxContext section according to your preferences. Service Item ids must be specified as item_id.
4. Open your .env config file and change parameter API_PORTAL_FCGI_GW_WEBAPI_ENABLE to true.
   Change parameter API_PORTAL_FCGI_GW_WEBAPI_URL if necessary.
5. Restart tera-api.
   
   Spoiler:

Screenshots

Spoiler:

Official documentation available here: https://forum.ragezone.com/f797/tera...ation-1206071/

[MentaL]

[vileninja]

BOX_sp_2.16.1.db50.sql gives 173 errors in navicat

[hsdn]

BOX_sp_2.16.1.db50.sql gives 173 errors in navicat

You need to follow the order when importing files, as the instructions.

[vileninja]

You need to follow the order when importing files, as the instructions.

I ran BOX_sp_2.16.1.db50.sql as the 2nd sql

I also get 92 errors on the STEER_sp_3.3.1.db15.sql I also ran this one as the 2nd sql

[hsdn]

BOX_schema_2.16.1.db50.sql imported without errors?
I have no problem when importing a database using HeidiSQL.

[vileninja]

BOX_schema_2.16.1.db50.sql imported without errors?

Yes it did

[hsdn]

I checked now, there are no problems when importing. The database must be encoded utf8_unicode_ci, not utf8_general_ci.

[vileninja]

Character set is uft8mb3 and collation is utf8_,unicode_ci and I get the errors with navicat16

[argeus99]

Importing databases is working fine from navicat and heidi sql

I'm stuck at "Integration WebApp 100.02 with the Steer Server" the provided password is not working for me, tried lower and upper case without luck

For those people who has the same problem as me, check this.


@hsdn thanks for your support!

[Robyson]

Character set is uft8mb3 and collation is utf8_,unicode_ci and I get the errors with navicat16

Use utf8, then uf8_unicode_ci

https://postimg.cc/mc0nHs2G

Tested on 92.03...

https://postimg.cc/JykLgKsM

[hsdn]

Importing databases is working fine from navicat and heidi sql

I'm stuck at "Integration WebApp 100.02 with the Steer Server" the provided password is not working for me, tried lower and upper case without luck

You can try change password of gadmin user in Steer Web panel.

[vileninja]

Use utf8, then uf8_unicode_ci

https://postimg.cc/mc0nHs2G

Tested on 92.03...

https://postimg.cc/JykLgKsM

I don't have one called just uft8

https://postimg.cc/9zz4Kgny

[dziobus]

So i am running into a block when creating the DB, i dont have a flat out the option to choose: utf8_unicode_ci
I only have these encodings and i am clueless as to which to choose:

[argeus99]

So i am running into a block when creating the DB, i dont have a flat out the option to choose: utf8_unicode_ci
I only have these encodings and i am clueless as to which to choose:

Keep in mind is on MySQL not MSSQL

[Robyson]

I don't have one called just uft8

https://postimg.cc/9zz4Kgny

That's because i'm using Navicat Premium and it works for me.