medal.php

PHPWind7_RC_UTF8 开源php论坛很不错的

<?php
!function_exists('readover') && exit('Forbidden');
$query = $db->query("SELECT id,awardee,level FROM pw_medalslogs WHERE action='1' AND state='0' AND timelimit>0 AND $timestamp-awardtime>timelimit*2592000");
$medaldb = $namedb = array();
while ($rt = $db->fetch_array($query)) {
	Add_S($rt);
	$medaldb[$rt['awardee']][] = array($rt['id'],$rt['level']);
	$namedb[] = $rt['awardee'];
}
if ($namedb) {
	include_once(R_P.'require/msg.php');
	include_once(D_P.'data/bbscache/medaldb.php');
	$namedb = array_unique($namedb);
	$usernames = "'".implode("','",$namedb)."'";
	$reason = Char_cv(getLangInfo('other','medal_reason'));
	$query = $db->query("SELECT uid,username,medals FROM pw_members WHERE username IN($usernames)");
	$ids = '';
	$medaluser = array();
	while ($rt = $db->fetch_array($query)) {
		Add_S($rt);
		$medals = ",".$rt['medals'].",";
		$medalname = '';
		foreach ($medaldb[$rt['username']] as $key => $value) {
			$ids .= $ids ? ','.$value[0] : $value[0];
			$medal = $value[1];
			$db->update("INSERT INTO pw_medalslogs(awardee,awarder,awardtime,level,action,why) VALUES('$rt[username]','SYSTEM','$timestamp','$medal','2','$reason')");
			$medals = str_replace(",$medal,",',',$medals);
			$medaluser = '(uid='.pwEscape($rt['uid']).' AND mid='.pwEscape($medal).')';
			$medalname .= $medalname ? ','.$_MEDALDB[$medal]['name'] : $_MEDALDB[$medal]['name'];
		}
		$message = array(
			'toUser'	=> $rt['username'],
			'subject'	=> 'metal_cancel',
			'content'	=> 'metal_cancel_text',
			'other'		=> array('medalname'=>$medalname)
		);
		pwSendMsg($message);
		$medals = substr($medals,1,-1);
		$db->update("UPDATE pw_members SET medals='$medals' WHERE uid='$rt[uid]'");
	}
	$ids && $db->update("UPDATE pw_medalslogs SET state='1' WHERE id IN($ids)");
	if ($medaluser) {
		$db->update("DELETE FROM pw_medalslogs WHERE ".implode(' OR ',$medaluser));
	}
	updatemedal_list();
}
function updatemedal_list(){
	global $db;
	$query = $db->query("SELECT uid FROM pw_medaluser GROUP BY uid");
	$medaldb = '<?php die;?>0';
	while($rt=$db->fetch_array($query)){
		$medaldb .= ','.$rt['uid'];
	}
	writeover(D_P.'data/bbscache/medals_list.php',$medaldb);
}
?>