Process specification

Page creation process

  • Category menu selection
    The items registered in sidebar are listed in check boxes.
    Associated elements & functions:
  • Body text insertion field
  • Image selection
    By way of new window popping up by button, will extract the image from local hard drive. both movie and the download data are the same in functioning
  • Movie selection
    The movie chosen by uploading plays on another screen.
  • Data selection for downloading
    The various file formats of data for downloading on its page can be up-loaded some file formats shall be deemed ZIP compression
  • Reference link insertion field
    An external link for reference consisting of title and comment.

Auto TOC registration process
Batch processing process
With the input informations prepared beforehand from the Excel documents, this automatically converts data at one go by batch processing.

Mail delivery functional process
The update notification service every week involving updated day and hour that are regularly delivered with the title and the link.

Posted: November 3, 2007 Comments (0)

Conceptual scheme

Main page
Functioning as table of contents listing in alphabetical arrangement for each word posted

Word pages
Common editable page to illustrate the meanings of word by specific modes as follows:

  • Description
  • Pictures
  • Movies
  • Download files
  • Reference links

Category pages
Listing words falling into each category in alphabetical arrangement. Each word page shall be deemed one or more category.

History pages
Storing edit history listing of when and who edited each page.

Special pages
These are created by the software on demand. They are located in their own namespace Special: and are not editable directly as other pages. Some special pages depend on the preferences that have been set by a user, e.g. the number of titles which is displayed on a user’s watchlist.

Posted: Comments (0)

Multi language activation

To enable multi language site in Mediawiki, it requires Mediawiki installation per language. For example, enabling mutual linkage for corresponded words in English, simplified Chinese and Thai is requiring three Mediawiki installations.

  1. To do so, install mediawiki for the number of language you need, and specify unique prefix for each of database table prefix during installation.
  2. After installation, open MySQL to replace column in interwiki table to be recognized of each identity as follows:

    For Chinese version, the following lets them identify English, its URL and some attributions:
    SELECT cw_interwiki.iw_prefix FROM cw_interwiki;
    REPLACE INTO cw_interwiki (iw_prefix,iw_url,iw_local,iw_trans) VALUES(’en’,'http://www.URL.com/wiki/index.php?title=$1′,0,0);

    For English version, just do vice versa way:
    SELECT mw_interwiki.iw_prefix FROM mw_interwiki;
    REPLACE INTO mw_interwiki (iw_prefix,iw_url,iw_local,iw_trans) VALUES(’zh-cn’,'http://www.URL.com/ch_wiki/index.php?title=$1′,0,0);

  3. After all done, go somewhere you can edit page, and link to somewhere in other language, like for example, you have created page named "test" in both English and Chinese… In Chinese page, it may be specified as [[en:test]] to go to corresponded page in English, and vice versa in English page, like [[zh-cn:test]]
Posted: September 2, 2007 Comments (0)

Enabling video files playback2

Through advisory help of Mr. Yeraze, video is finally played amazingly with the following step:

  1. Downloaded the vPIP Package(version 1.10 ) from http://wiki.vpip.org/index.php?title=All_Other_Installs
  2. Copy the lines from the following URL, and paste those to between <head> and </head> in monobook.php, then replace lines with actual URL
    http://wiki.vpip.org/index.php?title=All_Other_Installs
  3. Download the VPIPPlugin and unzip it and ensure there is two images(DownloadButton.gif, PlayButton.gif) and vPIP.php inside the folder "vPIPPlugin"
  4. place those 2 GIF images somewhere, I put those under "wiki/images"
  5. place the vPIP.php under "wiki/extensions", and specify location of a image in source code where you can find line with "img src" tag near bottom.
  6. Modified LocalSettings.php adding: require_once("$IP/extensions/vPIP.php")
  7. After all these done, go to "Special:Version" page, ensure there is <video> added
  8. Specify those attributions where you want video to play, following same way as follows:

    <video>
    url=<video URL>
    height=<video height>
    width=<video width>
    image=<placeholder image URL>
    title=<video Title>
    caption=<video Caption>
    download=<download URL>
    type=<video MIME Type>
    </video>

  9. If it ends up displaying 2 square vacant objects, problem may be in source code of vPIP.php, using the one provided by URL below may solve.
    http://www.yeraze.com/staticpages/index.php/20070813105349196

Lastly thank you for your support Mr. Yazae!

Posted: August 31, 2007 Comments (1)

Enabling video files playback

One of a means I’ve found was use of vPHP that is a plug-in that enable videos playing in place dynamically embedding after the viewer clicks on its link. However, plug-in provided can’t seem working without any file inside zip archive found after I unpack it.

Posted: August 23, 2007 Comments (5)

Managing rights level

To change the access levels of users in each groups, alter attribution in "includes/DefaultSettings.php"

http://meta.wikimedia.org/wiki/Help:User_levels

Posted: July 26, 2007 Comments (0)

Installation summary

After the long journey, I hereby summarize achievement with the following listed everything I have installed to run Mediawiki. Important points are commonly those path mistakes as well as comment out issues found in configuration file as is always the case with installation.

Server Environment:

  • Internet Information Services (IIS)
    Windows Server 2003 Standard Editioon Version 5.2
Softwares:

PHP Installation:

  1. Download php-5.2.3-Win32.zip and extract zip archive
  2. Rename directory with PHP, and move it under C drive
    • php-5.2.3-Win32 -> PHP (change of directory name)
    • C:¥PHP (move directory)
  3. Move php.ini-dist
    • C:¥PHP¥php.ini-dist => C:¥WINDOWS¥php.ini
      (change file name and move to WINDOWS directory)
    • Also to work with MySQL subsequently, ensure the php_mysql.dll and php_mysqli.dll dlls were in the ext folder of PHP, open your php.ini file to remove the following comments(semicolon):
      ;extension=php_mysql.dll
      ;extension=php_mysqli.dll
    • Change the extension_dir parameter to point to "c:\php\ext"
    • To enable email sending to registered users(from mediawiki), you go to PHP.ini, and alter the line "SMTP = localhost" to actual SMTP server name you are using.
  4. To register php5isapi.dll to IIS, you first open IIS Manager and click Web Service Extensions then go on to click Add a new Web service extension
  5. On the New Web Service Extention, key in "PHP" in extention name field then click "Add"
  6. Subsequently, Key in the path of php5isapi.dll then click "ok"
    • C:¥PHP¥php5isapi.dll
  7. Tick the checkbox Set extension status to Allowed
  8. Go to left panel of "Web sites", right click properties on a web service you are going on.
  9. Press Home Directory tab and press Configuration, and then press "Add" on Add/Edit Application Extension Mapping window
  10. Set everything up as follows:
    • Executable: C:\PHP\php5isapi.dll
    • Extension: .php
    • Script engine: check
  11. After everything is done, restart IIS server with iisreset command on the prompt

MySQL Installation:
Install MySQL to the default directory using the default options:

  1. Download MySQL Server 5.0 and just follow the installer
  2. Select “Detailed Configuration”
  3. Choose “Developer Machine”
  4. Choose “MultiFunctional Database”
  5. Select path for Data, this configuration used the default location.
  6. Choose “Decision Support (DSS)/OLAP
  7. Enable TCP/IP Networking on 3306 and Enable Strict Mode
  8. Enable standard character set
  9. Install as a Windows Service and set to launch automatically, check “Include Bin Directory in Windows PATH”
  10. Enter a Root Password
  11. Create the setup
  12. Not to skip InnoDB, find a configuration file my.ini under your MySQL program directory, and just disable the line skip-innodb with hatch "#", otherwise it will disturb your Mediawiki installation.
    Sources said InnoDB is the most popular transactional storage engine for MySQL also known as one of a various table in MySQL enabling functions such as commit, rollback, clash recovery, etc.

Mediawiki Installation:

  1. Download zip package from website and extract
  2. Alter directory name from Mediawiki-1.9.3 to wiki, and move its directory to anywhere you like where PHP is applied
  3. Open web browser and connect to its URL which may be http://localhost/wiki/index.php
  4. With sunflower shown on the browser, you can start installing Mediawiki, then just click the word below flower
  5. Fill up everything followed by, then click the button at bottom.
  6. If you stuck in trouble during installation, please go check again those configuration files of MySQL and PHP
Posted: July 25, 2007 Comments (0)

Install Guides

These two concretely describe about how to install and set Mediawiki in more detail (All written in Japanese)

Posted: Comments (0)

How to add User in MySQL?

To add super user in MySQL with the username "gep", put the following two commands at prompt

GRANT ALL PRIVILEGES ON *.* TO gep@localhost IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO gep@"%" IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

See also http://dev.mysql.com/doc/refman/4.1/en/grant.html

Posted: July 24, 2007 Comments (0)

Wiki Installation Note

Wiki name: Engineering Dictionery
Contact e-mail: ito@isidsea.com
Language: en - English
Copyright/license: No license metadata
Admin username: wikisid
Password: ********
Password confirm: ********
Shared memory caching: No caching
Memcached servers:

E-mail: Enabled
User-to-user e-mail: Enabled
E-mail notification: Enabled for user_talk and watch list changes (not recommended for large wikis)
E-mail authentiction: Enabled

Database type: MySQL
SQL server host: localhost
Database name: wikidb
DB username: gep
DB password: ********
DB password confirm: ********
Database table prefix: mw_
Database charset: Backwards-compatible UTF-8

Superuser account: root
Superuser password:

Posted: Comments (0)