[RELEASE] Atlantica Online Server V3.02.11

[rockerbla]

EDIT #2

How can I access any account from the DB ? I can only modify passwords for max 200 accounts ( from edit first 200 rows table )

My old character is around No.900 , not accesible from this edit window.

[xlw00tlx]

Originally Posted by x123x123x

Client and server file:
x:\Atlantica\CharInfo\AttackType.ndt
line:
BulletKind = BK_LASER1


Sword attack cross in the same file:
AT_GRID_CROSS = Cross attack

file:

what are those other attack types,and did you check the playeable "npc" that are spawnable for party?
some are recolored base ones and others are weird with special unique names

[Niels05]

some new server where you start creating +10 or +7

[x123x123x]

Originally Posted by rockerbla

EDIT #2

How can I access any account from the DB ? I can only modify passwords for max 200 accounts ( from edit first 200 rows table )

My old character is around No.900 , not accesible from this edit window.

Press 'Tools'; Select 'Option'; Select 'SQL Server Object Explorer'; Select 'Table and View Option'; Enter the desired value.


Or use code (update the value in the table):

USE [AT_AccountDB]
GO

UPDATE [dbo].[tbl_Account]
SET [Password] = 'Password'
WHERE [ID] = 'login_account'
GO

where
'login_account' = game login;
'Password' = MD5 hash password.

Originally Posted by Niels05

some new server where you start creating +10 or +7

You can modify the stored procedure [dbo].[rsp_PersonInfoCreate] Database [AT_GameDB01].

In the procedure code, add 1 variable:

, @SendDate int

Declare it in the procedure code:

...
DECLARE
@ret int
, @ID nvarchar(64)
, @MakeNumber int
, @Gender tinyint
, @ErrCode int
, @Count int
, @ClassMateUnique int
, @ServerCode nvarchar(35)
, @LastCreateDeleteTime datetime
, @MakeNum smallint
, @DatePerson int
, @DateBank int
, @Flag int
, @IP nvarchar(20)
, @MasterLevel int
, @ChannelIndex tinyint
, @SendDate int
...

Add the following code to the end of the procedure code:

SELECT @SendDate = [Datevary] FROM [dbo].[tbl_GameTime]
exec [AT_GameDB01].[dbo].[rsp_PostSend] 1, 1, @PersonID, NULL, 0, 0, 0, 501, 1, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, N'Gift!', @SendDate, 0, 1

This code calls for the execution of the procedure that will send a game mail to the player item.
In line figure 501 is an ID Item. (501 - "Officer's Shotgun")
Follows 1 - it is quantity, for item which can be piled.
Further in line figure 15 is a rank of a item (rank 15 = enchant +10; rank 5 = enchant +0)


If it is necessary to send several items, then we cause necessary number of times the procedure of sending a parcel. Example, 2 ring +10 "Lea's Piercing Signet":

SELECT @SendDate = [Datevary] FROM [dbo].[tbl_GameTime]
exec [AT_GameDB01].[dbo].[rsp_PostSend] 1, 1, @PersonID, NULL, 0, 0, 0, 7781, 1, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, N'Gift!', @SendDate, 0, 1
exec [AT_GameDB01].[dbo].[rsp_PostSend] 1, 1, @PersonID, NULL, 0, 0, 0, 7781, 1, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, N'Gift!', @SendDate, 0, 1

Save changes in the stored procedure code. Now any character created on the server will be automatically sent to the game mail items that you specified in the stored procedure.

[mirdad]

Excuse me, I have some problems with the Item ... As in the picture ... after I tweaked Sql so I made an error in the AT_GameDB01 section ... Stored Procedures ... I forgot what I changed ... please help me it's too far to play atlantica offline T_T ... Thank you in advance for the masters here

[rockerbla]

I think there was a post about this but I can't really find it.

How do I make FL/CL open with only me on server ?

[x123x123x]

Perhaps someone found a solution and write what to change in the settings FL\CL.
I have changed the conditions of quests, so that there were never requests for the League.

[rockerbla]

Originally Posted by x123x123x

Perhaps someone found a solution and write what to change in the settings FL\CL.
I have changed the conditions of quests, so that there were never requests for the League.

Can you help me with that please ?

[x123x123x]

Ok. As an example, will a quest to gain 100 LVL (the main character).
Quest in the file: ..\Atlantica\NewQuest\Sub36_1\Quest_Sub36_1.ndt
Part of the quest where you send 2 times to win the tournament (FL\CL does not matter what):

...
<Clear Condition>
ClearCondition Target Count MapIndex Postion_X Postion_Y Radius MapPos
QUEST_CLEAR_COND_TMPASS 0 2 -1 0 0 5
0 0 0 0 0 0 0
...

TMPASS = tournament match pass, 2 = Count = 2 times.

As a table:

ClearCondition	Target	Count	MapIndex	Postion_X	Postion_Y	Radius	MapPos
QUEST_CLEAR_COND_TMPASS	0	2	-1	0	0	5
0	0	0	0	0	0	0

Suppose we do not want to do this or CL\FL does not work.
So you need in the quest to change the conditions for its completion.
For example, instead of CL\FL open 1 time map of the world.
Change the condition to:

...
<Clear Condition>
ClearCondition Target Count MapIndex Postion_X Postion_Y Radius MapPos
QUEST_CLEAR_COND_OPENWORLDMAP 0 1 -1 0 0 5
0 0 0 0 0 0 0
...

OPENWORLDMAP - open map of the world, 1 = Count = 1 time.

As a table:

ClearCondition	Target	Count	MapIndex	Postion_X	Postion_Y	Radius	MapPos
QUEST_CLEAR_COND_OPENWORLDMAP	0	1	-1	0	0	5
0	0	0	0	0	0	0

The changes must be the same on the server and client!

[nightmander]

Ao client file is missing please lay out

[rockerbla]

I have a little issue with my client.Whenever I try to upgrade a merc it crashes...Why that's happening ?

[x123x123x]

Originally Posted by nightmander

Ao client file is missing please lay out

Downloaded, connects to the server (English client v3.02.12).

Originally Posted by rockerbla

I have a little issue with my client.Whenever I try to upgrade a merc it crashes...Why that's happening ?

I have never had, something difficult to imply.

[nightmander]

Thank you

[nephren]

Originally Posted by sarint01

Evior Want to continue to improve

Im not sure what you mean. Unfortunately, I do not have my files anymore. I wanted to share, previous but I forgot to check back, back then.

However, if there is any question I can help, just feel free to ask.

[magenub]

Originally Posted by x123x123x

Ok. As an example, will a quest to gain 100 LVL (the main character).
Quest in the file: ..\Atlantica\NewQuest\Sub36_1\Quest_Sub36_1.ndt
Part of the quest where you send 2 times to win the tournament (FL\CL does not matter what):

TMPASS = tournament match pass, 2 = Count = 2 times.

As a table:

Suppose we do not want to do this or CL\FL does not work.
So you need in the quest to change the conditions for its completion.
For example, instead of CL\FL open 1 time map of the world.
Change the condition to:

OPENWORLDMAP - open map of the world, 1 = Count = 1 time.

As a table:

The changes must be the same on the server and client!

You can also just set the count to 0 instead of changing the objective type and the quest insta completes