基于 MySQL 的 wiki 适合定制应用程序吗?

发布于 2024-10-31 18:16:27 字数 622 浏览 4 评论 0原文

我开发了一款基于 Flash 的在线多人游戏。这是一个复杂的游戏,需要大量文档才能向我们的用户充分解释。理想情况下,我希望找到基于 MySQL 的 wiki 软件,该软件可以在 Flash 之外(在 HTML 领域)提供这些可编辑的文档页面,但为了方便起见,也可以在 Flash 内提供这些可编辑的文档页面,这样玩家就可以在不中断游戏或在浏览器选项卡之间来回切换。我预计我需要自己在 Flash 方面做很多工作,例如格式化,但我希望能够轻松地查询 wiki 的数据库以直接获取信息。我想这意味着我需要一个结构相对“扁平”或直观的 wiki,以便我可以执行以下操作:

  1. 运行一个 MySQL 查询,返回 wiki 中所有文章(其标题和 ID)的列表
  2. 对于每篇文章wiki 中的 ID,返回相关内容

这可能意味着我必须限制放入 wiki 中的格式类型 - 像表格之类的东西可能会被省略,因为它们对我来说非常困难,如果不是不可能的话在Flash端。那很好!

基本上我只是在寻找关于 wiki 软件的建议,这些软件非常易于使用,但大多数在后端技术上足够简单,通过 MySQL 直接与其交互并不困难。直接与数据库交互时,我只需要读取数据。任何时候编辑或添加 wiki 都可以通过 wiki 的实际前端应用程序完成。

感谢您的任何建议!

I develop an online, Flash-based multiplayer game. It is a complex game, and requires a lot of documentation to fully explain it to our users. Ideally, I would like to find MySQL-based wiki software that can provide these editable documentation pages outside of Flash (in the HTML realm) but also within Flash for convenience, and so that players can refer to the information without interrupting their game or having to switch back-and-forth between browser tabs. I am expecting that I would need to do a lot of the work on the Flash side myself, as far as formatting, for example, but I would like to feel comfortable in querying the wiki's database to get info directly. I guess this means that I need a wiki that is structured relatively "flat" or intuitively so that I can do things like:

  1. Run a MySQL query that returns a list of all the articles (their titles and IDs) in the wiki
  2. For each article ID in the wiki, return the associated content

This may mean that I have to limit the kinds of formatting I put into the wiki -- things like tables would probably be omitted since they would be very difficult, if not impossible, for me to do on the Flash side. And that is fine!

Basically I am just looking for suggestions for wiki software that is pretty easy to use, but mostly is technically simple enough on the back-end that interfacing with it directly via MySQL is not difficult. When interfacing with the database directly, I only need to READ data. Any time the wiki would be edited or added to would be done via the wiki's actual front-end application.

Thanks for any suggestions!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

多情出卖 2024-11-07 18:16:27

MediaWiki 是最著名且最受支持的基于 MySQL 的 Wiki,用于大量复杂的游戏文档项目,例如 我的世界维基。该数据库并不那么简单,但它记录良好并且基本的读取操作并不太难。例如,以下是如何获取页面“MyPage”的当前内容:(

SELECT old_text FROM page,revision,text WHERE page.page_title="MyPage" AND
  page.page_id=revision.rev_page AND revision.rev_text_id=text.old_id;

是的,old_text是页面的当前内容。不要问我为什么!)

您的主要问题是弄清楚如何解析 MediaWiki 标记,有大量解析器,但我不知道任何可以在 Flash 中工作的东西。

MediaWiki is the best-known and best-supported MySQL-based Wiki, used for plenty of complex game documentation projects like MinecraftWiki. The database is not all that simple, but it's well documented and basic read operations aren't too hard. For example, here's how to fetch the current content of the page "MyPage":

SELECT old_text FROM page,revision,text WHERE page.page_title="MyPage" AND
  page.page_id=revision.rev_page AND revision.rev_text_id=text.old_id;

(And yes, old_text is the current content of the page. Don't ask me why!)

Your main problem will be figuring out how to parse MediaWiki markup, there are plenty of parsers for it but I'm not aware of anything that would work in Flash.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文