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['blog'] = "
	SELECT b.blog_id AS item_id, b.blog_title AS item_title, b.blog_body AS item_body, 
	b.blog_create_datetime AS item_create_datetime, t.webpage_id, t.plugin_name
	FROM " . $db->prefix . "_plugin_blog b
	INNER JOIN " . $db->prefix . "_tag t
	ON (b.blog_id=t.plugin_item_id AND t.plugin_name='blog')
	WHERE b.webspace_id=" . $_REQUEST['ws'] . "
	AND t.tag_name=" . $db->qstr($_REQUEST['tag']) . ""
;

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

?>