GIT.Harvie.CZ / mirrors / Kyberia-bloodline.git / blame
| Commit | Line | Data |
|---|---|---|
| bc13d5d6 H |
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 |