[SOLVED] .sql in game?

[faiver]

How do I save everything I do in the game?

*example . npc add 90000

where is the. sql where I am the npc?

is because I want to know how I store everything in the game q. so the day to do an event or something just is extract the. sql Event

 

[Tommy]

How do I save everything I do in the game?

*example . npc add 90000

where is the. sql where I am the npc?

is because I want to know how I store everything in the game q. so the day to do an event or something just is extract the. sql Event

When typing any command that spawns or adds something for the game is automatically saved in your database. Creature spawns are saved in the creature table and gameobjects spawns are saved in the gameobject table.

Future advice: Look on their wiki (http://collab.kpsn.org/display/tc/Database:+World) or look around in the database. Answering simple questions like these get kinda annoying. The tables you want are very obvious.

 

[faiver]

If they are right. sorry if uncomfortable is that when driving Mangos every time you inserted a code is generated a sql server folder.
and did not need to go to the database to export item by item.

 

[Rochet2]

Hmm, I cant see a way in the configs : |

 

[Tommy]

If they are right. sorry if uncomfortable is that when driving Mangos every time you inserted a code is generated a sql server folder.
and did not need to go to the database to export item by item.

I didn't understand a word of that. +_+

 

[Rochet2]

I didn't understand a word of that. +_+

On mangos (at least this is how it used to be) it was default or possibly a config setting that allowed the core to create logs with the SQL statements from commands.
For example if you decided that you want to save everything you do to make a mall ingame, you could set the log on and it will save each INSERT INTO statement from spawning new creatures etc.
This way you have a full SQL file that contains the mall spawns etc. No need to extract from DB.

 

[Tommy]

On mangos (at least this is how it used to be) it was default or possibly a config setting that allowed the core to create logs with the SQL statements from commands.
For example if you decided that you want to save everything you do to make a mall ingame, you could set the log on and it will save each INSERT INTO statement from spawning new creatures etc.
This way you have a full SQL file that contains the mall spawns etc. No need to extract from DB.

I'm assuming the configuration setting no longer exists? If not, that would be easy to make. :/

 

[faiver]

jajajaj thanks for helping to explain hahaha I and searched the settings but not trinity and managed to make remove. sql: (