Имам проблем с 21 и 38 ред
Код:
<?php include("jheader.php"); ?>
<?php
if ($_REQUEST['jokeid']) { $jokeid = $_REQUEST['jokeid']; }
if ($_REQUEST['random']) { $random = $_REQUEST['random']; }
if ($random == 1) {
$jokeid = get_random_joke(1);
} else {
$jokeid = $id;
}
$sql = "select d.pictype, d.title, d.joke, d.hits, d.rating, d.userid, d.type, c.category from jokes d, categories c where d.jokeid = $jokeid and c.catid = d.catid";
$result = mysql_query($sql ,$db);
това е 21 ред if ($myrow = mysql_fetch_array($result)) {
do {
$pagetitle = $myrow["title"];
$joke = $myrow["joke"];
$hits = $myrow["hits"];
$jokerating = $myrow["rating"];
$userid = $myrow["userid"];
$category = $myrow["category"];
$joketype = $myrow["type"];
$pictype = $myrow["pictype"];
} while ($myrow = mysql_fetch_array($result));
}
$sql = "select * from sponsored_jokes where jokeid = $jokeid";
$result = mysql_query($sql ,$db);
това е 38 ред if ($myrow = mysql_fetch_array($result)) {
do {
$sponsorid = $myrow["sponsorid"];
} while ($myrow = mysql_fetch_array($result));
}
if ($sponsorid > 0) {
$sql = "select * from sponsors where sponsorid = $sponsorid";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
do {
$sponsorurl = $myrow["url"];
$sponsortext = $myrow["text"];
$sponsorimage = $myrow["image"];
} while ($myrow = mysql_fetch_array($result));
}
}
$username = "n/a";
if ($userid != 0) {
$sql = "select login from users where userid = $userid";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
do {
$username = $myrow["login"];
} while ($myrow = mysql_fetch_array($result));
}
}
$hits++;
$sql = "update jokes set hits = $hits where jokeid = $jokeid";
$result = mysql_query($sql ,$db);
if ($mailafriend) {
$error = false;
$emailmsg = "";
if (strlen($senderemail) < 1) {
$error = true;
$emailmsg .= "<li><b>Sorry. You did not enter your email address.</b><br>\n";
}
if (strlen($friendsemail) < 1) {
$error = true;
$emailmsg .= "<li><b>Sorry. You did not enter your friends address.</b><br>\n";
}
if ($error == false) {
$sql = "insert into emailed_jokes (sender_email, friends_email, jokeid) values ('$senderemail', '$friendsemail', $id)";
$result = mysql_query($sql ,$db);
$newjoke = ereg_replace("<BR>\n", "\n", $joke);
$newjoke = ereg_replace("<p>", "", $newjoke);
$newjoke = ereg_replace("</p>", "", $newjoke);
$message = "This joke is being sent to you from $senderemail. Find more jokes and funny picture at $siteurl\n\n";
$message .= "==========================================================\n\n";
if ($joketype == "T") {
$message .= $newjoke;
} else {
$message .= "$pagetitle\n";
$message .= "$siteurl/joke.php?id=$jokeid&listtype=1";
}
$message .= "\n\n==========================================================\n\n";
$message .= "The best jokes and funny pictures on the Intenet\n$siteurl\n\n";
mail("$friendsemail", "From $senderemail : $pagetitle", $message, "From: $senderemail\r\n" ."Reply-To: $senderemail\r\n");
$emailmsg .= "<b>Thank You. The joke has been sent to your friend.</b><br>\n";
if ($emaillist) {
$sql = "select * from subscribers where emailaddress = '$senderemail'";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
$emailmsg .= "<br>You are already signed up to recieve jokes by email";
} else {
$sql = "insert into subscribers (emailaddress) values ('$senderemail')";
$result2 = mysql_query($sql ,$db);
$emailmsg .= "<br>You have now been signed up to recieve jokes by email";
}
}
}
}
if ($ratevalue) {
$ratecount = 0;
$ratetotal = 0;
$ip = getenv(remote_addr);
$sql = "select * from joke_ratings where jokeid = $jokeid and ip = '$ip'";
$result = mysql_query($sql ,$db);
if ($myrow = mysql_fetch_array($result)) {
$ratemsg = "Sorry you have already rated this joke";
} else {
$sql = "insert into joke_ratings (jokeid, rating, ip) values ($jokeid, $ratevalue, '$ip')";
$result2 = mysql_query($sql ,$db);
$sql = "select rating from joke_ratings where jokeid = $jokeid";
$result3 = mysql_query($sql ,$db);
if ($myrow2 = mysql_fetch_array($result3)) {
do {
$ratetotal = $ratetotal + $myrow2["rating"];
$ratecount++;
} while ($myrow2 = mysql_fetch_array($result3));
}
$newrate = $ratetotal / $ratecount;
$sql = "update jokes set rating = $newrate where jokeid = $jokeid";
$result4 = mysql_query($sql ,$db);
$ratemsg = "Thank you for rating this joke.";
}
$jokerating = $newrate;
}
?>
<table cellpadding=1 border=0 cellspacing=0 width=458>
<tr>
<td bgcolor=<?php printf($sitecolor); ?> align=center>
<font size="3" face="Arial"><b><?php printf($pagetitle); ?></b></font><br>
<table bgcolor=#CECECE cellpadding=1 border=0 cellspacing=0 width=100%>
<tr><td align=center colspan=2><font size="2" face="Arial">
<?php
if ($sponsorid > 0) {
?>
<br>
<table cellpadding=1 cellspacing=1 border=0><tr><td bgcolor=#000000 width=500 valign=center align=center>
<font face="Arial, Helvetica, sans-serif" size="2" color=white><b>Тази шега е избрана за вас от</b></font><br>
<table cellpadding=0 cellspacing=0 border=0><tr>
<td bgcolor=#DEDDDC width=300 valign=center align=center>
<font face="Arial, Helvetica, sans-serif" size="2"><b><?php printf($sponsortext); ?></b></font><br>
<font face="Arial, Helvetica, sans-serif" size="2"><a href="<?php printf($sponsorurl); ?>"><b><?php printf($sponsorurl); ?></b></a></font><br>
</td>
<td bgcolor=#DEDDDC width=200 valign=center align=center>
<a href="<?php printf($sponsorurl) ?>"><img border=0 src="sponsors/<? printf($sponsorimage); ?>"></a>
</td>
</tr></table>
</td></tr></table>
<?php
}
?>
<table>
<tr>
<td align=right valign=top width=500>
<table cellpadding=1 cellspacing=1 border=0><tr><td bgcolor=#000000 width=170 valign=center align=center>
<font face="Arial, Helvetica, sans-serif" size="2" color=white><b>Шега информация</b></font><br>
<table cellpadding=0 cellspacing=0 border=0><tr><td bgcolor=#DEDDDC width=168 valign=center align=center>
<font face="Arial, Helvetica, sans-serif" size="2"><b>Категория : </b><?php printf($category); ?></font><br>
<font face="Arial, Helvetica, sans-serif" size="2"><b>Рейтинг : </b><?php printf($jokerating); ?></font><br>
<font face="Arial, Helvetica, sans-serif" size="2"><b>Сътрудник : </b><?php printf($username); ?></font><br>
<font face="Arial, Helvetica, sans-serif" size="2"><b>Тип : </b><?php printf($joketype); ?></font><br>
</td></tr></table>
</td></tr></table>
</td>
</tr>
</table>
<?php
if ($mailafriend) {
printf("<b>$emailmsg</b><p>");
}
if ($ratevalue) {
printf("<b>$ratemsg</b><p>");
}
if ($joketype == "T") {
printf("<table cellpadding=5 cellspacing=0 border=0><tr><td><font size='2' face='Arial'>$joke</font></td></tr></table>");
}
if ($joketype == "P") {
printf("<img src=jokepics/$jokeid.$pictype>");
}
?>
</p></font></td></tr>
<form action=joke.php method=post>
<tr><td align=center colspan=2>
<table width=400 bgcolor=#000000 cellpadding=1 border=0 cellspacing=0><tr><td>
<input type=hidden name=id value="<?php printf($id) ?>">
<table bgcolor=lightgrey width=100%>
<tr><td align=middle colspan=2><font size="3" face="Arial, Helvetica, sans-serif"><b>Изпрати по Email този виц на приятел</b></font></td></tr>
<tr><td align=middle colspan=2><font size="2" face="Arial, Helvetica, sans-serif">Вашият email адрес : <input type=text name=senderemail width=20></td></tr>
<tr><td align=middle colspan=2><font size="2" face="Arial, Helvetica, sans-serif">адрес на приятел : <input type=text name=friendsemail width=20></td></tr>
<tr><td align=middle><font size="2" face="Arial, Helvetica, sans-serif"><input type=checkbox name=emaillist width=20 checked> Вашите приятели email.</td><td><font size="2" face="Arial, Helvetica, sans-serif"><input type=submit value=Send name=mailafriend></td></tr>
</table>
</td></tr></table>
</form>
<form action=joke.php method=post>
<input type=hidden name=id value="<?php printf($id) ?>">
<tr><td align=center colspan=2>
<table width=400 bgcolor=#000000 cellpadding=1 border=0 cellspacing=0><tr><td>
<table bgcolor=lightgrey width=100%>
<tr><td align=middle colspan=5><font size="3" face="Arial, Helvetica, sans-serif"><b>Оцени този виц</b></font></td></tr>
<tr>
<td align=middle><input type=radio name=ratevalue value=5 onClick="this.form.submit();"><br><font size="2" face="Arial, Helvetica, sans-serif">Много добър</font></td>
<td align=middle><input type=radio name=ratevalue value=4 onClick="this.form.submit();"><br><font size="2" face="Arial, Helvetica, sans-serif">Добър</font></td>
<td align=middle><input type=radio name=ratevalue value=3 onClick="this.form.submit();"><br><font size="2" face="Arial, Helvetica, sans-serif">Среден</font></td>
<td align=middle><input type=radio name=ratevalue value=2 onClick="this.form.submit();"><br><font size="2" face="Arial, Helvetica, sans-serif">Лош</font></td>
<td align=middle><input type=radio name=ratevalue value=1 onClick="this.form.submit();"><br><font size="2" face="Arial, Helvetica, sans-serif">Много Лош</font></td>
</tr>
</table>
</td></tr></table>
</form>
<br/>
</table>
</td>
</tr>
</table>
<?php include("jfooter.php"); ?>