 | SELECT
`npc`.`name` AS `怪物名稱`,
`npc`.`npcid` AS `怪物編號`,
`spawnlist`.`count` AS `隻數`,
`spawnlist`.`min_respawn_delay` AS `最小重生`,
`spawnlist`.`max_respawn_delay` AS `最大重生`,
`mapids`.`locationname` AS `地圖名稱`,
`mapids`.`mapid` AS `地圖編號`
FROM
`spawnlist`
Inner Join `npc` ON `spawnlist`.`npc_templateid` = `npc`.`npcid`
Inner Join `mapids` ON `spawnlist`.`mapid` = `mapids`.`mapid`
WHERE
`spawnlist`.`mapid` = '180'
輸入怪物名稱 查詢分布地區
SELECT
`npc`.`name` AS `怪物名稱`,
`npc`.`npcid` AS `怪物編號`,
`spawnlist`.`count` AS `隻數`,
`spawnlist`.`min_respawn_delay` AS `最小重生`,
`spawnlist`.`max_respawn_delay` AS `最大重生`,
`mapids`.`locationname` AS `地圖名稱`,
`mapids`.`mapid` AS `地圖編號`
FROM
`spawnlist`
Inner Join `npc` ON `spawnlist`.`npc_templateid` = `npc`.`npcid`
Inner Join `mapids` ON `spawnlist`.`mapid` = `mapids`.`mapid`
WHERE
`npc`.`name` = '死亡騎士'
輸入玩家名稱查詢 魔法狀態(變身名稱)
SELECT
`characters`.`char_name` AS `玩家名稱`,
`skills`.`name` AS `魔法名稱`,
`character_buff`.`remaining_time` AS `剩餘時間`,
`characters`.`objid` AS `玩家代碼`,
`character_buff`.`poly_id` AS `變身編號`,
`polymorphs`.`name` AS `變身名稱`
FROM
`character_buff`
Inner Join `characters` ON `character_buff`.`char_obj_id` = `characters`.`objid`
Inner Join `skills` ON `character_buff`.`skill_id` = `skills`.`skill_id`
Left Join `polymorphs` ON `character_buff`.`poly_id` = `polymorphs`.`id`
WHERE
`characters`.`char_name` = '線上GM'
輸入玩家名稱查詢 學習的魔法
SELECT
`characters`.`char_name` AS `玩家名稱`,
`characters`.`objid` AS `玩家代碼`,
`character_skills`.`skill_name` AS `魔法名稱`,
`character_skills`.`skill_id` AS `魔法編號`
FROM
`characters` ,
`character_skills`
WHERE
`characters`.`char_name` = '線上GM' AND
`characters`.`objid` = `character_skills`.`char_obj_id`
ORDER BY
`魔法編號` ASC
輸入玩家名稱 查詢 身上的道具(依照 道具的等級排序)
SELECT
`characters`.`char_name` AS `玩家名稱`,
`characters`.`level` AS `等級`,
`character_items`.`item_name` AS `持有道具`,
`character_items`.`enchantlvl` AS `道具等級`,
`character_items`.`count` AS `持有數量`,
`characters`.`MaxHp` AS `血`,
`characters`.`MaxMp` AS `魔`,
`characters`.`Str` AS `力量`,
`characters`.`Con` AS `體質`,
`characters`.`Dex` AS `魅力`,
`characters`.`Cha` AS `敏捷`,
`characters`.`Intel` AS `智力`,
`characters`.`Wis` AS `精神`
FROM
`characters` ,
`character_items`
WHERE
`characters`.`objid` = `character_items`.`char_id` AND
`characters`.`char_name` = '線上GM'
ORDER BY
`道具等級` DESC,
`持有數量` DESC,
`持有道具` ASC
輸入怪物編號 查詢 怪物掉落物品
SELECT
npc.name AS `怪物名稱`,
droplist.mobId AS `怪物編號`,
droplist.itemId AS `道具編號`,
weapon.name AS `武器名稱`,
armor.name AS `防具名稱`,
etcitem.name AS `道具名稱`,
droplist.chance AS `掉落機率`
FROM
droplist
Inner Join npc ON droplist.mobId = npc.npcid
Left Join weapon ON droplist.itemId = weapon.item_id
Left Join armor ON droplist.itemId = armor.item_id
Left Join etcitem ON droplist.itemId = etcitem.item_id
WHERE
droplist.mobId = '45601'
| |
[複製鏈接]
雷達卡
發表於 2016-8-3 12:19
提升卡
置頂卡
變色卡
千斤頂
