query($q4);
$set=$database->query($q);
$set3=$database->query($q3);
$set3->next();
$pomerall= ($set3->getString('allkarma')) /($set3->getString('psubmall'));
//Vsetka karma v systeme
echo "allkarma: ".$set3->getString('allkarma')."
";
//celkovy pocet prispevkov
echo "psubmall: ".$set3->getString('psubmall')."
";
//pomer karmy na prispevok celek kyberky
echo "pomerall: ".$pomerall."
";
//najprv sa stanovi dkarma podla charizmy
while($set->next()) {
$q0="update user set charisma='".$set->getString('pocet')."' where id='".$set->getString('friend_id')."'";
echo $q0."
";
// $database->query($q0);
$q0="update user set user_k='".$set->getString('pocet')."' where id='".$set->getString('friend_id')."'";
echo $q0."
";
// $database->query($q0);
}
echo "
";
//potom vyberiem z db rozne kraviny
$set2=$database->query($q2);
//a potom to cele rozdrbem neprehladnym vzorcom
while($set2->next()) {
$psubm=$set2->getString('psubm');
if ($psubm>100){
echo "ulogin: ".$set2->getString('ulogin')."
";
//userova dkarma podla charismy
echo "uk: ".$set2->getString('uk')."
";
//userovi pridelena karma celkovo
echo "ukarma: ".$set2->getString('ukarma')."
";
//pocet userovych prispevkov
echo "psubm: ".$set2->getString('psubm')."
";
$pomeruser=( $set2->getString('ukarma'))/($set2->getString('psubm'));
$from_average=($pomeruser/$pomerall);
$newuk=floor($from_average*23);
//pomer karmy na prispevok celek kyberky
echo "pomeruser: ".$pomeruser."
";
//pomer kvality prispevkov usera a celej kyberky
echo "from_average: ".$from_average."
";
//nova dkarma bez upravy nulovania podpriemeru
echo "newuk: ".$newuk."
";
//aby dostali K+ len nadpriemerny prispievatelia
if ($newuk>23) {$newuk=$newuk-23;}
else {$newuk=0;}
if ($newuk>46) {$newuk=46;}
$newuk+=($set2->getString('uk'));
$q0="update user set user_k='".$newuk."' where id='".$set2->getString('uid')."'";
echo $q0." ".$set2->getString('ulogin')."
";
// $database->query($q0);
}
}
//malo by z toho byt nieco taketo
//dk= (((userk/usersubm)/(allk/allsubm))) *23 , ?dk>23:$dk-23!$dk=0
?>