admin.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/>
// -----------------------------------------------------------------------

if(isset($_SESSION['level_id']) && $_SESSION['level_id'] == 64) {

	include_once($language_path . 'common.lang.php');
	
	if (isset($_POST['delete_guestbooks'])) {
		if (!empty($_POST['guestbook_ids'])) {
			// we delete and insert options
			$query = "
				DELETE FROM " . $db->prefix . "_plugin_guestbook 
				WHERE 
				guestbook_id in(" . implode(",", $_POST['guestbook_ids']) . ")"
			;
			
			$result = $db->Execute($query);
		}
	}
	
	
	// LIST GUESTBOOKS ----------------------------------------------------
	$query = "
		SELECT gb.guestbook_id, UNIX_TIMESTAMP(gb.guestbook_create_datetime) as guestbook_create_datetime,
		gb.guestbook_body, c.connection_nickname, c.connection_openid
		FROM " . $db->prefix . "_plugin_guestbook gb, " . $db->prefix . "_connection c
		WHERE
		gb.connection_id=c.connection_id AND
		gb.webspace_id=" . $output_webspace['webspace_id'] . "
		ORDER BY gb.guestbook_create_datetime"
	;
	
	$result = $db->Execute($query);
		
	if (isset($result)) {
		$body->set('guestbooks', $result);
	}
}
else { // no permission to be here
	header("Location: index.php?ws=" . $_REQUEST['ws']);
	exit;
}

?>