To zapytanie daje od razu z wynikami id, czyli wskazuje nam wartość z tabeli.
$description = dbresult(dbquery("SELECT page_description FROM pf_custom_pages WHERE page_id='$page_id'"), 0);
Kliknij i zaczekaj na załadowanie kodu ...
Jak zrobić unikalny description ? Proste.
Robisz nową tabelkę w bazie o nazwie np."page_description" z właściwościami jak page_title tylko ze długość znaków do 255.
Edycja custom_pages.php
gdzie jest zapytanie lub odczyty z bazy dodać zmienną odwołującą się do page_description.
//kod: // sorka pieka ale to co zwija pokazuje tylko do 72 linijki kodu :(
 Informacja interpretatora: Kod jest za duży dla GeSHi! Skorzystaj z tagu code.:<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "../maincore.php";
//require_once BASEDIR."subheader.php";
require_once "subheader.php";
require_once ADMIN."navigation.php";
include LOCALE.LOCALESET."admin/custom_pages.php";
if (!checkrights("CP") || !defined("iAUTH") || $aid != iAUTH) fallback("../index.php");
if (isset($page_id) && !isNum($page_id)) fallback("index.php");
if ($settings['tinymce_enabled'] == 1) echo "<script type='text/javascript'>advanced();</script>\n";
if (isset($status)) {
if ($status == "su") {
$title = $locale['400'];
$message = "<b>".$locale['401']."</b><br>\n".$locale['402']."\n<a href='".BASEDIR."viewpage.php?page_id=$pid'>viewpage.php?page_id=$pid</a>\n";
} elseif ($status == "sn") {
$title = $locale['405'];
$message = "<b>".$locale['406']."</b><br>\n".$locale['402']."\n<a href='".BASEDIR."viewpage.php?page_id=$pid'>viewpage.php?page_id=$pid</a>\n";
} elseif ($status == "del") {
$title = $locale['407'];
$message = "<b>".$locale['408']."</b>";
}
opentable($title);
echo "<div align='center'>".$message."</div>\n";
closetable();
tablebreak();
}
if (isset($_POST['save'])) {
$page_title = stripinput($_POST['page_title']);
$page_description = stripinput($_POST['page_description']);
$page_access = isNum($_POST['page_access']) ? $_POST['page_access'] : "0";
$page_content = addslash($_POST['page_content']);
$comments = isset($_POST['page_comments']) ? "1" : "0";
$ratings = isset($_POST['page_ratings']) ? "1" : "0";
if (isset($page_id)) {
$result = dbquery("UPDATE ".$db_prefix."custom_pages SET page_title='$page_title', page_description='$page_description', page_access='$page_access', page_content='$page_content', page_allow_comments='$comments', page_allow_ratings='$ratings' WHERE page_id='$page_id'");
redirect(FUSION_SELF.$aidlink."&status=su&pid=$page_id");
} else {
$result = dbquery("INSERT INTO ".$db_prefix."custom_pages (page_title, page_description, page_access, page_content, page_allow_comments, page_allow_ratings) VALUES ('$page_title','$page_description', '$page_access', '$page_content', '$comments', '$ratings')");
$page_id = mysql_insert_id();
if (isset($_POST['add_link'])) {
$result = dbquery("SELECT * FROM ".$db_prefix."site_links ORDER BY link_order DESC LIMIT 1");
$data = dbarray($result);
$link_order = $data['link_order'] + 1;
$result = dbquery("INSERT INTO ".$db_prefix."site_links (link_name, link_url, link_visibility, link_position, link_window, link_order) VALUES ('$page_title', '$page_description', 'viewpage.php?page_id=$page_id', '$page_access', '1', '0', '$link_order')");
}
redirect(FUSION_SELF.$aidlink."&status=sn&pid=$page_id");
}
} else if (isset($_POST['delete'])) {
$result = dbquery("DELETE FROM ".$db_prefix."custom_pages WHERE page_id='$page_id'");
$result = dbquery("DELETE FROM ".$db_prefix."site_links WHERE link_url='viewpage.php?page_id=$page_id'");
redirect(FUSION_SELF.$aidlink."&status=del");
} else {
if (isset($_POST['preview'])) {
$addlink = isset($_POST['add_link']) ? " checked" : "";
$page_title = stripinput($_POST['page_title']);
$page_description = stripinput($_POST['page_description']);
$page_access = $_POST['page_access'];
$page_content = $_POST['page_content'];
$page_content = stripslash($page_content);
$comments = isset($_POST['page_comments']) ? " checked" : "";
$ratings = ($_POST['page_ratings']) ? " checked" : "";
opentable($page_title);
eval("?>".$page_content."<?php ");
closetable();
tablebreak();
//$page_content = stripinput((QUOTES_GPC ? addslashes($page_content) : $page_content));
$page_content = phpentities($page_content);
}
$editlist = ""; $sel = "";
$result = dbquery("SELECT * FROM ".$db_prefix."custom_pages ORDER BY page_title DESC");
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
if (isset($page_id)) $sel = ($page_id == $data['page_id'] ? " selected" : "");
$editlist .= "<option value='".$data['page_id']."'$sel>".$data['page_title']."</option>\n";
}
}
opentable($locale['420']);
echo "<form name='selectform' method='post' action='".FUSION_SELF.$aidlink."'>
<center>
<select name='page_id' class='textbox' style='width:200px;'>
$editlist</select>
<input type='submit' name='edit' value='".$locale['421']."' class='button'>
<input type='submit' name='delete' value='".$locale['422']."' onclick='return DeletePage();' class='button'>
</center>
</form>\n";
closetable();
tablebreak();
if (isset($_POST['edit'])) {
$result = dbquery("SELECT * FROM ".$db_prefix."custom_pages WHERE page_id='$page_id'");
if (dbrows($result) != 0) {
$data = dbarray($result);
$page_title = $data['page_title'];
$page_description = $data['page_description'];
$page_access = $data['page_access'];
//$page_content = stripinput((QUOTES_GPC ? $data['page_content'] : stripslashes($data['page_content'])));
$page_content = phpentities(stripslashes($data['page_content']));
$comments = ($data['page_allow_comments'] == "1" ? " checked" : "");
$ratings = ($data['page_allow_ratings'] == "1" ? " checked" : "");
$addlink = "";
}
}
if (isset($page_id)) {
$action = FUSION_SELF.$aidlink."&page_id=$page_id";
opentable($locale['400']);
} else {
if (!isset($_POST['preview'])) {
$page_title = "";
$page_access = "";
$page_content = "";
$comments = " checked";
$ratings = " checked";
$addlink = "";
}
$action = FUSION_SELF.$aidlink;
opentable($locale['405']);
}
$user_groups = getusergroups(); $access_opts = ""; $sel = "";
while(list($key, $user_group) = each($user_groups)){
$sel = ($page_access == $user_group['0'] ? " selected" : "");
$access_opts .= "<option value='".$user_group['0']."'$sel>".$user_group['1']."</option>\n";
}
echo "<form name='inputform' method='post' action='$action' onSubmit='return ValidateForm(this);'>
<table align='center' cellpadding='0' cellspacing='0'>
<tr>
<td width='100' class='tbl'>".$locale['430']."</td>
<td width='80%' class='tbl'><input type='textbox' name='page_title' value='$page_title' class='textbox' style='width: 250px;'>
".$locale['431']."<select name='page_access' class='textbox' style='width:150px;'>
$access_opts</select></td>
</tr>
<tr>
<td width='100' class='tbl'>Description *255</td>
<td width='80%' class='tbl'><input type='textbox' name='page_description' value='$page_description' class='textbox' style='width: 500px; height: 30px;'></td>
</tr>
<tr>
<td valign='top' width='100' class='tbl'>".$locale['432']."</td>
<td width='80%' class='tbl'><textarea name='page_content' cols='95' rows='15' class='textbox'>$page_content</textarea></td>
</tr>";
// START ==> Show html-tags insertion only if tinyMCE is not active
if ($settings['tinymce_enabled'] != 1){
echo "
<!-- -->
<tr>
<td class='tbl'></td><td class='tbl'>
<input type='button' value='<?php?>' class='button' style='width:60px;' onClick=\"addText('page_content', '<?php\\n', '\\n?>');\">
<input type='button' value='<p>' class='button' style='width:35px;' onClick=\"insertText('page_content', '<p>');\">
<input type='button' value='<br>' class='button' style='width:40px;' onClick=\"insertText('page_content', '<br>');\">
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('page_content', '<b>', '</b>');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('page_content', '<i>', '</i>');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('page_content', '<u>', '</u>');\">
<input type='button' value='link' class='button' style='width:35px;' onClick=\"addText('page_content', '<a href=\'', '\' target=\'_blank\'>Link</a>');\">
<input type='button' value='img' class='button' style='width:35px;' onClick=\"insertText('page_content', '<img src=\'IMAGES/\' style=\'margin:5px;\' align=\'left\'>');\">
<input type='button' value='center' class='button' style='width:45px;' onClick=\"addText('page_content', '<center>', '</center>');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('page_content', '<span class=\'small\'>', '</span>');\">
<input type='button' value='small2' class='button' style='width:45px;' onClick=\"addText('page_content', '<span class=\'small2\'>', '</span>');\">
<input type='button' value='alt' class='button' style='width:25px;' onClick=\"addText('page_content', '<span class=\'alt\'>', '</span>');\">
</td>
</tr>
<!-- -->
\n";
}
// <== ENDS
echo "
<tr>
<td class='tbl'></td><td class='tbl'><br>\n";
if (!isset($page_id)) echo "<input type='checkbox' name='add_link' value='1'$addlink> ".$locale['433']."<br>\n";
echo "<input type='checkbox' name='page_comments' value='1'$comments> ".$locale['434']."<br>
<input type='checkbox' name='page_ratings' value='1'$ratings> ".$locale['435']."
</td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'><br>
<input type='submit' name='preview' value='".$locale['436']."' class='button'>
<input type='submit' name='save' value='".$locale['437']."' class='button'></td>
</tr>
</table>
</form>\n";
closetable();
echo "<script type='text/javascript'>
function DeletePage() {
return confirm('".$locale['409']."');
}
function ValidateForm(frm) {
if(frm.page_title.value=='') {
alert('".$locale['410']."');
return false;
}
}
</script>\n";
}
echo "</td>\n";
require_once BASEDIR."footer.php";
?>
W subheadr.php dodać tak jak poniżej kod:
if (!defined("IN_FUSION")) { header("Location: index.php"); exit; }
include "top.php";
require_once THEME."theme.php";
require_once INCLUDES."theme_functions_include.php";
if ($settings['maintenance'] == "1" && !iADMIN) fallback(BASEDIR."maintenance.php");
if (iMEMBER) $result = dbquery("UPDATE ".$db_prefix."users SET user_lastvisit='".time()."', user_ip='".USER_IP."' WHERE user_id='".$userdata['user_id']."'");
$description = dbresult(dbquery("SELECT page_description FROM ".$db_prefix."custom_pages WHERE page_id='$page_id'"), 0);
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">
<html>
<head>";
include_once INCLUDES."dynamic_titles.php";
if (!isset($title)) $title = "";
echo "<title>".$title.$settings['sitename']."</title>
<meta http-equiv='Content-Type' content='text/html; charset=".$locale['charset']."'>
<meta name='description' content='".$description.$settings['description']."'>
Kliknij i zaczekaj na załadowanie kodu ...
i to chyba na tyle :)
Edytowane przez osazwp dnia 24.02.2009 22:12:02
|
Rozwiń Kod źródłowy PHP
