0) { $draw_uid = "286"; } $blks = mysqli_query($conx, "SELECT blocked_uid FROM blocking WHERE blocked_uid='$u_uid' && uid='$draw_uid'"); $blkc = mysqli_num_rows($blks); if($blkc > 0) { $draw_uid = "286"; } if($draw_uid == '286') { die(""); } // ************************ // // *** BLOCKING SYSTEM *** // // ************************ // $draw_donations = "$".$draw_donations; $drwq = mysqli_query($conx, "SELECT username,md_verf FROM accounts WHERE uid='$draw_uid'"); $drwr = mysqli_fetch_assoc($drwq); $draw_username = $drwr['username']; $draw_vrf = $drwr['md_verf']; if($draw_vrf == 'yes') { $verif_check = " "; } else { $verif_check = ""; } if($draw_collections == 'no' && $u_uid != $draw_uid) { header("location: /draw"); exit(); } # GET LIKE COUNT $cntq = mysqli_query($conx, "SELECT id FROM draw_likes WHERE draw_id='$draw_id'"); $like_count = mysqli_num_rows($cntq); if($like_count != '1') { $like_s_or_nah = "s"; } else { $like_s_or_nah = ""; } # HAVE THEY LIKED IT $hasl = mysqli_query($conx, "SELECT id FROM draw_likes WHERE draw_id='$draw_id' && uid='$u_uid'"); $hasr = mysqli_fetch_assoc($hasl); $has_liked = mysqli_num_rows($hasl); if($has_liked == '0') { $like_act = "like"; } else { $like_act = "unlike"; } # GET DISLIKE COUNT $cntq = mysqli_query($conx, "SELECT id FROM draw_dislikes WHERE draw_id='$draw_id'"); $dislike_count = mysqli_num_rows($cntq); if($dislike_count != '1') { $dislike_s_or_nah = "s"; } else { $dislike_s_or_nah = ""; } # HAVE THEY DISLIKED IT $hasl = mysqli_query($conx, "SELECT id FROM draw_dislikes WHERE draw_id='$draw_id' && uid='$u_uid'"); $hasr = mysqli_fetch_assoc($hasl); $has_disliked = mysqli_num_rows($hasl); if($has_disliked == '0') { $dislike_act = "dislike"; } else { $dislike_act = "undislike"; } # LIKE vs. DISLIKE battle $total_both = $dislike_count + $like_count; $like_perc = ($like_count / $total_both) * 100; $dislike_perc = ($dislike_count / $total_both) * 100; ?>
|
| ";
echo "$cmt_username $verif_check";
echo " • ";
echo timeago($cmt_tstamp);
echo " ago ";
if($cmt_uid == $u_uid) {
echo "";
}
echo " "; echo bbc(atname(nl2br($string))); echo ""; echo " |