コード例 #1
0
ファイル: quote.php プロジェクト: hkirsman/tsitaat_com
 public static function vote_against($arr)
 {
     if (!quote::check_if_can_vote($arr)) {
         return false;
     }
     global $config_q;
     $q1 = "\n\t\t\tINSERT INTO\n\t\t\t" . $config_q["db"]["prefix"] . "quote_votes_log\n\t\t\t(\n\t\t\t\tquote_id,\n\t\t\t\tvote,\n\t\t\t\tuser_id,\n\t\t\t\tip,\n\t\t\t\ttime\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t'" . $arr["quote_id"] . "',\n\t\t\t\t-1,\n\t\t\t\t'" . $arr["user_id"] . "',\n\t\t\t\t'" . $arr["ip"] . "',\n\t\t\t\tNOW()\n\t\t\t);\n\t\t";
     arr($q1);
     //q($q1);
     $q2 = "\n\t\t\tSELECT\n\t\t\t\trank\n\t\t\tFROM\n\t\t\t\t" . $config_q["db"]["prefix"] . "quotes\n\t\t\tWHERE\n\t\t\t\tid = " . $this->quote_id;
     arr($q2);
     die;
     $r = q($q2);
     $row = mysqli_fetch_array($r, MYSQL_ASSOC);
     $current_rank = $row["rank"];
     $new_rank = $current_rank - 1;
     $q3 = "\n\t\t\tUPDATE\n\t\t\t\t" . $config_q["db"]["prefix"] . "quotes\n\t\t\tSET\n\t\t\t\trank = " . $new_rank . "\n\t\t\tWHERE\n\t\t\t\tid = " . $this->quote_id;
     q($q3);
     //echo "Vastuhääl antud!";
 }