Zanka

Lepo bi prosil nekoga naj gre skozi skripto in najde zanko.
Skripta pri izvajanju porabi too much procesorske moči in se niti ne zažene.

HVALA!

function showcontent($pnid,$mode,$order,$thold,$secid) {
global $dbi, $admin, $uimages, $prefix;
include ('header.php');
OpenTable();
//printsection($secid);
sql_query("UPDATE $prefix"._publications." SET counter=counter+1 WHERE pnid=$pnid",$dbi);

$query="SELECT pnid, title, $prefix"._pub_publications.".topicid, $prefix"._pub_publications.".typeid, year, alanguage, topictext, typetext, preview,firsturl, firstimg, secondurl, secondimg"
." FROM $prefix"._pub_publications.", $prefix"._pub_topics.", $prefix"._pub_types." WHERE "
." $prefix"._pub_publications.".topicid=$prefix"._pub_topics.".topicid AND "
." $prefix"._pub_publications.".typeid=$prefix"._pub_types.".typeid AND "
." pnid='$pnid'";

$result = sql_query($query,$dbi);
if (!$result) {echo _DBERROR; exit(); }
//if ($letter == '%') { $letter="All"; }
sql_query("UPDATE $prefix"._pub_publications." set counter=counter+1 where pnid='$pnid'",$dbi);
list($pnid,$title,$topicid,$typeid,$year,$alanguage,$topictext,$typetext, $preview, $firsturl, $firstimg, $secondurl, $secondimg)=sql_fetch_array($result,$dbi);
$query = "SELECT anid, fname, lname "
." FROM $prefix"._pub_authpub.", $prefix"._pub_authors." WHERE "
." $prefix"._pub_authpub.".anid=$prefix"._pub_authors.".authorid"
." AND $prefix"._pub_authpub.".pnid='$pnid'";

$resulta=sql_query($query,$dbi);
if (!$resulta) { echo _DBERROR; exit(); }

echo "< center >< TABLE BORDER="0" CELLPADDING="3" CELLSPACING="3" width="95%" >";
echo "< tr >< td colspan="3" >< P >< br >< STRONG >< BIG >  $title< /BIG >< /STRONG >< br > < /P >< /TD >< /TR >";
echo "< TR >< TD width="25%" >< b >"._PUBAUTHORS.":< /b >< /TD >< TD >";
while (list($anid,$fname,$lname)=sql_fetch_array($resulta,$dbi)) {
echo "< a href="modules.php?op=modload&name=Publications&file=index&p_op=showauthor&secid=$secid&anid=".$anid."" >".$fname." ".$lname."< /a >< br >";
}
echo "< /TD >< td rowspan="5" >";
if (!($firstimg==null || $firstimg=="")) {
echo "< img src="".$firstimg."" border="0" Alt="".$title."" >";
}
echo "< /TD >< /TR >< TR >< TD width="25%" >< b >"._PUBTOPIC.":< /b >< /TD >";
echo "< td >< a href="modules.php?op=modload&name=Publications&file=index&p_op=showtopic&secid=$secid&topicid=".$topicid."" >".$topictext."< /a >< /td >";
echo "< /TR >< TR >< TD width="25%" >< b >"._PUBTYPE.":< /b >< /TD >";
echo "< td >< a href="modules.php?op=modload&name=Publications&file=index&p_op=showtype&secid=$secid&typeid=".$typeid."" >".$typetext."< /a >< /td >";
echo "< /TR >< TR >< TD width="25%" >< b >"._YEAR.":< /b >< /TD >";
echo "< td >".$year."< /td >";
echo "< /TR >< TR >< TD width="25%" >< b >"._LANGUAGE.":< /b >< /TD >";
echo "< td >".$alanguage."< /td >";
echo "< /TR >< TR >< TD colspan="3" >< HR >< /TD >< /TR >";
echo "< /TR >< TR >< TD colspan="3" >";
if (!($secondimg==null || $secondimg=="")) {
echo "< img src="".$secondimg."" border="0" Alt="".$title."" align="left" hspace="10" vspace="10" >";
}
echo $preview."< /TD >< /TR >";
echo "< /TR >< TR >< TD colspan="3" >< HR >< /TD >< /TR >";
echo "< TR >< TD width="25%" >< p >< b >"._URL.":< /b >< /p >< /TD >< TD >";
// if (!($firsturl==null || $firsturl=="")) {
// if (eregi(".pdf$",$firsturl)) {
// echo "< a href="".$firsturl."" >< img src="images/publications/iconpdf.gif" >"._PDFFORMAT."< /a >";
// } else if (eregi(".doc$",$firsturl)){
// echo "< a href="".$firsturl."" >< img //src="images/publications/icondoc.gif" >"._DOCFORMAT."< /a >";
// } else if (eregi(".htm$|.html$",$firsturl)){
// echo "< a href="".$firsturl."" >< img //src="images/publications/iconhtml.gif" >"._HTMLFORMAT."< /a >";
// } else {
// echo "< a href="".$firsturl."" >< img //src="images/publications/icongeneral.gif" >"._VIEWFORMAT."< /a >";
// }
// }
//
echo "< /TD >< /TR >< TR >< TD width="25%" >< /TD >< TD >";

// if (!($secondurl==null || $secondurl=="")) {
// if (eregi(".pdf$",$secondurl)) {
// echo "< a href="".$secondurl."" >< img src="images/publications/iconpdf.gif" >"._PDFFORMAT."< /a >";
// } else if (eregi(".doc$",$secondurl)){
// echo "< a href="".$secondurl."" >< img //src="images/publications/icondoc.gif" >"._DOCFORMAT."< /a >";
// } else if (eregi(".htm$|.html$",$secondurl)){
// echo "< a href="".$secondurl."" >< img //src="images/publications/iconhtml.gif" >"._HTMLFORMAT."< /a >";
// } else {
// echo "< a href="".$secondurl."" >< img //src="images/publications/icongeneral.gif" >"._VIEWFORMAT."< /a >";
// }
// }
//
echo "< /TD >< /TR >< /TABLE >";
echo "< /CENTER >";

if (is_admin($admin)) {
echo "< b >"._ADMIN."< /b > [ < a href="admin.php?op=EditPublication&pnid=$pnid" >"._EDIT."< /a > | < a href=admin.php?op=DeletePublication&pnid=$pnid >"._DELETE."< /a > ]< br >";
}
//sql_free_result($result,$dbi);
//sql_free_result($resulta,$dbi);

CloseTable();
echo "< br >";

echo "< br >< CENTER >< b >"._COMMENTS."< /b >< /CENTER >< br >";
$sid=$pnid;
include("modules/Publications/pubcomments.php");
include ("footer.php");
}

Sem našel napake.
V bistvu je sploh ni ... pa pustimo podrobnosti.

xbite: Oprosti če sem te kakorkoli psihično prikrajšal, ampak kolikor vem je forum prostor kjer si ljudje med seboj pomagajo.
In moj post je bil popolnoma prostovoljen. Ni mus da mi kdo pomaga. Če pa mi ... svaka čast. Got point?

Ja no ,. ..

Mogoče sem premalo podrobno razložil kaj sploh želim.
Namreč noter bi lahko bila le ena brezvezna površna napaka, zaradi katere stvar mogoče nebi funkcionirala.

V glavnem - Case solved.