Project AhaWiki

내가원하는위키엔진을 만들었다!

http://ahawiki.aha00a.com

1. Trac Migration

:%s/time integer/time BIGINT/g
:%s/text text/text LONGTEXT/g
:%s/#!AhaTracTable/#!Table/g
:%s/\[\[PageOutline\]\]//g
:%s/{{{/[ [[/g
:%s/}}}/] ]]/g

INSERT INTO Page (name, revision, time, author, remoteAddress, content, comment)
SELECT w.name, w.revision + 1, 1445424450613000, 'aha00a@gmail.com', '127.0.0.1', CONCAT('#!read aha00a@gmail.com\n#!write aha00a@gmail.com\n', w.content), 'Migrate permission'
    FROM Page w
    INNER JOIN (
        SELECT
            name, MAX(revision) revision
            FROM Page
            WHERE name LIKE '끄%'
            GROUP BY name
            ORDER BY MAX(time) DESC
    ) NV ON w.name = NV.name AND w.revision = NV.revision
    ORDER BY name

INSERT INTO Page (name, revision, time, author, remoteAddress, content, comment)
SELECT w.name, w.revision + 1, 1445424450613000, 'aha00a@gmail.com', '127.0.0.1', REPLACE(w.content, '[wiki:aha00a]', ''), 'Remove signature'
    FROM Page w
    INNER JOIN (
        SELECT
            name, MAX(revision) revision
            FROM Page
            GROUP BY name
            ORDER BY MAX(time) DESC
    ) NV ON w.name = NV.name AND w.revision = NV.revision
    WHERE w.content LIKE '%[wiki:aha00a]%' AND w.name NOT LIKE '%Aha00a%'
    ORDER BY name

첨부파일들

2. See Also

2.1. Backlinks

2.2. Similar Pages

Similar pages by cosine similarity. Words after page name are term frequency.

Same Wiki

39.03% Objective-C Category name(16:10)
35.14% OracleDatabaseColumnInfo name(16:4), table(2:4), from(4:1), select(4:1), where(2:1)
33.66% DDL name(16:4), table(2:4)
31.60% Kakao name(16:12), address(2:9), content(5:1), 127(2:3)
30.85% OracleDatabaseCreateTableAsSelect name(16:2), select(4:2), table(2:4), from(4:1)

Sister Wikis

38.33% AhaWiki:Dev Page page(7:21), name(16:6), revision(12:6), time(6:1), content(5:2), wiki(3:2), aha(2:2), address(2:1), comment(2:1), remote(2:1)

2.3. Adjacent Pages

Control

Focus depth ≤ 32

Min degree all

Label scale 1.0x

Node scale 1.0x

Link distance 80

Charge -120

Thumbnail ON

Start Stop More Fullscreen

Metrics

Nodes(visible/total)0/0

Links(visible/total)0/0

Avg degree0.00

Depth coverage0

Queue(fetch/graph)0 / 0

Zoom(scale)1.00x

Ctrl/⌘ + Scroll: Zoom

Root 1-hop 2-hop+