コード例 #1
0
 public function getEntries($f_iLimit = 0, $f_szOrder = 'o ASC')
 {
     if (null === $this->_entries) {
         $es = AROGuestbookEntry::finder()->findMany('deleted = \'0\' AND ' . ($this->must_verify ? 'verified = \'1\' AND ' : '') . 'guestbook_implementation_id = ? ORDER BY ' . $f_szOrder . ', id ASC' . (0 < $f_iLimit ? ' LIMIT ' . $f_iLimit : ''), $this->implementation_id);
         if (0 < count($es)) {
             $es[0]->sequenceStart = true;
             $es[count($es) - 1]->sequenceEnd = true;
         }
         foreach ($es as $e) {
             $e->init($this);
         }
         $this->_entries = $es;
     }
     return $this->_entries;
 }
コード例 #2
0
ファイル: entries.php プロジェクト: rudiedirkx/CMS1
&sort=1">Sort</a></p>

<table id="sortable" border="2" cellpadding="3" cellspacing="0" bordercolor="white" width="700">
<thead>
<tr>
	<th>o</th>
	<th>Name</th>
	<th>E-mail</th>
	<th>Subject</th>
	<th>When</th>
	<th>Approved</th>
</tr>
</thead>
<tbody>
<?php 
$arrEntries = AROGuestbookEntry::finder()->findMany((empty($_GET['showdeleted']) ? "deleted = '0' AND " : '') . 'guestbook_implementation_id = ' . $objGuestbook->implementation_id . ' ORDER BY o ASC, id ASC');
foreach ($arrEntries as $e) {
    echo '<tr mid="' . $e->id . '"' . (empty($_GET['sort']) ? '' : ' bgcolor="#cccccc"') . '>';
    echo '	<td>' . $e->o . '</td>';
    echo '	<td>' . $e->name . '</td>';
    echo '	<td>' . $e->email . '</td>';
    echo '	<td>' . $e->subject . '</td>';
    echo '	<td><a href="edit_entry.php?id=' . $_GET['id'] . '&entry=' . $e->id . '">' . date('Y-m-d H:i:s', $e->utc) . '</td>';
    echo '	<td align="center">' . ($e->verified ? 'Y' : 'N') . '</td>';
    echo '	<td><a href="?id=' . $_GET['id'] . '&del=' . $e->id . '">x</a></td>';
    echo '</tr>';
}
?>
</tbody>
</table>
<?php 
コード例 #3
0
ファイル: edit_entry.php プロジェクト: rudiedirkx/CMS1
<?php

require_once 'cfg_admin.php';
logincheck();
$objGuestbook = AROImplementation::loadImplementationByID($_GET['id']);
$objEntry = AROGuestbookEntry::finder()->findOne('id = ? AND guestbook_implementation_id = ?', $_GET['entry'], $objGuestbook->implementation_id);
if (isset($_POST['name'], $_POST['email'], $_POST['website'], $_POST['subject'], $_POST['message'], $_POST['message_2'], $_POST['verified'])) {
    unset($_POST['id'], $_POST['o'], $_POST['deleted'], $_POST['ip'], $_POST['utc'], $_POST['guestbook_implementation_id']);
    $db->update('guestbook_entries', $_POST, 'id = ' . $objEntry->id);
    header('Location: entries.php?id=' . $_GET['id']);
    exit;
}
tpl_header();
echo '<h1>Editing entry in guestbook: ' . $objGuestbook->title . '</h1>';
?>
<form method="post" action="">

	<p><?php 
echo $objGuestbook->label_for_name;
?>
:<br /><input type="text" name="name" value="<?php 
echo $objEntry->name;
?>
" /></p>

	<p><?php 
echo $objGuestbook->label_for_email;
?>
:<br /><input type="text" name="email" value="<?php 
echo $objEntry->email;
?>