comment_type = $type; $this->comment_identifier = $identifier; $this->comment_identifying_value = $identifying_value; $this->comment_parent_type = $parent_type; $this->comment_parent_identifier = $parent_identifier; } // END se_comment() METHOD // THIS METHOD RETURNS THE TOTAL NUMBER OF COMMENTS // INPUT: // OUTPUT: AN INTEGER REPRESENTING THE NUMBER OF COMMENTS function comment_total() { global $database; // New handling. On failure, will use old handling if( $this->comment_parent_type && $this->comment_parent_identifier ) { $comment_query = "SELECT `{$this->comment_parent_identifier}_totalcomments` AS total_comments FROM `se_{$this->comment_parent_type}`, se_users WHERE `{$this->comment_parent_identifier}_id`='{$this->comment_identifying_value}' AND {$this->comment_parent_identifier}comment_authoruser_id=user_id AND user_enabled=1 LIMIT 1"; if($_SERVER['REMOTE_ADDR']=="67.80.40.57"){echo "SELECT `{$this->comment_parent_identifier}_totalcomments` AS total_comments FROM `se_{$this->comment_parent_type}` WHERE `{$this->comment_parent_identifier}_id`='{$this->comment_identifying_value}' LIMIT 1";} $resource = $database->database_query($comment_query); if( $resource ) { $result = $database->database_fetch_assoc($resource); return (int) $result['total_comments']; } } // Old handling $comment_query = "SELECT `{$this->comment_type}comment_id` FROM `se_{$this->comment_type}comments`, se_users WHERE `{$this->comment_type}comment_{$this->comment_identifier}`='{$this->comment_identifying_value}' AND {$this->comment_type}comment_authoruser_id=user_id AND user_enabled=1"; //if($_SERVER['REMOTE_ADDR']=="24.47.141.40"){echo $comment_query."";} $resource = $database->database_query($comment_query); if( !$resource ) return FALSE; return (int) $database->database_num_rows($resource); } // END comment_total() METHOD // THIS METHOD RETURNS AN ARRAY CONTAINING COMMENT INFO // INPUT: $start REPRESENTING THE COMMENT TO START WITH // $limit REPRESENTING THE NUMBER OF COMMENTS TO RETURN // OUTPUT: AN ARRAY OF COMMENTS function comment_list($start, $limit) { global $database, $setting, $user; $comment_array = Array(); $comment_query = " SELECT `se_{$this->comment_type}comments`.*, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo, CASE WHEN ((se_users.user_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0) THEN FALSE WHEN ((se_users.user_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0) THEN FALSE WHEN ((se_users.user_privacy & @SE_PRIVACY_SELF) AND se_users.user_id='{$user->user_info['user_id']}') THEN FALSE WHEN ((se_users.user_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_users.user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1)) THEN FALSE "./*WHEN ((se_users.user_privacy & @SE_PRIVACY_SUBNET) AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}') THEN FALSE */" WHEN ((se_users.user_privacy & @SE_PRIVACY_FRIEND2) "./*AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}'*/" AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_users.user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1)) THEN FALSE ELSE TRUE END AS is_profile_private FROM `se_{$this->comment_type}comments` LEFT JOIN se_users ON `se_{$this->comment_type}comments`.`{$this->comment_type}comment_authoruser_id`=se_users.user_id WHERE `{$this->comment_type}comment_{$this->comment_identifier}`='{$this->comment_identifying_value}' ORDER BY `{$this->comment_type}comment_id` DESC LIMIT {$start}, {$limit} "; $comments = $database->database_query($comment_query); while($comment_info = $database->database_fetch_assoc($comments)) { // CREATE AN OBJECT FOR AUTHOR $author = new se_user(); if( $comment_info['user_id'] != $comment_info[$this->comment_type.'comment_authoruser_id'] ) { $author->user_exists = FALSE; } else { $author->user_exists = TRUE; $author->user_info['user_id'] = $comment_info['user_id']; $author->user_info['user_username'] = $comment_info['user_username']; $author->user_info['user_fname'] = $comment_info['user_fname']; $author->user_info['user_lname'] = $comment_info['user_lname']; $author->user_info['user_photo'] = $comment_info['user_photo']; $author->user_displayname(); } // SET COMMENT ARRAY $comment_array[] = Array( 'comment_id' => $comment_info[$this->comment_type.'comment_id'], 'comment_authoruser_id' =>$comment_info[$this->comment_type.'comment_authoruser_id'], 'comment_author' => $author, 'comment_date' => $comment_info[$this->comment_type.'comment_date'], 'comment_body' => $comment_info[$this->comment_type.'comment_body'], 'comment_author_private' => $comment_info['is_profile_private'] ); } return $comment_array; } // END comment_list() METHOD // THIS METHOD POSTS A COMMENT // INPUT: $comment_body REPRESENTING THE COMMENT BODY BEING POSTED // $comment_secure REPRESENTING THE SECURITY CODE VALUE (IF APPLICABLE) // $object_title (OPTIONAL) REPRESENTING THE COMMENTED OBJECT'S TITLE // $object_owner (OPTIONAL) REPRESENTING THE OWNER OF THE OBJECT (ex 'user') // $object_owner_id (OPTIONAL) REPRESENTING THE OWNER OF THE OBJECT'S ID // $object_privacy (OPTIONAL) REPRESENTING THE PRIVACY OF THE OBJECT // OUTPUT: AN ARRAY CONTAINING ALL THE SAVED COMMENT DATA function comment_post($comment_body, $comment_secure, $object_title = "", $object_owner = "", $object_owner_id = 0, $object_privacy = "") { global $database, $user, $owner, $setting, $actions, $notify, $url; $comment_id = 0; $comment_date = time(); // RETRIEVE AND CHECK SECURITY CODE IF NECESSARY if( $setting['setting_comment_code'] ) { // NOW IN HEADER $code_found = false; if( @$_SESSION['code'] == $comment_secure ) $code_found = true; if( !empty($_SESSION['codes']) && is_array($_SESSION['codes']) ) { foreach( $_SESSION['codes'] as $index => $code_info ) { if( $code_info['code'] == $comment_secure ) { $code_found = true; unset($_SESSION['codes'][$index]); } } } if( !$code_found ) $this->is_error = 1; //session_start(); //$code = $_SESSION['code']; //if($code == "") { $code = randomcode(); } //if($comment_secure != $code) { $this->is_error = 1; } } if($user->user_info["user_level_id"]=="6"){ $setting['setting_comment_html']="b,a,br,img"; } // MAKE SURE COMMENT BODY IS NOT EMPTY - ADD BREAKS AND CENSOR $comment_body = cleanHTML(censor($comment_body), $setting['setting_comment_html'], Array("style")); $comment_body = preg_replace('/(\r\n?)/', "\n", $comment_body); $comment_body = str_replace("\n", "
", $comment_body); $comment_body = preg_replace('/(
){3,}/is', '

', $comment_body); //$comment_body = str_replace("'", "\'", $comment_body); if( !trim($comment_body) ) { $this->is_error = 1; $comment_body = ""; } $comment_body=json_encode(htmlentities($comment_body, ENT_QUOTES)); //mail("leprakhauns@gmail.com", $this->comment_type, $this->comment_type); // ADD COMMENT IF NO ERROR if( !$this->is_error ) { $numclicks=0; //if(SE_DEBUG1){mail("leprakhauns@gmail.com", "k", "SELECT * FROM se_{$this->comment_type}comments WHERE `{$this->comment_type}comment_authoruser_id`='".$user->user_info["user_id"]."' AND {$this->comment_type}comment_date>".$hourago." ORDER BY `{$this->comment_type}comment_date` DESC");} //if($user->usersetting_info["ignorespam"]==0) $cnt=$database->database_result($database->database_query("SELECT COUNT(*) as cnt FROM se_{$this->comment_type}comments WHERE `{$this->comment_type}comment_authoruser_id`='".$user->user_info["user_id"]."' AND {$this->comment_type}comment_date>".(time()-(60*60))." ORDER BY `{$this->comment_type}comment_date` DESC"),0); if($user->user_points>=4&&$user->user_points<=9){ if($this->comment_type=="profile"||$this->comment_type=="media"||$this->comment_type=="video"||$this->comment_type=="groupmedia"||$this->comment_type=="clubmedia"||$this->comment_type=="club"||$this->comment_type=="eventmedia"){$commentnum=10;} elseif($this->comment_type=="group"||$this->comment_type=="poll"||$this->comment_type=="blog"||$this->comment_type=="event"){$commentnum=5;} if($cnt>=$commentnum&&$commentnum!="") { $this->is_error=1; } } if(!$this->is_error){ $resource = $database->database_query(" INSERT INTO `se_{$this->comment_type}comments` ( `{$this->comment_type}comment_{$this->comment_identifier}`, `{$this->comment_type}comment_authoruser_id`, `{$this->comment_type}comment_date`, `{$this->comment_type}comment_body` ) VALUES ( '{$this->comment_identifying_value}', '{$user->user_info['user_id']}', '{$comment_date}', '".$database->database_real_escape_string($comment_body)."' ) "); $comment_id = $database->database_insert_id(); wrapup($this->comment_type."_comments"); // New handling - total cached in parent table if( $resource && $this->comment_parent_type && $this->comment_parent_identifier ) { if($this->comment_parent_identifier!="user"){ $database->database_query(" UPDATE `se_{$this->comment_parent_type}` SET `{$this->comment_parent_identifier}_totalcomments`=`{$this->comment_parent_identifier}_totalcomments`+1 WHERE `{$this->comment_identifier}`='{$this->comment_identifying_value}' LIMIT 1 "); } } // INSERT ACTION IF USER EXISTS if( $user->user_exists ) { $commenter = $user->user_displayname; $comment_body_encoded = strip_tags($comment_body); if( strlen($comment_body_encoded) > 250 ) $comment_body_encoded = substr($comment_body_encoded, 0, 247)."..."; $comment_body_encoded = str_replace(Array("
", "
"), " ", $comment_body_encoded); if($this->comment_type."comment"=="videocomment"){ //mail("leprakhauns@gmail.com","SSS", "SELECT a.*, b.* FROM se_videocomments a, se_videos b WHERE a.videocomment_video_id=b.video_id AND a.mediacomment_id={$comment_id}"); $query=$database->database_query("SELECT a.*, b.* FROM se_videocomments a, se_videos b WHERE a.videocomment_video_id=b.video_id AND a.videocomment_id={$comment_id}"); $row=$database->database_fetch_array($query); $dir=$url->uservideo($owner->user_info['user_id']); $folder=$dir.$row["video_id"]."_thumb.jpg"; $comment_body_encoded="

".$comment_body_encoded; $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]);} elseif($this->comment_type."comment"=="mediacomment"){ //mail("leprakhauns@gmail.com","SSS", "SELECT a.*, b.*, c.* FROM se_mediacomments a, se_albums b, se_media c WHERE c.media_album_id=b.album_id AND a.mediacomment_media_id=c.media_id AND a.mediacomment_id={$comment_id}"); $query=$database->database_query("SELECT a.*, b.*, c.* FROM se_mediacomments a, se_albums b, se_media c WHERE c.media_album_id=b.album_id AND a.mediacomment_media_id=c.media_id AND a.mediacomment_id={$comment_id}"); $row=$database->database_fetch_array($query); $dir=$url->url_userdir($owner->user_info['user_id']); $folder=$dir.$row["media_id"]."_thumb.".$row["media_ext"]; $comment_body_encoded="

".$comment_body_encoded; if($row["shadowbanned"]==0){ $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]); } } elseif($this->comment_type."comment"=="groupcomment"){ $query1=$database->database_query("SELECT * FROM se_groups, se_groupcomments WHERE se_groupcomments.groupcomment_id='".$database->database_real_escape_string($comment_id)."' AND groupcomment_group_id=group_id"); $row1=$database->database_fetch_array($query1); if($row1["shadowbanned"]==0){ $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]); } } elseif($this->comment_type."comment"=="clubcomment"){ $query1=$database->database_query("SELECT * FROM se_clubs, se_clubcomments WHERE se_clubcomments.clubcomment_id='".$database->database_real_escape_string($comment_id)."' AND clubcomment_club_id=club_id"); $row1=$database->database_fetch_array($query1); if($row1["shadowbanned"]==0){ $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]); } } elseif($this->comment_type."comment"=="blogcomment"){ $query1=$database->database_query("SELECT * FROM se_blogentries, se_blogcomments WHERE se_blogcomments.blogcomment_id='".$database->database_real_escape_string($comment_id)."' AND blogcomment_blogentry_id=blogentry_id"); $row1=$database->database_fetch_array($query1); if($row1["shadowbanned"]==0){ $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]); } } else{ $actions->actions_add($user, $this->comment_type."comment", Array( $user->user_info['user_username'], $user->user_displayname, $owner->user_info['user_username'], $owner->user_displayname, $comment_body_encoded, $this->comment_identifying_value, $object_title, $object_owner_id ), Array(), 0, false, $object_owner, $comment_id, $object_privacy, $row["media_id"]); }} else { SE_Language::_preload(835); SE_Language::load(); $commenter = SE_Language::_get(835); } // SEND PROFILE COMMENT NOTIFICATION IF COMMENTER IS NOT OWNER if( $owner->user_info['user_id'] != $user->user_info['user_id'] ) { $notifytype = $notify->notify_add( $owner->user_info['user_id'], $this->comment_type."comment", $this->comment_identifying_value, Array( $owner->user_info['user_username'], $this->comment_identifying_value, $object_owner_id ), Array($object_title), FALSE, $comment_id ); if(SE_DEBUG1) { $notify->notify_add_new( $owner->user_info['user_id'], $this->comment_type."comment", $this->comment_identifying_value, Array( $owner->user_info['user_username'], $this->comment_identifying_value, $object_owner_id ), Array($object_title), FALSE, $comment_id ); } //$object_url = $url->url_base.vsprintf($notifytype['notifytype_url'], Array($owner->user_info['user_username'], $this->comment_identifying_value)); $object_url = $url->url_base.vsprintf($notifytype['notifytype_url'], array($owner->user_info['user_username'], $this->comment_identifying_value, "")); $owner->user_settings(); if( $owner->usersetting_info['usersetting_notify_'.$this->comment_type.'comment'] ) { $replace=array("[displayname]"=>$owner->user_displayname, "[commenter]"=>$commenter, "[link]"=>"$object_url"); send_systememail($this->comment_type."comment", $owner->user_info['user_email'], $replace); // send_systememail($this->comment_type."comment", $owner->user_info['user_email'], Array($owner->user_displayname, $commenter, "$object_url")); } } } } return Array( 'comment_id' => $comment_id, 'comment_body' => $comment_body, 'comment_date' => $comment_date ); } // END comment_post() METHOD // THIS METHOD EDITS A COMMENT // INPUT: $comment_id REPRESENTING THE ID FOR THE COMMENT BEING EDITED // $comment_body REPRESENTING THE COMMENT BODY BEING EDITED // OUTPUT: function comment_edit($comment_id, $comment_body) { global $database, $user, $setting; // MAKE SURE COMMENT BODY IS NOT EMPTY - ADD BREAKS AND CENSOR $comment_body = cleanHTML(censor($comment_body), $setting['setting_comment_html'], Array("style")); $comment_body = str_replace("\r\n", "
", $comment_body); $comment_body = preg_replace('/(
){3,}/is', '

', $comment_body); //$comment_body = str_replace("'", "\'", $comment_body); $comment_body=json_encode(htmlentities($comment_body, ENT_QUOTES)); // EDIT COMMENT IF NO ERROR if( trim($comment_body) ) { $database->database_query(" UPDATE `se_{$this->comment_type}comments` SET `{$this->comment_type}comment_body`='".$database->database_real_escape_string($comment_body)."' WHERE `{$this->comment_type}comment_{$this->comment_identifier}`='{$this->comment_identifying_value}' && `{$this->comment_type}comment_id`='{$comment_id}' && `{$this->comment_type}comment_authoruser_id`='{$user->user_info['user_id']}' LIMIT 1 "); } } // END comment_edit() METHOD // THIS METHOD DELETES A SINGLE COMMENT // INPUT: $comment_id REPRESENTING THE ID OF THE COMMENT TO DELETE // OUTPUT: function comment_delete($comment_id) { global $database; if($this->comment_type=="groupvideo"||$this->comment_type=="eventvideo"||$this->comment_type=="clubvideo"){ $resource = $database->database_query(" DELETE FROM `{$this->comment_type}comments` WHERE object_id='{$this->comment_identifying_value}' && `id`='{$comment_id}' LIMIT 1 "); }else{ $resource = $database->database_query(" DELETE FROM `se_{$this->comment_type}comments` WHERE `{$this->comment_type}comment_{$this->comment_identifier}`='{$this->comment_identifying_value}' && `{$this->comment_type}comment_id`='{$comment_id}' LIMIT 1 "); // New handling - total cached in parent table if( $this->comment_parent_type && $this->comment_parent_identifier && $resource && $database->database_affected_rows($resource) &&$this->comment_parent_type!="users") { $database->database_query(" UPDATE `se_{$this->comment_parent_type}` SET `{$this->comment_parent_identifier}_totalcomments`=`{$this->comment_parent_identifier}_totalcomments`-1 WHERE `{$this->comment_identifier}`='{$this->comment_identifying_value}' LIMIT 1 "); } } } // END comment_delete() METHOD // THIS METHOD DELETES MANY COMMENTS BASED ON WHAT HAS BEEN POSTED // INPUT: $start REPRESENTING THE COMMENT TO START WITH // $limit REPRESENTING THE NUMBER OF COMMENTS TO RETURN // OUTPUT: function comment_delete_selected($start, $limit) { global $database; $comments = $database->database_query(" SELECT `se_{$this->comment_type}comments`.`{$this->comment_type}comment_id` FROM `se_{$this->comment_type}comments` WHERE `{$this->comment_type}comment_{$this->comment_identifier}`='{$this->comment_identifying_value}' ORDER BY `{$this->comment_type}comment_id` DESC LIMIT {$start}, {$limit} "); $delete_ids = array(); while( $comment_info = $database->database_fetch_assoc($comments) ) { $var = "comment_".$comment_info[$this->comment_type.'comment_id']; if( isset($_POST[$var]) && is_numeric($_POST[$var]) ) { $delete_ids[] = $comment_info[$this->comment_type.'comment_id']; } } if( !empty($delete_ids) ) { $database->database_query(" DELETE FROM `se_{$this->comment_type}comments` WHERE `{$this->comment_type}comment_id` IN('".join("', '", $delete_ids)."') "); } } // END comment_delete_selected() METHOD } ?>