城际通插件地图For神灯教新手套增加内置路径支持

foolenough · 发表于 2020-1-26 15:39:36

本帖最后由 foolenough 于 2020-1-27 10:55 AM 编辑

使用内置路径有几大好处：
1. 省服务器资源，降低服务器负载
2. set walk_spped -1之后走路更快
3. 更为准确
之前因为有内置CD，导致实用性不高。
zine最近非常开明的取消了内置CD，现同步更新新手套中的地图数据如下。
增加了绝大部分内置路径之间的路径，set walk_speed -1后使用。解压后替换原插件的db文件即可

db_new.zip (597.57 KB, 下载次数: 3287)

foolenough · 发表于 2020-1-26 16:05:53

本帖最后由 foolenough 于 2020-1-26 04:13 PM 编辑

附上本次修改相应素材和脚本

#! /bin/python
import sqlite3
#conn = sqlite3.connect('pkuxkx_p2palias_v2016.db')
conn = sqlite3.connect("pkuxkx_p2palias_v2019_1020.db")
cursor = conn.cursor()
# return nodeno by nodeid
def get_nodeno(nodeid):
cursor.execute('select nodeno from mud_node where nodeid="%s"' % nodeid)
nodeno = cursor.fetchone()
if nodeno is None:
print(nodeid)
return nodeno
return nodeno[0]
lz = [
"lanzhou,hhbeigudu,walk lingzhou",
"hhbeigudu,lanzhou,walk lanzhou",
"lanzhou,huangzhong",
"huangzhong,xingxiu"
]
bj = [
"puyang,huanghebeidukou3,walk qufu",
"huanghebeidukou3,puyang,walk puyang",
"puyang,beijing",
"beijing,andingmen,walk anding",
"andingmen,beijing,walk yongan",
"beijing,deshengmen,walk desheng",
"deshengmen,beijing,walk yongan",
"beijing,guanganmen,walk guangan",
"andingmen,beijing,walk yongan",
"andingmen,guanwailaolongtou,walk guanwai",
"guanwailaolongtou,andingmen,walk beijing",
"andingmen,deshengmen,walk desheng",
"deshengmen,andingmen,walk anding",
"andingmen,guanganmen,walk guangan",
"guanganmen,andingmen,walk anding",
"deshengmen,guanganmen,walk guangan",
"guanganmen,deshengmen,walk desheng",
"deshengmen,zhangjiakou,walk zhangjiakou",
"zhangjiakou,deshengmen,walk beijing",
"zhangjiakou,menggutulu,walk menggu",
"menggutulu,zhangjiakou,walk zhangjiakou",
"zhangjiakou,jinyangguangchang,walk jinyang",
"jinyangguangchang,zhangjiakou,walk zhangjiakou",
"jinyangguangchang,fenglingdu,walk luoyang",
"fenglingdu,jinyangguangchang,walk jinyang",
"jinyangguangchang,riyue,walk riyue",
"riyue,jinyangguangchang,walk jinyang",
"jinyangguangchang,guanganmen,walk beijing",
"guanganmen,jinyangguangchang,walk jinyang",
"riyue,guanganmen,walk beijing",
"guanganmen,riyue,walk riyue",
]
yz= [
"yangzhou,yangzijin,walk zhenjiang",
"yangzijin,yangzhou,walk yangzhou",
"yangzhou,changjiangbeidukou1,walk jiankang",
"changjiangbeidukou1,yangzhou,walk yangzhou",
"yangzhou,qufugulou,walk qufu",
"qufugulou,yangzhou,walk yangzhou",
"yangzhou,gaibang",
"yangzhou,xinyang",
"qufugulou,taishandaizongfang,walk taishan",
"taishandaizongfang,qufugulou,walk qufu",
"qufugulou,huanghenandukou1,walk puyang",
"huanghenandukou1,qufugulou,walk qufu",
"qufugulou,huaibei,walk huaibei",
"huaibei,qufugulou,walk qufu",
"huaibei,xuchang",
"nanyang,xuchang",
"ruzhou,xuchang",
"xinyang,xuchang",
"xinyang,cjbeidukou2,walk jiangzhou",
"cjbeidukou2,xinyang,walk xinyang",
"xinyang,xiangyang",
"xinyang,shashouguangchang,walk shashou",
"shashouguangchang,xinyang,walk xinyang",
"xiangyang,nanyang",
"xiangyang,wudangshanmen,walk wudang",
"wudangshanmen,xiangyang,walk xiangyang",
"xiangyang,jingzhou",
"jingzhou,lingji,walk yueyang",
"lingji,jingzhou,walk jingzhou",
"nanyang,luoyang",
"nanyang,xiaocun,walk huashancun",
"xiaocun,nanyang,walk nanyang",
"xiaocun,quanzhengongmen,walk quanzhen",
"quanzhengongmen,xiaocun,walk huashancun",
"quanzhengongmen,gumu,walk gumu",
"gumu,quanzhengongmen,walk quanzhen",
"xiaocun,huashanqianchichuang,walk huashan",
"huashanqianchichuang,xiaocun,walk huashancun",
"luoyang,mengjindu,walk jinyang",
"mengjindu,luoyang,walk luoyang",
"luoyang,ruzhou",
"ruzhou,2xu,walk shaolin",
"2xu,ruzhou,walk ruzhou",
"luoyang,qilincun",
"luoyang,changantonghuamen,walk changan",
"changantonghuamen,luoyang,walk luoyang",
"changantonghuamen,changanjinguangmen,walk jinguang",
"changanjinguangmen,changantonghuamen,walk tonghua",
"changantonghuamen,changanmingdemen,walk mingde",
"changanmingdemen,changantonghuamen,walk tonghua",
"changanjinguangmen,changanmingdemen,walk mingde",
"changanmingdemen,changanjinguangmen,walk jinguang",
"huizuxiaozhen,lingjiu,walk lingjiu",
"lingjiu,huizuxiaozhen,walk huijiang",
"huizuxiaozhen,lingzhou,walk lingzhou",
"lingzhou,huizuxiaozhen,walk huijiang",
"lingzhou,hhnangudu,walk lanzhou",
"hhnangudu,lingzhou,walk lingzhou",
"zanpu,dalunsishanmen,walk dalunsi",
"dalunsishanmen,zanpu,walk zanpu",
"chengdu,emeishanmen,walk emei",
"emeishanmen,chengdu,walk chengdu",
"dali,kunming",
"kunming,pingxiwang,walk pingxi",
"pingxiwang,kunming,walk kunming",
"miaoling,nanchang,walk nanchang",
"nanchang,miaoling,walk miaojiang",
"miaoling,yueyang,walk yueyang",
"yueyang,miaoling,walk miaojiang",
"jiangzhou,nanchang",
"jiangzhou,cjnandukou2,walk xinyang",
"cjnandukou2,jiangzhou,walk jiangzhou",
"jiangzhou,yueyang",
"jiangzhou,jiankangqingliangmen,walk jiankang",
"jiankangqingliangmen,jiangzhou,walk jiangzhou",
"jiankangqingliangmen,jiankangzhengyangmen,walk zhengyang",
"jiankangzhengyangmen,jiankangqingliangmen,walk qingliang",
"jiankangqingliangmen,jiankangshencemen,walk shence",
"jiankangshencemen,jiankangqingliangmen,walk qingliang",
"jiankangqingliangmen,jiankangchaoyangmen,walk chaoyang",
"jiankangchaoyangmen,jiankangqingliangmen,walk qingliang",
"jiankangchaoyangmen,jiankangzhengyangmen,walk zhengyang",
"jiankangzhengyangmen,jiankangchaoyangmen,walk chaoyang",
"jiankangchaoyangmen,jiankangshencemen,walk shence",
"jiankangshencemen,jiankangchaoyangmen,walk chaoyang",
"jiankangzhengyangmen,jiankangshencemen,walk shence",
"jiankangshencemen,jiankangzhengyangmen,walk zhengyang",
"jiankangshencemen,changjiangnanyanziji,walk yanziji",
"changjiangnanyanziji,jiankangshencemen,walk jiankang",
"nanchang,quanzhou",
"quanzhou,jiaxing",
"quanzhou,fuzhou",
"quanzhou,putian",
"quanzhou,hangzhou,walk linan",
"hangzhou,quanzhou,walk quanzhou",
"hangzhou,jiankangzhengyangmen,walk jiankang",
"jiankangzhengyangmen,hangzhou,walk linan",
"hangzhou,gushanmeizhuang,walk meizhuang",
"gushanmeizhuang,hangzhou,walk linan",
"hangzhou,yuefeimu,walk yuewangmu",
"yuefeimu,hangzhou,walk linan",
"putian,fuzhou",
"fuzhou,jiaxing",
"jiaxing,lujiazhuang",
"jiaxing,suzhoucanglangting,walk suzhou",
"suzhoucanglangting,jiaxing,walk jiaxing",
"jiaxing,yuefeimu,walk yuewangmu",
"yuefeimu,jiaxing,walk jiaxing",
"jiaxing,jiaxingtaihubian1,walk murong",
"jiaxingtaihubian1,jiaxing,walk jiaxing",
"jiaxing,mingzhouqingyuangang,walk mingzhou",
"mingzhouqingyuangang,jiaxing,walk jiaxing",
"jiaxing,yashan",
"jiaxing,jiankangzhengyangmen,walk jiankang",
"jiankangzhengyangmen,jiaxing,walk jiaxing",
"suzhoucanglangting,guiyunzhuang,walk guiyun",
"guiyunzhuang,suzhoucanglangting,walk suzhou",
"suzhoucanglangting,murong,walk murong",
"murong,suzhoucanglangting,walk suzhou",
"guiyunzhuang,murong,walk murong",
"murong,guiyunzhuang,walk guiyun",
"suzhoucanglangting,yixingxiancheng,walk yixing",
"yixingxiancheng,suzhoucanglangting,walk suzhou",
"suzhoucanglangting,jiankangchaoyangmen,walk jiankang",
"jiankangchaoyangmen,suzhoucanglangting,walk suzhou",
]
def prepare(ps):
results = []
for ori in ps:
sections = str.split(ori, ",")
if len(sections) == 2:
nodeno = get_nodeno(sections[0])
linknodeno = get_nodeno(sections[1])
results.append({"nodeno":nodeno, "linknodeno":linknodeno, "path": "walk %s" % sections[1], "linknodeid":sections[1]})
results.append({"nodeno":linknodeno, "linknodeno":nodeno, "path": "walk %s" % sections[0], "linknodeid":sections[0]})
elif len(sections) == 3:
nodeno = get_nodeno(sections[0])
linknodeno = get_nodeno(sections[1])
results.append({"nodeno":nodeno, "linknodeno":linknodeno, "path": sections[2], "linknodeid":sections[1]})
return results
def sql_prepare(results):
for res in results:
statement = 'insert into mud_links(nodeno, linknodeno, path, linknodeid) values (%d,%d,"%s","%s");' % (res["nodeno"], res["linknodeno"], res["path"], res["linknodeid"])
print(statement)
sql_prepare(prepare(yz))
sql_prepare(prepare(lz))
sql_prepare(prepare(bj))

复制代码

foolenough · 发表于 2020-1-26 16:12:32

能上传附件的也可以直接更新下qq群共享里的神灯教新手套

rainbowsnail · 发表于 2020-1-26 17:46:13

这个db是什么格式的？弱弱的问一下

creat · 发表于 2020-1-26 18:20:50

回复 1# foolenough

SQLiteExpert无法打开db
插件读取db报错

foolenough · 发表于 2020-1-27 10:56:20

重新更新了一下db文件，可能之前压缩的时候压缩错了。

songtao · 发表于 2020-1-27 19:41:46

回复 1# foolenough

感谢大佬分享。请问绝情谷怎么进不去呢？

乡间土路 -
            雪峰脚下---乡间土路---乡间土路
这里明显的方向有 east 和 west。
>
小路 -
                        山洞口
                           ∧
                        小路
                              ＼
                                 乡间土路
这里明显的方向有 southeast 和 enter。
你转身迅速地往绝情谷方向行进。
>
设定环境变量：brief = 0
>
石壁上竟是你之前刻上的路线：
左左右左后后右
>

foolenough · 发表于 2020-1-28 11:14:48

绝情谷是需要自己设置路径别名的，因为每个ID的绝情谷路线都不一样。

songtao · 发表于 2020-1-28 19:22:17

本帖最后由 songtao 于 2020-1-28 11:50 AM 编辑

回复 8# foolenough

非常抱歉。从QQ群里下载了神灯套装。但是在使用中还是有个问题，比如所有目的地是wudang的似乎都到不了。

beven · 发表于 2020-1-28 19:53:27

走路很重要，提高效率的必备武器

		自动登录	找回密码
密码			注册