開啟Navicat 打開要修改的資料庫後
按F6出現
mysql> 輸入
======================================================================
UPDATE spawnlist SET respawn_delay = (respawn_delay/2);//所有怪物重生時間變成原來的1/2
UPDATE spawnlist SET respawn_delay = (respawn_delay*2);//所有怪物重生時間變成原來2倍
update spawnlist set count = 2 where mapid;//全地圖指定怪物數量
update spawnlist set count = 2 where mapid = 240;//指定區域性怪物數量
update spawnlist set count = (count/2);//全地圖指定怪物數量成原來的1/2
update spawnlist set count = (count*2);//全地圖指定怪物數量成原來2倍
update spawnlist set count = count*2 where mapid = 240;//指定區域性怪物數量成原來2倍
update droplist set max = 10 where itemId;//調整所有物品最大掉落數量為指定數量
update droplist set max = 10 where itemId = 40074;//調整該編號掉落張數最大為10張
update droplist set max = (max/2);//調整所有物品最大掉落數量為原來的1/2
update droplist set max = (max*2);//調整所有物品最大掉落數量為原來2倍
|