admin/charismerweb.php

   1 <?
   2
   3 ini_set("include_path","./inc:./boxiky/:./config:../inc:../boxiky/:../config");
   4 include_once("kyberia.inc");
   5 $database=new CLASS_KYBERIA();
   6
   7 //toto je povodne stanovenie dK podla charizmy
   8 $q="select count(*) as pocet,friend_id from friends group by friend_id ";
   9 $q2="select count(*) as psubm,u.login as ulogin, u.id as uid, u.user_karma as ukarma, u.user_k as uk from submissions as s inner join user as u on
  10 u.id = s.submission_owner group by s.submission_owner";
  11 $q3="select count(*) as psubmall,sum(s.submission_k) as allkarma from submissions as s, user as u where s.submission_owner=u.id";
  12
  13 //vynulovanie povodnych kariem
  14 //co ak niekto zacne prispievat hrozne nahovno
  15 $q4="update user set user_k='0'";
  16 $database->query($q4);
  17
  18 $set=$database->query($q);
  19 $set3=$database->query($q3);
  20
  21 $set3->next();
  22 $pomerall= ($set3->getString('allkarma')) /($set3->getString('psubmall'));
  23 //Vsetka karma v systeme
  24         echo "allkarma:  ".$set3->getString('allkarma')."<br>";
  25 //celkovy pocet prispevkov
  26         echo "psubmall:  ".$set3->getString('psubmall')."<br>";
  27 //pomer karmy na prispevok celek kyberky
  28         echo "pomerall:  ".$pomerall."<br>";
  29
  30 //najprv sa stanovi dkarma podla charizmy
  31 while($set->next()) {
  32         $q0="update user set charisma='".$set->getString('pocet')."' where id='".$set->getString('friend_id')."'";
  33         echo $q0."<br>";
  34         $database->query($q0);
  35         $q0="update user set user_k='".$set->getString('pocet')."' where id='".$set->getString('friend_id')."'";
  36         echo $q0."<br>";
  37         $database->query($q0);
  38 }
  39         echo "<br><br>";
  40
  41 //potom vyberiem z db rozne kraviny
  42 $set2=$database->query($q2);
  43
  44 //a potom to cele rozdrbem neprehladnym vzorcom
  45 while($set2->next()) {
  46 $psubm=$set2->getString('psubm');
  47 if ($psubm>100){
  48         echo "ulogin:  ".$set2->getString('ulogin')."<br>";
  49 //userova dkarma podla charismy
  50         echo "uk:  ".$set2->getString('uk')."<br>";
  51 //userovi pridelena karma celkovo
  52         echo "ukarma:  ".$set2->getString('ukarma')."<br>";
  53 //pocet userovych prispevkov
  54         echo "psubm:  ".$set2->getString('psubm')."<br>";
  55 $pomeruser=( $set2->getString('ukarma'))/($set2->getString('psubm'));
  56 $from_average=($pomeruser/$pomerall);
  57 $newuk=floor($from_average*23);
  58 //pomer karmy na prispevok celek kyberky
  59         echo "pomeruser:  ".$pomeruser."<br>";
  60 //pomer kvality prispevkov usera a celej kyberky
  61         echo "from_average:  ".$from_average."<br>";
  62 //nova dkarma bez upravy nulovania podpriemeru
  63         echo "newuk:  ".$newuk."<br>";
  64 //aby dostali K+ len nadpriemerny prispievatelia
  65 if ($newuk>23) {$newuk=$newuk-23;}
  66 else {$newuk=0;}
  67 if ($newuk>46) {$newuk=46;}
  68 $newuk+=($set2->getString('uk'));
  69         $q0="update user set user_k='".$newuk."' where id='".$set2->getString('uid')."'";
  70         echo $q0."   ".$set2->getString('ulogin')."<br><br>";
  71         $database->query($q0);
  72 }
  73 }
  74 //malo by z toho byt nieco taketo
  75 //dk= (((userk/usersubm)/(allk/allsubm))^2) *23 , ?dk>23:$dk-23!$dk=0
  76 ?>
  77
  78