On Tuesday 03 June 2003 13:58, Jay Blanchard wrote:
> [snip]
> We would have to see some code....
>
> Jay
I'm not able to reproduce this in a short code-snippet.
But from the first echo to the last echo $lid change its value:
if ($hostid==31) echo "lid1: $lid";
# Paragraphs
#
if ($bodytype==1) {
sql_query("UPDATE tblArticleParagraph SET sort=-1 WHERE artid=$lid
AND hostid=$session_hostid");
$tmpbody = '';
for ($i=0; $i<count($paragraphs); $i++) {
$popt = 1;
$popt = $popt | (($parhardoutline[$i]) ? 0x2 : 0);
$parpicurl[$i] = preg_replace("/'/s",'"',$parpicurl[$i]);
$parheadline[$i] = trim($parheadline[$i]);
$parpictext[$i] = trim($parpictext[$i]);
if ($hostoptions&0x80) { # STRICT FONT/STYLE STRIP
$parparagraph[$i] = stripFontAndStyle($parparagraph[$i]);
}
sql_query("INSERT INTO tblArticleParagraph
(hostid,artid,sort,options,headline,picurl,paragraph,pictext)
VALUES
($session_hostid,$lid,$i,$popt,'$parheadline[$i]','$parpicurl[$i]','$parparagraph[$i]','$parpictext[$i]')");
$tmpbody .= $parheadline[$i];
$tmpbody .= ' ';
$tmpbody .= $parparagraph[$i];
$tmpbody .= ' ';
}
sql_query("UPDATE tblArticle SET body='$tmpbody' WHERE id=$lid AND
hostid=hostid=$session_hostid");
sql_query("DELETE FROM tblArticleParagraph WHERE artid=$lid AND
sort=-1 AND hostid=$session_hostid");
}
if ($special && $formid) {
# form based article publishing
# arnt h, Feb 03
list($tformid,$treplyid) = sql_queryandfetch("SELECT formid,replyid
FROM refArticleForm WHERE hostid=$session_hostid AND artid='$saveid'
if (!$tformid && !$treplyid) {
sql_query("INSERT INTO refArticleForm
(hostid,artid,formid,replyid) VALUES ($session_hostid,$saveid,$formid,0)");
$tformid = $formid;
}
$surveyid = $tformid;
$hostid = $session_hostid;
$arntid = $id;
$id = $saveid;
$arntpublic_userid = $public_userid;
$public_userid = 0;
include 'include/surveysavereply.inc'; ## perform saving
$public_userid = $arntpublic_userid;
$id = $arntid;
sql_query("UPDATE refArticleForm SET replyid=$thisreplyid WHERE
artid=$saveid AND hostid=$session_hostid");
$tmp = '';
reset($surveykeyval);
foreach ($surveykeyval as $key => $val) {
for ($xxi=0; $xxi<count($val); $xxi++) {
$tmpval = $val[$xxi];
if (!$tmpval) continue;
$tmpval = preg_replace('/\|\{.*?\}/','',$tmpval);
$lbl = "fbq_".$key;
$tmp .= "<$key lbl=\"".$$lbl."\">$tmpval</$key>\r\n";
}
}
# $tmp = '<bodyxml>'.$tmp.'</bodyxml>';
sql_query("UPDATE tblArticle SET body='$tmp' WHERE id=$saveid AND
hostid=$session_hostid");
}
# Save tblArticleExtension
#
list($tmp) = sql_queryandfetch("SELECT id FROM tblArticleExtension WHERE
artid=$lid AND hostid=$session_hostid");
if ($tmp) sql_query("UPDATE tblArticleExtension SET
custom1='$custom1',custom2='$custom2',custom3='$custom3',custom4='$custom4'
WHERE ar
elseif ($custom1||$custom2||$custom3||$custom4) sql_query("INSERT INTO
tblArticleExtension (hostid,artid,custom1,custom2,custom3,custom4) V
if ($hostid==31) echo "<hr>lid2:$lid";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
