help reducing maximum level of all player

[OunoriBaka]

halo.

im not good at editing in sql. but is there any command i can use to edit / lower our players maximum level?
my servers default max level is 255 i want to set it to like 99 

i already made the changes in conf and exp.txt but the first player still has their maximum level. which is kind of unfair for the new ones.


also


is there a way to reduce a headgear slot from [4] back to [1]? i dont mean editing from item db. but the ones currently used by player.


it will help a lot. thanks.

[vhan48]

Hi,this might help you:

 

http://www.eathena.ws/wiki/index.php/Edit_Max_Level

 

 

 

 

[Euphy]

Make sure all players are offline when you execute this:

UPDATE `char` SET `base_level` = 99 WHERE `base_level` > 99;

Also, make sure to reset their stats.

[OunoriBaka]

Make sure all players are offline when you execute this:

UPDATE `char` SET `base_level` = 99 WHERE `base_level` > 99;

Also, make sure to reset their stats.

thanks euphy. 

does it also works with stats? if i change some of it? i dont want to mess up my database. T_T....

@vhan - 

yep ive done that already. and compile. stil thanks.

Edited July 23, 2013 by OunoriBaka

[Euphy]

# Stat points for non-trans classes: 1273

UPDATE `char` SET `status_point` = 1273 WHERE `base_level` > 99 AND ((`class` > 4001) OR (`class` > 4022 AND `class` < 4060) OR (`class` > 4065 AND `class` < 4072) OR (`class` > 4095));

# Stat points for trans classes: 1325

UPDATE `char` SET `status_point` = 1325 WHERE `base_level` > 99 AND `status_point` != 1273;

# Lower level and reset stats

UPDATE `char` SET `base_level` = 99, `str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 WHERE `base_level` > 99;

[OunoriBaka]

# Stat points for non-trans classes: 1273
UPDATE `char` SET `status_point` = 1273 WHERE `base_level` > 99 AND ((`class` > 4001) OR (`class` > 4022 AND `class` < 4060) OR (`class` > 4065 AND `class` < 4072) OR (`class` > 4095));

# Stat points for trans classes: 1325
UPDATE `char` SET `status_point` = 1325 WHERE `base_level` > 99 AND `status_point` != 1273;

# Lower level and reset stats
UPDATE `char` SET `base_level` = 99, `str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 WHERE `base_level` > 99;

tried running it but query turn to no result.. 

btw. 

i tried removing the slot #2,3,4 (since we have [4] on our headgear) but it just delete the card that has been on it.

is there a way to remove the card and just put em back on the players inventory?

•how can i remove a specific equipment's card(s) on slot 2,3,4

example:

Dropping Imp (20404) *has quadruple kiel cards = i want to delete/remove the other kiel cards leaving behind the card on slot #1. 

(as i mention above ^ it seems like i deleted the weapon cards aswel.)

Edited July 23, 2013 by OunoriBaka

[Zaon]

# Stat points for non-trans classes: 1273
UPDATE `char` SET `status_point` = 1273 WHERE `base_level` > 99 AND ((`class` > 4001) OR (`class` > 4022 AND `class` < 4060) OR (`class` > 4065 AND `class` < 4072) OR (`class` > 4095));

# Stat points for trans classes: 1325
UPDATE `char` SET `status_point` = 1325 WHERE `base_level` > 99 AND `status_point` != 1273;

# Lower level and reset stats
UPDATE `char` SET `base_level` = 99, `str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 WHERE `base_level` > 99;

 

Will this work for 3rd job classes? (Trans to 3rd job)