|
|
本帖最后由 kkndbdra@tj 于 2019-5-31 16:26 编辑
最近用python 做了个脚本
数据库：sjmap.db
表名称：roomsdata
大家把lua简单改写一下 可以做成GPS导航功能。
把room.lua里面的房间数据：
Room {
id = "changan/xiaoyanta15",
name = "小雁塔十五层",
ways = {
["down"] = "changan/xiaoyanta14",
},
}
这种格式的都转换成了键值对（字典格式）：
{
"id": "changan/xiaoyanta15",
"name": "小雁塔十五层",
"ways": {
"down": "changan/xiaoyanta14",
},
},
除了数字自增主键num_id之外，其他全部用的 TEXT字段
['blocks', 'find', 'id', 'lengths', 'name', 'no_fight', 'nofind', 'nolooks', 'objs', 'outdoor', 'postcmds', 'precmds', 'room_relative', 'ways']
数据库：SQLITE3
数据库可视化软件：百度上搜 SQLITESPY 可以和操作excel一样直接编辑好维护
MUSH好像自带SQLITE模块，请查阅相关文档
lua需要安装Luasql库
python 自带 sqlite3 直接import sqlite3
应大家要求把其他数据也写入了数据库：
lookCitys = {
"baituo" : "白驼山", "beijing" : "京城", "cangzhou" : "沧州城", "changan" : "长安城",
"changle" : "长乐帮", "chengdu" : "成都城", "city" : "扬州城", "dali" : "大理城",
"daliwest" : "大理城西","dalisouth" : "大理城南","dalieast" : "大理城东",
"wuliang" : "无量山", "dlhg" : "大理皇宫", "wangfu" : "大理王府", "gumu" : "终南山",
"yuxu" : "玉虚观", "death" : "十八层地狱", "emei" : "峨嵋山", "yideng" : "桃源县",
"foshan" : "佛山镇", "fuzhou" : "福州城", "gb" : "丐帮", "fairyland" : "昆仑山",
"jqg" : "绝情谷", "xuantie" : "襄阳郊外", "hengshan" : "恒山", "hj" : "回疆",
"hmy" : "黑木崖", "pingding" : "平定州", "huanghe" : "黄河流域", "yyd" : "萧府",
"huashan" : "华山派", "hz" : "杭州城", "jiaxing" : "嘉兴城", "kunlun" : "昆仑派",
"lanzhou" : "兰州城", "meizhuang" : "梅庄", "miaojiang" : "苗疆", "mingjiao" : "明教",
"hdg" : "蝴蝶谷", "hhd" : "冰火岛", "lsd" : "灵蛇岛", "mr" : "姑苏慕容",
"yanziwu" : "燕子坞", "mtl" : "曼佗罗山庄", "nanyang" : "南阳城", "ningbo" : "宁波城",
"putian" : "莆田少林", "shaolin" : "少林派", "sld" : "神龙教", "songshan" : "嵩山派",
"suzhou" : "苏州城", "taishan" : "泰山", "tanggu" : "塘沽城", "thd" : "桃花岛",
"niujia" : "牛家村", "guiyun" : "归云庄", "tianshan" : "天山", "tiezhang" : "铁掌帮",
"tls" : "天龙寺", "village" : "华山村", "wizard" : "极乐世界", "wudang" : "武当派",
"houshan" : "武当后山", "wuguan" : "武馆", "xiakedao" : "侠客岛", "xiangyang" : "襄阳城",
"lzz" : "柳宗镇", "xingxiu" : "星宿派", "yili" : "伊犁城", "xueshan" : "大轮寺",
"caoyuan" : "大草原", "zhiye" : "郊外", "group" : "中原",
"entry" : "",
}
citys = {
"baituo" : "白驼山", "beijing" : "京城", "cangzhou" : "沧州", "changan" : "长安",
"changle" : "长乐帮", "chengdu" : "成都", "city" : "扬州", "dali" : "大理国",
"death" : "十八层地狱", "emei" : "峨嵋山", "fairyland" : "昆仑仙境","foshan" : "佛山",
"fuzhou" : "福州", "gb" : "丐帮分舵", "gumu" : "古墓", "hengshan" : "恒山",
"hj" : "回疆", "hmy" : "黑木崖", "huanghe" : "黄河流域", "huashan" : "华山",
"hz" : "杭州", "jiaxing" : "嘉兴", "kunlun" : "昆仑山",
"lanzhou" : "兰州", "miaojiang" : "苗疆", "mingjiao" : "明教", "murong" : "慕容",
"mr" : "s", "nanyang" : "南阳", "ningbo" : "宁波", "putian" : "莆田少林",
"meizhuang" : "梅庄", "shaolin" : "嵩山少林", "sld" : "神龙岛", "songshan" : "嵩山",
"suzhou" : "苏州", "taishan" : "泰山", "tanggu" : "塘沽", "thd" : "桃花岛",
"tiezhang" : "铁掌山", "tls" : "天龙寺", "village" : "华山村", "wizard" : "极乐世界",
"wudang" : "武当山", "wuguan" : "武馆", "xiangyang" : "襄阳", "xingxiu" : "星宿海",
"xueshan" : "大雪山", "yangzhou" : "扬州", "guiyun" : "归云庄", "hdg" : "蝴蝶谷",
"jqg" : "绝情谷", "bhd" : "冰火岛", "lsd" : "灵蛇岛", "pingding" : "平定州",
"caoyuan" : "大草原", "niujia" : "牛家村", "wuliang" : "无量山", "wangfu" : "镇南王府",
"yideng" : "桃源县", "yili" : "伊犁", "yanziwu" : "燕子坞", "mtl" : "曼佗罗山庄",
"shijian" : "试剑山庄", "zhiye" : "中原神州",
}
otherCitys = {
"gumu" : ("古墓派", "成都郊外", "大理城北", "丝绸之路", "回疆草原",)
这些也新建了三个表：lookcitys,citys,othercitys
字段名都是三个：num_id,eng_name,cn_name
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看，没有账号？注册
×
|
闽公网安备 35050202000162号 )
发表于 2019-5-30 19:02:17