[mirrors/Kyberia-bloodline.git] / admin / karmer.php

<?

ini_set("include_path","/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config");
include_once("kyberia.inc");
$database=new CLASS_KYBERIA();
$q="select acceptor_id,sum(k_amount) as pocet from k_logs group by acceptor_id";

$set=$database->query($q);
while($set->next()) {
	$q="update user set user_karma='".$set->getString('pocet')."' where id='".$set->getString('acceptor_id')."'";
	echo $q."<br>";
	$database->query($q);
}
?>
Commit	Line	Data
bc13d5d6 H	1	<?
	2
	3	ini_set("include_path","/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config");
	4	include_once("kyberia.inc");
	5	$database=new CLASS_KYBERIA();
	6	$q="select acceptor_id,sum(k_amount) as pocet from k_logs group by acceptor_id";
	7
	8	$set=$database->query($q);
	9	while($set->next()) {
	10	$q="update user set user_karma='".$set->getString('pocet')."' where id='".$set->getString('acceptor_id')."'";
	11	echo $q."<br>";
	12	$database->query($q);
	13	}
	14	?>