. . "%VOSWARNING%\n\n\n---+++RDF View for phpBB 2\n\n\nuse phpBB;\n\n\ncreate procedure phpBB2.DBA.phpBB2_foaf_iri (in s varchar)\n{\n return concat ('http://xmlns.com/foaf/0.1/', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_sioc_iri (in s varchar)\n{\n return concat ('http://rdfs.org/sioc/ns#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_rdf_iri (in s varchar)\n{\n return concat ('http://www.w3.org/1999/02/22-rdf-syntax-ns#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_rdfs_iri (in s varchar)\n{\n return concat ('http://www.w3.org/2000/01/rdf-schema#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_geo_iri (in s varchar)\n{\n return concat ('http://www.w3.org/2003/01/geo/wgs84_pos#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_atom_iri (in s varchar)\n{\n return concat ('http://atomowl.org/ontologies/atomrdf#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_dc_iri (in s varchar)\n{\n return concat ('http://purl.org/dc/elements/1.1/', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_dcterms_iri (in s varchar)\n{\n return concat ('http://purl.org/dc/terms/', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_skos_iri (in s varchar)\n{\n return concat ('http://www.w3.org/2004/02/skos/core#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_ext_iri (in s varchar)\n{\n return concat ('http://rdfs.org/sioc/types#', s);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_get_opt (in opt varchar)\n{\n return (select config_value from phpbb_config where config_name = opt);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_get_graph ()\n{\n declare script_name,server_name,server_protocol,server_port varchar;\n script_name := trim(trim(phpBB2.DBA.phpBB2_get_opt('script_path')),'/');\n server_name := trim(phpBB2.DBA.phpBB2_get_opt('server_name'));\n if (cast(phpBB2.DBA.phpBB2_get_opt('cookie_secure') as integer))\n server_protocol := 'https://';\n else\n server_protocol := 'http://';\n if (cast(phpBB2.DBA.phpBB2_get_opt('server_port') as integer) <> 80)\n server_port := ':' || cast(phpBB2.DBA.phpBB2_get_opt('server_port') as varchar) || '/';\n else\n server_port := '/';\n\n return server_protocol || server_name || server_port || script_name || '/';\n};\n\ncreate procedure phpBB2.DBA.phpBB2_user_iri (in id int)\n{\n return phpBB2.DBA.phpBB2_get_graph () || sprintf('profile.php?mode=viewprofile&u=%d',id);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_usergroup_iri (in id int)\n{\n return phpBB2.DBA.phpBB2_get_graph () || sprintf('groupcp.php?g=%d',id);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_forum_iri (in id int)\n{\n return phpBB2.DBA.phpBB2_get_graph () || sprintf('viewforum.php?f=%d',id);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_post_iri (in id int)\n{\n return phpBB2.DBA.phpBB2_get_graph () || sprintf('viewtopic.php?p=%d#%d',id,id);\n};\n\n\ncreate procedure phpBB2.DBA.phpBB2_rdf_init ()\n{\n declare iri, site_iri, graph_iri, forum_iri varchar;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n site_iri := graph_iri;\n delete from DB.DBA.RDF_QUAD where G = DB.DBA.RDF_IID_OF_QNAME (graph_iri);\n\n -- Site\n DB.DBA.RDF_QUAD_URI (graph_iri, site_iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Site'));\n DB.DBA.RDF_QUAD_URI (graph_iri, site_iri, phpBB2.DBA.phpBB2_sioc_iri ('link'), site_iri);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, site_iri, phpBB2.DBA.phpBB2_dc_iri ('title'), phpBB2.DBA.phpBB2_get_opt ('sitename'));\n\n for (select user_id, username,\n\t case when length (user_email) then 'mailto:'||user_email else '' end as E_MAIL,\n\t case when length (user_email) then sha1_digest (user_email) else '' end as E_MAIL_SHA1\n\t from phpbb_users\n\t where user_active = 1)do\n\t{\n\t phpBB2.DBA.phpBB2_user_rdf(user_id,username,E_MAIL,E_MAIL_SHA1);\n\t};\n\t\n\tfor (select group_id, group_name from phpbb_groups\n where group_type < 2 and group_single_user = 0) do\n {\n\t phpBB2.DBA.phpBB2_usergroups_rdf(group_id, group_name);\n };\n \n for (select group_id, user_id from phpbb_user_group\n where user_pending = 0) do\n {\n\t phpBB2.DBA.phpBB2_user_usergroups_rdf(group_id, user_id);\n };\n \n for (select forum_id, forum_name, forum_desc from phpbb_forums )do\n {\n\t phpBB2.DBA.phpBB2_forum_rdf(forum_id, forum_name,forum_desc);\n };\n \n for (select forum_id, user_id from phpbb_user_group ug\n INNER JOIN phpbb_auth_access aa on ug.group_id = aa.group_id \n where ug.user_pending = 0) do\n {\n\t phpBB2.DBA.phpBB2_forum_moderators_rdf(forum_id, user_id);\n };\n \n for (select pp.post_id, pp.forum_id, pp.poster_id, pt.post_subject, pt.post_text \n from phpbb_posts pp\n INNER JOIN phpbb_posts_text pt on pp.post_id = pt.post_id) do\n {\n\t phpBB2.DBA.phpBB2_post_rdf(post_id, forum_id,poster_id);\n\t phpBB2.DBA.phpBB2_post_text_rdf(post_id, post_subject,post_text);\n };\n\n};\n\ncreate procedure phpBB2.DBA.phpBB2_post_text_rdf (in post_id int,in post_subject varchar, in post_text varchar)\n{\n declare graph_iri,post_iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n post_iri := phpBB2.DBA.phpBB2_post_iri (post_id);\n \n DB.DBA.RDF_QUAD_URI_L (graph_iri, post_iri, phpBB2.DBA.phpBB2_dc_iri ('title'), post_subject);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('content'), post_text);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_post_rdf (in post_id int,in forum_id int, in user_id int)\n{\n declare graph_iri,post_iri,forum_iri,user_iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n post_iri := phpBB2.DBA.phpBB2_post_iri (post_id);\n forum_iri := phpBB2.DBA.phpBB2_forum_iri (forum_id);\n user_iri := phpBB2.DBA.phpBB2_user_iri (user_id);\n \n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Post'));\n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Item'));\n\n DB.DBA.RDF_QUAD_URI_L (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('id'), post_id);\n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_creator'), user_iri);\n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_container'), forum_iri);\n DB.DBA.RDF_QUAD_URI (graph_iri, forum_iri, phpBB2.DBA.phpBB2_sioc_iri ('container_of'), post_iri);\n\n};\n\ncreate procedure phpBB2.DBA.phpBB2_forum_moderators_rdf (in forum_id int, in user_id int)\n{\n declare graph_iri, forum_iri, user_iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n forum_iri := phpBB2.DBA.phpBB2_forum_iri (forum_id);\n user_iri := phpBB2.DBA.phpBB2_user_iri (user_id);\n \n DB.DBA.RDF_QUAD_URI (graph_iri, forum_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_moderator'), user_iri);\n DB.DBA.RDF_QUAD_URI (graph_iri, user_iri, phpBB2.DBA.phpBB2_sioc_iri ('moderator_of'), forum_iri);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_forum_rdf (in forum_id int, in forum_name varchar,in forum_desc varchar)\n{\n declare graph_iri, iri, site_iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n site_iri := graph_iri;\n iri := phpBB2.DBA.phpBB2_forum_iri (forum_id);\n \n DB.DBA.RDF_QUAD_URI (graph_iri, iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Forum'));\n DB.DBA.RDF_QUAD_URI (graph_iri, iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Container'));\n\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('id'), forum_id);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('name'), forum_name);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('description'), forum_desc);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_dc_iri ('title'), forum_name);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_dc_iri ('description'), forum_desc);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('type'), 'Forum');\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('has_host'), site_iri);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, site_iri, phpBB2.DBA.phpBB2_sioc_iri ('host_of'), iri);\n\n};\n\ncreate procedure phpBB2.DBA.phpBB2_user_usergroups_rdf (in group_id int, in user_id int)\n{\n declare graph_iri, group_iri, user_iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n group_iri := phpBB2.DBA.phpBB2_usergroup_iri (group_id);\n user_iri := phpBB2.DBA.phpBB2_user_iri (user_id);\n \n DB.DBA.RDF_QUAD_URI (graph_iri, group_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_member'), user_iri);\n DB.DBA.RDF_QUAD_URI (graph_iri, user_iri, phpBB2.DBA.phpBB2_sioc_iri ('member_of'), group_iri);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_usergroups_rdf (in ID int, in group_name varchar)\n{\n declare graph_iri,iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n iri := phpBB2.DBA.phpBB2_usergroup_iri (ID);\n \n DB.DBA.RDF_QUAD_URI (graph_iri, iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('Usergroup'));\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('id'), ID);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('name'), group_name);\n};\n\ncreate procedure phpBB2.DBA.phpBB2_user_rdf (in ID int, in username varchar, in user_email varchar, in sha1_digest varchar)\n{\n declare graph_iri,iri any;\n graph_iri := phpBB2.DBA.phpBB2_get_graph ();\n iri := phpBB2.DBA.phpBB2_user_iri (ID);\n\n DB.DBA.RDF_QUAD_URI (graph_iri, iri, phpBB2.DBA.phpBB2_rdf_iri ('type'), phpBB2.DBA.phpBB2_sioc_iri ('User'));\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('id'), ID);\n\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('name'), username);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('email'), user_email);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('email_sha1'), sha1_digest);\n\n};\n\ncreate procedure phpBB2.DBA.phpBB2_delete_rdf_obj (in iri any)\n{\n declare graph_iri any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME (phpBB2.DBA.phpBB2_get_graph ());\n iri := DB.DBA.RDF_IID_OF_QNAME (iri);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = iri;\n delete from DB.DBA.RDF_QUAD where G = graph_iri and O = iri;\n};\n\ncreate procedure phpBB2.DBA.phpBB2_delete_rdf_obj_link (in iri1 any,in iri2 any)\n{\n declare graph_iri any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME (phpBB2.DBA.phpBB2_get_graph ());\n iri1 := DB.DBA.RDF_IID_OF_QNAME (iri1);\n iri2 := DB.DBA.RDF_IID_OF_QNAME (iri2);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = iri1 and O = iri2;\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = iri2 and O = iri1;\n};\n\ncreate trigger phpbb_posts_text_i after insert on phpbb_posts_text referencing new as N\n{\n\t phpBB2.DBA.phpBB2_post_text_rdf(N.post_id, N.post_subject, N.post_text);\n};\n\ncreate trigger phpbb_posts_text_u after update on phpbb_posts_text referencing old as O, new as N\n{\n declare graph_iri, post_iri any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_get_graph ());\n post_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_post_iri (O.post_id));\n \n if (O.post_subject <> N.post_subject)\n {\n declare o_short any;\n o_short := DB.DBA.RDF_OBJ_OF_SQLVAL(O.post_subject);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = post_iri and O = o_short;\n DB.DBA.RDF_QUAD_URI_L (graph_iri, post_iri, phpBB2.DBA.phpBB2_dc_iri ('title'), N.post_subject);\n\n }\n\n if (O.post_text <> N.post_text)\n {\n declare o_short any;\n o_short := DB.DBA.RDF_OBJ_OF_SQLVAL(O.post_text);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = post_iri and O = o_short;\n DB.DBA.RDF_QUAD_URI_L (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('content'), N.post_text);\n }\n \n};\n\ncreate trigger phpbb_posts_text_d after delete on phpbb_posts_text referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_post_iri (O.post_id));\n};\n\n\ncreate trigger phpbb_posts_i after insert on phpbb_posts referencing new as N\n{\n if (isinteger(N.post_id))\n\t phpBB2.DBA.phpBB2_post_rdf(N.post_id, N.forum_id,N.poster_id);\n};\n\ncreate trigger phpbb_posts_u after update on phpbb_posts referencing old as O, new as N\n{\n declare graph_iri, post_iri any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_get_graph ());\n post_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_post_iri (O.post_id));\n \n if (O.forum_id <> N.forum_id)\n {\n declare forum_iri any;\n forum_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_forum_iri (O.forum_id));\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = post_iri and O = forum_iri;\n forum_iri := phpBB2.DBA.phpBB2_forum_iri (N.forum_id);\n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_container'), forum_iri);\n DB.DBA.RDF_QUAD_URI (graph_iri, forum_iri, phpBB2.DBA.phpBB2_sioc_iri ('container_of'), post_iri);\n }\n\n if (O.poster_id <> N.poster_id)\n {\n declare user_iri any;\n user_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_user_iri (O.poster_id));\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = post_iri and O = user_iri;\n user_iri := phpBB2.DBA.phpBB2_user_iri (N.poster_id);\n DB.DBA.RDF_QUAD_URI (graph_iri, post_iri, phpBB2.DBA.phpBB2_sioc_iri ('has_creator'), user_iri);\n }\n\n \n};\n\ncreate trigger phpbb_posts_d after delete on phpbb_posts referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_post_iri (O.post_id));\n};\n\n\ncreate trigger phpbb_user_forum_i after insert on phpbb_forums referencing new as N\n{\n\t phpBB2.DBA.phpBB2_forum_rdf(N.forum_id, N.forum_name,N.forum_desc);\n};\n\ncreate trigger phpbb_forums_u after update on phpbb_forums referencing old as O, new as N\n{\n --phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_forum_iri (O.forum_id));\n --phpBB2.DBA.phpBB2_forum_rdf(N.forum_id, N.forum_name,N.forum_desc);\n\n declare graph_iri, iri any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_get_graph ());\n iri := DB.DBA.RDF_IID_OF_QNAME(phpBB2.DBA.phpBB2_forum_iri (O.forum_id));\n \n if (O.forum_name <> N.forum_name)\n {\n declare o_short any;\n o_short := DB.DBA.RDF_OBJ_OF_SQLVAL(O.forum_name);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = iri and O = o_short;\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('name'), N.forum_name);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_dc_iri ('title'), N.forum_name);\n }\n\n if (O.forum_desc <> N.forum_desc)\n {\n declare o_short any;\n o_short := DB.DBA.RDF_OBJ_OF_SQLVAL(O.forum_desc);\n delete from DB.DBA.RDF_QUAD where G = graph_iri and S = iri and O = o_short;\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_sioc_iri ('description'), N.forum_desc);\n DB.DBA.RDF_QUAD_URI_L (graph_iri, iri, phpBB2.DBA.phpBB2_dc_iri ('description'), N.forum_desc);\n }\n\n \n};\n\ncreate trigger phpbb_forums_d after delete on phpbb_forums referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_forum_iri (O.forum_id));\n};\n\n\ncreate trigger phpbb_user_group_i after insert on phpbb_user_group referencing new as N\n{\n if (N.user_pending = 0)\n {\n\t phpBB2.DBA.phpBB2_user_usergroups_rdf(N.group_id, N.user_id);\n\t};\n\t\n\tfor (select forum_id from phpbb_auth_access aa where N.group_id = aa.group_id)do\n\t{\n\t phpBB2.DBA.phpBB2_forum_moderators_rdf(forum_id, N.user_id);\n\t};\n};\n\ncreate trigger phpbb_user_group_u after update on phpbb_user_group referencing old as O, new as N\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_usergroup_iri (O.group_id), phpBB2.DBA.phpBB2_user_iri (O.user_id));\n if (N.user_pending = 0)\n\t phpBB2.DBA.phpBB2_user_usergroups_rdf(N.group_id, N.user_id);\n\n\tfor (select forum_id from phpbb_auth_access aa where O.group_id = aa.group_id)do\n\t{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_forum_iri (forum_id), phpBB2.DBA.phpBB2_user_iri (O.user_id));\n }\n\tfor (select forum_id from phpbb_auth_access aa where N.group_id = aa.group_id)do\n\t{\n\t phpBB2.DBA.phpBB2_forum_moderators_rdf(forum_id, N.user_id);\n\t};\n};\n\ncreate trigger phpbb_user_group_d after delete on phpbb_user_group referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_usergroup_iri (O.group_id), phpBB2.DBA.phpBB2_user_iri (O.user_id));\n\tfor (select forum_id from phpbb_auth_access aa where O.group_id = aa.group_id)do\n\t{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_forum_iri (forum_id), phpBB2.DBA.phpBB2_user_iri (O.user_id));\n }\n};\n\n\ncreate trigger phpbb_auth_access_i after insert on phpbb_auth_access referencing new as N\n{\n\tfor (select user_id from phpbb_user_group ug where ug.group_id = N.group_id)do\n\t{\n\t phpBB2.DBA.phpBB2_forum_moderators_rdf(N.forum_id, user_id);\n\t};\n};\n\ncreate trigger phpbb_auth_access_u after update on phpbb_auth_access referencing old as O, new as N\n{\n\n\tfor (select user_id from phpbb_user_group ug where ug.group_id = O.group_id)do\n\t{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_forum_iri (O.forum_id), phpBB2.DBA.phpBB2_user_iri (user_id));\n }\n\tfor (select user_id from phpbb_user_group ug where ug.group_id = N.group_id)do\n\t{\n\t phpBB2.DBA.phpBB2_forum_moderators_rdf(N.forum_id, user_id);\n\t};\n};\n\ncreate trigger phpbb_auth_access_d after delete on phpbb_auth_access referencing old as O\n{\n\tfor (select user_id from phpbb_user_group ug where ug.group_id = O.group_id)do\n\t{\n phpBB2.DBA.phpBB2_delete_rdf_obj_link(phpBB2.DBA.phpBB2_forum_iri (O.forum_id), phpBB2.DBA.phpBB2_user_iri (user_id));\n }\n};\n\n\ncreate trigger phpbb_groups_i after insert on phpbb_groups referencing new as N\n{\n if (N.group_type < 2 and N.group_single_user = 0)\n\t phpBB2.DBA.phpBB2_usergroups_rdf(N.group_id, N.group_name);\n};\n\ncreate trigger phpbb_groups_u after update on phpbb_groups referencing old as O, new as N\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_usergroup_iri (O.group_id));\n if (N.group_type < 2 and N.group_single_user = 0)\n\t phpBB2.DBA.phpBB2_usergroups_rdf(N.group_id, N.group_name);\n\n for (select group_id, user_id from phpbb_user_group\n where user_pending = 0 and group_id = N.group_id) do\n {\n\t phpBB2.DBA.phpBB2_user_usergroups_rdf(group_id, user_id);\n };\n};\n\ncreate trigger phpbb_groups_d after delete on phpbb_groups referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_usergroup_iri (O.group_id));\n};\n\n\ncreate trigger phpbb_users_i after insert on phpbb_users referencing new as N\n{\n if (N.user_active = 1)\n\t phpBB2.DBA.phpBB2_user_rdf(N.user_id,N.username,\n\t (case when length (N.user_email) then 'mailto:'||N.user_email else '' end),\n\t (case when length (N.user_email) then sha1_digest (N.user_email) else '' end)\n\t );\n};\n\ncreate trigger phpbb_users_u after update on phpbb_users referencing old as O, new as N\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_user_iri (O.user_id));\n if (N.user_active = 1)\n\t phpBB2.DBA.phpBB2_user_rdf(N.user_id,N.username,\n\t (case when length (N.user_email) then 'mailto:'||N.user_email else '' end),\n\t (case when length (N.user_email) then sha1_digest (N.user_email) else '' end)\n\t );\n};\n\ncreate trigger phpbb_users_d after delete on phpbb_users referencing old as O\n{\n phpBB2.DBA.phpBB2_delete_rdf_obj (phpBB2.DBA.phpBB2_user_iri (O.user_id));\n};\n\n\ncreate trigger phpbb_config_u after update on phpbb_config referencing old as O, new as N\n{\n if (O.config_value = N.config_value)\n return;\n if (O.config_name = 'script_path' or\n O.config_name = 'server_name' or \n O.config_name = 'cookie_secure' or\n O.config_name = 'server_port' )\n {\n declare script_name,server_name,server_protocol,server_port varchar;\n\n if (O.config_name = 'script_path')\n script_name := trim(trim(O.config_value),'/');\n else\n script_name := trim(trim(phpBB2.DBA.phpBB2_get_opt('script_path')),'/');\n \n if (O.config_name = 'server_name')\n server_name := trim(O.config_value);\n else \n server_name := trim(phpBB2.DBA.phpBB2_get_opt('server_name'));\n \n if (O.config_name = 'cookie_secure')\n {\n if (cast(O.config_value as integer)) \n server_protocol := 'https://'; \n else \n server_protocol := 'http://';\n } else { \n if (cast(phpBB2.DBA.phpBB2_get_opt('cookie_secure') as integer)) \n server_protocol := 'https://'; \n else \n server_protocol := 'http://';\n };\n \n if (O.config_name = 'server_port')\n {\n if (cast(O.config_value as integer) <> 80)\n server_port := ':' || cast(O.config_value as varchar) || '/';\n else\n server_port := '/';\n } else {\n if (cast(phpBB2.DBA.phpBB2_get_opt('server_port') as integer) <> 80)\n server_port := ':' || cast(phpBB2.DBA.phpBB2_get_opt('server_port') as varchar) || '/';\n else\n server_port := '/';\n };\n \n declare oiri, niri any;\n oiri := DB.DBA.RDF_IID_OF_QNAME (server_protocol || server_name || server_port || script_name || '/');\n niri := DB.DBA.RDF_MAKE_IID_OF_QNAME (phpBB2.DBA.phpBB2_get_graph ());\n update DB.DBA.RDF_QUAD set G = niri where G = oiri;\n update DB.DBA.RDF_QUAD set S = niri where G = niri and S = oiri;\n update DB.DBA.RDF_QUAD set O = niri where G = niri and O = oiri;\n }\n else if (O.config_name = 'sitename')\n {\n declare iri, graph_iri, pred any;\n graph_iri := DB.DBA.RDF_IID_OF_QNAME (phpBB2.DBA.phpBB2_get_graph ());\n iri := graph_iri;\n pred := DB.DBA.RDF_IID_OF_QNAME (phpBB2.DBA.phpBB2_dc_iri ('title'));\n update DB.DBA.RDF_QUAD set O = DB.DBA.RDF_MAKE_OBJ_OF_SQLVAL (N.config_value)\n\t where G = graph_iri and S = iri and P = pred and O = DB.DBA.RDF_MAKE_OBJ_OF_SQLVAL (O.config_value);\n }\n};\n\nphpBB2.DBA.phpBB2_rdf_init ();\n\n-- RDF Views definition\n\ndrop view phpBB2.DBA.phpBB2_site_rdf;\ndrop view phpBB2.DBA.phpBB2_users_rdf;\ndrop view phpBB2.DBA.phpBB2_forums_rdf;\ndrop view phpBB2.DBA.phpBB2_usergroups_rdf;\ndrop view phpBB2.DBA.phpBB2_user_usergroups_rdf;\ndrop view phpBB2.DBA.phpBB2_forum_moderators_rdf;\ndrop view phpBB2.DBA.phpBB2_posts_rdf;\ndrop view phpBB2.DBA.phpBB2_forum_posts_rdf;\n\ncreate view phpBB2.DBA.phpBB2_site_rdf as select top 1\n\tconfig_value as WEB_TITLE,\n\t'' as WEB_LINK,\n\t'' as WS_DUMMY\n\tfrom phpbb_config\n\twhere config_name = 'sitename';\n\ncreate view phpBB2.DBA.phpBB2_users_rdf as select user_id, username,\n\tcase when length (user_email) then 'mailto:'||user_email else null end as E_MAIL,\n\tcase when length (user_email) then sha1_digest (user_email) else null end as E_MAIL_SHA1\n\tfrom phpbb_users\n\twhere user_active = 1;\n\ncreate view phpBB2.DBA.phpBB2_usergroups_rdf as select group_id, group_name from phpbb_groups\n where group_type < 2 and group_single_user = 0;\n\ncreate view phpBB2.DBA.phpBB2_user_usergroups_rdf as select group_id, user_id from phpbb_user_group\n where user_pending = 0;\n\ncreate view phpBB2.DBA.phpBB2_forums_rdf as select\n\tforum_id,\n\tforum_name,\n\tforum_desc,\n\t'Forum' as forum_type,\n\t'' as WS_DUMMY\n\tfrom phpbb_forums ;\n\ncreate view phpBB2.DBA.phpBB2_forum_moderators_rdf as \n select forum_id, user_id \n from phpbb_user_group ug\n INNER JOIN phpbb_auth_access aa on ug.group_id = aa.group_id \n where ug.user_pending = 0;\n\ncreate view phpBB2.DBA.phpBB2_posts_rdf as \n select pp.post_id,\n pp.forum_id,\n pp.poster_id,\n pt.post_subject,\n pt.post_text \n from phpbb_posts pp\n INNER JOIN phpbb_posts_text pt on pp.post_id = pt.post_id;\n\ncreate view phpBB2.DBA.phpBB2_forum_posts_rdf as \n select post_id,\n forum_id\n from phpbb_posts;\n\nexec (\n string_output_string (sparql_to_sql_text (\n'drop quad map graph iri(\"http://^{URIQADefaultHost}^/phpBB2_v/\") .')));\n\n--exec (\n-- string_output_string (sparql_to_sql_text (\n--'drop quad map virtrdf:phpBB2 .')));\n\n--exec (\n-- string_output_string (sparql_to_sql_text (\n--'\n--drop quad storage virtrdf:phpBB2 .\n--')));\n\nexec (\n string_output_string (sparql_to_sql_text (\n'\nprefix sioc: \nprefix sioct: \nprefix atom: \nprefix rdfs: \nprefix foaf: \nprefix dc: \nprefix dct: \nprefix skos: \nprefix geo: \nprefix bm: \nprefix exif: \nprefix ann: \nprefix phpbbsioc: \n\n#create quad storage virtrdf:phpBB2 {\n# create virtrdf:DefaultQuadMap using storage virtrdf:DefaultQuadStorage .\n# } .\n\n\ncreate iri class phpbbsioc:site \"http://^{URIQADefaultHost}^/phpBB2/%U\" (in dummy varchar not null) .\ncreate iri class phpbbsioc:user_iri \"http://^{URIQADefaultHost}^/phpBB2/profile.php?mode=viewprofile&u=%d\" (in user_id integer not null) .\ncreate iri class phpbbsioc:usergroup_iri \"http://^{URIQADefaultHost}^/phpBB2/groupcp.php?g=%d\" (in group_id integer not null) .\ncreate iri class phpbbsioc:forum_iri \"http://^{URIQADefaultHost}^/phpBB2/viewforum.php?f=%d\" (in forum_id integer not null) .\ncreate iri class phpbbsioc:post_iri \"http://^{URIQADefaultHost}^/phpBB2/viewtopic.php?p=%d#%d\" (in forum_id integer not null,in forum_id integer not null) .\n\n#alter quad storage virtrdf:phpBB2\nalter quad storage virtrdf:DefaultQuadStorage\n {\n create virtrdf:phpBB2 as graph iri (\"http://^{URIQADefaultHost}^/phpBB2_v/\")\n {\n\n # Default phpBB Site\n phpbbsioc:site (phpBB2.DBA.phpBB2_site_rdf.WS_DUMMY) a sioc:Site ;\n dc:title WEB_TITLE .\n\n # User\n phpbbsioc:user_iri (phpBB2.DBA.phpBB2_users_rdf.user_id)\n a sioc:User option (EXCLUSIVE);\n sioc:id user_id ;\n sioc:name username ;\n sioc:email E_MAIL ;\n sioc:email_sha1 E_MAIL_SHA1 .\n\n # Usergroup\n phpbbsioc:usergroup_iri (phpBB2.DBA.phpBB2_usergroups_rdf.group_id) \n a sioc:Usergroup option (EXCLUSIVE);\n sioc:id group_id ;\n sioc:name group_name .\n \n # Usergroup - USER ralationship\n phpbbsioc:usergroup_iri (phpBB2.DBA.phpBB2_user_usergroups_rdf.group_id) \n sioc:has_member phpbbsioc:user_iri (user_id) .\n\n # USER - Usergroup ralationship\n phpbbsioc:user_iri (phpBB2.DBA.phpBB2_user_usergroups_rdf.user_id) \n sioc:member_of phpbbsioc:usergroup_iri(group_id) .\n\n # Forum\n phpbbsioc:forum_iri (phpBB2.DBA.phpBB2_forums_rdf.forum_id)\n a sioc:Forum option (EXCLUSIVE);\n a sioc:Container option (EXCLUSIVE);\n sioc:id forum_id ;\n sioc:name forum_name ;\n sioc:description forum_desc ;\n dc:title forum_name ;\n dc:description forum_desc ;\n sioc:type forum_type ;\n sioc:has_host phpbbsioc:site(WS_DUMMY) .\n \n # Forum - moderators ralationship\n phpbbsioc:user_iri (phpBB2.DBA.phpBB2_forum_moderators_rdf.user_id) \n sioc:moderator_of phpbbsioc:forum_iri(forum_id) .\n\n # Site - Forum ralationship\n phpbbsioc:site (phpBB2.DBA.phpBB2_forums_rdf.WS_DUMMY) \n sioc:host_of phpbbsioc:forum_iri(forum_id) .\n\n # Moderators - Forum ralationship\n phpbbsioc:forum_iri (phpBB2.DBA.phpBB2_forum_moderators_rdf.forum_id) \n sioc:has_moderator phpbbsioc:user_iri(user_id) .\n\n # Post\n phpbbsioc:post_iri (phpBB2.DBA.phpBB2_posts_rdf.post_id,phpBB2.DBA.phpBB2_posts_rdf.post_id)\n a sioc:Post option (EXCLUSIVE);\n a sioc:Item option (EXCLUSIVE);\n sioc:id post_id ;\n sioc:has_container phpbbsioc:forum_iri(forum_id) ;\n dc:title post_subject ;\n sioc:has_creator phpbbsioc:user_iri (poster_id) ;\n sioc:content post_text .\n\n # Forum - post\n phpbbsioc:forum_iri (phpBB2.DBA.phpBB2_forum_posts_rdf.forum_id) \n sioc:container_of phpbbsioc:post_iri(post_id,post_id) .\n\n }\n } .\n')));\n\ngrant select on phpBB2.DBA.phpBB2_site_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_users_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_usergroups_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_user_usergroups_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_forums_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_forum_moderators_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_posts_rdf to \"SPARQL\";\ngrant select on phpBB2.DBA.phpBB2_forum_posts_rdf to \"SPARQL\";\n\nDB.DBA.XML_SET_NS_DECL ('phpbbsioc', 'http://openlinksw.com/phpBB/sioc/', 2);\n\n\nCategoryVirtuoso CategoryRDF" . "VirtRDFViewPHPBB" . . . . . . . . . . . . "2017-06-13T05:37:15.606127"^^ . "VirtRDFViewPHPBB" . . "2017-06-13T05:37:15Z" . "2017-06-13T05:37:15.606127"^^ . "2017-06-13T05:37:15Z" . "VirtRDFViewPHPBB" . . "333fdb455ee25d09bfcf8d6e84f98c4a" .