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!"; }