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

<?
ini_set("include_path","/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/");
include_once("kyberia.inc");
$database=new CLASS_KYBERIA();
$q="select mail_to as user_id,count(*) as pocet from mail where mail_new='yes' group by mail_to";
$set=$database->query($q);
while($set->next()) {
	$q="update user set user_mail='".$set->getString('pocet')."' where id='".$set->getString('user_id')."'";
	$set2=$database->query($q);
}
?>
Commit	Line	Data
bc13d5d6 H	1	<?
	2	ini_set("include_path","/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/");
	3	include_once("kyberia.inc");
	4	$database=new CLASS_KYBERIA();
	5	$q="select mail_to as user_id,count(*) as pocet from mail where mail_new='yes' group by mail_to";
	6	$set=$database->query($q);
	7	while($set->next()) {
	8	$q="update user set user_mail='".$set->getString('pocet')."' where id='".$set->getString('user_id')."'";
	9	$set2=$database->query($q);
	10	}
	11	?>