| 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 | |