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; ?>
$draw_username$verif_check"; ?>
   
no changes detected
"; echo "
$draw_name
"; echo "
"; echo "$draw_description"; echo "
"; } else { $string = $draw_name; require("../inc/replace.php"); echo "
$string
"; echo "
"; $string = $draw_description; require("../inc/replace.php"); echo "$string"; echo "
"; } ?>
No comments
"; } while($cmt_r = mysqli_fetch_assoc($cmt_q)) { $cmt_id = $cmt_r['id']; $cmt_uid = $cmt_r['uid']; $cmt_tstamp = $cmt_r['tstamp']; $string = $cmt_r['content']; // ************************ // // *** BLOCKING SYSTEM *** // // ************************ // $blks = mysqli_query($conx, "SELECT blocked_uid FROM blocking WHERE uid='$u_uid' && blocked_uid='$cmt_uid'"); $blkc = mysqli_num_rows($blks); if($blkc > 0) { $cmt_uid = "286"; } $blks = mysqli_query($conx, "SELECT blocked_uid FROM blocking WHERE blocked_uid='$u_uid' && uid='$cmt_uid'"); $blkc = mysqli_num_rows($blks); if($blkc > 0) { $cmt_uid = "286"; } // ************************ // // *** BLOCKING SYSTEM *** // // ************************ // include("../inc/replace.php"); $usr_q = mysqli_query($conx, "SELECT username,picture,online_time,md_verf FROM accounts WHERE uid='$cmt_uid'"); while($usr_r = mysqli_fetch_assoc($usr_q)) { $cmt_username = $usr_r['username']; $cmt_pic = $usr_r['picture']; $cmt_onltime = $usr_r['online_time']; $cmnt_vrf = $usr_r['md_verf']; if($cmnt_vrf == 'yes') { $verif_check = ""; } else { $verif_check = ""; } // // DATA SAVER if($u_datasaver == 'on') { $cmt_pic = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQAAAAA3bvkkAAAACklEQVR4AWNoAAAAggCBTBfX3wAAAABJRU5ErkJggg=="; } // DATA SAVER // $HUAHHH = time() - $cmt_onltime; $mens = round($HUAHHH / 60); if($mens <= 1) { $cv_activeness = "#00FF00"; } elseif($mens <= 2) { $cv_activeness = "#FFA500"; } elseif($mens < 5) { $cv_activeness = "#FF0000"; } else { $cv_activeness = "#FF0000"; } $usri_q = mysqli_query($conx, "SELECT username_color,text_color FROM user_theme_colors WHERE uid='$cmt_uid' && theme_id='$g_themeid'"); while($usri_r = mysqli_fetch_assoc($usri_q)) { $username_color = $usri_r['username_color']; $cmt_tcolor = $usri_r['text_color']; } } if($cmt_uid != '286') { echo ""; 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 "
"; } } ?>