Имам готов код за редактиране на уроци. Опитах се да вмъкна в готовия код и функция за активизация на урок , но той не работи.
<?php
session_start();
if($_SESSION['username'])
{
$sesusername = $_SESSION['username'];
$userlevel = 9;
$sql="SELECT * FROM users WHERE username='$sesusername'";
$result=mysql_query($sql);
while($r=mysql_fetch_array($result))
{
$lcount = $r['level'];
}
if($lcount==9 || $lcount==9)
{
?>
<script language="javascript" type="text/javascript">
</script>
<?php
if ((isset($_GET['id'])) && (is_numeric($_GET['id'])) ) {
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) && (is_numeric($_POST['id'])) ) {
$id = $_POST['id'];
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Ìîëÿ, èçáåðåòå óðîê äà ðåäàêòèðàòå.</a></td></tr></table>';
exit();
}
if (isset($_POST['submitted'])) {
$errors = array();
if (empty($_POST['title'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå çàãëàâèå.</a></td></tr></table>';
} else {
$title = $_POST['title'];
}
if (empty($_POST['name'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå àâòîð.</a></td></tr></table>';
} else {
$name = $_POST['name'];
}
if (empty($_POST['activen'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå êîä.</a></td></tr></table>';
} else {
$activen = $_POST['activen'];
}
if (empty($_POST['message'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå ñúîáùåíèå.</a></td></tr></table>';
} else {
$message = $_POST['message'];
}
$category = $_POST['category'];
if (empty($errors)) {
$query = "UPDATE lesson_posts SET title='$title', author='$name', post='$message', category='$category' , activen='$activen' WHERE id='$id'";
$result = mysql_query($query);
if ($result) {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò áåøå îáíîâåí!</a></td></tr></table>';
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò íå áåøå îáíîâåí.</a></td></tr></table>';
}
} else {
echo 'Óðîêúò íå ìîæåøå äà áúäå îáíîâåí çà ñëåäíèòå ïðè÷èíè -<br />';
foreach ($errors as $msg) {
echo " - $msg<br />\n";
}
}
} else {
$query = "SELECT title, author, post, activen, id FROM lesson_posts WHERE id=$id";
$result = mysql_query($query);
$num = mysql_num_rows($result);
$row = mysql_fetch_array ($result, MYSQL_NUM);
$title = $row['0'];
$name = $row['1'];
$message = $row['2'];
$activen = $row['3'];
$title = htmlspecialchars($title);
$name = htmlspecialchars($name);
$message = htmlspecialchars($message);
$activen = htmlspecialchars($activen);
if ($num == 1) {
echo '<form action="?d=dir&c=vip&p=edit_lesson&id=edit_lesson&num='.$id.'" method="post" name="vobn">
<table align="center" border="1">
<tr>
<td align="center" class="names">Çàãëàâèå : </td></tr>
<tr><td align="center"><input type="text" name="title" size="25" maxlength="255" value="'.$title.'" />
</td></tr><tr><td align="center" class="names">Àâòîð : </td></tr>
<tr><td align="center"> <input type="text" name="name" size="15" maxlength="255" value="'.$name.'" />
</td></tr><tr><td align="center" class="names">Êîä àêòèâàöèÿ : </td></tr>
<tr><td align="center"> <input type="text" name="activen" size="15" maxlength="255" value="'.$activen.'" />
<td align="center" class="names">Êàòåãîðèÿ :</td></tr><tr><td align="center"><select name="category">';
$result = mysql_query("SELECT * FROM categorii order by id");
while($r=mysql_fetch_array($result))
{
$cato = $r['catoption'];
echo "$cato";
}
echo '</select></td></tr><tr><td align="center" class="names">Óðîê : </td></tr>';
?>
<tr>
<td align="center">
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">BOLD</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('Text');"><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('Text');"><font face="verdana" color="#666" size="2">Size</font></a>
<a href="javascript:areatext('
');"><font face="verdana" color="#666" size="2">Img</font></a>
<a href="javascript:areatext('Name');"><font face="#666" color="#666" size="2">Link</font></a>
<a href="javascript:areatext('
');"><font face="#666" color="#666" size="2">Code</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('
');"><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('
');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a>
<a href="javascript:areatext('
');"><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('
');"><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>
</td>
</tr>
<?php
echo '
<tr><td align="center"><textarea rows="30" cols="70" name="message">'.$message.'</textarea></td></tr>
<tr><td align="center">
<input type="submit" name="submit" value="Îáíîâè" /></td></tr></table>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="id" value="'.$id.'" /></form>';
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò íå ìîæåøå äà áúäå ðåäàêòèðàí, ìîëÿ, îïèòàéòå îòíîâî.</a></td></tr></table>';
}
}
}
else
{
echo '<table align="center"><tr><td align="center">Âàøeòî ïîòðåáèòåëñêî èìå íå å àäìèíèñòðàòîðñêî èëè ìîäåðàòîðñêî ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a> êàòî àäìèíèñòðàòîð èëè ìîäåðàòîð</td></tr></table>';
}
}
else
{
echo '<table align="center"><tr><td>Äîñòúï, îòêàçàí ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a></td></tr></table>';
}
?>
Защо не се получава?
<?php
session_start();
if($_SESSION['username'])
{
$sesusername = $_SESSION['username'];
$userlevel = 9;
$sql="SELECT * FROM users WHERE username='$sesusername'";
$result=mysql_query($sql);
while($r=mysql_fetch_array($result))
{
$lcount = $r['level'];
}
if($lcount==9 || $lcount==9)
{
?>
<script language="javascript" type="text/javascript">
</script>
<?php
if ((isset($_GET['id'])) && (is_numeric($_GET['id'])) ) {
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) && (is_numeric($_POST['id'])) ) {
$id = $_POST['id'];
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Ìîëÿ, èçáåðåòå óðîê äà ðåäàêòèðàòå.</a></td></tr></table>';
exit();
}
if (isset($_POST['submitted'])) {
$errors = array();
if (empty($_POST['title'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå çàãëàâèå.</a></td></tr></table>';
} else {
$title = $_POST['title'];
}
if (empty($_POST['name'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå àâòîð.</a></td></tr></table>';
} else {
$name = $_POST['name'];
}
if (empty($_POST['activen'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå êîä.</a></td></tr></table>';
} else {
$activen = $_POST['activen'];
}
if (empty($_POST['message'])) {
$errors[] = '<table align="center"><tr><td align="center"><a class="text">Âèå çàáðàâèõòå äà âúâåäåòå ñúîáùåíèå.</a></td></tr></table>';
} else {
$message = $_POST['message'];
}
$category = $_POST['category'];
if (empty($errors)) {
$query = "UPDATE lesson_posts SET title='$title', author='$name', post='$message', category='$category' , activen='$activen' WHERE id='$id'";
$result = mysql_query($query);
if ($result) {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò áåøå îáíîâåí!</a></td></tr></table>';
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò íå áåøå îáíîâåí.</a></td></tr></table>';
}
} else {
echo 'Óðîêúò íå ìîæåøå äà áúäå îáíîâåí çà ñëåäíèòå ïðè÷èíè -<br />';
foreach ($errors as $msg) {
echo " - $msg<br />\n";
}
}
} else {
$query = "SELECT title, author, post, activen, id FROM lesson_posts WHERE id=$id";
$result = mysql_query($query);
$num = mysql_num_rows($result);
$row = mysql_fetch_array ($result, MYSQL_NUM);
$title = $row['0'];
$name = $row['1'];
$message = $row['2'];
$activen = $row['3'];
$title = htmlspecialchars($title);
$name = htmlspecialchars($name);
$message = htmlspecialchars($message);
$activen = htmlspecialchars($activen);
if ($num == 1) {
echo '<form action="?d=dir&c=vip&p=edit_lesson&id=edit_lesson&num='.$id.'" method="post" name="vobn">
<table align="center" border="1">
<tr>
<td align="center" class="names">Çàãëàâèå : </td></tr>
<tr><td align="center"><input type="text" name="title" size="25" maxlength="255" value="'.$title.'" />
</td></tr><tr><td align="center" class="names">Àâòîð : </td></tr>
<tr><td align="center"> <input type="text" name="name" size="15" maxlength="255" value="'.$name.'" />
</td></tr><tr><td align="center" class="names">Êîä àêòèâàöèÿ : </td></tr>
<tr><td align="center"> <input type="text" name="activen" size="15" maxlength="255" value="'.$activen.'" />
<td align="center" class="names">Êàòåãîðèÿ :</td></tr><tr><td align="center"><select name="category">';
$result = mysql_query("SELECT * FROM categorii order by id");
while($r=mysql_fetch_array($result))
{
$cato = $r['catoption'];
echo "$cato";
}
echo '</select></td></tr><tr><td align="center" class="names">Óðîê : </td></tr>';
?>
<tr>
<td align="center">
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">BOLD</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('Text');"><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('Text');"><font face="verdana" color="#666" size="2">Size</font></a>
<a href="javascript:areatext('
<a href="javascript:areatext('Name');"><font face="#666" color="#666" size="2">Link</font></a>
<a href="javascript:areatext('
Код:
</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('
');"><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('
');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a> <a href="javascript:areatext('
');"><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('
');"><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>
</td>
</tr>
<?php
echo '
<tr><td align="center"><textarea rows="30" cols="70" name="message">'.$message.'</textarea></td></tr>
<tr><td align="center">
<input type="submit" name="submit" value="Îáíîâè" /></td></tr></table>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="id" value="'.$id.'" /></form>';
} else {
echo '<table align="center"><tr><td align="center"><a class="text">Óðîêúò íå ìîæåøå äà áúäå ðåäàêòèðàí, ìîëÿ, îïèòàéòå îòíîâî.</a></td></tr></table>';
}
}
}
else
{
echo '<table align="center"><tr><td align="center">Âàøeòî ïîòðåáèòåëñêî èìå íå å àäìèíèñòðàòîðñêî èëè ìîäåðàòîðñêî ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a> êàòî àäìèíèñòðàòîð èëè ìîäåðàòîð</td></tr></table>';
}
}
else
{
echo '<table align="center"><tr><td>Äîñòúï, îòêàçàí ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a></td></tr></table>';
}
?>
Защо не се получава?