kps_web/kps_result/core.inc.php

   1 <?php
   2 function db_query_ng($result)
   3 {
   4         if ($result == FALSE) {
   5                 echo "db error!";
   6                 echo mysql_error();
   7                 exit(1);
   8         }
   9 }
  10
  11 function runSQL($sql_string, $verify = false)
  12 {
  13         $db = "";
  14         $link = "";
  15         $host = 'localhost';
  16         $db_name = 'ug7241_db';
  17         $db_user = 'kps';
  18         $db_password = 'password';
  19
  20         $link = mysql_connect($host, $db_user, $db_password);
  21         db_query_ng($link);
  22
  23         $res  = mysql_db_query($db_name, $sql_string, $link);
  24         db_query_ng($res);
  25         // mysql_db_query returns either positive result ressource or true/false for an insert/update statement
  26         if ($res === false){
  27                 if ($verify){
  28                         // report DB Problem
  29                         errorpage('Database Problem', mysql_error($link)."\n<br />\n".$sql_string);
  30                 } else {
  31                         // ignore problem but forward the information
  32                         $result = false;
  33                 }
  34         }else {
  35                 $result = $res;
  36         }
  37
  38         mysql_close($link);
  39         return $result;
  40 }
  41
  42 function getrelease()
  43 {
  44         $retarray = array();
  45         $i = 0;
  46
  47         $sql = 'select release_ver from kps where name != "end"';
  48         $result = runSQL($sql);
  49         db_query_ng($result);
  50         while ($row = mysql_fetch_array($result)) {
  51                 $row['release_ver'] = $row['release_ver']." ";
  52                 if (!in_array($row['release_ver'], $retarray)) {
  53                         $retarray[$i] = $row['release_ver'];
  54                         $i++;
  55                 }
  56         }
  57         while ($i > 0) {
  58                 $i--;
  59                 $retarray[$i] = trim($retarray[$i]);
  60         }
  61         return array_reverse($retarray);
  62 }
  63
  64 /* Store name's info to $number
  65  *
  66  * $id: name of people or org
  67  * $release: array of release info
  68  * $key: what kind of info we store, example: set_num | line_num
  69  *
  70  * return: store the query result into it
  71  */
  72 function getinfo($name, $release, $key)
  73 {
  74         $number = array();
  75         $count = count($release);
  76         for ($i = 0; $i < $count; $i++) {
  77                 $number[$i] = 0;
  78                 if ($name != NULL) {
  79                         $sql = 'select SUM('.$key.') from kps where name = "'.$name
  80                                 .'" and release_ver = "'.$release[$i].'"';
  81                         $result = runSQL($sql);
  82                         db_query_ng($result);
  83                         if (!($row = mysql_fetch_array($result)))
  84                                 continue;
  85                         $number[$i] = $row[0];
  86                 } else {
  87                         $sql = 'select * from kps where class = 1 and release_ver = "'.$release[$i].'"';
  88                         $result = runSQL($sql);
  89                         db_query_ng($result);
  90                         while ($row = mysql_fetch_array($result))
  91                                 $number[$i] += $row[$key];
  92                 }
  93         }
  94         return $number;
  95 }
  96
  97 function getrank($name, $release, $key)
  98 {
  99         $number = array();
 100         $count = count($release);
 101         for ($i = 0; $i < $count; $i++) {
 102                 $number[$i] = 0;
 103                 if ($name != NULL) {
 104                         $sql = 'select * from kps where name = "'.$name
 105                                 .'" and release_ver = "'.$release[$i].'"';
 106                         $result = runSQL($sql);
 107                         db_query_ng($result);
 108                         if (!($row = mysql_fetch_array($result)))
 109                                 continue;
 110                         $thiscount = $row[$key];
 111                         $thisclass = $row['class'];
 112
 113                         $sql = 'select count(*) as amount from kps where class = '.
 114                                 $thisclass.' and release_ver = "'.$release[$i].'"'.
 115                                 ' and '.$key.' > '.$thiscount;
 116                         $result = runSQL($sql);
 117                         db_query_ng($result);
 118                         $row = mysql_fetch_row($result);
 119                         /* If there are x item before this,
 120                          * this should be ranked as x+1
 121                          */
 122                         $number[$i] = $row[0]+1;
 123                 }
 124         }
 125         return $number;
 126 }
 127
 128 function getwho($class, $release)
 129 {
 130         $ret = array();
 131         $count = count($release);
 132         for ($i = 0; $i < $count; $i++) {
 133                 $sql = 'select count(id) from kps where class = '.$class
 134                         .' and release_ver = "'.$release[$i].'"';
 135                 $result = runSQL($sql);
 136                 db_query_ng($result);
 137                 $row = mysql_fetch_array($result);
 138                 $ret[$i] = $row[0];
 139
 140         }
 141         return $ret;
 142 }
 143
 144 function maxofarray($array)
 145 {
 146         $ret = 0;
 147         $count = count($array);
 148         for ($i = 0; $i < $count; $i++)
 149                 if ($array[$i] > $ret)
 150                         $ret = $array[$i];
 151         return $ret;
 152 }
 153
 154 function minofarray($array)
 155 {
 156         $ret = $array[0];
 157         $count = count($array);
 158         for ($i = 1; $i < $count; $i++)
 159                 if ($array[$i] < $ret)
 160                         $ret = $array[$i];
 161         return $ret;
 162 }
 163
 164 function id2name($id)
 165 {
 166         $sql = 'select * from kps where id = '.$id;
 167         $result = runSQL($sql);
 168         db_query_ng($result);
 169         if (!($row = mysql_fetch_array($result)))
 170                 return "";
 171         else
 172                 return $row['name'];
 173 }
 174
 175 function name2id($name)
 176 {
 177         $sql = 'select * from kps where name = "'.$name.'"';
 178         $result = runSQL($sql);
 179         db_query_ng($result);
 180         if (!($row = mysql_fetch_array($result)))
 181                 return 0;
 182         else
 183                 return $row['id'];
 184 }
 185 ?>