aiqiang.php

UCH爱墙插件

<?php
error_reporting( E_ERROR | E_PARSE );

if ( function_exists( 'date_default_timezone_set' ) )
	date_default_timezone_set( 'PRC' );

include( 'database.inc.php' );

$DB = new MySQL();
##############################

// 数据库主机
$DB->serverName = 'localhost';

// 数据库名
$DB->dbName = 'xxxxxx';

// 数据库用户名
$DB->dbUsername = 'xxxxx';

// 数据库密码
$DB->dbPassword = 'xxxxxx';

// 管理页面名
$managePage = '你设定的管理后台名称（后台暂不发布正在测试）';

##############################

$DB->Connect();
$DB->SelectDB();

if ( get_magic_quotes_gpc() )
{
	StripslashesArray( $_POST );
	StripslashesArray( $_GET );
	StripslashesArray( $_COOKIE );
}

function AddWish( $name, $content, $bgID, $signID, $ip )
{
	global $DB;
	$sql = "INSERT INTO plugin_wish SET name='{$name}',content='{$content}',bg_id='{$bgID}',sign_id='{$signID}',ip='{$ip}',add_time=NOW()";
	if ( $DB->Update( $sql ) )
		return true;
	else
		return false;
}

function GetWishes( $start = 0, $limit = 80 )
{
	global $DB;
	$sql = "SELECT * FROM plugin_wish ORDER BY ID DESC LIMIT {$start},{$limit}";
	return $DB->FM( $sql );
}

function DeleteWish( $str )
{
	global $DB;
	$sql = "DELETE FROM plugin_wish WHERE id IN({$str})";
	return $DB->FM( $sql );
}

function SearchWishes( $name )
{
	global $DB;
	$name = str_replace( '=', '', addslashes( $name ) );
	$sql = "SELECT * FROM plugin_wish WHERE name='{$name}' ORDER BY ID DESC LIMIT 0,80";
	return $DB->FM( $sql );
}

function GetCount()
{
	global $DB;
	$sql = "SELECT count(*) as total FROM plugin_wish";
	$result = $DB->FO( $sql );
	return $result['total'];
}

function StripSlashesArray( & $array )
{
	while ( list( $key, $var ) = each( $array ) )
	{
		if ( $key != 'argc' && $key != 'argv' && ( strtoupper( $key ) != $key || '' . intval( $key ) == "$key" ) )
		{
			if ( is_string( $var ) )
				$array[$key] = stripslashes( $var );
			if ( is_array( $var ) )
				$array[$key] = StripslashesArray( $var );
		}
	}
	return $array;
}

function GetIP()
{
	if ( $_SERVER['HTTP_CLIENT_IP'] )
		return $_SERVER['HTTP_CLIENT_IP'];
	elseif ( $_SERVER['HTTP_X_FORWARDED_FOR'] )
		return $_SERVER['HTTP_X_FORWARDED_FOR'];
	else
		return $_SERVER['REMOTE_ADDR'];
}

function CleanHtmlTags( $content )
{
	$content = htmlspecialchars( $content );
	$content = str_replace( '\n', '<br />', $content );
	$content = str_replace( '  ', '&nbsp;&nbsp;' , $content );
	return str_replace( '\t', '&nbsp;&nbsp;&nbsp;&nbsp;', $content );
}

function MultiPage( $total, $onePage, $page )
{
	$totalPage = ceil( $total / $onePage );
	$linkArray = explode( "page=", $_SERVER['QUERY_STRING'] );
	$linkArg = $linkArray[0];

	if ( $linkArg=='' )
		$url = $_SERVER['PHP_SELF'] . "?";
	else
	{
		$linkArg = substr( $linkArg, -1 ) == "&" ? $linkArg : $linkArg . '&';
		$url = $_SERVER['PHP_SELF'] . '?' . $linkArg;
	}

	!$totalPage && $totalPage = 1;
	( $page > $totalPage ) && $page = 1;
	!$page && $page = 1;

	$mid = floor( 10 / 2 );
	$last = ( 10 - 1 );
	$minPage = ( $page - $mid ) < 1 ? 1 : $page - $mid;
	$maxPage = $minPage + $last;

	if ( $maxPage > $totalPage )
	{
		$maxPage = $totalPage;
		$minPage = $maxPage - $last;
		$minPage = $minPage < 1 ? 1 : $minPage;
	}

	for ( $i = $minPage; $i <= $maxPage; $i++ )
	{
		if ( $i == $page )
			$numPageBar .= "<span class=\"page_on\">[$i]</span>";
		else
			$numPageBar .= "<a href=\"{$url}page=$i\">[$i]</a>";
	}

	if ( $page != 1 )
		$firstPageBar = "<a href=\"{$url}page=1\" title=\"第一页\">第一页</a> ";

	if ( $page > 1 )
	{
		$prePage = $page - 1;
		$prePageBar = "<a href=\"{$url}page=$prePage\" title=\"上一页\">上一页</a> ";
	}

	if ( $page < $totalPage )
	{
		$nextPage = $page + 1;
		$nextPageBar = " <a href=\"{$url}page=$nextPage\" title=\"下一页\"下一页</a>";
	}

	if ( $page != $totalPage ) 
		$lastPageBar = " <a href=\"{$url}page=$totalPage\" title=\"最后一页\">最后一页</a>";

	return $firstPageBar . $prePageBar . $numPageBar . $nextPageBar . $lastPageBar;
}
?>