plugin_tags.inc.php

一款开源的sns系统源码 安装简单

<?php

// -----------------------------------------------------------------------
// This file is part of AROUNDMe
// 
// Copyright (C) 2003-2007 Barnraiser
// http://www.barnraiser.org/
// [e-mail]
// 
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
// 
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with this program; see the file COPYING.txt.  If not, see
// <http://www.gnu.org/licenses/>
// -----------------------------------------------------------------------


$queries['wiki'] = "
	SELECT r.revision_id AS item_id, w.wikipage_name AS item_title, r.revision_body AS item_body, 
	r.revision_create_datetime AS item_create_datetime, t.webpage_id, t.plugin_name
	FROM " . $db->prefix . "_plugin_wiki_page w
	INNER JOIN " . $db->prefix . "_plugin_wiki_revision r
	ON w.current_revision_id=r.revision_id
	INNER JOIN " . $db->prefix . "_tag t
	ON (w.wikipage_id=t.plugin_item_id AND t.plugin_name='wiki')
	WHERE w.webspace_id=" . $_REQUEST['ws'] . "
	AND t.tag_name=" . $db->qstr($_REQUEST['tag']) . ""
;

function getTagLink_wiki($item_id, $webpage_id, $webspace_id) {
	return 'index.php?ws=' . $webspace_id . '&amp;wp=' . $webpage_id . '&amp;revision_id=' . $item_id;
}

?>