Open Journal Systems configuration
This is an initial version which extracts just basic information about authors and articles.
<?php
$cfg=parse_ini_file('../config.inc.php');
$triplify['namespaces']=array(
'vocabulary'=>'http://triplify.org/vocabulary/ojs/',
'foaf'=>'http://xmlns.com/foaf/0.1/',
'sioc'=>'http://rdfs.org/sioc/ns#',
'sioctypes'=>'http://rdfs.org/sioc/types#',
'dc'=>'http://purl.org/dc/elements/1.1/',
'dcterms'=>'http://purl.org/dc/terms/',
'skos'=>'http://www.w3.org/2004/02/skos/core#',
'tag'=>'http://www.holygoat.co.uk/owl/redwood/0.1/tags/',
'dc'=>'http://purl.org/dc/elements/1.1/',
'xsd'=>'http://www.w3.org/2001/XMLSchema#',
);
$triplify['queries']=array(
'author'=>"SELECT author_id,a.article_id AS 'sioc:creator_of',first_name AS 'foaf:firstName',middle_name,
last_name AS 'foaf:family_name',affiliation,country,
SHA(CONCAT('mailto:',email)) AS 'foaf:mbox_sha1sum',url AS 'foaf:homepage'
FROM article_authors aa INNER JOIN articles a ON(aa.article_id=a.article_id AND status=3)",
'article'=>"SELECT a.article_id AS id,title.setting_value title,abstract.setting_value abstract,keywords.setting_value keywords
FROM articles a
INNER JOIN article_settings title ON(a.article_id=title.article_id AND title.setting_name='title')
INNER JOIN article_settings abstract ON(a.article_id=abstract.article_id AND abstract.setting_name='abstract')
INNER JOIN article_settings keywords ON(a.article_id=keywords.article_id AND keywords.setting_name='subject')
WHERE status=3",
);
$triplify['objectProperties']=array(
'sioc:creator_of'=>'article',
);
$triplify['classMap']=array(
'author'=>'foaf:person'
);
$triplify['TTL']=0;
$triplify['db']=new PDO($cfg['driver'].':host='.$cfg['host'].';dbname='.$cfg['name'],$cfg['username'],$cfg['password']);
?>
There are no files on this page.
[Display files/form]
There is no comment on this page.
[Display comments/form]
Information
Last Modification: 
2008-03-16 02:09:58 by Soeren Auer
