<?
function bibrating_recal($ID) {
	$now=time();
	$orig=tmq("select * from media where randid='$ID' ");
	$orig=tmq_fetch_array($orig);
	//printr($orig);
	$s=tmq("select * from webpage_bibrating_log where bibid='$ID' ",false);
	if (tmq_num_rows($s)==0) {
		tmq("delete from webpage_bibrating_sum where bibid='$ID' ");
	} else {
		$data=tmq("select count(id) as cc1, avg(score) as avg1 from webpage_bibrating_log where bibid='$ID' ",false);
		$data=tmq_fetch_array($data);
		$s=tmq("select * from webpage_bibrating_sum where bibid='$ID' ",false);
		if (tmq_num_rows($s)!=1) {
			tmq("delete from webpage_bibrating_sum where bibid='$ID' ");
			tmq("insert into webpage_bibrating_sum set bibid='$ID' , 
			dtcreate='$now' ,
			dtlast='$now' ,
			votescore='$data[avg1]' ,
			votecount='$data[cc1]',
			LIBSITE='$orig[LIBSITE]'
			");
		} else {
			tmq("update webpage_bibrating_sum set 
			dtlast='$now' ,
			votescore='$data[avg1]' ,
			votecount='$data[cc1]',
			LIBSITE='$orig[LIBSITE]'

			where bibid='$ID' 
			");
		}
		//update index_db
		tmq("update index_db set bibrating ='$data[avg1]' where mid='$ID' ");
	}
}
?>