Additions:
__Find the section with the following code__
__Replace the above code with the following code__
Deletions:
Find the section with the following code
---------------------------------------
Replace the above code with the following code
----------------------------------------------
No differences.
No differences.
Additions:
===__STEP 1__===
===__STEP 2__===
===__STEP 3__===
----
Deletions:
===STEP 1===
===STEP 2===
===STEP 3===
Additions:
===STEP 3===
Upload all the files you edited back into their respective places in your FTP.
Thats its, now every time a comment is posted, the owner of the video will now get an email notification
Additions:
Replace the above code with the following code
----------------------------------------------
($user_id, '$user_name', $vid, '$comments', NOW())";
//--------------------------V3 Tweek - Send email notification on comments--------------------------------
$sql1 = "SELECT * FROM videos WHERE indexer = $vid";
$result1 = mysql_query($sql1);
$results = mysql_fetch_array($result1);
$owner = $results['user_id'];
$sql = "SELECT email_address FROM member_profile WHERE user_id = $owner";
$result = @mysql_query($sql);
$results = mysql_fetch_array($result);
$owners_email = $results['email_address'];
$comment = strip_tags(html_entity_decode($postedValue[0]));
$video_url = $config["site_base_url"].'/videos/'.$vid.'/';
$from = $config["from_system_name"];
$from_email = $config["notifications_from_email"];
//Email details [you can change these 2 items]
$subject = 'You have a new video comment';
$message = "$video_url\n\n\n--------------------------------------------------------\n\n$comment";
@mail($owners_email,$subject,$message,"From: $from <$from_email>");
//----------------------------------------------------------------------------------------------------------
Additions:
($user_id, '$user_name', $vid, '$comments', NOW())";
Deletions:
($user_id, '$user_name', $vid, '$comments', NOW())";
Additions:
===STEP 1===
Download the following files from your FTP and save them anywhere on your computer
- **/comments.php**
===STEP 2===
Edit **comments.php**
%%
Find the section with the following code
---------------------------------------
$sql = "INSERT into videocomments (by_id, by_username, video_id, comments, todays_date) VALUES
($user_id, '$user_name', $vid, '$comments', NOW())";
mysql_query($sql);
%%
Additions:
[[http://phpmotion.com/forum/index.php/topic,14406.0.html Original Forum Post]]
Additions:
=== {{color text="Solution" c="blue"}} ===
Deletions:
=== Answer ===
Additions:
=== {{color text="Question Asked" c="blue"}} ===
Deletions:
=== Question Asked===
Additions:
[[http://wiki.phpmotion.com/V3Tweaks Back to V3Tweaks]]
Deletions:
[[http://wiki.phpmotion.com/HowTo Back to Tips & Tricks (HOW TO)]]
Deletions:
=====Captcha Images=====