Тема: Проблемы с кодом ленты новостей
Файл Read Me для
Сайрами PHP скрипт - Новости (Свобода)
F Иль
~ ~ ~ ~ ~ ~ ~ ~ ~
example.php - например PHP файлы для тестирования
news.php - сайрами PHP скрипт - Новости (Свобода)
Новости-conf.php - конфигурационный файл
Новости-style.php - файл стиля
install.sql - SQL кода для установки
readme.txt - этот файл
Я nstall
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
1. Создать базу данных MySQL для новостей.
2. Выполнить "install.sql" в этой базе данных.
3. Копия "example.php", "news.php", "Новости-conf.php", "Новости-style.php» в
каталог на веб-сервере.
4. Редактировать "Новости-conf.php".
5. Редактировать "Новости-style.php".
6. Вставьте вызывать функции "меню ()", "новости ()", "ADM ()" на вас страницы.
все 5 пунктов сделал загвоздка в последнем 6, что я должен сделать с этими функциями
сам код:
<? include("news.php"); ?>
<html>
<head>
<style>
a:link,a:visited,a:active
{
font-weight:bold;
text-decoration:none;
color:#338080;
}
a:hover
{
font-weight:bold;
text-decoration:none;
color:#E18D11;
}
</style>
</head>
<body>
<h1><center>News page</center></h1>
<table Border=1 Bordercolor="#FF8000" CellSpacing=0 CellPadding=5 Width="100%">
<tr>
<td Width="100" valign="top"><? menu(); ?></td>
<td valign="top"><? news(); ?></td>
</tr>
</table>
<? login(); ?>
</body>
</html>файл news-style:
<? /*
--------------------------------------------------------------------------------
"Simple Grey"
Style file for
SAIRS PHP Script - News (Freedom)
Mod 1
[url]http://sairs.siteburg.com[/url]/
--------------------------------------------------------------------------------
*/
function MarkTop($pNAV)
{
return "
<center>".$pNAV."</center>
<table border=1 bordercolor=\"#C0C0C0\" Width=\"100%\" CellSpacing=0 CellPadding=5>
";
}
function MarkTopRoot($pNAV) {return MarkTop($pNAV);}
function MarkTemplate($pDATETIME, $pTITLE, $pDATA)
{
return "
<tr><td><b>".$pTITLE." (".$pDATETIME.")</b><br>".$pDATA."</td></tr>
";
}
function MarkTemplateRoot($pDATETIME, $pTITLE, $pDATA, $pURLEDIT, $pURLDELETE)
{
return MarkTemplate($pDATETIME, $pTITLE, $pDATA)."
<tr><td align=right bgcolor=\"#E6E6E6\">
<a href=\"".$pURLEDIT."\">Редактировать</a>
<a href=\"".$pURLDELETE."\">Удалить</a>
</td></tr>
";
}
function MarkDown($pNAV)
{
return "
</table>
<center>".$pNAV."</center>
";
}
function MarkDownRoot($pNAV) {return MarkDown($pNAV);}
/* Copyright (R) 2005 SAIRS, Company. All rights reserved. */ ?>news файл:
<? /*
--------------------------------------------------------------------------------
SAIRS PHP Script - News (Freedom)
Version 1 Source 9
Copyright (R) 2005 SAIRS, Company. All rights reserved.
This code is installed as part of SAIRS software. You may adapt this script
for your Web pages. You may not reprint or redistribute this code without
permission from SAIRS.
http://sairs.siteburg.com/
--------------------------------------------------------------------------------
*/
include("news-conf.php");
include("news-style.php");
session_start();
function menu()
{
echo "<a href=\"".$PHP_SELF."?action=view\">News</a>";
echo "<br><a href=\"".$PHP_SELF."?action=archive\">Archive</a>";
if($_SESSION['News_User']=="root")
{
echo "<br><a href=\"".$PHP_SELF."?action=add\">Add</a>";
}
}
function LeftRight($records,$start,$URL,$inpage)
{
$str="";
if($records<=$inpage) return;
if($start!=0) {
$str.="<a href=".$URL."0><<</a> ";
$str.="<a href=$URL".($start-1)."><</a> ";
}
else $str.="<< < ";
if($start==0) {$sstart=$start-0;$send=$start+10;}
if($start==1) {$sstart=$start-1;$send=$start+9;}
if($start==2) {$sstart=$start-2;$send=$start+8;}
if($start==3) {$sstart=$start-3;$send=$start+7;}
if($start==4) {$sstart=$start-4;$send=$start+6;}
if($start>=5) {$sstart=$start-5;$send=$start+5;}
if($send*$inpage>$records) $send=$records/$inpage;
if($sstart<0) $sstart=0;
if($records%$inpage==0) $add=0; else $add=1;
for($i=$sstart;$i<$send;$i++) {
if($i==$start) $str.=" <B>".($i+1)."/".(intval($records/$inpage)+$add)."</B> | ";
else $str.="<a href=$URL".($i)."><U><B>".($i+1)."</B></U></a> | ";
}
if($start+(1-$add)<intval($records/$inpage)) {
$str.=" <a href=$URL".($start+1).">></a>";
$str.=" <a href=$URL".(intval($records/$inpage)-(1-$add)).">>></a>";
}
else $str.=" > >>";
return($str);
}
function editor()
{ ?>
var EditFieldHeader = "<html><style>body, td, p {margin-left: 2px; margin-top: 2px; margin-bottom: 3px;}</style>";
var EditFieldHeaderOut = "";
var EditFieldFooter = "";
var EditFieldFooterOut = "</html>";
var PanelStyle = "";
function Toolkit() {
var TStyle = "";
if(navigator.userAgent.match(/msie/i)) TStyle = new Array('Undo','Redo','separator','Cut','Copy','Paste','separator','separator','Bold','Italic','Underline','StrikeThrough','Superscript','Subscript','separator','JustifyLeft','JustifyCenter','JustifyRight','JustifyFull','separator','InsertOrderedList','InsertUnorderedList','Indent','Outdent','separator','CreateLink','InsertHorizontalRule','InsertTable','InsertImage','separator','ForeColor','BackColor','separator','separator','RemoveFormat');
if(navigator.userAgent.match(/gecko/i)) TStyle = new Array('undo','redo','separator','cut','copy','paste','separator','separator','bold','italic','underline','strikethrough','superscript','subscript','separator','justifyleft','justifycenter','justifyright','justifyfull','separator','insertorderedlist','insertunorderedlist','indent','outdent','separator','createlink','inserthorizontalrule','inserttable','insertimage','separator','forecolor','backcolor','separator','separator','removeformat');
var TImage = new Array('undo','redo','','cut','copy','paste','','','b','i','u','s','sup','sub','','l','c','r','j','','ol','ul','in','out','','a','hr','tab','img','','cfg','cbg','','','F');
var TTitle = new Array('Undo','Redo','','Cut','Copy','Paste','','','Strong','Italic','Underline','Crossed out','Top index','Down index','','Left','Center','Right','Justify','','Number list','Mark list','Right list','Left list','','HTML','Line','Table','Image','','Font color','Background color','','','No format');
var Toolkit = "";
for (i in TStyle) {
if ((TStyle[i]!="separator")&&(TStyle[i]!="InsertImage")&&(TStyle[i]!="insertimage")) Toolkit+="<button class=tools width=20 height=20 onclick=\"setStyle('"+TStyle[i]+"')\" title=\""+TTitle[i]+"\"><img src=pix/"+TImage[i]+".gif></button>\n";
else Toolkit += " \n";
}
document.getElementById('tools').innerHTML = Toolkit;//+"</Tr></Table>";
} Toolkit();
function setStyle(TStyle)
{
if(TStyle.match(/inserttable/i))
{
var Form = "\
<html>\n\
<head>\n\
<title>Insert table</title>\n\
" + PanelStyle + "\n\
</head>\n\
\n\
<script language=Javascript>\n\
function AddTbl() {\n\
var nTable = '<TABLE width='+document.forms['tblf'].elements['width'].value+' height='+document.forms['tblf'].elements['height'].value+' cellpadding='+document.forms['tblf'].elements['padding'].value+' cellspacing='+document.forms['tblf'].elements['spacing'].value+' border='+document.forms['tblf'].elements['border'].value+' bgcolor=#'+document.forms['tblf'].elements['bgcolor'].value+'>';\n\
for (r=0;r<document.forms['tblf'].elements['rows'].value;r++) {\n\
nTable += '<tr>';\n\
for (c=0;c<document.forms['tblf'].elements['cols'].value;c++) {\n\
nTable += '<td></td>';\n\
}\n\
nTable += '</tr>';\n\
}\n\
nTable += '</TABLE>';\n\
var Field = window.opener.EditFieldHeader+window.opener.EditField.body.innerHTML+nTable+window.opener.EditFieldFooter;\n\
window.opener.EditField.open();\n\
window.opener.EditField.write(Field);\n\
window.opener.EditField.close();\n\
window.close();\n\
}\n\
</scr"+"ipt>\n\
\n\
<body topmargin=0 leftmargin=0>\n\
<br><form id=tblf><table width=100%>\n\
<tr><td>Width</td><td><input size=15 name=width value='100%'></td></tr>\n\
<tr><td>Height</td><td><input size=15 name=height value='200'></td></tr>\n\
<tr><td>Cols</td><td><input size=15 name=cols value='5'></td></tr>\n\
<tr><td>Rows</td><td><input size=15 name=rows value='2'></td></tr>\n\
<tr><td>Border</td><td><input size=15 name=border value='1'></td></tr>\n\
<tr><td>Padding</td><td><input size=15 name=padding value='2'></td></tr>\n\
<tr><td>Spacing</td><td><input size=15 name=spacing value='1'></td></tr>\n\
<tr><td>Background color</td><td><input size=15 name=bgcolor value='FFFFFF' maxlength=6></td></tr>\n\
<tr><td colspan=2><input type=button value=Insert style='width:100%' OnClick=\"AddTbl()\"></td></tr>\n\
</table></form>\n\
</body>\n\
\n\
</html>";
var TabPanel = window.open("","TabPanel","dependent=1,width=300,height=220,status=yes");
TabPanel.document.open();
TabPanel.document.write(Form);
TabPanel.document.close();
} else if (TStyle.match(/insertimage/i)) {
var Form = "\
<html>\n\
<head>\n\
<title>Insert image</title>\n\
</head>\n\
\n\
<body leftmargin=0 rightmargin=0 topmargin=0 bottommargin=0 marginwidth=0 marginheight=0>\n\
<FORM action=\"saveimg.php\" method=\"POST\" enctype=\"multipart/form-data\" id=\"imgform\">\n\
<input type=\"file\" name=\"img\" style=\"width:400\">\n\
<input type=\"hidden\" name=\"id\" value=\"165\">\n\
<br><input type=\"submit\" value=\"OK\" style=\"width:400\" onclick=\"window.opener.EditField.execCommand('insertimage',false,document.forms['imgform'].elements['img'].value);\">\n\
</FORM>\n\
</body>\n\
\n\
<html>";
ImgPanel = open('', 'ImgPanel', 'dependent=1,width=400,height=10,status=no,toolbar=no,menubar=no,location=no,resizable=yes');
ImgPanel.document.open();
ImgPanel.document.write(Form);
ImgPanel.document.close();
} else if (TStyle.match(/^createlink$/i)) {
var Url = prompt('Enter URL','http://');
EditField.execCommand('CreateLink',false,Url);
} else if (TStyle.match(/forecolor|backcolor/i)) {
var Form="\
<html>\n\
<head>\n\
<title>Palette</title>\n\
</head>\n\
\n\
<body leftmargin=0 rightmargin=0 topmargin=0 bottommargin=0 marginwidth=0 marginheight=0>\n<table width=\"360\" height=\"100\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td height=\"40\">\n\
<form name=clr>\n\
<input type=text name=colr style=\"width:40;height:30\" readonly> \n\
<input type=text name=colr_hex style=\"width:60\" value=#ffffff>\n\
</form>\n\
</td></tr><tr><td><table width=\"360\" height=\"60\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
var i=0;
for(r=0;r<6;r++) {
for(g=0;g<6;g++) {
for(b=0;b<6;b++) {
if(i==0) Form+="<tr>\n";
colr=i2hx(r)+i2hx(g)+i2hx(b);
Form+="<td width=10 height=10 bgcolor=#"+colr+" onclick=\"window.opener.EditField.execCommand('"+TStyle+"',false,'#"+colr+"');window.close();\" onmouseover=\"document.forms['clr'].elements['colr'].style.background='#"+colr+"';document.forms['clr'].elements['colr_hex'].value='#"+colr+"'\"><img src=pix/1x1.gif height=10 border=0></td>\n";
i++;
if(i==36) {
Form+='</tr>';
i=0;
}
}
}
}
Form+="\
</table></td><tr><table>\n\
</body>\n\
\n\
</html>";
ColorPanel = open('', 'ColorPanel', 'dependent=1,width=360,height=80,status=yes,toolbar=no,menubar=no,location=no,resizable=no');
ColorPanel.document.open();
ColorPanel.document.write(Form);
ColorPanel.document.close();
} else {
EditField.execCommand(TStyle,false,null);
}
}
function i2hx(i) {
i*=51;
if (i<16) return "0"+i.toString(16);
else return i.toString(16);
}
function SetFace() {EditField.execCommand('fontname',false,document.getElementById('fface').value)}
function SetSize() {EditField.execCommand('fontsize',false,document.getElementById('fsize').value)}
function Save() {
if (navigator.userAgent.match(/msie/i)) document.forms['EditForm'].elements['field'].value = EditFieldHeaderOut + EditField.body.outerHTML + EditFieldFooter;
if (navigator.userAgent.match(/gecko/i)) document.forms['EditForm'].elements['field'].value = EditFieldHeaderOut + "<body bgcolor=" + EditField.bgColor + ">\n" + EditField.body.innerHTML + "\n</body>" + EditFieldFooter;
document.forms['EditForm'].submit();
}
if (navigator.userAgent.match(/msie/i)) EditField = frames['EditFrame'].document;
else if (navigator.userAgent.match(/gecko/i)) EditField = document.getElementById('EditFrame').contentDocument;
else alert("ArthEdit is not supported by your browser");
EditField.designMode="On";
EditField.open();
EditField.write(EditFieldHeader);
EditField.write(Content);
EditField.write(EditFieldFooter);
EditField.close();
EditField.execCommand('fontname',false,'Verdana');
EditField.execCommand('fontsize',false,'2');
<? }
function snFormNewsAddVisual($snPDate="0000-00-00",$snPTime="00:00:00",$snPTitle="",$snPData="")
{ ?>
<form id="EditForm" method="post" action="<? echo $PHP_SELF."?action=add"; ?>" enctype="multipart/form-data">
<input type="hidden" name="field"><input type="hidden" name="filename"><input type="hidden" name="editmode" value="none">
<table Border=0 CellSpacing=3 CellPadding=0>
<tr><td align='right' valign="top">Date: </td><td><input type="text" name="FormAdd_Date" value="<? echo $snPDate; ?>"></td></tr>
<tr><td align='right' valign="top">Time: </td><td><input type="text" name="FormAdd_Time" value="<? echo $snPTime; ?>"></td></tr>
<tr><td align='right' valign="top">Title: </td><td><input type="text" name="FormAdd_Title" style="width: 300px;" value="<? echo $snPTitle; ?>"></td></tr>
<tr><td align='right' valign="top">News: </td><td>
<table Border=0 CellSpacing=0 CellPadding=0 Width="100%">
<tr>
<td style="border-color: #808080; border-width: 1px; border-style: solid solid none solid;"><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'visual'; document.forms['EditForm'].submit();">Visual editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;"> </td>
<td style="border-color: #808080; border-width: 1px; border-style: solid;" bgcolor=#D7D7D7><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'text'; Save();">Text editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;" Width="100%"> </td>
</tr>
</table>
<TABLE width="100%" cellpadding=3 cellspacing=0 border=0 style="border-color: #808080; border-width: 1px; border-style: none solid solid solid;">
<TR><TD height="25">
<div id="tools"></div>
</TD></TR>
<TR><TD height="25">
<div id="fonts">
Font face <select id="fface" onchange="SetFace()"><option value="Arial">Arial<option value="Courier New">Courier New<option value="Tahoma">Tahoma<option value="Times New Roman">Times New Roman<option value="Verdana" selected>Verdana</select>
Font size <select id="fsize" style="width:40" onchange="SetSize()"><option value="1">1<option value="2" selected>2<option value="3">3<option value="4">4<option value="5">5<option value="6">6<option value="7">7</select>
</div>
</TD></TR>
<TR>
<TD><IFRAME id="EditFrame" width="100%" height="300" frameborder="1" contenteditable="true"></IFRAME></TD>
</TR>
</TABLE>
</td></tr>
<tr><td align='right'> </td><td><INPUT type="button" value="OK" onclick="Save()"></td></tr>
</table>
</form>
<script language="javascript">Content = "";<?
$aline=explode("\n", trim($snPData));
for($for_i=0;$for_i<count($aline);$for_i++) echo "Content += \"".str_replace("\"", "'", trim($aline[$for_i]))."\";";
editor();
?></script><? }
function snFormNewsEditVisual($snPID,$snPDate="0000-00-00",$snPTime="00:00:00",$snPTitle="",$snPData="")
{ ?>
<form id="EditForm" method="post" action="<? echo $PHP_SELF."?action=edit&id=".$snPID; ?>" enctype="multipart/form-data">
<input type="hidden" name="field"><input type="hidden" name="filename"><input type="hidden" name="editmode" value="none">
<table Border=0 CellSpacing=3 CellPadding=0>
<tr><td align='right' valign="top">Data: </td><td><input type="text" name="FormEdit_Date" value="<? echo $snPDate; ?>"></td></tr>
<tr><td align='right' valign="top">Time: </td><td><input type="text" name="FormEdit_Time" value="<? echo $snPTime; ?>"></td></tr>
<tr><td align='right' valign="top">Title: </td><td><input type="text" name="FormEdit_Title" style="width: 300px;" value="<? echo $snPTitle; ?>"></td></tr>
<tr><td align='right' valign="top">News: </td><td>
<table Border=0 CellSpacing=0 CellPadding=0 Width="100%">
<tr>
<td style="border-color: #808080; border-width: 1px; border-style: solid solid none solid;"><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'visual'; document.forms['EditForm'].submit();">Visual editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;"> </td>
<td style="border-color: #808080; border-width: 1px; border-style: solid;" bgcolor=#D7D7D7><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'text'; Save();">Text editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;" Width="100%"> </td>
</tr>
</table>
<TABLE width="100%" cellpadding=3 cellspacing=0 border=0 style="border-color: #808080; border-width: 1px; border-style: none solid solid solid;">
<TR><TD height="25">
<div id="tools"></div>
</TD></TR>
<TR><TD height="25">
<div id="fonts">
Font face <select id="fface" onchange="SetFace()"><option value="Arial">Arial<option value="Courier New">Courier New<option value="Tahoma">Tahoma<option value="Times New Roman">Times New Roman<option value="Verdana" selected>Verdana</select>
Font size <select id="fsize" style="width:40" onchange="SetSize()"><option value="1">1<option value="2" selected>2<option value="3">3<option value="4">4<option value="5">5<option value="6">6<option value="7">7</select>
</div>
</TD></TR>
<TR>
<TD><IFRAME id="EditFrame" width="100%" height="300" frameborder="1" contenteditable="true"></IFRAME></TD>
</TR>
</TABLE>
</td></tr>
<tr><td align='right'> </td><td><INPUT type="button" value="OK" onclick="Save()"></td></tr>
</table>
</form>
<script language="javascript">Content = "";<?
$aline=explode("\n", trim($snPData));
for($for_i=0;$for_i<count($aline);$for_i++) echo "Content += \"".str_replace("\"", "'", trim($aline[$for_i]))."\";";
editor();
?></script><? }
function snFormNewsAddText($snPDate="0000-00-00",$snPTime="00:00:00",$snPTitle="",$snPData="")
{ ?>
<form id="EditForm" method="post" action="<? echo $PHP_SELF."?action=add"; ?>" enctype="multipart/form-data">
<input type="hidden" name="field"><input type="hidden" name="filename"><input type="hidden" name="editmode" value="none">
<table Border=0 CellSpacing=3 CellPadding=0>
<tr><td align='right' valign="top">Date: </td><td><input type="text" name="FormAdd_Date" value="<? echo $snPDate; ?>"></td></tr>
<tr><td align='right' valign="top">Time: </td><td><input type="text" name="FormAdd_Time" value="<? echo $snPTime; ?>"></td></tr>
<tr><td align='right' valign="top">Title: </td><td><input type="text" name="FormAdd_Title" style="width: 300px;" value="<? echo $snPTitle; ?>"></td></tr>
<tr><td align='right' valign="top">News: </td><td>
<table Border=0 CellSpacing=0 CellPadding=0 Width="100%">
<tr>
<td style="border-color: #808080; border-width: 1px; border-style: solid;" bgcolor=#D7D7D7><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'visual'; document.forms['EditForm'].submit();">Visual editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;"> </td>
<td style="border-color: #808080; border-width: 1px; border-style: solid solid none solid;"><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'text'; document.forms['EditForm'].submit();">Text editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;" Width="100%"> </td>
</tr>
</table>
<TABLE width="100%" cellpadding=3 cellspacing=0 border=0 style="border-color: #808080; border-width: 1px; border-style: none solid solid solid;">
<tr><td><textarea cols=50 rows=15 name="FormAdd_Data"><? echo $snPData; ?></textarea></td></tr>
</table>
</td></tr>
<tr><td align='right'> </td><td><INPUT type="submit" value="OK"></td></tr>
</table>
</form>
<? }
function snFormNewsEditText($snPID,$snPDate="0000-00-00",$snPTime="00:00:00",$snPTitle="",$snPData="")
{ ?>
<form id="EditForm" method="post" action="<? echo $PHP_SELF."?action=edit&id=".$snPID; ?>" enctype="multipart/form-data">
<input type="hidden" name="field"><input type="hidden" name="filename"><input type="hidden" name="editmode" value="none">
<table Border=0 CellSpacing=3 CellPadding=0>
<tr><td align='right' valign="top">Date: </td><td><input type="text" name="FormEdit_Date" value="<? echo $snPDate; ?>"></td></tr>
<tr><td align='right' valign="top">Time: </td><td><input type="text" name="FormEdit_Time" value="<? echo $snPTime; ?>"></td></tr>
<tr><td align='right' valign="top">Title: </td><td><input type="text" name="FormEdit_Title" style="width: 300px;" value="<? echo $snPTitle; ?>"></td></tr>
<tr><td align='right' valign="top">News: </td><td>
<table Border=0 CellSpacing=0 CellPadding=0 Width="100%">
<tr>
<td style="border-color: #808080; border-width: 1px; border-style: solid;" bgcolor=#D7D7D7><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'visual'; document.forms['EditForm'].submit();">Visual editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;"> </td>
<td style="border-color: #808080; border-width: 1px; border-style: solid solid none solid;"><nobr> <a href="javascript: document.forms['EditForm'].elements['editmode'].value = 'text'; document.forms['EditForm'].submit();">Text editor</a> </nobr></td>
<td style="border-color: #808080; border-width: 1px; border-style: none none solid none;" Width="100%"> </td>
</tr>
</table>
<TABLE width="100%" cellpadding=3 cellspacing=0 border=0 style="border-color: #808080; border-width: 1px; border-style: none solid solid solid;">
<tr><td><textarea cols=50 rows=15 name="FormEdit_Data"><? echo $snPData; ?></textarea></td></tr>
</table>
</td></tr>
<tr><td align='right'> </td><td><INPUT type="submit" value="OK"></td></tr>
</table>
</form>
<? }
function news()
{
global $MySQL_Host, $MySQL_User, $MySQL_Password, $MySQL_DataBase;
global $News_User, $News_Password;
global $Conf_RoP;
global $Mark_Top, $Mark_RootTop, $Mark_Template, $Mark_RootTemplate, $Mark_Down, $Mark_RootDown;
$News_Action_View=1;
if(isset($_GET['action']))
{
if($_GET['action']=="archive")
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$query = "SELECT DISTINCT `datetime` FROM `news` ORDER BY `datetime` DESC";
$result = mysql_query($query) or die("Query failed");
$nowy="0000";$nowm="00";
while($line=mysql_fetch_row($result))
{
list($liney,$linem,$lined)=explode("-", $line[0]);
if(($nowy!=$liney)||($nowm!=$linem))
{
$nowy=$liney; $nowm=$linem;
echo "<a href=\"".$PHP_SELF."?date=".$nowy."-".$nowm."\">".$nowy."-".$nowm."</a><br>";
}
}
mysql_free_result($result);
mysql_close($link);
$News_Action_View=0;
}
if(($_GET['action']=="add")&&($_SESSION['News_User']=="root"))
{
if(isset($_POST['FormAdd_Date']))
{
$Temp_FormAdd_Data="";
if(isset($_POST['FormAdd_Data'])) {
$Temp_FormAdd_Data=$_POST['FormAdd_Data'];
} else {
$_POST['field']=str_replace("<BODY>", "", $_POST['field']);
$_POST['field']=str_replace("</BODY>", "", $_POST['field']);
$_POST['field']=str_replace("\\\"", "\"", $_POST['field']);
$_POST['field']=str_replace("<P>", "<DIV>", $_POST['field']);
$_POST['field']=str_replace("</P>", "</DIV>", $_POST['field']);
$Temp_FormAdd_Data=str_replace("\\\\", "\\", $_POST['field']);
}
if($_POST['editmode']=="none")
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$query = "INSERT INTO `news` ( `id` , `datetime` , `title` , `data` , `status` ) VALUES ('', '".$_POST['FormAdd_Date']." ".$_POST['FormAdd_Time']."', '".$_POST['FormAdd_Title']."', '".$Temp_FormAdd_Data."', '1');";
mysql_query($query) or die("Query failed");
echo "News is added";
mysql_close($link);
}
if($_POST['editmode']=="text")
{
snFormNewsAddText($_POST['FormAdd_Date'], $_POST['FormAdd_Time'], $_POST['FormAdd_Title'], $Temp_FormAdd_Data);
}
if($_POST['editmode']=="visual")
{
snFormNewsAddVisual($_POST['FormAdd_Date'], $_POST['FormAdd_Time'], $_POST['FormAdd_Title'], $Temp_FormAdd_Data);
}
}
else snFormNewsAddVisual(date("Y-m-d"), date("G:i:s"));
$News_Action_View=0;
}
if(($_GET['action']=="edit")&&(isset($_GET['id']))&&($_SESSION['News_User']=="root"))
{
if(isset($_POST['FormEdit_Date']))
{
$Temp_FormEdit_Data="";
if(isset($_POST['FormEdit_Data'])) {
$Temp_FormEdit_Data=$_POST['FormEdit_Data'];
} else {
$_POST['field']=str_replace("<BODY>", "", $_POST['field']);
$_POST['field']=str_replace("</BODY>", "", $_POST['field']);
$_POST['field']=str_replace("\\\"", "\"", $_POST['field']);
$_POST['field']=str_replace("<P>", "<DIV>", $_POST['field']);
$_POST['field']=str_replace("</P>", "</DIV>", $_POST['field']);
$Temp_FormEdit_Data=str_replace("\\\\", "\\", $_POST['field']);
}
if($_POST['editmode']=="none")
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$query = "UPDATE `news` SET `datetime` = '".$_POST['FormEdit_Date']." ".$_POST['FormEdit_Time']."', `title` = '".$_POST['FormEdit_Title']."', `data` = '".$Temp_FormEdit_Data."' WHERE `id` =".$_GET['id'].";";
mysql_query($query) or die("Query failed");
echo "News is edited";
mysql_close($link);
}
if($_POST['editmode']=="text")
{
snFormNewsEditText($_GET['id'], $_POST['FormEdit_Date'], $_POST['FormEdit_Time'], $_POST['FormEdit_Title'], $Temp_FormEdit_Data);
}
if($_POST['editmode']=="visual")
{
snFormNewsEditVisual($_GET['id'], $_POST['FormEdit_Date'], $_POST['FormEdit_Time'], $_POST['FormEdit_Title'], $Temp_FormEdit_Data);
}
}
else
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$query = "SELECT `id`, `datetime`, `title`, `data` FROM `news` WHERE `id`=".$_GET['id'].";";
$result = mysql_query($query) or die("Query failed");
$line=mysql_fetch_row($result);
list($linedate,$linetime)=explode(" ", $line[1]);
mysql_free_result($result);
mysql_close($link);
snFormNewsEditVisual($_GET['id'], $linedate, $linetime, $line[2], $line[3]);
}
$News_Action_View=0;
}
if(($_GET['action']=="delete")&&(isset($_GET['id']))&&($_SESSION['News_User']=="root"))
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$query = "DELETE FROM `news` WHERE `id`=".$_GET['id'].";";
mysql_query($query) or die("Query failed");
echo "News is deleted";
mysql_close($link);
$News_Action_View=0;
}
if($_GET['action']=="login")
{
if(isset($_POST['FormLogin_User']))
{
if(($News_User==trim($_POST['FormLogin_User']))&&($News_Password==trim($_POST['FormLogin_Password'])))
{
$_SESSION['News_User']="root";
echo "Name and password are accepted";
}
else echo "Access denied";
}
else
{
if($_SESSION['News_User']=="root") echo "<a href=\"".$PHP_SELF."?action=logout\">Exit</a>";
else
{
?>
<form name="FormLogin" method="post" action="<? echo $PHP_SELF."?action=login"; ?>">
<table Border=0 CellSpacing=0 CellPadding=0>
<tr><td align='right'>Name: </td><td><input type="text" name="FormLogin_User"></td></tr>
<tr><td align='right'>Password: </td><td><input type="password" name="FormLogin_Password"></td></tr>
</table><br>
<INPUT name=submit type=submit value="OK">
</form>
<?
}
}
$News_Action_View=0;
}
if($_GET['action']=="logout")
{
session_unset();
echo "Exit is successful";
$News_Action_View=0;
}
}
if($News_Action_View)
{
$link = mysql_connect($MySQL_Host,$MySQL_User,$MySQL_Password) or die("Could not connect");
mysql_select_db($MySQL_DataBase) or die("Could not select database");
$Position=0;
if(isset($_GET['date']))
{
$query = "SELECT `id`, `datetime`, `title`, `data` FROM `news` WHERE `datetime` LIKE '".$_GET['date']."%' ORDER BY `datetime` DESC";
$result = mysql_query($query) or die("Query failed");
}
else
{
if(isset($_GET['position'])) $Position=$_GET['position'];
$result = mysql_query("SELECT `id` FROM `news`") or die("Query failed");
$resultall=mysql_num_rows($result);
mysql_free_result($result);
$query = "SELECT `id`, `datetime`, `title`, `data` FROM `news` ORDER BY `datetime` DESC LIMIT ".($Position*$Conf_RoP)." , ".$Conf_RoP;
$result = mysql_query($query) or die("Query failed");
}
$Nav=LeftRight($resultall,$Position,$PHP_SELF."?position=",$Conf_RoP);
if($_SESSION['News_User']=="root") echo MarkTopRoot($Nav); else echo MarkTop($Nav);
while($line=mysql_fetch_row($result))
{
if($_SESSION['News_User']=="root")
echo MarkTemplateRoot(
$line[1], $line[2], $line[3],
$PHP_SELF."?action=edit&id=".$line[0],
$PHP_SELF."?action=delete&id=".$line[0]
);
else
echo MarkTemplate(
$line[1], $line[2], $line[3]
);
}
if($_SESSION['News_User']=="root") echo MarkDownRoot($Nav); else echo MarkDown($Nav);
mysql_free_result($result);
mysql_close($link);
}
}
function login()
{
echo "<a href=\"".$PHP_SELF."?action=login\">Adm</a>";
}
/* Copyright (R) 2005 SAIRS, Company. All rights reserved. */ ?>