Naujokas

Reputacija:
0
Pranešimai: 8
Įstojo: 2010-06-13
|
Code
require_once \"../../maincore.php\";
require_once THEMES.\"templates/header.php\";
if (file_exists(INFUSIONS.\"suggestion_box/locale/\".$settings['locale'].\".php\")) {
include INFUSIONS.\"suggestion_box/locale/\".$settings['locale'].\".php\";
} else {
include INFUSIONS.\"suggestion_box/locale/English.php\";
}
error_reporting(E_ALL ^ E_NOTICE);
if (iMEMBER) {
if (!isset($step)) $step = \"\";
if (isset($_POST['submit_suggestion'])) {
$suggestion_summary = stripinput($_POST['suggestion_summary']);
$suggestion_version = stripinput($_POST['suggestion_version']);
$suggestion_description = stripinput($_POST['suggestion_description']);
if ($suggestion_summary != \"\" && $suggestion_description != \"\") {
$result = dbquery(\"INSERT INTO \".$db_prefix.\"suggestion_box VALUES('', '\".$userdata['user_id'].\"', '$suggestion_summary', '$suggestion_version', '$suggestion_description', '', '\".$locale['err142'].\"', '\".time().\"')\");
}
redirect(FUSION_SELF);
}
if ($step == \"view\") {
include INCLUDES.\"comments_include.php\";
if (!$suggestion_id || !isNum($suggestion_id)) redirect(FUSION_SELF);
opentable($locale['err110']);
$data = dbarray(dbquery(
\"SELECT ter.*, user_id,user_name FROM \".$db_prefix.\"suggestion_box ter
LEFT JOIN \".$db_prefix.\"users tusr ON ter.suggestion_user=tusr.user_id
WHERE suggestion_id='\".$suggestion_id.\"'\"
));
echo \"
\".$data['suggestion_summary'].\" |
\".$locale['err111'].\" |
\".$data['user_name'].\" -
\".strftime($settings['longdate'], $data['suggestion_datestamp']+($settings['timeoffset']*3600)).\" |
\".$locale['err112'].\" |
\".$data['suggestion_version'].\" |
\".$locale['err113'].\" |
\".nl2br($data['suggestion_description']).\" |
\n\";
if ($data['suggestion_response']) {
echo \"
\".$locale['err114'].\" |
\".nl2br($data['suggestion_response']).\" |
\n\";
}
echo \"
\".$locale['err115'].\" |
\".$data['suggestion_status'].\" |
\n\";
closetable();
showcomments(\"E\",\"\".$db_prefix.\"suggestion_box\",\"suggestion_id\",$suggestion_id,FUSION_SELF.\"?step=view&suggestion_id=$suggestion_id\",\"\");
tablebreak();
}
opentable($locale['err120']);
$result = dbquery(
\"SELECT ter.*, user_id,user_name, COUNT(comment_item_id) AS suggestion_comments
FROM \".$db_prefix.\"suggestion_box ter
LEFT JOIN \".$db_prefix.\"users tusr ON ter.suggestion_user=tusr.user_id
LEFT JOIN \".$db_prefix.\"comments ON ter.suggestion_id=comment_item_id AND comment_type='E'
GROUP BY suggestion_id ORDER BY suggestion_datestamp DESC\"
);
if (dbrows($result)) {
$i = 0;
echo \"\n\";
} else {
echo \" \n\".$locale['err123'].\"
\n\n\";
}
closetable();
tablebreak();
opentable($locale['err130']);
echo \"
Copyright © 2025 phpfusion.lt
|