[Feature Request] 讨论回复跳转优化

[langningchen]

检查项

• 我已确认了XMOJ增强脚本已为最新版，且最新版未实现这一功能。
• 我已在 Issues 页面 中搜索，确认了这一提案未被提交过。

描述

讨论回复提醒查看时应当直接跳转至相应的页面（如果是第二页的回复触发的提醒就跳转至第二页），而不是该讨论的第一页

原因

No response

[PythonSmall-Q]

errrrr好累

[langningchen]

@PythonSmall-Q 确实，我当时也很辛苦的

[PythonSmall-Q]

保持动力，客户至上

[langningchen]

当时我就是一个 Issue 没解决完又有一堆出来

[boomzero]

保持动力，客户至上

.

[boomzero]

Needs modifying the old db

[langningchen]

Needs modifying the old db

Why?

[boomzero]

Needs modifying the old db

Why?

@langningchen We only store postID

[boomzero]

Not replyID

[boomzero]

In addition, we would appreciate it if you could check out #599

[langningchen]

还有刚才 #599 是怎么回事？我没太明白……

[boomzero]

还有刚才 #599 是怎么回事？我没太明白……

review it, please

[langningchen]

好的，我看看

[boomzero]

Emm...That seems bad. I forgot it.

PS: A have some problems about Competitive programming, may you help me?

@langningchen So, impossible?

Is there a way to MODIFY a d1 database?

[boomzero]

Emm...That seems bad. I forgot it.
PS: A have some problems about Competitive programming, may you help me?

@langningchen So, impossible?

Is there a way to MODIFY a d1 database?

Apparently this works

ALTER TABLE table_name
ADD COLUMN column_name column_type;

[langningchen]

Emm...That seems bad. I forgot it.
PS: A have some problems about Competitive programming, may you help me?

@langningchen So, impossible?
Is there a way to MODIFY a d1 database?

Apparently this works

ALTER TABLE table_name
ADD COLUMN column_name column_type;

It works? It does not work on my machine. My way is to create a new temp database with the correct structure and copy the data into it, then drop to orginal database and rename it back.

[boomzero]

Emm...That seems bad. I forgot it.
PS: A have some problems about Competitive programming, may you help me?

@langningchen So, impossible?
Is there a way to MODIFY a d1 database?

Apparently this works

ALTER TABLE table_name
ADD COLUMN column_name column_type;

It works? It does not work on my machine. My way is to create a new temp database with the correct structure and copy the data into it, then drop to orginal database and rename it back.

According to ChatGPT

[boomzero]

Your way is… messy

[boomzero]

Let me test in production

[boomzero]

https://www.sqlite.org/lang_altertable.html

[langningchen]

@boomzero 你删了什么评论……？

[boomzero]

@boomzero 你删了什么评论……？

你问OI题的评论

[boomzero]

本来想hide, 但是按错了，干脆全删了