I tried installing OpenPNE, which is well known as a Mixi look-alike. Having used it, I find it very stable. It even makes me consider moving my diary over there.
It would be ideal if it became federation-enabled.
Now, as for OpenPNE’s internals, I had a hard time because the documentation was difficult to find, even after searching for it. Even though I have other things to do…
【Authentication】
User and member accounts are stored in c_member_secure.
Because all of the data is in Blob format, it cannot be viewed with tools such as phpMyAdmin, but it is actually text.
Field Field type
c_member_secure_id int(11)
c_member_id int(11)
hashed_password blob BINARY
hashed_password_query_answer blob BINARY
pc_address blob BINARY
ktai_address blob BINARY
regist_address blob BINARY
easy_access_id blob BINARY
The hashed_* fields contain values processed with MySQL’s md5().
pc_address is encrypted in some manner.
I will have to trace the source… Without understanding this, I cannot do things like migrate users from Xoops.
【Templates】
In the end, I carefully examined the contents of the directories.
OpenPNE/webapp/modules/pc/templates
They are written in Smarty.
The login page is o_login.tpl. But I cannot seem to edit it successfully.