Some Help Please

[joshy9]

Does anyone know anything / what to do about these?

1. I tried adding items and changing drop rates on monsters but they are not taking affect. i clicked All Modify (Save) this saves as a .dat file and even save text. but nothing is changing. -

2. How do i add NPCs in Rome? like if i want to place all the Skill NPCs in Rome how do i do this?

Many Thanks

[joshy9]

oh and also add items to market at a Fixed Price.

[nephren]

Any kind of changes within loots, will be saved on your client side. You have to copy the Client DAT file and replace it at your Server.

NPCGroup > Console (also saved client side-dat file.)

[joshy9]

Originally Posted by nephren

Any kind of changes within loots, will be saved on your client side. You have to copy the Client DAT file and replace it at your Server.

NPCGroup > Console (also saved client side-dat file.)

Many Thanks for the help, do you know how to add items to market at a fixed price? for example Atlas Ore - 1,000 FIXED ? also how to do make npc's you add just stand instead of walking? one last question too is how to you turn into a GM? i made a gm account but they appear as normal char with gm commends.

[x123x123x]

Originally Posted by joshy9

oh and also add items to market at a Fixed Price.

Edit file:
x:/server/LANG/ENG/NPCTRADEITEM/npctradeitem_eng.ndt

For example, if you add the following line:
501 0 일급 교도관의 산탄총 1000

Result: "Officer's Shotgun" at a fixed price 1000.

Korean names of the item can be taken from the files in the folder x:/server/ITEM/DATA/


The client files no need to fix.

[joshy9]

Originally Posted by x123x123x

Edit file:
x:/server/LANG/ENG/NPCTRADEITEM/npctradeitem_eng.ndt

For example, if you add the following line:
501 0 일급 교도관의 산탄총 1000

Result: "Officer's Shotgun" at a fixed price 1000.

Korean names of the item can be taken from the files in the folder x:/server/ITEM/DATA/


The client files no need to fix.

oh thank you so much, now i just need to figure out how to turn in to a [GM] angel with the white wings. and how to make npcs stop walking after adding them in.

[x123x123x]

how to turn in to a [GM] angel with the white wings

I badly understand about what here. To look at a nickname of this GM. Better screenshot.

[joshy9]

Originally Posted by x123x123x

I badly understand about what here. To look at a nickname of this GM. Better screenshot.

this is what i mean, i wanted to know how to turn into the GM Angel -->

[x123x123x]

This model "MASTER1" (Kind_1 - Kind_4). To understand still how models are divided on mercenaries, npc and monsters. I think it different groups. In them conditions, for example change of model have to be described at an upgrade of the mercenary. Somewhere there it is necessary to look for the answer.

[kesttutiss25]

can any help ant tell how put pegasus items on client ?
mayby any hawe files for pegasus items. plz share or tell me plz wery big ty

[joshy9]

Originally Posted by x123x123x

This model "MASTER1" (Kind_1 - Kind_4). To understand still how models are divided on mercenaries, npc and monsters. I think it different groups. In them conditions, for example change of model have to be described at an upgrade of the mercenary. Somewhere there it is necessary to look for the answer.

thanks and thank you for all your help. all i need to do now is figure out how to reset the database. clean database from all guilds, characters, nations and accounts. so the account id, person id, guild id and nation id etc restarts at 1 instead of 1937.

[nephren]

To turn into GM use the SolMain > Idx 0 and change Kind to 3

Start with IDs: 1
TRUNCATE TABLE
DBCC CHECKIDENT

[x123x123x]

When rewriting tables there were errors with sending on an foreign key. I haven't risked to delete this key and have just cleared tables of contents. Because of it some counters weren't nullified.
There is a lot of such keys, about 20 pieces. They in fact create dependences of tables among themselves.

-------
In the procedure the StoredProcedure [dbo].[rsp_MarketTrade] (AT_GameDB01) noticed an error. The variable with an error in her name is used.
It isn't sure that the mistake in the register of a symbol can create a problem (Ee).

Original:

...
SELECT @REsultBankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...

Fixed:

...
SELECT @ResultBankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...

No declare: @REsultBankMoney; Declare: @ResultBankMoney.

If "E=е" in a name, then it doesn't influence result. And if a name unique, then as a result there can be errors in a market.
I haven't noticed a difference in a game so far.

[joshy9]

Originally Posted by nephren

Start with IDs: 1
TRUNCATE TABLE
DBCC CHECKIDENT

Thanks for posting. could you kindly write a step by step guide i have no clue where to start what to get and how to run it.

Many Thanks to you all

[x123x123x]

USE [AT_GameDB01]
GO

UPDATE [dbo].[tbl_SolMain]
SET [PersonID] = 1933 /* ID your Person, example 1933 */
,[Kind] = 3

WHERE [PersonID] = 1933 /* ID your Person, example 1933 */
GO

result: