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


include_once("../../core/config/core.config.php");
include_once("../../core/class/Db.class.php");

if (!empty($_POST['comment_id']) && !empty($_POST['connection_id'])) {

	$db = new Database($core_config['db']);

	$query = "
		SELECT *
		FROM " . $db->prefix . "_comment_recommendation
		WHERE comment_id=" . $_POST['comment_id'] . " AND
		connection_id=" . $_POST['connection_id'] . ""
	;

	$result = $db->Execute($query);

	if (!empty($result[0])) {
		$query = "
			DELETE FROM
			" . $db->prefix . "_comment_recommendation
			WHERE comment_id=" . $_POST['comment_id'] . " AND
			connection_id=" . $_POST['connection_id'] . ""
		;

		$db->Execute($query);
	}
	else {
		$rec = array();
		$rec['comment_id'] = $_POST['comment_id'];
		$rec['connection_id'] = $_POST['connection_id'];

		$table = $db->prefix . "_comment_recommendation";

		$db->insertDb($rec, $table);
	}

	$query = "
		SELECT COUNT(*) AS total_recommendations
		FROM " . $db->prefix . "_comment_recommendation
		WHERE comment_id=" . $_POST['comment_id'] . ""
	;

	$result = $db->Execute($query);

	echo $_POST['comment_id'] . '|' . $result[0][0];
}

?>