Mysql

[mahant]

Hey,
I need fastly mysql text which will:

Make that you dont lose any skills and mlvl.

Can anyone help me ?:/ Ty.

 

[Evan]

open mysql.sql with text editor program,

look for this:

	`loss_mana` INT NOT NULL DEFAULT 100,
	`loss_skills` INT NOT NULL DEFAULT 100,

change to:

	`loss_mana` INT NOT NULL DEFAULT 0,
	`loss_skills` INT NOT NULL DEFAULT 0,

 

[mahant]

where is Mysql.sql?

 

[Evan]

should be in a folder called schemas

 

[mahant]

update players set loss_skills=0;

I made it,
how to make that will not loss eq and magic

 

[Evan]

same thing?...

magic is mana
eq is items

 

[mahant]

heh, i got a problem dude.
Maybe u can help me once again, (offtopic)

How can i reload talkactions ? I mean not with command, cuz i just turned off talkactions. I think u understand what i say

 

[Evan]

To be totally honest with you, I have no idea, I didn't know you can turn them off
Someone else will have to help you with that sorry

 

[Cykotitan]

Make an action or movement script with doReloadInfo(RELOAD_TALKACTIONS)

 

[Chris]

If someone else requires an easy way of changing the loss percentages.

-- Decide what the loss percentage (0-100 where 0 is never and 100 is always) should be for the following columns:
SET @experience = 0,
@health = 0,
@mana = 0,
@skills = 0,
@items = 0,
@containers = 0;



-- Do not touch these lines.
ALTER TABLE `players` MODIFY `loss_experience` INT(11) DEFAULT @experience, MODIFY `loss_health` INT(11) DEFAULT @health, MODIFY `loss_mana` INT(11) DEFAULT @mana, MODIFY `loss_skills` INT(11) DEFAULT @skills, MODIFY `loss_items` INT(11) DEFAULT @items, MODIFY `loss_containers` INT(11) DEFAULT @containers;
UPDATE `players` SET `loss_experience` = @experience, `loss_health` = @health, `loss_mana` = @mana, `loss_skills` = @skills, `loss_items` = @items, `loss_containers` = @containers;

 

[mahant]

@up
Nice, .
Thanks all for replying, and Bye =)