1 |
560
|
Ruebenwurz
|
<?php
|
2 |
1375
|
FrankH
|
/**
|
3 |
|
|
*
|
4 |
|
|
* @category module
|
5 |
|
|
* @package Form
|
6 |
|
|
* @author WebsiteBaker Project
|
7 |
|
|
* @copyright 2004-2009, Ryan Djurovich
|
8 |
|
|
* @copyright 2009-2011, Website Baker Org. e.V.
|
9 |
|
|
* @link http://www.websitebaker2.org/
|
10 |
|
|
* @license http://www.gnu.org/licenses/gpl.html
|
11 |
|
|
* @platform WebsiteBaker 2.8.x
|
12 |
|
|
* @requirements PHP 5.2.2 and higher
|
13 |
|
|
* @version $Id$
|
14 |
1457
|
Luisehahne
|
* @filesource $HeadURL$
|
15 |
|
|
* @lastmodified $Date$
|
16 |
1375
|
FrankH
|
* @description
|
17 |
|
|
*/
|
18 |
560
|
Ruebenwurz
|
|
19 |
1375
|
FrankH
|
require('../../config.php');
|
20 |
560
|
Ruebenwurz
|
|
21 |
1375
|
FrankH
|
// Include WB admin wrapper script
|
22 |
|
|
require(WB_PATH.'/modules/admin.php');
|
23 |
1466
|
Luisehahne
|
/* */
|
24 |
1553
|
Luisehahne
|
|
25 |
560
|
Ruebenwurz
|
// Get id
|
26 |
1553
|
Luisehahne
|
$submission_id = intval($admin->checkIDKEY('submission_id', false, 'GET'));
|
27 |
1375
|
FrankH
|
if (!$submission_id) {
|
28 |
|
|
$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id);
|
29 |
560
|
Ruebenwurz
|
}
|
30 |
1466
|
Luisehahne
|
|
31 |
560
|
Ruebenwurz
|
// Get submission details
|
32 |
1553
|
Luisehahne
|
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'mod_form_submissions` ';
|
33 |
|
|
$sql .= 'WHERE submission_id = '.$submission_id.' ';
|
34 |
|
|
if($query_content = $database->query($sql)) {
|
35 |
|
|
$submission = $query_content->fetchRow(MYSQL_ASSOC);
|
36 |
|
|
}
|
37 |
560
|
Ruebenwurz
|
// Get the user details of whoever did this submission
|
38 |
1553
|
Luisehahne
|
$sql = 'SELECT `username`,`display_name` FROM `'.TABLE_PREFIX.'users` ';
|
39 |
|
|
$sql .= 'WHERE `user_id` = '.$submission['submitted_by'];
|
40 |
|
|
if($get_user = $database->query($sql)) {
|
41 |
|
|
if($get_user->numRows() != 0) {
|
42 |
|
|
$user = $get_user->fetchRow(MYSQL_ASSOC);
|
43 |
|
|
} else {
|
44 |
|
|
$user['display_name'] = 'Unknown';
|
45 |
|
|
$user['username'] = 'unknown';
|
46 |
|
|
}
|
47 |
560
|
Ruebenwurz
|
}
|
48 |
1553
|
Luisehahne
|
$sec_anchor = (defined( 'SEC_ANCHOR' ) && ( SEC_ANCHOR != '' ) ? '#'.SEC_ANCHOR.$section['section_id'] : '' );
|
49 |
560
|
Ruebenwurz
|
?>
|
50 |
1553
|
Luisehahne
|
<table class="frm-submission" summary="" cellpadding="0" cellspacing="0" border="0">
|
51 |
560
|
Ruebenwurz
|
<tr>
|
52 |
|
|
<td><?php echo $TEXT['SUBMISSION_ID']; ?>:</td>
|
53 |
|
|
<td><?php echo $submission['submission_id']; ?></td>
|
54 |
|
|
</tr>
|
55 |
|
|
<tr>
|
56 |
|
|
<td><?php echo $TEXT['SUBMITTED']; ?>:</td>
|
57 |
1582
|
Luisehahne
|
<td><?php echo gmdate(DATE_FORMAT .', '.TIME_FORMAT, $submission['submitted_when']+TIMEZONE); ?></td>
|
58 |
1553
|
Luisehahne
|
</tr>
|
59 |
560
|
Ruebenwurz
|
<tr>
|
60 |
|
|
<td><?php echo $TEXT['USER']; ?>:</td>
|
61 |
|
|
<td><?php echo $user['display_name'].' ('.$user['username'].')'; ?></td>
|
62 |
|
|
</tr>
|
63 |
|
|
<tr>
|
64 |
|
|
<td colspan="2">
|
65 |
|
|
<hr />
|
66 |
|
|
</td>
|
67 |
|
|
</tr>
|
68 |
|
|
<tr>
|
69 |
|
|
<td colspan="2">
|
70 |
|
|
<?php echo nl2br($submission['body']); ?>
|
71 |
|
|
</td>
|
72 |
|
|
</tr>
|
73 |
|
|
</table>
|
74 |
|
|
|
75 |
|
|
<br />
|
76 |
|
|
|
77 |
1553
|
Luisehahne
|
<input type="button" value="<?php echo $TEXT['CLOSE']; ?>" onclick="javascript: window.location = '<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id.$sec_anchor; ?>';" style="width: 150px; margin-top: 5px;" />
|
78 |
1375
|
FrankH
|
<input type="button" value="<?php echo $TEXT['DELETE']; ?>" onclick="javascript: confirm_link('<?php echo $TEXT['ARE_YOU_SURE']; ?>', '<?php echo WB_URL; ?>/modules/form/delete_submission.php?page_id=<?php echo $page_id; ?>§ion_id=<?php echo $section_id; ?>&submission_id=<?php echo $admin->getIDKEY($submission_id); ?>');" style="width: 150px; margin-top: 5px;" />
|
79 |
560
|
Ruebenwurz
|
<?php
|
80 |
|
|
|
81 |
|
|
// Print admin footer
|
82 |
|
|
$admin->print_footer();
|