Нужда от помощ за два скрипта

V

vasilev5

Registered
Значи проблемът е следният:
Имам два кода- едниният чете показва новото- как мога да го редактирам, така че до датата да показва снимка от база данни - pic
Кодът е:
PHP: 
<?php
session_start();

{
$broinastranica = 10;

$pageNum = 1;

if(isset($_GET['pages']))
{
$pageNum = $_GET['pages'];
}
$query = "SELECT COUNT(news) AS numrows FROM news";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($pages = 1; $pages <= $maxPage; $pages++)
{
if ($pages == $pageNum)
{
$nomeranastranici .= " $pages ";
}
else
{
$nomeranastranici .= " <a href=\"$self?d=dir&c=news&p=news&pages=$pages\">$pages</a> ";
}
}
if ($pageNum > 1)
{
$pages = $pageNum - 1;
$predishna = " <a href=\"$self?d=dir&c=news&p=news&pages=$pages\"> [<<<] </a> ";

$parva = " <a href=\"$self?d=dir&c=news&p=news&pages=1\">[ïúðâà]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$pages = $pageNum + 1;
$sledvashta = " <a href=\"$self?d=dir&c=news&p=news&pages=$pages\"> [>>>] </a> ";
$posledna = " <a href=\"$self?d=dir&c=news&p=news&pages=$maxPage\">[ïîñëåäíà]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
$redove = ($pageNum - 1) * $broinastranica;
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$query="SELECT news,date FROM news ORDER BY id DESC LIMIT $redove, $broinastranica";
$result=mysql_query($query, $db_conn);
while ($row=mysql_fetch_row($result)) {
$news = $row['0'];
$date = $row['1'];
include("bbcode1.php");
echo("<table border='0' width='100%' cellspacing='1' align='center'>");
echo"<tr><td class='names'>";
echo "<center>Äàòà:<br>$date</center></td></tr><tr><td>$post_bbcode_treated</td></tr></table>";
}
echo "<center>";
echo "Ñòðàíèöè:";
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
echo "</center>";
}

?>
и вторият въпрос
Как да качвам снимки в кода за писане на новини
Кодът е:
<?php
session_start();
if($_SESSION['username'])
{
?>
<script language="javascript" type="text/javascript">

</script>
<?php
$sesusername = $_SESSION['username'];
$modadm = "SELECT * FROM users WHERE username='$sesusername'";
$modadm=mysql_query($modadm);
$modadm=mysql_fetch_array($modadm);
$level=$modadm['level'];
if($modadm)
{
if($level==4){
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$sesusername = $_SESSION['username'];
echo("<table border='0' width='100%' cellspacing='1' align='center'>");
echo ("<form method='POST' name='comment'>");
echo '<td align="center">';
?>
<a href="javascript:areatext('[b]Text[/b]');"><font face="verdana" color="#666" size="2">BOLD</font></a> 
<a href="javascript:areatext('[i]Text[/i]');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('[u]Text[/u]');"><font face="verdana" color="#666" size="2"><u>Underline</u></font></a> 
<a href="javascript:areatext('[color=]Text[/color]');"><font face="verdana" color="#666" size="2">Color</font></a>
<a href="javascript:areatext('[size=0]Text[/size]');"><font face="verdana" color="#666" size="2">Size</font></a>  
<a href="javascript:areatext('[img]Address[/img]');"><font face="verdana" color="#666" size="2">Img</font></a>  
<a href="javascript:areatext('[url=Address]Name[/url]');"><font face="#666" color="#666" size="2">Link</font></a> 
</td> 
</tr> 
<tr> 
<td align="center"> 
<a href="javascript:areatext(':)');"><img src="images/smilies/icon_smile.gif" alt="Smile" border="0"></a> 
<a href="javascript:areatext(':(');"><img src="images/smilies/icon_sad.gif" alt="Sad" border="0"></a> 
<a href="javascript:areatext(':arrow:');"><img src="images/smilies/icon_arrow.gif" alt="Arrow" border="0"></a> 
<a href="javascript:areatext(':D');"><img src="images/smilies/icon_biggrin.gif" alt="Biggrin" border="0"></a> 
<a href="javascript:areatext(':?');"><img src="images/smilies/icon_confused.gif" alt="Confused" border="0"></a> 
<a href="javascript:areatext('8)');"><img src="images/smilies/icon_cool.gif" alt="Cool" border="0"></a> 
<a href="javascript:areatext(';(');"><img src="images/smilies/icon_cry.gif" alt="Cry" border="0"></a> 
<a href="javascript:areatext('Shocked');"><img src="images/smilies/icon_eek.gif" alt="Eek" border="0"></a> 
<a href="javascript:areatext(':evil:');"><img src="images/smilies/icon_evil.gif" alt="Evil" border="0"></a> 
<a href="javascript:areatext('Exclamation');"><img src="images/smilies/icon_exclaim.gif" alt="Exclaim" border="0"></a> 
<a href="javascript:areatext('Idea');"><img src="images/smilies/icon_idea.gif" alt="Idea" border="0"></a> 
<a href="javascript:areatext('Laughing');"><img src="images/smilies/icon_lol.gif" alt="Lol" border="0"></a> 
<a href="javascript:areatext(':x');"><img src="images/smilies/icon_mad.gif" alt="Mad" border="0"></a> 
<a href="javascript:areatext('Question');"><img src="images/smilies/icon_question.gif" alt="Question" border="0"></a> 
<a href="javascript:areatext(':P');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a> 
<a href="javascript:areatext(':oops:');"><img src="images/smilies/icon_redface.gif" alt="Redface" border="0"></a> 
<a href="javascript:areatext(':roll:');"><img src="images/smilies/icon_rolleyes.gif" alt="Rolleyes" border="0"></a> 
<a href="javascript:areatext(':o');"><img src="images/smilies/icon_surprised.gif" alt="Surprised" border="0"></a> 
<a href="javascript:areatext(':wink:');"><img src="images/smilies/icon_wink.gif" alt="Wink" border="0"></a>
<?php
echo ("
</td> 
</tr>
<tr><td align='center' class=\"names\">Íîâèíà:</td></tr>
<tr><td align='center'>
<textarea rows='7' name='news' cols='35'></textarea></td></tr>
<tr><td align='center'>
<input type='submit' value='Èçïðàòè' name='send'></td></tr>
</form>
</td></tr></table>");
$news = $_POST['news'];
if($news)
{
if($news!="")
{
$query = "INSERT INTO news (news, date) VALUES ('$news', NOW())";
$result = @mysql_query($query);
}
}
}
elseif($level==4){
$news = $_POST['news'];
if($news)
{
if($news!="")
{
$query = "INSERT INTO news (news, date) VALUES ('$news', NOW())";
$result = @mysql_query($query);
}
}
echo("<table border='0' width='100%' cellspacing='1' align='center'>");
echo ("<form method='POST' name='comment'>");
echo '<td align="center">';
?>
<a href="javascript:areatext('[b]Text[/b]');"><font face="verdana" color="#666" size="2">BOLD</font></a> 
<a href="javascript:areatext('[i]Text[/i]');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('[u]Text[/u]');"><font face="verdana" color="#666" size="2"><u>Underline</u></font></a> 
<a href="javascript:areatext('[color=]Text[/color]');"><font face="verdana" color="#666" size="2">Color</font></a>
<a href="javascript:areatext('[size=0]Text[/size]');"><font face="verdana" color="#666" size="2">Size</font></a>  
<a href="javascript:areatext('[img]Address[/img]');"><font face="verdana" color="#666" size="2">Img</font></a>  
<a href="javascript:areatext('[url=Address]Name[/url]');"><font face="#666" color="#666" size="2">Link</font></a> 
</td> 
</tr> 
<tr> 
<td align="center"> 
<a href="javascript:areatext(':)');"><img src="images/smilies/icon_smile.gif" alt="Smile" border="0"></a> 
<a href="javascript:areatext(':(');"><img src="images/smilies/icon_sad.gif" alt="Sad" border="0"></a> 
<a href="javascript:areatext(':arrow:');"><img src="images/smilies/icon_arrow.gif" alt="Arrow" border="0"></a> 
<a href="javascript:areatext(':D');"><img src="images/smilies/icon_biggrin.gif" alt="Biggrin" border="0"></a> 
<a href="javascript:areatext(':?');"><img src="images/smilies/icon_confused.gif" alt="Confused" border="0"></a> 
<a href="javascript:areatext('8)');"><img src="images/smilies/icon_cool.gif" alt="Cool" border="0"></a> 
<a href="javascript:areatext(';(');"><img src="images/smilies/icon_cry.gif" alt="Cry" border="0"></a> 
<a href="javascript:areatext('Shocked');"><img src="images/smilies/icon_eek.gif" alt="Eek" border="0"></a> 
<a href="javascript:areatext(':evil:');"><img src="images/smilies/icon_evil.gif" alt="Evil" border="0"></a> 
<a href="javascript:areatext('Exclamation');"><img src="images/smilies/icon_exclaim.gif" alt="Exclaim" border="0"></a> 
<a href="javascript:areatext('Idea');"><img src="images/smilies/icon_idea.gif" alt="Idea" border="0"></a> 
<a href="javascript:areatext('Laughing');"><img src="images/smilies/icon_lol.gif" alt="Lol" border="0"></a> 
<a href="javascript:areatext(':x');"><img src="images/smilies/icon_mad.gif" alt="Mad" border="0"></a> 
<a href="javascript:areatext('Question');"><img src="images/smilies/icon_question.gif" alt="Question" border="0"></a> 
<a href="javascript:areatext(':P');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a> 
<a href="javascript:areatext(':oops:');"><img src="images/smilies/icon_redface.gif" alt="Redface" border="0"></a> 
<a href="javascript:areatext(':roll:');"><img src="images/smilies/icon_rolleyes.gif" alt="Rolleyes" border="0"></a> 
<a href="javascript:areatext(':o');"><img src="images/smilies/icon_surprised.gif" alt="Surprised" border="0"></a> 
<a href="javascript:areatext(':wink:');"><img src="images/smilies/icon_wink.gif" alt="Wink" border="0"></a>
<?php
echo ("
</td> 
</tr>
<tr><td align='center' class=\"names\">Íîâèíà:</td></tr>
<tr><td align='center'>
<textarea rows='7' name='news' cols='35'></textarea></td></tr>
<tr><td align='center'>
<input type='submit' value='Èçïðàòè' name='send'></td></tr>
</form>
</td></tr></table>");
}
elseif($level==1)
{
echo "<center>Äîñòúï, îòêàçàí.Ñàìî àäìèíèñòðàòîðè è ìîäåðàòîðè èìàò äîñòúï äî òîçè ìîäóë</center>";
}
}
}
else
{
echo '<table align="center"><tr><td align="center">Äîñòúï, îòêàçàí ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a></td></tr></table>';
}
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе