admin_friendlinks.php

来自「这是php编的论坛的原代码」· PHP 代码 · 共 174 行

<?php
/***************************************************************************
 *                           admin_friendlinks.php
 *                            -------------------
 *   begin                : Thursday, Jul 12, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : [e-mail]
 *
 *   $Id: admin_friendlinks.php,v 1.1.1.1 2003/02/11 22:27:31 wei.gao Exp $
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   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 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if ( !empty($setmodules) )
{
	$filename = basename(__FILE__);
	$module['Friendlinks']['Manage'] = $filename;

	return;
}

$submit = (isset($HTTP_POST_VARS['submit'])) ? TRUE : FALSE;

//
// Load default header
//
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('pagestart.' . $phpEx);

if ($submit)
{
	//
	// Change Friend Links
	//
	$link_change_list = ( isset($HTTP_POST_VARS['link_change_list']) ) ? $HTTP_POST_VARS['link_change_list'] : array();
	$link_name_list = ( isset($HTTP_POST_VARS['link_name_list']) ) ? $HTTP_POST_VARS['link_name_list'] : array();
	$link_url_list = ( isset($HTTP_POST_VARS['link_url_list']) ) ? $HTTP_POST_VARS['link_url_list'] : array();
	$link_image_list = ( isset($HTTP_POST_VARS['link_image_list']) ) ? $HTTP_POST_VARS['link_image_list'] : array();

	$allowed_list = array();

	for ($i = 0; $i < count($link_change_list); $i++)
	{
		$sql = "UPDATE " . FRIENDLINKS_TABLE . " 
			SET link_name = '" . trim(strip_tags($link_name_list[$i])) . "',
				link_url = '" . trim(strip_tags($link_url_list[$i])) . "',
				link_image = '" . trim(strip_tags($link_image_list[$i])) . "'
			WHERE link_id = " . $link_change_list[$i];

		if ( !($db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Couldn\'t update Friend Links', '', __LINE__, __FILE__, $sql);
		}
	}

	//
	// Delete Friend Links
	//
	$link_id_list = ( isset($HTTP_POST_VARS['link_id_list']) ) ?  $HTTP_POST_VARS['link_id_list'] : array();

	$link_id_sql = implode(', ', $link_id_list);

	if ($link_id_sql != '')
	{
		$sql = 'DELETE 
			FROM ' . FRIENDLINKS_TABLE . ' 
			WHERE link_id IN (' . $link_id_sql . ')';

		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not delete Friend Links', '', __LINE__, __FILE__, $sql);
		}
	}

	//
	// Add Friend Links ?
	//
	$link_name = ( isset($HTTP_POST_VARS['link_name']) ) ?  trim(strip_tags($HTTP_POST_VARS['link_name'])) : '';
	$link_url = ( isset($HTTP_POST_VARS['link_url']) ) ?  trim(strip_tags($HTTP_POST_VARS['link_url'])) : '';
	$link_image = ( isset($HTTP_POST_VARS['link_image']) ) ?  trim(strip_tags($HTTP_POST_VARS['link_image'])) : '';
	$add = ( isset($HTTP_POST_VARS['add_link_check']) ) ? TRUE : FALSE;

	if ($link_url != '' && $add)
	{
		//
		// check link name
		//
		$sql = 'SELECT link_url
			FROM ' . FRIENDLINKS_TABLE;

		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not query Friend Links Table', '', __LINE__, __FILE__, $sql);
		}
			
		$row = $db->sql_fetchrowset($result);
		$num_rows = $db->sql_numrows($result);

		if ( $num_rows > 0 )
		{
			for ($i = 0; $i < $num_rows; $i++)
			{
				if ($row[$i]['link_url'] == $link_url)
				{
					message_die(GENERAL_ERROR, $lang['Friend_Link_exist']);
				}
			}
		}
			
		$sql = "INSERT INTO " . FRIENDLINKS_TABLE . " (link_name, link_url, link_image) 
			VALUES ('" . $link_name . "', '" . $link_url . "' , '" . $link_image . "')";

		if ( !($db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not add Friend Link', '', __LINE__, __FILE__, $sql);
		}
	}

	$message = $lang['Friendlinks_updated'] . '<br /><br />' . sprintf($lang['Click_return_friendlinks_config'], '<a href="' . append_sid("admin_friendlinks.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');

	message_die(GENERAL_MESSAGE, $message);
}

$sql = 'SELECT * 
	FROM ' . FRIENDLINKS_TABLE;
if(!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not find Frind Links Table', '', __LINE__, __FILE__, $sql);
}
$friendlinks_rowset = $db->sql_fetchrowset($result);

$template->set_filenames(array(
	"body" => "admin/friendlinks_body.tpl")
);

$template->assign_vars(array(
	"L_MANAGE_FRIENDLINKS_TITLE" => $lang['Manage_friendlinks'],
	"L_MANAGE_FRIENDLINKS_EXPLAIN" => $lang['Manage_friendlinks_explain'],
	"S_FRIENDLINKS_ACTION" => append_sid('admin_friendlinks.' . $phpEx),
	"L_NAME" => $lang['Friendlink_name'],
	"L_URL" => $lang['Friendlink_url'],
	"L_IMAGE" => $lang['Friendlink_image'],
	"L_ADD_NEW" => $lang['Add_new'],
	"L_DELETE" => $lang['Delete'],
	"L_SUBMIT" => $lang['Submit'])
);
for ($i = 0; $i < count($friendlinks_rowset); $i++)
{
	$template->assign_block_vars("friendlinks", array(
		"LINK_ID" => $friendlinks_rowset[$i]['link_id'],
		"LINK_NAME" => $friendlinks_rowset[$i]['link_name'],
		"LINK_URL" => $friendlinks_rowset[$i]['link_url'],
		"LINK_IMAGE" => $friendlinks_rowset[$i]['link_image'])
	);
		
}

$template->pparse("body");	

include('page_footer_admin.' . $phpEx);

?>