Buy And Sell in NPC

[Onairda]

Do we have a table in the database where we can track all the bought and sold items in the NPC?

 

I am talking for the whole NPC inside the Ragnarok.

 

I don't need a custom script to manually insert it in the database I want the default NPC script used inside the game.

 

like the tool dealer, if someone buys and sells items to the tool dealer it will be recorded.

 

 

thank you

 

 

 

 

[Winterfox]

If you have logging enabled, you can check the picklog table for rows where type is S.

// 0x00000010 - (S) Log NPC transactions (buy/sell)

For details, check log_athena.conf. The logging part is directly at the beginning of the file.

Edited September 17, 2023 by Winterfox

[AceofSpades]

1 hour ago, G-RO said:

Do we have a table in the database where we can track all the bought and sold items in the NPC?

 

I am talking for the whole NPC inside the Ragnarok.

 

I don't need a custom script to manually insert it in the database I want the default NPC script used inside the game.

 

like the tool dealer, if someone buys and sells items to the tool dealer it will be recorded.

 

 

thank you

 

 

 

 

then learn how to apply the queryl_sql guide here, you need to learn and understand how to apply it on your npc

[Onairda]

7 hours ago, AceofSpades said:

then learn how to apply the queryl_sql guide here, you need to learn and understand how to apply it on your npc

hahaha, thanks for replying . but this is not what i asked .

 

5 hours ago, Winterfox said:

If you have logging enabled, you can check the picklog table for rows where type is S.

// 0x00000010 - (S) Log NPC transactions (buy/sell)

For details, check log_athena.conf. The logging part is directly at the beginning of the file.

Thank you so much Winterfox, this what I need