<?php
$con = mysql_connect("115.28.14.33","root","ins");
mysql_select_db("we7",$con);	

//return $this->respText($this->message['from']);


	$identify = 'ozaFEuEU2hOzN6g359kqvMpxtBJ0';
	$sql =<<<EOF
	select `code` from `ims_activity` where `identify` = "$identify"
EOF;
	$query = mysql_query($sql);
	$result= mysql_fetch_array($query,MYSQL_NUM);
	if(!empty($result[0])){
		var_dump($result[0]);
		exit();
//		return $this->respText($result[0]);
	}
	
	$sql = "SELECT `code` FROM `ims_activity` WHERE `usertype` = '0' and `status`= '0' order by id asc limit 1 ";
	$query = mysql_query($sql);
	$record = mysql_fetch_array($query,MYSQL_NUM);
	if(empty($record[0])){
		return $this->respText("奖品已经发送完毕，期待下次参与！");
	}else{
		$sql = <<<EOF
			update `ims_activity` set status='1',`identify`="$identify" where `code`="$record[0]"
EOF;
		mysql_query($sql);
	}
	var_dump($record[0]);
//	return $this->respText($record[0]);