[Sql database Command ]

[Shushu]

I need 3 sql commands for loss_mana loss_exp loss_skills

How are they so i can make them lower?

Like loss_mana set 0 or something, no idea, :S
Thanks..
Post them in the comments.
thx

 

[Shushu]

People, what are the commands? i need it rly fast.

 

[amiroslo2]

u can only bump every 24h

 

[Shushu]

Ohh sorry for spam than didnt know XDxdXDxdXDxdXD

 

[Lucenzo]

UPDATE `players` SET loss_mana = xxx, loss_experience = xxxx, loss_skills = xxxx;

 

[Santi]

UPDATE `players` SET loss_mana = 0, loss_skills = 0, loss_exp = 0

EDIT:Meh, I shouldnt watch TV

 

[Shushu]

UPDATE `players` SET loss_mana = 0

UPDATE `players` SET loss_experience = 1

UPDATE `players` SET loss_skills = 0

Like this?

 

[Shushu]

Okay, ive done it, But it only was affected to the existed chars, How do i make so it will be allways like this from when a char is started? :S

 

[Lucenzo]

As long as Sample chars have the updates and are set save then all new chars should have the same losses aswell.

 

[Shushu]

But the thing is, I do not have samples, Im not using gesior nor modern acc, But yes Avesta sql, It does not have those samples

 

[Cykotitan]

If you're using Nicaw AAC, then try to find and edit the part where it inserts the character into the database.
If you're using the ingame Account Manager then you either have to edit the default value for the columns in table players, or sources.