Jump to navigation

You are currently browsing all posts tagged with '帝国ecms'

uchome与帝国ecms积分兑换与积分同步

  • Posted on July 13, 2010 at 9:53 am

众所周知，uchome与ecms有二种整合方式：
1 万能会员接口。ecms只能与discuz进行同步登录，同步积分。uchome就没办法了。
2 ucenter接口。ecms可以和uchome同步登录。无法同步积分。

下面介绍一下积分兑换的方法：
把这些代码保存成php文件，放到uchome的根目录下即可。
如果您实在不知道怎样搞，可以付费请QQ：190890101 协助搞定。

<?PHP
header("Cache-Control:no-cache,must-revalidate");
header("Expires: -1");
header("Pragma:no-cache");
 
include_once('./common.php');
checkclose();
checklogin();
require_once './source/function_common.php';
 
include_once(S_ROOT.'./source/function_cp.php');
 
$uid = $_SGLOBAL['supe_uid'];
$username = $_SGLOBAL['supe_username'];
$db = $_SGLOBAL['db'];
$ecms_user_table = "ucenter.phome_enewsmember";
$uchome_user_table = "ucenter.uchome_space";
// 1 means 1 uchome -> 1 ECMS
// 2 means 1 uchome -> 2 ECMS
// 1/2 means 1 uchome -> 1/2 ECMS
define ("DUIHUAN_BILI", 1);
 
if (isset($_POST['exchange']))
{
	//进行积分兑换。
	$from = trim($_POST['from']);
	$to = trim($_POST['to']);
 
	$count = intval($_POST['count']);
	if ($count <= 0)
	{
		showmessage("兑换积分数必须大于0。");
	}
	if ($from == "uchome" && $to=="ecms")
	{
		$count_ecms = intval($count * DUIHUAN_BILI);
		$count_uchome = $count;
		//从uchome取出积分
		$sql = "SELECT credit FROM ".$uchome_user_table." WHERE uid='".$uid."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		$row = $db->fetch_array($query);
		//检测是否足够
		if (intval($row['credit']) < $count_uchome)
		{
			showmessage("UCHOME积分不足!");
 
		}
		//-uchome
		$sql = "UPDATE ".$uchome_user_table." SET credit=credit-".$count_uchome." WHERE uid='".$uid."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		//+ecms.
		$sql = "UPDATE ".$ecms_user_table." SET userfen=userfen+".$count_ecms." WHERE username='".$username."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		showmessage("成功兑换.");
	}
	else if ($from == "ecms" && $to == "uchome")
	{
		$count_ecms = $count;
		$count_uchome = intval($count/DUIHUAN_BILI);
		//从ecms取出积分
		$sql = "SELECT userfen FROM ".$ecms_user_table." WHERE username='".$username."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		$row = $db->fetch_array($query);
		//检测是否足够
		if (intval($row['userfen']) < $count_ecms)
		{
			showmessage("ECMS 点数不够!");
		}
 
		//-ecms.
		$sql = "UPDATE ".$ecms_user_table." SET userfen=userfen-".$count_ecms." WHERE username='".$username."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		//+uchome
		$sql = "UPDATE ".$uchome_user_table." SET credit=credit+".$count_uchome." WHERE uid='".$uid."'";
		//print $sql ."<BR>";
		$query = $db->query($sql);
		showmessage("成功兑换.");
 
	}
	else
	{
		showmessage("我");
	}
}
 
 
$sql = "SELECT userfen FROM ".$ecms_user_table." WHERE username='".$username."'";
//print $sql ."<BR>";
$query = $db->query($sql);
$row = $db->fetch_array($query);
$ecms_credits = intval($row['userfen']);
 
$sql = "SELECT credit FROM ".$uchome_user_table." WHERE uid='".$uid."'";
//print $sql ."<BR>";
$query = $db->query($sql);
$row = $db->fetch_array($query);
$uchome_credits = intval($row['credit']);
?>
<!--显示兑换表单-->
<form method=POST id='f1'>
from:
<select name='from' id='from' onChange='from_change(this.value);'>
<option value='uchome'>UCHOME</option>
<option value='ecms'>ECMS</option>
</select>
to:
<select name='to' id='to'>
<option value='ecms'>ECMS</option>
</select>
<br>
现有积分：
<div id='div_uchome_credits' style='display:;'>UCHOME:<?PHP print $uchome_credits;?></div>
<div id='div_ecms_credits' style='display:none;'>ECMS:<?PHP print $ecms_credits;?></div>
兑换数量:
<input type=text name='count' value='' id='count'><br />
<input type=hidden name='exchange' value='1'>
<input  type='button' onClick='check_form();' value='兑换！'>
</form>
<script>
function check_form()
{
	var f = document.getElementById("f1");
	var count = parseInt(document.getElementById("count").value);
	f.submit();
}
function from_change(v)
{
	//清空to.
	//
	document.getElementById("to").options.length=0;
	if(v=="uchome")
	{
		//to增加ecms
		document.getElementById("div_uchome_credits").style.display = "";
		document.getElementById("div_ecms_credits").style.display = "none";
		m_add(document.getElementById("to"), "ECMS", "ecms");
	}
	else if (v =="ecms")
	{
		//to增加uchome
		document.getElementById("div_uchome_credits").style.display = "none";
		document.getElementById("div_ecms_credits").style.display = "";
		m_add(document.getElementById("to"), "UCHOME", "uchome");
	}
	else
	{
		//do nothing.
	}
}
 
function m_add(obj, key,value)
{
 var o = new Option(key,value);
 obj.options.add(o);
}
</script>

Top