OpenBiblio

2010-06-06T14:33:27Z

77.185.80.156: +version 0.6.1

OpenBiblio是[[OpenSource for Educators|開放原始碼]]的圖書管理系統。

{{Software version | url=http://freshmeat.net/projects/obiblio/ | software=OpenBiblio | version=0.6.0 }}

== install instruction ==
* Check the requirement: PHP 4.2+ & MySQL 4.0.12+
* Setup the MySQL: {openbiblio}/database_constants.php
: more on [http://www.iriti.cnr.it/openbiblio/install_instructions.html OpenBiblio Install Instructions]
* run the http://localhost/openbiblio/install/index.php

== localization ==
* copy the {openbiblio}/locale/en to {openbiblio}/locale/en_utf
* modify the {openbiblio}/locale/en_utf8/metadata.php <pre> "locale_description" => "English_utf8" </pre>

: http://farm2.static.flickr.com/1238/1167678345_7fef04238c.jpg
: image host on [http://www.flickr.com/photos/planetoid/1167678345/ flickr]

; Setup the library
* Click the ''admin'' label
* login the default admin account
* click the ''library settings''
** Locale: switch to English_utf8
** HTML Charset: modify iso-8859-1 to utf-8
* click the ''Update'' button

; When create DB (for MySQL5)
SQL:

create database openbiblio CHARACTER SET utf8 COLLATE utf8_general_ci;

; Modify PHP source

openbiblio\Query.php

add line: '''$rc = Query::act( 'SET NAMES UTF8' );'''
so that all connection will be UTF8

function connect_e() {
list($this->_link, $e) = Query::_connect_e();
'''$rc = Query::act( 'SET NAMES UTF8' );'''
return $e;
}

; Modify PHP source (version 0.6.1)

openbiblio\classes\Query.php

add the two lines: '''mysql_query("SET CHARACTER SET utf8");''' and '''mysql_query("SET NAMES utf8");'''
so that all connection will be UTF8

function _connect_e() {
static $link;
if (!isset($link)) {
if (!function_exists('mysql_connect')) {
return array(NULL, new DbError("Checking for MySQL Extension...",
"Unable to connect to database.",
"The MySQL extension is not available"));
}
$link = mysql_connect(OBIB_HOST,OBIB_USERNAME,OBIB_PWD);
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
if (!$link) {
return array(NULL, new DbError("Connecting to database server...",
"Cannot connect to database server.",
mysql_error()));
}
$rc = mysql_select_db(OBIB_DATABASE, $link);
if (!$rc) {
return array(NULL, new DbError("Selecting database...",
"Cannot select database.",
mysql_error($link)));
}
}
return array($link, NULL);
}

; Validation
* click the ''Cataloging'' label -> ''New Bibliography''
* ''add a new Bibliography'' in Chinese
* & search ''Bibliography Search'' in Chinese
* Check MySQL DB table biblio, to see if the string store in Chinese. You can use freeware Toad for MySQL to do it.
* Try again in Simplified Chinese

;Reference
* [http://obiblio.sourceforge.net/index.php/Main/TranslatingOpenBiblio OpenBiblio | Main / TranslatingOpenBiblio browse]

[[Category:OSS]] [[Category:Education]]

LemonWiki共筆 - User contributions [en]

OpenBiblio