[RELEASE] Atlantica Online Server V3.02.11

[sutan123]

Originally Posted by agos

How do we create GM character like that?

used script in SQL server

[x123x123x]

Originally Posted by Basti87

Yeah the problem is I can't run the Servers, having errors after errors.
And I really have no clue and knowledge what I should do to solve the issue.

That's why I was asking about a file which is ready to download and just change the id or something simple.

And what are server errors? Configuration it seems not very complicated.


Сreate a GM from any existing account:

USE [AT_AccountDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
UPDATE dbo.tbl_Account SET MasterLevelValue = 120, MasterLevelExpireTime = '2100-12-06 21:33:00.000' WHERE ID = 'your login'

[natakusumajr]

Originally Posted by grccorrea

Im put my nick on the char unique but not happen, im click on init all quests and not happen, can you help me? =D

Not your nickname but your char uniq

iam try edit item in box but some time using item failed, what wrong

[Basti87]

Can you guys make a step by step tutorial please ?
I downloaded the files what's next ?

[odnako]

Originally Posted by Basti87

Can you guys make a step by step tutorial please ?
I downloaded the files what's next ?

Next step - read all page of this thread

[natakusumajr]

Originally Posted by odnako

Next step - read all page of this thread

So funny bro, please read all page to step and fixing error

[odnako]

Originally Posted by natakusumajr

So funny bro, please read all page to step and fixing error

no funny - i'ts real. i already read full this thread and launch server.... after reading - i no have questions.

[sutan123]

Originally Posted by odnako

no funny - i'ts real. i already read full this thread and launch server.... after reading - i no have questions.

dont hear him.. maybe he think its easy

[x123x123x]

Originally Posted by Basti87

Can you guys make a step by step tutorial please ?
I downloaded the files what's next ?

1.To install and configure MSSQL.
2.Restore from the backup of the databases.
3.To configure ODBC.
4.To configure the databases (linked servers, the records in the tables).
5.Allow service the MSDTC transaction over the network.
6.To configure the game and support the servers.
7.To configure the game client (IP).
8.It is possible to configure the firewall.

Start all servers and client.

It seems nothing is forgotten.
Earlier in the topic there are several videos on installing the server on different OS. Some videos are not complete because the task was not the creation of a full server, only to run on different operating systems.

[neuronet]

For those who want to run the MSSQL server on a different box... to save resources you are now able to run it on Ubuntu 16.04 !!!

Here's a bash script for the installation of MSSQL 2017 on Ubuntu 16.04 (thx to Microsoft )

#!/bin/bash

# Use the following variables to control your install:

# Password for the SA user (required)
MSSQL_SA_PASSWORD='<YourStrong!Passw0rd>'

# Product ID of the version of SQL server you're installing
# Must be evaluation, developer, express, web, standard, enterprise, or your 25 digit product key
# Defaults to developer
MSSQL_PID='developer'

# Install SQL Server Agent (recommended)
SQL_INSTALL_AGENT='y'

# Install SQL Server Full Text Search (optional)
# SQL_INSTALL_FULLTEXT='y'

# Create an additional user with sysadmin privileges (optional)
# SQL_INSTALL_USER='<Username>'
# SQL_INSTALL_USER_PASSWORD='<YourStrong!Passw0rd>'

if [ -z $MSSQL_SA_PASSWORD ]
then
  echo Environment variable MSSQL_SA_PASSWORD must be set for unattended install
  exit 1
fi

echo Adding Microsoft repositories...
sudo curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
repoargs="$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list)"
sudo add-apt-repository "${repoargs}"
repoargs="$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)"
sudo add-apt-repository "${repoargs}"

echo Running apt-get update -y...
sudo apt-get update -y

echo Installing SQL Server...
sudo apt-get install -y mssql-server

echo Running mssql-conf setup...
sudo MSSQL_SA_PASSWORD=$MSSQL_SA_PASSWORD \
     MSSQL_PID=$MSSQL_PID \
     /opt/mssql/bin/mssql-conf -n setup accept-eula

echo Installing mssql-tools and unixODBC developer...
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools unixodbc-dev

# Add SQL Server tools to the path by default:
echo Adding SQL Server tools to your path...
echo PATH="$PATH:/opt/mssql-tools/bin" >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

# Optional SQL Server Agent installation:
if [ ! -z $SQL_INSTALL_AGENT ]
then
  echo Installing SQL Server Agent...
  sudo apt-get install -y mssql-server-agent
fi

# Optional SQL Server Full Text Search installation:
if [ ! -z $SQL_INSTALL_FULLTEXT ]
then
    echo Installing SQL Server Full-Text Search...
    sudo apt-get install -y mssql-server-fts
fi

# Configure firewall to allow TCP port 1433:
echo Configuring UFW to allow traffic on port 1433...
sudo ufw allow 1433/tcp
sudo ufw reload

# Optional example of post-installation configuration.
# Trace flags 1204 and 1222 are for deadlock tracing.
# echo Setting trace flags...
# sudo /opt/mssql/bin/mssql-conf traceflag 1204 1222 on

# Restart SQL Server after installing:
echo Restarting SQL Server...
sudo systemctl restart mssql-server

# Connect to server and get the version:
counter=1
errstatus=1
while [ $counter -le 5 ] && [ $errstatus = 1 ]
do
  echo Waiting for SQL Server to start...
  sleep 3s
  /opt/mssql-tools/bin/sqlcmd \
    -S localhost \
    -U SA \
    -P $MSSQL_SA_PASSWORD \
    -Q "SELECT @@VERSION" 2>/dev/null
  errstatus=$?
  ((counter++))
done

# Display error if connection failed:
if [ $errstatus = 1 ]
then
  echo Cannot connect to SQL Server, installation aborted
  exit $errstatus
fi

# Optional new user creation:
if [ ! -z $SQL_INSTALL_USER ] && [ ! -z $SQL_INSTALL_USER_PASSWORD ]
then
  echo Creating user $SQL_INSTALL_USER
  /opt/mssql-tools/bin/sqlcmd \
    -S localhost \
    -U SA \
    -P $MSSQL_SA_PASSWORD \
    -Q "CREATE LOGIN [$SQL_INSTALL_USER] WITH PASSWORD=N'$SQL_INSTALL_USER_PASSWORD', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON; ALTER SERVER ROLE [sysadmin] ADD MEMBER [$SQL_INSTALL_USER]"
fi

echo Done!

I've tested MSSQL on Linux for a while and I'm really happy about the performance of it.

[ruammit]

I want to make it possible to create Chare Name other language?

[agos]

What is the command for clear a quest? F10 GUI tool not working for me

[odnako]

Originally Posted by agos

What is the command for clear a quest? F10 GUI tool not working for me

F10 - quest - enter char unicue number (near nick name) - click Set - Serch NPC name - Select quest - click quest pass.

[agos]

Originally Posted by odnako

F10 - quest - enter char unicue number (near nick name) - click Set - Serch NPC name - Select quest - click quest pass.

It's worked, thank you, my fault before is I type my char name not char unique number

[x123x123x]

Big Bank! Example: bank limit = 900 billions.
1. Go to table [dbo].[tbl_BankAccount] database [GameDB01].
2. See Constraints. Select [CK_tbl_BankAccount], press right click -> Modyfy.

In the window that appears [Check Constraints] select the first line in the (General) Expression -> [..]

Change the value:

([Money]>=(-900000000000.) AND [Money]<=(900000000000.))

Confirm and close window.
This value affects the total size of your Bank.
Limit for type (bigint) data = -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
Next:
3. Go to stored procedure [dbo].[rasp_BankMoneyInput] database [GameDB01].
Right click -> select Modify.
Replace value condition:

WHERE PersonID = @PersonID and VillageUnique > 0 and ( ([Money]+@InputMoney) <= 900000000000 )

900bil -> The value of gold that a character can put in the Bank.
We perform the procedure (Execute or Press F5).
Close query. Watch out if changes in the procedure -> rignt click -> select Modify.
If the procedure has changed as you like, then close all.

If the procedure has not changed, then do another way:
Right click -> Script Stored Procedure as -> DROP an CREATE to -> New Query (or File..). Change the value in the condition. Execute the query.
Save to file is useful because it is written the value before replacement, if you want to reset then just run the query from a file.

The result is the ability to store gold in the Bank of more than 20billions and the ability to send in a Deposit and take the Deposit character.
Video:
PS Restart the game server and SQL server are not needed.