Toledoh
Enthusiast
Mar 3, 2010, 6:45 PM
Post #1 of 2
(3385 views)
Shortcut
|
|
Generic Comments code.
|
Can't Post
|
|
Hi All.
The following code seems to be working well enough for me. Maybe someone out there with a bit better understanding of things could turn it into a plugin? I've got it working with the membership plugin so only members can post comments... but you can easily remove this if you wish.
Step 1: Create a multi-record section called "Comments" with the fields:
- content: text box
- rel_module: text field
- rel_item: text field
- author: text field
Step 2: Add the following code to the top of the Details Page. (I actually have this code in a separate php file, which I insert via php insert)
<?php
header('Content-type: text/html; charset=utf-8'); ?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
require_once "WHATEVER/lib/viewer_functions.php";
list($a_text_snippetsRecords, $a_text_snippetsMetaData) = getRecords(array(
'tableName' => 'a_text_snippets',
));
list($commentsRecords, $commentsMetaData) = getRecords(array(
'tableName' => 'comments',
));
?>
<?php
require_once "WHATEVER/lib/viewer_functions.php";
// submit form
if (@$_REQUEST['submit']) {
// error checking
$errorsAndAlerts = "";
if (!@$_REQUEST['content']) { $errorsAndAlerts .= "Please write a comment!<br/>\n"; }
// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}comments` SET
content = '".mysql_real_escape_string( $_REQUEST['content'] )."',
rel_item = '".mysql_real_escape_string( $_REQUEST['rel_item'] )."',
rel_module = '".mysql_real_escape_string( $_REQUEST['rel_module'] )."',
author = '".mysql_real_escape_string( $_REQUEST['author'] )."',
createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:<br/>\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();
// display thanks message and clear form
$errorsAndAlerts = "Thanks! Your comment has been added below.";
$_REQUEST = array();
}
}
?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
require_once "WHATEVER/lib/viewer_functions.php";
list($commentsRecords, $commentsMetaData) = getRecords(array(
'tableName' => 'comments',
));
?>
Step 3: Add the following code to your Details Page. changing "e_blog" to whatever section you are workign with.
<?php $item = $e_blogRecord['num'] ?>
<?php $table = 'e_blog' ?>
Step 4: Insert the following code where you want the comments to be displayed. (must follow step 3, and again, I use a php include).
<h2>Comments</h2>
<div id="sectionPanelHighlight">
<?php if (!$CURRENT_USER): ?><p>Please <a href="signup.php">register</a> to add your comments</p><?php endif ?>
<?php if ($CURRENT_USER): ?><p>
<form method="post" action="">
<input type="hidden" name="submit" value="1" />
<input type="hidden" name="rel_module" value="<?php echo $table ?>">
<input type="hidden" name="rel_item" value="<?php echo $item ?>">
<input type="hidden" name="author" value="<?php echo $CURRENT_USER['username'] ?>">
<?php if (@$errorsAndAlerts): ?>
<div id="noticeDisplay">
<?php echo $errorsAndAlerts; ?>
</div>
<?php endif ?>
<textarea name="content" rows="4" class="help"><?php echo htmlspecialchars(@$_REQUEST['content']) ?></textarea><br />
<input name="add" type="submit" class="searchbutton" value="Add Record >>" />
</form>
</p><?php endif ?>
</div>
<div id="commentsList">
<?php foreach ($commentsRecords as $record): ?>
<?php if ($record['rel_item'] == $item && $record['rel_module'] == $table): ?>
<?php echo $record['content'] ?><br/><?php echo $record['author'] ?> - <?php echo $record['createdDate'] ?>
<hr/>
<?php endif; ?>
<?php endforeach ?>
</div>
Tim Forrest
Toledoh Enterprises
www.toledoh.com.au
(This post was edited by Toledoh on Mar 3, 2010, 6:49 PM)
|
