[RELEASE] Atlantica Online Server V3.02.11

[x123x123x]

MSSQL stored procedures reference linked servers.
This is done correctly because it we have everything here in 1 MSSQL. In reality, these are several instances of MSSQL on different physical servers that make up the overall game complex.
Linked servers are used to link databases to each other.
Databases all:

There is a function to update the server is to click on the game server console and press F11. But she needs either the files or link. I didn't know much about it.
Probably found a way to connect to the official update channels...

[HighGamer.]

Thanks the AtlanticaWeb linked server fixed the item mall problem.




how would I add a item_mall item to all players like a event item? do I use

dbo.NGM_BUY_INS_EVENT ? for all players inserting

or the only way is to create a dbo.NGM_BUY_INS for every player in game run a ton of times?.

P.S.> anyone got a list of items with item Id's a file with all the items and id's to them so i can create a input box drop-down in website to select which item I want to add to item-mall

[x123x123x]

I don't fully understand the code, but noticed this stuff that using itemmall he sends the product for all characters of the account (duplicates). Maybe it's just me. This database is created for the website and launchers. Some procedures create an html response to a site request.

[HighGamer.]

Sending to all characters on a account is not bad that's good I want it like that, But sending to all Id's thats a challenge, i guess I'll just loop through all accounts and send a bunch of NGM_BUY_INS for every id.

Here is a sample of the item list I found from the file TextMgr_Item_ENG.NDT

3668	Smoked Salmon		2.8	4562
3669	Rice Cake Stick		2.8	4562
3670	Surprise Box		2.8	4563
3671	Scroll of the Hero Pack(7days)		2.8	4584
3672	Requiem Scroll		2.8	4593
3673	Glimmering Soul Jar		2.8	4593
3674	Liyu's Jade Trinket		2.8	4593
3675	Boatman's Accessory Box		2.8	4593
3676	Old Tombstone Piece		2.8	4593
3677	Broken Lamp		2.8	4593
3678	Money Ghost's Gold Bundle		2.8	4593
3679	Traditional Lion Mask		2.8	4593
3680	Nether King's Maid's Note	   	2.8	4593

AS you can see the Smoked Salmon says its 3668. But somehow to add this item you need to type 16004. Where can i find those numbers ?

[x123x123x]

All items are located in the 'Item' folder in the item description and properties files.
Almost all of the files it is better to read as a table.
For example:

ItemTypeFood
2007-01-31
V1.0
KIMNERE
<Data>
....

Unique

Name

NameTextNum

Code

ImageFile

ImageFont

GradeCode

bUse

IsShow

ItemFunc

FuncParam

EffectKind

UseWill

ItemMall

PCRoomOnly

TradeList

TradeNPC

Work

MakeSkillLevel

Life

Mana

IsOrder

QuickItem

productUnit

Material

Tool

CoolingTime

Explain

OnlyEmployMake

16004

훈제 연어

3668

NULL

17

40

NORMAL

1

1

NULL

NULL

MAGIC_AWAKE_HIT

0

1

FALSE

0

0

0

0

1000

1000

0

0

0

NULL

NULL

500

0

0

This shows that the property "item name" has the code 3668 in the text Manager. This is exactly what is displayed in the client\server, the primary name of the item in Korean language is something like a comment.
The unique item number will always be the first in the table.

[HighGamer.]

cool thanks mate thats exactly what I was looking for.
I'll make a tool to link it all together in a nice little dump
Thanks tool is done here is the dump I made from all the NDT files combined together
Tools done.. I dumped dump.txt with a bunch of 0's (couldn't find those in NDT's)
in dumphtml.txt since I will use that.. I removed all 0's so it's missing the items it couldn't find.
improved dumphtml.txt by sorting every name in ABC order to find items easier.
also added regular dump.txt sorted in ABC order (kinda useless but ya)

also included the source code to the dumper tool i made for this task.

[x123x123x]

Wouldn't it be better to leave it in different files as different types of items?
(food, boots, mounts, armor, etc.)
Although if you use it as a search, it will be better in one file.

[HighGamer.]

All thats missing now is some newer Atlantica files

[x123x123x]

No one wants to share files of a newer version...

[BazzCreative]

Originally Posted by x123x123x

No one wants to share files of a newer version...

And this is very very sad.

[HighGamer.]

Anyone know why when I put mercenary inside a house, I go to the house and it's not there?

also do you know how to view a online user count or players who are online in database

[x123x123x]

Anyone know why when I put mercenary inside a house, I go to the house and it's not there?

This behavior indicates that you have a problem with the linked Bridge server.
1) It is possible you have not configured ie you need properties to enable RPC and RPC OUT = true.
2) The MSDTC service may have shut down. On some operating systems, it turns off automatically.
3) You may not have activated the game time with the /timeon command.

The database may not have a record of the current number of players online. But, there is an entry in the server logs, in the file server.txt ( ..\Atlantica\Config\server.txt )

machine translator from Korean to English and further line-by-line comparison (app WinMerge)

[HighGamer.]

Originally Posted by x123x123x

This behavior indicates that you have a problem with the linked Bridge server.
1) It is possible you have not configured ie you need properties to enable RPC and RPC OUT = true.
2) The MSDTC service may have shut down. On some operating systems, it turns off automatically.
3) You may not have activated the game time with the /timeon command.

The database may not have a record of the current number of players online. But, there is an entry in the server logs, in the file server.txt ( ..\Atlantica\Config\server.txt )

machine translator from Korean to English and further line-by-line comparison (app WinMerge)

Found the command to fix mercenaries in house bug

/hsetheexp command

[magenub]

Has anyone been able to crack the quest based level caps? Haven't found it yet in the stored procedures so I'm starting to think it's unfortunately held in the gameserver

[x123x123x]

In quests and database there are no conditions to limit the character to receive levels.
I suspect that the restriction process occurs in the event file: ../CharInfo/EVENTCHAR.DAT
I currently do not have an active server to view events for pc\npc.
Maybe in the gm interface (F10) there is a window for working with events. Otherwise, events are generated by gmtool.