AslroNx's World

Sql 相关

2020-2-25 aslronx

update item_template set RequiredLevel = 1 where Quality = 0;

update item_template set RequiredLevel = 1 where Quality = 1;

update item_template set RequiredLevel = 3 where Quality = 2;

update item_template set RequiredLevel = 6 where Quality = 3;

update item_template set RequiredLevel = 10 where Quality = 4;

update item_template set RequiredLevel = 15 where Quality = 5;

update item_template set RequiredLevel = 20 where Quality = 6;

#item 使用等级修改

update item_template set RequiredLevel = ceil(ItemLevel/10) where RequiredLevel >0;

#item 使用等级修改

update item_template set RequiredLevel = 0 where ItemLevel<10;

update item_template set RequiredLevel = 1 where ItemLevel >9 and ItemLevel<20;

update item_template set RequiredLevel = 2 where ItemLevel >19 and ItemLevel<30;

update item_template set RequiredLevel = 3 where ItemLevel >29 and ItemLevel<40;

update item_template set RequiredLevel = 4 where ItemLevel >39 and ItemLevel<50;

update item_template set RequiredLevel = 5 where ItemLevel >49 and ItemLevel<60;

update item_template set RequiredLevel = 6 where ItemLevel >59 and ItemLevel<70;

update item_template set RequiredLevel = 7 where ItemLevel >69 and ItemLevel<80;

update item_template set RequiredLevel = 8 where ItemLevel >79 and ItemLevel<90;

update item_template set RequiredLevel = 9 where ItemLevel >89 and ItemLevel<100;

update item_template set RequiredLevel = 10 where ItemLevel >99 and ItemLevel<110;

update item_template set RequiredLevel = 11 where ItemLevel >109 and ItemLevel<120;

update item_template set RequiredLevel = 12 where ItemLevel >119 and ItemLevel<130;

update item_template set RequiredLevel = 13 where ItemLevel >129 and ItemLevel<140;

update item_template set RequiredLevel = 14 where ItemLevel >139 and ItemLevel<150;

update item_template set RequiredLevel = 15 where ItemLevel >149 and ItemLevel<160;

#creature 等级修改

update creature_template set MinLevel = 1,MaxLevel = 4 where Rank = 0;

update creature_template set MinLevel = 4,MaxLevel = 9 where Rank = 1;

update creature_template set MinLevel = 9,MaxLevel = 16 where Rank = 4;

update creature_template set MinLevel = 16,MaxLevel = 25 where Rank = 2;

update creature_template set MinLevel = 25,MaxLevel = 36 where Rank = 3;

#creature 等级修改 update creature_template set MinLevel = 1,MaxLevel = 2 where MinLevel <20;

update creature_template set MinLevel = 2,MaxLevel = 3 where MinLevel >19 and MinLevel <30;

update creature_template set MinLevel = 3,MaxLevel = 4 where MinLevel >29 and MinLevel <40;

update creature_template set MinLevel = 4,MaxLevel = 5 where MinLevel >39 and MinLevel <50;

update creature_template set MinLevel = 5,MaxLevel = 6 where MinLevel >49 and MinLevel <60;

update creature_template set MinLevel = 6,MaxLevel = 7 where MinLevel >59 and MinLevel <70;

update creature_template set MinLevel = 7,MaxLevel = 8 where MinLevel >69 and MinLevel <80;

#creature 生命值修改

update creature_template set MinLevelHealth = MinLevel *MinLevel +100,MaxLevelHealth = MaxLevel *MaxLevel +100;

#player 基础生命值修改

update player_classlevelstats set basehp=level*level+100;

#player 基础魔法值修改

update player_classlevelstats set basemana=(level*level+100)/2;

#player 升级经验值修改

update player_xp_for_level set xp_for_next_level=lvl*(lvl+1)*100;