Witam pomoże mi ktoś dodać nowe pole do PA->FAQ miało by ono wyglądać tak:
Zaznaczone na czerwono.
Następnie to co wpiszemy w tym nowym polu ma się wyświetlać na stronie faq.php
Obrazek:
Proszę o pomoc nawet o małe wskazówki co po kolei robić wiem że będę musiał dodać nowe pole do bazy danych to nie problem. Ale problem zaczyna się przy edycji pliku faq.php
Czyli tu gdzie ma się wyświetlać wiadomość.
Wiadomość doklejona:
Zrobiłem te pole w PA->FAQ to jest plik administarion\faq.php Ale coś jak kliknę zapisz nic się nie dzieje mógłby ktoś luknąć fachowym okiem co jest nie tak bardzo proszę :)
Kod:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: faq.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
require_once THEMES."templates/admin_header.php";
require_once INCLUDES."html_buttons_include.php";
include LOCALE.LOCALESET."admin/faq.php";
if (!checkrights("FQ") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect("../index.php"); }
if (isset($_GET['status']) && !isset($message)) {
if ($_GET['status'] == "scn") {
$message = $locale['410'];
} elseif ($_GET['status'] == "scu") {
$message = $locale['411'];
} elseif ($_GET['status'] == "delcn") {
$message = $locale['412']."<br />\n<span class='small'>".$locale['413']."</span>";
} elseif ($_GET['status'] == "delcy") {
$message = $locale['414'];
} elseif ($_GET['status'] == "sn") {
$message = $locale['510'];
} elseif ($_GET['status'] == "su") {
$message = $locale['511'];
} elseif ($_GET['status'] == "del") {
$message = $locale['512'];
}
if ($message) { echo "<div class='admin-message'>".$message."</div>\n"; }
}
if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['faq_cat_id']) && isnum($_GET['faq_cat_id'])) && (isset($_GET['t']) && $_GET['t'] == "cat")) {
$result = dbquery("SELECT * FROM ".DB_FAQS." WHERE faq_cat_id='".$_GET['faq_cat_id']."'");
if (dbrows($result) != 0) {
redirect(FUSION_SELF.$aidlink."&status=delcn");
} else {
$result = dbquery("DELETE FROM ".DB_FAQ_CATS." WHERE faq_cat_id='".$_GET['faq_cat_id']."'");
redirect(FUSION_SELF.$aidlink."&status=delcy");
}
} elseif ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['faq_id']) && isnum($_GET['faq_id'])) && (isset($_GET['t']) && $_GET['t'] == "faq")) {
$faq_count = dbcount("(faq_id)", DB_FAQS, "faq_id='".$_GET['faq_id']."'");
$result = dbquery("DELETE FROM ".DB_FAQS." WHERE faq_id='".$_GET['faq_id']."'");
if ($faq_count) {
redirect(FUSION_SELF.$aidlink."&faq_cat_id=".intval($_GET['faq_cat_id'])."&status=del");
} else {
redirect(FUSION_SELF.$aidlink."&status=del");
}
}
elseif (isset($_POST['save_opis'])) {
$faq_opis_title = stripinput($_POST['$faq_opis_title']);
$faq_opis = stripinput($_POST['faq_opis']);
}
elseif (isset($_POST['save_cat'])) {
$faq_cat_name = stripinput($_POST['faq_cat_name']);
$faq_cat_description = stripinput($_POST['faq_cat_description']);
if ($faq_cat_name) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['faq_cat_id']) && isnum($_GET['faq_cat_id'])) && (isset($_GET['t']) && $_GET['t'] == "cat")) {
$result = dbquery("UPDATE ".DB_FAQ_CATS." SET faq_cat_name='$faq_cat_name', faq_cat_description='$faq_cat_description' WHERE faq_cat_id='".$_GET['faq_cat_id']."'");
redirect(FUSION_SELF.$aidlink."&status=scu");
} else {
$result = dbquery("INSERT INTO ".DB_FAQ_CATS." (faq_cat_name, faq_cat_description) VALUES('$faq_cat_name', '$faq_cat_description')");
redirect(FUSION_SELF.$aidlink."&status=scn");
}
} else {
redirect(FUSION_SELF.$aidlink);
}
} elseif (isset($_POST['save_faq'])) {
$faq_cat = intval($_POST['faq_cat']);
$faq_question = stripinput($_POST['faq_question']);
$faq_answer = addslash($_POST['faq_answer']);
if ($faq_question && $faq_answer) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['faq_id']) && isnum($_GET['faq_id'])) && (isset($_GET['t']) && $_GET['t'] == "faq")) {
$result = dbquery("UPDATE ".DB_FAQS." SET faq_cat_id='$faq_cat', faq_question='$faq_question', faq_answer='$faq_answer' WHERE faq_id='".$_GET['faq_id']."'");
redirect(FUSION_SELF.$aidlink."&faq_cat_id=$faq_cat&status=su");
} else {
$result = dbquery("INSERT INTO ".DB_FAQS." (faq_cat_id, faq_question, faq_answer) VALUES ('$faq_cat', '$faq_question', '$faq_answer')");
redirect(FUSION_SELF.$aidlink."&faq_cat_id=$faq_cat&status=sn");
}
} else {
redirect(FUSION_SELF.$aidlink);
}
} elseif (isset($_GET['action']) && $_GET['action'] == "edit") {
if ((isset($_GET['faq_cat_id']) && isnum($_GET['faq_cat_id'])) && (isset($_GET['t']) && $_GET['t'] == "cat")) {
$result = dbquery("SELECT * FROM ".DB_FAQ_CATS." WHERE faq_cat_id='".$_GET['faq_cat_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$faq_cat_id = $data['faq_cat_id'];
$faq_cat_name = $data['faq_cat_name'];
$faq_cat_description = $data['faq_cat_description'];
$faq_cat_title = $locale['401'];
$faq_cat_action = FUSION_SELF.$aidlink."&action=edit&faq_cat_id=".$data['faq_cat_id']."&t=cat";
// --------------------- //
$faq_question = "";
$faq_answer = "";
$faq_title = $locale['400'];
$faq_action = FUSION_SELF.$aidlink;
} else {
redirect(FUSION_SELF.$aidlink);
}
} elseif ((isset($_GET['faq_id']) && isnum($_GET['faq_id'])) && (isset($_GET['t']) && $_GET['t'] == "faq")) {
$result = dbquery("SELECT * FROM ".DB_FAQS." WHERE faq_id='".$_GET['faq_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$faq_cat_name = "";
$faq_cat_description = "";
$faq_cat_title = $locale['420'];
$faq_cat_action = FUSION_SELF.$aidlink;
// --------------------- //
$faq_id = $data['faq_id'];
$faq_question = $data['faq_question'];
$faq_answer = stripslashes($data['faq_answer']);
$faq_title = $locale['501'];
$faq_action = FUSION_SELF.$aidlink."&action=edit&faq_id=".$data['faq_id']."&t=faq";
} else {
redirect(FUSION_SELF.$aidlink);
}
}
} else {
$faq_cat_name = "";
$faq_cat_description = "";
$faq_cat_title = $locale['400'];
$faq_cat_action = FUSION_SELF.$aidlink;
$faq_question = "";
$faq_answer = "";
$faq_title = $locale['500'];
$faq_action = FUSION_SELF.$aidlink;
$faq_opis_title = $locale['402'];
$faq_opis = "";
}
opentable($faq_opis_title);
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td valign='top' class='tbl'>".$locale['403']."</td>\n";
echo "<td class='tbl'><textarea name='faq_opis' cols='60' rows='5' class='textbox' style='width:330px;'>".phpentities(stripslashes($faq_opis))."</textarea></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo display_html("inputform", "faq_opis")."</td>\n";
echo "</tr>\n<tr>\n";
echo "<td align='center' colspan='2' class='tbl'><br />\n";
echo "<input type='submit' name='save_opis' value='".$locale['523']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
if (!isset($_GET['t']) || $_GET['t'] != "faq") {
opentable($faq_cat_title);
echo "<form name='add_faq_cat' method='post' action='".$faq_cat_action."'>\n";
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td class='tbl'>".$locale['420']."</td>\n";
echo "<td class='tbl'><input type='text' name='faq_cat_name' value='".$faq_cat_name."' class='textbox' style='width:210px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='130' class='tbl'>".$locale['421']."</td>\n";
echo "<td class='tbl'><input type='text' name='faq_cat_description' value='".$faq_cat_description."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td align='center' colspan='2' class='tbl'><input type='submit' name='save_cat' value='".$locale['422']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
}
if (!isset($_GET['t']) || $_GET['t'] != "cat") {
$cat_opts = ""; $sel = "";
$result2 = dbquery("SELECT * FROM ".DB_FAQ_CATS." ORDER BY faq_cat_name");
if (dbrows($result2) != 0) {
while ($data2 = dbarray($result2)) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['faq_cat_id']) && isnum($_GET['faq_cat_id'])) && $_GET['t'] == "faq") { $sel = ($data2['faq_cat_id'] == $_GET['faq_cat_id'] ? " selected" : ""); }
$cat_opts .= "<option value='".$data2['faq_cat_id']."'$sel>".$data2['faq_cat_name']."</option>\n";
}
opentable($faq_title);
echo "<form name='inputform' method='post' action='".$faq_action."'>\n";
echo "<table cellpadding='0' cellspacing='0' class='center'>\n<tr>\n";
echo "<td class='tbl'>".$locale['520']."</td>\n";
echo "<td class='tbl'><select name='faq_cat' class='textbox' style='width:250px;'>\n".$cat_opts."</select></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'>".$locale['521']."</td>\n";
echo "<td class='tbl'><input type='text' name='faq_question' value='".$faq_question."' class='textbox' style='width:330px' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td valign='top' class='tbl'>".$locale['522']."</td>\n";
echo "<td class='tbl'><textarea name='faq_answer' cols='60' rows='5' class='textbox' style='width:330px;'>".phpentities(stripslashes($faq_answer))."</textarea></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo display_html("inputform", "faq_answer")."</td>\n";
echo "</tr>\n<tr>\n";
echo "<td align='center' colspan='2' class='tbl'><br />\n";
echo "<input type='submit' name='save_faq' value='".$locale['523']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
}
}
opentable($locale['502']);
$result = dbquery("SELECT * FROM ".DB_FAQ_CATS." ORDER BY faq_cat_name");
if (dbrows($result) != 0) {
echo "<table cellpadding='0' cellspacing='0' width='400' class='center'>\n<tr>\n";
echo "<td class='tbl2'>".$locale['540']."</td>\n";
echo "<td align='right' class='tbl2'>".$locale['541']."</td>\n";
echo "</tr>\n<tr>\n";
echo "<td colspan='2' height='1'></td>\n";
echo "</tr>\n";
while ($data = dbarray($result)) {
if (!isset($_GET['faq_cat_id']) || !isnum($_GET['faq_cat_id'])) { $_GET['faq_cat_id'] = 0; }
if ($data['faq_cat_id'] == $_GET['faq_cat_id']) { $p_img = "off"; $div = ""; } else { $p_img = "on"; $div = "style='display:none'"; }
echo "<tr>\n";
echo "<td class='tbl2'><img src='".get_image("panel_$p_img")."' name='b_".$data['faq_cat_id']."' alt='' onclick=\"javascript:flipBox('".$data['faq_cat_id']."')\" /> ".$data['faq_cat_name']."</td>\n";
echo "<td class='tbl2' align='right' style='font-weight:normal;'><a href='".FUSION_SELF.$aidlink."&action=edit&faq_cat_id=".$data['faq_cat_id']."&t=cat'>".$locale['542']."</a> -\n";
echo "<a href='".FUSION_SELF.$aidlink."&action=delete&faq_cat_id=".$data['faq_cat_id']."&t=cat' onclick=\"return confirm('".$locale['546']."');\">".$locale['543']."</a></td>\n";
echo "</tr>\n";
$result2 = dbquery("SELECT * FROM ".DB_FAQS." WHERE faq_cat_id='".$data['faq_cat_id']."' ORDER BY faq_id");
if (dbrows($result2) != 0) {
echo "<tr>\n<td colspan='2'>\n";
echo "<div id='box_".$data['faq_cat_id']."'".$div.">\n";
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n";
while ($data2 = dbarray($result2)) {
echo "<tr>\n";
echo "<td class='tbl'><strong>".$data2['faq_question']."</strong></td>\n";
echo "<td align='right' class='tbl'><a href='".FUSION_SELF.$aidlink."&action=edit&faq_cat_id=".$data['faq_cat_id']."&faq_id=".$data2['faq_id']."&t=faq'>".$locale['542']."</a> -\n";
echo "<a href='".FUSION_SELF.$aidlink."&action=delete&faq_cat_id=".$data['faq_cat_id']."&faq_id=".$data2['faq_id']."&t=faq' onclick=\"return confirm('".$locale['547']."');\">".$locale['543']."</a></td>\n";
echo "</tr>\n<tr>\n";
echo "<td colspan='2' class='tbl'>".trimlink(stripinput($data2['faq_answer']), 60)."</td>\n";
echo "</tr>\n";
}
echo "</table>\n</div>\n</td>\n</tr>\n";
} else {
echo "<tr>\n<td colspan='2'>\n";
echo "<div id='box_".$data['faq_cat_id']."' style='display:none'>\n";
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n";
echo "<tr>\n<td class='tbl'>".$locale['544']."</td>\n</tr>\n";
echo "</table>\n</div>\n</td>\n</tr>\n";
}
}
echo "</table>\n";
} else {
echo "<div style='text-align:center'>".$locale['545']."<br />\n</div>\n";
}
closetable();
require_once THEMES."templates/footer.php";
?>
Wiadomość doklejona:
To jak panowie pomoże mi ktoś sprawdzić ten kod bo zapisz nie działa coś klikam i nic się nie dzieje:(:(
PW od moderatora:
- Zmiana nazwy tematu - Pieka 01.03 - 18:51
Edytowane przez ArkaGdynia dnia 01.03.2010 21:51:25
|
